- Created by Anne Sørensen, last modified by Sigurd Vedsted Drejer on Jul 01, 2025
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 22 Next »
GeoFA Årshjul
Denne sektion indeholder SQL-kald for hvor meget data der er registreret i hver kommune og andre aktører, indenfor de faciliteter der er i fokus for hver måned i årshjulet.
Tilmeld dig nyhedsbrevet om GeoFA datavask her. Nyhedsbrevet bliver sendt ud månedligt efter årshjulets struktur.
| Alle registrerede data | Statistik data (pr myndighed) | |
| Løberuter (2) | Alle registrerede løberuter | Antal registrerede løberuter |
| Cykelruter (3) | Alle registrerede cykelruter | Antal registrerede cykelruter |
| Orienteringsruter start (4322) | Alle registrerede orienteringsruter start | Antal registrerede orienteringsruter start |
| Udendørs fitness/motionsplads (4222) | Alle udendørs fitness/motionspladser | Antal registrerede udendørs fitness/motionsplads |
| Børne- og skoledistrikter | Alle børne- og skoledistrikter |
[vc_column_text]
<table style="border: 1px solid #808080;">
<tbody>
<tr>
<td style="border: 1px solid #808080; text-align: center;"></td>
<td style="border: 1px solid #808080; text-align: center;"><strong>Alle registrerede data</strong></td>
<td style="border: 1px solid #808080; text-align: center;"><strong>Statistik data (pr myndighed)</strong></td>
</tr>
<tr>
<td style="border: 1px solid #808080; text-align: center;"><strong>Løberuter (2)</strong></td>
<td style="border: 1px solid #808080; text-align: center;"><span style="text-decoration: underline;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&q=select%20*%20from%20fkg.t_5802_fac_li%20WHERE%20rute_ty_k=2">Alle registrerede løberuter</a></span></td>
<td style="border: 1px solid #808080; text-align: center;"><span style="text-decoration: underline;"><a href="Antal'>https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(route_count)%20AS%20antalløberuter%20FROM%20(SELECT%20cvr_navn,%20COUNT(*)%20AS%20route_count%20FROM%20fkg.t_5802_fac_li%20WHERE%20rute_ty_k%20=%202%20GROUP%20BY%20cvr_navn%20UNION%20ALL%20SELECT%20NULL%20AS%20cvr_navn,%20COUNT(*)%20AS%20route_count%20FROM%20fkg.t_5802_fac_li%20WHERE%20rute_ty_k%20=%202)%20AS%20subquery%20GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede løberuter</a></span>
<span style="text-decoration: underline;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&q=SELECT%20COALESCE(cvr_navn,%20%27Alle%27)%20AS%20Kommune,%20SUM(route_count)%20AS%20antall%C3%B8beruter,%20ROUND(SUM(route_length)::numeric,%200)%20AS%20samlet_l%C3%A6ngde_m%20FROM%20(SELECT%20cvr_navn,%20COUNT(*)%20AS%20route_count,%20SUM(ST_Length(geometri))%20AS%20route_length%20FROM%20fkg.t_5802_fac_li%20WHERE%20rute_ty_k%20=%202%20GROUP%20BY%20cvr_navn%20UNION%20ALL%20SELECT%20NULL%20AS%20cvr_navn,%20COUNT(*)%20AS%20route_count,%20SUM(ST_Length(geometri))%20AS%20route_length%20FROM%20fkg.t_5802_fac_li%20WHERE%20rute_ty_k%20=%202)%20AS%20subquery%20GROUP%20BY%20COALESCE(cvr_navn,%20%27Alle%27)%20ORDER%20BY%20CASE%20WHEN%20COALESCE(cvr_navn,%20%27Alle%27)%20=%20%27Alle%27%20THEN%200%20ELSE%201%20END,%20Kommune">Attributlængde (geometri) – løberuter målt I m</a></span></td>
</tr>
<tr>
<td style="border: 1px solid #808080; text-align: center;"><strong>Cykelruter (3)</strong></td>
<td style="border: 1px solid #808080; text-align: center;"><span style="text-decoration: underline;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&q=select%20*%20from%20fkg.t_5802_fac_li%20WHERE%20rute_ty_k=3">Alle registrerede cykelruter</a></span></td>
<td style="border: 1px solid #808080; text-align: center;"><span style="text-decoration: underline;"><a href="Antal'>https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(route_count)%20AS%20antalcykelruter%20FROM%20(SELECT%20cvr_navn,%20COUNT(*)%20AS%20route_count%20FROM%20fkg.t_5802_fac_li%20WHERE%20rute_ty_k%20=%203%20GROUP%20BY%20cvr_navn%20UNION%20ALL%20SELECT%20NULL%20AS%20cvr_navn,%20COUNT(*)%20AS%20route_count%20FROM%20fkg.t_5802_fac_li%20WHERE%20rute_ty_k%20=%203)%20AS%20subquery%20GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede cykelruter</a></span>
<span style="text-decoration: underline;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&q=SELECT%20COALESCE(cvr_navn,%20%27Alle%27)%20AS%20Kommune,%20SUM(route_count)%20AS%20antalcykelruter,%20ROUND(SUM(route_length)::numeric,%200)%20AS%20samlet_l%C3%A6ngde_m%20FROM%20(SELECT%20cvr_navn,%20COUNT(*)%20AS%20route_count,%20SUM(ST_Length(geometri))%20AS%20route_length%20FROM%20fkg.t_5802_fac_li%20WHERE%20rute_ty_k%20=%203%20GROUP%20BY%20cvr_navn%20UNION%20ALL%20SELECT%20NULL%20AS%20cvr_navn,%20COUNT(*)%20AS%20route_count,%20SUM(ST_Length(geometri))%20AS%20route_length%20FROM%20fkg.t_5802_fac_li%20WHERE%20rute_ty_k%20=%203)%20AS%20subquery%20GROUP%20BY%20COALESCE(cvr_navn,%20%27Alle%27)%20ORDER%20BY%20CASE%20WHEN%20COALESCE(cvr_navn,%20%27Alle%27)%20=%20%27Alle%27%20THEN%200%20ELSE%201%20END,%20Kommune">Attributlængde (geometri) – cykelruter målt i m</a></span></td>
</tr>
<tr>
<td style="border: 1px solid #808080; text-align: center;"><strong>Orienteringsruter start (4322)</strong></td>
<td style="border: 1px solid #808080; text-align: center;"><span style="text-decoration: underline;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=csv&q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=4322">Alle registrerede orienteringsruter start</a></span></td>
<td style="border: 1px solid #808080; text-align: center;"><span style="text-decoration: underline;"><a href="Antal'>https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(pkt_count)%20AS%20orienteringsruter_start%20FROM%20(SELECT%20cvr_navn,%20COUNT(*)%20AS%20pkt_count%20FROM%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k%20=%204322%20GROUP%20BY%20cvr_navn%20UNION%20ALL%20SELECT%20NULL%20AS%20cvr_navn,%20COUNT(*)%20AS%20pkt_count%20FROM%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k%20=%204322)%20AS%20subquery%20GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede orienteringsruter start</a></span></td>
</tr>
<tr>
<td style="border: 1px solid #808080; text-align: center;"><strong>Udendørs fitness/motionsplads (4222)</strong></td>
<td style="border: 1px solid #808080; text-align: center;"><span style="text-decoration: underline;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=4222">Alle udendørs fitness/motionspladser</a></span></td>
<td style="border: 1px solid #808080; text-align: center;"><span style="text-decoration: underline;"><a href="Antal'>https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(pkt_count)%20AS%20udendørs_fitness_motionspladser%20FROM%20(SELECT%20cvr_navn,%20COUNT(*)%20AS%20pkt_count%20FROM%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k%20=%204222%20GROUP%20BY%20cvr_navn%20UNION%20ALL%20SELECT%20NULL%20AS%20cvr_navn,%20COUNT(*)%20AS%20pkt_count%20FROM%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k%20=%204222)%20AS%20subquery%20GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede udendørs fitness/motionsplads</a></span></td>
</tr>
<tr>
<td style="border: 1px solid #808080; text-align: center;"><strong>Børne- og skoledistrikter</strong></td>
<td style="border: 1px solid #808080; text-align: center;"><span style="text-decoration: underline;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&q=select%20*%20from%20fkg.t_5710_born_skole_dis">Alle børne- og skoledistrikter</a></span></td>
<td style="border: 1px solid #808080; text-align: center;"></td>
</tr>
</tbody>
</table>
<!--more-->
<!--more-->
<!--more-->[/vc_column_text]
- No labels