I added a column AddGeometryColumn(db,'table','geo', 26912, 'POINT', 2); 
update table set geo = setsrid(MakePoint(x, y), 26912)
Because the data I was working with was in the this projection 26912.
 
The problem now is I have data outside of this projection I need to add to the 
column.  I am guessing I needed to add the column with a more general srid, and 
then transform to the general srid?  My question is...  Is there a general 
projection for the western US or something similar?  I was thinking srid = 
4269?  But I'm not sure if this is correct?  Or if this is the right approach?  
But below is what i would do instead?
 
AddGeometryColumn(db,'table','geo', 4269, 'POINT', 2);
 
update table set geo = transform(setsrid(MakePoint(x, y), 26912), 4269)
update table set geo = transform(setsrid(MakePoint(x, y), 32107), 4269)
 
any help much appreciated
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to