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

erreurs « generate gtfs shapes »

JackDrost

<\/HEAD>

Bonjour, je reçois une erreur chaque fois que j'essaie d'exécuter un outil dans la boîte à outils « generate gtfs shapes » (depuis https:\/\/github.com\/Esri\/public-transit-tools\/tree\/master\/generate-GTFS-shapes). Les erreurs sont : "Erreur SQLizing les données GTFS.....sqlite3.ProgrammingError : Nombre incorrect de liaisons fournies. La déclaration actuelle utilise 9, et 10 sont fournies." Mon objectif ici est de mettre à jour mon Google Transit Feed / GTFS. En particulier, j'essaie de trouver un moyen plus simple de mettre à jour « shapes.txt ».<\/P><\/BODY><\/HTML>

Trouver plus de publications taguées avec

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?

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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