I've been having issues converting OpenStreetMap geometries to valid points in PostGIS.
MY PostGIS table has the this definition for the geom column:
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:
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?