Name: DAProjects.DBO.DA220003_Unit_Table

Display Field: VEH_TRANSP_NAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 87c798066f534f22b9bf2460753af3d4

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CRASH_ID ( type: esriFieldTypeInteger, alias: CRASH_ID )
• UNIT_NBR ( type: esriFieldTypeInteger, alias: UNIT_NBR )
• UNIT_DESC_ID ( type: esriFieldTypeString, alias: UNIT_DESC_ID, length: 1073741822 )
• VEH_PARKED_FL ( type: esriFieldTypeString, alias: VEH_PARKED_FL, length: 1073741822 )
• VEH_HNR_FL ( type: esriFieldTypeString, alias: VEH_HNR_FL, length: 1073741822 )
• VEH_LIC_STATE_ID ( type: esriFieldTypeInteger, alias: VEH_LIC_STATE_ID )
• VIN ( type: esriFieldTypeString, alias: VIN, length: 1073741822 )
• VEH_MOD_YEAR ( type: esriFieldTypeInteger, alias: VEH_MOD_YEAR )
• VEH_COLOR_ID ( type: esriFieldTypeInteger, alias: VEH_COLOR_ID )
• VEH_MAKE_ID ( type: esriFieldTypeInteger, alias: VEH_MAKE_ID )
• VEH_MOD_ID ( type: esriFieldTypeInteger, alias: VEH_MOD_ID )
• VEH_BODY_STYL_ID ( type: esriFieldTypeString, alias: VEH_BODY_STYL_ID, length: 1073741822 )
• EMER_RESPNDR_FL ( type: esriFieldTypeString, alias: EMER_RESPNDR_FL, length: 1073741822 )
• OWNR_ZIP ( type: esriFieldTypeInteger, alias: OWNR_ZIP )
• FIN_RESP_PROOF_ID ( type: esriFieldTypeInteger, alias: FIN_RESP_PROOF_ID )
• FIN_RESP_TYPE_ID ( type: esriFieldTypeInteger, alias: FIN_RESP_TYPE_ID )
• VEH_DAMAGE_DESCRIPTION1_ID ( type: esriFieldTypeInteger, alias: VEH_DAMAGE_DESCRIPTION1_ID )
• VEH_DAMAGE_SEVERITY1_ID ( type: esriFieldTypeInteger, alias: VEH_DAMAGE_SEVERITY1_ID )
• VEH_DAMAGE_DIRECTION_OF_FORCE1_ ( type: esriFieldTypeInteger, alias: VEH_DAMAGE_DIRECTION_OF_FORCE1_ID )
• VEH_DAMAGE_DESCRIPTION2_ID ( type: esriFieldTypeInteger, alias: VEH_DAMAGE_DESCRIPTION2_ID )
• VEH_DAMAGE_SEVERITY2_ID ( type: esriFieldTypeInteger, alias: VEH_DAMAGE_SEVERITY2_ID )
• VEH_DAMAGE_DIRECTION_OF_FORCE2_ ( type: esriFieldTypeInteger, alias: VEH_DAMAGE_DIRECTION_OF_FORCE2_ID )
• VEH_INVENTORIED_FL ( type: esriFieldTypeString, alias: VEH_INVENTORIED_FL, length: 1073741822 )
• VEH_TRANSP_NAME ( type: esriFieldTypeString, alias: VEH_TRANSP_NAME, length: 1073741822 )
• VEH_TRANSP_DEST ( type: esriFieldTypeString, alias: VEH_TRANSP_DEST, length: 1073741822 )
• VEH_CMV_FL ( type: esriFieldTypeString, alias: VEH_CMV_FL, length: 1073741822 )
• CMV_FIVETON_FL ( type: esriFieldTypeString, alias: CMV_FIVETON_FL, length: 1073741822 )
• CMV_HAZMAT_FL ( type: esriFieldTypeString, alias: CMV_HAZMAT_FL, length: 1073741822 )
• CMV_NINE_PLUS_PASS_FL ( type: esriFieldTypeString, alias: CMV_NINE_PLUS_PASS_FL, length: 1073741822 )
• CMV_VEH_OPER_ID ( type: esriFieldTypeInteger, alias: CMV_VEH_OPER_ID )
• CMV_CARRIER_ID_TYPE_ID ( type: esriFieldTypeInteger, alias: CMV_CARRIER_ID_TYPE_ID )
• CMV_CARRIER_ZIP ( type: esriFieldTypeInteger, alias: CMV_CARRIER_ZIP )
• CMV_VEH_TYPE_ID ( type: esriFieldTypeInteger, alias: CMV_VEH_TYPE_ID )
• CMV_GVWR ( type: esriFieldTypeInteger, alias: CMV_GVWR )
• CMV_RGVW ( type: esriFieldTypeInteger, alias: CMV_RGVW )
• CMV_HAZMAT_REL_FL ( type: esriFieldTypeString, alias: CMV_HAZMAT_REL_FL, length: 1073741822 )
• HAZMAT_CLS_1_ID ( type: esriFieldTypeString, alias: HAZMAT_CLS_1_ID, length: 1073741822 )
• HAZMAT_IDNBR_1_ID ( type: esriFieldTypeString, alias: HAZMAT_IDNBR_1_ID, length: 1073741822 )
• HAZMAT_CLS_2_ID ( type: esriFieldTypeString, alias: HAZMAT_CLS_2_ID, length: 1073741822 )
• HAZMAT_IDNBR_2_ID ( type: esriFieldTypeString, alias: HAZMAT_IDNBR_2_ID, length: 1073741822 )
• CMV_CARGO_BODY_ID ( type: esriFieldTypeInteger, alias: CMV_CARGO_BODY_ID )
• CMV_EVNT1_ID ( type: esriFieldTypeInteger, alias: CMV_EVNT1_ID )
• CMV_EVNT2_ID ( type: esriFieldTypeString, alias: CMV_EVNT2_ID, length: 1073741822 )
• CMV_EVNT3_ID ( type: esriFieldTypeString, alias: CMV_EVNT3_ID, length: 1073741822 )
• CMV_EVNT4_ID ( type: esriFieldTypeString, alias: CMV_EVNT4_ID, length: 1073741822 )
• CMV_TOT_AXLE ( type: esriFieldTypeString, alias: CMV_TOT_AXLE, length: 1073741822 )
• CMV_TOT_TIRE ( type: esriFieldTypeString, alias: CMV_TOT_TIRE, length: 1073741822 )
• CONTRIB_FACTR_1_ID ( type: esriFieldTypeString, alias: CONTRIB_FACTR_1_ID, length: 1073741822 )
• CONTRIB_FACTR_2_ID ( type: esriFieldTypeInteger, alias: CONTRIB_FACTR_2_ID )
• CONTRIB_FACTR_3_ID ( type: esriFieldTypeInteger, alias: CONTRIB_FACTR_3_ID )
• CONTRIB_FACTR_P1_ID ( type: esriFieldTypeInteger, alias: CONTRIB_FACTR_P1_ID )
• CONTRIB_FACTR_P2_ID ( type: esriFieldTypeString, alias: CONTRIB_FACTR_P2_ID, length: 1073741822 )
• VEH_DFCT_1_ID ( type: esriFieldTypeInteger, alias: VEH_DFCT_1_ID )
• VEH_DFCT_2_ID ( type: esriFieldTypeString, alias: VEH_DFCT_2_ID, length: 1073741822 )
• VEH_DFCT_3_ID ( type: esriFieldTypeString, alias: VEH_DFCT_3_ID, length: 1073741822 )
• VEH_DFCT_P1_ID ( type: esriFieldTypeInteger, alias: VEH_DFCT_P1_ID )
• VEH_DFCT_P2_ID ( type: esriFieldTypeString, alias: VEH_DFCT_P2_ID, length: 1073741822 )
• VEH_TRVL_DIR_ID ( type: esriFieldTypeInteger, alias: VEH_TRVL_DIR_ID )
• FIRST_HARM_EVT_INV_ID ( type: esriFieldTypeInteger, alias: FIRST_HARM_EVT_INV_ID )
• SUS_SERIOUS_INJRY_CNT ( type: esriFieldTypeInteger, alias: SUS_SERIOUS_INJRY_CNT )
• NONINCAP_INJRY_CNT ( type: esriFieldTypeInteger, alias: NONINCAP_INJRY_CNT )
• POSS_INJRY_CNT ( type: esriFieldTypeInteger, alias: POSS_INJRY_CNT )
• NON_INJRY_CNT ( type: esriFieldTypeInteger, alias: NON_INJRY_CNT )
• UNKN_INJRY_CNT ( type: esriFieldTypeInteger, alias: UNKN_INJRY_CNT )
• TOT_INJRY_CNT ( type: esriFieldTypeInteger, alias: TOT_INJRY_CNT )
• DEATH_CNT ( type: esriFieldTypeInteger, alias: DEATH_CNT )
• CMV_DISABLING_DAMAGE_FL ( type: esriFieldTypeString, alias: CMV_DISABLING_DAMAGE_FL, length: 1073741822 )
• CMV_BUS_TYPE_ID ( type: esriFieldTypeInteger, alias: CMV_BUS_TYPE_ID )
• TRLR_GVWR ( type: esriFieldTypeInteger, alias: TRLR_GVWR )
• TRLR_RGVW ( type: esriFieldTypeInteger, alias: TRLR_RGVW )
• TRLR_TYPE_ID ( type: esriFieldTypeString, alias: TRLR_TYPE_ID, length: 1073741822 )
• TRLR_DISABLING_DMAG_ID ( type: esriFieldTypeString, alias: TRLR_DISABLING_DMAG_ID, length: 1073741822 )
• PEDESTRIAN_ACTION_ID ( type: esriFieldTypeString, alias: PEDESTRIAN_ACTION_ID, length: 1073741822 )
• PEDALCYCLIST_ACTION_ID ( type: esriFieldTypeString, alias: PEDALCYCLIST_ACTION_ID, length: 1073741822 )
• PBCAT_PEDESTRIAN_ID ( type: esriFieldTypeInteger, alias: PBCAT_PEDESTRIAN_ID )
• PBCAT_PEDALCYCLIST_ID ( type: esriFieldTypeInteger, alias: PBCAT_PEDALCYCLIST_ID )
• E_SCOOTER_ID ( type: esriFieldTypeString, alias: E_SCOOTER_ID, length: 1073741822 )
• AUTONOMOUS_UNIT_ID ( type: esriFieldTypeInteger, alias: AUTONOMOUS_UNIT_ID )
• INCLUDE_HIN ( type: esriFieldTypeString, alias: INCLUDE_HIN, length: 1073741822 )
• STATE_FACILITY ( type: esriFieldTypeString, alias: STATE_FACILITY, length: 1073741822 )
• STATE_FACILITY_V2 ( type: esriFieldTypeString, alias: STATE_FACILITY_V2, length: 1073741822 )
• KSI ( type: esriFieldTypeInteger, alias: KSI )
• YEAR ( type: esriFieldTypeInteger, alias: YEAR )
• COLLISION_SEVERITY ( type: esriFieldTypeString, alias: COLLISION_SEVERITY, length: 1073741822 )
• CRASH_MODE ( type: esriFieldTypeString, alias: CRASH_MODE, length: 1073741822 )
• SEVERITY_INT ( type: esriFieldTypeInteger, alias: SEVERITY_INT )
• CRASH_MODE_INT ( type: esriFieldTypeInteger, alias: CRASH_MODE_INT )
• UNIT_MODE ( type: esriFieldTypeString, alias: UNIT_MODE, length: 1073741822 )
• UNIT_MODE_INT ( type: esriFieldTypeInteger, alias: UNIT_MODE_INT )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata