Skip to main content
Solved

SDE to SHP - Loop through txt file and re-projecting

  • January 25, 2013
  • 1 reply
  • 5 views
Y
Hi All, 

 

 

Just wondering if anyone can help me out. I'm looking at pulling a single SDE layer and re-projecting it through FME workbench. I will be fanning the output dataset by province (BC,AB,SK) and each province will have 2 or 3 projections (LL27,LL83,UTM, etc...) .

 

 

I am trying to figure out the best way to approach this. The SDE layer is large so I know the processing time may suffer a bit. I was thinking about creating a batch process and looping through a .txt file containing a list of provinces & projections to run the workbench. The batch process looks like this:

 

 

BATCH

 

FOR /F "tokens=1,2,3 delims=," %%A IN (reproject.txt) DO fme <workspacename>.fmw --<fme_projection> <projection> --<provincename> <province>

 

 

MY BASIC FME WORKBENCH FLOW:

 

SDE > ATTRIBUTE FILTER >SOME OTHER TRANSFORMATIONS> STRING CONCATINATOR (create file name)>OUTPUT (shp) 

 

 

Any suggestions and/or feedback would be greatly appreciated!

 

 

 

Thanks

 

Best answer by sigtill

If many provinces: Use 2 FME workspaces. The first one for loading the provinces and bounding box. The bounding box and name of province and geometry of province then gets loaded to second workspace to do the processing. This way you can do one workspace per processor. 

 

 

Regarding reprojector you might want to reproject first to the output coordinate system, and then send this bounding box to the second workspace. 
View original
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.

sigtill
Contributor
Forum|alt.badge.img+24
  • sigtillContributor
  • Contributor
  • January 26, 2013
If many provinces: Use 2 FME workspaces. The first one for loading the provinces and bounding box. The bounding box and name of province and geometry of province then gets loaded to second workspace to do the processing. This way you can do one workspace per processor. 

 

 

Regarding reprojector you might want to reproject first to the output coordinate system, and then send this bounding box to the second workspace. 
The real SigTill

Most helpful members this week

Community Stats

30,872
Posts
117,020
Replies
38,692
Members
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.