Thank you Paul ..
getting the correct projection (SRID) on the table made
this possible
http://www.michiganwxsystem.com/wxweb.php?run=pass&temp=warningmap2&state=son
the map is 'clickable' using postGIS to find the EC Area's based off the
X,Y from your click
*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 <j...@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@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
