POC - Export d'un référentiel geo avec Data via module export + exploitation dans shiny

[pierre56]

Export d'un référentiel geo via module export + exploitation dans shiny

Contexte/objectif

a retravailler, travail presque abouti sur shiny

SQL

create view gn_exports.v_ref_geo_commune_api as
select st_asgeojson(data.*)
from (
select id_area, area_name , area_code , geom
from ref_geo.l_areas la
where id_type = 25
--and area_code ilike '56007'
)data

Module export

https://geonature.bretagne-vivante.org/api/exports/api/6
https://geonature.bretagne-vivante.org/api/exports/api/7

Taxhub - Liste Nicheurs

https://taxhub.bretagne-vivante.org/#!/listes/107
https://taxhub.bretagne-vivante.org/api/taxref/allnamebylist/107

API Geonature

https://geonature.bretagne-vivante.org/api/exports/api/7
avec variable

https://geonature.bretagne-vivante.org/api/exports/api/7?limit=1000&offset=1000&geojson=geojson

Shiny

https://shiny.posit.co/r/articles/build/layout-guide/

DOC

Paste

https://www.rdocumentation.org/packages/base/versions/3.6.2/topics/paste
https://www.digitalocean.com/community/tutorials/paste-in-r
https://stackoverflow.com/questions/5738831/r-plus-equals-and-plus-plus-equivalent-from-c-c-java-etc
https://stackoverflow.com/questions/51143588/convert-string-into-json-string-and-parsing-in-r
https://www.math.ucla.edu/~anderson/rw1001/library/base/html/character.html

While + Merge Data

https://www.w3schools.com/r/r_while_loop.asp
https://sparkbyexamples.com/r-programming/r-create-an-empty-dataframe/
https://stackoverflow.com/questions/26508519/how-to-add-elements-to-a-list-in-r-loop
https://statisticsglobe.com/merge-multiple-data-frames-of-list-in-r

Json

https://cran.r-project.org/web/packages/geojsonR/geojsonR.pdf
https://community.rstudio.com/t/fromjson-in-shiny-app/68306/3
https://cran.r-project.org/web/packages/geojsonR/vignettes/the_geojsonR_package.html
https://rstudio.github.io/leaflet/json.html
https://cran.r-project.org/web/packages/jsonlite/vignettes/json-paging.html
https://www.flother.is/til/postgis-geojson/
https://jsonlint.com/
https://stackoverflow.com/questions/37933084/how-to-display-multiple-polygons-at-once-using-leaflet-addgeojson-function
https://www.tutorialspoint.com/r/r_json_files.htm
https://community.rstudio.com/t/fromjson-in-shiny-app/68306/4
https://datatracker.ietf.org/doc/pdf/rfc7946.pdf#page=5
https://cran.r-project.org/web/packages/geojsonsf/vignettes/geojson-sf-conversions.html

Filter dataframe

https://datatofish.com/remove-column-dataframe-r/
https://stackoverflow.com/questions/47191727/r-filtering-by-two-columns-using-is-not-equal-operator-dplyr-subset
https://stackoverflow.com/questions/60129630/special-symbols-pattern-search-with-str-detect
https://stackoverflow.com/questions/22850026/filter-rows-which-contain-a-certain-string/40233929#40233929
https://tidyselect.r-lib.org/reference/starts_with.html
https://stackoverflow.com/questions/74019414/r-how-to-filter-rows-where-the-start-of-entries-match-a-list

Leaflet

https://stackoverflow.com/questions/47789632/customizing-leaflet-popup-in-r
https://rstudio.github.io/leaflet/json.html

add-polygons

https://stackoverflow.com/questions/29480795/add-polygons-to-r-shiny-leaflet-map
https://rdrr.io/cran/geoops/man/FeatureCollection.html
https://cran.r-project.org/web/packages/sf/vignettes/sf2.html

Colors (heatmap

https://r-graph-gallery.com/38-rcolorbrewers-palettes.html
https://www.rdocumentation.org/packages/leaflet.extras/versions/1.0.0/topics/addHeatmap
https://www.rdocumentation.org/packages/leaflet/versions/2.2.0/topics/colorNumeric
https://www.r-bloggers.com/2012/10/palettes-in-r/
https://stackoverflow.com/questions/51931610/r-leaflet-fill-polygons-with-colours

AddsearchFeature

https://campus.datacamp.com/courses/interactive-maps-with-leaflet-in-r/groups-layers-and-extras?ex=13

Legend

http://rstudio.github.io/leaflet/legends.html
https://leafletjs.com/examples/layers-control/
https://stackoverflow.com/questions/50641092/r-leaflet-map-change-legends-based-on-selected-layer-group
https://stackoverflow.com/questions/65572493/how-to-turn-off-the-layer-display-of-addlayerscontrol-first-when-launching-the-s