- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I wish to know the school district for a given home address of a student.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Census Bureau is better it seems, single file:
https://nces.ed.gov/programs/edge/Geographic/DistrictBoundaries
- Use PROC GEOCODE to map your addresses to lat/long
- Use PROC MAPIMPORT to import the boundary file
- Use PROC GINSIDE to determine which points from #1 belong to which regions in #2
If you have something like QGIS or ESRI ARCGIS this is more easily accomplished in those tools via point and click procedures except for Step #1.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You may be able to use SAS geocoding functions to convert an address to some other geo field (like a zip code or other region or lat/long), but you're going to need a database of school districts and their boundaries. Or sometimes the rules are more complex, and you need to use a web service (if available) to perform this lookup.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You'll need to provide more details.
Do you have a data set of school districts of some kind? Maps of those spatial area's in SHP files?
What country are you in?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Are you looking at all of USA or a particular state or region?
States/ municipalities often publish this data on their open data portal.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Census Bureau is better it seems, single file:
https://nces.ed.gov/programs/edge/Geographic/DistrictBoundaries
- Use PROC GEOCODE to map your addresses to lat/long
- Use PROC MAPIMPORT to import the boundary file
- Use PROC GINSIDE to determine which points from #1 belong to which regions in #2
If you have something like QGIS or ESRI ARCGIS this is more easily accomplished in those tools via point and click procedures except for Step #1.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
A possible issue may be that your school does not actually belong to a school district. School Districts typically are Public schools and do not consider a Private school in there geography as belonging to the district.
I have worked with public/ private mixed school data. If this is for a single state I might also search the department of education, or whatever a specific state might call it, website. I know in my state I can get such information along with enrollment and other bits in a single file.