topic Re: Geocoding Intersections in Data Management Questions

Geocoding Intersections

JonahWaterman — Thu, 26 Dec 2013 14:42:59 GMT

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

Re: Geocoding Intersections

DanPatterson_Retired — Thu, 26 Dec 2013 15:16:22 GMT

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

Re: Geocoding Intersections

JonahWaterman — Thu, 26 Dec 2013 17:32:54 GMT

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!

Re: Geocoding Intersections

DanPatterson_Retired — Fri, 27 Dec 2013 00:43:57 GMT

No problem...