nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

converting addresses to XY

ELTerrell

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.

Encuentra más publicaciones etiquetadas con

Accepted answers

StevenGraf1

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.

All comments

Mapperzmap

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

Free Non-Commercial YQL Table Usage - YDN‌

ELTerrell

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

StevenGraf1

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

ELTerrell

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

StevenGraf1

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‌

kellenober

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.

TimWitt2

Maybe the first part of this will help?

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.