Research Task - Fix column names for traffic ops routes/stops open data

[tiffanychu90]

Research Task

Use this template to create issues that represent small chunks of work (.5 - 2 days) that stand alone, or represent incremental work as part of an Epic Issue Template.

Previous GH issues: #281, #283, #173, #160

• Relevant PR (if applicable):

• Question or Goal: Address Chad Baker's feedback about open data datasets:

1. agency_id and agency_name seem to be randomly populated -- not randomly populated, but the fact that calitp_itp_id and agency_id / agency_name weren't 1:1 join meant that the multiple names were constructed as a list, then converted to string (ESRI can't take lists in columns).
   Fix: Only use 1 name, drop duplicates. Pick the name that is used in portfolio_utils because that's the agency_name that is displayed in the portfolio, has more visibility.
2. Column names over 10 characters -- this becomes an issue because we go from gdf to ESRI shapefile to file geodatabase. ESRI shapefile is the one with 10 character limit.
   FIx: If possible, use 10 characters. But, also look into way of overwriting the field attributes in the metadata, even if manually done.

• Data Required:

  • Currently have:
  • Need:

• Research Required:

• Metrics:

• Expected Outputs / Findings: Make changes and overwrite open data datasets in this month's updates