Missouri Office of Geospatial Information 573-522-5034 PO Box 570 301 West High Street, Room 578 Jefferson City MO 65102 US MO.GIS@oa.mo.gov M-F 8-5 Central Standard 20211223 Shapefile 10.6 MO 2021 Public Schools (SHP) Missouri Dept of Elementary and Secondary Education Original data provided by Missouri Department of Elementary and Secondary Education - http://www.dese.mo.gov/directory/ Originally geocoded using the Centrus Geocoder for ArcGIS. Some schools photo identified and placed by University of Missouri's Geographic Resource Center (GRC). February 2010 from data published 11/25/2009 2021-12-23T00:00:00 2021-12-23T00:00:00 Missouri Office of Geospatial Information 573-522-5034 PO Box 570 301 West High Street, Room 578 Jefferson City MO 65102 US MO.GIS@oa.mo.gov M-F 8-5 Central Standard Missouri Office of Geospatial Information <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Contains locations of all identified Missouri public schools</SPAN></P></DIV></DIV></DIV> Missouri schools. This layer currently includes public schools as provided by the Missouri Dept of Elementary and Secondary Education (DESE). Original DESE database included educational programs at correctional facilities. This layer does not include those sites.This dataset developed by the Office of Geospatial Information. Data Updated December 2021. Missouri Office of Geospatial Information 573-522-5034 301 West High Street, Room 578 PO Box 570 Jefferson City MO 65102 US MO.GIS@oa.mo.gov M-F 8-5:00 Will be updated more frequently if new buildings are added or previous schools moved into new facilities. Missouri Office of Geospatial Information 573-522-5034 PO Box 570 301 West High Street, Room 578 Jefferson City MO 65102 US MO.GIS@oa.mo.gov M-F 8-5 Central Standard Missouri Office of Geospatial Information 029 Missouri MO 2021-2022 education magnet schools secondary DESE elementary special education school Missouri MO education 029 secondary DESE elementary school Esri ArcGIS 10.2.2.3574 Locations generated using Centrus Geocoder for ArcGIS from data provided by Missouri Dept of Elementary and Secondary Education from their web site (http://www.dese.mo.gov/directory/download.html) Quality Control by Geographic Resources Center (GRC) completed 10/13/2003 to adjust for false Geocoding results. (Geocoding points that were originally accurate to the ZIP code centroid.) PUBLIC SCHOOLS updated 5/2004. Locational updates provided by GEOGRAPHIC RESOURCE CENTER 6/24/2004 New schools for year 2004-2005 placed using Centrus Geocoder for ArcGIS. 5/9/2007 - schools closed since 2005-2006 were deleted. Schools new for 2006-2007 were added by geocoding addresses with Centrus Geocoder for ArcGIS. Enrollment for these new schools is "0" at the time of data layer creation. 4/7/2008 - new schools for 2007-2008 school year added. Several corrections to locations made to GRC work done in 2003. 3/31/2009 - new schools for 2008-2009 added, any closed schools removed. Locations of new schools photo identified if possible. 2/5/2010 - new schools for 2009-2010 added, any closed schools removed. Location of new schools photo identified if possible. NOTE: Charter schools, which had been previously stored as a separate layer for 2008-09 school year are now included in this public school layers. 10/2010: Data was field verified in the Southeast region of Missouri by staff in the SEMO and Bootheel Regional Planning Commission (RPC) offices, and corrections were added to this file by Missouri State Emergency Management Agency GIS staff. Data that has been field verified by these agencies has a value of "RPC" in the field "LocCode". 11/2011 New Schools were added, closed schools were removed. New schools were photo verified. Comments field added to allow for including information on schools damaged due to Joplin tornado. 09/2013 New Schools were added, closed schools were removed. New schools were photo verified. As several schools have went to a central address, physical addresses were provided for these schools (where different). 02/2014 New Schools were added, closed schools were removed. New schools were photo verified. Three new schools that opened on January 6, 2014 in Joplin were updated with new locations. New facilities for 2014 were geocoded using the Centrus Geocoder. Positions were photo identified on aerial photography where possible (see loc_code attribute for level of positional placement). Latitude, Longitude and Loc_Code were copied and pasted into the missing fields in the working full table of 2014 sites. Two schools that opened in Joplin in August 2014 were updated, and points moved to new locations. 7/28/2016 - Schloss 14 schools deleted, 9 new schools added: based on list of schools provided by DESE data warehouse table, As of this date, there were 8 additional schools in this table, unplaced because there was no address available. 11/27/2017 There were 22 new schools added to the list of schools provided by DESE data warehouse table. 01/05/2018 Deleted 10 schools. Added 4 new schools from the list provided by DESE datawarehouse table. 06/08/2018 Moved three schools to new building locations from the list provided by DESE datawarehouse table. 12/20/2018 Aaron Kale- Deleted 12 schools, added 26 schools from the list provided by DESE datawarehouse table. 08/22/2019 Kendra Williams - Deleted 1 school per DESE. 01/15/2020 Deleted 21 schools, added 29 schools from the list provided by DESE datawarehouse table. Updated 5 schools to 911 addressing and moved 2 schools to new locations. 12/23/2021 Deleted 2 schools. Added 9 new schools from the list provided by DESE datawarehouse table. Missouri Department of Elementary and Secondary Education, Missouri Office of Geospatial Information 1 -95.522797 -89.148059 40.565597 36.019052 Publication date. 2018-12-20T00:00:00 2021-12-23T00:00:00 <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>None</SPAN></P></DIV></DIV></DIV> New facilities for 2009 were geocoded using the software Centrus Geocoder for ArcGIS. Positions were photo identified on 2007 aerial photography where possible (see loc_code attribute for level of positional placement). Latitude, Longitude and Loc_Code were copied and pasted into the missing fields in the working full table of 2008-2009 sites. Table was then displayed as XY events. Events were then exported to personal geodatabase. Spatial join to county boundaries was made to add a column for county name. New facilities for 2011 were geocoded using the ArcGIS 10.0 Online Geocoder for ArcGIS. Positions were photo identified on aerial photography where possible (see loc_code attribute for level of positional placement). Latitude, Longitude and Loc_Code were copied and pasted into the missing fields in the working full table of 2011 sites. Table was then displayed as XY events. Events were then exported to personal geodatabase. Spatial join to county boundaries was made to add a column for county name New facilities for 2012 were geocoded using the ArcGIS 10.0 Online Geocoder for ArcGIS. Positions were photo identified on aerial photography where possible (see loc_code attribute for level of positional placement). Latitude, Longitude and Loc_Code were copied and pasted into the missing fields in the working full table of 2012 sites. As several schools have began using a single district address for all buildings, the physical address of buildings in these districts were added to the "Address2" attribute. New facilities for 2013 were geocoded using the ArcGIS 10.0 Online Geocoder for ArcGIS. Positions were photo identified on aerial photography where possible (see loc_code attribute for level of positional placement). Latitude, Longitude and Loc_Code were copied and pasted into the missing fields in the working full table of 2013 sites. Three new school that opened in Joplin on January 6, 2014 were updated to their new locations. Location of several facilities previously located with aerial photography were further refined during a QA/QC process for a layer for all licensed daycares in Missouri. Many of these daycares are afterschool programs located in the school facilities. Schools for Stet and Revere were removed from the data layer. These school districts were closed on June 30, 2012. New facilities for 2014 were geocoded using the Centrus Geocoder. Positions were photo identified on aerial photography where possible (see loc_code attribute for level of positional placement). Latitude, Longitude and Loc_Code were copied and pasted into the missing fields in the working full table of 2014 sites. Two schools that opened in Joplin in August 2014 were updated, and points moved to new locations. Excel data provided by program converted to Access table. School IDs (SCHID) from previous year (2005-2006) was used to determine which facilities were closed and which facilities were newly opened. Table of new addresses was geocoded using Centrus Geocoder for ArcGIS; personal geodatabase file created. Facilities that had closed since last data update were delete. New addresses geocoded in previous were appended to the file. Locations were checked against 2004 NAIP aerial photography to refine location As a quality check, entire table is geocoded again. Fields for X and Y coordinates are added to this temporary file using the ArcMap command Calculate Geometry. Shape file from previous step also has these fields added. In Access, a table is created that contains the ID, school name and XY coordinates pairs for each. This resultant table is used to generate a line file using the Hawth's Tools command Add XY Line Data from Table. Length of these lines are calculated in miles using the ArcMap Calculate Geometry command. Schools that were more than 1 mile different (between original check at MU in 2004 and regeocoded locations) were verified. Several points were determined to be incorrect (often high school and junior high locations were reversed).,UPDATES FOR 2009 -XLS file from DESE web site is downloaded. File is imported into Microsoft Access. School ID is created by concatenating district number and school number. Fields are added for latitude/longitude and location code. Latitude and Longitude from previous year's layer is transferred to new file using Access update query. Locations that do not have lat/long field are new for 2008-2009. New schools are put into a new file for processing.,As a quality check, entire table is geocoded again. Fields for X and Y coordinates are added to this temporary file using the ArcMap command Calculate Geometry. Shape file from previous step also has these fields added. In Access, a table is created that contains the ID, school name and XY coordinates pairs for each. This resultant table is used to generate a line file using the Hawth's Tools command Add XY Line Data from Table. Length of these lines are calculated in miles using the ArcMap Calculate Geometry command. Schools that were more than 1 mile different (between original check at MU in 2004 and regeocoded locations) were verified. Several points were determined to be incorrect (often high school and junior high locations were reversed).,UPDATES FOR 2009 -XLS file from DESE web site is downloaded. File is imported into Microsoft Access. School ID is created by concatenating district number and school number. Fields are added for latitude/longitude and location code. Latitude and Longitude from previous year's layer is transferred to new file using Access update query. Locations that do not have lat/long field are new for 2008-2009. New schools are put into a new file for processing. New facilities for 2009 (there were 29) were geocoded using the software Centrus Geocoder for ArcGIS. Positions were photo identified on 2008 aerial photography where possible (see loc_code attribute for level of positional placement). Latitude, Longitude and Loc_Code were copied and pasted into the missing fields in the working full table of 2009-2010 sites. Table was then displayed as XY events. Events were then exported to personal geodatabase. Spatial join to county boundaries was made to add a column for county name. As a quality check, entire table is geocoded again. Fields for X and Y coordinates are added to this temporary file using the ArcMap command Calculate Geometry. Shape file from previous step also has these fields added. In Access, a table is created that contains the ID, school name and XY coordinates pairs for each. This resultant table is used to generate a line file using the Hawth's Tools command Add XY Line Data from Table. Length of these lines are calculated in miles using the ArcMap Calculate Geometry command. Schools that were more than 1 mile different (between original check at MU in 2004 and regeocoded locations) were verified. Several points were determined to be incorrect (often high school and junior high locations were reversed).,UPDATES FOR 2009 -XLS file from DESE web site is downloaded. File is imported into Microsoft Access. School ID is created by concatenating district number and school number. Fields are added for latitude/longitude and location code. Latitude and Longitude from previous year's layer is transferred to new file using Access update query. Locations that do not have lat/long field are new for 2008-2009. New schools are put into a new file for processing.,As a quality check, entire table is geocoded again. Fields for X and Y coordinates are added to this temporary file using the ArcMap command Calculate Geometry. Shape file from previous step also has these fields added. In Access, a table is created that contains the ID, school name and XY coordinates pairs for each. This resultant table is used to generate a line file using the Hawth's Tools command Add XY Line Data from Table. Length of these lines are calculated in miles using the ArcMap Calculate Geometry command. Schools that were more than 1 mile different (between original check at MU in 2004 and regeocoded locations) were verified. Several points were determined to be incorrect (often high school and junior high locations were reversed).,UPDATES FOR 2009 -XLS file from DESE web site is downloaded. File is imported into Microsoft Access. School ID is created by concatenating district number and school number. Fields are added for latitude/longitude and location code. Latitude and Longitude from previous year's layer is transferred to new file using Access update query. Locations that do not have lat/long field are new for 2008-2009. New schools are put into a new file for processing. New facilities for 2009 (there were 29) were geocoded using the software Centrus Geocoder for ArcGIS. Positions were photo identified on 2008 aerial photography where possible (see loc_code attribute for level of positional placement). Latitude, Longitude and Loc_Code were copied and pasted into the missing fields in the working full table of 2009-2010 sites. Table was then displayed as XY events. Events were then exported to personal geodatabase. Spatial join to county boundaries was made to add a column for county name. January 2015 - The interactive web map created for DESE generated a review of the current fields in this layer. Fields for Phone, FAX and ZIP were modified to be the appropriate length and switched to Text fields (formerly Number). The PrnTitle field was expanded. This data layer was reconciled with the DESE SQL database view as of 2/5/15. This live link will always likely be more current than the school directory data file posted on the DESE web page. Future updates to this data layer should use this view instead of the web data file. 2015-02-05T00:00:00 Tracy Schloss MO Office of Geospatial Information GIS Specialist From data provided by DESE datawarehouse, 22 new schools were added to the layer. These were geocoded and photography used in QA/QC of the locations. 2017-11-22T00:00:00 Deleted 10 schools, and added 4 new ones from list provided by DESEdata list. 2018-01-05T00:00:00 Three facilities were moved to new locations. 2018-06-08T00:00:00 Missouri Office of Geospatial Information 573-522-5034 PO Box 570 301 West High Street, Room 840 Jefferson City MO 65102 US MO.GIS@oa.mo.gov M-F 8-5 Central Standard Missouri Office of Geospatial Information Deleted 12 schools, added 26 schools from the list provided by DESE datawarehouse table. 2018-12-20T00:00:00 Missouri Office of Geospatial Information 573-522-5034 PO Box 570 301 West High Street, Room 578 Jefferson City MO 65102 US MO.GIS@oa.mo.gov M-F 8-5 Central Standard Missouri Office of Geospatial Information Removed 1 school per DESE 2019-08-22T00:00:00 Missouri Office of Geospatial Information 573-522-5034 PO Box 570 301 West High Street, Room 578 Jefferson City MO 65102 US MO.GIS@oa.mo.gov M-F 8-5 Central Standard Missouri Office of Geospatial Information Deleted 21 schools, added 29 schools from the list provided by DESE datawarehouse table. Updated 5 schools to 911 addressing and moved 2 schools to new locations. 2020-01-15T00:00:00 Missouri Office of Geospatial Information 573-522-5034 PO Box 570 301 West High Street, Room 578 Jefferson City MO 65102 US MO.GIS@oa.mo.gov M-F 8-5 Central Standard Missouri Office of Geospatial Information Removed 16 schools. Added 21 new schools. Moved 10 schools to new locations. 2020-12-23T00:00:00 Missouri Office of Geospatial Information 573-522-5034 PO Box 570 301 West High Street, Room 578 Jefferson City MO 65102 US MO.GIS@oa.mo.gov M-F 8-5 Central Standard Missouri Office of Geospatial Information Removed two schools. Added 9 new facilities. Updated several administrators and email addresses. 2021-12-23T00:00:00 Missouri Office of Geospatial Information 573-522-5034 PO Box 570 301 West High Street, Room 578 Jefferson City MO 65102 US MO.GIS@oa.mo.gov M-F 8-5 Central Standard Missouri Office of Geospatial Information NA NA Complete as of the data of data download. MO 2021 Public Schools (SHP) Contains all public schools in the state of Missouri Missouri Department of Elementary and Secondary Education. Feature Class 2399 Enrollment Total students enrolled, DESE field name - SCHTENR Missouri Department of Elementary and Secondary Education Sequential unique whole numbers that are automatically generated. Enrollment Double 8 18 8 Teachers Total number of teachers. DESE field name - SCHTTEACH Missouri Department of Elementary and Secondary Education Sequential unique whole numbers that are automatically generated. Teachers Double 8 18 8 Principal Full name of the school's principal, concatenated from DESE school directory fields PRINSAL, PRINFN, PRINMI,PRINLN Missouri Department of Elementary and Secondary Education Sequential unique whole numbers that are automatically generated. Principal String 50 0 0 CtyDist School District number Department of Elementary and Secondary Education CtyDist String 8 0 0 Shape Feature geometry. ESRI Coordinates defining the features. SHAPE Geometry 4 0 0 Longitude Longitude in decimal degrees, Coordinates = geographic coordinates NAD 1983 ArcGIS Online Geocoder - added by OGI Sequential unique whole numbers that are automatically generated. Longitude Double 8 18 8 OBJECTID Internal feature number. Esri Sequential unique whole numbers that are automatically generated. OBJECTID OID 4 10 0 Zip ZIP code where school city is located. DESE field name - SCHZIP Department of Elementary and Secondary Education Sequential unique whole numbers that are automatically generated. ZIP String 10 0 0 Phone Phone number of the school. DESE field name - SCHPHONE Department of Elementary and Secondary Education Sequential unique whole numbers that are automatically generated. Phone String 15 0 0 Address School address, DESE field name - SCHADDR1 Department of Elementary and Secondary Education Sequential unique whole numbers that are automatically generated. Address String 50 0 0 PrinTitle Title of the Principal. DESE field name - PRINTITL Missouri Department of Elementary and Secondary Education Sequential unique whole numbers that are automatically generated. PrinTitle String 25 0 0 SchNum School number (numbers assigned per district and are not unique, see SCHID) Department of Elementary and Secondary Education SchNum String 6 0 0 Address2 Secondary or supplemental address information, In the case of schools with a district-wide address, contains physical address of individual school. DESE field name - SCHADDR2 Missouri Department of Elementary and Secondary Education Sequential unique whole numbers that are automatically generated. Address2 String 100 0 0 City City where school city is located. DESE field name - SCHCITY Department of Elementary and Secondary Education Sequential unique whole numbers that are automatically generated. City String 35 0 0 Latitude Latitude in decimal degrees, Coordinates = geographic coordinates NAD 1983 ArcGIS Online Geocoder- added by OGI Sequential unique whole numbers that are automatically generated. Latitude Double 8 18 8 EGrade Ending Grade taught at school Missouri Department of Elementary and Secondary Education Sequential unique whole numbers that are automatically generated. EGrade String 3 0 0 BGrade Beginning Grade taught at school Missouri Department of Elementary and Secondary Education Sequential unique whole numbers that are automatically generated. BGrade String 3 0 0 SchID Used to link school locations with school attendance. Created by combining the district number and the school number provided by DESE Office of Geospatial Information. SchID String 15 0 0 Email SchEmail String 35 0 0 State State where school city is located (all MO for Missouri) - field not found in original DESE school directory Office of Geospatial Information. Sequential unique whole numbers that are automatically generated. State String 4 0 0 Loc_Code Reports the locational accuracy of the match, includes whether or not an address geocode is achieved. ESRI GEO Location based on address matching provided by Centrus Geocoder for ArcGIS. Location is placed along a particular road segment. OGI MAP_MU Location based on existing map features that were previously photo identified using 2004 NAIP aerial photography by staff at Geographic Resource Center at MU. University of Missouri GRC CENT Location approximated; centrally located in general vicinity i.e. center of town. Positional accuracy will vary - unable to find location on aerial photograph OGI MAP Location based on existing map features that were previously photo identified using aerial photography and Google Street view by OGI staff. OGI RPC location field verified by local Regional Planning Commission staff SEMA Loc_Code String 6 0 0 Facility Name of school building, DESE field name - SCHNAME Department of Elementary and Secondary Education. Sequential unique whole numbers that are automatically generated. Facility String 50 0 0 FAX FAX number of the school, DESE field name - SCHFAX ESRI FAX String 15 0 0 County County where schools is located Office of Geospatial Information Sequential unique whole numbers that are automatically generated. County String 35 0 0 dataset EPSG 8.2.6 2399 Simple FALSE 2399 TRUE FALSE Missouri Office of Geospatial Information 573-522-5034 PO Box 570 301 West High Street, Room 578 Jefferson City MO 65102 US MO.GIS@oa.mo.gov M-F 8-5 Central Standard Missouri Office of Geospatial Information EDUCATION_SCHOOL_PUBLIC 002 286343.655800 826422.187900 3992133.406400 4490536.000500 1 Projected GCS_North_American_1983 Linear Unit: Meter (1.000000) NAD_1983_UTM_Zone_15N <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.7'><WKT>PROJCS[&quot;NAD_1983_UTM_Zone_15N&quot;,GEOGCS[&quot;GCS_North_American_1983&quot;,DATUM[&quot;D_North_American_1983&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Transverse_Mercator&quot;],PARAMETER[&quot;False_Easting&quot;,500000.0],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-93.0],PARAMETER[&quot;Scale_Factor&quot;,0.9996],PARAMETER[&quot;Latitude_Of_Origin&quot;,0.0],UNIT[&quot;Meter&quot;,1.0],AUTHORITY[&quot;EPSG&quot;,26915]]</WKT><XOrigin>-5120900</XOrigin><YOrigin>-9998100</YOrigin><XYScale>10000</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>26915</WKID><LatestWKID>26915</LatestWKID></ProjectedCoordinateSystem> 20220613 11472200 20220613 11472200 150000000 5000 1.0 FGDC 20230120 07583100 FGDC CSDGM Metadata FALSE MO 2018 Public Schools (SHP)