Hi Mike, Oh, naturally. I had forgotten that even I seem to have -lco SRID parameter included in all the scripts I have written myself. But how about appendind the data? Using -a_srs does not work and using "-lco SRID=2393" together with "-append" gives a message
"WARNING: Layer creation options ignored since an existing layer is being appended to." -Jukka- Smith, Michael wrote: > > Jukka, > > To set the SRID when loading to Oracle, you have to use the > layer creation option > > -lco srid=2393 > > Mike > > > -- > Michael Smith > RSGIS Center > US Army Corps of Engineers > > > > > On 11/30/09 7:25 AM, "Jukka Rahkonen" > <[email protected]> wrote: > > > Hi, > > > > Short question: I cannot get ogr2ogr to co-operate with me > and Oracle > > Spatial if I want to set the table SRID by using its EPSG > code. I can do what > > I > > want by using SQL*Plus but not with ogr2ogr. What am I doing wrong? > > > > Longish description follows. > > > > I was trying to use ogr2ogr that comes with MS4W 3.0 (dgal > version 1.7.0dev) > > for > > > > a) Importing a shapefile into Oracle 10g and give SRID at > the same time. > > b) Appending date into existing table with SRID set. > > > > The SRID I would like to use is epsg:2393. It is > configured it in Oracle as > > can > > be seen from the following SQL query: > > > > select * from mdsys.cs_srs where srid=2393; > > CS_NAME | SRID |AUTH_SRID |AUTH_NAME |WKTEXT |CS_BOUNDS > > > > KKJ / Finland Uniform Coordinate System > > 2393 2393 > > www.nls.fi/maa/papers/kkj.html > > PROJCS["KKJ / Finland Uniform Coordinate System", > > GEOGCS [ "KKJ", DATUM ["Kartasto Koordinaati Jarjestelma 1966 > > (EPSG ID 6123)", SPHEROID ["International 1924 (EPSG ID 7022)", > > 6378388.0, 297.0], -90.7, -106.1, -119.2, 4.09, 0.218, -1.05, > > 1.37], PRIMEM [ "Greenwich", 0.000000 ], UNIT ["Decimal Degree", > > 0.01745329251994328]], PROJECTION ["Finland Uniform Coordinate > > System (EPSG OP 18193)"], PARAMETER ["Latitude_Of_Origin", 0.0], > > PARAMETER ["Central_Meridian", 27.0], PARAMETER > > ["Scale_Factor", 1.0], PARAMETER ["False_Easting", 3500000.0], > > PARAMETER ["False_Northing", 0.0], UNIT ["Meter", 1.0]] > > > > Case a) Importing data to new table with ogr2ogr > > ================================================ > > Command: > > ogr2ogr -f "OCI" OCI:username/pas...@db:test -a_srs > epsg:2393 test.shp > > > > Result: Table is created and features are inserted, but > without SRID set. > > Ogr2ogr is trying to insert a new line into the table > MDSYS.CS_SRS but it > > fails > > because of insufficient privileges > > ERROR 1: ORA-01031: insufficient privileges > > in INSERT INTO MDSYS.CS_SRS (SRID, WKTEXT, CS_NAME) > > VALUES (1000003006,'PROJCS["KKJ / Finland Uniform Coordinate > > System",GEOGCS["KKJ",DATUM["Kartastokoordinaattijarjestelma_1966", > > SPHEROID["International 1924",6378388,297]],PRIMEM["Greenwich",0], > > UNIT["Decimal Degree",0.0174532925199433]],UNIT["metre",1], > > PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0], > > PARAMETER["central_meridian",27],PARAMETER["scale_factor",1], > > PARAMETER["false_easting",3500000],PARAMETER["false_northing",0]]', > > 'KKJ / Finland Uniform Coordinate System' ) > > > > I wonder why org2ogr is trying to add the projection, > because SRID 2393 is > > already defined in the database, and why it would like to > insert my SRID=2393 > > with code "1000003006". > > > > Case b) Appending data into table having SRID=2393 > > ================================================ > > Command: > > ogr2ogr -update -append -f "OCI" OCI:username/pas...@db:test > > -a_srs epsg:2393 test2.shp > > > > This fails with Oracle error ""Layer SRID does not match > geometry SRID". I can > > make the insert to succeed by dropping the spatial index of > the table, but > > then > > the newly inserted features have SRID=null. > > > > -Jukka Rahkonen > > > > > > _______________________________________________ > > gdal-dev mailing list > > [email protected] > > http://lists.osgeo.org/mailman/listinfo/gdal-dev > > _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
