About this Dataset

Transportation

Street center lines in Chicago. The data can be viewed on the Chicago Data Portal with a web browser. However, to view or use the files outside of a web browser, you will need to use compression software and special GIS software, such as ESRI ArcGIS (shapefile) or Google Earth (KML or KMZ), is required.
Organization: City of Chicago
Last updated: 2024-02-17T06:33:13.432037
Tags: deprecated, gis, kml, map_layer, shapefiles, streets, transportation

Tables

Table 1

@usgov.city_of_chicago_transportation_a10a2.table_1

15.68 MB
55,747 rows
49 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "fnode_id" BIGINT,
  "tnode_id" BIGINT,
  "trans_id" BIGINT,
  "pre_dir" VARCHAR,
  "street_nam" VARCHAR,
  "street_typ" VARCHAR,
  "suf_dir" VARCHAR,
  "streetname" BIGINT,
  "l_f_add" BIGINT,
  "l_t_add" BIGINT,
  "r_f_add" BIGINT,
  "r_t_add" BIGINT,
  "logiclf" BIGINT,
  "logiclt" BIGINT,
  "logicrf" BIGINT,
  "logicrt" BIGINT,
  "class" VARCHAR,
  "status" VARCHAR,
  "status_dat" VARCHAR,
  "tiered" VARCHAR,
  "oneway_dir" VARCHAR,
  "dir_travel" VARCHAR,
  "ewns" BIGINT,
  "l_parity" VARCHAR,
  "r_parity" VARCHAR,
  "f_zlev" BIGINT,
  "t_zlev" BIGINT,
  "l_fips" BIGINT,
  "r_fips" BIGINT,
  "r_zip" DOUBLE,
  "l_zip" DOUBLE,
  "r_censusbl" BIGINT,
  "l_censusbl" BIGINT,
  "f_cross" VARCHAR,
  "f_cross_st" BIGINT,
  "t_cross" VARCHAR,
  "t_cross_st" BIGINT,
  "length" DOUBLE,
  "edit_date" BIGINT,
  "edit_type" VARCHAR,
  "flag_strin" VARCHAR,
  "ewns_dir" VARCHAR,
  "ewns_coord" BIGINT,
  "create_use" VARCHAR,
  "create_tim" VARCHAR,
  "update_use" VARCHAR,
  "update_tim" VARCHAR,
  "shape_len" DOUBLE
);