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

About this Dataset

Centerline

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.
Organization: City of New York
Last updated: 2024-12-27T21:50:29.768269
Tags: centerline

Tables

Table 1

@usgov.city_of_new_york_nyc_street_centerline_cscl_9a0e0.table_1

24.67 MB
121,964 rows
64 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "physicalid" BIGINT,
  "l_low_hn" VARCHAR,
  "l_high_hn" VARCHAR,
  "r_low_hn" VARCHAR,
  "r_high_hn" VARCHAR,
  "l_zip" DOUBLE,
  "r_zip" DOUBLE,
  "status" BIGINT,
  "bike_lane" DOUBLE,
  "trafdir" VARCHAR,
  "rw_type" BIGINT,
  "pre_type" VARCHAR,
  "post_type" VARCHAR,
  "objectid" BIGINT,
  "fcc" DOUBLE,
  "left_side_block_face_id" DOUBLE,
  "right_side_block_face_id" DOUBLE,
  "average_travel_time" VARCHAR,
  "roadway_jurisdiction" DOUBLE,
  "nominaldir" VARCHAR,
  "accessible" DOUBLE,
  "nonped" VARCHAR,
  "borough_code" BIGINT,
  "borough_indicator" DOUBLE,
  "segloc_status" VARCHAR,
  "san_district_inc" DOUBLE,
  "left_side_subset" VARCHAR,
  "right_side_subset" VARCHAR,
  "continuous_parity_flag" DOUBLE,
  "twisted_parity_flag" VARCHAR,
  "posted_speed" DOUBLE,
  "segment_length" DOUBLE,
  "street_width" DOUBLE,
  "street_width_irr" VARCHAR,
  "special_disaster" VARCHAR,
  "fire_lane" VARCHAR,
  "created_date" VARCHAR,
  "modified_date" VARCHAR,
  "within_bndy_dist" DOUBLE,
  "truck_route_type" DOUBLE,
  "collection_method" VARCHAR,
  "from_level_code" BIGINT,
  "to_level_code" BIGINT,
  "b5sc" BIGINT,
  "snow_priority" VARCHAR,
  "joinid" VARCHAR,
  "bphys_id" VARCHAR,
  "cartography_display_level" DOUBLE,
  "number_travel_lanes" DOUBLE,
  "number_park_lanes" DOUBLE,
  "number_total_lane" DOUBLE,
  "pre_modifier" VARCHAR,
  "pre_directional" VARCHAR,
  "post_directional" VARCHAR,
  "post_modifier" VARCHAR,
  "full_street_name" VARCHAR,
  "bike_traffic_direction" VARCHAR,
  "shape_length" DOUBLE  -- SHAPE, Length,
  "globalid" VARCHAR,
  "segment_type" VARCHAR,
  "segment_type_value" VARCHAR,
  "street_name" VARCHAR,
  "street_name_label" VARCHAR
);