View In:   ArcGIS Online Map Viewer

Name: Water Hydrant

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 2d85a562a7754180ac60e9550eefb375

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 311813.61763499986
YMin: 5770735.9559349995
XMax: 720045.2868650004
YMax: 6178967.625165001
Spatial Reference: 26910  (26910)  VCSWkid(5703)  LatestVCSWkid(5703)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: ASSETGROUP
Field 2: ownedby
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 7,1
  Label: CPG
  Description: N/A
  Symbol:
  
• Value: 7,-2
  Label: Private
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [assetid]
Use Coded Values: true
Symbol:
Color: [168, 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
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [assetid]
Use Coded Values: true
Symbol:
Color: [230, 230, 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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: ASSETGROUP

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: Object ID, editable: false, nullable: false, length: 8, defaultValue: null, modelName: OBJECTID )
• ASSETGROUP ( type: esriFieldTypeInteger, alias: Asset group, editable: true, nullable: false, defaultValue: 0, modelName: ASSETGROUP, required: true )
• ASSETTYPE ( type: esriFieldTypeSmallInteger, alias: Asset type, editable: true, nullable: false, defaultValue: 0, modelName: ASSETTYPE, required: true )
• ASSOCIATIONSTATUS ( type: esriFieldTypeSmallInteger, alias: Association status, editable: false, nullable: false, defaultValue: 0, modelName: ASSOCIATIONSTATUS, required: true , Coded Values: [0: None] , [1: Container] , [2: Structure] , ...33 more... )
• ISSUBNETWORKCONTROLLER ( type: esriFieldTypeSmallInteger, alias: Is subnetwork controller, editable: false, nullable: false, defaultValue: 0, modelName: ISSUBNETWORKCONTROLLER, required: true , Coded Values: [0: False] , [1: True] )
• ISCONNECTED ( type: esriFieldTypeSmallInteger, alias: Is connected, editable: false, nullable: false, defaultValue: 2, modelName: ISCONNECTED, required: true , Coded Values: [0: False] , [1: True] , [2: Unknown] )
• SUBNETWORKCONTROLLERNAME ( type: esriFieldTypeString, alias: Subnetwork controller name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: SUBNETWORKCONTROLLERNAME, required: true )
• TIERNAME ( type: esriFieldTypeSmallInteger, alias: Tier name, editable: false, nullable: false, defaultValue: 0, modelName: TIERNAME, required: true , Coded Values: [0: Unknown] , [1: Water Cathodic Protection] , [2: Water System] , ...3 more... )
• TIERRANK ( type: esriFieldTypeInteger, alias: Tier rank, editable: false, nullable: false, defaultValue: 0, modelName: TIERRANK, required: true )
• TERMINALCONFIGURATION ( type: esriFieldTypeString, alias: Terminal path, editable: true, nullable: false, length: 128, defaultValue: Default, modelName: TERMINALCONFIGURATION, required: true )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: Global ID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• cpsubnetworkname ( type: esriFieldTypeString, alias: CP Subnetwork Name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: cpsubnetworkname, required: true )
• SUPPORTEDSUBNETWORKNAME ( type: esriFieldTypeString, alias: Supported subnetwork name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: SUPPORTEDSUBNETWORKNAME, required: true )
• SUPPORTINGSUBNETWORKNAME ( type: esriFieldTypeString, alias: Supporting subnetwork name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: SUPPORTINGSUBNETWORKNAME, required: true )
• SystemSubnetworkName ( type: esriFieldTypeString, alias: System Subnetwork Name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: SystemSubnetworkName, required: true )
• PressureSubnetworkName ( type: esriFieldTypeString, alias: Pressure Subnetwork Name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: PressureSubnetworkName, required: true )
• IsolationSubnetworkName ( type: esriFieldTypeString, alias: Isolation Subnetwork Name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: IsolationSubnetworkName, required: true )
• DMASubnetworkName ( type: esriFieldTypeString, alias: DMA Subnetwork Name, editable: false, nullable: false, length: 2000, defaultValue: Unknown, modelName: DMASubnetworkName, required: true )
• creationdate ( type: esriFieldTypeDate, alias: Creation date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: creationdate, required: true )
• creator ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 255, defaultValue: null, modelName: creator, required: true )
• lastupdate ( type: esriFieldTypeDate, alias: Last update, editable: false, nullable: true, length: 8, defaultValue: null, modelName: lastupdate, required: true )
• updatedby ( type: esriFieldTypeString, alias: Updated by, editable: false, nullable: true, length: 255, defaultValue: null, modelName: updatedby, required: true )
• diameter ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: diameter )
• secondarydiameter ( type: esriFieldTypeDouble, alias: Secondary Diameter, editable: true, nullable: true, defaultValue: null, modelName: secondarydiameter )
• pressure ( type: esriFieldTypeDouble, alias: Pressure, editable: true, nullable: true, defaultValue: null, modelName: pressure )
• designtype ( type: esriFieldTypeSmallInteger, alias: Design Type, editable: true, nullable: true, defaultValue: null, modelName: designtype )
• normalstatus ( type: esriFieldTypeSmallInteger, alias: Normal Status, editable: true, nullable: true, defaultValue: null, modelName: normalstatus , Coded Values: [0: Closed] , [1: Open] )
• presentstatus ( type: esriFieldTypeSmallInteger, alias: Present Status, editable: true, nullable: true, defaultValue: null, modelName: presentstatus , Coded Values: [0: Closed] , [1: Open] )
• additionaldetails ( type: esriFieldTypeSmallInteger, alias: Additional Details, editable: true, nullable: true, defaultValue: null, modelName: additionaldetails )
• designinfo ( type: esriFieldTypeDouble, alias: Design Info, editable: true, nullable: true, defaultValue: null, modelName: designinfo )
• operable ( type: esriFieldTypeSmallInteger, alias: Operable, editable: true, nullable: false, defaultValue: null, modelName: operable )
• name ( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 64, defaultValue: null, modelName: name )
• installdate ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: installdate )
• assetid ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: assetid )
• accountid ( type: esriFieldTypeString, alias: Account ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: accountid )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: ownedby , Coded Values: [1: CPG] , [-1: RDFFG] , [-2: Private] , ...3 more... )
• maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By, editable: true, nullable: true, defaultValue: 1, modelName: maintby , Coded Values: [1: Asset] , [2: Bylaw] , [3: Civic Facility] , ...21 more... )
• additionaldevice ( type: esriFieldTypeSmallInteger, alias: Additional Device, editable: true, nullable: true, defaultValue: null, modelName: additionaldevice )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: notes )
• symbolrotation ( type: esriFieldTypeSmallInteger, alias: Symbol Rotation, editable: true, nullable: true, defaultValue: null, modelName: symbolrotation , Range: [0, 359] )
• lastmaint ( type: esriFieldTypeDate, alias: Last Maintenance, editable: true, nullable: true, length: 8, defaultValue: null, modelName: lastmaint )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Lifecycle Status, editable: true, nullable: false, defaultValue: 0, modelName: lifecyclestatus , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...14 more... )
• bondedinsulated ( type: esriFieldTypeSmallInteger, alias: Bonded/Insulated, editable: true, nullable: true, defaultValue: null, modelName: bondedinsulated , Coded Values: [1: Bonded] , [2: Insulated] )
• cptraceability ( type: esriFieldTypeSmallInteger, alias: Cathodic Protection Traceability, editable: true, nullable: true, defaultValue: 0, modelName: cptraceability , Coded Values: [0: Unknown] , [1: Yes] , [2: No] )
• inservicedate ( type: esriFieldTypeDate, alias: In-Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: inservicedate )
• retireddate ( type: esriFieldTypeDate, alias: Retired Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: retireddate )
• spatialsource ( type: esriFieldTypeSmallInteger, alias: Spatial Source, editable: true, nullable: true, defaultValue: null, modelName: spatialsource , Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more... )
• spatialconfidence ( type: esriFieldTypeSmallInteger, alias: Spatial Confidence, editable: true, nullable: true, defaultValue: null, modelName: spatialconfidence , Coded Values: [0: Unknown] , [1: High] , [2: Medium] , ...1 more... )
• cpoverride ( type: esriFieldTypeSmallInteger, alias: Cathodic Protection Override, editable: true, nullable: true, defaultValue: null, modelName: cpoverride , Coded Values: [1: Traceable] , [2: Not Traceable] )
• manufacturer ( type: esriFieldTypeSmallInteger, alias: Manufacturer, editable: true, nullable: true, defaultValue: null, modelName: manufacturer )
• operator ( type: esriFieldTypeSmallInteger, alias: Postindicator Valve, editable: true, nullable: true, defaultValue: null, modelName: operator )
• location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 100, defaultValue: null, modelName: location )
• pressurezone ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 20, defaultValue: null, modelName: pressurezone )
• installcontractor ( type: esriFieldTypeSmallInteger, alias: Install Contractor, editable: true, nullable: true, defaultValue: null, modelName: installcontractor )
• elevation ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: elevation )
• groundtype ( type: esriFieldTypeSmallInteger, alias: Ground Type, editable: true, nullable: true, defaultValue: null, modelName: groundtype )
• model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 20, defaultValue: null, modelName: model )
• source ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 20, defaultValue: null, modelName: source )
• overflowelev ( type: esriFieldTypeDouble, alias: Overflow Elevation, editable: true, nullable: true, defaultValue: null, modelName: overflowelev )
• nozzlediameter2 ( type: esriFieldTypeDouble, alias: Nozzle Diameter 2, editable: true, nullable: true, defaultValue: null, modelName: nozzlediameter2 )
• nozzlediameter3 ( type: esriFieldTypeDouble, alias: Nozzle Diameter 3, editable: true, nullable: true, defaultValue: null, modelName: nozzlediameter3 )
• nozzlediameter4 ( type: esriFieldTypeDouble, alias: Nozzle Diameter 4, editable: true, nullable: true, defaultValue: null, modelName: nozzlediameter4 )
• seatdiameter ( type: esriFieldTypeDouble, alias: Seat Diameter, editable: true, nullable: true, defaultValue: null, modelName: seatdiameter )
• markertype ( type: esriFieldTypeSmallInteger, alias: Marker Type, editable: true, nullable: true, defaultValue: null, modelName: markertype )
• designflow ( type: esriFieldTypeString, alias: Design Flow, editable: true, nullable: true, length: 20, defaultValue: null, modelName: designflow )
• serialnumber ( type: esriFieldTypeString, alias: Serial Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: serialnumber )
• bottomelev ( type: esriFieldTypeDouble, alias: Elevation at Bottom, editable: true, nullable: true, defaultValue: null, modelName: bottomelev )
• pressurerange ( type: esriFieldTypeString, alias: Pressure Range, editable: true, nullable: true, length: 20, defaultValue: null, modelName: pressurerange )
• pressuresettingus ( type: esriFieldTypeDouble, alias: Pressure Setting Upstream, editable: true, nullable: true, defaultValue: null, modelName: pressuresettingus )
• pressuresettingds ( type: esriFieldTypeDouble, alias: Pressure Setting Downstream, editable: true, nullable: true, defaultValue: null, modelName: pressuresettingds )
• totaldynamichead ( type: esriFieldTypeInteger, alias: Total Dynamic Head, editable: true, nullable: true, defaultValue: null, modelName: totaldynamichead )
• depth ( type: esriFieldTypeDouble, alias: Depth, editable: true, nullable: true, defaultValue: null, modelName: depth )
• percentopen ( type: esriFieldTypeInteger, alias: Percent Open, editable: true, nullable: true, defaultValue: null, modelName: percentopen )
• currentvalue ( type: esriFieldTypeString, alias: Current Value, editable: true, nullable: true, length: 20, defaultValue: null, modelName: currentvalue )
• id ( type: esriFieldTypeString, alias: ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: id )
• measurementtype ( type: esriFieldTypeString, alias: Measurement Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: measurementtype )
• conditiondate ( type: esriFieldTypeDate, alias: Condition Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: conditiondate )
• acquisitioncost ( type: esriFieldTypeDouble, alias: Acquisition Cost, editable: true, nullable: true, defaultValue: null, modelName: acquisitioncost )
• expectedlife ( type: esriFieldTypeDouble, alias: Expected Life, editable: true, nullable: true, defaultValue: null, modelName: expectedlife )
• residualvalue ( type: esriFieldTypeDouble, alias: Residual Value, editable: true, nullable: true, defaultValue: null, modelName: residualvalue )
• condition ( type: esriFieldTypeDouble, alias: Condition, editable: true, nullable: true, defaultValue: null, modelName: condition )
• cofscore ( type: esriFieldTypeDouble, alias: CoF Score, editable: true, nullable: true, defaultValue: null, modelName: cofscore )
• cofdate ( type: esriFieldTypeDate, alias: CoF Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: cofdate )
• riskscore ( type: esriFieldTypeDouble, alias: Risk Score, editable: true, nullable: true, defaultValue: null, modelName: riskscore )
• link ( type: esriFieldTypeString, alias: Link, editable: true, nullable: true, length: 255, defaultValue: null, modelName: link )
• parentglobalid ( type: esriFieldTypeGUID, alias: Parent Global ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: parentglobalid )
• VALIDATIONSTATUS ( type: esriFieldTypeSmallInteger, alias: Validation status, editable: false, nullable: true, defaultValue: 6, modelName: VALIDATIONSTATUS )
• subtypetext ( type: esriFieldTypeString, alias: Subtype Text, editable: true, nullable: true, length: 255, defaultValue: null, modelName: subtypetext )

Types:

ID: 7
Name: Fire Hydrant
Domains:
Templates:
• Name: 7, 1
  Description:
  Prototype:
  pressurerange: null
  parentglobalid: null
  ASSETGROUP: 7
  ASSETTYPE: 0
  link: null
  riskscore: null
  cofdate: null
  cofscore: null
  condition: null
  residualvalue: null
  TERMINALCONFIGURATION: Default
  subtypetext: null
  expectedlife: null
  acquisitioncost: null
  conditiondate: null
  measurementtype: null
  id: null
  currentvalue: null
  percentopen: null
  depth: null
  totaldynamichead: null
  pressuresettingds: null
  pressuresettingus: null
  diameter: null
  secondarydiameter: null
  pressure: null
  designtype: null
  normalstatus: null
  presentstatus: null
  additionaldetails: null
  designinfo: null
  operable: 0
  name: null
  installdate: null
  assetid: null
  accountid: null
  ownedby: 1
  maintby: 21
  additionaldevice: 0
  notes: null
  symbolrotation: null
  lastmaint: null
  lifecyclestatus: 8
  bondedinsulated: null
  cptraceability: 0
  inservicedate: null
  retireddate: null
  spatialsource: 0
  spatialconfidence: 0
  cpoverride: null
  manufacturer: null
  operator: null
  location: null
  pressurezone: null
  installcontractor: null
  elevation: null
  groundtype: null
  model: null
  source: null
  overflowelev: null
  nozzlediameter2: null
  nozzlediameter3: null
  nozzlediameter4: null
  seatdiameter: null
  markertype: null
  designflow: null
  serialnumber: null
  bottomelev: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: 7, -2
  Description:
  Prototype:
  pressurerange: null
  parentglobalid: null
  ASSETGROUP: 7
  ASSETTYPE: 0
  link: null
  riskscore: null
  cofdate: null
  cofscore: null
  condition: null
  residualvalue: null
  TERMINALCONFIGURATION: Default
  subtypetext: null
  expectedlife: null
  acquisitioncost: null
  conditiondate: null
  measurementtype: null
  id: null
  currentvalue: null
  percentopen: null
  depth: null
  totaldynamichead: null
  pressuresettingds: null
  pressuresettingus: null
  diameter: null
  secondarydiameter: null
  pressure: null
  designtype: null
  normalstatus: null
  presentstatus: null
  additionaldetails: null
  designinfo: null
  operable: 0
  name: null
  installdate: null
  assetid: null
  accountid: null
  ownedby: -2
  maintby: 21
  additionaldevice: 0
  notes: null
  symbolrotation: null
  lastmaint: null
  lifecyclestatus: 8
  bondedinsulated: null
  cptraceability: 0
  inservicedate: null
  retireddate: null
  spatialsource: 0
  spatialconfidence: 0
  cpoverride: null
  manufacturer: null
  operator: null
  location: null
  pressurezone: null
  installcontractor: null
  elevation: null
  groundtype: null
  model: null
  source: null
  overflowelev: null
  nozzlediameter2: null
  nozzlediameter3: null
  nozzlediameter4: null
  seatdiameter: null
  markertype: null
  designflow: null
  serialnumber: null
  bottomelev: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• StructureBoundary (2) -- Related To: Water Structure (24)

Capabilities: Query,Extract,ChangeTracking

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports OidReservation: true

Edit Fields Info:

• Creation Date Field: creationdate
• Creator Field: creator
• Edit Date Field: lastupdate
• Editor Field: updatedby

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata