Changes between Version 164 and Version 165 of UserGuidelines/GIS/Data


Ignore:
Timestamp:
06/18/11 21:57:26 (10 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UserGuidelines/GIS/Data

    v164 v165  
    251251unzip gadm_v1_lev1_shp.zip
    252252unzip gadm_v1_lev2_shp.zip
     253ogr2ogr -f CSV CSV gadm1_lev0.shp -lco GEOMETRY=AS_WKT
     254ogr2ogr -f CSV CSV2 gadm1_lev1.shp -lco GEOMETRY=AS_WKT
     255ogr2ogr -f CSV CSV3 gadm_v1_lev2.shp -lco GEOMETRY=AS_WKT
     256mv CSV2/gadm1_lev1.csv CSV
     257mv CSV3/gadm_v1_lev2.csv CSV
     258rm -rf CSV2
     259rm -rf CSV3
     260# Fix encodings! http://ww.gadm.org/node/287
     261python utf8.py
    253262su postgres
    254 createuser -s -P gadm
    255 # Mixed encodings! http://ww.gadm.org/node/287
    256 createdb -O gadm -E SQL_ASCII gadm -T template0
    257 createlang plpgsql -d gadm
    258 psql -d gadm -f /usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sql
    259 psql -d gadm -f /usr/share/postgresql/8.4/contrib/postgis-1.5/spatial_ref_sys.sql
    260 shp2pgsql -s 4326 -I gadm1_lev0.shp public.gadm1_lev0 | psql -d gadm
    261 shp2pgsql -s 4326 -I gadm1_lev1.shp public.gadm1_lev1 | psql -d gadm
    262 shp2pgsql -s 4326 -I gadm_v1_lev2.shp public.gadm1_lev2 | psql -d gadm
     263pgloader
    263264}}}
    264265==== Configure !GeoServer ====