{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 95, "name": "Asphalt Event History Related Table", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "EventType", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "RelatedGlobalID", "type": "esriFieldTypeGUID", "alias": "RelatedGlobalID", "length": 38, "domain": null }, { "name": "EventType", "type": "esriFieldTypeString", "alias": "Event Type", "length": 255, "domain": null }, { "name": "EventDate", "type": "esriFieldTypeDate", "alias": "Event Date", "length": 8, "domain": null }, { "name": "WorkDoneBy", "type": "esriFieldTypeString", "alias": "Work Done By", "length": 255, "domain": null }, { "name": "MaintenanceType", "type": "esriFieldTypeString", "alias": "Maintenance Type", "length": 255, "domain": { "type": "codedValue", "name": "StreetsAsphaltMaintType", "description": "Types of maintenance for Asphalt", "codedValues": [ { "name": "1\" Overlay", "code": "1\" Overlay" }, { "name": "1.5\" Overlay", "code": "1.5\" Overlay" }, { "name": "2\" Overlay", "code": "2\" Overlay" }, { "name": "2\" Overlay Parking Lot", "code": "2\" Overlay Parking Lot" }, { "name": "2\" Overlay Trails", "code": "2\" Overlay Trails" }, { "name": "3\" New Asphalt", "code": "3\" New Asphalt" }, { "name": "3\" New Asphalt Trails", "code": "3\" New Asphalt Trails" }, { "name": "Chip Seal", "code": "Chip Seal" }, { "name": "Micro Seal", "code": "Micro Seal" }, { "name": "Mineral Seal", "code": "Mineral Seal" }, { "name": "Mineral Seal Parking Lot", "code": "Mineral Seal Parking Lot" }, { "name": "Mineral Seal Trails", "code": "Mineral Seal Trails" }, { "name": "Slurry Seal", "code": "Slurry Seal" }, { "name": "Slurry Seal Parking Lot", "code": "Slurry Seal Parking Lot" }, { "name": "Slurry Seal Trails", "code": "Slurry Seal Trails" }, { "name": "Lane Leveling", "code": "Lane Leveling" }, { "name": "Milling", "code": "Milling" }, { "name": "Crack Sealing", "code": "Crack Sealing" }, { "name": "Rejuvenating Seal", "code": "Rejuvenating Seal" }, { "name": "Rejuvenating Seal Parking Lot", "code": "Rejuvenating Seal Parking Lot" }, { "name": "Rejuvenating Seal Trails", "code": "Rejuvenating Seal Trails" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "AreaSqFt", "type": "esriFieldTypeDouble", "alias": "Area (sqft)", "domain": null }, { "name": "Class", "type": "esriFieldTypeString", "alias": "Class", "length": 255, "domain": { "type": "codedValue", "name": "AsphaltClass", "description": "What Class of Road is It", "codedValues": [ { "name": "Local", "code": "Local" }, { "name": "Commercial Local", "code": "Commercial Local" }, { "name": "Minor Collector", "code": "Minor Collector" }, { "name": "Collector", "code": "Collector" }, { "name": "Major Collector", "code": "Major Collector" }, { "name": "Minor Arterial", "code": "Minor Arterial" }, { "name": "Major Arterial", "code": "Major Arterial" }, { "name": "Freeway Frontage Road", "code": "Freeway Frontage Road" }, { "name": "Freeway", "code": "Freeway" }, { "name": "Airport", "code": "Airport" }, { "name": "Parking Lot", "code": "Parking Lot" }, { "name": "Trail", "code": "Trail" }, { "name": "Residential Local", "code": "Residential Local" }, { "name": "Cemetery", "code": "Cemetery" }, { "name": "Fairgrounds", "code": "Fairgrounds" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "LinkedFiles", "type": "esriFieldTypeString", "alias": "Linked Files", "length": 255, "domain": null }, { "name": "OverlayTons", "type": "esriFieldTypeSmallInteger", "alias": "Overlay (tons)", "domain": null }, { "name": "LaneLevelingTons", "type": "esriFieldTypeSmallInteger", "alias": "Lane Leveling (tons)", "domain": null }, { "name": "TreesTrimmed", "type": "esriFieldTypeSmallInteger", "alias": "Trees Trimmed", "domain": null }, { "name": "CrackRating", "type": "esriFieldTypeSmallInteger", "alias": "Crack Rating", "domain": { "type": "codedValue", "name": "AsphaltRatings", "description": "Asphalt Ratings from 1-5", "codedValues": [ { "name": "1", "code": 1 }, { "name": "2", "code": 2 }, { "name": "3", "code": 3 }, { "name": "4", "code": 4 }, { "name": "5", "code": 5 }, { "name": "6", "code": 6 }, { "name": "10", "code": 10 }, { "name": "11", "code": 11 }, { "name": "12", "code": 12 }, { "name": "13", "code": 13 }, { "name": "7", "code": 7 }, { "name": "8", "code": 8 }, { "name": "9", "code": 9 }, { "name": "0", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CrackRatingDescription", "type": "esriFieldTypeString", "alias": "Crack Rating Description", "length": 255, "domain": { "type": "codedValue", "name": "AsphaltCrackRatingDescription", "description": "What is the description of the Asphalt Crack Rating", "codedValues": [ { "name": "Heavy Alligator Cracking", "code": "Heavy Alligator Cracking" }, { "name": "Light Alligator Cracking", "code": "Light Alligator Cracking" }, { "name": "Transverse & Longitudinal Cracking", "code": "Transverse & Longitudinal Cracking" }, { "name": "Light Cracking", "code": "Light Cracking" }, { "name": "No Cracking", "code": "No Cracking" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CrackSealRating", "type": "esriFieldTypeSmallInteger", "alias": "Crack Seal Rating", "domain": { "type": "codedValue", "name": "AsphaltRatings", "description": "Asphalt Ratings from 1-5", "codedValues": [ { "name": "1", "code": 1 }, { "name": "2", "code": 2 }, { "name": "3", "code": 3 }, { "name": "4", "code": 4 }, { "name": "5", "code": 5 }, { "name": "6", "code": 6 }, { "name": "10", "code": 10 }, { "name": "11", "code": 11 }, { "name": "12", "code": 12 }, { "name": "13", "code": 13 }, { "name": "7", "code": 7 }, { "name": "8", "code": 8 }, { "name": "9", "code": 9 }, { "name": "0", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CrackSealDescription", "type": "esriFieldTypeString", "alias": "Crack Seal Description", "length": 255, "domain": { "type": "codedValue", "name": "AsphaltCrackSealRatingDescription", "description": "What is the description of the crack seal rating", "codedValues": [ { "name": "Sealed but Alligatoring", "code": "Sealed but Alligatoring" }, { "name": "Sealed with Heavy Cracking", "code": "Sealed with Heavy Cracking" }, { "name": "Sealed with Light Cracking", "code": "Sealed with Light Cracking" }, { "name": "All Cracks are Sealed", "code": "All Cracks are Sealed" }, { "name": "Heavy Alligatoring/Not Sealed", "code": "Heavy Alligatoring/Not Sealed" }, { "name": "No Big Cracks are Sealed", "code": "No Big Cracks are Sealed" }, { "name": "No Small Cracks are Sealed", "code": "No Small Cracks are Sealed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SealRating", "type": "esriFieldTypeSmallInteger", "alias": "Seal Rating", "domain": { "type": "codedValue", "name": "AsphaltRatings", "description": "Asphalt Ratings from 1-5", "codedValues": [ { "name": "1", "code": 1 }, { "name": "2", "code": 2 }, { "name": "3", "code": 3 }, { "name": "4", "code": 4 }, { "name": "5", "code": 5 }, { "name": "6", "code": 6 }, { "name": "10", "code": 10 }, { "name": "11", "code": 11 }, { "name": "12", "code": 12 }, { "name": "13", "code": 13 }, { "name": "7", "code": 7 }, { "name": "8", "code": 8 }, { "name": "9", "code": 9 }, { "name": "0", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SealRatingDescription", "type": "esriFieldTypeString", "alias": "Seal Rating Description", "length": 255, "domain": { "type": "codedValue", "name": "AsphaltSealRatingDescription", "description": "What is the description of the seal rating", "codedValues": [ { "name": "No Seal", "code": "No Seal" }, { "name": "Seal in Poor Condition", "code": "Seal in Poor Condition" }, { "name": "Seal in Fair Condition", "code": "Seal in Fair Condition" }, { "name": "Seal in Good Condition", "code": "Seal in Good Condition" }, { "name": "Newly Sealed or Asphalted", "code": "Newly Sealed or Asphalted" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SmoothnessRating", "type": "esriFieldTypeSmallInteger", "alias": "Smoothness Rating", "domain": { "type": "codedValue", "name": "AsphaltRatings", "description": "Asphalt Ratings from 1-5", "codedValues": [ { "name": "1", "code": 1 }, { "name": "2", "code": 2 }, { "name": "3", "code": 3 }, { "name": "4", "code": 4 }, { "name": "5", "code": 5 }, { "name": "6", "code": 6 }, { "name": "10", "code": 10 }, { "name": "11", "code": 11 }, { "name": "12", "code": 12 }, { "name": "13", "code": 13 }, { "name": "7", "code": 7 }, { "name": "8", "code": 8 }, { "name": "9", "code": 9 }, { "name": "0", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "SmoothnessRatingDescription", "type": "esriFieldTypeString", "alias": "Smoothness Rating Description", "length": 255, "domain": { "type": "codedValue", "name": "AsphaltSmoothnessRatingDescription", "description": "What is the description of the smoothness rating", "codedValues": [ { "name": "Rough and Needs Replacement", "code": "Rough and Needs Replacement" }, { "name": "Significant Bumps, Settling & Recurring Pot Holes", "code": "Significant Bumps, Settling & Recurring Pot Holes" }, { "name": "Moderate Bumps or Settling", "code": "Moderate Bumps or Settling" }, { "name": "Minor Bumps or Settling", "code": "Minor Bumps or Settling" }, { "name": "Smooth or New Asphalt", "code": "Smooth or New Asphalt" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "TotalRating", "type": "esriFieldTypeSmallInteger", "alias": "Total Rating", "domain": null } ], "indexes": [ { "name": "R104_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_199_RelatedG", "fields": "RelatedGlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 4, "name": "DBO.Asphalt", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "RelatedGlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C06E8828-6C00-4D8A-8EC2-0CD6D120CDE3}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Mountain Standard Time", "timeZoneIANA": "America/Denver", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Mountain Standard Time", "timeZoneIANA": "America/Denver", "respectsDaylightSaving": true }, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "204a0ae75bcc4381b550024a676bc212" }