About this Dataset

Parking Regulation Locations And Signs

Department of Transpiration manages approximately 1,000,000 signs on the streets of New York. This dataset contains current and historical parking regulation signs. For all street signs, please use Street Sign Work Orders.
Organization: City of New York
Last updated: 2022-04-28T05:17:10.441922
Tags: location, parking, regulation, sign, sims, status, street

Tables

Table 1

@usgov.city_of_new_york_parking_regulation_locations_and_signs_1a954.table_1

14.33 MB
442,008 rows
25 columns

CREATE TABLE table_1 (
  "order_number" VARCHAR,
  "record_type" VARCHAR,
  "order_type" VARCHAR,
  "borough" VARCHAR,
  "on_street" VARCHAR,
  "on_street_suffix" VARCHAR,
  "from_street" VARCHAR,
  "from_street_suffix" VARCHAR,
  "to_street" VARCHAR,
  "to_street_suffix" VARCHAR,
  "side_of_street" VARCHAR,
  "order_completed_on_date" TIMESTAMP,
  "sign_code" VARCHAR,
  "sign_description" VARCHAR,
  "sign_size" VARCHAR,
  "sign_design_voided_on_date" TIMESTAMP,
  "sign_location" VARCHAR,
  "distance_from_intersection" BIGINT,
  "arrow_direction" VARCHAR,
  "facing_direction" VARCHAR,
  "sheeting_type" VARCHAR,
  "support" VARCHAR,
  "sign_notes" VARCHAR,
  "sign_x_coord" DOUBLE,
  "sign_y_coord" DOUBLE
);