System and method for processing and display of geographical data

• US 6,732,120 B1
• Filed: 09/03/1998
• Issued: 05/04/2004
• Est. Priority Date: 09/03/1998
• Status: Expired due to Term

• Current Assignee: Amazon Technologies, Inc. (Amazon.com, Inc.)
• Original Assignee: Geojet Information Solutions Inc.
• Inventors: Du, Mike
• Primary Examiner(s): ROBINSON, GRETA LEE
• Application Number:
  US09/148,551
• Time in Patent Office: 2,070 Days
• Field of Search: 707/104, 707/526, 707/504, 707/517, 707/1, 707/2, 707/104.1, 345/112, 345/352, 345/226, 345/803, 345/968, 345/156, 345/163, 345/168, 340/990, 340/995.1, 340/995.19
• US Class Current: 715/764
• CPC Class Codes: G01C 21/20 Instruments for performing navigational calculations G01C21/24, G01C21/26 take precedence
• CPC Class Codes: G06F 16/29 Geographical information databases
• CPC Class Codes: G09B 29/10 Map spot or coordinate position indicators; Map reading aids optical projection apparatus per se G03B
• CPC Class Codes: Y10S 707/917 Text
• CPC Class Codes: Y10S 707/919 Geographic
• CPC Class Codes: Y10S 707/956 Hierarchical
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A display to display a visual representation of geographic information in a first portion of a display and text information in tabular format in a second portion of a display. The text information is subdivided into a group table and a member list table. The group table lists named groups in tabular form and members of the groups are listed in the member list table. Tabular information may include attachments which are capable of appearing as overlaid graphical representations on the geographic display. A method of coordinating the display of geographic graphical and tabular information provides hide/show capabilities for attachment graphics responsive to selection of tabular information. A method for modelling and storing geographic data is disclosed providing the steps of dividing the spatial extent defined by geographic data into uniquely identified cells, grouping geographic data by cells, and storing grouped geographic data into a long binary field of a database record in a relational database.

Claims

1. A computer based graphical system to display geographic information comprising:

(a) a first display area for presentation of graphical representations of geographic information;

(b) second display area for presentation of textual geographic information;

(c) user input means; and

(d) means responsive to said user input means to control the information presented by said first and second display areas.

2. The system of claim 1 wherein said user input means comprises a keyboard.

3. The system of claim 2 wherein said user input means further includes a mouse.

4. The system of claim 1 wherein said second display area comprises:

(a) a group display area to display textual descriptions of attributes of groups of geographic information; and

(b) a tab display area to display textual descriptions of occurrences in said groups of geographic information.

5. The system of claim 1 wherein said graphical representations of geographic information comprises:

(a) graphical representation of at least a portion of data defining a base map having a predefined spatial extent; and

(b) graphical representation of data corresponding to at least one map attachment.

6. The system of claim 5 wherein said user input means comprises a keyboard.

7. The system of claim 6 wherein said user input means further includes a mouse.

8. The system of claim 5 wherein said second display area comprises:

(a) a group display area to display textual descriptions of attributes of groups of geographic information; and

(b) a tab display area to display textual descriptions of occurrences in said groups of geographic information.

9. A method of operating a computer based graphical system for displaying geographic information comprising the steps of:

(a) displaying graphical representations of geographic information in a first display area;

(b) displaying of textual geographic information in a second display area; and

(c) responding to user input means to control the information presented in said first and second display areas.

10. The method of claim 9 wherein displaying textual geographic information further includes the steps of:

(a) displaying textual descriptions of attributes of groups of geographic information in said second display area; and

(b) displaying textual descriptions of occurrences in said groups of geographic information in a tab display area.

11. The method of claim 9 wherein displaying said graphical representations of geographic information further includes the steps of:

(a) displaying a graphical representation of at least a portion of data defining a base map having a predefined spatial extent; and

(b) displaying a graphical representation of data corresponding to at least one map attachment.

12. The method of claim 11 wherein displaying textual geographic information further includes the steps of:

(a) displaying textual descriptions of attributes of groups of geographic information in said second display area; and

(b) displaying textual descriptions of occurrences in said groups of geographic information in a tab display area.

13. A method for modelling and storing data in a relational database related to geographic data defining a spatial extent comprising the steps of:

(a) providing data defining each geographic object within a spatial extent;

(b) partitioning said spatial extent into cells using a partitioning strategy;

(c) generating a unique cell identification for each said cell;

(d) grouping said data defining each geographic object by said unique cell identification to form cell grouped geographic objects; and

(e) storing said cell grouped geographic objects in a database record corresponding to said unique cell identification.

14. The method of claim 13, wherein said data defining each geographic object of said cell grouped geographic objects is stored as a long binary field in said database record.

15. The method of claim 13, further including the steps of:

(a) providing a unique hierarchical level identification to define each of a plurality of hierarchical levels;

(b) grouping said data defining each geographic object by said unique hierarchical level identification and said unique cell identification to form hierarchical grouped geographic objects; and

(c) storing said hierarchical grouped geographic objects in a database record corresponding to said unique hierarchical level identification data and said unique cell identification.

16. The method of claim 15, wherein said data defining each geographic object of said hierarchical grouped geographic objects is stored as a long binary field in said database record.

17. The method of claim 13, further including the steps of:

(a) providing a unique non-spatial attribute for each of a plurality of non-spatial attributes;

(b) grouping said data defining each geographic object by said unique non-spatial attribute to form non-spatial attribute grouped geographic objects; and

(c) storing said non-spatial attribute grouped geographic objects in a database record corresponding to said unique non-spatial attribute.

18. The method of claim 17, wherein said data defining each geographic object of said non-spatial grouped geographic objects is stored as a long binary field in said database record.

19. A method for modelling and storing data defining attachments in a relational database related to geographic data defining a spatial extent comprising the steps of:

(a) providing unique attachment data to define each of a plurality of attachments;

(b) assigning a unique attachment identification code to each said unique attachment data;

(c) providing a unique category description to define each of a plurality of category descriptions;

(d) grouping each said unique attachment data at least one said unique category description to form category description grouped attachment data; and

(e) storing said category description grouped attachment data in a database record corresponding to said unique category description.

20. The method of claim 19, further including the step of including a text descriptor with each said unique attachment identification code.

21. A method for modelling and storing data defining attachments in a relational database related to geographic data defining a spatial extent comprising the steps of:

(a) providing unique attachment data to define each of a plurality of attachments;

(b) assigning a spatial index to each said unique attachment data to define the location of said unique attachment data within a spatial extent;

(c) providing a category description for each said unique attachment data;

(d) grouping said unique attachment data by said category description and said spatial index to form category grouped attachment data; and

(e) storing said category grouped attachment data in a database record corresponding to said category description.

22. The method of claim 21, further including the step of including a text descriptor with each said unique attachment data.