results.md

#Results Use the links below to perform the tests using Good Tables.

Test using valid data and no schema

• Test agency.txt without a schema
• Test calendar.txt without a schema
• Test calendar_dates.txt without a schema
• Test feed_info.txt without a schema
• Test routes.txt without a schema
• Test shapes.txt without a schema (Hits 30,000 row limit*)
• Test stops.txt without a schema
• Test trips.txt without a schema

Test using valid data with its schema

• Test agency.txt with a schema
• Test calendar.txt with a schema
• Test calendar_dates.txt with a schema
• Test feed_info.txt with a schema
• Test routes.txt with a schema
• Test shapes.txt with a schema
• Test stops.txt with a schema
• Test trips.txt with a schema

Test using invalid data and its schema

• Test invalid agency.txt with a schema
• Test invalid calendar.txt with a schema
• Test invalid calendar_dates.txt with a schema
• Test invalid feed_info.txt with a schema
• Test invalid routes.txt with a schema
• Test invalid shapes.txt with a schema
• Test invalid stops.txt with a schema
• Test invalid trips.txt with a schema

Create test links

The test links call Good Tables using links to the raw data and schema files as input to Good Tables e.g.

• valid data: https://raw.githubusercontent.com/Stephen-Gates/GTFS/master/data/agency.txt
• schema: https://raw.githubusercontent.com/Stephen-Gates/GTFS/master/schemas/agency-schema.json
• invalid data: https://github.com/Stephen-Gates/GTFS/blob/master/tests/agency.txt

The URL passed to Good Tables needs escaped versions of the links above e.g.

• http://goodtables.okfnlabs.org/reports?data_url=https%3A%2F%2Fraw.githubusercontent.com%2FStephen-Gates%2FGTFS%2Fmaster%2Fdata%2Fagency.txt&format=csv&encoding=&schema_url=https%3A%2F%2Fraw.githubusercontent.com%2FStephen-Gates%2FGTFS%2Fmaster%2Fschemas%2Fagency-schema.json

Good Tables issues

• Good Tables supposedly has a 100,000 row limit (see goodtables-web #54) but it appears to be limited to 30,000*
• Good Tables only returns a limited number of errors so the test data will need to be split into smaller sets.
• Good Tables doesn't use the primary key to check for duplicates (see goodtables-web #64)
• Good Tables doesn't handle optional uri fields (see goodtables #109)
• view other goodtables-web and goodtables issues