| Source |
https://open.data4citizen.com/visualisation/information/?id=education_prioritaire_et_indice_de_position_sociale_dans_la_co
|
| Last Updated |
June 24, 2026, 15:38 (UTC)
|
| Created |
May 22, 2026, 09:59 (UTC)
|
| FTP_API |
FTP |
| LinkedDataSet |
["etablissements_de_l_education_prioritaire","indices_de_position_sociale_dans_les_colleges_2022","indices_de_position_sociale_dans_les_lycees_2022","indices_de_position_sociale_des_ecoles_a_partir_de_2022","base_du_comparateur_de_territoires"] |
| Picto |
|
| allow_data_inputs |
0 |
| bbox-east-long |
55.825493124272 |
| bbox-north-lat |
51.033901387675 |
| bbox-south-lat |
-21.386912898623 |
| bbox-west-long |
-61.798305091244 |
| 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":"WITH ips_consolide AS (\r\n SELECT\r\n 'ecole' AS type_etablissement,\r\n rentree_scolaire,\r\n code_insee_de_la_commune AS code_commune,\r\n nom_de_la_commune AS commune,\r\n uai,\r\n nom_de_l_etablissement AS nom_etablissement,\r\n secteur,\r\n CASE\r\n WHEN REPLACE(ips, ',', '.') ~ '^-?[0-9]+(\\.[0-9]+)?$'\r\n THEN REPLACE(ips, ',', '.')::numeric\r\n ELSE NULL\r\n END AS ips\r\n FROM \"f53e280a-bf05-4660-92f8-7cc071b740c4\"\r\n\r\n UNION ALL\r\n\r\n SELECT\r\n 'college' AS type_etablissement,\r\n rentree_scolaire,\r\n code_insee_de_la_commune AS code_commune,\r\n nom_de_la_commune AS commune,\r\n uai,\r\n nom_de_l_etablissment AS nom_etablissement,\r\n secteur,\r\n ips\r\n FROM \"d33a2cc8-58c0-4a2d-b5a2-3f54ebbbb1db\"\r\n\r\n UNION ALL\r\n\r\n SELECT\r\n 'lycee' AS type_etablissement,\r\n rentree_scolaire,\r\n code_insee_de_la_commune AS code_commune,\r\n nom_de_la_commune AS commune,\r\n uai,\r\n nom_de_l_etablissment AS nom_etablissement,\r\n secteur,\r\n \"ips_ensemble_gt-pro\" AS ips\r\n FROM \"824d0e74-fb7b-4975-a2e3-eff9be88d32b\"\r\n)\r\n\r\nSELECT\r\n ep.uai,\r\n ep.nom_etablissement,\r\n ep.type_etablissement,\r\n ep.statut_public_prive,\r\n ep.ep_2022_2023 AS statut_education_prioritaire,\r\n ep.qp_a_proximite_o_n,\r\n ep.qp_a_proximite,\r\n ep.nom_du_qp,\r\n ep.nombre_d_eleves,\r\n ep.code_commune,\r\n ep.nom_commune AS commune,\r\n ep.code_departement,\r\n ep.libelle_departement AS departement,\r\n ep.code_region,\r\n ep.libelle_region AS region,\r\n ep.latitude,\r\n ep.longitude,\r\n\r\n CASE\r\n WHEN ep.latitude IS NOT NULL AND ep.longitude IS NOT NULL\r\n THEN ep.latitude::text || ',' || ep.longitude::text\r\n ELSE NULL\r\n END AS geo_point_2d,\r\n c.epci,\r\n ips.rentree_scolaire,\r\n ips.ips\r\nFROM \"816a0970-e5ae-4b9c-8c9e-f6c637bfb691\" ep\r\nJOIN \"a69528ba-9dac-43fd-b974-c9c62aec2c41\" c\r\n ON TRIM(ep.code_commune) = TRIM(c.codgeo)\r\nLEFT JOIN ips_consolide ips\r\n ON ep.uai = ips.uai\r\nORDER BY ep.nom_commune, ep.nom_etablissement;"} |
| dataset_not_visible |
0 |
| dataset_size |
3.610422134399414 |
| date_dataset |
2026-05-22 |
| date_deposit |
2026-05-22 |
| date_modification |
2026-05-22 |
| date_modification_data |
2026-05-22T09:59:34+00:00 |
| date_moissonnage_last_modification |
2026-05-22T09:59:46.230193 |
| 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,choropleth,map_data |
| map_color |
|
| nb_geo_features |
0 |
| nb_views |
00000017 |
| not_visible_in_chart_interface |
0 |
| not_visible_in_map_interface |
0 |
| producer |
|
| records_count |
{"ae623444-1faa-42c6-9889-1b987006ab5f":"0000016269"} |
| show_cube_tab |
0 |
| spatial |
{"type":"Polygon","coordinates":[[[-61.798305091244,-21.386912898623],[55.825493124272,-21.386912898623],[55.825493124272,51.033901387675],[-61.798305091244,51.033901387675],[-61.798305091244,-21.386912898623]]]} |
| themes |
["education_et_enseignement"] |
| tooltip |
{"resources":[{"type":"standard","resource_id":"ae623444-1faa-42c6-9889-1b987006ab5f","value":{"title":"","fields":"_id,uai,nom_etablissement,type_etablissement,statut_public_prive,statut_education_prioritaire,qp_a_proximite_o_n,qp_a_proximite,nom_du_qp,nombre_d_eleves,code_commune,commune,code_departement,departement,code_region,region,latitude,longitude,geo_point_2d,epci,rentree_scolaire,ips"}}]} |
| uploader |
user_d4c |
| weight |
0 |
| wfs_link |
|
| wms_link |
|