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 ([email protected]) http://www.compton.nu/ _______________________________________________ Geocoding mailing list [email protected] http://lists.openstreetmap.org/listinfo/geocoding
