search

codeforokc / school-finder

Geolocation-based web app for locating schools and school districts near you
MIT License
18 stars 17 forks source link

Show data on map #21

Open vantreeseba opened 9 years ago

jvrousseau commented 9 years ago

not sure if this is useful, but here's a dataset from ok.gov (statewide):

https://data.ok.gov/Education/Oklahoma-Institutions-of-Common-Education/y9pd-rjtd

cc: @joekarl @DevinClark

joekarl commented 9 years ago

Yeah saw that, trick will be xrefing the data we have with that data (probably have to go against school name which will be spotty at best)

Mike-Loffland commented 9 years ago

We're only concerned with Oklahoma City Schools... correct?

Filtering the school data at data.ok.gov to only include OKC schools returns 184 results. This is significantly lower than the 363 school entries in our current dataset.

mkchandler commented 9 years ago

We want to also include the surrounding suburbs of OKC if possible (Edmond, Mustang, Yukon, Bethany, etc.)

Mike-Loffland commented 9 years ago

@mkchandler gotcha... I'm just trying to figure out what geographic boundary was used to produce the dataset at http://data.okc.gov/applications/datadownload/forms/DownloadDetails.aspx?DataSetID=17.

It includes only one school from the Norman area. It also includes Little Axe and McCloud.

Mike-Loffland commented 9 years ago

Here is a filtered view of the OKC Metro area.

There seems to be a refresh issue with their grid when loading a saved view... click the "OKC METRO" link to get the grid to populate the correct view.

https://data.ok.gov/Education/OKC-METRO/4whz-7phq

@joekarl I saw that you have a branch that is attempting to make the schools as points instead of polygons. The data on data.ok.gov has lat, long, and location columns. I assume that location would be the point we need?

joekarl commented 9 years ago

Yeah, those columns are the ones we'd need to cross reference with our existing polygon data from the city (should be able to see which feature from the geojson contains the school point from ok.data.gov).