[OSM-dev] Questions on PostGIS

[Milo van der Linden]

I have been on a Windows machine without python and perl, no C-compiler 
or CYGWin and an IIS webserver, crying a lot. Working my behind of on 
AJAX, WMS servers and clients, Google Maps, Google Earth and postGIS 
datasets. :-D
Since I am currently not able to find the time to get a linux machine 
running, I am stuck in the shadows ;-)

About osm2pgsql,  I run the plaxo GIS group which contains a link shared 
with the members to download your osm2pgsql_latest.exe.

So if you seen any hits comming in from 
http://pulse.plaxo.com/pulse/events/filter/group/141734817667, it is 
because of me...

And of course, feel free to join!

Artem Pavlenko schreef:
>>>
>>>
>> This is indeed an issue with the datastructure from OSM. Building
>> queries to combine nodes to dynamically generate ways on every request
>> is a performance killer!
>> Basically I think it would be best to write a script that will generate
>> REAL ways (polylines) in the postGIS database in a real geometric table.
>> That way you will take optimized use of geometry functions.
>
>
> Where have you been? Do you read this mailing list  or wiki ? ;)
>
> __osm2pgsql__
>
> http://trac.openstreetmap.org/browser/applications/utils/export/osm2pgsql
>
> Cheers
> Artem
>
>
>