Tracking and Traceability Deployment パターンの zip ファイルです。全体のソリューションの公開を支援するための Barcode decode GP Tool と MXD が含まれています。 <\/P><\/BODY><\/HTML>
One issue that was noted by a user was that after publishing the StagingGDB, they were unable to collect features using Collector for ArcGIS. The issue stems from the fact that the feature classes have z-values and when publishing directly from ArcMap to ArcGIS Online, the feature service sets "'enableZDefaults' : false,". Without the ability to collect z-values or set a default, Collector is not able to add new features. A workaround for this, is to create a Service Definition from ArcMap (Share As, Publish, Save a service definition file) and then uploads this to ArcGIS Online. This will set the "'enableZDefaults': true".
If publishing to ArcGIS Server, users can change the z-defaults parameter during the publishing stage.
Or, you can simply publish from ArcGIS Pro and the value will be set to 'true' as well.
Hello Tom, do you have an email i can contact you?
Hi Jordan,
You can reach me via my esri email account: tdewitte@esri.com
Tom
I was able to configure the script with my data, but I am having one problem. The barcode decoder only works if every feature has a barcode value entered. If one feature has a null value the tool will skip all other features that have barcodes and not decode any of them. Is there a way to get around this problem?
Thanks,
Brian
Matthew Baber & Tom DeWitte I understand that there is a newer version of the script? Would one of you guys mind helping out Brian?
Hi Brian,
Within the python script is a function called: AppendSelectedRecords. this function is where each featureclass of selected features is processed. The first part of this function runs a cursor to test individually each record in the featureclasses selected set. For each row it tests whether the BARCODE value is NULL. If it is NULL is skips the row and moves onto the next row in the selection set. If the BARCODE value is populated, it attempts to decode it.
There is messaging built into the function to indicate for each ROW whether it thinks the BARCODE is NULL or whether it is processing the BARCODE.
If you are not seeing either of these two messages, than the script is not seeing a selection set. When this occurs you should see a message stating: "No Selected Staging Features".
This would happen if you did not run the tool interactively in ArcMap, and draw the polygon which is used to intersect (ie. Select by Location) the staging featureclasses.
Hope this helps
Tom DeWitte
Technical Lead - Natural Gas Industry
Esri, Inc
Yes, we have successfully prototyped the use of Arcade scripting and the new Attribute Rule capability to automatically decode the ASTM F2897 barcodes. There are a couple of minor issues with the scripts that we have not yet had a chance to address. Specifically;
1) The Error handling of the Manufacture Date is not consistently working correctly in all use cases.
2) For Diameter and Wallthickness the decoding of a 2 diameter fitting (i.e. reducer) is not processing correctly. Single diameter fittings and pipe are working correctly.
These Attribute Rules will work with Collector, ArcGIS Pro, and web maps. They do not work within ArcMap. Additionally they require an Enterprise Geodatabase working with ArcGIS Enterprise 10.6.1 or higher.
Until, there two known issues are resolved, I do not intend to post the arcade scripts. But, if you are interested in using them, please contact me directly and I will provide them to you.
email: tdewitte@esri.com
Hi Tom,
It doesn't appear that the script I am running is testing each row whether the BARCODE value is NULL. If I have any that are null at all it fails. I am using ArcMap 10.6.
My Gas Main Connector layer is the only current layer that has Barcode values populated.
Appending Gas Main Connector Processing Barcode = PE3tlZ96MB830v60 Processing Barcode = NoneFailed script AppendStagingGDBData...
Traceback (most recent call last): File "R:\Tracking and Traceability\AppendStagingGDBData.py", line 442, in <module> AppendSelectedRecords(Staking_GasMainConnector, Enterprise_GasMainConnector, Feature_Set, "MANUFACTURER","MANUFACTURELOTNO","","","","","","","") File "R:\Tracking and Traceability\AppendStagingGDBData.py", line 180, in AppendSelectedRecords MFGMATERIAL = BARCODE[9]IndexError: string index out of range
Failed to execute (AppendStagingGDBData).Failed at Wed Nov 14 14:41:54 2018 (Elapsed Time: 54.81 seconds)
# ---------------------------------------------------------------------------# AppendStagingGDBData.py# Created on: 2016-09-23# Updated on: 2017-04-11 Added support for multi-diameter devices## Usage: AppendStagingGDBData <Feature_Set>## Description: Purpose is to interactively select the hosted feature layer data# which was collected via digital as-builting and load it into the enterprise GDB.# As part of the append process the BARCODE value is decoded and attirbutes are# auto-populated.# ---------------------------------------------------------------------------
# Import arcpy moduleimport collectionsimport sys, os, arcpy, traceback, datetimefrom arcpy import envimport math
arcpy.env.overwriteOutput = Truearcpy.env.maintainAttachments = True
# Script argumentsFeature_Set = arcpy.GetParameterAsText(0)if Feature_Set == '#' or not Feature_Set: arcpy.AddMessage("Feature Set is Empty") Feature_Set = "in_memory\\{E4B69402-D56F-43EB-91A6-E84B26D09D9F}" # provide a default value if unspecified
# Staging Geodatabase Layers:Staking_GasServicePoint = "Staking\\Gas Service Point"Staking_GasMainPipe = "Staking\\Staking Gas Main Pipe"Staking_GasDimension = "Staking\\Staking Gas Dimension"Staking_GasAnode = "Staking\\Staking Gas Anode"Staking_GasValve = "Staking\\Staking Gas Valve"Staking_GasCPTestPoint = "Staking\\Staking Gas CP Test Point"Staking_GasFlowControlDevice = "Staking\\Staking Gas Flow Control Device"Staking_GasFitting = "Staking\\Staking Gas Fitting"Staking_GasMonitoringDevice = "Staking\\Staking Gas Monitoring Device"Staking_GasServiceValve = "Staking\\Staking Gas Service Valve"Staking_GasLocatingPoint = "Staking\\Staking Gas Locating Point"Staking_GasMainConnector = "Staking\\Staking Gas Main Connector"Staking_GasServicePipe = "Staking\\Staking Gas Service Pipe"# StagingAnode = "RockGas.DBO.Staking\\Anode"# StagingRectifier = "RockGas.DBO.Staking\\Rectifier"# StagingProjectLocation= "RockGas.DBO.Staking\\Project Location"
# Enterprise Geodatabase Layers:Enterprise_GasServicePoint = "Master\\Gas Service Point"Enterprise_GasMainPipe = "Master\\Gas Main Pipe"Enterprise_GasDimension = "Master\\Gas Dimension"Enterprise_GasAnode = "Master\\Gas Anode"Enterprise_GasValve = "Master\\Gas Valve"Enterprise_CPTestPoint = "Master\\Gas CP Test Point"Enterprise_GasFlowControlDevice = "Master\\Gas Flow Control Device"Enterprise_GasFitting = "Master\\Gas Fitting"Enterprise_GasMonitoringDevice = "Master\\Gas Monitoring Device"Enterprise_GasServiceValve = "Master\\Gas Service Valve"Enterprise_GasLocatingPoint = "Master\\Gas Locating Point"Enterprise_GasMainConnector = "Master\\Gas Main Connector"Enterprise_GasServicePipe = "Master\\Gas Service Pipe"# Enterprise_CompressorStation = "RockGas.DBO.Network\\Pipe System\\Compressor Station"# Enterprise_Tank = "RockGas.DBO.Network\\Pipe System\\Tank"# Enterprise_RectifierCable = "RockGas.DBO.Network\\CP System\\Rectifier Cable"# Enterprise_GasDimension = "RockGas.DBO\\CP System\\GasDimension"# Enterprise_GasPipeCasing = "RockGas.DBO.Network\\Pipe System\\Gas Pipe Casing"# Enterprise_BondJunction = "RockGas.DBO.Network\\CP System\\Bond Junction"# Enterprise_TestPoint = "RockGas.DBO.Network\\CP System\\Test Point"# Enterprise_Anode = "RockGas.DBO.Network\\CP System\\Anode"# Enterprise_Rectifier = "RockGas.DBO.Network\\CP System\\Rectifier"# Enterprise_ProjectLocation= "RockGas.DBO.Network\\Project Location"# Enterprise_PipelineMarker = "RockGas.DBO.Network\\Pipeline Marker"# Enterprise_MainJobSeparator = "RockGas.DBO.Network\\Pipe Job Separator"
################################################################################ Function Convert Base62 to Base 10## ---------------DO NOT MODIFY THIS FUNCTION--------------------################################################################################BASE2 = "01"BASE10 = "0123456789"BASE16 = "0123456789ABCDEF"BASE62 = "0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ"
def baseconvert(number,fromdigits,todigits): """ converts a "number" between two bases of arbitrary digits
The input number is assumed to be a string of digits from the fromdigits string (which is in order of smallest to largest digit). The return value is a string of elements from todigits (ordered in the same way). The input and output bases are determined from the lengths of the digit strings. Negative signs are passed through.
decimal to a base that uses A-Z0-9a-z for its digits >>> baseconvert(257938572394L,BASE10,BASE62) 'E78Lxik'
..convert back >>> baseconvert('E78Lxik',BASE62,BASE10) '257938572394' """
if str(number)[0]=='-': number = str(number)[1:] neg=1 else: neg=0
# make an integer out of the number x=0 for digit in str(number): x = x*len(fromdigits) + fromdigits.index(digit)
# create the result in base 'len(todigits)' if x == 0: res = todigits[0] else: res="" while x>0: digit = x % len(todigits) res = todigits[digit] + res x = int(x / len(todigits)) if neg: res = "-"+res
return res
############################################################################## Function Append Selected Records## ---------------DO NOT MODIFY THIS FUNCTION--------------------## StagingLayer- Name of TrackingGDB Staging Layer to have its selected features appended# EnterpriseLayer- Name of the EnterpriseGDB Enterprise Layer to receive the selected features of the TrackingGDB Staging Layer# FeatureSet- The User defined polygon which will act as a spatial filter on the TrackingGDB Staging Layer# MANUFACTURER- Name of the EnterpriseGDB Enterprise layer field to store the ASTM barcode Manufacturer name# MFGLOTNO- Name of the EnterpriseGDB Enterprise layer field to store the ASTM barcode Manufacturer Lot number value# MANUFACTUREDATE- Name of the EnterpriseGDB Enterprise layer field to store the ASTM barcode Manufacturer Date# MANUFACTUREMAT- Name of the EnterpriseGDB Enterprise layer field to store the ASTM barcode Manufacturer Material value# MANUFACTURECOMP- Name of the EnterpriseGDB Enterprise layer field to store the ASTM barcode Manufacturer Model value# MANUFACTUREDIAMETER- Name of the EnterpriseGDB Enterprise layer field to store the ASTM barcode Manufacture Diameter value# MANUFACTUREWALLTHICK- Name of the EnterpriseGDB Enterprise layer field to store the ASTM barcode Manufacture Wall thickness value# MANUFACTUREDIAMETER2- Name of the EnterpriseGDB Enterprise layer field to store the ASTM barcode Manufacture Diameter 2 value# MANUFACTUREWALLTHICK2-Name of the EnterpriseGDB Enterprise layer field to store the ASTM barcode Manufacture Wall thickness 2 value##############################################################################def AppendSelectedRecords(StagingLayer,EnterpriseLayer,FeatureSet,MANUFACTURER,MFGLOTNO,MANUFACTUREDATE,MANUFACTUREMAT,MANUFACTURECOMP,MANUFACTUREDIAMETER,MANUFACTUREWALLTHICK,MANUFACTUREDIAMETER2,MANUFACTUREWALLTHICK2):
Count = str(arcpy.GetCount_management(StagingLayer)) CountINT = int(Count) if CountINT > 0: # Process: Select Staging Layer By Location arcpy.SelectLayerByLocation_management(StagingLayer, "INTERSECT", FeatureSet, "1 Feet", "NEW_SELECTION", "NOT_INVERT")
# Process: Export Selected Hosted Feature Service Layer features to in-memory layer arcpy.FeatureClassToFeatureClass_conversion(StagingLayer, "in_memory", "INMEMORY_TEMP", "", "", "") INMEMORY_TEMP = "in_memory\\INMEMORY_TEMP" CountSelected = str(arcpy.GetCount_management(INMEMORY_TEMP))
# Check for existance of BARCODE attribute. If does not exist, skip decoding fields = arcpy.ListFields(StagingLayer, "BARCODE")
# Use Update Cursor to decode BARCODE for newly appended records with a not NULL BARCODE attribute for field in fields: cursor = arcpy.UpdateCursor(INMEMORY_TEMP) row = cursor.next() if row == None: arcpy.AddMessage(" No Selected Staging Features") elif row.isNull("BARCODE"): arcpy.AddMessage(" BARCODE value is NULL") else: while row: BARCODE = str(row.getValue("BARCODE")) arcpy.AddMessage(" Processing Barcode = " + BARCODE) MFG = BARCODE[0:2] LOTNO = BARCODE[2:6] MFGDATE = BARCODE[6:9] MFGMATERIAL = BARCODE[9] MFGCOMPONENT = BARCODE[10:12] MFGSIZE = BARCODE[12:15]
#Convert from Base62 and parse Manufacture date MFGDATEBASE10 = baseconvert(MFGDATE,BASE62,BASE10) MFGDATELENGTH = len(MFGDATEBASE10) if MFGDATELENGTH == 3: MFGDATEYEAR = 2000 + int(MFGDATEBASE10[1:]) MFGDATEDAY = int(MFGDATEBASE10[0]) elif MFGDATELENGTH == 4: MFGDATEYEAR = 2000 + int(MFGDATEBASE10[2:]) MFGDATEDAY = int(MFGDATEBASE10[0:2]) else: MFGDATEYEAR = 2000 + int(MFGDATEBASE10[3:]) MFGDATEDAY = int(MFGDATEBASE10[0:3]) MFGDATECONVERTED = datetime.date(MFGDATEYEAR, 1, 1) + datetime.timedelta(MFGDATEDAY - 1)
# Query for Pipes or fittings where C1 = C2 SIZECODE = int(baseconvert(MFGSIZE,BASE62,BASE10)) C1FACTOR = (SIZECODE - 1)/379 if ASTMSIZE.has_key(C1FACTOR): C1VALUESET = ASTMSIZE.get(C1FACTOR) MFGDIAMETER = C1VALUESET[0] MFGWALLTHICKNESS = C1VALUESET[3] else: MFGDIAMETER = 0 MFGWALLTHICKNESS = 0 arcpy.AddMessage("Multiple Diameters") ########################################################################## # Need to add in logic to query for fittings with 2 diameters # NOTES: Valid answer is first combination of C1/C2 values meeting the following criteria # NOTES: C1 and C2 valid values are 1 to 378 # NOTES: C2 much be greater then C1 value # NOTES: Equation to solve: SIZECODE = (C1 * 378)+ C2 + 1 ########################################################################## C1Candidate = 0 for C1Candidate in range(1, 378): C2Start = C1Candidate + 1 for C2Candidate in range(C2Start, 378): SIZECODECandidate = (C1Candidate * 378) + C2Candidate + 1 if SIZECODECandidate == SIZECODE: C1VALUESET = ASTMSIZE.get(C1Candidate) C2VALUESET = ASTMSIZE.get(C2Candidate) break # end if # end for C2Candidate # end for C1Candidate MFGDIAMETER = C1VALUESET[0] MFGWALLTHICKNESS = C1VALUESET[3] MFGDIAMETER2 = C2VALUESET[0] MFGWALLTHICKNESS2 = C2VALUESET[3]
# Update columns with BARCODE decoded values if MANUFACTURER != "": row.setValue(MANUFACTURER, MFG) if MFGLOTNO != "": row.setValue(MFGLOTNO, baseconvert(LOTNO,BASE62,BASE10)) if MANUFACTUREDATE != "": row.setValue(MANUFACTUREDATE, str(MFGDATECONVERTED)) if MANUFACTUREMAT != "": row.setValue(MANUFACTUREMAT, MFGMATERIAL) if MANUFACTURECOMP != "": row.setValue(MANUFACTURECOMP, MFGCOMPONENT) if MANUFACTUREDIAMETER != "": row.setValue(MANUFACTUREDIAMETER, MFGDIAMETER) if MANUFACTUREWALLTHICK != "": row.setValue(MANUFACTUREWALLTHICK, MFGWALLTHICKNESS) if MANUFACTUREDIAMETER2 != "": row.setValue(MANUFACTUREDIAMETER2, MFGDIAMETER2) if MANUFACTUREWALLTHICK2 != "": row.setValue(MANUFACTUREWALLTHICK2, MFGWALLTHICKNESS2) cursor.updateRow(row)
row = cursor.next()
# Process: Append onto RockGas.DBO.Network arcpy.Append_management(INMEMORY_TEMP, EnterpriseLayer, "NO_TEST", "")
arcpy.AddMessage(" Added " + CountSelected + " Selected Staging Features")
else: Count is None CountINT is None arcpy.AddMessage(" No Selected Staging Features")
################################################################################ Create Dictionary for Pipe Sizes [C1 value: Diameter,Pipe Sizing Method,Wallthickness(in)]# CTS = Copper Tubing Size# IPS = Iron Pipe Size# NPS = Nominal Pipe Size###############################################################################ASTMSIZE = {1:(0.25,0,"CTS",0.062),2:(0.375,0,"CTS",0.062),3:(0.50,0,"CTS",0.062),4:(0.50,0,"CTS",0.090),5:(0.50,0,"CTS",0.104), \ 6:(0.75,0,"CTS",0.062),7:(0.75,0,"CTS",0.077),8:(0.75,0,"CTS",0.090),9:(1.0,0,"CTS",0.062),10:(1.0,0,"CTS",0.090), \ 11:(1.0,0,"CTS",0.099),12:(1.0,0,"CTS",1.01),13:(1.0,0,"CTS",0.121),14:(1.25,0,"CTS",0.062),15:(1.25,0,"CTS",0.090), \ 16:(1.25,0,"CTS",0.121),17:(1.75,0,"CTS",0.062),18:(0.50,9.3,"IPS",0.090),19:(0.50,11,"IPS",0.076),20:(0.75,11,"IPS",0.095), \ 21:(0.75,"D","IPS",0.090),22:(1.0,9.33,"IPS",0.140),23:(1.0,9.9,"IPS",0.133),24:(1.0,11,"IPS",0.120),25:(1.0,13.5,"IPS",0.097), \ 26:(1.0,"D","IPS",0.090),27:(1.25,9.33,"IPS",0.178),28:(1.25,10,"IPS",0.166),29:(1.25,11,"IPS",0.151),30:(1.25,13.5,"IPS",0.123), \ 31:(1.25,17,"IPS",0.098),32:(1.25,"D","IPS",0.090),33:(1.50,11,"IPS",0.173),34:(1.50,13.5,"IPS",0.141),35:(1.50,17,"IPS",0.112), \ 36:(1.50,"D","IPS",0.090),37:(2.0,9.33,"IPS",0.255),38:(2.0,11,"IPS",0.216),39:(2.0,13.5,"IPS",0.176),40:(3.0,11,"IPS",0.318), \ 41:(3.0,11.5,"IPS",0.304),42:(3.0,13.5,"IPS",0.259),43:(4.0,9.33,"IPS",0.482),44:(4.0,11,"IPS",0.409),45:(4.0,11.5,"IPS",0.391), \ 46:(4.0,13.5,"IPS",0.333),47:(4.0,15.5,"IPS",0.290),48:(4.0,17,"IPS",0.265),49:(6.0,11,"IPS",0.602),50:(6.0,11.5,"IPS",0.576), \ 51:(6.0,13.5,"IPS",0.491),52:(6.0,17,"IPS",0.390),53:(6.0,21,"IPS",0.315),54:(8.0,11,"IPS",0.784),55:(8.0,11.5,"IPS",0.750), \ 56:(8.0,13.5,"IPS",0.639),57:(8.0,17,"IPS",0.507),58:(8.0,21,"IPS",0.411),59:(10.0,11,"IPS",0.977),60:(10.0,11.5,"IPS",0.935), \ 61:(10.0,13.5,"IPS",0.796),62:(10.0,17,"IPS",0.632),63:(10.0,21,"IPS",0.512),64:(12.0,11,"IPS",1.159),65:(12.0,11.5,"IPS",1.109), \ 66:(12.0,13.5,"IPS",0.944),67:(12.0,17,"IPS",0.750),68:(12.0,21,"IPS",0.607),69:(14.0,11,"IPS",1.273),70:(14.0,13.5,"IPS",1.037), \ 71:(14.0,17,"IPS",0.824),72:(14.0,21,"IPS",0.667),73:(16.0,11,"IPS",1.455),74:(16.0,13.5,"IPS",1.185),75:(16.0,17,"IPS",0.941), \ 76:(16.0,21,"IPS",0.762),77:(18.0,11,"IPS",1.636),78:(18.0,13.5,"IPS",1.333),79:(18.0,17,"IPS",1.059),80:(18.0,21,"IPS",0.857), \ 81:(20.0,11,"IPS",1.818),82:(20.0,13.5,"IPS",1.481),83:(20.0,17,"IPS",1.176),84:(20.0,21,"IPS",0.952),85:(22.0,11,"IPS",2.000), \ 86:(22.0,13.5,"IPS",1.630),87:(22.0,17,"IPS",1.294),88:(22.0,21,"IPS",1.048),89:(24.0,11,"IPS",2.182),90:(24.0,13.5,"IPS",1.778), \ 91:(24.0,17,"IPS",1.412),92:(24.0,21,"IPS",1.143),101:(0.5,-1,"MPT",-1),102:(0.75,-1,"MPT",-1),103:(1.0,-1,"MPT",-1), \ 104:(1.25,-1,"MPT",-1),105:(1.50,-1,"MPT",-1),106:(2.0,-1,"MPT",-1),107:(3.0,-1,"MPT",-1),108:(4.0,-1,"MPT",-1),109:(6.0,-1,"MPT",-1), \ 110:(8.0,-1,"MPT",-1),111:(10.0,-1,"MPT",-1),112:(12.0,-1,"MPT",-1),121:(0.5,-1,"FPT",-1),122:(0.75,-1,"FPT",-1),123:(1.0,-1,"FPT",-1), \ 124:(1.25,-1,"FPT",-1),125:(1.50,-1,"FPT",-1),126:(2.0,-1,"FPT",-1),127:(3.0,-1,"FPT",-1),128:(4.0,-1,"FPT",-1),129:(6.0,-1,"FPT",-1), \ 130:(8.0,-1,"FPT",-1),131:(10.0,-1,"FPT",-1),132:(12.0,-1,"FPT",-1),151:(0.125,-1,"NPS",0.068),152:(0.125,-1,"NPS",0.095), \ 153:(0.25,-1,"NPS",0.088),154:(0.25,-1,"NPS",0.119),155:(0.375,-1,"NPS",0.091),156:(0.375,-1,"NPS",0.126),157:(0.5,-1,"NPS",0.109), \ 158:(0.5,-1,"NPS",0.147),159:(0.75,-1,"NPS",0.113),160:(0.75,-1,"NPS",0.154),161:(1,-1,"NPS",0.133),162:(1,-1,"NPS",0.179), \ 163:(1.25,-1,"NPS",0.14),164:(1.25,-1,"NPS",0.191),165:(1.5,-1,"NPS",0.145),167:(2,-1,"NPS",0.154),168:(2,-1,"NPS",0.218), \ 169:(3,-1,"NPS",0.188),170:(3,-1,"NPS",0.216),171:(4,-1,"NPS",0.156),172:(4,-1,"NPS",0.188),173:(4,-1,"NPS",0.237), \ 175:(6,-1,"NPS",0.188),176:(6,-1,"NPS",0.219),177:(6,-1,"NPS",0.25),178:(6,-1,"NPS",0.28),181:(8,-1,"NPS",0.188), \ 182:(8,-1,"NPS",0.219),183:(8,-1,"NPS",0.25),184:(8,-1,"NPS",0.322),187:(10,-1,"NPS",0.188),188:(10,-1,"NPS",0.203), \ 189:(10,-1,"NPS",0.219),190:(10,-1,"NPS",0.279),191:(10,-1,"NPS",0.365),193:(12,-1,"NPS",0.219),194:(12,-1,"NPS",0.25), \ 195:(12,-1,"NPS",0.312),196:(12,-1,"NPS",0.375),197:(14,-1,"NPS",0.209),198:(14,-1,"NPS",0.25),199:(14,-1,"NPS",0.375), \ 200:(14,-1,"NPS",0.625),201:(14,-1,"NPS",0.687),202:(14,-1,"NPS",0.938),203:(15,-1,"NPS",0.209),204:(15,-1,"NPS",0.25), \ 205:(16,-1,"NPS",0.188),206:(16,-1,"NPS",0.219),207:(16,-1,"NPS",0.225),208:(16,-1,"NPS",0.243),209:(16,-1,"NPS",0.25), \ 210:(16,-1,"NPS",0.26),211:(16,-1,"NPS",0.27),212:(16,-1,"NPS",0.28),213:(16,-1,"NPS",0.312),214:(16,-1,"NPS",0.325), \ 215:(16,-1,"NPS",0.345),216:(16,-1,"NPS",0.357),217:(16,-1,"NPS",0.365),218:(16,-1,"NPS",0.375),219:(16,-1,"NPS",0.406), \ 220:(16,-1,"NPS",0.5),221:(16,-1,"NPS",0.53),222:(16,-1,"NPS",0.55),223:(16,-1,"NPS",0.56),224:(16,-1,"NPS",0.625), \ 225:(16,-1,"NPS",0.656),226:(16,-1,"NPS",0.843),227:(16,-1,"NPS",1.039),228:(16,-1,"NPS",1.125),229:(16,-1,"NPS",1.218), \ 230:(16,-1,"NPS",1.438),231:(16,-1,"NPS",1.594),232:(18,-1,"NPS",0.219),233:(18,-1,"NPS",0.25),234:(18,-1,"NPS",0.312), \ 235:(18,-1,"NPS",0.344),236:(18,-1,"NPS",0.375),237:(18,-1,"NPS",0.406),238:(18,-1,"NPS",0.5),239:(18,-1,"NPS",0.75), \ 240:(18,-1,"NPS",0.938),241:(18,-1,"NPS",1.125),242:(18,-1,"NPS",1.156),243:(18,-1,"NPS",1.375),244:(18,-1,"NPS",2.1), \ 245:(20,-1,"NPS",0.219),246:(20,-1,"NPS",0.234),247:(20,-1,"NPS",0.25),248:(20,-1,"NPS",0.265),249:(20,-1,"NPS",0.281), \ 250:(20,-1,"NPS",0.288),251:(20,-1,"NPS",0.312),252:(20,-1,"NPS",0.328),253:(20,-1,"NPS",0.344),254:(20,-1,"NPS",0.375), \ 255:(20,-1,"NPS",0.406),256:(20,-1,"NPS",0.438),257:(20,-1,"NPS",0.469),258:(20,-1,"NPS",0.5),259:(22,-1,"NPS",0.219), \ 260:(22,-1,"NPS",0.237),261:(22,-1,"NPS",0.25),262:(22,-1,"NPS",0.281),263:(22,-1,"NPS",0.312),264:(22,-1,"NPS",0.344), \ 265:(22,-1,"NPS",0.371),266:(22,-1,"NPS",0.375),267:(22,-1,"NPS",0.432),268:(22,-1,"NPS",0.438),269:(22,-1,"NPS",0.5), \ 270:(22,-1,"NPS",0.562),271:(22,-1,"NPS",0.625),272:(24,-1,"NPS",0.25),273:(24,-1,"NPS",0.265),274:(24,-1,"NPS",0.271), \ 275:(24,-1,"NPS",0.281),276:(24,-1,"NPS",0.289),277:(24,-1,"NPS",0.307),278:(24,-1,"NPS",0.312),279:(24,-1,"NPS",0.32), \ 280:(24,-1,"NPS",0.344),281:(24,-1,"NPS",0.375),282:(24,-1,"NPS",0.382),283:(24,-1,"NPS",0.391),284:(24,-1,"NPS",0.406), \ 285:(24,-1,"NPS",0.5),286:(24,-1,"NPS",0.562),287:(24,-1,"NPS",0.625),288:(24,-1,"NPS",1.531),289:(26,-1,"NPS",0.25), \ 290:(26,-1,"NPS",0.264),291:(26,-1,"NPS",0.278),292:(26,-1,"NPS",0.281),293:(26,-1,"NPS",0.291),294:(26,-1,"NPS",0.312), \ 295:(26,-1,"NPS",0.344),296:(26,-1,"NPS",0.375),297:(26,-1,"NPS",0.438),298:(26,-1,"NPS",0.5),299:(30,-1,"NPS",0.25), \ 300:(30,-1,"NPS",0.281),301:(30,-1,"NPS",0.287),302:(30,-1,"NPS",0.312),303:(30,-1,"NPS",0.328),304:(30,-1,"NPS",0.337), \ 305:(30,-1,"NPS",0.344),306:(30,-1,"NPS",0.35),307:(30,-1,"NPS",0.365),308:(30,-1,"NPS",0.375),309:(30,-1,"NPS",0.391), \ 310:(30,-1,"NPS",0.406),311:(30,-1,"NPS",0.417),312:(30,-1,"NPS",0.421),313:(30,-1,"NPS",0.428),314:(30,-1,"NPS",0.43), \ 315:(30,-1,"NPS",0.437),316:(30,-1,"NPS",0.438),317:(30,-1,"NPS",0.45),318:(30,-1,"NPS",0.469),319:(30,-1,"NPS",0.5), \ 320:(30,-1,"NPS",0.562),321:(30,-1,"NPS",0.563),322:(30,-1,"NPS",0.593),323:(30,-1,"NPS",0.625),324:(30,-1,"NPS",0.75), \ 325:(34,-1,"NPS",0.375),326:(34,-1,"NPS",0.416),327:(34,-1,"NPS",0.438),328:(34,-1,"NPS",0.469),329:(34,-1,"NPS",0.5), \ 330:(34,-1,"NPS",0.524),331:(34,-1,"NPS",0.562),332:(34,-1,"NPS",0.566),333:(34,-1,"NPS",0.6),334:(34,-1,"NPS",0.628), \ 335:(34,-1,"NPS",0.75),336:(34,-1,"NPS",0.754),337:(34,-1,"NPS",0.875),338:(34,-1,"NPS",1.25),339:(36,-1,"NPS",0.312), \ 340:(36,-1,"NPS",0.322),341:(36,-1,"NPS",0.344),342:(36,-1,"NPS",0.375),343:(36,-1,"NPS",0.391),344:(36,-1,"NPS",0.406), \ 345:(36,-1,"NPS",0.422),346:(36,-1,"NPS",0.428),347:(36,-1,"NPS",0.438),348:(36,-1,"NPS",0.453),349:(36,-1,"NPS",0.469), \ 350:(36,-1,"NPS",0.484),351:(36,-1,"NPS",0.5),352:(36,-1,"NPS",0.525),353:(36,-1,"NPS",0.562),354:(36,-1,"NPS",0.594), \ 355:(42,-1,"NPS",0.625),356:(42,-1,"NPS",0.75),357:(42,-1,"NPS",0.375),358:(42,-1,"NPS",0.5),359:(42,-1,"NPS",0.688)}
####################################################################### Mapping of Enterprise GDB Layer attributes for receiving the appending Tracking features#### StagingLayer- Name of TrackingGDB Staging Layer to have its selected features appended## EnterpriseLayer- Name of the EnterpriseGDB Enterprise Layer to receive the selected features of the TrackingGDB Staging Layer## FeatureSet- The User defined polygon which will act as a spatial filter on the TrackingGDB Staging Layer## MANUFACTURER- Name of the EnterpriseGDB Enterprise layer field to store the ASTM barcode Manufacturer name## MANUFACTURELOTNO- Name of the EnterpriseGDB Enterprise layer field to store the ASTM barcode Manufacturer Lot number value## MANUFACTUREDATE- Name of the EnterpriseGDB Enterprise layer field to store the ASTM barcode Manufacturer Date## MATERIAL- Name of the EnterpriseGDB Enterprise layer field to store the ASTM barcode Manufacturer Material value## MANUFACTUREMODEL- Name of the EnterpriseGDB Enterprise layer field to store the ASTM barcode Manufacturer Model value## DIAMETER- Name of the EnterpriseGDB Enterprise layer field to store the ASTM barcode Manufacture Diameter value## WALLTHICKNESS- Name of the EnterpriseGDB Enterprise layer field to store the ASTM barcode Manufacture Wall thickness value## DIAMETER2- Name of the EnterpriseGDB Enterprise layer field to store the ASTM barcode Manufacture Diameter 2 value## WALLTHICKNESS2- Name of the EnterpriseGDB Enterprise layer field to store the ASTM barcode Manufacture Wall thichness 2 value###################################################################
# ############################ Gas Service Point# ###########################arcpy.AddMessage("Appending GasServicePoint")AppendSelectedRecords(Staking_GasServicePoint, Enterprise_GasServicePoint, Feature_Set, "", "", "", "","", "","","","")arcpy.AddMessage(" Completed Appending GasServicePoint")arcpy.AddMessage(" ")
# ############################# # Gas Main Pipe# ############################arcpy.AddMessage("Appending GasMainPipe")AppendSelectedRecords(Staking_GasMainPipe, Enterprise_GasMainPipe, Feature_Set, "MANUFACTURER", "MANUFACTURELOTNO", "MANUFACTUREDATE", "PIPEGRADE", "PIPESPECIFICATION", "NOMINALDIAMETER","WALLTHICKNESS","","")arcpy.AddMessage(" Completed Appending GasMainPipe")arcpy.AddMessage(" ")
# ############################# # Gas Dimension# ############################arcpy.AddMessage("Appending Gas Dimension")AppendSelectedRecords(Staking_GasDimension, Enterprise_GasDimension, Feature_Set, "", "", "", "","","","","","")arcpy.AddMessage(" Completed Appending Gas Dimension")arcpy.AddMessage(" ")
# ############################# # Gas Anode# ############################arcpy.AddMessage("Appending Gas Anode")AppendSelectedRecords(Staking_GasAnode, Enterprise_GasAnode, Feature_Set,"","","","","","","","","")arcpy.AddMessage(" Completed Gas Anode")arcpy.AddMessage(" ")
# ############################# # Gas Valve# ############################arcpy.AddMessage("Appending Gas Valve")AppendSelectedRecords(Staking_GasValve, Enterprise_GasValve, Feature_Set, "MANUFACTURER", "MANUFACTURELOTNO", "MANUFACTUREDATE", "MATERIAL", "MANUFACTUREMODEL","DIAMETER","","","")arcpy.AddMessage(" Completed Appending Gas Valve")arcpy.AddMessage(" ")
# ############################# # Gas CP Test Point# ############################arcpy.AddMessage("Appending CP Test Point")AppendSelectedRecords(Staking_GasCPTestPoint, Enterprise_CPTestPoint, Feature_Set,"MANUFACTURER","","","","MANUFACTUREMODEL","","","","")arcpy.AddMessage(" Completed Appending CP Test Point")arcpy.AddMessage(" ")
# ############################# # Gas Flow Control Device# ############################arcpy.AddMessage("Appending Gas Flow Control Device")AppendSelectedRecords(Staking_GasFlowControlDevice, Enterprise_GasFlowControlDevice, Feature_Set, "MANUFACTURER", "MANUFACTURELOTNO", "MANUFACTUREDATE", "", "MANUFACTUREMODEL","DIAMETER","","","")arcpy.AddMessage(" Completed Appending Gas Flow Control Device")arcpy.AddMessage(" ")
# ############################# # Gas Fitting# ############################arcpy.AddMessage("Appending Gas Fitting")AppendSelectedRecords(Staking_GasFitting, Enterprise_GasFitting, Feature_Set, "MANUFACTURER", "MANUFACTURERLOTNO", "MANUFACTUREDATE", "", "MANUFACTUREMODEL","DIAMETER","","","")arcpy.AddMessage(" Completed Appending Gas Fitting")arcpy.AddMessage(" ")
# ############################# # Gas Service Valve# ############################arcpy.AddMessage("Appending Gas Service Valve")AppendSelectedRecords(Staking_GasServiceValve, Enterprise_GasServiceValve, Feature_Set, "MANUFACTURER", "MANUFACTURERLOTNO", "MANUFACTUREDATE", "", "MANUFACTUREMODEL","DIAMETER","","","")arcpy.AddMessage(" Completed Appending Gas Service Valve")arcpy.AddMessage(" ")
# ############################# # Gas Locating Point# ############################arcpy.AddMessage("Appending Gas Locating Point")AppendSelectedRecords(Staking_GasLocatingPoint, Enterprise_GasLocatingPoint, Feature_Set, "MANUFACTURER", "MANUFACTURERLOTNO", "MANUFACTUREDATE", "", "MANUFACTUREMODEL","DIAMETER","","","")arcpy.AddMessage(" Completed Appending Gas Locating Point")arcpy.AddMessage(" ")
# ############################# # Gas Main Connector# ############################arcpy.AddMessage("Appending Gas Main Connector")AppendSelectedRecords(Staking_GasMainConnector, Enterprise_GasMainConnector, Feature_Set, "MANUFACTURER","MANUFACTURELOTNO","","","","","","","")arcpy.AddMessage(" Completed Appending Gas Main Connector")arcpy.AddMessage(" ")
# ############################# # Gas Service Pipe# ############################arcpy.AddMessage("Appending Gas Service Pipe")AppendSelectedRecords(Staking_GasServicePipe, Enterprise_GasServicePipe, Feature_Set,"MANUFACTURER", "MANUFACTURELOTNO", "MANUFACTUREDATE", "PIPEGRADE", "PIPESPECIFICATION", "NOMINALDIAMETER","WALLTHICKNESS","","")arcpy.AddMessage(" Completed Gas Service Pipe")arcpy.AddMessage(" ")
# ############################# # Test Point# ############################# arcpy.AddMessage("Appending Test Point")# AppendSelectedRecords(StagingTestPoint, Enterprise_TestPoint, Feature_Set,"","","","","","","","","")# arcpy.AddMessage(" Completed Appending Test Point")# arcpy.AddMessage(" ")
# ############################# # Anode# ############################# arcpy.AddMessage("Appending Anode")# AppendSelectedRecords(StagingAnode, Enterprise_Anode, Feature_Set,"MANUFACTURER","MANUFACTURELOTNO","MANUFACTUREDATE","MATERIAL","MANUFACTUREMODEL","","","","")# arcpy.AddMessage(" Completed Appending Anode")# arcpy.AddMessage(" ")
# ############################# # Rectifier# ############################# arcpy.AddMessage("Appending Rectifier")# AppendSelectedRecords(StagingRectifier, Enterprise_Rectifier, Feature_Set,"MANUFACTURER","","","","MANUFACTUREMODEL","","","","")# arcpy.AddMessage(" Completed Appending Rectifier")# arcpy.AddMessage(" ")
# ############################# # Project Location# ############################# arcpy.AddMessage("Appending Project Location")# AppendSelectedRecords(StagingProjectLocation, Enterprise_ProjectLocation, Feature_Set,"","","","","","","","","")# arcpy.AddMessage(" Completed Appending Project Location")# arcpy.AddMessage(" ")
サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
