Tag Info

New answers tagged


I've been having the same problem for a few days now. I found a solution, however, I didn't use PostGIS. Instead, I used QGIS (2.0.1 - Dufour) to do so. My problem was the same as yours. I imported a shapefile of road network that I have previously displayed in QGIS, where it would display correctly. The original SRID was 3347 (EPSG:3347 - NAD83 / ...


PostGIS typically expects coordinates in longitude-latitude or E-N order. Looking at the second example from postgis.org/docs/ST_AsGML.html, it seems there is some flipping of coordinates: -- Flip coordinates and output extended EPSG (16 | 1)-- SELECT ST_AsGML(3, ST_GeomFromText('POINT(5.23423 6.34535)',4326), 5, 17); st_asgml -------- <gml:Point ...

Top 50 recent answers are included