<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from text --><style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<meta content="text/html; charset=UTF-8">
<style type="text/css" style="">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
<div dir="ltr">
<div id="x_divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Arial,Helvetica,sans-serif">
<p>Hi,</p>
<p><br>
</p>
<p>a) If you look at this code here [1] from the raster driver, there are two function, FIND_GEOG_CRS and FIND_PROJ_CRS, that uses the WKT string to find matches with inside SRS.</p>
<p><br>
</p>
<p>That runs independently from Authority code and returns a list of possible matches SRIDs. The driver takes the first one automatically.</p>
<p><br>
</p>
<p>Looking back on that code, there is a lot of property-name strings that need to be adjusted, adding or removing some "_" or uppercase here and there.<br>
</p>
<p><br>
</p>
<p>b) I believe that EPSG codes are supported since version 11. <br>
</p>
<p><br>
</p>
<p>c) The -lco SRID is still useful. The way the OCI driver code works now "-a_srs EPSG:4326" will be translated to SRID 8078 (or something like that).</p>
<p><br>
</p>
<p>That is how the driver was originally developed, when EPSG was not supported yet. By using -lco SRID 4326 users can overwrite that.</p>
<p><br>
</p>
<p><br>
</p>
<p>I am kind of thinking about merging the two Oracle driver into one "raster/vector" driver. Any advice on that will be gladly accepted.</p>
<p><br>
</p>
<p><br>
</p>
<p>Regards,</p>
<p>Ivan<br>
</p>
<p><br>
</p>
<p>[1] - <a href="https://trac.osgeo.org/gdal/browser/trunk/gdal/frmts/georaster/georaster_dataset.cpp#L1673" class="x_OWAAutoLink" id="LPlnk651379">
https://trac.osgeo.org/gdal/browser/trunk/gdal/frmts/georaster/georaster_dataset.cpp#L1673</a></p>
<p><br>
</p>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Rahkonen Jukka (MML) <jukka.rahkonen@maanmittauslaitos.fi><br>
<b>Sent:</b> Thursday, November 17, 2016 9:18:43 AM<br>
<b>To:</b> Even Rouault; Ivan Lucena<br>
<b>Cc:</b> gdal-dev@lists.osgeo.org<br>
<b>Subject:</b> Re: [gdal-dev] Ogr2ogr -dim and Oracle</font>
<div> </div>
</div>
</div>
<font size="2"><span style="font-size:10pt;">
<div class="PlainText">Hi,<br>
<br>
Probably SDO_COORD_REF_SYS is what to use nowadays even I guess that it points to MDSYS tables. Looks like something has changed with Oracle 10.2 and I believe that it is very hard to use so old Oracle version without paying much extra.<br>
<a href="https://docs.oracle.com/database/121/SPATL/GUID-7DEF5C91-777C-4023-AE2E-E2E29F5213D2.htm#SPATL652">https://docs.oracle.com/database/121/SPATL/GUID-7DEF5C91-777C-4023-AE2E-E2E29F5213D2.htm#SPATL652</a>
<br>
<br>
-Jukka Rahkonen- <br>
<br>
<br>
Even Rouault wrote:<br>
<br>
Le jeudi 17 novembre 2016 14:19:10, Ivan Lucena a écrit :<br>
> Hi Even,<br>
> <br>
>> Did you try your change?<br>
<br>
>Yes<br>
<br>
>> <br>
> There has been a lot of changes in both sides over the years that are <br>
> not reflected on the OCI driver code.<br>
> <br>
> That hard coded SRID conversion should be deleted since EPSG is fully <br>
> supported now.<br>
<br>
Do you know which since which version of OCI this "now" apply ?<br>
<br>
With 11.2.0, I see things like :<br>
<br>
OGRFeature(select * from MDSYS.CS_SRS):6<br>
CS_NAME (String) = NAD83(CSRS98) / UTM zone 17N<br>
SRID (Integer64) = 2150<br>
AUTH_SRID (Integer64) = 2150<br>
AUTH_NAME (String) = Geomatics Canada.<br>
WKTEXT (String) = PROJCS["NAD83(CSRS98) / UTM zone 17N", GEOGCS [ "NAD83(CSRS98)", DATUM ["NAD83 Canadian Spatial Reference System (EPSG ID 6140)", SPHEROID ["GRS 1980 (EPSG ID 7019)", 6378137.0, 298.257222101]], PRIMEM [ "Greenwich", 0.000000 ], UNIT ["degree
minute second hemisphere", 0.0174532925199433]], PROJECTION ["Transverse Mercator"], PARAMETER ["Latitude_Of_Origin", 0.0], PARAMETER ["Central_Meridian", -81.0], PARAMETER ["Scale_Factor", 0.9996], PARAMETER ["False_Easting", 500000.0], PARAMETER ["False_Northing",
0.0], UNIT ["Meter", 1.0]]<br>
WKTEXT3D (String) = PROJCS[<br>
"NAD83(CSRS98) / UTM zone 17N",<br>
GEOGCS["NAD83(CSRS98)",<br>
DATUM["NAD83 Canadian Spatial Reference System",<br>
SPHEROID[<br>
"GRS 1980",<br>
6378137.0,<br>
298.257222101,<br>
AUTHORITY["EPSG", "7019"]],<br>
TOWGS84[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0],<br>
AUTHORITY["EPSG", "6140"]],<br>
PRIMEM["Greenwich", 0.000000, AUTHORITY["EPSG","8901"]],<br>
UNIT["degree minute second hemisphere", 0.0174532925199433, AUTHORITY["EPSG", "9108"]],<br>
AXIS["Lat", NORTH],<br>
AXIS["Long", EAST],<br>
AUTHORITY["EPSG", "4140"]],<br>
PROJECTION ["Transverse Mercator"],<br>
PARAMETER ["Latitude_Of_Origin", 0.0],<br>
PARAMETER ["Central_Meridian", -81.0],<br>
PARAMETER ["Scale_Factor", 0.9996],<br>
PARAMETER ["False_Easting", 500000.0],<br>
PARAMETER ["False_Northing", 0.0],<br>
UNIT["metre", 1.0, AUTHORITY["EPSG", "9001"]],<br>
AXIS["E", EAST],<br>
AXIS["N", NORTH],<br>
AUTHORITY["EPSG", "2150"]]<br>
<br>
What surprises me is the AUTH_NAME which is not EPSG (for other codes it is null). So it is not entirely clear how you would find the SRID if you can't search by AUTH_NAME = 'EPSG' AND AUTH_SRID = epsg_code. Skimming through the list, it seems that SRID = AUTH_SRID
for EPSG codes however.<br>
<br>
> <br>
> He georaster driver uses some PLSQL functions to try to match WKT to<br>
> possible SRIDs. That could be added to the OCI. I think.<br>
<br>
OK. Good to know<br>
<br>
Even<br>
<br>
-- <br>
Spatialys - Geospatial professional services<br>
<a href="http://www.spatialys.com">http://www.spatialys.com</a><br>
</div>
</span></font>
</body>
</html>