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
d.annee_mutation,\\r\\n    d.code_iris,\\r\\n    d.nom_iris,\\r\\n    
54
d.annee_mutation,\\r\\n    d.code_iris,\\r\\n    d.nom_iris,\\r\\n    
            
55
d.type_iris,\\r\\n\\r\\n    COUNT(DISTINCT d.parcelle_id) AS 
55
d.type_iris,\\r\\n\\r\\n    COUNT(DISTINCT d.parcelle_id) AS 
            
56
nb_parcelles_mut\\u00e9es,\\r\\n    COUNT(*) AS 
56
nb_parcelles_mut\\u00e9es,\\r\\n    COUNT(*) AS 
            
57
nb_lignes_dvf,\\r\\n\\r\\n    COUNT(DISTINCT concat_ws('|',\\r\\n        
57
nb_lignes_dvf,\\r\\n\\r\\n    COUNT(DISTINCT concat_ws('|',\\r\\n        
            
58
d.identifiant_document,\\r\\n        d.no_disposition,\\r\\n        
58
d.identifiant_document,\\r\\n        d.no_disposition,\\r\\n        
            
59
d.date_mutation,\\r\\n        d.parcelle_section,\\r\\n        
59
d.date_mutation,\\r\\n        d.parcelle_section,\\r\\n        
            
60
d.parcelle_numero\\r\\n    )) AS nb_mutations_estimees,\\r\\n\\r\\n    
60
d.parcelle_numero\\r\\n    )) AS nb_mutations_estimees,\\r\\n\\r\\n    
            
61
SUM(d.valeur_fonciere) AS valeur_fonciere_totale,\\r\\n\\r\\n    
61
SUM(d.valeur_fonciere) AS valeur_fonciere_totale,\\r\\n\\r\\n    
            
62
percentile_cont(0.5) WITHIN GROUP (ORDER BY d.valeur_fonciere)\\r\\n        
62
percentile_cont(0.5) WITHIN GROUP (ORDER BY d.valeur_fonciere)\\r\\n        
            
63
AS valeur_fonciere_mediane,\\r\\n\\r\\n    SUM(d.surface_terrain) AS 
63
AS valeur_fonciere_mediane,\\r\\n\\r\\n    SUM(d.surface_terrain) AS 
            
64
surface_terrain_mutee,\\r\\n\\r\\n    percentile_cont(0.5) WITHIN 
64
surface_terrain_mutee,\\r\\n\\r\\n    percentile_cont(0.5) WITHIN 
            
65
GROUP (\\r\\n        ORDER BY d.valeur_fonciere \\/ 
65
GROUP (\\r\\n        ORDER BY d.valeur_fonciere \\/ 
            
66
NULLIF(d.surface_terrain, 0)\\r\\n    ) FILTER (\\r\\n        WHERE 
66
NULLIF(d.surface_terrain, 0)\\r\\n    ) FILTER (\\r\\n        WHERE 
            
67
d.surface_terrain > 0\\r\\n          AND d.valeur_fonciere IS NOT 
67
d.surface_terrain > 0\\r\\n          AND d.valeur_fonciere IS NOT 
            
68
NULL\\r\\n    ) AS prix_m2_terrain_median,\\r\\n\\r\\n    
68
NULL\\r\\n    ) AS prix_m2_terrain_median,\\r\\n\\r\\n    
            
69
i.geo_point_2d,\\r\\n    i.geo_shape\\r\\nFROM v_dvf_saint_martin_iris 
69
i.geo_point_2d,\\r\\n    i.geo_shape\\r\\nFROM v_dvf_saint_martin_iris 
            
70
d\\r\\nJOIN \\\"iris_saint-martin\\\" i\\r\\n  ON d.code_iris = 
70
d\\r\\nJOIN \\\"iris_saint-martin\\\" i\\r\\n  ON d.code_iris = 
            
71
i.code_iris\\r\\nWHERE d.valeur_fonciere IS NOT NULL\\r\\nGROUP 
71
i.code_iris\\r\\nWHERE d.valeur_fonciere IS NOT NULL\\r\\nGROUP 
            
72
BY\\r\\n    d.annee_mutation,\\r\\n    d.code_iris,\\r\\n    
72
BY\\r\\n    d.annee_mutation,\\r\\n    d.code_iris,\\r\\n    
            
73
d.nom_iris,\\r\\n    d.type_iris,\\r\\n    i.geo_point_2d,\\r\\n    
73
d.nom_iris,\\r\\n    d.type_iris,\\r\\n    i.geo_point_2d,\\r\\n    
            
74
i.geo_shape;\"}"
74
i.geo_shape;\"}"
            
75
    },
75
    },
            
76
    {
76
    {
            
77
      "key": "dataset_not_visible",
77
      "key": "dataset_not_visible",
            
78
      "value": "0"
78
      "value": "0"
            
79
    },
79
    },
            
80
    {
80
    {
            
81
      "key": "dataset_size",
81
      "key": "dataset_size",
            
n
82
      "value": "1.131016731262207"
n
82
      "value": "1.1332206726074219"
            
83
    },
83
    },
            
84
    {
84
    {
            
85
      "key": "date_dataset",
85
      "key": "date_dataset",
            
86
      "value": "2026-03-26"
86
      "value": "2026-03-26"
            
87
    },
87
    },
            
88
    {
88
    {
            
89
      "key": "date_deposit",
89
      "key": "date_deposit",
            
90
      "value": "2026-03-26"
90
      "value": "2026-03-26"
            
91
    },
91
    },
            
92
    {
92
    {
            
93
      "key": "date_modification",
93
      "key": "date_modification",
            
94
      "value": "2026-03-27"
94
      "value": "2026-03-27"
            
95
    },
95
    },
            
96
    {
96
    {
            
97
      "key": "date_moissonnage_last_modification",
97
      "key": "date_moissonnage_last_modification",
            
98
      "value": "2026-03-26T16:47:14.504399"
98
      "value": "2026-03-26T16:47:14.504399"
            
99
    },
99
    },
            
100
    {
100
    {
            
101
      "key": "default_visu",
101
      "key": "default_visu",
            
102
      "value": "0"
102
      "value": "0"
            
103
    },
103
    },
            
104
    {
104
    {
            
105
      "key": "disable_export_type",
105
      "key": "disable_export_type",
            
106
      "value": 
106
      "value": 
            
107
e_formats\":false,\"data_analysis_formats\":false,\"metadata\":false}"
107
e_formats\":false,\"data_analysis_formats\":false,\"metadata\":false}"
            
108
    },
108
    },
            
109
    {
109
    {
            
110
      "key": "donnees_source",
110
      "key": "donnees_source",
            
111
      "value": ""
111
      "value": ""
            
112
    },
112
    },
            
113
    {
113
    {
            
114
      "key": "edition_security",
114
      "key": "edition_security",
            
115
      "value": 
115
      "value": 
            
116
"{\"roles\":[\"administrator\"],\"users\":[\"*99*\",\"*1*\"]}"
116
"{\"roles\":[\"administrator\"],\"users\":[\"*99*\",\"*1*\"]}"
            
117
    },
117
    },
            
118
    {
118
    {
            
119
      "key": "encoding",
119
      "key": "encoding",
            
120
      "value": "UTF-8"
120
      "value": "UTF-8"
            
121
    },
121
    },
            
122
    {
122
    {
            
123
      "key": "features",
123
      "key": "features",
            
124
      "value": "analyze,geo,api,table,map_data"
124
      "value": "analyze,geo,api,table,map_data"
            
125
    },
125
    },
            
126
    {
126
    {
            
127
      "key": "map_color",
127
      "key": "map_color",
            
128
      "value": ""
128
      "value": ""
            
129
    },
129
    },
            
130
    {
130
    {
            
131
      "key": "nb_geo_features",
131
      "key": "nb_geo_features",
            
132
      "value": "0"
132
      "value": "0"
            
133
    },
133
    },
            
134
    {
134
    {
            
135
      "key": "nb_views",
135
      "key": "nb_views",
            
136
      "value": "00000004"
136
      "value": "00000004"
            
137
    },
137
    },
            
138
    {
138
    {
            
139
      "key": "not_visible_in_chart_interface",
139
      "key": "not_visible_in_chart_interface",
            
140
      "value": "0"
140
      "value": "0"
            
141
    },
141
    },
            
142
    {
142
    {
            
143
      "key": "not_visible_in_map_interface",
143
      "key": "not_visible_in_map_interface",
            
144
      "value": "0"
144
      "value": "0"
            
145
    },
145
    },
            
146
    {
146
    {
            
147
      "key": "producer",
147
      "key": "producer",
            
148
      "value": ""
148
      "value": ""
            
149
    },
149
    },
            
150
    {
150
    {
            
151
      "key": "records_count",
151
      "key": "records_count",
            
152
      "value": 
152
      "value": 
            
153
"{\"1edafa76-f2cc-4b4e-bc77-39b2b04e8faf\":\"0000000081\"}"
153
"{\"1edafa76-f2cc-4b4e-bc77-39b2b04e8faf\":\"0000000081\"}"
            
154
    },
154
    },
            
155
    {
155
    {
            
156
      "key": "show_cube_tab",
156
      "key": "show_cube_tab",
            
157
      "value": "0"
157
      "value": "0"
            
158
    },
158
    },
            
159
    {
159
    {
            
160
      "key": "spatial",
160
      "key": "spatial",
            
161
      "value": 
161
      "value": 
            
162
18.11016654],[-63.13087678,18.11016654],[-63.13087678,18.05622138]]]}"
162
18.11016654],[-63.13087678,18.11016654],[-63.13087678,18.05622138]]]}"
            
163
    },
163
    },
            
164
    {
164
    {
            
165
      "key": "themes",
165
      "key": "themes",
            
166
      "value": "[]"
166
      "value": "[]"
            
167
    },
167
    },
            
168
    {
168
    {
            
169
      "key": "uploader",
169
      "key": "uploader",
            
170
      "value": "user_d4c"
170
      "value": "user_d4c"
            
171
    },
171
    },
            
172
    {
172
    {
            
173
      "key": "weight",
173
      "key": "weight",
            
174
      "value": "0"
174
      "value": "0"
            
175
    },
175
    },
            
176
    {
176
    {
            
177
      "key": "wfs_link",
177
      "key": "wfs_link",
            
178
      "value": ""
178
      "value": ""
            
179
    },
179
    },
            
180
    {
180
    {
            
181
      "key": "wms_link",
181
      "key": "wms_link",
            
182
      "value": ""
182
      "value": ""
            
183
    }
183
    }
            
184
  ],
184
  ],
            
185
  "groups": [],
185
  "groups": [],
            
186
  "id": "c6dd0f9d-6ee3-4ff1-b93a-ea16e4a520cd",
186
  "id": "c6dd0f9d-6ee3-4ff1-b93a-ea16e4a520cd",
            
187
  "isopen": false,
187
  "isopen": false,
            
188
  "license_id": "licence-ouverte-v2-etalab",
188
  "license_id": "licence-ouverte-v2-etalab",
            
189
  "license_title": "Licence Ouverte v2.0 (Etalab)",
189
  "license_title": "Licence Ouverte v2.0 (Etalab)",
            
190
  "license_url": 
190
  "license_url": 
            
191
b.gouv.fr/wp-content/uploads/2017/04/ETALAB-Licence-Ouverte-v2.0.pdf",
191
b.gouv.fr/wp-content/uploads/2017/04/ETALAB-Licence-Ouverte-v2.0.pdf",
            
192
  "maintainer": "",
192
  "maintainer": "",
            
193
  "maintainer_email": "",
193
  "maintainer_email": "",
            
194
  "metadata_created": "2026-03-26T16:47:01.077265",
194
  "metadata_created": "2026-03-26T16:47:01.077265",
            
t
195
  "metadata_modified": "2026-03-27T08:35:12.381295",
t
195
  "metadata_modified": "2026-03-27T08:35:22.563847",
            
196
  "name": "lignes_dvf_par_iris",
196
  "name": "lignes_dvf_par_iris",
            
197
  "notes": "",
197
  "notes": "",
            
198
  "num_resources": 1,
198
  "num_resources": 1,
            
199
  "num_tags": 0,
199
  "num_tags": 0,
            
200
  "organization": {
200
  "organization": {
            
201
    "approval_status": "approved",
201
    "approval_status": "approved",
            
202
    "created": "2026-03-23T15:21:28.094156",
202
    "created": "2026-03-23T15:21:28.094156",
            
203
    "description": "",
203
    "description": "",
            
204
    "id": "d9eb451b-eb5b-4465-8ecf-5bc81a2fadca",
204
    "id": "d9eb451b-eb5b-4465-8ecf-5bc81a2fadca",
            
205
    "image_url": 
205
    "image_url": 
            
206
n.data4citizen.com/sites/default/files/organization/saint-martin.svg",
206
n.data4citizen.com/sites/default/files/organization/saint-martin.svg",
            
207
    "is_organization": true,
207
    "is_organization": true,
            
208
    "name": "saint-martin",
208
    "name": "saint-martin",
            
209
    "state": "active",
209
    "state": "active",
            
210
    "title": "Saint-Martin",
210
    "title": "Saint-Martin",
            
211
    "type": "organization"
211
    "type": "organization"
            
212
  },
212
  },
            
213
  "owner_org": "d9eb451b-eb5b-4465-8ecf-5bc81a2fadca",
213
  "owner_org": "d9eb451b-eb5b-4465-8ecf-5bc81a2fadca",
            
214
  "private": false,
214
  "private": false,
            
215
  "relationships_as_object": [],
215
  "relationships_as_object": [],
            
216
  "relationships_as_subject": [],
216
  "relationships_as_subject": [],
            
217
  "resources": [
217
  "resources": [
            
218
    {
218
    {
            
219
      "cache_last_updated": null,
219
      "cache_last_updated": null,
            
220
      "cache_url": null,
220
      "cache_url": null,
            
221
      "created": "2026-03-26T16:47:12.041722",
221
      "created": "2026-03-26T16:47:12.041722",
            
222
      "datastore_active": true,
222
      "datastore_active": true,
            
223
      "description": "",
223
      "description": "",
            
224
      "format": "CSV",
224
      "format": "CSV",
            
225
      "hash": "e3e2d294f781b565bc6cfd113ebc26aa",
225
      "hash": "e3e2d294f781b565bc6cfd113ebc26aa",
            
226
      "id": "1edafa76-f2cc-4b4e-bc77-39b2b04e8faf",
226
      "id": "1edafa76-f2cc-4b4e-bc77-39b2b04e8faf",
            
227
      "last_modified": "2026-03-26T16:55:35",
227
      "last_modified": "2026-03-26T16:55:35",
            
228
      "metadata_modified": "2026-03-26T16:55:37.835651",
228
      "metadata_modified": "2026-03-26T16:55:37.835651",
            
229
      "mimetype": "text/csv",
229
      "mimetype": "text/csv",
            
230
      "mimetype_inner": null,
230
      "mimetype_inner": null,
            
231
      "name": "lignes_dvf_par_iris.csv",
231
      "name": "lignes_dvf_par_iris.csv",
            
232
      "package_id": "c6dd0f9d-6ee3-4ff1-b93a-ea16e4a520cd",
232
      "package_id": "c6dd0f9d-6ee3-4ff1-b93a-ea16e4a520cd",
            
233
      "parent_id": null,
233
      "parent_id": null,
            
234
      "position": 0,
234
      "position": 0,
            
235
      "preview": true,
235
      "preview": true,
            
236
      "preview_rows": 81,
236
      "preview_rows": 81,
            
237
      "resource_type": null,
237
      "resource_type": null,
            
238
      "size": null,
238
      "size": null,
            
239
      "state": "active",
239
      "state": "active",
            
240
      "total_record_count": 81,
240
      "total_record_count": 81,
            
241
      "url": 
241
      "url": 
            
242
ataset/c6d/d0f9d-6ee3-4ff1-b93a-ea16e4a520cd/lignes_dvf_par_iris.csv",
242
ataset/c6d/d0f9d-6ee3-4ff1-b93a-ea16e4a520cd/lignes_dvf_par_iris.csv",
            
243
      "url_type": "",
243
      "url_type": "",
            
244
      "uuid": "69c5650738413"
244
      "uuid": "69c5650738413"
            
245
    }
245
    }
            
246
  ],
246
  ],
            
247
  "state": "active",
247
  "state": "active",
            
248
  "tags": [],
248
  "tags": [],
            
249
  "title": "Lignes DVF par IRIS",
249
  "title": "Lignes DVF par IRIS",
            
250
  "type": "dataset",
250
  "type": "dataset",
            
251
  "url": 
251
  "url": 
            
252
n.data4citizen.com/visualisation/information/?id=lignes_dvf_par_iris",
252
n.data4citizen.com/visualisation/information/?id=lignes_dvf_par_iris",
            
253
  "version": ""
253
  "version": ""
            
254
}
254
}