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; } } }

Geocoding Table with Anonymized Addresses & Lat/Lon

WalidAlmasri1

Hello, I am trying to set up a process to map locations to a street centerline by either an address or or by lat/lon if no address exists or if the address cannot be found. I have created a geocoder that only uses the Street Address Role and have a process set up to change addresses from 1234 N Main to 1200 N Main in an effort to anonymize them. All locations have a lat/lon even if no address exists. The geocoder is configured properly and geocodes the events to the street centerline with the address. The issue I am having is that the geocoder will not locate events by lat/lon where no addresses match can be found. Even if I only specify the geocoder to use the Coordinate System Category in the Geocode Table dialogue box, it will return zero matches.

Just wondering if anyone has any input on how I can geocode based on lat/lon. Everything I've tried seems to not work.

Thanks!

Finde mehr Beiträge mit dem Tag

Accepted answers

Shana Britt

@WalidAlmasri1 If the Address field is the input address field and it contains 'Null' values for the record, there is no input that is geocoded, so the record with a 'Null' value will be unmatched. I would suggest moving the coordinate pair to the address field, by selecting all of the records that have 'Null' values, the using Calculate Field concatenate the Lat and Lon fields into the Address field. [Lon] + ","+ [Lat] Then geocode the table with the locator that has the Coordinates category enabled.

All comments

WalidAlmasri1

@ShanaBritt is there a particular way the data needs to be in order to return the "Addr_type" output field to equal "StreetMidBlock"?

I've actually removed our "Block of" information from the address and now only do the full hundred block address and am having good results, but in areas where ranges are limited, mapping to StreetMidBlock would be helpful as some get missed, but I'm not sure how to return that result from the geocoder. Everything I return is LatLon, StreetAddress or StreetAddressExt no matter how I type using the examples ESRI provides.

100 block of New York St, Redlands, CA
1600 blk E Cliff Dr, El Paso
200-500 block Taylor St, San Francisco
1700-1900 blk of Locust St, Philadelphia, Pennsylvania

Thanks!!

Shana Britt

For stacked addresses, you could cartographically disperse them using https://pro.arcgis.com/en/pro-app/latest/tool-reference/cartography/disperse-markers.htm.

-Shana

WalidAlmasri1

Hi @ShelbyZelonisRoberson, exactly correct. Build a geocoder using only centerlines with Street Address Role. You need to have address ranges in the centerline though in order for this to work.

On the backend, the data is converted into a new table. So addresses like 1264 N Main St, are converted to 1300 Block of N Main St and if the address is 1231 N Main St, we convert it to 1200 Block of N Main St. You don't need to have 'block of' text in your address, but the geocoder will understand it if it's there. Then run those new addresses through the geocoder to get the new location. I'm not certain how having block information in the centerline would affect geocoding accuracy since we don't have that, but let's assume the street had an address range of 1000-3000, addresses that get converted to 1000 Block are placed on the beginning point of the line, addresses that are 2000 block would be placed on the center of the line, and addresses on the 3000 block will be placed on the other end of the line.

The only downside I'm seeing here is if you have multiple addresses on one street that get converted with the same block information, they will stack. One way around that would be to geocode the actual address but only display the 'block of' address, but then that could potentially place the address close to where you are trying to mask. Or limit the data by date range.

I hope this helps, let me know if you have any questions.

ShelbyZelonisRoberson

Hi! I'm trying to do something similar. Do you geocode to the centerline using 1234 N Main or to 1200 N Main? Would you mind sharing your process for anonymizing the addresses to the block level? Thank you!

Shana Britt

It's possible to search for Street blocks, which is described here for StreetAddress role, https://pro.arcgis.com/en/pro-app/3.0/help/data/geocoding/introduction-to-locator-roles.htm#ESRI_SECTION2_6D3D70C9F7AA4871ABDBCD7F98D363D1. You will need ArcGIS Pro 2.7 or later to build a locator that supports searching for street blocks, for example "100 block of New York St, Redlands, CA". How do you have the block address formatted in your input address table? You will need to modify your address table to change addresses from "1234 N Main" to '1200 block of N Main' in order to get the matches you are looking for. You can also test this out using the following tutorial and the test addresses at the bottom of the tutorial. https://pro.arcgis.com/en/pro-app/latest/help/data/geocoding/tutorial-create-a-locator.htm#

WalidAlmasri1

Hello @ShanaBritt Making an event layer works out fine, but that's not what I am trying to do. We have many records that map an exact location and I am trying to geocode masked addresses (to hundred block - EX: 2352 = 2300) back to the street centerline. Most of the locations do geocode back to the centerline, but many that do not have an address, but have Lat/Lon, to do not get processed by the geocoder even with coordinate category selected. I have investigated other methods like reverse geocoding the layer, which yields better results (sort of), but also causes issues when the reverse geocode goes to the wrong street since it was closer than where the address specifies.

I'm really trying to find how precise data is anonymized and I'm not having very good luck it seems.

Shana Britt

Building a locator with the Create Locator or Create Feature Locator tools suppors global search for coordinates (latitude/longitude, MGRS, DD, or USNG). Support for coordinate searching is disabled or enabled under Categories to support on the Geocoding options page of the Locator Properties dialog box for the locator. What is the format of the coordinates you are using? Can you enter the same coordinates into the Locate pane and get results returned by the StreetAddress role locator you created? What is the coordinate system of the locator (the reference data)?

Also, are you not able to use Make XY Event Layer to generate points from the coordinates?

-Shana

WalidAlmasri1

Maybe I should simplify the question. Can a geocoder geocode lat/lon or XY's? Because the geocoders I create seem to not be able to perform that function.

WalidAlmasri1

Thanks, I will look into this option!

jcarlson

Perhaps there is a way with the ArcGIS Python API? arcgis.features.GeoAccessor.from_df() will geocode the input table, and you can specify the geocoder used. There is also from_xy(), which would handle the lat/lon input.

So perhaps something like this? Haven't tested this out, but it might be a starting point.

import arcgis
import pandas as pd

# load your address table as a DataFrame; this will depend on its format, location, etc

# get the blank addresses
no_addrs = df[df['address_field'].isna() == True]

# get addresses
addrs = df[df['address_field'].isna() == False]

sdf_addrs = arcgis.features.GeoAccessor.from_df(addrs, 'address column', 'your geocoder')

sdf_noaddrs = arcgis.features.GeoAccessor.from_xy(no_addrs, 'lon', 'lat')

# merge into one dataframe
geocoded = pd.concat([sdf_addrs, sdf_noaddrs], ignore_index=True)

# then export / upload as needed

WalidAlmasri1

Yes, but unfortunately, this will become an automated process that will run daily, so there will be no interaction for manual matching. We already map the data internally by lat/lon and locations that do not have a lat/lon from creation get moved to a fixed location depending on the district they are assigned.

I'm looking publish the data publicly, which is why I am altering the addresses and hoping to use lat/lon where no address exists.

jcarlson

You should be able to use X/Y in the Rematch Addresses tool. Have you tried that?

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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