POST
|
I like your approach, it's like a hybrid. For what it's worth, we went with the single large catch-all record. My understanding is that if a record has more than 2000 features, it won't calculate or update the geometry of the record during edit operations. We didn't see any performance issues related to this approach.
... View more
02-14-2024
11:51 AM
|
1
|
0
|
312
|
POST
|
OK, thanks for the info. I don't suppose there is any way to tell how they were initially created?
... View more
02-12-2024
03:37 PM
|
0
|
2
|
362
|
POST
|
We have a couple of data stores pointing to the same database with different users. Recently, some user passwords were reset. I'm updating the datastore items' passwords by uploading a new .sde connection file. However, I don't know if the data stores were created with branch or traditional versioned connections in the .sde connection file. My question is, does it matter to a Portal data store item if the underlying .sde connection file was created as a branch or traditional connection?
... View more
02-12-2024
03:23 PM
|
0
|
4
|
372
|
POST
|
Hi Adam I have some code that does something similar that you should be able to adapt. On any feature Insert or update, it queries a table, t.Road_atr, for a related record and updates that record with a value from the feature being updated. //get the road_atr record
var results = FeatureSetByName($datastore, 'T.Road_atr', ['GlobalID', 'FNODE', 'TNODE', 'ObjectID'], false)
var roadsegid = $feature.roadsegid
var atrset = Filter(results, 'roadsegid = @roadsegid');
if(Count(atrset) > 0){
var atr = First(atrset);
console(atr.objectID);
// atr.GlobalID,
return {
'edit': [{
'className': 'T.Road_atr',
'updates': [{
'objectID': atr.objectID,
'attributes':{
'FNODE': $feature.from_interid,
'TNODE': $feature.to_interid
}
}]
}]
}
}
... View more
02-01-2024
01:02 PM
|
1
|
0
|
229
|
POST
|
I'm working on migrating from an ArcMap Parcel Fabric to the newest version. The Migrate Parcel fabric tool works great. All features are migrated, and records are created in the records table. The only issue is that over 20 parcel types are created in the new fabric. Many of these types should be merged together; for example, three different Lot parcel types are created. I want to merge many of these parcel types together. Since records have already been created, I also want to preserve them. I think I can append some parcel types into others and remove them from the fabric, but I'm considering whether this will cause problems. So my question is, can anybody see problems with this approach? For example, If I want to append three parcel types, LotA, LotB, and LotC, the basic steps would be Disable topology Add LotType attribute to LotA Append LotB and LotC into LotA Calc LotType attribute Remove LotB and LotC parcel types from the Fabric Once the Created By Record attribute is appended correctly, then Lots should still be related to the records that created them. If I do an append
... View more
02-01-2024
12:43 PM
|
0
|
2
|
183
|
POST
|
Thanks @MarceloMarques . This is an interesting problem. I hope it gets a fix soon, as I can see our editors making large numbers of edits on particularly big projects. For now, my fix was to do the edits in the default version. I'm the geodatabase admin so I have the permissions to edit sde.Default directly. This won't be an option if one of the editors comes across this problem. These are the steps I used to fix the problem should anybody else come across it. From the version that won't reconcile and contains the edits, export the table to a local FGDB Switch to the default version, connected to Portal as a user with rights to edit sde.Default Join local copy of data to feature layer Use the field calculator tool to update feature layer attributes with local copy attributes.
... View more
12-20-2023
03:33 PM
|
1
|
1
|
356
|
POST
|
Thanks for the link Scott. The feature service and the editing workflow have been in place and working fine for over a year, so I'm sure it's not the service or how we are reconciling. To test this I created a new version, repeated 20 of the edits and it rec and posted fine. I've started digging into the SQL running on the database but so far can't isolate and COLLATE command using SQL Profiler.
... View more
12-20-2023
12:47 PM
|
0
|
0
|
446
|
POST
|
The layer I was trying to edit contained a join. Once I removed the join the error stopped happening and I could edit as normal. I don't recall joins preventing editing before, I wonder if this is a bug?
... View more
12-20-2023
11:57 AM
|
0
|
0
|
186
|
POST
|
ArcGIS Enterprise 10.9.1 Pro 3.2 SQL Server 2016 I have branch-versioned data in a feature service. I made approx. 4000 edits in a version. Now however I cannot reconcile this version. When I do, I get a popup in ArcGIS Pro: ERROR: A database error was encountered. Please contact your system administrator to review the server logs. When I check the ArcGIS Server logs, I see this error: Underlying DBMS error [[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Expression type int is invalid for COLLATE clause.] Does anybody know how to troubleshoot this? I'd like to not lose the edits.
... View more
12-20-2023
11:54 AM
|
0
|
5
|
520
|
POST
|
Pro 3.2 Branch versioned feature service I get the following error when trying to edit data in a feature service. Could not get the data store associated with this dataset. Please make sure this is a valid and non-virtual dataset The data is from a referenced geodatabase that is branch-versioned. The error might be caused by the .aprx as other editors are able to edit the same feature class in different versions. Has anyone seen this error before?
... View more
12-19-2023
10:03 AM
|
0
|
1
|
285
|
POST
|
@ECarsonThanks for the information. I didn't know about how ownership is controlled. Like you I have a published Trace Network that works in Pro. In my case I'm trying to add the published service to a Web Map and use one of the existing ESRI widgets to allow traces to be run from a web app in the field. After further research it looks like I'll have to build my own tool as the 2 existing widgets I'm aware of only support Utility Networks and not Trace Networks.
... View more
11-20-2023
09:40 AM
|
0
|
0
|
348
|
POST
|
I have the trace network published already, and I can bring it into Pro and use it successfully. My problem is that all attempts to bring it into a web map fail. The Map Viewer in Portal shows an error indicator for the Trace Network layer when I add the service to it. I tried your suggestion in another post of adding the published feature service to Pro and publishing the web map from there, but Publishing fails. All of this might be a moot point anyway if the existing widgets don't work with a Trace Network. If I have to build my own web app to run traces, then I can hit the rest endpoint directly. I was just hoping for something plug-and-play.
... View more
11-20-2023
09:35 AM
|
0
|
0
|
348
|
POST
|
@gis_KIWI4Thanks for pointing that out. Since many of the trace operation REST endpoint parameters are common between the 2 I was hoping ESRI made them compatible. Unfortunately, it looks like I'll have to code my own.
... View more
11-20-2023
09:23 AM
|
0
|
0
|
276
|
Title | Kudos | Posted |
---|---|---|
1 | 02-14-2024 11:51 AM | |
1 | 02-01-2024 01:02 PM | |
1 | 12-20-2023 03:33 PM | |
1 | 01-13-2023 01:39 PM | |
1 | 11-15-2023 03:22 PM |
Online Status |
Offline
|
Date Last Visited |
a week ago
|