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.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+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.