OSM uses a PostgreSQL database as the main data store, along with PostGIS
extension for geometries. The tags are stored in key and value columns and
uses hstore, which makes it easy to add new ones without having to modify
the table schema. You can read about the database schema and infrastructure
Overpass is independent of the above infrastructure. It reads from the
replication files and builds a binary on-disk database. More about Overpass
Also, you should join the OSM Talk-in mailing list if you haven't!
On Mon, Feb 5, 2018 at 11:12 AM, Nikhil VJ <nikhil...@gmail.com> wrote:
> I want to learn how OpenStreetmap stores and manages its data, plus how
> Overpass Turbo extracts it.
> I find the key-value pair system fascinating (variable fields, organic
> building up of data) and want to replicate that elsewhere. Just the data
> storing part.. don't want to generate map tiles etc.
> Any pointers? Any place I should ask?
> For those interested, here's a link to the project I have in mind:
> Nikhil VJ
> Pune, India
> Datameet is a community of Data Science enthusiasts in India. Know more
> about us by visiting http://datameet.org
> You received this message because you are subscribed to the Google Groups
> "datameet" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to datameet+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
Talk-in mailing list