Changes

              
    

          
          
        
        

            
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    
            
54
p.code_iris,\\r\\n    p.nom_iris,\\r\\n    p.type_iris,\\r\\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(p.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 
            
57
(ORDER BY p.contenance)\\r\\n        AS 
57
(ORDER BY p.contenance)\\r\\n        AS 
            
58
surface_mediane_parcelle_m2,\\r\\n    i.geo_point_2d,\\r\\n    
58
surface_mediane_parcelle_m2,\\r\\n    i.geo_point_2d,\\r\\n    
            
59
i.geo_shape\\r\\nFROM v_parcelles_saint_martin_iris p\\r\\nJOIN 
59
i.geo_shape\\r\\nFROM v_parcelles_saint_martin_iris p\\r\\nJOIN 
            
60
\\\"iris_saint-martin\\\" i\\r\\n  ON p.code_iris = 
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    
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    
62
p.nom_iris,\\r\\n    p.type_iris,\\r\\n    i.geo_point_2d,\\r\\n    
            
63
i.geo_shape;\"}"
63
i.geo_shape;\"}"
            
64
    },
64
    },
            
65
    {
65
    {
            
66
      "key": "dataset_not_visible",
66
      "key": "dataset_not_visible",
            
67
      "value": "0"
67
      "value": "0"
            
68
    },
68
    },
            
69
    {
69
    {
            
70
      "key": "dataset_size",
70
      "key": "dataset_size",
            
71
      "value": "0.19211864471435547"
71
      "value": "0.19211864471435547"
            
72
    },
72
    },
            
73
    {
73
    {
            
74
      "key": "date_dataset",
74
      "key": "date_dataset",
            
75
      "value": "2026-03-26"
75
      "value": "2026-03-26"
            
76
    },
76
    },
            
77
    {
77
    {
            
78
      "key": "date_deposit",
78
      "key": "date_deposit",
            
79
      "value": "2026-03-26"
79
      "value": "2026-03-26"
            
80
    },
80
    },
            
81
    {
81
    {
            
82
      "key": "date_modification",
82
      "key": "date_modification",
            
83
      "value": "2026-03-27"
83
      "value": "2026-03-27"
            
84
    },
84
    },
            
85
    {
85
    {
            
86
      "key": "date_moissonnage_last_modification",
86
      "key": "date_moissonnage_last_modification",
            
87
      "value": "2026-03-26T16:41:07.679223"
87
      "value": "2026-03-26T16:41:07.679223"
            
88
    },
88
    },
            
89
    {
89
    {
            
90
      "key": "default_visu",
90
      "key": "default_visu",
            
91
      "value": "0"
91
      "value": "0"
            
92
    },
92
    },
            
93
    {
93
    {
            
94
      "key": "disable_export_type",
94
      "key": "disable_export_type",
            
95
      "value": 
95
      "value": 
            
96
e_formats\":false,\"data_analysis_formats\":false,\"metadata\":false}"
96
e_formats\":false,\"data_analysis_formats\":false,\"metadata\":false}"
            
97
    },
97
    },
            
98
    {
98
    {
            
99
      "key": "donnees_source",
99
      "key": "donnees_source",
            
100
      "value": ""
100
      "value": ""
            
101
    },
101
    },
            
102
    {
102
    {
            
103
      "key": "edition_security",
103
      "key": "edition_security",
            
104
      "value": 
104
      "value": 
            
105
"{\"roles\":[\"administrator\"],\"users\":[\"*99*\",\"*1*\"]}"
105
"{\"roles\":[\"administrator\"],\"users\":[\"*99*\",\"*1*\"]}"
            
106
    },
106
    },
            
107
    {
107
    {
            
108
      "key": "encoding",
108
      "key": "encoding",
            
109
      "value": "UTF-8"
109
      "value": "UTF-8"
            
110
    },
110
    },
            
111
    {
111
    {
            
112
      "key": "features",
112
      "key": "features",
            
113
      "value": "analyze,geo,api,table,map_data"
113
      "value": "analyze,geo,api,table,map_data"
            
114
    },
114
    },
            
115
    {
115
    {
            
116
      "key": "map_color",
116
      "key": "map_color",
            
117
      "value": ""
117
      "value": ""
            
118
    },
118
    },
            
119
    {
119
    {
            
120
      "key": "nb_geo_features",
120
      "key": "nb_geo_features",
            
121
      "value": "0"
121
      "value": "0"
            
122
    },
122
    },
            
123
    {
123
    {
            
124
      "key": "nb_views",
124
      "key": "nb_views",
            
n
125
      "value": "00000008"
n
125
      "value": "00000009"
            
126
    },
126
    },
            
127
    {
127
    {
            
128
      "key": "not_visible_in_chart_interface",
128
      "key": "not_visible_in_chart_interface",
            
129
      "value": "0"
129
      "value": "0"
            
130
    },
130
    },
            
131
    {
131
    {
            
132
      "key": "not_visible_in_map_interface",
132
      "key": "not_visible_in_map_interface",
            
133
      "value": "0"
133
      "value": "0"
            
134
    },
134
    },
            
135
    {
135
    {
            
136
      "key": "producer",
136
      "key": "producer",
            
137
      "value": ""
137
      "value": ""
            
138
    },
138
    },
            
139
    {
139
    {
            
140
      "key": "records_count",
140
      "key": "records_count",
            
141
      "value": 
141
      "value": 
            
142
"{\"c58d2397-b680-4113-a8d1-1dba984491e1\":\"0000000014\"}"
142
"{\"c58d2397-b680-4113-a8d1-1dba984491e1\":\"0000000014\"}"
            
143
    },
143
    },
            
144
    {
144
    {
            
145
      "key": "show_cube_tab",
145
      "key": "show_cube_tab",
            
146
      "value": "0"
146
      "value": "0"
            
147
    },
147
    },
            
148
    {
148
    {
            
149
      "key": "spatial",
149
      "key": "spatial",
            
150
      "value": 
150
      "value": 
            
151
18.11016654],[-63.13087678,18.11016654],[-63.13087678,18.05622138]]]}"
151
18.11016654],[-63.13087678,18.11016654],[-63.13087678,18.05622138]]]}"
            
152
    },
152
    },
            
153
    {
153
    {
            
154
      "key": "themes",
154
      "key": "themes",
            
155
      "value": "[]"
155
      "value": "[]"
            
156
    },
156
    },
            
157
    {
157
    {
            
158
      "key": "uploader",
158
      "key": "uploader",
            
159
      "value": "user_d4c"
159
      "value": "user_d4c"
            
160
    },
160
    },
            
161
    {
161
    {
            
162
      "key": "weight",
162
      "key": "weight",
            
163
      "value": "0"
163
      "value": "0"
            
164
    },
164
    },
            
165
    {
165
    {
            
166
      "key": "wfs_link",
166
      "key": "wfs_link",
            
167
      "value": ""
167
      "value": ""
            
168
    },
168
    },
            
169
    {
169
    {
            
170
      "key": "wms_link",
170
      "key": "wms_link",
            
171
      "value": ""
171
      "value": ""
            
172
    }
172
    }
            
173
  ],
173
  ],
            
174
  "groups": [],
174
  "groups": [],
            
175
  "id": "2056ab03-9e53-447f-8588-b1d329b1f0e5",
175
  "id": "2056ab03-9e53-447f-8588-b1d329b1f0e5",
            
176
  "isopen": false,
176
  "isopen": false,
            
177
  "license_id": "licence-ouverte-v2-etalab",
177
  "license_id": "licence-ouverte-v2-etalab",
            
178
  "license_title": "Licence Ouverte v2.0 (Etalab)",
178
  "license_title": "Licence Ouverte v2.0 (Etalab)",
            
179
  "license_url": 
179
  "license_url": 
            
180
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",
            
181
  "maintainer": "",
181
  "maintainer": "",
            
182
  "maintainer_email": "",
182
  "maintainer_email": "",
            
183
  "metadata_created": "2026-03-26T16:41:01.664861",
183
  "metadata_created": "2026-03-26T16:41:01.664861",
            
t
184
  "metadata_modified": "2026-03-27T09:15:34.942805",
t
184
  "metadata_modified": "2026-03-27T09:15:41.082404",
            
185
  "name": "testpouriris_sql",
185
  "name": "testpouriris_sql",
            
186
  "notes": "",
186
  "notes": "",
            
187
  "num_resources": 1,
187
  "num_resources": 1,
            
188
  "num_tags": 0,
188
  "num_tags": 0,
            
189
  "organization": {
189
  "organization": {
            
190
    "approval_status": "approved",
190
    "approval_status": "approved",
            
191
    "created": "2026-03-18T13:01:46.198467",
191
    "created": "2026-03-18T13:01:46.198467",
            
192
    "description": "",
192
    "description": "",
            
193
    "id": "54c7c24b-06c0-4141-adb9-895a96463c7a",
193
    "id": "54c7c24b-06c0-4141-adb9-895a96463c7a",
            
194
    "image_url": 
194
    "image_url": 
            
195
en.com/sites/default/files/organization/logoopendatav2%20%281%29.png",
195
en.com/sites/default/files/organization/logoopendatav2%20%281%29.png",
            
196
    "is_organization": true,
196
    "is_organization": true,
            
197
    "name": "agence_nationale_des_frquences",
197
    "name": "agence_nationale_des_frquences",
            
198
    "state": "active",
198
    "state": "active",
            
199
    "title": "Agence nationale des fr\u00e9quences",
199
    "title": "Agence nationale des fr\u00e9quences",
            
200
    "type": "organization"
200
    "type": "organization"
            
201
  },
201
  },
            
202
  "owner_org": "54c7c24b-06c0-4141-adb9-895a96463c7a",
202
  "owner_org": "54c7c24b-06c0-4141-adb9-895a96463c7a",
            
203
  "private": false,
203
  "private": false,
            
204
  "relationships_as_object": [],
204
  "relationships_as_object": [],
            
205
  "relationships_as_subject": [],
205
  "relationships_as_subject": [],
            
206
  "resources": [
206
  "resources": [
            
207
    {
207
    {
            
208
      "cache_last_updated": null,
208
      "cache_last_updated": null,
            
209
      "cache_url": null,
209
      "cache_url": null,
            
210
      "created": "2026-03-26T16:41:05.245281",
210
      "created": "2026-03-26T16:41:05.245281",
            
211
      "datastore_active": true,
211
      "datastore_active": true,
            
212
      "description": "",
212
      "description": "",
            
213
      "format": "CSV",
213
      "format": "CSV",
            
214
      "hash": "be5b137d42efd17e6ba454b811d91da4",
214
      "hash": "be5b137d42efd17e6ba454b811d91da4",
            
215
      "id": "c58d2397-b680-4113-a8d1-1dba984491e1",
215
      "id": "c58d2397-b680-4113-a8d1-1dba984491e1",
            
216
      "last_modified": "2026-03-27T09:11:17",
216
      "last_modified": "2026-03-27T09:11:17",
            
217
      "metadata_modified": "2026-03-27T09:11:20.473909",
217
      "metadata_modified": "2026-03-27T09:11:20.473909",
            
218
      "mimetype": "text/csv",
218
      "mimetype": "text/csv",
            
219
      "mimetype_inner": null,
219
      "mimetype_inner": null,
            
220
      "name": 
220
      "name": 
            
221
"indicateurs_concernant_les_parcelles_par_iris_2023.csv",
221
"indicateurs_concernant_les_parcelles_par_iris_2023.csv",
            
222
      "package_id": "2056ab03-9e53-447f-8588-b1d329b1f0e5",
222
      "package_id": "2056ab03-9e53-447f-8588-b1d329b1f0e5",
            
223
      "parent_id": null,
223
      "parent_id": null,
            
224
      "position": 0,
224
      "position": 0,
            
225
      "preview": true,
225
      "preview": true,
            
226
      "preview_rows": 14,
226
      "preview_rows": 14,
            
227
      "resource_type": null,
227
      "resource_type": null,
            
228
      "size": null,
228
      "size": null,
            
229
      "state": "active",
229
      "state": "active",
            
230
      "total_record_count": 14,
230
      "total_record_count": 14,
            
231
      "url": 
231
      "url": 
            
232
-b1d329b1f0e5/indicateurs_concernant_les_parcelles_par_iris_2023.csv",
232
-b1d329b1f0e5/indicateurs_concernant_les_parcelles_par_iris_2023.csv",
            
233
      "url_type": "",
233
      "url_type": "",
            
234
      "uuid": "69c649b5e40b1"
234
      "uuid": "69c649b5e40b1"
            
235
    }
235
    }
            
236
  ],
236
  ],
            
237
  "state": "active",
237
  "state": "active",
            
238
  "tags": [],
238
  "tags": [],
            
239
  "title": "Indicateurs concernant les parcelles par IRIS 2023",
239
  "title": "Indicateurs concernant les parcelles par IRIS 2023",
            
240
  "type": "dataset",
240
  "type": "dataset",
            
241
  "url": 
241
  "url": 
            
242
open.data4citizen.com/visualisation/information/?id=testpouriris_sql",
242
open.data4citizen.com/visualisation/information/?id=testpouriris_sql",
            
243
  "version": ""
243
  "version": ""
            
244
}
244
}