Tag Archives: Kansas City

National Children & Education Statistics Program Updates

.. NCES Program updates .. tools, data & methodology to examine national scope children & education .. school, school district & extended geographic-statistical data with drill-down to school and intersection level. See more about the NCES Program below.

New this Week
ACS 2015 school district demographic-economic interactive tables
– view, compare, analyze selected/all U.S. school districts
– more focused blog updates coming soon.

School Districts with Highest Median Household Income
Use the interactive table to examine economic characteristics of school districts. Below is a list of the 10 school districts having the highest median household income developed using the Economic Characteristics interactive table. Develop similar views for metros and states of interest.

– ranked on item E062 — median household income.
– click graphic for larger view.

Use GIS tools to develop thematic pattern maps such as the one shown below with NCES GIS projects. Select from hundreds of statistical measures. Create your own regional;/district views. Integrate other data.

Patterns of Economic Prosperity by School District
– median household income (item E062 in table)

– view developed with CVGIS software & related GIS project and data.
– click graphic for larger view.

See the School Districts Economic Characteristics Interactive Table.

About the National Children & Education Statistics Program
The National Children & Education Statistics (NCES) Program provides access to tools, data & methodology to examine national scope children’s demographics & education-related characteristics. These resources enable stakeholders to view and analyze detailed geographic and statistical data at the school, neighborhood, community, attendance zone, school district and higher level geography. Integrate these data with drill-down demographic-economic data to the census block and intersection levels. Examine characteristics of schools, school districts and education data with related and higher level geography including urban/rural, cities, counties, metros, state and the U.S.

See NCES Main Section.

Contents: Summary of NCES Program Resources
Click a link to view more detail on a selected topic.
Updates: New Resources, Events & Related Topics
Analytics, Blogs, Studies
Using Software Tools & Datasets
01 Mapping & Visual Analysis Tools
02 School District Annual Demographic-Economic Data Resources
03 Children’s Demographics & Living Environment by School District
04 School District Enrollment & Operational Characteristics
05 School District Finances: Sources & Uses of Funds
06 School District Geographic Size & Characteristics
07 School District-ZIP Code Area Relationship Table
08 K-12 Public Schools
09 K-12 Private Schools
10 K-12 Public School Attendance Zones
11 K-12 Public Schools by Urban/Rural Status
12 Census Tract Demographic-Economic Characteristics
13 Metropolitan Area Situation & Outlook Reports

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Citizen Voting Age Population by Block Group

.. tools and resources to access and analyze citizen voting age population by block group … ideally analysts and stakeholders will examine patterns and characteristics of the citizen voting age population (CVAP) by block group. This is partly because of the extreme variability of CVAP within higher level geography — even at the census tract level. This becomes even more important in more densely populated areas. See about ACS 2014 CVAP block group demographics in this related Web section.

Patterns of ACS 2014 CVAP Population by Block Group
— Houston Area
See legend in lower right of graphic for interval/color correspondence. Click graphic for larger view; expand browser window for best quality view.

.. view developed with ProximityOne CV XE GIS and related GIS project.

The size, characteristics and distribution of the citizen voting age population by block group is very important.
• Block groups are the most granular geography at which we can study these demographics.
• The size of the citizen voting age population ultimately determines election outcomes.

This section provides thematic pattern map views and analyses of selected metros. These applications can be replicated for any area. They serve as an “analytical basis” that can be augmented with other methods and data (e.g., voter registration, voter propensity, voter turnout, and other election factors) to gain insights into election outcomes under alternative scenarios. Equally important, this information can be used to better equip voters with the potential impact of improved voting activity for their own neighborhood and larger areas (e.g., even congressional districts).

Using these GIS Resources; Obtaining Custom Maps & Analyses
Contact us (or call 888.364.7656) for maps and analyses for areas of interest or to use the integrated, ready-to-use, national scope GIS software, GIS project and datasets. Add your own data; create custom views.

CVAP Block Group Thematic Pattern Map shown below for Selected Areas
• Atlanta
• Chicago
• Los Angeles
• Kansas City
• Washington, DC

Patterns of ACS 2014 CVAP Population by Block Group
— Atlanta Area
See legend in lower right of graphic for interval/color correspondence. Click graphic for larger view; expand browser window for best quality view.

.. view developed with ProximityOne CV XE GIS and related GIS project.

Patterns of ACS 2014 CVAP Population by Block Group
— Chicago Area
See legend in upper right of graphic for interval/color correspondence. Click graphic for larger view; expand browser window for best quality view.

.. view developed with ProximityOne CV XE GIS and related GIS project.

Patterns of ACS 2014 CVAP Population by Block Group
— Los Angeles Area
See legend in upper right of graphic for interval/color correspondence. Click graphic for larger view; expand browser window for best quality view.

.. view developed with ProximityOne CV XE GIS and related GIS project.

Patterns of ACS 2014 CVAP Population by Block Group
— Kansas City Area
See legend in lower right of graphic for interval/color correspondence. Click graphic for larger view; expand browser window for best quality view.

.. view developed with ProximityOne CV XE GIS and related GIS project.

Patterns of ACS 2014 CVAP Population by Block Group
— Washington, DC Area
See legend in lower right of graphic for interval/color correspondence. Click graphic for larger view; expand browser window for best quality view.

.. view developed with ProximityOne CV XE GIS and related GIS project.

ACS 2014 CVAP Block Group Demographics
For the 217,479 block groups covering the U.S. wall-to-wall, the median citizen population value is 1,165 (291.8 million population) and the median citizen voting age population is 885 (220 million population). The median total population is 1,252 (314 million population). These data are based on the 2014 American Community Survey ACS 2014 CVAP special tabulation completed in early 2016. WHile the focus here is on the total population, the same scope of data is integrated into the shapefiles used here for 13 race/origin population groups. The 13 race/origin groups include:
  • American Indian or Alaska Native Alone
• Asian Alone
• Black Alone
• Native Hawaiian or Other Pacific Islander Alone
• White Alone
• American Indian or Alaska Native and White
• Asian and White
• Black and White
• American Indian or Alaska Native and Black
• Remainder of Two or More Races
• not Hispanic
• Hispanic (of any race)

Related CVAP Sections
Census Tracts; ACS 2009-13 special tabulation
Census Tracts; ACS 2009-13 special tabulation – Hispanic focus
Tracts & Congressional Districts; ACS 2009-13 special tabulation

See this blog post in this full, more detailed Web section.

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Developing & Using Map Graphics

.. steps to develop map graphics & visual analysis of market/study areas .. map graphics are an important part of most demographic-economic analyses and essential for many applications. Not only are are maps needed to show geographic boundaries and the relative location of geography within a broader area, they can come alive by showing patterns. A thematic pattern map of median household income by block group is a good example; higher and lower areas of economic prosperity by neighborhood can be immediately determined. Map graphics can improve our ability to communicate complex information. Convey information faster. Make more compelling presentations. Collaborate more effectively through the use of map graphics.  See related Web section for more details.

The focus of this section is on creating and using KML files to prepare map graphics for use in developing Market-Study Area Comparative Analysis Reports. These files and map graphics also have broader uses. Steps are reviewed to develop the KML circular area map graphics files, convert them to shapefile structure and integrate both files into mapping and GIS applications and put them into operational use. 

KML (Keyhole Markup Language) files are XML structured files useful for visualizing geographic objects (like circles) using Internet-based browsers, notably Google Earth. Why develop/use KML files? They are easy to create with precision, there is little to no learning curve, they can be used in many venues and they are free to develop. KML files can be used side-by-side with shapefiles. Shapefiles, structured very much unlike KML files, are the dominant vector-based file structure used in GIS applications involved in both viewing and geospatial analysis. 

Developing Circular KML Files & Map Graphics
An “objective view” of this section is shown in the following graphic. The graphic shows a study site location (red marker), 1-mile & 3-mile radius circles. The site location is a Starbucks located at 302 Nichols Road, Kansas City, MO 64112. The view shows a circular KML-based graphics in context of patterns of median household income by block group. Develop similar views for any area, any site circular configuration, using steps reviewed in this section.

– view developed using CV XE GIS

Creating the KML Circular Graphics File
Proceed through the next steps to develop a KML file used to create the graphic below on left — a Starbucks located at 302 Nichols Road, Kansas City, MO 64112. Graphic on the right is a Starbucks location in Paris, used to illustrate this process works globally. Both graphics include study area center point and 1-mile and 3-mile radius circles.

302 Nichols Road, Kansas City, MO 64112
23 Avenue de Wagram, 75001 Paris, France

Start the create KML file application
• Key in address 302 Nichols Road, Kansas City, MO 64112 to Google Maps
.. see the latitude-longitude (39.041548,-94.592965) in the URL bar.
• Open this web page to create the circles & save results as KML file.
• Refresh this page if making a new KML file.
• Set the colors and lines to medium, blank and clear.
• Enter coordinates — key in lat 39.041548 and lon -94.592965
.. these for for this example
.. enter the values for your location of interest
Add center point
• In the Radius Distance, key in 0.05 miles
• Click Draw Radius blue button (at right of longitude).
Add site 1 circle
• In the Radius Distance, key in 1.00 miles (use preferred radius for inner circle).
• Click Draw Radius blue button (at right of longitude).
Add site 2 circle
• In the Radius Distance, key in 3.00 miles (use preferred radius for inner circle).
• Click Draw Radius blue button (at right of longitude).
View study area geography
• Optionally navigate up to the map view and make the view similar to the graphic at the top of this page 
.. this step is not required but might be useful to verify the study area appearance.
Save KML file
• Navigate down the page to “Google Earth KML Output”. Click the blue button Generate KML.
• Click “Download KML file Here.” Save the file to a folder and make a note of the file path and name
.. save the file as c:\sitereport\302nichols.kml (this file and filename are used below).
Done
• The three part KML file has been created and saved to the local computer. 
• Finished using this browser application.

This same process may be used again to create similarly structured KML files of any radius about any point for any location in the world. 

Loading a KML file into Google Maps
Optionally create the objective map graphic using the following steps. Or, the KML file may be used with the CV XE GIS software (see below) enabling yet further analytical possibilities. 

 Click this link to start the Google MyMaps application.
• When the new page opens click create new map button
• Next click import button
• Enter the file path/name as created above (c:\sitereport\302nichols.kml), or any KML file.
• Edit the MyMaps rendering to achieve preferred view.
• Use preferred screen capture tool to save that part of the map view as a graphic for the study report.

Using the KML File with an Existing GIS Project and converting the KML file to shapefile structure

1. Add the KML file to an Existing CV XE GIS Project
• Start the CV XE GIS software and open the project file c:\cvxe\1\cvxe_us2.gis (distributed with installer).
.. uncheck Locations and $MHI x BG layers in legend panel.
• Click the AddLayer button (second button from left on toolbar)
• Select the KML file that was created above (c:\sitereport\302nichols.kml) .. circles appear in the map window.
• Use LayerEditor to adjust settings for KML layer (transparent, bold outline)
• Navigate to zoom-in view and smaller map window.
• Use Toolbar button Save to Image (button 7 from left) to save the map window view to a .jpg file.

Navigate to this view:

2. Converting a KML File to a Shapefile
This step requires the CV XE GIS Basic or higher level version. After the KML layer appears in the above sequence, proceed as follows:

• Click File>ExportShapefile.
• Select the KML layer name.
• Set Coordinate System edit box value to NAD83.
• Click OK button.
• On the Export Layer/FileSave dialog, select an output file path and name.
• The shapefile is generated and may be reused with any GIS project.

3. Editing attributes of the study area shapefile and project file
There are three shapes in the shapefile (center point, circle 1, circle 2). 
Modify the appearance of these shapes/objects by using the Select tool (mouse in Select mode).
• In legend panel click on circles layer; name turns blue indicating this is the active layer.
• In the map window, click in the circle; the profile/editor appears (pop-up)
• Initially all three shapes have the name “Polygon”.
.. change the object names successively to Point1 (the small circle), Circle1 and Circle2.
• The shapefile attributes have been permanently changed.
• When each shape/object has been renamed, use the LayerEditor to modify the appearance of each shape.
.. the changes modify the project file and not the shapefile.
.. optional save the project (overwriting the former version) or save the project with a new name.

Renaming a shape to “Point1”
Click for larger view

Using LayerEditor to set attributes of the study area layer
Click for larger view

View of final study area layer in context of broader project
Click for larger view

View as above with $MHI x BG checked on/visible
Click for larger view
 

Join me in a Data Analytics Lab session to discuss more details about accessing and using wide-ranging demographic-economic data and data analytics. Learn more about using these data for areas and applications of interest.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.

Crime Data Analytics

Goto ProximityOne .. examining crime incidence and socioeconomic patterns and analyzing small-area and location-based data.

.. what are the crime patterns in neighborhoods or areas of interest? It is challenging to get useful answers to this type of question. Crime incidence data by location/address are often difficult or not possible to obtain. Even where the location-based crime data are available, the data must be geocoded, e.g., assigned a census block code to each address. Separately demographic-economic must be organized to examine contextually with the crime data.

Integrating Crimes by Location & Patterns of Economic Prosperity
– View developed using CV XE GIS and related GIS project.

Crime Data Analytics. Use the Crime Incidence and Socioeconomic Patterns GIS project and associated datasets to explore relationships between crime and small area demographic-economic characteristics. Follow the steps described below to study patterns and relationships in Kansas City and/or use this framework to develop similar data analytics for other areas.

Framework for a case study. 409 of Missouri’s 4,506 block groups are within the jurisdiction of the Kansas City police department (KCPD) and had one or more crimes in 2014 (latest fully reported year). There were approximately 10,400 crimes recorded by the KCPD in 2014, in the city area spanning four counties. In this section tools and data are used to examine crime patterns in Kansas City, MO. Crime data are included as markers/locations in a GIS project. Crime data are also aggregated to the census block level and examined as summary data (aggregate crimes by census block). Crime data are related to American Community Survey (ACS) 2014 5-year demographic-economic data at the block group geographic level.

To perform these types of analyses, it is important to start with location-based crime data that have been attributed with type of offense (offense code). Ideally, each crime incidence data record includes minimally the offense code and address of the crime. Such location-based crime incidence data have been acquired from the KCPD. These data are used to develop a shapefile that can be included in a GIS project.

Patterns of Crime Incidence in Kansas City, MO
The following graphic shows patterns of crime incidence by census block for the “Plaza Area” within Kansas city. This view shows all types of crimes aggregated to the census block level. Crimes committed where a handgun was involved are shown as black/red circular markers. Click the graphic for a larger view that shows legend and more detail.
– View developed using CV XE GIS and related GIS project.

Related views (click link to view graphic in new window):
Use the GIS project to develop variations of these views. Optionally add your own data.
Lay of the land: Kansas City city (cross hatched) in context of metro
All crimes as markers in Kansas City in 2014

Patterns of Economic Prosperity & Crime Incidence
The following graphic shows patterns of economic prosperity (median household income $MHI) by block group for the same general area as above. This view illustrates how two types of crimes (burglary blue triangle markers and homicide (red/black square markers) can be examined in context. Click the graphic for a larger view that shows legend and more detail.

– View developed using CV XE GIS and related GIS project.

Related views (click link to view graphic in new window):
Use the GIS project to develop variations of these views.
View similar to above, without $MHI layer

Data used to analyze patterns of economic prosperity/$MHI are based on the American Community Survey (ACS) 2014 5-year estimates at the block group geographic level. The same scope of subject matter is available for higher level geography. The GIS project/datasets includes many types of demographic-economic subject matter that can be used to display/analyze different socioeconomic patterns.

Using Block Group Geography/Data
Census Block Groups sit in a “mid-range” geography between census blocks and census tracts. All cover the U.S. wall-to-wall and nest together, census blocks being the lowest common denominator for each. Block Groups (BGs) are the smallest geographic area for which annually updated ACS 5-year estimates data are tabulated.

Advantages of using BG geodemographics include the maximum degree of geographic drill-down (using ACS data) … enabling the most micro-perspective of demographics for a neighborhood or part of study area. A disadvantages of using BG estimates is that typically the smaller area estimates have a relatively higher error of estimate.

Crime Incidence and Socioeconomic Patterns GIS Project/Datasets
1. Install the ProximityOne CV XE GIS
… omit this step if CV XE GIS software already installed.
… run the CV XE GIS installer
… take all defaults during installation
2. Download the CISP GIS Project fileset
… requires ProximityOne User Group ID (join now)
… unzip CISP GIS project files to local folder c:\crime
3. Open the kcmo_crimes_2014.gis project
… after completing the above steps, click File>Open>Dialog
… open the file named C:\crime\kcmo_crimes_2014.gis
4. Done .. the start-up view shows the crime patterns.

Weekly Data Analytics Lab Sessions
Join me in a Data Analytics Lab session to discuss more details about accessing location-based data and block group demographics and integrating those data into analytical applications.  Learn more about integrating these data with other geography, your data and use of data analytics that apply to your situation.

About the Author
— Warren Glimpse is former senior Census Bureau statistician responsible for innovative data access and use operations. He is also the former associate director of the U.S. Office of Federal Statistical Policy and Standards for data access and use. He has more than 20 years of experience in the private sector developing data resources and tools for integration and analysis of geographic, demographic, economic and business data. Contact Warren. Join Warren on LinkedIn.