System and method for accessing geographic-based data

• US 7,174,301 B2
• Filed: 09/09/2003
• Issued: 02/06/2007
• Est. Priority Date: 10/23/2000
• Status: Expired due to Term

• Current Assignee: Costar Realty Information Incorporated (CoStar Group Inc.)
• Original Assignee: CoStar Group Inc.
• Inventors: Florance, Andrew C., Hofman, Deborah, Evatt, Robert, Choi, John
• Primary Examiner(s): ZEENDER, FLORIAN M
• Application Number:
  US10/657,275
• Publication Number:
  US 20040128215A1
• Time in Patent Office: 1,246 Days
• Field of Search: 705/26, 705/27, 705/1, 705/6, 705/28, 701/207, 342/350, 340/995.14
• US Class Current: 705/313
• CPC Class Codes: G06F 16/29 Geographical information databases
• CPC Class Codes: G06Q 10/025 Coordination of plural reservations, e.g. plural trip segments, transportation combined with accommodation
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions
• CPC Class Codes: G06Q 50/16 Real estate

Abstract

A system and method for creating a unified commercial real estate data model through collection, distribution and use of information in connection with commercial real estate and for creating a web-based marketplace that facilitates the efficient and secure buying, selling, and leasing of commercial properties. The invention provides a digital marketplace in which the members of the commercial real estate and related business community can continuously interact and facilitate transactions by efficiently exchanging accurate and standardized information. An embodiment provides a system and method for providing communication and analytical tools that interface with a commercial real estate database and support commercial real estate transactions between parties. These communication and analytical tools can include: 1) a survey tool; 2) a commercial real estate transaction tool; 3) a tour scheduling tool; 4) an activity summary tool; 5) a tool for analyzing commercial real estate data; and 6) a map search tool.

Claims

1. In a system comprising a real estate database containing information regarding commercial real estate properties, a method for disseminating information contained in the real estate database comprising:

receiving from a user a series of points on a map that define a polygonal search area;

bounding the polygonal search area in a box;

subdividing the box into latitude/longitude sub-boxes;

identifying the sub-boxes as one of inside, outside, and intersecting;

further subdividing the intersecting sub-boxes into further latitude/longitude sub-boxes and identifying the further sub-boxes as one of inside, outside, and intersecting, up to a predefined number of iterations, resulting in identified inside sub-boxes and remaining intersecting sub-boxes;

receiving search attributes from the user;

searching the real estate database for properties within the identified inside sub-boxes and the remaining intersecting sub-boxes that meet the search attributes; and

displaying, to the user on a screen, information about the properties within the identified inside sub-boxes and the remaining intersecting sub-boxes that meet the search attributes.

2. The method of claim 1, wherein the search attributes are specific to properties for lease.

3. The method of claim 1, wherein displaying comprises plotting an icon on the map a location corresponding to a property within the identified inside sub-boxes and the remaining intersecting sub-boxes that meets the search attributes.

4. The method of claim 3, further comprising displaying a photograph of the property when a mouse pointer is positioned over the icon.

5. The method of claim 1, wherein displaying comprises displaying a list of the properties within the identified inside sub-boxes and the remaining intersecting sub-boxes that meet the search attributes, wherein the list provides property descriptions, property addresses, and property prices.

6. The method of claim 1, wherein the polygonal search area is irregular.

7. The method of claim 1, wherein the map is an aerial photograph.

14. The method of claim 1, further comprising recombining the identified inside sub-boxes and the remaining intersecting sub-boxes.

15. The method of claim 14, the recombining comprising:

monitoring which iteration of subdividing and identifying produced each sub-box;

for each iteration starting with the most detailed iteration to the least detailed iteration,

combining, for each row within an iteration, any two sub-boxes that have matching edges and are identified the same as between inside and intersecting, and

combining, for each column within an iteration, any two sub-boxes that have matching edges and are identified the same as between inside and intersecting; and

repeating the combining until no more recombinations are found,

the searching comprising searching for properties within combined inside sub-boxes and combined intersecting sub-boxes.

16. The method of claim 1, further comprising filtering the properties within the intersecting sub-boxes using a point-in-polygon algorithm.

8. A method for retrieving geographic-based commercial real estate data comprising:

receiving a polygonal area drawn on a map;

converting the drawn area into pixels by bounding the drawn area in a box and subdividing the box into pixels;

converting the pixels into latitude and longitude coordinates;

calculating a spatial index based on the latitude and longitude coordinates by;

identifying the pixels as one of inside, outside, and intersecting; and

further subdividing the intersecting pixels into sub-pixels and in the sub-pixels as one of inside, outside, and intersecting, up to a predefined number of iterations, resulting in one or more of identified inside pixels, identified inside sub-pixels, and remaining intersecting sub-pixels;

searching the commercial real estate database for properties having latitude and longitude coordinates within the identified inside pixels, the identified inside sub-pixels, and the remaining intersecting sub-pixels; and

displaying, on a screen, the properties having latitude and longitude coordinates within the identified inside pixels, the identified inside sub-pixels, and the remaining intersecting sub-pixels.

9. The method of claim 8, wherein the pixels comprise multiple quadrangles.

10. The method of claim 8, wherein the pixels are converted into latitude and longitude coordinates by sending an XML message to a mapping application.

11. The method of claim 8, further comprising receiving additional search attributes, and wherein searching comprises searching the commercial real estate database for properties having latitude and longitude coordinates within the identified inside pixels, the identified inside sub-pixels, and the remaining intersecting sub-pixels and matching the search attributes.

12. The method of claim 11, wherein the search attributes are specific to properties for lease.

13. The method of claim 11, wherein the search attributes include price per building square foot, gross acres, and year built.

17. The method of claim 8, wherein calculating the spatial index further comprises recombining the identified inside pixels, the identified inside sub-pixels, and the remaining intersecting sub-pixels.

18. The method of claim 17, the recombining comprising:

monitoring which iteration of subdividing and identifying produced each pixel or sub-pixel;

for each iteration starting with the most detailed iteration to the least detailed iteration,

combining, for each row within an iteration, any two pixels or sub-pixels that have matching edges and are identified the same as between inside and intersecting, and

combining, for each column within an iteration, any two pixels or sub-pixels that have matching edges and are identified the same as between inside and intersecting; and

repeating the combining until no more recombinations are found,

the searching comprising searching for properties within combined inside pixels or sub-pixels and combined intersecting sub-pixels.

19. The method of claim 8, the spatial index comprising an XML document listing the identified inside pixels, the identified inside sub-pixels, and the remaining intersecting sub-pixels, and the method further comprising submitting the XML document to an SQL server to retrieve latitude and longitude coordinates of the identified inside pixels, the identified inside sub-pixels, and the remaining intersecting sub-pixels.

20. The method of claim 8, wherein calculating the spatial index further comprises ignoring the outside pixels and the outside sub-pixels.