Also, be aware that PostGIS expects coordinates in X-Y order which means
for need to enter lat, lon as (long, lat) to correspond to (X, Y).
-Steve
PS: Merry Christmas Brent and everyone else!
On 12/24/2012 3:54 PM, [email protected] wrote:
Hi Neville,
Merry Christmas (it already is here in NZ :-)
You are passing a string - 'POINT(33.911404 -116.768347)' - not a
geometry in your query hence the error message that ST_SetSRID() doesn't
know what the first parameter is
Instead of:
select state from zipcode where DISTANCE(column2,
ST_SetSRID('POINT(33.911404 -116.768347)', 2163)) < 8000;
try:
select state from zipcode where DISTANCE(column2,
ST_SetSRID(ST_MAKEPOINT(33.911404 -116.768347), 2163)) < 8000;
Cheers,
Brent
--- On *Tue, 12/25/12, nevillekb /<[email protected]>/* wrote:
From: nevillekb <[email protected]>
Subject: Re: [postgis-users] Using PostGIS for latitude & longitude
To: [email protected]
Date: Tuesday, December 25, 2012, 1:32 AM
Hi,
So i created a table named zipcode with the following columns
Id
State
Zip
Latitude
Longitude
column1
column2
columns named column1 and column2 are the 2 geometry columns i have
created
to store the lat and long in 2 formats -SRID 4269 (Lat/Lon) and SRID
2163
(US National Atlas – meters).
Then i execute the following query to populate both the columns with
the lat
and lon data
UPDATE zipcode SET column1 =
ST_SetSRID(ST_MakePoint("longitude","latitude"),4269), column2 =
ST_Transform(ST_SetSRID(ST_MakePoint("longitude","latitude"),4269),
2163);
Everything has worked fine till now, but now when i try to execute the
following query to show all records that are within 5 miles of a
given point
i get an error.
Query:
select state from zipcode where DISTANCE(column2,
ST_SetSRID('POINT(33.911404 -116.768347)', 2163)) < 8000;
Error Generated:
WARNING ] select state from zipcode where DISTANCE(column2,
ST_SetSRID('POINT(33.911404 -116.768347)', 2163)) < 8000
ERROR: function st_setsrid(unknown, integer) is not unique
LINE 1: select state from zipcode where DISTANCE(column2,
ST_SetSRID...
^
HINT: Could not choose a best candidate function. You
might
need to add explicit type casts.
Can someone help me out as to where am i going wrong in the above
query??
Thanks
--
View this message in context:
http://postgis.17.n6.nabble.com/Using-PostGIS-for-latitude-longitude-tp5002097p5002125.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
