wiki:GIS/InstallationGuidelines/Linux

Version 101 (modified by Nico Presto, 11 years ago) ( diff )

--

Installation of GIS Tools on Linux

Suggest these CLI tools for data manipulation:

PostGIS

PostGIS adds Spatial storage to PostgreSQL (visit this page to configure PostgreSQL before returning here to continue with the GIS parts)

NB PostGIS in Debian Lenny is rather old - recommend using the version in Squeeze

apt-get install postgresql-8.4-postgis
su postgres
createuser -s -P gis

createdb -O gis gis
createlang plpgsql -d gis
psql -d gis -f /usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sql
psql -d gis -f /usr/share/postgresql/8.4/contrib/postgis-1.5/spatial_ref_sys.sql

Ubuntu users (Lucid/PostgreSQL 8.4/Post-GIS 1.4) - the paths are slightly different

psql -d gis -f /usr/share/postgresql/8.4/contrib/postgis.sql
psql -d gis -f /usr/share/postgresql/8.4/contrib/spatial_ref_sys.sql

Add Spherical Mercator projection (900913. See http://www.cadmaps.com/gisblog/?p=81 for 54004):

  • Not needed with PostGIS-1.5 :)
    psql gis
    INSERT into spatial_ref_sys (srid, auth_name, auth_srid, srtext, proj4text) values (900913 ,'EPSG',900913,'GEOGCS["WGS 84", DATUM["World Geodetic System 1984", SPHEROID["WGS 84", 6378137.0, 298.257223563,AUTHORITY["EPSG","7030"]], AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich", 0.0, AUTHORITY["EPSG","8901"]], NIT["degree",0.017453292519943295], AXIS["Longitude", EAST], AXIS["Latitude", NORTH],AUTHORITY["EPSG","4326"]], PROJECTION["Mercator_1SP"],PARAMETER["semi_minor", 6378137.0], PARAMETER["latitude_of_origin",0.0], PARAMETER["central_meridian", 0.0], PARAMETER["scale_factor",1.0], PARAMETER["false_easting", 0.0], PARAMETER["false_northing", 0.0],UNIT["m", 1.0], AXIS["x", EAST], AXIS["y", NORTH],AUTHORITY["EPSG","900913"]] |','+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs');
    

Using PostGIS in Sahana

Java

Update: As of version 2.0, a Java Runtime Environment (JRE) is sufficient to run GeoServer. GeoServer no longer requires a Java Development Kit (JDK). Also note, OpenJDK does not work optimally with GeoServer.

for ubuntu 10.x

vim /etc/apt/sources.list
#uncomment partner repository
sudo apt-get update
sudo apt-get install sun-java6-jre

sudo emacs /etc/environment
JAVA_HOME=/usr/lib/jvm/java-6-sun
export JAVA_HOME

or,

for debian

vim /etc/apt/sources.list
# for sun-java packages in unstable
deb http://ftp.debian.org/debian/ unstable non-free
deb-src http://ftp.debian.org/debian/ unstable non-free

apt-get update
apt-get install sun-java6-jdk
vim /etc/profile
JAVA_HOME=/usr/lib/jvm/java-6-sun
export JAVA_HOME

or:

  • Download the JDK & install it:
    cd /usr/local
    sh ~/jdk-6u21-linux-i586.bin
    ln -sf /usr/local/jdk1.6.0_21 /usr/local/java
    vim /etc/profile
    JAVA_HOME=/usr/local/java
    export JAVA_HOME
    

Install the JAI extensions (improves performance for GeoServer WMS), the downloads available are listed here

32-bit:

cd /usr/lib/jvm/java-6-sun
wget http://download.java.net/media/jai/builds/release/1_1_3/jai-1_1_3-lib-linux-i586-jdk.bin
wget http://download.java.net/media/jai-imageio/builds/release/1.1/jai_imageio-1_1-lib-linux-i586-jdk.bin
sh jai-1_1_3-lib-linux-i586-jdk.bin
# accept license
export _POSIX2_VERSION=199209
sh jai_imageio-1_1-lib-linux-i586-jdk.bin
# accept license
rm jai-1_1_3-lib-linux-i586-jdk.bin
rm jai_imageio-1_1-lib-linux-i586-jdk.bin

64-bit:

cd /usr/lib/jvm/java-6-sun
wget http://download.java.net/media/jai/builds/release/1_1_3/jai-1_1_3-lib-linux-amd64-jdk.bin
wget http://download.java.net/media/jai-imageio/builds/release/1.1/jai_imageio-1_1-lib-linux-amd64-jdk.bin
sh jai-1_1_3-lib-linux-amd64-jdk.bin
# accept license
export _POSIX2_VERSION=199209
sh jai_imageio-1_1-lib-linux-amd64-jdk.bin
# accept license
rm jai-1_1_3-lib-linux-amd64-jdk.bin
rm jai_imageio-1_1-lib-linux-amd64-jdk.bin

If you installed JRE (sudo sh on Ubuntu)

cd /usr/lib/jvm/java-6-sun/jre
wget http://download.java.net/media/jai/builds/release/1_1_3/jai-1_1_3-lib-linux-amd64-jre.bin
sh jai-1_1_3-lib-linux-amd64-jre.bin 
#accept licence and replace [yes]
rm jai-1_1_3-lib-linux-amd64-jre.bin

Apache Tomcat

Tomcat is the recommended way to deploy Java applications

  • Debian:
    apt-get install sun-java6-jdk tomcat5.5 libapache2-mod-jk
    a2enmod jk
    vim /etc/libapache2-mod-jk/workers.properties
    workers.java_home=/usr/lib/jvm/java-6-sun
    
    # Needed for GeoServer-2.1-beta1 (2.0.2 was fine, but maybe it's because of running both at once?)
    vim /etc/default/tomcat5.5
    JAVA_OPTS="-Djava.awt.headless=true -Xmx256M -XX:MaxPermSize=128m"
    
    vim /etc/init.d/tomcat5.5
    TOMCAT5_SECURITY=no
    
    /etc/init.d/tomcat5.5 restart
    
  • Ubuntu 10.x:
    sudo apt-get install unzip lynx tomcat6 tomcat6-admin libapache2-mod-jk
    vim /etc/libapache2-mod-jk/workers.properties
    workers.java_home=/usr/lib/jvm/java-6-sun
    
    /etc/init.d/tomcat5.5 restart
    #should see stopping [OK] and starting [OK]
    }}
    
    Enable access to !GeoServer on Port 80:
    {{{
    a2enmod proxy
    a2enmod proxy_ajp
    a2enmod proxy_http
    vim /etc/apache2/mods-enabled/proxy.conf
        Deny from all
        Allow from localhost
    
    vim /etc/apache2/sites-available/geo
    <VirtualHost *:80>
      ServerName geo.eden.sahanafoundation.org
      ServerAdmin webmaster@sahanafoundation.org
      DocumentRoot /var/www
    
      ProxyPreserveHost on
      RewriteEngine On
      # These 2 lines should be disabled in Production
      RewriteRule ^/geoserver/(.*)$ ajp://localhost:8009/geoserver/$1 [P]
      ProxyPassReverse /geoserver ajp://localhost:8009/geoserver/
      RewriteRule ^/geoserver/wfs ajp://localhost:8009/geoserver/wfs [P]
      ProxyPassReverse /geoserver/wfs ajp://localhost:8009/geoserver/wfs
      RewriteRule ^/geoserver/wms ajp://localhost:8009/geoserver/wms/ [P]
      ProxyPassReverse /geoserver/wms ajp://localhost:8009/geoserver/wms/
      RewriteRule ^/geowebcache/(.*)$ ajp://localhost:8009/geowebcache/$1 [P]
      ProxyPassReverse /geowebcache ajp://localhost:8009/geowebcache/
    
      ErrorLog /var/log/apache2/geo_error.log
      LogLevel warn
      CustomLog /var/log/apache2/geo_access.log combined
    </VirtualHost>
    
    a2ensite geo
    /etc/init.d/apache2 restart
    }}}
    == WMS/WFS ==
    === [http://geoserver.org GeoServer] ===
    (recommended)
    
    {{{
    apt-get install unzip
    wget http://downloads.sourceforge.net/project/geoserver/GeoServer/2.0.2/geoserver-2.0.2-war.zip
    
    cd /var/lib/tomcat5.5/webapps
    unzip ~/geoserver-2.0.2-war.zip
    
    /etc/init.d/tomcat5.5 restart
    
    vim /etc/iptables.rules
    -A INPUT -p tcp --dport 8180 -j ACCEPT
    
    reboot
    }}}
    
    http://geo.host.domain:8180/geoserver
    
    or
    {{{
    wget http://downloads.sourceforge.net/project/geoserver/GeoServer/2.0.2/geoserver-2.0.2-bin.zip
    cd /usr/local
    unzip ~/geoserver-2.0.2-bin.zip
    ln -sf /usr/local/geoserver-2.0.2 /usr/local/geoserver
    
    vim /etc/profile
    GEOSERVER_HOME=/usr/local/geoserver
    export GEOSERVER_HOME
    
    vim /etc/rc.local
    /usr/local/geoserver/bin/startup.sh &
    
    vim /etc/iptables.rules
    -A INPUT -p tcp --dport 8080 -j ACCEPT
    
    reboot
    }}}
    http://geo.host.domain:8080/geoserver
    
    Configure:
     * [wiki:UserGuidelinesGISData#GeoServer]
     * [http://docs.geoserver.org/stable/en/user/production/index.html Production Performance]
       
    === [http://mapserver.org MapServer] ===
     * [http://www.tinyows.org TinyOWS] can complement this for WFS-T
    
    == !OpenStreetMap ==
     * http://weait.com/content/build-your-own-openstreetmap-server
     * http://weait.com/content/make-your-first-map
     * http://dbsgeo.com/foss4g2010/pdf/osm-rendering-foss4g2010.pdf
    
    !OpenStreetMap data can be stored in a PostGIS database & rendered using Mapnik.
    
    To support Key/Value pairs:
    {{{
    apt-get install postgresql-contrib-8.4
    su postgres
    psql -d gis -f /usr/share/postgresql/8.4/contrib/hstore.sql
    }}}
    
    To support Planet diff files:
    {{{
    su postgres
    psql gis < /usr/share/postgresql/8.4/contrib/_int.sql
    }}}
    
    === Osm2pgsql ===
     * http://wiki.openstreetmap.org/wiki/Osm2pgsql
    
    It is recommended to use the latest version from source rather than an out of date package:
    {{{
    apt-get install build-essential libxml2-dev libgeos-dev libpq-dev libbz2-dev proj autoconf subversion libtool
    svn export http://svn.openstreetmap.org/applications/utils/export/osm2pgsql/
    Optional (patch updated from original here): http://www.mail-archive.com/dev@openstreetmap.org/msg12768.html
    #wget http://eden.sahanafoundation.org/raw-attachment/wiki/InstallationGuidelinesGISDataLinux/osm2pgsql_centroid.patch
    cd osm2pgsql
    #patch -p0 < ../osm2pgsql_centroid.patch
    ./autogen.sh
    ./configure
    sed -i 's/-g -O2/-O2 -march=native -fomit-frame-pointer/' Makefile
    make
    make install
    # Fix needed for SVN version 0.70.5
    cp default.style /usr/local/share
    }}}
    
    === Mapnik ===
     * http://wiki.openstreetmap.org/wiki/Mapnik
     * http://mike.teczno.com/notes/mapnik.html (Advanced Tips)
    
    0.7.1 is packaged for Squeeze:
    {{{
    apt-get install python-mapnik unzip
    }}}
    
    Download the !OpenStreetMap extensions for Mapnik:
    {{{
    cd
    svn export http://svn.openstreetmap.org/applications/rendering/mapnik
    }}}
    
    Download/decompress Coastlines:
    {{{
    cd
    wget http://tile.openstreetmap.org/world_boundaries-spherical.tgz
    wget http://tile.openstreetmap.org/processed_p.tar.bz2
    wget http://tile.openstreetmap.org/shoreline_300.tar.bz2
    wget http://www.naturalearthdata.com/http//www.naturalearthdata.com/download/10m/cultural/10m-populated-places.zip
    wget http://www.naturalearthdata.com/http//www.naturalearthdata.com/download/110m/cultural/110m-admin-0-boundary-lines.zip
    cd ~/mapnik
    tar zxvf ~/world_boundaries-spherical.tgz
    tar jxvf ~/processed_p.tar.bz2 -C world_boundaries
    tar jxvf ~/shoreline_300.tar.bz2 -C world_boundaries
    unzip ~/10m-populated-places.zip -d world_boundaries
    unzip ~/110m-admin-0-boundary-lines.zip -d world_boundaries
    }}}
    
    Disable autovacuum:
    {{{
    vim /etc/postgresql/8.4/main/postgresql.conf
    #autovacuum = on
    /etc/init.d/postgresql restart
    }}}
    
    Download/Import area of interest, e.g.:
    {{{
    #wget http://downloads.cloudmade.com/north_america/haiti/haiti.osm.bz2
    #su postgres
    #osm2pgsql -s -d gis haiti.osm.bz2
    wget http://labs.geofabrik.de/haiti/2010-11-24-14-43.osm.bz2
    su postgres
    osm2pgsql -s -d gis 2010-11-24-14-43.osm.bz2
    }}}
    
    Re-enable autovacuum:
    {{{
    vim /etc/postgresql/8.4/main/postgresql.conf
    autovacuum = on
    /etc/init.d/postgresql restart
    }}}
    
    Setup XML file:
    {{{
    cd ~/mapnik
    ./generate_xml.py --accept-none --dbname gis --symbols ./symbols/ --world_boundaries ./world_boundaries/
    }}}
    
    Render tiles:
    {{{
    cd ~/mapnik
    vim generate_tiles.py
    render_tiles(bbox, mapfile, tile_dir, 0, 8, "World")
    #minZoom = 10
    #maxZoom = 16
    #bbox = (-2, 50.0,1.0,52.0)
    #render_tiles(bbox, mapfile, tile_dir, minZoom, maxZoom)
    # Haiti
    bbox = (-74.668, 17.884, -71.659, 20.232)
    render_tiles(bbox, mapfile, tile_dir, 9, 17, "Haiti")
    # Muenchen
    # comment all under here
    
    mkdir /var/www/tiles
    chown postgres /var/www/tiles
    ln -s /var/www/tiles
    su postgres
    MAPNIK_MAP_FILE="osm.xml" MAPNIK_TILE_DIR="tiles/" ./generate_tiles.py
    }}}
    === Contours ===
     * http://wiki.openstreetmap.org/wiki/Contours#The_PostGIS_approach
    
    {{{
    apt-get install gdal-bin
    }}}
    
    [http://dds.cr.usgs.gov/srtm/version2_1/SRTM3/ SRTM3] data:
    {{{
    mkdir ~/mapnik/srtm
    cd ~/mapnik/srtm
    wget http://mapnik-utils.googlecode.com/svn@170/sandbox/testing/hillshading/srtm_generate_hdr.sh 
    chmod +x srtm_generate_hdr.sh 
    cp srtm_generate_hdr.sh /usr/local/bin
    vim process_srtm3.sh
    #!/bin/bash 
    PREP_TABLE="1" 
    for X in *.hgt.zip; do 
        yes | srtm_generate_hdr.sh $X 
        rm -f "${X%%.zip}" 
    
        # Import 10m contours 
        rm -f "${X%%.hgt.zip}.shp" "${X%%.hgt.zip}.shx" "${X%%.hgt.zip}.dbf" 
        gdal_contour -i 10 -snodata 32767 -a height "${X%%.hgt.zip}.tif" "${X%%.hgt.zip}.shp" 
        [ "$PREP_TABLE" ] && shp2pgsql -p -I -g way "${X%%.hgt.zip}" contours | psql -q gis 
        shp2pgsql -a -g way "${X%%.hgt.zip}" contours | psql -q gis 
    
        rm -f "${X%%.hgt.zip}.shp" "${X%%.hgt.zip}.shx" "${X%%.hgt.zip}.dbf" 
        rm -f "${X%%.hgt.zip}.bil" 
        rm -f "${X%%.hgt.zip}.hdr" 
        rm -f "${X%%.hgt.zip}.prj" 
        rm -f "${X%%.hgt.zip}.tif" 
        unset PREP_TABLE 
    done
    
    # Haiti
    wget http://dds.cr.usgs.gov/srtm/version2_1/SRTM3/North_America/N17W072.hgt.zip
    wget http://dds.cr.usgs.gov/srtm/version2_1/SRTM3/North_America/N18W072.hgt.zip
    wget http://dds.cr.usgs.gov/srtm/version2_1/SRTM3/North_America/N18W073.hgt.zip
    wget http://dds.cr.usgs.gov/srtm/version2_1/SRTM3/North_America/N18W074.hgt.zip
    wget http://dds.cr.usgs.gov/srtm/version2_1/SRTM3/North_America/N18W075.hgt.zip
    wget http://dds.cr.usgs.gov/srtm/version2_1/SRTM3/North_America/N19W072.hgt.zip
    wget http://dds.cr.usgs.gov/srtm/version2_1/SRTM3/North_America/N19W073.hgt.zip
    wget http://dds.cr.usgs.gov/srtm/version2_1/SRTM3/North_America/N19W074.hgt.zip
    wget http://dds.cr.usgs.gov/srtm/version2_1/SRTM3/North_America/N19W075.hgt.zip
    wget http://dds.cr.usgs.gov/srtm/version2_1/SRTM3/North_America/N20W073.hgt.zip
    wget http://dds.cr.usgs.gov/srtm/version2_1/SRTM3/North_America/N20W074.hgt.zip
    wget http://dds.cr.usgs.gov/srtm/version2_1/SRTM3/North_America/N20W075.hgt.zip
    
    chown postgres .
    su postgres
    sh process_srtm3.sh
    }}}
    
    Since we are non-commercial, we should be able to use the SRTM4.1 data from [http://srtm.csi.cgiar.org CGIAR], however the Shapefile production crashed when it reached 2Gb.[[BR]]
    Example for Haiti:
    {{{
    cd ~/mapnik/srtm
    wget http://srtm.csi.cgiar.org/SRT-ZIP/SRTM_V41/SRTM_Data_GeoTiff/srtm_22_09.zip
    unzip srtm_22_09.zip
    gdal_contour -i 10 -snodata 32767 -a height "srtm_22_09.tif" "srtm_22_09.shp"
    su postgres
    shp2pgsql -p -I -g way "srtm_22_09" contours | psql -q gis
    shp2pgsql -a -g way "srtm_22_09" contours | psql -q gis
    }}}
    
    Configure Mapnik:
    {{{
    vim ~/mapnik/osm.xml
    # Under line &layer-shapefiles;
    &layer-contours;
    vim ~/mapnik/inc/layer-contours.xml.inc
    <Style name="contours10">
            <Rule>
                    &maxscale_zoom14;
                    &minscale_zoom17;
                    <LineSymbolizer>
                            <CssParameter name="stroke">#9cb197</CssParameter>
                            <CssParameter name="stroke-width">0.5</CssParameter>
                    </LineSymbolizer>
            </Rule>
    </Style>
    <Style name="contours50">
            <Rule>
                    &maxscale_zoom14;
                    &minscale_zoom17;
                    <LineSymbolizer>
                            <CssParameter name="stroke">#9cb197</CssParameter>
                            <CssParameter name="stroke-width">0.6</CssParameter>
                    </LineSymbolizer>
            </Rule>
            <Rule>
                    &maxscale_zoom12;
                    &minscale_zoom13;
                    <LineSymbolizer>
                            <CssParameter name="stroke">#747b90</CssParameter>
                            <CssParameter name="stroke-width">0.6</CssParameter>
                    </LineSymbolizer>
            </Rule>
    </Style>
    <Style name="contours100">
            <Rule>
                    &maxscale_zoom14;
                    &minscale_zoom17;
                    <LineSymbolizer>
                            <CssParameter name="stroke">#9cb197</CssParameter>
                            <CssParameter name="stroke-width">0.7</CssParameter>
                    </LineSymbolizer>
            </Rule>
            <Rule>
                    &maxscale_zoom12;
                    &minscale_zoom13;
                    <LineSymbolizer>
                            <CssParameter name="stroke">#747b90</CssParameter>
                            <CssParameter name="stroke-width">0.7</CssParameter>
                    </LineSymbolizer>
            </Rule>
            <Rule>
                    &maxscale_zoom10;
                    &minscale_zoom11;
                    <LineSymbolizer>
                            <CssParameter name="stroke">#855d62</CssParameter>
                            <CssParameter name="stroke-width">0.7</CssParameter>
                    </LineSymbolizer>
            </Rule>
    </Style>
    <Style name="contours-text50">
            <Rule>
                    &maxscale_zoom14;
                    &minscale_zoom17;
                    <TextSymbolizer name="height" face_name="DejaVu Sans Book" size="8" fill="#747b90" halo_radius="1" placement="line" />
            </Rule>
    </Style>
    <Style name="contours-text100">
            <Rule>
                    &maxscale_zoom14;
                    &minscale_zoom17;
                    <TextSymbolizer name="height" face_name="DejaVu Sans Book" size="8" fill="#747b90" halo_radius="1" placement="line" />
            </Rule>
            <Rule>
                    &maxscale_zoom12;
                    &minscale_zoom13;
                    <TextSymbolizer name="height" face_name="DejaVu Sans Book" size="8" fill="#855d62" halo_radius="1" placement="line" />
            </Rule>
    </Style>
    <Layer name="srtm_10" status="on" srs="+proj=latlong +datum=WGS84">
            <StyleName>contours10</StyleName>
            <StyleName>contours-text10</StyleName>
            <Datasource>
                    <Parameter name="table">(select way,height from contours WHERE height::integer % 10 = 0 AND height::integer % 50 != 0 AND height::integer % 100 != 0) as "contours-10"</Parameter>
                    &datasource-settings;
            </Datasource>
    </Layer>
    <Layer name="srtm_50" status="on" srs="+proj=latlong +datum=WGS84">
            <StyleName>contours50</StyleName>
            <StyleName>contours-text50</StyleName>
            <Datasource>
                    <Parameter name="table">(select way,height from contours WHERE height::integer % 50 = 0 AND height::integer % 100 != 0) as "contours-50"</Parameter>
                    &datasource-settings;
            </Datasource>
    </Layer>
    <Layer name="srtm_100" status="on" srs="+proj=latlong +datum=WGS84">
            <StyleName>contours100</StyleName>
            <StyleName>contours-text100</StyleName>
            <Datasource>
                    <Parameter name="table">(select way,height from contours WHERE height::integer % 100 = 0) as "contours-100"</Parameter>
                    &datasource-settings;
            </Datasource>
    </Layer>
    }}}
    
    ==== Hillshading ====
     * http://wiki.openstreetmap.org/wiki/HikingBikingMaps#Hill_Shading
    
    === Serve Tiles ===
    Tiles can simply be served by Apache:
    {{{
    vim /etc/apache2/sites-available/mysite
    <VirtualHost *:80>
      ServerName mysite.org
      Alias /tiles     /var/www/tiles
      <LocationMatch "/tiles/">
        Order Allow,Deny
        Allow from all
      </LocationMatch>
    </VirtualHost>
    apache2ctl restart
    }}}
    
    === WMS ===
    In order to serve the OSM data via WMS then can use mod_mapnik_wms:
     * http://wiki.openstreetmap.org/wiki/Mod_mapnik_wms
    {{{
    gpg --gen-key
    apt-get install pbuilder debsigs apache2-prefork-dev libmapnik-dev libgd2-xpm-dev
    svn export http://svn.openstreetmap.org/applications/utils/mod_mapnik_wms
    cd mod_mapnik_wms
    sh autogen.sh
    vim debian/mapnik_wms.load
    LoadFile /usr/lib/libmapnik.so.0.7
    
    debuild
    }}}
    
    This data can then be converted by !GeoServer into a KML !SuperOverlay to display in Google Earth:
     * http://geoserver.org/display/GEOS/GSIP+47+-+WMS+cascading
     * http://docs.geoserver.org/stable/en/user/googleearth/tutorials/superoverlaysgwc.html
    
    === Rails Port ===
    This is needed to allow editing of the data using Potlatch, JOSM, etc
     * http://wiki.openstreetmap.org/wiki/The_Rails_Port
    
    {{{
    apt-get install imagemagick libmagick9-dev
    apt-get install ruby ruby1.8-dev libxml2-dev libxml-ruby1.8 libxml-parser-ruby1.8 rubygems librmagick-ruby
    gem install -v=2.3.8 rails 
    #gem install libxml-ruby
    #gem install composite_primary_keys
    #gem install rmagick
    gem install timecop
    gem install pg
    gem install oauth
    
    #svn co http://railsexpress.de/svn/plugins/sql_session_store/trunk sql_session_store
    
    apt-get install postgresql-contrib libpq-dev
    su postgres
    createuser openstreetmap -s -P
    createdb -E UTF8 -O openstreetmap openstreetmap 
    createdb -E UTF8 -O openstreetmap osm_test
    createdb -E UTF8 -O openstreetmap osm
    psql -d openstreetmap < /usr/share/postgresql/8.4/contrib/btree_gist.sql
    
    apt-get install git
    cd /home
    git clone git://git.openstreetmap.org/rails.git
    cd rails
    cp config/postgres.example.database.yml config/database.yml
    vim config/database.yml
    
    rake gems:install
    rake db:migrate
    env RAILS_ENV=production rake db:migrate
    rake test
    
    osmosis --read-xml-0.6 file="planet.osm.bz2" --write-apidb-0.6 populateCurrentTables=yes host="localhost" database="openstreetmap" user="openstreetmap" password="openstreetmap" validateSchemaVersion=no
    
    select setval('acls_id_seq', (select max(id) from acls)); 
    select setval('changesets_id_seq', (select max(id) from changesets)); 
    select setval('countries_id_seq', (select max(id) from countries)); 
    select setval('current_nodes_id_seq', (select max(id) from current_nodes)); 
    select setval('current_relations_id_seq', (select max(id) from current_relations)); 
    select setval('current_ways_id_seq', (select max(id) from current_ways)); 
    select setval('diary_comments_id_seq', (select max(id) from diary_comments)); 
    select setval('diary_entries_id_seq', (select max(id) from diary_entries)); 
    select setval('friends_id_seq', (select max(id) from friends)); 
    select setval('gpx_file_tags_id_seq', (select max(id) from gpx_file_tags)); 
    select setval('gpx_files_id_seq', (select max(id) from gpx_files)); 
    select setval('messages_id_seq', (select max(id) from messages)); 
    select setval('sessions_id_seq', (select max(id) from sessions)); 
    select setval('user_tokens_id_seq', (select max(id) from user_tokens)); 
    select setval('users_id_seq', (select max(id) from users));
    
    cd /home/rails
    ruby script/server
    
    cd db/functions
    make libpgosm.so
    
        * Log into PgSQL and execute the CREATE FUNCTION statement from maptile.c's comment: 
    
     CREATE FUNCTION maptile_for_point(int8, int8, int4) RETURNS int4 
     AS '/path/to/rails-port/db/functions/libpgosm', 'maptile_for_point'
     LANGUAGE C STRICT;
    
     CREATE FUNCTION tile_for_point(int4, int4) RETURNS int8 
     AS '/path/to/rails-port/db/functions/libpgosm', 'tile_for_point'
     LANGUAGE C STRICT;
    
    }}}
    
    == Printing ==
    For Printing TMS layers, need to compile the Trunk version of the [http://www.mapfish.org/doc/print/ MapFish Print Module] & then serve the resultant .war with [http://tomcat.apache.org Tomcat]:
     1. Ensure that {{{JAVA_HOME}}} points to a JDK.
     2. Download & build source:
    {{{
    svn checkout http://www.mapfish.org/svn/mapfish/print/trunk/
    cd trunk
    ./gradlew build
    }}}
     3. Configure Tomcat
    {{{
    vim /etc/tomcat5.5/policy.d/04webapps.policy
    permission java.io.FilePermission "/var/lib/tomcat5.5/webapps/print-servlet-1.2-SNAPSHOT/WEB-INF/classes/logging.properties", "read";
    
    /etc/init.d/tomcat5.5 restart
    
    vim /etc/apache2/sites-available/print
    
    
    ln -s /etc/apache2/sites-available/print /etc/apache2/sites-enabled/print
    /etc/init.d/apache2 restart
    }}}
     4. Copy the WAR file to your %WEBAPPS% directory:
    {{{
    cp trunk/build/libs/print-servlet-1.2-SNAPSHOT.war /var/lib/tomcat5.5/webapps
    }}}
     5. (re)Start Tomcat
     6. Configure the Map URL for Eden to:
      * http://host.domain:8180/print-servlet-1.2-SNAPSHOT/pdf/
     7. Configure %WEBAPPS%\print-servlet-1.2-SNAPSHOT\config.yaml: http://www.mapfish.org/doc/print/configuration.html
    
    Printing can also be done within !GeoServer:
     * http://geoserver.org/display/GEOS/Printing+2.0+HOWTO
    However this version doesn't yet support TMS layers, like !OpenStreetMap.
    {{{
    wget http://geoserver.org/download/attachments/20938936/printing-2.0.x.zip
    wget http://geoserver.org/download/attachments/20938936/printing-data-2.0.x.zip
    cd /usr/local/geoserver-2.0.2/webapps/geoserver/WEB-INF/lib
    unzip ~/printing-2.0.x.zip
    cd /usr/local/geoserver-2.0.2/data_dir
    unzip ~/printing-data-2.0.x.zip
    /usr/local/geoserver/bin/shutdown.sh
    /usr/local/geoserver/bin/startup.sh &
    }}}
       * Configure by editing {{{/usr/local/geoserver-2.0.2/data_dir/printing/config.yaml}}} according to [http://trac.mapfish.org/trac/mapfish/wiki/PrintModuleServer Documentation]
    
    === Print to Image ===
     * http://trac.mapfish.org/trac/mapfish/ticket/161
    
    == Cache ==
     * http://mapproxy.org
      * http://mapproxy.org/docs/latest/install.html
    {{{
    wget http://effbot.org/downloads/Imaging-1.1.7.tar.gz
    tar zxvf Imaging-1.1.7.tar.gz
    cd Imaging-1.1.7
    python setup.py install
    cd ..
    
    wget http://pyproj.googlecode.com/files/pyproj-1.8.6.tar.gz
    tar zxvf pyproj-1.8.6.tar.gz
    cd pyproj-1.8.6
    python setup.py install
    cd ..
    
    wget http://pyyaml.org/download/pyyaml/PyYAML-3.09.tar.gz
    tar zxvf PyYAML-3.09.tar.gz
    cd PyYAML-3.09
    python setup.py install
    cd ..
    
    wget http://pypi.python.org/packages/source/J/Jinja2/Jinja2-2.1.1.tar.gz
    tar zxvf Jinja2-2.1.1.tar.gz
    cd Jinja2-2.1.1
    python setup.py install
    cd ..
    
    wget http://pypi.python.org/packages/source/f/flup/flup-1.0.3.dev-20100525.tar.gz
    tar zxvf flup-1.0.3.dev-20100525.tar.gz
    cd flup-1.0.3.dev-20100525
    python setup.py install
    cd ..
    
    wget http://pypi.python.org/packages/source/P/Paste/Paste-1.7.4.tar.gz
    tar zxvf Paste-1.7.4.tar.gz
    cd Paste-1.7.4
    python setup.py install
    cd ..
    
    wget http://pypi.python.org/packages/source/P/PasteDeploy/PasteDeploy-1.3.3.tar.gz
    tar zxvf PasteDeploy-1.3.3.tar.gz
    cd PasteDeploy-1.3.3
    python setup.py install
    cd ..
    
    wget http://pypi.python.org/packages/source/P/PasteScript/PasteScript-1.7.3.tar.gz
    tar zxvf PasteScript-1.7.3.tar.gz
    cd PasteScript-1.7.3
    python setup.py install
    cd ..
    
    wget http://pypi.python.org/packages/source/M/MapProxy/MapProxy-0.8.4.tar.gz
    tar zxvf MapProxy-0.8.4.tar.gz
    cd MapProxy-0.8.4
    python setup.py install
    cd ..
    
    cd /home
    paster create -t mapproxy_conf mapproxy
    }}}
      * http://code.google.com/p/modwsgi/wiki/IntegrationWithPylons
    {{{
    wget http://pypi.python.org/packages/source/C/ConcurrentLogHandler/ConcurrentLogHandler-0.8.4.tar.gz
    tar zxvf ConcurrentLogHandler-0.8.4.tar.gz
    cd ConcurrentLogHandler-0.8.4
    python setup.py install
    cd ..
    
    mkdir /var/www/.python-eggs
    chown www-data /var/www/.python-eggs
    
    vim /home/mapproxy/mapproxy.py
    import os, sys
    from paste.script.util.logging_config import fileConfig
    BASEDIR = os.path.dirname(__file__)
    INIFILE = os.path.join(BASEDIR, 'etc', 'config.ini')
    LOGFILE = os.path.join(BASEDIR, 'etc', 'log_deploy.ini')
    sys.path.append(BASEDIR)
    os.environ['PYTHON_EGG_CACHE'] = '/var/www/.python-eggs'
    fileConfig( LOGFILE )
    from paste.deploy import loadapp
    application = loadapp('config:%s' % INIFILE)
    
    vim /etc/apache2/sites-available/proxy
    <VirtualHost *:80>
      ServerName proxy.sahanafoundation.org
      ServerAdmin webmaster@sahanafoundation.org
      
      WSGIScriptAlias / /home/mapproxy/mapproxy.py
      WSGIDaemonProcess mapproxy user=www-data group=www-data home=/home/mapproxy processes=2 maximum-requests=100
      
      <Location "/">
        Order deny,allow
        Allow from all
        WSGIProcessGroup mapproxy
      </Location>
    
      ErrorLog /var/log/apache2/proxy_error.log
      LogLevel warn
      CustomLog /var/log/apache2/proxy_access.log combined
    </VirtualHost>
    
    cd /etc/apache2/sites-enabled
    ln -s ../sites-available/proxy
    /etc/init.d/apache2 force-reload
    }}}
      * http://mapproxy.org/docs/latest/configuration.html
    {{{
    
    }}}
    
     * http://tilecache.org
      * http://github.com/migurski/GridTile
    
     * http://geowebcache.org
      * e.g. included as part of [http://opengeo.org/community/suite/download/ OpenGeoSuite]
    
    ----
    [wiki:UserGuidelinesGISData]
    

Attachments (2)

Download all attachments as: .zip

Note: See TracWiki for help on using the wiki.