Revision 11345
Added by Paul Sarando about 11 years ago
| derived/biengeo/geovalidate.sh | ||
|---|---|---|
| 61 | 61 |
# create simplified country polygons |
| 62 | 62 |
psql -c \ |
| 63 | 63 |
"SELECT AddGeometryColumn('public', 'gadm2', 'simple_geom', 4326, 'MULTIPOLYGON', 2 );
|
| 64 |
UPDATE gadm2 SET simple_geom = SELECT st_simplify(geom, 0.001)" geoscrub
|
|
| 65 |
psql -c |
|
| 64 |
UPDATE gadm2 SET simple_geom = (SELECT st_simplify(geom, 0.001))" geoscrub
|
|
| 65 |
psql -c \
|
|
| 66 | 66 |
'CREATE INDEX "gadm2_simple_geom_gist" ON gadm2 USING gist (simple_geom)' geoscrub |
| 67 | 67 |
# ... and create geography versions ... |
| 68 | 68 |
# note workaround to exclude Antarctica because it has an invalid |
Also available in: Unified diff
Fixed a couple of syntax errors in geovalidate.sh.
Fixed a sql syntax error and a bash syntax error in the next line.