{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "MCEHistoricEvents_PT", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": {"editDateField": "ServiceLastUpdatedUTC"}, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "Operations.GIS_WEBUSER.MCEHistoric_EventDetails", "relatedTableId": 7, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "MCELiveOID", "composite": false, "catalogID": "{6D6999BE-0AC9-4B5A-8DAE-DE40CFCDEC28}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": 2257866.1929426747, "ymin": 1202730.8770000003, "xmax": 2738585.8877717163, "ymax": 1905625.2848000005, "spatialReference": { "wkid": 102605, "latestWkid": 8826, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -3120900, "falseY": -13447900, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102605, "latestWkid": 8826, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -3120900, "falseY": -13447900, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 33, 137, 94, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "MCESegmentName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "MCESegmentName", "type": "esriFieldTypeString", "alias": "MCE Segment Name", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "MCESegmentName" }, { "name": "RWISStationName", "type": "esriFieldTypeString", "alias": "RWIS Station Name", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "RWISStationName" }, { "name": "EventID", "type": "esriFieldTypeSmallInteger", "alias": "Storm Event ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EventID" }, { "name": "EventSortOrder", "type": "esriFieldTypeSmallInteger", "alias": "MCE Event Sort Order", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EventSortOrder" }, { "name": "TechnicalEventStartDateTimeUTC", "type": "esriFieldTypeDate", "alias": "Event Technically Start Date-Time (UTC)", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "TechnicalEventStartDateTimeUTC" }, { "name": "EventStartDateTimeUTC", "type": "esriFieldTypeDate", "alias": "Event Start Date-Time (UTC)", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EventStartDateTimeUTC" }, { "name": "EventStartDateTimeUTCOffset", "type": "esriFieldTypeString", "alias": "Event Start Date-Time UTC Offset", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "EventStartDateTimeUTCOffset" }, { "name": "EventEndDateTimeUTC", "type": "esriFieldTypeDate", "alias": "Event End Date-Time (UTC)", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EventEndDateTimeUTC" }, { "name": "EventEndDateTimeUTCOffset", "type": "esriFieldTypeString", "alias": "Event End Date-Time UTC Offset", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "EventEndDateTimeUTCOffset" }, { "name": "EventStartDateText", "type": "esriFieldTypeString", "alias": "Event Start Date (Text)", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "EventStartDateText" }, { "name": "EventStartTimeText", "type": "esriFieldTypeString", "alias": "Event Start Time (Text)", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "EventStartTimeText" }, { "name": "EventEndDateText", "type": "esriFieldTypeString", "alias": "Event End Date (Text)", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "EventEndDateText" }, { "name": "EventEndTimeText", "type": "esriFieldTypeString", "alias": "Event End Time (Text)", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "EventEndTimeText" }, { "name": "EventDurationHours", "type": "esriFieldTypeDouble", "alias": "Event Duration (Hours)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EventDurationHours" }, { "name": "EventPollingCount", "type": "esriFieldTypeInteger", "alias": "Polling Count for Storm Event", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EventPollingCount" }, { "name": "EventPollingCount_CriteriaMet", "type": "esriFieldTypeInteger", "alias": "Polling Count for Storm Event (Criteria Met Only)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EventPollingCount_CriteriaMet" }, { "name": "EventDurationHours_CriteriaMet", "type": "esriFieldTypeDouble", "alias": "Event Duration - Criteria Met Only (Hours)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EventDurationHours_CriteriaMet" }, { "name": "EventPollingCount_MCE", "type": "esriFieldTypeInteger", "alias": "Polling Count for MCE Event", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EventPollingCount_MCE" }, { "name": "MaxWindSpeedRangeMPH", "type": "esriFieldTypeString", "alias": "Event Max Wind Speed Range (MPH)", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "MaxWindSpeedRangeMPH" }, { "name": "PrecipitationHoursPollingCount", "type": "esriFieldTypeInteger", "alias": "Polling Count for Precipitation Hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PrecipitationHoursPollingCount" }, { "name": "PrecipitationHours", "type": "esriFieldTypeDouble", "alias": "Event Precipitation Total Hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PrecipitationHours" }, { "name": "MinRoadTempF", "type": "esriFieldTypeDouble", "alias": "Event Minimum Road Temp (F)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MinRoadTempF" }, { "name": "MaxRoadTempF", "type": "esriFieldTypeDouble", "alias": "Event Maximum Road Temp (F)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaxRoadTempF" }, { "name": "TargetLaneMilePercent", "type": "esriFieldTypeDouble", "alias": "Target Lane Mile Percentage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TargetLaneMilePercent" }, { "name": "MCEEvent", "type": "esriFieldTypeString", "alias": "MCE Event (Yes/No)", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "MCEEvent" }, { "name": "MCEIndex", "type": "esriFieldTypeDouble", "alias": "MCE Index", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MCEIndex" }, { "name": "MCEReduction", "type": "esriFieldTypeDouble", "alias": "MCE Reduction", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MCEReduction" }, { "name": "MCEScoreType", "type": "esriFieldTypeString", "alias": "MCE Score Type", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MCEScoreType" }, { "name": "MCEScore", "type": "esriFieldTypeDouble", "alias": "MCE Score", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MCEScore" }, { "name": "AchievementCategory", "type": "esriFieldTypeString", "alias": "Event Achievement Category", "domain": null, "editable": true, "nullable": true, "length": 33, "defaultValue": null, "modelName": "AchievementCategory" }, { "name": "MobilityHours", "type": "esriFieldTypeDouble", "alias": "Mobility Hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MobilityHours" }, { "name": "MobilityCounter", "type": "esriFieldTypeSmallInteger", "alias": "Mobility Counter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MobilityCounter" }, { "name": "MobilityPercentage", "type": "esriFieldTypeDouble", "alias": "Mobility Percentage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MobilityPercentage" }, { "name": "WPICounter", "type": "esriFieldTypeSmallInteger", "alias": "WPI Counter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WPICounter" }, { "name": "WPIHours", "type": "esriFieldTypeDouble", "alias": "WPI Hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WPIHours" }, { "name": "WPIPercentage", "type": "esriFieldTypeDouble", "alias": "WPI Percentage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WPIPercentage" }, { "name": "RWISStationID", "type": "esriFieldTypeInteger", "alias": "RWIS Station ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RWISStationID" }, { "name": "RWISCycleLastDateTimeUTC", "type": "esriFieldTypeDate", "alias": "RWIS Sensor Last Date-Time (UTC)", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "RWISCycleLastDateTimeUTC" }, { "name": "RWISDownTimeHours", "type": "esriFieldTypeDouble", "alias": "RWIS Down Time Hours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RWISDownTimeHours" }, { "name": "RWISDownTimeCounter", "type": "esriFieldTypeInteger", "alias": "RWIS Down Time Counter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RWISDownTimeCount" }, { "name": "RWISIssue", "type": "esriFieldTypeString", "alias": "RWIS Issue (Yes/No)", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "RWISIssue" }, { "name": "DualCarriage", "type": "esriFieldTypeSmallInteger", "alias": "Dual Carriage MCE Segment", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DualCarriage" }, { "name": "TravelDirection", "type": "esriFieldTypeString", "alias": "Travel Direction", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "TravelDirection" }, { "name": "RouteID", "type": "esriFieldTypeString", "alias": "Route ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "RouteID" }, { "name": "CommonRouteName", "type": "esriFieldTypeString", "alias": "Common Route Name", "domain": null, "editable": true, "nullable": true, "length": 120, "defaultValue": null, "modelName": "CommonRouteName" }, { "name": "FromMeasure", "type": "esriFieldTypeDouble", "alias": "MCE Segment From Measure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FromMeasure" }, { "name": "ToMeasure", "type": "esriFieldTypeDouble", "alias": "MCE Segment To Measure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ToMeasure" }, { "name": "DOT_DistrictNumber", "type": "esriFieldTypeSmallInteger", "alias": "ITD District Number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOT_DistrictNumber" }, { "name": "DOT_MaintDistrictNumber", "type": "esriFieldTypeSmallInteger", "alias": "ITD Maintenance District Number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOT_MaintDistrictNumber" }, { "name": "DOT_ForemanArea", "type": "esriFieldTypeSmallInteger", "alias": "ITD Foreman Area", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOT_ForemanArea" }, { "name": "LatitudeDD_RWIS", "type": "esriFieldTypeDouble", "alias": "RWIS Station Latitude (WGS84 - DD)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LatitudeDD_RWIS" }, { "name": "LongitudeDD_RWIS", "type": "esriFieldTypeDouble", "alias": "RWIS Station Longitude (WGS84 -DD)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LongitudeDD_RWIS" }, { "name": "RWISAltitudeFeet", "type": "esriFieldTypeDouble", "alias": "RWIS Station Altitude (Feet)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RWISAltitudeFeet" }, { "name": "RWISMeasure", "type": "esriFieldTypeDouble", "alias": "RWIS Station Measure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RWISMeasure" }, { "name": "MCEYear", "type": "esriFieldTypeSmallInteger", "alias": "MCE Segment Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MCEYear" }, { "name": "CountyName", "type": "esriFieldTypeString", "alias": "County Name", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "CountyName" }, { "name": "CountyFIPS", "type": "esriFieldTypeString", "alias": "County FIPS", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "CountyFIPS" }, { "name": "SegmentLengthMile", "type": "esriFieldTypeDouble", "alias": "Segment Length (Mile - UTM83-ITD)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SegmentLengthMile" }, { "name": "LaneMiles", "type": "esriFieldTypeDouble", "alias": "Lane Miles", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LaneMiles" }, { "name": "MaterialQuantityTotal_Solid", "type": "esriFieldTypeDouble", "alias": "Event Total Solid Material Applied (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialQuantityTotal_Solid" }, { "name": "MaterialQuantityTotal_Liquid", "type": "esriFieldTypeDouble", "alias": "Event Total Liquid Material Applied (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialQuantityTotal_Liquid" }, { "name": "MaterialQuantityTotal_PreWet", "type": "esriFieldTypeDouble", "alias": "Event Total PreWet Material Applied (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialQuantityTotal_PreWet" }, { "name": "MaterialSolid_Salt_SPIDS", "type": "esriFieldTypeString", "alias": "List of Salt Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialSolid_Salt_SPIDS" }, { "name": "MaterialSolid_Salt_Usage", "type": "esriFieldTypeDouble", "alias": "Event Salt Usage (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_Salt_Usage" }, { "name": "MaterialSolid_IceSlicer_SPIDS", "type": "esriFieldTypeString", "alias": "List of Ice Slicer Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialSolid_IceSlicer_SPIDS" }, { "name": "MaterialSolid_IceSlicer_Usage", "type": "esriFieldTypeDouble", "alias": "Event Ice Slicer Usage (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_IceSlicer_Usage" }, { "name": "MaterialSolid_SaltSand21_SPIDS", "type": "esriFieldTypeString", "alias": "List of Salt/Sand 2:1 Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialSolid_SaltSand21_SPIDS" }, { "name": "MaterialSolid_SaltSand21_Usage", "type": "esriFieldTypeDouble", "alias": "Event Salt/Sand 2:1 Usage (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SaltSand21_Usage" }, { "name": "MaterialSolid_SaltSand31_SPIDS", "type": "esriFieldTypeString", "alias": "List of Salt/Sand 3:1 Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialSolid_SaltSand31_SPIDS" }, { "name": "MaterialSolid_SaltSand31_Usage", "type": "esriFieldTypeDouble", "alias": "Event Salt/Sand 3:1 Usage (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SaltSand31_Usage" }, { "name": "MaterialSolid_SandSalt11_SPIDS", "type": "esriFieldTypeString", "alias": "List of Sand/Salt 1:1 Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialSolid_SandSalt11_SPIDS" }, { "name": "MaterialSolid_SandSalt11_Usage", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 1:1 Usage (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SandSalt11_Usage" }, { "name": "MaterialSolid_SandSalt21_SPIDS", "type": "esriFieldTypeString", "alias": "List of Sand/Salt 2:1 Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialSolid_SandSalt21_SPIDS" }, { "name": "MaterialSolid_SandSalt21_Usage", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 2:1 Usage (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SandSalt21_Usage" }, { "name": "MaterialSolid_SandSalt31_SPIDS", "type": "esriFieldTypeString", "alias": "List of Sand/Salt 3:1 Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialSolid_SandSalt31_SPIDS" }, { "name": "MaterialSolid_SandSalt31_Usage", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 3:1 Usage (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SandSalt31_Usage" }, { "name": "MaterialSolid_SandSalt41_SPIDS", "type": "esriFieldTypeString", "alias": "List of Sand/Salt 4:1 Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialSolid_SandSalt41_SPIDS" }, { "name": "MaterialSolid_SandSalt41_Usage", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 4:1 Usage (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SandSalt41_Usage" }, { "name": "MaterialSolid_IceKicker_SPIDS", "type": "esriFieldTypeString", "alias": "List of Ice Kicker Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialSolid_IceKicker_SPIDS" }, { "name": "MaterialSolid_IceKicker_Usage", "type": "esriFieldTypeDouble", "alias": "Event Ice Kicker Usage (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_IceKicker_Usage" }, { "name": "MaterialSolid_Sand_SPIDS", "type": "esriFieldTypeString", "alias": "List of Sand Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialSolid_Sand_SPIDS" }, { "name": "MaterialSolid_Sand_Usage", "type": "esriFieldTypeDouble", "alias": "Event Sand Usage (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_Sand_Usage" }, { "name": "MaterialPreWet_Brine_SPIDS", "type": "esriFieldTypeString", "alias": "List of PreWet Brine Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialPreWet_Brine_SPIDS" }, { "name": "MaterialPreWet_Brine_Usage", "type": "esriFieldTypeDouble", "alias": "Event PreWet Brine Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialPreWet_Brine_Usage" }, { "name": "MaterialPreWet_MgCl_SPIDS", "type": "esriFieldTypeString", "alias": "List of PreWet MgCl Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialPreWet_MgCl_SPIDS" }, { "name": "MaterialPreWet_MgCl_Usage", "type": "esriFieldTypeDouble", "alias": "Event PreWet MgCl Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialPreWet_MgCl_Usage" }, { "name": "MaterialPreWet_CaCl_SPIDS", "type": "esriFieldTypeString", "alias": "List of PreWet CaCl Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialPreWet_CaCl_SPIDS" }, { "name": "MaterialPreWet_CaCl_Usage", "type": "esriFieldTypeDouble", "alias": "Event PreWet CaCl Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialPreWet_CaCl_Usage" }, { "name": "MaterialPreWet_BoostBrine_SPIDS", "type": "esriFieldTypeString", "alias": "List of PreWet Boost Brine Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialPreWet_BoostBrine_SPIDS" }, { "name": "MaterialPreWet_BoostBrine_Usage", "type": "esriFieldTypeDouble", "alias": "Event PreWet Boost Brine Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialPreWet_BoostBrine_Usage" }, { "name": "MaterialPreWet_GeoBrine_SPIDS", "type": "esriFieldTypeString", "alias": "List of PreWet Geomelt Brine Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialPreWet_GeoBrine_SPIDS" }, { "name": "MaterialPreWet_GeoBrine_Usage", "type": "esriFieldTypeDouble", "alias": "Event PreWet Geomelt Brine Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialPreWet_GeoBrine_Usage" }, { "name": "MaterialLiquid_BrineDeIce_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Brine/De-Icing Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialLiquid_BrineDeIce_SPIDS" }, { "name": "MaterialLiquid_BrineDeIce_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Brine/De-Icing Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_BrineDeIce_Usage" }, { "name": "MaterialLiquid_MgClDeIce_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid MgCl/De-Icing Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialLiquid_MgClDeIce_SPIDS" }, { "name": "MaterialLiquid_MgClDeIce_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid MgCl/De-Icing Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_MgClDeIce_Usage" }, { "name": "MaterialLiquid_BoostDeIce_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Boost Brine/De-Icing Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialLiquid_BoostDeIce_SPIDS" }, { "name": "MaterialLiquid_BoostDeIce_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Boost Brine/De-Icing Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_BoostDeIce_Usage" }, { "name": "MaterialLiquid_GeoDeIce_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Geomelt Brine/De-Icing Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialLiquid_GeoDeIce_SPIDS" }, { "name": "MaterialLiquid_GeoDeIce_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Geomelt Brine/De-Icing Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_GeoDeIce_Usage" }, { "name": "MaterialLiquid_BrineAnti_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Brine/Anti-Icing Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialLiquid_BrineAnti_SPIDS" }, { "name": "MaterialLiquid_BrineAnti_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Brine/Anti-Icing Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_BrineAnti_Usage" }, { "name": "MaterialLiquid_MgClAnti_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid MgCL/Anti-Icing Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialLiquid_MgClAnti_SPIDS" }, { "name": "MaterialLiquid_MgClAnti_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid MgCl/Anti-Icing Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_MgClAnti_Usage" }, { "name": "MaterialLiquid_BoostAnti_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Boost Brine/Anti-Icing Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialLiquid_BoostAnti_SPIDS" }, { "name": "MaterialLiquid_BoostAnti_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Boost Brine/Anti-Icing Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_BoostAnti_Usage" }, { "name": "MaterialLiquid_GeoAnti_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Geomelt Brine/Anti-Icing Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialLiquid_GeoAnti_SPIDS" }, { "name": "MaterialLiquid_GeoAnti_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Geomelt Brine/Anti-Icing Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_GeoAnti_Usage" }, { "name": "TruckIDList", "type": "esriFieldTypeString", "alias": "List of Trucks Used During Event", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "TruckIDList" }, { "name": "OperatorIDList", "type": "esriFieldTypeString", "alias": "List of Operators Used During Event", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "OperatorIDList" }, { "name": "TargetMaterial_Solid_Usage", "type": "esriFieldTypeDouble", "alias": "Target Material Solid Usage (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TargetMaterial_Solid_Usage" }, { "name": "TargetMaterial_Liquid_Usage", "type": "esriFieldTypeDouble", "alias": "Target Material Liquid Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TargetMaterial_Liquid_Usage" }, { "name": "TargetMaterial_PreWet_Usage", "type": "esriFieldTypeDouble", "alias": "Target Material PreWet Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TargetMaterial_PreWet_Usage" }, { "name": "LaborHours_Actual", "type": "esriFieldTypeDouble", "alias": "Labor Hours - Actual", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LaborHours_Actual" }, { "name": "LaborHours_Target", "type": "esriFieldTypeDouble", "alias": "Labor Hours - Target", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LaborHours_Target" }, { "name": "EquipmentMiles_Actual", "type": "esriFieldTypeDouble", "alias": "Equipment Miles - Actual", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EquipmentMiles_Actual" }, { "name": "EquipmentMiles_Target", "type": "esriFieldTypeDouble", "alias": "Equipment Miles - Target", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EquipmentMiles_Target" }, { "name": "NumberPasses", "type": "esriFieldTypeSmallInteger", "alias": "Number of Passes on Segment", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NumberPasses" }, { "name": "AVLDataAvailable", "type": "esriFieldTypeString", "alias": "AVL Data Available after 12 Hours", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "AVLDataAvailable" }, { "name": "InvalidStockPileIDPresent", "type": "esriFieldTypeString", "alias": "Invalid Stockpile IDs Present", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "InvalidStockPileIDPresent" }, { "name": "EventNotes", "type": "esriFieldTypeString", "alias": "Event Notes", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "EventNotes" }, { "name": "FMECode", "type": "esriFieldTypeSmallInteger", "alias": "FME Code Used for Calculations", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FMECode" }, { "name": "ServiceLastUpdatedUTC", "type": "esriFieldTypeDate", "alias": "Service Last Updated (UTC)", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ServiceLastUpdatedUTC" }, { "name": "ServiceLastUpdatedUTCOffset", "type": "esriFieldTypeString", "alias": "Service Last Updated UTC Offset", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "ServiceLastUpdatedUTCOffset" }, { "name": "TargetCost", "type": "esriFieldTypeDouble", "alias": "Target Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TargetCost" }, { "name": "ActualCost", "type": "esriFieldTypeDouble", "alias": "Actual Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ActualCost" }, { "name": "MaterialSolid_Salt_Cost", "type": "esriFieldTypeDouble", "alias": "Event Salt Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_Salt_Cost" }, { "name": "MaterialSolid_IceSlicer_Cost", "type": "esriFieldTypeDouble", "alias": "Event Ice Slicer Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_IceSlicer_Cost" }, { "name": "MaterialSolid_SaltSand21_Cost", "type": "esriFieldTypeDouble", "alias": "Event Salt/Sand 2:1 Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SaltSand21_Cost" }, { "name": "MaterialSolid_SaltSand31_Cost", "type": "esriFieldTypeDouble", "alias": "Event Salt/Sand 3:1 Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SaltSand31_Cost" }, { "name": "MaterialSolid_SandSalt11_Cost", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 1:1 Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SandSalt11_Cost" }, { "name": "MaterialSolid_SandSalt21_Cost", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 2:1 Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SandSalt21_Cost" }, { "name": "MaterialSolid_SandSalt31_Cost", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 3:1 Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SandSalt31_Cost" }, { "name": "MaterialSolid_SandSalt41_Cost", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 4:1 Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SandSalt41_Cost" }, { "name": "MaterialSolid_IceKicker_Cost", "type": "esriFieldTypeDouble", "alias": "Event Ice Kicker Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_IceKicker_Cost" }, { "name": "MaterialSolid_Sand_Cost", "type": "esriFieldTypeDouble", "alias": "Event Sand Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_Sand_Cost" }, { "name": "MaterialPreWet_Brine_Cost", "type": "esriFieldTypeDouble", "alias": "Event PreWet Brine Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialPreWet_Brine_Cost" }, { "name": "MaterialPreWet_MgCl_Cost", "type": "esriFieldTypeDouble", "alias": "Event PreWet MgCl Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialPreWet_MgCl_Cost" }, { "name": "MaterialPreWet_CaCl_Cost", "type": "esriFieldTypeDouble", "alias": "Event PreWet CaCl Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialPreWet_CaCl_Cost" }, { "name": "MaterialPreWet_BoostBrine_Cost", "type": "esriFieldTypeDouble", "alias": "Eent PreWet Boost Brine Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialPreWet_BoostBrine_Cost" }, { "name": "MaterialPreWet_GeoBrine_Cost", "type": "esriFieldTypeDouble", "alias": "Event PreWet Geomelt Brine Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialPreWet_GeoBrine_Cost" }, { "name": "MaterialLiquid_BrineDeIce_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Brine/De-Icing Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_BrineDeIce_Cost" }, { "name": "MaterialLiquid_MgClDeIce_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid MgCl/De-Icing Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_MgClDeIce_Cost" }, { "name": "MaterialLiquid_BoostDeIce_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Boost Brine/De-Icing Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_BoostDeIce_Cost" }, { "name": "MaterialLiquid_GeoDeIce_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Geomelt Brine/De-Icing Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_GeoDeIce_Cost" }, { "name": "MaterialLiquid_BrineAnti_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Brine/Anti-Icing Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_BrineAnti_Cost" }, { "name": "MaterialLiquid_MgClAnti_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid MgCl/Anti-Icing Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_MgClAnti_Cost" }, { "name": "MaterialLiquid_BoostAnti_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Boost Brine/Anti-Icing Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_BoostAnti_Cost" }, { "name": "MaterialLiquid_GeoAnti_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Geomelt Brine/Anti-Icing Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_GeoAnti_Cost" }, { "name": "TargetMaterial_Solid_Cost", "type": "esriFieldTypeDouble", "alias": "Target Material Solid Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TargetMaterial_Solid_Cost" }, { "name": "TargetMaterial_Liquid_Cost", "type": "esriFieldTypeDouble", "alias": "Target Material Liquid Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TargetMaterial_Liquid_Cost" }, { "name": "TargetMaterial_PreWet_Cost", "type": "esriFieldTypeDouble", "alias": "Target Material PreWet Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TargetMaterial_PreWet_Cost" }, { "name": "BackgroundColor", "type": "esriFieldTypeString", "alias": "Background Color (Dashboard)", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "BackgroundColor" }, { "name": "TextColor", "type": "esriFieldTypeString", "alias": "Text Color (Dashboard)", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "TextColor" }, { "name": "StartDateTimeLocal", "type": "esriFieldTypeDate", "alias": "StartDateTimeLocal", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "StartDateTimeLocal" }, { "name": "EndDateTimeLocal", "type": "esriFieldTypeDate", "alias": "EndDateTimeLocal", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EndDateTimeLocal" }, { "name": "FrostEvent", "type": "esriFieldTypeString", "alias": "Frost Event", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "FrostEvent" }, { "name": "MCELiveOID", "type": "esriFieldTypeInteger", "alias": "MCELive ObjectID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MCELiveOID" }, { "name": "TotalMaterial_Solid_Cost", "type": "esriFieldTypeDouble", "alias": "Event Total Solid Material Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalMaterial_Solid_Cost" }, { "name": "TotalMaterial_Liquid_Cost", "type": "esriFieldTypeDouble", "alias": "Event Total Liquid Material Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalMaterial_Liquid_Cost" }, { "name": "TotalMaterial_PreWet_Cost", "type": "esriFieldTypeDouble", "alias": "Event Total PreWet Material Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalMaterial_PreWet_Cost" }, { "name": "FrostPollingCount", "type": "esriFieldTypeSmallInteger", "alias": "Frost Polling Count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FrostPollingCount" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R48_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S30_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "MCEHistoricEvents_PT", "description": "", "prototype": { "attributes": { "TotalMaterial_PreWet_Cost": null, "FrostPollingCount": null, "MCESegmentName": null, "RWISStationName": null, "EventID": null, "EventSortOrder": null, "TechnicalEventStartDateTimeUTC": null, "EventStartDateTimeUTC": null, "EventStartDateTimeUTCOffset": null, "EventEndDateTimeUTC": null, "EventEndDateTimeUTCOffset": null, "EventStartDateText": null, "EventStartTimeText": null, "EventEndDateText": null, "EventEndTimeText": null, "EventDurationHours": null, "EventPollingCount": null, "EventPollingCount_CriteriaMet": null, "EventDurationHours_CriteriaMet": null, "EventPollingCount_MCE": null, "MaxWindSpeedRangeMPH": null, "PrecipitationHoursPollingCount": null, "PrecipitationHours": null, "MinRoadTempF": null, "MaxRoadTempF": null, "TargetLaneMilePercent": null, "MCEEvent": null, "MCEIndex": null, "MCEReduction": null, "MCEScoreType": null, "MCEScore": null, "AchievementCategory": null, "MobilityHours": null, "MobilityCounter": null, "MobilityPercentage": null, "WPICounter": null, "WPIHours": null, "WPIPercentage": null, "RWISStationID": null, "RWISCycleLastDateTimeUTC": null, "RWISDownTimeHours": null, "RWISDownTimeCounter": null, "RWISIssue": null, "DualCarriage": null, "TravelDirection": null, "RouteID": null, "CommonRouteName": null, "FromMeasure": null, "ToMeasure": null, "DOT_DistrictNumber": null, "DOT_MaintDistrictNumber": null, "DOT_ForemanArea": null, "LatitudeDD_RWIS": null, "LongitudeDD_RWIS": null, "RWISAltitudeFeet": null, "RWISMeasure": null, "MCEYear": null, "CountyName": null, "CountyFIPS": null, "SegmentLengthMile": null, "LaneMiles": null, "MaterialQuantityTotal_Solid": null, "MaterialQuantityTotal_Liquid": null, "MaterialQuantityTotal_PreWet": null, "MaterialSolid_Salt_SPIDS": null, "MaterialSolid_Salt_Usage": null, "MaterialSolid_IceSlicer_SPIDS": null, "MaterialSolid_IceSlicer_Usage": null, "MaterialSolid_SaltSand21_SPIDS": null, "MaterialSolid_SaltSand21_Usage": null, "MaterialSolid_SaltSand31_SPIDS": null, "MaterialSolid_SaltSand31_Usage": null, "MaterialSolid_SandSalt11_SPIDS": null, "MaterialSolid_SandSalt11_Usage": null, "MaterialSolid_SandSalt21_SPIDS": null, "MaterialSolid_SandSalt21_Usage": null, "MaterialSolid_SandSalt31_SPIDS": null, "MaterialSolid_SandSalt31_Usage": null, "MaterialSolid_SandSalt41_SPIDS": null, "MaterialSolid_SandSalt41_Usage": null, "MaterialSolid_IceKicker_SPIDS": null, "MaterialSolid_IceKicker_Usage": null, "MaterialSolid_Sand_SPIDS": null, "MaterialSolid_Sand_Usage": null, "MaterialPreWet_Brine_SPIDS": null, "MaterialPreWet_Brine_Usage": null, "MaterialPreWet_MgCl_SPIDS": null, "MaterialPreWet_MgCl_Usage": null, "MaterialPreWet_CaCl_SPIDS": null, "MaterialPreWet_CaCl_Usage": null, "MaterialPreWet_BoostBrine_SPIDS": null, "MaterialPreWet_BoostBrine_Usage": null, "MaterialPreWet_GeoBrine_SPIDS": null, "MaterialPreWet_GeoBrine_Usage": null, "MaterialLiquid_BrineDeIce_SPIDS": null, "MaterialLiquid_BrineDeIce_Usage": null, "MaterialLiquid_MgClDeIce_SPIDS": null, "MaterialLiquid_MgClDeIce_Usage": null, "MaterialLiquid_BoostDeIce_SPIDS": null, "MaterialLiquid_BoostDeIce_Usage": null, "MaterialLiquid_GeoDeIce_SPIDS": null, "MaterialLiquid_GeoDeIce_Usage": null, "MaterialLiquid_BrineAnti_SPIDS": null, "MaterialLiquid_BrineAnti_Usage": null, "MaterialLiquid_MgClAnti_SPIDS": null, "MaterialLiquid_MgClAnti_Usage": null, "MaterialLiquid_BoostAnti_SPIDS": null, "MaterialLiquid_BoostAnti_Usage": null, "MaterialLiquid_GeoAnti_SPIDS": null, "MaterialLiquid_GeoAnti_Usage": null, "TruckIDList": null, "OperatorIDList": null, "TargetMaterial_Solid_Usage": null, "TargetMaterial_Liquid_Usage": null, "TargetMaterial_PreWet_Usage": null, "LaborHours_Actual": null, "LaborHours_Target": null, "EquipmentMiles_Actual": null, "EquipmentMiles_Target": null, "NumberPasses": null, "AVLDataAvailable": null, "InvalidStockPileIDPresent": null, "EventNotes": null, "FMECode": null, "TotalMaterial_Liquid_Cost": null, "ServiceLastUpdatedUTCOffset": null, "TargetCost": null, "ActualCost": null, "MaterialSolid_Salt_Cost": null, "MaterialSolid_IceSlicer_Cost": null, "MaterialSolid_SaltSand21_Cost": null, "MaterialSolid_SaltSand31_Cost": null, "MaterialSolid_SandSalt11_Cost": null, "MaterialSolid_SandSalt21_Cost": null, "MaterialSolid_SandSalt31_Cost": null, "MaterialSolid_SandSalt41_Cost": null, "MaterialSolid_IceKicker_Cost": null, "MaterialSolid_Sand_Cost": null, "MaterialPreWet_Brine_Cost": null, "MaterialPreWet_MgCl_Cost": null, "MaterialPreWet_CaCl_Cost": null, "MaterialPreWet_BoostBrine_Cost": null, "MaterialPreWet_GeoBrine_Cost": null, "MaterialLiquid_BrineDeIce_Cost": null, "MaterialLiquid_MgClDeIce_Cost": null, "MaterialLiquid_BoostDeIce_Cost": null, "MaterialLiquid_GeoDeIce_Cost": null, "MaterialLiquid_BrineAnti_Cost": null, "MaterialLiquid_MgClAnti_Cost": null, "MaterialLiquid_BoostAnti_Cost": null, "MaterialLiquid_GeoAnti_Cost": null, "TargetMaterial_Solid_Cost": null, "TargetMaterial_Liquid_Cost": null, "TargetMaterial_PreWet_Cost": null, "BackgroundColor": null, "TextColor": null, "StartDateTimeLocal": null, "EndDateTimeLocal": null, "FrostEvent": null, "MCELiveOID": null, "TotalMaterial_Solid_Cost": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "ee39e37ee15f4c84b15923c3b2bf2e00" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "MCESegments", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolyline", "description": "", "copyrightText": "", "editFieldsInfo": {"editDateField": "ServiceLastUpdatedUTC"}, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "modelName": "GP_534388419", "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasGeometryProperties": true, "geometryProperties": { "shapeLengthFieldName": "Shape__Length", "units": "esriMeters" }, "hasMetadata": true, "extent": { "xmin": 2257333.2592, "ymin": 1200974.2594000008, "xmax": 2739825.7802, "ymax": 1972821.6764000002, "spatialReference": { "wkid": 102605, "latestWkid": 8826, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -3120900, "falseY": -13447900, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102605, "latestWkid": 8826, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -3120900, "falseY": -13447900, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 150, 136, 45, 255 ], "width": 1 } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": true, "hasZ": false, "allowUpdateWithoutMValues": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "MCESegmentName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "MCESegmentName", "type": "esriFieldTypeString", "alias": "MCE Segment Name", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "MCESegmentName" }, { "name": "RWISStationName", "type": "esriFieldTypeString", "alias": "RWIS Station Name", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "RWISStationName" }, { "name": "RWISStationID", "type": "esriFieldTypeInteger", "alias": "RWIS Station ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RWISStationID" }, { "name": "TravelDirection", "type": "esriFieldTypeString", "alias": "Travel Direction", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "TravelDirection" }, { "name": "RouteID", "type": "esriFieldTypeString", "alias": "Route ID", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "RouteID" }, { "name": "CommonRouteName", "type": "esriFieldTypeString", "alias": "Common Route Name", "domain": null, "editable": true, "nullable": true, "length": 120, "defaultValue": null, "modelName": "CommonRouteName" }, { "name": "FromMeasure", "type": "esriFieldTypeDouble", "alias": "MCE Segment From Measure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FromMeasure" }, { "name": "ToMeasure", "type": "esriFieldTypeDouble", "alias": "MCE Segment To Measure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ToMeasure" }, { "name": "DOT_MaintDistrictNumber", "type": "esriFieldTypeInteger", "alias": "ITD Maintenance District Number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOT_MaintenanceDistrictNumber" }, { "name": "LatitudeDD_RWIS", "type": "esriFieldTypeDouble", "alias": "RWIS Station Latitude (WGS84 - DD)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LatitudeDD_RWIS" }, { "name": "LongitudeDD_RWIS", "type": "esriFieldTypeDouble", "alias": "RWIS Station Longitude (WGS84 -DD)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LongitudeDD_RWIS" }, { "name": "RWISAltitudeFeet", "type": "esriFieldTypeDouble", "alias": "RWIS Station Altitude (Feet)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RWISAltitudeFeet" }, { "name": "RWISMeasure", "type": "esriFieldTypeDouble", "alias": "RWIS Station Measure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RWISMeasure" }, { "name": "MCEYear", "type": "esriFieldTypeInteger", "alias": "MCE Segment Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MCEYear" }, { "name": "CountyName", "type": "esriFieldTypeString", "alias": "County Name", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "CountyName" }, { "name": "CountyFIPS", "type": "esriFieldTypeString", "alias": "County FIPS", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "CountyFIPS" }, { "name": "SegmentLengthMile", "type": "esriFieldTypeDouble", "alias": "Segment Length (Mile - UTM83-ITD)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SegmentLengthMile" }, { "name": "LaneMiles", "type": "esriFieldTypeDouble", "alias": "Lane Miles", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LaneMiles" }, { "name": "DualCarriage", "type": "esriFieldTypeSmallInteger", "alias": "Dual Carriage MCE Segment", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DualCarriage" }, { "name": "DOT_DistrictNumber", "type": "esriFieldTypeSmallInteger", "alias": "ITD District Number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOT_DistrictNumber" }, { "name": "DOT_ForemanArea", "type": "esriFieldTypeSmallInteger", "alias": "ITD Foreman Area", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOT_ForemanArea" }, { "name": "ServiceLastUpdatedUTC", "type": "esriFieldTypeDate", "alias": "Service Last Updated (UTC)", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ServiceLastUpdatedUTC" }, { "name": "ServiceLastUpdatedUTCOffset", "type": "esriFieldTypeString", "alias": "Service Last Updated UTC Offset", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "ServiceLastUpdatedUTCOffset" }, { "name": "MCESegmentType", "type": "esriFieldTypeString", "alias": "MCE Segment Type", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "MCESegmentType" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE.STLength()", "required": true } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R19_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S8_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "MCESegments", "description": "", "prototype": { "attributes": { "MCESegmentType": null, "ServiceLastUpdatedUTCOffset": null, "MCESegmentName": null, "RWISStationName": null, "RWISStationID": null, "TravelDirection": null, "RouteID": null, "CommonRouteName": null, "FromMeasure": null, "ToMeasure": null, "DOT_MaintDistrictNumber": null, "LatitudeDD_RWIS": null, "LongitudeDD_RWIS": null, "RWISAltitudeFeet": null, "RWISMeasure": null, "MCEYear": null, "CountyName": null, "CountyFIPS": null, "SegmentLengthMile": null, "LaneMiles": null, "DualCarriage": null, "DOT_DistrictNumber": null, "DOT_ForemanArea": null } }, "drawingTool": "esriFeatureEditToolLine" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 8000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "ee39e37ee15f4c84b15923c3b2bf2e00" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "SnowRoutes_HistoricEvents_PT", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "Operations.GIS_WEBUSER.SnowRoutes_EventDetails", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "RWIS_Storm_Key", "composite": false, "catalogID": "{DED3FE54-9594-4F84-8BA7-28767345C3A6}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": 2257866.2380999997, "ymin": 1202730.8770000003, "xmax": 2738585.8329999996, "ymax": 1905625.2848000005, "spatialReference": { "wkid": 102605, "latestWkid": 8826, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -3120900, "falseY": -13447900, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102605, "latestWkid": 8826, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -3120900, "falseY": -13447900, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 71, 150, 37, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Segment511Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "RWIS_Storm_Key", "type": "esriFieldTypeString", "alias": "RWIS_Storm_Key", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "RWIS_Storm_Key" }, { "name": "Segment511Number", "type": "esriFieldTypeDouble", "alias": "Segment511Number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Segment511Number" }, { "name": "Segment511Name", "type": "esriFieldTypeString", "alias": "Segment511Name", "domain": null, "editable": true, "nullable": true, "length": 45, "defaultValue": null, "modelName": "Segment511Name" }, { "name": "Segment511RouteId", "type": "esriFieldTypeString", "alias": "Segment511RouteId", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "Segment511RouteId" }, { "name": "Segment511CommonRouteName", "type": "esriFieldTypeString", "alias": "Segment511CommonRouteName", "domain": null, "editable": true, "nullable": true, "length": 7, "defaultValue": null, "modelName": "Segment511CommonRouteName" }, { "name": "Segment511FromMeasure", "type": "esriFieldTypeDouble", "alias": "Segment511FromMeasure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Segment511FromMeasure" }, { "name": "Segment511ToMeasure", "type": "esriFieldTypeDouble", "alias": "Segment511ToMeasure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Segment511ToMeasure" }, { "name": "StormObjectID", "type": "esriFieldTypeInteger", "alias": "StormObjectID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "StormObjectID" }, { "name": "StormEventID", "type": "esriFieldTypeSmallInteger", "alias": "StormEventID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "StormEventID" }, { "name": "TechnicalEventStartDateTimeUTC", "type": "esriFieldTypeDate", "alias": "TechnicalEventStartDateTimeUTC", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "TechnicalEventStartDateTimeUTC" }, { "name": "EventStartDateTimeUTC", "type": "esriFieldTypeDate", "alias": "EventStartDateTimeUTC", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EventStartDateTimeUTC" }, { "name": "EventStartDateTimeUTCOffset", "type": "esriFieldTypeString", "alias": "EventStartDateTimeUTCOffset", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "EventStartDateTimeUTCOffset" }, { "name": "EventEndDateTimeUTC", "type": "esriFieldTypeDate", "alias": "EventEndDateTimeUTC", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EventEndDateTimeUTC" }, { "name": "EventEndDateTimeUTCOffset", "type": "esriFieldTypeString", "alias": "EventEndDateTimeUTCOffset", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "EventEndDateTimeUTCOffset" }, { "name": "EventStartDateText", "type": "esriFieldTypeString", "alias": "EventStartDateText", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "EventStartDateText" }, { "name": "EventStartTimeText", "type": "esriFieldTypeString", "alias": "EventStartTimeText", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "EventStartTimeText" }, { "name": "EventEndDateText", "type": "esriFieldTypeString", "alias": "EventEndDateText", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "EventEndDateText" }, { "name": "EventEndTimeText", "type": "esriFieldTypeString", "alias": "EventEndTimeText", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "EventEndTimeText" }, { "name": "EventDurationHours", "type": "esriFieldTypeDouble", "alias": "EventDurationHours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EventDurationHours" }, { "name": "EventPollingCount", "type": "esriFieldTypeInteger", "alias": "EventPollingCount", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EventPollingCount" }, { "name": "EventPollingCount_CriteriaMet", "type": "esriFieldTypeInteger", "alias": "EventPollingCount_CriteriaMet", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EventPollingCount_CriteriaMet" }, { "name": "EventDurationHours_CriteriaMet", "type": "esriFieldTypeDouble", "alias": "EventDurationHours_CriteriaMet", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EventDurationHours_CriteriaMet" }, { "name": "MaxWindSpeedRangeMPH", "type": "esriFieldTypeString", "alias": "MaxWindSpeedRangeMPH", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "MaxWindSpeedRangeMPH" }, { "name": "PrecipitationHoursPollingCount", "type": "esriFieldTypeInteger", "alias": "PrecipitationHoursPollingCount", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PrecipitationHoursPollingCount" }, { "name": "PrecipitationHours", "type": "esriFieldTypeDouble", "alias": "PrecipitationHours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PrecipitationHours" }, { "name": "MinRoadTempF", "type": "esriFieldTypeDouble", "alias": "MinRoadTempF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MinRoadTempF" }, { "name": "MaxRoadTempF", "type": "esriFieldTypeDouble", "alias": "MaxRoadTempF", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaxRoadTempF" }, { "name": "MCEEvent", "type": "esriFieldTypeString", "alias": "MCEEvent", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "MCEEvent" }, { "name": "RWISStationID", "type": "esriFieldTypeInteger", "alias": "RWISStationID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RWISStationID" }, { "name": "RWISStationName", "type": "esriFieldTypeString", "alias": "RWISStationName", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "RWISStationName" }, { "name": "RWISCycleLastDateTimeUTC", "type": "esriFieldTypeDate", "alias": "RWISCycleLastDateTimeUTC", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "RWISCycleLastDateTimeUTC" }, { "name": "RWISDownTimeHours", "type": "esriFieldTypeDouble", "alias": "RWISDownTimeHours", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RWISDownTimeHours" }, { "name": "RWISDownTimeCounter", "type": "esriFieldTypeInteger", "alias": "RWISDownTimeCounter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RWISDownTimeCounter" }, { "name": "RWISIssue", "type": "esriFieldTypeString", "alias": "RWISIssue", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "RWISIssue" }, { "name": "LatitudeDD_RWIS", "type": "esriFieldTypeDouble", "alias": "LatitudeDD_RWIS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LatitudeDD_RWIS" }, { "name": "LongitudeDD_RWIS", "type": "esriFieldTypeDouble", "alias": "LongitudeDD_RWIS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LongitudeDD_RWIS" }, { "name": "RWISAltitudeFeet", "type": "esriFieldTypeDouble", "alias": "RWISAltitudeFeet", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RWISAltitudeFeet" }, { "name": "SegmentYear", "type": "esriFieldTypeSmallInteger", "alias": "SegmentYear", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SegmentYear" }, { "name": "CountyName", "type": "esriFieldTypeString", "alias": "CountyName", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "CountyName" }, { "name": "CountyFIPS", "type": "esriFieldTypeString", "alias": "CountyFIPS", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "CountyFIPS" }, { "name": "SegmentLength", "type": "esriFieldTypeString", "alias": "SegmentLength", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "SegmentLength" }, { "name": "LaneMiles", "type": "esriFieldTypeString", "alias": "LaneMiles", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LaneMiles" }, { "name": "DOT_ForemanArea", "type": "esriFieldTypeSmallInteger", "alias": "DOT_ForemanArea", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOT_ForemanArea" }, { "name": "DOT_DistrictNumber", "type": "esriFieldTypeDouble", "alias": "DOT_DistrictNumber", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOT_DistrictNumber" }, { "name": "LaborHours_Actual", "type": "esriFieldTypeDouble", "alias": "LaborHours_Actual", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LaborHours_Actual" }, { "name": "EquipmentMiles_Actual", "type": "esriFieldTypeDouble", "alias": "EquipmentMiles_Actual", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EquipmentMiles_Actual" }, { "name": "NumberPasses", "type": "esriFieldTypeSmallInteger", "alias": "NumberPasses", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NumberPasses" }, { "name": "AVLDataAvailable", "type": "esriFieldTypeString", "alias": "AVLDataAvailable", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "AVLDataAvailable" }, { "name": "EventNotes", "type": "esriFieldTypeString", "alias": "EventNotes", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "EventNotes" }, { "name": "StartDateTimeLocal", "type": "esriFieldTypeDate", "alias": "StartDateTimeLocal", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "StartDateTimeLocal" }, { "name": "EndDateTimeLocal", "type": "esriFieldTypeDate", "alias": "EndDateTimeLocal", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EndDateTimeLocal" }, { "name": "FrostEvent", "type": "esriFieldTypeString", "alias": "FrostEvent", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "FrostEvent" }, { "name": "FMECode", "type": "esriFieldTypeSmallInteger", "alias": "FMECode", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FMECode" }, { "name": "ServiceLastUpdatedUTC", "type": "esriFieldTypeDate", "alias": "ServiceLastUpdatedUTC", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ServiceLastUpdatedUTC" }, { "name": "ServiceLastUpdatedUTCOffset", "type": "esriFieldTypeString", "alias": "ServiceLastUpdatedUTCOffset", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "ServiceLastUpdatedUTCOffset" }, { "name": "BackgroundColor", "type": "esriFieldTypeString", "alias": "BackgroundColor", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "BackgroundColor" }, { "name": "TextColor", "type": "esriFieldTypeString", "alias": "TextColor", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "TextColor" }, { "name": "DOT_MaintDistrictNumber", "type": "esriFieldTypeSmallInteger", "alias": "ITD Maintenance District Number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOT_MaintDistrictNumber" }, { "name": "RWISMeasure", "type": "esriFieldTypeDouble", "alias": "RWIS Station Measure", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RWISMeasure" }, { "name": "MaterialQuantityTotal_Solid", "type": "esriFieldTypeDouble", "alias": "Event Total Solid Material Applied (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialQuantityTotal_Solid" }, { "name": "MaterialQuantityTotal_Liquid", "type": "esriFieldTypeDouble", "alias": "Event Total Liquid Material Applied (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialQuantityTotal_Liquid" }, { "name": "MaterialQuantityTotal_PreWet", "type": "esriFieldTypeDouble", "alias": "Event Total PreWet Material Applied (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialQuantityTotal_PreWet" }, { "name": "MaterialSolid_Salt_SPIDS", "type": "esriFieldTypeString", "alias": "List of Salt Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialSolid_Salt_SPIDS" }, { "name": "MaterialSolid_Salt_Usage", "type": "esriFieldTypeDouble", "alias": "Event Salt Usage (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_Salt_Usage" }, { "name": "MaterialSolid_IceSlicer_SPIDS", "type": "esriFieldTypeString", "alias": "List of Ice Slicer Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialSolid_IceSlicer_SPIDS" }, { "name": "MaterialSolid_IceSlicer_Usage", "type": "esriFieldTypeDouble", "alias": "Event Ice Slicer Usage (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_IceSlicer_Usage" }, { "name": "MaterialSolid_SaltSand21_SPIDS", "type": "esriFieldTypeString", "alias": "List of Salt/Sand 2:1 Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialSolid_SaltSand21_SPIDS" }, { "name": "MaterialSolid_SaltSand21_Usage", "type": "esriFieldTypeDouble", "alias": "Event Salt/Sand 2:1 Usage (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SaltSand21_Usage" }, { "name": "MaterialSolid_SaltSand31_SPIDS", "type": "esriFieldTypeString", "alias": "List of Salt/Sand 3:1 Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialSolid_SaltSand31_SPIDS" }, { "name": "MaterialSolid_SaltSand31_Usage", "type": "esriFieldTypeDouble", "alias": "Event Salt/Sand 3:1 Usage (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SaltSand31_Usage" }, { "name": "MaterialSolid_SandSalt11_SPIDS", "type": "esriFieldTypeString", "alias": "List of Sand/Salt 1:1 Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialSolid_SandSalt11_SPIDS" }, { "name": "MaterialSolid_SandSalt11_Usage", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 1:1 Usage (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SandSalt11_Usage" }, { "name": "MaterialSolid_SandSalt21_SPIDS", "type": "esriFieldTypeString", "alias": "List of Sand/Salt 2:1 Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialSolid_SandSalt21_SPIDS" }, { "name": "MaterialSolid_SandSalt21_Usage", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 2:1 Usage (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SandSalt21_Usage" }, { "name": "MaterialSolid_SandSalt31_SPIDS", "type": "esriFieldTypeString", "alias": "List of Sand/Salt 3:1 Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialSolid_SandSalt31_SPIDS" }, { "name": "MaterialSolid_SandSalt31_Usage", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 3:1 Usage (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SandSalt31_Usage" }, { "name": "MaterialSolid_SandSalt41_SPIDS", "type": "esriFieldTypeString", "alias": "List of Sand/Salt 4:1 Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialSolid_SandSalt41_SPIDS" }, { "name": "MaterialSolid_SandSalt41_Usage", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 4:1 Usage (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SandSalt41_Usage" }, { "name": "MaterialSolid_IceKicker_SPIDS", "type": "esriFieldTypeString", "alias": "List of Ice Kicker Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialSolid_IceKicker_SPIDS" }, { "name": "MaterialSolid_IceKicker_Usage", "type": "esriFieldTypeDouble", "alias": "Event Ice Kicker Usage (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_IceKicker_Usage" }, { "name": "MaterialSolid_Sand_SPIDS", "type": "esriFieldTypeString", "alias": "List of Sand Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialSolid_Sand_SPIDS" }, { "name": "MaterialSolid_Sand_Usage", "type": "esriFieldTypeDouble", "alias": "Event Sand Usage (Tons)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_Sand_Usage" }, { "name": "MaterialPreWet_Brine_SPIDS", "type": "esriFieldTypeString", "alias": "List of PreWet Brine Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialPreWet_Brine_SPIDS" }, { "name": "MaterialPreWet_Brine_Usage", "type": "esriFieldTypeDouble", "alias": "Event PreWet Brine Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialPreWet_Brine_Usage" }, { "name": "MaterialPreWet_MgCl_SPIDS", "type": "esriFieldTypeString", "alias": "List of PreWet MgCl Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialPreWet_MgCl_SPIDS" }, { "name": "MaterialPreWet_MgCl_Usage", "type": "esriFieldTypeDouble", "alias": "Event PreWet MgCl Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialPreWet_MgCl_Usage" }, { "name": "MaterialPreWet_CaCl_SPIDS", "type": "esriFieldTypeString", "alias": "List of PreWet CaCl Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialPreWet_CaCl_SPIDS" }, { "name": "MaterialPreWet_CaCl_Usage", "type": "esriFieldTypeDouble", "alias": "Event PreWet CaCl Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialPreWet_CaCl_Usage" }, { "name": "MaterialPreWet_BoostBrine_SPIDS", "type": "esriFieldTypeString", "alias": "List of PreWet Boost Brine Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialPreWet_BoostBrine_SPIDS" }, { "name": "MaterialPreWet_BoostBrine_Usage", "type": "esriFieldTypeDouble", "alias": "Event PreWet Boost Brine Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialPreWet_BoostBrine_Usage" }, { "name": "MaterialPreWet_GeoBrine_SPIDS", "type": "esriFieldTypeString", "alias": "List of PreWet Geomelt Brine Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialPreWet_GeoBrine_SPIDS" }, { "name": "MaterialPreWet_GeoBrine_Usage", "type": "esriFieldTypeDouble", "alias": "Event PreWet Geomelt Brine Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialPreWet_GeoBrine_Usage" }, { "name": "MaterialLiquid_BrineDeIce_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Brine/De-Icing Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialLiquid_BrineDeIce_SPIDS" }, { "name": "MaterialLiquid_BrineDeIce_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Brine/De-Icing Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_BrineDeIce_Usage" }, { "name": "MaterialLiquid_MgClDeIce_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid MgCl/De-Icing Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialLiquid_MgClDeIce_SPIDS" }, { "name": "MaterialLiquid_MgClDeIce_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid MgCl/De-Icing Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_MgClDeIce_Usage" }, { "name": "MaterialLiquid_BoostDeIce_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Boost Brine/De-Icing Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialLiquid_BoostDeIce_SPIDS" }, { "name": "MaterialLiquid_BoostDeIce_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Boost Brine/De-Icing Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_BoostDeIce_Usage" }, { "name": "MaterialLiquid_GeoDeIce_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Geomelt Brine/De-Icing Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialLiquid_GeoDeIce_SPIDS" }, { "name": "MaterialLiquid_GeoDeIce_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Geomelt Brine/De-Icing Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_GeoDeIce_Usage" }, { "name": "MaterialLiquid_BrineAnti_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Brine/Anti-Icing Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialLiquid_BrineAnti_SPIDS" }, { "name": "MaterialLiquid_BrineAnti_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Brine/Anti-Icing Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_BrineAnti_Usage" }, { "name": "MaterialLiquid_MgClAnti_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid MgCL/Anti-Icing Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialLiquid_MgClAnti_SPIDS" }, { "name": "MaterialLiquid_MgClAnti_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid MgCl/Anti-Icing Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_MgClAnti_Usage" }, { "name": "MaterialLiquid_BoostAnti_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Boost Brine/Anti-Icing Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialLiquid_BoostAnti_SPIDS" }, { "name": "MaterialLiquid_BoostAnti_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Boost Brine/Anti-Icing Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_BoostAnti_Usage" }, { "name": "MaterialLiquid_GeoAnti_SPIDS", "type": "esriFieldTypeString", "alias": "List of Liquid Geomelt Brine/Anti-Icing Stockpile IDs", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "MaterialLiquid_GeoAnti_SPIDS" }, { "name": "MaterialLiquid_GeoAnti_Usage", "type": "esriFieldTypeDouble", "alias": "Event Liquid Geomelt Brine/Anti-Icing Usage (Gal)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_GeoAnti_Usage" }, { "name": "ActualCost", "type": "esriFieldTypeDouble", "alias": "Actual Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ActualCost" }, { "name": "MaterialSolid_Salt_Cost", "type": "esriFieldTypeDouble", "alias": "Event Salt Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_Salt_Cost" }, { "name": "MaterialSolid_IceSlicer_Cost", "type": "esriFieldTypeDouble", "alias": "Event Ice Slicer Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_IceSlicer_Cost" }, { "name": "MaterialSolid_SaltSand21_Cost", "type": "esriFieldTypeDouble", "alias": "Event Salt/Sand 2:1 Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SaltSand21_Cost" }, { "name": "MaterialSolid_SaltSand31_Cost", "type": "esriFieldTypeDouble", "alias": "Event Salt/Sand 3:1 Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SaltSand31_Cost" }, { "name": "MaterialSolid_SandSalt11_Cost", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 1:1 Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SandSalt11_Cost" }, { "name": "MaterialSolid_SandSalt21_Cost", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 2:1 Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SandSalt21_Cost" }, { "name": "MaterialSolid_SandSalt31_Cost", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 3:1 Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SandSalt31_Cost" }, { "name": "MaterialSolid_SandSalt41_Cost", "type": "esriFieldTypeDouble", "alias": "Event Sand/Salt 4:1 Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_SandSalt41_Cost" }, { "name": "MaterialSolid_IceKicker_Cost", "type": "esriFieldTypeDouble", "alias": "Event Ice Kicker Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_IceKicker_Cost" }, { "name": "MaterialSolid_Sand_Cost", "type": "esriFieldTypeDouble", "alias": "Event Sand Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialSolid_Sand_Cost" }, { "name": "MaterialPreWet_Brine_Cost", "type": "esriFieldTypeDouble", "alias": "Event PreWet Brine Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialPreWet_Brine_Cost" }, { "name": "MaterialPreWet_MgCl_Cost", "type": "esriFieldTypeDouble", "alias": "Event PreWet MgCl Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialPreWet_MgCl_Cost" }, { "name": "MaterialPreWet_CaCl_Cost", "type": "esriFieldTypeDouble", "alias": "Event PreWet CaCl Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialPreWet_CaCl_Cost" }, { "name": "MaterialPreWet_BoostBrine_Cost", "type": "esriFieldTypeDouble", "alias": "Event PreWet Boost Brine Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialPreWet_BoostBrine_Cost" }, { "name": "MaterialPreWet_GeoBrine_Cost", "type": "esriFieldTypeDouble", "alias": "Event PreWet Geomelt Brine Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialPreWet_GeoBrine_Cost" }, { "name": "MaterialLiquid_BrineDeIce_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Brine/De-Icing Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_BrineDeIce_Cost" }, { "name": "MaterialLiquid_MgClDeIce_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid MgCl/De-Icing Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_MgClDeIce_Cost" }, { "name": "MaterialLiquid_BoostDeIce_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Boost Brine/De-Icing Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_BoostDeIce_Cost" }, { "name": "MaterialLiquid_GeoDeIce_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Geomelt Brine/De-Icing Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_GeoDeIce_Cost" }, { "name": "MaterialLiquid_BrineAnti_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Brine/Anti-Icing Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_BrineAnti_Cost" }, { "name": "MaterialLiquid_MgClAnti_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid MgCl/Anti-Icing Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_MgClAnti_Cost" }, { "name": "MaterialLiquid_BoostAnti_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Boost Brine/Anti-Icing Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_BoostAnti_Cost" }, { "name": "MaterialLiquid_GeoAnti_Cost", "type": "esriFieldTypeDouble", "alias": "Event Liquid Geomelt Brine/Anti-Icing Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialLiquid_GeoAnti_Cost" }, { "name": "TotalMaterial_Solid_Cost", "type": "esriFieldTypeDouble", "alias": "Event Total Solid Material Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalMaterial_Solid_Cost" }, { "name": "TotalMaterial_Liquid_Cost", "type": "esriFieldTypeDouble", "alias": "Event Total Liquid Material Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalMaterial_Liquid_Cost" }, { "name": "TotalMaterial_PreWet_Cost", "type": "esriFieldTypeDouble", "alias": "Event Total PreWet Material Cost ($)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalMaterial_PreWet_Cost" }, { "name": "AVLProcessed", "type": "esriFieldTypeSmallInteger", "alias": "AVLProcessed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AVLProcessed" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R70_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4128_RWIS_St", "fields": "RWIS_Storm_Key", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S46_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SnowRoutes_HistoricEvents_PT", "description": "", "prototype": { "attributes": { "TotalMaterial_PreWet_Cost": null, "AVLProcessed": null, "RWIS_Storm_Key": null, "Segment511Number": null, "Segment511Name": null, "Segment511RouteId": null, "Segment511CommonRouteName": null, "Segment511FromMeasure": null, "Segment511ToMeasure": null, "StormObjectID": null, "StormEventID": null, "TechnicalEventStartDateTimeUTC": null, "EventStartDateTimeUTC": null, "EventStartDateTimeUTCOffset": null, "EventEndDateTimeUTC": null, "EventEndDateTimeUTCOffset": null, "EventStartDateText": null, "EventStartTimeText": null, "EventEndDateText": null, "EventEndTimeText": null, "EventDurationHours": null, "EventPollingCount": null, "EventPollingCount_CriteriaMet": null, "EventDurationHours_CriteriaMet": null, "MaxWindSpeedRangeMPH": null, "PrecipitationHoursPollingCount": null, "PrecipitationHours": null, "MinRoadTempF": null, "MaxRoadTempF": null, "MCEEvent": null, "RWISStationID": null, "RWISStationName": null, "RWISCycleLastDateTimeUTC": null, "RWISDownTimeHours": null, "RWISDownTimeCounter": null, "RWISIssue": null, "LatitudeDD_RWIS": null, "LongitudeDD_RWIS": null, "RWISAltitudeFeet": null, "SegmentYear": null, "CountyName": null, "CountyFIPS": null, "SegmentLength": null, "LaneMiles": null, "DOT_ForemanArea": null, "DOT_DistrictNumber": null, "LaborHours_Actual": null, "EquipmentMiles_Actual": null, "NumberPasses": null, "AVLDataAvailable": null, "EventNotes": null, "StartDateTimeLocal": null, "EndDateTimeLocal": null, "FrostEvent": null, "FMECode": null, "ServiceLastUpdatedUTC": null, "ServiceLastUpdatedUTCOffset": null, "BackgroundColor": null, "TextColor": null, "DOT_MaintDistrictNumber": null, "RWISMeasure": null, "MaterialQuantityTotal_Solid": null, "MaterialQuantityTotal_Liquid": null, "MaterialQuantityTotal_PreWet": null, "MaterialSolid_Salt_SPIDS": null, "MaterialSolid_Salt_Usage": null, "MaterialSolid_IceSlicer_SPIDS": null, "MaterialSolid_IceSlicer_Usage": null, "MaterialSolid_SaltSand21_SPIDS": null, "MaterialSolid_SaltSand21_Usage": null, "MaterialSolid_SaltSand31_SPIDS": null, "MaterialSolid_SaltSand31_Usage": null, "MaterialSolid_SandSalt11_SPIDS": null, "MaterialSolid_SandSalt11_Usage": null, "MaterialSolid_SandSalt21_SPIDS": null, "MaterialSolid_SandSalt21_Usage": null, "MaterialSolid_SandSalt31_SPIDS": null, "MaterialSolid_SandSalt31_Usage": null, "MaterialSolid_SandSalt41_SPIDS": null, "MaterialSolid_SandSalt41_Usage": null, "MaterialSolid_IceKicker_SPIDS": null, "MaterialSolid_IceKicker_Usage": null, "MaterialSolid_Sand_SPIDS": null, "MaterialSolid_Sand_Usage": null, "MaterialPreWet_Brine_SPIDS": null, "MaterialPreWet_Brine_Usage": null, "MaterialPreWet_MgCl_SPIDS": null, "MaterialPreWet_MgCl_Usage": null, "MaterialPreWet_CaCl_SPIDS": null, "MaterialPreWet_CaCl_Usage": null, "MaterialPreWet_BoostBrine_SPIDS": null, "MaterialPreWet_BoostBrine_Usage": null, "MaterialPreWet_GeoBrine_SPIDS": null, "MaterialPreWet_GeoBrine_Usage": null, "MaterialLiquid_BrineDeIce_SPIDS": null, "MaterialLiquid_BrineDeIce_Usage": null, "MaterialLiquid_MgClDeIce_SPIDS": null, "MaterialLiquid_MgClDeIce_Usage": null, "MaterialLiquid_BoostDeIce_SPIDS": null, "MaterialLiquid_BoostDeIce_Usage": null, "MaterialLiquid_GeoDeIce_SPIDS": null, "MaterialLiquid_GeoDeIce_Usage": null, "MaterialLiquid_BrineAnti_SPIDS": null, "MaterialLiquid_BrineAnti_Usage": null, "MaterialLiquid_MgClAnti_SPIDS": null, "MaterialLiquid_MgClAnti_Usage": null, "MaterialLiquid_BoostAnti_SPIDS": null, "MaterialLiquid_BoostAnti_Usage": null, "MaterialLiquid_GeoAnti_SPIDS": null, "MaterialLiquid_GeoAnti_Usage": null, "ActualCost": null, "MaterialSolid_Salt_Cost": null, "MaterialSolid_IceSlicer_Cost": null, "MaterialSolid_SaltSand21_Cost": null, "MaterialSolid_SaltSand31_Cost": null, "MaterialSolid_SandSalt11_Cost": null, "MaterialSolid_SandSalt21_Cost": null, "MaterialSolid_SandSalt31_Cost": null, "MaterialSolid_SandSalt41_Cost": null, "MaterialSolid_IceKicker_Cost": null, "MaterialSolid_Sand_Cost": null, "MaterialPreWet_Brine_Cost": null, "MaterialPreWet_MgCl_Cost": null, "MaterialPreWet_CaCl_Cost": null, "MaterialPreWet_BoostBrine_Cost": null, "MaterialPreWet_GeoBrine_Cost": null, "MaterialLiquid_BrineDeIce_Cost": null, "MaterialLiquid_MgClDeIce_Cost": null, "MaterialLiquid_BoostDeIce_Cost": null, "MaterialLiquid_GeoDeIce_Cost": null, "MaterialLiquid_BrineAnti_Cost": null, "MaterialLiquid_MgClAnti_Cost": null, "MaterialLiquid_BoostAnti_Cost": null, "MaterialLiquid_GeoAnti_Cost": null, "TotalMaterial_Solid_Cost": null, "TotalMaterial_Liquid_Cost": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "ee39e37ee15f4c84b15923c3b2bf2e00" } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "Materials_Costs", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "StockpileName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "STOCK_ID", "type": "esriFieldTypeDouble", "alias": "STOCK_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STOCK_ID" }, { "name": "StockpileName", "type": "esriFieldTypeString", "alias": "StockpileName", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "StockpileName" }, { "name": "COMMON_NAME", "type": "esriFieldTypeString", "alias": "COMMON_NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "COMMON_NAME" }, { "name": "CURR_AMOUNT", "type": "esriFieldTypeDouble", "alias": "CURR_AMOUNT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CURR_AMOUNT" }, { "name": "MASTER_CODE_ID", "type": "esriFieldTypeDouble", "alias": "MASTER_CODE_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MASTER_CODE_ID" }, { "name": "TOTAL_COST", "type": "esriFieldTypeDouble", "alias": "TOTAL_COST", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTAL_COST" }, { "name": "UNIT_ID", "type": "esriFieldTypeDouble", "alias": "UNIT_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UNIT_ID" }, { "name": "UNIT_COST", "type": "esriFieldTypeDouble", "alias": "UNIT_COST", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UNIT_COST" }, { "name": "MASTER_CODE_NAME", "type": "esriFieldTypeString", "alias": "MASTER_CODE_NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MASTER_CODE_NAME" }, { "name": "FinalUnitCost", "type": "esriFieldTypeDouble", "alias": "FinalUnitCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FinalUnitCost" } ], "indexes": [ { "name": "R80_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "mci_idx", "fields": "MASTER_CODE_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "stk_idx", "fields": "STOCK_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "cn_idx", "fields": "COMMON_NAME", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Materials_Costs", "description": "", "prototype": { "attributes": { "MASTER_CODE_NAME": null, "FinalUnitCost": null, "STOCK_ID": null, "StockpileName": null, "COMMON_NAME": null, "CURR_AMOUNT": null, "MASTER_CODE_ID": null, "TOTAL_COST": null, "UNIT_ID": null, "UNIT_COST": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ee39e37ee15f4c84b15923c3b2bf2e00" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "MCE_DefaultMaterialCost", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": {"editDateField": "TableLastUpdatedUTC"}, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "MaterialName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "MCEYear", "type": "esriFieldTypeSmallInteger", "alias": "MCEYear", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MCEYear" }, { "name": "MaterialSubType", "type": "esriFieldTypeString", "alias": "MaterialSubType", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MaterialSubType" }, { "name": "MaterialName", "type": "esriFieldTypeString", "alias": "MaterialName", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "MaterialName" }, { "name": "CPSMaterialName", "type": "esriFieldTypeString", "alias": "CPSMaterialName", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "CPSMaterialName" }, { "name": "UnitType", "type": "esriFieldTypeString", "alias": "UnitType", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "UnitType" }, { "name": "DOT_DistrictNumber", "type": "esriFieldTypeSmallInteger", "alias": "ITD District Number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOT_DistrictNumber" }, { "name": "MaterialUnitCost", "type": "esriFieldTypeDouble", "alias": "MaterialUnitCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MaterialUnitCost" }, { "name": "TableLastUpdatedUTC", "type": "esriFieldTypeDate", "alias": "TableLastUpdated", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "TableLastUpdatedUTC" }, { "name": "TableLastUpdatedUTCOffset", "type": "esriFieldTypeString", "alias": "TableLastUpdatedUTCOffset", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "TableLastUpdatedUTCOffset" } ], "indexes": [ { "name": "R22_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "MCE_DefaultMaterialCost", "description": "", "prototype": { "attributes": { "MaterialUnitCost": null, "TableLastUpdatedUTCOffset": null, "MCEYear": null, "MaterialSubType": null, "MaterialName": null, "CPSMaterialName": null, "UnitType": null, "DOT_DistrictNumber": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ee39e37ee15f4c84b15923c3b2bf2e00" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 5, "name": "RWIS_HistoricData", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": {"editDateField": "ServiceLastUpdatedUTC"}, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "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", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ee39e37ee15f4c84b15923c3b2bf2e00" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "name": "SnowRoutes_EventDetails", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "Operations.GIS_WEBUSER.SnowRoutes_HistoricEvents_PT", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "RWIS_StormID", "composite": false, "catalogID": "{DED3FE54-9594-4F84-8BA7-28767345C3A6}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Segment511CommonRouteName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Truck", "type": "esriFieldTypeString", "alias": "Truck", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Truck" }, { "name": "Operator", "type": "esriFieldTypeString", "alias": "Operator", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Operator" }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Material" }, { "name": "EventCost", "type": "esriFieldTypeDouble", "alias": "EventCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EventCost" }, { "name": "StockPileID", "type": "esriFieldTypeString", "alias": "StockPileID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "StockPileID" }, { "name": "EventObjectID", "type": "esriFieldTypeInteger", "alias": "EventObjectID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EventObjectID" }, { "name": "EventUsage", "type": "esriFieldTypeDouble", "alias": "EventUsage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EventUsage" }, { "name": "RWIS_StormID", "type": "esriFieldTypeString", "alias": "RWIS_StormID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "RWIS_StormID" }, { "name": "MaterialCategory", "type": "esriFieldTypeString", "alias": "Material Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaterialCategory" }, { "name": "MaterialUnits", "type": "esriFieldTypeString", "alias": "Material Units", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "MaterialUnits" }, { "name": "Segment511CommonRouteName", "type": "esriFieldTypeString", "alias": "Segment511CommonRouteName", "domain": null, "editable": true, "nullable": true, "length": 7, "defaultValue": null, "modelName": "Segment511CommonRouteName" }, { "name": "Segment511Name", "type": "esriFieldTypeString", "alias": "Segment511Name", "domain": null, "editable": true, "nullable": true, "length": 45, "defaultValue": null, "modelName": "Segment511Name" }, { "name": "Segment511Number", "type": "esriFieldTypeDouble", "alias": "Segment511Number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Segment511Number" }, { "name": "EventStartDateText", "type": "esriFieldTypeString", "alias": "EventStartDateText", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "EventStartDateText" }, { "name": "EventStartTimeText", "type": "esriFieldTypeString", "alias": "EventStartTimeText", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "EventStartTimeText" }, { "name": "EventEndDateText", "type": "esriFieldTypeString", "alias": "EventEndDateText", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "EventEndDateText" }, { "name": "EventEndTimeText", "type": "esriFieldTypeString", "alias": "EventEndTimeText", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "EventEndTimeText" }, { "name": "StormEventID", "type": "esriFieldTypeSmallInteger", "alias": "StormEventID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "StormEventID" }, { "name": "StartDateTimeLocal", "type": "esriFieldTypeDate", "alias": "StartDateTimeLocal", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "StartDateTimeLocal" }, { "name": "EndDateTimeLocal", "type": "esriFieldTypeDate", "alias": "EndDateTimeLocal", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EndDateTimeLocal" }, { "name": "EventStartDateTimeUTC", "type": "esriFieldTypeDate", "alias": "EventStartDateTimeUTC", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EventStartDateTimeUTC" }, { "name": "EventEndDateTimeUTC", "type": "esriFieldTypeDate", "alias": "EventEndDateTimeUTC", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EventEndDateTimeUTC" }, { "name": "DOT_ForemanArea", "type": "esriFieldTypeSmallInteger", "alias": "DOT_ForemanArea", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOT_ForemanArea" }, { "name": "DOT_DistrictNumber", "type": "esriFieldTypeDouble", "alias": "DOT_DistrictNumber", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOT_DistrictNumber" }, { "name": "SegmentYear", "type": "esriFieldTypeSmallInteger", "alias": "SegmentYear", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SegmentYear" } ], "indexes": [ { "name": "R69_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4127_RWIS_St", "fields": "RWIS_StormID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "SnowRoutes_EventDetails", "description": "", "prototype": { "attributes": { "DOT_DistrictNumber": null, "SegmentYear": null, "Truck": null, "Operator": null, "Material": null, "EventCost": null, "StockPileID": null, "EventObjectID": null, "EventUsage": null, "RWIS_StormID": null, "MaterialCategory": null, "MaterialUnits": null, "Segment511CommonRouteName": null, "Segment511Name": null, "Segment511Number": null, "EventStartDateText": null, "EventStartTimeText": null, "EventEndDateText": null, "EventEndTimeText": null, "StormEventID": null, "StartDateTimeLocal": null, "EndDateTimeLocal": null, "EventStartDateTimeUTC": null, "EventEndDateTimeUTC": null, "DOT_ForemanArea": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ee39e37ee15f4c84b15923c3b2bf2e00" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "MCEHistoric_EventDetails", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "Operations.GIS_WEBUSER.MCEHistoricEvents_PT", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "EventObjectID", "composite": false, "catalogID": "{6D6999BE-0AC9-4B5A-8DAE-DE40CFCDEC28}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "MCESegmentName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Truck", "type": "esriFieldTypeString", "alias": "Truck", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Truck" }, { "name": "Operator", "type": "esriFieldTypeString", "alias": "Operator", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Operator" }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Material" }, { "name": "StockPileID", "type": "esriFieldTypeString", "alias": "StockPileID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "StockPileID" }, { "name": "EventObjectID", "type": "esriFieldTypeInteger", "alias": "EventObjectID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EventObjectID" }, { "name": "MaterialCategory", "type": "esriFieldTypeString", "alias": "MaterialCategory", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MaterialCategory" }, { "name": "MaterialUnits", "type": "esriFieldTypeString", "alias": "MaterialUnits", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "MaterialUnits" }, { "name": "MCESegmentName", "type": "esriFieldTypeString", "alias": "MCESegmentName", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "MCESegmentName" }, { "name": "EventStartDateText", "type": "esriFieldTypeString", "alias": "EventStartDateText", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "EventStartDateText" }, { "name": "EventStartTimeText", "type": "esriFieldTypeString", "alias": "EventStartTimeText", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "EventStartTimeText" }, { "name": "EventEndDateText", "type": "esriFieldTypeString", "alias": "EventEndDateText", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "EventEndDateText" }, { "name": "EventEndTimeText", "type": "esriFieldTypeString", "alias": "EventEndTimeText", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "EventEndTimeText" }, { "name": "EventCost", "type": "esriFieldTypeDouble", "alias": "EventCost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EventCost" }, { "name": "EventUsage", "type": "esriFieldTypeDouble", "alias": "EventUsage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EventUsage" }, { "name": "EventID", "type": "esriFieldTypeSmallInteger", "alias": "EventID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EventID" }, { "name": "StartDateTimeLocal", "type": "esriFieldTypeDate", "alias": "StartDateTimeLocal", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "StartDateTimeLocal" }, { "name": "EndDateTimeLocal", "type": "esriFieldTypeDate", "alias": "EndDateTimeLocal", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EndDateTimeLocal" }, { "name": "EventStartDateTimeUTC", "type": "esriFieldTypeDate", "alias": "EventStartDateTimeUTC", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EventStartDateTimeUTC" }, { "name": "EventEndDateTimeUTC", "type": "esriFieldTypeDate", "alias": "EventEndDateTimeUTC", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EventEndDateTimeUTC" }, { "name": "DOT_DistrictNumber", "type": "esriFieldTypeSmallInteger", "alias": "ITD District Number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOT_DistrictNumber" }, { "name": "DOT_ForemanArea", "type": "esriFieldTypeSmallInteger", "alias": "ITD Foreman Area", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOT_ForemanArea" }, { "name": "MCEYear", "type": "esriFieldTypeSmallInteger", "alias": "MCE Segment Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MCEYear" } ], "indexes": [ { "name": "R75_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4134_EventOb", "fields": "EventObjectID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "MCEHistoric_EventDetails", "description": "", "prototype": { "attributes": { "DOT_ForemanArea": null, "MCEYear": null, "Truck": null, "Operator": null, "Material": null, "StockPileID": null, "EventObjectID": null, "MaterialCategory": null, "MaterialUnits": null, "MCESegmentName": null, "EventStartDateText": null, "EventStartTimeText": null, "EventEndDateText": null, "EventEndTimeText": null, "EventCost": null, "EventUsage": null, "EventID": null, "StartDateTimeLocal": null, "EndDateTimeLocal": null, "EventStartDateTimeUTC": null, "EventEndDateTimeUTC": null, "DOT_DistrictNumber": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "ee39e37ee15f4c84b15923c3b2bf2e00" } ] }