Layer: Hydrant Lateral (ID:10)

View In: Map Viewer

Name: Hydrant Lateral

Display Field: EAM_PARENT

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Hydrant Laterals specifically represent the line connecting fire hydrants and the water mains. Their positions are GPS verified by collecting locations of hydrants and branch valves, and sourced from as-built drawings and in house repair and replacement efforts.

Attribute Information:

Field Name	Description
OBJECTID	ESRI software specific field that serves as an index for the database.
EAM_PARENT	Infor required field.
EAM_PARENTORG	Infor required field.
EAM_UOM	Infor required field.
EAM_UOMREF	Infor required field.
EAM_PRECISION	Infor required field.
GISOBJID	Unique identifier that serves as the key field for Infor. Infor required field.
FacilityID	A unique identifier for the asset class. Infor required field.
InstallDate	The date when the asset was installed. Typically pulled from as-builts for consistency. Infor required field.
PressureZone	Numbered areas bound by both a lower and upper elevation that require pressure adjustment between areas to keep pressures up high enough to achieve fire flow.
LifecycleStatus	The current status of the asset with respect to its location in the asset management lifecycle. Infor required field.
WaterType	Denotes the level of treatment of the water within the main from raw water to potable.
Comments	A catch all for asset information that is irregular and doesn't warrant the creation of a new field.
Diameter	Diameter of the pipe in inches.
Material	Material the asset is constructed from.
FlowMeasurementID	A unique identifier for use in flow measurement software.
RestraintType	The fitting used to attach the lateral to the water main.
Description	Information related to the construction location or project name. Infor required field
Clean_Route	Maintenance zone number the asset is associated with.
Insp_Route	Maintenance zone number the asset is associated with.
SubZone	Sub zones within pressure zones for operators and maintenance purposes.
created_user	Name of user whom created the asset.
created_date	Date when the asset was created.
last_edited_user	Name of user whom most recently edited asset information.
last_edited_date	Date when asset was most recently updated.
Enabled	ESRI software specific field related to the inclusion in a network.
GlobalID	ESRI software specific field that is automatically assigned by the geodatabase at row creation.
AsBuiltNumber	The file number where the as-built for the asset can be found.
Shape	ESRI software specific field denoting the geometry type of the asset.
Shape.STLength()	Length of the asset in feet.

Copyright Text: City of Bend

Min. Scale: 2257

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"LifecycleStatus","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":1},"value":"DC","label":"Removed; Withdrawn; Abandoned"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":1},"value":"D","label":"Removed; Withdrawn; Abandoned"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":1},"value":"AB","label":"Removed; Withdrawn; Abandoned"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[168,0,0,255],"width":1.5},"value":"I","label":"Active"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[156,156,156,255],"width":1.5},"value":"IN","label":"Inactive"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[168,0,0,255],"width":1.5},"value":"PROP","label":"Proposed"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[244,252,192,255],"toColor":[244,252,192,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[246,179,252,255],"toColor":[246,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,233,252,255],"toColor":[187,233,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,185,255],"toColor":[252,182,185,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,222,255],"toColor":[179,252,222,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,227,207,255],"toColor":[252,227,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[224,207,252,255],"toColor":[224,207,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,179,252,255],"toColor":[179,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,184,255],"toColor":[179,252,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,230,255],"toColor":[252,215,230,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[210,252,245,255],"toColor":[210,252,245,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[223,252,215,255],"toColor":[223,252,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,192,225,255],"toColor":[252,192,225,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field: LifecycleStatus

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
FacilityID (type: esriFieldTypeString, alias: FacilityID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
InstallDate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
PressureZone (type: esriFieldTypeString, alias: Pressure Zone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Zone 1: Zone 1], [Zone 2: Zone 2], [Zone 3: Zone 3], ... 7 more ...)
LifecycleStatus (type: esriFieldTypeString, alias: Lifecycle Status, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [PROP: Proposed], [I: Active], [IN: Inactive], ... 3 more ...)
WaterType (type: esriFieldTypeString, alias: Water Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Non-Potable Water: Non-Potable Water], [Treated Water: Treated Water], [Potable Water: Potable Water])
Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Diameter (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown/Other], [0.375: 3/8 Inch], [0.5: 1/2 Inch], ... 17 more ...)
Material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Copper: Copper], [Ductile Iron: Ductile Iron], [Cast Iron: Cast Iron], ... 7 more ...)
Description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
SubZone (type: esriFieldTypeString, alias: Pressure Subzone, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [2A: 2A], ... 30 more ...)
created_user (type: esriFieldTypeString, alias: Created User, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
created_date (type: esriFieldTypeDate, alias: Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
last_edited_user (type: esriFieldTypeString, alias: Last Edited User, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
last_edited_date (type: esriFieldTypeDate, alias: Last Edited Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
AsBuiltNumber (type: esriFieldTypeString, alias: AsBuilt Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
UPDATE_COUNT (type: esriFieldTypeSmallInteger, alias: UPDATE_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

Field Name: PressureZone
Inherited
Field Name: LifecycleStatus
Inherited
Field Name: WaterType
Inherited
Field Name: Diameter
Inherited
Field Name: Material
Inherited
Field Name: SubZone
Inherited
Field Name: RestraintType
Inherited
Field Name: Enabled
Inherited

LifecycleStatus: DC
WaterType: Potable Water

Field Name: PressureZone
Inherited
Field Name: LifecycleStatus
Inherited
Field Name: WaterType
Inherited
Field Name: Diameter
Inherited
Field Name: Material
Inherited
Field Name: SubZone
Inherited
Field Name: RestraintType
Inherited
Field Name: Enabled
Inherited

LifecycleStatus: D
WaterType: Potable Water

Field Name: PressureZone
Inherited
Field Name: LifecycleStatus
Inherited
Field Name: WaterType
Inherited
Field Name: Diameter
Inherited
Field Name: Material
Inherited
Field Name: SubZone
Inherited
Field Name: RestraintType
Inherited
Field Name: Enabled
Inherited

LifecycleStatus: AB
WaterType: Potable Water

Field Name: PressureZone
Inherited
Field Name: LifecycleStatus
Inherited
Field Name: WaterType
Inherited
Field Name: Diameter
Inherited
Field Name: Material
Inherited
Field Name: SubZone
Inherited
Field Name: RestraintType
Inherited
Field Name: Enabled
Inherited

LifecycleStatus: I
WaterType: Potable Water

Field Name: PressureZone
Inherited
Field Name: LifecycleStatus
Inherited
Field Name: WaterType
Inherited
Field Name: Diameter
Inherited
Field Name: Material
Inherited
Field Name: SubZone
Inherited
Field Name: RestraintType
Inherited
Field Name: Enabled
Inherited

LifecycleStatus: IN
WaterType: Potable Water

Field Name: PressureZone
Inherited
Field Name: LifecycleStatus
Inherited
Field Name: WaterType
Inherited
Field Name: Diameter
Inherited
Field Name: Material
Inherited
Field Name: SubZone
Inherited
Field Name: RestraintType
Inherited
Field Name: Enabled
Inherited

LifecycleStatus: PROP
WaterType: Potable Water

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/26/2024 12:31:55 AM

Schema Last Edit Date: 11/26/2024 12:31:55 AM

Data Last Edit Date: 4/25/2024 10:59:56 AM

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