About this Dataset

Motor City Mapping, Certified Results, Winter 2013-14 ( Census Tract Aggregation)

In the fall of 2013, the Detroit Blight Removal Task Force commissioned Data Driven Detroit, the Michigan Nonprofit Association, and LOVELAND Technologies to conduct a survey of every parcel in the City of Detroit. The goal of the survey was to collect data on property condition and vacancy. The effort, called Motor City Mapping, leveraged relationships with the Rock Ventures family of companies and the Detroit Employment Solutions Corporation to assemble a dedicated team of over 200 resident surveyors, drivers, and quality control associates. Data collection occurred from December 4, 2013 until February 16, 2014, and the initiative resulted in survey information for over 370,000 parcels of land in the city of Detroit, identifying condition, occupancy, and use. The data were then extensively reviewed by the Motor City Mapping quality control team, a process that concluded on September 30, 2014.

This file contains the official certified results from the Winter 2013/2014 survey, aggregated to 2010 Census Tracts for easy mapping and analysis. The topics covered in the dataset include totals and calculated percentages for parcels in the categories of illegal dumping, fire damage, structural condition, existence of a structure or accessory structure, and improvements on lots without structures.

Metadata associated with this file includes field description metadata and a narrative summary documenting the process of creating the dataset.
Organization: City of Ferndale, Michigan
Last updated: 2024-02-21T07:03:17.038777
Tags: aggregation, blight, census-tract, comprehensive-parcel-survey, condition, dcps, detroit, lots, mcm, motor-city-mapping, parcel-survey, parcels, property-land-use-and-housing, structures, vacancy

Tables

Table 1

@usgov.city_of_ferndale_michigan_motor_city_mapping_certified_f670392a.table_1

270.24 kB
297 rows
108 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "geoid10" BIGINT,
  "sqmiles" DOUBLE,
  "acres" DOUBLE,
  "parcel_count" BIGINT,
  "total_surveyed" DOUBLE,
  "pctsurveyed" DOUBLE,
  "structureyes" DOUBLE,
  "pct_structureyes" DOUBLE,
  "structureno" DOUBLE,
  "pct_structureno" DOUBLE,
  "use_commercial" DOUBLE,
  "pctparcels_commercial" DOUBLE,
  "pctstructure_commercial" DOUBLE,
  "use_industrial" DOUBLE,
  "pctparcels_industrial" DOUBLE,
  "pctstructure_industrial" DOUBLE,
  "use_institutional" DOUBLE,
  "pctparcels_institutional" DOUBLE,
  "pctstructure_institutional" DOUBLE,
  "use_mixed" DOUBLE,
  "pctparcels_mixed" DOUBLE,
  "pctstructure_mixed" DOUBLE,
  "use_private" DOUBLE,
  "pctparcels_private" DOUBLE,
  "pctlots_private" DOUBLE,
  "use_public" DOUBLE,
  "pctparcel_public" DOUBLE,
  "pctlots_public" DOUBLE,
  "use_residential" DOUBLE,
  "pctparcels_residental" DOUBLE,
  "pctstructure_residential" DOUBLE,
  "structureno_unknown" DOUBLE,
  "pctparcelsno_unknown" DOUBLE,
  "pctlotsno_unknown" DOUBLE,
  "structureyes_unknown" DOUBLE,
  "pctparcelsyes_unknown" DOUBLE,
  "pctstructureyes_unknown" DOUBLE,
  "condition_good" DOUBLE,
  "pct_conditiongood" DOUBLE,
  "condition_fair" DOUBLE,
  "pctcondition_fair" DOUBLE,
  "condition_poor" DOUBLE,
  "pctcondition_poor" DOUBLE,
  "condition_suggestdemo" DOUBLE,
  "pctcondition_suggestdemo" DOUBLE,
  "avgconditionrating" DOUBLE,
  "resstructs_good" DOUBLE,
  "pctgood_resstruct" DOUBLE,
  "resstructs_fair" DOUBLE,
  "pctfair_resstruct" DOUBLE,
  "resstruct_poor" DOUBLE,
  "pctpoor_resstruct" DOUBLE,
  "resstruct_sugdemo" DOUBLE,
  "pctsugdemo_resstruct" DOUBLE,
  "resstruct_avgconditionrating" DOUBLE,
  "occupancy_occupied" DOUBLE,
  "pctstructures_occupied" DOUBLE,
  "occupancy_maybe" DOUBLE,
  "pctstructures_maybe" DOUBLE,
  "occupancy_unoccupied" DOUBLE,
  "pctstructures_unoccupied" DOUBLE,
  "resstruct_occupied" DOUBLE,
  "pctresstruct_occupied" DOUBLE,
  "resstruct_maybe" DOUBLE,
  "pctresstruct_maybe" DOUBLE,
  "resstruct_unoccupied" DOUBLE,
  "pctresstruct_unoccupied" DOUBLE,
  "boarding_yes" DOUBLE,
  "pctstructures_needboarding" DOUBLE,
  "fire_yes" DOUBLE,
  "pctstructures_fire" DOUBLE,
  "resstruct_needboarding" DOUBLE,
  "pctresstruct_boarding" DOUBLE,
  "resstruct_firedamage" DOUBLE,
  "pctresstruct_fire" DOUBLE,
  "structureno_dumpingyes" DOUBLE,
  "pctlots_withdumping" DOUBLE,
  "structureyes_dumpingyes" DOUBLE,
  "pctstructures_withdumping" DOUBLE,
  "totalparcels_withdumping" DOUBLE,
  "pcttotalparcels_withdumping" DOUBLE,
  "resmixunits_0units" BIGINT,
  "pctresmixunits_0units" DOUBLE,
  "resmixunits_1units" DOUBLE,
  "pctresmixunits_1units" DOUBLE,
  "resmixunits_2to3units" DOUBLE,
  "pctresmixunits_2to3units" DOUBLE,
  "resmixunits_4units" BIGINT,
  "pctresmixunits_4units" DOUBLE,
  "emptylots_improved" DOUBLE,
  "pctlots_improved" DOUBLE,
  "emptylots_unimproved" DOUBLE,
  "pctlots_unimproved" DOUBLE,
  "emptylot_maintained" DOUBLE,
  "pctlots_maintained" DOUBLE,
  "emptylot_unmaintained" DOUBLE,
  "pctlots_unmaintained" DOUBLE,
  "public_use_lots" DOUBLE,
  "emptylot_publicuse_parkgarden" DOUBLE
);