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

[Paul Ramsey]

Find the .prj file next to your .shp file and plug it into here
http://prj2epsg.org/search

P

On Thu, Oct 11, 2012 at 4:38 PM, Jeff Lake <jeff at michiganwxsystem.com> wrote:
> 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
> AllisonHouse
> GRLevelXStuff
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>