View In:   ArcGIS Online Map Viewer

Name: Water Hydrant

Display Field: Active

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Combination of "wHydrant2011", "wHydrantUTIL", and "whydrant" feature classes from gisdata server as well as "wHydrant"modified on 10/9/2012 to include data pulled from an access database table named "tblHydrantFlowTests" which was located on the :T drive of the 10.1.14.49 server.

Service Item Id: e1592cb43ef34972b19fc551b1493ae3

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000

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: 812852.3982939646
YMin: 626334.1325459331
XMax: 892206.094160106
YMax: 682173.6059711277
Spatial Reference: 102990  (6407)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: FieldColor
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label:
UniqueValueInfos:
• Value:
  Label:
  Description:
  Symbol:
  
• Value: Blue
  Label: Blue
  Description: Blue
  Symbol:
  
• Value: Green
  Label: Green
  Description: Green
  Symbol:
  
• Value: Orange
  Label: Orange
  Description: Orange
  Symbol:
  
• Value: Red
  Label: Red
  Description: Red
  Symbol:
  
• Value: Unknown
  Label: Unknown
  Description: Unknown
  Symbol:
  
• Value: White
  Label: White
  Description: White
  Symbol:
  
• Value: Yellow
  Label: Yellow
  Description: Yellow
  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: FieldColor

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID_1, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID_1 )
• Active ( type: esriFieldTypeString, alias: Active, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Active )
• InstallDat ( type: esriFieldTypeDate, alias: InstallDat, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallDat )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
• Supplier ( type: esriFieldTypeString, alias: Supplier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Supplier )
• FieldColor ( type: esriFieldTypeString, alias: FieldColor, editable: true, nullable: true, length: 12, defaultValue: null, modelName: FieldColor )
• ValveVisib ( type: esriFieldTypeString, alias: ValveVisib, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ValveVisib )
• FeederDiam ( type: esriFieldTypeString, alias: FeederDiam, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FeederDiam )
• BarrelDiam ( type: esriFieldTypeString, alias: BarrelDiam, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BarrelDiam )
• GPS_Qualit ( type: esriFieldTypeString, alias: GPS_Qualit, editable: true, nullable: true, length: 24, defaultValue: null, modelName: GPS_Qualit )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Editor )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• LegacyID ( type: esriFieldTypeDouble, alias: LegacyID, editable: true, nullable: true, defaultValue: null, modelName: LegacyID )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Notes )
• testDate ( type: esriFieldTypeDate, alias: testDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: testDate )
• staticPSI ( type: esriFieldTypeDouble, alias: staticPSI, editable: true, nullable: true, defaultValue: null, modelName: staticPSI )
• residualPS ( type: esriFieldTypeDouble, alias: residualPS, editable: true, nullable: true, defaultValue: null, modelName: residualPS )
• pitot ( type: esriFieldTypeDouble, alias: pitot, editable: true, nullable: true, defaultValue: null, modelName: pitot )
• flowGPM ( type: esriFieldTypeDouble, alias: flowGPM, editable: true, nullable: true, defaultValue: null, modelName: flowGPM )
• testLength ( type: esriFieldTypeDouble, alias: testLength, editable: true, nullable: true, defaultValue: null, modelName: testLength )
• waterUse ( type: esriFieldTypeDouble, alias: waterUse, editable: true, nullable: true, defaultValue: null, modelName: waterUse )
• northing ( type: esriFieldTypeDouble, alias: northing, editable: true, nullable: true, defaultValue: null, modelName: northing )
• easting ( type: esriFieldTypeDouble, alias: easting, editable: true, nullable: true, defaultValue: null, modelName: easting )
• 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 )
• CityworksID ( type: esriFieldTypeString, alias: CityworksID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CityworksID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Asset_ID ( type: esriFieldTypeString, alias: Asset_ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Asset_ID )

Types:

ID:
Name:
Domains:
Templates:
• Name:
  Description:
  Prototype:
  Asset_ID: null
  CityworksID: null
  Active: null
  InstallDat: null
  FacilityID: null
  Supplier: null
  FieldColor:
  ValveVisib: null
  FeederDiam: null
  BarrelDiam: null
  GPS_Qualit: null
  Editor: null
  EditDate: null
  LegacyID: null
  Notes: null
  testDate: null
  staticPSI: null
  residualPS: null
  pitot: null
  flowGPM: null
  testLength: null
  waterUse: null
  northing: null
  easting: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Blue
Name: Blue
Domains:
Templates:
• Name: Blue
  Description:
  Prototype:
  Asset_ID: null
  CityworksID: null
  Active: null
  InstallDat: null
  FacilityID: null
  Supplier: null
  FieldColor: Blue
  ValveVisib: null
  FeederDiam: null
  BarrelDiam: null
  GPS_Qualit: null
  Editor: null
  EditDate: null
  LegacyID: null
  Notes: null
  testDate: null
  staticPSI: null
  residualPS: null
  pitot: null
  flowGPM: null
  testLength: null
  waterUse: null
  northing: null
  easting: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Green
Name: Green
Domains:
Templates:
• Name: Green
  Description:
  Prototype:
  Asset_ID: null
  CityworksID: null
  Active: null
  InstallDat: null
  FacilityID: null
  Supplier: null
  FieldColor: Green
  ValveVisib: null
  FeederDiam: null
  BarrelDiam: null
  GPS_Qualit: null
  Editor: null
  EditDate: null
  LegacyID: null
  Notes: null
  testDate: null
  staticPSI: null
  residualPS: null
  pitot: null
  flowGPM: null
  testLength: null
  waterUse: null
  northing: null
  easting: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Orange
Name: Orange
Domains:
Templates:
• Name: Orange
  Description:
  Prototype:
  Asset_ID: null
  CityworksID: null
  Active: null
  InstallDat: null
  FacilityID: null
  Supplier: null
  FieldColor: Orange
  ValveVisib: null
  FeederDiam: null
  BarrelDiam: null
  GPS_Qualit: null
  Editor: null
  EditDate: null
  LegacyID: null
  Notes: null
  testDate: null
  staticPSI: null
  residualPS: null
  pitot: null
  flowGPM: null
  testLength: null
  waterUse: null
  northing: null
  easting: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Red
Name: Red
Domains:
Templates:
• Name: Red
  Description:
  Prototype:
  Asset_ID: null
  CityworksID: null
  Active: null
  InstallDat: null
  FacilityID: null
  Supplier: null
  FieldColor: Red
  ValveVisib: null
  FeederDiam: null
  BarrelDiam: null
  GPS_Qualit: null
  Editor: null
  EditDate: null
  LegacyID: null
  Notes: null
  testDate: null
  staticPSI: null
  residualPS: null
  pitot: null
  flowGPM: null
  testLength: null
  waterUse: null
  northing: null
  easting: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Unknown
Name: Unknown
Domains:
Templates:
• Name: Unknown
  Description:
  Prototype:
  Asset_ID: null
  CityworksID: null
  Active: null
  InstallDat: null
  FacilityID: null
  Supplier: null
  FieldColor: Unknown
  ValveVisib: null
  FeederDiam: null
  BarrelDiam: null
  GPS_Qualit: null
  Editor: null
  EditDate: null
  LegacyID: null
  Notes: null
  testDate: null
  staticPSI: null
  residualPS: null
  pitot: null
  flowGPM: null
  testLength: null
  waterUse: null
  northing: null
  easting: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: White
Name: White
Domains:
Templates:
• Name: White
  Description:
  Prototype:
  Asset_ID: null
  CityworksID: null
  Active: null
  InstallDat: null
  FacilityID: null
  Supplier: null
  FieldColor: White
  ValveVisib: null
  FeederDiam: null
  BarrelDiam: null
  GPS_Qualit: null
  Editor: null
  EditDate: null
  LegacyID: null
  Notes: null
  testDate: null
  staticPSI: null
  residualPS: null
  pitot: null
  flowGPM: null
  testLength: null
  waterUse: null
  northing: null
  easting: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Yellow
Name: Yellow
Domains:
Templates:
• Name: Yellow
  Description:
  Prototype:
  Asset_ID: null
  CityworksID: null
  Active: null
  InstallDat: null
  FacilityID: null
  Supplier: null
  FieldColor: Yellow
  ValveVisib: null
  FeederDiam: null
  BarrelDiam: null
  GPS_Qualit: null
  Editor: null
  EditDate: null
  LegacyID: null
  Notes: null
  testDate: null
  staticPSI: null
  residualPS: null
  pitot: null
  flowGPM: null
  testLength: null
  waterUse: null
  northing: null
  easting: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing,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: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

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