Page History

[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]