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

Jeff Lake jeff at michiganwxsystem.com
Thu Oct 11 18:27:15 PDT 2012


Thank you !!!

set the column 'the_geom' to the correct SRID ..
and now this works

SELECT ST_AsText(ST_Transform(ST_GeomFromText(the_geom,3347),4326)) FROM 
canada WHERE name LIKE 'Caledon'




*Jeff Lake*
MichiganWxSystem <http://www.michiganwxsystem.com>
AllisonHouse <http://www.allisonhouse.com>
GRLevelXStuff <http://www.grlevelxstuff.com>
On 10/11/2012 20:56, Paul Ramsey wrote:
> 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
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121011/d2915b75/attachment.html>


More information about the postgis-users mailing list