akiatoji

OSRM North America route server on EC2

Overview

OSRM route server is an extremely useful tool for getting the driving distance/time through multiple locations. The route server requires data that has to be downloaded and processsed before it can be used to serve routes from.

Processing OSRM data for large region like North America can be a real challenge due to memory and disk size requirements. It's also really time consuming. If you cut and try from scratch, you will repeatedly run into some constraints and fail after hours of running.

The following are summary notes from trying this with eventual success.

onzfonz

group: Elmasri & Navathe Possible Airline DB State Figure 5.8

description[[ this is a potential set of data based on the Airline Schema from the Elmasri & Navathe (Fundamentals of Database Systems Textbook) While it is based on the Schema, this is not from the book.

The relation _Airport_ contains basic information about an airport	
The relation _Flight_ contains basic information about a complete flight route
The relation _Flight_Leg_ contains information about a flight segment within that route
The relation _Leg_instance_ contains information on a flight leg from a particular day
The relation _Fare_ contains information on a fare for a flight
The relation _Airplane_type_ has information about different airplane models

didip

; Sample supervisor config file.

[unix_http_server]
file=/tmp/supervisor.sock   ; (the path to the socket file)
;chmod=0700                 ; sockef file mode (default 0700)
;chown=nobody:nogroup       ; socket file uid:gid owner
;username=user              ; (default is no username (open server))
;password=123               ; (default is no password (open server))

;[inet_http_server]         ; inet (TCP) server disabled by default