{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 4, "name": "Crash_NonMotorist", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 2, "name": "Crash_Report", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "REPORTNUMBER", "composite": false, "catalogID": "{5BE9B93D-5CD1-4953-AF78-B1464EBDAE76}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "REPORTNUMBER", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "System-maintained ObjectID" }, { "name": "CRASHSEVERITYDESCRIPTION", "type": "esriFieldTypeString", "alias": "CrashSeverityDescription", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CRASHSEVERITYDESCRIPTION" }, { "name": "REPORTNUMBER", "type": "esriFieldTypeString", "alias": "Reportnumber", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "REPORTNUMBER" }, { "name": "TYPENMDESCRIPTION", "type": "esriFieldTypeString", "alias": "TypeNMDescription", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TYPENMDESCRIPTION" }, { "name": "PERSONIDNM", "type": "esriFieldTypeString", "alias": "PersonIDNM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PERSONIDNM" }, { "name": "ACTIONPRIORTOCRASHNM", "type": "esriFieldTypeInteger", "alias": "ActionPriorToCrashNM_2024", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ACTIONPRIORTOCRASHNM" }, { "name": "ACTIONPRIORTOCRASHNMDESCRIPTIO", "type": "esriFieldTypeString", "alias": "ActionPriorToCrashNMDescription", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ACTIONPRIORTOCRASHNMDESCRIPTIO" }, { "name": "AGENM", "type": "esriFieldTypeInteger", "alias": "AgeNM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AGENM" }, { "name": "CITYNM", "type": "esriFieldTypeString", "alias": "CityNM_2024", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CITYNM" }, { "name": "CONTACTPOINTNM", "type": "esriFieldTypeInteger", "alias": "ContactPointNM_2024", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CONTACTPOINTNM" }, { "name": "CONTACTPOINTNMDESCRIPTION", "type": "esriFieldTypeString", "alias": "ContactPointNMDescription_2024", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CONTACTPOINTNMDESCRIPTION" }, { "name": "DISTRACTEDBYACTIONNM", "type": "esriFieldTypeInteger", "alias": "DistractedByActionNM_2024", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DISTRACTEDBYACTIONNM" }, { "name": "DISTRACTEDBYACTIONNMDESCRIPTIO", "type": "esriFieldTypeString", "alias": "DistractedByActionNMDescription_2024", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DISTRACTEDBYACTIONNMDESCRIPTIO" }, { "name": "DISTRACTEDBYSOURCE", "type": "esriFieldTypeInteger", "alias": "DistractedBySource_2024", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DISTRACTEDBYSOURCE" }, { "name": "DISTRACTEDBYSOURCEDESCRIPTION", "type": "esriFieldTypeString", "alias": "DistractedBySourceDescription_2024", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DISTRACTEDBYSOURCEDESCRIPTION" }, { "name": "GENDERNM", "type": "esriFieldTypeString", "alias": "GenderNM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "GENDERNM" }, { "name": "INCIDENTRESPONDERNM", "type": "esriFieldTypeInteger", "alias": "IncidentResponderNM_2024", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INCIDENTRESPONDERNM" }, { "name": "INCIDENTRESPONDERNMDESCRIPTION", "type": "esriFieldTypeString", "alias": "IncidentResponderNMDescription_2024", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "INCIDENTRESPONDERNMDESCRIPTION" }, { "name": "INJURYSTATUSNM", "type": "esriFieldTypeInteger", "alias": "InjuryStatusNM_2024", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INJURYSTATUSNM" }, { "name": "INJURYSTATUSNMDESCRIPTION", "type": "esriFieldTypeString", "alias": "InjuryStatusNMDescription", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "INJURYSTATUSNMDESCRIPTION" }, { "name": "LOCATIONNM", "type": "esriFieldTypeInteger", "alias": "LocationNM_2024", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LOCATIONNM" }, { "name": "LOCATIONNMDESCRIPTION", "type": "esriFieldTypeString", "alias": "LocationNMDescription", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LOCATIONNMDESCRIPTION" }, { "name": "ORIGINDESTINATIONNM", "type": "esriFieldTypeInteger", "alias": "OriginDestinationNM_2024", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ORIGINDESTINATIONNM" }, { "name": "ORIGINDESTINATIONNMDESCRIPTION", "type": "esriFieldTypeString", "alias": "OriginDestinationNMDescription_2024", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ORIGINDESTINATIONNMDESCRIPTION" }, { "name": "REPORTNUMBERNM", "type": "esriFieldTypeString", "alias": "ReportNumberNM", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "REPORTNUMBERNM" }, { "name": "STATENM", "type": "esriFieldTypeString", "alias": "StateNM_2024", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STATENM" }, { "name": "STRUCKBYVEHIDNM", "type": "esriFieldTypeString", "alias": "StruckByVehIDNM_2024", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "STRUCKBYVEHIDNM" }, { "name": "TYPENM", "type": "esriFieldTypeInteger", "alias": "TypeNM_2024", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TYPENM" }, { "name": "UNKNOWNNM", "type": "esriFieldTypeString", "alias": "UnknownNM_2024", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "UNKNOWNNM" }, { "name": "ZIPCODENM", "type": "esriFieldTypeInteger", "alias": "ZipCodeNM_2024", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ZIPCODENM" }, { "name": "NONMOTORISTDOB", "type": "esriFieldTypeDate", "alias": "NonMotoristDOB_2019_2023", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "NONMOTORISTDOB" }, { "name": "NONMOTORISTDRUGTESTINDICATOR", "type": "esriFieldTypeString", "alias": "NonMotoristDrugTestIndicator_2019_2023", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "NONMOTORISTDRUGTESTINDICATOR" }, { "name": "NONMOTORISTDRUGTESTRESULT", "type": "esriFieldTypeString", "alias": "NonMotoristDrugTestResult_2019_2023", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "NONMOTORISTDRUGTESTRESULT" }, { "name": "NONMOTORISTOBEYTRAFFICSIGNAL", "type": "esriFieldTypeString", "alias": "NonMotoristObeyTrafficSignal_2019_2023", "domain": null, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "NONMOTORISTOBEYTRAFFICSIGNAL" }, { "name": "NONMOTORISTSUBSTANCEUSE", "type": "esriFieldTypeString", "alias": "NonMotoristSubstanceUse_2019_2023", "domain": null, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "NONMOTORISTSUBSTANCEUSE" }, { "name": "NONMOTORISTUNITNUMBERFIRSTSTRI", "type": "esriFieldTypeSmallInteger", "alias": "NonMotoristUnitNumberFirstStrike_2019_2023", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NONMOTORISTUNITNUMBERFIRSTSTRI" }, { "name": "NONMOTORISTVISIBILITY", "type": "esriFieldTypeString", "alias": "NonMotoristVisibility_2019_2023", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "NONMOTORISTVISIBILITY" }, { "name": "MERGE_SRC", "type": "esriFieldTypeString", "alias": "MERGE_SRC", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MERGE_SRC" } ], "indexes": [ { "name": "G67856GENDERNM", "fields": "GENDERNM", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G67856REPORTNUMB", "fields": "REPORTNUMBER", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I67856ACTIONPRIO", "fields": "ACTIONPRIORTOCRASHNMDESCRIPTIO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I67856AGENM", "fields": "AGENM", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I67856INJURYSTAT", "fields": "INJURYSTATUSNMDESCRIPTION", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I67856LOCATIONNM", "fields": "LOCATIONNMDESCRIPTION", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I67856REPORTNUMB", "fields": "REPORTNUMBERNM", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I67856TYPENMDESC", "fields": "TYPENMDESCRIPTION", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R396290_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Crash_NonMotorist", "description": "", "prototype": { "attributes": { "NONMOTORISTVISIBILITY": null, "MERGE_SRC": null, "CRASHSEVERITYDESCRIPTION": null, "REPORTNUMBER": null, "TYPENMDESCRIPTION": null, "PERSONIDNM": null, "ACTIONPRIORTOCRASHNM": null, "ACTIONPRIORTOCRASHNMDESCRIPTIO": null, "AGENM": null, "CITYNM": null, "CONTACTPOINTNM": null, "CONTACTPOINTNMDESCRIPTION": null, "DISTRACTEDBYACTIONNM": null, "DISTRACTEDBYACTIONNMDESCRIPTIO": null, "DISTRACTEDBYSOURCE": null, "DISTRACTEDBYSOURCEDESCRIPTION": null, "GENDERNM": null, "INCIDENTRESPONDERNM": null, "INCIDENTRESPONDERNMDESCRIPTION": null, "INJURYSTATUSNM": null, "INJURYSTATUSNMDESCRIPTION": null, "LOCATIONNM": null, "LOCATIONNMDESCRIPTION": null, "ORIGINDESTINATIONNM": null, "ORIGINDESTINATIONNMDESCRIPTION": null, "REPORTNUMBERNM": null, "STATENM": null, "STRUCKBYVEHIDNM": null, "TYPENM": null, "UNKNOWNNM": null, "ZIPCODENM": null, "NONMOTORISTDOB": null, "NONMOTORISTDRUGTESTINDICATOR": null, "NONMOTORISTDRUGTESTRESULT": null, "NONMOTORISTOBEYTRAFFICSIGNAL": null, "NONMOTORISTSUBSTANCEUSE": null, "NONMOTORISTUNITNUMBERFIRSTSTRI": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }