{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 5, "name": "Crash_Occupants", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CRASHSEVERITYDESCRIPTION", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CRASHSEVERITYDESCRIPTION", "type": "esriFieldTypeString", "alias": "CrashSeverityDescription", "length": 255, "domain": null }, { "name": "REPORTNUMBER", "type": "esriFieldTypeString", "alias": "Reportnumber", "length": 255, "domain": null }, { "name": "DRUGRESULTOCC", "type": "esriFieldTypeString", "alias": "DrugResultOcc", "length": 255, "domain": null }, { "name": "PERSONIDOCC", "type": "esriFieldTypeString", "alias": "PersonIDOcc", "length": 255, "domain": null }, { "name": "SUSPECTSALCOHOLUSEOCC", "type": "esriFieldTypeString", "alias": "SuspectsAlcoholUseOcc_2024", "length": 255, "domain": null }, { "name": "SUSPECTSDRUGUSEOCC", "type": "esriFieldTypeString", "alias": "SuspectsDrugUseOcc_2024", "length": 255, "domain": null }, { "name": "BACOCC", "type": "esriFieldTypeDouble", "alias": "BACOcc", "domain": null }, { "name": "PRELIMINARYTESTRESULTOCC", "type": "esriFieldTypeDouble", "alias": "PreliminaryTestResultOcc_2024", "domain": null }, { "name": "AGEOCC", "type": "esriFieldTypeInteger", "alias": "AgeOcc", "domain": null }, { "name": "AIRBAGDEPLOYEDOCC", "type": "esriFieldTypeString", "alias": "AirbagDeployedOcc", "length": 255, "domain": null }, { "name": "ALCOHOLTESTSTATUSOCCDESCRIPTIO", "type": "esriFieldTypeString", "alias": "AlcoholTestStatusOccDescription", "length": 255, "domain": null }, { "name": "ALCOHOLTESTTYPEOCCDESCRIPTION", "type": "esriFieldTypeString", "alias": "AlcoholTestTypeOccDescription", "length": 255, "domain": null }, { "name": "CITYOCC", "type": "esriFieldTypeString", "alias": "CityOcc_2024", "length": 255, "domain": null }, { "name": "CONDITIONBEFORECRASH", "type": "esriFieldTypeString", "alias": "ConditionBeforeCrash", "length": 255, "domain": null }, { "name": "DISTRACTEDBYACTIONOCCDESCRIPTI", "type": "esriFieldTypeString", "alias": "DistractedByActionOccDescription_2024", "length": 255, "domain": null }, { "name": "DISTRACTEDBYSOURCEOCCDESCRIPTI", "type": "esriFieldTypeString", "alias": "DistractedBySourceOccDescription_2024", "length": 255, "domain": null }, { "name": "DLSTATEOCC", "type": "esriFieldTypeString", "alias": "DLStateOcc_2024", "length": 255, "domain": null }, { "name": "DLSTATEOCCDESCRIPTION", "type": "esriFieldTypeString", "alias": "DLStateOccDescription_2024", "length": 255, "domain": null }, { "name": "DRUGTESTSTATUSOCCDESCRIPTION", "type": "esriFieldTypeString", "alias": "DrugTestStatusOccDescription", "length": 255, "domain": null }, { "name": "DRUGTESTTYPEOCCDESCRIPTION", "type": "esriFieldTypeString", "alias": "DrugTestTypeOccDescription_2024", "length": 255, "domain": null }, { "name": "EJECTIONOCCDESCRIPTION", "type": "esriFieldTypeString", "alias": "EjectionOccDescription", "length": 255, "domain": null }, { "name": "EMSUNITOCC", "type": "esriFieldTypeString", "alias": "EMSUnitOcc_2024", "length": 255, "domain": null }, { "name": "GENDEROCC", "type": "esriFieldTypeString", "alias": "GenderOcc", "length": 255, "domain": null }, { "name": "HELMETDOTCOMPLIANT", "type": "esriFieldTypeString", "alias": "HelmetDOTCompliant_2024", "length": 255, "domain": null }, { "name": "HELMETTYPEOCCDESCRIPTION", "type": "esriFieldTypeString", "alias": "HelmetTypeOccDescription_2024", "length": 255, "domain": null }, { "name": "INCIDENTRESPONDEROCCDESCRIPTIO", "type": "esriFieldTypeString", "alias": "IncidentResponderOccDescription_2024", "length": 255, "domain": null }, { "name": "INJURYSTATUSOCCDESCRIPTION", "type": "esriFieldTypeString", "alias": "InjuryStatusOccDescription", "length": 255, "domain": null }, { "name": "OCCUPANTUNKNOWN", "type": "esriFieldTypeString", "alias": "OccupantUnknown_2024", "length": 255, "domain": null }, { "name": "PRELIMINARYTESTGIVENOCC", "type": "esriFieldTypeString", "alias": "PreliminaryTestGivenOcc_2024", "length": 255, "domain": null }, { "name": "REPORTNUMBEROCC", "type": "esriFieldTypeString", "alias": "ReportNumberOcc", "length": 255, "domain": null }, { "name": "RESTRAINTOCCDESCRIPTION", "type": "esriFieldTypeString", "alias": "RestraintOccDescription", "length": 255, "domain": null }, { "name": "SAFETYEQUIPMENTIMPROPERLYUSED", "type": "esriFieldTypeString", "alias": "SafetyEquipmentImproperlyUsed_2024", "length": 255, "domain": null }, { "name": "SEATINGLOCATIONOCCDESCRIPTION", "type": "esriFieldTypeString", "alias": "SeatingLocationOccDescription", "length": 255, "domain": null }, { "name": "SEATINGROWOCC", "type": "esriFieldTypeInteger", "alias": "SeatingRowOcc", "domain": null }, { "name": "STATEOCC", "type": "esriFieldTypeString", "alias": "StateOcc_2024", "length": 255, "domain": null }, { "name": "TYPEOFOCCUPANTDESCRIPTION", "type": "esriFieldTypeString", "alias": "TypeOfOccupantDescription", "length": 255, "domain": null }, { "name": "VEHICLEIDOCC", "type": "esriFieldTypeString", "alias": "VehicleIDOcc", "length": 255, "domain": null }, { "name": "ZIPCODEOCC", "type": "esriFieldTypeString", "alias": "ZipCodeOcc_2024", "length": 255, "domain": null }, { "name": "DRIVERCONDITION", "type": "esriFieldTypeString", "alias": "DriverCondition_2019_2023", "length": 50, "domain": null }, { "name": "DRIVERDISTRACTEDBY", "type": "esriFieldTypeString", "alias": "Driverdistractedby_2019_2023", "length": 60, "domain": null }, { "name": "DRIVERDOB", "type": "esriFieldTypeDate", "alias": "DriverDOB_temp", "length": 8, "domain": null }, { "name": "DRIVEREQUIPMENTPROBLEM", "type": "esriFieldTypeString", "alias": "DriverEquipmentProblem_2019_2023", "length": 25, "domain": null }, { "name": "DRIVERHASCDL", "type": "esriFieldTypeString", "alias": "DriverHasCDL_2019_2023", "length": 1, "domain": null }, { "name": "DRIVERSUBSTANCEUSE", "type": "esriFieldTypeString", "alias": "DriverSubstanceUse_2019_2023", "length": 35, "domain": null }, { "name": "MERGE_SRC", "type": "esriFieldTypeString", "alias": "MERGE_SRC", "length": 255, "domain": null } ], "indexes": [ { "name": "G23687REPORTNUMB", "fields": "REPORTNUMBER", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I23687VEHICLEIDO", "fields": "VEHICLEIDOCC", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R2520353_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "Crash_Report", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Reportnumber", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{7F475B40-8C63-4929-BEB5-85BFEEA624A5}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "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 }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }