You're currently viewing an old version of this dataset. To see the current version, click here.
Indicateurs DVF par IRIS et par année
Data and Resources
Additional Info
| Field | Value |
|---|---|
| Source | https://open.data4citizen.com/visualisation/information/?id=lignes_dvf_par_iris |
| Last Updated | March 27, 2026, 08:52 (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 | 00000007 |
| 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 | [] |
| uploader | user_d4c |
| weight | 0 |
| wfs_link | |
| wms_link |