topic Re: Geocoding intersections with an offset based on a field with a distance in Data Management Questions

Geocoding intersections with an offset based on a field with a distance

LarisaJohnstone — Thu, 13 Apr 2017 13:55:12 GMT

Hi Folks,

I am trying to geocode some accident collision data (intersection) but each intersection point is defined with an offset distance and direction of the collision. For example: a collision at an intersection of two streets has a field saying that it is, n N (north), 25m, one field has 25 and the other has the N.

Any ideas how I can geocode these intersections with the offset?

Thanks

Larisa

Re: Geocoding intersections with an offset based on a field with a distance

ShanaBritt — Thu, 13 Apr 2017 21:07:31 GMT

Larisa:

It is possible to search for the intersection using a spatial offset, but the input address needs to be in the following format:

[distance] [units] [direction] from [address] for example 25 meters N from juniper st ne & 6th St ne, atlanta

You would need to use the Field Calculator to populate a new field in your table with the spatial offset and intersection addresses using the above format. Then the new field could be used for batch geocoding.

About finding an address—Help | ArcGIS Desktop

About finding an address—ArcGIS Pro | ArcGIS Desktop

Re: Geocoding intersections with an offset based on a field with a distance

JovanaBurz1 — Mon, 24 Apr 2017 18:07:20 GMT

I have tried doing what Shana Britt posted, but it does not work for me. I have tried formatting both in the attribute table and in the geocoding toolbar but it does not do any offsets.

I geocoded the same table using the column that has not been modified first, to get a set of original base points. This is shown as the green point in the image below. Then I geocoded based on the new column that was modified in the following format: [distance] [units] [direction] from [address] as suggested. This is shown as the black triangle in the image below. As you can see, there has not been any offsetting with or without the format applied.

This is the attribute table with the original input (GEOCODE) and with the modified formatting (ADDRESS):

Am i doing something wrong?

Re: Geocoding intersections with an offset based on a field with a distance

NikhilB — Mon, 24 Dec 2018 00:49:51 GMT

Having this exact same issue. Has anyone found a solution? Jovana Burz‌ Shana Britt‌ Larisa Johnstone‌

Re: Geocoding intersections with an offset based on a field with a distance

ShanaBritt — Thu, 27 Dec 2018 23:36:33 GMT

Nikhil:

Did you try my suggestion above? Are you able to provide a small sample of your data?

Re: Geocoding intersections with an offset based on a field with a distance

NikhilB — Fri, 28 Dec 2018 00:37:04 GMT

Hi Shana,

I tried following the format [distance] [units] [direction] from [address] but the default address locator (ArcGIS World Geocoding Service) does not provide the offset location from an intersection.

For example, in San Francisco, I am looking at the intersection of Market St and 7th St. The address locator can identify the intersection, but when I try "100 feet W from Market St & 7th St", the result is just the intersection without an offset.

Any help would be appreciated.

Re: Geocoding intersections with an offset based on a field with a distance

ShanaBritt — Fri, 28 Dec 2018 17:39:46 GMT

Nikhil:

The information above does not apply to the ArcGIS World Geocoding Service, it only applies to address locators that you create using the Create Address Locator tool in ArcMap or ArcGIS Pro. You would have to use your own or commercial reference data to build your own locator to be able to use what I've described above.

Re: Geocoding intersections with an offset based on a field with a distance

Anonymous User — Tue, 21 Jan 2020 09:32:46 GMT

Could anyone figure this out? I am trying to do a similar problem where the location that I have is in reference to intersecting street e.g. 10 meters north of "some street address"?

Re: Geocoding intersections with an offset based on a field with a distance

LarisaJohnstone — Tue, 21 Jan 2020 19:30:06 GMT

NO, I have never found a solution for this.

Re: Geocoding intersections with an offset based on a field with a distance

ShanaBritt — Fri, 24 Jan 2020 09:01:36 GMT

Does searching with the spatial offset work for you in the Find tool or Geocoding Toolbar in ArcMap or the Locate pane in ArcGIS Pro when using a locator you created with the Create Address Locator tool, but does not work when batch geocoding a table?

Re: Geocoding intersections with an offset based on a field with a distance

Anonymous User — Sat, 25 Jan 2020 01:05:57 GMT

For me, it doesn't work on either the toolbar or while batch geocoding. The issue apparently is that ArcGIS World Geocoding Service does not allow offsetting. One has to create there own locator to do offsetting (which seems like an uphill task for a beginner like me).

Re: Geocoding intersections with an offset based on a field with a distance

ShanaBritt — Tue, 28 Jan 2020 06:13:43 GMT

I can get this to work as described in the help using a locator created with the Create Address Locator tool in the Find tool and Geocoding toolbar. Unfortunately, batch geocoding a table is not working with the latest versions of ArcMap. If this is functionality that you need I'd suggest either submitting an Enhancement request through Tech Support or add an ArcGIS Idea.