Data

Data is the cornerstone of our work. Whether it is to empower analysis or to inform the public on Transit, data is involved in every decision we make and in every output we produce. When there is a lack of data, we create it.

Greater Cairo Region (GCR)

Public Transport Data

  • Routes: Origin, destination and roads taken by each bus route
  • Stops: Location of virtual bus stops serviced by all routes
  • Mode Coverage:   Includes all formal routes operated or licensed by the CTA. Includes paratransit routes, known as informal routes.  
  • Routes:   Geographic trace of active lines used by the Cairo Metro
  • Stops:      Location of physical stations, with destination by platforms used by each route

Coming soon

Urban Data

  • To download publicly available administrative boundaries of the GCR, we recommend GADM.
  • For more specific and custom needs don’t hesitate to contact us.  
  • For the most recent publicly available population data on Egypt and the GCR, please refer to the Egyptian national statistics agency CAPMAS
  • For geographically distributed models of population contact us.  
  • There are no publicly available datasets on the distribution of employment locations within the GCR. For publicly available aggregate statistics please refer to the Egyptian national statistics agency CAPMAS
  • For geographically distributed models of employment distribution contact us.

Data Formats

GIS

Geographic Information Systems 
Combines the power of a tabular database along with the power of location, enabling spatial analysis.

GTFS

General Transit Feed Specification 
A Transit-specific format aimed for trip planning but is also used for analysis and understanding the transit network’s characteristics

Data Process

Data Collection

Multiple scopes are defined (Geographic, Temporal, etc.) Once the Data Collection strategies and protocols are in place, the actual data collection commences

Data Processing

The Digitization of data is usually the first step in processing. Cleaning is the second step and is not necessarily limited to Quality Assurance, but could also include the different processes that are done to understand the anomalies that the data show. The Data is then usually transformed from GIS Layers to GTFS Feeds.

Data Analysis

Making sense out of the complex data of human interactions and urbanism, especially in Cairo, requires constant innovation in the analysis approaches and techniques. Spatial and network analysis are amongst the many tools that enable us to inform our clients and the public user.

Previous Projects

Greater Cairo Region Digitalization

In the summer of 2019, TfC was contracted by the World Bank to map the formal and informal public transport routes in the Greater Cairo Region. A field team of 19 researchers were hired and equipped with mobile phones and in-house applications. A data pipeline with a high level of automation was developed; reducing manual work and ensuring a high-quality output. GPS traces received from the field were later transferred to GTFS feeds using an in-house tool. For any trip to become part of our final list, it needed to be mapped more than once. Redundancy allowed us to validate itineraries and flag trips that had deviating itineraries. Flagged trips were then mapped again to determine the correct itinerary.
0
Unique Trips Mapped

Mapping the transit network in the Greater Cairo Region started with mapping the New Urban Communities, the satellite cities surrounding central Cairo & Giza. We partnered up with ‘Digital Matatus’ along with Takween Integrated Development to form ‘Digital Cairo’
Between 2017 and early 2018 we managed to map over 90% of the formal and semi-formal transportation network in the NUCs.
The resulting datasets are GIS layers describing the stops and the trips that form the network, along with a GTFS feed for the same network with travel time estimations, enabling research and decision making on a scale and with a level of detail unprecedented.

0
Unique Trips Mapped

FAQs

Datasets published are stored in industry standard GIS and GTFS files:

  1. Geographic Information Systems (GIS)
      • Combines the power of a tabular database along with the power of location, enabling spatial analysis.
      • Could present a visual of our trips network overlayed on a base-map
      • Can be opened by the open-source QGIS or the proprietary ArcMap, as well as other GIS software packages. 
  1.   General Transit Feed Specification (GTFS)
      • A Transit-specific format aimed for trip planning but is also used for analysis and understanding the transit network’s characteristics.
      • To learn more on GTFS we recommend the excellent documentation maintained on Google Developers.
      • GTFS files are composed of a series of text files collected in a ZIP file, and can be opened using any spreadsheet editor such as Microsoft Excel. More advanced use cases are possible using dedicated GTFS consumer applications such as Open-Trip-Planner. 

Almost all digital maps are produced using a GIS. The term GIS is a catch all term for any system that can store, manipulate and display digital map data, they range from powerful desktop systems such as QGIS and Esri’s ArcGIS.

The standard for storing and exchanging map data in the GIS world is the Shapefile. Despite it’s name, a Shapefile is usually made up of four files (although it can be more).

Unfortunately no. Any application or use of the GIS shapefiles that generates revenue through payment, ads or any other form of direct or indirect monetization is prohibited by the Creative Commons CC BY-NC license which the GIS shapefiles use. Please contact us to discuss the option of licensing the data.

Of course you can. However, any software or research produced must be for a non-profit purpose, be shared under Creative Commons CC BY-NC license or other open license and properly attribute the data. We encourage you to explore public transit in Cairo, produce data-driven research papers and graduation projects and share the results to help improve mobility in Cairo.

Please feel free to contact us with your question. Please type ‘QUESTION’ in the e-mail subject.