{
 "currentVersion": 11.2,
 "cimVersion": "3.2.0",
 "id": 3,
 "name": "DDOTSGIS.BRIDGE.INSPEVNT",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "INSPNAME",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "BRKEY",
   "type": "esriFieldTypeString",
   "alias": "BRKEY",
   "length": 15,
   "domain": null
  },
  {
   "name": "INSPKEY",
   "type": "esriFieldTypeString",
   "alias": "INSPKEY",
   "length": 4,
   "domain": null
  },
  {
   "name": "INSPDATE",
   "type": "esriFieldTypeDate",
   "alias": "INSPDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "INSPNAME",
   "type": "esriFieldTypeString",
   "alias": "INSPNAME",
   "length": 24,
   "domain": null
  },
  {
   "name": "INSPUSRKEY",
   "type": "esriFieldTypeString",
   "alias": "INSPUSRKEY",
   "length": 4,
   "domain": null
  },
  {
   "name": "REV_REQ",
   "type": "esriFieldTypeString",
   "alias": "REV_REQ",
   "length": 1,
   "domain": null
  },
  {
   "name": "DET_UPD",
   "type": "esriFieldTypeString",
   "alias": "DET_UPD",
   "length": 1,
   "domain": null
  },
  {
   "name": "INSPECTCONTROLID",
   "type": "esriFieldTypeString",
   "alias": "INSPECTCONTROLID",
   "length": 20,
   "domain": null
  },
  {
   "name": "NBINSPDONE",
   "type": "esriFieldTypeString",
   "alias": "NBINSPDONE",
   "length": 1,
   "domain": null
  },
  {
   "name": "BRINSPFREQ",
   "type": "esriFieldTypeSmallInteger",
   "alias": "BRINSPFREQ",
   "domain": null
  },
  {
   "name": "LASTINSP",
   "type": "esriFieldTypeDate",
   "alias": "LASTINSP",
   "length": 8,
   "domain": null
  },
  {
   "name": "NEXTINSP",
   "type": "esriFieldTypeDate",
   "alias": "NEXTINSP",
   "length": 8,
   "domain": null
  },
  {
   "name": "ELINSPDONE",
   "type": "esriFieldTypeString",
   "alias": "ELINSPDONE",
   "length": 1,
   "domain": null
  },
  {
   "name": "ELINSPFREQ",
   "type": "esriFieldTypeSmallInteger",
   "alias": "ELINSPFREQ",
   "domain": null
  },
  {
   "name": "ELINSPDATE",
   "type": "esriFieldTypeDate",
   "alias": "ELINSPDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "ELNEXTDATE",
   "type": "esriFieldTypeDate",
   "alias": "ELNEXTDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "UWINSPREQ",
   "type": "esriFieldTypeString",
   "alias": "UWINSPREQ",
   "length": 1,
   "domain": null
  },
  {
   "name": "UWINSPDONE",
   "type": "esriFieldTypeString",
   "alias": "UWINSPDONE",
   "length": 1,
   "domain": null
  },
  {
   "name": "UWINSPFREQ",
   "type": "esriFieldTypeSmallInteger",
   "alias": "UWINSPFREQ",
   "domain": null
  },
  {
   "name": "UWLASTINSP",
   "type": "esriFieldTypeDate",
   "alias": "UWLASTINSP",
   "length": 8,
   "domain": null
  },
  {
   "name": "UWNEXTDATE",
   "type": "esriFieldTypeDate",
   "alias": "UWNEXTDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "FCINSPREQ",
   "type": "esriFieldTypeString",
   "alias": "FCINSPREQ",
   "length": 1,
   "domain": null
  },
  {
   "name": "FCINSPDONE",
   "type": "esriFieldTypeString",
   "alias": "FCINSPDONE",
   "length": 1,
   "domain": null
  },
  {
   "name": "FCINSPFREQ",
   "type": "esriFieldTypeSmallInteger",
   "alias": "FCINSPFREQ",
   "domain": null
  },
  {
   "name": "FCLASTINSP",
   "type": "esriFieldTypeDate",
   "alias": "FCLASTINSP",
   "length": 8,
   "domain": null
  },
  {
   "name": "FCNEXTDATE",
   "type": "esriFieldTypeDate",
   "alias": "FCNEXTDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "OSINSPREQ",
   "type": "esriFieldTypeString",
   "alias": "OSINSPREQ",
   "length": 1,
   "domain": null
  },
  {
   "name": "OSINSPDONE",
   "type": "esriFieldTypeString",
   "alias": "OSINSPDONE",
   "length": 1,
   "domain": null
  },
  {
   "name": "OSINSPFREQ",
   "type": "esriFieldTypeSmallInteger",
   "alias": "OSINSPFREQ",
   "domain": null
  },
  {
   "name": "OSLASTINSP",
   "type": "esriFieldTypeDate",
   "alias": "OSLASTINSP",
   "length": 8,
   "domain": null
  },
  {
   "name": "OSNEXTDATE",
   "type": "esriFieldTypeDate",
   "alias": "OSNEXTDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "IETRIGGER",
   "type": "esriFieldTypeString",
   "alias": "IETRIGGER",
   "length": 1,
   "domain": null
  },
  {
   "name": "APPRDATE",
   "type": "esriFieldTypeDate",
   "alias": "APPRDATE",
   "length": 8,
   "domain": null
  },
  {
   "name": "RAILRATING",
   "type": "esriFieldTypeString",
   "alias": "RAILRATING",
   "length": 1,
   "domain": null
  },
  {
   "name": "TRANSRATIN",
   "type": "esriFieldTypeString",
   "alias": "TRANSRATIN",
   "length": 1,
   "domain": null
  },
  {
   "name": "ARAILRATIN",
   "type": "esriFieldTypeString",
   "alias": "ARAILRATIN",
   "length": 1,
   "domain": null
  },
  {
   "name": "AENDRATING",
   "type": "esriFieldTypeString",
   "alias": "AENDRATING",
   "length": 1,
   "domain": null
  },
  {
   "name": "OPPOSTCL",
   "type": "esriFieldTypeString",
   "alias": "OPPOSTCL",
   "length": 1,
   "domain": null
  },
  {
   "name": "DECKGEOM",
   "type": "esriFieldTypeString",
   "alias": "DECKGEOM",
   "length": 1,
   "domain": null
  },
  {
   "name": "UNDERCLR",
   "type": "esriFieldTypeString",
   "alias": "UNDERCLR",
   "length": 1,
   "domain": null
  },
  {
   "name": "WATERADEQ",
   "type": "esriFieldTypeString",
   "alias": "WATERADEQ",
   "length": 1,
   "domain": null
  },
  {
   "name": "PIERPROT",
   "type": "esriFieldTypeString",
   "alias": "PIERPROT",
   "length": 1,
   "domain": null
  },
  {
   "name": "SCOURCRIT",
   "type": "esriFieldTypeString",
   "alias": "SCOURCRIT",
   "length": 1,
   "domain": null
  },
  {
   "name": "APPRALIGN",
   "type": "esriFieldTypeString",
   "alias": "APPRALIGN",
   "length": 1,
   "domain": null
  },
  {
   "name": "DKRATING",
   "type": "esriFieldTypeString",
   "alias": "DKRATING",
   "length": 1,
   "domain": null
  },
  {
   "name": "SUPRATING",
   "type": "esriFieldTypeString",
   "alias": "SUPRATING",
   "length": 1,
   "domain": null
  },
  {
   "name": "SUBRATING",
   "type": "esriFieldTypeString",
   "alias": "SUBRATING",
   "length": 1,
   "domain": null
  },
  {
   "name": "CHANRATING",
   "type": "esriFieldTypeString",
   "alias": "CHANRATING",
   "length": 1,
   "domain": null
  },
  {
   "name": "CULVRATING",
   "type": "esriFieldTypeString",
   "alias": "CULVRATING",
   "length": 1,
   "domain": null
  },
  {
   "name": "STRRATING",
   "type": "esriFieldTypeString",
   "alias": "STRRATING",
   "length": 1,
   "domain": null
  },
  {
   "name": "NBI_RATING",
   "type": "esriFieldTypeString",
   "alias": "NBI_RATING",
   "length": 1,
   "domain": null
  },
  {
   "name": "SUFF_RATE",
   "type": "esriFieldTypeSingle",
   "alias": "SUFF_RATE",
   "domain": null
  },
  {
   "name": "SUFF_PREFX",
   "type": "esriFieldTypeString",
   "alias": "SUFF_PREFX",
   "length": 1,
   "domain": null
  },
  {
   "name": "INSPTYPE",
   "type": "esriFieldTypeString",
   "alias": "INSPTYPE",
   "length": 1,
   "domain": null
  },
  {
   "name": "INSPSTAT",
   "type": "esriFieldTypeString",
   "alias": "INSPSTAT",
   "length": 1,
   "domain": null
  },
  {
   "name": "DECKDISTR",
   "type": "esriFieldTypeDouble",
   "alias": "DECKDISTR",
   "domain": null
  },
  {
   "name": "BITRIGGER",
   "type": "esriFieldTypeString",
   "alias": "BITRIGGER",
   "length": 1,
   "domain": null
  },
  {
   "name": "RECWORKFLG",
   "type": "esriFieldTypeString",
   "alias": "RECWORKFLG",
   "length": 1,
   "domain": null
  },
  {
   "name": "CREATEDATETIME",
   "type": "esriFieldTypeDate",
   "alias": "CREATEDATETIME",
   "length": 8,
   "domain": null
  },
  {
   "name": "CREATEUSERKEY",
   "type": "esriFieldTypeString",
   "alias": "CREATEUSERKEY",
   "length": 32,
   "domain": null
  },
  {
   "name": "MODTIME",
   "type": "esriFieldTypeDate",
   "alias": "MODTIME",
   "length": 8,
   "domain": null
  },
  {
   "name": "USERKEY",
   "type": "esriFieldTypeString",
   "alias": "USERKEY",
   "length": 32,
   "domain": null
  },
  {
   "name": "DOCREFKEY",
   "type": "esriFieldTypeString",
   "alias": "DOCREFKEY",
   "length": 255,
   "domain": null
  },
  {
   "name": "NOTES",
   "type": "esriFieldTypeString",
   "alias": "NOTES",
   "length": 3999,
   "domain": null
  },
  {
   "name": "ELEMCONVERT",
   "type": "esriFieldTypeString",
   "alias": "ELEMCONVERT",
   "length": 1,
   "domain": null
  },
  {
   "name": "INSPEVNT_GD",
   "type": "esriFieldTypeString",
   "alias": "INSPEVNT_GD",
   "length": 32,
   "domain": null
  },
  {
   "name": "INSPEVNT_LB",
   "type": "esriFieldTypeString",
   "alias": "INSPEVNT_LB",
   "length": 50,
   "domain": null
  },
  {
   "name": "BRIDGE_GD",
   "type": "esriFieldTypeString",
   "alias": "BRIDGE_GD",
   "length": 32,
   "domain": null
  },
  {
   "name": "OSTYPE",
   "type": "esriFieldTypeString",
   "alias": "OSTYPE",
   "length": 255,
   "domain": null
  },
  {
   "name": "SCHEDULE_NOTES",
   "type": "esriFieldTypeString",
   "alias": "SCHEDULE_NOTES",
   "length": 3999,
   "domain": null
  },
  {
   "name": "ENGINEER_OF_RECORD",
   "type": "esriFieldTypeString",
   "alias": "ENGINEER_OF_RECORD",
   "length": 128,
   "domain": null
  },
  {
   "name": "DATE_ENTERED",
   "type": "esriFieldTypeDate",
   "alias": "DATE_ENTERED",
   "length": 8,
   "domain": null
  },
  {
   "name": "INSPUSRGUID",
   "type": "esriFieldTypeString",
   "alias": "INSPUSRGUID",
   "length": 32,
   "domain": null
  },
  {
   "name": "ENTERED_BY_GD",
   "type": "esriFieldTypeString",
   "alias": "ENTERED_BY_GD",
   "length": 32,
   "domain": null
  },
  {
   "name": "BRIDGE_CONDITION",
   "type": "esriFieldTypeString",
   "alias": "BRIDGE_CONDITION",
   "length": 1,
   "domain": null
  },
  {
   "name": "HEALTH_INDEX",
   "type": "esriFieldTypeSingle",
   "alias": "HEALTH_INDEX",
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R587_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "I16860INSPEVNT_G",
   "fields": "INSPEVNT_GD",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_16860_BRKEY",
   "fields": "BRKEY",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 1,
   "name": "BRMBridgeLines",
   "relatedTableId": 2,
   "role": "esriRelRoleDestination",
   "keyField": "BRKEY",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true,
   "catalogID": "{B56FDA44-3CED-4D6B-BA37-FD0950D880E0}"
  }
 ],
 "capabilities": "Data,Map,Query",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "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,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": {
  "timeZone": "Eastern Standard Time",
  "respectsDaylightSaving": true
 },
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 }
}