Name: Public School Administrative Data 2022-23
Display Field: LEA_NAME
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: 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. CCD school and agency point locations are derived from reported information about the physical location of schools and agency administrative offices. The point locations and administrative attributes in this data layer were developed from the 2022-2023 CCD collection. For more information about NCES school point data, see: https://nces.ed.gov/programs/edge/Geographic/SchoolLocations. For more information about these CCD attributes, as well as additional attributes not included, see: https://nces.ed.gov/ccd/files.asp.All information contained in this file is in the public domain. Data users are advised to review NCES program documentation and feature class metadata to understand the limitations and appropriate use of these data.
Copyright Text: NCES EDGE
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -176.640330999
YMin: -14.348924
XMax: 145.784429999
YMax: 71.3003370000001
Spatial Reference: 4269 (4269)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"6d1a7c3b2f45f17dc3d15174cb9c1b78","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA8AAAAOCAYAAADwikbvAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA6UlEQVQokaWSwXHCMBBFn2KakNpwukB2GaQAMVwh1wwugDYS0UVoA1dhLSPZHisweIDsRV/S/t2nHS34Ryzu3tQbQ+gOoE74/e45c9dpFBbEYp3lraj5/jo/Zr4O6bbAx5NmVeP3P/PYdl0hoiePMiCgxLJ003lR+BE/71yi2Gac47JCZVkhfAK7W2yh5dgYrIuYGt+8Y90v0OKbiqU754X+mhWayh0IlGnfawOYpAU9P7BAlYrkOhL1mvvma+zjgK3msFOyxE+hk5YBu9c99lhQZIV1ZSyWd24BP7z9lM1h0vH+pnNEeiEuy09bHYXROcsAAAAASUVORK5CYII=","contentType":"image/png","width":11,"height":10,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- NCESSCH (type: esriFieldTypeString, alias: Unique School ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- SURVYEAR (type: esriFieldTypeString, alias: Year corresponding to survey record, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- STABR (type: esriFieldTypeString, alias: Postal state abbreviation code, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- LEAID (type: esriFieldTypeString, alias: NCES Agency ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- ST_LEAID (type: esriFieldTypeString, alias: State Local Education Number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- LEA_NAME (type: esriFieldTypeString, alias: Education Agency Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- SCH_NAME (type: esriFieldTypeString, alias: School name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- LSTREET1 (type: esriFieldTypeString, alias: Location address, street 1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- LSTREET2 (type: esriFieldTypeString, alias: Location address, street 2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- LCITY (type: esriFieldTypeString, alias: Location city, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- LSTATE (type: esriFieldTypeString, alias: Location state, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- LZIP (type: esriFieldTypeString, alias: Location 5 digit ZIP code, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- LZIP4 (type: esriFieldTypeString, alias: Location Secondary ZIP code, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- PHONE (type: esriFieldTypeString, alias: Telephone number, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- CHARTER_TEXT (type: esriFieldTypeString, alias: Whether a Charter School, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- VIRTUAL (type: esriFieldTypeString, alias: Virtual School Status, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- GSLO (type: esriFieldTypeString, alias: Grades Offered - Lowest, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- GSHI (type: esriFieldTypeString, alias: Grades Offered - Highest, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- SCHOOL_LEVEL (type: esriFieldTypeString, alias: School level, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- STATUS (type: esriFieldTypeString, alias: Start of year status (code), SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- SCHOOL_TYPE_TEXT (type: esriFieldTypeString, alias: School type (description), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- SY_STATUS_TEXT (type: esriFieldTypeString, alias: Start of year Status (description), SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- ULOCALE (type: esriFieldTypeString, alias: Locale Code, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- NMCNTY (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
- CNTY (type: esriFieldTypeString, alias: County FIPS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- TOTFRL (type: esriFieldTypeInteger, alias: Total of free lunch and reduced-price lunch eligible, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FRELCH (type: esriFieldTypeInteger, alias: Free Lunch Program, SQL Type: sqlTypeOther, nullable: true, editable: true)
- REDLCH (type: esriFieldTypeInteger, alias: Reduced-Lunch Program, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DIRECTCERT (type: esriFieldTypeInteger, alias: Direct Certification, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PK (type: esriFieldTypeInteger, alias: Prekindergarten students, SQL Type: sqlTypeOther, nullable: true, editable: true)
- KG (type: esriFieldTypeInteger, alias: Kindergarten students, SQL Type: sqlTypeOther, nullable: true, editable: true)
- G01 (type: esriFieldTypeInteger, alias: Grade 1 students, SQL Type: sqlTypeOther, nullable: true, editable: true)
- G02 (type: esriFieldTypeInteger, alias: Grade 2 students, SQL Type: sqlTypeOther, nullable: true, editable: true)
- G03 (type: esriFieldTypeInteger, alias: Grade 3 students, SQL Type: sqlTypeOther, nullable: true, editable: true)
- G04 (type: esriFieldTypeInteger, alias: Grade 4 students , SQL Type: sqlTypeOther, nullable: true, editable: true)
- G05 (type: esriFieldTypeInteger, alias: Grade 5 students, SQL Type: sqlTypeOther, nullable: true, editable: true)
- G06 (type: esriFieldTypeInteger, alias: Grade 6 students , SQL Type: sqlTypeOther, nullable: true, editable: true)
- G07 (type: esriFieldTypeInteger, alias: Grade 7 students , SQL Type: sqlTypeOther, nullable: true, editable: true)
- G08 (type: esriFieldTypeInteger, alias: Grade 8 students , SQL Type: sqlTypeOther, nullable: true, editable: true)
- G09 (type: esriFieldTypeInteger, alias: Grade 9 students , SQL Type: sqlTypeOther, nullable: true, editable: true)
- G10 (type: esriFieldTypeInteger, alias: Grade 10 students, SQL Type: sqlTypeOther, nullable: true, editable: true)
- G11 (type: esriFieldTypeInteger, alias: Grade 11 students, SQL Type: sqlTypeOther, nullable: true, editable: true)
- G12 (type: esriFieldTypeInteger, alias: Grade 12 students, SQL Type: sqlTypeOther, nullable: true, editable: true)
- G13 (type: esriFieldTypeInteger, alias: Grade 13 students, SQL Type: sqlTypeOther, nullable: true, editable: true)
- UG (type: esriFieldTypeInteger, alias: Ungraded students, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AE (type: esriFieldTypeInteger, alias: Adult Education Students, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TOTMENROL (type: esriFieldTypeInteger, alias: Total Male Enrollment, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TOTFENROL (type: esriFieldTypeInteger, alias: Total Female Enrollment, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TOTAL (type: esriFieldTypeInteger, alias: Total students, all grades (includes AE), SQL Type: sqlTypeOther, nullable: true, editable: true)
- MEMBER (type: esriFieldTypeInteger, alias: Total elementary/secondary students (excludes AE), SQL Type: sqlTypeOther, nullable: true, editable: true)
- FTE (type: esriFieldTypeDouble, alias: Total Teachers, SQL Type: sqlTypeOther, nullable: true, editable: true)
- STUTERATIO (type: esriFieldTypeDouble, alias: Student teacher ratio, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AMALM (type: esriFieldTypeInteger, alias: All Students - American Indian/Alaska Native - Male, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AMALF (type: esriFieldTypeInteger, alias: All Students - American Indian/Alaska Native - Female, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AM (type: esriFieldTypeInteger, alias: All Students - American Indian/Alaska Native, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ASALM (type: esriFieldTypeInteger, alias: All Students - Asian - Male, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ASALF (type: esriFieldTypeInteger, alias: All Students - Asian - Female, SQL Type: sqlTypeOther, nullable: true, editable: true)
- AS_ (type: esriFieldTypeInteger, alias: All Students - Asian, SQL Type: sqlTypeOther, nullable: true, editable: true)
- BLALM (type: esriFieldTypeInteger, alias: All Students - Black or African American - Male, SQL Type: sqlTypeOther, nullable: true, editable: true)
- BLALF (type: esriFieldTypeInteger, alias: All Students - Black or African American - Female, SQL Type: sqlTypeOther, nullable: true, editable: true)
- BL (type: esriFieldTypeInteger, alias: All Students - Black or African American, SQL Type: sqlTypeOther, nullable: true, editable: true)
- HPALM (type: esriFieldTypeInteger, alias: All Students - Native Hawai'ian or Other Pacific Islander - Male, SQL Type: sqlTypeOther, nullable: true, editable: true)
- HPALF (type: esriFieldTypeInteger, alias: All Students - Native Hawai'ian or Other Pacific Islander - Female, SQL Type: sqlTypeOther, nullable: true, editable: true)
- HP (type: esriFieldTypeInteger, alias: All Students - Native Hawai'ian or Other Pacific Islander, SQL Type: sqlTypeOther, nullable: true, editable: true)
- HIALM (type: esriFieldTypeInteger, alias: All Students - Hispanic - Male, SQL Type: sqlTypeOther, nullable: true, editable: true)
- HIALF (type: esriFieldTypeInteger, alias: All Students - Hispanic - Female, SQL Type: sqlTypeOther, nullable: true, editable: true)
- HI (type: esriFieldTypeInteger, alias: All Students - Hispanic, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TRALM (type: esriFieldTypeInteger, alias: All Students - Two or More Races - Male, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TRALF (type: esriFieldTypeInteger, alias: All Students - Two or More Races - Female, SQL Type: sqlTypeOther, nullable: true, editable: true)
- TR (type: esriFieldTypeInteger, alias: All Students - Two or More Races, SQL Type: sqlTypeOther, nullable: true, editable: true)
- WHALM (type: esriFieldTypeInteger, alias: All Students - White - Male, SQL Type: sqlTypeOther, nullable: true, editable: true)
- WHALF (type: esriFieldTypeInteger, alias: All Students - White - Female, SQL Type: sqlTypeOther, nullable: true, editable: true)
- WH (type: esriFieldTypeInteger, alias: All Students - White, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LATCOD (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- LONCOD (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
Templates:
Name: Public School Administrative Data 2022-23
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 2/10/2025 8:09:12 PM
Schema Last Edit Date: 2/10/2025 8:09:12 PM
Data Last Edit Date: 2/10/2025 8:09:12 PM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat