Name: wServiceLateral
Display Field: CreatedBy
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Description: Inventory of water service laterals.
Copyright Text:
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON, geoJSON
Min Scale: 0
Max Scale: 0
Supports Advanced Queries: true
Supports Statistics: true
Has Labels: false
Can Modify Layer: true
Can Scale Symbols: false
Use Standardized Queries: true
Supports Datum Transformation: true
Extent:
XMin: 771327.587890625
YMin: 456237.86907958984
XMax: 857921.0294799805
YMax: 517793.16912841797
Spatial Reference: 103412
(8193)
Drawing Info:
Renderer:
Simple Renderer:
Symbol: Style: esriSLSSolid
Color: [0, 169, 230, 255]
Width: 1
Label:
Description:
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: false
HasM: true
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
Enabled
(
type: esriFieldTypeSmallInteger, alias: Enabled
, Coded Values:
[0: No]
, [1: Yes]
)
-
CreatedBy
(
type: esriFieldTypeString, alias: CreatedBy, length: 5
)
-
CreatedDate
(
type: esriFieldTypeDate, alias: CreatedDate, length: 8
)
-
LastEditor
(
type: esriFieldTypeString, alias: Last Editor, length: 5
)
-
LastUpdate
(
type: esriFieldTypeDate, alias: Last Update Date, length: 8
)
-
ServiceType
(
type: esriFieldTypeString, alias: ServiceType, length: 15
, Coded Values:
[GENERAL: General]
, [PUBLIC FIRE: Public Fire Protection]
, [PRIVATE FIRE: Private Fire Protection]
, ...9 more...
)
-
Metered
(
type: esriFieldTypeSmallInteger, alias: Metered
, Coded Values:
[0: False]
, [1: True]
)
-
AssetCode
(
type: esriFieldTypeString, alias: AssetCode, length: 4
)
-
PageNumber
(
type: esriFieldTypeInteger, alias: PageNumber
)
-
AssetNumber
(
type: esriFieldTypeInteger, alias: AssetNumber
)
-
FacilityID
(
type: esriFieldTypeString, alias: FacilityID, length: 20
)
-
LegacyID
(
type: esriFieldTypeString, alias: LegacyID, length: 20
)
-
WaterType
(
type: esriFieldTypeString, alias: WaterType, length: 10
, Coded Values:
[Treated: Treated Water]
, [Combined: Combined Waste Water]
, [Potable: Potable Water]
, ...6 more...
)
-
DataSource
(
type: esriFieldTypeString, alias: DataSource, length: 10
, Coded Values:
[DES: Design Drawing]
, [GPS: GPS]
, [ASB: Asbuilt/Record Drawing]
, ...7 more...
)
-
RetiredProject
(
type: esriFieldTypeString, alias: RetiredProject, length: 20
)
-
ProjectNumber
(
type: esriFieldTypeString, alias: ProjectNumber, length: 20
)
-
InstallDate
(
type: esriFieldTypeDate, alias: InstallDate, length: 8
)
-
RetireDate
(
type: esriFieldTypeDate, alias: RetireDate, length: 8
)
-
LifecycleStatus
(
type: esriFieldTypeString, alias: LifecycleStatus, length: 20
, Coded Values:
[ACT: Active]
, [INA: Inactive]
, [PRO: Proposed]
, ...4 more...
)
-
Diameter
(
type: esriFieldTypeDouble, alias: Diameter
, Coded Values:
[0.75: 3/4]
, [1: 1]
, [1.25: 1.25]
, ...14 more...
)
-
Material
(
type: esriFieldTypeString, alias: Material, length: 10
, Coded Values:
[AC: Asbestos Concrete]
, [CI: Cast Iron]
, [CL: Clay]
, ...12 more...
)
-
POMaterial
(
type: esriFieldTypeString, alias: POMaterial, length: 10
, Coded Values:
[AC: Asbestos Concrete]
, [CI: Cast Iron]
, [CL: Clay]
, ...12 more...
)
-
ServiceLength
(
type: esriFieldTypeInteger, alias: ServiceLength
)
-
OutDistance
(
type: esriFieldTypeInteger, alias: OutDistance
)
-
PropertyID
(
type: esriFieldTypeString, alias: PropertyID, length: 12
)
-
Comments
(
type: esriFieldTypeString, alias: Comments, length: 255
)
-
mslink
(
type: esriFieldTypeInteger, alias: mslink
)
-
Hyperlink
(
type: esriFieldTypeString, alias: Hyperlink, length: 255
)
-
ApplicationID
(
type: esriFieldTypeString, alias: ApplicationID, length: 10
)
-
DistAlongPL
(
type: esriFieldTypeDouble, alias: DistAlongPL
)
-
Tail
(
type: esriFieldTypeDouble, alias: Tail
)
-
MeasuredFrom
(
type: esriFieldTypeString, alias: MeasuredFrom, length: 25
)
-
EntersProp
(
type: esriFieldTypeString, alias: EntersProp, length: 50
)
-
Notes
(
type: esriFieldTypeString, alias: Notes, length: 255
)
-
Plumber
(
type: esriFieldTypeString, alias: Plumber, length: 50
)
-
ModDate
(
type: esriFieldTypeDate, alias: ModDate, length: 8
)
-
InstallType
(
type: esriFieldTypeString, alias: InstallType, length: 25
)
-
CorpSize
(
type: esriFieldTypeDouble, alias: CorpSize
)
-
MainSize
(
type: esriFieldTypeDouble, alias: MainSize
)
-
ServiceValveID
(
type: esriFieldTypeString, alias: ServiceValveID, length: 20
)
-
ModType
(
type: esriFieldTypeString, alias: ModType, length: 10
)
-
MaintainedBy
(
type: esriFieldTypeString, alias: MaintainedBy, length: 25
, Coded Values:
[MADISON WATER UTILITY: Madison Water Utility]
, [PRIVATE: Private]
, [OTHER: Other]
, ...5 more...
)
-
Shape
(
type: esriFieldTypeGeometry, alias: Shape
)
-
Location
(
type: esriFieldTypeString, alias: Location, length: 250
)
-
StreetSegmentID
(
type: esriFieldTypeString, alias: StreetSegmentID, length: 25
)
-
WarrantyDate
(
type: esriFieldTypeDate, alias: WarrantyDate, length: 8
)
-
Condition
(
type: esriFieldTypeInteger, alias: Condition
)
-
ConditionDate
(
type: esriFieldTypeDate, alias: ConditionDate, length: 8
)
-
StopKeyType
(
type: esriFieldTypeString, alias: StopType, length: 10
)
-
StopPosition
(
type: esriFieldTypeString, alias: StopPosition, length: 10
, Coded Values:
[Open: Open]
, [Closed: Closed]
)
-
CWWorkOrderID2
(
type: esriFieldTypeString, alias: CWWorkOrderID2, length: 30
)
-
CWRetiredWorkOrderID2
(
type: esriFieldTypeString, alias: CWRetiredWorkOrderID2, length: 30
)
-
CorpManufacturer
(
type: esriFieldTypeString, alias: CorpManufacturer, length: 10
, Coded Values:
[McDonald: AY McDonald]
, [Ford: Ford]
, [Mueller: Mueller]
)
-
CurbStopManufacturer
(
type: esriFieldTypeString, alias: CurbStopManufacturer, length: 10
, Coded Values:
[McDonald: AY McDonald]
, [Ford: Ford]
, [Mueller: Mueller]
)
-
Municipality
(
type: esriFieldTypeString, alias: Municipality, length: 30
)
-
PREV_LEAD
(
type: esriFieldTypeString, alias: PREV_LEAD, length: 5
, Coded Values:
[Y: Y]
, [N: N]
, [UNK: UNK]
)
-
BASIS_CLASS
(
type: esriFieldTypeString, alias: BASIS_CLASS, length: 25
, Coded Values:
[PREVIOUS EVAL: PREVIOUS MATERIALS EVALUATION]
, [INSTALLATION RECORD: INSTALLATION RECORD (EG TAP CARD)]
, [INSTALLED AFTER LEAD BAN: INSTALLATION AFTER LEAD BAN (1986)]
, ...5 more...
)
-
MATERIAL_VERIFIED
(
type: esriFieldTypeString, alias: MATERIAL_VERIFIED, length: 5
, Coded Values:
[Y: Y]
, [N: N]
, [UNK: UNK]
)
-
VERIFICATION_METHOD
(
type: esriFieldTypeString, alias: VERIFICATION_METHOD, length: 25
, Coded Values:
[CUSTOMER SELF ID: CUSTOMER SELF IDENTIFICATION]
, [CCTV - INTERNAL: CCTV AT CURB STOP - INTERNAL]
, [CCTV - EXTERNAL: CCTV AT CURB STOP - EXTERNAL]
, ...5 more...
)
-
VERIFICATION_DT
(
type: esriFieldTypeDate, alias: VERIFICATION_DT, length: 8
)
-
PO_PREV_LEAD
(
type: esriFieldTypeString, alias: PO_PREV_LEAD, length: 5
, Coded Values:
[Y: Y]
, [N: N]
, [UNK: UNK]
)
-
PO_BASIS_CLASS
(
type: esriFieldTypeString, alias: PO_BASIS_CLASS, length: 25
, Coded Values:
[PREVIOUS EVAL: PREVIOUS MATERIALS EVALUATION]
, [INSTALLATION RECORD: INSTALLATION RECORD (EG TAP CARD)]
, [INSTALLED AFTER LEAD BAN: INSTALLATION AFTER LEAD BAN (1986)]
, ...5 more...
)
-
PO_MATERIAL_VERIFIED
(
type: esriFieldTypeString, alias: PO_MATERIAL_VERIFIED, length: 5
, Coded Values:
[Y: Y]
, [N: N]
, [UNK: UNK]
)
-
PO_VERIFICATION_METHOD
(
type: esriFieldTypeString, alias: PO_VERIFICATION_METHOD, length: 25
, Coded Values:
[CUSTOMER SELF ID: CUSTOMER SELF IDENTIFICATION]
, [CCTV - INTERNAL: CCTV AT CURB STOP - INTERNAL]
, [CCTV - EXTERNAL: CCTV AT CURB STOP - EXTERNAL]
, ...5 more...
)
-
PO_VERIFICATION_DT
(
type: esriFieldTypeDate, alias: PO_VERIFICATION_DT, length: 8
)
-
MAT_CLASS_NOTES
(
type: esriFieldTypeString, alias: MAT_CLASS_NOTES, length: 255
)
-
PO_MAT_CLASS_NOTES
(
type: esriFieldTypeString, alias: PO_MAT_CLASS_NOTES, length: 255
)
-
Shape.STLength()
(
type: esriFieldTypeDouble, alias: Shape.STLength()
)
Supported Operations:
Query
Query Attachments
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata