Parking Violations Summary For 2010 - Weeks 27 To 52 by US Government | Demographics and Population Studies

About this Dataset

Parking Violations Summary For 2010 - Weeks 27 To 52

The Vision Zero data contained in this layer pertain to parking 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 50 different combinations of violations. Create interesting street segment heat maps which can get quite specific to identify patterns and answer questions. For example, what type of parking violations occurred the most in the time period of this data? These data will give up to 26 distinct street segments of information – one for each week of the half year.

Important Notes: Records which could not be associated to a street centerline segment (StreetSeg) were excluded from these summaries. Records 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-30T17:45:23.605392
Tags: ddot, dmv, dpw, enforcement, feb2016, mpd, odtest, parking, parking-violation, police, ppsa, transportation, violations, vision-zero, vz, washington-dc

Tables

Table 1

@usgov.district_of_columbia_parking_violations_summary_for_20_2e72a560.table_1

1.09 MB
79406 rows
58 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "streetseg" BIGINT,
  "weeknumber" BIGINT,
  "commvehicle_am_norush" BIGINT,
  "commvehicle_am_rush" BIGINT,
  "commvehicle_evening" BIGINT,
  "commvehicle_overnight" BIGINT,
  "commvehicle_pm_norush" BIGINT,
  "commvehicle_pm_rush" BIGINT,
  "impedbikeped_am_norush" BIGINT,
  "impedbikeped_am_rush" BIGINT,
  "impedbikeped_evening" BIGINT,
  "impedbikeped_overnight" BIGINT,
  "impedbikeped_pm_norush" BIGINT,
  "impedbikeped_pm_rush" BIGINT,
  "meters_am_norush" BIGINT,
  "meters_am_rush" BIGINT,
  "meters_evening" BIGINT,
  "meters_overnight" BIGINT,
  "meters_pm_norush" BIGINT,
  "meters_pm_rush" BIGINT,
  "other_am_norush" BIGINT,
  "other_am_rush" BIGINT,
  "other_evening" BIGINT,
  "other_overnight" BIGINT,
  "other_pm_norush" BIGINT,
  "other_pm_rush" BIGINT,
  "restrictedzones_am_norush" BIGINT,
  "restrictedzones_am_rush" BIGINT,
  "restrictedzones_evening" BIGINT,
  "restrictedzones_overnight" BIGINT,
  "restrictedzones_pm_norush" BIGINT,
  "restrictedzones_pm_rush" BIGINT,
  "rpp_am_norush" BIGINT,
  "rpp_am_rush" BIGINT,
  "rpp_evening" BIGINT,
  "rpp_overnight" BIGINT,
  "rpp_pm_norush" BIGINT,
  "rpp_pm_rush" BIGINT,
  "rushhourviolations_am_rush" BIGINT,
  "rushhourviolations_evening" BIGINT,
  "rushhourviolations_pm_rush" BIGINT,
  "unsafeparking_am_norush" BIGINT,
  "unsafeparking_am_rush" BIGINT,
  "unsafeparking_evening" BIGINT,
  "unsafeparking_overnight" BIGINT,
  "unsafeparking_pm_norush" BIGINT,
  "unsafeparking_pm_rush" BIGINT,
  "registeredname" VARCHAR,
  "streettype" VARCHAR,
  "quadrant" VARCHAR,
  "fromaddresslefttheo" DOUBLE,
  "toaddresslefttheo" DOUBLE,
  "shape" VARCHAR,
  "rushhourviolations_am_norus_40" BIGINT,
  "rushhourviolations_overnigh_43" BIGINT,
  "rushhourviolations_pm_norus_44" BIGINT,
  "shapelen" BIGINT
);