Thanks a lot, Jukka, that worked. <div><br></div><div>This has me wondering is ogr2ogr2 should have a general mechanism where ogr queries the underlying driver for SRS info, rather that GDAL using only the GDAL_DATA files. This is probably not an issue when using only local files, but transferring between spatial databases I imagine it could be useful, since Oracle in particular has pretty extensive CS data. Then -srs <whatever> works as long as the driver can supply the parameters. For example Oracle provides plenty of 3/7 arg datum shift arguments that would be useful, but are not, to my knowledge, distributed with GDAL. This is logically what is accomplished when using -lco ="SRID=___", but this functionality could be lifted into ogr proper rather than being on the driver level. Forgive me if this is actually the case; I just assume from this experience that it isn't. </div>
<div><br></div><div>Regards, </div><div>Anders<br><br><div class="gmail_quote">On Mon, Nov 15, 2010 at 2:14 PM, Jukka Rahkonen <span dir="ltr"><<a href="mailto:jukka.rahkonen@mmmtike.fi">jukka.rahkonen@mmmtike.fi</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">Anders Moe <anders.moe <at> <a href="http://geocap.no" target="_blank">geocap.no</a>> writes:<br>
<br>
><br>
><br>
> Hi everyone<br>
><br>
><br>
> When importing an ED50 (EPSG:4230) shapefile to Oracle Spatial 11g2, <br>
><br>
> ogr2ogr -a_srs EPSG:4230 -f OCI blabla<br>
><br>
> a get an insufficient privileges error<br>
<br>
<br>
</div>I would have a try with -lco SRID=4230. Ogr2ogr tries to find exact match and<br>
if that fails it tries to insert new projection definitions.<br>
Excerpt from <a href="http://gdal.org/ogr/drv_oci.html" target="_blank">http://gdal.org/ogr/drv_oci.html</a><br>
"SRID: By default this driver will attempt to find an existing row in the<br>
MDSYS.CS_SRS table with a well known text coordinate system exactly matching the<br>
one for this dataset. If one is not found, a new row will be added to this<br>
table. The SRID creation option allows the user to force use of an existing<br>
Oracle SRID item even it if does not exactly match the WKT the driver expects."<br>
<br>
-Jukka Rahkonen-<br>
<br>
<br>
_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
</blockquote></div><br><br clear="all"><br>-- <br><br>________________________________________________________<br><br>Anders Moe<br><br>Managing Director<br>Geocap<br>w: +47 22 95 56 63<br><a href="mailto:anders.moe@geocap.no" target="_blank">anders.moe@geocap.no</a><br>
________________________________________________________<br><br><br><br> <br><br>
</div>