atd_txdot_locations

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
location_id varchar 2147483647 null
afd__incidents.location_id Implied Constraint R
atd_apd_blueform.location_id Implied Constraint R
crashes.location_id crashes_location_id_fkey N
crashes_list_view.location_id Implied Constraint R
ems__incidents.location_id Implied Constraint R
location_crashes_view.location_id Implied Constraint R
location_notes.location_id fk_location_note_location R
locations_list_view.location_id Implied Constraint R
description text 2147483647 null
last_update date 13 now()
latitude float8 17,17 √ null
longitude float8 17,17 √ null
scale_factor float8 17,17 √ null
geometry geometry 2147483647 √ null
street_level varchar 16 √ null
is_intersection int4 10 0
council_district int4 10 √ null
location_group int2 5 √ 0

Indexes

Constraint Name Type Sort Column(s)
atd_txdot_locations_pk Primary key Asc location_id
atd_txdot_locations_council_district_idx Performance Asc council_district
atd_txdot_locations_geometry_index Performance Asc geometry
atd_txdot_locations_group_index Performance Asc location_group
atd_txdot_locations_unique_id_key Must be unique Asc location_id
atd_txdot_locations_unique_id_uindex Must be unique Asc location_id

Relationships

Close relationships within degrees of separation