About this Dataset

Allegheny County Public Schools / Local Education Agency (LEAs) Locations

These geocoded locations are based on the Allegheny County extract of Educational Names & Addresses (EdNA) via Pennsylvania Department of Education website as of April 19, 2018. Several addresses were not able to be geocoded (ex. If PO Box addresses were provided, they were not geocoded.)

If viewing this description on the Western Pennsylvania Regional Data Center’s open data portal (http://www.wprdc.org), this dataset is harvested on a weekly basis from Allegheny County’s GIS data portal (http://openac.alcogis.opendata.arcgis.com/). The full metadata record for this dataset can also be found on Allegheny County’s GIS portal. You can access the metadata record and other resources on the GIS portal by clicking on the “Explore” button (and choosing the “Go to resource” option) to the right of the “ArcGIS Open Dataset” text below.

Category: Education

Organization: Allegheny County

Department: Department of Human Services

**Temporal Coverage: **as of April 19, 2018

**Data Notes: **

Coordinate System: GCS_North_American_1983

Development Notes: none

Other: none****

Related Document(s): Data Dictionary - none

Frequency - Data Change: April, 19, 2018 data

Frequency - Publishing: one-time

Data Steward Name: See http://www.edna.ed.state.pa.us/Screens/Extracts/wfExtractEntitiesAdmin.aspx for more information.

Data Steward Email: RA-DDQDataCollection@pa.gov (Data Collection Team)
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:01:26.374488
Tags: _etl, arcgis, education, schools, sd, service-definition, state-data

Tables

Table 1

@usgov.allegheny_county_city_of_pitts_allegheny_county_public_5f6c7a5a.table_1

103.16 kB
276 rows
85 columns

CREATE TABLE table_1 (
  "n__id" BIGINT  -- Id,
  "x" DOUBLE,
  "y" DOUBLE,
  "fid" BIGINT,
  "lea_aunumbe" BIGINT,
  "lea_instnam" VARCHAR,
  "lea_category" VARCHAR,
  "lea_iunumbe" BIGINT,
  "lea_iu" VARCHAR,
  "lea_county" VARCHAR,
  "lea_status" VARCHAR,
  "lea_status_e" TIMESTAMP,
  "lea_web_address" VARCHAR,
  "lea_mailing" VARCHAR,
  "lea_maili_1" VARCHAR,
  "lea_maili_2" VARCHAR,
  "lea_maili_3" VARCHAR,
  "lea_maili_4" BIGINT,
  "lea_maili_5" BIGINT,
  "lea_location" VARCHAR,
  "lea_locat_1" VARCHAR,
  "lea_locat_2" VARCHAR,
  "lea_locat_3" VARCHAR,
  "lea_locat_4" BIGINT,
  "lea_locat_5" BIGINT,
  "lea_phone" VARCHAR,
  "lea_phone_1" VARCHAR,
  "lea_admin_ti" VARCHAR,
  "lea_admin_sa" VARCHAR,
  "lea_admin_fi" VARCHAR,
  "lea_admin_mi" VARCHAR,
  "lea_admin_la" VARCHAR,
  "lea_admin_su" VARCHAR,
  "lea_admin_ph" VARCHAR,
  "lea_admin_1" BIGINT,
  "school_inst" VARCHAR,
  "school_aunn" BIGINT,
  "school_bran" BIGINT,
  "school_name" VARCHAR,
  "grade_year" VARCHAR,
  "grade_list" VARCHAR,
  "grade_ctgy" VARCHAR,
  "k4_half" BOOLEAN,
  "k4_full" BOOLEAN,
  "k5_half" BOOLEAN,
  "k5_full" BOOLEAN,
  "grade_1" BOOLEAN,
  "grade_2" BOOLEAN,
  "grade_3" BOOLEAN,
  "grade_4" BOOLEAN,
  "grade_5" BOOLEAN,
  "grade_6" BOOLEAN,
  "elementary" BOOLEAN,
  "grade_7" BOOLEAN,
  "grade_8" BOOLEAN,
  "grade_9" BOOLEAN,
  "grade_10" BOOLEAN,
  "grade_11" BOOLEAN,
  "grade_12" BOOLEAN,
  "secondary" BOOLEAN,
  "school_county" VARCHAR,
  "school_stat" VARCHAR,
  "school_st_1" TIMESTAMP,
  "school_web_address" VARCHAR,
  "school_phone" VARCHAR,
  "school_ph_1" VARCHAR,
  "school_mail" VARCHAR,
  "school_ma_1" VARCHAR,
  "school_ma_2" VARCHAR,
  "school_ma_3" VARCHAR,
  "school_ma_4" BIGINT,
  "school_ma_5" BIGINT,
  "school_loca" VARCHAR,
  "school_lo_1" VARCHAR,
  "school_lo_2" VARCHAR,
  "school_lo_3" VARCHAR,
  "school_lo_4" BIGINT,
  "school_lo_5" BIGINT,
  "school_admi" VARCHAR,
  "school_ad_1" VARCHAR,
  "school_ad_2" VARCHAR,
  "school_ad_3" VARCHAR,
  "school_ad_4" VARCHAR,
  "school_ad_5" VARCHAR,
  "cyberschool" VARCHAR
);