<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
I obtained a shape file from Environment Canada,<br>
imported it into a postGIS enabled database with shp2pgsql with no
problem.<br>
<br>
queried the table and noticed the SRID was -1, reset it with
UpdateGeometrySRID to 4326<br>
<br>
now when query the table I get the following<br>
(had the same results before updating the SRID)<br>
<br>
<pre>SELECT ST_AsText(the_geom) FROM canada WHERE name LIKE 'Caledon'
MULTIPOLYGON(((7185795.71819089 960058.015757074,7186925.78661135 958323.504835823,7187144.84742271 >>>>>>>> continues on
</pre>
I was expecting Lat/Long <br>
I *think* this is meter's ??<br>
<br>
anybody care to guess ??<br>
and if what needs to be adjusted and where <br>
<br>
<div class="moz-signature">-- <br>
<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>
</body>
</html>