ST_Intersects on infinite numbers
|Reported by:||komzpa||Owned by:||pramsey|
I have a table with geometries I have gotten by dumping a world raster in EPSG:54009 and projecting to EPSG:3857. QGIS shows table in project good enough.
Identify tool in qgis stops working and barks a warning:
2019-03-05T11:36:36 WARNING Fetching from cursor qgis_3 failed Database error: ERROR: GEOSIntersects: IllegalArgumentException: RobustDeterminant encountered non-finite numbers 2019-03-05T11:36:36 WARNING Query: CLOSE qgis_3 returned 7 [ERROR: current transaction is aborted, commands ignored until end of transaction block ] 2019-03-05T11:36:36 WARNING 1 cursor states lost. SQL: CLOSE qgis_3 Result: 7 (ERROR: current transaction is aborted, commands ignored until end of transaction block )
I believe if we're sure geometry is offscreen we can handle the infininty intersects with a point or box in screen by telling "it doesn't intersect".