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