# What is the format for OSM lat/lon in .osm/.osh files and how to import correctly into PostGIS?

I've been having issues converting OpenStreetMap geometries to valid points in PostGIS.

MY PostGIS table has the this definition for the geom column:

SELECT AddGeometryColumn('node','geom',900913,'POINT',2);


Using ST_GeomFromText, all points I enter into this table have points out in the middle of nowhere.

I've isolated one geom for investigation (the lat/lon below is from the OpenStreetMap .osm file):

SELECT ST_GeomFromText('POINT(53.3302090 -6.2642905)', 900913);


I've also tried:

SELECT ST_SetSrid(ST_MakePoint(53.3302090,-6.2642905),900913);


The point produced is no nowhere near land (when displayed in QGIS, also using 900913).

However, I have tested the lat/lon above in a website: http://www.latlong.net/Show-Latitude-Longitude.html, and it correctly identified a point in Dublin, Ireland.

I am assuming the lat/lon is in the WKT format?

ST_Transform(ST_GeomFromText('POINT(-6.2642905 53.3302090)', 4326), 900913));