[Geocoding] Local Mirror of OSM Data...

[Tom Hughes]

On 23/10/09 16:20, Anthony wrote:

> For my database, I installed rails-port, dumped the database, and
> edited the dump file to fit my needs (I got rid of a bunch of the
> foreign key constraints, got rid of the "current" tables, got rid of
> the "private" tables and columns which I won't have access to, added
> fields like "isdownloaded" to tables like the changesets table to let
> me know how up to date the data is, etc.).  I plan to implement the
> "current" tables initially as a view, and ultimately as a materialized
> view.

What is your intended use for the data? I assume (given that this is the 
geocoding list) that it's some sort of geocoding?

The reason I ask is simple that the best schema to use for the data is 
generally heavily influenced by what you want to do with it - the rails 
schema is designed to make updating etc easy and is often not a good 
choice for other tasks.

> (*) Alternatively, is there an easy way to download *everything*,
> including current, history, and changeset info, preferably just for a
> large subset of the world, in my case Florida?  I could probably
> accept that, but I couldn't find the data.  So, I've basically decided
> to implement a cache (I call the database osm_cache), and get the info
> from the API when it's not in the cache (and cache it).

This kind of thing is discouraged - the API is really intended for 
editors and the like not for this sort of bulk usage.

Tom

-- 
Tom Hughes (tom at compton.nu)
http://www.compton.nu/