[postgis] Itasca demo and spatial reference systems

John Reid jgreid at uow.edu.au
Wed Feb 13 06:33:49 PST 2002


Is this the right spatial reference system for the Itasca demo (from 
postgresql/share/contrib/spatial_ref_sys.sql)?

srid = 26915
auth_name = ESRI
auth_srid = 26915 | srtext =
PROJCS["NAD_1983_UTM_Zone_15N",
GEOGCS["GCS_North_American_1983",
DATUM["D_North_American_1983",
SPHEROID["GRS_1980",6378137,298.257222101]],
PRIMEM["Greenwich",0],
UNIT["Degree",0.017453292519943295]],
PROJECTION["Transverse_Mercator"],
PARAMETER["False_Easting",500000],
PARAMETER["False_Northing",0],
PARAMETER["Central_Meridian",-93],
PARAMETER["Scale_Factor",0.9996],
PARAMETER["Latitude_Of_Origin",0],
UNIT["Meter",1]]

The create table entry contains a CHECK contraint on the srid.  Any idea 
where that came from?  Does shp2pgsql create it automatically?  It is 
causing problems when I try to follow the instructions in 
postgresql/share/contrib/README.postgis.

itasca=> update airports set the_geom = SetSRID(the_geom,26915);
ERROR:  ExecReplace: rejected due to CHECK constraint $1


--
-- TOC Entry ID 32 (OID 41542)
--
-- Name: airports Type: TABLE Owner: pgis_user
--

CREATE TABLE "airports" (
    "gid" integer,
    "name" character varying,
    "lat" double precision,
    "lon" double precision,
    "elevation" double precision,
    "quadname" character varying,
    "the_geom" geometry,
    CHECK ((srid(the_geom) = -1)),
    CHECK (((geometrytype(the_geom) = 'MULTIPOINT'::text) OR (the_geom 
ISNULL)))
);

BTW, postgresql/share/contrib/README.postgis looks like it has an error 
in line 81:
  UPDATE TABLE <table> SET <geocolumn> = SetSRID(<geocolumn>,<SRID>);
should read:
  UPDATE <table> SET <geocolumn> = SetSRID(<geocolumn>,<SRID>);

-- 
----------------------------------------------------------------------
john reid                                     e-mail jgreid at uow.edu.au
        
uproot your questions from their ground and the dangling roots will be
seen.  more questions!
                                                       -mentat zensufi

apply standard disclaimers as desired...
----------------------------------------------------------------------
 



------------------------ Yahoo! Groups Sponsor ---------------------~-->
Sponsored by VeriSign - The Value of Trust
Secure all your Web servers now - with a proven 5-part
strategy. The FREE Server Security Guide shows you how.
http://us.click.yahoo.com/iWSNbC/VdiDAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 





More information about the postgis-users mailing list