Changes between Version 49 and Version 50 of BldgsGeomMisc

Timestamp:

Sep 22, 2019, 4:13:40 PM (5 years ago)

Author:

darkblueb

Comment:

--

BldgsGeomMisc

@@ -363 +363 @@
 (35 rows)
 
- POSTGIS="2.4.3" PGSQL="100" GEOS="3.6.2-CAPI-1.10.2 4d2925d6" SFCGAL="1.3.0" PROJ="Rel. 4.9.3, 15 August 2016" LIBXML="2.9.3" LIBJSON="0.11.99" LIBPROTOBUF="1.2.1" 
-
-
-}}}
+}}}
+
+{{{
+user=# select pkey, refvalid, st_isValid(geom) from valids_delft ;
+NOTICE:  Self-intersection at or near point 163.39202965708989 235.00834105653382
+NOTICE:  Hole lies outside shell at or near point 130 292
+NOTICE:  Interior is disconnected at or near point 170 170
+NOTICE:  Interior is disconnected at or near point 170 170
+NOTICE:  Self-intersection at or near point 200 201.76470588235293
+NOTICE:  Self-intersection at or near point 200 202
+NOTICE:  Holes are nested at or near point 180 200
+NOTICE:  Self-intersection at or near point 200 210
+NOTICE:  Self-intersection at or near point 219.6352644836272 111.99294710327453
+NOTICE:  Self-intersection at or near point 129.99999999999989 210.99999999999991
+NOTICE:  Self-intersection at or near point 212.95837780046392 99.000086530632473
+ pkey | refvalid | st_isvalid 
+------+----------+------------
+    1 | Valid    | t
+    2 | Valid    | t
+    3 | Valid    | t
+    4 | Valid    | t
+    5 | Valid    | t
+    7 | Valid    | t
+    6 | Valid    | t
+    8 | Valid    | t
+    9 | Valid    | t
+   11 | Valid    | t
+   12 | Valid    | t
+   13 | Invalid  | f
+   14 | Invalid  | f
+   15 | Valid    | t
+   16 | Valid    | t
+   17 | Valid    | t
+   18 | Valid    | t
+   19 | Valid    | t
+   20 | Invalid  | f
+   21 | Invalid  | f
+   22 | Invalid  | f
+   23 | Invalid  | f
+   24 | Invalid  | f
+   25 | Invalid  | f
+   26 | Valid    | t
+   27 | Valid    | t
+   28 | Valid    | t
+   29 | Valid    | t
+   30 | Invalid  | f
+   31 | Valid    | t
+   32 | Invalid  | f
+   33 | Valid    | t
+   34 | Valid    | t
+   35 | Invalid  | f
+   36 | Valid    | t
+(35 rows)
+
+PostgreSQL 9.5.14 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.10) 5.4.0 20160609, 64-bit
+POSTGIS="2.3.2 r15302" GEOS="3.8.0dev-CAPI-1.12.0 " PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 2.1.3, released 2017/20/01" LIBXML="2.9.3" LIBJSON="0.11.99" RASTER
+
+}}}