Dataset: Detroit Blocks, With Vacancy Index Summaries, 2014-15

About this Dataset

Detroit Blocks, With Vacancy Index Summaries, 2014-15

The D3 vacancy index was designed to provide a more nuanced assessment of structural vacancy than the "occupied/unoccupied/maybe" categories used in the Motor City Mapping windshield survey. The dataset includes several sources, including Motor City Mapping, utility data, and other resources to create a score evaluating the occupancy status of a parcel. These values are then coded as "Likely Occupied", "Potentially Vacant", "Likely Vacant", and "Very Likely Vacant", helping to show a spectrum of vacancy across Detroit at three points in time: July 2014, November 2014, and May 2015.

Because the vacancy index incorporates proprietary data sources, D3 is unable to release the raw values of the index to the public at the address level. To allow the public to obtain some of the benefit from this highly-effective tool, however, D3 aggregated this data to the Census block level. This file allows Detroit's policymakers and community members to track vacancy across the city using data that is as up-to-date as possible.

Field description metadata are available upon request.
Organization: City of Ferndale, Michigan
Last updated: 2024-02-21T07:04:08.595790
Tags: 2014, 2015, block, blocks, change-over-time, motor-city-mapping, vacancy

Tables

Table 1

@usgov.city_of_ferndale_michigan_detroit_blocks_with_vacancy__8bb54226.table_1

1.29 MB
15935 rows
26 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "statefp10" BIGINT,
  "countyfp10" BIGINT,
  "tractce10" BIGINT,
  "blockce10" BIGINT,
  "geoid10" BIGINT,
  "name10" VARCHAR,
  "mcdname" VARCHAR,
  "totalstructures_072014" BIGINT,
  "likelyoccupied_072014" BIGINT,
  "potentiallyvacant_072014" BIGINT,
  "likelyvacant_072014" BIGINT,
  "verylikelyvacant_072014" BIGINT,
  "totalstructures_112014" BIGINT,
  "likelyoccupied_112014" BIGINT,
  "potentiallyvacant_112014" BIGINT,
  "likelyvacant_112014" BIGINT,
  "verylikelyvacant_112014" BIGINT,
  "totalstructures_052015" BIGINT,
  "likelyoccupied_052015" BIGINT,
  "potentiallyvacant_052015" BIGINT,
  "likelyvacant_052015" BIGINT,
  "verylikelyvacant_052015" BIGINT,
  "globalid" VARCHAR,
  "shape_starea" DOUBLE,
  "shape_stlength" DOUBLE
);