About this Dataset

Address Assignments

The borough president of each borough is responsible for assigning new addresses to new or significantly altered properties or buildings for the purpose of identification from the street and the delivery of mail. Vanity addresses are valid street addresses that take nearby landmarks or geographies into account instead of the street name where the building entrance is located. New addresses and vanity addresses are assigned by request by property owner or developer.
Organization: City of New York
Last updated: 2020-11-10T17:04:51.110680

Tables

Table 1

@usgov.city_of_new_york_address_assignments.table_1

191.12 kB
2,931 rows
23 columns

CREATE TABLE table_1 (
  "number" VARCHAR,
  "street" VARCHAR,
  "borough" VARCHAR,
  "block" BIGINT,
  "lot" BIGINT,
  "bin" DOUBLE,
  "saf_type" VARCHAR,
  "primary" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "geocode_status" VARCHAR,
  "construction_status" VARCHAR,
  "assignment_type" VARCHAR,
  "created_date" VARCHAR,
  "last_modified_date" VARCHAR,
  "postcode" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR
);