Skip to content

Allen County Cross Bores Data Engineering Project for Unearth Labs

Notifications You must be signed in to change notification settings

awshumway/Allen_County_cross-bores

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Allen County Cross-bores

Using raw data and limited information, create an analysis for Allen County, Indiana which includes a map of high-risk streets and a driving route for a field crew.

Source data can be found in /src_data

Mapbox Interactive Map

Interactive Map of Allen County pipe data

Understanding the data

GISMAPSTREET.txt as provided has 15 columns:

Column Name Description
MINORGRIDNAME Minor Grid Name, seems to be a custom name or identifier
STREETNAME Name of the street, such as "Gordon Rd"
ROADDIRECTIONPREFIXCD Prefix road direction, such as N for North
ROADNAME Name of the Road, such as "Gordon"
ROADTYPESUFFIXCD Type of road code, such as ST, RD, LN, etc.
ROADDIRECTIONSUFFIXCD Suffix road direction, such as W for West
LEFTZIPCD Left Zip Code
RIGHTZIPCD Right Zip Code
LOWADDRESSRANGEVALUE Value for the lowest/ first address on the street
HIGHADDRESSRANGEVALUE Value for the highest/ last address on the street
TOWNSHIPNAME Name of the township where the street is located
MUNICIPALITYNAME Name of the municipality in which the township is located
NUMCENTERLINES The number of centerlines found on the street
INTERSECTINGLENGTH Intersecting Length
GEOM_WKT Geometry Well-known text

Street Consequence has 5 columns:

Column Name Description
STATE Address State two-letter code, such as IN
MUNICIPALITY name of the municipality in which the street is located
STREETNAME Name of the street
MINORGRIDNAME Minor Grid Name, custom name or ID?
Street Consequence Consequence associated with the street, greater number = greater consequence

Helpful Mapbox Links

Next Steps

  1. Use a recipe to specify min and max zoom for the tileset to address zoom issues
  2. Improve wrangling code processing time
  3. Add functions to ETL pipeline code to improve readability
  4. Discover why some streets seem to have multiple different consequence values

Notes

Initial test Tileset ID : awshum.75w3tcn9 Full tileset ID : awshum.allen-co-pipes

About

Allen County Cross Bores Data Engineering Project for Unearth Labs

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published