nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Visão rápida sobre Utility and Pipeline Data Model 2020

TomDeWitte

Por Tom Coolidge e Tom DeWitte

No início deste mês, a Esri lançou o Utility and Pipeline Data Model (UPDM) 2020. Esta versão continua a prática da Esri de manter um modelo de dados template pronto para uso imediato para gerenciar dados de sistemas de tubulação de gás natural e líquidos perigosos dentro de um geodatabase Esri. Esta versão inclui melhorias para acompanhar as mudanças nas práticas da indústria e nos requisitos regulatórios.

Novidades para 2020

A equipe de desenvolvimento de software da Esri continua a aprimorar e evoluir as capacidades do geodatabase. Acompanhar esses avanços é uma atividade contínua. Além do modelo de dados representar uma melhor prática sobre como aproveitar o geodatabase, o modelo de dados também representa um repositório de conhecimento da indústria. Grande parte da estrutura e conteúdo deste modelo de dados é baseada no feedback dos muitos usuários da indústria de gás e líquidos perigosos da Esri.

Para a edição 2020, o foco especial foi em três áreas-chave:

Incorporação de novas capacidades do geodatabase
Ajustes para atender às novas práticas da indústria e requisitos regulatórios
Feedback dos clientes

Incorporação de Novas Capacidades do Geodatabase

Duas melhorias recentes foram incorporadas ao UPDM 2020. Essas melhorias são Attribute Rules e Contingent Values.

Uma attribute rule é um script arcade que automatiza uma tarefa de edição, como preencher um atributo ou definir uma associação na utility network. O script está embutido dentro do geodatabase. Isso garante que a automação dos dados e as propriedades de garantia dos dados da attribute rule sejam sempre acionadas independentemente do aplicativo cliente Esri que realiza a edição. Com o UPDM 2020, regras de atributo foram adicionadas para automatizar as seguintes tarefas de edição:

Criar automaticamente uma associação de contenção quando uma feição conteúdo estiver espacialmente contida por ou dentro da distância de uma feição container válida.
Preencher automaticamente o valor do atributo "material" com o valor "assettype" para aqueles materiais que têm o mesmo valor para "assettype" e "material". Isso se aplica a Cast Iron, Ductile Iron e Other.

Um contingent value é uma restrição dinâmica sobre os valores em uma lista de domínio codificado baseada no valor definido por outro atributo que não seja o campo subtype. No UPDM 2020, uma listagem contingent value foi adicionada à featureclass PipelineLine para limitar as escolhas válidas para os atributos "material" baseados no valor "assettype". Por exemplo, quando o editor está posicionando um segmento de tubo com um valor "assettype" de "Coated Steel", o atributo "material" é dinamicamente restringido para limitar a lista de seleção do editor apenas a graus de aço (Grade A, Grade X42, Grade X60, etc).

Ajustes às Práticas da Indústria

Acompanhar as mudanças nas práticas da indústria e nos requisitos regulatórios é um esforço contínuo. Para operadores nos Estados Unidos, um novo conjunto de regulamentos federais para gasodutos terrestres entrou em vigor em 1º de julho de 2020. Um desses regulamentos é o 192.607, Verificação das Propriedades e Atributos do Material do Gasoduto: Gasodutos terrestres em aço. Este novo regulamento define mudanças nas informações que um operador de transmissão deve manter durante toda a vida útil do ativo tubo. Muitas pessoas na indústria referem-se a essa nova prática regulatória obrigatória como rastreável, verificável e completa.

Para ajudar os operadores terrestres a adotarem essa nova prática da indústria, várias mudanças foram feitas no UPDM 2020.

Adicionados atributos ao PipelineJunction para gerenciar "X-Ray Number" e "Joint Coating Type" em conexões.
Adicionado atributo ao PipelineLine para gerenciar "Mill Test Pressure", "Heat Number" e "Joint Number" para melhorar o gerenciamento dos dados de fabricação do tubo.
Adicionados atributos ao PipelineDevice para gerenciar dados "Remote Operation", "Operator Type" e "Device Actuator Type" para melhorar o gerenciamento dos dispositivos com capacidades de operação remota.

Melhorias Devidas ao Feedback dos Clientes

Muitos clientes no final de 2019 e início de 2020 foram gentis em dedicar tempo para compartilhar lições aprendidas com sua implementação do UPDM 2019. Muitas dessas lições aprendidas foram incorporadas ao UPDM 2020. Uma amostra das mudanças baseadas no feedback dos clientes inclui:

Aumento do comprimento do campo texto do atributo LocationDescription da PipelineLine de 100 para 255.
Mudança do valor padrão dos atributos WarningTape e TraceWire da PipelineLine de "Yes" para "No" para o subtype "Transmission Pipe".
Adição do subtype "Pipe Bend" à featureclass PipelineJunction para melhor suportar o gerenciamento dos dados de transmissão.
Movimento da featureclass "P_PipeCrossing" para dentro do dataset PipeSystem para suportar seu uso como evento referenciado linearmente com a solução ArcGIS Pipeline Referencing.

Gerenciamento Empresarial de Dados Gas and Pipeline

Para muitas empresas utilitárias e operadoras de gasodutos, implantar a plataforma ArcGIS que aproveita os conceitos de um webgis orientado a serviços é mais do que carregar o modelo de dados UPDM 2020 em um geodatabase empresarial. Requer etapas adicionais como criar um mapa ArcGIS Pro configurado para publicar o modelo de dados, publicar o mapa Pro para criar os serviços necessários de mapa e feição e, talvez, configurar um sistema de localização referenciada. Para ajudar a simplificar essas etapas adicionais realizadas com UPDM 2020, a Esri incorporou o UPDM 2020 em uma nova solução ArcGIS for Gas. A nova solução chama-se Gas and Pipeline Enterprise Data Management. Esta solução fornece UPDM 2020, dados exemplo e um projeto ArcGIS Pro configurado com tarefas e mapas otimizados para desempenho. Você pode acessar esta solução no site Esri ArcGIS For Gas:

https://solutions.arcgis.com/gas/help/gas-pipeline-enterprise-data-management/

Como parte da incorporação do UPDM 2020 nesta nova solução da indústria do gás, o dicionário de dados foi convertido em uma página web online pesquisável. Isso simplificará a busca pelo dicionário que antes tinha 800 páginas. Você pode acessar diretamente o novo dicionário online UPDM 2020 através deste link:

https://solutions.arcgis.com/utilities/data-dictionary/index.html?cacheId=699ffe0419684c288bc6c5d638355b6e

Para mais informações sobre Gas and Pipeline Enterprise Data Management e as informações adicionais que ela fornece, você pode ler o seguinte storymap.

https://storymaps.arcgis.com/stories/02cf898e224b49be87babc1d7699201b?rmedium=links_esri_com_s&rsource=https%3A%2F%2Flinks.esri.com%2FSolutions%2FGasPipelineEnterpriseDataManagement%2FGettingtoKnow

Para aqueles que não estão familiarizados com UPDM e seu objetivo, aqui está uma visão geral rápida.

O que é UPDM

UPDM é um modelo template de dados geodatabase para operadores de redes de tubulação nas indústrias de gás e líquidos perigosos. UPDM é um modelo moderadamente normalizado que representa explicitamente cada componente físico da rede de tubos desde a cabeça do poço até o medidor do cliente no caso do gás, ou desde a cabeça do poço até o terminal ou ponto de entrega no caso dos líquidos perigosos, em um único objeto tabela no banco de dados.

UPDM é o único modelo da indústria capaz de gerenciar uma representação única do sistema completo de tubulação. Para muitas empresas ao redor do mundo este repositório único alinha-se bem com práticas empresariais para integrar verticalmente processos comerciais e operações.

Por que UPDM

O objetivo do Esri UPDM é tornar mais fácil, rápido e econômico para operadores de gasodutos e utilitários implementar a plataforma ArcGIS. O Esri UPDM alcança isso fornecendo gratuitamente um modelo de dados que aproveita totalmente as capacidades do geodatabase. O modelo foi criado e testado com produtos ArcGIS para garantir seu funcionamento. Isso reduz significativamente a complexidade, tempo e custo para implementar um repositório espacialmente habilitado para sistemas pipe hazardous liquid ou gas.

Perspectivas para UPDM 2021

Um homem sábio disse certa vez “a mudança é a única constante.” Esta é uma ótima citação ao pensar sobre o futuro do UPDM. A equipe Esri continuará aprimorando as capacidades do ArcGIS. A indústria continuará evoluindo suas práticas. Para continuar ajustando às práticas da indústria e incorporando novas capacidades ArcGIS, o Utility and Pipeline Data Model continuará evoluindo. Essas mudanças serão constantes por muitos anos ainda.

Encontre mais publicações marcadas com

Gas

Pipeline

Comentários

Cristian_Galindo

Hi,

I was just checking the Data dictionary (using the link provided above) and I was not able to found neither the layers for DA Survey Readings or the layers related to ILI. Are those layers were removed? What is the strategy to store that information?

GelisaJoseph

Cristian,

We have updated the dictionary to include all layers included in the data model for the Gas and Pipeline Data Management for ArcGIS Enterprise solution. I have added the link for you below.

Data Dictionary

cpolley

@GelisaJoseph , What would it take to just update the link with the correct data dictionary instead of having an old link above listed in the article and the current data dictionary in comment posts. Having it like this can lead to confusion.

Old Data Dictionary

New Data Dictionary

TomDeWitte

Excellent suggestion. I have updated the article to include the correct link. The "New Data Dictionary" link is now embedded in the article.

Thank you for this recommendation

Tom DeWitte

Esri

APurviance

Hello,

Is there anyway I can obtain a UPDM data model in Excel format? or generate one somehow. I am trying to study the model without any GIS software at the moment.

Thank you,

Allison

cpolley

Allison, you could just look at the data dictionary posted above which will also provide descriptions for field types , domains etc, an excel file might be overwhelming and not provide

HarshalGharat

The so called 'enhanced data dictionaries' are an absolute pain to navigate if one wants to understand the data model. Why are you complicating the things? I always prefer the HTML version of data dictionary which comes along with the solutions template.

Cristian_Galindo

I try to understand the Data Model:

I started using the "Gas and Pipeline Data Management for ArcGIS Enterprise", I made the deployment of the version 1.2 (it includes a UPDM deployment solution for the version 2020).

Following the instructions provided in here I tried to prototype a single user environment with WGS 1984 as Geographical Coordinates Reference system.

Then I enabled APR (no UN), and add some centerlines to the model, create the routes in the Engineering Network, then update the Continuous Network.....so far..so good.

I wanted to upload some events to the PipelineDevice Feature Class. therefore, I added the feature class to the LRS, prepare a table with the data to upload (name, route, engm, route id, etc. except the geometry). I am using the Append Events tool, then I receive the error message:

Append Events
=====================
Parameters

Input Event PipelineDevice_FeaturesToUploadEvents_CopyFeatures
Target Event PipelineDevice
Field Map ASSETGROUP "Asset group" true false true 4 Long 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,ASSETGROUP,-1,-1;ASSETTYPE "Asset type" true false true 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,ASSETTYPE,-1,-1;TERMINALCONFIGURATION "Terminal Path" true false true 128 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,TERMINALCONFIGURATION,0,128;adddetails "adddetails: Additional Details, Clockwise to Close" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,adddetails,-1,-1;devicestatus "Device Status" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,devicestatus,-1,-1;regulatorytype "Regulatory Type" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,regulatorytype,-1,-1;designtype "Type" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,designtype,-1,-1;accessible "Accessible" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,accessible,-1,-1;yesno "yesno: Drain Valve Indicator, Internal Meter, SCADA Indicator" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,yesno,-1,-1;turnstoclose "Turns to Close" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,turnstoclose,-1,-1;normalposition "Normal Position" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,normalposition,-1,-1;installdate "Install Date" true true false 8 Date 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,installdate,-1,-1;inservicedate "In-Service Date" true true false 8 Date 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,inservicedate,-1,-1;assetid "Asset ID" true true false 64 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,assetid,0,64;serialnumber "Serial Number" true true false 20 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,serialnumber,0,20;ownedby "Owned By" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,ownedby,-1,-1;maintby "Maintained By" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,maintby,-1,-1;lifecyclestatus "Lifecycle Status" true false false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,lifecyclestatus,-1,-1;maopdesign "MAOP Design" true false false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,maopdesign,-1,-1;maoptest "MAOP Test" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,maoptest,-1,-1;maoprecord "MAOP Record" true false false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,maoprecord,-1,-1;depth "Depth" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,depth,-1,-1;depthtonut "Depth to Nut" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,depthtonut,-1,-1;measuredlength "Length" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,measuredlength,-1,-1;diameter "Diameter" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,diameter,-1,-1;maxinletpressure "Max Inlet Pressure" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,maxinletpressure,-1,-1;maxoutletpressure "Max Outlet Pressure" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,maxoutletpressure,-1,-1;setpressureentered "Set Pressure Entered" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,setpressureentered,-1,-1;setpressurestandard "Set Pressure Standard" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,setpressurestandard,-1,-1;symbolrotation "Symbol Rotation" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,symbolrotation,-1,-1;barcode "Barcode" true true false 16 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,barcode,0,16;manufacturer "Manufacturer" true true false 2 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,manufacturer,0,2;manufacturerlotno "Manufacturer Lot #" true true false 4 Long 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,manufacturerlotno,-1,-1;manufacturedate "Manufacture Date" true true false 8 Date 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,manufacturedate,-1,-1;manufacturecomponent "Manufacture Component" true true false 2 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,manufacturecomponent,0,2;material "Material" true true false 2 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,material,0,2;casingmaterial "Casing Material" true true false 20 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,casingmaterial,0,20;devicename "Name" true true false 20 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,devicename,0,20;quantity "Quantity" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,quantity,-1,-1;weight "Weight" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,weight,-1,-1;amperage "Amperage" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,amperage,-1,-1;usage "Usage" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,usage,-1,-1;duration "Duration" true true false 4 Long 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,duration,-1,-1;height "Height" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,height,-1,-1;notes "Notes" true true false 2000 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,notes,0,2000;iscritical "Critical Valve" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,iscritical,-1,-1;flowcapacity "Flow Capacity" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,flowcapacity,-1,-1;permanentindicator "Permanent Indicator" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,permanentindicator,-1,-1;spatialaccuracy "Spatial Accuracy" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,spatialaccuracy,-1,-1;depthunits "Depth Units" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,depthunits,-1,-1;diameterunits "Diameter Units" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,diameterunits,-1,-1;flowcapacityunits "Flow Capacity Units" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,flowcapacityunits,-1,-1;heightunits "Height Units" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,heightunits,-1,-1;lengthunits "Length Units" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,lengthunits,-1,-1;pressureunits "Set Pressure Units" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,pressureunits,-1,-1;maopunits "MAOP Unit of Measure" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,maopunits,-1,-1;usageunits "Usage Units" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,usageunits,-1,-1;usagerateunits "Usage Rate Units" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,usagerateunits,-1,-1;recordingmethod "Recording Method" true true false 25 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,recordingmethod,0,25;regulatorbodytype "Regulator Body Type" true true false 20 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,regulatorbodytype,0,20;outletdiameter "Outlet Diameter" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,outletdiameter,-1,-1;diaphragmdiameter "Diaphragm Diameter" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,diaphragmdiameter,-1,-1;premise "Premise" true true false 10 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,premise,0,10;indoormeter "Indoor Meter" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,indoormeter,-1,-1;operatingclassification "Operating Classification" true true false 40 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,operatingclassification,0,40;maxdifferentialpressure "Max Differential Pressure" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,maxdifferentialpressure,-1,-1;companypaidtelephone "Company Paid Telephone" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,companypaidtelephone,-1,-1;telephonenumber "Telephone Number" true true false 15 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,telephonenumber,0,15;usagerate "Usage Rate" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,usagerate,-1,-1;gpsx "GPS X" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,gpsx,-1,-1;gpsy "GPS Y" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,gpsy,-1,-1;gpsz "GPS Z" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,gpsz,-1,-1;legacyid "Legacy ID" true true false 38 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,legacyid,0,38;workorderid "Work Order ID" true true false 38 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,workorderid,0,38;projectnumber "Project Number" true true false 38 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,projectnumber,0,38;servicesummaryid "Service Summary ID" true true false 38 Guid 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,servicesummaryid,-1,-1;assetunitcode "Asset Unit Code" true true false 38 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,assetunitcode,0,38;eventid "Event ID" true true false 38 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,eventid,0,38;fromdate "From Date" true true false 8 Date 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,fromdate,-1,-1;todate "To Date" true true false 8 Date 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,todate,-1,-1;engrouteid "Engineering Route ID" true true false 38 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,engrouteid,0,38;engroutename "Engineering Route Name" true true false 100 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,engroutename,0,100;engm "Engineering Measure" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,engm,-1,-1;continrouteid "Continuous Route ID" true true false 38 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,continrouteid,0,38;continroutename "Continuous Route Name" true true false 100 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,continroutename,0,100;continm "Continuous Measure" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,continm,-1,-1;refmethod "Reference Method" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,refmethod,-1,-1;reflocation "Reference Location" true true false 50 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,reflocation,0,50;refoffset "Reference Offset" true true false 50 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,refoffset,0,50;bondedinsulated "Bonded/Insulated" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,bondedinsulated,-1,-1;cptraceability "Cathodic Protection Traceability" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,cptraceability,-1,-1;cpoverride "CP Override" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,cpoverride,-1,-1;locationdescription "Location Description" true true false 255 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,locationdescription,0,255;wallthickness "Wall Thickness" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,wallthickness,-1,-1;wallthickness2 "Wall Thickness 2" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,wallthickness2,-1,-1;diameter2 "Diameter 2" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,diameter2,-1,-1;temprating "Temp Rating" true true false 20 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,temprating,0,20;coolingmethod "Cooling Method" true true false 20 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,coolingmethod,0,20;rating "Rating" true true false 8 Double 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,rating,-1,-1;specification "Specification" true true false 30 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,specification,0,30;remoteoperation "Remote Operation" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,remoteoperation,-1,-1;valvekeysize "Valve Key Size" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,valvekeysize,-1,-1;modelnumber "Model Number" true true false 20 Text 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,modelnumber,0,20;deviceactuatortype "Device Actuator Type" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,deviceactuatortype,-1,-1;operatortype "Operator Type" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,operatortype,-1,-1;remotedevicefailtype "Remote Device Fail Type" true true false 2 Short 0 0,First,#,U:\Documents\ArcGIS\Projects\Prototype_APR\Prototype_APR.gdb\PipelineDevice_FeaturesToUploadEvents_CopyFeatures,remotedevicefailtype,-1,-1
Load Type ADD
Generate Event ID GUIDs for loaded events NO_GENERATE_EVENT_IDS
Generate Shapes GENERATE_SHAPES
Output Target Event PipelineDevice
Output Results File U:\Documents\ArcGIS\Projects\Prototype_APR\GP_A9C43.txt
=====================
Messages

Start Time: 24 August 2021 07:36:39
The target field SHAPE does not allow NULL values, but is not mapped
Failed to execute (AppendEvents).
Failed at 24 August 2021 07:36:40 (Elapsed Time: 1.29 seconds)

I am not able to change the definition of the Pipeline Device, and the tool does not allow me to map the SHAPE field (Let's say I create the geometry, and add it to my table of data)...so.... How that should be done???

MaximoMiller

What is the significance of the 6_ on all the DOMAIN names?

Thanks,

Miller

TomDeWitte

Hello Maximo Miller,

The prefix "6_" is an artifact of the Asset Package import process. The import tool adds a "#_" (NOTE: The number is not always "6") to insure that the newly imported domains do not conflict with any existing domains.

Tom DeWitte

Esri Technical Lead Natural Gas and District Energy

JSchroeder

Hi @Cristian_Galindo,

The error you receive with appending Events to the Pipeline Device feature class is expected because this Feature Class participates in the Utility Network. These base Utility Network Feature Classes have different requirements than APR is expecting for Events.

The Gas and Pipeline Data Management for ArcGIS Enterprise solution is intended to deploy the Utility Network, and as such, there is not a step for deploying the Asset Package without the Utility Network. However, if you enable APR with the UN, all of the Feature Classes which are not participating in the Utility Network (Anomaly, DOTClass, etc.) can facilitate Events. Last, if you wish to use the Utility Network Feature Classes like Pipeline Device or Pipeline Junction, there is a tool to update the Measure and Route ID on these features, which is documented here.

TomDeWitte

Adding to Jason's comments.

You can also leverage the current version of UPDM 2020 and configure it to use only linear referencing functionality. There are a few steps involved in modifying the 7 featureclasses which are configured with the Utility Network in the downloadable asset package, so that they can be utilized as point or linear events within the ArcGIS Pipeline Referencing framework. If this linear referencing only implementation pattern of UPDM 2020 is what you are looking to implement, you can contact myself (tdewitte@esri.com) or Jeff Allen (Jeff_Allen@esri.com) for more details.

Tom DeWitte

Esri Technical Lead Natural Gas and District Energy

Cristian_Galindo

@JSchroeder thanks for the info, As I mentioned, my geodatabase does not have the UN enable. According to the data dictionary the PipelineDevice FC is required to store the information of Valves, therefore I would like to use it.

"Last, if you wish to use the Utility Network Feature Classes like Pipeline Device or Pipeline Junction, there is a tool to update the Measure and Route ID on these features, which is documented here."

This sounds good, the issue is, I do not have features/rows in that feature class (because the error already mentioned), therefore It can not update measure and/or routes ID.

@TomDeWitte thanks a lot for your comment. I will contact you.

JSchroeder

Hi @Cristian_Galindo,

To make sure we are discussing the same workflow, if you followed the steps in the solution as you outlined, the Utility Network should be enabled. There are options to bypass the Pipeline or Structure domain networks, however, the Utility Network is deployed. To be clear, there is not a step to bypass the creation of the Utility Network, and as Tom mentioned, this would require some workaround.

You should be able to create features, such as valves in the Pipeline Device feature class and store measures and route ID on them (not the same as loading an Event). This feature class in this solution is intended to be used in the Utility Network, and has requirements which will not allow the loading of Events.

ArcGIS Pipeline Referencing manages Events, which cannot participate in the Utility Network (Device, Line, Junction, Assembly, SubnetLine). These feature classes can store 'Event information' using the 'Update Measures from LRS' tool, but they cannot participate as true Events. To reiterate, all the other feature classes in the UPDM which are not participating in the Utility Network can be modeled as Events.

For more information on Pipeline Referencing here is a very useful post: ArcGIS Pipeline Referencing - Useful Resources

Cristian_Galindo

Hello!!!!! again.....

I just download the version 2.1 of the Gas and Pipeline Referencing Utility Network Foundation. I started reviewing the Data dictionary and I want to be sure to have the latest, proper version of it.

Inside the project downloaded there is a link to the data dictionary, I start checking and found this:

Is this the latest version (of the data dictionary)?

Also found this discrepancy between the included data dictionary, and the online version:

I am trying to browse in the online version of the data dictionary, to me, the fact that not having the list sorted, make a little difficult to browse, and find objects (Yes, I know there is a "Search" option).

Thanks a lot for your support.

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.