Transit Layer

Transit Layer Resources

Current

Repo

• https://github.com/hackforla/food-oasis-transit

Data Sources

• https://gis.data.ca.gov/
  • California Transit Routes API explorer
  • California Transit Routes - this dataset requires cleaning before use (see cleaning list).

    • Cleaning List

      • for lines that don't have transit agencies (something we noticed when we looked at csv), we will need to properly associate them with their transit agency
      • When lines are not properly showing on the map (see Steps_For_Mapping_County_routes) documentation, figure out how we will fix
      • Removing data for lines that do not intersect with LA County to reduce the size of data set
      • identify which transit agencies that appear in LA_County_Transit_Agencies(5-6-25) are not in the California state data (e.g., Compton Renaissance transit)

    • It contains the following file formats:

      CSV

      Downloaded CSV file into California_Transit_Routes_With_County on 2025-05-06 (added column L: Manually added Counties). The way the CSV works is that it has "shape_id" s associated with Transit agencies which you can then use to identify which shape files are relevant. For example

      OBJECTID	org_id	agency	route_id	route_type	route_name	shape_id	n_trips	base64_url	Shape_Length
      245	recPnGkwdpnr8jmHB	Los Angeles County Metropolitan Transportation Authority	108-13183	3	MARINA DEL REY - PICO RIVERA VIA SLAUSON AV	1080450_JUNE24	3	aHR0cHM6Ly9naXRsYWIuY29tL0xBQ01UQS9ndGZzX2J1cy9yYXcvbWFzdGVyL2d0ZnNfYnVzLnppcA==	0.261591

    • Shape File

    • GeoJSON

    • KML

    • File Geodatabase

  • Bus Stop Benches Data
• Spreadsheet: LA_County_Transit_Agencies(5-6-25)

Data

• [REPLACE with any data uploaded to the repo]

Scripts

• [REPLACE with any scripts used]

---

History

The following is information about FOLA's partnership with CSULB, between 2025-04-04 and 2025-05-19, and the resources that were created during this partnership

FOLA & GEOG 482/582 Project

As part of our community partnership, Hack for LA's Food Oasis project partnered with CSULB’s GEOG 482/582 course. Read more about it:

• Project Overview
• Class information

Resources

• Folders

  • FOLA Shared Google Drive Folder: GEOG 482/582 - 2025- Q2, Project Work

• Repo

  • fola-geog-482-582

• Forms

  • Sign Up Form - Edit
  • Sign Up Form - Responses

• Issues Assigned to Student

  • Create Jupyter Notebook and write Python scripts
  • Review data set for California Transit Routes
  • Gather data sets: Bus Routes: Los Angeles County
  • Prework: Edwin Arguello

• Created By Student

  • Steps_For_Mapping_County_routes
  • California_Transit_Routes_With_County.csv
  • Bus_routes&stops.ppkx
  • Google Colab File: Data Cleaning Script This script downloads two Google Sheets as CSVs — one with LA_County_Transit_Agencies(5-6-25), and one with California_Transit_Routes_With_County. It checks each route’s agency name to see if it matches a known agency or city from the LA County list. If it matches, it labels the route as "Los Angeles" in a new County column; otherwise, it labels it "Unknown". Finally, it saves the updated routes to a new CSV file.

• Tutorials/Help

  • Intro to Data Analysis With Python - Jupyter Notebooks
  • ArcGIS: Select features by location