Re: [datameet] How does OSM store its data

Thanks Devdatta and Sajjad, I did send the query to osm list too. But my follow-up queries will be more about data management than maps. Momentarily keeping maps in mind, has anybody worked on Cartaro in Drupal? http://cartaro.org/ NoSQL/Object Store database : It seems MongoDB is a big name

Re: [datameet] How does OSM store its data

Hey Nikhil, 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

Re: [datameet] How does OSM store its data

Hi Nikhil, The Database design has been documented here: https://wiki.openstreetmap.org/wiki/Database This is, at its essence, a modified EAV Model( https://en.wikipedia.org/wiki/Entity–attribute–value_model). A good place to start researching for these kinds of database design, is to look at

[datameet] How does OSM store its data

Hi, 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