# Bash script to dump geoscrub_input table (created by AMK) from the

# vegbien database, and load it into the geoscrub database (i.e., the

# postgis database prepped with geonames.org data, GADM2 data, and

# associated mapping tables).

#

# Won't be necessary if we end up injecting all of the geoscrubbing and

# geovalidation functionality directly into vegbien itself. And if we

# end up implementing this stuff as a standalone service instead, we'd

# need to rethink (and generalize) how the input data is handled. But

# for now, this should at least serve as a placeholder that could be

# tweaked manually to load any arbitrary geoscrub input data table.

#

# Jim Regetz

# NCEAS

# Created Nov 2012

# dump distinct records from vegbien

psql --host vegbiendev -U bien vegbien \

    -c 'COPY "public.2012-11-04-07-34-10.r5984".geoscrub_input

    TO STDOUT

    WITH CSV' > geoscrub-corpus.csv

# generate table

psql -c \

   'CREATE TABLE vegbien_geoscrub (

        country text,

        stateProvince text,

        county text,

        decimalLatitude double precision,

        decimalLongitude double precision

    )' geoscrub

# load

psql -c "COPY vegbien_geoscrub FROM '$DATADIR/geoscrub-corpus.csv' WITH CSV" geoscrub