MN2GT Support Scripts

fetch.sh

wget \
    http://developer.mapquest.com/content/static/geotiffs/mercator_tiffs.tar \
    http://tile.openstreetmap.org/world_boundaries-spherical.tgz \
    http://tile.openstreetmap.org/processed_p.tar.bz2 \
    http://tile.openstreetmap.org/shoreline_300.tar.bz2

prepare-database.sh

export PGUSER=postgres PGHOST=localhost
DB=osm
dropdb $DB
createdb $DB
createlang plgsql -d $DB
psql -d $DB -f /usr/share/pgsql/contrib/postgis-1.5/postgis.sql
psql -d $DB -f /usr/share/pgsql/contrib/postgis-1.5/spatial_ref_sys.sql

bunzip2 -c colorado.osm.bz2 | (
  cd ~/opt/osm2pgsql/
  ./osm2pgsql -sc -d $DB -H localhost -U postgres -S default.style -m /dev/stdin
)

prepare-datadir.sh

rm -rf mn2gt-data/
svn export https://svn.codehaus.org/geoserver/trunk/data/minimal/ mn2gt-data/
# cp -R ~/Projects/geoserver/data/minimal/ mn2gt-data/

mkdir mn2gt-data/data/
(cd mn2gt-data/data/ && tar x) < mercator_tiffs.tar
(cd mn2gt-data/data/ && tar xz) < world_boundaries-spherical.tgz
(cd mn2gt-data/data/world_boundaries && tar xj) < processed_p.tar.bz2
(cd mn2gt-data/data/world_boundaries && tar xj) < shoreline_300.tar.bz2

cp -r ~/Projects/MapQuest-Mapnik-Style/mapquest_symbols/ \
    mn2gt-data/styles/symbols/

reset-database.sh

export PGUSER=postgres
export PGDATABASE=osm
export PGHOST=127.0.0.1
dropdb
createdb
createlang plgsql
psql -f /usr/share/pgsql/contrib/postgis-1.5/postgis.sql
psql -f /usr/share/pgsql/contrib/postgis-1.5/spatial_ref_sys.sql
gunzip -c california.sql.gz | psql