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; } } }

‘generate gtfs shapes’ fouten

JackDrost

<\/HEAD>

Hallo, ik krijg een foutmelding telkens wanneer ik probeer een tool uit de ‘generate gtfs shapes’ toolbox (van https:\/\/github.com\/Esri\/public-transit-tools\/tree\/master\/generate-GTFS-shapes) uit te voeren. De fouten zijn: "Fout bij het SQLizen van de GTFS-gegevens.....sqlite3.ProgrammingError: Onjuist aantal bindings opgegeven. De huidige instructie gebruikt 9, en er zijn 10 opgegeven." Mijn doel hier is om mijn Google Transit Feed / GTFS bij te werken. In het bijzonder probeer ik een eenvoudigere manier te vinden om "shapes.txt" bij te werken.<\/P><\/BODY><\/HTML>

Vind meer berichten getagd met

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?

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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