Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

GeoFA Årshjul

 Image Removed

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.

[vc_tta_accordion active_section="0"][vc_tta_section title="Januar" tab_id="1706100326775-c7631d3d-da8c"][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&amp;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&amp;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&amp;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&amp;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&amp;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&amp;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&amp;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&amp;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&amp;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&amp;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&amp;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][/vc_tta_section][vc_tta_section title="Februar" tab_id="1706881377616-8c632f48-25ca"][vc_column_text css=""]
<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>Toilet (1012)</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&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=1012">Alle registrerede toiletter</a></span></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&amp;q=SELECT%20COALESCE(cvr_navn,%20%27Alle%27)%20AS%20Kommune,%20SUM(pkt_count)%20AS%20Toilet%20FROM%20(%20SELECT%20cvr_navn,%20COUNT(*)%20AS%20pkt_count%20FROM%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k%20=%201012%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=%201012%20)%20AS%20subquery%20GROUP%20BY%20COALESCE(cvr_navn,%20%27Alle%27)">Antal registrerede toiletter</a></span></td>
</tr>
<tr>
<td style="border: 1px solid #808080; text-align: center;"><strong>Vandpost (1222)</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&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=1222">Alle registrerede vandposter</a></span></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&amp;q=SELECT%20COALESCE(cvr_navn,%20%27Alle%27)%20AS%20Kommune,%20SUM(pkt_count)%20AS%20Vandpost%20FROM%20(%20SELECT%20cvr_navn,%20COUNT(*)%20AS%20pkt_count%20FROM%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k%20=%201222%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=%201222%20)%20AS%20subquery%20GROUP%20BY%20COALESCE(cvr_navn,%20%27Alle%27)">Antal registrerede </a><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20%27Alle%27)%20AS%20Kommune,%20SUM(pkt_count)%20AS%20Vandpost%20FROM%20(%20SELECT%20cvr_navn,%20COUNT(*)%20AS%20pkt_count%20FROM%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k%20=%201222%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=%201222%20)%20AS%20subquery%20GROUP%20BY%20COALESCE(cvr_navn,%20%27Alle%27)">vandposter</a></span></td>
</tr>
<tr>
<td style="border: 1px solid #808080; text-align: center;"><strong>Bålplads (1022)</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&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=1022">Alle registrerede bålpladser</a></span></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&amp;q=SELECT COALESCE(cvr_navn, %27Alle%27) AS Kommune, SUM(pkt_count) AS B%C3%A5lplads FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM fkg.t_5800_fac_pkt WHERE facil_ty_k = 1022 GROUP BY cvr_navn UNION ALL SELECT NULL AS cvr_navn, COUNT(*) AS pkt_count FROM fkg.t_5800_fac_pkt WHERE facil_ty_k = 1022) AS subquery GROUP BY COALESCE(cvr_navn, %27Alle%27)">Antal registrerede bålpladser</a></span></td>
</tr>
<tr>
<td style="border: 1px solid #808080; text-align: center;"><strong>Bålhytte (3091)</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&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=3091">Alle registrerede bålhytter</a></span></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&amp;q=SELECT COALESCE(cvr_navn, 'Alle') AS Kommune, SUM(pkt_count) AS Bålhytte FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM fkg.t_5800_fac_pkt WHERE facil_ty_k = 3091 GROUP BY cvr_navn UNION ALL SELECT NULL AS cvr_navn, COUNT(*) AS pkt_count FROM fkg.t_5800_fac_pkt WHERE facil_ty_k = 3091) AS subquery GROUP BY COALESCE(cvr_navn, 'Alle')">Antal registrerede bålhytter</a></span></td>
</tr>
</tbody>
</table>
<!--more-->
<!--more-->
<!--more-->[/vc_column_text][/vc_tta_section][vc_tta_section title="Marts" tab_id="1706882152702-b1b75637-9bc2"][vc_column_text]
<table style="border: 1px solid #808080; width: 684px; height: 222px;">
<tbody>
<tr>
<td style="border: 1px solid #808080; text-align: center; width: 160.531px;"></td>
<td style="border: 1px solid #808080; text-align: center; width: 229.969px;"><strong>Alle registrerede data</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 243.5px;"><strong>Statistik data (pr myndighed)</strong></td>
</tr>
<tr>
<td style="border: 1px solid #808080; text-align: center; width: 160.531px;"><strong>Shelter (3012)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 229.969px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=csv&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=3012">Alle registrerede sheltere</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 243.5px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT COALESCE(cvr_navn, 'Alle') AS Kommune, SUM(pkt_count) AS Shelter FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM fkg.t_5800_fac_pkt WHERE facil_ty_k = 3012 GROUP BY cvr_navn UNION ALL SELECT NULL AS cvr_navn, COUNT(*) AS pkt_count FROM fkg.t_5800_fac_pkt WHERE facil_ty_k = 3012) AS subquery GROUP BY COALESCE(cvr_navn, 'Alle')">Antal registrerede sheltere</a></td>
</tr>
<tr>
<td style="border: 1px solid #808080; text-align: center; width: 160.531px;"><strong>Teltplads (3031)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 229.969px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=3031">Alle registrerede teltpladser</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 243.5px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT COALESCE(cvr_navn, 'Alle') AS Kommune, SUM(pkt_count) AS Teltplads FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM fkg.t_5800_fac_pkt WHERE facil_ty_k = 3031 GROUP BY cvr_navn UNION ALL SELECT NULL AS cvr_navn, COUNT(*) AS pkt_count FROM fkg.t_5800_fac_pkt WHERE facil_ty_k = 3031) AS subquery GROUP BY COALESCE(cvr_navn, 'Alle')">Antal registrerede teltpladser</a></td>
</tr>
<tr>
<td style="border: 1px solid #808080; text-align: center; width: 160.531px;"><strong>Legeplads (1031)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 229.969px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=1031">Alle registrerede legepladser</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 243.5px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT COALESCE(cvr_navn, 'Alle') AS Kommune, SUM(pkt_count) AS Legeplads FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM fkg.t_5800_fac_pkt WHERE facil_ty_k = 1031 GROUP BY cvr_navn UNION ALL SELECT NULL AS cvr_navn, COUNT(*) AS pkt_count FROM fkg.t_5800_fac_pkt WHERE facil_ty_k = 1031) AS subquery GROUP BY COALESCE(cvr_navn, 'Alle')">Antal registrerede legepladser</a></td>
</tr>
<tr>
<td style="border: 1px solid #808080; text-align: center; width: 160.531px;"><strong>Naturlegeplads (1041)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 229.969px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=1041">Alle registrerede naturlegepladser</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 243.5px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT COALESCE(cvr_navn, 'Alle') AS Kommune, SUM(pkt_count) AS Naturlegeplads FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM fkg.t_5800_fac_pkt WHERE facil_ty_k = 1041 GROUP BY cvr_navn UNION ALL SELECT NULL AS cvr_navn, COUNT(*) AS pkt_count FROM fkg.t_5800_fac_pkt WHERE facil_ty_k = 1041) AS subquery GROUP BY COALESCE(cvr_navn, 'Alle')">Antal registrerede naturlegepladser</a></td>
</tr>
</tbody>
</table>
<!--more-->
<!--more-->
<!--more-->[/vc_column_text][/vc_tta_section][vc_tta_section title="April" tab_id="1706882945145-c07280cd-f831"][vc_column_text]
<table style="border: 1px solid #808080; width: 751px; height: 283px;">
<tbody>
<tr>
<td style="border: 1px solid #808080; text-align: center; width: 233.406px;"></td>
<td style="border: 1px solid #808080; text-align: center; width: 235.281px;"><strong>Alle registrerede data</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 232.312px;"><strong>Statistik data (pr myndighed)</strong></td>
</tr>
<tr>
<td style="border: 1px solid #808080; text-align: center; width: 233.406px;"><strong>Borde-bænke/Picnic (1201)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 235.281px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=1201">Alle registrerede borde-bænke/picnic</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 232.312px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT COALESCE(cvr_navn, 'Alle') AS Kommune, SUM(pkt_count) AS Borde_bænke_Picnic FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM fkg.t_5800_fac_pkt WHERE facil_ty_k = 1201 GROUP BY cvr_navn UNION ALL SELECT NULL AS cvr_navn, COUNT(*) AS pkt_count FROM fkg.t_5800_fac_pkt WHERE facil_ty_k = 1201) AS subquery GROUP BY COALESCE(cvr_navn, 'Alle')">Antal registrerede borde-bænke/picnic</a></td>
</tr>
<tr>
<td style="border: 1px solid #808080; text-align: center; width: 233.406px;"><strong>Tørvejrsrum/madpakkehus (1132)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 235.281px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=1132">Alle registrerede tørvejrsrum/madpakkehuse</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 232.312px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT COALESCE(cvr_navn, 'Alle') AS Kommune, SUM(pkt_count) AS Tørvejrsrum_madpakkehus FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM fkg.t_5800_fac_pkt WHERE facil_ty_k = 1132 GROUP BY cvr_navn UNION ALL SELECT NULL AS cvr_navn, COUNT(*) AS pkt_count FROM fkg.t_5800_fac_pkt WHERE facil_ty_k = 1132) AS subquery GROUP BY COALESCE(cvr_navn, 'Alle')">Antal registrerede tørvejrsrum/madpakkehuse</a></td>
</tr>
<tr>
<td style="border: 1px solid #808080; text-align: center; width: 233.406px;"><strong>Petanquebane (4132)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 235.281px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=4132">Alle registrerede petanquebaner</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 232.312px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT COALESCE(cvr_navn, 'Alle') AS Kommune, SUM(pkt_count) AS antal_petanquebaner FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM fkg.t_5800_fac_pkt WHERE facil_ty_k = 4132 GROUP BY cvr_navn UNION ALL SELECT NULL AS cvr_navn, COUNT(*) AS pkt_count FROM fkg.t_5800_fac_pkt WHERE facil_ty_k = 4132) AS subquery GROUP BY COALESCE(cvr_navn, 'Alle')">Antal registrerede petanquebaner</a></td>
</tr>
</tbody>
</table>
<!--more-->
<!--more-->
<!--more-->[/vc_column_text][/vc_tta_section][vc_tta_section title="Maj" tab_id="1707225158202-030d23ca-4ea2"][vc_column_text css=""]
<table style="border: 1px solid #808080; width: 751px; height: 283px;">
<tbody>
<tr>
<td style="border: 1px solid #808080; text-align: center; width: 233.406px;"></td>
<td style="border: 1px solid #808080; text-align: center; width: 235.281px;"><strong>Alle registrerede data</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 232.312px;"><strong>Statistik data (pr myndighed)</strong></td>
</tr>
<tr>
<td style="border: 1px solid #808080; text-align: center; width: 233.406px;"><strong>Ophaler-/isætningsplads (6062)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 235.281px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=6062">Alle registrerede ophaler-/isætningspladser</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 232.312px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20%27Alle%27)%20AS%20Kommune,%20SUM(pkt_count)%20AS%20Ophaler_is%C3%A6tningsplads%20FROM%20(%20SELECT%20cvr_navn,%20COUNT(*)%20AS%20pkt_count%20FROM%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k%20=%206062%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=%206062%20)%20AS%20subquery%20GROUP%20BY%20COALESCE(cvr_navn,%20%27Alle%27)">Antal registrerede ophaler-/isætningspladser</a></td>
</tr>
<tr>
<td style="border: 1px solid #808080; text-align: center; width: 233.406px;"><strong>Kano-/kajakrasteplads (6052)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 235.281px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=csv&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=6052">Alle registrerede kano-/kajakrastepladser</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 232.312px;"><a href="Antal'>https://geofa.geodanmark.dk/api/v2/sql/fkg?format=csv&amp;q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(pkt_count)%20AS%20Kano_kajakrasteplads%20FROM%20(SELECT%20cvr_navn,%20COUNT(*)%20AS%20pkt_count%20FROM%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k%20=%206052%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=%206052)%20AS%20subquery%20GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede kano-/kajakrastepladser</a></td>
</tr>
<tr>
<td style="border: 1px solid #808080; text-align: center; width: 233.406px;"><strong>Slæbested (1102)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 235.281px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=1102">Alle registrerede slæbesteder</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 232.312px;"><a href="Antal'>https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(pkt_count)%20AS%20slæbested%20FROM%20(SELECT%20cvr_navn,%20COUNT(*)%20AS%20pkt_count%20FROM%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k%20=%201102%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=%201102)%20AS%20subquery%20GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede slæbested</a></td>
</tr>
<tr>
<td style="border: 1px solid #808080; text-align: center; width: 233.406px;"><strong>Svajeplads (6071)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 235.281px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=6071">Alle registrerede svajepladser</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 232.312px;"><a href="Antal'>https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(pkt_count)%20AS%20svajeplads%20FROM%20(SELECT%20cvr_navn,%20COUNT(*)%20AS%20pkt_count%20FROM%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k%20=%206071%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=%206071)%20AS%20subquery%20GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede svajepladser</a></td>
</tr>
<tr>
<td style="border: 1px solid #808080; text-align: center; width: 233.406px;"><strong>Kano og kajaksejlads (9)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 235.281px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5802_fac_li%20WHERE%20rute_ty_k=9">Alle registrerede kano og kajaksejlads</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 232.312px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(route_count)%20AS antalkanoogkajaksejlads FROM%20(SELECT cvr_navn,%20COUNT(*)%20AS route_count FROM%20fkg.t_5802_fac_li%20WHERE rute_ty_k =%209%20GROUP%20BY cvr_navn UNION%20ALL%20SELECT%20NULL%20AS cvr_navn,%20COUNT(*)%20AS route_count FROM%20fkg.t_5802_fac_li%20WHERE rute_ty_k =%209)%20AS subquery GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede kano og kajaksejlads</a>

<a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=%20SELECT%20COALESCE(cvr_navn,%20%27Alle%27)%20AS%20Kommune,%20SUM(route_count)%20AS%20antalkanogkajaksejlads,%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=%209%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=%209)%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) - kano og kajaksejlads målt i m</a></td>
</tr>
</tbody>
</table>
<!--more-->
<!--more-->
<!--more-->[/vc_column_text][/vc_tta_section][vc_tta_section title="Juni" tab_id="1707228240197-593a0887-a91f"][vc_column_text css=""]
<table style="border: 1px solid #808080; width: 571px; height: 406px;">
<tbody>
<tr style="height: 28px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 28px;"></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 28px;"><strong>Alle registrerede data</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 28px;"><strong>Statistik data (pr myndighed)</strong></td>
</tr>
<tr style="height: 56px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 56px;"><strong>Mountainbikerute (4)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 56px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5802_fac_li%20WHERE%20rute_ty_k=4">Alle registrerede mountainbikeruter</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 56px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20%27Alle%27)%20AS%20Kommune,%20SUM(route_count)%20AS%20antalmountainbikeruter,%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=%204%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=%204)%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">Antal registrerede mountainbikeruter</a>

<a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20%27Alle%27)%20AS%20Kommune,%20SUM(route_count)%20AS%20antalmountainbikeruter,%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=%204%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=%204)%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) - mountainbikeruter målt i m</a></td>
</tr>
<tr style="height: 28px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 28px;"><strong>Cykelbane (4041)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 28px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=4041">Alle registrerede cykelbaner</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 28px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(pkt_count)%20AS%20Cykelbane FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt%20WHERE facil_ty_k =%204041%20GROUP%20BY cvr_navn UNION%20ALL%20SELECT%20NULL%20AS cvr_navn,%20COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt WHERE facil_ty_k =%204041)%20AS subquery GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede cykelbaner</a></td>
</tr>
<tr style="height: 84px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 84px;"><strong>Hundeskov/hundepark
/fritløbsareal (1191)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 84px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=1191">Alle registrerede hundeskove/hundeparker/
fritløbsarealer</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 84px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(pkt_count)%20AS%20Hundeskov FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt%20WHERE facil_ty_k =%201191%20GROUP%20BY cvr_navn UNION%20ALL%20SELECT%20NULL%20AS cvr_navn,%20COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt WHERE facil_ty_k =%201191)%20AS subquery GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede hundeskov/hundepark/
fritløbsarealer</a></td>
</tr>
</tbody>
</table>
<!--more-->
<!--more-->
<!--more-->[/vc_column_text][/vc_tta_section][vc_tta_section title="August" tab_id="1725457971766-539271dc-97a4"][vc_column_text css=""]
<table style="border: 1px solid #808080; width: 571px; height: 406px;">
<tbody>
<tr style="height: 28px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 28px;"></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 28px;"><strong>Alle registrerede data</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 28px;"><strong>Statistik data (pr myndighed)</strong></td>
</tr>
<tr style="height: 56px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 56px;"><strong>Fugle/udsigtstårn (2012)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 56px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=2012">Alle registrerede fugle/udsigtstårne</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 56px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(pkt_count)%20AS%20 antal_fugletaarn_udsigstaarn FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt%20WHERE facil_ty_k =%202012%20GROUP%20BY cvr_navn UNION%20ALL%20SELECT%20NULL%20AS cvr_navn,%20COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt WHERE facil_ty_k =%202012)%20AS subquery GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede fugle/udsigtstårne</a></td>
</tr>
<tr style="height: 28px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 28px;"><strong>Udsigtspunkt (2022)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 28px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=2022">Alle registrerede udsigtspunkter</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 28px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(pkt_count)%20AS%20 antal_udsigtspunkt FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt%20WHERE facil_ty_k =%202022%20GROUP%20BY cvr_navn UNION%20ALL%20SELECT%20NULL%20AS cvr_navn,%20COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt WHERE facil_ty_k =%202022)%20AS subquery GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede udsigtspunkter</a></td>
</tr>
<tr style="height: 84px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 84px;"><strong>Udstilling (2092)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 84px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=2092">Alle registrerede udstillinger</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 84px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(pkt_count)%20AS%20 antal_Udstilling FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt%20WHERE facil_ty_k =%202092%20GROUP%20BY cvr_navn UNION%20ALL%20SELECT%20NULL%20AS cvr_navn,%20COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt WHERE facil_ty_k =%202092)%20AS subquery GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede udstillinger</a></td>
</tr>
</tbody>
</table>
<!--more-->
<!--more-->
<!--more-->[/vc_column_text][/vc_tta_section][vc_tta_section title="September" tab_id="1725457986865-ad5f9368-68f5"][vc_column_text css=""]
<table style="border: 1px solid #808080; width: 571px; height: 406px;">
<tbody>
<tr style="height: 28px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 28px;"></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 28px;"><strong>Alle registrerede data</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 28px;"><strong>Statistik data (pr myndighed)</strong></td>
</tr>
<tr style="height: 56px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 56px;"><strong>Naturskole (2082)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 56px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=2082">Alle registrerede naturskoler</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 56px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(pkt_count)%20AS%20antal_Naturskole FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt%20WHERE facil_ty_k =%202082%20GROUP%20BY cvr_navn UNION%20ALL%20SELECT%20NULL%20AS cvr_navn,%20COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt WHERE facil_ty_k =%202082)%20AS subquery GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede naturskoler</a></td>
</tr>
<tr style="height: 28px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 28px;"><strong>Virtuelt oplevelsespunkt (1142)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 28px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=1142">Alle registrerede virtuelle oplevelsespunkter</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 28px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(pkt_count)%20AS%20antal_Virtuelt_oplevelsespunkt FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt%20WHERE facil_ty_k =%201142%20GROUP%20BY cvr_navn UNION%20ALL%20SELECT%20NULL%20AS cvr_navn,%20COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt WHERE facil_ty_k =%201142)%20AS subquery GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede virtuelle oplevelsespunkter</a></td>
</tr>
<tr style="height: 84px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 84px;"><strong>Formidling af fortidsminder (5072)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 84px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=5072">Alle registrerede formidlinger af fortidsminder</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 84px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(pkt_count)%20AS%20antal_Formidling_af_fortidsminde FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt%20WHERE facil_ty_k =%205072%20GROUP%20BY cvr_navn UNION%20ALL%20SELECT%20NULL%20AS cvr_navn,%20COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt WHERE facil_ty_k =%205072)%20AS subquery GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede formidlinger af fortidsminder</a></td>
</tr>
</tbody>
</table>
<!--more-->
<!--more-->
<!--more-->[/vc_column_text][/vc_tta_section][vc_tta_section title="Oktober" tab_id="1725457997657-f6ba430d-9046"][vc_column_text css=""]
<table style="border: 1px solid #808080; width: 571px; height: 406px;">
<tbody>
<tr style="height: 28px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 28px;"></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 28px;"><strong>Alle registrerede data</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 28px;"><strong>Statistik data (pr myndighed)</strong></td>
</tr>
<tr style="height: 56px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 56px;"><strong>Kælkebakke (2132)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 56px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=2132">Alle registrerede kælkebakker</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 56px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(pkt_count)%20AS%20antal_Kaelkebakke FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt%20WHERE facil_ty_k =%202132%20GROUP%20BY cvr_navn UNION%20ALL%20SELECT%20NULL%20AS cvr_navn,%20COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt WHERE facil_ty_k =%202132)%20AS subquery GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede kælkebakker</a></td>
</tr>
<tr style="height: 28px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 28px;"><strong>Parkeringsplads (1351)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 28px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=1351">Alle registrerede parkeringspladser</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 28px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(pkt_count)%20AS%20antal_Parkeringsplads FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt%20WHERE facil_ty_k =%201351%20GROUP%20BY cvr_navn UNION%20ALL%20SELECT%20NULL%20AS cvr_navn,%20COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt WHERE facil_ty_k =%201351)%20AS subquery GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede parkeringspladser</a></td>
</tr>
<tr style="height: 84px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 84px;"><strong>Holdepladser (1291)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 84px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=1291">Alle registrerede holdepladser</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 84px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(pkt_count)%20AS%20antal_Holdeplads FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt%20WHERE facil_ty_k =%201291%20GROUP%20BY cvr_navn UNION%20ALL%20SELECT%20NULL%20AS cvr_navn,%20COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt WHERE facil_ty_k =%201291)%20AS subquery GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede holdepladser</a></td>
</tr>
</tbody>
</table>
<!--more-->
<!--more-->
<!--more-->[/vc_column_text][/vc_tta_section][vc_tta_section title="November" tab_id="1725458010682-6ba4cc7b-4e66"][vc_column_text css=""]
<table style="border: 1px solid #808080; width: 571px; height: 406px;">
<tbody>
<tr style="height: 28px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 28px;"></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 28px;"><strong>Alle registrerede data</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 28px;"><strong>Statistik data (pr myndighed)</strong></td>
</tr>
<tr style="height: 56px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 56px;"><strong>Frit fiskeri (2171)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 56px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=2171">Alle registrerede frit fiskeri</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 56px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(pkt_count)%20AS%20antal_Frit_Fiskeri FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt%20WHERE facil_ty_k =%202171%20GROUP%20BY cvr_navn UNION%20ALL%20SELECT%20NULL%20AS cvr_navn,%20COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt WHERE facil_ty_k =%202171)%20AS subquery GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede frit fiskeri</a></td>
</tr>
<tr style="height: 28px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 28px;"><strong>Badestrand/-sted (1051)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 28px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=1051">Alle registrerede badestrande/steder</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 28px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(pkt_count)%20AS%20antal_Badestrand_badested FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt%20WHERE facil_ty_k =%201051%20GROUP%20BY cvr_navn UNION%20ALL%20SELECT%20NULL%20AS cvr_navn,%20COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt WHERE facil_ty_k =%201051)%20AS subquery GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede badestrande/steder</a></td>
</tr>
<tr style="height: 84px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 84px;"><strong>Blå flag strand (1071)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 84px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=1071">Alle registrerede blå flag strande</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 84px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(pkt_count)%20AS%20antal_Blå_flag_strand FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt%20WHERE facil_ty_k =%201071%20GROUP%20BY cvr_navn UNION%20ALL%20SELECT%20NULL%20AS cvr_navn,%20COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt WHERE facil_ty_k =%201071)%20AS subquery GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede blå flag strande</a></td>
</tr>
<tr style="height: 84px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 84px;"><strong>Badepunkt (1062)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 84px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=1062">Alle registrerede badepunkter</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 84px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(pkt_count)%20AS%20antal_Badepunkt FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt%20WHERE facil_ty_k =%201062%20GROUP%20BY cvr_navn UNION%20ALL%20SELECT%20NULL%20AS cvr_navn,%20COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt WHERE facil_ty_k =%201062)%20AS subquery GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede badepunkter</a></td>
</tr>
</tbody>
</table>
<!--more-->
<!--more-->
<!--more-->[/vc_column_text][/vc_tta_section][vc_tta_section title="December" tab_id="1725458020176-6ed3ffa8-8059"][vc_column_text css=""]
<table style="border: 1px solid #808080; width: 571px; height: 406px;">
<tbody>
<tr style="height: 28px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 28px;"></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 28px;"><strong>Alle registrerede data</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 28px;"><strong>Statistik data (pr myndighed)</strong></td>
</tr>
<tr style="height: 56px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 56px;"><strong>Vandreruter (5)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 56px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=csv&amp;q=select%20*%20from%20fkg.t_5802_fac_li%20WHERE%20rute_ty_k=5">Alle registrerede vandreruter</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 56px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT COALESCE(cvr_navn, 'Alle') AS Kommune, SUM(route_count) AS antal_vandreruter, ROUND(SUM(route_length)::numeric, 0) AS samlet_længde_m FROM (SELECT cvr_navn, COUNT(*) AS route_count, SUM(ST_Length(geometri)) AS route_length FROM fkg.t_5802_fac_li WHERE rute_ty_k = 5 GROUP BY cvr_navn UNION ALL SELECT NULL AS cvr_navn, COUNT(*) AS route_count, SUM(ST_Length (geometri)) AS route_length FROM fkg.t_5802_fac_li WHERE rute_ty_k = 5) AS subquery GROUP BY COALESCE (cvr_navn, 'Alle') ORDER BY CASE WHEN COALESCE(cvr_navn, 'Alle') = 'Alle' THEN 0 ELSE 1 END, Kommune">Antal registrerede vandreruter</a></td>
</tr>
<tr style="height: 28px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 28px;"><strong>Rekreativt naturområde (2041)</strong></td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 28px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=select%20*%20from%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k=2041">Alle registrerede rekreative naturområder</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 28px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(pkt_count)%20AS%20antal_Rekreativt_naturomraade FROM (SELECT cvr_navn, COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt%20WHERE facil_ty_k =%202041%20GROUP%20BY cvr_navn UNION%20ALL%20SELECT%20NULL%20AS cvr_navn,%20COUNT(*) AS pkt_count FROM%20fkg.t_5800_fac_pkt WHERE facil_ty_k =%202041)%20AS subquery GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede rekreative naturområder</a></td>
</tr>
<tr style="height: 84px;">
<td style="border: 1px solid #808080; text-align: center; width: 185.234px; height: 84px;"><strong><strong>Seværdigheder
</strong></strong>2191 Seværdighed - Fauna
2201 Seværdighed – Flora
2211 Seværdighed – Geologi</td>
<td style="border: 1px solid #808080; text-align: center; width: 203.922px; height: 84px;"><a href="https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20*%20FROM%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k%20IN%20(2191,%202201,%202211)">Alle registrerede seværdigheder</a></td>
<td style="border: 1px solid #808080; text-align: center; width: 186.094px; height: 84px;"><a href="Antal'>https://geofa.geodanmark.dk/api/v2/sql/fkg?format=excel&amp;q=SELECT%20COALESCE(cvr_navn,%20'Alle')%20AS%20Kommune,%20SUM(CASE%20WHEN%20facil_ty_k%20=%202191%20THEN%20pkt_count%20ELSE%200%20END)%20AS%20antal_Fauna_seværdighed,%20SUM(CASE%20WHEN%20facil_ty_k%20=%202201%20THEN%20pkt_count%20ELSE%200%20END)%20AS%20antal_Flora_seværdighed,%20SUM(CASE%20WHEN%20facil_ty_k%20=%202211%20THEN%20pkt_count%20ELSE%200%20END)%20AS%20antal_geologi_seværdighed%20FROM%20(SELECT%20cvr_navn,%20facil_ty_k,%20COUNT(*)%20AS%20pkt_count%20FROM%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k%20IN%20(2191,%202201,%202211)%20GROUP%20BY%20cvr_navn,%20facil_ty_k%20UNION%20ALL%20SELECT%20NULL%20AS%20cvr_navn,%20facil_ty_k,%20COUNT(*)%20AS%20pkt_count%20FROM%20fkg.t_5800_fac_pkt%20WHERE%20facil_ty_k%20IN%20(2191,%202201,%202211)%20GROUP%20BY%20facil_ty_k)%20AS%20subquery%20GROUP%20BY%20COALESCE(cvr_navn,%20'Alle')">Antal registrerede seværdigheder</a></td>
</tr>
</tbody>
</table>
<!--more-->
<!--more-->
<!--more-->[/vc_column_text][/vc_tta_section][/vc_tta_accordion]

Information om siden:

Sidst revideret: 2022

Ansvarlig: Sigurd Drejer, sivd@kl.dk

Du kan lade dig inspirere af dette årshjul, som er en sammensmeltning af flere kommuners måde at arbejde med GeoFA.-data på. Årshjulet giver en struktureret og tilbagevendende måde at gøre fokuserede indsatser ift. friluftsdata på. Elefanten nedbrydes i mindre bidder slightly smiling face  Nedenunder hjulet finder du for hver måned dels en hjælp til best practice, men også en altid opdateret oversigt over, hvor mange data din kommune og andre interessenter har registreret i GeoFA:

 Image Added

.

Information om siden:

Sidst revideret: 31.07.2025

Ansvarlig: Sigurd Drejer, sivd@kl.dk

Expand
titleJanuar
Expand
titleFebruar
Expand
titleMarts
Expand
titleApril


Expand
titleMaj
Expand
titleJuni
Expand
titleAugust
Expand
titleSeptember
Expand
titleOktober

Data til dig

  • En leverandør har registreret kælkebakker på deres kælkekort blandt andet gennem en crowdsourcing funktion, hvor folk kunne melde manglende kælkebakker ind. Disse kælkebakker ligger ikke i forvejen i GeoFA. Kælkebakkerne kan hentes gratis her til upload i GeoFA. Bemærk kolonnen ‘navn’ er udfyldt ved størstedelen af kælkebakkerne.
Expand
titleNovember
Expand
titleDecember

Alle registrerede dataStatistik data (pr myndighed)
Vandreruter (5)Alle registrerede vandreruterAntal registrerede vandreruter
Rekreativt naturområde (2041)Alle registrerede rekreative naturområderAntal registrerede rekreative naturområder
Seværdigheder
 Seværdighed - Fauna (2191)
 Seværdighed – Flora (2201)
Seværdighed – Geologi (2211)
Alle registrerede seværdighederAntal registrerede seværdigheder

Tilmeld dig nyhedsbrevet om GeoFA datavask her. Nyhedsbrevet bliver sendt ud månedligt efter årshjulets struktur. Se tidligere udsendte nyhedsmails her.

Expand
titleJanuar
ExpandtitleFebruar