[OSM-talk] lat and lon in the db

2011-07-27 Thread Kenneth Gonsalves
hi, on querying the db, I get the lat and lon of a particular place as: lat 145921624 lon 864071554 but the map shows the correct figures: lat 12.9954832 lon 77.6208684 can anyone explain this? -- regards Kenneth Gonsalves ___ talk mailing list

[OSM-talk] lat and lon in the db

2011-07-27 Thread kenneth gonsalves
hi, on querying the db, I get the lat and lon of a particular place as: lat 145921624 lon 864071554 but the map shows the correct figures: lat 12.9954832 lon 77.6208684 can anyone explain this? -- regards Kenneth Gonsalves ___ talk mailing list

Re: [OSM-talk] lat and lon in the db

2011-07-27 Thread Tom Hughes
On 27/07/11 09:08, kenneth gonsalves wrote: on querying the db, I get the lat and lon of a particular place as: The db. Which db would that be exactly? Presumably one you have created somehow from planet, but how exactly did you create it? lat 145921624 lon 864071554 but the map shows

Re: [OSM-talk] lat and lon in the db

2011-07-27 Thread Jorge Gustavo
Hi Kenneth, As Tom already said, you probably used osm2pgsql and those coordinates are in the SRID EPSG:900913. You can/should confirm it by quering the geometry_columns table. osm2pgsql fills the table automatically. You should see something like:

Re: [OSM-talk] lat and lon in the db

2011-07-27 Thread kenneth gonsalves
On Wed, 2011-07-27 at 11:04 +0100, Jorge Gustavo wrote: As Tom already said, you probably used osm2pgsql and those coordinates are in the SRID EPSG:900913. You can/should confirm it by quering the geometry_columns table. osm2pgsql fills the table automatically. that's right ... In

Re: [OSM-talk] lat and lon in the db

2011-07-27 Thread Frederik Ramm
Hi, On 07/27/11 13:04, kenneth gonsalves wrote: I would prefer to reload in ESPG 4326, but on doing: ./osm2pgsql -S ./default.style -E EPSG:4326 ./bang.osm I get this error: Projection code failed to initialise Use -l (ell) instead of -E EPSG:4326. Bye Frederik

Re: [OSM-talk] lat and lon in the db

2011-07-27 Thread kenneth gonsalves
On Wed, 2011-07-27 at 13:11 +0200, Frederik Ramm wrote: On 07/27/11 13:04, kenneth gonsalves wrote: I would prefer to reload in ESPG 4326, but on doing: ./osm2pgsql -S ./default.style -E EPSG:4326 ./bang.osm I get this error: Projection code failed to initialise Use -l (ell) instead

Re: [OSM-talk] lat and lon in the db

2011-07-27 Thread kenneth gonsalves
On Wed, 2011-07-27 at 16:58 +0530, kenneth gonsalves wrote: Use -l (ell) instead of -E EPSG:4326. same error - maybe I need to install something. done - yum install proj-epsg. Thanks everyone. ___ talk mailing list talk@openstreetmap.org

Re: [OSM-talk] lat and lon in the db

2011-07-27 Thread Parveen Arora
On Wed, Jul 27, 2011 at 1:29 PM, Kenneth Gonsalves law...@gmail.com wrote: hi, on querying the db, I get the lat and lon of a particular place as: lat 145921624 lon 864071554 I was having the same problem, when I have implemented search in my map tile server. Actually these are not the

Re: [OSM-talk] lat and lon in the db

2011-07-27 Thread M∡rtin Koppenhoefer
2011/7/27 Kenneth Gonsalves law...@gmail.com: on querying the db, I get the lat and lon of a particular place as: lat 145921624 lon 864071554 but the map shows the correct figures: lat 12.9954832  lon 77.6208684 I guess these coordinates are the same, the first are the coordinates in your