[Qgis-user] QGIS w/ Oracle 19c

[Even Rouault]

Will,

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 (https://github.com/OSGeo/PROJ/pull/4181), for 
the next PROJ release

Even

Le 24/06/2024 à 23:15, Burt, William WLRS:EX via QGIS-User a écrit :
>
> Hello QGIS users! I am wondering if anyone has any experience with 
> this issue I am having working with Oracle DB and QGIS.
>
> When new layers are added from Oracle via the QGIS Browser panel I get 
> an error message in QGIS:
>
> /No transform is available between NAD83 / BC Albers and EPSG:4326 - 
> WGS 84./
>
> /Unknown error (code 4096) /
>
> Some details:
>
>  1. 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.
>  2. Our enterprise Oracle db was recently upgraded to 19c. This may or
>     may not be the cause but seems re
>  3. The error is only thrown for data with BC Albers coordinate
>     systems. WGS 84 datasets work fine
>  4. Datasets where the URI is defined by .qqz or data added via our
>     SLYR plugin via .lyr .lyrx  all work fine.
>  5. 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
>
> 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):
>
> 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]]
>
> Thank you,
>
> Will
>
>
> _______________________________________________
> QGIS-User mailing list
> QGIS-User at lists.osgeo.org
> List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
http://www.spatialys.com
My software is free, but my time generally not.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240625/15707369/attachment.htm>