View In:   ArcGIS Online Map Viewer

Name: Service

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: 1784129.914754734
YMin: 572210.5233495773
XMax: 1838651.1599701254
YMax: 620038.3782689209
Spatial Reference: 103152  (6576)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSDash
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... )
• PINCHABLE ( type: esriFieldTypeString, alias: Pinchable, editable: true, nullable: true, length: 5, defaultValue: Y, modelName: PINCHABLE , Coded Values: [N: No] , [Y: Yes] )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: 0.75, modelName: DIAMETER , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...6 more... )
• 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 , Range: [1, 1000000000] )
• 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] )
• COVERTYPE ( type: esriFieldTypeString, alias: CoverType, editable: true, nullable: true, length: 15, defaultValue: Grass, modelName: COVERTYPE , Coded Values: [Asphalt: Asphalt] , [Concrete: Concrete] , [Grass: Grass] , ...4 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: null, modelName: OWNER )
• INSERVICEDATE ( type: esriFieldTypeDate, alias: In Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSERVICEDATE )
• DATE_RETIRED ( type: esriFieldTypeDate, alias: Electric Survey Indicator, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_RETIRED )
• INSTALLATIONMETHOD ( type: esriFieldTypeString, alias: Installation Method, editable: true, nullable: true, length: 20, defaultValue: null, 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: Y, 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: 15 MIN, modelName: PIPETESTDURATION )
• PIPETESTPRESSURE ( type: esriFieldTypeString, alias: Pipe Test Pressure, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PIPETESTPRESSURE )
• PIPETESTTYPE ( type: esriFieldTypeString, alias: Pipe Test Type, editable: true, nullable: true, length: 10, defaultValue: Air, modelName: PIPETESTTYPE , Coded Values: [Air: Air] , [Gas: Gas] , [Water: Water] )
• 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 )
• Material ( type: esriFieldTypeInteger, alias: Material, editable: true, nullable: true, defaultValue: 8, modelName: Material )
• STUBBED ( type: esriFieldTypeString, alias: Stubbed, editable: true, nullable: true, length: 2, defaultValue: N, modelName: STUBBED , 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: [Charter: Charter] , [Drisco: Drisco] )
• 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 )
• MANUFACTUREMODEL ( type: esriFieldTypeString, alias: Manufacturer Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MANUFACTUREMODEL )
• SYSTEMTYPE ( type: esriFieldTypeString, alias: System Type, editable: true, nullable: true, length: 20, defaultValue: Distribution, modelName: SYSTEMTYPE , Coded Values: [Distribution: Distribution] , [Transmission: Transmission] , [Gathering: Gathering] , ...2 more... )
• 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: GPS, 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: Service
  Description:
  Prototype:
  CrewMember: null
  HorizontalAccuracy: null
  HowCollected: GPS
  AssetLocation: null
  PipeInfo: null
  Enabled: 1
  CREATIONUSER: null
  DATECREATED: null
  DATEMODIFIED: null
  LASTUSER: null
  LEGACYID: null
  INSTALLATIONDATE: null
  STATUS: Active
  PINCHABLE: Y
  DIAMETER: 0.75
  DIAMETERUNITS: inch
  OPERATINGPRESSURE: null
  COATINGTYPE: null
  MEASUREDLENGTH: null
  LENGTHSOURCE: Field Measurement
  COVERTYPE: Grass
  ASSETUNITCODE: null
  OWNER: null
  INSERVICEDATE: null
  DATE_RETIRED: null
  INSTALLATIONMETHOD: null
  WARNINGTAPE: null
  TRACERWIRE: Y
  WORKORDERID: null
  PROJECTNUMBER: null
  PIPETESTDATE: null
  PIPETESTDURATION: 15 MIN
  PIPETESTPRESSURE: null
  PIPETESTTYPE: Air
  DESIGNPRESSUREENTERED: null
  DESIGNPRESSURESTANDARD: null
  DESIGNPRESSUREUNITOFMEASURE: null
  Material: 8
  STUBBED: N
  BARCODE: null
  MANUFACTURER: null
  MANUFACTURELOTNO: null
  MANUFACTUREDATE: null
  MANUFACTUREMODEL: null
  SYSTEMTYPE: Distribution
  
  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

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

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