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.
[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&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][/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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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&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]