Skip to content

Instantly share code, notes, and snippets.

@pigreco

pigreco/comuni_point_invalid_istat2024.csv

Created April 5, 2024 14:36
Show Gist options
  • Save pigreco/3ff947d2eaf5435f6a4e094404c1b396 to your computer and use it in GitHub Desktop.
Save pigreco/3ff947d2eaf5435f6a4e094404c1b396 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
comuni_point_invalid_istat2024.csv
PRO_COM COMUNE GEOS_GetLastWarningMsg() coord_punto
72001 Acquaviva delle Fonti Ring Self-intersection at or near point 1158442.6376999998 4556057.8583000004 POINT(1158442.6377 4556057.8583)
87009 Bronte Ring Self-intersection at or near point 1028304.0548 4195170.1164999995 POINT(1028304.0548 4195170.1165)
24018 Caldogno Self-intersection at or near point 695843.26275384938 5054095.577508538 POINT(695843.262754 5054095.577509)
90035 La Maddalena Ring Self-intersection at or near point 528108.51559999958 4571486.8072999995 POINT(528108.5156 4571486.8073)
29041 Rovigo Self-intersection at or near point 715837.53051888163 4995712.1190747796 POINT(715837.530519 4995712.119075)
72037 Rutigliano Ring Self-intersection at or near point 1177064.5067999996 4571209.1926000006 POINT(1177064.5068 4571209.1926)
72040 Sannicandro di Bari Ring Self-intersection at or near point 1154968.4281000001 4561653.8167000003 POINT(1154968.4281 4561653.8167)
81019 Santa Ninfa Ring Self-intersection at or near point 841730.11459999997 4190972.9642999992 POINT(841730.1146 4190972.9643)
@pigreco
Copy link
Author

pigreco commented Apr 5, 2024 •
edited
Loading

SpatiaLite_gui

DATABASE:
https://drive.google.com/file/d/12RBpij--2CuJuhCB5zGCjT3iyabel-tc/view?usp=sharing

SELECT
  pro_com,
  comune,
  GEOS_GetLastWarningMsg(),
  ST_AsText(GEOS_GetCriticalPointFromMsg()) AS coord_punto
FROM
  Com01012024_WGS84
WHERE
  ST_IsValid(geometry) <> 1
ORDER BY
  2;

QGIS

image

@pigreco
Copy link
Author

pigreco commented Apr 5, 2024

Verifica con strumenti ESRI:
https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/check-geometry.htm
image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment