{ "layers": [], "tables": [ { "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 0, "name": "RWIS_HistoricData", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": {"editDateField": "servicelastupdatedutc"}, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "supportsStatistics": 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 }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": null, "displayField": "stationname", "typeIdField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "nullable": false, "defaultValue": null, "modelName": "OBJECTID", "editable": false }, { "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": 29, "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": 29, "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": 29, "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": "r52_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" } ], "useStandardizedQueries": true, "standardMaxRecordCount": 16000, "tileMaxRecordCount": 4000, "maxRecordCountFactor": 1, "supportedQueryFormats": "JSON", "maxRecordCount": 2000, "allowGeometryUpdates": true, "capabilities": "Query", "enableZDefaults": true, "zDefault": 0, "allowUpdateWithoutMValues": true, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "supportsApplyEditsWithGlobalIds": false, "serviceItemId": "ce580fcf474d42cd89bd30e7d6e83652", "hasMetadata": true, "sqlParserVersion": "PG_10.8.1" } ] }