Dataset: Moving Violations Summary For 2012

About this Dataset

Moving Violations Summary For 2012

The Vision Zero data contained in this layer pertain to moving violations issued by the District of Columbia's Metropolitan Police Department (MPD) and partner agencies with the authority to do so. For example, the District Department of Transportation's (DDOT) traffic control officers who prevent congestion through enforcement and control at intersections throughout the District. Locations of moving violations are identified from a database provided by the District Department of Motor Vehicles (DMV).

The data is summarized by ticket counts based on time of day, week of year, year, and category of violation. The summary form was created as a series of aggregated street segment data, in order to view spatial patterns on a weekly basis. This is a temporal crosstab of violation types (defined below) by week and time of day (ranges defined below).

Users are able to query by week to get a DC-wide yearly and weekly perspective on over 40 different combinations of violations. Create interesting street segment heat maps which can get quite specific to identify patterns and answer questions. For example, where are the majority of Unsafe Operator moving violations in the AM Rush of 2012? These data will give up to 52 distinct street segments of information – one for each week of the year.

**
**

Field Definitions:

Identification

Weeknumber – Week of Year, based on a Sunday start of the week
StreetSeg – Street Segment ID, corresponds to the DDOT street centerline ‘StreetSegID’ field
Registered Name – Street name
StreetType – Type of Street (Road, Ave, etc)
Quad – DC Quadrant
FromAddLeft – Unit number start (for approximating this segment’s block)
ToAddLeft – Unit number end (for approximating this segment’s block

Moving

Low Speeding (Under 20mph) - speed violations under 20mph
High Speeding (above 20mph) - speed violations over 20 mph including reckless driving
Unsafe Driving -violations for driving maneuvers unsafe to traffic
Unsafe Vehicle - violations for vehicle characteristics unsafe to traffic
Unsafe Operator- violations for operator (driver) characteristics unsafe to traffic
Other- miscellaneous violations

Important Notes: Records which could not be associated to a street centerline segment (StreetSeg) were excluded from these summariesRecords which do not have a time of day associated with the violation were excluded from these summaries.
Organization: District of Columbia
Last updated: 2024-04-30T18:46:14.488334
Tags: ddot, dmv, dpw, enforcement, feb2016, moving, moving-violations, mpd, odtest, police, ppsa, transportation, violations, vision-zero, vz, washington-dc

Tables

Table 1

@usgov.district_of_columbia_moving_violations_summary_for_2012.table_1

455.13 KB
27806 rows
52 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "streetseg" BIGINT,
  "weeknumber" BIGINT,
  "highspeed_am_norush" BIGINT,
  "highspeed_am_rush" BIGINT,
  "highspeed_evening" BIGINT,
  "highspeed_no_time" BIGINT,
  "highspeed_overnight" BIGINT,
  "highspeed_pm_norush" BIGINT,
  "highspeed_pm_rush" BIGINT,
  "lowspeed_am_norush" BIGINT,
  "lowspeed_am_rush" BIGINT,
  "lowspeed_evening" BIGINT,
  "lowspeed_no_time" BIGINT,
  "lowspeed_overnight" BIGINT,
  "lowspeed_pm_norush" BIGINT,
  "lowspeed_pm_rush" BIGINT,
  "other_am_norush" BIGINT,
  "other_am_rush" BIGINT,
  "other_evening" BIGINT,
  "other_no_time" BIGINT,
  "other_overnight" BIGINT,
  "other_pm_norush" BIGINT,
  "other_pm_rush" BIGINT,
  "unsafedriving_am_norush" BIGINT,
  "unsafedriving_am_rush" BIGINT,
  "unsafedriving_evening" BIGINT,
  "unsafedriving_no_time" BIGINT,
  "unsafedriving_overnight" BIGINT,
  "unsafedriving_pm_norush" BIGINT,
  "unsafedriving_pm_rush" BIGINT,
  "unsafeoper_am_norush" BIGINT,
  "unsafeoper_am_rush" BIGINT,
  "unsafeoper_evening" BIGINT,
  "unsafeoper_no_time" BIGINT,
  "unsafeoper_overnight" BIGINT,
  "unsafeoper_pm_norush" BIGINT,
  "unsafeoper_pm_rush" BIGINT,
  "unsafevehicle_am_norush" BIGINT,
  "unsafevehicle_am_rush" BIGINT,
  "unsafevehicle_evening" BIGINT,
  "unsafevehicle_no_time" BIGINT,
  "unsafevehicle_overnight" BIGINT,
  "unsafevehicle_pm_norush" BIGINT,
  "unsafevehicle_pm_rush" BIGINT,
  "registeredname" VARCHAR,
  "streettype" VARCHAR,
  "quadrant" VARCHAR,
  "fromaddresslefttheo" DOUBLE,
  "toaddresslefttheo" DOUBLE,
  "shape" VARCHAR,
  "shapelen" BIGINT
);