forked from vouillon/osm
-
Notifications
You must be signed in to change notification settings - Fork 0
Experiments with the OpenStreetMap database : map rendering, routing, ...
License
kit-ty-kate/osm
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
Installation ============ This software only works on 64-bit machines. The following external libraries are needed: camlzip, cairo, lablgtk. They can be install through opam: opam install camlzip cairo2 lablgtk To compile, just type 'make'. Usage ===== At the moment, we provide a tool 'display' that displays a map and can be used to compute shortest paths on this map. A number of tools need to be run first to build the data used by 'display'. All these tools should scale to the whole world, except for the routing preprocessor which currently requires a huge amount of memory (~ 100 GB?) in this case. The France data can be processed on a 8 GB machine. Loading a PBF file ------------------ The 'load' tool will load a PBF file into the database: ./load ile-de-france-latest.osm.pbf PBF files can be found for instance at this address: http://download.geofabrik.de/europe/france.html The data is written to the 'base', 'source' and 'string' subdirectories of a database (currently hardcoded to '/tmp/osm'). (See the 'database' section for more details on the structure of the database.) The 'base' directory contains the following tables: Nodes node/id The node id in the OpenStreetMap database node/lat Node latitude node/lon Node longitude Node tags node_assoc/idx Index of the node in the node table node_assoc/key Key (string) node_assoc/val Value (string) Ways way/id The way id in the OpenStreetMap database Way tags way_assoc/idx Index of the way in the way table way_assoc/key Key (string) way_assoc/val Value (string) Way nodes way_refs/way Index of the way in the way table way_refs/node Index of the node in the node table Relations relation/id The relation id in the OpenStreetMap database Relation tags relation_assoc/idx Index of the relation in the relation table relation_assoc/key Key (string) relation_assoc/val Value (string) Relation members relation_members/relation Index of the relation in the relation table relation_members/type Type of the member (0: node, 1: way, 2:relation) relation_members/member Index of the member in the appropriate table relation_members/role Role of the member (string) The 'string' directory contains a string dictionary associating a unique integer to each string. Querying the database --------------------- The tool 'query' can be used to access the contents of this database: - Without argument, it will list all columns. - Given a subdirectory of the database, it will list the columns in this directory: ./query base - Given a list of columns, it will output the contents of these columns: ./query base/node/{id,lat,lon} - The '--string' option tells the tool to resolve and output the strings contained in the subsequent columns, using the string dictionary: ./query base/node_assoc/idx --string base/node_assoc/{key,val} (The --num option swithes back to outputing integers.) - The '--index i' option can be used to read this one line of table. For instance, this returns the OSM id of the node at index 1234: ./query base/node/id --index 1234 Preprocessing ------------- The five following operations need to be performed before being able to display the map: - extract multipolygons: ./multipolygons - build surface R-trees: ./surfaces - build R-trees of linear features: ./linear - build the routing graph: ./highway - preprocess the routing graph: ./contraction (we use so-called contraction hierarchies to speed-up route searches) Optionally, you can include the coastline data: - download coastlines-split-4326.zip from http://openstreetmapdata.com/data/coastlines (shapefile format, containing linestrings in WGS84 projection) - unzip the file - build the coastline R-trees: ./coastline /path/to/coastlines-split-4326.zip Map display ----------- The command 'display' displays the map. One can pan the map with the mouse and zoom using the mouse wheel. The start and destination of a route can be set by clicking respectively with the left and right mouse button. Database ======== We make heavy use of a specialized database engine for data storage and processing. Currently, the database path is hardcoded as /tmp/osm Data is stored using three possible formats: - columns of 63-bit integers - string dictionaries - R-trees Columns ------- Columns contain 63-bit integers. Columns are compressed by performing a delta encoding and using a variable-length encoding. This considerably reduces the disk memory usage and speeds up I/Os. A number of operations are implemented to process columns in an efficient manner: one can read sequentially the contents of a column, sort two columns according to the first column, perform a join between two pairs of columns, ... Random access is possible, but should be avoided when possible, as it is slow. String dictionaries ------------------- A string dictionnary associates a unique positive integer to each string. Strings can thus be compared by their id, without lookup. A two-way mapping between strings and their identifier is provided. At the moment, we use a single dictionnary, stored in the 'strings directory. R-tree ------ An R-tree is a kind of extension of B-trees to multidimensional objects. Each node in the tree holds the bounding box of its children. Hence, given a rectangle, one can efficiently find all leaves whose bounding box intersects with the rectangle. R-trees are stored as a directories containing files 0, 1, ..., n. Files '1' to 'n' contain nodes and are managed by the database. The contents of the leaf file '0' is free: when performing a request, we will get a list of leaf pages and it is our job to decode these pages. Page overflows (chunk of data that spans several pages) are possible, by reporting an empty bounding boxe for overflow pages. In order to build a R-tree, we sort the data according to there position on the Hilbert curve (which ensure good locality properties) and then insert them sequentially in the R-tree. (http://en.wikipedia.org/wiki/Hilbert_R-tree)
About
Experiments with the OpenStreetMap database : map rendering, routing, ...
Resources
License
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published
Languages
- OCaml 92.0%
- C 8.0%