Name: Gravity_Main_To_Be_Lined_

Display Field: ENABLED

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 1992400.91518834
YMin: 770476.768986061
XMax: 2066301.6800065
YMax: 868291.960589066
Spatial Reference: 102719 (2264)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"RehabStatus","defaultSymbol":null,"uniqueValueInfos":[{"value":"Pending CCTV","symbol":{"color":[76,230,0,255],"width":1.5,"type":"esriSLS","style":"esriSLSSolid"},"label":"Pending CCTV"},{"value":"CCTV’d","symbol":{"color":[0,197,255,255],"width":1.5,"type":"esriSLS","style":"esriSLSSolid"},"label":"CCTV’d"},{"value":"Lined Pending Approval","symbol":{"color":[255,127,127,255],"width":1.5,"type":"esriSLS","style":"esriSLSSolid"},"label":"Lined Pending Approval"},{"value":"Lining Accepted","symbol":{"color":[223,115,255,255],"width":1.5,"type":"esriSLS","style":"esriSLSSolid"},"label":"Lining Accepted"},{"value":"Other","symbol":{"color":[173,173,173,255],"width":1.5,"type":"esriSLS","style":"esriSLSSolid"},"label":"Other (Not in Project Area)"}]},"transparency":0}

HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field: RehabStatus

Fields:

• ENABLED (type: esriFieldTypeSmallInteger, alias: ENABLED, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• SUBTYPE (type: esriFieldTypeInteger, alias: SUBTYPE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Collector], [6: Outfall], [8: Tunnel], ... 1 more ...)
• ADMINISTRATIVEAREA (type: esriFieldTypeString, alias: ADMINISTRATIVE AREA, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [Cary: Town of Cary], [CNTY: County of Durham], [DNC: City of Durham], ... 2 more ...)
• FACILITYID (type: esriFieldTypeString, alias: FACILITY ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• INSTALLDATE (type: esriFieldTypeDate, alias: INSTALL DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OPERATIONALAREA (type: esriFieldTypeString, alias: OPERATIONALAREA, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [Eno: Eno River Pump Station], [Lick: Lick Creek Pump Station], [North: North Durham Waste Water Reclaimation Facility], ... 4 more ...)
• LIFECYCLESTATUS (type: esriFieldTypeString, alias: LIFECYCLE STATUS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Abandoned: Abandoned], [Active: Active], [Construction: Under Construction], ... 5 more ...)
• LININGTYPE (type: esriFieldTypeString, alias: LINING TYPE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Assumed: Assumed], [Standard: Standard])
• UPSTREAMINVERT (type: esriFieldTypeDouble, alias: Upstream Invert, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DOWNSTREAMINVERT (type: esriFieldTypeDouble, alias: Downstream Invert, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SLOPE (type: esriFieldTypeDouble, alias: Slope(%), SQL Type: sqlTypeOther, nullable: true, editable: true)
• DIAMETER (type: esriFieldTypeDouble, alias: DIAMETER, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1"], [2: 2"], [3: 3"], ... 16 more ...)
• OWNER (type: esriFieldTypeString, alias: OWNER, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [BUT: Town of Butner], [CARY: Town of Cary], [CHAT: Chatham County], ... 8 more ...)
• RECORDEDLENGTH (type: esriFieldTypeDouble, alias: RECORDED LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LEGACYID (type: esriFieldTypeString, alias: LEGACYID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ITEMDESCRIPTION (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• FROMMH (type: esriFieldTypeString, alias: FROM MH, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• TOMH (type: esriFieldTypeString, alias: TO MH, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• EASEMENTNUMBER (type: esriFieldTypeString, alias: EASEMENT #, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• CREATEDATE (type: esriFieldTypeDate, alias: CREATE DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MODIFYDATE (type: esriFieldTypeDate, alias: EDIT DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EDITEDBY (type: esriFieldTypeString, alias: EDITED BY, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• HPL (type: esriFieldTypeString, alias: High Priority Line, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [?: Needs investigation], [A: Aerial], [P: Parallel], ... 1 more ...)
• RELINEDATE (type: esriFieldTypeDate, alias: RELINE DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ASBUILTID (type: esriFieldTypeString, alias: ASBUILT ID, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
• ACCEPTDATE (type: esriFieldTypeDate, alias: ACCEPT DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• REPLACEDATE (type: esriFieldTypeDate, alias: REPLACE DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• REPLACETYPE (type: esriFieldTypeString, alias: REPLACE TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PROJECTID (type: esriFieldTypeString, alias: PROJECTID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• CREATEDBY (type: esriFieldTypeString, alias: CREATED BY, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• SRC (type: esriFieldTypeString, alias: Source, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [CAD (AS-BUILT DRAWING): CAD (AS-BUILT DRAWING)], [CAD (PERMIT DRAWING): CAD (PERMIT DRAWING)], [CCTV: CCTV], ... 28 more ...)
• TYPE (type: esriFieldTypeString, alias: TYPE, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [Collector: Collector], [Interceptor: Interceptor], [Outfall: Outfall], ... 1 more ...)
• MONITORBASIN (type: esriFieldTypeString, alias: MONITOR BASIN, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [AAO: Alston Avenue Outfall], [BLP: Brightleaf Pump Station], [BMP: Broadmoor Pump Station], ... 40 more ...)
• WATERTYPE (type: esriFieldTypeString, alias: WATERTYPE, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [Chemical: Chemical], [Combined: Combined Waste Water], [Effluent: Waste Water Effluent], ... 7 more ...)
• DROPINVERT (type: esriFieldTypeDouble, alias: DROPINVERT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MATERIAL (type: esriFieldTypeString, alias: MATERIAL, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [ACP: Asbestos Concrete], [CIP: Cast Iron], [DIP: Ductile Iron], ... 7 more ...)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Mon_Basin (type: esriFieldTypeString, alias: Mon Basin, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Priority (type: esriFieldTypeString, alias: Priority, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Basin (type: esriFieldTypeString, alias: Basin, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Temp_Basin (type: esriFieldTypeString, alias: Temp Basin, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Location (type: esriFieldTypeString, alias: Location (Approx.), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• RehabStatus (type: esriFieldTypeString, alias: Rehab Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CCTV’d: CCTV’d], [Lining Accepted: Lining Accepted], [Lined Pending Approval: Lined Pending Approval], ... 2 more ...)
• CCTV (type: esriFieldTypeString, alias: CCTV (Yes/No), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: NA])
• CCTV_Date (type: esriFieldTypeDate, alias: CCTV Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LINED_LENGTH (type: esriFieldTypeDouble, alias: LINED_LENGTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LINED (type: esriFieldTypeString, alias: LINED, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: NA])
• LINED_DATE (type: esriFieldTypeDate, alias: LINED DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• BasinGroup (type: esriFieldTypeString, alias: Basin Group, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• MainsToBeLined (type: esriFieldTypeString, alias: Mains To Lined, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: NA])
• GRID (type: esriFieldTypeString, alias: GRID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SubBasin (type: esriFieldTypeString, alias: SubBasin, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• CalculatedLength (type: esriFieldTypeDouble, alias: CalculatedLength, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeOther, nullable: true, editable: false)
• Facilty_ID (type: esriFieldTypeString, alias: Facilty_ID, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• USMH (type: esriFieldTypeString, alias: USMH, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• DSMH (type: esriFieldTypeString, alias: DSMH, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• GIS_Diameter (type: esriFieldTypeInteger, alias: GIS_Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GIS_Pipe_Material (type: esriFieldTypeString, alias: GIS_Pipe_Material, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Pipe_Inspection_Status (type: esriFieldTypeString, alias: Pipe_Inspection_Status, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• CCTV_Diameter (type: esriFieldTypeInteger, alias: CCTV_Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CCTV_Pipe_Material (type: esriFieldTypeString, alias: CCTV_Pipe_Material, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• CIPP_Installed_Date (type: esriFieldTypeString, alias: CIPP_Installed_Date, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• Contract (type: esriFieldTypeString, alias: Contract, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• GISLength (type: esriFieldTypeSingle, alias: GISLength, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PreliminaryCCTVLength (type: esriFieldTypeSingle, alias: PreliminaryCCTVLength, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InstallationLength (type: esriFieldTypeSingle, alias: InstallationLength, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID_1545427352291 (type: esriFieldTypeGUID, alias: GlobalID_1545427352291, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Types:

ID: Pending CCTV
Name: Pending CCTV
Domains:

• Field Name: ENABLED
  Inherited
  
• Field Name: SUBTYPE
  Inherited
  
• Field Name: ADMINISTRATIVEAREA
  Inherited
  
• Field Name: OPERATIONALAREA
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: LININGTYPE
  Inherited
  
• Field Name: DIAMETER
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: HPL
  Inherited
  
• Field Name: SRC
  Inherited
  
• Field Name: TYPE
  Inherited
  
• Field Name: MONITORBASIN
  Inherited
  
• Field Name: WATERTYPE
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: RehabStatus
  Inherited
  
• Field Name: CCTV
  Inherited
  
• Field Name: LINED
  Inherited
  
• Field Name: MainsToBeLined
  Inherited
  
Templates:

Name: Pending CCTV
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• RehabStatus: Pending CCTV
• ENABLED: 0
• WATERTYPE: Sewage
• CCTV: NA
• LINED: NA
• MainsToBeLined: NA

---

ID: CCTV’d
Name: CCTV’d
Domains:

• Field Name: ENABLED
  Inherited
  
• Field Name: SUBTYPE
  Inherited
  
• Field Name: ADMINISTRATIVEAREA
  Inherited
  
• Field Name: OPERATIONALAREA
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: LININGTYPE
  Inherited
  
• Field Name: DIAMETER
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: HPL
  Inherited
  
• Field Name: SRC
  Inherited
  
• Field Name: TYPE
  Inherited
  
• Field Name: MONITORBASIN
  Inherited
  
• Field Name: WATERTYPE
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: RehabStatus
  Inherited
  
• Field Name: CCTV
  Inherited
  
• Field Name: LINED
  Inherited
  
• Field Name: MainsToBeLined
  Inherited
  
Templates:

Name: CCTV’d
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• RehabStatus: CCTV’d
• ENABLED: 0
• WATERTYPE: Sewage
• CCTV: NA
• LINED: NA
• MainsToBeLined: NA

---

ID: Lined Pending Approval
Name: Lined Pending Approval
Domains:

• Field Name: ENABLED
  Inherited
  
• Field Name: SUBTYPE
  Inherited
  
• Field Name: ADMINISTRATIVEAREA
  Inherited
  
• Field Name: OPERATIONALAREA
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: LININGTYPE
  Inherited
  
• Field Name: DIAMETER
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: HPL
  Inherited
  
• Field Name: SRC
  Inherited
  
• Field Name: TYPE
  Inherited
  
• Field Name: MONITORBASIN
  Inherited
  
• Field Name: WATERTYPE
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: RehabStatus
  Inherited
  
• Field Name: CCTV
  Inherited
  
• Field Name: LINED
  Inherited
  
• Field Name: MainsToBeLined
  Inherited
  
Templates:

Name: Lined Pending Approval
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• RehabStatus: Lined Pending Approval
• ENABLED: 0
• WATERTYPE: Sewage
• CCTV: NA
• LINED: NA
• MainsToBeLined: NA

---

ID: Lining Accepted
Name: Lining Accepted
Domains:

• Field Name: ENABLED
  Inherited
  
• Field Name: SUBTYPE
  Inherited
  
• Field Name: ADMINISTRATIVEAREA
  Inherited
  
• Field Name: OPERATIONALAREA
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: LININGTYPE
  Inherited
  
• Field Name: DIAMETER
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: HPL
  Inherited
  
• Field Name: SRC
  Inherited
  
• Field Name: TYPE
  Inherited
  
• Field Name: MONITORBASIN
  Inherited
  
• Field Name: WATERTYPE
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: RehabStatus
  Inherited
  
• Field Name: CCTV
  Inherited
  
• Field Name: LINED
  Inherited
  
• Field Name: MainsToBeLined
  Inherited
  
Templates:

Name: Lining Accepted
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• RehabStatus: Lining Accepted
• ENABLED: 0
• WATERTYPE: Sewage
• CCTV: NA
• LINED: NA
• MainsToBeLined: NA

---

ID: Other
Name: Other
Domains:

• Field Name: ENABLED
  Inherited
  
• Field Name: SUBTYPE
  Inherited
  
• Field Name: ADMINISTRATIVEAREA
  Inherited
  
• Field Name: OPERATIONALAREA
  Inherited
  
• Field Name: LIFECYCLESTATUS
  Inherited
  
• Field Name: LININGTYPE
  Inherited
  
• Field Name: DIAMETER
  Inherited
  
• Field Name: OWNER
  Inherited
  
• Field Name: HPL
  Inherited
  
• Field Name: SRC
  Inherited
  
• Field Name: TYPE
  Inherited
  
• Field Name: MONITORBASIN
  Inherited
  
• Field Name: WATERTYPE
  Inherited
  
• Field Name: MATERIAL
  Inherited
  
• Field Name: RehabStatus
  Inherited
  
• Field Name: CCTV
  Inherited
  
• Field Name: LINED
  Inherited
  
• Field Name: MainsToBeLined
  Inherited
  
Templates:

Name: Other (Not in Project Area)
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• RehabStatus: Other
• ENABLED: 0
• WATERTYPE: Sewage
• CCTV: NA
• LINED: NA
• MainsToBeLined: NA

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/12/2022 8:12:15 AM

Schema Last Edit Date: 5/12/2022 8:12:15 AM

Data Last Edit Date: 5/12/2022 8:12:15 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat