Changes between Version 190 and Version 191 of UserGuidelines/GIS/Data

Timestamp:

01/22/12 10:54:24 (14 years ago)

Author:

Fran Boon

Comment:

--

UserGuidelines/GIS/Data

@@ -345 +345 @@
 }}}
 
-
-To import into PostGIS for serving as WMS:
-{{{
-apt-get -y install gdal-bin pgloader
-mkdir GADMv1
-cd GADMv1
-wget http://gadm.org/data/gadm_v1_lev0_shp.zip
-wget http://gadm.org/data/gadm_v1_lev1_shp.zip
-wget http://biogeo.ucdavis.edu/data/gadm/gadm_v1_lev2_shp.zip
-unzip gadm_v1_lev0_shp.zip
-unzip gadm_v1_lev1_shp.zip
-unzip gadm_v1_lev2_shp.zip
-ogr2ogr -f CSV CSV gadm1_lev0.shp -lco GEOMETRY=AS_WKT
-ogr2ogr -f CSV CSV2 gadm1_lev1.shp -lco GEOMETRY=AS_WKT
-ogr2ogr -f CSV CSV3 gadm_v1_lev2.shp -lco GEOMETRY=AS_WKT
-mv CSV2/gadm1_lev1.csv CSV
-mv CSV3/gadm_v1_lev2.csv CSV
-# Fix encodings! http://ww.gadm.org/node/287
-python utf8.py
-rm -rf CSV
-rm -rf CSV2
-rm -rf CSV3
-cat << EOF > "/home/GADMv1/pgloader.conf"
-[pgsql]
-host    =   localhost
-port    =   5432
-base    =   sahana
-user    =   sahana
-pass    =   eden
-
-client_encoding = 'utf-8'
-
-[ogr_tmpl]
-template     = True
-format       = csv
-field_sep    = ,
-quotechar    = "
-trailing_sep = False
-
-[l1]
-use_template    = ogr_tmpl
-table           = public.gis_location
-filename        = gadm1_lev0_utf8.csv
-columns         = wkt:1, name:6, code:22, area:28
-only_cols       = 1, 6, 22, 28
-skip_head_lines = 1
-
-EOF
-vim /usr/share/pyshared/pgloader/csvreader.py
-csv.field_size_limit(2**20 * 100)  # 100 megs
-
-pgloader
-}}}
-
-This can then be served as 3 WMS layers using !GeoServer & !GeoWebCache. SLD files are attached:
+This can then be served as separate WMS layers using !GeoServer & !GeoWebCache.[[BR]]
+You can use GeoServer's [http://docs.geoserver.org/2.1.3/user/data/sqlview.html SQLView] feature.[[BR]]
+SLD files are attached:
  * [http://eden.sahanafoundation.org/attachment/wiki/UserGuidelinesGISData/gadm_v1_lev0_base_sld.xml L0 Base]
+  * SQL View: SELECT id, name, area, the_geom FROM gis_location WHERE level='L0'
  * [http://eden.sahanafoundation.org/attachment/wiki/UserGuidelinesGISData/gadm_v1_lev0_overlay_sld.xml L0 Overlay]
+  * SQL View: SELECT id, name, area, the_geom FROM gis_location WHERE level='L0'
  * [http://eden.sahanafoundation.org/attachment/wiki/UserGuidelinesGISData/gadm_v1_lev1_overlay_sld.xml L1 Overlay]
+  * SQL View: SELECT id, name, area, the_geom FROM gis_location WHERE level='L1'
  * [http://eden.sahanafoundation.org/attachment/wiki/UserGuidelinesGISData/gadm_v1_lev2_overlay_sld.xml L2 Overlay]
+  * SQL View: SELECT id, name, area, the_geom FROM gis_location WHERE level='L2'
 
 Example [http://eden.sahanafoundation.org/attachment/wiki/UserGuidelinesGISData/geowebcache.xml geowebcache.xml] for GADM attached which provides 3 layers: