[postgis-users] Setting up PostGis, fail at applying 900913.sql

Sandro Santilli strk at keybit.net
Mon Oct 3 00:58:18 PDT 2011


On Mon, Oct 03, 2011 at 01:45:42AM +0200, Torsten Mohr wrote:

> postgres at schleim:/tmp/osm2pgsql/osm2pgsql> psql -d gis -f 900913.sql 
> psql:900913.sql:1: FEHLER:  doppelter Schlüsselwert verletzt Unique-Constraint 
> »spatial_ref_sys_pkey«
> DETAIL:  Schlüssel »(srid)=(900913)« existiert bereits.

I guess (can't read that message) that 900913 doesn't exist as a record
in spatial_ref_sys. Check that out if that's what the message says.
The spatial_ref_sys.sql I have in postgis trunk does contain 900913, if
you want to add it here it is:

INSERT INTO "spatial_ref_sys" ("srid","auth_name","auth_srid","srtext","proj4text") VALUES (900913,'spatialreference.org',900913,'PROJCS["Popular Visualisation CRS / Mercator (deprecated)",GEOGCS["Popular Visualisation CRS",DATUM["Popular_Visualisation_Datum",SPHEROID["Popular Visualisation Sphere",6378137,0,AUTHORITY["EPSG","7059"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6055"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4055"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],PROJECTION["Mercator_1SP"],PARAMETER["central_meridian",0],PARAMETER["scale_factor",1],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["EPSG","3785"],AXIS["X",EAST],AXIS["Y",NORTH]]','+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs' );

--strk;

  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html



More information about the postgis-users mailing list