Re: [postgis-users] pgsql2shp error

2010-08-24 Thread smas036
Hi Jeff, Thanks for your reply. The data was correct when I just used the table name. I have tried working with just the integer but I was still getting similar errors. I decided to just use a temp table, update that with a normal query and output the temp table as the shapefile. Thanks for

Re: [postgis-users] How to use accurate SRID ?

2010-08-24 Thread Paragon Corporation
Nguyen, 1) If you care about accurate measurement, don't use SRID 900913. It is grossly inaccurate for measurement and was designed specifically for map visualization. 2) If you are using PostGIS 1.5, you may want to store your long lat data in geography data type. It will allow you to keep