I am trying to geocode addresses using 911 sites and an excell spreadsheet

786
3
11-09-2014 04:21 AM
JonathanLax
New Contributor

My class project is to map out vacated properties in Providence, RI.  I want to be as accurate as possible, so I am building my address locator from 911 sites shapefile and then geocode the addresses from an Excel spreadsheet.  But I was having a lot of trouble loading the spreadsheet - its seems the connection between the folder where I am storing the spreadsheet and the map is broken!  What am I doing wrong?

0 Kudos
3 Replies
StevenGraf1
Occasional Contributor III

Seems like a strange issue.  I would save your excel document as a csv in a folder that you already have connected inside ArcMap.

Steven

0 Kudos
JonathanLax
New Contributor

Hello Steven - thanks for responding to my question.

Actually I have successfully created the address locator and joined the

data from my spreadsheet.

However, I got a huge number of mismatches: about half of the 1217

properties on the list!

I've manually trying to rematch those properties by checking the addresses

/ zip codes on google maps. That works occasionally - 14 of 55 attempts so

far.

But that means the Interactive Rematch is not finding correct / corrected

addresses / zip codes 41 times.

Its a terribly laborious process. Any suggestions? Do tell.

And my thanks for all you do!

Jonathan Lax

<compass.research.company@gmail.com>

Roger Williams University

<compass.research.company@gmail.com>

School of Continuing Studies Community Development program

<compass.research.company@gmail.com>

jlax315@g.rwu.edu <compass.research.company@gmail.com>

935-7877 <compass.research.company@gmail.com>

0 Kudos
StevenGraf1
Occasional Contributor III

By 911 sites, I assume that's a point shapefile.  Did you create a general address locator from this?  Make sure the addresses in the 911 sites and excel document are formatted EXACTLY the same to get a good geocode.

Steven

0 Kudos