nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Fehler bei ‚generate gtfs shapes‘

JackDrost

<\/HEAD>

Hallo, ich erhalte einen Fehler, wann immer ich versuche, ein Werkzeug in der ‚generate gtfs shapes‘ Toolbox (von https:\/\/github.com\/Esri\/public-transit-tools\/tree\/master\/generate-GTFS-shapes) auszuführen. Die Fehler sind: "Fehler beim SQLizing der GTFS-Daten.....sqlite3.ProgrammingError: Falsche Anzahl an Bindungen angegeben. Die aktuelle Anweisung verwendet 9, und es wurden 10 angegeben." Mein Ziel hier ist es, meinen Google Transit Feed / GTFS zu aktualisieren. Insbesondere versuche ich, einen einfacheren Weg zu finden, um „shapes.txt“ zu aktualisieren.<\/P><\/BODY><\/HTML>

Finde mehr Beiträge mit dem Tag

Generate GTFS Shapes

Public transit networks in ArcGIS Pro

Display GTFS in ArcGIS

Accepted answers

MelindaMorang

In your stop_times.txt file, each row has an extra comma at the end. You have 9 headers, but effectively 10 columns of data, even though the last column (after the final comma) has nothing in it.

I'm not sure why my tool isn't handling that situation, but I will update it so it doesn't fail.

A quick and simple fix for you is to just add a dummy column name in your stop_times.txt file:

trip_id,arrival_time,departure_time,stop_id,stop_sequence,stop_headsign,pickup_type,drop_off_type,shape_dist_traveled,junk

The tool will succeed and will ignore the junk column.

All comments

JackDrost

This appears to have worked. I somehow accidentally created that last column in Excel, but it was easy to fix. I cannot thank you enough for your quick response on this!

-Jack

MelindaMorang

In your stop_times.txt file, each row has an extra comma at the end. You have 9 headers, but effectively 10 columns of data, even though the last column (after the final comma) has nothing in it.

I'm not sure why my tool isn't handling that situation, but I will update it so it doesn't fail.

A quick and simple fix for you is to just add a dummy column name in your stop_times.txt file:

trip_id,arrival_time,departure_time,stop_id,stop_sequence,stop_headsign,pickup_type,drop_off_type,shape_dist_traveled,junk

The tool will succeed and will ignore the junk column.

JackDrost

ArcGIS Pro version 2.3.2. And yes, enclosed is a zip file with the GTFS dataset. Thanks for your help with this!

-Jack

google_transit.zip

MelindaMorang

What version of ArcGIS are you using? And is your GTFS dataset available somewhere where I can play with it and run some tests?

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.