density map

770
3
08-05-2014 06:01 AM
ELTerrell
New Contributor III

I am teaching myself to make a density map of over 600,000 addresses.  The way I know how to do this involves creating a spreadsheet and adding it to the map.  However, I believe excel won't take that many rows.  Is excel the only option?

0 Kudos
3 Replies
DanPatterson_Retired
MVP Emeritus

surely you aren't going to enter this yourself, so what is the format now?  text file of an appropriate format and a variety of others will work

DonOpgenorth
Esri Contributor

I've moved your post into the GIS Managing Data space. You will get a
much better answer here as the
GeoNet Help is intended for community
help and feedback. I have also added in a few additional tags. You can see more
on the community structure, and what topics are under each space from the
following documents:

GeoNet Community Structure

ArcGIS Discussion Forums Migration Strategy

Thanks!

Don

0 Kudos
XanderBakker
Esri Esteemed Contributor

The addresses you have, are they already geocoded? Do you have X, Y coordinates or Latitude, Longitude coordinates?. If not, you should first geocode the addresses. If you already have X, Y coordinates or Lat, Long attributes, you can use Add XY Events to convert the X, Y or Lat, Long values to a geolocation. Note that this information does not need to be in an Excel file.

Once you have your 600.000 points you can visualize them or perform some spatial analysis. It is important to know the difference between a Heatmap visualization and spatial analysis like Point Density or Kernel Density.

Heatmaps are often used in viewer like JavaScript, Silverlight and Flex viewer, or using Maps for Office.

Heat map in esri Maps for Office

http://doc.arcgis.com/en/maps-for-office/help/add-a-heat-map.htm

Hot Spot Analysis Getis-Ord Gi* (Spatial Statistics)

http://resources.arcgis.com/en/help/main/10.2/index.html#/Hot_Spot_Analysis_Getis_Ord_Gi/005p0000001...

Kernel Density (Spatial Analyst)

http://resources.arcgis.com/en/help/main/10.2/index.html#//009z0000000s000000

Point Density (Spatial Analyst)

http://resources.arcgis.com/en/help/main/10.2/index.html#/Point_Density/009z0000000v000000/

Kind regards, Xander