PostgreSQL Database

3dmashup edited this page Feb 22, 2013 · 1 revision

The PostgreSQL database for the Urban Data Challenge comprises

PostgreSQL database and Schema

User Defined Transit Time data type with + - operators and functions to convert between Transit Time and seconds. The Transit Time type represents time from a range of 99 hours 59 minutes 5.999999 seconds to 00 hours 00 minutes 0.0 seconds.

18 Stored Procedure Functions Including Lat/long to UTM conversion. UTM distance functions, and functions to compute speed and distance m/s and m.

The schema includes 20 tables and 3 Views including Country City Transit agency GTFS Routes GTFS Stops GTFS ... Urban Data Challenge Data tables for San Francisco, Geneva and Zurich.

Numerous SQL scripts to load And query the data.