[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] select from layer where spatial-relationship geom-from-KML
From:       "Simon Greener" <simon () spatialdbadvisor ! com>
Date:       2012-12-13 23:26:57
Message-ID: op.wo93e7ywzbn0g9 () big-spdba ! greener ! local
[Download RAW message or body]

Martin,

Why not enforce the SRID as follows:

SELECT *
   FROM layer
  WHERE ST_Relate( geom, ST_SetSRID(ST_GeomFromKML('<Point><coordinates>-12=
5.6077,49.8986</coordinates></Point>'),3005) );

regards
Simon
-- =

Holder of "2011 Oracle Spatial Excellence Award for Education and Research."
SpatialDB Advice and Design, Solutions Architecture and Programming,
Oracle Database 10g Administrator Certified Associate; Oracle Database 10g =
SQL Certified Professional
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE, Manifold GIS, FME, Radi=
us Topology and Studio Specialist.
39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia.
Website: www.spatialdbadvisor.com
   Email: simon@spatialdbadvisor.com
   Voice: +61 362 396397
Mobile: +61 418 396391
Skype: sggreener
Longitude: 147.20515 (147=B0 12' 18" E)
Latitude: -43.01530 (43=B0 00' 55" S)
GeoHash: r22em9r98wg
NAC:W80CK 7SWP3
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]