AW: [fdo-users] AutoCAD Map 3d 2011 FDO 3.5.0 BulkCopy Point fromShpFile to PostGIS 1.5.5 Table Coordinate Transformation Problem

[Hermann Karl]

Hi Brent,
 
Thanks for your reply.
 
Another workaround:
Change the sequence of the axes definition in the srtext of the table
spatial_ref_sys in postgis with originally first AXIS Y then AXIS X to
first AXIS X then AXIS Y the xy values are not swapped.
 
(update spatial_ref_sys
set srtext = 'PROJCS["MGI / Austria GK
West",GEOGCS["MGI",DATUM["Militar_Geographische_Institute",SPHEROID["Bes
sel
1841",6377397.155,299.1528128,AUTHORITY["EPSG","7004"]],TOWGS84[577.326,
90.129,463.919,5.137,1.474,5.297,2.4232],AUTHORITY["EPSG","6312"]],PRIME
M["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994
33,AUTHORITY["EPSG","9108"]],AUTHORITY["EPSG","4312"]],UNIT["metre",1,AU
THORITY["EPSG","9001"]],PROJECTION["Transverse_Mercator"],PARAMETER["lat
itude_of_origin",0],PARAMETER["central_meridian",10.33333333333333],PARA
METER["scale_factor",1],PARAMETER["false_easting",0],PARAMETER["false_no
rthing",-5000000],AUTHORITY["EPSG","31254"],AXIS["X",NORTH],AXIS["Y",EAS
T]]'
where srid = 31254;).
 
 
Karl

________________________________

Von: fdo-users-bounces at lists.osgeo.org
[mailto:fdo-users-bounces at lists.osgeo.org] Im Auftrag von Brent Robinson
Gesendet: Mittwoch, 19. Mai 2010 22:42
An: FDO Users Mail List
Betreff: RE: [fdo-users] AutoCAD Map 3d 2011 FDO 3.5.0 BulkCopy Point
fromShpFile to PostGIS 1.5.5 Table Coordinate Transformation Problem



Hi Karl,

 

The xy swapping might be due to different axes assignments in the source
and destination coordinate systems. For srid 31254, the PostGIS
spatial_ref_sys table has the following in the WKT:
AXIS["Y",EAST],AXIS["X",NORTH]].

 

Could you check your .prj file? If the WKT sets Y to North, or does not
set it explicitly then that would explain the swapping, which would
occur when Bulk copy converts the geometries between the source and
destination WKT's.

 

For SRID=26986, the WKT from PostGIS sets X to East and Y to North which
explains why Bulk Copy worked fine for it.

 

I'm not a coordinate system expert so I have to talk to a few other
people to determine a long-term solution. In the meantime, the
workaround you mentioned in another e-mail would be a good one.
Overriding the source coordinate system to an incompatible one and then
ignoring coordinate system errors, causes the coordinate conversion to
be bypassed, preventing the undesired ordinate swap.

 

Brent.

 

From: fdo-users-bounces at lists.osgeo.org
[mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Brent Robinson
Sent: Wednesday, May 19, 2010 10:21 AM
To: FDO Users Mail List
Subject: RE: [fdo-users] AutoCAD Map 3d 2011 FDO 3.5.0 BulkCopy Point
from ShpFile to PostGIS 1.5.5 Table Coordinate Transformation Problem

 

Hi Karl,

 

I get the same results with this coordinate system when bulk copying to
the PostgreSQL provider. The x and y values get switched. I'll do a bit
more investigation to narrow down the cause.

 

Brent.

 

From: fdo-users-bounces at lists.osgeo.org
[mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Hermann Karl
Sent: Tuesday, May 18, 2010 5:54 AM
To: FDO Users Mail List
Subject: [fdo-users] AutoCAD Map 3d 2011 FDO 3.5.0 BulkCopy Point from
ShpFile to PostGIS 1.5.5 Table Coordinate Transformation Problem

 

Dear List, 

If I try to BulkCopy a point from a FDO_Connected shapefile to which i
have allocated  the coordinatesystem  "MGI-AT.AUT-West / GK" (MGI /
Austria GK West Zone) (srid = 31254) in AutoCAD Map 3d to a
FDO_Connected point table in postgis (srid of the_geom = 31254) to which
i have allocated the coordinatesystem "MGI-AT.AUT-West / GK" in AutoCAD
Map 3d too, then the resulting x value of the point in the postgis table
equals the y value of the original point in the shapefile and the
resulting y value of the point in the postgis table equals the x value
of the original point in the shapefile.

Karl 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20100520/c010bfed/attachment.html