Name: RWIS_HistoricData

Display Field: stationname

Type: Table

Geometry Type: N/A

Description:

Service Item Id: ce580fcf474d42cd89bd30e7d6e83652

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

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: false
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: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( modelName: OBJECTID, nullable: false, defaultValue: null, editable: false, alias: OBJECTID, type: esriFieldTypeOID )
• stationid ( modelName: StationID, nullable: true, editable: true, defaultValue: null, alias: Station ID, type: esriFieldTypeInteger )
• stationname ( modelName: StationName, nullable: true, editable: true, defaultValue: null, length: 30, alias: Station Name, type: esriFieldTypeString )
• sensorvaluedatetimeutc ( modelName: SensorValueDateTimeUTC, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Sensor Value Date-Time (UTC), type: esriFieldTypeDate )
• sensorvaluedatetimeutcoffset ( modelName: SensorValueDateTimeUTCOffset, nullable: true, editable: true, defaultValue: null, length: 6, alias: Sensor Value Date-Time UTC Offset, type: esriFieldTypeString )
• sensorvaluedatetimelocal ( modelName: SensorValueDateTimeLocal, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Sensor Value Date-Time (Local), type: esriFieldTypeDate )
• sensorvaluedatetimelocalzone ( modelName: SensorValueDateTimeLocalZone, nullable: true, editable: true, defaultValue: null, length: 3, alias: Sensor Value Date-Time Local Timezone, type: esriFieldTypeString )
• generalstatuscode ( modelName: GeneralStatusCode, nullable: true, editable: true, defaultValue: null, alias: General Status Code, type: esriFieldTypeInteger )
• generalstatusdesc ( modelName: GeneralStatusDesc, nullable: true, editable: true, defaultValue: null, length: 11, alias: General Status Description, type: esriFieldTypeString )
• airtempf ( modelName: AirTempF, nullable: true, editable: true, defaultValue: null, alias: Air Temperature (F), type: esriFieldTypeDouble )
• airtempc ( modelName: AirTempC, nullable: true, editable: true, defaultValue: null, alias: Air Temperature (C), type: esriFieldTypeDouble )
• dewtempf ( modelName: DewTempF, nullable: true, editable: true, defaultValue: null, alias: Dew Temperature (F), type: esriFieldTypeDouble )
• dewtempc ( modelName: DewTempC, nullable: true, editable: true, defaultValue: null, alias: Dew Temperature (C), type: esriFieldTypeDouble )
• basetempf ( modelName: BaseTempF, nullable: true, editable: true, defaultValue: null, alias: Base Temperature (F), type: esriFieldTypeDouble )
• basetempc ( modelName: BaseTempC, nullable: true, editable: true, defaultValue: null, alias: Base Temperature (C), type: esriFieldTypeDouble )
• pressureinhg ( modelName: PressureINHg, nullable: true, editable: true, defaultValue: null, alias: Pressure (IN Hg), type: esriFieldTypeDouble )
• relativehumidity ( modelName: RelativeHumidity, nullable: true, editable: true, defaultValue: null, alias: Relative Humidity (%), type: esriFieldTypeDouble )
• icelayer1in ( modelName: IceLayer1IN, nullable: true, editable: true, defaultValue: null, alias: Ice Layer 1 (Inch), type: esriFieldTypeDouble )
• icelayer2in ( modelName: IceLayer2IN, nullable: true, editable: true, defaultValue: null, alias: Ice Layer 2 (Inch), type: esriFieldTypeDouble )
• griplevelpercent1 ( modelName: GripLevelPercent1, nullable: true, editable: true, defaultValue: null, alias: Grip Level Percentage (1), type: esriFieldTypeDouble )
• griplevelpercent2 ( modelName: GripLevelPercent2, nullable: true, editable: true, defaultValue: null, alias: Grip Level Percentage (2), type: esriFieldTypeDouble )
• presentweathercode ( modelName: PresentWeatherCode, nullable: true, editable: true, defaultValue: null, alias: Present Weather Code, type: esriFieldTypeInteger )
• presentweatherdesc ( modelName: PresentWeatherDesc, nullable: true, editable: true, defaultValue: null, length: 150, alias: Present Weather Description, type: esriFieldTypeString )
• rainpresentcode ( modelName: RainPresentCode, nullable: true, editable: true, defaultValue: null, alias: Rain Present Code, type: esriFieldTypeInteger )
• rainpresentdesc ( modelName: RainPresentDesc, nullable: true, editable: true, defaultValue: null, length: 20, alias: Rain Present Description, type: esriFieldTypeString )
• rainintensityin_hr ( modelName: RainIntensityIN_HR, nullable: true, editable: true, defaultValue: null, alias: Rain Intensity (Inches/Hour), type: esriFieldTypeDouble )
• rainstatecode ( modelName: RainStateCode, nullable: true, editable: true, defaultValue: null, alias: Rain State Code, type: esriFieldTypeInteger )
• rainstatedesc ( modelName: RainStateDesc, nullable: true, editable: true, defaultValue: null, length: 40, alias: Rain State Description, type: esriFieldTypeString )
• eventpreciptotalin ( modelName: EventPrecipTotalIN, nullable: true, editable: true, defaultValue: null, alias: Event Precipitation Total (Inches), type: esriFieldTypeDouble )
• preciptotalin_1hr ( modelName: PrecipTotalIN_1HR, nullable: true, editable: true, defaultValue: null, alias: Precipitation Total Last 1 Hour (Inches), type: esriFieldTypeDouble )
• preciptotalin_3hr ( modelName: PrecipTotalIN_3HR, nullable: true, editable: true, defaultValue: null, alias: Precipitation Total Last 3 Hours (Inches), type: esriFieldTypeDouble )
• preciptotalin_6hr ( modelName: PrecipTotalIN_6HR, nullable: true, editable: true, defaultValue: null, alias: Precipitation Total Last 6 Hours (Inches), type: esriFieldTypeDouble )
• preciptotalin_12hr ( modelName: PrecipTotalIN_12HR, nullable: true, editable: true, defaultValue: null, alias: Precipitation Total Last 12 Hours (Inches), type: esriFieldTypeDouble )
• preciptotalin_24hr ( modelName: PrecipTotalIN_24HR, nullable: true, editable: true, defaultValue: null, alias: Precipitation Total Last 24 Hours (Inches), type: esriFieldTypeDouble )
• snowheightin ( modelName: SnowHeightIN, nullable: true, editable: true, defaultValue: null, alias: Snow Height Off Roadway (Inches), type: esriFieldTypeDouble )
• snowlayerin1 ( modelName: SnowLayerIN1, nullable: true, editable: true, defaultValue: null, alias: Snow Layer 1 (Inch), type: esriFieldTypeDouble )
• snowlayerin2 ( modelName: SnowLayerIN2, nullable: true, editable: true, defaultValue: null, alias: Snow Layer 2 (Inch), type: esriFieldTypeDouble )
• surfacetempf ( modelName: SurfaceTempF, nullable: true, editable: true, defaultValue: null, alias: Surface Temperature (F), type: esriFieldTypeDouble )
• surfacetempc ( modelName: SurfaceTempC, nullable: true, editable: true, defaultValue: null, alias: Surface Temperature (C), type: esriFieldTypeDouble )
• surfacestatecode1 ( modelName: SurfaceStateCode1, nullable: true, editable: true, defaultValue: null, alias: Surface State Code (1), type: esriFieldTypeInteger )
• surfacestatedesc1 ( modelName: SurfaceStateDesc1, nullable: true, editable: true, defaultValue: null, length: 40, alias: Surface State Description (1), type: esriFieldTypeString )
• surfacestatecode2 ( modelName: SurfaceStateCode2, nullable: true, editable: true, defaultValue: null, alias: Surface State Code (2), type: esriFieldTypeInteger )
• surfacestatedesc2 ( modelName: SurfaceStateDesc2, nullable: true, editable: true, defaultValue: null, length: 40, alias: Surface State Description (2), type: esriFieldTypeString )
• surfacefriction ( modelName: SurfaceFriction, nullable: true, editable: true, defaultValue: null, length: 20, alias: Surface Friction, type: esriFieldTypeString )
• subsurfacetempf ( modelName: SubSurfaceTempF, nullable: true, editable: true, defaultValue: null, alias: Sub-Surface Temp (F), type: esriFieldTypeDouble )
• visibilitymile ( modelName: VisibilityMile, nullable: true, editable: true, defaultValue: null, alias: Visibility (Miles), type: esriFieldTypeDouble )
• winddirectiondeg ( modelName: WindDirectionDeg, nullable: true, editable: true, defaultValue: null, alias: Wind Direction Degree (Average), type: esriFieldTypeDouble )
• maxwinddirectiondeg ( modelName: MaxWindDirectionDeg, nullable: true, editable: true, defaultValue: null, alias: Wind Direction Degree (Gust), type: esriFieldTypeDouble )
• windspeedmph ( modelName: WindSpeedMPH, nullable: true, editable: true, defaultValue: null, alias: Average Wind Speed (MPH), type: esriFieldTypeDouble )
• maxwindspeedmph ( modelName: MaxWindSpeedMPH, nullable: true, editable: true, defaultValue: null, alias: Wind Speed (Gust) (MPH), type: esriFieldTypeDouble )
• cloudstatuscode ( modelName: CloudStatusCode, nullable: true, editable: true, defaultValue: null, alias: Cloud Status Code, type: esriFieldTypeInteger )
• cloudstatusdesc ( modelName: CloudStatusDesc, nullable: true, editable: true, defaultValue: null, length: 25, alias: Cloud Status Description, type: esriFieldTypeString )
• waterlayerin1 ( modelName: WaterLayerIN1, nullable: true, editable: true, defaultValue: null, alias: Water Layer (Inches) (1), type: esriFieldTypeDouble )
• waterlayerin2 ( modelName: WaterLayerIN2, nullable: true, editable: true, defaultValue: null, alias: Water Layer (Inches) (2), type: esriFieldTypeDouble )
• waterthicknessin ( modelName: WaterThicknessIN, nullable: true, editable: true, defaultValue: null, alias: Water Thickness (Inches), type: esriFieldTypeDouble )
• imageurl_1 ( modelName: ImageURL_1, nullable: true, editable: true, defaultValue: null, length: 254, alias: RWIS Image Camera 1, type: esriFieldTypeString )
• imageposition_1 ( modelName: ImagePosition_1, nullable: true, editable: true, defaultValue: null, length: 20, alias: RWIS Image Camera 1 Position, type: esriFieldTypeString )
• imageurl_2 ( modelName: ImageURL_2, nullable: true, editable: true, defaultValue: null, length: 254, alias: RWIS Image Camera 2, type: esriFieldTypeString )
• imageposition_2 ( modelName: ImagePosition_2, nullable: true, editable: true, defaultValue: null, length: 20, alias: RWIS Image Camera 2 Position, type: esriFieldTypeString )
• imageurl_3 ( modelName: ImageURL_3, nullable: true, editable: true, defaultValue: null, length: 254, alias: RWIS Image Camera 3, type: esriFieldTypeString )
• imageposition_3 ( modelName: ImagePosition_3, nullable: true, editable: true, defaultValue: null, length: 20, alias: RWIS Image Camera 3 Position, type: esriFieldTypeString )
• imageurl_4 ( modelName: ImageURL_4, nullable: true, editable: true, defaultValue: null, length: 254, alias: RWIS Image Camera 4, type: esriFieldTypeString )
• imageposition_4 ( modelName: ImagePosition_4, nullable: true, editable: true, defaultValue: null, length: 20, alias: RWIS Image Camera 4 Position, type: esriFieldTypeString )
• imageurl_5 ( modelName: ImageURL_5, nullable: true, editable: true, defaultValue: null, length: 254, alias: RWIS Image Camera 5, type: esriFieldTypeString )
• imageposition_5 ( modelName: ImagePosition_5, nullable: true, editable: true, defaultValue: null, length: 20, alias: RWIS Image Camera 5 Position, type: esriFieldTypeString )
• alarmstatuscode1 ( modelName: AlarmStatusCode1, nullable: true, editable: true, defaultValue: null, alias: Alarm Status Code (1), type: esriFieldTypeInteger )
• alarmstatusdesc1 ( modelName: AlarmStatusDesc1, nullable: true, editable: true, defaultValue: null, length: 15, alias: Alarm Status Description (1), type: esriFieldTypeString )
• alarmstatuscode2 ( modelName: AlarmStatusCode2, nullable: true, editable: true, defaultValue: null, alias: Alarm Status Code (2), type: esriFieldTypeInteger )
• alarmstatusdesc2 ( modelName: AlarmStatusDesc2, nullable: true, editable: true, defaultValue: null, length: 15, alias: Alarm Status Description (2), type: esriFieldTypeString )
• servicelastupdatedutc ( modelName: ServiceLastUpdatedUTC, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: Feature Service Last Updated (UTC), type: esriFieldTypeDate )
• servicelastupdatedutcoffset ( modelName: ServiceLastUpdatedUTCOffset, nullable: true, editable: true, defaultValue: null, length: 6, alias: Feature Service Last UpdatedOffset, type: esriFieldTypeString )

Templates:

• Name: RWIS_HistoricData
  Description:
  Prototype:
  basetempc: null
  sensorvaluedatetimelocalzone: null
  griplevelpercent2: null
  griplevelpercent1: null
  snowlayerin1: null
  snowlayerin2: null
  surfacetempc: null
  waterlayerin1: null
  waterlayerin2: null
  surfacefriction: null
  surfacetempf: null
  maxwinddirectiondeg: null
  preciptotalin_1hr: null
  icelayer1in: null
  presentweatherdesc: null
  snowheightin: null
  imageposition_2: null
  imageposition_1: null
  windspeedmph: null
  preciptotalin_6hr: null
  surfacestatecode2: null
  surfacestatecode1: null
  servicelastupdatedutcoffset: null
  stationname: null
  waterthicknessin: null
  imageposition_5: null
  imageposition_4: null
  imageposition_3: null
  presentweathercode: null
  alarmstatuscode2: null
  sensorvaluedatetimeutcoffset: null
  preciptotalin_12hr: null
  alarmstatuscode1: null
  rainstatedesc: null
  basetempf: null
  winddirectiondeg: null
  stationid: null
  rainpresentcode: null
  cloudstatuscode: null
  eventpreciptotalin: null
  generalstatusdesc: null
  imageurl_1: null
  dewtempf: null
  imageurl_2: null
  airtempf: null
  preciptotalin_24hr: null
  dewtempc: null
  pressureinhg: null
  visibilitymile: null
  icelayer2in: null
  imageurl_5: null
  rainstatecode: null
  imageurl_3: null
  sensorvaluedatetimelocal: null
  airtempc: null
  imageurl_4: null
  alarmstatusdesc1: null
  alarmstatusdesc2: null
  generalstatuscode: null
  preciptotalin_3hr: null
  cloudstatusdesc: null
  subsurfacetempf: null
  maxwindspeedmph: null
  rainpresentdesc: null
  sensorvaluedatetimeutc: null
  surfacestatedesc1: null
  relativehumidity: null
  surfacestatedesc2: null
  rainintensityin_hr: null
  
  Drawing Tool: esriFeatureEditToolNone

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

Edit Fields Info:

• Creation Date Field:
• Creator Field:
• Edit Date Field: servicelastupdatedutc
• Editor Field:

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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