View In:   ArcGIS Online Map Viewer

Name: FireHydrant_currentinspection

Display Field: assettype

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: b48b732e86094dec9ef74b3504321a4c

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -1.8E7
YMin: -1.2E7
XMax: 1.8E7
YMax: 1.6E7
Spatial Reference: 3857  (0)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: assettype
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [255, 255, 255, 255]
Size: 12.75
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Default Label: Other
UniqueValueInfos:
• Value: 0
  Label: Unknown
  Description: N/A
  Symbol:
  
• Value: 321
  Label: Fire Hydrant
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [78, 78, 78, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Tahoma
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 1750.0
Max. Scale: 0.0

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: true
Supports Query With LOD Spatial Reference: true
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: true

HasM: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: assettype

Fields:

• assettype ( nullable: false, editable: true, defaultValue: 0, alias: Asset type, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [321: Fire Hydrant] )
• assetid ( nullable: true, editable: true, defaultValue: null, length: 64, alias: Asset ID, type: esriFieldTypeString )
• diameter ( nullable: true, editable: true, defaultValue: 0, alias: Diameter, type: esriFieldTypeDouble , Coded Values: [0: Unknown] , [4: 4"] , [4.5: 4 1/2"] , ...4 more... )
• secondarydiameter ( nullable: true, editable: true, defaultValue: 0, alias: Nozzle Diameter, type: esriFieldTypeDouble , Coded Values: [0: Unknown] , [2.5: 2 1/2"] , [4.5: 4 1/2"] , ...4 more... )
• manufacturer ( nullable: true, editable: true, defaultValue: null, description: {"fieldValueType":"typeOrCategory","value":""}, type: esriFieldTypeSmallInteger, alias: Manufacturer , Coded Values: [0: Unknown] , [60: American Darling] , [61: Clow Corporation] , ...12 more... )
• model ( nullable: true, editable: true, defaultValue: null, alias: Model, type: esriFieldTypeInteger )
• installdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Install Date, type: esriFieldTypeDate )
• lifecyclestatus ( nullable: false, editable: true, defaultValue: 8, alias: Lifecycle Status, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: Proposed] , [2: Approved] , ...7 more... )
• inservicedate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: In-Service Date, type: esriFieldTypeDate )
• retireddate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Retired Date, type: esriFieldTypeDate )
• notes ( nullable: true, editable: true, defaultValue: null, length: 2000, alias: Notes, type: esriFieldTypeString )
• lastmaint ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Last Maintenance, type: esriFieldTypeDate )
• ownedby ( nullable: true, editable: true, defaultValue: 1, alias: Owned By, type: esriFieldTypeSmallInteger , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• maintby ( nullable: true, editable: true, defaultValue: 1, alias: Maintained By, type: esriFieldTypeSmallInteger , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• spatialsource ( nullable: true, editable: true, defaultValue: 0, alias: Spatial Source, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: As-Built] , [2: CAD] , ...3 more... )
• spatialconfidence ( nullable: true, editable: true, defaultValue: 0, alias: Spatial Confidence, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: High] , [2: Medium] , ...1 more... )
• symbolrotation ( nullable: true, editable: true, defaultValue: null, alias: Symbol Rotation, type: esriFieldTypeSmallInteger , Range: [0, 359] )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: Global ID )
• created_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Creation date, type: esriFieldTypeDate )
• created_user ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Creator, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Last update, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Updated by, type: esriFieldTypeString )
• esrignss_positionsourcetype ( nullable: true, editable: true, defaultValue: null, alias: Position source type, type: esriFieldTypeSmallInteger , Coded Values: [0: Unknown] , [1: User defined] , [2: Integrated (System) Location Provider] , ...2 more... )
• esrignss_receiver ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Receiver Name, type: esriFieldTypeString )
• esrignss_latitude ( nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• esrignss_longitude ( nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• esrignss_altitude ( nullable: true, editable: true, defaultValue: null, alias: Altitude, type: esriFieldTypeDouble )
• esrignss_h_rms ( nullable: true, editable: true, defaultValue: null, alias: Horizontal Accuracy (m), type: esriFieldTypeDouble )
• esrignss_v_rms ( nullable: true, editable: true, defaultValue: null, alias: Vertical Accuracy (m), type: esriFieldTypeDouble )
• esrignss_fixdatetime ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Fix Time, type: esriFieldTypeDate )
• esrignss_fixtype ( nullable: true, editable: true, defaultValue: null, alias: Fix Type, type: esriFieldTypeSmallInteger , Coded Values: [0: Fix not valid] , [1: GPS] , [2: Differential GPS] , ...2 more... )
• esrignss_correctionage ( nullable: true, editable: true, defaultValue: null, alias: Correction Age, type: esriFieldTypeDouble )
• esrignss_stationid ( nullable: true, editable: true, defaultValue: null, alias: Station ID, type: esriFieldTypeSmallInteger , Range: [0, 1023] )
• esrignss_numsats ( nullable: true, editable: true, defaultValue: null, alias: Number of Satellites, type: esriFieldTypeSmallInteger , Range: [0, 99] )
• esrignss_pdop ( nullable: true, editable: true, defaultValue: null, alias: PDOP, type: esriFieldTypeDouble )
• esrignss_hdop ( nullable: true, editable: true, defaultValue: null, alias: HDOP, type: esriFieldTypeDouble )
• esrignss_vdop ( nullable: true, editable: true, defaultValue: null, alias: VDOP, type: esriFieldTypeDouble )
• esrignss_direction ( nullable: true, editable: true, defaultValue: null, alias: Direction of travel (°), type: esriFieldTypeDouble )
• esrignss_speed ( nullable: true, editable: true, defaultValue: null, alias: Speed (km/h), type: esriFieldTypeDouble )
• esrisnsr_azimuth ( nullable: true, editable: true, defaultValue: null, alias: Compass reading (°), type: esriFieldTypeDouble )
• esrignss_avg_h_rms ( nullable: true, editable: true, defaultValue: null, alias: Average Horizontal Accuracy (m), type: esriFieldTypeDouble )
• esrignss_avg_v_rms ( nullable: true, editable: true, defaultValue: null, alias: Average Vertical Accuracy (m), type: esriFieldTypeDouble )
• esrignss_avg_positions ( nullable: true, editable: true, defaultValue: null, alias: Averaged Positions, type: esriFieldTypeSmallInteger )
• esrignss_h_stddev ( nullable: true, editable: true, defaultValue: null, alias: Standard Deviation (m), type: esriFieldTypeDouble )
• assignmenttype ( nullable: true, editable: true, defaultValue: null, alias: Assignment Type, type: esriFieldTypeInteger , Coded Values: [3: Flow Test] , [2: Flush] )
• assignmentdue ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Assignment Due, type: esriFieldTypeDate )
• assignedon ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Assigned On, type: esriFieldTypeDate )
• station ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Assigned Station, type: esriFieldTypeString )
• shift ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Assigned Shift, type: esriFieldTypeString )
• adoptionstatus ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Adoption Status, type: esriFieldTypeString , Coded Values: [Available: Available] , [Adopted: Adopted] )
• nickname ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Nickname, type: esriFieldTypeString )
• publicview ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Public View, type: esriFieldTypeString , Coded Values: [1: Yes] , [2: No] )
• adoptedby ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Adopted By, type: esriFieldTypeString )
• adoptedon ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Adopted On, type: esriFieldTypeDate )
• maintstatus ( nullable: true, editable: true, defaultValue: null, alias: Maintenance Status, type: esriFieldTypeInteger , Coded Values: [1: Submitted] , [2: Acknowledged] , [3: Planned] , ...3 more... )
• inspector ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Inspector, type: esriFieldTypeString )
• insdate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Inspection Date, type: esriFieldTypeDate )
• chains ( nullable: true, editable: true, defaultValue: null, alias: Are chains missing?, type: esriFieldTypeSmallInteger , Coded Values: [0: No] , [1: Yes] )
• paint ( nullable: true, editable: true, defaultValue: null, alias: Needs to be painted?, type: esriFieldTypeSmallInteger , Coded Values: [0: No] , [1: Yes] )
• marker ( nullable: true, editable: true, defaultValue: null, alias: Needs marker?, type: esriFieldTypeSmallInteger , Coded Values: [0: No] , [1: Yes] )
• oil ( nullable: true, editable: true, defaultValue: null, alias: Needs lubrication?, type: esriFieldTypeSmallInteger , Coded Values: [0: No] , [1: Yes] )
• greased ( nullable: true, editable: true, defaultValue: null, alias: Needs grease?, type: esriFieldTypeSmallInteger , Coded Values: [0: No] , [1: Yes] )
• drain ( nullable: true, editable: true, defaultValue: null, alias: Drains correctly?, type: esriFieldTypeSmallInteger , Coded Values: [0: No] , [1: Yes] )
• notes_1684787360669 ( nullable: true, editable: true, defaultValue: null, length: 2000, alias: Notes, type: esriFieldTypeString )
• pressure ( nullable: true, editable: true, defaultValue: null, alias: Pressure, type: esriFieldTypeDouble )
• flowrate ( nullable: true, editable: true, defaultValue: null, alias: Flow Rate, type: esriFieldTypeDouble )
• flowduration ( nullable: true, editable: true, defaultValue: null, alias: Flow Duration, type: esriFieldTypeDouble )
• assetguid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: Asset GlobalID, type: esriFieldTypeGUID )
• globalid_1684787360669 ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• creator_1684787360669 ( nullable: true, editable: false, defaultValue: null, length: 255, alias: Creator, type: esriFieldTypeString )
• creationdate_1684787360669 ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: Creation date, type: esriFieldTypeDate )
• updatedby_1684787360669 ( nullable: true, editable: false, defaultValue: null, length: 255, alias: Updated by, type: esriFieldTypeString )
• lastupdate_1684787360669 ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: Last update, type: esriFieldTypeDate )
• leaking ( nullable: true, editable: true, defaultValue: null, alias: Is the hydrant leaking?, type: esriFieldTypeInteger , Coded Values: [0: No] , [1: Yes] )
• operable ( nullable: true, editable: true, defaultValue: null, alias: Is the hydrant operable?, type: esriFieldTypeInteger , Coded Values: [0: No] , [1: Yes] )
• inspgroup ( nullable: true, editable: true, defaultValue: null, length: 75, alias: Inspection Group, type: esriFieldTypeString , Coded Values: [0: Water Company] , [1: Fire Department] , [2: Contractor] )
• firestation ( nullable: true, editable: true, defaultValue: null, length: 75, alias: Station Completing Inspection, type: esriFieldTypeString , Coded Values: [1: Station 1] , [2: Station 2] , [3: Station 3] , ...7 more... )
• totalused ( nullable: true, editable: true, defaultValue: null, alias: Total Water Used, type: esriFieldTypeDouble )
• inspectiontype ( nullable: true, editable: true, defaultValue: null, alias: Inspection Type, type: esriFieldTypeInteger , Coded Values: [3: Flow Test] , [2: Flush] )
• dischargecoe ( nullable: true, editable: true, defaultValue: null, alias: Discharge Coefficient, type: esriFieldTypeDouble )
• outletdiameter ( nullable: true, editable: true, defaultValue: null, alias: Outlet Diameter, type: esriFieldTypeDouble )
• discharge ( nullable: true, editable: true, defaultValue: null, alias: Available Fire Flow, type: esriFieldTypeDouble )
• staticpressure ( nullable: true, editable: true, defaultValue: null, alias: Static Pressure, type: esriFieldTypeDouble )
• residualpressure ( nullable: true, editable: true, defaultValue: null, alias: Residual Pressure, type: esriFieldTypeInteger )
• flush ( nullable: true, editable: true, defaultValue: null, alias: Flush, type: esriFieldTypeInteger , Coded Values: [1: Yes] , [2: No] )
• pitotpressure ( nullable: true, editable: true, defaultValue: null, alias: Pitot Pressure, type: esriFieldTypeDouble )
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: Object ID )

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata