Skip to content
This repository has been archived by the owner on Aug 23, 2020. It is now read-only.

merlos/panatrans-dataset

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

69 Commits
May 2, 2016
Sep 5, 2015
Sep 5, 2015
Sep 5, 2015
Sep 5, 2015

Repository files navigation

Panatrans Dataset

Dataset of the public bus tranportation system of Ciudad de Panamá (Panamá).

About

Panatrans is a collaborative project to allow the users of the panamenian public transport to create a dataset with the information of the stops and routes available in the City of Panama (which is currently inexistent).

This project is based in the premise that open software and open data are the key of innovation.

Related Projects that may interest you:

  1. panatrans-api: API that makes usage of this dataset.
  2. panatrans-web: A javascript web client and editor that makes usage of this API.

Conventions and docs

In our Wiki you can find more about the naming conventions and the status of the dataset. Please, note that we write this documentation in Spanish.

THE Dataset

This dataset is an extreme simplification of the General Transit Feed Specification (GTFS) defined by Google.

Conceptual model of a route

There are 4 types of resources to represent a route (models, data types, objects or whatever you):

  • Stop: Represents a bus stop. Includes a name and the (latitude, longitude) tuple.

  • Route: Represents a bus route, for example: the route from Albrook to Miraflores.

  • Trip: A route generally has one or two trips. For example, the route Albrook - Miraflores has two trips: (1) the trip from Albrook to Miraflores, and (2) the trip from Miraflores to Albrook. Each trip has a set of stops that may be the same or not. There may be some routes that only have a single trip (ie: circular routes or those that start and end at the same location).

  • Stop_Sequence: Links a trip with a stop to create an ordered list of stops. In the example, the trip Albrook to Miraflores has 4 stops, and therefore it has 4 stop_sequences, each one will link one of the stops with that trip. The first stop is Albrook (sequence = 0), then Diablo (sequence = 1), Ciudad del Saber (sequence = 2) and the last one Miraflores (sequence = 3).

These are the formats:

stops.csv

column type Description
id INT Unique identifier of the stop
name STRING Name of the stop
lat FLOAT(latitude) Latitude of the stop location
lon FLOAT(longitude) Longitude of the stop location
created_at DATE Date when the stop was created
updated_at DATE Date when the stop was last updated

routes.csv

column type Description
id INT Unique identifier of the route
name STRING Name of the route
url STRING Web address with more information of the page (usually at mibus.com.pa)
created_at DATE Date when the route was created
updated_at DATE Date when the route was last updated

trips.csv

column type Description
id INT Unique identifier of the trip
headsign STRING Some text to identify the trip
route_id INT Route this trip belongs to
created_at DATE Date when the trip was created
updated_at DATE Date when the trip was last updated

stop_sequences.csv

column type Description
id INT Unique identifier of the stop
sequence INT sequence number of the stop on the trip.
trip_id STRING Id of the trip this sequence links
stop_id INT Id of the stop this sequence links
created_at DATE Date when the stop was created
updated_at DATE Date when the stop was last updated

License

panatrans-dataset is made available under the Open Database License. Any rights in individual contents of the database are licensed under the Database Contents License.

When using panatrans-dataset, credits should be publicly available:

Panatrans-dataset © www.panatrans.org contributors, distributed under Open Database License