About this Dataset

Micro-Market Recovery Program - Addresses

The City of Chicago launched the Micro-Market Recovery Program (MMRP), a coordinated effort among the City, not-for-profit intermediaries, and non-profit and for-profit capital sources to improve conditions, strengthen property values, and create environments supportive of private investment in targeted markets throughout the city. The goal of MMRP is to improve conditions, strengthen property values, and create environments supportive of private investment in targeted areas by strategically deploying public and private capital and other tools and resources in well-defined micro-markets. This address dataset contains additional geographies, such as Fire and Police Districts, Census Tract and TIF Zones, that can be linked to MMRP Permit, Case and Violation data using the ADDRKEY or ADDRGRPKEY.
Organization: City of Chicago
Last updated: 2020-11-10T16:54:44.883135
Tags: buildings, inspections

Tables

Table 1

@usgov.city_of_chicago_micro_market_recovery_program_addresses.table_1

1.8 MB
20,504 rows
21 columns

CREATE TABLE table_1 (
  "mmrp_zone" VARCHAR,
  "street_number" BIGINT,
  "pre_direction" VARCHAR,
  "street_name" VARCHAR,
  "suffix" VARCHAR,
  "post_direction" VARCHAR,
  "zip_code" BIGINT,
  "community_area" BIGINT,
  "ward" BIGINT,
  "fire_district" VARCHAR,
  "police_district" BIGINT,
  "census_tract" BIGINT,
  "tif_zone" VARCHAR,
  "x_coord" DOUBLE,
  "y_coord" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "central_business_district" VARCHAR,
  "address_key" BIGINT,
  "address_grouping_key" DOUBLE,
  "location" VARCHAR
);