16.4.4. Global Terrorism Database (GTD)¶
This directory provides GTD GeoMesa ingest commands, converter configuration files, and an R script to prepare data from the spreadsheet in which it is distributed.
This work is based on a GTD pull done 2015 December 17. The GTD data distribution is dated June 26, 2015. GTD data is updated annually.
22.214.171.124. Getting GTD data¶
Download the GTD from (http://www.start.umd.edu) via the contact link.
You must fill out a web form. Select the zip file with all data and
unzip this in a convenient directory. This will
result in a number of Excel (.xlsx) spreadsheets and PDF documents.
126.96.36.199. R script¶
The R script extracts the GTD data from the Excel spreadsheets for a selection of the about 150 fields available. The R script expects two arguments. The first is the working directory, which is where the CSV files will be output. The second is the path to the GTD spreadsheet, relative to the working directory.
The R script extracts the data from the main spreadsheet into a
data.frame. The script will then export a subset of columns to a
gtd-include.csv. For convenience, the column names in that file
are printed to
gtd-column-names.csv. Note there are ~160 available
The script then handles some data cleaning that could be dealt with by
the GeoMesa ingest: removing entries with invalid or missing dates and
coordinates. The R script writes this
data.frame to a CSV file
gtd-clean.csv. This step results in about 18% of the data being
dropped from the dataset.
188.8.131.52. Ingest Commands¶
Check that the
gtd simple feature type is available on the GeoMesa tools
classpath. This is the default case.
geomesa env | grep gtd
If it is not, merge the contents of
$GEOMESA_ACCUMULO_HOME/conf/application.conf, or ensure that
reference.conf is in
Run the ingest. You may optionally point to a different Accumulo
-z options. See
geomesa help ingest
for more detail.
geomesa ingest -u USERNAME -c CATALOGNAME -s gtd -C gtd gtd-clean.csv