POST
|
I appreciate all of your responses, and the time you put in to helping me. I appreciate that @JoshuaBixby tried to do the CAST in a query on a joined file geodatabase feature classes and also found that it didn't work either. Validation. 🙂 The operation I was trying to perform was a microcosm of a project I need to do this week. I was using file geodatabase feature classes to practice the operation I need to perform before the big day. The actual, production feature classes are on SQL Server, and I have no doubt my query will work there. If it's just a bug with file geodatabases, then I can live with that. I did verify that the CAST operator works as expected when querying a feature class that is not involved in a join. Thanks, everyone!
... View more
12-29-2020
10:24 AM
|
0
|
0
|
116
|
POST
|
It sounds as though you are new to the product, which is great and I welcome you to the community. Please know that labeling in ArcMap is basically its own course and takes a really long time to master. There are so many options, and so many combinations of options, that it could be difficult to assist you without further information, screen shots, and so forth. By design, ArcMap does not normally show labels all on top of each other, so it has to selectively pick which ones to display and which ones to hide. There are ways to tweak this, but by default, it may seem random to you. Let us see your map at different scales before we suggest ways to configure the settings.
... View more
12-28-2020
03:00 PM
|
0
|
0
|
40
|
POST
|
Oh, and I've also seen this problem when a layer's spatial index is out of date. Catalog > Properties of the feature class > Indexes > Spatial Index > Update...
... View more
12-28-2020
02:56 PM
|
1
|
0
|
128
|
POST
|
You can also see your map's selection tolerance. Another thing I'd look at is how zoomed in you are. Zoom levels like "1:0.7" don't work well interactively.
... View more
12-28-2020
02:29 PM
|
2
|
0
|
129
|
POST
|
I remember experiencing this with 10.6. In my case, the C:\Python27 directory had had its permissions changed so that only Administrators could view its contents. To fix it, I clicked the Python folder, waited for File Explorer to tell me that it wasn't accessible and asked if I wanted to make it accessible, to which I clicked Yes. Python, after all, is necessary for a lot of ArcMap functionality so it made sense why it was crashing. But still no idea on how those permissions got changed. I saw this on four other workstations in my organization, out of perhaps 25 workstations.
... View more
12-28-2020
02:27 PM
|
0
|
6
|
242
|
POST
|
I am using ArcMap 10.8.1. I have two feature classes in a local file geodatabase. Both have an ID field of type Long, which has been indexed. Feature class A has a Long field (AFIELD) and feature class B has a Text field (BFIELD). I have joined A and B on ID. Now all I want to do is select records where A.AFIELD <> B.BFIELD. The SELECT statement always yields an error. I have tried using CAST, CONVERT, and other workarounds, but cannot get the statement to run. I have assembled a small example in the form of a map document, file geodatabase, and two feature classes. Each feature class is indexed on ID and a join has been performed from B to A (A is the target, B is the joined). If executed correctly, ID 10 will not be in the selection set because 123 = '123' but ID 20 will be in the selection set because 456 <> '457'.
... View more
12-28-2020
01:57 PM
|
1
|
5
|
145
|
POST
|
On page 67 of the ArcGIS 9 Managing ArcSDE: Application Servers book, it says, "If the system administrator account is not being used to start the service, make sure the user is a member of the administrator power group." The way I fixed this problem on our legacy server was to have the service run as the Administrator on the local box, rather than the Local Service Account option. When I did that, I got a dialog message that Administrator was then being granted login privileges. Despite that, when I restarted the server, ArcSDE ran automatically like I had hoped. I believe that the reason that people are able to start the service when they're logged in is because they're logging in with an account with administrative privileges before starting the service Now, our service has a few nuances. For instance, arcsde isn't really the name of our service--we customized it. And, we don't use a database called sde, we renamed it something else, and then set the SDE_ADMIN_DATABASE configuration parameter to that name. But we modified etc\services like we were supposed to, and services.sde, and added %SDEHOME% to %PATH%, yet none of those things made ArcSDE start automatically, successfully, after server reboot.
... View more
11-16-2020
12:06 PM
|
0
|
0
|
41
|
POST
|
I took this concept a step or two further and developed this little one-line gem which uses list comprehension and treats the cursor like a tuple: max([cur[0] for cur in arcpy.da.SearchCursor("Asset Layer", "ASSETID")]) Important notes: This bit of arcpy code works in ArcMap, but it fails on an empty layer because the list is empty. Also, since it's in ArcMap, the code above honors the user's selected rows or features and therefore returns the maximum number of the field within the selection.
... View more
10-30-2020
11:47 AM
|
0
|
0
|
576
|
BLOG
|
There is a reason that my implementation is more complex. The stake holder wanted to update one field in the master class based on date fields in TWO detail classes. The code has to look at the latest inspection in both of the related tables, get the maximum, and then do date math to find the number of days different. I also set up variables and method parameters instead of hard-coding any field names. Still, I can tell your grasp of Python is stronger than mine, so a mix of our code could be close to ideal. I also want to add another note. I used to have a problem where the call to stopEditing would raise an exception about the state of the edits. I found another thread on this forum that mentioned that the key to not raising the exception is to delete (del) the variable holding the cursor. In my code above, this is masterRow.
... View more
01-02-2020
01:54 PM
|
1
|
0
|
322
|
POST
|
I changed my DLL to replace pluses with spaces and it now works! Thank you. I'll mark your reply as an answer.
... View more
01-02-2020
01:45 PM
|
0
|
0
|
144
|
Online Status |
Offline
|
Date Last Visited |
01-04-2021
05:11 PM
|