This is a collection of layers created by Tian Xie(Intern in DDP) in August, 2018. This collection includes Detroit Parcel Data(Parcel_collector), InfoUSA business data(BIZ_INFOUSA), and building data(Building). The building and business data have been edited by Tian during field research and have attached images.

The original source for these layers are:

Business Data: InfoUSA business database purchased by DDP in 2017
Building Data: Detroit Building Footprint data
Parcel Data: from Detroit Open Data Portal, download in May 2018.

For field research by Tian, some fields have been added and some records in building and business have been edited.

For business data, Tian confirmed most of public assessable businesses and deleted those which do not exist. Also, Tian add new Business to the business data if it did not exist on the record.
For building data, Tian recorded the total business space for each building, not-empty business space, occupancy status, parking adjacency status, and took picture for every building in downtown Detroit.

Detail field META DATA:

InfoUSA Business

OBJECTID_1
COMPANY_NA: company name
ADDRESS: company address
CITY: city
STATE: state
ZIP_CODE: zip code
MAILING_CA: source InfoUSA
MAILING_DE source InfoUSA
LOCATION_A source InfoUSA: address
LOCATION_1 source InfoUSA: city
LOCATION_2 source InfoUSA: state
LOCATION_3 source InfoUSA: zip code
LOCATION_4source InfoUSA
LOCATION_5 source InfoUSA
COUNTY: county
PHONE_NUMB: phone number
WEB_ADDRES: website address
LAST_NAME: contact last name
FIRST_NAME: contact first name
CONTACT_TI: contact type
CONTACT_PR:
CONTACT_GE: contact gender
ACTUAL_EMP: employee number
EMPLOYEE_S: employee number class
ACTUAL_SAL: actual sale
SALES_VOLU: sales value
PRIMARY_SI: primary sales value
PRIMARY__1: primary classification
SECONDARY_: secondary classification
SECONDARY1
SECONDAR_1
SECONDAR_2
CREDIT_ALP: credit level
CREDIT_NUM: credit number
HEADQUARTE: headquarte
YEAR_1ST_A: year open
OFFICE_SIZ: office size
SQUARE_FOO: square foot
FIRM_INDIV:
PUBLIC_PRI
Fleet_size
FRANCHISE_
FRANCHISE1
INDUSTRY_S
ADSIZE_IN_
METRO_AREA
INFOUSA_ID
LATITUDE: y
LONGITUDE: x
PARKING: parking adjacency
NAICS_CODE: NAICS CODE
NAICS_DESC: NAICS DESCRIPTION
parcelnum*: PARCEL NUMBER
parcelobji* PARCEL OBJECT ID
CHECK_*
ACCESSIABLE* PUBLIC ACCESSIBILITY
PROPMANAGER* PROPERTY MANAGER
GlobalID

Notes: field with * means it came from other source or field research done by Tian Xie in Aug, 2018

Building

OBJECTID_12
BUILDING_I: building id
PARCEL_ID : parcel id
BUILD_TYPE: building type
CITY_ID：city id
APN: parcel number
RES_SQFT: Res square feet
NONRES_SQF non-res square feet
YEAR_BUILT: year built
YEAR_DEMO
HOUSING_UN: housing units
STORIES: # of stories
MEDIAN_HGT: median height
CONDITION: building condition
HAS_CONDOS: has condos or not
FLAG_SQFT: flag square feet
FLAG_YEAR_: flag year
FLAG_CONDI: flag condition
LOADD1: address number
HIADD1 (type: esriFieldTypeInteger, alias: HIADD1, SQL Type: sqlTypeOther, nullable: true, editable: true)
STREET1: street name
LOADD2:
HIADD2 (type: esriFieldTypeString, alias: HIADD2, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
STREET2 (type: esriFieldTypeString, alias: STREET2, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
ZIPCODE: zip code
AKA: building name
USE_LOCATO
TEMP (type: esriFieldTypeString, alias: TEMP, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
SPID (type: esriFieldTypeInteger, alias: SPID, SQL Type: sqlTypeOther, nullable: true, editable: true)
Zone (type: esriFieldTypeString, alias: Zone, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
F7_2SqMile (type: esriFieldTypeString, alias: F7_2SqMile, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
Shape_Leng (type: esriFieldTypeDouble, alias: Shape_Leng, SQL Type: sqlTypeOther, nullable: true, editable: true)
PARKING*: parking adjacency
OCCUPANCY*: occupied or not
BuildingType* : building type
TotalBusinessSpace*: available business space in this building
NonEmptySpace*: non-empty business space in this building
CHECK_*
FOLLOWUP*: need followup or not
GlobalID*
PropmMana*: property manager

Notes: field with * means it came from other source or field research done by Tian Xie in Aug, 2018

Showcases featuring BIZ INFOUSA