View In:   ArcGIS Online Map Viewer

Parent Layer: Sewer Pressure Mains

Name: TOC Pressure Mains and Operation Status

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This dataset contains a collection of features that represent the separated and combined sewer features in a community.

Service Item Id: e632556336ef499a84fd8a97908d040d

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 150000.0

Max Scale: 0.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: 2002083.6750542969
YMin: 650377.8690559715
XMax: 2080543.7999578863
YMax: 780131.1528559774
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: ACTIVEFLAG
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Currently Active
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 4
• Value: 0
  Label: Currently Not Active
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 4
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [DIAMETER] CONCAT """ " CONCAT [MATERIAL]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 5000.0
Max. Scale: 0.0

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: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: ACTIVEFLAG

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MATERIAL , Coded Values: [ABS: ABS Plastic / Acrylonitrile Butadiene Styrene] , [CAS: Cast Iron] , [CT: Clay Tile] , ...12 more... )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [0: Unknown] , [0.75: 3/4"] , [1: 1"] , ...27 more... )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ROOTCNTLDATE , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: CASETYPE , Coded Values: [4: Aqua] , [7: Apex] , [13: Chatham County] , ...5 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [7: Apex] , [4: Aqua] , [1: Cary] , ...5 more... )
• NUM ( type: esriFieldTypeInteger, alias: NUM, editable: true, nullable: true, defaultValue: null, modelName: NUM )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ROOTCNTL )
• FROMMH ( type: esriFieldTypeString, alias: FROMMH, editable: true, nullable: true, length: 11, defaultValue: null, modelName: FROMMH )
• TOMH ( type: esriFieldTypeString, alias: TOMH, editable: true, nullable: true, length: 11, defaultValue: null, modelName: TOMH )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GROUTED , Coded Values: [Existing: Existing] , [Proposed: Proposed] )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength(), required: true )
• CREATED_USER ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 75, defaultValue: null, modelName: CREATED_USER, required: true )
• CREATED_DATE ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE, required: true )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 75, defaultValue: null, modelName: LAST_EDITED_USER, required: true )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE, required: true )
• ESTINSTALLYEAR ( type: esriFieldTypeSmallInteger, alias: Estimated Install Year, editable: true, nullable: true, defaultValue: null, modelName: ESTINSTALLYEAR )
• PIPECLASS ( type: esriFieldTypeString, alias: Pipe Class, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PIPECLASS , Coded Values: [CL250: Ductile Iron Class CL250] , [CL300: Ductile Iron Class CL300] , [CL350: Ductile Iron Class CL350] , ...3 more... )
• PIPEINTCOATING ( type: esriFieldTypeString, alias: Pipe Interior Coating, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PIPEINTCOATING , Coded Values: [CM: Cement Mortar] , [EP: Epoxy] , [NONE: None] , ...1 more... )
• PIPEEXTCOATING ( type: esriFieldTypeString, alias: Pipe Exterior Coating, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PIPEEXTCOATING , Coded Values: [PE: Polyethylene Encasement] , [ZN: Zinc] , [ZNPE: Zinc w/ Polyethylene Encasement] )
• MATFLDSOURCE ( type: esriFieldTypeString, alias: Material Field Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MATFLDSOURCE , Coded Values: [CCTV: CCTV Inspection] , [CONSULTANT: Consultant Resources] , [TOWN: Town Resources] )
• DIAMFLDSOURCE ( type: esriFieldTypeString, alias: Diameter Field Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DIAMFLDSOURCE , Coded Values: [CCTV: CCTV Inspection] , [CONSULTANT: Consultant Resources] , [TOWN: Town Resources] )
• FLDVRFDDATE ( type: esriFieldTypeDate, alias: Field Verified Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FLDVRFDDATE )
• UTILEXTPERMNUM ( type: esriFieldTypeString, alias: Utility Extension Permit Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: UTILEXTPERMNUM )
• RECORDNAME ( type: esriFieldTypeString, alias: Record Name, editable: true, nullable: true, length: 150, defaultValue: null, modelName: RECORDNAME )
• RECORDNUM ( type: esriFieldTypeString, alias: Record Number, editable: true, nullable: true, length: 100, defaultValue: null, modelName: RECORDNUM )
• RECORDSOURCE ( type: esriFieldTypeString, alias: Record Source, editable: true, nullable: true, length: 25, defaultValue: null, modelName: RECORDSOURCE , Coded Values: [Auto: Auto Generated] , [Construction: Construction] , [Construction (Permitted): Construction (Permitted)] , ...6 more... )
• RECORDNOTES ( type: esriFieldTypeString, alias: Record Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RECORDNOTES )
• ESMNTCLEARTYPE ( type: esriFieldTypeString, alias: Easement Clearing Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ESMNTCLEARTYPE , Coded Values: [TOWN: Town Maintained] , [CITIZEN: Citizen Maintained] )
• DEEDREF ( type: esriFieldTypeString, alias: Deed Reference, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DEEDREF )
• MARKERTAPE ( type: esriFieldTypeSmallInteger, alias: Marker Tape, editable: true, nullable: true, defaultValue: null, modelName: MARKERTAPE , Coded Values: [0: False] , [1: True] )
• CATHPROT ( type: esriFieldTypeSmallInteger, alias: Cathodic Protection, editable: true, nullable: true, defaultValue: null, modelName: CATHPROT , Coded Values: [0: False] , [1: True] )
• REHABBED ( type: esriFieldTypeSmallInteger, alias: Rehabbed, editable: true, nullable: true, defaultValue: 0, modelName: REHABBED , Coded Values: [0: False] , [1: True] )
• REHABTYPE ( type: esriFieldTypeString, alias: Rehab Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: REHABTYPE , Coded Values: [CIP: Cured in Place] , [SC: Continuous Slip Liner] , [SE: Sectional Slip Liner] , ...3 more... )
• REHABDATE ( type: esriFieldTypeDate, alias: Rehab Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REHABDATE )
• REHABPROJNUM ( type: esriFieldTypeString, alias: Rehab Project Number, editable: true, nullable: true, length: 100, defaultValue: null, modelName: REHABPROJNUM )
• REHABPROJNAME ( type: esriFieldTypeString, alias: Rehab Project Name, editable: true, nullable: true, length: 150, defaultValue: null, modelName: REHABPROJNAME )
• REHABCONTRACTOR ( type: esriFieldTypeString, alias: Rehab Contractor, editable: true, nullable: true, length: 75, defaultValue: null, modelName: REHABCONTRACTOR )
• MAINTTYPE ( type: esriFieldTypeString, alias: Maintenance Type, editable: true, nullable: true, length: 12, defaultValue: null, modelName: MAINTTYPE , Coded Values: [RES: Residential] , [COM: Commercial] )
• HIGHPRIORITY ( type: esriFieldTypeString, alias: High Priority, editable: true, nullable: true, length: 8, defaultValue: null, modelName: HIGHPRIORITY , Coded Values: [AER: Aerial] , [WATER: Water Crossing] , [SIP: Siphon] , ...1 more... )
• RECORDLENG ( type: esriFieldTypeDouble, alias: Record Length, editable: true, nullable: true, defaultValue: null, modelName: RECORDLENG )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• FLOWDIRECTION ( type: esriFieldTypeSmallInteger, alias: Flow direction, editable: true, nullable: true, defaultValue: 1, modelName: FLOWDIRECTION, required: true , Coded Values: [1: With digitized] , [2: Against digitized] , [3: Indeterminate] )

Types:

ID: 1
Name: Currently Active
Domains:
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• STATUS:
  Inherited
• PIPECLASS:
  Inherited
• PIPEINTCOATING:
  Inherited
• PIPEEXTCOATING:
  Inherited
• MATFLDSOURCE:
  Inherited
• DIAMFLDSOURCE:
  Inherited
• RECORDSOURCE:
  Inherited
• ESMNTCLEARTYPE:
  Inherited
• MARKERTAPE:
  Inherited
• CATHPROT:
  Inherited
• REHABBED:
  Inherited
• REHABTYPE:
  Inherited
• MAINTTYPE:
  Inherited
• HIGHPRIORITY:
  Inherited
• FLOWDIRECTION:
  Inherited
Templates:
• Name: 1
  Description:
  Prototype:
  FLOWDIRECTION: 1
  RECORDLENG: null
  FACILITYID: null
  INSTALLDATE: null
  MATERIAL: null
  DIAMETER: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  NUM: null
  NOTES: null
  FROMMH: null
  TOMH: null
  STATUS: null
  HIGHPRIORITY: null
  MAINTTYPE: null
  REHABCONTRACTOR: null
  REHABPROJNAME: null
  REHABPROJNUM: null
  ESTINSTALLYEAR: null
  PIPECLASS: null
  PIPEINTCOATING: null
  PIPEEXTCOATING: null
  MATFLDSOURCE: null
  DIAMFLDSOURCE: null
  FLDVRFDDATE: null
  UTILEXTPERMNUM: null
  RECORDNAME: null
  RECORDNUM: null
  RECORDSOURCE: null
  RECORDNOTES: null
  ESMNTCLEARTYPE: null
  DEEDREF: null
  MARKERTAPE: null
  CATHPROT: null
  REHABBED: 0
  REHABTYPE: null
  REHABDATE: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 0
Name: Currently Not Active
Domains:
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• STATUS:
  Inherited
• PIPECLASS:
  Inherited
• PIPEINTCOATING:
  Inherited
• PIPEEXTCOATING:
  Inherited
• MATFLDSOURCE:
  Inherited
• DIAMFLDSOURCE:
  Inherited
• RECORDSOURCE:
  Inherited
• ESMNTCLEARTYPE:
  Inherited
• MARKERTAPE:
  Inherited
• CATHPROT:
  Inherited
• REHABBED:
  Inherited
• REHABTYPE:
  Inherited
• MAINTTYPE:
  Inherited
• HIGHPRIORITY:
  Inherited
• FLOWDIRECTION:
  Inherited
Templates:
• Name: 0
  Description:
  Prototype:
  FLOWDIRECTION: 1
  RECORDLENG: null
  FACILITYID: null
  INSTALLDATE: null
  MATERIAL: null
  DIAMETER: null
  ENABLED: 1
  ACTIVEFLAG: 0
  OWNEDBY: 1
  MAINTBY: 1
  NUM: null
  NOTES: null
  FROMMH: null
  TOMH: null
  STATUS: null
  HIGHPRIORITY: null
  MAINTTYPE: null
  REHABCONTRACTOR: null
  REHABPROJNAME: null
  REHABPROJNUM: null
  ESTINSTALLYEAR: null
  PIPECLASS: null
  PIPEINTCOATING: null
  PIPEEXTCOATING: null
  MATFLDSOURCE: null
  DIAMFLDSOURCE: null
  FLDVRFDDATE: null
  UTILEXTPERMNUM: null
  RECORDNAME: null
  RECORDNUM: null
  RECORDSOURCE: null
  RECORDNOTES: null
  ESMNTCLEARTYPE: null
  DEEDREF: null
  MARKERTAPE: null
  CATHPROT: null
  REHABBED: 0
  REHABTYPE: null
  REHABDATE: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports OidReservation: true

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: true

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata