topic Re: converting addresses to XY in Data Management Questions

converting addresses to XY

ELTerrell — Fri, 18 Jul 2014 14:19:34 GMT

Hi all,

I am trying to teach myself point density map making. However, I have a little over 600,000 addresses in our county I would need to convert from excel to XY coordinates. I haven't been able to find a way to convert to XY and then back to excel in a very manageable way. Can anyone help me? Please & thank you.

Re: converting addresses to XY

TimWitt2 — Fri, 18 Jul 2014 14:23:25 GMT

Maybe the first part of this will help?

Re: converting addresses to XY

kellenober — Fri, 18 Jul 2014 14:29:22 GMT

The problem is that you have so many addresses to geocode... so at at about $.10 a credit you're looking to pay thousands for geocoding through ESRI.

Re: converting addresses to XY

StevenGraf1 — Fri, 18 Jul 2014 14:34:46 GMT

Do you have access to a roads layer with address ranges so you can create your own locator?

Otherwise as already stated, ArcGIS Online geocoder costs.

You can use other free geocoders such as Google or Bing but they limit your daily input. I think Google allows for 2,500 a day.

If you need more information on creating your own locator, there is plenty of information out there on that: ArcGIS Help 10.1‌

Re: converting addresses to XY

ELTerrell — Fri, 18 Jul 2014 14:47:35 GMT

I do have all the roads however, no address ranges.

Re: converting addresses to XY

StevenGraf1 — Fri, 18 Jul 2014 15:04:32 GMT

Hmm, the only other thing I can think of is if you have access to your MSAG (master street address guide) then you could join your MSAG to your roads layer based on the street name. The MSAG has low and high address ranges. This would at least allow you to geocode your points but wouldn't tell you what side of the road they are on.

This would only work if your MSAG and roads layer street names are 100% the same.

Re: converting addresses to XY

ELTerrell — Fri, 18 Jul 2014 16:37:00 GMT

Ok. I'll try and get in touch with our GIS dept and see if they have the roads with address ranges.

Re: converting addresses to XY

Mapperzmap — Fri, 18 Jul 2014 20:19:10 GMT

Yahoo will still allow 2000 geocodes per day with their placemaker api

Free Non-Commercial YQL Table Usage - YDN‌