Version 1 (modified by Fran Boon, 14 years ago) ( diff )


User Guidelines for GIS Data

Assumes installation of the relevant tools: InstallationGuidelinesGISData

Display Shapefile as Overlay Layer in Sahana Eden

e.g. Country Outlines:

Import into PostGIS (or use pgAdmin III GUI's Shapefile loader on plugins menu)

createdb my_spatial_db
createlang plpgsql my_spatial_db
psql -d my_spatial_db -f /usr/share/lwpostgis.sql
psql -d my_spatial_db -f /usr/share/spatial_ref_sys.sql
shp2pgsql -s 4326 -I TM_WORLD_BORDERS-0.3.shp public.countries | psql -U postgres -W -d my_spatial_db

Get GeoServer to serve as WMS

  • tbc

Set up TileCache

  • tbc

Add WMS Layer to Sahana Eden

  • tbc

Convert Shapefile to an importable format

ogr2ogr -f CSV TM_WORLD_BORDERS-0.3.csv TM_WORLD_BORDERS-0.3.shp
ogr2ogr -f geojson TM_WORLD_BORDERS-0.3.json TM_WORLD_BORDERS-0.3.shp

PostgreSQL management

  • Connect to Database (or use pgAdmin III GUI's PSQL Console on plugins menu)
    psql -d my_spatial_db -U username
  • List Databases
  • List Tables
  • List Table structure
    \d tablename
    select field/* from tablename where field = 'value';

PostGIS functions

  • Centroids
    SELECT name, iso2, asText(ST_Transform(ST_Centroid(the_geom), 4326)) AS centroid FROM countries;


Attachments (12)

Download all attachments as: .zip

Note: See TracWiki for help on using the wiki.