[OSM-talk] OSM2PQSQL / PostGis: Coordinate Conversion

d8930 d8930 at uggsrock.com
Mon Feb 22 10:51:36 GMT 2010



d8930 wrote:
> 
> 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
> +nadgrids=@null +no_defs"
> 
> Would you mind posting your entries for comparison?
> 
> Thanks a lot,
> Ben
> 
Sorry for spamming. I found out that it has to deal with the 4326 entry. I
have added the projection 4324 from the Postgis installation package, and I
get quite precise results:
POINT(8.30107722233746 50.1359315159791)
Nevertheless, this result differs a few meters from the one you obtained
with the 4326 projection. So I guess, with your entry I should get it right.
-- 
View this message in context: http://n2.nabble.com/OSM2PQSQL-PostGis-Coordinate-Conversion-tp4367010p4611333.html
Sent from the General Discussion mailing list archive at Nabble.com.




More information about the talk mailing list