Latest Contributions by VishApte

This is more of a discussion than a question... With UN model, we have only 3 feature classes per domain; Junction, Device and Line to model the assets. Most of the "assets" will be either a Device or a Line. I understand that this is by-design for performance reasons. In traditional data modeling, we used separate feature classes for asset types e.g. Fuse, Switch, Circuit Break, Transformer, Service Connection, HV Conductor, LV Conductor, Busbar etc. for Electric Distribution model.  Working with only two meaningful feature classes for some disparate asset types creates an under-normalised data model. It either creates a huge table with only a fraction of fields populated for any row or overloads fields for each subtype e.g. "Rating" attribute will be used as "KVA Rating" for a Transformer, "Load Break amps" for Fuse, "Maximum current" for a Regulator and so on. Some of the clients I work with tend to store electrical characteristics for devices and lines in GIS e.g. impedance and reactance for transformer etc. With separate field for each classification and sub-classification will easily create a table with more than 250 fields, not a best option from DBA point of view or we have to use generic fields such as "AttributeA", "AttributeB" etc. and then give alias (configure pop-up) in each layer which is time consuming exercise in the least not mentioning the heartache it gives to a data modeler.  It seems that Asset Package 3.x has tried to address the issue by creating related tables for devices and line wires. But it is still only two related tables. Will it be better to create a related table for each subtype e.g. Fuse Unit, Transformer Unit, Switch Unit, HV Conductor Wire etc. This way Device and Line feature class only stores network attributes and symbology attributes and individual tables stores electrical and EAM attributes for that type. It seems doable but have following questions; Can related tables participate in defining tracing? E.g. stop a trace if transformer KVA rating exceeds certain value or sum impedance of all lines traced.  Does UN editing support adding attributes to related tables?  Can data in related table be updated in client-server mode instead of Web Service mode? Can "Export Subnetwork" export attributes from a related table? All comments and suggestions welcome... Thanks, Vish ... View more

Hi, I have a client who has a requirement in UNME to trace from the Transmission Subnetwork Controller to a customer service connection or meter. This is tracing from the most upstream point in the electric network to the most downstream tracing point. As I understand, UNME traces such as Downstream Stream etc work on one domain at a time but can trace through multiple tiers. The model in UNTools 2.0.1 has Distribution and Transmission as two separate domains. I am wondering if there is a Utility Network Asset Package available with Electric Distribution and Transmission assets combined in a single domain?  Cheers, Vish ... View more

Hi, I have an Enterprise Geodatabase in SQL Server 2016 and I am building Utility Network using ArcGIS Pro 2.2. My geodatabase is created as DBO owned schema and not as SDE owned schema. When I set geodatabase connection properties with versioning type set to Branch, it sets the version name as DEFAULT and owner as "SDE" and does not let me choose different owner. I do not have SDE log-in or SDE user in the SQL Server database. Will any functionality be affected if I start using branch versioning without SDE user in the database? Cheers, Vish ... View more