[Data-modeling] Changes to the schema for primary and secondary schools

Jeff Prucher jeff at metaweb.com
Wed Sep 17 00:18:54 UTC 2008


Currently, the lowest and highest grade levels taught for schools (that is,
primary and secondary schools) is stored as a text string. This makes it
extremely difficult to compare schools, since the data varies widely (e.g.
"1" and "first" are both used). There's been a request to normalize this,
and I've put up a proposal in a personal domain on sandbox. My idea is that
there should be a new type (Grade Level) for this value. Because these can
vary greatly (both in terms of nomenclature and how they function in the
school system), I've also included a non-unique, disambiguating property for
the locations in which this grade is used.

The Grade Level type is here:
http://sandbox.freebase.com/view/user/jeff/education/grade_level

Additionally, I'd like to add dates to the "average class size" and
"student:teacher ratio" properties.

Here's an example of a school with (only) these changed properties:
<URL:
http://sandbox.freebase.com/view/guid/9202a8c04000641f8000000006bad0a0?domai
n=%2Fuser%2Fjeff%2Feducation>

Thoughts?

Jeff



More information about the Data-modeling mailing list