Strange enough, I still get the wrong result, even when using 100.0 instead
of 100. The extra ")" was because I copied the line from Java code. Maybe
somethings wrong with my spatial_ref_sys table.
I have two entries:
4326; "EPSG"; 4326; "GEOGCS["WGS
84",DATUM["WGS_1984",SPHEROID["WGS
84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]]";
"+proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs "
and
900913; "EPSG"; 900913; "PROJCS["WGS84 / Simple
Mercator",GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS_1984", 6378137.0,
298.257223563]],PRIMEM["Greenwich", 0.0],UNIT["degree",
0.017453292519943295],AXIS["Longitude", EAST],AXIS["Latitude",
NORTH]],PROJECTION["Mercator_1SP_Google"],PARAMETER["latitude_of_origin",
0.0],PARAMETER["central_meridian", 0.0],PARAMETER["scale_factor",
1.0],PARAMETER["false_easting", 0.0],PARAMETER["false_northing",
0.0],UNIT["m", 1.0],AXIS["x", EAST],AXIS["y",
NORTH],AUTHORITY["EPSG","900913"]]"; "+proj=merc +a=6378137
+b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m
+nadgri...@null +no_defs"
Would you mind posting your entries for comparison?
Thanks a lot,
Ben
--
View this message in context:
http://n2.nabble.com/OSM2PQSQL-PostGis-Coordinate-Conversion-tp4367010p4610881.html
Sent from the General Discussion mailing list archive at Nabble.com.
_______________________________________________
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk
