Contents
What does the Tiger schema do in PostGIS?
The script builds a schema called tiger to house all the tiger related functions, reusable lookup data such as road type prefixes, suffixes, states, various control tables for managing data load, and skeleton base tables from which all the tiger loaded tables inherit from.
Which is the schema for census data in PostGIS?
Another schema called tiger_datais also created which houses all the census data for each state that the loader downloads from Census site and loads into the database. In the current model, each set of state tables is prefixed with the state code e.g ma_addr, ma_edgesetc with constraints to enforce only that state data.
How to enable the extension in the PostGIS database?
For instructions on how to enable the extension in your database and also to load data using it, refer to Section 2.9.1, “Tiger Geocoder Enabling your PostGIS database: Using Extension”. If you are using tiger geocoder (tiger_2010), you can upgrade the scripts using the accompanying upgrade_geocoder.bat / .sh scripts in extras/tiger.
How to generate a state script in PostGIS?
Loader_Generate_Script— Generates a shell script for the specified platform for the specified states that will download Tiger data, stage and load into tiger_dataschema. Each state script is returned as a separate record. Latest version supports Tiger 2010 structural changes and also loads census tract, block groups, and blocks tables.
Where can I find Chapter 13 of PostGIS?
Tiger Geocoder This chapter documents features found in the extras folder of the PostGIS source tarballs and source repository. These are not always packaged with PostGIS binary releases, but are usually plpgsql based or standard shell scripts that can be run as is. 13.1. Tiger Geocoder Abstract
When do the Tiger Line shapefiles come out?
The core TIGER/Line Files and Shapefiles do not include demographic data, but they do contain geographic entity codes (GEOIDs) that can be linked to the Census Bureau’s demographic data, available on data.census.gov. All legal boundaries and names are as of January 1, 2020. Released February 2, 2021.