View In:   ArcGIS Online Map Viewer

Name: Pipes

Display Field: Enabled

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 446eed2244384d878aba8823e548f49f

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

Supports Datum Transformation: true

Extent:

XMin: 1784254.1817285556
YMin: 572077.1840372361
XMax: 1848478.683239827
YMax: 625108.246129865
Spatial Reference: 103152  (6576)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [230, 230, 0, 255]
Width: 2
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: true
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: false
Supports Query With LOD Spatial Reference: false
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:

• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• CREATIONUSER ( type: esriFieldTypeString, alias: Creation User, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CREATIONUSER )
• DATECREATED ( type: esriFieldTypeDate, alias: Date Created, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATECREATED )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: Date Modified, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEMODIFIED )
• LASTUSER ( type: esriFieldTypeString, alias: Last User, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTUSER )
• LEGACYID ( type: esriFieldTypeString, alias: Legacy ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: LEGACYID )
• INSTALLATIONDATE ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLATIONDATE )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 20, defaultValue: Active, modelName: STATUS , Coded Values: [Proposed: Proposed] , [Proposed Retired: Proposed Retired] , [Active: Active] , ...3 more... )
• NOMINALDIAMETER ( type: esriFieldTypeDouble, alias: Nominal Diameter, editable: true, nullable: true, defaultValue: null, modelName: NOMINALDIAMETER , Coded Values: [0.25: 1/4"] , [0.38: 3/8"] , [0.5: 1/2"] , ...25 more... )
• OUTSIDEDIAMETER ( type: esriFieldTypeDouble, alias: Outside Diameter, editable: true, nullable: true, defaultValue: null, modelName: OUTSIDEDIAMETER )
• DIAMETERUNITS ( type: esriFieldTypeString, alias: Nominal Diameter Units, editable: true, nullable: true, length: 20, defaultValue: inch, modelName: DIAMETERUNITS , Coded Values: [inch: inch] , [mm: millimeter] )
• OPERATINGPRESSURE ( type: esriFieldTypeDouble, alias: Operating Pressure, editable: true, nullable: true, defaultValue: null, modelName: OPERATINGPRESSURE )
• COATINGTYPE ( type: esriFieldTypeString, alias: Coating Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: COATINGTYPE , Coded Values: [3M Tape: 3M Tape] , [Bare: Bare] , [Blue Guard: Blue Guard] , ...33 more... )
• MEASUREDLENGTH ( type: esriFieldTypeDouble, alias: Measured Length, editable: true, nullable: true, defaultValue: null, modelName: MEASUREDLENGTH )
• LENGTHSOURCE ( type: esriFieldTypeString, alias: Length Source, editable: true, nullable: true, length: 25, defaultValue: Field Measurement, modelName: LENGTHSOURCE , Coded Values: [Field Measurement: Field Measurement] , [Mapping System: Mapping System] , [User-Derived: User-Derived] )
• ACTUALINTERNALDIAMETER ( type: esriFieldTypeDouble, alias: Actual Internal Diameter, editable: true, nullable: true, defaultValue: null, modelName: ACTUALINTERNALDIAMETER )
• WALLTHICKNESS ( type: esriFieldTypeDouble, alias: Wall Thickness, editable: true, nullable: true, defaultValue: null, modelName: WALLTHICKNESS , Coded Values: [0: 0] , [0.125: 0.125] , [0.2: 0.2] , ...12 more... )
• ASSETUNITCODE ( type: esriFieldTypeString, alias: Asset Unit Code, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ASSETUNITCODE )
• OWNER ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 20, defaultValue: Smyrna, modelName: OWNER , Coded Values: [Smyrna: Smyrna] , [LaVergne: LaVergne] , [Nolensville: Nolensville] )
• INSERVICEDATE ( type: esriFieldTypeDate, alias: In Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSERVICEDATE )
• DATE_RETIRED ( type: esriFieldTypeDate, alias: Date Retired, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_RETIRED )
• INSTALLATIONMETHOD ( type: esriFieldTypeString, alias: Installation Method, editable: true, nullable: true, length: 20, defaultValue: Direct Bore, modelName: INSTALLATIONMETHOD , Coded Values: [Trench: Trench] , [Joint Trench: Joint Trench] , [Insertion: Insertion] , ...2 more... )
• WARNINGTAPE ( type: esriFieldTypeString, alias: Warning Tape, editable: true, nullable: true, length: 5, defaultValue: null, modelName: WARNINGTAPE , Coded Values: [N: No] , [Y: Yes] )
• TRACERWIRE ( type: esriFieldTypeString, alias: Tracer Wire, editable: true, nullable: true, length: 5, defaultValue: null, modelName: TRACERWIRE , Coded Values: [N: No] , [Y: Yes] )
• WORKORDERID ( type: esriFieldTypeString, alias: Work Order ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WORKORDERID )
• PROJECTNUMBER ( type: esriFieldTypeString, alias: Project Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJECTNUMBER )
• PIPETESTDATE ( type: esriFieldTypeDate, alias: Pipe Test Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PIPETESTDATE )
• PIPETESTDURATION ( type: esriFieldTypeString, alias: Pipe Test Duration, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PIPETESTDURATION )
• PIPETESTPRESSURE ( type: esriFieldTypeDouble, alias: Pipe Test Pressure, editable: true, nullable: true, defaultValue: null, modelName: PIPETESTPRESSURE )
• PIPETESTTYPE ( type: esriFieldTypeString, alias: Pipe Test Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PIPETESTTYPE , Coded Values: [Air: Air] , [Gas: Gas] , [Water: Water] )
• ELECTRICSURVEYINDICATOR ( type: esriFieldTypeString, alias: Electric Survey Indicator, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ELECTRICSURVEYINDICATOR , Coded Values: [N: No] , [Y: Yes] )
• DESIGNPRESSUREENTERED ( type: esriFieldTypeDouble, alias: Design Pressure - Entered, editable: true, nullable: true, defaultValue: null, modelName: DESIGNPRESSUREENTERED )
• DESIGNPRESSURESTANDARD ( type: esriFieldTypeDouble, alias: Design Pressure - Standard, editable: true, nullable: true, defaultValue: null, modelName: DESIGNPRESSURESTANDARD )
• DESIGNPRESSUREUNITOFMEASURE ( type: esriFieldTypeString, alias: Design Pressure - Unit of Measure, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DESIGNPRESSUREUNITOFMEASURE )
• DESIGNCLASS ( type: esriFieldTypeInteger, alias: Design Class, editable: true, nullable: true, defaultValue: null, modelName: DESIGNCLASS , Coded Values: [1: Class 1] , [2: Class 2] , [3: Class 3] , ...1 more... )
• DESIGNFACTOR ( type: esriFieldTypeDouble, alias: Design Factor, editable: true, nullable: true, defaultValue: null, modelName: DESIGNFACTOR )
• Material ( type: esriFieldTypeInteger, alias: Material, editable: true, nullable: true, defaultValue: 3, modelName: Material )
• SYSTEMTYPE ( type: esriFieldTypeString, alias: Pipe System Type, editable: true, nullable: true, length: 20, defaultValue: Distribution, modelName: SYSTEMTYPE , Coded Values: [Distribution: Distribution] , [Transmission: Transmission] , [Gathering: Gathering] , ...2 more... )
• CRITICALINDICATOR ( type: esriFieldTypeString, alias: Critical Indicator, editable: true, nullable: true, length: 5, defaultValue: null, modelName: CRITICALINDICATOR , Coded Values: [N: No] , [Y: Yes] )
• PIGGABLE ( type: esriFieldTypeString, alias: Piggable, editable: true, nullable: true, length: 2, defaultValue: N, modelName: PIGGABLE , Coded Values: [N: No] , [Y: Yes] )
• BARCODE ( type: esriFieldTypeString, alias: Barcode, editable: true, nullable: true, length: 16, defaultValue: null, modelName: BARCODE )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MANUFACTURER , Coded Values: [Thrall Distribution: Thrall Distribution] , [UPONOR: UPONOR] , [Other: Other] , ...1 more... )
• MANUFACTURELOTNO ( type: esriFieldTypeString, alias: Manufacture Lot No, editable: true, nullable: true, length: 5, defaultValue: null, modelName: MANUFACTURELOTNO )
• MANUFACTUREDATE ( type: esriFieldTypeDate, alias: Manufacture Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MANUFACTUREDATE )
• PIPESPECIFICATION ( type: esriFieldTypeString, alias: Pipe Specification, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PIPESPECIFICATION )
• CPSYSTEM_GlobalID ( type: esriFieldTypeGUID, alias: CPSystem_GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: CPSYSTEM_GlobalID )
• MAOPDESIGN ( type: esriFieldTypeDouble, alias: MAOP Design, editable: true, nullable: true, defaultValue: null, modelName: MAOPDESIGN )
• MAOPTEST ( type: esriFieldTypeDouble, alias: MAOP Test, editable: true, nullable: true, defaultValue: null, modelName: MAOPTEST )
• MAOPRECORD ( type: esriFieldTypeDouble, alias: MAOP Record, editable: true, nullable: true, defaultValue: null, modelName: MAOPRECORD )
• MAOPUNITOFMEASURE ( type: esriFieldTypeString, alias: MAOP Unit of Measure, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MAOPUNITOFMEASURE )
• PRESSURESYSTEM_GlobalID ( type: esriFieldTypeGUID, alias: PressureSystem_GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PRESSURESYSTEM_GlobalID )
• EMERISOSYS_GlobalID ( type: esriFieldTypeGUID, alias: EmerIsoSys_GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: EMERISOSYS_GlobalID )
• PINCHABLE ( type: esriFieldTypeString, alias: PINCHABLE, editable: true, nullable: true, length: 2, defaultValue: N, modelName: PINCHABLE , Coded Values: [N: No] , [Y: Yes] )
• PIPEGRADE ( type: esriFieldTypeString, alias: PIPEGRADE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PIPEGRADE )
• GIRTHWELDTYPE ( type: esriFieldTypeString, alias: Girth Weld Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GIRTHWELDTYPE )
• LONGITUDINALSEAMORIENTATION ( type: esriFieldTypeString, alias: Longitudinal Seam Orientation, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LONGITUDINALSEAMORIENTATION )
• GASTRACEWEIGHT ( type: esriFieldTypeInteger, alias: GASTRACEWEIGHT, editable: true, nullable: true, defaultValue: null, modelName: GASTRACEWEIGHT )
• SMYS ( type: esriFieldTypeDouble, alias: SMYS, editable: true, nullable: true, defaultValue: null, modelName: SMYS )
• PERCENTSMYS ( type: esriFieldTypeDouble, alias: Percent SMYS, editable: true, nullable: true, defaultValue: null, modelName: PERCENTSMYS )
• PipeInfo ( type: esriFieldTypeString, alias: PipeInfo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PipeInfo )
• AssetLocation ( type: esriFieldTypeString, alias: AssetLocation, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AssetLocation , Coded Values: [Smyrna: Smyrna] , [LaVergne: LaVergne] , [Nolensville: Nolensville] )
• HowCollected ( type: esriFieldTypeString, alias: HowCollected, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HowCollected , Coded Values: [Geocoded: Geocoded] , [GPS: GPS] , [Site Visit: Site Visit] , ...3 more... )
• HorizontalAccuracy ( type: esriFieldTypeDouble, alias: HorizontalAccuracy, editable: true, nullable: true, defaultValue: null, modelName: HorizontalAccuracy )
• CrewMember ( type: esriFieldTypeString, alias: CrewMember, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CrewMember , Coded Values: [Chas Keel: Chas Keel] , [Derek Francis: Derek Francis] , [DJ Carter: DJ Carter] , ...6 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength(), required: true )

Templates:

• Name: Pipes
  Description:
  Prototype:
  DESIGNFACTOR: null
  CrewMember: null
  HorizontalAccuracy: null
  HowCollected: null
  AssetLocation: null
  PipeInfo: null
  Enabled: 1
  CREATIONUSER: null
  DATECREATED: null
  DATEMODIFIED: null
  LASTUSER: null
  LEGACYID: null
  INSTALLATIONDATE: null
  STATUS: Active
  NOMINALDIAMETER: 4
  OUTSIDEDIAMETER: null
  DIAMETERUNITS: inch
  OPERATINGPRESSURE: null
  COATINGTYPE: null
  MEASUREDLENGTH: null
  LENGTHSOURCE: Field Measurement
  ACTUALINTERNALDIAMETER: null
  WALLTHICKNESS: null
  ASSETUNITCODE: null
  OWNER: Smyrna
  INSERVICEDATE: null
  DATE_RETIRED: null
  INSTALLATIONMETHOD: Trench
  WARNINGTAPE: null
  TRACERWIRE: null
  WORKORDERID: null
  PROJECTNUMBER: null
  PIPETESTDATE: null
  PIPETESTDURATION: null
  PIPETESTPRESSURE: null
  PIPETESTTYPE: null
  ELECTRICSURVEYINDICATOR: null
  DESIGNPRESSUREENTERED: null
  DESIGNPRESSURESTANDARD: null
  DESIGNPRESSUREUNITOFMEASURE: null
  DESIGNCLASS: null
  Material: 3
  SYSTEMTYPE: Distribution
  CRITICALINDICATOR: null
  PIGGABLE: N
  BARCODE: null
  MANUFACTURER: null
  MANUFACTURELOTNO: null
  MANUFACTUREDATE: null
  PIPESPECIFICATION: null
  CPSYSTEM_GlobalID: null
  MAOPDESIGN: null
  MAOPTEST: null
  MAOPRECORD: null
  MAOPUNITOFMEASURE: null
  PRESSURESYSTEM_GlobalID: null
  EMERISOSYS_GlobalID: null
  PINCHABLE: N
  PIPEGRADE: null
  GIRTHWELDTYPE: null
  LONGITUDINALSEAMORIENTATION: null
  GASTRACEWEIGHT: null
  SMYS: null
  PERCENTSMYS: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata