[postgis-users] Not what I was expecting....

Jeff Lake jeff at michiganwxsystem.com
Thu Oct 11 16:38:01 PDT 2012


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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121011/64c94f52/attachment.html>


More information about the postgis-users mailing list