| 308 | |
| 309 | {{{ |
| 310 | 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 |
| 311 | |
| 312 | 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" |
| 313 | |
| 314 | dbb=# select pkey, refvalid, st_isValid(geom) from valids_delft ; |
| 315 | NOTICE: Self-intersection at or near point 163.39202965708989 235.00834105653382 |
| 316 | NOTICE: Hole lies outside shell at or near point 130 292 |
| 317 | NOTICE: Interior is disconnected at or near point 170 170 |
| 318 | NOTICE: Interior is disconnected at or near point 170 170 |
| 319 | NOTICE: Self-intersection at or near point 200 201.76470588235293 |
| 320 | NOTICE: Self-intersection at or near point 200 202 |
| 321 | NOTICE: Holes are nested at or near point 180 200 |
| 322 | NOTICE: Self-intersection at or near point 200 210 |
| 323 | NOTICE: Self-intersection at or near point 219.6352644836272 111.99294710327453 |
| 324 | NOTICE: Self-intersection at or near point 129.99999999999989 210.99999999999991 |
| 325 | NOTICE: Self-intersection at or near point 212.95837780046392 99.000086530632473 |
| 326 | pkey | refvalid | st_isvalid |
| 327 | ------+----------+------------ |
| 328 | 1 | Valid | t |
| 329 | 2 | Valid | t |
| 330 | 3 | Valid | t |
| 331 | 4 | Valid | t |
| 332 | 5 | Valid | t |
| 333 | 7 | Valid | t |
| 334 | 6 | Valid | t |
| 335 | 8 | Valid | t |
| 336 | 9 | Valid | t |
| 337 | 11 | Valid | t |
| 338 | 12 | Valid | t |
| 339 | 13 | Invalid | f |
| 340 | 14 | Invalid | f |
| 341 | 15 | Valid | t |
| 342 | 16 | Valid | t |
| 343 | 17 | Valid | t |
| 344 | 18 | Valid | t |
| 345 | 19 | Valid | t |
| 346 | 20 | Invalid | f |
| 347 | 21 | Invalid | f |
| 348 | 22 | Invalid | f |
| 349 | 23 | Invalid | f |
| 350 | 24 | Invalid | f |
| 351 | 25 | Invalid | f |
| 352 | 26 | Valid | t |
| 353 | 27 | Valid | t |
| 354 | 28 | Valid | t |
| 355 | 29 | Valid | t |
| 356 | 30 | Invalid | f |
| 357 | 31 | Valid | t |
| 358 | 32 | Invalid | f |
| 359 | 33 | Valid | t |
| 360 | 34 | Valid | t |
| 361 | 35 | Invalid | f |
| 362 | 36 | Valid | t |
| 363 | (35 rows) |
| 364 | |
| 365 | 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" |
| 366 | |
| 367 | |
| 368 | }}} |