• EN
Solved

Using Spatial ETL Tool Combine Multiple GTFS into ArcSDE

H

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

icon

Best answer by lars_de_vries 27 July 2017, 09:21

View original

2 replies

stalknecht
Rank
Userlevel 1
Badge +18
Please share what you have sofar. A workspace and some GTFS example data.

 

 

lars_de_vries
Badge +10

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

28,819
Posts
109,858
Replies
36,638
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.