Network Configuration Data Model Version Last Update Configuration Location Data Loading Tools Location Migration Tools Location
http://esriurl.com/electricunconfig
https://solutions.arcgis.com/shared/help/data-loading/
http://esriurl.com/commsunconfig
http://esriurl.com/gasunconfig
esriurl.com/waterdistunconfig
http://esriurl.com/waterdistmigration
This table shows the current status of Utility Network Industry Configurations and data loading tools. It will be kept up to date.
Resource specific data models for the utility network are contained in the corresponding Network Configuration. For example, if looking for the water distribution data model for the utility network download the Water Distribution Data Management for ArcGIS Enterprise.
Hi there,
Where can one find the location of the file geodatabase to download that is the schema, etc of the above configurations? I keep hearing about this with no direction/location of where to find it.
Thanks
What type of network do you want the schema for? Meaning electric distribution, gas or water distribution.
Howard,
I'm after Electric Distribution & Gas at the moment. In time, I'll be looking for Electric Transmission & Telecommunnications when they become available.
You need the asset packages included with these configurations:
esriurl.com/elecdistunconfig
esriurl.com/gasunconfig
For each of those configurations look under the Get Started tab. Step 3 is what will give you the asset packages that contains the schema you can load to the utility network.
This explains what is included in the Industry Configurations - https://www.esri.com/arcgis-blog/products/product/electric-gas/introducing-utility-network-configurations/
If you need more help let us know.
Thanks for this. I'm having trouble with Step 2 in finding the untools with python add in part of ArcGIS Pro. I have asked this question as Plan B to see what can be obtained until this issue of mine is resolved.
Any Updates on this, it is over 6 months old? Is this still the correct location?
Hi,
I am looking for a Data Interop migration tool for Electric Transmission and Distribution as mentioned in the http://proceedings.esri.com/library/userconf/proc18/tech-workshops/tw_1771-55.pdf
We have Electricity Distribution and Transmission lines and devices data in a Geometric Network and some relationship tables similar to "Containment" and "Attachment" associations. We would like to build a Utility Network with all 5 rule types and wondering if there is Work Bench or Data Interop tool available? At this time, we are not looking to build terminal level connectivity.
Thanks,
Vish
Vish,
I have been working with Safe software and have a "beta" of the electric migration tools workbench. As always, FME is a starting point just like the AssetPackage itself. Having worked with FME for over 14 years, it will require someone with a very good working knowledge of the source and destination DM and FME, this is not going to be an OOTB solution but a starting point. I have already built several workbenches to do this, Geometric Network to UN for both Gas and Electric, and each one turns out to be specific. You can, and I have, created custom transformer that are generic, but as we all know, everyone does things "just a little bit differently". But the tools will make this process easier than a lot of custom code.Rich
Hi Rich,
Thanks for your reply. Where can I get this beta workbench?
I have used FME / Data Interop for some time and have reasonable understanding. Have used SchemaMapper transformer to perform most source to destination ETL for feature classes, table and attributes including splitting features based on attributes, merging features etc. With UN model, the data needs to be in Asset Package first in correct format and haven't mastered the Asset Package nuances just yet. And as always, there is a pressure to get the data in UN model quickly, So was wondering if I could use any pre-cooked models.
Cheers,
At the end of last year there was a training done by Safe software (FME) and Esri:
https://knowledge.safe.com/articles/73939/fme-training-course-for-esri-utility-network-migra.html
Recordings can be found here:
https://www.gotostage.com/channel/fmeesriun
For the basic migration of the electric UN a FME workbench was shared, although I notice that the donwload page does not include a download of the workbench for electric (it does for gas and water UN):
https://knowledge.safe.com/articles/72048/utility-network-migration-tools.html
Hi All,
Is there an updated set of migrations tools for the Water Utility Network Migration?
Currently with the Water Utility Network Migration, there seems to be a few miss-matches between the migration tool and the current Asset Package Template. (it looks like the Asset Package Template was updated recently?)
For example in "WaterSchemaMapper.xlsx" the "MATERIAL" field from the LGIM is being mapped to the 'AssetType' field of the Utility Network features. However it seems like it should be getting mapped to the "MATERIAL" field of the Utility Network.
Jordan
Hi Jordan,
You are right, the latest Water Distribution asset package (v2.4) has shifted from "material" based assettype for lines to "delivery type" (e.g. Rural Service, Residential Service, Dist Main, Trunk main etc) based assettypes. "material" is now an attribute on its own for WaterLine. The FME tool has not been updated accordingly, and not sure if and when it will be.
You probably need to reset the schemamapper spreadsheet to match the new model.
Thanks Vish, I really appreciate the response - it's good to know I'm not just missing something.
No problem I can update the schema mapper to suit, if there's any other gotchas you (or anyone else reading this) can think of - due to the difference between FME toolset and current Asset Package let me know!
Also, is there some kind of changelog somewhere which may have pointed this out?
Hi Vish,
To be sure. Do I understand it correctly that the water data model leaves material as asset type completely?
@Tom DeWitte, @Mike Miller, in the UPDM material is still an asset type.
What is the vision here for the gas data model? Is a sort of alignment on the roadmap?
Thx,
Barend
Hi Barend,
Not sure what the plan is for APDM model but Water Distribution Asset Package's (v.2.4) WaterLine now has following asset groups.
And it has following asset types for Water Main and Service groups.
I personally think newer model is better as creating association and connectivity rules for each material based asset type is a lot of topology modelling work.
UPDM and the Gas Pipe Utility network configuration was made with material as the Asset Types to build rules to control which types of pipes, fittings, etc can be connected. Do you not require rules by material in your implementation?
I'm not sure if this is the most effective place to mention this, but we've spotted a glitch in the latest water distribution asset package (3.2) - it is designed to report the "service connection count" per subnetwork but isn't correctly configured to do so within most of its tiers. It turns out to be quite easy to fix - by editingthe relevant records in the "B_Subnetwork_Summaries" table of the package GDB before applying it to the enterprise GDB.
Hi Andrew,
Thank you for letting us know! I have updated the summaries table for version 3.3 that will release in January.
Hi All,Is there a way to incorporate cardinality rules in the utility network that define how many edges can be connected to a single device/junction. An example of this would be limiting the maximum number of edges that can connect to a X-Junction (cross junction) to 4.Thanks everyone!
The Utility Network does not model cardinality, but it can be enforced, restricted or flaged as error with an Attribute Rule. Here is an example of a constraint rule I created to reject too many related features by type. This could also be done as a validation rule where instead of preventing the edit, it would just mark the issue as an error when the rule was violated.
https://github.com/MikeMillerGIS/arcade-expressions/blob/master/attribute_rule_constraint/reject_too_many_related.md
Michael,
Thank you for the link to the item within your git repo. The other rules in this repo are very interesting and will definitely be looking into some of these in the future.
Just a quick question - How much overhead to the user do these cause? Especially when it comes to looking up values from other feature classes (eg. restrict editing rule looking up the user access from the fgdb)? Is the delay noticeable everything it fires on the insert/update/delete?
I am not sure, but the editors should not notice this as it is done in the database.
Similarly, the transsubnetworklength and distsubnetworklength summary attributes should be based on the summed lengths of lines with an asset type of 1 and 2 (respectively) - rather than asset groups 1 and 2.This can be fixed in an existing utility network (with topology disabled) by running Add Network Attribute, Set Network Attribute, and Set Subnetwork Definition.
The link to the sewer configuration appears to be broken. Ideally, I'm looking for an FME workbench for sewer if that exists...
Thank you for letting us know the links are not working, we will get them fixed today.
A workbench for sewer does not exist.
The Sewer Utility Network foundation is here - https://solutions.arcgis.com/water/help/sewer-utility-network-foundation/
I would explore the Data Loading tools for migration - https://solutions.arcgis.com/shared/help/data-loading/
Hi Mike,
Do we have an indicative release date on data loading for other utility networks, specifically sewer?
We'd like to see if these things are tailored to migrating from an Esri geometric network or they could be used for other sources like in our locale.
Do they handle complex transformations?
Chris
Hi Chris,
We don't anticipate releasing Utility Network Data Loading for Sewer in the short term. My suggestion is to use the generic Data Loading Tools Data Loading Tools | ArcGIS Solutions with your input sewer data and your desired output asset package and establish the mapping yourself.
Think of Water Utility Network Data Loading Water Distribution Utility Network Data Loading | ArcGIS Solutions for Water as the Data Loading Tools preconfigured for a common representation of a water distribution system as the source and the most recent water asset package as the target. The documentation includes some additional useful info when working with water datasets, but will highlight concepts that will help you with sewer or other data sets.
So you would use the same tools - Data Loading - just feed your source and target in and establish your own mappings. Yes, you would have to do some extra work, but we've heard from other organizations loading sewer data that once they understand how the Data Loading Tools work it is a quick process to set it up for their specific source and target.
Hope that helps.
Regards,
Howard
Hi, I would like to know if there is an ETA for the Fiber configuration 1.0 release (Anticipated Q3 2020 is this the 1.0 release) and if any of the following artifacts would be provided for Fiber or any of the telecom configurations.
It's great to see that the water industry data models are still being worked on, but there seems to be a minor inconsistency in the asset package GDB provided within the "Sewer Data Management for ArcGIS Enterprise" solution (v1) zip file - the rename table still has references to "collector force main" and "interceptor force main" asset types which have elsewhere been replaced with a single "force main" asset type.Can we simply add another record to this table to support renaming of the new asset type, and ignore/remove the rename records pertaining to the asset types that have been deprecated?
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
