You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
OSM data at the poles for example will be inserted with invalid EPSG:3857 values, which will result in NaN values when transformed back to EPSG:4326 (see #2).
The text was updated successfully, but these errors were encountered:
We can make indizes and clustering on tables by our own. For deleting mistaken polygons we can use:
DELETE FROM osm_transport_points WHERE NOT ST_Intersects(geometry, ST_GeomFromText('POLYGON((-20037508.34 20037508.34, -20037508.34 20037508.34, 20037508.34 20037508.34, 20037508.34 -20037508.34))', '3857'))
and
DELETE FROM osm_places WHERE NOT ST_Intersects(geometry, ST_GeomFromText('POLYGON((-20037508.34 20037508.34, -20037508.34 20037508.34, 20037508.34 20037508.34, 20037508.34 -20037508.34))', '3857'))
OSM data at the poles for example will be inserted with invalid EPSG:3857 values, which will result in NaN values when transformed back to EPSG:4326 (see #2).
The text was updated successfully, but these errors were encountered: