Skip to content

Instantly share code, notes, and snippets.

@mapcentia

mapcentia/gist:b0ae1a09d10833cb771071f33d1861ab

Created April 22, 2021 10:26
Show Gist options
  • Save mapcentia/b0ae1a09d10833cb771071f33d1861ab to your computer and use it in GitHub Desktop.
Save mapcentia/b0ae1a09d10833cb771071f33d1861ab to your computer and use it in GitHub Desktop.
Download ZIP
Demo SQLs
Raw
gistfile1.txt
https://geofa.geodanmark.dk/api/v2/sql/fkg?q=SELECT navn,facil_ty_k,facil_ty,geometri FROM fkg.t_5800_fac_pkt WHERE facil_ty='Toilet'&format=excel&geoformat=geojson&srs=4326
https://geofa.geodanmark.dk/api/v2/sql/fkg?q=SELECT navn,rute_ty,ST_Length(geometri) FROM fkg.t_5802_fac_li WHERE ST_Length(geometri) > 500000&format=excel
https://geofa.geodanmark.dk/api/v2/sql/fkg?q=select a.facil_ty, a.navn, st_distance(a.geometri, b.geometri) from t_5800_fac_pkt a, t_5800_fac_pkt b where a.kommunekode = 851 and a.facil_ty='Shelter' and b.facil_ty='Toilet' and st_distance(a.geometri,b.geometri)<200&format=excel
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment