SYSTEMS AND METHODS FOR DETERMINING SCHOOL GEOGRAPHIC BOUNDARIES AND RELATED SEARCHES

• US 20130018704A1
• Filed: 07/03/2012
• Published: 01/17/2013
• Est. Priority Date: 07/13/2011
• Status: Abandoned Application

• Current Assignee: Navaro Innovation, LLC
• Original Assignee: Navaro Innovation, LLC
• Inventors: Liu, Ying
• Application Number:
  US13/541,514
• Publication Number:
  US 20130018704A1
• Time in Patent Office: Days
• US Class Current: 705/7.38
• CPC Class Codes: G06F 16/29 Geographical information databases
• CPC Class Codes: G06Q 50/20 Education

Abstract

Method, system, and computer program product for collecting and integrating school information. The method includes collecting boundary data for one or more schools, and determining one or more boundary lines based on at least the collected boundary data. Each of the one or more boundary lines represent a border between a first area assigned to a first school selected from the one or more schools and a second area assigned to a second school selected from the one or more schools. Additionally, the method includes digitizing the one or more boundary lines, and collecting student performance data for the one or more schools. The collected student performance data include first student performance data for the first school and second student performance data for the second school. Moreover, the method includes storing the one or more digitized boundary lines and the student performance data in one or more data stores.

Claims

1. A method for collecting and integrating school information, the method comprising:

collecting boundary data for one or more schools;

determining one or more boundary lines based on at least the collected boundary data, each of the one or more boundary lines representing a border between a first area assigned to a first school selected from the one or more schools and a second area assigned to a second school selected from the one or more schools;

digitizing the one or more boundary lines;

collecting student performance data for the one or more schools, the collected student performance data including first student performance data for the first school and second student performance data for the second school; and

storing the one or more digitized boundary lines and the student performance data in one or more data stores;

wherein the process for storing the one or more digitized boundary lines and the student performance data includes;

associating the one or more digitized boundary lines with at least the first school and the second school; and

associating the first student performance data with the first school and the second student performance data with the second school.

2. The method of claim 1, and further comprising providing a search interface to allow one or more searches based on at least information associated with the stored one or more digitized boundary lines.

3. The method of claim 2 wherein the process for providing a search interface includes providing the search interface to allow the one or more searches based on at least information associated with the stored first student performance data.

4. The method of claim 1 wherein the student performance data include one or more Academic Performance Index (API) scores.

5. The method of claim 1 wherein the student performance data include ranking data for at least the first school and the second school.

6. The method of claim 1 wherein the student performance data include aggregate school scores for at least the first school and the second school.

7. The method of claim 1 wherein each of the one or more data stores includes a database.

8. The method of claim 1 wherein each of the one or more data stores includes a file.

9. The method of claim 1, and further comprising:

identifying missing student performance data;

estimating the missing student performance data based on at least information associated with the collected student performance data; and

storing the missing student performance data;

wherein the process for storing the missing student performance data includes associating the missing student performance data with at least one of the one or more schools.

10. A method for creating one or more boundary lines, the method comprising:

identifying one or more sources of school boundary data;

processing information associated with each of the one or more sources of school boundary data;

identifying a format for each of the one or more sources of school boundary data;

collecting boundary data for one or more schools from the one or more sources of school boundary data;

determining one or more boundary lines based on at least the collected boundary data, each of the one or more boundary lines representing a border between a first area assigned to a first school selected from the one or more schools and a second area assigned to a second school selected from the one or more schools;

digitizing the one or more boundary lines;

resolving inconsistencies between the one or more digitized boundary lines; and

storing the one or more digitized boundary lines in one or more data stores;

wherein the process for storing the one or more digitized boundary lines includes associating the one or more digitized boundary lines with at least the first school and the second school.

11. The method of claim 10 wherein the one or more boundary lines associated with the first school define one or more polygons.

12. The method of claim 10 wherein the process for determining one or more boundary lines includes aligning one or more of the one or more boundary lines with one or more geographic landmarks.

13. The method of claim 10 wherein the boundary lines are represented using at least one or more geolocations.

14. The method of claim 10, and further comprising:

determining a bounding rectangle that encloses at least the first area; and

storing the bounding rectangle in the one or more data stores;

wherein the process for storing the bounding rectangle includes associating the bounding rectangle with the first school.

15. The method of claim 10 wherein the process for resolving inconsistencies between the one or more digitized boundary lines includes:

identifying one or more first regions based on at least information associated with one or more first boundary lines selected from the one or more boundary lines, the one or more first boundary lines being associated with the first school and determined using a first source selected from the one or more sources of school boundary data;

identifying one or more second regions based on at least information associated with one or more second boundary lines selected from the one or more boundary lines, the one or more second boundary lines being associated with the first school and determined using a second source selected from the one or more sources of school boundary data;

calculating one or more differences between the one or more first regions and the one or more second regions;

processing the one or more differences and a predetermined threshold; and

if the one or more differences are greater than the predetermined threshold, removing the one or more first boundary lines determined using the first source from the one or more boundary lines.

16. The method of claim 15 wherein the predetermined threshold is 50 square feet.

17. The method of claim 10 wherein the format of each of the one or more sources of school boundary data includes one selected from a group consisting of a street attendance directory, an online school locator, and a boundary map.

18. The method of claim 10 wherein:

a first source of school boundary data includes a street attendance directory; and

the process for determining one or more boundary lines includes;

selecting a first attending school record from the street attendance directory, the first attending school record matching one or more first addresses to a first school, the one or more first addresses including at least a first property address;

receiving a second attending school record from the street attendance directory, the second attending school record matching one or more second addresses to a second school, the one or more second addresses including at least a second property address;

converting at least the first property address to a first geolocation;

converting at least the second property address to a second geolocation;

assigning a first symbol to the first school;

assigning a second symbol to the second school;

displaying the first symbol in a boundary editor at at least a first screen position based on at least information associated with the first geolocation and displaying the second symbol in the boundary editor at at least a second screen position based on at least information associated with the second geolocation; and

locating the one or more boundary lines between one or more displays of the first symbol and one or more displays of the second symbol.

19. The method of claim 18 wherein the process for determining one or more boundary lines further includes:

generating an address format converter for converting the one or more first addresses to a uniform address format; and

converting the one or more first addresses to a uniform address format.

20. The method of claim 10 wherein:

a first source of school boundary data includes an online school locator; and

the process for determining one or more boundary lines includes;

collecting one or more addresses including a first address and a second address;

querying the online school locator using an interface wrapper based on at least information associated with the first address;

querying the online school locator using an interface wrapper based on at least information associated with the second address;

receiving, from the online school locator, information associated with a first school based on at least information associated with the first address;

receiving, from the online school locator, information associated with a second school based on at least information associated with the second address;

converting the first address to a first geolocation;

converting the second address to a second geolocation;

assigning a first symbol to the first school;

assigning a second symbol to the second school;

displaying the first symbol in a boundary editor at at least a first screen position based on at least information associated with the first geolocation and displaying the second symbol in the boundary editor at at least a second screen position based on at least information associated with the second geolocation; and

locating the one or more boundary lines between one or more displays of the first symbol and one or more displays of the second symbol.

21. The method of claim 20 wherein the process for determining one or more boundary lines further includes generating the interface wrapper.

22. The method of claim 10 wherein:

a first source of school boundary data includes a boundary map with one or more school boundaries; and

the process for determining one or more boundary lines includes;

loading the boundary map into a boundary editor;

loading a street map into the boundary editor, the street map corresponding to the boundary map;

aligning the boundary map and the corresponding street map;

adjusting at least a scale for the boundary map or the corresponding street map; and

converting the one or more school boundaries on the boundary map into the one or more boundary lines on the corresponding street map.

23. The method of claim 22 wherein the process for determining one or more boundary lines further includes loading one or more previously determined boundary lines in the boundary editor.

24. A method for collecting school data, the method comprising:

collecting first student performance data associated with a school from a first data source;

collecting second student performance data associated with the school from a second data source;

processing information associated with the first student performance data and the second student performance data;

processing the first student performance data and the second student performance data;

if the first student performance data is not consistent with the second student performance data, generating third student performance data based on at least information associated with the second student performance data;

if the first student performance data is consistent with the second student performance data, generating the third student performance data based on at least information associated with the first student performance data and the second student performance data;

determining a geolocation of the school; and

storing the third student performance data and the geolocation in one or more data stores;

wherein the process for storing the third student performance data and the geolocation includes;

associating the third student performance data with the school; and

associating the geolocation with the school.

25. The method of claim 24 wherein the third student performance data include one or more Academic Performance Index (API) scores.

26. The method of claim 24 wherein the third student performance data include ranking data for the school.

27. The method of claim 24 wherein the third student performance data include aggregate school scores for the school.

28. The method of claim 24, and further comprising:

identifying missing student performance data;

estimating the missing student performance data based on at least information associated with the third student performance data; and

storing the missing student performance data;

wherein the process for storing the missing student performance data includes associating the missing student performance data with at least the school.

29. The method of claim 28 wherein the process for estimating the missing student performance data includes using a function selected from a group consisting of an interpolation function and an extrapolation function.

30. A method for collecting and storing property data, the method comprising:

accessing a first property data source using a first interface;

requesting at least first property data correspond to a first property from the first property data source;

determining a geolocation for the first property based on at least information associated with the first property data;

accessing one or more first data stores;

receiving, from the one or more first data stores, information associated with one or more attending schools related to the geolocation; and

storing the first property data and the one or more attending schools in one or more second data stores;

wherein the process for storing the first property data and the one or more attending schools includes associating the one or more attending schools with the first property.

31. The method of claim 30 wherein the one or more first data stores and the one or more second data stores are different.

32. The method of claim 30, and further comprising:

determining the one or more attending schools based on at least information associated with the geolocation, the one or more attending schools including a first school;

wherein the process for determining one or more attending schools includes;

receiving, from the one or more first data stores, information associated with one or more boundary lines associated with the first school;

determining an attendance area for the first school based on at least information associated with the one or more boundary lines;

processing the geolocation and the attendance area; and

determining if the geolocation is within the attendance area.

33. The method of claim 32 wherein the process for determining one or more attending schools further includes:

receiving, from the one or more first data stores, a bounding rectangle associated with the first school;

processing the geolocation and the bounding rectangle; and

determining if the geolocation is within the bounding rectangle.

34. The method of claim 30, and further comprising:

requesting, from the one or more first data stores, first student performance data for the one or more attending schools;

determining an aggregate school score for at least the first property based on at least information associated with the first student performance data; and

storing the aggregate school score in the one or more second data stores;

wherein the process for storing the aggregate school score in the one or more second data stores includes associating the aggregate school score with the first property.

35. The method of claim 34 wherein the process for determining an aggregate school score for at least the first property includes computing a weighted sum of the first student performance data.

36. The method of claim 34 wherein the process for determining an aggregate school score for at least the first property includes:

requesting, from the one or more first data stores, one or more first schools based on at least information associated with the geolocation;

requesting, from the one or more first data stores, second student performance data for the one or more first schools;

initializing the aggregate school score to a first predetermined constant;

determining, for each first attending school selected from the one or more attending schools, a partial aggregate score; and

adding the partial aggregate score weighted by a weighting constant to the aggregate school score;

wherein the process for determining, for each first attending school selected from the one or more attending schools, a partial aggregate score includes;

initializing the partial aggregate score to a second predetermined constant;

requesting, from the one or more first data stores, information associated with one or more second schools for each of the one or more first schools;

the one or more second schools including a second school;

requesting, from the one or more first data stores, third student performance data based on at least information associated with the second school;

processing the second student performance data and the third student performance data; and

adding a corresponding coefficient to the partial aggregate score if the second student performance data is greater than the third student performance data.

37. The method of claim 36 wherein the second predetermined constant is zero.

38. The method of claim 36 wherein the second predetermined constant is not zero.

39. The method of claim 30, and further comprising:

accessing a second property data source using a second interface;

requesting at least second property data corresponding to the first property from the second property data source;

processing a first property identifier based on information associated with the first property data and a second property identifier based on information associated with the second property data;

if the first property identifier and the second property identifier are the same, merging the second property data with the first property data; and

if the first property identifier and the second property identified are different, processing the first property data and the second property data and merging the second property data with the first property data if the first property and the second property are the same.

40. A method for searching for a school, the method comprising:

receiving, by a search interface, one or more school search parameters and one or more geographic search parameters, the one or more school search parameters including at least one or more student performance thresholds;

processing information associated with the one or more school search parameters and the one or more geographic search parameters;

accessing one or more data stores;

requesting, from the one or more data stores, at least student performance data for a school;

processing the student performance data and the one or more student performance thresholds;

requesting, from the one or more data stores, at least one or more attendance boundaries for the school;

processing the one or more attendance boundaries and the one or more geographic search parameters; and

generating a search result identifying at least data associated with the school if the one or more attendance boundaries satisfy the one or more geographic search parameters and the student performance data meets or exceeds the one or more student performance thresholds.

41. The method of claim 40 wherein the student performance data include one or more Academic Performance Index (API) scores.

42. The method of claim 40 wherein the student performance data include ranking data for the school.

43. The method of claim 40 wherein the student performance data includes one or more aggregate school scores.

44. The method of claim 40 wherein the process for processing the one or more attendance boundaries and the one or more geographic search parameters includes:

identifying a first region associated with the one or more attendance boundaries;

identifying a second region associated with the one or more geographic search parameters; and

processing the first region and the second region to determine if the first region and the second region share a third region at least as large as a predetermined threshold.

45. The method of claim 44 wherein the predetermined threshold is 50 square feet.

46. A method for searching for a property, the method comprising:

receiving, by a search interface, one or more school search parameters, one or more geographic search parameters, and one or more property search parameters, the one or more school search parameters including at least one or more student performance thresholds;

processing information associated with the one or more school search parameters, the one or more geographic parameters, and the one or more property search parameters;

accessing one or more data stores;

requesting, from the one or more data stores, at least student performance data for a school;

processing the student performance data and the one or more student performance thresholds;

requesting, from the one or more data stores, at least one or more attendance boundaries for the school;

requesting, from the one or more data stores, at least property location data and property characteristic data corresponding to a property, the property location data including an address corresponding to the property;

processing information associated with the property characteristic data and the one or more property search parameters;

processing information associated with the address and the one or more geographic search parameters;

processing information associated with the address and the one or more attendance boundaries; and

generating a search result identifying at least data associated with the property if the student performance data meets or exceeds the one or more student performance thresholds, the address satisfies the geographic search parameters'"'"' the address is within the one or more attendance boundaries, and the first property satisfies the one or more property search parameters.

47. The method of claim 46, and further comprising displaying the search result on a display screen.

48. The method of claim 47 wherein the process for displaying the search result includes:

displaying a map;

displaying at least a first icon representing the address of the property;

determining a location associated with the school; and

displaying at least a second icon representing the location of the school.

49. The method of claim 46, and further comprising:

determining a first area based on at least information associated with the one or more attendance boundaries;

determining a second area based on at least information associated with the geographic search parameters; and

processing the first area and the second area to determine if the first are and the second area overlap.

50. The method of claim 46, and further comprising:

determining an attendance area based on at least information associated with the one or more attendance boundaries;

determining a geolocation using information associated with at least the address; and

determining whether the geolocation is within the attendance area.

51. The method of claim 50, and further comprising:

requesting, from the one or more data stores, a bounding rectangle associated with the school; and

determining whether the geolocation is within the bounding rectangle.

52. The method of claim 46 wherein the student performance data include one or more Academic Performance Index (API) scores.

53. The method of claim 46 wherein the student performance data include ranking data for the school.

54. The method of claim 46 wherein the student performance data includes one or more aggregate school scores.

55. A method for searching for a property, the method comprising:

receiving, by a search interface, a target school and property search parameters;

processing information associated with the target school and the one or more property search parameters;

accessing one or more data stores;

requesting, from the one or more data stores, one or more attendance boundaries for the target school;

requesting, from the one or more data stores, at least property location data and property characteristic data corresponding to a property, the property location data including an address corresponding to the property;

processing information associated with the property characteristic data and the one or more property search parameters;

processing information associated with the address and the one or more attendance boundaries; and

generating a search result identifying at least data associated with the property if the address is within at least the one or more first attendance boundaries and the property satisfies the one or more property search parameters.

56. The method of claim 55, and further comprising:

determining a first area based on at least information associated with the one or more attendance boundaries;

determining a second area based on at least information associated with the geographic search parameters; and

processing the first area and the second area to determine if the first area and the second area overlap.

57. The method of claim 55, and further comprising:

determining an attendance area based on at least information associated with the one or more attendance boundaries;

determining a geolocation using information associated with at least the address; and

determining whether the geolocation is within the attendance area.

58. The method of claim 57, and further comprising:

requesting, from the one or more data stores, a bounding rectangle associated with the target school; and

determining whether the geolocation is within the bounding rectangle.

59. A method for searching for a property, the method comprising:

receiving, by a search interface, a first target school, a second target school, and property search parameters;

processing information associated with the first target school, the second target school, and the one or more property search parameters;

accessing one or more data stores;

requesting, from the one or more data stores, one or more first attendance boundaries for the first target school;

requesting, from the one or more data stores, one or more second attendance boundaries for the second target school;

requesting, from the one or more data stores, at least property location data and property characteristic data corresponding to a property, the property location data including an address corresponding to the property;

processing information associated with the property characteristic data and the one or more property search parameters;

processing information associated with the address and the one or more first attendance boundaries;

processing information associated with the address and the one or more second attendance boundaries; and

generating a search result identifying at least data associated with the property if the address is within the one or more first attendance boundaries, the address is within the one or more second attendance boundaries, and the first property satisfies the one or more property search parameters.

60. A method for identifying one or more school combinations, the method comprising:

receiving, by a search interface, a first school;

processing information associated with the first school;

accessing one or more data stores;

requesting, from the one or more data stores, one or more first attendance boundaries for the first school;

requesting, from the one or more data stores, one or more second attendance boundaries for at least a second school;

determining a first area based on at least information associated with the first attendance boundaries;

determining a second area based on at least information associated with the second attendance boundaries;

processing the first area and the second area;

identifying a school combination if the first area and the second area overlap; and

generating a search result identifying at least data associated with the school combination.

61. The method of claim 60, and further comprising:

requesting, from the one or more data stores, at least information associated with a third school of a first level;

requesting, from the one or more data stores, at least information associated with a fourth school of a second level;

requesting, from the one or more data stores, at least information associated with a fifth school of a third level;

requesting, from the one or more data stores, information associated with one or more third attendance boundaries associated with the third school;

requesting, from the one or more data stores, information associated with one or more fourth attendance boundaries associated with the fourth school;

requesting, from the one or more data stores, information associated with one or more fifth attendance boundaries associated with the third school;

determining a third area based on information associated with the one or more third attendance boundaries;

determining a fourth area based on information associated with the one or more fourth attendance boundaries;

determining a fifth area based on information associated with the one or more fifth attendance boundaries; and

processing the third area, the fourth area, and the fifth area to determine if they share a sixth area at least as large as a predetermined threshold.

62. The method of claim 61 wherein the predetermined threshold is 50 square feet.

63. The method of claim 61 wherein the first school is selected from a group consisting of the third school, the fourth school, and the fifth school.

64. The method of claim 61, and further comprising:

requesting, from the one or more data stores, a school district associated with the first school;

wherein;

the third school is associated with the school district;

the fourth school is associated with the school district; and

the fifth school is associated with the school district.