I obtained a shape file from Environment Canada, imported it into a postGIS enabled database with shp2pgsql with no problem.
queried the table and noticed the SRID was -1, reset it with UpdateGeometrySRID to 4326
now when query the table I get the following (had the same results before updating the SRID) SELECT ST_AsText(the_geom) FROM canada WHERE name LIKE 'Caledon' MULTIPOLYGON(((7185795.71819089 960058.015757074,7186925.78661135 958323.504835823,7187144.84742271 >>>>>>>> continues on I was expecting Lat/Long I *think* this is meter's ?? anybody care to guess ?? and if what needs to be adjusted and where -- *Jeff Lake* MichiganWxSystem <http://www.michiganwxsystem.com> AllisonHouse <http://www.allisonhouse.com> GRLevelXStuff <http://www.grlevelxstuff.com>
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users