Name: AddressPoint
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

AddressPoint

Address points were developed to supplement the address information supplied by the CSCL centerline. Some computer aided dispatch systems use address points as the primary source for locating an address.
Organization: City of New York
Last updated: 2024-11-29T21:54:27.567554
Tags: address-point

Tables

Table 1

@usgov.city_of_new_york_nyc_address_points_e0c4f.table_1

55.16 MB
967,749 rows
31 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "bin" DOUBLE,
  "zipcode" DOUBLE,
  "pre_type" VARCHAR,
  "post_type" VARCHAR,
  "objectid" BIGINT,
  "address_point_id" BIGINT,
  "complex_id" DOUBLE,
  "house_number" VARCHAR,
  "house_number_suffix" VARCHAR,
  "hyphen_type" VARCHAR,
  "sos_indicator" BIGINT,
  "special_condition" VARCHAR,
  "address_source" BIGINT,
  "address_status" DOUBLE,
  "validation" BIGINT,
  "borough_code" BIGINT,
  "collection_method" VARCHAR,
  "created_date" VARCHAR,
  "modified_date" VARCHAR,
  "b7sc_actual" BIGINT,
  "b7sc_vanity" DOUBLE,
  "a4id" DOUBLE,
  "street_name" VARCHAR,
  "house_number_range" VARCHAR,
  "house_number_range_suffix" VARCHAR,
  "pre_modifier" VARCHAR,
  "pre_directional" VARCHAR,
  "post_directional" VARCHAR,
  "post_modifier" VARCHAR,
  "full_street_name" VARCHAR
);