service_id not necessarily numeric

[stationstops]

service_id is not necessarily numeric (example: 'weekday')

FIX:

1. Switch to varchar(50) in sql files where service_id defined
2. implement following diff in build_indices.py:

33c33

< service_id = int(row[0])

    service_id = row[0]

36c36

< sql = "UPDATE calendar SET start_date_timestamp=%d, end_date_timestamp=%d WHERE service_id=%d AND start_date='%s' AND end_date='%s'" % (convert_date_string_to_timestamp(start_date), convert_date_string_to_timestamp(end_date), service_id, start_date, end_date)

    sql = "UPDATE calendar SET start_date_timestamp=%d, end_date_timestamp=%d WHERE service_id='%s' AND start_date='%s' AND end_date='%s'" % (convert_date_string_to_timestamp(start_date), convert_date_string_to_timestamp(end_date), service_id, start_date, end_date)

52c52

< service_id = int(row[0])

    service_id = row[0]

54c54

< sql = "UPDATE calendar_dates SET date_timestamp=%d WHERE service_id=%d AND date='%s'" % (convert_date_string_to_timestamp(date), service_id, date)

    sql = "UPDATE calendar_dates SET date_timestamp=%d WHERE service_id='%s' AND date='%s'" % (convert_date_string_to_timestamp(date), service_id, date)

[gjtorikian]

This is also true of trip_id and stop_id in stop_times. For an example of this (non-int) value, see the BART GTFS feed.