View In:   ArcGIS Online Map Viewer

Parent Layer: COT Water Network Structures

Name: wtrHydrant - Frozen; Out Of Service

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Source:Data Owner:Projection: NAD_1983_StatePlane_Ohio_North_FIPS_3401_FeetDate Created:Description: Maintenance Cycle:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 30000

Max Scale: 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: 1599574.79009102
YMin: 694250.264618412
XMax: 1707637.19205069
YMax: 754258.789010957
Spatial Reference: 102722  (3734)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Status
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: O
  Label: Out of Service
  Description: N/A
  Symbol:
  
• Value: F
  Label: Frozen
  Description: N/A
  Symbol:
  
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: true
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: Status

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• AssetID ( type: esriFieldTypeString, alias: AssetID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AssetID )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LegacyID )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Location )
• Owner ( type: esriFieldTypeString, alias: Ownership, editable: true, nullable: true, length: 10, defaultValue: COT, modelName: Owner , Coded Values: [COT: City of Toledo] , [LUC: Lucas County] , [PRVT: Private] , ...8 more... )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Status , Coded Values: [I: In Service] , [O: Out of Service] , [R: Removed] , ...3 more... )
• Source ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Source , Coded Values: [ATL: Atlas] , [ASB: As Built] , [FVE: Field Verified] , ...14 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Comments )
• Installation ( type: esriFieldTypeString, alias: Installation Type, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Installation , Coded Values: [TOLEDO: Toledo Standard] , [COUNTY: County Style] , [EOLTOL: End of Line] )
• GPSCoordX ( type: esriFieldTypeDouble, alias: GPS X Coordinate, editable: true, nullable: true, defaultValue: null, modelName: GPSCoordX )
• GPSCoordY ( type: esriFieldTypeDouble, alias: GPS Y Coordinate, editable: true, nullable: true, defaultValue: null, modelName: GPSCoordY )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Manufacturer , Coded Values: [AD-B62B: American Darling B62B] , [AD-B84B: American Darling B84B] , [CLOW: Clow] , ...3 more... )
• Height ( type: esriFieldTypeDouble, alias: Height, editable: true, nullable: true, defaultValue: null, modelName: Height , Coded Values: [4: 4] , [5: 5] , [5.5: 5.5] , ...2 more... )
• Color ( type: esriFieldTypeString, alias: Paint Color, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Color , Coded Values: [YEL: Yellow] , [GRN: Green] , [RED: Red] )
• DrainPlug ( type: esriFieldTypeString, alias: Plugged, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DrainPlug , Coded Values: [NO: No] , [YES: Yes] )
• LocChSource ( type: esriFieldTypeString, alias: Location Change Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LocChSource )
• DateLastOper ( type: esriFieldTypeDate, alias: Date Last Operated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateLastOper )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• waterzone ( type: esriFieldTypeString, alias: waterzone, editable: true, nullable: true, length: 20, defaultValue: null, modelName: waterzone )
• NearestAddress ( type: esriFieldTypeString, alias: NearestAddress, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NearestAddress )
• NearestIntersection ( type: esriFieldTypeString, alias: NearestIntersection, editable: true, nullable: true, length: 200, defaultValue: null, modelName: NearestIntersection )
• InspectionDate ( type: esriFieldTypeDate, alias: InspectionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionDate )
• ResidPressure ( type: esriFieldTypeDouble, alias: ResidPressure, editable: true, nullable: true, defaultValue: null, modelName: ResidPressure )
• StaticPressure ( type: esriFieldTypeDouble, alias: StaticPressure, editable: true, nullable: true, defaultValue: null, modelName: StaticPressure )
• ThirtyPSIFlow ( type: esriFieldTypeDouble, alias: ThirtyPSIFlow, editable: true, nullable: true, defaultValue: null, modelName: ThirtyPSIFlow )
• TwentyPSIFlow ( type: esriFieldTypeDouble, alias: TwentyPSIFlow, editable: true, nullable: true, defaultValue: null, modelName: TwentyPSIFlow )
• WO ( type: esriFieldTypeString, alias: WO, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WO )
• OperatedStatus ( type: esriFieldTypeString, alias: Operated Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OperatedStatus , Coded Values: [Operated: Operated] , [Needs Operated: Needs Operated] , [Fix Issue: Fix Issue] )
• DateLastPainted ( type: esriFieldTypeDate, alias: Date Last Painted, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateLastPainted )
• OperatedBy ( type: esriFieldTypeString, alias: OperatedBy, editable: true, nullable: true, length: 100, defaultValue: null, modelName: OperatedBy , Coded Values: [Dawn Hartford: Dawn Hartford] , [Jeff Placzkiewicz: Jeff Placzkiewicz] , [Jerry Thomas: Jerry Thomas] , ...16 more... )

Types:

ID: O
Name: Out of Service
Domains:
• Owner:
  Inherited
• Status:
  Inherited
• Source:
  Inherited
• Installation:
  Inherited
• Manufacturer:
  Inherited
• Height:
  Inherited
• Color:
  Inherited
• DrainPlug:
  Inherited
• OperatedStatus:
  Inherited
• OperatedBy:
  Inherited
Templates:
• Name: Out of Service
  Description:
  Prototype:
  Location: null
  Owner: COT
  DateLastPainted: null
  AssetID: null
  LegacyID: null
  InstallationDate: null
  Status: O
  Source: null
  Comments: null
  Installation: null
  GPSCoordX: null
  GPSCoordY: null
  Manufacturer: null
  Height: null
  Color: null
  DrainPlug: null
  LocChSource: null
  DateLastOper: null
  OperatedStatus: null
  WO: null
  TwentyPSIFlow: null
  ThirtyPSIFlow: null
  OperatedBy: null
  waterzone: null
  NearestAddress: null
  NearestIntersection: null
  InspectionDate: null
  ResidPressure: null
  StaticPressure: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: F
Name: Frozen
Domains:
• Owner:
  Inherited
• Status:
  Inherited
• Source:
  Inherited
• Installation:
  Inherited
• Manufacturer:
  Inherited
• Height:
  Inherited
• Color:
  Inherited
• DrainPlug:
  Inherited
• OperatedStatus:
  Inherited
• OperatedBy:
  Inherited
Templates:
• Name: Frozen
  Description:
  Prototype:
  Location: null
  Owner: COT
  DateLastPainted: null
  AssetID: null
  LegacyID: null
  InstallationDate: null
  Status: F
  Source: null
  Comments: null
  Installation: null
  GPSCoordX: null
  GPSCoordY: null
  Manufacturer: null
  Height: null
  Color: null
  DrainPlug: null
  LocChSource: null
  DateLastOper: null
  OperatedStatus: null
  WO: null
  TwentyPSIFlow: null
  ThirtyPSIFlow: null
  OperatedBy: null
  waterzone: null
  NearestAddress: null
  NearestIntersection: null
  InspectionDate: null
  ResidPressure: null
  StaticPressure: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata