Re: [Qgis-user] Problem CRS to data base Oracle

[Julien Cabieces]

Hi Stefanos,

I remember trying to do it but fail to. I didn't try too hard though so
maybe it's possible, but IIRC there were some triggers involved
that complicated things.

I'm afraid about others problems that could come then.

Regards,
Julien

> Hi Julien,
> do you think updating the crs definition in MDSYS.CS_SRS with a proper one
> could be a workaround for such cases or would it introduce other problems?
>
> Stefanos

___
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

Re: [Qgis-user] Problem CRS to data base Oracle

[uclaros]

Hi Julien,
do you think updating the crs definition in MDSYS.CS_SRS with a proper one
could be a workaround for such cases or would it introduce other problems?

Stefanos




--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
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

Re: [Qgis-user] Problem CRS to data base Oracle

[Julien Cabieces]

Hi,

I'm pretty sure this is the same issue than this one:
https://github.com/qgis/QGIS/issues/37898

Long story short, Oracle definition for projection differs from PROJ
database ones. So this exception needs to be taken care of. It's done in
PROJ > 7.1 but QGIS 3.16 and 3.18 relies on PROJ 6.3.2.

When QGIS will be built with PROJ 7.2 or greater (QGIS 3.20 maybe?), il
would be OK.

But for now, you just have to wait (or build a QGIS 3.18 with PROJ 7.2,
not an easy task).

Regards,
Julien


> Hello,
>
> We are having a problem displaying our data from our Oracle database.
> Our data stored in our Oracle database has the EPSG code as a projection: 
> 2154.
> We have configured Qgis with the following parameters:
>
> - Project CRS: EPSG 2154: RGF 93 / Lambert-93
> - Layer CRS: use the project CRS
>
> Despite this setting, when we load a layer from our database, it loads but it 
> does not appear on the screen.
> To visualize it, we must modify the CRS assigned to the layer by selecting:
> - the project CRS: EPSG 2154: RGF 93 / Lambert-93.
>
>
> By default, it is indicated RGF93 / Lambert-93.
>
> Why does QGIS not recognize the projection of our data in the new versions 
> (3.16.5 or 3.18)?
> Knowing that in version 3.4 we layers opened perfectly without modifying the 
> CRS assigned to the layer.
>
> Looking forward to your response.
>
> Cordially
>
> Stephanie GUILLAUMIN
> Head of GIS administration
> stephanie.guillau...@valdemarne.fr
>
> 01.49.56.53.21
>
> Le Val-de-Marne, D?partement utile : valdemarne.fr ? 
> votre service
> ___
> 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

___
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

[Qgis-user] Problem CRS to data base Oracle

[Guillaumin, Stephanie]

Hello,

We are having a problem displaying our data from our Oracle database.
Our data stored in our Oracle database has the EPSG code as a projection: 2154.
We have configured Qgis with the following parameters:

- Project CRS: EPSG 2154: RGF 93 / Lambert-93
- Layer CRS: use the project CRS

Despite this setting, when we load a layer from our database, it loads but it 
does not appear on the screen.
To visualize it, we must modify the CRS assigned to the layer by selecting:
- the project CRS: EPSG 2154: RGF 93 / Lambert-93.


By default, it is indicated RGF93 / Lambert-93.

Why does QGIS not recognize the projection of our data in the new versions 
(3.16.5 or 3.18)?
Knowing that in version 3.4 we layers opened perfectly without modifying the 
CRS assigned to the layer.

Looking forward to your response.

Cordially

Stephanie GUILLAUMIN
Head of GIS administration
stephanie.guillau...@valdemarne.fr

01.49.56.53.21

Le Val-de-Marne, D?partement utile : valdemarne.fr ? 
votre service
___
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