About this Dataset

SFMTA - Parking Citations & Fines

SUMMARY Parking Citations & Fines issued by the SFMTA. Citation information includes citation, violation and location details which indicate the location and amount of parking citations throughout the city. HOW THIS DATASET IS CREATED Citation data is provided by the SFMTA as an export of the citation management system. Citation data is provided daily and the DataSF datasource is updated daily with a 24 hour lag. The geolocation is based on a geocoding process upon load and may not be accurate based on incomplete address data. HOW TO USE THIS DATASET For more information on violation codes and descriptions, go here.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:19.861211
Tags: parking

Tables

Table 1

@usgov.city_of_san_francisco_sfmta_parking_citations.table_1

1.6 GB
21998259 rows
19 columns


CREATE TABLE table_1 (
  "citation_number" VARCHAR,
  "citation_issued_datetime" VARCHAR,
  "violation" VARCHAR,
  "violation_description" VARCHAR,
  "citation_location" VARCHAR,
  "vehicle_plate_state" VARCHAR,
  "vehicle_plate" VARCHAR,
  "fine_amount" DOUBLE,
  "date_added" VARCHAR,
  "geom" VARCHAR,
  "supervisor_district" DOUBLE,
  "analysis_neighborhood" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "analysis_neighborhoods" DOUBLE,
  "neighborhoods" DOUBLE,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts" DOUBLE,
  "current_supervisor_districts" DOUBLE
);