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:

Name : OBJECTID

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:

Attributes:

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