Update PHB Data for 1st PHB/Signal Study Data Driven Evaluation

[jaime-mckeown]

• Renee emailed to let me know that they are preparing to kick off the first PHB/signal study data driven evaluation process. She asked if I could update any data that may need updating, i.e. crash data, signals, CSRs, streetlights, schools, churches, schools, parks, etc.
• She also asked about putting the data on AGOL for presenting data.
• Her earliest possible meeting is on 10/19, need to start working on the update now.

[jaime-mckeown]

Emailed Blake at AE for an updated version of the utility pole data.

[jaime-mckeown]

Copy from AGOL into PHB.gdb under Data directory:

• Traffic Signals and Pedestrian Signals
• Traffic Signal and Pedestrian Signal Requests

[jaime-mckeown]

Added new H-E-B located at Congress and Slaughter to Large Retail Locations dataset.

[jaime-mckeown]

Updated Bus Routes with latest cmta bus route data from the open data portal. Many routes have been removed.

[jaime-mckeown]

Pedestrian Crash Fields from CRIS download:

• Crash_ID
• Reported_Road
• Reported_Intersecting_Road
• Intersection_Related
• Manner_of_Collision
• First_Harmful_Event
• Crash_Latitude
• Crash_Longitude
• Crash_Year
• City (don't need field since filtering only Austin Full Purpose)
• Fatal_Crashes
• Suspected_Serious_Injury_Crashes
• Non-Incapacitating_Crashes
• Non_Injury_Crashes
• Possible_Injury_Crashes
• Unknown_Severity_Crashes

Created new process for updating Pedestrian Crashes by getting data from VZ Database. All docs and Project are located under: H:\Documents\ArcGIS\Projects\Vision_Zero_Database

[jaime-mckeown]

Received AE Poles data, created new AE_Streetlights layer.

[jaime-mckeown]

Copied all of the unchanged data to the Data Collection FGDB and ran the scripts. Updated the PHB Data FGDB in the AMD folder and let Renee know.