Version 17 (modified by 5 years ago) ( diff ) | ,
---|
Microsoft Buildings dataset, snapshot feb19 valid/invalid in postgis
https://trac.osgeo.org/geos/attachment/ticket/987/msft-osm-CA_ex0sm.jpg
Invalid Polygons Datafile
https://trac.osgeo.org/geos/attachment/ticket/987/feb19_reason.csv
https://github.com/Microsoft/USBuildingFootprints
CA scan for invalid polygons:
select gid,st_isvalidreason(geom) from msft_ca_jul18 where not st_isvalid(geom); -- gid | st_isvalidreason ---------+------------------------------------------------------- 1932577 | Self-intersection[-117.879309006686 34.0939527158598] 1083503 | Self-intersection[-118.151041032252 34.1665520003544] 88756 | Ring Self-intersection[-119.076734 35.415403] ... .... 4354462 | Ring Self-intersection[-118.565846 34.078259] 5310650 | Self-intersection[-117.885100999011 34.1099770731587] 5244655 | Self-intersection[-116.344896 33.719872] (43 rows)
Import to postgis
https://trac.osgeo.org/geos/attachment/ticket/987/do_import_msft.sql
https://trac.osgeo.org/geos/attachment/ticket/987/feb19_invalids.csv
Screenshots of Invalid Geometry
https://trac.osgeo.org/geos/attachment/ticket/987/OGC_fail-11.png
https://trac.osgeo.org/geos/attachment/ticket/987/invalid-8039880-46.png
https://trac.osgeo.org/geos/attachment/ticket/987/ex-28.png
=# SELECT postgis_full_version(); ----------------------------------- POSTGIS="2.4.3" PGSQL="100" GEOS="3.6.2-CAPI-1.10.2 4d2925d6" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.3.3, released 2018/12/14" LIBXML="2.9.3" LIBJSON="0.11.99" LIBPROTOBUF="1.2.1" RASTER