{ "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": false, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "RWIS_HistoricData", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "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 } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "RWIS_HistoricData", "displayField": "stationname", "supportsCalculate": true, "fields": [ { "modelName": "OBJECTID", "nullable": false, "defaultValue": null, "editable": false, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "modelName": "StationID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stationid", "alias": "Station ID", "type": "esriFieldTypeInteger" }, { "modelName": "StationName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stationname", "length": 30, "alias": "Station Name", "type": "esriFieldTypeString" }, { "modelName": "SensorValueDateTimeUTC", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "sensorvaluedatetimeutc", "length": 29, "alias": "Sensor Value Date-Time (UTC)", "type": "esriFieldTypeDate" }, { "modelName": "SensorValueDateTimeUTCOffset", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sensorvaluedatetimeutcoffset", "length": 6, "alias": "Sensor Value Date-Time UTC Offset", "type": "esriFieldTypeString" }, { "modelName": "SensorValueDateTimeLocal", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "sensorvaluedatetimelocal", "length": 29, "alias": "Sensor Value Date-Time (Local)", "type": "esriFieldTypeDate" }, { "modelName": "SensorValueDateTimeLocalZone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sensorvaluedatetimelocalzone", "length": 3, "alias": "Sensor Value Date-Time Local Timezone", "type": "esriFieldTypeString" }, { "modelName": "GeneralStatusCode", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "generalstatuscode", "alias": "General Status Code", "type": "esriFieldTypeInteger" }, { "modelName": "GeneralStatusDesc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "generalstatusdesc", "length": 11, "alias": "General Status Description", "type": "esriFieldTypeString" }, { "modelName": "AirTempF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "airtempf", "alias": "Air Temperature (F)", "type": "esriFieldTypeDouble" }, { "modelName": "AirTempC", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "airtempc", "alias": "Air Temperature (C)", "type": "esriFieldTypeDouble" }, { "modelName": "DewTempF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dewtempf", "alias": "Dew Temperature (F)", "type": "esriFieldTypeDouble" }, { "modelName": "DewTempC", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dewtempc", "alias": "Dew Temperature (C)", "type": "esriFieldTypeDouble" }, { "modelName": "BaseTempF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "basetempf", "alias": "Base Temperature (F)", "type": "esriFieldTypeDouble" }, { "modelName": "BaseTempC", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "basetempc", "alias": "Base Temperature (C)", "type": "esriFieldTypeDouble" }, { "modelName": "PressureINHg", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pressureinhg", "alias": "Pressure (IN Hg)", "type": "esriFieldTypeDouble" }, { "modelName": "RelativeHumidity", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "relativehumidity", "alias": "Relative Humidity (%)", "type": "esriFieldTypeDouble" }, { "modelName": "IceLayer1IN", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "icelayer1in", "alias": "Ice Layer 1 (Inch)", "type": "esriFieldTypeDouble" }, { "modelName": "IceLayer2IN", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "icelayer2in", "alias": "Ice Layer 2 (Inch)", "type": "esriFieldTypeDouble" }, { "modelName": "GripLevelPercent1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "griplevelpercent1", "alias": "Grip Level Percentage (1)", "type": "esriFieldTypeDouble" }, { "modelName": "GripLevelPercent2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "griplevelpercent2", "alias": "Grip Level Percentage (2)", "type": "esriFieldTypeDouble" }, { "modelName": "PresentWeatherCode", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "presentweathercode", "alias": "Present Weather Code", "type": "esriFieldTypeInteger" }, { "modelName": "PresentWeatherDesc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "presentweatherdesc", "length": 150, "alias": "Present Weather Description", "type": "esriFieldTypeString" }, { "modelName": "RainPresentCode", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rainpresentcode", "alias": "Rain Present Code", "type": "esriFieldTypeInteger" }, { "modelName": "RainPresentDesc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rainpresentdesc", "length": 20, "alias": "Rain Present Description", "type": "esriFieldTypeString" }, { "modelName": "RainIntensityIN_HR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rainintensityin_hr", "alias": "Rain Intensity (Inches/Hour)", "type": "esriFieldTypeDouble" }, { "modelName": "RainStateCode", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rainstatecode", "alias": "Rain State Code", "type": "esriFieldTypeInteger" }, { "modelName": "RainStateDesc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rainstatedesc", "length": 40, "alias": "Rain State Description", "type": "esriFieldTypeString" }, { "modelName": "EventPrecipTotalIN", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "eventpreciptotalin", "alias": "Event Precipitation Total (Inches)", "type": "esriFieldTypeDouble" }, { "modelName": "PrecipTotalIN_1HR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "preciptotalin_1hr", "alias": "Precipitation Total Last 1 Hour (Inches)", "type": "esriFieldTypeDouble" }, { "modelName": "PrecipTotalIN_3HR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "preciptotalin_3hr", "alias": "Precipitation Total Last 3 Hours (Inches)", "type": "esriFieldTypeDouble" }, { "modelName": "PrecipTotalIN_6HR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "preciptotalin_6hr", "alias": "Precipitation Total Last 6 Hours (Inches)", "type": "esriFieldTypeDouble" }, { "modelName": "PrecipTotalIN_12HR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "preciptotalin_12hr", "alias": "Precipitation Total Last 12 Hours (Inches)", "type": "esriFieldTypeDouble" }, { "modelName": "PrecipTotalIN_24HR", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "preciptotalin_24hr", "alias": "Precipitation Total Last 24 Hours (Inches)", "type": "esriFieldTypeDouble" }, { "modelName": "SnowHeightIN", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "snowheightin", "alias": "Snow Height Off Roadway (Inches)", "type": "esriFieldTypeDouble" }, { "modelName": "SnowLayerIN1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "snowlayerin1", "alias": "Snow Layer 1 (Inch)", "type": "esriFieldTypeDouble" }, { "modelName": "SnowLayerIN2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "snowlayerin2", "alias": "Snow Layer 2 (Inch)", "type": "esriFieldTypeDouble" }, { "modelName": "SurfaceTempF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "surfacetempf", "alias": "Surface Temperature (F)", "type": "esriFieldTypeDouble" }, { "modelName": "SurfaceTempC", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "surfacetempc", "alias": "Surface Temperature (C)", "type": "esriFieldTypeDouble" }, { "modelName": "SurfaceStateCode1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "surfacestatecode1", "alias": "Surface State Code (1)", "type": "esriFieldTypeInteger" }, { "modelName": "SurfaceStateDesc1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "surfacestatedesc1", "length": 40, "alias": "Surface State Description (1)", "type": "esriFieldTypeString" }, { "modelName": "SurfaceStateCode2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "surfacestatecode2", "alias": "Surface State Code (2)", "type": "esriFieldTypeInteger" }, { "modelName": "SurfaceStateDesc2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "surfacestatedesc2", "length": 40, "alias": "Surface State Description (2)", "type": "esriFieldTypeString" }, { "modelName": "SurfaceFriction", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "surfacefriction", "length": 20, "alias": "Surface Friction", "type": "esriFieldTypeString" }, { "modelName": "SubSurfaceTempF", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subsurfacetempf", "alias": "Sub-Surface Temp (F)", "type": "esriFieldTypeDouble" }, { "modelName": "VisibilityMile", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "visibilitymile", "alias": "Visibility (Miles)", "type": "esriFieldTypeDouble" }, { "modelName": "WindDirectionDeg", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "winddirectiondeg", "alias": "Wind Direction Degree (Average)", "type": "esriFieldTypeDouble" }, { "modelName": "MaxWindDirectionDeg", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "maxwinddirectiondeg", "alias": "Wind Direction Degree (Gust)", "type": "esriFieldTypeDouble" }, { "modelName": "WindSpeedMPH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "windspeedmph", "alias": "Average Wind Speed (MPH)", "type": "esriFieldTypeDouble" }, { "modelName": "MaxWindSpeedMPH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "maxwindspeedmph", "alias": "Wind Speed (Gust) (MPH)", "type": "esriFieldTypeDouble" }, { "modelName": "CloudStatusCode", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cloudstatuscode", "alias": "Cloud Status Code", "type": "esriFieldTypeInteger" }, { "modelName": "CloudStatusDesc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cloudstatusdesc", "length": 25, "alias": "Cloud Status Description", "type": "esriFieldTypeString" }, { "modelName": "WaterLayerIN1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "waterlayerin1", "alias": "Water Layer (Inches) (1)", "type": "esriFieldTypeDouble" }, { "modelName": "WaterLayerIN2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "waterlayerin2", "alias": "Water Layer (Inches) (2)", "type": "esriFieldTypeDouble" }, { "modelName": "WaterThicknessIN", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "waterthicknessin", "alias": "Water Thickness (Inches)", "type": "esriFieldTypeDouble" }, { "modelName": "ImageURL_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "imageurl_1", "length": 254, "alias": "RWIS Image Camera 1", "type": "esriFieldTypeString" }, { "modelName": "ImagePosition_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "imageposition_1", "length": 20, "alias": "RWIS Image Camera 1 Position", "type": "esriFieldTypeString" }, { "modelName": "ImageURL_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "imageurl_2", "length": 254, "alias": "RWIS Image Camera 2", "type": "esriFieldTypeString" }, { "modelName": "ImagePosition_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "imageposition_2", "length": 20, "alias": "RWIS Image Camera 2 Position", "type": "esriFieldTypeString" }, { "modelName": "ImageURL_3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "imageurl_3", "length": 254, "alias": "RWIS Image Camera 3", "type": "esriFieldTypeString" }, { "modelName": "ImagePosition_3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "imageposition_3", "length": 20, "alias": "RWIS Image Camera 3 Position", "type": "esriFieldTypeString" }, { "modelName": "ImageURL_4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "imageurl_4", "length": 254, "alias": "RWIS Image Camera 4", "type": "esriFieldTypeString" }, { "modelName": "ImagePosition_4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "imageposition_4", "length": 20, "alias": "RWIS Image Camera 4 Position", "type": "esriFieldTypeString" }, { "modelName": "ImageURL_5", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "imageurl_5", "length": 254, "alias": "RWIS Image Camera 5", "type": "esriFieldTypeString" }, { "modelName": "ImagePosition_5", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "imageposition_5", "length": 20, "alias": "RWIS Image Camera 5 Position", "type": "esriFieldTypeString" }, { "modelName": "AlarmStatusCode1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alarmstatuscode1", "alias": "Alarm Status Code (1)", "type": "esriFieldTypeInteger" }, { "modelName": "AlarmStatusDesc1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alarmstatusdesc1", "length": 15, "alias": "Alarm Status Description (1)", "type": "esriFieldTypeString" }, { "modelName": "AlarmStatusCode2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alarmstatuscode2", "alias": "Alarm Status Code (2)", "type": "esriFieldTypeInteger" }, { "modelName": "AlarmStatusDesc2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alarmstatusdesc2", "length": 15, "alias": "Alarm Status Description (2)", "type": "esriFieldTypeString" }, { "modelName": "ServiceLastUpdatedUTC", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "servicelastupdatedutc", "length": 29, "alias": "Feature Service Last Updated (UTC)", "type": "esriFieldTypeDate" }, { "modelName": "ServiceLastUpdatedUTCOffset", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "servicelastupdatedutcoffset", "length": 6, "alias": "Feature Service Last UpdatedOffset", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r52_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": {"editDateField": "servicelastupdatedutc"}, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "ce580fcf474d42cd89bd30e7d6e83652", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }