[mapserver-users] How to enter the projected coordinates in Postgis

[Gregor at HostGIS]

> 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. Look through them manually and find the one that 
has the wrong latitude or longitude then correct or delete it.

SELECT astext(the_geom) from gpsdata;

You can also try these, to sort the list and perhaps make the bad 
coordinate show up at the start or end of the list:

SELECT astext(the_geom) from gpsdata order by x(the_geom);
SELECT astext(the_geom) from gpsdata order by x(the_geom) DESC;
SELECT astext(the_geom) from gpsdata order by y(the_geom);
SELECT astext(the_geom) from gpsdata order by y(the_geom) DESC;

-- 
HostGIS, Open Source solutions for the global GIS community
Greg Allensworth - SysAdmin, Programmer, GIS Person, Security
Network+   Server+   A+   Security+