{"action":"created","issue":{"url":"https://api.github.com/repos/inbo/reporting-rshiny-grofwildjacht/issues/2","repository_url":"https://api.github.com/repos/inbo/reporting-rshiny-grofwildjacht","labels_url":"https://api.github.com/repos/inbo/reporting-rshiny-grofwildjacht/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/inbo/reporting-rshiny-grofwildjacht/issues/2/comments","events_url":"https://api.github.com/repos/inbo/reporting-rshiny-grofwildjacht/issues/2/events","html_url":"https://github.com/inbo/reporting-rshiny-grofwildjacht/issues/2","id":233930435,"number":2,"title":"Te ontwikkelen figuren Rshiny grofwildjacht","user":{"login":"stijnvanhoey","id":754862,"avatar_url":"https://avatars2.githubusercontent.com/u/754862?v=3","gravatar_id":"","url":"https://api.github.com/users/stijnvanhoey","html_url":"https://github.com/stijnvanhoey","followers_url":"https://api.github.com/users/stijnvanhoey/followers","following_url":"https://api.github.com/users/stijnvanhoey/following{/other_user}","gists_url":"https://api.github.com/users/stijnvanhoey/gists{/gist_id}","starred_url":"https://api.github.com/users/stijnvanhoey/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stijnvanhoey/subscriptions","organizations_url":"https://api.github.com/users/stijnvanhoey/orgs","repos_url":"https://api.github.com/users/stijnvanhoey/repos","events_url":"https://api.github.com/users/stijnvanhoey/events{/privacy}","received_events_url":"https://api.github.com/users/stijnvanhoey/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"tverbeke","id":5047312,"avatar_url":"https://avatars3.githubusercontent.com/u/5047312?v=3","gravatar_id":"","url":"https://api.github.com/users/tverbeke","html_url":"https://github.com/tverbeke","followers_url":"https://api.github.com/users/tverbeke/followers","following_url":"https://api.github.com/users/tverbeke/following{/other_user}","gists_url":"https://api.github.com/users/tverbeke/gists{/gist_id}","starred_url":"https://api.github.com/users/tverbeke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tverbeke/subscriptions","organizations_url":"https://api.github.com/users/tverbeke/orgs","repos_url":"https://api.github.com/users/tverbeke/repos","events_url":"https://api.github.com/users/tverbeke/events{/privacy}","received_events_url":"https://api.github.com/users/tverbeke/received_events","type":"User","site_admin":false},"assignees":[{"login":"tverbeke","id":5047312,"avatar_url":"https://avatars3.githubusercontent.com/u/5047312?v=3","gravatar_id":"","url":"https://api.github.com/users/tverbeke","html_url":"https://github.com/tverbeke","followers_url":"https://api.github.com/users/tverbeke/followers","following_url":"https://api.github.com/users/tverbeke/following{/other_user}","gists_url":"https://api.github.com/users/tverbeke/gists{/gist_id}","starred_url":"https://api.github.com/users/tverbeke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tverbeke/subscriptions","organizations_url":"https://api.github.com/users/tverbeke/orgs","repos_url":"https://api.github.com/users/tverbeke/repos","events_url":"https://api.github.com/users/tverbeke/events{/privacy}","received_events_url":"https://api.github.com/users/tverbeke/received_events","type":"User","site_admin":false},{"login":"jimcasaer","id":17747176,"avatar_url":"https://avatars3.githubusercontent.com/u/17747176?v=3","gravatar_id":"","url":"https://api.github.com/users/jimcasaer","html_url":"https://github.com/jimcasaer","followers_url":"https://api.github.com/users/jimcasaer/followers","following_url":"https://api.github.com/users/jimcasaer/following{/other_user}","gists_url":"https://api.github.com/users/jimcasaer/gists{/gist_id}","starred_url":"https://api.github.com/users/jimcasaer/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jimcasaer/subscriptions","organizations_url":"https://api.github.com/users/jimcasaer/orgs","repos_url":"https://api.github.com/users/jimcasaer/repos","events_url":"https://api.github.com/users/jimcasaer/events{/privacy}","received_events_url":"https://api.github.com/users/jimcasaer/received_events","type":"User","site_admin":false},{"login":"ThomasScheppers","id":24563808,"avatar_url":"https://avatars1.githubusercontent.com/u/24563808?v=3","gravatar_id":"","url":"https://api.github.com/users/ThomasScheppers","html_url":"https://github.com/ThomasScheppers","followers_url":"https://api.github.com/users/ThomasScheppers/followers","following_url":"https://api.github.com/users/ThomasScheppers/following{/other_user}","gists_url":"https://api.github.com/users/ThomasScheppers/gists{/gist_id}","starred_url":"https://api.github.com/users/ThomasScheppers/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ThomasScheppers/subscriptions","organizations_url":"https://api.github.com/users/ThomasScheppers/orgs","repos_url":"https://api.github.com/users/ThomasScheppers/repos","events_url":"https://api.github.com/users/ThomasScheppers/events{/privacy}","received_events_url":"https://api.github.com/users/ThomasScheppers/received_events","type":"User","site_admin":false},{"login":"Fhuysent","id":26084056,"avatar_url":"https://avatars2.githubusercontent.com/u/26084056?v=3","gravatar_id":"","url":"https://api.github.com/users/Fhuysent","html_url":"https://github.com/Fhuysent","followers_url":"https://api.github.com/users/Fhuysent/followers","following_url":"https://api.github.com/users/Fhuysent/following{/other_user}","gists_url":"https://api.github.com/users/Fhuysent/gists{/gist_id}","starred_url":"https://api.github.com/users/Fhuysent/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Fhuysent/subscriptions","organizations_url":"https://api.github.com/users/Fhuysent/orgs","repos_url":"https://api.github.com/users/Fhuysent/repos","events_url":"https://api.github.com/users/Fhuysent/events{/privacy}","received_events_url":"https://api.github.com/users/Fhuysent/received_events","type":"User","site_admin":false}],"milestone":null,"comments":6,"created_at":"2017-06-06T15:25:50Z","updated_at":"2017-06-20T11:39:35Z","closed_at":null,"body":"The further development of the Rshiny application is based on the figures of the [existing report](https://pureportal.inbo.be/portal/files/11785261/Huysentruyt_etal_2015_GrofwildjachtVlaanderen.pdf). \r\n\r\nThe raw/source data for the app is available in the  `inst/extdata/` folder, with two data files:\r\n\r\n* `rshiny_reporting_data_geography.csv`: data to use to create maps\r\n* `rshiny_reporting_data_ecology.csv`: data to use for all other plots\r\n\r\nExisting scripts of the `ggplot` figures in the report will be provided, but when suitable the interactivity should be exploited as much as possible. For verification and review, please ask @ThomasScheppers.\r\n\r\n## General html-widget options\r\n\r\nThe user should be able to do some general selections in the main menu, which are applied to all (relevant) figures/tables of the page:\r\n* `diersoort` (species) main level/choice. Dependent from this selection, the relevant figures appear. Options are `wild zwijn`,  `ree`, `damhert` en `edelhert`. Remark that in the future more species could be added, so no hardcoding on the species options. In the figure-section, the species for which a figure should be made are enlisted.\r\n\r\nThe current 'visual' options `kleurenpalet`, `Legende` and `Extra variabelen` are not required as menu item. Colors should be according to [INBOtheme](https://github.com/inbo/INBOtheme/blob/master/vignettes/themes.Rmd#theme_inbo-with-transparant-background), the legend replacement should be on figure-level only if relevant for that specific figure and the popup should give a proper representation of the available information. \r\n\r\n## Other options:\r\nFor some of the figures, the region-level and the time-range are relevant. These options should be provided on **figure-level**, when relevant:\r\n\r\n* `'Regio-schaal` and `Regio`: Possible levels of `regioschaal` are `Vlaanderen`, `Provincies` and `Fusiegemeenten` (from which the `regio's` options follow). Both menu-items should be close to each other. \r\n* `Tijdstip`: an option to provide a specific year or the required period \r\n\r\n**Remark**: When the figure concerns `wild zwijn` on the *level of provinces*, `Voeren` should be added as an individual category. When the value in the column for `edelhert` or `damhert` is still on `Voeren` , than is should be `Limburg`.\r\n**Remark**: * final dataset of ree will start at 2002, other species from 2006, so adapt x-range to this when relevant\r\n\r\n## Figures\r\n\r\nFollowing sections provide the information on the figures to add to the Rshiny application. The page number represents the corresponding page of the [existing report](https://pureportal.inbo.be/portal/files/11785261/Huysentruyt_etal_2015_GrofwildjachtVlaanderen.pdf). \r\n\r\n### Figure p4.\r\n![image](https://cloud.githubusercontent.com/assets/754862/26830216/6942f1fc-4ac8-11e7-9447-1c12e99f338f.png)\r\n* available for: ree, wild zwijn, damhert en edelhert\r\n* source data file: `rshiny_reporting_data_ecology.csv`\r\n* bar-chart (not the `createPlot1`-lines) with option to add or exclude provinces (and Voeren!) as it is in the plotly `createPlot1` example.\r\n* Besides the provinces, ONLY for `wild zwijn`, *Voeren* should be an additional category\r\n* figure-level-menu-option: `time period` (start and end)\r\n\r\n### Table p5.\r\n![image](https://cloud.githubusercontent.com/assets/754862/26831470/b3049c42-4acc-11e7-8872-b12e002ae5a3.png)\r\n![image](https://cloud.githubusercontent.com/assets/754862/26831534/e0a192b8-4acc-11e7-9d5e-d76ac6a61ced.png)\r\n* available for: ree, wild zwijn\r\n* source data file: `rshiny_reporting_data_ecology.csv`\r\n* table-level-menu-option: `jaar` (specific year)\r\n* In the example figures, for not- ree` trend is derived on 1 and 5 year; for `ree` this is 5 and 10 year. This should be `1`/`5` and `10` for both ree and wild zwijn (and if selected period relevant). Heading name of columns `verandering tov ...` (change) instead of `trend/toename`.\r\n* Do not provide the `verandering` in case of *low* numbers for `zwijn`. The threshold should be an input for the plot-function with the default 10 (will be further checked later).\r\n* Besides the provinces, ONLY for `wild zwijn`, *Voeren* should be an additional category\r\n* The percentages provided in *ree*-table do require an additional information file (`toegekend afschot per provincie per labeltype per jaar`). This will be delivered later this month.\r\n* Nice-to have: possibility to select/unselect specific provinces with adaptation of the total number (requires also  clear distinction in between `Vlaanderen` and additional`total` row). \r\n\r\n### Map p6.\r\n![image](https://cloud.githubusercontent.com/assets/754862/26831640/3f57e046-4acd-11e7-83e3-093bd27c29d8.png)\r\n* available for: ree, wild zwijn, damhert en edelhert\r\n* source data file: `rshiny_reporting_data_geography.csv`\r\n* Use following classes for the data: 0; 1-10; 11-20; 21-40; 41-70; >70\r\n* add popup with the name and total number\r\n* add *trend* figure at right hand-side of the map based on selection (cfr. current example of Rshiny app)\r\n* figure-level-menu-option:  `time period` slider (start and end year) and 'Regio-schaal` and `Regio` (3 levels). Remark that on the `Vlaanderen` level,  the map will be a total number, but the line graph is still relevant as quick reference\r\n* On the province-regional level; besides the provinces, ONLY for `wild zwijn`, *Voeren* should be an additional category\r\n\r\n### Figure p7. -> out of scope\r\nThis figure is (for the moment) not required for the application\r\n\r\n### Figure p9\r\n![image](https://cloud.githubusercontent.com/assets/754862/26834333/586c1aa4-4ad5-11e7-9fa2-523483fcdcb4.png)\r\n* available for: `zwijn` (adult, overloper, frisling) and `ree` (geit, kits en jongvolwassen)\r\n* source data file: `rshiny_reporting_data_ecology.csv`\r\n* figure-level-menu-option:  `time period` slider (start and end year), no spatial element (always whole data set)\r\n* *% ingezamelde onderkaken tov het totaal van de dataset vermelden*\r\n\r\n### Figure p. 11\r\n![image](https://cloud.githubusercontent.com/assets/754862/26834742/738d6c10-4ad6-11e7-8930-c12c9200aded.png)\r\n* available for: `zwijn`  and `ree`; \r\n* source data file: `rshiny_reporting_data_ecology.csv`\r\n* categories for ree as in *meldingsformulier* (p 20)\r\n* *Voor everzwijn: categorie op basis van leeftijdscategorie onderkaak + niet ingezameld. % berekenen vanaf 2009 tov het totaal ingezamelde onderkaken voor dat jaar (dus niet inclusief de niet ingezamelden). Aantallen onderaan zijn inclusief de niet ingezamelden.* (info @ThomasScheppers )\r\n* should be LINE-graph, not bars (cfr. example create_plot1)\r\n* figure-level-menu-option:  `time period` slider, 'Regio-schaal` and `Regio` (2 levels: Provincies and Vlaanderen)\r\n\r\n### Figure p. 13\r\n* available for: `zwijn`  and `ree`; \r\n* source data file: `rshiny_reporting_data_ecology.csv`\r\n* adapt to the visual representation of `createPlot3()`\r\n* temporal resolution is each half-month\r\n* figure-level-menu-option:  `time period` slider for the reference period, `year`-selection for the year of interest; no spatial selection, always use Flanders-data (whole data set)\r\n* the grey-rectangle defines the `openingstijd`, which should be an input of the figure as well, but no interactive option (is given info). For the moment use dummy data, this information will be delivered later this month. For example, for `zwijn` this was the entire year in 2016, but this changes. The delivered information table will have the variables: `soort`, `type`, `startdatum`, `einddatum`.\r\n\r\n### Figure p. 15\r\n![image](https://user-images.githubusercontent.com/754862/26867935-7263a8f4-4b67-11e7-8fba-daf8bb29ea35.png)\r\n\r\n* available for: `zwijn`  and `ree`; \r\n* for `zwijn`: geslacht using the  *meldingsformulier* (column geslacht.MF); for `ree`: `leeftijdscategorie` op basis van *meldingsformulier* (kits, jongvolwassen, volwassen), geslacht using the  *meldingsformulier*\r\n* source data file: `rshiny_reporting_data_ecology.csv`\r\n* figure-level-menu-option:  `time period` slider (no spatial)\r\n* Exclude the category ‘Onbekend’\r\n\r\n### Figure p. 17\r\n![image](https://user-images.githubusercontent.com/754862/26836400-08c5023a-4adb-11e7-984e-ccc322bfa70b.png)\r\n* available for: `zwijn`  and `ree`; \r\n* source data file: `rshiny_reporting_data_ecology.csv`\r\n* figure-level-menu-option:  'Regio-schaal` and `Regio` (2 levels: Provincies and Vlaanderen) (aggregate all years)\r\n* voor everzwijn: geslacht using the  *meldingsformulier* (column geslacht.MF); Category op basis van leeftijdsbepaling_onderkaak (combine leeftijd_maanden en leeftijdscategorie_onderkaak)\r\n* voor ree:  (cfr. p. 28): (is ook leeggewicht): category as *meldingsformulier*. All weight lower than 5 kg and above 30 kg are regarded unrealistic and excluded from the data set\r\n\r\n### Figure p28. \r\n![image](https://user-images.githubusercontent.com/754862/26837286-5c4b7c16-4add-11e7-8677-4a865ec95d37.png)\r\n* available for: `ree`\r\n* source data file: `rshiny_reporting_data_ecology.csv`\r\n* figure-level-menu-option:  'Regio-schaal` and `Regio` (2 levels: Provincies and Vlaanderen) (aggregate all years)\r\n* `onderkaaklengte` of an animal is the mean of both *onderkaken*-columns (`onderkaaklengte_links` and `onderkaaklengte_rechts`, without NA (`rowMeans(subset(Meldingen, select = c(onderkaaklengte_links, onderkaaklengte_rechts)), na.rm = TRUE)`) of that animal. All averages < 100 mm and > 200 mm are excluded from the visualisation.\r\n\r\n### Figure p29: bio-indicators\r\n![image](https://user-images.githubusercontent.com/754862/26837270-5323f30c-4add-11e7-88d5-53a2495b9340.png)\r\n* available for: `ree`\r\n* 3 figures, always shown all three of them under subtitle *Bio-indicatoren*: 1) Onderkaaklengte (cfr supra) ifv jaar (boxplot) 2) Gewicht ifv jaar (boxplot) and 3) aantal embryo’s voor de vrouwelijke reeën ifv jaar (cfr. current figure on p. 29) (barplot)\r\n* source data file: `rshiny_reporting_data_ecology.csv`\r\n* figure-level-menu-option:  'Regio-schaal` and `Regio` (2 levels: Provincies and Vlaanderen) (aggregate all years). A figure specific menu-item is the `type`: Geitkits, Bokkits, Jaarlingbok, Smalree, Geit, Bok) for figure 1) and 2) and `type` Geitkits, Smalree en Geit for 3) (*aantal embryo’s*). In the cas of 3), the types shown should not be a dropdown, but a checkbox on which types to include in the figure (all of them, or any combination of types).\r\n* hence, x-as is the year\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/inbo/reporting-rshiny-grofwildjacht/issues/comments/309727185","html_url":"https://github.com/inbo/reporting-rshiny-grofwildjacht/issues/2#issuecomment-309727185","issue_url":"https://api.github.com/repos/inbo/reporting-rshiny-grofwildjacht/issues/2","id":309727185,"user":{"login":"mvarewyck","id":22143743,"avatar_url":"https://avatars0.githubusercontent.com/u/22143743?v=3","gravatar_id":"","url":"https://api.github.com/users/mvarewyck","html_url":"https://github.com/mvarewyck","followers_url":"https://api.github.com/users/mvarewyck/followers","following_url":"https://api.github.com/users/mvarewyck/following{/other_user}","gists_url":"https://api.github.com/users/mvarewyck/gists{/gist_id}","starred_url":"https://api.github.com/users/mvarewyck/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mvarewyck/subscriptions","organizations_url":"https://api.github.com/users/mvarewyck/orgs","repos_url":"https://api.github.com/users/mvarewyck/repos","events_url":"https://api.github.com/users/mvarewyck/events{/privacy}","received_events_url":"https://api.github.com/users/mvarewyck/received_events","type":"User","site_admin":false},"created_at":"2017-06-20T11:39:35Z","updated_at":"2017-06-20T11:39:35Z","body":"Is there already a decision on the boxplot versus lineplot for Ree bioindicatoren? (see comment @ThomasScheppers)"}}
{"actor":{"display_login":"mvarewyck"}}