|
|
Welcome to SDISQuery ...
To view tables/reports, extract data, or view maps of schools, school districts, or workforce areas that meet your criteria, modify the SQL statement in the text area
and then click Submit. View this sample profile
that is generated from the default SQL statement.
SDISQuery Overview and Features [goto top]
SDISQuery enables easy linkage of data items located in separate, often inaccessible datasets.
Flexibly select and combine data items for schools or geographic areas of interest.
For example, the Census 2000 school district demographics cannot be easily displayed for all
districts in Harris County, TX. However, using SDIS, you can join the Census 2000 demographics
dataset with a school district administrative dataset that includes the county name, ZIP code and
other identifiers. By linking the attributes between the datasets, data may be analytically combined
using multisourced items and Census 2000 demographics can be displayed for districts that are in
certain user specified ZIP code areas.
SDIS Uses and Benefits [goto top]
Use SDISQuery to perform these types of operations:
- (SDCOP1) - Call up a profile of the number of students by type of
enrollment for
districts meeting your criteria.
View the number of
children in a school districts, compare one district to other districts.
See how many children
are enrolled in private versus public school.
- (SDCOP1) - View how many and
what percentage of school age children are not enrolled in school (see related description).
- View data from SDCOP1 based on attributes of the district (e.g. ZIP code/location) derived
from the SDADMIN table.
- Compare Census demographic data (SDCOP1; DPX) to administratively reported data for
the school district (SDADMIN) or data summarized (aggregated) from school level data (SCADMIN)
for schools in that district.
SDISQuery SQL Instructions and Examples [goto top]
SDISQuery is unique in its enabling ability to dynamically mix and access
multi-sourced subject matter and geography relating to schools, school districts,
children, and associated objects. The flexibility to organize the types of subject
matter for the types and specific geography of interest is provided through use of
Structured Query Language (SQL) instructions. The following SQL instruction appears
as the default in the query form at the top of this Web page.
SELECT sdcop1.code,sdcop1.name, sdadmin.name, sdcop1.rcepub, sdadmin.students,
FORMAT(100*sdcop1.rcepub/sdadmin.students,2) FROM sdcop1,sdadmin WHERE
sdcop1.code = sdadmin.code and substring(sdadmin.ctyname,1,6)="Harris" and sdadmin.stab='TX'
This instruction says to display an html table that includes the school district code, school name
(from Census 2000), school name (from CCD), Census 2000 relevant children enrolled in public school,
CCD sourced number of students (01-02), and index of relevant children enrolled in public school (RCEPUB) to number of students.
Only those cases will be listed where the school district code is matched between the tables
and the district must be in Harris County, Texas.
SELECT ... choose these items to display
FROM ... specifies which database names to use
WHERE ... specifies criteria that must be met
Examples of SELECT Instructions and Results
A userid required to view examples. Register here to obtain userid.
Most registered users can use their existing userid.
-
Comparative Analysis Profile -- Selected School Districts
Type of Enrollment Demographic Profile
(uses Census 2000 School District Special Tabulation Database Table)
How can I view the number of children by type of enrollment for selected school districts?
In the following example, the instruction specifies the school districts to be included based
on part of the school name.
SELECT code, name, tc, rc, rce, rcepub, rceprv, rcne, FORMAT(100*rcne/rc,2), stab FROM
sdcop1 WHERE (substring(name,1,7)='Houston' or substring(name,1,3)='Cyp') and stab='TX'
See results of this query (Profile was selected as checkbox option.)
-
Comparative Analysis Profile -- Selected School Districts Based on Reported Enrollment
School District Administrative Profile
(uses augmented SY 2001-02 NCES CCD Non-Fiscal Database Table)
How can I view basic profiles (address and contact information) for the largest 3 school districts in the U.S.?
In the following example, the instruction specifies the school districts to be included by using
the ORDER BY based on the reported enrollment. DESC will result in the processing to
rank the results in descending order. LIMIT is set to 3 which results in only the largest
3 school districts to be output.
on the school name.
select * from sdadmin order by students desc limit 3
See results of this query (Profile was selected as checkbox option.)
-
Comparative Analysis Profile -- Selected School Districts
School District Financial Profile
(uses augmented FY 2001 Census Bureau/NCES CCD Finances Database Table)
How can I view financial profiles for three selected school districts?
In the following example, the instruction specifies the school districts to be included by
using the Federal school district code for San Antonio, TX area districts (Northside,
North East, and San Antonio)
select * from sdfin INNER JOIN sdadmin ON sdadmin.code LIKE sdfin.code
where sdfin.code="4833120" or sdfin.code="4838730" or sdfin.code="4832940"
See results of this query (Profile was selected as checkbox option.)
Discussion. Use this simpler query which is easier to apply but does not access school
system name from the SDADMIN table:
select * from sdfin where sdfin.code="4833120" or sdfin.code="4838730" or sdfin.code="4832940"
See results of this query (Profile was selected as checkbox option.)
-
List of Selected School Districts by Federal Revenue
School District Financial Table Report
(uses augmented FY 2001 Census Bureau/NCES CCD Finances Database Table)
How can I view total Federal and per student Federal revenue for all school districts
in Onondaga County, NY?
select sdadmin.name,sdfin.code,totalrev,sdfin.students,tfedrev,
FORMAT(1000*tfedrev/sdfin.students,0), c14,c15,c25 from sdfin INNER JOIN sdadmin ON sdadmin.code LIKE sdfin.code where substring(stcty,1,5)="36067"
See results of this query (Table was selected as checkbox option.)
-
List of Selected School Districts by Children in Poverty
School District Poverty Table Report
(uses augmented SY 2001-02 NCES CCD and Census Bureau 2000 Poverty Estimates)
How can I view the number of children in poverty using the most recent Census Bureau
estimates for all school districts
in Onondaga County, NY? (this query is associated with previous query)
select name,students,rc5_17,FORMAT(100*students/rc5_17,2), rc5_17pov, totalpop from sdpov03 INNER JOIN sdadmin ON (sdadmin.code LIKE sdpov03.code) where stfips="36" and cty="067"
See results of this query (Table was selected as checkbox option.)
-
List of Title I Schools
How can I get a list of schools designated as Title I in Fort Bend County, Texas?
SELECT scadmin.schl,scadmin.schname,scadmin.title1,sdadmin.code,sdadmin.name,
sdadmin.cty,sdadmin.ctyname from scadmin,sdadmin where sdadmin.ctyname='Fort Bend' and (sdadmin.code=scadmin.code) and scadmin.title1='1'
See results of this query (Table was selected as checkbox option.)
-
List of Largest Schools
How can I get a list of the largest schools in Texas? I need to see the school code,
school name, number of students, and school district name.
SELECT scadmin.schl,scadmin.schname,scadmin.students,sdadmin.code,sdadmin.cty,sdadmin.name
from scadmin,sdadmin where substring(scadmin.code,1,2)='48' and
(sdadmin.code=scadmin.code) and scadmin.students > 3000
See results of this query (Table was selected as checkbox option.)
-
Comparative Analysis Profile -- Selected Schools -- Using Prior Query
From the list generated in the previous example, how can I view comparative analysis
profiles of selected schools?
In the following example, the instruction specifies the schools to be included based
on the school code. The school name could also be used but may be more error prone (spelling
errors).
SELECT * from scadmin where substring(scadmin.code,1,2)='48' and (schl='00903' or schl='00906' or schl='01148')
See results of this query (Profile was selected as checkbox option.)
Terms of Use [goto top]
Registered users may utilize SDIS data for any purpose
provided that the data are not distributed in bulk nor used to set up
a service competitive to SDIS.
Definitions and Documentation [goto top]
The following terms apply to data from the Census 2000 School District Special Tabulation (SDST).
Total children definition. The 2000 SDST defines a child as a person age 0 to 17
(as of April 1, 2000) or a person age 18 or 19 who is not a high school graduate
(based on the educational attainment response from the Census 2000 questionnaire).
Relevant children definition. A child is relevant to a school district if
he/she lives within the territory of the district and
his/her assigned grade falls within the grade range provided by a district.
The Census 2000 SDST database includes only school districts having 50 or more unweighted number of children
(13,559 or 14,286 districts). These data were not tabulated for districts with a smaller number of
children.
[goto top]
|
