Transportation by US Government | Transportation and Logistics

About this Dataset

Transportation

OUTDATED. See the current data at https://data.cityofchicago.org/d/6imu-meau --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-06-08T09:00:45.019611
Tags: deprecated, gis, kml, map_layer, shapefiles, streets, transportation

Tables

Table 1

@usgov.city_of_chicago_transportation_48eaf.table_1

14.26 MB
56321 rows
48 columns


CREATE TABLE table_1 (
  "trans_id" BIGINT,
  "the_geom" VARCHAR,
  "tnode_id" BIGINT,
  "fnode_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" DOUBLE,
  "l_censusbl" DOUBLE,
  "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
);