Demographic Data Analyst

School District Characteristics

Hide Navigation Pane

School District Characteristics

Previous topic Next topic No directory for this topic No expanding text in this topic  

School District Characteristics

Previous topic Next topic Topic directory requires JavaScript JavaScript is required for expanding text JavaScript is required for the print function Mail us feedback on this topic!  

Comments (...)

This section illustrates use of DDA focused on school districts.  Kansas statewide school districts are analyzed using data from Census 2010 Summary File 1 and TIGER shapefiles.


Start DDA


Select Kansas (KS) as the state to process (upper left "State" combobox).


Downloading Complete 2010 Census Summary File 1 (SF1) Data


Use File>Get Census SF1 to download the Kansas SF1. (optionally skip this step using the DVD as data source)

Use File>UnZip to expand all or selected SF1 segments.


Creating Complete or Partial SF1 Database


Use Tools>Create Census 2010 SF1 DBFs

   ... each of the SF1 segments is created as a dbase file.

   ... after conversion, any SF1 segment can be accessed with File>Open DBF.


Extracting Data from the Relational SF1 Database into Flat File


Use the pre-existing "itemlista.txt" file to select desired subject matter fields.

   ... alternatively load the SF1 all table/all subject matter items and multi-select items of interest.

   ... this example is focused on SF1 Table P3 Population by Race and P4 Hispanic Origin.


   ... any set of items can be extracted from SF1.

   ... click Help>SF1 Table Shells (xls) or SF1 Tables (doc) to view tables/items.

Data are extracted and a new flat dbase file is created ("extract1.dbf").

The Extract Query is set to sumlev='050' by default (only extract county data).

   ... select any summary level (e.g., sumlev='140' for census tracts).

   ... in this application, unified school districts are selected (sumlev='970')

Click Go button to proceed.



Mapping Applications


The next steps illustrate steps to integrate the "extract1.dbf" data with a shapefile for mapping.

However, some applications may not involve mapping.

Your SF1 processing might end here.


Downloading Shapefiles


Use File>Get Shapefile to download the Kansas unified school districts. (optionally skip this step using the DVD as data source).

   ... any Census 2010 shapefile may be accessed via the point and click lists; no need to know "FTP" or where the files are located.



Shapefile zip files are auto-expanded or you can use File>UnZip to expand the shapefile zip.

The Kansas unified school districts shapefile is now available on your computer.

In the next step, the SF1 "extract1.dbf" (created earlier, see above) is integrated with the shapefile dbf.


Integrating Data to TIGER/Line Shapefiles


Start Tools>DBMerge and select the shapefile dbf as File 1 and extract1 dbf as File 2:



To merge the data, the shapefile merge key is set to "GEOID10" and the extract1.dbf merge key is set to state+sduni.

All items (optionally) are moved from Source File 1 to Output File.

The final step is to click the Merge button.


The updated shapefile dbf may be inspected using DDA (File>Open DBF).

Field STUSAB and to the right have been merged from the extract1.dbf file.



Pattern Analysis; Creating Thematic Maps


The Kansas Census 2010 school district shapefile with integrated SF1 data is opened using the CommunityViewer GIS (CV) software.

Mapping capabilities are not included with DDA.

Use CV or other mapping software to create a thematic map.

A thematic map is created showing the percent Hispanic population by school district shown below.

The CV identify tool is used to show a profile for a selected school district (see pointer).

Comments (...)