topic Re: Additional asset information in Utility Network 2.0 in Gas and Pipeline Questions https://community.esri.com/t5/gas-and-pipeline-questions/additional-asset-information-in-utility-network-2/m-p/701683#M563 <HTML><HEAD></HEAD><BODY><P>For medium and large sized utilities a lot of this detail is stored and maintained inside external asset management systems (Cityworks, SAP, Maximo, and WAM are the ones I've seen the most).&nbsp;&nbsp;Related data you're going to be using in things like collector is going to be captured in related tables (the example packages have inspections done this way).&nbsp; Other misc related data can be stored in flat tables and then either related or joined to the source data&nbsp;as needed.&nbsp; I wouldn't recommend having these joins and relates in your day-to-day editing displays since they'll impact performance, but having specific views that pull in several aspects of this data at a time is pretty typical.</P></BODY></HTML> Tue, 31 Jul 2018 00:26:47 GMT RobertKrisher 2018-07-31T00:26:47Z Additional asset information in Utility Network 2.0 https://community.esri.com/t5/gas-and-pipeline-questions/additional-asset-information-in-utility-network-2/m-p/701682#M562 <HTML><HEAD></HEAD><BODY><P>I don't see anywhere for additional asset information to stored in the new Utility Network 2.0.&nbsp; Manufacturer information, service dates... additional information that could be useful to a worker in the field.&nbsp; ESRI recommends against using joins with this data.&nbsp; Is that what Notes is for?&nbsp; Are we supposed to add a lot of additional fields?&nbsp; Does anyone have a strategy for this type of information?</P></BODY></HTML> Mon, 30 Jul 2018 18:53:19 GMT https://community.esri.com/t5/gas-and-pipeline-questions/additional-asset-information-in-utility-network-2/m-p/701682#M562 StevenBell2 2018-07-30T18:53:19Z Re: Additional asset information in Utility Network 2.0 https://community.esri.com/t5/gas-and-pipeline-questions/additional-asset-information-in-utility-network-2/m-p/701683#M563 <HTML><HEAD></HEAD><BODY><P>For medium and large sized utilities a lot of this detail is stored and maintained inside external asset management systems (Cityworks, SAP, Maximo, and WAM are the ones I've seen the most).&nbsp;&nbsp;Related data you're going to be using in things like collector is going to be captured in related tables (the example packages have inspections done this way).&nbsp; Other misc related data can be stored in flat tables and then either related or joined to the source data&nbsp;as needed.&nbsp; I wouldn't recommend having these joins and relates in your day-to-day editing displays since they'll impact performance, but having specific views that pull in several aspects of this data at a time is pretty typical.</P></BODY></HTML> Tue, 31 Jul 2018 00:26:47 GMT https://community.esri.com/t5/gas-and-pipeline-questions/additional-asset-information-in-utility-network-2/m-p/701683#M563 RobertKrisher 2018-07-31T00:26:47Z