[OSM-dev] Questions on PostGIS

Artem Pavlenko artem.mapnik at googlemail.com
Wed Feb 6 14:45:03 GMT 2008


On 6 Feb 2008, at 14:37, Milo van der Linden wrote:

> I have been on a Windows machine without python and perl, no C- 
> compiler or CYGWin and an IIS webserver, crying a lot.

Sorry to hear this. Could you download vc++ express ?

> 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!

Thanks for the invitation, perhaps, some time.
But if you need help or more info re:osm2pgsql do post here, please

Artem
>
> 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
>>
>>
>>
>





More information about the dev mailing list