| Source |
https://open.data4citizen.com/visualisation/information/?id=indices_de_position_sociale_des_etablissements_scolaires_de_la
|
| Last Updated |
May 22, 2026, 10:12 (UTC)
|
| Created |
May 22, 2026, 08:59 (UTC)
|
| ChoroplethConfig |
{"04a07c00-a91b-4550-8825-43469165c451":{"metric_column":"effectifs","aggregate":"SUM"}} |
| FTP_API |
FTP |
| LinkedDataSet |
["indices_de_position_sociale_des_ecoles_a_partir_de_2022","indices_de_position_sociale_dans_les_colleges_2022","indices_de_position_sociale_dans_les_lycees_2022","base_du_comparateur_de_territoires"] |
| 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":"WITH ips_ecoles AS (\r\n SELECT\r\n 'ecole' AS type_etablissement,\r\n rentree_scolaire,\r\n academie,\r\n code_du_departement AS code_departement,\r\n departement,\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 NULL::numeric AS effectifs,\r\n NULL::numeric AS ecart_type_ips\r\n FROM \"f53e280a-bf05-4660-92f8-7cc071b740c4\"\r\n),\r\n\r\nips_colleges AS (\r\n SELECT\r\n 'college' AS type_etablissement,\r\n rentree_scolaire,\r\n academie,\r\n code_du_departement AS code_departement,\r\n departement,\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 effectifs,\r\n ecart_type_de_l_ips AS ecart_type_ips\r\n FROM \"d33a2cc8-58c0-4a2d-b5a2-3f54ebbbb1db\"\r\n),\r\n\r\nips_lycees AS (\r\n SELECT\r\n 'lycee' AS type_etablissement,\r\n rentree_scolaire,\r\n academie,\r\n code_du_departement AS code_departement,\r\n departement,\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 \"effectifs_ensemble_gt-pro\" AS effectifs,\r\n NULL::numeric AS ecart_type_ips\r\n FROM \"824d0e74-fb7b-4975-a2e3-eff9be88d32b\"\r\n)\r\n\r\nSELECT ips.*, c.codgeo\r\nFROM (\r\n SELECT * FROM ips_ecoles\r\n UNION ALL\r\n SELECT * FROM ips_colleges\r\n UNION ALL\r\n SELECT * FROM ips_lycees\r\n) ips\r\nJOIN \"a69528ba-9dac-43fd-b974-c9c62aec2c41\" c\r\n ON TRIM(ips.code_commune) = TRIM(c.codgeo)\r\nWHERE c.epci = 200033579\r\nORDER BY commune, type_etablissement, nom_etablissement, rentree_scolaire;"} |
| dataset_not_visible |
0 |
| dataset_size |
0.022665023803710938 |
| date_dataset |
2026-05-22 |
| date_deposit |
2026-05-22 |
| date_modification |
2026-05-22 |
| date_modification_data |
2026-05-22T08:59:32+00:00 |
| date_moissonnage_last_modification |
2026-05-22T08:59:35.883875 |
| 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,api,table,choropleth,raw_data |
| map_color |
|
| nb_geo_features |
0 |
| nb_views |
00000008 |
| not_visible_in_chart_interface |
0 |
| not_visible_in_map_interface |
0 |
| producer |
|
| records_count |
{"04a07c00-a91b-4550-8825-43469165c451":"0000000192"} |
| show_cube_tab |
0 |
| themes |
["education_et_enseignement"] |
| tooltip |
{"resources":[{"type":"standard","resource_id":"04a07c00-a91b-4550-8825-43469165c451","value":{"title":"","fields":"_id,type_etablissement,rentree_scolaire,academie,code_departement,departement,code_commune,commune,uai,nom_etablissement,secteur,ips,effectifs,ecart_type_ips,codgeo"}}]} |
| uploader |
user_d4c |
| weight |
0 |
| wfs_link |
|
| wms_link |
|