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
Solved
Using Spatial ETL Tool Combine Multiple GTFS into ArcSDE
Best answer by lars_de_vries
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.
+10Hi @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
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.