link geocoded coordinates with date ranges to cooresponding census tracts from the appropriate vintage

Docker Build Status GitHub Latest Tag

DeGAUSS example call

If my_address_file_geocoded.csv is a file in the current working directory with coordinate columns named lat, lon, start_date, and end_date, then

docker run --rm -v $PWD:/tmp degauss/st_census_tract:0.0.3 my_address_file_geocoded.csv

will produce my_address_file_geocoded_st_census_tract_v0.0.3.csv with an added columns named census_tract_vintage and census_tract_id.

geomarker methods

Input data must have columns called lat and lon containing the latitude and longitude, respecitvely, as well as start_date and end_date specifying a date range over which tract-level geomarkers will be assessed. The date range will be used to assign a census tract vintage, ranging from 1970 to 2020 by decade. If you do not have temporal data and wish to use the 2010 tract or block group boundaries, you can utilize the census_block_group DeGAUSS container.

After the vintage is assigned, the latitude and longitude will be overlayed within a tract to assign a census tract identifier from the appropriate decade.

If the date range spans two census decades, the result will contain one row per decade. For example,

id lat lon start_date end_date
1234 39.15852 -84.41757 2019-12-27 2020-01-03

would become

id lat lon start_date end_date census_tract_vintage census_tract_id
1234 39.15852 -84.41757 2019-12-27 2019-12-31 2019 39061005400
1234 39.15852 -84.41757 2020-01-01 2020-01-03 2020 39061027600

where a 2019 tract identifier is assigned to the first row, and a 2020 tract identifier is assigned to the second row.

geomarker data

DeGAUSS details

For detailed documentation on DeGAUSS, including general usage and installation, please see the DeGAUSS homepage.