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 2017Building 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 nameADDRESS: company addressCITY: citySTATE: stateZIP_CODE: zip codeMAILING_CA: source InfoUSAMAILING_DE source InfoUSALOCATION_A source InfoUSA: addressLOCATION_1 source InfoUSA: cityLOCATION_2 source InfoUSA: stateLOCATION_3 source InfoUSA: zip codeLOCATION_4source InfoUSALOCATION_5 source InfoUSACOUNTY: countyPHONE_NUMB: phone numberWEB_ADDRES: website addressLAST_NAME: contact last nameFIRST_NAME: contact first nameCONTACT_TI: contact type CONTACT_PR: CONTACT_GE: contact genderACTUAL_EMP: employee numberEMPLOYEE_S: employee number classACTUAL_SAL: actual sale SALES_VOLU: sales value PRIMARY_SI: primary sales valuePRIMARY__1: primary classificationSECONDARY_: secondary classification SECONDARY1SECONDAR_1SECONDAR_2CREDIT_ALP: credit level CREDIT_NUM: credit numberHEADQUARTE: headquarteYEAR_1ST_A: year openOFFICE_SIZ: office sizeSQUARE_FOO: square footFIRM_INDIV:PUBLIC_PRI Fleet_size FRANCHISE_ FRANCHISE1 INDUSTRY_SADSIZE_IN_METRO_AREA INFOUSA_ID LATITUDE: yLONGITUDE: xPARKING: parking adjacency NAICS_CODE: NAICS CODENAICS_DESC: NAICS DESCRIPTION parcelnum: PARCEL NUMBER parcelobji PARCEL OBJECT IDCHECK_ ACCESSIABLE PUBLIC ACCESSIBILITYPROPMANAGER PROPERTY MANAGERGlobalID Notes: field with * means it came from other source or field research done by Tian Xie in Aug, 2018BuildingOBJECTID_12 BUILDING_I: building idPARCEL_ID : parcel id BUILD_TYPE: building type CITY_ID：city id APN: parcel number RES_SQFT: Res square feet NONRES_SQF non-res square feetYEAR_BUILT: year built YEAR_DEMOHOUSING_UN: housing unitsSTORIES: # of stories MEDIAN_HGT: median height CONDITION: building condition HAS_CONDOS: has condos or not FLAG_SQFT: flag square feet FLAG_YEAR_: flag yearFLAG_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_LOCATOTEMP (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 buildingNonEmptySpace: non-empty business space in this buildingCHECK_ FOLLOWUP: need followup or notGlobalIDPropmMana: property manager Notes: field with * means it came from other source or field research done by Tian Xie in Aug, 2018