Skip to content

Instantly share code, notes, and snippets.

@anand086

anand086/traffic_violations_p table

Created March 29, 2022 01:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anand086/1611266f1602fd028f6f2c75a1649faf to your computer and use it in GitHub Desktop.
Save anand086/1611266f1602fd028f6f2c75a1649faf to your computer and use it in GitHub Desktop.
Download ZIP
Raw
traffic_violations_p table
\d+ traffic_violations_p
Partitioned table "admin.traffic_violations_p"
+-------------------------+------------------------+-----------+----------+---------+----------+--------------+-------------+
| Column | Type | Collation | Nullable | Default | Storage | Stats target | Description |
+-------------------------+------------------------+-----------+----------+---------+----------+--------------+-------------+
| seqid | text | | | | extended | | |
| date_of_stop | date | | not null | | plain | | |
| time_of_stop | time without time zone | | | | plain | | |
| agency | text | | | | extended | | |
| subagency | text | | | | extended | | |
| description | text | | | | extended | | |
| location | text | | | | extended | | |
| latitude | numeric | | | | main | | |
| longitude | numeric | | | | main | | |
| accident | text | | | | extended | | |
| belts | boolean | | | | plain | | |
| personal_injury | boolean | | | | plain | | |
| property_damage | boolean | | | | plain | | |
| fatal | boolean | | | | plain | | |
| commercial_license | boolean | | | | plain | | |
| hazmat | boolean | | | | plain | | |
| commercial_vehicle | boolean | | | | plain | | |
| alcohol | boolean | | | | plain | | |
| workzone | boolean | | | | plain | | |
| search_conducted | text | | | | extended | | |
| search_disposition | text | | | | extended | | |
| search_outcome | text | | | | extended | | |
| search_reason | text | | | | extended | | |
| search_reason_for_stop | text | | | | extended | | |
| search_type | text | | | | extended | | |
| search_arrest_reason | text | | | | extended | | |
| state | text | | | | extended | | |
| vehicletype | text | | | | extended | | |
| year | smallint | | | | plain | | |
| make | text | | | | extended | | |
| model | text | | | | extended | | |
| color | text | | | | extended | | |
| violation_type | text | | | | extended | | |
| charge | text | | | | extended | | |
| article | text | | | | extended | | |
| contributed_to_accident | boolean | | | | plain | | |
| race | text | | | | extended | | |
| gender | text | | | | extended | | |
| driver_city | text | | | | extended | | |
| driver_state | text | | | | extended | | |
| dl_state | text | | | | extended | | |
| arrest_type | text | | | | extended | | |
| geolocation | point | | | | plain | | |
+-------------------------+------------------------+-----------+----------+---------+----------+--------------+-------------+
Partition key: RANGE (date_of_stop)
Partitions: traffic_violations_p_2012 FOR VALUES FROM ('2012-01-01') TO ('2013-01-01'),
traffic_violations_p_2013 FOR VALUES FROM ('2013-01-01') TO ('2014-01-01'),
traffic_violations_p_2014 FOR VALUES FROM ('2014-01-01') TO ('2015-01-01'),
traffic_violations_p_2015 FOR VALUES FROM ('2015-01-01') TO ('2016-01-01'),
traffic_violations_p_2016 FOR VALUES FROM ('2016-01-01') TO ('2017-01-01'),
traffic_violations_p_2017 FOR VALUES FROM ('2017-01-01') TO ('2018-01-01'),
traffic_violations_p_2018 FOR VALUES FROM ('2018-01-01') TO ('2019-01-01'),
traffic_violations_p_2019 FOR VALUES FROM ('2019-01-01') TO ('2020-01-01'),
traffic_violations_p_2020 FOR VALUES FROM ('2020-01-01') TO ('2021-01-01'),
traffic_violations_p_2021 FOR VALUES FROM ('2021-01-01') TO ('2022-01-01'),
traffic_violations_p_default DEFAULT
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment