Hi,
I have a little Python application that populates a posgresql database using
osm2pgsql, renders a map with mapnik and extracts information from the
database to highlight points of interest.
I am having a bit of trouble with working out what units the coordinates of
nodes are in in the postgresq
I think I have found the problem - I was using planet_osm_nodes lat and lon
fields. If I use the planet_osm_point way field, and extract the
coordinates using ST_X() and ST_Y() all of the numbers match up.
You can see the factor of 100 difference if you do:
select id,lat,lon,astext(way) fro
On Tue, Dec 22, 2009 at 11:28 PM, Lars Francke wrote:
> Are there any other bugs/strange things you've encountered? I haven't
> had the time to look at the final file myself.
>
The num_changes data is weird.
http://www.openstreetmap.org/browse/changeset/2212421
4 nodes + 25 ways + 8 relations=3
2010/1/2 Graham Jones :
> I think I have found the problem - I was using planet_osm_nodes lat and lon
> fields. If I use the planet_osm_point way field, and extract the
> coordinates using ST_X() and ST_Y() all of the numbers match up.
>
> You can see the factor of 100 difference if you do:
>
Thanks Jon,
I thought it might be an efficiency thing, but wasn't sure when we are using
the postgis extensions anyway. I didn't get that far through the osm2pgsql
source code to spot it!
Regards
Graham.
2010/1/2 Jon Burgess
> 2010/1/2 Graham Jones :
> > I think I have found the problem - I w
Here's an interesting pair of nodes:
http://www.openstreetmap.org/api/0.6/node/558001392/2
http://www.openstreetmap.org/api/0.6/node/554816398/2
There's a version 2, but no version 1.
http://www.openstreetmap.org/browse/node/554816398
http://www.openstreetmap.org/browse/node/558001392
http://ww
Hello all,
When installing osm, am getting
== AddRelations: migrating ===
-- create_enumeration(:nwr_enum, ["Node", "Way", "Relation"])
rake aborted!
An error has occurred, this and all later migrations canceled:
PGError: ERROR: syntax error at o
On Sat, Jan 2, 2010 at 19:17, Anthony wrote:
> On Tue, Dec 22, 2009 at 11:28 PM, Lars Francke
> wrote:
>>
>> Are there any other bugs/strange things you've encountered? I haven't
>> had the time to look at the final file myself.
>
> The num_changes data is weird.
>
> http://www.openstreetmap.org/
On Sun, Jan 3, 2010 at 12:14 AM, Lars Francke wrote:
> On Sat, Jan 2, 2010 at 19:17, Anthony wrote:
> > 4 nodes + 25 ways + 8 relations=37 changes. But it's listed as
> > num_changes=35. And it's not because some elements have multiple
> versions,
> > because excluding duplicates would bring th
9 matches
Mail list logo