crashes_list_view

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
cris_crash_id int4 10 √ null
record_locator text 2147483647 √ null
case_id text 2147483647 √ null
crash_timestamp timestamptz 35,6 √ null
address_primary text 2147483647 √ null
address_secondary text 2147483647 √ null
private_dr_fl bool 1 √ null
in_austin_full_purpose bool 1 √ null
location_id text 2147483647 √ null
atd_txdot_locations.location_id Implied Constraint R
rpt_block_num text 2147483647 √ null
rpt_street_pfx text 2147483647 √ null
rpt_street_sfx text 2147483647 √ null
rpt_street_name text 2147483647 √ null
rpt_sec_block_num text 2147483647 √ null
rpt_sec_street_pfx text 2147483647 √ null
rpt_sec_street_sfx text 2147483647 √ null
rpt_sec_street_name text 2147483647 √ null
latitude numeric 0 √ null
longitude numeric 0 √ null
light_cond_id int4 10 √ null
wthr_cond_id int4 10 √ null
active_school_zone_fl bool 1 √ null
schl_bus_fl bool 1 √ null
at_intrsct_fl bool 1 √ null
onsys_fl bool 1 √ null
traffic_cntl_id int4 10 √ null
road_constr_zone_fl bool 1 √ null
rr_relat_fl bool 1 √ null
toll_road_fl bool 1 √ null
intrsct_relat_id int4 10 √ null
obj_struck_id int4 10 √ null
crash_speed_limit int4 10 √ null
council_district int4 10 √ null
is_temp_record bool 1 √ null
nonincap_injry_count int8 19 √ null
poss_injry_count int8 19 √ null
sus_serious_injry_count int8 19 √ null
non_injry_count int8 19 √ null
tot_injry_count int8 19 √ null
vz_fatality_count int8 19 √ null
cris_fatality_count int8 19 √ null
law_enf_fatality_count int8 19 √ null
fatality_count int8 19 √ null
unkn_injry_count int8 19 √ null
est_comp_cost_crash_based int4 10 √ null
crash_injry_sev_id int4 10 √ null
years_of_life_lost int8 19 √ null
crash_injry_sev_desc text 2147483647 √ null
collsn_desc text 2147483647 √ null
is_manual_geocode bool 1 √ null
crash_date_ct text 2147483647 √ null
crash_time_ct text 2147483647 √ null
crash_day_of_week text 2147483647 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views