View In:   ArcGIS Online Map Viewer

Parent Layer: Gas

Name: PipelineDevice

Display Field: devicename

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 5e2b184155e24a7ca47191e0d1d59431

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -1.2464386332600001E7
YMin: 3931891.3593999967
XMax: -1.24617232906E7
YMax: 3933966.5068999976
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: Object ID )
• assetgroup ( modelName: assetgroup, nullable: false, editable: true, defaultValue: 0, alias: Asset group, type: esriFieldTypeInteger )
• assettype ( modelName: assettype, nullable: true, editable: true, defaultValue: 0, alias: Asset type, type: esriFieldTypeSmallInteger )
• adddetails ( modelName: adddetails, nullable: true, editable: true, defaultValue: null, alias: adddetails: Additional Details, Clockwise to Close, type: esriFieldTypeSmallInteger )
• devicestatus ( modelName: devicestatus, nullable: true, editable: true, defaultValue: null, alias: Device Status, type: esriFieldTypeSmallInteger )
• regulatorytype ( modelName: regulatorytype, nullable: true, editable: true, defaultValue: 0, alias: Regulatory Type, type: esriFieldTypeSmallInteger )
• designtype ( modelName: designtype, nullable: true, editable: true, defaultValue: null, alias: Type, type: esriFieldTypeSmallInteger )
• piggable ( modelName: piggable, nullable: true, editable: true, defaultValue: null, alias: Piggable, type: esriFieldTypeSmallInteger )
• operable ( modelName: operable, nullable: true, editable: true, defaultValue: null, alias: Operable, type: esriFieldTypeSmallInteger )
• accessible ( modelName: accessible, nullable: true, editable: true, defaultValue: 1, alias: Accessible, type: esriFieldTypeSmallInteger )
• yesno ( modelName: yesno, nullable: true, editable: true, defaultValue: null, alias: yesno: Drain Valve Indicator, Internal Meter, SCADA Indicator, type: esriFieldTypeSmallInteger )
• turnstoclose ( modelName: turnstoclose, nullable: true, editable: true, defaultValue: null, alias: Turns to Close, type: esriFieldTypeDouble )
• normalposition ( modelName: normalposition, nullable: true, editable: true, defaultValue: null, alias: Normal Position, type: esriFieldTypeSmallInteger )
• installdate ( modelName: installdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Install Date, type: esriFieldTypeDate )
• inservicedate ( modelName: inservicedate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: In-Service Date, type: esriFieldTypeDate )
• assetid ( modelName: assetid, nullable: true, editable: true, defaultValue: null, length: 64, alias: Asset ID, type: esriFieldTypeString )
• serialnumber ( modelName: serialnumber, nullable: true, editable: true, defaultValue: null, length: 20, alias: Serial Number, type: esriFieldTypeString )
• ownedby ( modelName: ownedby, nullable: true, editable: true, defaultValue: 1, alias: Owned By, type: esriFieldTypeSmallInteger )
• maintby ( modelName: maintby, nullable: true, editable: true, defaultValue: 1, alias: Maintained By, type: esriFieldTypeSmallInteger )
• lifecyclestatus ( modelName: lifecyclestatus, nullable: false, editable: true, defaultValue: 8, alias: Lifecycle Status, type: esriFieldTypeSmallInteger )
• maopdesign ( modelName: maopdesign, nullable: false, editable: true, defaultValue: 0, alias: MAOP Design, type: esriFieldTypeDouble )
• maoptest ( modelName: maoptest, nullable: true, editable: true, defaultValue: 0, alias: MAOP Test, type: esriFieldTypeDouble )
• maoprecord ( modelName: maoprecord, nullable: false, editable: true, defaultValue: 0, alias: MAOP Record, type: esriFieldTypeDouble )
• depth ( modelName: depth, nullable: true, editable: true, defaultValue: null, alias: Depth, type: esriFieldTypeDouble )
• depthtonut ( modelName: depthtonut, nullable: true, editable: true, defaultValue: null, alias: Depth to Nut, type: esriFieldTypeDouble )
• measuredlength ( modelName: measuredlength, nullable: true, editable: true, defaultValue: null, alias: Length, type: esriFieldTypeDouble )
• diameter ( modelName: diameter, nullable: true, editable: true, defaultValue: null, alias: Diameter, type: esriFieldTypeDouble )
• maxinletpressure ( modelName: maxinletpressure, nullable: true, editable: true, defaultValue: null, alias: Max Inlet Pressure, type: esriFieldTypeDouble )
• maxoutletpressure ( modelName: maxoutletpressure, nullable: true, editable: true, defaultValue: null, alias: Max Outlet Pressure, type: esriFieldTypeDouble )
• setpressureentered ( modelName: setpressureentered, nullable: true, editable: true, defaultValue: null, alias: Set Pressure Entered, type: esriFieldTypeDouble )
• setpressurestandard ( modelName: setpressurestandard, nullable: true, editable: true, defaultValue: null, alias: Set Pressure Standard, type: esriFieldTypeDouble )
• symbolrotation ( modelName: symbolrotation, nullable: true, editable: true, defaultValue: null, alias: Symbol Rotation, type: esriFieldTypeSmallInteger )
• barcode ( modelName: barcode, nullable: true, editable: true, defaultValue: null, length: 16, alias: Barcode, type: esriFieldTypeString )
• manufacturer ( modelName: manufacturer, nullable: true, editable: true, defaultValue: null, length: 2, alias: Manufacturer, type: esriFieldTypeString )
• manufacturerlotno ( modelName: manufacturerlotno, nullable: true, editable: true, defaultValue: null, alias: Manufacturer Lot #, type: esriFieldTypeInteger )
• manufacturedate ( modelName: manufacturedate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Manufacture Date, type: esriFieldTypeDate )
• manufacturecomponent ( modelName: manufacturecomponent, nullable: true, editable: true, defaultValue: null, length: 2, alias: Manufacture Component, type: esriFieldTypeString )
• material ( modelName: material, nullable: true, editable: true, defaultValue: null, length: 2, alias: Material, type: esriFieldTypeString )
• casingmaterial ( modelName: casingmaterial, nullable: true, editable: true, defaultValue: null, length: 20, alias: Casing Material, type: esriFieldTypeString )
• devicename ( modelName: devicename, nullable: true, editable: true, defaultValue: null, length: 20, alias: Name, type: esriFieldTypeString )
• quantity ( modelName: quantity, nullable: true, editable: true, defaultValue: null, alias: Quantity, type: esriFieldTypeDouble )
• weight ( modelName: weight, nullable: true, editable: true, defaultValue: null, alias: Weight, type: esriFieldTypeDouble )
• amperage ( modelName: amperage, nullable: true, editable: true, defaultValue: null, alias: Amperage, type: esriFieldTypeDouble )
• usage ( modelName: usage, nullable: true, editable: true, defaultValue: null, alias: Usage, type: esriFieldTypeDouble )
• duration ( modelName: duration, nullable: true, editable: true, defaultValue: null, alias: Duration, type: esriFieldTypeInteger )
• height ( modelName: height, nullable: true, editable: true, defaultValue: null, alias: Height, type: esriFieldTypeDouble )
• notes ( modelName: notes, nullable: true, editable: true, defaultValue: null, length: 2000, alias: Notes, type: esriFieldTypeString )
• iscritical ( modelName: iscritical, nullable: true, editable: true, defaultValue: null, alias: Critical Valve, type: esriFieldTypeSmallInteger )
• flowcapacity ( modelName: flowcapacity, nullable: true, editable: true, defaultValue: null, alias: Flow Capacity, type: esriFieldTypeDouble )
• permanentindicator ( modelName: permanentindicator, nullable: true, editable: true, defaultValue: null, alias: Permanent Indicator, type: esriFieldTypeSmallInteger )
• spatialaccuracy ( modelName: spatialaccuracy, nullable: true, editable: true, defaultValue: null, alias: Spatial Accuracy, type: esriFieldTypeSmallInteger )
• depthunits ( modelName: depthunits, nullable: true, editable: true, defaultValue: null, alias: Depth Units, type: esriFieldTypeSmallInteger )
• diameterunits ( modelName: diameterunits, nullable: true, editable: true, defaultValue: null, alias: Diameter Units, type: esriFieldTypeSmallInteger )
• flowcapacityunits ( modelName: flowcapacityunits, nullable: true, editable: true, defaultValue: null, alias: Flow Capacity Units, type: esriFieldTypeSmallInteger )
• heightunits ( modelName: heightunits, nullable: true, editable: true, defaultValue: null, alias: Height Units, type: esriFieldTypeSmallInteger )
• lengthunits ( modelName: lengthunits, nullable: true, editable: true, defaultValue: null, alias: Length Units, type: esriFieldTypeSmallInteger )
• pressureunits ( modelName: pressureunits, nullable: true, editable: true, defaultValue: null, alias: Set Pressure Units, type: esriFieldTypeSmallInteger )
• maopunits ( modelName: maopunits, nullable: true, editable: true, defaultValue: null, alias: MAOP Unit of Measure, type: esriFieldTypeSmallInteger )
• usageunits ( modelName: usageunits, nullable: true, editable: true, defaultValue: null, alias: Usage Units, type: esriFieldTypeSmallInteger )
• usagerateunits ( modelName: usagerateunits, nullable: true, editable: true, defaultValue: null, alias: Usage Rate Units, type: esriFieldTypeSmallInteger )
• recordingmethod ( modelName: recordingmethod, nullable: true, editable: true, defaultValue: null, length: 25, alias: Recording Method, type: esriFieldTypeString )
• regulatorbodytype ( modelName: regulatorbodytype, nullable: true, editable: true, defaultValue: null, length: 20, alias: Regulator Body Type, type: esriFieldTypeString )
• outletdiameter ( modelName: outletdiameter, nullable: true, editable: true, defaultValue: null, alias: Outlet Diameter, type: esriFieldTypeDouble )
• diaphragmdiameter ( modelName: diaphragmdiameter, nullable: true, editable: true, defaultValue: null, alias: Diaphragm Diameter, type: esriFieldTypeDouble )
• premise ( modelName: premise, nullable: true, editable: true, defaultValue: null, length: 10, alias: Premise, type: esriFieldTypeString )
• indoormeter ( modelName: indoormeter, nullable: true, editable: true, defaultValue: null, alias: Indoor Meter, type: esriFieldTypeSmallInteger )
• operatingclassification ( modelName: operatingclassification, nullable: true, editable: true, defaultValue: null, length: 40, alias: Operating Classification, type: esriFieldTypeString )
• maxdifferentialpressure ( modelName: maxdifferentialpressure, nullable: true, editable: true, defaultValue: null, alias: Max Differential Pressure, type: esriFieldTypeDouble )
• companypaidtelephone ( modelName: companypaidtelephone, nullable: true, editable: true, defaultValue: null, alias: Company Paid Telephone, type: esriFieldTypeSmallInteger )
• telephonenumber ( modelName: telephonenumber, nullable: true, editable: true, defaultValue: null, length: 15, alias: Telephone Number, type: esriFieldTypeString )
• usagerate ( modelName: usagerate, nullable: true, editable: true, defaultValue: null, alias: Usage Rate, type: esriFieldTypeDouble )
• gpsx ( modelName: gpsx, nullable: true, editable: true, defaultValue: null, alias: GPS X, type: esriFieldTypeDouble )
• gpsy ( modelName: gpsy, nullable: true, editable: true, defaultValue: null, alias: GPS Y, type: esriFieldTypeDouble )
• gpsz ( modelName: gpsz, nullable: true, editable: true, defaultValue: null, alias: GPS Z, type: esriFieldTypeDouble )
• legacyid ( modelName: legacyid, nullable: true, editable: true, defaultValue: null, length: 38, alias: Legacy ID, type: esriFieldTypeString )
• workorderid ( modelName: workorderid, nullable: true, editable: true, defaultValue: null, length: 38, alias: Work Order ID, type: esriFieldTypeString )
• projectnumber ( modelName: projectnumber, nullable: true, editable: true, defaultValue: null, length: 38, alias: Project Number, type: esriFieldTypeString )
• assetunitcode ( modelName: assetunitcode, nullable: true, editable: true, defaultValue: null, length: 38, alias: Asset Unit Code, type: esriFieldTypeString )
• eventid ( modelName: eventid, nullable: true, editable: true, defaultValue: null, length: 38, alias: Event ID, type: esriFieldTypeString )
• fromdate ( modelName: fromdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: From Date, type: esriFieldTypeDate )
• todate ( modelName: todate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: To Date, type: esriFieldTypeDate )
• locationerror ( modelName: locationerror, nullable: true, editable: true, defaultValue: null, length: 100, alias: Location Error, type: esriFieldTypeString )
• engrouteid ( modelName: engrouteid, nullable: true, editable: true, defaultValue: null, length: 38, alias: Engineering Route ID, type: esriFieldTypeString )
• engroutename ( modelName: engroutename, nullable: true, editable: true, defaultValue: null, length: 255, alias: Engineering Route Name, type: esriFieldTypeString )
• engm ( modelName: engm, nullable: true, editable: true, defaultValue: null, alias: Engineering Measure, type: esriFieldTypeDouble )
• continrouteid ( modelName: continrouteid, nullable: true, editable: true, defaultValue: null, length: 38, alias: Continuous Route ID, type: esriFieldTypeString )
• continroutename ( modelName: continroutename, nullable: true, editable: true, defaultValue: null, length: 255, alias: Continuous Route Name, type: esriFieldTypeString )
• continm ( modelName: continm, nullable: true, editable: true, defaultValue: null, alias: Continuous Measure, type: esriFieldTypeDouble )
• refmethod ( modelName: refmethod, nullable: true, editable: true, defaultValue: null, alias: Reference Method, type: esriFieldTypeSmallInteger )
• reflocation ( modelName: reflocation, nullable: true, editable: true, defaultValue: null, length: 50, alias: Reference Location, type: esriFieldTypeString )
• refoffset ( modelName: refoffset, nullable: true, editable: true, defaultValue: null, length: 50, alias: Reference Offset, type: esriFieldTypeString )
• bondedinsulated ( modelName: bondedinsulated, nullable: true, editable: true, defaultValue: null, alias: Bonded/Insulated, type: esriFieldTypeSmallInteger )
• locationdescription ( modelName: locationdescription, nullable: true, editable: true, defaultValue: null, length: 255, alias: Location Description, type: esriFieldTypeString )
• wallthickness ( modelName: wallthickness, nullable: true, editable: true, defaultValue: null, alias: Wall Thickness, type: esriFieldTypeDouble )
• wallthickness2 ( modelName: wallthickness2, nullable: true, editable: true, defaultValue: null, alias: Wall Thickness 2, type: esriFieldTypeDouble )
• diameter2 ( modelName: diameter2, nullable: true, editable: true, defaultValue: null, alias: Diameter 2, type: esriFieldTypeDouble )
• temprating ( modelName: temprating, nullable: true, editable: true, defaultValue: null, length: 20, alias: Temp Rating, type: esriFieldTypeString )
• coolingmethod ( modelName: coolingmethod, nullable: true, editable: true, defaultValue: null, length: 20, alias: Cooling Method, type: esriFieldTypeString )
• rating ( modelName: rating, nullable: true, editable: true, defaultValue: null, alias: Rating, type: esriFieldTypeDouble )
• specification ( modelName: specification, nullable: true, editable: true, defaultValue: null, length: 30, alias: Specification, type: esriFieldTypeString )
• remoteoperation ( modelName: remoteoperation, nullable: true, editable: true, defaultValue: null, alias: Remote Operation, type: esriFieldTypeSmallInteger )
• valvekeysize ( modelName: valvekeysize, nullable: true, editable: true, defaultValue: null, alias: Valve Key Size, type: esriFieldTypeSmallInteger )
• modelnumber ( modelName: modelnumber, nullable: true, editable: true, defaultValue: null, length: 20, alias: Model Number, type: esriFieldTypeString )
• deviceactuatortype ( modelName: deviceactuatortype, nullable: true, editable: true, defaultValue: null, alias: Device Actuator Type, type: esriFieldTypeSmallInteger )
• operatortype ( modelName: operatortype, nullable: true, editable: true, defaultValue: null, alias: Operator Type, type: esriFieldTypeSmallInteger )
• remotedevicefailtype ( modelName: remotedevicefailtype, nullable: true, editable: true, defaultValue: null, alias: Remote Device Fail Type, type: esriFieldTypeSmallInteger )
• created_user ( modelName: created_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )

Templates:

• Name: PipelineDevice
  Description:
  Prototype:
  diameterunits: null
  installdate: null
  heightunits: null
  usage: null
  flowcapacity: null
  manufacturedate: null
  valvekeysize: null
  coolingmethod: null
  flowcapacityunits: null
  premise: null
  maopunits: null
  engrouteid: null
  remotedevicefailtype: null
  symbolrotation: null
  height: null
  gpsz: null
  measuredlength: null
  manufacturerlotno: null
  reflocation: null
  depthunits: null
  usageunits: null
  yesno: null
  usagerate: null
  regulatorbodytype: null
  gpsx: null
  gpsy: null
  accessible: 1
  maxdifferentialpressure: null
  wallthickness: null
  locationerror: null
  manufacturer: null
  companypaidtelephone: null
  setpressureentered: null
  setpressurestandard: null
  indoormeter: null
  remoteoperation: null
  last_edited_date: null
  diameter2: null
  assettype: 0
  maoptest: 0
  engm: null
  projectnumber: null
  continroutename: null
  regulatorytype: 0
  last_edited_user: null
  depth: null
  workorderid: null
  diaphragmdiameter: null
  devicename: null
  operable: null
  notes: null
  telephonenumber: null
  deviceactuatortype: null
  outletdiameter: null
  temprating: null
  rating: null
  devicestatus: null
  maopdesign: 0
  fromdate: null
  diameter: null
  todate: null
  pressureunits: null
  maxinletpressure: null
  ownedby: 1
  barcode: null
  assetunitcode: null
  serialnumber: null
  created_user: null
  refoffset: null
  weight: null
  usagerateunits: null
  turnstoclose: null
  lengthunits: null
  designtype: null
  inservicedate: null
  recordingmethod: null
  legacyid: null
  eventid: null
  continm: null
  continrouteid: null
  engroutename: null
  normalposition: null
  operatortype: null
  lifecyclestatus: 8
  maoprecord: 0
  duration: null
  amperage: null
  spatialaccuracy: null
  maxoutletpressure: null
  depthtonut: null
  adddetails: null
  permanentindicator: null
  manufacturecomponent: null
  quantity: null
  operatingclassification: null
  refmethod: null
  specification: null
  assetgroup: 0
  wallthickness2: null
  iscritical: null
  locationdescription: null
  material: null
  assetid: null
  modelnumber: null
  maintby: 1
  casingmaterial: null
  created_date: null
  piggable: null
  bondedinsulated: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata