Name: Sanitary Mains
Display Field: FACILITYID
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Description:
Definition Expression: N/A
Copyright Text:
Default Visibility: true
MaxRecordCount: 1000
Supported Query Formats: JSON, AMF, geoJSON
Min Scale: 25000
Max Scale: 0
Supports Advanced Queries: true
Supports Statistics: true
Has Labels: true
Can Modify Layer: true
Can Scale Symbols: false
Use Standardized Queries: true
Supports Datum Transformation: true
Extent:
XMin: 1.3272968729658797E7
YMin: 367694.1240157485
XMax: 1.3285447467847764E7
YMax: 382732.32185038924
Spatial Reference: 2253
(2253)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [85, 255, 0, 255]
Width: 1
Label:
Description:
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementCenterAlong
Label Expression: [FACILITYID] CONCAT " - " CONCAT [Diameter_S] CONCAT "''" CONCAT NEWLINE CONCAT [Material_S]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: baseline
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none
Min. Scale: 1000.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: false
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID
, alias: OBJECTID
)
-
FACILITYID
(
type: esriFieldTypeString
, alias: Facility Identifier
, length: 20
)
-
Material_S
(
type: esriFieldTypeSmallInteger
, alias: Material
, Coded Values:
[1: Concrete]
, [2: Liner Material]
, [3: Plastic]
, ...15 more...
)
-
Diameter_S
(
type: esriFieldTypeSmallInteger
, alias: Diameter
)
-
PDrop_S
(
type: esriFieldTypeSmallInteger
, alias: PDrop
, Coded Values:
[2: No]
, [1: Unknown]
, [3: Yes]
)
-
LineType_S
(
type: esriFieldTypeSmallInteger
, alias: Line Type
, Coded Values:
[1: Gravity]
, [2: Force Main]
, [3: Unknown]
)
-
INSTALLDATE
(
type: esriFieldTypeDate
, alias: Install Date
, length: 8
)
-
MAINSHAPE
(
type: esriFieldTypeString
, alias: Main Shape
, length: 50
, Coded Values:
[Circular: Circular]
, [Oblong: Oblong]
, [Other: Other]
, ...10 more...
)
-
LINEDYEAR
(
type: esriFieldTypeString
, alias: Year Lined
, length: 4
)
-
LINERTYPE
(
type: esriFieldTypeString
, alias: Liner Type
, length: 20
, Coded Values:
[NONE: None]
, [OTH: Other]
, [SW: Spiral Wound]
, ...4 more...
)
-
FROMMH
(
type: esriFieldTypeString
, alias: From Manhole
, length: 11
)
-
TOMH
(
type: esriFieldTypeString
, alias: To Manhole
, length: 11
)
-
WATERTYPE
(
type: esriFieldTypeString
, alias: Water Type
, length: 30
, Coded Values:
[Combined: Combined Waste Water]
, [Effluent: Waste Water Effluent]
, [0: N/A]
, ...7 more...
)
-
ENABLED
(
type: esriFieldTypeSmallInteger
, alias: Enabled
, Coded Values:
[0: False]
, [1: True]
)
-
ACTIVEFLAG
(
type: esriFieldTypeSmallInteger
, alias: Active Flag
, Coded Values:
[0: False]
, [1: True]
)
-
OWNEDBY
(
type: esriFieldTypeSmallInteger
, alias: Owned By
, Coded Values:
[-2: Other]
, [-1: Private]
, [1: City of Brighton]
, ...1 more...
)
-
MAINTBY
(
type: esriFieldTypeSmallInteger
, alias: Managed By
, Coded Values:
[-1: Private]
, [-2: Other]
, [1: City of Brighton]
)
-
SUMFLOW
(
type: esriFieldTypeDouble
, alias: Flow Summary
)
-
LASTUPDATE
(
type: esriFieldTypeDate
, alias: Last Update Date
, length: 8
)
-
LASTEDITOR
(
type: esriFieldTypeString
, alias: Last Editor
, length: 50
)
-
DOWNELEV
(
type: esriFieldTypeDouble
, alias: Downstream Elevation
)
-
UPELEV
(
type: esriFieldTypeDouble
, alias: Upstream Elevation
)
-
SLOPE
(
type: esriFieldTypeDouble
, alias: Slope
)
-
Legacy_ID
(
type: esriFieldTypeString
, alias: Legacy ID
, length: 50
)
-
District
(
type: esriFieldTypeString
, alias: District
, length: 50
)
-
CCTV_ID
(
type: esriFieldTypeString
, alias: CCTV_ID
, length: 20
)
-
Rehab_Date
(
type: esriFieldTypeString
, alias: Rehab Date
, length: 6
)
-
US_Rim_Elev
(
type: esriFieldTypeDouble
, alias: US_Rim_Elev
)
-
DS_Rim_Elev
(
type: esriFieldTypeDouble
, alias: DS_Rim_Elev
)
-
US_Measure
(
type: esriFieldTypeDouble
, alias: US_Measure
)
-
DS_Measure
(
type: esriFieldTypeDouble
, alias: DS_Measure
)
-
US_DS_ID
(
type: esriFieldTypeString
, alias: US_DS_ID
, length: 50
)
-
Comments
(
type: esriFieldTypeString
, alias: Comments
, length: 150
)
-
Televising_Report
(
type: esriFieldTypeString
, alias: Televising_Report
, length: 50
)
-
CCTV_Setup
(
type: esriFieldTypeString
, alias: CCTV Setup
, length: 8
)
-
cctv_report_Num
(
type: esriFieldTypeString
, alias: cctv_report_Num
, length: 50
)
-
cctv_Date
(
type: esriFieldTypeString
, alias: cctv_Date
, length: 30
)
-
cctv_US_MH
(
type: esriFieldTypeString
, alias: cctv_US_MH
, length: 25
)
-
cctv_DS_MH
(
type: esriFieldTypeString
, alias: cctv_DS_MH
, length: 25
)
-
cctv_Street
(
type: esriFieldTypeString
, alias: cctv_Street
, length: 50
)
-
cctv_Material
(
type: esriFieldTypeString
, alias: cctv_Material
, length: 50
)
-
cctv_Diameter
(
type: esriFieldTypeString
, alias: cctv_Diameter
, length: 15
)
-
cctv_Length
(
type: esriFieldTypeString
, alias: cctv_Length
, length: 15
)
-
cctv_Num_Connections
(
type: esriFieldTypeString
, alias: Num_Connections
, length: 10
)
-
cctv_Quick_Str
(
type: esriFieldTypeString
, alias: cctv_Quick_Str
, length: 30
)
-
cctv_Quick_OM
(
type: esriFieldTypeString
, alias: cctv_Quick_OM
, length: 30
)
-
cctv_Str_Rating
(
type: esriFieldTypeString
, alias: cctv_Str_Rating
, length: 20
)
-
cctv_Str_Index
(
type: esriFieldTypeString
, alias: cctv_Str_Index
, length: 20
)
-
cctv_OM_Rating
(
type: esriFieldTypeString
, alias: cctv_OM_Rating
, length: 20
)
-
cctv_OM_Index
(
type: esriFieldTypeString
, alias: cctv_OM_Index
, length: 20
)
-
cctv_Overall_Rating
(
type: esriFieldTypeString
, alias: cctv_Overall_Rating
, length: 20
)
-
cctv_Overall_Index
(
type: esriFieldTypeString
, alias: cctv_Overall_Index
, length: 20
)
-
cctv_Primary_Str_Defect
(
type: esriFieldTypeString
, alias: cctv_Primary_Str_Defect
, length: 50
)
-
cctv_Primary_OM_Defect
(
type: esriFieldTypeString
, alias: cctv_Primary_OM_Defect
, length: 50
)
-
cctv_Engineer_Cond_Rating
(
type: esriFieldTypeString
, alias: cctv_Engineer_Cond_Rating
, length: 50
)
-
CCTV_Video
(
type: esriFieldTypeString
, alias: CCTV_Video
, length: 100
)
-
Work_Orders
(
type: esriFieldTypeSmallInteger
, alias: Work Orders
)
-
cctv_Report
(
type: esriFieldTypeString
, alias: cctv_Report
, length: 70
, Coded Values:
[Yes: Yes]
, [No: No]
, [Proposed: Proposed]
)
-
US_Photo
(
type: esriFieldTypeString
, alias: US_Photo
, length: 125
)
-
DS_Photo
(
type: esriFieldTypeString
, alias: DS_Photo
, length: 125
)
-
Assumed_Matl
(
type: esriFieldTypeString
, alias: Assumed_Matl
, length: 50
, Coded Values:
[Precast Concrete: Precast Concrete]
, [Concrete: Concrete]
, [Brick: Brick]
, ...11 more...
)
-
Status
(
type: esriFieldTypeString
, alias: Status
, length: 30
)
-
Crew
(
type: esriFieldTypeString
, alias: Crew
, length: 25
, Coded Values:
[Crew 1: Crew 1]
, [Crew 2: Crew 2]
, [Crew 3: Crew 3]
)
-
US_Severity
(
type: esriFieldTypeString
, alias: US_Severity
, length: 25
, Coded Values:
[Small/Light: Small/Light]
, [Medium/Moderate: Medium/Moderate]
, [Large/Heavy: Large/Heavy]
, ...2 more...
)
-
DS_Severity
(
type: esriFieldTypeString
, alias: DS_Severity
, length: 25
, Coded Values:
[Small/Light: Small/Light]
, [Medium/Moderate: Medium/Moderate]
, [Large/Heavy: Large/Heavy]
, ...2 more...
)
-
US_Defect
(
type: esriFieldTypeString
, alias: US_Defect
, length: 25
, Coded Values:
[None: None]
, [Cracked: Cracked]
, [Loose: Loose]
, ...10 more...
)
-
DS_Defect
(
type: esriFieldTypeString
, alias: DS_Defect
, length: 25
, Coded Values:
[None: None]
, [Cracked: Cracked]
, [Loose: Loose]
, ...10 more...
)
-
US_Comment
(
type: esriFieldTypeString
, alias: US_Comment
, length: 150
)
-
DS_Comment
(
type: esriFieldTypeString
, alias: DS_Comment
, length: 150
)
-
Critical
(
type: esriFieldTypeString
, alias: Critical
, length: 15
, Coded Values:
[Yes: Yes]
, [No: No]
)
-
created_user
(
type: esriFieldTypeString
, alias: created_user
, length: 255
)
-
created_date
(
type: esriFieldTypeDate
, alias: created_date
, length: 8
)
-
last_edited_user
(
type: esriFieldTypeString
, alias: last_edited_user
, length: 255
)
-
last_edited_date
(
type: esriFieldTypeDate
, alias: last_edited_date
, length: 8
)
-
Inspection
(
type: esriFieldTypeString
, alias: Inspection
, length: 50
)
-
Remaining_Useful_Life_Per
(
type: esriFieldTypeDouble
, alias: Remaining Useful Life %
)
-
Install_Year_D
(
type: esriFieldTypeDouble
, alias: Install Year
)
-
EEL
(
type: esriFieldTypeSmallInteger
, alias: EEL
)
-
POF_Age
(
type: esriFieldTypeSmallInteger
, alias: POF_Age
, Coded Values:
[0: NA]
, [1: > 50% RUL]
, [2: 10% - 50% RUL]
, ...1 more...
)
-
POF_Material
(
type: esriFieldTypeSmallInteger
, alias: POF_Material
, Coded Values:
[0: NA]
, [1: All Others]
, [2: VCP, Truss]
)
-
POF_Condition
(
type: esriFieldTypeSmallInteger
, alias: POF_Condition
, Coded Values:
[0: No Data or CA 1/CA2]
, [1: CA 3]
, [2: CA 4]
, ...1 more...
)
-
POF_Surcharge
(
type: esriFieldTypeSmallInteger
, alias: POF_Surcharge
, Coded Values:
[0: NA]
, [1: Under Capacity/Surcharged]
)
-
WO_Last_Date
(
type: esriFieldTypeDate
, alias: WO Last Date
, length: 8
)
-
Default_WO_Cat
(
type: esriFieldTypeString
, alias: Default_WO_Cat
, length: 10
)
-
WO_Reason
(
type: esriFieldTypeString
, alias: WO Reason
, length: 100
)
-
POF_WO
(
type: esriFieldTypeSmallInteger
, alias: POF_WO
, Coded Values:
[0: None]
, [1: Previous Work Order]
)
-
COF_Size
(
type: esriFieldTypeSmallInteger
, alias: COF_Size
, Coded Values:
[0: Diameter <= 10"]
, [1: > 10" & <= 15"]
, [2: > 15"]
)
-
COF_Property
(
type: esriFieldTypeSmallInteger
, alias: COF_Property
, Coded Values:
[0: > 10' of building]
, [1: < 10' of building]
, [2: Under building]
)
-
COF_Repair_Diff
(
type: esriFieldTypeSmallInteger
, alias: COF_Repair_Diff
, Coded Values:
[0: Depth < 10']
, [1: Depth 10' - 15']
, [2: Depth > 15']
)
-
COF_Surface_Water
(
type: esriFieldTypeSmallInteger
, alias: COF_Surface_Water
, Coded Values:
[0: Not near water or floodplain]
, [1: Within 50' of water or 100 year floodplain]
, [2: Crossing beneath water body]
)
-
COF_Trans
(
type: esriFieldTypeSmallInteger
, alias: COF_Trans
, Coded Values:
[0: Not under pavement]
, [1: Under Pavement]
, [2: In commercial roadway]
)
-
POF
(
type: esriFieldTypeDouble
, alias: POF
)
-
COF
(
type: esriFieldTypeDouble
, alias: COF
)
-
BRE
(
type: esriFieldTypeDouble
, alias: BRE
)
-
LucityAutoID
(
type: esriFieldTypeInteger
, alias: LucityAutoID
)
-
LucitySyncDate
(
type: esriFieldTypeDate
, alias: LucitySyncDate
, length: 8
)
-
LucityCategory
(
type: esriFieldTypeString
, alias: LucityCategory
, length: 5
)
-
InLucityFlag
(
type: esriFieldTypeSmallInteger
, alias: In Lucity Flag
)
-
LastModBy
(
type: esriFieldTypeString
, alias: Last Modified By
, length: 50
)
-
LastModDate
(
type: esriFieldTypeDate
, alias: Last Modified Date
, length: 8
)
-
GlobalID
(
type: esriFieldTypeGlobalID
, alias: GlobalID
, length: 38
)
-
XStart
(
type: esriFieldTypeDouble
, alias: XStart
)
-
YStart
(
type: esriFieldTypeDouble
, alias: YStart
)
-
XY_Start
(
type: esriFieldTypeString
, alias: XY_Start
, length: 50
)
-
XEnd
(
type: esriFieldTypeDouble
, alias: XEnd
)
-
YEnd
(
type: esriFieldTypeDouble
, alias: YEnd
)
-
XY_End
(
type: esriFieldTypeString
, alias: XY_End
, length: 50
)
-
Shape
(
type: esriFieldTypeGeometry
, alias: Shape
)
-
Shape.STLength()
(
type: esriFieldTypeDouble
, alias: Shape.STLength()
)
-
DATE_OF_LAST_CLEANING
(
type: esriFieldTypeDate
, alias: DATE OF LAST CLEANING
, length: 8
)
-
Length_ft_Temp
(
type: esriFieldTypeDouble
, alias: Length_ft_Temp
)
-
JET_CLEAN_DATE
(
type: esriFieldTypeDate
, alias: Jet Cleaning Date
, length: 8
)
Supported Operations:
Query
Generate Renderer
Return Updates