{
 "currentVersion": 11.5,
 "cimVersion": "3.5.0",
 "id": 95,
 "name": "Asphalt Event History Related Table",
 "type": "Table",
 "description": "",
 "copyrightText": "",
 "editFieldsInfo": null,
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": false,
 "relationships": [
  {
   "id": 4,
   "name": "DBO.Asphalt",
   "relatedTableId": 1,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "RelatedGlobalID",
   "composite": false,
   "catalogID": "{C06E8828-6C00-4D8A-8EC2-0CD6D120CDE3}"
  }
 ],
 "isDataVersioned": true,
 "isDataArchived": false,
 "isDataBranchVersioned": false,
 "isDataReplicaTracked": false,
 "isCoGoEnabled": false,
 "supportsRollbackOnFailureParameter": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportsValidateSQL": true,
 "supportsCoordinatesQuantization": false,
 "supportsCalculate": true,
 "supportsASyncCalculate": true,
 "advancedQueryCapabilities": {
  "supportsPagination": true,
  "supportsQueryWithDistance": true,
  "supportsReturningQueryExtent": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsCurrentUserQueries": true,
  "supportsFullTextSearch": true,
  "fullTextSearchCapabilities": {
   "supportsSearchOperator": true,
   "supportsOperator": false,
   "supportsSqlExpressionInFullText": true
  },
  "fullTextSearchableFields": [],
  "supportsQueryWithResultType": true,
  "supportsReturningGeometryCentroid": false,
  "supportsReturningGeometryEnvelope": false,
  "supportsSqlExpression": true,
  "supportsLod": false,
  "supportsQueryWithLodSR": false,
  "supportsQueryAnalytic": true,
  "supportsQueryWithCacheHint": false
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": true,
  "supportsPercentileAnalytic": true
 },
 "advancedEditingCapabilities": {
  "supportedSqlFormatsInCalculate": [
   "standard"
  ],
  "supportsAsyncApplyEdits": true,
  "supportsApplyEditsbyUploadID": true,
  "supportedApplyEditsUploadIDFormats": "JSON,PBF"
 },
 "hasMetadata": true,
 "hasAttachments": false,
 "supportsApplyEditsWithGlobalIds": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "objectIdField": "OBJECTID",
 "globalIdField": "",
 "displayField": "EventType",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null,
   "modelName": "OBJECTID"
  },
  {
   "name": "RelatedGlobalID",
   "type": "esriFieldTypeGUID",
   "alias": "RelatedGlobalID",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 38,
   "defaultValue": null,
   "modelName": "RelatedGlobalID"
  },
  {
   "name": "EventType",
   "type": "esriFieldTypeString",
   "alias": "Event Type",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "EventType"
  },
  {
   "name": "EventDate",
   "type": "esriFieldTypeDate",
   "alias": "Event Date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "EventDate"
  },
  {
   "name": "WorkDoneBy",
   "type": "esriFieldTypeString",
   "alias": "Work Done By",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "WorkDoneBy"
  },
  {
   "name": "MaintenanceType",
   "type": "esriFieldTypeString",
   "alias": "Maintenance Type",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "MaintenanceType"
  },
  {
   "name": "AreaSqFt",
   "type": "esriFieldTypeDouble",
   "alias": "Area (sqft)",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "AreaSqFt"
  },
  {
   "name": "Class",
   "type": "esriFieldTypeString",
   "alias": "Class",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Class"
  },
  {
   "name": "Notes",
   "type": "esriFieldTypeString",
   "alias": "Notes",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "Notes"
  },
  {
   "name": "LinkedFiles",
   "type": "esriFieldTypeString",
   "alias": "Linked Files",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "LinkedFiles"
  },
  {
   "name": "OverlayTons",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Overlay (tons)",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "OverlayTons"
  },
  {
   "name": "LaneLevelingTons",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Lane Leveling (tons)",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "LaneLevelingTons"
  },
  {
   "name": "TreesTrimmed",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Trees Trimmed",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "TreesTrimmed"
  },
  {
   "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"
   },
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "CrackRating"
  },
  {
   "name": "CrackRatingDescription",
   "type": "esriFieldTypeString",
   "alias": "Crack Rating Description",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "CrackRatingDescription"
  },
  {
   "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"
   },
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "CrackSealRating"
  },
  {
   "name": "CrackSealDescription",
   "type": "esriFieldTypeString",
   "alias": "Crack Seal Description",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "CrackSealDescription"
  },
  {
   "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"
   },
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "SealRating"
  },
  {
   "name": "SealRatingDescription",
   "type": "esriFieldTypeString",
   "alias": "Seal Rating Description",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "SealRatingDescription"
  },
  {
   "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"
   },
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "SmoothnessRating"
  },
  {
   "name": "SmoothnessRatingDescription",
   "type": "esriFieldTypeString",
   "alias": "Smoothness Rating Description",
   "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"
   },
   "editable": true,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "SmoothnessRatingDescription"
  },
  {
   "name": "TotalRating",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Total Rating",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": 1,
   "modelName": "TotalRating"
  }
 ],
 "indexes": [
  {
   "name": "R104_SDE_ROWID_UK",
   "isAscending": true,
   "isUnique": true,
   "description": "",
   "fields": "OBJECTID"
  },
  {
   "name": "GDB_199_RelatedG",
   "isAscending": true,
   "isUnique": false,
   "description": "",
   "fields": "RelatedGlobalID"
  }
 ],
 "datesInUnknownTimezone": false,
 "dateFieldsTimeReference": {
  "timeZone": "Mountain Standard Time",
  "timeZoneIANA": "America/Denver",
  "respectsDaylightSaving": true
 },
 "preferredTimeReference": {
  "timeZone": "Mountain Standard Time",
  "timeZoneIANA": "America/Denver",
  "respectsDaylightSaving": true
 },
 "types": [],
 "templates": [
  {
   "name": "Asphalt Event History Related Table",
   "description": "",
   "prototype": {
    "attributes": {
     "SmoothnessRatingDescription": null,
     "TotalRating": 1,
     "RelatedGlobalID": null,
     "EventType": null,
     "EventDate": null,
     "WorkDoneBy": null,
     "MaintenanceType": null,
     "AreaSqFt": null,
     "Class": null,
     "Notes": null,
     "LinkedFiles": null,
     "OverlayTons": null,
     "LaneLevelingTons": null,
     "TreesTrimmed": null,
     "CrackRating": null,
     "CrackRatingDescription": null,
     "CrackSealRating": null,
     "CrackSealDescription": null,
     "SealRating": null,
     "SealRatingDescription": null,
     "SmoothnessRating": 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,
 "supportsAppend": true,
 "supportedAppendFormats": "FILEGDB,PBF",
 "standardMaxRecordCount": 32000,
 "tileMaxRecordCount": 2000,
 "maxRecordCountFactor": 1,
 "serviceItemId": "d2ec778d35a34e2a96f2cb49e173adad"
}