-
-
Save lennart/997669 to your computer and use it in GitHub Desktop.
spacialdb live demo
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Live Demo at EuRuCamp Berlin of deploying a routing app to Heroku using @spacialdb | |
# Goal is to have your own deployment of a location based application that does street routing: http://spacialdb-routing.heroku.com/ | |
# =============================================== | |
# PREREQUISITES: | |
# =============================================== | |
# 1. Get a Heroku account: http://heroku.com | |
# 2. Email [email protected] so we can give you access to the SpacialDB alpha Heroku addon | |
# 3. Install PostGIS | |
$ brew install postgis cmake boost | |
# 4. Install osm2pgrouting | |
$ git clone git://github.com/kashif/osm2pgrouting.git | |
$ cd osm2pgrouting | |
$ cmake . | |
$ make | |
$ cd .. | |
# ========================================================= | |
# Live Deployment: We will do this together during the talk | |
# ========================================================= | |
$ git clone git://github.com/spacialdb/Routing-Heroku-Example.git | |
$ cd Routing-Heroku-Example | |
$ heroku create <some-app-name> | |
$ heroku addons:add spacialdb:test | |
$ heroku config | |
SPACIALDB_URL => postgres://user:[email protected]:9999/heroku_shoaib_burq_517e | |
# set up env variables | |
$ wget https://gist.github.com/raw/996860/8eb0429d8bc6d95e4843d9dd56ff96c91830f732/print_spacialdb_params.rb | |
# run the printed export stat | |
$ chmod +x print_spacialdb_params.rb | |
$ heroku config | |
$ SPACIALDB_URL=postgres://user:[email protected]:9999/heroku_shoaib_burq_517e ./print_spacialdb_params.rb | |
# get the data | |
$ wget -O map.osm http://api.openstreetmap.org/api/0.6/map?bbox=13.4066263,52.494329,13.420215,52.520088 | |
$ wget -O mapconfig.xml https://gist.github.com/raw/996868/cdcfa8439eca48b1aa517b069fb1a7d65888e070/mapconfig.xml | |
# import the data | |
$ osm2pgrouting -file map.osm \ | |
-conf ./mapconfig.xml \ | |
-dbname $SPACIALDB_DB \ | |
-user $SPACIALDB_USER \ | |
-host $SPACIALDB_HOST \ | |
-port $SPACIALDB_PORT \ | |
-passwd $SPACIALDB_PASS -clean | |
$ git push heroku master | |
$ heroku open | |
# For more checkout: http://beta.spacialdb.com |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment