{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 2, "name": "Crash_Vehicle", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "REPORTNUMBER", "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": "BODYTYPEVEH", "type": "esriFieldTypeInteger", "alias": "BodyTypeVeh_2024", "domain": null }, { "name": "LARGEVEHICLEBODYTYPE", "type": "esriFieldTypeInteger", "alias": "LargeVehicleBodyType_2024", "domain": null }, { "name": "VEHICLEID", "type": "esriFieldTypeString", "alias": "VehicleID", "length": 255, "domain": null }, { "name": "BARRIERTYPEDESCRIPTIONVEH", "type": "esriFieldTypeString", "alias": "BarrierTypeDescriptionVeh_2024", "length": 255, "domain": null }, { "name": "BARRIERTYPEVEH", "type": "esriFieldTypeInteger", "alias": "BarrierTypeVeh_2024", "domain": null }, { "name": "BODYTYPEVEHDESCRIPTION", "type": "esriFieldTypeString", "alias": "BodyTypeVehDescription", "length": 255, "domain": null }, { "name": "CARRIERSTATE", "type": "esriFieldTypeString", "alias": "CarrierState_2024", "length": 255, "domain": null }, { "name": "CARRIERTYPEDESCRIPTION", "type": "esriFieldTypeString", "alias": "CarrierTypeDescription", "length": 255, "domain": null }, { "name": "CARRIERZIPCODE", "type": "esriFieldTypeString", "alias": "CarrierZipCode_2024", "length": 255, "domain": null }, { "name": "CARRIERTYPE", "type": "esriFieldTypeInteger", "alias": "Carriertype_2024", "domain": null }, { "name": "DAMAGEDBYFIRE", "type": "esriFieldTypeString", "alias": "DamagedByFire", "length": 255, "domain": null }, { "name": "DAMAGEEXTENTVEH", "type": "esriFieldTypeInteger", "alias": "DamageExtentVeh_2024", "domain": null }, { "name": "DAMAGEEXTENTVEHDESCRIPTION", "type": "esriFieldTypeString", "alias": "DamageExtentVehDescription", "length": 255, "domain": null }, { "name": "DIVIDEDROADWAYVEH", "type": "esriFieldTypeInteger", "alias": "DividedRoadwayVeh_2024", "domain": null }, { "name": "DIVIDEDROADWAYVEHDESCRIPTION", "type": "esriFieldTypeString", "alias": "DividedRoadwayVehDescription_2024", "length": 255, "domain": null }, { "name": "DRIVERLESSVEH", "type": "esriFieldTypeString", "alias": "DriverlessVeh", "length": 255, "domain": null }, { "name": "EMERGENCYUSEVEH", "type": "esriFieldTypeInteger", "alias": "EmergencyUseVeh_2024", "domain": null }, { "name": "EMERGENCYUSEVEHDESCRIPTION", "type": "esriFieldTypeString", "alias": "EmergencyUseVehDescription", "length": 255, "domain": null }, { "name": "FIRSTIMPACTDESCRIPTION", "type": "esriFieldTypeString", "alias": "FirstImpactDescription", "length": 255, "domain": null }, { "name": "FIRSTIMPACTVEH", "type": "esriFieldTypeInteger", "alias": "FirstImpactVeh_2024", "domain": null }, { "name": "HASHAZMATONBOARD", "type": "esriFieldTypeString", "alias": "HashazmatOnboard_2024", "length": 255, "domain": null }, { "name": "HASTOWEDTRAILERVEH", "type": "esriFieldTypeString", "alias": "HasTowedTrailerVeh_2024", "length": 255, "domain": null }, { "name": "HAZMATCLASS", "type": "esriFieldTypeInteger", "alias": "HazmatClass", "domain": null }, { "name": "HAZMATCLASSDESCRIPTION", "type": "esriFieldTypeString", "alias": "HazmatClassDescription_2024", "length": 255, "domain": null }, { "name": "HAZMATPLACARDDISPLAYED", "type": "esriFieldTypeString", "alias": "HazmatPlacardDisplayed", "length": 255, "domain": null }, { "name": "HAZMATSPILL", "type": "esriFieldTypeString", "alias": "HazmatSpill", "length": 255, "domain": null }, { "name": "HIGHOCCUPANCYLANEVEH", "type": "esriFieldTypeInteger", "alias": "HighOccupancyLaneVeh_2024", "domain": null }, { "name": "HIGHOCCUPANYLANEDESCRIPTIONVEH", "type": "esriFieldTypeString", "alias": "HighOccupanyLaneDescriptionVeh_2024", "length": 255, "domain": null }, { "name": "HOVRELATEDVEH", "type": "esriFieldTypeString", "alias": "HOVRelatedVeh_2024", "length": 255, "domain": null }, { "name": "ISINSURED", "type": "esriFieldTypeString", "alias": "IsInsured_2024", "length": 255, "domain": null }, { "name": "ISPARKED", "type": "esriFieldTypeString", "alias": "IsParked", "length": 255, "domain": null }, { "name": "LANEDIRECTIONVEH", "type": "esriFieldTypeInteger", "alias": "LaneDirectionVeh_2024", "domain": null }, { "name": "LANEDIRECTIONVEHDESCRIPTION", "type": "esriFieldTypeString", "alias": "LaneDirectionVehDescription_2024", "length": 255, "domain": null }, { "name": "LANEVEHICLEINVEH", "type": "esriFieldTypeString", "alias": "LaneVehicleInVeh_2024", "length": 255, "domain": null }, { "name": "LANEVEHICLEINVEHDESCRIPTION", "type": "esriFieldTypeString", "alias": "LaneVehicleInVehDescription_2024", "length": 255, "domain": null }, { "name": "LARGEVEHICLEBODYTYPEDESCRIPTIO", "type": "esriFieldTypeString", "alias": "LargeVehicleBodyTypeDescription", "length": 255, "domain": null }, { "name": "LARGEVEHICLECONFIGURATION", "type": "esriFieldTypeInteger", "alias": "LargeVehicleConfiguration_2024", "domain": null }, { "name": "LARGEVEHICLECONFIGURATIONDESCR", "type": "esriFieldTypeString", "alias": "LargeVehicleConfigurationDescription", "length": 255, "domain": null }, { "name": "LARGEVEHICLENUMBEROFAXLES", "type": "esriFieldTypeInteger", "alias": "LargeVehicleNumberOfAxles", "domain": null }, { "name": "LEFTSCENEVEH", "type": "esriFieldTypeString", "alias": "LeftSceneVeh", "length": 255, "domain": null }, { "name": "MAKEVEH", "type": "esriFieldTypeString", "alias": "MakeVeh", "length": 255, "domain": null }, { "name": "MODELVEH", "type": "esriFieldTypeString", "alias": "ModelVeh", "length": 255, "domain": null }, { "name": "MOSTHARMFULEVENTVEH", "type": "esriFieldTypeInteger", "alias": "MostHarmfulEventVeh_2024", "domain": null }, { "name": "MOSTHARMFULEVENTVEHDESCRIPTION", "type": "esriFieldTypeString", "alias": "MostHarmfulEventVehDescription", "length": 255, "domain": null }, { "name": "MOVEMENTVEH", "type": "esriFieldTypeInteger", "alias": "MovementVeh_2024", "domain": null }, { "name": "MOVEMENTVEHDESCRIPTION", "type": "esriFieldTypeString", "alias": "MovementVehDescription", "length": 255, "domain": null }, { "name": "NUMBEROFAUXILIARYLANESVEH", "type": "esriFieldTypeInteger", "alias": "NumberOfAuxiliaryLanesVeh_2024", "domain": null }, { "name": "NUMBEROFTHROUGHLANESVEH", "type": "esriFieldTypeInteger", "alias": "NumberOfThroughLanesVeh_2024", "domain": null }, { "name": "PERMITTEDLOAD", "type": "esriFieldTypeString", "alias": "PermittedLoad_2024", "length": 255, "domain": null }, { "name": "REGISTRATIONSTATEVEH", "type": "esriFieldTypeString", "alias": "RegistrationStateVeh_2024", "length": 255, "domain": null }, { "name": "REPORTNUMBERVEH", "type": "esriFieldTypeString", "alias": "ReportNumberVeh", "length": 255, "domain": null }, { "name": "ROADALIGNMENTVEH", "type": "esriFieldTypeInteger", "alias": "RoadAlignmentVeh_2024", "domain": null }, { "name": "ROADALIGNMENTVEHDESCRIPTION", "type": "esriFieldTypeString", "alias": "RoadAlignmentVehDescription_2024", "length": 255, "domain": null }, { "name": "ROADGRADEVEH", "type": "esriFieldTypeInteger", "alias": "RoadGradeVeh_2024", "domain": null }, { "name": "ROADGRADEVEHDESCRIPTION", "type": "esriFieldTypeString", "alias": "RoadGradeVehDescription_2024", "length": 255, "domain": null }, { "name": "SPECIALFUNCTIONVEH", "type": "esriFieldTypeInteger", "alias": "SpecialFunctionVeh_2024", "domain": null }, { "name": "SPECIALFUNCTIONVEHDESCRIPTION", "type": "esriFieldTypeString", "alias": "SpecialFunctionVehDescription", "length": 255, "domain": null }, { "name": "SPEEDLIMITVEH", "type": "esriFieldTypeInteger", "alias": "SpeedLimitVeh", "domain": null }, { "name": "TOWEDAWAYVEH", "type": "esriFieldTypeString", "alias": "TowedAwayVeh_2024", "length": 255, "domain": null }, { "name": "TOWEDTYPEVEH", "type": "esriFieldTypeInteger", "alias": "TowedTypeVeh_2024", "domain": null }, { "name": "TOWEDTYPEVEHDESCRIPTION", "type": "esriFieldTypeString", "alias": "TowedTypeVehDescription", "length": 255, "domain": null }, { "name": "TRAVELDIRECTIONVEH", "type": "esriFieldTypeInteger", "alias": "TravelDirectionVeh_2024", "domain": null }, { "name": "TRAVELDIRECTIONVEHDESCRIPTION", "type": "esriFieldTypeString", "alias": "TravelDirectionVehDescription", "length": 255, "domain": null }, { "name": "UNITNUMBERVEH", "type": "esriFieldTypeInteger", "alias": "UnitnumberVeh", "domain": null }, { "name": "UNKNOWNVEHICLEVEH", "type": "esriFieldTypeString", "alias": "UnknownVehicleVeh_2024", "length": 255, "domain": null }, { "name": "VINVEH", "type": "esriFieldTypeString", "alias": "VINVeh", "length": 255, "domain": null }, { "name": "YEARVEH", "type": "esriFieldTypeInteger", "alias": "YearVeh", "domain": null }, { "name": "COMMERCIALGVW", "type": "esriFieldTypeString", "alias": "CommercialGVW_2019_2023", "length": 25, "domain": null }, { "name": "COMMERCIALHAZMATNUMBER", "type": "esriFieldTypeString", "alias": "CommercialHazmatNumber_2019_2023", "length": 10, "domain": null }, { "name": "CONTINUEDIRECTION", "type": "esriFieldTypeString", "alias": "Continuedirection_2019_2023", "length": 1, "domain": null }, { "name": "MAINIMPACT", "type": "esriFieldTypeString", "alias": "Mainimpact_2019_2023", "length": 520, "domain": null }, { "name": "VEHICLEBUSUSE", "type": "esriFieldTypeString", "alias": "VehicleBusUse_2019_2023", "length": 15, "domain": null }, { "name": "MERGE_SRC", "type": "esriFieldTypeString", "alias": "MERGE_SRC", "length": 255, "domain": null }, { "name": "EMERGENCYMOTORVEHICLEUSE", "type": "esriFieldTypeString", "alias": "Emergencymotorvehicleuse_2019_2023", "length": 10, "domain": null } ], "indexes": [ { "name": "G68165REPORTNUMB", "fields": "REPORTNUMBER", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I68165BODYTYPEVE", "fields": "BODYTYPEVEHDESCRIPTION", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I68165CRASHSEVER", "fields": "CRASHSEVERITYDESCRIPTION", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I68165FIRSTIMPAC", "fields": "FIRSTIMPACTDESCRIPTION", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I68165MOSTHARMFU", "fields": "MOSTHARMFULEVENTVEHDESCRIPTION", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I68165MOVEMENTVE", "fields": "MOVEMENTVEHDESCRIPTION", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I68165TRAVELDIRE", "fields": "TRAVELDIRECTIONVEHDESCRIPTION", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I68165VEHICLEID", "fields": "VEHICLEID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R396295_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Crash_Report", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "REPORTNUMBER", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{2C07B06C-9E65-4ACF-BDFB-E73FCF80F88C}" } ], "capabilities": "Map,Query,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 } }