About this Dataset

Neighborhood Change Index Variables 20181010

This layer includes the variables (by 2010 census block) used in the Neighborhood Change Index created by Data Driven Detroit in October 2018 for the Turning the Corner project. The final neighborhood change index was created using the average scores of five factors, which were made up of various combinations of these variables.
Organization: City of Ferndale, Michigan
Last updated: 2024-02-21T06:59:01.449378
Tags: blocks, neighborhood, neighborhood-change, turning-the-corner, variables

Tables

Table 1

@usgov.city_of_ferndale_michigan_neighborhood_change_index_va_70ee36b1.table_1

10.8 MB
329,885 rows
30 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "geoid10" BIGINT,
  "pctparcels" DOUBLE,
  "use_reside" DOUBLE,
  "medianvalu" DOUBLE,
  "comaddress" DOUBLE,
  "comvacancy" DOUBLE,
  "constructi" DOUBLE,
  "resaddress" DOUBLE,
  "resvacancy" DOUBLE,
  "demolition" DOUBLE,
  "structuref" DOUBLE,
  "firealarmc" DOUBLE,
  "taxforeclo" DOUBLE,
  "blight_vio" DOUBLE,
  "inactive_d" DOUBLE,
  "water_shut" DOUBLE,
  "rentalcoun" DOUBLE,
  "f_salescou" DOUBLE,
  "propertycr" DOUBLE,
  "violentcri" DOUBLE,
  "speculator" DOUBLE,
  "socadvq" VARCHAR,
  "housingq" VARCHAR,
  "businessq" VARCHAR,
  "proactq" VARCHAR,
  "crmupdq" VARCHAR,
  "indxq" VARCHAR,
  "shape_area" DOUBLE  -- Shape, Area,
  "shape_length" DOUBLE  -- Shape, Length
);