Skip to main content
  • EN

I am trying to combine roughly 50 different GTFS feeds (a feed is composed of 13 CSV/txt files) into ArcSDE using the spatial ETL tool. I need to update the stop_id field in each of the csv text files to continue the stop_id sequence that of the agency table in the SDE. Basically i need to remove and match the Stop id from the incoming feed to the stop id sequence in the SDE. I am very new to spatial ETL i have only been using it one day so please bear with me if i am not making much sense as this is very new to me

Please share what you have sofar. A workspace and some GTFS example data.

 

 

Hi @holtstephenw,

Sounds to me like you want to have to readers, one for your ArcSDE dataset and one for your GTFS feeds (probably a CSV reader). If you want to merge both, you can use a FeatureMerger for that. A TestFilter transformer will allow testing and removing features from your data flow.

Since you state you are really new, I would recommend to follow a training course or at least look at some tutorials e.g. on the FME Channel on YouTube and look into some tutorials.

I hope this helps for you.

 

Reply


Community Stats

30,185
Posts
114,572
Replies
37,848
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.