About this Dataset

City-Owned Land Inventory

Property currently or historically owned and managed by the City of Chicago. Information provided in the database, or on the City’s website generally, should not be used as a substitute for title research, title evidence, title insurance, real estate tax exemption or payment status, environmental or geotechnical due diligence, or as a substitute for legal, accounting, real estate, business, tax or other professional advice. The City assumes no liability for any damages or loss of any kind that might arise from the reliance upon, use of, misuse of, or the inability to use the database or the City’s web site and the materials contained on the website. The City also assumes no liability for improper or incorrect use of materials or information contained on its website. All materials that appear in the database or on the City’s web site are distributed and transmitted "as is," without warranties of any kind, either express or implied as to the accuracy, reliability or completeness of any information, and subject to the terms and conditions stated in this disclaimer. The following columns were added 4/14/2023: - Sales Status - Sale Offering Status - Sale Offering Reason - Square Footage - City Estimate - Land Value (2022) -- Note: The year will change over time. The following columns were added 3/19/2024: - Application Use - Grouped Parcels - Application Deadline - Offer Round - Application URL
Organization: City of Chicago
Last updated: 2020-11-10T16:54:37.592091

Tables

Table 1

@usgov.city_of_chicago_city_owned_land_inventory.table_1

1.97 MB
20,652 rows
29 columns

CREATE TABLE table_1 (
  "id" BIGINT,
  "pin" VARCHAR,
  "address" VARCHAR,
  "managing_organization" VARCHAR,
  "property_status" VARCHAR,
  "date_of_acquisition" VARCHAR,
  "date_of_disposition" TIMESTAMP,
  "sales_status" VARCHAR,
  "sale_offering_status" VARCHAR,
  "sale_offering_reason" VARCHAR,
  "sq_ft" DOUBLE  -- Sq. Ft.,
  "square_footage_city_estimate" DOUBLE  -- Square Footage - City Estimate,
  "land_value_2022" DOUBLE  -- Land Value (2022),
  "ward" DOUBLE,
  "community_area_number" DOUBLE,
  "community_area_name" VARCHAR,
  "zoning_classification" VARCHAR,
  "zip_code" DOUBLE,
  "last_update" TIMESTAMP,
  "application_use" VARCHAR,
  "grouped_parcels" VARCHAR,
  "application_deadline" TIMESTAMP,
  "offer_round" VARCHAR,
  "application_url" VARCHAR,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);