Name: transbase_collisions_05132020_btwn_07012014_to_06312019.csv

Display Field: full_street_name

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• type (type: esriFieldTypeString, alias: type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• geometry (type: esriFieldTypeString, alias: geometry, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• case_id_pkey (type: esriFieldTypeInteger, alias: case_id_pkey, SQL Type: sqlTypeOther, nullable: true, editable: true)
• collision_severity (type: esriFieldTypeString, alias: collision_severity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• accident_year (type: esriFieldTypeInteger, alias: accident_year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• collision_date (type: esriFieldTypeInteger, alias: collision_date, SQL Type: sqlTypeOther, nullable: true, editable: true)
• collision_time (type: esriFieldTypeInteger, alias: collision_time, SQL Type: sqlTypeOther, nullable: true, editable: true)
• distance (type: esriFieldTypeInteger, alias: distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• direction (type: esriFieldTypeString, alias: direction, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• pcf_viol_category (type: esriFieldTypeString, alias: pcf_viol_category, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• pcf_violation (type: esriFieldTypeString, alias: pcf_violation, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• pcf_viol_subsection (type: esriFieldTypeString, alias: pcf_viol_subsection, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• type_of_collision (type: esriFieldTypeString, alias: type_of_collision, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• mviw (type: esriFieldTypeString, alias: mviw, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• street_view (type: esriFieldTypeString, alias: street_view, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• primary_rd (type: esriFieldTypeString, alias: primary_rd, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• secondary_rd (type: esriFieldTypeString, alias: secondary_rd, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• dph_col_grp (type: esriFieldTypeString, alias: dph_col_grp, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• day_of_week (type: esriFieldTypeString, alias: day_of_week, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• time_cat (type: esriFieldTypeString, alias: time_cat, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• weather_1 (type: esriFieldTypeString, alias: weather_1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• full_pcf (type: esriFieldTypeString, alias: full_pcf, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• intersection (type: esriFieldTypeString, alias: intersection, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• month (type: esriFieldTypeString, alias: month, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• vz_pcf_link (type: esriFieldTypeString, alias: vz_pcf_link, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• x_street_comb (type: esriFieldTypeString, alias: x_street_comb, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• lighting (type: esriFieldTypeString, alias: lighting, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• number_killed (type: esriFieldTypeInteger, alias: number_killed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• number_injured (type: esriFieldTypeInteger, alias: number_injured, SQL Type: sqlTypeOther, nullable: true, editable: true)
• latitude (type: esriFieldTypeDouble, alias: latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• longitude (type: esriFieldTypeDouble, alias: longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cnn_sgmt_fkey (type: esriFieldTypeInteger, alias: cnn_sgmt_fkey, SQL Type: sqlTypeOther, nullable: true, editable: true)
• full_street_name (type: esriFieldTypeString, alias: full_street_name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• from_intrsctn (type: esriFieldTypeString, alias: from_intrsctn, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• to_intrsctn (type: esriFieldTypeString, alias: to_intrsctn, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• st_lat (type: esriFieldTypeDouble, alias: st_lat, SQL Type: sqlTypeOther, nullable: true, editable: true)
• st_long (type: esriFieldTypeDouble, alias: st_long, SQL Type: sqlTypeOther, nullable: true, editable: true)
• dph_col_grp_description (type: esriFieldTypeString, alias: dph_col_grp_description, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• road_surface (type: esriFieldTypeString, alias: road_surface, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ped_action (type: esriFieldTypeString, alias: ped_action, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• control_device (type: esriFieldTypeString, alias: control_device, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• pst_pull_date_time (type: esriFieldTypeString, alias: pst_pull_date_time, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• bndy_type (type: esriFieldTypeString, alias: bndy_type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• report_link (type: esriFieldTypeString, alias: report_link, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• number_reports (type: esriFieldTypeInteger, alias: number_reports, SQL Type: sqlTypeOther, nullable: true, editable: true)
• party_at_fault (type: esriFieldTypeInteger, alias: party_at_fault, SQL Type: sqlTypeOther, nullable: true, editable: true)
• party1_type (type: esriFieldTypeString, alias: party1_type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• party1_dir_of_travel (type: esriFieldTypeString, alias: party1_dir_of_travel, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• party1_move_pre_acc (type: esriFieldTypeString, alias: party1_move_pre_acc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• party2_type (type: esriFieldTypeString, alias: party2_type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• party2_dir_of_travel (type: esriFieldTypeString, alias: party2_dir_of_travel, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• party2_move_pre_acc (type: esriFieldTypeString, alias: party2_move_pre_acc, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Shape (type: esriFieldTypeGeometry, alias: Shape, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: transbase_collisions_05132020_btwn_07012014_to_06312019.csv
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/11/2020 11:15:39 PM

Schema Last Edit Date: 8/11/2020 11:15:39 PM

Data Last Edit Date: 8/11/2020 11:15:39 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat