Skip to main content
Solved

Split a range address in multiple list addresses

  • September 12, 2016
  • 6 replies
  • 48 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

View original
Did this help you find an answer to your question?

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+17
  • 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+17
  • Supporter
  • September 12, 2016
itay wrote:

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+44
  • Safer
  • September 13, 2016
rudy_v wrote:

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.

 

 


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