|
|
|
-- demographic-economic-geographic data & analysis July 2023 .. mapping and geospatial analysis of K-12 schools & school districts. Topic of the Day .. updates irregularly Which school district(s) have the highest Federal revenue as a percent of total revenue? .. what about your school districts of interest? Consider the objective of getting a list Virginia school districts ranked in descending order based on Federal revenue as a percent of total revenue and view a map of the top ranked district. Use VDA Web GIS .. all you need is a browser. The graphic below illustrates the answer. Lee County Public Schools has the highest Federal revenue as a percent of total revenue based on the FY 2021 (most recent data available) sources & uses of funds data available for all Virginia school districts. See steps below graphic to replicate this for any state or U.S.  Get started ... a few minutes away ... • Start VDA Web GIS and signin or register then signin. • After signin, optionally install VDA Desktop GIS .. skip that for now .. click continue. • On the next form, click the K-12 Schools & School Districts project and click Select. • Wait for interface to complete display. • Below the map to right, check the magnifying A icon .. the table view opens. • Below the table, click the Select Field button .. a list of fields displays - choose name, geoid and PCTFTOT .. click Set & Close. • In the SQL Filter edit box enter geoid like '51%' .. as shown in graphic above. • In the SORT edit box enter PCTFTOT DESC • Click Query button .. further to right .. the table sorts and appears as shown in graphic • To find/show a district in the map, click that row - then click button "click geography row to display" • Map refreshes with zoom to selected district. Done! Try a state of interest. Topics in this section • 01 School District Interactive Table & Profiles • 02 Demographic-Economic Data Explorer • 03 VDA GIS Tools • 04 Geographic Solutions and Demographic-Economic Estimates & Projections • 05 Web meetings Interactive Table & Profiles Use the interactive table below to view, rank, compare selected characteristics of each/all more than 13,000 school districts. New 2021-22 school year data have been recently added. Demographic-Economic Data Explorer Use the Demographic-Economic Data Explorer (DEDE) to access and create datasets drawn from Federal Statistical System Use DEDE to develop Comparative Analysis Profiles • Illustrative examples: ... Los Angeles Unified & Houston ISD ... Wichita USD KS & Kansas • Request one for your district; use this form .. enter primary & comparison district names in text box. • Illustrating side by side comparison of an ESD intersecting with corresponding SSD in Fresno, CA area ... Click to view Alvina ESD CA & Caruthers SSD CA HTML ACS 2019 5-year Caruthers district comprised of two separate parts  VDA GIS Tools Use the Visual Data Analytics (VDA) Web GIS to map and geospatially analyze schools and school districts in context of other geography and subject matter. GIS (Geographic Information System) tools can do more than just make maps. They help us understand patterns and relationships that can only be with this technology. Below are some examples of using VDA GIS tools. Patterns of Poverty Rate for Population Ages 5-17 by School District  .. click graphic for larger view. .. see notes below for additional detail. Elementary, Secondary, Unified School Districts .. illustrative examples for the extended Los Angeles, CA area .. most states have only unified districts .. elementary districts  .. secondary districts  .. unified districts; LA Unified shown with darker color .. nationally, unified districts comprise approximately ~10,000 of total ~13,000 districts  Patterns of Poverty Rate for Population Ages 5-17 by School District .. Fresno, CA region zoom-in .. bold boundaries show counties .. legend shows color patterns associated with poverty rates  .. click graphic for larger view .. view poverty rates as labels by district .. expand browser window for best quality view. .. see notes below for additional detail. Geographic Solutions and Demographic-Economic Estimates & Projections - Geographic Solutions -- developing attendance zones - Demographic-Economic Estimates & Projections Web meetings Join us in the weekly Web Meetings Every Tuesday: Accessing & Using Demographic-Economic Data Every Thursday: Using GIS Tools & GeoSpatial Analysis School Districts 2021-22 Characteristics Interactive Table .. goto top ... Click on header to sort; click header again to sort other direction. ... Click ShowAll button between queries (resets view/table). ... View additional notes below table. See other interactive tables. Using the Table • Cell value codes: - 1 indicates that the data are not applicable - 2 indicates that the data are missing - 3 indicates that the data do not meet data quality standards • See column descriptions below. • Click ShowAll button between queries (resets view/table). Column descriptions - Name - St - LEAID - ZIP - Public Schools - Charter Schools - Type - State Code - Profile Link - Teachers - Std/Tch Ratio - Total Staff - Students 2018-19 - Students 2021-22 - Reserved - Enrl Grades 1-8 - Enrl Grades 9-12 - Enrl Grade PK - Enrl Grade K - Enrl Grade 1 - Enrl Grade 2 - Enrl Grade 3 - Enrl Grade 4 - Enrl Grade 5 - Enrl Grade 6 - Enrl Grade 7 - Enrl Grade 8 - Enrl Grade 9 - Enrl Grade 10 - Enrl Grade 11 - Enrl Grade 12 - Male - Female - Native Amer - Asian - Hispanic - Black - White - Native Hawaiian - Multi race SAIPE Based Estimates TotPop 2021 .. Total Population Pop 5-17 2021 .. Grade Relevant Ages 5 to 17 PopPov 5-17 2021 .. Grade Relevant Ages 5 to 17 in Families in Poverty PopPov 5-17 Rate 2021 .. Grade Relevant Ages 5 to 17 Poverty Ratio - ESD Code - SSD Code - USD Code - SD Code Support Using these Resources .. goto top Learn more about demographic economic data and related analytical tools. Join us in a Data Analytics Lab session. There is no fee for these Web sessions. Each informal session is focused on a specific topic. The open structure also provides for Q&A and discussion of application issues of interest to participants. ProximityOne User Group Join the ProximityOne User Group to keep up-to-date with new developments relating to geographic-demographic-economic decision-making information resources. Receive updates and access to tools and resources available only to members. Use this form to join the User Group. Additional Information ProximityOne develops geographic-demographic-economic data and analytical tools and helps organizations knit together and use diverse data in a decision-making and analytical framework. We develop custom demographic/economic estimates and projections, develop geographic and geocoded address files, and assist with impact and geospatial analyses. Wide-ranging organizations use our software, data and methodologies to analyze their own data integrated with other data. Follow ProximityOne on Twitter at www.twitter.com/proximityone. Contact ProximityOne (888-364-7656) with questions about data covered in this section or to discuss custom estimates, projections or analyses for your areas of interest. |
|
|
