Dataset: AddressPoint

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

52.61 MB
967749 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
);