Public School Locations 2017-18
Department of Education
@usgov.ed_gov_public_school_locations_2017_18_af716
Department of Education
@usgov.ed_gov_public_school_locations_2017_18_af716
The National Center for Education Statistics’ (NCES) Education Demographic and Geographic Estimate (EDGE) program develops annually updated point locations (latitude and longitude) for public elementary and secondary schools included in the NCES Common Core of Data (CCD). The CCD program annually collects administrative and fiscal data about all public schools, school districts, and state education agencies in the United States. The data are supplied by state education agency officials and include basic directory and contact information for schools and school districts, as well as characteristics about student demographics, number of teachers, school grade span, and various other administrative conditions. The CCD program also provides fiscal data about school district revenues and expenditures. CCD school and agency point locations are derived from reported information about the physical location of schools and agency administrative offices. The NCES EDGE program collaborates with the U.S. Census Bureau’s Education Demographic, Geographic, and Economic Statistics (EDGE) Branch to develop point locations for schools reported in the annual CCD directory file. The point locations in this data layer were developed from the 2017-2018 CCD collection. For more information about NCES school point data, see: https://nces.ed.gov/programs/edge/Geographic/SchoolLocations.
Organization: Department of Education
Last updated: 2024-04-16T10:15:23.275179
Tags: ccd, common-core-of-data, edge, education-demographic-and-geographic-estimates-program, national-center-for-education-statistics, nces, points, public-school-locations, public-schools, u-s-census-bureau, united-states, us-census-bureau
CREATE TABLE table_1 (
"x" DOUBLE,
"y" DOUBLE,
"ncessch" BIGINT,
"name" VARCHAR,
"opstfips" BIGINT,
"street" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip" BIGINT,
"stfip" BIGINT,
"cnty" BIGINT,
"nmcnty" VARCHAR,
"locale" BIGINT,
"lat" DOUBLE,
"lon" DOUBLE,
"cbsa" VARCHAR,
"nmcbsa" VARCHAR,
"cbsatype" BIGINT,
"csa" VARCHAR,
"nmcsa" VARCHAR,
"necta" VARCHAR,
"nmnecta" VARCHAR,
"cd" BIGINT,
"sldl" VARCHAR,
"sldu" VARCHAR,
"schoolyear" VARCHAR,
"objectid" BIGINT
);Anyone who has the link will be able to view this.