User Guidelines for GIS Data

Assumes installation of the relevant tools: InstallationGuidelinesGISData

Base Layers

• WMS BlueMarble & Mosaic (LandSat7): ​http://onearth.jpl.nasa.gov/

Display Shapefile as Overlay Layer in Sahana Eden

e.g. Country Outlines:

• ​http://thematicmapping.org/downloads/TM_WORLD_BORDERS-0.3.zip

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

If needing to reproject (e.g. for the ​Haiti Departements):

ogr2ogr -f CSV haiti_departments Haiti_departementes_edited_01132010.shp -s_srs EPSG:32618 -t_srs EPSG:4326 -lco GEOMETRY=AS_WKT

NB AS_WKT requires OGR v1.6+

Display Grid as Overlay Layer in Sahana Eden

tbc: BluePrintGISGrid

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

  \l
  

• List Tables

  \d
  

• 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;
  

---

UserGuidelinesGIS

UserGuidelines