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: false
Supports Query With Distance: false
Supports Sql Expression: false
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

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

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata