About this Dataset

Detroit Residential Parcel Survey, 2009

In 2009, Data Driven Detroit partnered with Living Cities, the Detroit Office of Foreclosure Prevention and Response and Community Legal Resources (Michigan Community Resources) to conduct a survey of 1-4 unit residential structures and vacant lots in the City of Detroit. Surveyors went out in the field in August and September of 2009, and following this, data were entered into a database and cleaned. The survey collected information on property type, condition, vacancy, danger to the surrounding community, fire damage, and improvements on vacant lots.For more information on the DRPS, including aggregations and maps of the original data, please visit www.detroitparcelsurvey.org.

Upon request, field description metadata is also available for this dataset.
Organization: City of Ferndale, Michigan
Last updated: 2024-02-21T07:04:18.489151
Tags: 2009, condition, drps, housing, occupancy, parcels, property, residential, structure, survey

Tables

Table 1

@usgov.city_of_ferndale_michigan_detroit_residential_parcel_s_9dd41876.table_1

13.17 MB
343,849 rows
24 columns

CREATE TABLE table_1 (
  "autoid" BIGINT,
  "parcelnumber" VARCHAR,
  "stfidblock" BIGINT,
  "tract" BIGINT,
  "blockgroup" BIGINT,
  "block" BIGINT,
  "addressnumber" DOUBLE,
  "dir" VARCHAR,
  "street" VARCHAR,
  "propaddresscombined" VARCHAR,
  "odd_even" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "address_new" VARCHAR,
  "type" VARCHAR,
  "condition" DOUBLE,
  "vacancy" DOUBLE,
  "vod" DOUBLE,
  "fire" DOUBLE,
  "vacant_lot" DOUBLE,
  "atlas" VARCHAR,
  "row_id" VARCHAR,
  "col_id" BIGINT,
  "col_number" BIGINT
);