Hi folks, I just tested the select on my dev machine at home and there it produces the right output. So it is obvious that my db at work is not correctly setup. I'm just going to clean my db and import the latest data.
Thanks again for all the help. Cheers Ric Rahkonen Jukka schrieb: > Hi, > > There should be no problem in this. I do regularly update the whole OSM data > from Finland to epsg:2393 inside PostGIS with transform and never faced a > problem. Reasons I can imagine are > > - the Ingolstadt point is in a wrong place in OSM database > - PostGIS has wrong parameters for either source or target projection. Really > hard to believe that 4326 could be the problematic one. Check what > projection your OSM data has in the database and projection string that is > stored for that in PostGIS coordinate system table. You may also try to > import OSM data again with osm2pgsql by using some other option for the > projection. If epsg:4326 is your goal you can import data directly to that. > > -Jukka Rahkonen- > > >> -----Alkuperäinen viesti----- >> Lähettäjä: [email protected] >> [mailto:[email protected]] Puolesta Ric S >> Lähetetty: 26. helmikuuta 2009 15:07 >> Vastaanottaja: Mapnik users mailing-list >> Aihe: [Mapnik-users] OT: Openstreetmap projection >> >> Hi Folks, >> >> this is a little bit offtopic, but I think someone here might >> know the solution. >> I'm trying to transform osm data from my postgis db to lat lon values. >> >> SELECT name, place, asText(transform(way,4326)) from >> planet_osm_point WHERE name = 'Ingolstadt' AND place = 'city' >> ORDER BY name; >> >> The result is: >> >> 11.4333 48.9570163662354 >> >> If I use the values for example with google maps the >> resulting point is off by about 20km. The expected result >> would be rather around 11.41 48.76. >> >> Any clue what's wrong? >> >> Thanks Ric >> >> >> >> >> >> >> _______________________________________________ >> Mapnik-users mailing list >> [email protected] >> https://lists.berlios.de/mailman/listinfo/mapnik-users >> >> > > _______________________________________________ Mapnik-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/mapnik-users
