Loader_Generate_Nation_Script — Generates a shell script for the specified platform that loads in the county and state lookup tables.
text loader_generate_nation_script(
text os)
;
Generates a shell script for the specified platform that loads in the county_all
, county_all_lookup
, state_all
tables into tiger_data
schema. These inherit respectively from the county
, county_lookup
, state
tables in tiger
schema.
It uses unzip on Linux (7-zip on Windows by default) and wget to do the downloading. It uses Section 4.4.2, “shp2pgsql: Using the ESRI Shapefile Loader” to load in the data.
It uses the following control tables tiger.loader_platform
, tiger.loader_variables
, and tiger.loader_lookuptables
to control the process and different OS shell syntax variations.
loader_variables
keeps track of various variables such as census site, year, data and staging schemas
loader_platform
profiles of various platforms and where the various executables are located. Comes with windows and linux/unix. More can be added.
loader_lookuptables
each record defines a kind of table (state, county), whether to process records in it and how to load them in. Defines the steps to import data, stage data, add, removes columns, indexes, and constraints for each. Each table is prefixed with the state and inherits from a table in the tiger schema. e.g. creates tiger_data.ma_faces
which inherits from tiger.faces
Availability: 2.1.0
If you were running |