Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About JoeBorgione
JoeBorgione
MVP Emeritus
since
07-04-2014
05-19-2026
5690
Posts created
961
Kudos given
216
Solutions
2622
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(16 Idea Submissions)Latest Contributions by JoeBorgione
|
POST
|
I guess the only option is to use Python 3 (Pro) for that task and probably migrate whole geoprocessing service. This... And... Do yourself a favor and embrace ArcGIS Pro. It's a tough change I know but if an old gray-hair such as myself can do it, anyone can. I haven't used ArcMap/ArcCatalog in almost two years and don't miss it one bit.
... View more
08-11-2021
07:18 AM
|
2
|
0
|
4437
|
|
POST
|
In your OP you mentioned tables only, but from your concise description it sounds like you are doing things correctly. Check your locator properties: there is a setting that you need to check or uncheck that specifies to match without zones. I suspect that's your problem. Click here for more info.
... View more
08-11-2021
07:09 AM
|
1
|
1
|
2021
|
|
POST
|
Sometimes adding Python and ArcGis together makes for a good time!
... View more
08-11-2021
07:03 AM
|
0
|
0
|
9091
|
|
POST
|
Are any of your original GEOID fields null or empty?
... View more
08-10-2021
03:31 PM
|
0
|
5
|
9127
|
|
POST
|
I have a line street table .... I have another table... Are you using tables to match to or actual feature classes? You should be matching against a feature class in order for you addresses to be 'spatially enabled' as points.
... View more
08-10-2021
10:23 AM
|
1
|
1
|
2035
|
|
POST
|
How about: origString = 'a;b;c'
newList = origString.split(';')
#newList
#Out[16]: ['a', 'b', 'c'] That'll get you a list rather than the tuple which might be easier for the SQL statement.
... View more
08-10-2021
10:17 AM
|
0
|
0
|
2527
|
|
POST
|
I use georeferencing almost daily in concert with the Address Data Management Solution to add new streets and site address points; below I've georeferenced a plat map of a proposed subdivision to the parcels it involves: After that's done, adding the new street and subsequent address points is easy.
... View more
08-10-2021
09:27 AM
|
0
|
1
|
7958
|
|
POST
|
@KeithOlson @DavidPike @Asrujit_SenGupta I've been working with ESRI Tech support on this and at the moment, have a work around: If you recalculate the spatial index of the feature class, the symbology behaves itself. I have no idea why but I just tried it on a test feature class, and then on my production feature class. I'm not a fan of work arounds. However, from an email conversation with the support analyst, I was offered this pearl of wisdom: ...It seems like we are running into some strange buggy behavior here... All I can think of is:
... View more
08-10-2021
09:00 AM
|
3
|
3
|
2634
|
|
POST
|
It seems like I figured it out:\
addressLocators = r"N:\GIS\Geocoding\CityWorksLocators\Locators\MsdMultiRoleLocator.loc Msd;"\
r"N:\GIS\Geocoding\CityWorksLocators\Locators\NonMSDMultiRoleLocator.loc NonMSD;"\
r"N:\GIS\Geocoding\CityWorksLocators\Locators\SingleRoleParcelLocator.loc Parcel"
#fieldMap = r'"Address or Place" true true false 100 Text 0 0,First,#,N:\GIS\Geocoding\CityWorksLocators\Locators\MsdMultiRoleLocator.loc,Address,0,0,N:\GIS\Geocoding\CityWorksLocators\Locators\NonMSDMultiRoleLocator.loc,Address,0,0,N:\GIS\Geocoding\CityWorksLocators\Locators\SingleRoleParcelLocator.loc,Address,0,0'
fieldMap = 'Address "Address or Place" true true false 100 Text 0 0,First,#,;'\
r'N:\GIS\Geocoding\CityWorksLocators\Locators\MsdMultiRoleLocator.loc,Address,0,0,;'\
r'N:\GIS\Geocoding\CityWorksLocators\Locators\NonMSDMultiRoleLocator.loc,Address,0,0,;'\
r'N:\GIS\Geocoding\CityWorksLocators\Locators\SingleRoleParcelLocator.loc,Address,0,0'
selectionCriteria = "MsdLocator #;"\
"NonMsdLocator #;"\
"Parcel #"
outLocator = r'N:\GIS\Geocoding\CityWorksLocators\Locators\CityWorksComposite.loc'
... View more
08-09-2021
12:36 PM
|
0
|
0
|
1581
|
|
POST
|
I'll forward this thread to the tech support analyst working on my case.
... View more
08-05-2021
12:27 PM
|
1
|
0
|
2667
|
|
POST
|
Hate to pawn you off to ESRI Tech Support, but at this point it's probably a good call.
... View more
08-05-2021
11:48 AM
|
0
|
0
|
5182
|
|
POST
|
I'm not familiar with Sql Lite. When you are in ArcGIS Pro and make your connection can you actually see the tables and values therein? Is there a driver you may need to install in order for ArcGIS Pro & Sql Lite to play nice together? I had a problem connecting to My Sql sometime back and it turns out there's a bug in ArcGIS Pro that won't let that happen. Not saying that's your issue, but ESRI didn't know about it till I showed them...
... View more
08-05-2021
09:24 AM
|
1
|
2
|
5186
|
|
POST
|
I was hoping to see the actual code you used. Your select statement in the search cursor is pretty complex but I think if you use a series of if/elif statements that check for null values in each of your indices followed with a pass ( or a print statement saying Such and Such index is null) you should be able to avoid the error. Emphasis in think and should... OIN = SelectedTempFields.index('ORIG_FID')
VIN = SelectedTempFields.index('ValveID')
DIN = SelectedTempFields.index('LAND_DIST')
LIN = SelectedTempFields.index('LAND_LOT_1')
#blah blah blah...
if OIN is None:
pass
elif VIN is None:
pass
elif DIN is None:
pass
elif LIN is None:
pass
else:
# do your list comprehension with the search cursor....
... View more
08-05-2021
09:18 AM
|
0
|
1
|
19100
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 10-11-2018 07:12 AM | |
| 1 | 05-17-2021 11:18 AM | |
| 1 | 06-29-2021 11:42 AM | |
| 1 | 07-05-2012 07:49 AM | |
| 1 | 09-03-2016 06:16 AM |
Activity Feed
- Got a Kudo for Re: Migrating to GlobalID Relationship. 2 weeks ago
- Got a Kudo for Reorder Attribute Rules with Drag and Drop. 03-10-2026 07:14 AM
- Got a Kudo for arcpy.ListDatabaseSequences() for EGDB. 02-13-2026 09:05 AM
- Got a Kudo for Re: Compare field values from 2 different tables, Locate value from table 2 in that row, use UpdateCursor to Update field in table 1. 12-18-2025 01:45 PM
- Got a Kudo for Modify existing Geodatabase Sequences. 12-04-2025 11:45 AM
- Got a Kudo for List Database Sequences for Enterprise Geodatabase. 12-03-2025 12:16 PM
- Got a Kudo for Re: Removing Zeros From a Field. 12-03-2025 07:01 AM
- Got a Kudo for List Database Sequences for Enterprise Geodatabase. 11-24-2025 01:16 PM
- Got a Kudo for Modify existing Geodatabase Sequences. 11-17-2025 08:52 AM
- Got a Kudo for Re: List Database Sequences for Enterprise Geodatabase. 11-06-2025 07:35 AM
- Got a Kudo for Re: Using Attribute Rules to calculate fields from intersecting polygons. 10-10-2025 06:26 PM
- Got a Kudo for Modify existing Geodatabase Sequences. 09-29-2025 08:04 AM
- Got a Kudo for Can't select multiple features in map. 08-20-2025 01:33 PM
- Got a Kudo for Re: How to add black space in Dashboard title?. 07-17-2025 12:15 PM
- Got a Kudo for Re: arcpy.ListUsers(). 06-17-2025 12:44 AM
- Got a Kudo for arcpy.ListDatabaseSequences() for EGDB. 06-10-2025 03:50 PM
- Got a Kudo for Modify existing Geodatabase Sequences. 05-29-2025 08:09 PM
- Got a Kudo for Modify existing Geodatabase Sequences. 05-27-2025 02:47 PM
- Got a Kudo for Modify existing Geodatabase Sequences. 04-16-2025 07:39 AM
- Got a Kudo for Re: List Database Sequences for Enterprise Geodatabase. 03-11-2025 06:41 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
05-19-2026
11:56 AM
|