Changes between Version 47 and Version 48 of BldgsGeomMisc

Timestamp:

Sep 21, 2019, 11:58:02 AM (5 years ago)

Author:

darkblueb

Comment:

--

BldgsGeomMisc

@@ -234 +234 @@
 
 }}}
+
+**Valids-Delft Lab**
+
+{{{
+PostgreSQL 10.10 (Ubuntu 10.10-1.pgdg16.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.11) 5.4.0 20160609, 64-bit
+
+POSTGIS="2.4.3" PGSQL="100" GEOS="3.7.2-CAPI-1.11.2 0" PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 2.3.2, released 2018/09/21" LIBXML="2.9.3" LIBJSON="0.11.99" LIBPROTOBUF="1.2.1"
+
+              Table "public.valids_delft"
+  Column   |   Type   | Collation | Nullable | Default 
+-----------+----------+-----------+----------+---------
+ pkey      | integer  |           | not null | 
+ groupname | text     |           |          | 
+ refvalid  | text     |           |          | 
+ wkt_base  | text     |           |          | 
+ geom      | geometry |           |          | 
+Indexes:
+    "valids_delft_pkey" PRIMARY KEY, btree (pkey)
+
+##----------------------------------------------------------------------------------
+dbb=# 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)
+
+}}}