missing_required_field additions where network.network_id exists

[mobilitydataio]

Commit Nº 1

AUTHOR × DATE

• Tzu-Jen Chan ( tzujenchanmbd )
• December 5, 2024 @ 12:55 PM ETC (05:55 PM UTC)

MESSAGE

[GTFS-Fares v2] Add fare_leg_join_rules.txt (#439)
* Add Effective Fare Leg to term definition
* Add fare_leg_join_rules.txt
* Modify fare_leg_rules for effective fare leg
* Add from/to_stop_id
* Update file desc for from/to_stop_id
* Editorial updates

FILES CHANGED

google/transit@7be58b0

https://github.com/google/transit/commit/7be58b00bce9955551668d9aa1bf5c8c93e8839a

---

NEW RULE DETAILS

Describe the new validation rules

Related spec language	Rationale for rule	Notice name to update or add	Pseudologic	Notice table columns	Severity	Notice description
networks.network_id, fare_leg_join_rules.from_network_id, fare_leg_join_rules.to_network_id	from_network_id and to_network_id are required	missing_required_field	If the checks for missing_required_column above are complete and do not generate a notice, then: If from_network_id is empty and to_network_id is empty: Trigger Notice and do not check for foreign_key_violation	csvRowNumber, FieldName, Filename	ERROR	A required field is missing. The given field has no value in some input row, even though values are required.
stops.stop_id, fare_leg_join_rules.from_stop_id, fare_leg_join_rules.to_stop_id	from_stop_id and to_stop_id are mutually required	missing_required_field	If (from_stop_id is not empty and to_stop_id is empty) or (from_stop_id is empty and to_stop_id is not empty): Trigger Notice and do not check for foreign_key_violation	csvRowNumber, FieldName, Filename	ERROR	A required field is missing. The given field has no value in some input row, even though values are required.

Sample GTFS datasets

Severity

ERROR

Additional context