Changes
On March 27, 2026 at 9:11:14 AM UTC,
user_d4c:
-
Changed title to Indicateurs concernant les parcelles par IRIS 2023 (previously Parcelles par IRIS 2023)
-
Changed value of field
date_modification
to2026-03-27
(previously2026-03-26
) in Indicateurs concernant les parcelles par IRIS 2023 -
Changed value of field
dataset-model
to{"db_type":"pgsql","db_name":"open","host":"data4citizen-db","port":"5432","login":"postgres","password":"ifr2ipTVt3uf9kK","sql_query":"SELECT\r\n p.code_iris,\r\n p.nom_iris,\r\n p.type_iris,\r\n COUNT(*) AS nb_parcelles,\r\n SUM(p.contenance) AS surface_cadastrale_m2,\r\n percentile_cont(0.5) WITHIN GROUP (ORDER BY p.contenance)\r\n AS surface_mediane_parcelle_m2,\r\n i.geo_point_2d,\r\n i.geo_shape\r\nFROM v_parcelles_saint_martin_iris p\r\nJOIN \"iris_saint-martin\" i\r\n ON p.code_iris = i.code_iris\r\nGROUP BY\r\n p.code_iris,\r\n p.nom_iris,\r\n p.type_iris,\r\n i.geo_point_2d,\r\n i.geo_shape;"}
(previously{"db_type":"pgsql","db_name":"open","host":"data4citizen-db","port":"5432","login":"postgres","password":"ifr2ipTVt3uf9kK","sql_query":"SELECT\r\n annee_mutation,\r\n code_iris,\r\n nom_iris,\r\n count(*) AS nb_parcelles,\r\n sum(contenance) AS surface_cadastrale_m2,\r\n percentile_cont(0.5) WITHIN GROUP (ORDER BY contenance) AS surface_mediane_parcelle_m2,\r\n geo_point_2d,\r\n geo_shape\r\nFROM v_parcelles_saint_martin_iris\r\nGROUP BY annee_mutation,code_iris, nom_iris, geo_point_2d, geo_shape\r\nORDER BY nb_parcelles DESC;"}
) in Indicateurs concernant les parcelles par IRIS 2023
| f | 1 | { | f | 1 | { |
| 2 | "author": "", | 2 | "author": "", | ||
| 3 | "author_email": "", | 3 | "author_email": "", | ||
| 4 | "creator_user_id": "6111694c-812e-41fb-b7fb-4097f86ee8ae", | 4 | "creator_user_id": "6111694c-812e-41fb-b7fb-4097f86ee8ae", | ||
| 5 | "extras": [ | 5 | "extras": [ | ||
| 6 | { | 6 | { | ||
| 7 | "key": "FTP_API", | 7 | "key": "FTP_API", | ||
| 8 | "value": "FTP" | 8 | "value": "FTP" | ||
| 9 | }, | 9 | }, | ||
| 10 | { | 10 | { | ||
| 11 | "key": "LinkedDataSet", | 11 | "key": "LinkedDataSet", | ||
| 12 | "value": "[\"\"]" | 12 | "value": "[\"\"]" | ||
| 13 | }, | 13 | }, | ||
| 14 | { | 14 | { | ||
| 15 | "key": "Picto", | 15 | "key": "Picto", | ||
| 16 | "value": "" | 16 | "value": "" | ||
| 17 | }, | 17 | }, | ||
| 18 | { | 18 | { | ||
| 19 | "key": "allow_data_inputs", | 19 | "key": "allow_data_inputs", | ||
| 20 | "value": "0" | 20 | "value": "0" | ||
| 21 | }, | 21 | }, | ||
| 22 | { | 22 | { | ||
| 23 | "key": "bbox-east-long", | 23 | "key": "bbox-east-long", | ||
| 24 | "value": "-63.02330492" | 24 | "value": "-63.02330492" | ||
| 25 | }, | 25 | }, | ||
| 26 | { | 26 | { | ||
| 27 | "key": "bbox-north-lat", | 27 | "key": "bbox-north-lat", | ||
| 28 | "value": "18.11016654" | 28 | "value": "18.11016654" | ||
| 29 | }, | 29 | }, | ||
| 30 | { | 30 | { | ||
| 31 | "key": "bbox-south-lat", | 31 | "key": "bbox-south-lat", | ||
| 32 | "value": "18.05622138" | 32 | "value": "18.05622138" | ||
| 33 | }, | 33 | }, | ||
| 34 | { | 34 | { | ||
| 35 | "key": "bbox-west-long", | 35 | "key": "bbox-west-long", | ||
| 36 | "value": "-63.13087678" | 36 | "value": "-63.13087678" | ||
| 37 | }, | 37 | }, | ||
| 38 | { | 38 | { | ||
| 39 | "key": "data4citizen-type", | 39 | "key": "data4citizen-type", | ||
| 40 | "value": "sql" | 40 | "value": "sql" | ||
| 41 | }, | 41 | }, | ||
| 42 | { | 42 | { | ||
| 43 | "key": "data_interop", | 43 | "key": "data_interop", | ||
| 44 | "value": "0" | 44 | "value": "0" | ||
| 45 | }, | 45 | }, | ||
| 46 | { | 46 | { | ||
| 47 | "key": "data_rgpd", | 47 | "key": "data_rgpd", | ||
| 48 | "value": "false" | 48 | "value": "false" | ||
| 49 | }, | 49 | }, | ||
| 50 | { | 50 | { | ||
| 51 | "key": "dataset-model", | 51 | "key": "dataset-model", | ||
| 52 | "value": | 52 | "value": | ||
| 53 | stgres\",\"password\":\"ifr2ipTVt3uf9kK\",\"sql_query\":\"SELECT\\r\\n | 53 | stgres\",\"password\":\"ifr2ipTVt3uf9kK\",\"sql_query\":\"SELECT\\r\\n | ||
| n | 54 | annee_mutation,\\r\\n code_iris,\\r\\n nom_iris,\\r\\n | n | 54 | p.code_iris,\\r\\n p.nom_iris,\\r\\n p.type_iris,\\r\\n |
| 55 | count(*) AS nb_parcelles,\\r\\n sum(contenance) AS | 55 | COUNT(*) AS nb_parcelles,\\r\\n SUM(p.contenance) AS | ||
| 56 | surface_cadastrale_m2,\\r\\n percentile_cont(0.5) WITHIN GROUP | 56 | surface_cadastrale_m2,\\r\\n percentile_cont(0.5) WITHIN GROUP | ||
| n | 57 | (ORDER BY contenance) AS surface_mediane_parcelle_m2,\\r\\n | n | 57 | (ORDER BY p.contenance)\\r\\n AS |
| 58 | geo_point_2d,\\r\\n geo_shape\\r\\nFROM | 58 | surface_mediane_parcelle_m2,\\r\\n i.geo_point_2d,\\r\\n | ||
| 59 | v_parcelles_saint_martin_iris\\r\\nGROUP BY annee_mutation,code_iris, | 59 | i.geo_shape\\r\\nFROM v_parcelles_saint_martin_iris p\\r\\nJOIN | ||
| 60 | nom_iris, geo_point_2d, geo_shape\\r\\nORDER BY nb_parcelles DESC;\"}" | 60 | \\\"iris_saint-martin\\\" i\\r\\n ON p.code_iris = | ||
| 61 | i.code_iris\\r\\nGROUP BY\\r\\n p.code_iris,\\r\\n | ||||
| 62 | p.nom_iris,\\r\\n p.type_iris,\\r\\n i.geo_point_2d,\\r\\n | ||||
| 63 | i.geo_shape;\"}" | ||||
| 61 | }, | 64 | }, | ||
| 62 | { | 65 | { | ||
| 63 | "key": "dataset_not_visible", | 66 | "key": "dataset_not_visible", | ||
| 64 | "value": "0" | 67 | "value": "0" | ||
| 65 | }, | 68 | }, | ||
| 66 | { | 69 | { | ||
| 67 | "key": "dataset_size", | 70 | "key": "dataset_size", | ||
| 68 | "value": "0.19208240509033203" | 71 | "value": "0.19208240509033203" | ||
| 69 | }, | 72 | }, | ||
| 70 | { | 73 | { | ||
| 71 | "key": "date_dataset", | 74 | "key": "date_dataset", | ||
| 72 | "value": "2026-03-26" | 75 | "value": "2026-03-26" | ||
| 73 | }, | 76 | }, | ||
| 74 | { | 77 | { | ||
| 75 | "key": "date_deposit", | 78 | "key": "date_deposit", | ||
| 76 | "value": "2026-03-26" | 79 | "value": "2026-03-26" | ||
| 77 | }, | 80 | }, | ||
| 78 | { | 81 | { | ||
| 79 | "key": "date_modification", | 82 | "key": "date_modification", | ||
| n | 80 | "value": "2026-03-26" | n | 83 | "value": "2026-03-27" |
| 81 | }, | 84 | }, | ||
| 82 | { | 85 | { | ||
| 83 | "key": "date_moissonnage_last_modification", | 86 | "key": "date_moissonnage_last_modification", | ||
| 84 | "value": "2026-03-26T16:41:07.679223" | 87 | "value": "2026-03-26T16:41:07.679223" | ||
| 85 | }, | 88 | }, | ||
| 86 | { | 89 | { | ||
| 87 | "key": "default_visu", | 90 | "key": "default_visu", | ||
| 88 | "value": "0" | 91 | "value": "0" | ||
| 89 | }, | 92 | }, | ||
| 90 | { | 93 | { | ||
| 91 | "key": "disable_export_type", | 94 | "key": "disable_export_type", | ||
| 92 | "value": | 95 | "value": | ||
| 93 | e_formats\":false,\"data_analysis_formats\":false,\"metadata\":false}" | 96 | e_formats\":false,\"data_analysis_formats\":false,\"metadata\":false}" | ||
| 94 | }, | 97 | }, | ||
| 95 | { | 98 | { | ||
| 96 | "key": "donnees_source", | 99 | "key": "donnees_source", | ||
| 97 | "value": "" | 100 | "value": "" | ||
| 98 | }, | 101 | }, | ||
| 99 | { | 102 | { | ||
| 100 | "key": "edition_security", | 103 | "key": "edition_security", | ||
| 101 | "value": | 104 | "value": | ||
| 102 | "{\"roles\":[\"administrator\"],\"users\":[\"*99*\",\"*1*\"]}" | 105 | "{\"roles\":[\"administrator\"],\"users\":[\"*99*\",\"*1*\"]}" | ||
| 103 | }, | 106 | }, | ||
| 104 | { | 107 | { | ||
| 105 | "key": "encoding", | 108 | "key": "encoding", | ||
| 106 | "value": "UTF-8" | 109 | "value": "UTF-8" | ||
| 107 | }, | 110 | }, | ||
| 108 | { | 111 | { | ||
| 109 | "key": "features", | 112 | "key": "features", | ||
| 110 | "value": "analyze,geo,api,table,raw_data" | 113 | "value": "analyze,geo,api,table,raw_data" | ||
| 111 | }, | 114 | }, | ||
| 112 | { | 115 | { | ||
| 113 | "key": "map_color", | 116 | "key": "map_color", | ||
| 114 | "value": "" | 117 | "value": "" | ||
| 115 | }, | 118 | }, | ||
| 116 | { | 119 | { | ||
| 117 | "key": "nb_geo_features", | 120 | "key": "nb_geo_features", | ||
| 118 | "value": "0" | 121 | "value": "0" | ||
| 119 | }, | 122 | }, | ||
| 120 | { | 123 | { | ||
| 121 | "key": "nb_views", | 124 | "key": "nb_views", | ||
| 122 | "value": "00000006" | 125 | "value": "00000006" | ||
| 123 | }, | 126 | }, | ||
| 124 | { | 127 | { | ||
| 125 | "key": "not_visible_in_chart_interface", | 128 | "key": "not_visible_in_chart_interface", | ||
| 126 | "value": "0" | 129 | "value": "0" | ||
| 127 | }, | 130 | }, | ||
| 128 | { | 131 | { | ||
| 129 | "key": "not_visible_in_map_interface", | 132 | "key": "not_visible_in_map_interface", | ||
| 130 | "value": "0" | 133 | "value": "0" | ||
| 131 | }, | 134 | }, | ||
| 132 | { | 135 | { | ||
| 133 | "key": "producer", | 136 | "key": "producer", | ||
| 134 | "value": "" | 137 | "value": "" | ||
| 135 | }, | 138 | }, | ||
| 136 | { | 139 | { | ||
| 137 | "key": "records_count", | 140 | "key": "records_count", | ||
| 138 | "value": | 141 | "value": | ||
| 139 | "{\"c58d2397-b680-4113-a8d1-1dba984491e1\":\"0000000014\"}" | 142 | "{\"c58d2397-b680-4113-a8d1-1dba984491e1\":\"0000000014\"}" | ||
| 140 | }, | 143 | }, | ||
| 141 | { | 144 | { | ||
| 142 | "key": "show_cube_tab", | 145 | "key": "show_cube_tab", | ||
| 143 | "value": "0" | 146 | "value": "0" | ||
| 144 | }, | 147 | }, | ||
| 145 | { | 148 | { | ||
| 146 | "key": "spatial", | 149 | "key": "spatial", | ||
| 147 | "value": | 150 | "value": | ||
| 148 | 18.11016654],[-63.13087678,18.11016654],[-63.13087678,18.05622138]]]}" | 151 | 18.11016654],[-63.13087678,18.11016654],[-63.13087678,18.05622138]]]}" | ||
| 149 | }, | 152 | }, | ||
| 150 | { | 153 | { | ||
| 151 | "key": "themes", | 154 | "key": "themes", | ||
| 152 | "value": "[]" | 155 | "value": "[]" | ||
| 153 | }, | 156 | }, | ||
| 154 | { | 157 | { | ||
| 155 | "key": "uploader", | 158 | "key": "uploader", | ||
| 156 | "value": "user_d4c" | 159 | "value": "user_d4c" | ||
| 157 | }, | 160 | }, | ||
| 158 | { | 161 | { | ||
| 159 | "key": "weight", | 162 | "key": "weight", | ||
| 160 | "value": "0" | 163 | "value": "0" | ||
| 161 | }, | 164 | }, | ||
| 162 | { | 165 | { | ||
| 163 | "key": "wfs_link", | 166 | "key": "wfs_link", | ||
| 164 | "value": "" | 167 | "value": "" | ||
| 165 | }, | 168 | }, | ||
| 166 | { | 169 | { | ||
| 167 | "key": "wms_link", | 170 | "key": "wms_link", | ||
| 168 | "value": "" | 171 | "value": "" | ||
| 169 | } | 172 | } | ||
| 170 | ], | 173 | ], | ||
| 171 | "groups": [], | 174 | "groups": [], | ||
| 172 | "id": "2056ab03-9e53-447f-8588-b1d329b1f0e5", | 175 | "id": "2056ab03-9e53-447f-8588-b1d329b1f0e5", | ||
| 173 | "isopen": false, | 176 | "isopen": false, | ||
| 174 | "license_id": "licence-ouverte-v2-etalab", | 177 | "license_id": "licence-ouverte-v2-etalab", | ||
| 175 | "license_title": "Licence Ouverte v2.0 (Etalab)", | 178 | "license_title": "Licence Ouverte v2.0 (Etalab)", | ||
| 176 | "license_url": | 179 | "license_url": | ||
| 177 | b.gouv.fr/wp-content/uploads/2017/04/ETALAB-Licence-Ouverte-v2.0.pdf", | 180 | b.gouv.fr/wp-content/uploads/2017/04/ETALAB-Licence-Ouverte-v2.0.pdf", | ||
| 178 | "maintainer": "", | 181 | "maintainer": "", | ||
| 179 | "maintainer_email": "", | 182 | "maintainer_email": "", | ||
| 180 | "metadata_created": "2026-03-26T16:41:01.664861", | 183 | "metadata_created": "2026-03-26T16:41:01.664861", | ||
| n | 181 | "metadata_modified": "2026-03-27T09:10:37.660400", | n | 184 | "metadata_modified": "2026-03-27T09:11:14.000526", |
| 182 | "name": "testpouriris_sql", | 185 | "name": "testpouriris_sql", | ||
| 183 | "notes": "", | 186 | "notes": "", | ||
| 184 | "num_resources": 1, | 187 | "num_resources": 1, | ||
| 185 | "num_tags": 0, | 188 | "num_tags": 0, | ||
| 186 | "organization": { | 189 | "organization": { | ||
| 187 | "approval_status": "approved", | 190 | "approval_status": "approved", | ||
| 188 | "created": "2026-03-18T13:01:46.198467", | 191 | "created": "2026-03-18T13:01:46.198467", | ||
| 189 | "description": "", | 192 | "description": "", | ||
| 190 | "id": "54c7c24b-06c0-4141-adb9-895a96463c7a", | 193 | "id": "54c7c24b-06c0-4141-adb9-895a96463c7a", | ||
| 191 | "image_url": | 194 | "image_url": | ||
| 192 | en.com/sites/default/files/organization/logoopendatav2%20%281%29.png", | 195 | en.com/sites/default/files/organization/logoopendatav2%20%281%29.png", | ||
| 193 | "is_organization": true, | 196 | "is_organization": true, | ||
| 194 | "name": "agence_nationale_des_frquences", | 197 | "name": "agence_nationale_des_frquences", | ||
| 195 | "state": "active", | 198 | "state": "active", | ||
| 196 | "title": "Agence nationale des fr\u00e9quences", | 199 | "title": "Agence nationale des fr\u00e9quences", | ||
| 197 | "type": "organization" | 200 | "type": "organization" | ||
| 198 | }, | 201 | }, | ||
| 199 | "owner_org": "54c7c24b-06c0-4141-adb9-895a96463c7a", | 202 | "owner_org": "54c7c24b-06c0-4141-adb9-895a96463c7a", | ||
| 200 | "private": false, | 203 | "private": false, | ||
| 201 | "relationships_as_object": [], | 204 | "relationships_as_object": [], | ||
| 202 | "relationships_as_subject": [], | 205 | "relationships_as_subject": [], | ||
| 203 | "resources": [ | 206 | "resources": [ | ||
| 204 | { | 207 | { | ||
| 205 | "cache_last_updated": null, | 208 | "cache_last_updated": null, | ||
| 206 | "cache_url": null, | 209 | "cache_url": null, | ||
| 207 | "created": "2026-03-26T16:41:05.245281", | 210 | "created": "2026-03-26T16:41:05.245281", | ||
| 208 | "datastore_active": true, | 211 | "datastore_active": true, | ||
| 209 | "description": "", | 212 | "description": "", | ||
| 210 | "format": "CSV", | 213 | "format": "CSV", | ||
| 211 | "hash": "22867c11094f454956859f37d6c741d9", | 214 | "hash": "22867c11094f454956859f37d6c741d9", | ||
| 212 | "id": "c58d2397-b680-4113-a8d1-1dba984491e1", | 215 | "id": "c58d2397-b680-4113-a8d1-1dba984491e1", | ||
| 213 | "last_modified": null, | 216 | "last_modified": null, | ||
| 214 | "metadata_modified": "2026-03-26T16:41:07.683741", | 217 | "metadata_modified": "2026-03-26T16:41:07.683741", | ||
| 215 | "mimetype": "text/csv", | 218 | "mimetype": "text/csv", | ||
| 216 | "mimetype_inner": null, | 219 | "mimetype_inner": null, | ||
| 217 | "name": "testpouriris_sql.csv", | 220 | "name": "testpouriris_sql.csv", | ||
| 218 | "package_id": "2056ab03-9e53-447f-8588-b1d329b1f0e5", | 221 | "package_id": "2056ab03-9e53-447f-8588-b1d329b1f0e5", | ||
| 219 | "parent_id": null, | 222 | "parent_id": null, | ||
| 220 | "position": 0, | 223 | "position": 0, | ||
| 221 | "preview": true, | 224 | "preview": true, | ||
| 222 | "preview_rows": 14, | 225 | "preview_rows": 14, | ||
| 223 | "resource_type": null, | 226 | "resource_type": null, | ||
| 224 | "size": null, | 227 | "size": null, | ||
| 225 | "state": "active", | 228 | "state": "active", | ||
| 226 | "total_record_count": 14, | 229 | "total_record_count": 14, | ||
| 227 | "url": | 230 | "url": | ||
| 228 | s/dataset/205/6ab03-9e53-447f-8588-b1d329b1f0e5/testpouriris_sql.csv", | 231 | s/dataset/205/6ab03-9e53-447f-8588-b1d329b1f0e5/testpouriris_sql.csv", | ||
| 229 | "url_type": null | 232 | "url_type": null | ||
| 230 | } | 233 | } | ||
| 231 | ], | 234 | ], | ||
| 232 | "state": "active", | 235 | "state": "active", | ||
| 233 | "tags": [], | 236 | "tags": [], | ||
| t | 234 | "title": "Parcelles par IRIS 2023", | t | 237 | "title": "Indicateurs concernant les parcelles par IRIS 2023", |
| 235 | "type": "dataset", | 238 | "type": "dataset", | ||
| 236 | "url": | 239 | "url": | ||
| 237 | open.data4citizen.com/visualisation/information/?id=testpouriris_sql", | 240 | open.data4citizen.com/visualisation/information/?id=testpouriris_sql", | ||
| 238 | "version": "" | 241 | "version": "" | ||
| 239 | } | 242 | } |