| Source |
https://open.data4citizen.com/visualisation/information/?id=etablissements_scolaires_geolocalises_de_la_communaute_urbaine
|
| Last Updated |
May 22, 2026, 14:35 (UTC)
|
| Created |
May 22, 2026, 08:38 (UTC)
|
| FTP_API |
FTP |
| LinkedDataSet |
["base_du_comparateur_de_territoires","liste_geolocalisee_des_etablissements_d_enseignement_des_premi_1"] |
| Picto |
|
| allow_data_inputs |
0 |
| data4citizen-type |
sql |
| data_interop |
0 |
| data_rgpd |
false |
| dataset-model |
{"db_type":"pgsql","db_name":"datastore","host":"db","port":"5432","login":"ckan","password":"ckan","sql_query":"SELECT\r\n e.numero_d_uai AS uai,\r\n e.appellation_officielle AS nom_etablissement,\r\n e.denomination_principale,\r\n e.denomination_complementaire_ou_patronyme AS patronyme,\r\n e.secteur,\r\n e.adresse___designation_de_la_voie AS adresse,\r\n e.adresse___code_postal AS code_postal,\r\n e.localite_d_acheminement,\r\n e.libelle_de_la_commune AS commune,\r\n e.code_insee_de_la_commune AS code_commune,\r\n e.code_insee_du_departement_ou_de_la_collectivite AS code_departement,\r\n e.libelle_du_departement_ou_de_la_collectivite AS departement,\r\n e.code_insee_de_la_region AS code_region,\r\n e.libelle_de_la_region AS region,\r\n e.code_de_l_academie AS code_academie,\r\n e.libelle_de_l_academie AS academie,\r\n e.code_nature_de_l_uai,\r\n e.libelle_de_la_nature_de_l_uai AS nature_etablissement,\r\n e.libelle_de_l_etat_de_l_etablissement AS etat_etablissement,\r\n e.libelle_du_type_de_contrat AS type_contrat,\r\n\r\n CASE\r\n WHEN REPLACE(e.latitude_wgs84, ',', '.') ~ '^-?[0-9]+(\\.[0-9]+)?$'\r\n THEN REPLACE(e.latitude_wgs84, ',', '.')::numeric\r\n ELSE NULL\r\n END AS latitude,\r\n\r\n CASE\r\n WHEN REPLACE(e.longitude_wgs84, ',', '.') ~ '^-?[0-9]+(\\.[0-9]+)?$'\r\n THEN REPLACE(e.longitude_wgs84, ',', '.')::numeric\r\n ELSE NULL\r\n END AS longitude,\r\n\r\n e.latitude_et_longitude_wgs84,\r\n 'Liste g\u00e9olocalis\u00e9e des \u00e9tablissements d\u2019enseignement - data.education.gouv.fr' AS source\r\nFROM \"fdd6b3cd-d459-41bf-86d8-5ea9b404ecf2\" e\r\nJOIN \"a69528ba-9dac-43fd-b974-c9c62aec2c41\" c\r\n ON TRIM(e.code_insee_de_la_commune) = TRIM(c.codgeo)\r\nWHERE c.epci = 200033579\r\nORDER BY e.libelle_de_la_commune, e.appellation_officielle;"} |
| dataset_not_visible |
0 |
| dataset_size |
0.04456138610839844 |
| date_dataset |
2026-05-22 |
| date_deposit |
2026-05-22 |
| date_modification |
2026-05-22 |
| date_modification_data |
2026-05-22T08:38:06+00:00 |
| date_moissonnage_last_modification |
2026-05-22T08:38:10.330403 |
| default_visu |
0 |
| disable_export_type |
{"flat_formats":false,"geographic_formats":false,"alternative_formats":false,"data_analysis_formats":false,"metadata":false} |
| donnees_source |
|
| edition_security |
{"roles":["administrator"],"users":["*1*","*99*","*127*"]} |
| encoding |
UTF-8 |
| features |
analyze,geo,api,table,raw_data |
| map_color |
|
| nb_geo_features |
0 |
| nb_views |
00000012 |
| not_visible_in_chart_interface |
0 |
| not_visible_in_map_interface |
0 |
| producer |
|
| records_count |
{"90710710-6467-4eff-9bb3-26e9073ed455":"0000000105"} |
| show_cube_tab |
0 |
| themes |
["education_et_enseignement"] |
| tooltip |
{"resources":[{"type":"standard","resource_id":"90710710-6467-4eff-9bb3-26e9073ed455","value":{"title":"","fields":"_id,uai,nom_etablissement,denomination_principale,patronyme,secteur,adresse,code_postal,localite_d_acheminement,commune,code_commune,code_departement,departement,code_region,region,code_academie,academie,code_nature_de_l_uai,nature_etablissement,etat_etablissement,type_contrat,latitude,longitude,latitude_et_longitude_wgs84,source"}}]} |
| uploader |
user_d4c |
| weight |
0 |
| wfs_link |
|
| wms_link |
|