Description

more
In the fall of 2013, the Detroit Blight Removal Task Force commissioned Data Driven Detroit (D3), the Michigan Nonprofit Association, and LOVELAND Technologies to complete a survey of every parcel in the City of Detroit. This 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. From December 4, 2013, to February 16, 2014, the team collected data on over 370,000 properties, including information on use and condition of structures, fire damage, boarding, and the presence of dumping. This dataset formed the centerpiece of the Blight Removal Task Force's report, "Every Neighborhood has a Future...and It Doesn't Include Blight." Following the completion of the survey, D3 and LOVELAND have continued to collaborate on a second phase of the Motor City Mapping project, involving the build-out of a technology infrastructure intended to keep the data updated as conditions change across the city. LOVELAND issued a public release of the "Blexting" application used to conduct the initial survey, allowing Detroit's residents, workers, and community organizations to survey properties across the city. Responses, or "blexts", are reviewed by a quality-control team to ensure that the information is consistent with the standards set forth by D3 and LOVELAND, and then are displayed publicly on www.motorcitymapping.org. This file consists of the most recent "blext" for each parcel through October 1, 2014, the date that responsibility for surveying and quality control transitioned from D3 to LOVELAND. In addition to the MCM dataset, D3 has enhanced this file with several other datasets, including 2014 tax foreclosures and delinquency, likely public ownership, and building footprint information. The tax foreclosure data flags properties that were likely headed to Tax Foreclosure as of August, 2014, while the tax delinquency data dates to June, 2014. Likely public ownership identifies properties identified by one of several sources as being owned by a public entity as of 2013/2014, while the building footprint information has been aggregated to parcel and dates to 2008. Metadata accompanying this dataset includes field description metadata and a narrative document describing the process of creating the final file. We look forward to seeing how this data can lead to a deeper understanding of Detroit! For more information about the Blight Removal Task Force, and to download the full report, please visit http://www.timetoendblight.com. For more information about the Motor City Mapping project, visit http://www.motorcitymapping.org.

Dataset Attributes

  • OBJECTID
    Number
  • D3_SurveyParcelID
    Text
    {"value"=>"21069531.20414", "count"=>1} (), {"value"=>"21051671.13038", "count"=>1} (), {"value"=>"21043736.8292", "count"=>1} (), {"value"=>"18011829.2168", "count"=>1} (), {"value"=>"17006619.9373", "count"=>1} (), {"value"=>"16006805.16356", "count"=>1} (), {"value"=>"15001620.14248", "count"=>1} (), {"value"=>"22067591.8969", "count"=>1} (), {"value"=>"22064489.17476", "count"=>1} (), {"value"=>"22048990.22925", "count"=>1} ()
  • CityParcelID2013
    Text
    {"value"=>"16002754.", "count"=>1} (), {"value"=>"13003407.", "count"=>1} (), {"value"=>"09014687.", "count"=>1} (), {"value"=>"20006257.", "count"=>1} (), {"value"=>"16033126.", "count"=>1} (), {"value"=>"13014238.", "count"=>1} (), {"value"=>"22121923.001", "count"=>1} (), {"value"=>"13024516.009", "count"=>1} (), {"value"=>"22121969.", "count"=>1} (), {"value"=>"22101769.", "count"=>1} ()
  • AddCombo
    Text
    {"value"=>" ", "count"=>55} (), {"value"=>"100 S WEST END", "count"=>2} (), {"value"=>"10035 VIOLETLAWN", "count"=>1} (), {"value"=>"10035 VAUGHAN", "count"=>1} (), {"value"=>"10035 RUTLAND", "count"=>1} (), {"value"=>"10035 QUINCY", "count"=>1} (), {"value"=>"10035 ORANGELAWN", "count"=>1} (), {"value"=>"10035 MONTROSE", "count"=>1} (), {"value"=>"10035 MEMORIAL", "count"=>1} (), {"value"=>"10035 MCKINNEY", "count"=>1} ()
  • Address_Number
    Text
    {"value"=>"20101", "count"=>90} (), {"value"=>"14900", "count"=>85} (), {"value"=>"19440", "count"=>79} (), {"value"=>"14300", "count"=>77} (), {"value"=>"18501", "count"=>72} (), {"value"=>"14601", "count"=>72} (), {"value"=>"19321", "count"=>71} (), {"value"=>"17190", "count"=>70} (), {"value"=>"5200", "count"=>69} (), {"value"=>"5050", "count"=>63} ()
  • Address_Direction
    Text
    {"value"=>" ", "count"=>354158} (), {"value"=>"W", "count"=>11904} (), {"value"=>"E", "count"=>10942} (), {"value"=>"S", "count"=>1950} (), {"value"=>"N", "count"=>594} (), {"value"=>"14", "count"=>1} ()
  • Street
    Text
    {"value"=>"WARREN", "count"=>1574} (), {"value"=>"ST MARYS", "count"=>1450} (), {"value"=>"MANSFIELD", "count"=>1419} (), {"value"=>"GRAND BLVD", "count"=>1363} (), {"value"=>"STAHELIN", "count"=>1360} (), {"value"=>"RUTHERFORD", "count"=>1323} (), {"value"=>"ROSEMONT", "count"=>1299} (), {"value"=>"HEYDEN", "count"=>1293} (), {"value"=>"FORRER", "count"=>1284} (), {"value"=>"FIELDING", "count"=>1255} ()
  • Zip
    Text
    {"value"=>"48228", "count"=>23889} (), {"value"=>"48227", "count"=>23267} (), {"value"=>"48205", "count"=>22877} (), {"value"=>"48213", "count"=>21886} (), {"value"=>"48219", "count"=>21403} (), {"value"=>"48235", "count"=>21061} (), {"value"=>"48234", "count"=>20742} (), {"value"=>"48221", "count"=>18491} (), {"value"=>"48204", "count"=>18116} (), {"value"=>"48224", "count"=>17999} ()
  • PCount
    Number
    0 to 334
  • Blext_ID
    Text
    {"value"=>"298272", "count"=>1} (), {"value"=>"162537", "count"=>1} (), {"value"=>"337341", "count"=>1} (), {"value"=>"263234", "count"=>1} (), {"value"=>"357911", "count"=>1} (), {"value"=>"78160", "count"=>1} (), {"value"=>"325113", "count"=>1} (), {"value"=>"55760", "count"=>1} (), {"value"=>"325611", "count"=>1} (), {"value"=>"176229", "count"=>1} ()
  • Blext_Created
    Date
    1386167407000 to 1412008833000
  • User_ID
    Text
    {"value"=>"2719", "count"=>9967} (), {"value"=>"2727", "count"=>9762} (), {"value"=>"2767", "count"=>8580} (), {"value"=>"2752", "count"=>7914} (), {"value"=>"2776", "count"=>7888} (), {"value"=>"2714", "count"=>6263} (), {"value"=>"2939", "count"=>5923} (), {"value"=>"2765", "count"=>5859} (), {"value"=>"2738", "count"=>5726} (), {"value"=>"2775", "count"=>5570} ()
  • Blext_Updated
    Date
    1386255858000 to 1412115650000
  • Reviewer_ID
    Text
    {"value"=>"3041", "count"=>25033} (), {"value"=>"3047", "count"=>18876} (), {"value"=>"3044", "count"=>18126} (), {"value"=>"3046", "count"=>15614} (), {"value"=>"3049", "count"=>13466} (), {"value"=>"3054", "count"=>13323} (), {"value"=>"3121", "count"=>12416} (), {"value"=>"3042", "count"=>12112} (), {"value"=>"3127", "count"=>11554} (), {"value"=>"3048", "count"=>10946} ()
  • Blext_Status
    Number
    1 to 1
  • Photo_URL
    Text
  • Structure
    Text
    {"value"=>"yes", "count"=>261188} (), {"value"=>"no", "count"=>112096} ()
  • Use
    Text
    {"value"=>"residential", "count"=>243665} (), {"value"=>"unknown", "count"=>75121} (), {"value"=>"private", "count"=>31042} (), {"value"=>"commercial", "count"=>11456} (), {"value"=>"public", "count"=>6832} (), {"value"=>"institutional", "count"=>2802} (), {"value"=>"industrial", "count"=>1483} (), {"value"=>"mixed", "count"=>892} ()
  • Condition
    Text
    {"value"=>"good", "count"=>218432} (), {"value"=>"fair", "count"=>30069} (), {"value"=>"poor", "count"=>8566} (), {"value"=>"suggest demolition", "count"=>4332} ()
  • Occupancy
    Text
    {"value"=>"occupied", "count"=>202145} (), {"value"=>"unoccupied", "count"=>48231} (), {"value"=>"maybe", "count"=>10869} ()
  • Needs_Boarding
    Text
    {"value"=>"no", "count"=>233713} (), {"value"=>"yes", "count"=>27601} ()
  • Fire
    Text
    {"value"=>"no", "count"=>254594} (), {"value"=>"yes", "count"=>6735} ()
  • Dumping
    Text
    {"value"=>"no", "count"=>362966} (), {"value"=>"yes", "count"=>10275} ()
  • Units
    Text
    {"value"=>"1 unit", "count"=>223062} (), {"value"=>"2-3 units", "count"=>18337} (), {"value"=>"4+ units", "count"=>2879} (), {"value"=>"0 units", "count"=>1022} ()
  • Improved
    Text
    {"value"=>"unimproved", "count"=>79243} (), {"value"=>"improved", "count"=>32841} ()
  • Maintained
    Text
    {"value"=>"no", "count"=>67453} (), {"value"=>"yes", "count"=>44578} ()
  • PublicUse
    Text
    {"value"=>"other", "count"=>3384} (), {"value"=>"parking lot", "count"=>2428} (), {"value"=>"park/garden", "count"=>1543} ()
  • Notes
    Text
  • GEOID10_Tract
    Text
    {"value"=>"26163511000", "count"=>3880} (), {"value"=>"26163514100", "count"=>2710} (), {"value"=>"26163524700", "count"=>2490} (), {"value"=>"26163514300", "count"=>2472} (), {"value"=>"26163504700", "count"=>2451} (), {"value"=>"26163536400", "count"=>2416} (), {"value"=>"26163512900", "count"=>2403} (), {"value"=>"26163534200", "count"=>2358} (), {"value"=>"26163512600", "count"=>2338} (), {"value"=>"26163500600", "count"=>2330} ()
  • NAMELSAD10_Tract
    Text
    {"value"=>"Census Tract 5110", "count"=>3880} (), {"value"=>"Census Tract 5141", "count"=>2710} (), {"value"=>"Census Tract 5247", "count"=>2490} (), {"value"=>"Census Tract 5143", "count"=>2472} (), {"value"=>"Census Tract 5047", "count"=>2451} (), {"value"=>"Census Tract 5364", "count"=>2416} (), {"value"=>"Census Tract 5129", "count"=>2403} (), {"value"=>"Census Tract 5342", "count"=>2358} (), {"value"=>"Census Tract 5126", "count"=>2338} (), {"value"=>"Census Tract 5006", "count"=>2330} ()
  • GEOID10_Block
    Text
    {"value"=>"261635143002010", "count"=>151} (), {"value"=>"261635361001005", "count"=>130} (), {"value"=>"261635189001018", "count"=>127} (), {"value"=>"261635126003001", "count"=>111} (), {"value"=>"261635078001027", "count"=>99} (), {"value"=>"261635141003008", "count"=>98} (), {"value"=>"261635302003001", "count"=>84} (), {"value"=>"261635372002006", "count"=>84} (), {"value"=>"261635351002004", "count"=>82} (), {"value"=>"261635437003000", "count"=>80} ()
  • NAME10_Block
    Text
    {"value"=>"Block 2005", "count"=>8364} (), {"value"=>"Block 1003", "count"=>8335} (), {"value"=>"Block 1004", "count"=>8164} (), {"value"=>"Block 2006", "count"=>8147} (), {"value"=>"Block 2002", "count"=>8080} (), {"value"=>"Block 1005", "count"=>8071} (), {"value"=>"Block 2004", "count"=>8069} (), {"value"=>"Block 1002", "count"=>8047} (), {"value"=>"Block 2003", "count"=>7965} (), {"value"=>"Block 2001", "count"=>7693} ()
  • GeoID10_BG
    Text
    {"value"=>"261635220001", "count"=>1568} (), {"value"=>"261635078001", "count"=>1320} (), {"value"=>"261635188002", "count"=>1188} (), {"value"=>"261635055001", "count"=>1166} (), {"value"=>"261635110004", "count"=>1146} (), {"value"=>"261635073003", "count"=>1104} (), {"value"=>"261635110002", "count"=>1100} (), {"value"=>"261635129002", "count"=>1091} (), {"value"=>"261635184001", "count"=>1072} (), {"value"=>"261635249001", "count"=>1061} ()
  • DLBA_Flag
    Number
  • PublicOwnership_Flag
    Text
  • PublicOwnership_Count
    Number
  • TaxFC2014_Flag
    Text
  • TaxFC2014_Count
    Number
  • TaxDelinquency_062014
    Text
  • TaxDelinquency_062014_Amount
    Number
  • BuildingCount_2008
    Number
  • BuildingFootprint_TotalArea_2008
    Number
  • AvgMedBldgHeight_2008
    Number
  • ShedCount_2008
    Number
  • ShedFootprint_TotalArea_2008
    Number
  • AvgMedShedHeight_2008
    Number

Related Datasets