Skip to main content
Solved

Split a range address in multiple list addresses

  • September 12, 2016
  • 6 replies
  • 68 views

rudy_v
Contributor
Forum|alt.badge.img+6

Hi,

I want to split an address which are in range (from-to) example 12-24 Collins Street, into separate

attributes:

12 Collins Street

14 Collins Street

16 Collins Street

18 Collins Street

20 Collins Street

22 Collins Street

24 Collins Street

I thought of doing it with a pythoncaller, but could get it to work well

Any suggestions

Best answer by rudy_v

All of the above solutions above worked for me. Great work all of you.

We use this kind of address splitting and matching all the time. Previously i did the splitting in Access with code and later in SQL, but it is much easier in FME running on server

I will use this in my GeoCoding service, probably build a custom transformer

I would like to accept all 3, but it seems you can only have 1

Rudy

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.

6 replies

Forum|alt.badge.img+5
  • September 12, 2016

I believe this can be done without resorting to Python. I've had a quick look at it and I think I have a possible solution using AttributeSplitters and a Cloner. It works for the example you provided. I've attached an example workspace. Let me know if this is what you were looking for!


itay
Supporter
Forum|alt.badge.img+18
  • Supporter
  • September 12, 2016

Hi,

I agree with @kim, python is not necessary, but probably can provide a solution.

I have attached my take on it, which is 100% FME....

Hope this helps,createadressrange.fmw


Forum|alt.badge.img+7

Hi @rudy_v,

 

This question can indeed be solved using Python but there is also a pure FME option. My suggestion can be found below. If you would like to use Python anyway, just let us know and we will help you with that!

 

The used method in the workspace below is calculating the range, the number of addresses to add, afterwards you clone the feature and update the address field.

Good luck!

workspace-addressranges.fmw


itay
Supporter
Forum|alt.badge.img+18
  • Supporter
  • September 12, 2016

Hi,

I agree with @kim, python is not necessary, but probably can provide a solution.

I have attached my take on it, which is 100% FME....

Hope this helps,createadressrange.fmw

Workspace

 

 


rudy_v
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • Best Answer
  • September 12, 2016

All of the above solutions above worked for me. Great work all of you.

We use this kind of address splitting and matching all the time. Previously i did the splitting in Access with code and later in SQL, but it is much easier in FME running on server

I will use this in my GeoCoding service, probably build a custom transformer

I would like to accept all 3, but it seems you can only have 1

Rudy


mark2atsafe
Safer
Forum|alt.badge.img+59
  • Safer
  • September 13, 2016

All of the above solutions above worked for me. Great work all of you.

We use this kind of address splitting and matching all the time. Previously i did the splitting in Access with code and later in SQL, but it is much easier in FME running on server

I will use this in my GeoCoding service, probably build a custom transformer

I would like to accept all 3, but it seems you can only have 1

Rudy

True - there can be only one! So I accepted your answer. I'll just mention that there is a geocoder transformer in 2017 now, that connects to a whole bunch of different services. You'll still need the address splitting you asked about, but perhaps it will help with the following geocoding.