<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Thank you !!!<br>
<br>
set the column 'the_geom' to the correct SRID ..<br>
and now this works<br>
<br>
SELECT
ST_AsText(ST_Transform(ST_GeomFromText(the_geom,3347),4326)) FROM
canada WHERE name LIKE 'Caledon'<br>
<br>
<br>
<br>
<br>
<div class="moz-signature"><b>Jeff Lake</b><br>
<a href="http://www.michiganwxsystem.com">MichiganWxSystem</a><br>
<a href="http://www.allisonhouse.com">AllisonHouse</a><br>
<a href="http://www.grlevelxstuff.com">GRLevelXStuff</a></div>
On 10/11/2012 20:56, Paul Ramsey wrote:<br>
</div>
<blockquote
cite="mid:CACowWR2SX5V=ub3-220s2XRbmZwnr01b5raWCPh6aC2v5gGD6A@mail.gmail.com"
type="cite">
<pre wrap="">Find the .prj file next to your .shp file and plug it into here
<a class="moz-txt-link-freetext" href="http://prj2epsg.org/search">http://prj2epsg.org/search</a>
P
On Thu, Oct 11, 2012 at 4:38 PM, Jeff Lake <a class="moz-txt-link-rfc2396E" href="mailto:jeff@michiganwxsystem.com"><jeff@michiganwxsystem.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
</body>
</html>