Name: Water Hydrants

Display Field: HYD_NUMBER

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Point Featureclass Provideing spatial and attribute values for fire hydrants within the City of Brandon.Projection NAD 1983 UTM 14N Data DictionaryField NameData TypeDomain NameDescriptionObjectID*ObjectIDNoneFeature IDDISTRICTLongNoneIdentifies cob infrastructure district feature is located inHydrant NumberStringNoneCOB Hydrant NumberOWNERSHIPStringOwnershipDefines Ownership of asset (Public/Private)MANUFACTURERStringHydrant ManufacturersDefuines Hydrant ManufacturerMODELStringHydrant Models GPS position accuracyBURY_DEPTHDoubleNoneDefines Byury depth of TURNS_TO_OPENLongNoneDefines how many turns required to open valveOPEN_DIRECTIONStringDirection To OpenDefines wether valve is opened counter clockwise/clockwiseNUT_TYPEStringHydrant Nut TypesDefines Nut type on HydrantNUT_SIZEDoubleNoneDefines size of Nuts on HydrantINLET_TYPEStringHydrant Inlet TypesDefines Inlet typeINLET_SIZEStringNoneSize of Hydrant inletVALVE_MANUFACTURERStringHydrant Valve ManufacturerHydrant Valve ManufacturerVALVE_MODELStringHydrant Valve ModelValve ModelsMAIN_VALVE_SIZEDoubleNoneDefines Hydrant main valve sizeVALVE_TURNS_TO_OPENLongNone# of turns to open main valve fullyVALVE_OPEN_DIRECTIONStringDirection To OpenDirection to open Clockwise/CounterclockwiseVALVE_NUT_TYPEStringNoneVALVE NUT TYPEVALVE_NUT_SIZEDoubleNoneValve Nut SizeVALVE_INLET_SIZEStringNoneValve inlet sizeHOSE_OUTLETLongNoneHouse Outlet sizeHOSE_OUTLET_THREADDoubleNoneNumber of threads on outletPUMPER_OUTLETSLongNoneNumber of pumper outlets on hydrantPUMPER_OUTLET_SIZEDoubleNonePumper outlet sizePUMPER_THREADDoubleNonePumper outlet Thread #HYDRANT_ANODEDoubleAnode SizeAnode sizeVALVE_ANODEDoubleAnode SizeAnode sizeFacilityIDStringNoneCityworks FIDLocationStringNoneUnused Location Identifier fieldWarrantyDateDateNoneEnd date of Waranty (unused)InstallDateDateNoneDate Hydrant is installedShape*GeometryNonedefines Geometry of featureHYDRANT_CATHODICALLY_TREATEDStringYesNoHYDRANT_CATHODICALLY_TREATEDVALVE_CATHODICALLY_TREATEDStringYesNoVALVE_CATHODICALLY_TREATED

Service Item Id: a185cd5f2ced422a89639ff79987f062

Copyright Text: Author: Jeff Scott/ Date Created (DD/MM/YYYY): 06/06/2012 Development Services Division Department of Engineering AR McDiarmid Civic Complex 638 Princess Ave. Brandon, MB R7A OP3 Phone 204.729.2142 Fax 204.725.3235

Default Visibility: true

MaxRecordCount: 500

Supported Query Formats: JSON, geoJSON

Min Scale: 2500

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -1.11326611478E7
YMin: 6413861.160099998
XMax: -1.11153124968E7
YMax: 6429775.155199997
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: OWNERSHIP
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: PUBLIC
  Label: Public
  Description:
  Symbol:
  
• Value: PRIVATE
  Label: Private
  Description:
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementBelowRight
Label Expression: [FacilityID]
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: 10
Font Family: Segoe UI
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 1500.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
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• DISTRICT ( type: esriFieldTypeInteger, alias: DISTRICT )
• HYD_NUMBER ( type: esriFieldTypeString, alias: HYD_NUMBER, length: 3 )
• OWNERSHIP ( type: esriFieldTypeString, alias: OWNERSHIP, length: 10 )
• MANUFACTURER ( type: esriFieldTypeString, alias: MANUFACTURER, length: 10 )
• MODEL ( type: esriFieldTypeString, alias: MODEL, length: 10 )
• BURY_DEPTH ( type: esriFieldTypeDouble, alias: BURY_DEPTH )
• TURNS_TO_OPEN ( type: esriFieldTypeInteger, alias: TURNS_TO_OPEN )
• OPEN_DIRECTION ( type: esriFieldTypeString, alias: OPEN_DIRECTION, length: 3 )
• NUT_TYPE ( type: esriFieldTypeString, alias: NUT_TYPE, length: 6 )
• NUT_SIZE ( type: esriFieldTypeDouble, alias: NUT_SIZE )
• INLET_TYPE ( type: esriFieldTypeString, alias: INLET_TYPE, length: 10 )
• INLET_SIZE ( type: esriFieldTypeString, alias: INLET_SIZE, length: 1 )
• VALVE_MANUFACTURER ( type: esriFieldTypeString, alias: VALVE_MANUFACTURER, length: 10 )
• VALVE_MODEL ( type: esriFieldTypeString, alias: VALVE_MODEL, length: 10 )
• MAIN_VALVE_SIZE ( type: esriFieldTypeDouble, alias: MAIN_VALVE_SIZE )
• VALVE_TURNS_TO_OPEN ( type: esriFieldTypeInteger, alias: VALVE_TURNS_TO_OPEN )
• VALVE_OPEN_DIRECTION ( type: esriFieldTypeString, alias: VALVE_OPEN_DIRECTION, length: 3 )
• VALVE_NUT_TYPE ( type: esriFieldTypeString, alias: VALVE_NUT_TYPE, length: 6 )
• VALVE_NUT_SIZE ( type: esriFieldTypeDouble, alias: VALVE_NUT_SIZE )
• VALVE_INLET_SIZE ( type: esriFieldTypeString, alias: VALVE_INLET_SIZE, length: 1 )
• HOSE_OUTLET ( type: esriFieldTypeInteger, alias: HOSE_OUTLET )
• HOSE_OUTLET_SIZE ( type: esriFieldTypeDouble, alias: HOSE_OUTLET_SIZE )
• HOSE_OUTLET_THREAD ( type: esriFieldTypeDouble, alias: HOSE_OUTLET_THREAD )
• PUMPER_OUTLETS ( type: esriFieldTypeInteger, alias: PUMPER_OUTLETS )
• PUMPER_OUTLET_SIZE ( type: esriFieldTypeDouble, alias: PUMPER_OUTLET_SIZE )
• PUMPER_THREAD ( type: esriFieldTypeDouble, alias: PUMPER_THREAD )
• HYDRANT_ANODE ( type: esriFieldTypeDouble, alias: HYDRANT_ANODE )
• VALVE_ANODE ( type: esriFieldTypeDouble, alias: VALVE_ANODE )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, length: 20 )
• Location ( type: esriFieldTypeString, alias: Location, length: 100 )
• WarrantyDate ( type: esriFieldTypeDate, alias: WarrantyDate, length: 8 )
• InstallDate ( type: esriFieldTypeDate, alias: InstallDate, length: 8 )
• HYDRANT_CATHODICALLY_TREATED ( type: esriFieldTypeString, alias: HYDRANT_CATHODICALLY_TREATED, length: 3 )
• VALVE_CATHODICALLY_TREATED ( type: esriFieldTypeString, alias: VALVE_CATHODICALLY_TREATED, length: 3 )
• CONSTRUCTION_TYPE ( type: esriFieldTypeString, alias: Construction Type, length: 50 )
• created_by ( type: esriFieldTypeString, alias: created_by, length: 255 )
• created_on ( type: esriFieldTypeDate, alias: created_on, length: 8 )
• edited_by ( type: esriFieldTypeString, alias: edited_by, length: 255 )
• edited_on ( type: esriFieldTypeDate, alias: edited_on, length: 8 )
• ABANDONED ( type: esriFieldTypeString, alias: ABANDONED, length: 50 )
• ASSET_TYPE ( type: esriFieldTypeString, alias: ASSET_TYPE, length: 50 )
• LENGTH ( type: esriFieldTypeDouble, alias: LENGTH )
• AREA ( type: esriFieldTypeDouble, alias: AREA )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata