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