cal-itp / data-infra

Cal-ITP data infrastructure
https://docs.calitp.org/data-infra
GNU Affero General Public License v3.0
48 stars 13 forks source link

Crosswalk to MobilityDatabase data #13

Open e-lo opened 3 years ago

e-lo commented 3 years ago

Ability to join information from the MobilityDatabase to information in CT Data Warehouse.

MobilityDatabase.org should be the canonical source of things like:

  1. Transit providers
  2. Transit route names
  3. Relationships between Transit Providers and GTFS feeds
  4. Relationships between stop_id in a GTFS feeds and canonical station/stop names (aka shared identifiers / aliases)
  5. Relationships between GTFS feeds such as transfer fares.

Mobility Database is implemented using WikiBase and managed by MobilityData.

mcplanner-zz commented 3 years ago

@e-lo can you say more about this? Is this just a matter of picking the right agency IDs?

atvaccaro commented 1 year ago

@lauriemerrell this is done right?

atvaccaro commented 1 year ago

ah I'm mixing up airtable transit database and the mobility database CSV

lauriemerrell commented 1 year ago

Yeah no this is separate. However I think that this still might be obsolete, could check with @e-lo because MD has changed their product direction on the database significantly.