search

kekscom / osmbuildings

OSM Buildings Classic 2.5D
http://osmbuildings.org
BSD 2-Clause "Simplified" License
505 stars 140 forks source link

Run on local database #69

Closed xEtherealx closed 9 years ago

xEtherealx commented 9 years ago

Is there a suggested way to run this against a local database, or are we left to implement a local conforming xapi server from scratch?

kekscom commented 9 years ago

OMG no :-) Create whatever backend you like but make sure:

a) it serves GeoJSON in TMS (Web Map Tile) schema, i.e. http://service.com/z/x/y.json b) Respect some custom properteis if you want your data to look nice (see last section of the readme)

Use that url schema in .load(URL)

Get back if you need further assistance.

xEtherealx commented 9 years ago

Hmm, well we are required to be able to run this offline so I guess I'll hash it out. I had already put together the pieces that you mentioned above, and I was really mostly hoping for specific SQL queries to fetch the proper pieces of data. I can see performance being an issue -- would you suggest moving the hstore tags/info out into a separate table?

kekscom commented 9 years ago

Offline in terms of off osmbuildings.org, right? Sorry, I have no SQL query ready for you. I'm adapting to Overpass with some code. Depending on load, performance should not be an issue for you. hstore is fine too, as you're most likely not filtering over it (assuming entirely buildings data). Have a proper geo index in place.

xEtherealx commented 9 years ago

Gotcha, thought I would ask. Maybe the overpass people will share their sauce :) If my code ends up looking decent enough I'll try to throw it on github for the masses, as I don't think something like this exists in the wild yet (that I could find).