topic Re: geocoding error in ArcMAp in New to GIS Questions

geocoding error in ArcMAp

CaroleWacta — Thu, 07 Jan 2016 01:55:29 GMT

Hello ,

I am having errors trying to geocode this table in arcMAP. Can anyone please look at my excel file and tell me what I am doing wrong?

I have cleaned the file cannot figure out why it would not work in ArcMAP.

Thank you.

Carole

Re: geocoding error in ArcMAp

DanPatterson_Retired — Thu, 07 Jan 2016 02:01:18 GMT

what doesn't work? although I did see some cells that lack entries and the odd spot where the city name got shifted over a column.

Are there error messages? a poor match count? what geocode settings did you use?

Re: geocoding error in ArcMAp

RebeccaStrauch__GISP — Thu, 07 Jan 2016 02:12:38 GMT

My guess is some of the characters you have within the address field (and possibly the Name field) are the issue.

Try removing the "#" signs in the address (e.g. 11215 Abercorn St #2 and Tailte Sports Bar & Grill )

EDIT...oh, and apostrophes Casimir's Lounge

EDIT2: and the first two records have space(s) before the city name

I haven't done a whole lot of geocoding, but those are red flags in my book.

Re: geocoding error in ArcMAp

TimOrmsby — Thu, 07 Jan 2016 03:52:33 GMT

Hi,

1) What errors are you having exactly?

2) Are you using the ArcGIS Online World Geocode Service (signed in to ArcMap through ArcGIS Online) or are you using your own geocoding locator and street data?

I geocoded the xlsx you attached from ArcMap using the ArcGIS Online World Geocode Service. I didn't get any errors. I got 88 matches and 3 ties. The ties were caused by mistakes or ambiguous notation in the address data. For example, the Minglz location has "6 teway Blvd E" in the address field, which is a bad address.

I don't think any geocoding problems are caused by characters like # and &. Not in the address data and definitely not in the Name field, which isn't used in address matching.

Re: geocoding error in ArcMAp

CaroleWacta — Thu, 07 Jan 2016 10:07:02 GMT

It just says an error happen while geocoding addresses. I am using the geocoding in ArcMap(first option)

Here are my steps

Here are the steps I followed:

1. Right-click Pubs table > Geocode Addresses

2. Choos an Address Locator to use > World Geocode Service (ArcGIS Online)

3. Sign in to ArcGIS Online (if necessary)

4. Geocode Addresses dialog box settings:

· Address Input Fields > Multiple Fields option

o Address: Address

o Neighborhood:

I will try cleaning the address field and running it again.

Thank you

Sent from my iPhone

Re: geocoding error in ArcMAp

CaroleWacta — Thu, 07 Jan 2016 10:10:38 GMT

I was using ArcMap. I will try it in Gis online then.

Are the steps the Same? I have never geocoded in GISONLINE

Thank you so much Tim.

Sent from my iPhone

Re: geocoding error in ArcMAp

CaroleWacta — Thu, 07 Jan 2016 10:13:39 GMT

Oh I read your answer wrong Tim.

So do you think then that the issue is computer related? Because I tried few times and it says geocoding encountered error. And that all I get.

Tks a lot

Sent from my iPhone

Re: geocoding error in ArcMAp

CaroleWacta — Thu, 07 Jan 2016 13:43:23 GMT

Tim, I am attaching the error message.

I am doing geocoding in ArcMap. Using the GisOnline geocoding and exactly the steps that you had sent me earlier.

1. Right-click Pubs table > Geocode Addresses

Chose an Address Locator to use > World Geocode Service (ArcGIS Online)
Sign in to ArcGIS Online (if necessary)
Geocode Addresses dialog box settings:

Address Input Fields > Multiple Fields option
- Address: Address
- Neighborhood: <None>
- City: City
- Subregion: <None>
- Region: State
- Postal: ZIP
- PostalExt: <None>
- Country: <None>

Now I am thinking that this has something to do with my settings... What do you think?

I did geocode over 9000 addresses a week ago and it went smooth...

I am not sure what this means...

Thank you again

Re: geocoding error in ArcMAp

TimOrmsby — Mon, 11 Jan 2016 17:12:10 GMT

Those settings seem right. I'm not sure what's causing your problem. You might want to get in touch with Esri technical support. They could do a better job of troubleshooting it. In the meantime, attached is a shapefile of the geocoding results I got with your file. As I said, three of the locations may not have correct matches. One for sure doesn't because it's in China. The other two may or may not be correct--you can probably tell by looking at the points. If you want to try rematching these addresses, add the shapefile to ArcMap, add the Geocoding toolbar, and click the Review/Rematch Addresses button. In the Interactive Rematch dialog box, set the Show results drop-down list to Matched Addresses with Candidates Tied. That will pick out the three problem cases. For those cases, you have the option either of correcting the address in the Address window or picking the right location from the list of candidates.

Tim

Re: geocoding error in ArcMAp

CaroleWacta — Tue, 12 Jan 2016 01:29:33 GMT

Tim,

I can not see an attachment ,

Could you please resend it for me?

Thank you

Best.

Christine

Re: geocoding error in ArcMAp

DanPatterson_Retired — Tue, 12 Jan 2016 01:48:41 GMT

do not respond to a link or try to find attachments in your mailbox...simply click on the title of the thread to go to the actual thread you started and Tim's attachment will show Geocoding_Result_Pubs.zip

Re: geocoding error in ArcMAp

CaroleWacta — Tue, 12 Jan 2016 01:59:33 GMT

Tim,

Thank you so much.

Yes, I tried so many times and I now think that the software is giving me some glitch....

I now know that I am doing nothing wrong...

I will contact ESRI and see what they can do...

On a side note:

I registered as GeoMENTOR and have talked to a middleschool who is willing to get on the ConnectED program and I will be working with them through Esri pre-created courses,,,

Do you happen to know who I should talk to at ESRI to get someone to help the school set up their account and get free software?

Very new at this and excited to get out there and learn with the kids..

have a great day.

Christine

Re: geocoding error in ArcMAp

CaroleWacta — Tue, 12 Jan 2016 02:12:45 GMT

Tks

Sent from my iPhone

Re: geocoding error in ArcMAp

ShanaBritt — Mon, 25 Jan 2016 16:37:02 GMT

Carole:

I have checked out the information you have provided and the responses in this thread and wanted to know what the name of the geocode result was and the data format, as well as, the version of ArcGIS Desktop you are using when the error was returned. I'm also curious to know if you receive the same or similar error when using the Geocode Addresses tool from ArcToolbox > Geocoding toolbox and use the World locator from the Ready-to-use-services > Geocoding in ArcCatalog when singed into ArcGIS Online.

You may also want to try to save the spreadsheet as a csv file and geocode it in ArcMap. I did not getting errors geocoding the spreadsheet you uploaded in ArcMap either.

-Shana

Re: geocoding error in ArcMAp

ElleHolbrook — Fri, 20 Apr 2018 21:28:29 GMT

Hi Shana,

I'm also having this same issue. I followed the same steps and get the error "There was an error trying to process this table." The only difference with my file is that I don't have addresses and am geocoding by zip code only.

I tried using the ArcToolbox > Geocoding option and based on the more detailed error paths produced there I think it's an issue with using the online geocoder; I have ArcMap 10.6 as part of my university's subscription, but I'm not sure I have access to the ArcGIS World Geocoding Service or ArcGIS Online. When I follow links to sign up for a trial, though, it takes me to the same screen where I downloaded ArcMap so I'm not sure how to proceed.

Any help you can provide would be great, thanks!

Re: geocoding error in ArcMAp

KoryKramer — Wed, 25 Apr 2018 13:40:25 GMT

Hi Elle Holbrook‌. When you say that the trial takes you to an ArcMap download, what link is that? The trial page is Free Trial of ArcGIS You should be able to use that to start a trial, which would give you your own ArcGIS Online organization account and some credits to use for geocoding, but since you're at a university, you shouldn't have to do that. Please contact the person at your university who provides you with the software download and license code. That person should know how to add you as a member of an ArcGIS Online account. To batch geocode, you will need to be a member of an ArcGIS Online organization and have credits allocated to you. See Working with the ArcGIS Online World Geocoding Service—Help | ArcGIS Desktop for more info.

In your specific use case of geocoding to zip code only, you could go get zip code point or polygon data and join your table to the feature class table based on the zip code field. If this results in a 1:M join and you're working in a file geodatabase, you won't actually see every record, but if you export to shapefile, they'll all be there. This has to do with the different ways that file gdb and shapefile manage the data and is explained more here: About joining and relating tables—Help | ArcGIS Desktop in the One-to-many section.

Note that if you were to do the same thing in ArcGIS Pro, the table will display all records, duplicating the OID. So there is an option to move forward with your analysis even without geocoding.

I hope this helps.

Re: geocoding error in ArcMAp

ElleHolbrook — Wed, 25 Apr 2018 16:22:45 GMT

Hi Kory,

I've already gotten the trial of ArcGIS through my university, so I have ArcMap 10.6 installed on my computer. But when I tried to do the geocoding for these data the error messages I got made it seem like I don't have access to the ArcGis Online subscription, which is why I was trying to access that via a free trial.

I did end up getting a .shp of the zip code borders and headed down the path of joining or relating that to my data points. However, I do have a 1:M situation so I'm not sure how to proceed. Ultimately I want to map each of my data points in ArcMap. I ran a relate between the zip code .shp and my data points, but my data file doesn't have an ObjectID field so when I open the .shp attribute table and click on "Related Tables" up top, the relate is greyed out and I can't click it. I found another post about the same issue (https://community.esri.com/thread/103332 ) but I'm not sure how to do what the answer to this post says to do.

Do you have any advice on how I can proceed with this? I just want to map my data points, which are stored as zip codes for each case number in an Excel file (so not a geodatabase) as points on a shape file of the state.

Thanks!

Re: geocoding error in ArcMAp

KoryKramer — Wed, 25 Apr 2018 16:36:01 GMT

Well if you have many records for individual zip code points, how do you want to "map those out"? Just using points won't show anything because those points will be stacked on top of each other - i.e. there may be 10 points, but you only see one. So essentially what you'll want to do is get a count of how many points there are per zip code polygon ( Spatial Join—Help | ArcGIS Desktop ) and then symbolize the polygons based on the count.

Re: geocoding error in ArcMAp

ElleHolbrook — Thu, 26 Apr 2018 13:26:16 GMT

I assumed I could just jitter the points so they don't overlap, like other programs allow you to do. Is that not something ArcMap can do?

Re: geocoding error in ArcMAp

KoryKramer — Thu, 26 Apr 2018 13:30:48 GMT

How to scatter stacked or clustered marker symbols for point features