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@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.
_______________________________________________
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
