Hi,
I am having problem to find a suitable way to normalise Street Name in my geodatabase.
Example of Street Name to be normalised;
Example List of abbrivations to search and replace;
Any idea how to solve it either with a transformer or Python Script.
Many Thanks!
Abdul
Best answer by takashi
Hope this works fine!
# PythonCaller Script Example (Python 2.7 only)
class FeatureProcessor(object):
def __init__(self):
self.map = None
def input(self,feature):
if self.map == None:
search = feature.getAttribute('_map{}.To Search')
change = feature.getAttribute('_map{}.To change')
self.map = zip(search, change)
name = feature.getAttribute('Street Name')
for src, dst in self.map:
name = name.replace(src, dst)
feature.setAttribute('Normalized', name)
self.pyoutput(feature)
# PythonCaller Script Example (works with both Python 2.7 and 3.5)
class FeatureProcessor(object):
def __init__(self):
self.search = None
self.change = None
def input(self,feature):
if self.search == None:
self.search = feature.getAttribute('_map{}.To Search')
self.change = feature.getAttribute('_map{}.To change')
name = feature.getAttribute('Street Name')
for src, dst in zip(self.search, self.change):
name = name.replace(src, dst)
feature.setAttribute('Normalized', name)
self.pyoutput(feature)
Your captures aren't showing, but in general you can use a series of StringReplacer transformers to search and replace text inside e.g. street name attribute.
+49Your captures aren't showing, but in general you can use a series of StringReplacer transformers to search and replace text inside e.g. street name attribute.
Your captures aren't showing, but in general you can use a series of StringReplacer transformers to search and replace text inside e.g. street name attribute.
str-name-and-normalization-list-sample.xlsx
Hi David,
Thanks for your answer but they are so many about 100s and if I do with StringReplacer it will be much work and mess :). we have a python module for this problem from an other collegue but I can not intergrate it into FME because have not worked with Python.
Attach you can find the sample data.
Hope this works fine!
# PythonCaller Script Example (Python 2.7 only)
class FeatureProcessor(object):
def __init__(self):
self.map = None
def input(self,feature):
if self.map == None:
search = feature.getAttribute('_map{}.To Search')
change = feature.getAttribute('_map{}.To change')
self.map = zip(search, change)
name = feature.getAttribute('Street Name')
for src, dst in self.map:
name = name.replace(src, dst)
feature.setAttribute('Normalized', name)
self.pyoutput(feature)
# PythonCaller Script Example (works with both Python 2.7 and 3.5)
class FeatureProcessor(object):
def __init__(self):
self.search = None
self.change = None
def input(self,feature):
if self.search == None:
self.search = feature.getAttribute('_map{}.To Search')
self.change = feature.getAttribute('_map{}.To change')
name = feature.getAttribute('Street Name')
for src, dst in zip(self.search, self.change):
name = name.replace(src, dst)
feature.setAttribute('Normalized', name)
self.pyoutput(feature)
Hope this works fine!
# PythonCaller Script Example (Python 2.7 only)
class FeatureProcessor(object):
def __init__(self):
self.map = None
def input(self,feature):
if self.map == None:
search = feature.getAttribute('_map{}.To Search')
change = feature.getAttribute('_map{}.To change')
self.map = zip(search, change)
name = feature.getAttribute('Street Name')
for src, dst in self.map:
name = name.replace(src, dst)
feature.setAttribute('Normalized', name)
self.pyoutput(feature)
# PythonCaller Script Example (works with both Python 2.7 and 3.5)
class FeatureProcessor(object):
def __init__(self):
self.search = None
self.change = None
def input(self,feature):
if self.search == None:
self.search = feature.getAttribute('_map{}.To Search')
self.change = feature.getAttribute('_map{}.To change')
name = feature.getAttribute('Street Name')
for src, dst in zip(self.search, self.change):
name = name.replace(src, dst)
feature.setAttribute('Normalized', name)
self.pyoutput(feature)
Hope this works fine!
# PythonCaller Script Example (Python 2.7 only)
class FeatureProcessor(object):
def __init__(self):
self.map = None
def input(self,feature):
if self.map == None:
search = feature.getAttribute('_map{}.To Search')
change = feature.getAttribute('_map{}.To change')
self.map = zip(search, change)
name = feature.getAttribute('Street Name')
for src, dst in self.map:
name = name.replace(src, dst)
feature.setAttribute('Normalized', name)
self.pyoutput(feature)
# PythonCaller Script Example (works with both Python 2.7 and 3.5)
class FeatureProcessor(object):
def __init__(self):
self.search = None
self.change = None
def input(self,feature):
if self.search == None:
self.search = feature.getAttribute('_map{}.To Search')
self.change = feature.getAttribute('_map{}.To change')
name = feature.getAttribute('Street Name')
for src, dst in zip(self.search, self.change):
name = name.replace(src, dst)
feature.setAttribute('Normalized', name)
self.pyoutput(feature)
Dear @takashi,
Thanks a lot. It is sort of working.
Dear @takashi,
Thanks a lot. It is sort of working.
Note that the previous script works only with Python 2.7. I added another script that works with both Python 2.7 and Python 3.5
Hope this works fine!
# PythonCaller Script Example (Python 2.7 only)
class FeatureProcessor(object):
def __init__(self):
self.map = None
def input(self,feature):
if self.map == None:
search = feature.getAttribute('_map{}.To Search')
change = feature.getAttribute('_map{}.To change')
self.map = zip(search, change)
name = feature.getAttribute('Street Name')
for src, dst in self.map:
name = name.replace(src, dst)
feature.setAttribute('Normalized', name)
self.pyoutput(feature)
# PythonCaller Script Example (works with both Python 2.7 and 3.5)
class FeatureProcessor(object):
def __init__(self):
self.search = None
self.change = None
def input(self,feature):
if self.search == None:
self.search = feature.getAttribute('_map{}.To Search')
self.change = feature.getAttribute('_map{}.To change')
name = feature.getAttribute('Street Name')
for src, dst in zip(self.search, self.change):
name = name.replace(src, dst)
feature.setAttribute('Normalized', name)
self.pyoutput(feature)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
