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

[Brent Robinson]

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/20100519/75fe9347/attachment.html