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
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