crashes

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
change_log_crashes.record_id change_log_crashes_record_id_fkey C
crash_notes.crash_pk notes_crashes_id_fkey R
recommendations.crash_pk recommendations_crashes_pk_fkey R
units.crash_pk units_crash_pk_fkey C
crashes_cris.id crashes_id_fkey C
active_school_zone_fl bool 1 √ null
address_primary text 2147483647 √ build_crash_address(rpt_block_num, rpt_street_pfx, rpt_street_name, rpt_street_sfx)
address_secondary text 2147483647 √ build_crash_address(rpt_sec_block_num, rpt_sec_street_pfx, rpt_sec_street_name, rpt_sec_street_sfx)
at_intrsct_fl bool 1 √ null
case_id text 2147483647 √ null
council_district int4 10 √ null
cr3_processed_at timestamptz 35,6 √ null
cr3_stored_fl bool 1 false
crash_speed_limit int4 10 √ null
crash_timestamp timestamptz 35,6 null
created_at timestamptz 35,6 now()
created_by text 2147483647 'system'::text
cris_crash_id int4 10 √ null
units.cris_crash_id units_cris_crash_id_fkey C
engineering_area_id int4 10 √ null
engineering_areas.area_id crashes_engineering_area_fkey N
fhe_collsn_id int4 10 √ null
collsn.id crashes_fhe_collsn_id_fkey R
in_austin_full_purpose bool 1 √ null
intrsct_relat_id int4 10 √ null
intrsct_relat.id crashes_intrsct_relat_id_fkey R
investigat_agency_id int4 10 √ null
agency.id crashes_investigat_agency_id_fkey R
investigator_narrative text 2147483647 √ null
is_deleted bool 1 false
is_temp_record bool 1 false
latitude numeric 0 √ null
law_enforcement_ytd_fatality_num text 2147483647 √ null
light_cond_id int4 10 √ null
light_cond.id crashes_light_cond_id_fkey R
location_id text 2147483647 √ null
atd_txdot_locations.location_id crashes_location_id_fkey N
longitude numeric 0 √ null
medical_advisory_fl bool 1 √ null
obj_struck_id int4 10 √ null
obj_struck.id crashes_obj_struck_id_fkey R
onsys_fl bool 1 √ null
position geometry 2147483647 √ null
private_dr_fl bool 1 √ null
record_locator text 2147483647 CASE WHEN (is_temp_record = true) THEN ('T'::text || (id)::text) ELSE (cris_crash_id)::text END
road_constr_zone_fl bool 1 √ null
road_constr_zone_wrkr_fl bool 1 √ null
rpt_block_num text 2147483647 √ null
rpt_city_id int4 10 √ null
city.id crashes_rpt_city_id_fkey R
rpt_cris_cnty_id int4 10 √ null
cnty.id crashes_rpt_cris_cnty_id_fkey R
rpt_hwy_num text 2147483647 √ null
rpt_hwy_sfx text 2147483647 √ null
rpt_rdwy_sys_id int4 10 √ null
rwy_sys.id crashes_rpt_rdwy_sys_id_fkey R
rpt_ref_mark_dir text 2147483647 √ null
rpt_ref_mark_dist_uom text 2147483647 √ null
rpt_ref_mark_nbr text 2147483647 √ null
rpt_ref_mark_offset_amt numeric 0 √ null
rpt_road_part_id int4 10 √ null
road_part.id crashes_rpt_road_part_id_fkey R
rpt_sec_block_num text 2147483647 √ null
rpt_sec_hwy_num text 2147483647 √ null
rpt_sec_hwy_sfx text 2147483647 √ null
rpt_sec_rdwy_sys_id int4 10 √ null
rwy_sys.id crashes_rpt_sec_rdwy_sys_id_fkey R
rpt_sec_road_part_id int4 10 √ null
road_part.id crashes_rpt_sec_road_part_id_fkey R
rpt_sec_street_desc text 2147483647 √ null
rpt_sec_street_name text 2147483647 √ null
rpt_sec_street_pfx text 2147483647 √ null
rpt_sec_street_sfx text 2147483647 √ null
rpt_street_desc text 2147483647 √ null
rpt_street_name text 2147483647 √ null
rpt_street_pfx text 2147483647 √ null
rpt_street_sfx text 2147483647 √ null
rr_relat_fl bool 1 √ null
schl_bus_fl bool 1 √ null
surf_cond_id int4 10 √ null
surf_cond.id crashes_surf_cond_id_fkey R
surf_type_id int4 10 √ null
surf_type.id crashes_surf_type_id_fkey R
thousand_damage_fl bool 1 √ null
toll_road_fl bool 1 √ null
traffic_cntl_id int4 10 √ null
traffic_cntl.id crashes_traffic_cntl_id_fkey R
txdot_rptable_fl bool 1 √ null
updated_at timestamptz 35,6 now()
updated_by text 2147483647 'system'::text
wthr_cond_id int4 10 √ null
wthr_cond.id crashes_wthr_cond_id_fkey R
investigator_narrative_ocr_processed_at timestamptz 35,6 √ null

The most recent timestamp at which the OCR process attempted to extract the investigator narrative. If null, indicates that the OCR narrative extract has never been attempted. This value should be set via ETL process on the crashes_edits table.

Indexes

Constraint Name Type Sort Column(s)
crashes_pkey Primary key Asc id
crashes_address_primary_idx Performance Asc address_primary
crashes_crash_timestamp_idx Performance Asc crash_timestamp
crashes_cris_crash_id_idx Performance Asc cris_crash_id
crashes_cris_crash_id_key Must be unique Asc cris_crash_id
crashes_in_austin_full_purpose_idx Performance Asc in_austin_full_purpose
crashes_is_deleted_idx Performance Asc is_deleted
crashes_location_id_idx Performance Asc location_id
crashes_position_idx Performance Asc position
crashes_private_dr_fl_idx Performance Asc private_dr_fl
crashes_record_locator_idx Performance Asc record_locator
crashes_record_locator_key Must be unique Asc record_locator

Relationships

Close relationships within degrees of separation