| Source |
https://open.data4citizen.com/visualisation/information/?id=testpouriris_sql |
| Last Updated |
March 31, 2026, 15:18 (UTC)
|
| Created |
March 26, 2026, 16:41 (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 p.code_iris,\r\n p.nom_iris,\r\n p.type_iris,\r\n COUNT(*) AS nb_parcelles,\r\n SUM(p.contenance) AS surface_cadastrale_m2,\r\n percentile_cont(0.5) WITHIN GROUP (ORDER BY p.contenance)\r\n AS surface_mediane_parcelle_m2,\r\n i.geo_point_2d,\r\n i.geo_shape\r\nFROM v_parcelles_saint_martin_iris p\r\nJOIN \"iris_saint-martin\" i\r\n ON p.code_iris = i.code_iris\r\nGROUP BY\r\n p.code_iris,\r\n p.nom_iris,\r\n p.type_iris,\r\n i.geo_point_2d,\r\n i.geo_shape;"} |
| dataset_not_visible |
0 |
| dataset_size |
0.19211864471435547 |
| date_dataset |
2026-03-26 |
| date_deposit |
2026-03-26 |
| date_modification |
2026-03-27 |
| date_moissonnage_last_modification |
2026-03-26T16:41:07.679223 |
| 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 |
00000025 |
| not_visible_in_chart_interface |
0 |
| not_visible_in_map_interface |
0 |
| producer |
|
| records_count |
{"c58d2397-b680-4113-a8d1-1dba984491e1":"0000000014"} |
| 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":"c58d2397-b680-4113-a8d1-1dba984491e1","value":{"title":"nom_iris","fields":"nb_parcelles,surface_cadastrale_m2,surface_mediane_parcelle_m2"}}]} |
| uploader |
user_d4c |
| weight |
0 |
| wfs_link |
|
| wms_link |
|
