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

Timestamp:

06/18/11 21:57:26 (13 years ago)

Author:

Fran Boon

Comment:

--

UserGuidelines/GIS/Data

@@ -251 +251 @@
 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
+rm -rf CSV2
+rm -rf CSV3
+# Fix encodings! http://ww.gadm.org/node/287
+python utf8.py
 su postgres
-createuser -s -P gadm
-# Mixed encodings! http://ww.gadm.org/node/287
-createdb -O gadm -E SQL_ASCII gadm -T template0
-createlang plpgsql -d gadm
-psql -d gadm -f /usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sql
-psql -d gadm -f /usr/share/postgresql/8.4/contrib/postgis-1.5/spatial_ref_sys.sql
-shp2pgsql -s 4326 -I gadm1_lev0.shp public.gadm1_lev0 | psql -d gadm
-shp2pgsql -s 4326 -I gadm1_lev1.shp public.gadm1_lev1 | psql -d gadm
-shp2pgsql -s 4326 -I gadm_v1_lev2.shp public.gadm1_lev2 | psql -d gadm
+pgloader
 }}}
 ==== Configure !GeoServer ====