Latest Contributions by JoeBorgione

‎12-03-2020

Thanks Dan! I this might have been what I was thinking of ,

‎12-03-2020

I thought there were some new python tools that would make it easier that were coming down the pike....

‎12-03-2020

ArcGIS Pro 2.6 I have a multi role locator with point address, street address and parcel roles. My table of addresses includes an Address field as well as a Parcel ID field. [In theory] if the Address field is <null> the Parcel ID field will be populated. Can I use two completely different input fields when geocoding this table against the described locator? If so, how? @ShanaBritt @BradNiemand

‎12-03-2020

ArcGIS Pro 2.6 Can I change the default setting from yes to no when creating a street address role locator rather than changing it in the locator properties? For that matter, can I change any of the other properties like Scores etc in a python scripting environment rather than manually after the fact? JoeBorgione_0-1607021900125.png @ShanaBritt @BradNiemand

‎12-03-2020

What agency curates the parcel data for your area of interest? Do they have parcels in a GIS format? For the county in which I live, the Recorder's office has it. However, (at least here) they charge private entities for the data. The parcel data I have access to contains owner address information, so it's a fairly simple query to get just those out of state owners.

‎12-02-2020

Turns out the arcpy.SignInToPotal() call isn't needed for me. The game changer is while the create locator tool is able to exploit a map service as a data source, arcpy cannot; arcpy wants a feature service. The portal I have access to is behind a firewall and is available 'publicly' to those users logged into the network which I am. All I had to do is change the urls to the various feature services and I'm good to go. One of the data sources in my multi-role locator is on our SDE-Egdb, so it's part of inTable variable as shown below in the final code: import arcpy arcpy.env.overwriteOutput = True arcpy.SetLogHistory(False) outLocator = r'M:\path_to\my_locator' language = 'ENG' country = 'USA' inTable = "https://www.yady_yady.org/gisfed/rest/services/Internal/FeatureServer/1 PointAddress;"\ "https://www.yady_yady.org/gisfed/rest/services/Internal/FeatureServer/9 StreetAddress;"\ "https://www.yady_yady.org/gisfed/rest/services/Internal/FeatureServer/3 Parcel;"\ "\\\sharedDrive\to\connectionFile.sde\OurSde.AddressGridCoordinatePoints POI" fieldMapping = "'PointAddress.HOUSE_NUMBER 1.ADDR_HN';"\ "'PointAddress.STREET_PREFIX_DIR 1.ADDR_PD';"\ "'PointAddress.STREET_NAME 1.ADDR_SN';"\ "'PointAddress.STREET_SUFFIX_TYPE 1.ADDR_ST';"\ "'PointAddress.STREET_SUFFIX_DIR 1.ADDR_SD';"\ "'PointAddress.SUB_ADDRESS_UNIT 1.UNIT_DESIG';"\ "'PointAddress.CITY 1.CITY';"\ "'StreetAddress.HOUSE_NUMBER_FROM_LEFT 9.FROMADDR_L';"\ "'StreetAddress.HOUSE_NUMBER_TO_LEFT 9.TOADDR_L';"\ "'StreetAddress.HOUSE_NUMBER_FROM_RIGHT 9.FROMADDR_R';"\ "'StreetAddress.HOUSE_NUMBER_TO_RIGHT 9.TOADDR_R';"\ "'StreetAddress.STREET_PREFIX_DIR 9.PREDIR';"\ "'StreetAddress.STREET_NAME 9.NAME';"\ "'StreetAddress.STREET_SUFFIX_TYPE 9.POSTTYPE';"\ "'StreetAddress.STREET_SUFFIX_DIR 9.POSTDIR';"\ "'Parcel.PARCEL_NAME 3.parcel_id';"\ "POI.PLACE_NAME 'OurSde.AddressGridCoordinatePoints'.Coordinates" arcpy.geocoding.CreateLocator(country, inTable, fieldMapping, outLocator, language)

‎12-01-2020

I just noticed the change and see it as welcome relief from the original.

‎12-01-2020

I'd like to find posts that I started rather than those I've replied to.

‎12-01-2020

What then is the search function for? I entered my user name in the author button and get one return from last year. When I search on my user name in the main search bar, I get zero returns.... JoeBorgione_0-1606836080876.png

‎11-30-2020

...is not 'Import' more appropriate since there are no features to append to? Not neccesarily; I use a sequece of truncate followed by append all the time in certain workflows. Works like a charm and I wouldn't consider import.

‎11-25-2020

Following the example towards the bottom of the help page mentioned, I am trying to create a single role street address locator with a service as the data source: (sorry for the lame code editing, but I'm at the mercy of the new geonet) import arcpy arcpy.env.overwriteOutput = True arcpy.SetLogHistory(False) outLocator = r'M:\HansenSQL\HansenGeocoding\TestLocator' language = 'ENG' country = 'USA' inTable = "https://blah/blahlah/rest/services/Transportation/MapServer/0 StreetAddress" fieldMapping = "'StreetAddress.HOUSE_NUMBER_FROM_LEFT 0.FROMADDR_L';"\ "'StreetAddress.HOUSE_NUMBER_TO_LEFT 0.TOADDR_L';"\ "'StreetAddress.HOUSE_NUMBER_FROM_RIGHT 0.FROMADDR_R';"\ "'StreetAddress.HOUSE_NUMBER_TO_RIGHT 0.TOADDR_R';"\ "'StreetAddress.STREET_PREFIX_DIR 0.PREDIR';"\ "'StreetAddress.STREET_NAME 0.NAME';"\ "'StreetAddress.STREET_SUFFIX_TYPE 0.POSTTYPE';"\ "'StreetAddress.STREET_SUFFIX_DIR 0.POSTDIR'" arcpy.geocoding.CreateLocator(country, inTable, fieldMapping, outLocator, language) However, it errors out with: ExecuteError: Failed to execute. Parameters are not valid. ERROR 002782: Selected Primary Table does not contain geometry. Failed to execute (CreateLocator). I can think of two things: I can get to the service via the create locator tool, but perhaps there is a security setting that does not allow me to hit it with python; I don't think that's it because in a console window I can use arcpy.ListFields(inTable) and get a list. or Creating a locator with a service as the data source simply does not work in python....

‎11-25-2020

The help page has a sample; I'll see what I need to do to get it to work for me...

‎11-25-2020

I just posted a thread in the Geoprocessing space, but when I refresh Latest Activity page, I don't see it. There are posts there from 50 minutes ago etc. And they aren't in chronological order. edited; but this one shows up...

‎11-25-2020

ArcGIS Pro 2.6 Yesterday I successfully created a multi-role locator using the Create Locator tool. Three of the four data sources are rest-end services. I would like to automate the task in a python script and things aren't quite working for me and I'm not sure why. The history of the tool is my source for the parameters. I've used it before but the data sources were feature classes rather than services. At any rate, here is what I use and the ensuing error: countryCode = 'USA' addressPrimary = r'https://path/to/rest/services/Reference/MapServer/5' centerlinesPrimary = r'https://path/to/rest/services/Transportation/MapServer/0' parcelsPrimary = r'https://path/tos/rest/services/Land/MapServer/1' poiPrimary = r'\\SDE\Connection\To\Our.sde\owner.AddressGridCoordinatePoints' #primaryReferenceData = "{} PointAddress;{} StreetAddress;{} POI".format(addressPrimary,centerlinesPrimary, #parcelsPrimary) primaryReferenceData = f'{addressPrimary} PointAddress;{centerlinesPrimary} StreetAddress;{parcelsPrimary} Parcel;{poiPrimary} POI' outLocator = r'M:\HansenSQL\HansenGeocodingTestMultiRole' fieldMapping = "'PointAddress.HOUSE_NUMBER 5.ADDR_HN';"\ "'PointAddress.STREET_PREFIX_DIR 5.ADDR_PD';"\ "'PointAddress.STREET_NAME 5.ADDR_SN';"\ "'PointAddress.STREET_SUFFIX_TYPE 5.ADDR_ST';"\ "'PointAddress.STREET_SUFFIX_DIR 5.ADDR_SD';"\ "'PointAddress.SUB_ADDRESS_UNIT 5.UNIT_DESIG';"\ "'PointAddress.CITY 5.CITY';"\ "'StreetAddress.HOUSE_NUMBER_FROM_LEFT 0.FROMADDR_L';"\ "'StreetAddress.HOUSE_NUMBER_TO_LEFT 0.TOADDR_L';"\ "'StreetAddress.HOUSE_NUMBER_FROM_RIGHT 0.FROMADDR_R';"\ "'StreetAddress.HOUSE_NUMBER_TO_RIGHT 0.TOADDR_R';"\ "'StreetAddress.STREET_PREFIX_DIR 0.PREDIR';"\ "'StreetAddress.STREET_NAME 0.NAME';"\ "'StreetAddress.STREET_SUFFIX_TYPE 0.POSTTYPE';"\ "'StreetAddress.STREET_SUFFIX_DIR 0.POSTDIR';"\ "'Parcel.PARCEL_NAME 1.parcel_id';"\ "POI.PLACE_NAME 'owner.AddressGridCoordinatePoints'.Coordinates" Error: Failed to execute. Parameters are not valid. ERROR 002782: Selected Primary Table does not contain geometry. I don't care for this new code editor as it doesn't list line numbers, but I'll limp through this. Notice in the field mapping portion it refers to the feature id only; does it need to be fully qualified with the entire url? @ShanaBritt @BradNiemand

‎11-24-2020

Lets see.... code goes here and here... Ahh, the old down arrow key trick! Why didn't I think of that?!

Online Status	Offline
Date Last Visited	‎05-19-2026 11:56 AM

My Ideas

Latest Contributions by JoeBorgione

Re: Create Locator: Change Match Out Of Range Default to NO

Re: Create Locator: Change Match Out Of Range Default to NO

Geocoding Address Table with Mulitiple Input Address Fields

Create Locator: Change Match Out Of Range Default to NO

Re: Point in the right direction

Re: Create Locator; Using Services as the Data Source

Re: Clicking Load more scrolls to the bottom of the new list vs staying put

Re: Listing of our contributions

Re: Listing of our contributions

Re: Load Data vs Append vs Import syntax

Re: Create Locator; Using Services as the Data Source

Re: Create Locator; Using Services as the Data Source

Where is my post

Create Locator; Using Services as the Data Source

Re: Code Formatting in a Reply

Topology in a Versioned GDB

Re: How do I edit metadata with Python?

Attribute Pane Properties

Re: Artificial Intelligence in GIS

Re: Data Scrubbing Addresses

Addressing

911 GIS