Changes between Initial Version and Version 1 of UserGuidelines/GIS/Data

Timestamp:

05/26/10 21:57:46 (16 years ago)

Author:

Fran Boon

Comment:

--

UserGuidelines/GIS/Data

@@ +1 @@
+== User Guidelines for GIS Data ==
+Assumes installation of the relevant tools: [wiki:InstallationGuidelinesGISData]
+=== 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
+}}}
+
+=== 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;
+}}}
+----
+UserGuidelines