Geocoding Intersections

2235
3
12-26-2013 06:42 AM
Highlighted
New Contributor III
I have Geocoded a accident table  and have gotten somewhat positive results.  The issue I am seeing is that intersections in the table  without a space separating the forward slash will not be searchable.


For Example:   North Carolina Dr/Vermont St will not geocode
However:        North Carolina Dr / Vermont St will geocode properly



How can I properly geocode this list of accidents without manually changing thousands of records within the attribute table. Thanks again
Tags (2)
0 Kudos
3 Replies
Highlighted
MVP Esteemed Contributor
if that intersection is in the table use the field calculator (python parser) to replace the single / with a space wrapped one

>>> "North Carolina Dr/Vermont St".replace("/", " / ")
'North Carolina Dr / Vermont St'
>>>

substitute your fieldname for the example text string shown
0 Kudos
Highlighted
New Contributor III
if that intersection is in the table use the field calculator (python parser) to replace the single / with a space wrapped one

>>> "North Carolina Dr/Vermont St".replace("/", " / ")
'North Carolina Dr / Vermont St'
>>>

substitute your fieldname for the example text string shown


Thanks my Canadian friend!
0 Kudos
Highlighted
MVP Esteemed Contributor
No problem...
0 Kudos