About this Dataset

CSCL PlowNYC

The NYC Street Centerline (CSCL) is a road-bed representation of New York City streets containing address ranges and other information such as traffic directions, road types, segment types. Please use this dataset to determine what physicalid maps to the physicalid street segment in the [DSNY PlowNYC dataset for the 2016/2017 winter season. For a current version of CSCL, please use [this dataset
Organization: City of New York
Last updated: 2024-02-09T16:30:23.990588

Tables

Table 1

@usgov.city_of_new_york_cscl_plownyc.table_1

16.2 MB
109,018 rows
37 columns

CREATE TABLE table_1 (
  "physicalid" BIGINT,
  "l_low_hn" VARCHAR,
  "objectid" BIGINT,
  "the_geom" VARCHAR,
  "l_high_hn" VARCHAR,
  "r_low_hn" VARCHAR,
  "r_high_hn" VARCHAR,
  "l_zip" DOUBLE,
  "r_zip" DOUBLE,
  "stname_lab" VARCHAR,
  "status" BIGINT,
  "rwjurisdic" DOUBLE,
  "accessible" DOUBLE,
  "nonped" VARCHAR,
  "bike_lane" DOUBLE,
  "boroughcod" BIGINT,
  "borough_in" DOUBLE,
  "seglocstat" VARCHAR,
  "sandist_in" DOUBLE,
  "lsubsect" VARCHAR,
  "rsubsect" VARCHAR,
  "continuous" DOUBLE,
  "twisted_pa" VARCHAR,
  "segmentlen" DOUBLE,
  "created_by" VARCHAR,
  "created_da" VARCHAR,
  "modified_b" VARCHAR,
  "modified_d" VARCHAR,
  "trafdir" VARCHAR,
  "rw_type" BIGINT,
  "within_bnd" DOUBLE,
  "collection" VARCHAR,
  "from_level" BIGINT,
  "to_level_c" BIGINT,
  "b5sc" BIGINT,
  "bphys_id" BIGINT,
  "shape_leng" DOUBLE
);