Skip to content

Query and export KML files from ANFR radio sites public data

Notifications You must be signed in to change notification settings

looran/antennes

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

51 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

antennes - Query and export KML files from ANFR radio sites data

Features:

  • Generates KML file of all emetteurs sites based on ANFR monthly data
  • Opens in many PC / Mobile mapping software
  • Each placemark contains all informations about support, stations, emetteurs and antennes on the site
  • Each placemark is colored in red or orange if it has received modifications in the last 1 or 3 months

You can download pre-generated KML files here for each month perdiod since 2015:

  • anfr_YYYY-MM_departements.kml [~200MB] KML file containing all supports organised by departement
  • anfr_YYYY-MM_departements_light.kml [~30MB] KML file containing all supports organised by departement and with no description
  • anfr_YYYY-MM_proprietaires.kml [~200MB] KML file containing all supports organised by proprietaire
  • anfr_YYYY-MM_stats.txt [~2KB] statistics for the period

Additionally in split/ you can find the splited KML files for each period:

  • split/anfr_YYYY-MM_departement/anfr_YYYY-MM_departement_<dept-id>.kml [<10MB] a KML file with supports for a single departement
  • split/anfr_YYYY-MM_proprietaire/anfr_YYYY-MM_proprietaire_<prop-id>_<prop-name>.kml [<30MB] a KML file with supports owned by a single proprietaire
  • split/anfr_YYYY-MM_systeme/anfr_YYYY-MM_systeme_<sys-id>_<prop-name>.kml [12KB-200MB] a KML file with supports that host a given system, organized by departement

example usage: antennes KML file imported in Google Earth
example usage: antennes KML file imported in Google Earth


example usage: antennes KML file imported on Android

NOTE: Some mapping software do not support large numbers of placemarks. Consider displaying only a single Document within the KML files, or load smaller splitted KML files.

Usage

usage: antennes [-Cv] [-b <dir>] [-k <dir>] <data_dir>
Query and export KML files from ANFR radio sites public data
-b <dir> export csv bands statistics to this directory
-C       do not set any kml placemark colors
-k <dir> export kml files to this directory
-s       display antennes statistics
-v       verbose logging
if neither -s or -k are specified, this program only loads the data.
output kml files hierarchy:
   anfr_proprietaires.kml : all supports in a single file, one section per proprietaire
   anfr_departements.kml : all supports in a single file, one section per departement
   anfr_departements_light.kml : all supports in a single file, one section per departement, no description
   anfr_proprietaire/anfr_proprietaire_<proprietaire-id>_<proprietaire-name>.kml : one file per proprietaire
   anfr_departement/anfr_departement_<dept-id>.kml : one file per departement
   anfr_systeme/anfr_systeme_<sys-name>.kml : one file per systeme, one section per departement
kml placemark colors:
   orange for supports with stations updated in less than 3 months, red for 1 month, blue otherwise

Build

make will build using clang

make with_gcc will build using gcc

make debug will build using clang and debug flags

Example usage

Fetching latest data set

$ ./fetch_antennes.sh
downloading last 1 sets
[...]
[*] all sets downloaded to ./dl and extracted in ./extract

Generating KML files on data from 2022-08

$ ./antennes -k output_kml/ extract/2022-08
[+] loading files from extract/2022-08
35 natures of support
87271 supports
74 proprietaires
antennes: incoherent data set: line 72205: station 0422750464 already exists, ignoring
169115 stations in 108 departments and 2628 zones
176 exploitants
1953886 emetteurs and 71 systemes
3897941 bandes
antennes: incoherent data set: station 9720980043 not found for antenne 210680, ignoring
antennes: incoherent data set: station 9720980003 not found for antenne 1755967, ignoring
552795 antennes
82 types of antenne
[*] exporting kml to output_kml/
created 171 kml files

Source code hierarchy

  • antennes.c source code for this program
  • fetch_antennes.sh fetch the data from data.gouv.fr
  • Makefile targets to build and test this program
  • README.md this file
  • release_antennes.sh automate generation of KML and statistics for multiple sets of data

Input data fields

SUP_ANTENNE.txt
    STA_NM_ANFR;AER_ID;TAE_ID;AER_NB_DIMENSION;AER_FG_RAYON;AER_NB_AZIMUT;AER_NB_ALT_BAS;SUP_ID
SUP_BANDE.txt
    STA_NM_ANFR;BAN_ID;EMR_ID;BAN_NB_F_DEB;BAN_NB_F_FIN;BAN_FG_UNITE
SUP_EMETTEUR.txt
    EMR_ID;EMR_LB_SYSTEME;STA_NM_ANFR;AER_ID;EMR_DT_SERVICE
SUP_EXPLOITANT.txt
    ADM_ID;ADM_LB_NOM
SUP_NATURE.txt
    NAT_ID;NAT_LB_NOM
SUP_PROPRIETAIRE.txt
    TPO_ID;TPO_LB
SUP_STATION.txt
    STA_NM_ANFR;ADM_ID;DEM_NM_COMSIS;DTE_IMPLANTATION;DTE_MODIF;DTE_EN_SERVICE
SUP_SUPPORT.txt
    SUP_ID;STA_NM_ANFR;NAT_ID;COR_NB_DG_LAT;COR_NB_MN_LAT;COR_NB_SC_LAT;COR_CD_NS_LAT;COR_NB_DG_LON;COR_NB_MN_LON;COR_NB_SC_LON;COR_CD_EW_LON;SUP_NM_HAUT;TPO_ID;ADR_LB_LIEU;ADR_LB_ADD1;ADR_LB_ADD2;ADR_LB_ADD3;ADR_NM_CP;COM_CD_INSEE
SUP_TYPE_ANTENNE.txt
    TAE_ID;TAE_LB

Requirements

5GB of free RAM

Ressources

Data sources

Source des donnees sur data.gouv.fr

Reutilisation des donnees

Autres sources de donnees

Similar projects

carte-fh

About

Query and export KML files from ANFR radio sites public data

Topics

Resources

Stars

Watchers

Forks