<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Will,</p>
<p>I presume Oracle must have changed their WKTEXT definition. The
issue here was the naming "Albers_Conical_Equal_Area" that must be
a Oraclism and a not-yet supported alias for this projection name.
I've queued support for it in PROJ
(<a class="moz-txt-link-freetext" href="https://github.com/OSGeo/PROJ/pull/4181">https://github.com/OSGeo/PROJ/pull/4181</a>), for the next PROJ
release</p>
<p>Even<br>
</p>
<div class="moz-cite-prefix">Le 24/06/2024 à 23:15, Burt, William
WLRS:EX via QGIS-User a écrit :<br>
</div>
<blockquote type="cite"
cite="mid:YT2PR01MB91891F4BE1BFE3029B701E1CC3D42@YT2PR01MB9189.CANPRD01.PROD.OUTLOOK.COM">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator"
content="Microsoft Word 15 (filtered medium)">
<style>@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
{font-family:Aptos;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;}p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
font-size:11.0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;}span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Aptos",sans-serif;
color:windowtext;}.MsoChpDefault
{mso-style-type:export-only;
font-size:11.0pt;}div.WordSection1
{page:WordSection1;}ol
{margin-bottom:0cm;}ul
{margin-bottom:0cm;}</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Hello QGIS users! I am wondering if anyone
has any experience with this issue I am having working with
Oracle DB and QGIS.
<o:p></o:p></p>
<p class="MsoNormal">When new layers are added from Oracle via
the QGIS Browser panel I get an error message in QGIS:<o:p></o:p></p>
<p class="MsoNormal"><i><span
style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#172B4D;background:white">No
transform is available between NAD83 / BC Albers and
EPSG:4326 - WGS 84.<o:p></o:p></span></i></p>
<p class="MsoNormal"><i><span
style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#172B4D;background:white">Unknown
error (code 4096)
</span><o:p></o:p></i></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Some details:<o:p></o:p></p>
<ol style="margin-top:0cm" type="1" start="1">
<li class="MsoListParagraph"
style="margin-left:0cm;mso-list:l0 level1 lfo1">I am certain
the root of the issue is not QGIS as I get the error message
on both current and older versions of QGIS that were working
fine a few months ago.
<o:p></o:p></li>
<li class="MsoListParagraph"
style="margin-left:0cm;mso-list:l0 level1 lfo1">Our
enterprise Oracle db was recently upgraded to 19c. This may
or may not be the cause but seems re<o:p></o:p></li>
<li class="MsoListParagraph"
style="margin-left:0cm;mso-list:l0 level1 lfo1">The error is
only thrown for data with BC Albers coordinate systems. WGS
84 datasets work fine<o:p></o:p></li>
<li class="MsoListParagraph"
style="margin-left:0cm;mso-list:l0 level1 lfo1">Datasets
where the URI is defined by .qqz or data added via our SLYR
plugin via .lyr .lyrx all work fine.<o:p></o:p></li>
<li class="MsoListParagraph"
style="margin-left:0cm;mso-list:l0 level1 lfo1">Dataset can
be made to work if the assigned CRS is changed to EPSG:3005
– NAD83/BC Albers from the auto detected crs: NAD83 / BC
Albers<o:p></o:p></li>
</ol>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">This leads me to think that the CRS
metadata is being delivered to QGIS differently than before.
Below is the WKTEXT for SRID 3005 from the Oracle medadata
table MDSYS.CS_SRS (I can’t tell if this has changed from the
older Oracle and I don’t see why it would):<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span
style="font-size:10.5pt;font-family:"Arial",sans-serif;color:#172B4D;background:white">PROJCS["NAD83
/ BC
Albers",GEOGCS["NAD83",DATUM["North_American_Datum_1983",SPHEROID["GRS
1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],AUTHORITY["EPSG","6269"]],PRIMEM["Greenwich",0],UNIT["Decimal
Degree",0.0174532925199433]],PROJECTION["Albers_Conical_Equal_Area"],PARAMETER["Latitude_Of_Origin",45],PARAMETER["Central_Meridian",-126],PARAMETER["Standard_Parallel_1",50],PARAMETER["Standard_Parallel_2",58.5],PARAMETER["False_Easting",1000000],PARAMETER["False_Northing",0],UNIT["Meter",1],AXIS["Easting",EAST],AXIS["Northing",NORTH]]<o:p></o:p></span></p>
<p class="MsoNormal"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thank you,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Will<o:p></o:p></p>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
QGIS-User mailing list
<a class="moz-txt-link-abbreviated" href="mailto:QGIS-User@lists.osgeo.org">QGIS-User@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
<a class="moz-txt-link-freetext" href="http://www.spatialys.com">http://www.spatialys.com</a>
My software is free, but my time generally not.</pre>
</body>
</html>