Is this your street address?

    Card

    ···· ···· ···· 4242
    Test card

    05/18

    Card

    Use a different card?

    Card

    pp paypal

    or pay with

    We do not keep any of your sensitive credit card information on file with us unless you ask us to after this purchase is complete.

    or pay with

    Please confirm your location:
    Your card will be charged .

    Thank you!

      Gumroad Library

      Download from the App Store or text yourself a link to the app

      Download from the App Store or text yourself a link to the app

      Send SMS
      Nevermind

      $44.95

      GTFS + GTFS-realtime Book Bundle


      Save $5 by buying both books together!


      Book 1 - The Definitive Guide to GTFS

      Learn all about the General Transit Feed Specification (GTFS) and how to consume open public transportation data, including:

      • All about the structure of a GTFS feed
      • How to import a GTFS feed to an SQL database and perform queries
      • How to search for trips, handle blocks and calculate fares
      • Techniques for optimizing a GTFS database in order to minimize resource usage on mobile phones (such as on iOS & Android devices).

      Download Sample Chapter


      Book 2 - The Definitive Guide to GTFS-realtime

      Learn all about GTFS-realtime and how to complement static schedule data with real-time vehicle positions, trip updates and service alerts, including:

      • All about the structure of a GTFS-realtime feed and the GTFS-realtime specification
      • How to install and use the Protocol Buffers library in order to read or write GTFS-realtime feeds
      • How to import a GTFS-realtime feed to an SQL database alongside a GTFS feed and perform queries
      • How to use GTFS-realtime extensions

      Download Sample Chapter


      Table of Contents (Book 1):

      1. Introduction to GTFS

      2. Agencies (agency.txt)

      3. Stops & Stations (stops.txt)

      4. Routes (routes.txt)

      5. Trips (trips.txt)

      6. Stop Times (stop_times.txt)

      7. Trip Schedules (calendar.txt & calendar_dates.txt)

      8. Fare Definitions (fare_attributes.txt & fare_rules.txt)

      9. Trip Shapes (shapes.txt)

      10. Repeating Trips (frequencies.txt)

      11. Stop Transfers (transfers.txt)

      12. Feed Information (feed_info.txt)

      13. Importing a GTFS Feed to SQL

      14. Switching to Integer IDs

      15. Optimizing Shapes

      16. Deleting Unused Data

      17. Searching for Trips

      18. Working With Trip Blocks

      19. Calculating Fares

      20. Trip Patterns



      Table of Contents (Book 2):

      1. Introduction to GTFS-realtime

      2. Introduction to Service Alerts

      3. Introduction to Vehicle Positions

      4. Introduction to Trip Updates

      5. Protocol Buffers

      6. Consuming Service Alerts

      7. Consuming Vehicle Positions

      8. Consuming Trip Updates

      9. Storing Feed Data in a Database

      10. GTFS-realtime Extensions

      11. Publishing GTFS-realtime Feeds


      Save $5 by buying both books together!


      Each book is also available for individual purchase:


      Sorry, this item is not available in your location.
      Sold out, please go back and pick another option.

      You've purchased this product

      See it in your library

      • You'll get two PDF files of GTFS and GTFS-realtime goodness.
      • Book 1 The Definitive Guide to GTFS
      • Book 2 The Definitive Guide to GTFS-realtime

      Card

      ···· ···· ···· 4242
      Test card

      05/18

      Card

      Use a different card?

      Card

      pp paypal

      or pay with

      We do not keep any of your sensitive credit card information on file with us unless you ask us to after this purchase is complete.

      or pay with

      Please confirm your location:
      Your card will be charged US$44.95.

      Your rental will be available for 30 days. Once started, you’ll have 72 hours to watch it as much as you’d like!

      Thank you!

        Gumroad Library

        Download from the App Store or text yourself a link to the app

        Download from the App Store or text yourself a link to the app

        Send SMS
        Nevermind