About this Dataset

Parking Citations

Parking citations with latitude / longitude in Mercator map projection which is a variant of Web Mercator, Google Web Mercator, Spherical Mercator, WGS 84 Web Mercator or WGS 84/Pseudo-Mercator and is the de facto standard for Web mapping applications.

Additional information about Meractor projections - https://en.wikipedia.org/wiki/Mercator_projection

The official EPSG identifier for Web Mercator is EPSG:3857.

Additional information on projections can be read here: https://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=Projection_basics_the_GIS_professional_needs_to_know

For more information on Geographic vs Projected coordinate systems, read here: https://www.esri.com/arcgis-blog/products/arcgis-pro/mapping/gcs_vs_pcs/

For information on how to change map projections, read here: https://learn.arcgis.com/en/projects/make-a-web-map-without-web-mercator/
Organization: City of Los Angeles
Last updated: 2024-01-05T14:32:07.212390

Tables

Table 1

@usgov.city_of_los_angeles_parking_citations_82ba2.table_1

1.25 GB
23,218,747 rows
23 columns

CREATE TABLE table_1 (
  "ticket_number" VARCHAR,
  "issue_date" VARCHAR,
  "issue_time" DOUBLE,
  "meter_id" VARCHAR,
  "marked_time" DOUBLE,
  "rp_state_plate" VARCHAR,
  "plate_expiry_date" DOUBLE,
  "vin" VARCHAR,
  "make" VARCHAR,
  "body_style" VARCHAR,
  "color" VARCHAR,
  "location" VARCHAR,
  "route" VARCHAR,
  "agency" DOUBLE,
  "violation_code" VARCHAR,
  "violation_description" VARCHAR,
  "fine_amount" DOUBLE,
  "agency_desc" VARCHAR,
  "color_desc" VARCHAR,
  "body_style_desc" VARCHAR,
  "loc_lat" DOUBLE,
  "loc_long" DOUBLE,
  "geocodelocation" VARCHAR
);