|
POST
|
Export Asset Package with data and Reapply Asset Package worked. Device Status is updated with in-line network attribute of 3 bits. Traces work correctly. It will be nice if Pro UN toolset adds a tool to remove network attribute or reset network attribute and to remove network attribute assignment.
... View more
02-28-2021
04:41 PM
|
0
|
0
|
1684
|
|
POST
|
Trying to fix my model so that inline field bit size updates to 3 to cater for additional value of 4 in the Device Status Combined domain. But I cannot find a tool to remove network attribute or disassociate network attribute so that I can add it again. Adding the same attribute errors out. ERROR 001952: Network attribute with the specified name already exists. Failed to execute (AddNetworkAttribute). Parameters were: Input Utility Network UNWater Utility Network Attribute Name P:Device Status Attribute Type SHORT In Line INLINE Apportionable NOT_APPORTIONABLE Domain Name 6_Pipeline_Device_Status_Combined Is Overridable NOT_OVERRIDABLE Nullable NOT_NULLABLE Substitution NOT_SUBSTITUTION Network Attribute to Substitute Updated Utility Network UNWater Utility Network Looks like I will have to export asset package, fix network attribute and reapply 😞
... View more
02-26-2021
03:43 AM
|
0
|
1
|
1710
|
|
POST
|
@MikeMillerGIS I tried the same in Naperville V4 model and I could not reproduce. The only difference I found is Naperville v4 model schema v2.6 does not have "Device Status Combined" domain and does not have "Device Status" domain, only "Valve Status" domain. Also, I found network attribute definition is different. Naperville model has as below. My model also V4 and created using Pro 2.6.0 has Will it making the difference? Cheers, Vish
... View more
02-26-2021
03:19 AM
|
0
|
2
|
1710
|
|
POST
|
Hi, I am in a process of building a UN model for Water Distribution. It is set-up correctly mostly similar to Naperville model and can see subnetworks and run traces etc. Now I need to add an additional code to VALVE_STATUS domain called "Partial" to represent that a valve is partially open. I stopped UN services and disabled UN topology. I then added a code 4 with description of "Partial" to appropriate domains i.e. Valve_Status and Device_Status_Combined. I then reenabled the topology. When I change one of the valves from "Open" to "Partial", it becomes a barrier and the network downstream is left out of the subnetwork after Validate and Update subnetwork. The tier is defined only with Present_Status=0 (closed) as a barrier. So Present_Status of 4 (Partial) should not become a barrier. Am I missing something? Cheers, Vish
... View more
02-24-2021
02:16 PM
|
0
|
4
|
1784
|
|
POST
|
Hi all, I have a query regarding the Arcade function NextSequenceValue to assign as assetid attribute. Very similar to this link. I have a multi-domain utility client that has Water, Sewer and Electric domains. Each domain classes reside in a separate SQL Server geodatabase. The client wants to use single sequence for all assets as these assets are linked to Asset Mgmt system. It seems that NextSequenceValue function assumes the sequence must reside in a same geodatabase. Is there a way to use a sequence in one centralised database and make it available for NextSequenceValue? I tried creating SQL Alias for the sequence in each Water, Sewer and Electric database but that does not work. It is not supported by SQL Server to query next sequence number using SQL ALias. Any other solution? Client cannot combine Water, Sewer and Electric domains in a single geodatabase. Thanks, Vish
... View more
02-22-2021
06:00 PM
|
0
|
2
|
2536
|
|
POST
|
It looks like tables were dropped directly in SQL Server. When a table is dropped using ArcGIS Pro or Catalog, it deletes lot of metadata entries, typically, GDB_ITEMS, SDE_TABLE_REGISTRY, SDE_COLUMN_REGISTRY, "a" and "d" tables for versioning etc. If possible, try to create the table again with same structure using SQL statement and then delete the table using ArcGIS Catalog. Hopefully, Catalog will complete the workflow of table deletion without a rollback due to the missing table. If you simply want these tables not appear in dataset tree, then delete the corresponding entries from SDE_TABLE_REGISTRY and GDB_ITEMS. See https://desktop.arcgis.com/en/arcmap/latest/manage-data/using-sql-with-gdbs/overview-geodatabase-system-tables.htm and https://desktop.arcgis.com/en/arcmap/10.4/manage-data/geodatabases/registering-a-table-with-the-geodatabase.htm for some info. NOTE: manual edits to metadata tables is a not recommended and can corrupt entire EGDB. So, take a backup before attempting anything. Cheers, Vish
... View more
02-22-2021
04:28 PM
|
4
|
5
|
4869
|
|
POST
|
Hi all, I am in the process of architecting ArcGIS Enterprise 10.8.1 solution with Utility Network in Azure for a large Electricity distribution client. Client currently has on-premise solution with a geodatabase for editing (System of Record) and a geodatabase for publication (System of Engagement) Client wants to continue with similar architecture for ArcGIS Utility Network ie workload separation between network editors and web map/app users. Web App users will need to perform UN traces so publication database needs to maintain UN topology. As I understand, geodatabase replication does not support Utility Network topology or anything that uses branch versioning. To meet client's requirements for the workload separation (UN editing vs web maps / web traces etc) we are thinking of proposing Azure SQL's read-only replica. As I understand, ArcGIS geodatabase connection strings support APPLICATIONINTENT=ReadOnly parameter. And that is all seems to be needed to access read-only replica in Azure SQL. Does anyone have experience setting this up and can confirm if it works? Is this a valid/supported/certified configuration by ArcGIS Enterprise? Thanks, Vish
... View more
02-21-2021
04:26 PM
|
2
|
2
|
1856
|
|
POST
|
Thanks @MikeMillerGIS . Bit more involved than SQL queries and joins but I think that will do the trick. Just a quick query, I guess fromnetworksourceid and tonetworksourceid translate to Junction/Device/Line/Assembly layer that can be queried using from/to globalid for additional details. Where will the mapping be for fromnetworksourceid and tonetworksourceid to the Junction/Device/Line/Assembly layer ids?
... View more
02-17-2021
03:41 AM
|
0
|
1
|
3672
|
|
POST
|
Hi, I have a query from an electric dist. client about being able to extract associations (connectivity, container, structural attachment) using SQL queries. The client is in the process of deploying UN with SQL Server as a geodatabase. Client wants to query connectivity and containment relationship directly in the database for reporting, DMS integration etc. Their legacy GIS supported it. e.g. for a given transformer, find what High/Primary side protection device is. My initial feel is this is not possible with UN as this information is stored as Blobs. There are few UN_X_* tables, but I guess it is not something that can be exposed or relied upon. Is there any other way? I cannot even find REST API to do something like this.
... View more
02-16-2021
05:11 PM
|
0
|
10
|
3947
|
|
POST
|
Hi, I am trying to generate schematic diagrams for electric distribution feeders. The diagram needs to go from left to right and both sides with the subnetwork controller for the feeder (Circuit Breaker in a substation) Breaker needs to be the left-most point and edges and junctions flowing rightward and up and down from breaker like the diagram below from https://desktop.arcgis.com/en/arcmap/latest/extensions/schematics/hierarchical-main-line-tree-schematic-layout-algorithm-properties-page.htm However, I cannot get this to happen using ArcGIS Pro 2.6.3 and ArcGIS Enterprise 10.8.1 UN SP1. The picture below is geographic extent of the feeder selected. I thought Mainline Tree Layout will be the best algorithm but it produced below. Starting Circuit Breaker in red. Is there a trick or different layout algorithm needed to achieve what I am trying to achieve? Cheers, Vish
... View more
02-16-2021
04:52 PM
|
0
|
2
|
1814
|
|
POST
|
For Sewer Networks, I would prefer to model Manholes as Sewer Devices rather than Structure Junctions. It can then control the flow of the resource like sewer. In reality, manhole can get blocked, flooded etc. and is important to trace to/from. I have a customer who wants to model Manhole as a Sewer Line instead of junction or device, albeit it will be a vertical line. And then model inlet and outlet as junctions that connect to manhole. I dont see anything wrong with this modeling but just haven't found courage to try implement it this way 🙂 For inlets and outlets, I can imagine three ways to model them. 1. As attributes for manhole as a sewer device. One of my customer deployed it this way. Inlet level and type, Outlet level and type, cover type, cover elev etc were captured as attributes. 2. Model them as sewer junctions that connect to manholes as devices. Inlet and Outlet can have Z value that represents depth or can have attribute for depth. Pipe(s) connects to inlet or outlet. 3. Model inlet and outlet as "terminals" for manholes. There will be editing overheads to specify terminals for pipes. Re. 80 different types of manholes, inlets etc specified by an abbreviated code, using FME's AttributeFilter transformer, you can apply filter and specify attribute mapping differently before writing to output UN feature class. Hope this helps, Vish
... View more
02-16-2021
04:45 PM
|
0
|
1
|
1862
|
|
POST
|
Yes, I too observed this behaviour when symbology is based on anything other than assetgroup, the assettype comes as numbers and doesnt display the text. End user doesnt know what those numbers mean. I found that for publishing feature service, it is best to leave the symbology based on assetgroup. If I dont want certain assetgroups, I use definition query in the map to filter them out or create multiple layers such as WaterValve, WaterPump etc out of WaterDevice. And I reset the feature creation templates accordingly. We need to do this any way due to the under-nomalised data model. This is in ArcGIS Pro or Portal Web Maps. I haven't tried with Collector just yet but I guess it is pretty much dictated by the web map used. My guess for this behaviour is, because assettype has different domain for each assetgroup, using symbology based on anything other than assetgroup, the service definition JSON doesn't list domain values for every assetgroup. Hence the numeric code doesn't get converted to text. And I think it as a bug rather than a feature 🙂
... View more
02-10-2021
02:25 PM
|
0
|
3
|
3325
|
|
POST
|
@JamesWright9 I am assuming you work for either Schneider or Latitude 🙂 I am working with a large Utility migrating them from GN to UN. This client currently has Geocortex Web. The target go live for UN is Q1 2022. Will ArcFM Web be UN ready by then?
... View more
02-09-2021
03:26 AM
|
1
|
1
|
4158
|
|
POST
|
Though there are UN admin tools and standard GDB tools to perform all required configurations such as adding a new subtype, domain for asset types, topology rules, terminals, network attributes etc, I find Asset Package is still the better way to apply the model changes. The process I follow is 1. Export existing UN model as Asset Package including data. 2. Make changes to the FGDB feature class definitions as necessary 3. Add/update/remove to appropriate B_* tables. 4. Optionally, make any changes to the data or C_* tables if required. 5. Re-apply asset package in full replacing entire geodatabase. 6. Version dataset 7. Enable topology. 8. Republish/restart the service. Not sure if this was a bug (or user error 🙂), but tinkering with the feature class definitions especially assetgroup (subtype field) required me to republish the service. Existing service was failing to restart due to a renderer issue of some sort. Downside is, it could be a longer downtime.
... View more
02-09-2021
03:13 AM
|
1
|
0
|
1713
|
|
POST
|
Thanks @MelissaJarman I can now see what Status Descriptions mean. However, I am still not sure why my Dirty Areas with status 9 (1 + 😎 doesn't go away after I shortened the geometry and Validate UN Topology was successful. I had to Disable Topology and Re-enable to see those dirty areas go away. This is with ArcGIS Pro 2.6.3, UN v4, ArcGIS Enterprise 10.8.1 plus UN SP1.
... View more
01-19-2021
05:51 PM
|
0
|
5
|
6101
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 12-13-2021 01:47 PM | |
| 1 | 10-13-2020 02:54 PM | |
| 1 | 03-09-2020 04:38 AM | |
| 1 | 02-23-2022 08:50 PM | |
| 1 | 01-31-2022 05:22 PM |
| Online Status |
Offline
|
| Date Last Visited |
03-13-2022
07:27 PM
|