Centerline

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,
  "globalid" VARCHAR,
  "segment_type" VARCHAR,
  "segment_type_value" VARCHAR,
  "street_name" VARCHAR,
  "street_name_label" VARCHAR
);