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
|
My first reaction is to migrate your shapefiles into a geodatabase format, either a local file geodatabase or enterprise geodatabase. As far as your newly added features not displaying, it sounds to me like you may have a definition query enabled such that when you add a new feature, the attribute that drives that definition query is not populated correctly. See: https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/definition-query.htm
... View more
03-18-2021
09:08 AM
|
0
|
0
|
5365
|
|
POST
|
I work strictly in ArcGIS Pro and during this process never did I get a warning to pick a unique identifier field.
... View more
03-18-2021
09:02 AM
|
0
|
0
|
5102
|
|
POST
|
...whole team can use and understand though... 114 fields? Your team uses and understands all 114 fields? Good on ya!
... View more
03-17-2021
01:48 PM
|
0
|
1
|
2119
|
|
POST
|
The whole point of the dictionary approach is to avoid a join. I done it dozens of times on thousands of records/updates. But do what you feel works for you.
... View more
03-17-2021
01:31 PM
|
0
|
2
|
7759
|
|
POST
|
Is python an option? I use a dictionary approach described here.
... View more
03-17-2021
12:37 PM
|
1
|
1
|
7818
|
|
POST
|
This thing is a circa 1995 Oracle db that got pushed into a SQL server. There are literally hundreds of tables in it and those tables have upwards of 100 fields; most of which are <Null>. Logic? We don't need no stinkin' logic....
... View more
03-17-2021
12:34 PM
|
0
|
1
|
5127
|
|
POST
|
Thanks @George_Thompson ; I could examine the tables in SQL and see if the other numeric fields have null values. Truth be told, this database is so poorly designed I'm drowning in it...
... View more
03-17-2021
12:23 PM
|
0
|
3
|
5129
|
|
POST
|
Correct: stand alone SQL instance not even close to a Geodatabase. Not sure I follow you about 'not null numeric field', I'm adding the tables as tables, not query layers. We are seeing other things like if none of the SQL table fields are numeric (text and dates only) a field called ESRI_OID gets inserted into the Design/Fields view. That I can accept, but the randomizing of numeric to oid is a PITA.
... View more
03-17-2021
12:01 PM
|
0
|
5
|
5133
|
|
POST
|
I have an odd situation. In ArcGIS Pro 2.7 I have a connection to a SQL Server database. Within this database are tons of tables with tons of fields of all types. When I make a connection to that database and open the tables in ArcGIS and then look at the design view, it randomly changes numeric fields to Object ID Type. I stumbled upon this issue because when I performed a Table to Table operation, I would lose that field: you can only have 1 object id field in any given ArcGIS database object. Here is what the field definition shows in Sql Server Management Studio: And here are those same fields when shown in the design view in ArcGIS Pro: The APDEFNKEY field does not have unique values in this particular table. This database has many related tables with a field from each with a KEY suffix. For example, in the APDEFN table, the APDEFNKEY value is unique to each record. In the ADDRESS table the ADDRKEY is unique to each record. Anyone seen this before? Is it a known 'undocumented' feature?
... View more
03-17-2021
09:48 AM
|
0
|
9
|
5183
|
|
POST
|
Check your field names; be sure they don't start with a number and/or have special characters in them. Well.... I've been using ESRI products since 1990 and have always been able to perform spatial analyses with all of them.
... View more
03-16-2021
07:13 AM
|
0
|
0
|
3317
|
|
POST
|
Ahhh. I see... Take a look here ; I see that last value currently does not have an attribute rule counter part.
... View more
03-16-2021
07:09 AM
|
1
|
0
|
3609
|
|
POST
|
What's your end game here? It looks like you are using some SQL cursors to create some tables and insert some records yet you mention making queries on either shapefiles or fgdb feature classes after extracting them from a zipfile. Start with the basics like: 1. I want to ..... 2. Then I want to..... 3. Once that is done, I want to.... As Dan alludes to, you need to pick which platform you want this to execute in: ArcMap Python, ArcMap Model Builder, ArcGIS Pro Python, ArcGIS Pro Model Builder. Until you cover the basics it's kind of tough to offer any sort of advice or solution.
... View more
03-15-2021
03:28 PM
|
1
|
2
|
2145
|
|
POST
|
That is not the tool to use: see the online help linked in my post above. All that step does is take the excel spread sheet and convert it into an ArcGIS data table. You will be limited in your analytical approaches if you are using shapefles and converting the excel spreadsheet into a .dbf table. I strongly urge you to use a File Geodatabse in which to store your data, both spatial and tablular.
... View more
03-15-2021
01:14 PM
|
0
|
1
|
3334
|
|
POST
|
My first suggestion is that you use the excel to table tool to convert your spreadsheet into a database table. It is much easier to work with ArcGIS tables rather than excel spreadsheets. I can only assume you have a valid key field between the polygons and your excel data. With as many rows as your excel data seems to have, a join may not work. Joins in ArcGIS are 1 to 1 or Many to 1, but not 1 to Many. If you have 1 polygon and many records in the excel data, you will need to use a relate rather than a join.
... View more
03-15-2021
12:52 PM
|
1
|
1
|
3336
|
|
POST
|
@MervynLotter - where do you find the .shp.xml? And what is the equivalent for an Enterprise GBD feature class?
... View more
03-15-2021
09:21 AM
|
0
|
0
|
2934
|
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. 06-22-2026 12:29 PM
- 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
|