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

2009-07-31 Thread Suman Chatterjee
...@hostgis.com] Sent: Friday, July 31, 2009 12:39 PM To: Suman Chatterjee Cc: Alexander Petkov; mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] How to enter the projected coordinates in Postgis > Select ST_Transform(gpscoords,2276) from gpsdata; > But it is throwing error : &

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

2009-07-31 Thread 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. Loo

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

2009-07-31 Thread Suman Chatterjee
itude exceeded)SQL state:XX000 Any idea how to proceed? Thanks Suman -Original Message- From: Alexander Petkov [mailto:green...@gmail.com] Sent: Friday, July 31, 2009 10:38 AM To: Suman Chatterjee Cc: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] How to enter the proj

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

2009-07-31 Thread Alexander Petkov
On Thu, Jul 30, 2009 at 8:57 AM, Suman Chatterjee 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 another I am capturing