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

About this Dataset

StreetMidline2015

The Street Midlines in this feature class represent the interpreted midline between the compiled edges of pavement. Unimproved rights-of-way are also included in this database.
Organization: Cook County of Illinois
Last updated: 2024-04-12T17:42:04.026712
Tags: centerlines, gis, inactive, maps, midlines, streets, transportation

Tables

Table 1

@usgov.cook_county_of_illinois_streetmidline2015.table_1

65.11 MB
250439 rows
80 columns


CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "uniqueid" BIGINT,
  "type" BIGINT,
  "majorroad" VARCHAR,
  "laddrfrom" VARCHAR,
  "laddrto" VARCHAR,
  "raddrfrom" VARCHAR,
  "raddrto" VARCHAR,
  "stnameprd" VARCHAR,
  "stnameprm" VARCHAR,
  "stnameprt" VARCHAR,
  "stname" VARCHAR,
  "stnamepot" VARCHAR,
  "stnamepod" VARCHAR,
  "stnamepom" VARCHAR,
  "fullstna" VARCHAR,
  "fulstnaab" VARCHAR,
  "stnameprd1" VARCHAR,
  "stnameprm1" VARCHAR,
  "stnameprt1" VARCHAR,
  "stname1" VARCHAR,
  "stnamepot1" VARCHAR,
  "stnamepod1" VARCHAR,
  "stnamepom1" VARCHAR,
  "fullstna1" VARCHAR,
  "fulstnaab1" VARCHAR,
  "honstname" VARCHAR,
  "honstname1" VARCHAR,
  "dedicated" VARCHAR,
  "lcity" VARCHAR,
  "rcity" VARCHAR,
  "luspsst" VARCHAR,
  "ruspsst" VARCHAR,
  "zipl" BIGINT,
  "zipr" BIGINT,
  "hwytype" VARCHAR,
  "hwyno" DOUBLE,
  "fullhina" VARCHAR,
  "hwytype1" VARCHAR,
  "hwyno1" DOUBLE,
  "fullhina1" VARCHAR,
  "hwytype2" VARCHAR,
  "hwyno2" DOUBLE,
  "fullhina2" VARCHAR,
  "hwytype3" VARCHAR,
  "hwyno3" VARCHAR,
  "fullhina3" VARCHAR,
  "rte_hrchy" BIGINT,
  "grade_sep" BIGINT,
  "from_grade" BIGINT,
  "to_grade" BIGINT,
  "surface" BIGINT,
  "spdlimit" BIGINT,
  "length" DOUBLE,
  "minute" DOUBLE,
  "oneway" VARCHAR,
  "htrestrc" VARCHAR,
  "longitude" VARCHAR,
  "latitude" VARCHAR,
  "univrsldt" VARCHAR,
  "cfcccode" VARCHAR,
  "gnismunil" VARCHAR,
  "gnismunir" VARCHAR,
  "gnistwp" DOUBLE,
  "gniscnty" DOUBLE,
  "gnisstate" DOUBLE,
  "coordaccu" BIGINT,
  "editor" VARCHAR,
  "edittime" VARCHAR,
  "edittype" VARCHAR,
  "reviewer_i" VARCHAR,
  "review_dat" VARCHAR,
  "opstatus" VARCHAR,
  "anomaly" VARCHAR,
  "msagstat" VARCHAR,
  "pwa_commen" VARCHAR,
  "orthoyear" VARCHAR,
  "safezone" VARCHAR,
  "safezoneen" VARCHAR,
  "shape_len" DOUBLE
);