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)

​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