View In:   ArcGIS Online Map Viewer

Name: GIS.DBO.wHydrant

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

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: 2828049.883401215
YMin: 1635078.8277359009
XMax: 2841618.8480611444
YMax: 1675514.1720618904
Spatial Reference: 102654  (2232)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Operable_
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label:
UniqueValueInfos:
• Value: Yes
  Label: Yes
  Description: N/A
  Symbol:
  
• Value: No
  Label: No
  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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Operable_

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MANUFACTURER , Coded Values: [American Darling: American Darling] , [Clow Corporation: Clow Corporation] , [Corey: Corey] , ...13 more... )
• LASTSERVICE ( type: esriFieldTypeDate, alias: Last Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTSERVICE )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: null, modelName: OWNEDBY , Coded Values: [-1: Private] , [-2: Other] , [1: TOS] )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: null, modelName: MAINTBY , Coded Values: [-1: Private] , [-2: Other] , [1: TOS] )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• FLOW ( type: esriFieldTypeDouble, alias: Flow Rate (GPM), editable: true, nullable: true, defaultValue: null, modelName: FLOW )
• DATASOURCE ( type: esriFieldTypeString, alias: Data Source, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DATASOURCE , Coded Values: [Aerial Imagery: Aerial Imagery] , [As-Builts/Construction Drawings: As-Builts/Construction Drawings] , [CAD: CAD] , ...4 more... )
• GPSACCURACY ( type: esriFieldTypeString, alias: GPS Accuracy, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GPSACCURACY )
• FIELDNOTES ( type: esriFieldTypeString, alias: Field Notes, editable: true, nullable: true, length: 150, defaultValue: null, modelName: FIELDNOTES )
• CREATEDATE ( type: esriFieldTypeDate, alias: Date Created, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATEDATE )
• CREATEUSER ( type: esriFieldTypeString, alias: Created By, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CREATEUSER )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• ServiceValveLocation ( type: esriFieldTypeString, alias: Service Valve Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ServiceValveLocation )
• HydrantID ( type: esriFieldTypeString, alias: HydrantID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HydrantID )
• Operable_ ( type: esriFieldTypeString, alias: Operable_, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Operable_ , Coded Values: [Yes: Yes] , [No: No] )
• Attention_Comment ( type: esriFieldTypeString, alias: Attention_Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Attention_Comment )

Types:

ID: Yes
Name: Yes
Domains:
• MANUFACTURER:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• DATASOURCE:
  Inherited
• Operable_:
  Inherited
Templates:
• Name: Yes
  Description:
  Prototype:
  Operable_: Yes
  HydrantID: null
  FACILITYID: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  MANUFACTURER: null
  LASTSERVICE: null
  OWNEDBY: null
  MAINTBY: null
  LASTUPDATE: null
  LASTEDITOR: null
  FLOW: null
  DATASOURCE: null
  GPSACCURACY: null
  FIELDNOTES: null
  CREATEDATE: null
  CREATEUSER: null
  Attention_Comment: null
  ServiceValveLocation: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: No
Name: No
Domains:
• MANUFACTURER:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• DATASOURCE:
  Inherited
• Operable_:
  Inherited
Templates:
• Name: No
  Description:
  Prototype:
  Operable_: No
  HydrantID: null
  FACILITYID: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  MANUFACTURER: null
  LASTSERVICE: null
  OWNEDBY: null
  MAINTBY: null
  LASTUPDATE: null
  LASTEDITOR: null
  FLOW: null
  DATASOURCE: null
  GPSACCURACY: null
  FIELDNOTES: null
  CREATEDATE: null
  CREATEUSER: null
  Attention_Comment: null
  ServiceValveLocation: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• HydrantInspection (0) -- Related To: GIS.DBO.HydrantInspection (12)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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