Latest Contributions by FazertyCazerty

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 ... View more

So I should use an SDE fonction like set SRID 2154 on every 4326 data ? ... View more

Yeah but the problem is the same : Under Postgres : No transformation available when source and destination spatial references do not have the same geographic coordinate system... ... View more

Hi Neil, Thank you for your anwser I already take a look into the geographic_transformations_10.1.pdf (didn't find the 10.3 version), and the transformation with the WKID 1671 is for RGF_1993_To_WGS_1984_1...me I need to go from WGS84 to RGF93 ! Moreover, I'm not sure that I can specify a geogtrans_id (WKID) with Postgres...It's said there : Aide ArcGIS (10.2, 10.2.1 et 10.2.2) (Take a look on the second sample) And maybe it's okay for the overlay but I need to put everything in L93 for the consistency of my database ! ... View more

Hi Carrie, Thx for your answer but I need to project from WGS84 (SRID : 4326) to GCS_RGF_1993 (SRID : 2154)...not form 2154 to 4326... And in ArcGIS, this projection is more difficult because the transformation is : WGS_1984_To_NTF_NTv2 + NTF_To_RGF_1993_1 In fact, I'm using an ETL for scheduling some SQL Queries, those queries are launched from this ETL into an SDE database under postgres. That's why I'm not searching for an answer with ArcGIS but with ArcSDE and the ST_Transform query ! BUT, this query doesn't work under postgres for source and destination spatial references do not have the same geographic coordinate system... In ArcGIS, for this problem, the transformation used is WGS_1984_To_NTF_NTv2 + NTF_To_RGF_1993_1 but I don't know how to use it with ArcSDE... Thx a lot for your answers ... View more