Hi everyone,
- Neil Ayres :
No it doesn't overlay because : the origin data are lon/lat in WGS84 (SRID : 4326), my database is in L93 (SRID : 2154) and I would like to inject the origin data (in WGS84) into a layer (in L93), so yes it makes sense to reproject the lon/lat from WGS84 (SRID : 4326) to L93 (SRID : 2154), maybe with a transformation like WGS84_1984_To_RGF_1993 or the transformation used in ArcGIS which is WGS_1984_To_NTF_NTv2+NTF_To_RGF_1993_1 but certainly not RGF_1993_To_WGS_1984 (SRID-transformation : 1671) because if for reproject from WGS84 to RGF93, i'm not sure that if the 1671-transformation worked, ArcMap would prefer to use the WGS_1984_To_NTF_NTv2+NTF_To_RGF_1993_1 transformation rather than the RGF_1993_To_WGS_1984 which looks simpler...
- Steven Embree II :
Yes I'm using ArcSDE within Postgresql, but I have to use the SQL/SDE queries without using ArcMap because my goal is to schedulling some tasks like : Creating point from lon/lat WGS84 data --> Reprojecting it in L93 --> Insert it into my sde/PG database...
I don't understand you're message, are you telling me that the sde queries malfunction ?
- Carrie Davis :
No my script is in Java and it lunch some queries in XPath and SQL sometimes, on the other side, I really don't know Python and I really would like to do this in SQL...
Is it me or this transformation is not possible in SQL with the sde.st_transform under Postgres ?
Thx everyone for your reponses