On Thu, Jul 30, 2009 at 8:57 AM, Suman
Chatterjeeschatter...@addisontx.gov wrote:
Hi,
I have created 2 tables in postGIS and POSTGreSQL – in one, I am storing
the GPS coordinates which are in the form of say lat= 32.4 and longitude =
72.45 ( which are in degrees) with SRID 2276
And in
Hi Alex,
Thank You very much for pointing out the mistake. But still I am facing
some problem. My GPS is collecting data in NAD1983 which I found
corresponds to SRID 4269. The extent of the Addison area is
2445459.0713 7001896.9648 2514178.5480 7070616.4415
It is in LCC NAD1983(ft) which I
Select ST_Transform(gpscoords,2276) from gpsdata;
But it is throwing error :
ERROR: transform: couldn't project point:-14 (latitude or longitude
exceeded)SQL state:XX000
It means what it says: one of your points has a invalid ordinate, so it
cannot be transformed.
Try this to debug it.
Hi Greg,
Thank You very much. I was just trying and found the fault.Actually the
longitude should come first and then the latitude. I was doing otherwise
and so the error.
Now the transform function is working.
Thanks
Suman
-Original Message-
From: Gregor at HostGIS
