Small UZA/Rural Area Section 5310 Project Mapping
Problem Statement
Summarize small UZA/Rural Area Section 5310 project by county.
Data Sources
- FY15, FY16, FY17 Small UZA/Rural Area Section 5310 Projects
- California Counties (TomTom m8)
- County Abbreviation Lookup Table
Methodology
Summarized project by county, generating view containing Project County, Project Total, and County Centroid:
- Summarize_Funding_by_County.sql
- Script generates point feature class view through a right join with a sub query, which maintains relationship only with counties where there are proposed investments
- Sub query joins FY15, FY16, FY17 Small UZA/Rural Area Section 5310 Projects to County Abbreviation Lookup Table on County Abbreviations (string based join), grouping by County
Issues:
California County abbreviations don’t match Caltrains abbreviations - County Abbreviation Lookup Table was created to create intermediary join table between California County Polygons and FY15, FY16, FY17 Small UZA/Rural Area Section 5310 Projects