New answers tagged

2

An inline SQL test to demonstrate what goes wrong and how to fix the problem. select ST_Within( ST_GeomFromText('POINT (326253.33 674110.63)'), ST_Buffer(ST_GeomFromText('POINT (326253.33 674110.63)',27700),10)); ERROR: contains: Operation on mixed SRID geometries (Polygon, 27700) != (Point, 0) SQL state: XX000 select ST_Within( ST_GeomFromText('POINT (...


1

You need to specify the SRID of the table you create. To create it with the same SRID as the flickr_edin table: CREATE TABLE temppat (id serial, geom geometry(Geometry,27700)); INSERT INTO temppat (geom) VALUES (ST_GeomFromText('POINT (326253.33 674110.63)')); To find out the SRID(s) of a table: SELECT DISTINCT ON (ST_SRID(geom)) ST_SRID(geom) FROM ...


Top 50 recent answers are included