School District
Dataset
Description
US schools are usually grouped into school districts responsible for administering those schools. Some school districts may be responsible for all K12 schools in an area, while others may only administer schools of a specific level (e.g. high schools). This dataset provides a summary for each of those school districts. This dataset provides the mechanisms to establish the relationships between individual properties and a school district
Geo ID | 2199 : 6e42512882c957ae6383fe48e2b71227 |
Name | Irvine Unified School District |
Address | 5050 Barranca Pkwy, Irvine CA 92604 |
URL | http://www.iusd.org |
Level | Unified |
Schools | 43 |
Teachers | 1,379.9 |
Students | 35,660 |
Total Revenue | $508,471,000 |
Total Expenditure | $541,186,000 |
Rating | A+ |
Examples
Vacant Land in School District
The following code demonstrates how to locate all properties that are vacant land within a specific school district
/* * Identify Owners of Residential Vacant Land in a specific school district */ Select PF.[ATTOM ID], /* * Property Address Details */ PF.APNFormatted, CONCAT(PF.SitusAddress,', ',PF.SitusCity,' ',PF.SitusState,' ',PF.SitusZip) AS Address, PF.LegalDescription, PF.LotSizeSquareFeet, /* * Owner details */ RO.Owner1FullName, CONCAT(RO.TaxBillMailingAddress,', ',RO.TaxBillMailingCity,' ',RO.TaxBillMailingState,' ',RO.TaxBillMailingZip) AS TaxBillAddress From ADW.DimSchoolDistrict SD -- School District Join ADW.PropertyBoundaryMatch PBM On SD.SchoolDistrictKey = PBM.GeographyKey -- Property Boundary Match Join ADW.PropertyFeature PF On PBM.[ATTOM ID] = PF.[ATTOM ID] -- Property Address & Property Characteristics Join ADW.REOwnership RO On RO.[ATTOM ID] = PF.[ATTOM ID] -- Current Owner Where SD.SchoolDistrictKey = 1868 AND -- Specific School Diustrict PBM.GeographyTypeKey = 53 AND -- School District PF.PropertyTypeKey = 301 -- Residential Vacant Land