Layer: Hydrant Table (ID:3)

Name: Hydrant Table

Display Field: F_unique_id

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
General (type: esriFieldTypeString, alias: General, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
F_address (type: esriFieldTypeString, alias: _address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
F_unique_id (type: esriFieldTypeString, alias: _unique_id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
F_latitude (type: esriFieldTypeDouble, alias: _latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
F_longitude (type: esriFieldTypeDouble, alias: _longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
F_assigned_by (type: esriFieldTypeString, alias: _assigned_by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
F_assigned_to (type: esriFieldTypeString, alias: _assigned_to, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
F_created_at (type: esriFieldTypeString, alias: _created_at, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
F_notes (type: esriFieldTypeString, alias: _notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
F_elevation (type: esriFieldTypeDouble, alias: _elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
F_last_saved_date (type: esriFieldTypeDate, alias: _last_saved_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
F_record_date (type: esriFieldTypeDate, alias: _record_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
F_resolution (type: esriFieldTypeDouble, alias: _resolution, SQL Type: sqlTypeOther, nullable: true, editable: true)
F_schedule_from (type: esriFieldTypeDate, alias: _schedule_from, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
F_schedule_to (type: esriFieldTypeDate, alias: _schedule_to, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
F_status (type: esriFieldTypeString, alias: _status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
F_priority (type: esriFieldTypeString, alias: _priority, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
F_task (type: esriFieldTypeString, alias: _task, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
HydrantID (type: esriFieldTypeString, alias: ValveID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
OperationalStatus (type: esriFieldTypeString, alias: OperationalStatus, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
BarrelType (type: esriFieldTypeString, alias: BarrelType, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
BarrelSize (type: esriFieldTypeString, alias: BarrelSize, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
IsoValve (type: esriFieldTypeString, alias: IsoValve, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Num2Ports (type: esriFieldTypeSmallInteger, alias: Num2Ports, SQL Type: sqlTypeOther, nullable: true, editable: true)
Num4Ports (type: esriFieldTypeSmallInteger, alias: Num4Ports, SQL Type: sqlTypeOther, nullable: true, editable: true)
Model (type: esriFieldTypeString, alias: Model, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ModelYear (type: esriFieldTypeSmallInteger, alias: ModelYear, SQL Type: sqlTypeOther, nullable: true, editable: true)
LastExercisedDate (type: esriFieldTypeDate, alias: LastExercisedDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LastPaintedDate (type: esriFieldTypeDate, alias: LastPaintedDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
StaticPSI (type: esriFieldTypeInteger, alias: StaticPSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
ResidualPSI (type: esriFieldTypeInteger, alias: ResidualPSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
PitotPSI (type: esriFieldTypeInteger, alias: PitotPSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
FlowMinute (type: esriFieldTypeString, alias: FlowMinute, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
FlowGPM (type: esriFieldTypeInteger, alias: FlowGPM, SQL Type: sqlTypeOther, nullable: true, editable: true)
FlowBase (type: esriFieldTypeString, alias: FlowBase, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GallonsUsed (type: esriFieldTypeSmallInteger, alias: GallonsUsed, SQL Type: sqlTypeOther, nullable: true, editable: true)
F_comment (type: esriFieldTypeString, alias: _comment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
OWNER (type: esriFieldTypeString, alias: OWNER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
PortDiameter (type: esriFieldTypeDouble, alias: PortDiameter, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/19/2024 5:14:15 PM

Schema Last Edit Date: 8/18/2023 8:13:30 PM

Data Last Edit Date: 11/19/2024 5:14:15 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Add Features Update Features Delete Features Apply Edits Calculate Generate Renderer Validate SQL Get Estimates ConvertFormat