search

mattwigway / gtfsrdb

GTFSrDB is a tool to archive gtfs-realtime data to a database.
56 stars 24 forks source link

Fields in alerts are condensed, sometimes dropping information #3

Open mattwigway opened 13 years ago

mattwigway commented 13 years ago

When there is more than one TimeRange in an alert, only the first is used. When there is more than one language available, the language specified on the command line or the string with no language (i.e., the default language for the feed) is used.

This is a tradeoff between creating more tables (to hold repeated elements), placing ugly, difficult to query JSON in the database, or losing some data.

mattwigway commented 11 years ago

To really use third-normal form, like GTFS, additional tables for TimeRange and a message table should be created.