Name: DAProjects.DBO.DA220003_Persons_Table

Display Field: CRASH_ID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: bb2fb27ad19c4c52aa5d4edd56903bf9

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CRASH_ID ( type: esriFieldTypeInteger, alias: CRASH_ID, editable: true, nullable: true, defaultValue: null, modelName: CRASH_ID )
• UNIT_NBR ( type: esriFieldTypeInteger, alias: UNIT_NBR, editable: true, nullable: true, defaultValue: null, modelName: UNIT_NBR )
• PRSN_NBR ( type: esriFieldTypeInteger, alias: PRSN_NBR, editable: true, nullable: true, defaultValue: null, modelName: PRSN_NBR )
• PRSN_TYPE_ID ( type: esriFieldTypeString, alias: PRSN_TYPE_ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRSN_TYPE_ID )
• PRSN_OCCPNT_POS_ID ( type: esriFieldTypeString, alias: PRSN_OCCPNT_POS_ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRSN_OCCPNT_POS_ID )
• PRSN_INJRY_SEV_ID ( type: esriFieldTypeString, alias: PRSN_INJRY_SEV_ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRSN_INJRY_SEV_ID )
• PRSN_AGE ( type: esriFieldTypeInteger, alias: PRSN_AGE, editable: true, nullable: true, defaultValue: null, modelName: PRSN_AGE )
• PRSN_AGE_GROUP ( type: esriFieldTypeString, alias: PRSN_AGE_GROUP, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRSN_AGE_GROUP )
• PRSN_AGE_GROUP_2 ( type: esriFieldTypeString, alias: PRSN_AGE_GROUP_2, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRSN_AGE_GROUP_2 )
• PRSN_AGE_GROUP_INT ( type: esriFieldTypeInteger, alias: PRSN_AGE_GROUP_INT, editable: true, nullable: true, defaultValue: null, modelName: PRSN_AGE_GROUP_INT )
• PRSN_ETHNICITY_ID ( type: esriFieldTypeString, alias: PRSN_ETHNICITY_ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRSN_ETHNICITY_ID )
• PRSN_ETHNICITY_ID_CLEAN ( type: esriFieldTypeString, alias: PRSN_ETHNICITY_ID_CLEAN, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRSN_ETHNICITY_ID_CLEAN )
• PRSN_GNDR_ID ( type: esriFieldTypeString, alias: PRSN_GNDR_ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRSN_GNDR_ID )
• PRSN_EJCT_ID ( type: esriFieldTypeString, alias: PRSN_EJCT_ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRSN_EJCT_ID )
• PRSN_REST_ID ( type: esriFieldTypeString, alias: PRSN_REST_ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRSN_REST_ID )
• PRSN_AIRBAG_ID ( type: esriFieldTypeString, alias: PRSN_AIRBAG_ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRSN_AIRBAG_ID )
• PRSN_HELMET_ID ( type: esriFieldTypeString, alias: PRSN_HELMET_ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRSN_HELMET_ID )
• PRSN_SOL_FL ( type: esriFieldTypeString, alias: PRSN_SOL_FL, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRSN_SOL_FL )
• PRSN_ALC_SPEC_TYPE_ID ( type: esriFieldTypeString, alias: PRSN_ALC_SPEC_TYPE_ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRSN_ALC_SPEC_TYPE_ID )
• PRSN_ALC_RSLT_ID ( type: esriFieldTypeString, alias: PRSN_ALC_RSLT_ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRSN_ALC_RSLT_ID )
• PRSN_BAC_TEST_RSLT ( type: esriFieldTypeString, alias: PRSN_BAC_TEST_RSLT, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRSN_BAC_TEST_RSLT )
• PRSN_DRG_SPEC_TYPE_ID ( type: esriFieldTypeString, alias: PRSN_DRG_SPEC_TYPE_ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRSN_DRG_SPEC_TYPE_ID )
• PRSN_DRG_RSLT_ID ( type: esriFieldTypeString, alias: PRSN_DRG_RSLT_ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRSN_DRG_RSLT_ID )
• PRSN_DEATH_TIME ( type: esriFieldTypeString, alias: PRSN_DEATH_TIME, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRSN_DEATH_TIME )
• SUS_SERIOUS_INJRY_CNT ( type: esriFieldTypeInteger, alias: SUS_SERIOUS_INJRY_CNT, editable: true, nullable: true, defaultValue: null, modelName: SUS_SERIOUS_INJRY_CNT )
• NONINCAP_INJRY_CNT ( type: esriFieldTypeInteger, alias: NONINCAP_INJRY_CNT, editable: true, nullable: true, defaultValue: null, modelName: NONINCAP_INJRY_CNT )
• POSS_INJRY_CNT ( type: esriFieldTypeInteger, alias: POSS_INJRY_CNT, editable: true, nullable: true, defaultValue: null, modelName: POSS_INJRY_CNT )
• NON_INJRY_CNT ( type: esriFieldTypeInteger, alias: NON_INJRY_CNT, editable: true, nullable: true, defaultValue: null, modelName: NON_INJRY_CNT )
• UNKN_INJRY_CNT ( type: esriFieldTypeInteger, alias: UNKN_INJRY_CNT, editable: true, nullable: true, defaultValue: null, modelName: UNKN_INJRY_CNT )
• TOT_INJRY_CNT ( type: esriFieldTypeInteger, alias: TOT_INJRY_CNT, editable: true, nullable: true, defaultValue: null, modelName: TOT_INJRY_CNT )
• DEATH_CNT ( type: esriFieldTypeInteger, alias: DEATH_CNT, editable: true, nullable: true, defaultValue: null, modelName: DEATH_CNT )
• UNIT_DESC_ID ( type: esriFieldTypeString, alias: UNIT_DESC_ID, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: UNIT_DESC_ID )
• KSI ( type: esriFieldTypeInteger, alias: KSI, editable: true, nullable: true, defaultValue: null, modelName: KSI )
• YEAR ( type: esriFieldTypeInteger, alias: YEAR, editable: true, nullable: true, defaultValue: null, modelName: YEAR )
• COLLISION_SEVERITY ( type: esriFieldTypeString, alias: COLLISION_SEVERITY, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: COLLISION_SEVERITY )
• CRASH_MODE ( type: esriFieldTypeString, alias: CRASH_MODE, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CRASH_MODE )
• SEVERITY_INT ( type: esriFieldTypeInteger, alias: SEVERITY_INT, editable: true, nullable: true, defaultValue: null, modelName: SEVERITY_INT )
• CRASH_MODE_INT ( type: esriFieldTypeInteger, alias: CRASH_MODE_INT, editable: true, nullable: true, defaultValue: null, modelName: CRASH_MODE_INT )
• PERSON_MODE ( type: esriFieldTypeString, alias: PERSON_MODE, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PERSON_MODE )
• PERSON_MODE_INT ( type: esriFieldTypeInteger, alias: PERSON_MODE_INT, editable: true, nullable: true, defaultValue: null, modelName: PERSON_MODE_INT )
• INCLUDE_HIN ( type: esriFieldTypeString, alias: INCLUDE_HIN, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: INCLUDE_HIN )
• STATE_FACILITY ( type: esriFieldTypeString, alias: STATE_FACILITY, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: STATE_FACILITY )
• STATE_FACILITY_V2 ( type: esriFieldTypeString, alias: STATE_FACILITY_V2, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: STATE_FACILITY_V2 )

Templates:

• Name: DAProjects.DBO.DA220003_Persons_Table
  Description:
  Prototype:
  STATE_FACILITY: null
  CRASH_ID: null
  UNIT_NBR: null
  PRSN_NBR: null
  PRSN_TYPE_ID: null
  PRSN_OCCPNT_POS_ID: null
  PRSN_INJRY_SEV_ID: null
  PRSN_AGE: null
  PRSN_AGE_GROUP: null
  PRSN_AGE_GROUP_2: null
  PRSN_AGE_GROUP_INT: null
  PRSN_ETHNICITY_ID: null
  PRSN_ETHNICITY_ID_CLEAN: null
  PRSN_GNDR_ID: null
  PRSN_EJCT_ID: null
  PRSN_REST_ID: null
  PRSN_AIRBAG_ID: null
  PRSN_HELMET_ID: null
  PRSN_SOL_FL: null
  PRSN_ALC_SPEC_TYPE_ID: null
  PRSN_ALC_RSLT_ID: null
  PRSN_BAC_TEST_RSLT: null
  PRSN_DRG_SPEC_TYPE_ID: null
  PRSN_DRG_RSLT_ID: null
  PRSN_DEATH_TIME: null
  SUS_SERIOUS_INJRY_CNT: null
  NONINCAP_INJRY_CNT: null
  POSS_INJRY_CNT: null
  NON_INJRY_CNT: null
  UNKN_INJRY_CNT: null
  TOT_INJRY_CNT: null
  DEATH_CNT: null
  UNIT_DESC_ID: null
  KSI: null
  YEAR: null
  COLLISION_SEVERITY: null
  CRASH_MODE: null
  SEVERITY_INT: null
  CRASH_MODE_INT: null
  PERSON_MODE: null
  PERSON_MODE_INT: null
  INCLUDE_HIN: null
  STATE_FACILITY_V2: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata