Layers:

Tables:

Hydrant Table (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:

Name : OBJECTID

IsSystemMaintained : True


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:

Name: Hydrant Table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:


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