About this Dataset

Schools With Average Commute 2013-14

The Michigan Center for Educational Performance and Information (CEPI), working with the Michigan Center for Shared Solutions (CSS) provided Data Driven Detroit (D3) with census block codes approximating student residence locations from the October 2013 student count for all students attending a public school in Detroit (DPS, Charter, EAA). With this data, D3 calculated the street-grid distance traveled from home (approximate location) to school for each student that attended a school in Detroit. We then calculated an average distance traveled by students of each school. Ann Arbor Magnet school (and possibly others) is not included in these data due to omission from the original data submission to D3. Average distances were calculated after first removing outlier student locations in counties outside of Wayne, Oakland, Macomb and Washtenaw. Distances were calculated using shortest distance routes from schools to the center of the Census Tract of residence.
Organization: City of Ferndale, Michigan
Last updated: 2024-02-21T07:04:21.616958
Tags: charter, commute, detroit, dispersion, dps, eaa, education, kids, schools, transportation, travel-time, youth

Tables

Table 1

@usgov.city_of_ferndale_michigan_schools_with_average_commute_9ee15af3.table_1

35.35 kB
209 rows
19 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "building_code" BIGINT,
  "school_name" VARCHAR,
  "type" VARCHAR,
  "authorized_grades" VARCHAR,
  "district" VARCHAR,
  "charter_authorizer" VARCHAR,
  "esp_2013_2014" VARCHAR,
  "street_address" VARCHAR,
  "school_type" VARCHAR,
  "zip" BIGINT,
  "alternative_flag" DOUBLE,
  "school_label" VARCHAR,
  "skillmanarea" VARCHAR,
  "skillmanareaalt" VARCHAR,
  "totalstudentsfall2013" BIGINT,
  "schooltype2" VARCHAR,
  "totalstudentmiles" DOUBLE,
  "avgstudentmiles" DOUBLE
);