{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 1, "name": "RWIS_HistoricData", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": {"editDateField": "ServiceLastUpdatedUTC"}, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "StationName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "StationID", "type": "esriFieldTypeInteger", "alias": "Station ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "StationID" }, { "name": "StationName", "type": "esriFieldTypeString", "alias": "Station Name", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "StationName" }, { "name": "SensorValueDateTimeUTC", "type": "esriFieldTypeDate", "alias": "Sensor Value Date-Time (UTC)", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SensorValueDateTimeUTC" }, { "name": "SensorValueDateTimeUTCOffset", "type": "esriFieldTypeString", "alias": "Sensor Value Date-Time UTC Offset", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "SensorValueDateTimeUTCOffset" }, { "name": "SensorValueDateTimeLocal", "type": "esriFieldTypeDate", "alias": "Sensor Value Date-Time (Local)", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SensorValueDateTimeLocal" }, { "name": "SensorValueDateTimeLocalZone", "type": "esriFieldTypeString", "alias": "Sensor Value Date-Time Local Timezone", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "SensorValueDateTimeLocalZone" }, { "name": "GeneralStatusCode", "type": "esriFieldTypeInteger", "alias": "General Status Code", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GeneralStatusCode" }, { "name": "GeneralStatusDesc", "type": "esriFieldTypeString", "alias": "General Status Description", "domain": null, "editable": true, "nullable": true, "length": 11, "defaultValue": null, "modelName": "GeneralStatusDesc" }, { "name": "AirTempF", "type": "esriFieldTypeDouble", "alias": "Air Temperature (F)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AirTempF" }, { "name": "AirTempC", "type": "esriFieldTypeDouble", "alias": "Air Temperature (C)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AirTempC" }, { "name": "DewTempF", "type": "esriFieldTypeDouble", "alias": "Dew Temperature (F)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DewTempF" }, { "name": "DewTempC", "type": "esriFieldTypeDouble", "alias": "Dew Temperature (C)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DewTempC" }, { "name": "BaseTempF", "type": "esriFieldTypeDouble", "alias": "Base Temperature (F)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BaseTempF" }, { "name": "BaseTempC", "type": "esriFieldTypeDouble", "alias": "Base Temperature (C)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BaseTempC" }, { "name": "PressureINHg", "type": "esriFieldTypeDouble", "alias": "Pressure (IN Hg)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PressureINHg" }, { "name": "RelativeHumidity", "type": "esriFieldTypeDouble", "alias": "Relative Humidity (%)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RelativeHumidity" }, { "name": "IceLayer1IN", "type": "esriFieldTypeDouble", "alias": "Ice Layer 1 (Inch)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IceLayer1IN" }, { "name": "IceLayer2IN", "type": "esriFieldTypeDouble", "alias": "Ice Layer 2 (Inch)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IceLayer2IN" }, { "name": "GripLevelPercent1", "type": "esriFieldTypeDouble", "alias": "Grip Level Percentage (1)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GripLevelPercent1" }, { "name": "GripLevelPercent2", "type": "esriFieldTypeDouble", "alias": "Grip Level Percentage (2)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GripLevelPercent2" }, { "name": "PresentWeatherCode", "type": "esriFieldTypeInteger", "alias": "Present Weather Code", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PresentWeatherCode" }, { "name": "PresentWeatherDesc", "type": "esriFieldTypeString", "alias": "Present Weather Description", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "PresentWeatherDesc" }, { "name": "RainPresentCode", "type": "esriFieldTypeInteger", "alias": "Rain Present Code", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RainPresentCode" }, { "name": "RainPresentDesc", "type": "esriFieldTypeString", "alias": "Rain Present Description", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "RainPresentDesc" }, { "name": "RainIntensityIN_HR", "type": "esriFieldTypeDouble", "alias": "Rain Intensity (Inches/Hour)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RainIntensityIN_HR" }, { "name": "RainStateCode", "type": "esriFieldTypeInteger", "alias": "Rain State Code", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RainStateCode" }, { "name": "RainStateDesc", "type": "esriFieldTypeString", "alias": "Rain State Description", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "RainStateDesc" }, { "name": "EventPrecipTotalIN", "type": "esriFieldTypeDouble", "alias": "Event Precipitation Total (Inches)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EventPrecipTotalIN" }, { "name": "PrecipTotalIN_1HR", "type": "esriFieldTypeDouble", "alias": "Precipitation Total Last 1 Hour (Inches)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PrecipTotalIN_1HR" }, { "name": "PrecipTotalIN_3HR", "type": "esriFieldTypeDouble", "alias": "Precipitation Total Last 3 Hours (Inches)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PrecipTotalIN_3HR" }, { "name": "PrecipTotalIN_6HR", "type": "esriFieldTypeDouble", "alias": "Precipitation Total Last 6 Hours (Inches)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PrecipTotalIN_6HR" }, { "name": "PrecipTotalIN_12HR", "type": "esriFieldTypeDouble", "alias": "Precipitation Total Last 12 Hours (Inches)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PrecipTotalIN_12HR" }, { "name": "PrecipTotalIN_24HR", "type": "esriFieldTypeDouble", "alias": "Precipitation Total Last 24 Hours (Inches)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PrecipTotalIN_24HR" }, { "name": "SnowHeightIN", "type": "esriFieldTypeDouble", "alias": "Snow Height Off Roadway (Inches)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SnowHeightIN" }, { "name": "SnowLayerIN1", "type": "esriFieldTypeDouble", "alias": "Snow Layer 1 (Inch)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SnowLayerIN1" }, { "name": "SnowLayerIN2", "type": "esriFieldTypeDouble", "alias": "Snow Layer 2 (Inch)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SnowLayerIN2" }, { "name": "SurfaceTempF", "type": "esriFieldTypeDouble", "alias": "Surface Temperature (F)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SurfaceTempF" }, { "name": "SurfaceTempC", "type": "esriFieldTypeDouble", "alias": "Surface Temperature (C)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SurfaceTempC" }, { "name": "SurfaceStateCode1", "type": "esriFieldTypeInteger", "alias": "Surface State Code (1)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SurfaceStateCode1" }, { "name": "SurfaceStateDesc1", "type": "esriFieldTypeString", "alias": "Surface State Description (1)", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "SurfaceStateDesc1" }, { "name": "SurfaceStateCode2", "type": "esriFieldTypeInteger", "alias": "Surface State Code (2)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SurfaceStateCode2" }, { "name": "SurfaceStateDesc2", "type": "esriFieldTypeString", "alias": "Surface State Description (2)", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "SurfaceStateDesc2" }, { "name": "SurfaceFriction", "type": "esriFieldTypeString", "alias": "Surface Friction", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SurfaceFriction" }, { "name": "SubSurfaceTempF", "type": "esriFieldTypeDouble", "alias": "Sub-Surface Temp (F)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SubSurfaceTempF" }, { "name": "VisibilityMile", "type": "esriFieldTypeDouble", "alias": "Visibility (Miles)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VisibilityMile" }, { "name": "WindDirectionDeg", "type": "esriFieldTypeDouble", "alias": "Wind Direction Degree (Average)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WindDirectionDeg" }, { "name": "MaxWindDirectionDeg", "type": "esriFieldTypeDouble", "alias": "Wind Direction Degree (Gust)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaxWindDirectionDeg" }, { "name": "WindSpeedMPH", "type": "esriFieldTypeDouble", "alias": "Average Wind Speed (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WindSpeedMPH" }, { "name": "MaxWindSpeedMPH", "type": "esriFieldTypeDouble", "alias": "Wind Speed (Gust) (MPH)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaxWindSpeedMPH" }, { "name": "CloudStatusCode", "type": "esriFieldTypeInteger", "alias": "Cloud Status Code", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CloudStatusCode" }, { "name": "CloudStatusDesc", "type": "esriFieldTypeString", "alias": "Cloud Status Description", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CloudStatusDesc" }, { "name": "WaterLayerIN1", "type": "esriFieldTypeDouble", "alias": "Water Layer (Inches) (1)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WaterLayerIN1" }, { "name": "WaterLayerIN2", "type": "esriFieldTypeDouble", "alias": "Water Layer (Inches) (2)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WaterLayerIN2" }, { "name": "WaterThicknessIN", "type": "esriFieldTypeDouble", "alias": "Water Thickness (Inches)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WaterThicknessIN" }, { "name": "ImageURL_1", "type": "esriFieldTypeString", "alias": "RWIS Image Camera 1", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "ImageURL_1" }, { "name": "ImagePosition_1", "type": "esriFieldTypeString", "alias": "RWIS Image Camera 1 Position", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ImagePosition_1" }, { "name": "ImageURL_2", "type": "esriFieldTypeString", "alias": "RWIS Image Camera 2", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "ImageURL_2" }, { "name": "ImagePosition_2", "type": "esriFieldTypeString", "alias": "RWIS Image Camera 2 Position", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ImagePosition_2" }, { "name": "ImageURL_3", "type": "esriFieldTypeString", "alias": "RWIS Image Camera 3", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "ImageURL_3" }, { "name": "ImagePosition_3", "type": "esriFieldTypeString", "alias": "RWIS Image Camera 3 Position", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ImagePosition_3" }, { "name": "ImageURL_4", "type": "esriFieldTypeString", "alias": "RWIS Image Camera 4", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "ImageURL_4" }, { "name": "ImagePosition_4", "type": "esriFieldTypeString", "alias": "RWIS Image Camera 4 Position", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ImagePosition_4" }, { "name": "ImageURL_5", "type": "esriFieldTypeString", "alias": "RWIS Image Camera 5", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "ImageURL_5" }, { "name": "ImagePosition_5", "type": "esriFieldTypeString", "alias": "RWIS Image Camera 5 Position", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ImagePosition_5" }, { "name": "AlarmStatusCode1", "type": "esriFieldTypeInteger", "alias": "Alarm Status Code (1)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AlarmStatusCode1" }, { "name": "AlarmStatusDesc1", "type": "esriFieldTypeString", "alias": "Alarm Status Description (1)", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "AlarmStatusDesc1" }, { "name": "AlarmStatusCode2", "type": "esriFieldTypeInteger", "alias": "Alarm Status Code (2)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AlarmStatusCode2" }, { "name": "AlarmStatusDesc2", "type": "esriFieldTypeString", "alias": "Alarm Status Description (2)", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "AlarmStatusDesc2" }, { "name": "ServiceLastUpdatedUTC", "type": "esriFieldTypeDate", "alias": "Feature Service Last Updated (UTC)", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ServiceLastUpdatedUTC" }, { "name": "ServiceLastUpdatedUTCOffset", "type": "esriFieldTypeString", "alias": "Feature Service Last UpdatedOffset", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "ServiceLastUpdatedUTCOffset" } ], "indexes": [ { "name": "R25_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "RWIS_HistoricData", "description": "", "prototype": { "attributes": { "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 } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "34bafd5485024a7e9863b7e7e3e50290" }