| Source |
https://open.data4citizen.com/visualisation/information/?id=lignes_dvf_par_iris |
| Last Updated |
March 31, 2026, 14:08 (UTC)
|
| Created |
March 26, 2026, 16:47 (UTC)
|
| FTP_API |
FTP |
| LinkedDataSet |
[""] |
| Picto |
|
| allow_data_inputs |
0 |
| bbox-east-long |
-63.02330492 |
| bbox-north-lat |
18.11016654 |
| bbox-south-lat |
18.05622138 |
| bbox-west-long |
-63.13087678 |
| data4citizen-type |
sql |
| data_interop |
0 |
| data_rgpd |
false |
| dataset-model |
{"db_type":"pgsql","db_name":"open","host":"data4citizen-db","port":"5432","login":"postgres","password":"ifr2ipTVt3uf9kK","sql_query":"SELECT\r\n d.annee_mutation,\r\n d.code_iris,\r\n d.nom_iris,\r\n d.type_iris,\r\n\r\n COUNT(DISTINCT d.parcelle_id) AS nb_parcelles_mut\u00e9es,\r\n COUNT(*) AS nb_lignes_dvf,\r\n\r\n COUNT(DISTINCT concat_ws('|',\r\n d.identifiant_document,\r\n d.no_disposition,\r\n d.date_mutation,\r\n d.parcelle_section,\r\n d.parcelle_numero\r\n )) AS nb_mutations_estimees,\r\n\r\n SUM(d.valeur_fonciere) AS valeur_fonciere_totale,\r\n\r\n percentile_cont(0.5) WITHIN GROUP (ORDER BY d.valeur_fonciere)\r\n AS valeur_fonciere_mediane,\r\n\r\n SUM(d.surface_terrain) AS surface_terrain_mutee,\r\n\r\n percentile_cont(0.5) WITHIN GROUP (\r\n ORDER BY d.valeur_fonciere \/ NULLIF(d.surface_terrain, 0)\r\n ) FILTER (\r\n WHERE d.surface_terrain > 0\r\n AND d.valeur_fonciere IS NOT NULL\r\n ) AS prix_m2_terrain_median,\r\n\r\n i.geo_point_2d,\r\n i.geo_shape\r\nFROM v_dvf_saint_martin_iris d\r\nJOIN \"iris_saint-martin\" i\r\n ON d.code_iris = i.code_iris\r\nWHERE d.valeur_fonciere IS NOT NULL\r\nGROUP BY\r\n d.annee_mutation,\r\n d.code_iris,\r\n d.nom_iris,\r\n d.type_iris,\r\n i.geo_point_2d,\r\n i.geo_shape;"} |
| dataset_not_visible |
0 |
| dataset_size |
1.1332206726074219 |
| date_dataset |
2026-03-26 |
| date_deposit |
2026-03-26 |
| date_modification |
2026-03-27 |
| date_moissonnage_last_modification |
2026-03-26T16:47:14.504399 |
| default_visu |
0 |
| disable_export_type |
{"flat_formats":false,"geographic_formats":false,"alternative_formats":false,"data_analysis_formats":false,"metadata":false} |
| donnees_source |
|
| edition_security |
{"roles":["administrator"],"users":["*99*","*1*"]} |
| encoding |
UTF-8 |
| features |
analyze,geo,api,table,map_data |
| map_color |
|
| nb_geo_features |
0 |
| nb_views |
00000011 |
| not_visible_in_chart_interface |
0 |
| not_visible_in_map_interface |
0 |
| producer |
|
| records_count |
{"1edafa76-f2cc-4b4e-bc77-39b2b04e8faf":"0000000081"} |
| show_cube_tab |
0 |
| spatial |
{"type":"Polygon","coordinates":[[[-63.13087678,18.05622138],[-63.02330492,18.05622138],[-63.02330492,18.11016654],[-63.13087678,18.11016654],[-63.13087678,18.05622138]]]} |
| themes |
[] |
| tooltip |
{"resources":[{"type":"standard","resource_id":"1edafa76-f2cc-4b4e-bc77-39b2b04e8faf","value":{"title":"nom_iris","fields":"annee_mutation,nb_parcelles_mutees,nb_lignes_dvf,nb_mutations_estimees,valeur_fonciere_totale,valeur_fonciere_mediane,surface_terrain_mutee,prix_m2_terrain_median"}}]} |
| uploader |
user_d4c |
| weight |
0 |
| wfs_link |
|
| wms_link |
|
