This dataset contains 2017 Private and Public School Information for the State of Florida. It is a combination of schools and educational facility addresses from various sources, including the Florida Department of Education, the U.S. Department of Education National Center for Education Statistics, and other sources listed below. The data contains selected fields denoting the physical address, school number, district, and contact information for schools located in Florida. This data is meant to be used for planning purposes only and is not intended to represent a 100% inventory of schools. School locations that have been verified are marked with the letter V in the FLAG field. This layer corresponds to the schools point layer GC_SCHOOLS_SEP17 available through FGDL.
The data was created to serve as base information for use in GIS systems for a variety of planning and analytical purposes.
Master School Identification File Background and Use The Master School Identification (MSID) file is maintained by the Department of Education (DOE) to ensure the Department provides accurate identification and directory information on each Florida public school in the state. This file contains information for all public PK-12 schools as well as for adult and vocational-technical schools operated by district school boards. Information from this file is used for direct communication to the schools as well as for reporting data for each school. The Master School Identification file is used to edit all records submitted to the Department's Student, Staff and Finance Automated Data Base Systems. The MSID provides the universe for accountability reporting, including annual school grades and adequate yearly progress calculations. It is the basis for reporting to the U.S. Department of Education (USDE) via the Common Core of Data and Education Data Exchange Network (EDEN) reporting systems. The federally-assigned identification numbers, which are required for certain grant applications and for assignment of E-rate funds, are provided to the Florida DOE the year following submission of new school information to the USDE. Accessing the File Appendix A provides a list of the elements contained in the Master School Identification file. MSID information for each Florida public school is available on the web at: http://doeweb-prd.doe.state.fl.us/EDS/MasterSchoolID. The data are presented in three sections: 1) addresses, 2) administration and 3) accountability. Three ways are provided for the user to look up a school: 1) by the school name, 2) by the district in which the school is located and 3) by the city/town in which the school is located. School Type School Type is an indication of the level of instruction offered at the school. The School Type is derived directly from the Grade Code reported for the school. Elementary Schools: Schools providing instruction at one or more grade levels from PK through grade 5. May include schools serving grade 6 if also serving one or more grades PK through 5 (e.g., a K-6 school). Middle/Junior High Schools: Schools providing instruction in middle school configurations (grades 6-8) and junior high school configurations (grades 7-9). Can also include schools serving a single grade in the 6-8 range (e.g., a 6th grade center). Senior High Schools: Schools providing instruction at one or more grade levels from 9 to 12. Includes regular high schools and 9th grade centers. Combination Elementary and Secondary Schools: Schools providing instruction in grade groupings that include more than one of the categories described above (e.g., PK-8, 6-12, K-12, etc.). Adult Schools: Schools providing adult education instruction. FDOE Public Schools are from the Master School ID file, Public schools are from the 2016-2017 school year. http://doeweb-prd.doe.state.fl.us/EDS/MasterSchoolID FDOE K-12 Private Schools are from the Florida Department of Education K-12 Private Schools Annual Survey, Private schools are from the 2014-2015 school year. http://www.floridaschoolchoice.org/information/PrivateSchoolDirectory/Default.aspx **************************************************** The Common Core of Data (CCD) is a program of the U.S. Department of Education's National Center for Education Statistics that annually collects fiscal and non-fiscal data about all public schools, public school districts and state education agencies in the United States. The data are supplied by state education agency officials and include information that describes schools and school districts, including name, address, and phone number; descriptive information about students and staff, including demographics; and fiscal data, including revenues and current expenditures. http://nces.ed.gov/ccd/address.asp NCES public school data is gathered by CCD (Common Core of Data), Public school data is from the 2014-2015 school year http://nces.ed.gov/ccd/ NCES private school data is gathered by PSS (Private School Universe Survey), Private school data is from the 2013-2014 school year. NCES college data is gathered by IPEDS, College data is from the 2015-2016 school year. ********************************************************
publication date
NONE
131 Architecture PO Box 115706
Web site: http://www.fgdl.org
FDOE, NCES, FLORIDA COUNTIES, DTS, RPCs.
GeoPlan relied on the integrity of the attribute information within the original data.
This data is provided 'as is'. GeoPlan relied on the integrity of the original data layer's topology
This data is provided 'as is' by GeoPlan and is complete to our knowledge.
This data is provided 'as is' and its horizontal positional accuracy has not been verified by GeoPlan
This data is provided 'as is' and its vertical positional accuracy has not been verified by GeoPlan
Spatial and Attribute Information
The GeoPlan Center performed the following steps in order to create the 2008 statewide schools data layer. 68 Different Sources Comprise the Schools Dataset. The following Sources were either reprojected to the FGDL Albers NAD83 HPGN map projection or if no spatial data existed they were geocoded to a statewide 2007 TeleAtlas Streets dataset. For downloaded county and district wide polygon layers the label points were created and then used for each facility. Once the point sources were created via geocoding or reprojected existing point data they were merged into one statewide layer. Record (facility) duplications were removed by manually viewing and editing the statewide layer's attribute table for each of the 67 counties. Where record duplication existed source information of previously corrected FDOT Districts and Regional Planning Council data took preference followed by, County data, and finally geocoded data. Finally the FDOE state identification number and the NCES federal identification numbers were added for each facility with such an id. Next a table join was performed for each table (FDOE and NCES) to the master statewide shapefile. Un-used or duplicate fields were deleted. Below are the data Sources as described in the Source field in the attribute table.
SOURCE DATA INFORMATION - 68 Sources STRUCTURE: SOURCE NAME RECORD COUNT UPDATE DAY FILE NAME PROJECTION SCALE WEBSITE OTHER ****************************** ALACHUA COUNTY RECORD COUNT: 40 01/01/2004 SCHOOLS.SHP NAD_1983_StatePlane_Florida_North_FIPS_0903_Feet N/A http://gis.alachuacounty.us/ ****************************** BAY COUNTY RECORD COUNT: 35 11/01/2000 SCHOOLS_PT.SHP NAD_1983_StatePlane_Florida_North_FIPS_0903_Feet N/A http://www.pcbaygis.com/ ****************************** BRADFORD COUNTY P.A. RECORD COUNT: 10 12/31/2006 BRADFORD_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** BREVARD COUNTY RECORD COUNT: 2 06/30/2008 ADDRESS.SHP NAD1983 HARN State Plane Florida East FIPS 0901 Ft N/A http://www.brevardpropertyappraiser.com/gisdata/datasearch.asp ****************************** BROWARD COUNTY RECORD COUNT: 251 08/21/2003 SCHOOLS.SHP NAD_1983_HARN_StatePlane_Florida_East_FIPS_0901_Ft N/A 05/01/1999 COLLEGES.SHP NAD_1983_HARN_StatePlane_Florida_East_FIPS_0901_Ft N/A http://gis.broward.org/GISData.htm ****************************** CALHOUN COUNTY P.A. RECORD COUNT: 5 12/31/2006 CALHOUN_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** CHARLOTTE COUNTY RECORD COUNT: 20 07/05/2008 COMMUNITY_AMENITIES.SHP NAD_1983_StatePlane_Florida_West_FIPS_0902 N/A http://www.ccgis.com/gis/ftp_download_page.html ****************************** CITRUS COUNTY P.A. RECORD COUNT: 22 12/31/2006 CITRUS_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** COLLIER COUNTY RECORD COUNT: 73 02/17/2004 SCHOOLS.SHP NAD_1983_StatePlane_Florida_East_FIPS_0901_Feet N/A http://gis.colliergov.net/portal2007/ ****************************** COLUMBIA COUNTY P.A. RECORD COUNT: 17 12/31/2006 COLUMBIA_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** DESOTO COUNTY P.A. RECORD COUNT: 7 12/31/2006 DESOTO_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** DIXIE COUNTY P.A. RECORD COUNT: 4 12/31/2006 DIXIE_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** DTS RECORD COUNT: 1353 12/06/2006 SCHOOLS_D5_JAN07.SHP GCS_North_American_1983_HARN - ALBERS VARIOUS ****************************** ESCAMBIA COUNTY RECORD COUNT: 79 06/30/2004 SCHOOLS.SHP NAD_1983_HARN_StatePlane_Florida_North_FIPS_0903 N/A http://www.co.escambia.fl.us/departments/gis/default.php ****************************** FDOE COLLEGE RECORD COUNT: 323 11/06/2007 COMM_COLLEGE_INDEPENDENT.XLS GCS_North_American_1983_HARN - ALBERS VARIOUS 11/06/2007 COMM_COLLEGE_PUB.XLS N/A The database files were geocoded against 2007 Tel Atlas Roads, and finally converted into a shapefile with the FGDL Albers HPGN map projection. ****************************** FDOE PRIVATE RECORD COUNT: 459 5/29/2007 K_12_PRIVATE_DATA_REQUEST.XLS GCS_North_American_1983_HARN - ALBERS VARIOUS The database files were geocoded against 2007 Tel Atlas Roads, and finally converted into a shapefile with the FGDL Albers HPGN map projection. ****************************** FDOE PUBLIC RECORD COUNT: 424 5/29/2007 MSID_ALL_SCHOOLS_0708.XLS GCS_North_American_1983_HARN - ALBERS VARIOUS The database files were geocoded against 2007 Tel Atlas Roads, and finally converted into a shapefile with the FGDL Albers HPGN map projection. ****************************** FRANKLIN COUNTY P.A. RECORD COUNT: 5 12/31/2006 FRANKLIN_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** GADSDEN COUNTY P.A. RECORD COUNT: 16 12/31/2006 GADSDEN_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** GEOPLAN CENTER RECORD COUNT: 31 06/30/2008 GCS_North_American_1983_HARN - ALBERS VARIOUS ****************************** GILCHRIST COUNTY P.A. RECORD COUNT: 4 12/31/2006 GILCHRIST_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** GLADES COUNTY P.A. RECORD COUNT: 4 12/31/2006 GLADES_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** GULF COUNTY RECORD COUNT: 11 7/13/2007 SCHOOLS_PT_1.SHP NAD_1983_StatePlane_Florida_North_FIPS_0903_Feet N/A http://www.gulfcounty-fl.gov/ ****************************** HAMILTON COUNTY P.A. RECORD COUNT: 7 12/31/2006 HAMILTON_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** HARDEE COUNTY P.A. RECORD COUNT: 8 12/31/2006 HARDEE_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ftp://ftp.hardeecounty.net/Layers ****************************** HENDRY COUNTY P.A. RECORD COUNT: 11 12/31/2006 HENDRY_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** HERNANDO COUNTY RECORD COUNT: 20 06/01/2001 ELEME_PT.SHP NAD_1983_StatePlane_Florida_West_FIPS_0902_Feet N/A 06/01/2001 MIDDLEPT.SHP NAD_1983_StatePlane_Florida_West_FIPS_0902_Feet N/A 06/01/2001 HIGHPT.SHP NAD_1983_StatePlane_Florida_West_FIPS_0902_Feet N/A ftp://www.hernandocounty.us/planning/Shape%20Library%20(ESRI%20Format)/ ****************************** HIGHLANDS COUNTY P.A. RECORD COUNT: 14 12/31/2006 HIGHLANDS_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** HILLSBOROUGH COUNTY RECORD COUNT: 227 05/01/2006 SCHLPTS.SHP NAD_1983_StatePlane_Florida_West_FIPS_0902_Feet N/A ****************************** HILLSBOROUGH COUNTY P.A. RECORD COUNT: 1 12/31/2006 HILLSBOROUGH_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS http://www-gis.hillsboroughcounty.org/geodata/FTP_HTMLS/geodatadir.cfm ****************************** HOLMES COUNTY P.A. RECORD COUNT: 8 12/31/2006 HOLMES_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** INDIAN RIVER COUNTY RECORD COUNT: 24 02/06/2008 SCHOOLS_PUB_K12.SHP NAD_1983_StatePlane_Florida_East_FIPS_0901_Feet N/A ****************************** JACKSON COUNTY RECORD COUNT: 22 02/04/2008 JC_FIREPOLICESCHOOLS_POINT_MERGE.SHP GCS_WGS_1984 N/A ****************************** JEFFERSON COUNTY P.A. RECORD COUNT: 6 12/31/2006 JEFFERSON_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** LAFAYETTE COUNTY P.A. RECORD COUNT: 2 12/31/2006 LAFAYETTE_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** LAKE COUNTY RECORD COUNT: 54 01/01/2006 PUBLICSCHOOLS.SHP NAD1983_HARN_StatePlane_Florida_East_FIPS_0901_Ft N/A 2006 PRIVATESCHOOLS.SHP NAD1983_HARN_StatePlane_Florida_East_FIPS_0901_Ft N/A 05/22/2006 CHARTERSCHOOLS.SHP NAD1983_HARN_StatePlane_Florida_East_FIPS_0901_Ft N/A ftp://ftp.co.lake.fl.us/GIS/GisDownloads/Shapefiles/ ****************************** LEE COUNTY RECORD COUNT: 89 01/01/2008 SCHOOLLOCATIONS.SHP NAD_1983_StatePlane_Florida_West_FIPS_0902_Feet N/A http://leegis.leegov.com/GISData.htm ****************************** LEON COUNTY RECORD COUNT: 147 07/18/2005 COMMON_PLACES.SHP NAD1983_HARN_StatePlane_Florida_North_FIPS_0903_Ft N/A ****************************** LEVY COUNTY P.A. RECORD COUNT: 14 12/31/2006 LEVY_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** LIBERTY COUNTY P.A. RECORD COUNT: 5 12/31/2006 LIBERTY_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** MADISON COUNTY P.A. RECORD COUNT: 10 12/31/2006 MADISON_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** MANATEE COUNTY RECORD COUNT: 65 08/25/2005 SCHOOLS.SHP NAD_1983_StatePlane_Florida_West_FIPS_0902_Feet N/A http://www.mymanatee.org/internet/information_services_site.nsf/ContentLookup/gis_data_downloads ****************************** MARION COUNTY RECORD COUNT: 10 06/19/2006 SCHOOLS.SHP NAD_1983_StatePlane_Florida_West_FIPS_0902_Feet N/A ftp://146.201.97.137/County_local_data/Marion/shapefiles/ ****************************** MARTIN COUNTY RECORD COUNT: 26 10/09/2001 SCHOOLS.SHP NAD_1983_HARN_StatePlane_Florida_East_FIPS_0901 N/A http://www.martin.fl.us/portal/page?_pageid=254,3431495&_dad=portal&_schema=PORTAL ****************************** MIAMI-DADE COUNTY RECORD COUNT: 894 06/01/2006 LSCHOOLS.SHP NAD 1983 State Plane Zone 3601 N/A 03/01/2006 LSCHLPVT.SHP NAD 1983 State Plane Zone 3601 N/A 09/01/2006 LSCHCHRT.SHP NAD 1983 State Plane Zone 3601 ****************************** MONROE COUNTY RECORD COUNT: 16 11/04/2004 CRITICALFACILITIES.SHP NAD_1983_StatePlane_Florida_East_FIPS_0901_Feet N/A ****************************** NCES 2005-2006 PRIVATE RECORD COUNT: 857 02/29/2008 NCESDATA_BBE49DF8_02292008.XLS GCS_North_American_1983_HARN - ALBERS VARIOUS National Center for Education Statistics PSS Private School Universe Survey data 2005-2006 school year The file contains (1819) records based on your search. NCES is not responsible for the manner in which this data is presented. This data is provided as an extra service to the user. For more information about this data, visit the PSS homepage. http://nces.ed.gov/surveys/pss downloaded from: http://nces.ed.gov/surveys/pss/privateschoolsearch/school_list.asp?Search=1&State=12 NCES Public and Private School Data were down loaded from: http://nces.ed.gov/globallocator/ The database files were geocoded against 2007 Tel Atlas Roads, and finally converted into a shapefile with the FGDL Albers HPGN map projection. ****************************** NCES 2005-2006 PUBLIC RECORD COUNT: 320 02/29/2008 NCESDATA_662805A5_02292008.XLS GCS_North_American_1983_HARN - ALBERS VARIOUS National Center for Education Statistics CCD public school data 2005-2006 school year The file contains (3723) records based on your search. SEARCH CRITERIA: State: "Florida" NCES is not responsible for the manner in which this data is presented. This data is provided as an extra service to the user. To download full CCD datasets, please go to the CCD home page. http://nces.ed.gov/ccd downloaded from: http://nces.ed.gov/globallocator/ NCES Public and Private School Data were down loaded from: http://nces.ed.gov/globallocator/ The database files were geocoded against 2007 Tel Atlas Roads, and finally converted into a shapefile with the FGDL Albers HPGN map projection. ****************************** NEFRPC RECORD COUNT: 386 06/15/2006 SCHOOLS_D2_JUN06.SHP GCS_North_American_1983_HARN - ALBERS N/A ****************************** OKALOOSA COUNTY RECORD COUNT: 59 05/15/2007 SCHPY.SHP NAD_1983_StatePlane_Florida_North_FIPS_0903_Feet N/A ftp://ftpgis.co.okaloosa.fl.us/public/Shape%20Files/ ****************************** OKEECHOBEE COUNTY P.A. RECORD COUNT: 12 12/31/2006 OKEECHOBEE_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** ORANGE COUNTY RECORD COUNT: 193 07/17/2007 PUBLIC_SCHOOLS.SHP NAD_1983_StatePlane_Florida_East_FIPS_0901_Feet N/A 09/20/2007 HEAD_START.SHP NAD_1983_StatePlane_Florida_East_FIPS_0901_Feet N/A 09/20/2007 COLLEGE_AND_UNIVERSITIES.SHP NAD_1983_StatePlane_Florida_East_FIPS_0901_Feet N/A ftp://ftp.onetgov.net/divisions/Infomap/pub/GIS_Downloads/ ****************************** PALM BEACH COUNTY RECORD COUNT: 173 08/29/2001 SCHOOLS.SHP NAD_1983_StatePlane_Florida_East_FIPS_0901_Feet 1:24,000 04/15/2008 LANDMARKS.SHP NAD_1983_StatePlane_Florida_East_FIPS_0901_Feet N/A ftp://ftp.co.palm-beach.fl.us/ http://www.palmbeach.k12.fl.us/maps/gis/gisdata/gisdata.htm ****************************** PASCO COUNTY RECORD COUNT: 28 11/03/2005 PASCOSCHOOLS.SHP NAD_1983_StatePlane_Florida_West_FIPS_0902_Feet N/A http://www.pascocountyfl.net/devser/sd/survey/surveyweb/GisMaps/default.html ****************************** PASCO SCHL BRD RECORD COUNT: 79 01/01/2008 PASCO COUNTY SCHOOLS GIS PUBLIC.MDB NAD_1983_StatePlane_Florida_West_FIPS_0902_Feet N/A http://www.pasco.k12.fl.us/ ****************************** PINELLAS COUNTY RECORD COUNT: 266 01/11/2008 SCHOOLS.SHP NAD_1927_StatePlane_Florida_West_FIPS_0902 N/A http://gis.pinellascounty.org/gisData/gisDataSets.aspx ****************************** POLK COUNTY RECORD COUNT: 21 01/03/2008 SCHOOLS_ALL.SHP NAD_1983_StatePlane_Florida_West_FIPS_0902_Feet N/A ftp://www.polk-county.net/ ****************************** POLK COUNTY P.A. RECORD COUNT: 122 12/31/2006 POLK_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** SANTA ROSA COUNTY RECORD COUNT: 39 02/05/2008 SCHOOLS.SHP NAD_1983_StatePlane_Florida_North_FIPS_0903_Feet N/A http://www.santarosa.fl.gov/gis/index.html ****************************** SARASOTA COUNTY RECORD COUNT: 80 01/27/2008 SCHOOLSPOINTS.SHP NAD_1983_StatePlane_Florida_West_FIPS_0902_Feet N/A http://gis.scgov.net/data_download_page.asp ****************************** ST. LUCIE COUNTY RECORD COUNT: 64 01/29/2008 ST_LUCIECOUNTY_CRITICAL_FACILITIES.SHP NAD_1983_StatePlane_Florida_East_FIPS_0901_Feet N/A ****************************** SUWANNEE COUNTY P.A. RECORD COUNT: 9 12/31/2006 SUWANNEE_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** TAYLOR COUNTY P.A. RECORD COUNT: 8 12/31/2006 TAYLOR_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** UNION COUNTY P.A. RECORD COUNT: 4 12/31/2006 UNION_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** VOLUSIA COUNTY RECORD COUNT: 150 07/03/2007 SCHOOLS.SHP NAD1983_HARN_StatePlane_Florida_East_FIPS_0901_Ft N/A http://volusia.org/gis/download/shapes.htm ****************************** WAKULLA COUNTY P.A. RECORD COUNT: 10 12/31/2006 WAKULLA_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ****************************** WALTON COUNTY RECORD COUNT: 17 02/14/2007 SCHOOLS.SHP NAD_1983_StatePlane_Florida_North_FIPS_0903_Feet N/A http://gisftp.co.walton.fl.us/ ****************************** WASHINGTON COUNTY P.A. RECORD COUNT: 7 12/31/2006 WASHINGTON_PARCELS_06.SHP NAD 1983 State Plane Florida (north east or west) Feet VARIOUS ******************************
Next GeoPlan Center performed the following attribute table adjustments. -Upper cased all records. -Added DESCRIPT field based on NAME -Socio-Cultural Effect data fields and definitions were added. FLAG, UPDATE_DAY, AUTOID, NAME, ADDRESS, CITY, ZIPCODE, OPERATING, OP_CLASS, SERVICES, COMMON_USE USE, YR_BUILT, FGDLAQDATE.
-------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------
The GeoPlan Center performed the following steps in 2011-2012.
Downloaded data:
June 1st, 2011 & May 14, 2012- MSID all public schools from
FDOE http://doeweb-prd.doe.state.fl.us/EDS/MasterSchoolID/
May 14, 2012- FDOE Private schools
http://www.floridaschoolchoice.org/information/privateschooldirectory/DownloadExcelFile.aspx
(Downloaded and merged All Schools Part 1 & 2)
NCES public schools: http://nces.ed.gov/ccd/schoolsearch/
(Search State: Florida, then download as an excel file)
NCES private schools: http://nces.ed.gov/surveys/pss/privateschoolsearch/
(Search State: Florida, then download as excel file)
Community colleges: http://data.fldoe.org/workforce/contacts/default.cfm?action=showList&ListID=11
Colleges: http://nces.ed.gov/collegenavigator/
Location of codebooks/glossaries for downloaded tables:
MSID: http://www.fldoe.org/eias/dataweb/tech/msid.pdf
NCES Public schools glossary: http://nces.ed.gov/ccd/commonfiles/glossary.asp
NCES Private schools file layout: http://nces.ed.gov/surveys/pss/privateschoolsearch/aboutdata.asp
Downloaded gc_schools_jul08.shp from FGDL. Total number of records 7781
----------------------------------------------------------------------
Spatial updates:
-Converted downloaded Excel tables to DBF table in spatial database
-Compared/investigated records in this table that were not in gc_schools_jul08.shp. Populated a h_check field
by marking them as: 0= add to gc_schools_may12 and 1= already reside in the gc_schools_jul08 dataset, 3= investigate further.
-Flag field:
-V = verified. Verified means that the point has been visually checked, point is over building, and that the
record was also found in the MSID
-NV = not verified. Not verified means that unable to verify the school and/or its location
-Duplicates were marked as duplicate and were later deleted
-If the point was new, the point was moved from the geocoded generated spot, the SCORE field was populated with '0',
SIDE was populated with '*', and MATCH_ADRESS was populated as blank.
-A duplicate point of all superintendent offices was created and the name was calculated as
"**** COUNTY STUDENT SERVICES/ MIGRANT/VIRTUAL PROGRAM/ MCKAY SCHOLARSHIP/ HOMEBOUND PROGRAM"
and its FEDERAL_ID was calculated as the migrant program ID when available.
----------------------------------------------------------------------
Attribute table updates:
-Cleaned up city, county, and address fields in updated layer, ex. Ft. Myers became FORT MYERS. Replaced sch with
school when found.
-COMMENT field records that were previously populated were given parentheses to separate previous update from
current update
-PARCEL_ID was updated for points without an ID by identifying the parcel boundary that the point was within and
copying LINK field from statewide_parcels10.shp to PARCEL_ID
-LAT_DD, LONG_DD were updated by calculating geometry tool
-USNG_FL_1K was updated through a spatial join
-For added records, source updated to GEOPLAN
-FGDLAQDATE and UPDATE_DAY were updated
-For public schools (OP_CLASS = 'PUBLIC'):
-Joined gc_schools_may12.shp and MSID_all_schools.dbf based on STATE_ID
-Updated table through field calculator:
PRINCIPAL **see below for description of field and calculation
PHONE
LOW_GRADE
HIGH_GRADE
PROGRAMS **see below for description of field and calculation
MAGNETINFO **see below for description of field and calculation
TYPE **see below for description of field and calculation
-Joined gc_schools and NCES schools based on FEDERAL_ID
-Updated:
STTCH_RT (in NCES table: STUDENT_TE)
TEACHER (in NCES table: TEACHERS_)
ENROLLMENT (in NCES table: STUDENTS_)
TITLE1SCHO (in NCES table: TITLE_1_SC)
FREE_LUNCH
REDUCED_LUNCH (in NCES table: REDUCED_LU)
-If school did not have a STATE_ID, then HIGH_GRADE, LOW_GRADE, MAGNETINFO, PROGRAMS (charter school status)
were obtained from NCES public schools records by joining on FEDERAL_ID
-For records in gc_school_may12 that were not joined, COMMENT field includes note "NO NCES 09-10 UDPATE"
-For private schools, (OP_CLASS = 'PRIVATE'):
-For private schools, FEDERAL_ID has multiple records under one unique ID.
To fix:
Ran summary on private ID, sorted count field descending. Created a query for all private IDs in gc_schools
layer that had more than one count. Cross checked records against NCES attribute table. Corrected private
ID for the one to one match. For the duplicate private ID, either remove ID or found the correct ID.
-Joined gc_schools and FDOE_private based on STATE_ID
-Updated:
PRINCIPAL (in NCES: DIRECTOR)
PHONE
GRADE (in NCES: GRAD_LEVE)
-Joined gc_schools and NCES_private based on FEDERAL_ID
-Updated:
LOW_GRADE (in NCES: LOGRADE) **see below for description of field and calculation
HIGH_GRADE (in NCES: HIGRADE) **see below for description of field and calculation
PHONE (in NCES: PSS_PHONE)
ENROLLMENT (in NCES: PSS_ENR_15)
STTCH_RT (in NCES: PSS_STDTCH)
TEACHER (in NCES: PSS_FTE_TE)
-For records in gc_school_may12 that were not joined, COMMENT field includes note "NO NCES 09-10 UDPATE"
-If school did not have a STATE_ID, then HIGH_GRADE and LOW_GRADE were obtained from NCES records
-For colleges, (USE = 'COLLEGE/UNIVERSITY'),
Updated:
PHONE
OP_CLASS (in FDOE College: TYPE indicated public or private)
ENROLLMENT (in FDOE College: STUDENT_PO)
-Fields that were derived from fields within the attribute table,
GRADES: LOW_GRADE & "-" & HIGH_GRADE
OPERATING: Selected OP_CLASS = 'PUBLIC', removed PROGRAMS= 'DEPARTMENT OF JUVENILE JUSTICE (DJJ)'
from selection. Field calculated selection as: COUNTY & " " & "COUNTY SCHOOL DISTRICT"
TYPE: If private, based on GRADES selection
-After attribute table was updated, STTCH_RT and TEACHERS were rounded to a whole number
-All fields were upcased.
-------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------
GeoPlan process steps of public and private schools in 2017:
The following data sources were used to update the public and private schools data set:
(1) FDOE Public Schools
Source: Master School ID 2016-2017
http://doeweb-prd.doe.state.fl.us/EDS/MasterSchoolID
Downloaded on 02/20/2017.
(2) FDOE K-12 Private Schools
Source: Florida Department of Education K-12 Private Schools Annual Survey 2014-2015
http://www.floridaschoolchoice.org/information/PrivateSchoolDirectory/Default.aspx
Downloaded on 02/20/2017
(3) NCES Public Schools
CCD Public school data 2014-2015, 2015-2016 school years
http://nces.ed.gov/ccd/schoolsearch/
* The directory information on school name, address, and phone number are preliminary data from initial
submissions of school level data for 2015-2016.
** Data provided on student membership and staffing are from the official school level data for 2014-2015.
Downloaded on 02/20/2017
(4) NCES Private Schools
Source: PSS Private School Universe Survey data for the 2013-2014 school year
http://nces.ed.gov/ccd/schoolsearch/
Downloaded on 02/20/2017
(5) NCES Colleges
Source: College Navigator consisting of 2015-2016 data from the Integrated Postsecondary
Education Data System (IPEDS), the core postsecondary education data collection program
for NCES.
http://nces.ed.gov/collegenavigator/
Downloaded on 04/14/2017
(6) FDOE Florida Colleges
Source: Florida Department of Education College System Campuses
http://data.fldoe.org/workforce/contacts/default.cfm?action=showList&ListID=11
Accessed on 04/14/2017
-------------------------------------------------------------------------------------------------------
Using schools data sets downloaded from the websites listed above, records were reviewed
and edited to apply any available spatial and attribute updates. In most cases, school locations
were checked using imagery and Google Street View and either marked as Verified or Not Verified
in the FLAG field, please see the FLAG field Attribute Definition for more information.
During the Spatial and Tabular QAQC duplicates and non-qualified points were removed.
The school boundary layer was produced by taking a completed schools point layer, GC_SCHOOLS_SEP17
and spatially joining it to a 2015 statewide parcel layer. The GCID field was created and populated with a
crosswalk ID linking the attributes of each point feature with its corresponding polygon layer feature. The
GCID field replaces the SCHOOL_ID field of the previous gc_schools layer as the unique crosswalk ID.
In most cases, school boundaries were delineated based on parcel boundaries and visual inspection
using satellite imagery (see FLAG field for more details). Please note that this layer does not constitute an
official, verified source for school boundaries.
Finally, the GeoPlan Center performed the following attribute table adjustments:
Populated and cleaned all fields.
Fields added include:
-GCID: replaces SCHOOLID as unique ID field
-FSOURCE
-DATASOURCE: replaces SOURCE
-MGRS: replaces USNG_FL_1K field
Fields removed include:
-COMMON_USE
-USE
-ACTIVITY
School services/programs from new datasets above that were located at county school district offices
(for example:county student services, migrant programs, virtual programs, Mckay scholarship programs,
homebound programs, etc.) were not added in order to avoid duplicate boundaries at county school district
locations. Schools or programs located at detention centers were not added with this latest update.
-------------------------------------------------------------------------------------------------------
Attribute table updates by data source:
For public schools (OP_CLASS = PUBLIC):
(1) Joined GC_SCHOOLS and MSID Schools based on STATE_ID
PRINCIPAL **see below for description of field and calculation
PHONE
LOW_GRADE **see below for description of field and calculation
HIGH_GRADE **see below for description of field and calculation
PROGRAMS **see below for description of field and calculation
OP_CLASS (For charter schools) **see below for description of field and calculation
MAGNETINFO **see below for description of field and calculation
TYPE **see below for description of field and calculation
(2) Joined GC_SCHOOLS and NCES Public Schools based on FEDERAL_ID
STTCH_RT (NCES: STUDENT_TEACHER_RATIO)
TEACHER (NCES: TEACHERS)
ENROLLMENT (NCES: STUDENTS)
TITLE1SCHO (NCES: TITLE_1_SCHOOL)
FREE_LUNCH (NCES: FREE_LUNCH)
REDUCED_LUNCH (NCES: REDUCED_LUNCH)
For schools with no STATE_ID, HIGH_GRADE, LOW_GRADE, MAGNETINFO,
were obtained from NCES Public Schools.
For private schools (OP_CLASS = PRIVATE):
(3) Joined GC_SCHOOLS and FDOE Private Schools based on STATE_ID
PRINCIPAL (in NCES: DIRECTOR)
PHONE
GRADE (in NCES: GRAD_LEVEL)
(4) Joined GC_SCHOOLS and NCES Private Schools based on FEDERAL_ID
LOW_GRADE (in NCES: LOGRADE) **see below for description of field and calculation
HIGH_GRADE (in NCES: HIGRADE) **see below for description of field and calculation
PHONE (in NCES: PSS_PHONE)
ENROLLMENT (in NCES: PSS_ENROLL_T)
STTCH_RT (in NCES: PSS_STDTCH)
TEACHER (in NCES: PSS_FTE_TEACH)
If school did not have a STATE_ID, then HIGH_GRADE and LOW_GRADE were obtained
from NCES records.
-------------------------------------------------------------------------------------------------------
Attribute definitions from codebooks:
PRINCIPAL_TITLE from MSID Codebook
Attribute Definition
1 Mr.
2 Ms.
3 Mrs.
4 Miss
5 Dr.
6 Other/Unknown
-Selected all 1's and field calculation as: "PRINCIPAL_TITLE" & "PRINCIPAL_LAST". Repeated process for all attributes,
except did not use the PRINCIPAL_TITLE= other/unknown
CHARTER_SCHL_STAT from MSID Codebook
Attribute Definition
R Regular charter school
C Conversion charter school
T Charter technical career center
B Conversion charter school/charter technical career center
Z Not a charter school
-Selected all attributes equal to R,C,T, and B. Field calculated OP_CLASS= "CHARTER"
TYPE from MSID Codebook
Attribute Definition
01 Elementary
02 Middle/Jr. High
03 Senior High
04 Combination Elementary and Secondary
05 Adult
07 Other
-Selected all 01's and field calculation as "ELEMENTARY". Repeated the process for 02, 03, 04, and 05.
PRIMARY SERVICE TYPE from MSID Codebook
R K-12 General Education
S Special Education
B Alternative Education
V Career and Technical Education
A Adult General Education
O Other
-Selected all A's and calculated field as PROGRAMS="ADULT GENERAL EDUCATION". Repeated the same process
for all other primary service type codes.
*This field was updated according to the above categories only for those records with a State ID that could
be joined to the Master School ID 2016-2017.
MAGNET_STATUS from MSID Codebook
Attribute Definition
S Magnet School
P Magnet Program
Z Not Applicable
-Selected all S's and field calculation as "MAGNET SCHOOL".
-Selected all P's and field calculation as "MAGENT PROGRAM".
-Selected all Z's and field calculation as "NOT A MAGNET SCHOOL/PROGRAM".
-If field still blank after, field calculated as "NO INFORMATION AVAILABLE".
LOGRADE from NCES Private Schools database Codebook
Attribute Definition
2 Lowest grade in school is PK
3 Lowest grade in school is KG
4 Lowest grade in school is transitional KG
5 Lowest grade in school is transitional 1st grade
6 Lowest grade in school is 1st grade
7 Lowest grade in school is 2nd grade
8 Lowest grade in school is 3rd grade
9 Lowest grade in school is 4th grade
10 Lowest grade in school is 5th grade
11 Lowest grade in school is 6th grade
12 Lowest grade in school is 7th grade
13 Lowest grade in school is 8th grade
14 Lowest grade in school is 9th grade
15 Lowest grade in school is 10th grade
16 Lowest grade in school is 11th grade
17 Lowest grade in school is 12th grade
-Selected all 2's and field calculated as "PK". Repeated the process for all attributes.
HIGRADE from NCES Private Schools database Codebook
Attribute Definition
2 Highest grade in school is PK
3 Highest grade in school is KG
4 Highest grade in school is transitional KG
5 Highest grade in school is transitional 1st grade
6 Highest grade in school is 1st grade
7 Highest grade in school is 2nd grade
8 Highest grade in school is 3rd grade
9 Highest grade in school is 4th grade
10 Highest grade in school is 5th grade
11 Highest grade in school is 6th grade
12 Highest grade in school is 7th grade
13 Highest grade in school is 8th grade
14 Highest grade in school is 9th grade
15 Highest grade in school is 10th grade
16 Highest grade in school is 11th grade
17 Highest grade in school is 12th grade
-Selected all 2's and field calculated as "PK". Repeated the process for all attributes.
New and future schools added (20 total) from various sources including Google, county school districts, and the Bureau of Indian Education in Florida.
Dataset copied.
Internal feature number.
ESRI
Feature geometry.
ESRI
Parcel Identification Number, derived from the 2015 statewide parcel layer.
GeoPlan
The Federal (NCES) public and private school identification number.
GeoPlan
The FDOE public school ID number.
GeoPlan
Facility designation, facility name.
GeoPlan
A description of a facility's physical location providing direction for delivery and provision of emergency services.
GeoPlan
City of facility's physical location.
GeoPlan
US postal delivery designation of facility's physical location.
GeoPlan
County of facility's physical location.
GeoPlan
The phone number of the school facility.
GeoPlan
Educational grade ranges by category. The School Type is derived directly from the Grade Code reported for the school.
FLDOE
Schools providing adult education instruction.
FLDOE
College or University.
GeoPlan
Schools providing instruction at grade levels from elementary to middle/junior high.
GeoPlan
Schools providing instruction in grade groupings that include more than one of the elementary, middle/junior high, and senior high grade categories.
FLDOE
Schools providing instruction at grade levels from middle/junior high to senior high.
GeoPlan
County school district office or school board.
GeoPlan
Schools providing instruction at one or more grade levels from PK through grade 5. May include schools serving grade 6 if also serving one or more grades PK through 5 (e.g., a K-6 school).
FLDOE
Head start.
GeoPlan
Kindergarten.
GeoPlan
Combination of daycare/pre-kindergarten.
GeoPlan
Schools providing instruction in middle school configurations (grades 6-8) and junior high school configurations (grades 7-9). This school type can also include schools serving a single grade in the 6-8 range (e.g., a 6th grade center).
FLDOE
Pre-Kindergarten
GeoPlan
Combination of pre-kindergarten and kindergarten.
GeoPlan
Schools providing instruction at one or more grade levels from 9 to 12; includes regular high schools and 9th grade centers.
FLDOE
County school district facilities including custodial, maintenance, transportation, and other services that support school operations.
GeoPlan
Grade level not yet assigned.
FLDOE
Grade level unknown.
GeoPlan
Entity owner of the facility.
GeoPlan
The responsible organization for management and operation of a facility (e.g., FEDERAL, STATE, COUNTY, MUNICIPAL, PRIVATE, WMD, etc.).
GeoPlan
Classification of the operating entity. (e.g., public, private, quasi-public).
GeoPlan
The year a structure was built for determining possible historical significance.
GeoPlan
Feature Spatial Source.
GeoPlan
Feature Data/Tabular Source.
GeoPlan
The main educational program offered at the school.
FLDOE
The grade level range available at the school.
GeoPlan
The lowest grade level at the school.
GeoPlan
The highest grade level at the school.
GeoPlan
The school principal's name.
GeoPlan
Total number of students attending the school.
GeoPlan
Number of teachers. Teachers for this are full time teachers only.
GeoPlan
Student teacher ratio.
GeoPlan
Number of migrant students. Migrant has not been updated since 2008.
GeoPlan
Designation of the school as a Title I school. Title I Status is designated by the school district based upon criteria in the No Child Left Behind legislation. A school's status is reported to the Department's Bureau of Student Assistance and is supplied to the MSID file by that office. Title I schools may operate school-wide programs or targeted assistance programs.
GeoPlan
Type of magnet program(s) available at the school. Magnet schools and magnet programs offer a specialized curriculum to students outside the school's normal attendance boundaries attracting substantial numbers of students of different social, economic, ethnic, and racial backgrounds. These programs may include subjects like performing arts, technology, marine and environmental science, communications and international affairs and business. Program specialty areas include Academically Talented, Criminal Justice, Foreign Language, International Baccalaureate, Medical, Performing Arts, Science/Math, Technology and others.
GeoPlan
Comments about school. Comments from previous versions of the layer are placed in parentheses.
GeoPlan
Number of students receiving free lunch.
GeoPlan
Number of students receiving reduced lunch.
GeoPlan
First Florida Inventory of School Houses (FISH) Identification Number.
GeoPlan
Second Florida Inventory of School Houses (FISH) Identification Number.
GeoPlan
The presence of broadband service at facility.
GeoPlan
Yes
Unknown
Provider of broadband service.
GeoPlan
Broadband speed to and from facility.
GeoPlan
Max download speed.
GeoPlan
Less than or equal to 200 kbps
Greater than 200 kbps and less than 768 kbps
Greater than or equal 768 kbps and less than 1.5 mbps
Greater than or equal to 1.5 mbps and less than 3 mbps
Greater than or equal to 3 mbps and less than 6 mbps
Greater than or equal to 6 mbps and less than 10 mbps
Greater than or equal to 10 mbps and less than 25 mbps
Greater than or equal to 25 mbps and less than 50 mbps
Greater than or equal to 50 mbps and less than 100 mbps
Greater than or equal to 100 mbps and less than 1000 mbps (1Gbps)
Greater than 1000 mbps (1Gbps)
Date that attribute data was updated based on the FDOE Master School Identification File.
GeoPlan
Date that attribute data was updated based on the NCES public schools dataset
GeoPlan
Date that attribute data was updated based on the FDOE private schools dataset
GeoPlan
Latitude in Decimal Degrees.
GeoPlan
Longitude in Decimal Degrees.
GeoPlan
Military Grid Reference System (MGRS) Coordinate of the facility. The MGRS is the geocoordinate standard used by NATO militaries for locating points on the earth. The MGRS provides a means to represent any location on the surface of the Earth using an alphanumeric string. Hierarchical references are based on the Universal Transverse Mercator (UTM) coordinate system. The MGRS is used for the entire earth. http://mgrs-data.org/
GeoPlan
The GeoPlan Center identification number that links this point feature layer with its corresponding polygon feature layer.
GeoPlan
Facility acreage.
GeoPlan
FGDL added item based on NAME.
GeoPlan
Type of update that occurred.
GeoPlan
Verified, in most cases this verification was based on ESRI/Google Imagery, Google Street View, and Parcel Data. The exact facility boundaries are not verified and in many cases only based on parcel boundaries.
Not verified
Future school not verified
Closed school, verified
The date the data was last updated by the Source.
GeoPlan
The date FGDL acquired the data from the source.
GeoPlan
Unique ID added by GeoPlan
GeoPlan
Area in meters
GeoPlan
Perimeter in meters
GeoPlan
431 Architecture PO Box 115706
The Florida Geographic Data Library is a collection of Geospatial Data compiled by the University of Florida GeoPlan Center with support from the Florida Department of Transportation. GIS data available in FGDL is collected from various state, federal, and other agencies (data sources) who are data stewards, producers, or publishers. The data available in FGDL may not be the most current version of the data offered by the data source. University of Florida GeoPlan Center makes no guarantees about the currentness of the data and suggests that data users check with the data source to see if more recent versions of the data exist. Furthermore, the GIS data available in the FGDL are provided 'as is'. The University of Florida GeoPlan Center makes no warranties, guaranties or representations as to the truth, accuracy or completeness of the data provided by the data sources. The University of Florida GeoPlan Center makes no representations or warranties about the quality or suitability of the materials, either expressly or implied, including but not limited to any implied warranties of merchantability, fitness for a particular purpose, or non-infringement. The University of Florida GeoPlan Center shall not be liable for any damages suffered as a result of using, modifying, contributing or distributing the materials. A note about data scale: Scale is an important factor in data usage. Certain scale datasets are not suitable for some project, analysis, or modeling purposes. Please be sure you are using the best available data. 1:24000 scale datasets are recommended for projects that are at the county level. 1:24000 data should NOT be used for high accuracy base mapping such as property parcel boundaries. 1:100000 scale datasets are recommended for projects that are at the multi-county or regional level. 1:125000 scale datasets are recommended for projects that are at the regional or state level or larger. Vector datasets with no defined scale or accuracy should be considered suspect. Make sure you are familiar with your data before using it for projects or analysis. Every effort has been made to supply the user with data documentation. For additional information, see the References section and the Data Source Contact section of this documentation. For more information regarding scale and accuracy, see our webpage at: http://geoplan.ufl.edu/education.html
131 Architecture, PO Box 11570
www.fgdl.org