[OSM-talk] lat and lon in the db

kenneth gonsalves lawgon at thenilgiris.com
Wed Jul 27 12:04:30 BST 2011

On Wed, 2011-07-27 at 11:04 +0100, Jorge Gustavo wrote:
> As Tom already said, you probably used osm2pgsql and those
> coordinates 
> are in the SRID EPSG:900913. You can/should confirm it by quering the 
> geometry_columns table. osm2pgsql fills the table automatically.

that's right


> In PostGIS, you can change coordinates doing st_transform.
> Example:
> Select astext(ST_transform(st_geometryfromtext('POINT(864071554 
> 145921624)',900913),4326)); 

I would prefer to reload in ESPG 4326, but on doing:
./osm2pgsql -S ./default.style -E EPSG:4326 ./bang.osm

I get this error:
Projection code failed to initialise

any clues?

More information about the talk mailing list