How to convert OSM geometries to other coordinate reference systems?

Question

Hi everyone,

I haven't found any useable source on the web which tells me how to convert data from OSM which I have imported with osm2pgsql into my postGIS database to another coordinate reference Systems (CRS) like UTM or lat/Long. How can I do this task with the integrated functions in the postGIS database or vice versa, how to convert data from another database with e.g. UTM coordinates to the format OSM is using?

Thanks, Stefan aka nordie69

Answer 1

4

Unless you have specified a different CRS upon import (using the -l or -E), your import is in EPSG:3857 a.k.a EPSG:900913. To convert to a different CRS, use the PostGIS ST_Transform method:

SELECT name, ST_AsText(ST_Transform(way, 4326))
FROM planet_osm_point
WHERE amenity='pub';

permanent link

answered 25 Jan '15, 00:40

Frederik Ramm ♦
82.5k●92●720●1273
accept rate: 23%

Answer 2

Use standard PostGIS function st_transform(geometry,EPSG#). Using ST_Setsrid is useful to ensure the DB knows which co-ordinate system it is using. It is relatively easy to alter the standard table to add additional geometry columns, but the tables may not then be suitable for updates.

osm2pgsql allows the specification of the desired co-ordinate system as a flag on input. I'd use this if working predominantly in one co-ordinate system.

How to convert OSM geometries to other coordinate reference systems?

Follow this question

Related questions