Select to view content in your preferred language

Geocoding Table of Address using Lat/Long Values

1763
4
08-18-2011 06:15 AM
JohnSterritt1
Deactivated User
I'm trying to geocode a table of addresses using their lat/long values in a ArcGIS 10 locator style. The lat/long values return candidates when using the "Find" and "Geocoding Toolbar", but fail when batch geocoding a table, and in the review/rematch dialog.

The goal here is to use a composite locator to first try geocoding to the street address, and fall out to the coordinate if the street address cannot be used. This process is currently done in ArcGIS 9.3 using the Python and a combination of geocoding and XY event themes, but with the enhancements in 10 we are hoping to consolidate this workflow into a composite locator. Is batch geocoding a table of lat/longs currently supported, or is the general rule to still use an XY Event Theme?
Tags (2)
0 Kudos
4 Replies
JohnSterritt1
Deactivated User
Investigating this further I've managed to get a very small percentage (1%) of points to geocode using lat/long values while batch geocoding a table. However, in these instances the geocoder appears to have problems interpreting the lat/long values as they are usually a couple of degrees from their true location.

It also appears to have tried to reverse geocode the lat/long values and bring back a Match Address Value with a house number and address information. The address locator style is US Address - Dual Range, but I have also tried using lat/long with the US Address - Single Address, Single Field, and Gazetter. All reference data has been reprojected to WGS84 to try and avoid translation issues.

The help documentation seems to indicate that if a table is geocoded using lat/long there is a possibility to have the values mapped to an Addr_Type of coordinates. However, I'm not seeing this behaviour - How can I get these results?

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002500000025000000.htm
0 Kudos
JoeBorgione
MVP Emeritus
I guess I'm missing the point of your work flow; if you have records with xy coordinates, how come you need to geocode them?  If your data has an address, and an xy, to me that would be better than relying on an interpolated  match against a range of addresses along a street. That approach sounds like a great way to qa/qc your street data; match the address against your streets and the ones that don't hit (but you can still add as xy events) show you where your problems are. Is that what you're after?
That should just about do it....
0 Kudos
JohnSterritt1
Deactivated User
Here is a little context to the issue. We are mapping occurrences with information coming from two systems the first our Records Management System (RMS), and second the Computer Aided Dispatch System (CAD). The RMS system is updated by our personnel to reflect the address where the occurrence took place, after being dispatch to the location. The CAD system has its information pushed into the RMS system where a coordinate value is updated based on the dispatch location for an occurrence.

In our situation the address having been updated by our personnel, is more accurate than the coordinate, especially considering the occurrence location is not always the same as the dispatch location. For example if a neighbor a couple doors down calls in to report an occurrence, and we used the coordinate coming over from the CAD system the occurrence will be mapped at the neighbors location who placed the call. We want to only use the dispatched location as a secondary option to help fill in the gaps where addresses cannot be geocoded using the address information.

With the improvements to the locators in ArcGIS 10 we have a great opportunity handle this geocode workflow completely within a composite locator, and reduce the processing done using Python and the Geoprocessor. It may also open up additional possibilities such as a setting up a dynamic feature class, and reviewing and rematching our results. This currently is not possible because each geocoding set is processed independently using address locators and xy event layers, with all outputs append together in the end.
0 Kudos
JoeBorgione
MVP Emeritus
Interesting- I do most of my work in CAD and some flavor Public Safety RMS myself; I'm still using 9.3.1 so any of the enhancements in 10.x are foreign to me. 

I'm just curious; where do the actual lat/longs come from?  The CADs I work with assign them as long as the address is verified upon dispatch (it hits).  Of course we still dispatch if the address doesn't verify but since the CAD is (are) address-centric we don't store any history of the call since there isn't an address to assign the incident to.

Perhaps we could carry on this more tangent discussion off line; jborgione at alpinegeographic dot com.
That should just about do it....
0 Kudos