Parcel data acquisition and processing

• US 7,890,509 B1
• Filed: 12/04/2007
• Issued: 02/15/2011
• Est. Priority Date: 12/05/2006
• Status: Active Grant

• Current Assignee: Corelogic Solutions LLC (CoreLogic Incorporated)
• Original Assignee: First American Real Estate Solutions LLC (CoreLogic Incorporated)
• Inventors: Yadavalli, Balakrishna M., Maltby, David R. II, Tagle, Hugo A., Pearcy, Brett T., Reynolds, Charles P., Karli, Matthew E., Clark, Michael J.
• Primary Examiner(s): Morrison; Jay A
• Application Number:
  US11/999,319
• Time in Patent Office: 1,169 Days
• Field of Search: 707/101
• US Class Current: 707/736
• CPC Class Codes: G06F 16/113 Details of archiving lifecycle management in storage systems G06F3/0649; backup systems G06F11/1446
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06F 16/29 Geographical information databases
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: G06Q 50/16 Real estate
• CPC Class Codes: G06Q 50/165 Land development

Abstract

In some embodiments, scripts may be used to perform parcel data acquisition, conversion, and clean-up/repair in an automated manner and/or through graphical user interfaces. The scripts may be used, for example, to repair geometries of new parcel data, convert multi-part parcel geometries to single part parcel geometries (explode), eliminate duplicate parcel geometries, append columns, create feature classes, and append feature classes. These scripts may be executed in a predetermined manner to increase efficiency. In some embodiments, different combinations of attributes may be appended to stored parcel data. In some embodiments, a tracking application may be used to track information about sources of data. In some embodiments, a tracking application may be used to track which system users are assigned to specific tasks (e.g., in a data acquisition project).

Claims

1. A method of incorporating parcel data into a database, comprising:

receiving parcel data from a first source, said parcel data including boundary coordinates;

converting the parcel data from the first source into a format for storage in a common format database;

receiving parcel data from a second source;

converting the parcel data from the second source into the format for storage in the common format database, including

determining spatial accuracy of the parcel data,

projecting the parcel data into a common projection,

rechecking spatial accuracy of the projected parcel data,

repairing geometries of the parcel data,

integrating the repaired parcel data,

formatting available attribute data for the parcel data,

appending the parcel data to a temporary feature class,

integrating the appended parcel data, and

repairing geometries of the second integrated parcel data;

storing the converted parcel data from the first source and the converted parcel data from the second source in the common format database;

removing, by a processor, redundant parcel data between the parcel data from the first and second source; and

retrieving parcel data from the common format database in response to a user request,

wherein storing the converted parcel data from the first source and the second source in the common format database includes

receiving an indication to add the converted parcel data from the first source and the second source to the common format database, and

loading the converted parcel data from the first source and the second source into the common format database using a spatial database interface.

2. A method of incorporating parcel data into a database, comprising:

receiving parcel data from a first source, said parcel data including boundary coordinates;

converting the parcel data from the first source into a format for storage in a common format database;

receiving parcel data from a second source;

converting the parcel data from the second source into the format for storage in the common format database, wherein converting the parcel data includes converting parcel data from a raster format into a vector format, including

determining spatial accuracy of the parcel data,

projecting the parcel data into a common projection,

rechecking spatial accuracy of the projected parcel data,

repairing geometries of the parcel data,

integrating the repaired parcel data,

formatting available attribute data for the parcel data,

appending the parcel data to a temporary feature class,

integrating the appended parcel data, and

repairing geometries of the second integrated parcel data;

storing the converted parcel data from the first source and the converted parcel data from the second source in the common format database;

removing, by a processor, redundant parcel data between the parcel data from the first and second source; and

retrieving parcel data from the common format database in response to a user request,

wherein the common format database includes a national parcel layer having parcel data from a plurality of sources.

3. A method of incorporating parcel data into a database, comprising:

receiving parcel data from a first source, said parcel data including boundary coordinates;

converting the parcel data from the first source into a format for storage in the common format database;

receiving parcel data from a second source;

converting the parcel data from the second source into the format for storage in the common format database, including determining spatial accuracy of the parcel data

rechecking spatial accuracy of the projected parcel data,

repairing geometries of the parcel data,

integrating the repaired parcel data,

appending the parcel data to a temporary feature class,

integrating the appended parcel data, and

repairing geometries of the second integrated parcel data;

wherein converting the parcel data includes converting parcel data from a raster format into a vector format and converting the parcel data from at least the first source or the second source into the format for storage in the common format database includes

projecting the parcel data into a common projection, and

formatting available attribute data for the parcel data;

storing the converted parcel data from the first source and the converted parcel data from the second source in the common format database;

removing, by a processor, redundant parcel data between the parcel data from the first and second source; and

retrieving parcel data from the common format database in response to a user request,

wherein the common format database includes a national parcel layer having the parcel data from a plurality of sources,

wherein storing the converted parcel data from the first source and the second source in the common format database includes

receiving an indication to add the converted parcel data from the first source and the second source to the common format database, and

loading the converted parcel data from the first source and the second source into the common format database using a spatial database interface.

4. A method of incorporating parcel data into a database, comprising:

receiving parcel data from a first source, said parcel data including boundary coordinates;

converting the parcel data from the first source into a format for storage in a common format database;

receiving parcel data from a second source;

converting the parcel data from the second source into the format for storage in the common format database;

storing the converted parcel data from the first source and the converted parcel data from the second source in the common format database;

removing, by a processor, redundant parcel data between the parcel data from the first and second source; and

retrieving parcel data from the common format database in response to a user request,

wherein converting the parcel data from at least the first source or the second source into the format for storage in the common format database includes

determining spatial accuracy of the parcel data,

projecting the parcel data into a common projection,

rechecking spatial accuracy of the projected parcel data,

repairing geometries of the parcel data,

integrating the repaired parcel data,

formatting available attribute data for the parcel data,

appending the parcel data to a temporary feature class,

integrating the appended parcel data, and

repairing geometries of the second integrated parcel data,

wherein storing the converted parcel data includes loading the converted parcel data into the common format database.

5. The method of claim 4, wherein converting the parcel data from at least the first source or the second source into the format for storage in the common format database further comprises:

integrating the parcel data that has been projected into the common projection; and

repairing geometries of the integrated parcel data.

6. The method of claim 4,

wherein converting the parcel data from the first source into a format for storage in the common format database includes automatically converting the parcel data from the first source into a format for storage in the common format database;

wherein converting the parcel data from the second source into the format for storage in the common format database includes automatically converting the parcel data from the second source into the format for storage in the common format database; and

wherein storing the converted parcel data from the first source and the converted parcel data from the second source in the common format database includes automatically storing the converted parcel data from the first source and the converted parcel data from the second source in the common format database.

7. The method of claim 6, wherein automatically converting parcel data from the first source and from the second source into the format for storage in the common format database includes executing at least two scripts in a predetermined order.

8. The method of claim 7, wherein a first script of the at least two scripts includes converting multi-part parcel geometries into single part parcel geometries in the parcel data and a second script of the at least two scripts includes eliminating duplicate geometries in the parcel data.

9. The method of claim 4, wherein the format includes at least one personal geodatabase format with at least one feature class.

10. The method of claim 4, wherein the parcel data from the first source and the parcel data from the second source include data points for at least one polygon defining a parcel.

11. The method of claim 4,

wherein converting the parcel data from at least the first source or the second source includes

converting multi-part parcel geometries into single part parcel geometries in the parcel data, and

eliminating duplicate geometries in the parcel data.

12. The method of claim 4, wherein the common format database includes a national parcel layer having parcel data from a plurality of sources.

13. The method of claim 4, further comprising generating a log file, wherein the log file includes at least one detail regarding an execution of the converting of the parcel data from the first source and the converting of the parcel data from the second source.

14. The method of claim 13, wherein the at least one detail includes an exception, an error, or a value outside established parameters.

15. The method of claim 4, further comprising:

receiving new parcel data;

storing data associated with the parcel data to persist through an update;

updating the parcel data from at least the first source or the second source with the new parcel data; and

maintaining storage of the data to persist through the update.

16. The method of claim 4,

wherein converting the parcel data from at least the first source or the second source into the format for storage in the common format database includes executing scripts in the following order:

determining spatial accuracy of the parcel data;

projecting the parcel data into a common projection;

rechecking spatial accuracy of the projected parcel data;

exploding the projected parcel data;

repairing geometries of the exploded parcel data;

integrating the repaired parcel data;

formatting and concatenating available attribute data for the parcel data;

eliminating duplicate geometries of the first integrated parcel data;

appending the parcel data with eliminated duplicated geometries to a temporary feature class;

integrating the appended parcel data;

repairing geometries of the second integrated parcel data; and

wherein storing the converted parcel data includes loading the converted parcel data into the common format database.

17. The method of claim 4, wherein converting parcel data from at least the first source or the second source into a format for storage in the common format database includes

counting voids in one or more parcels of the parcel data,

removing the parcel when a void count of a parcel of the one or more parcels is above a threshold, remove the parcel, and

keeping the parcel when a void count of a parcel of the one or more parcels is not above a threshold, keep the parcel.

18. The method of claim 4, wherein converting the parcel data from at least the first source or the second source includes converting parcel data from a raster format into a vector format.

19. The method of claim 4, wherein converting the parcel data from at least the first source or the second source includes repairing incorrect geometries in the parcel data.

20. The method of claim 4, wherein converting the parcel data from at least the first source or the second source includes converting multi-part parcel geometries into single part parcel geometries in the parcel data.

21. The method of claim 4, wherein converting the parcel data from at least the first source or the second source includes eliminating duplicate geometries in the parcel data.

22. The method of claim 4, wherein the converted parcel data in the common format database is used for navigation systems, online mapping, telematics, cell phone services, or risk assessment tasks.

23. The method of claim 4, wherein the parcel data from the first source is in a different format than the parcel data from the second source.

24. The method of claim 4, wherein receiving parcel data from at least the first source or the second source includes receiving at least one shape-file from the at least the first source or the second source.

25. The method of claim 4, further comprising storing the attribute data.

26. The method of claim 4, wherein converting the parcel data from at least the first source or the second source into the format for storage in the common format database further includes appending the attribute data to the parcel data.

27. The method of claim 4, wherein converting the parcel data from at least the first source or the second source into the format for storage in the common format database further includes manipulating the attribute data.

28. A system, comprising:

a processor;

a memory coupled to the processor and configured to store program instructions executable by the processor to;

receive parcel data from a first source, said parcel data including boundary coordinates;

convert the parcel data from the first source into a format for storage in a common format database;

receive parcel data from a second source;

convert the parcel data from the second source into the format for storage in the common format database, including

determining spatial accuracy of the parcel data,

projecting the parcel data into a common projection,

rechecking spatial accuracy of the projected parcel data,

repairing geometries of the parcel data,

integrating the repaired parcel data,

formatting available attribute data for the parcel data,

appending the parcel data to a temporary feature class,

integrating the appended parcel data, and

repairing geometries of the second integrated parcel data;

store the converted parcel data from the first source and the converted parcel data from the second source in the common format database;

remove redundant parcel data between the parcel data from the first and second source; and

retrieve parcel data from the common format database in response to a user request,

wherein converting the parcel data from at least the first source or the second source into the format for storage in the common format database includes

projecting the parcel data into a common projection, and

formatting available attribute data for the parcel data,

wherein storing the converted parcel data includes loading the converted parcel data into the common format database.

29. A non-transitory computer readable medium storing computer-readable instructions thereon that when executed by a computer cause the computer to perform a method comprising:

receiving parcel data from a first source, said parcel data including boundary coordinates;

converting the parcel data from the first source into a format for storage in a common format database;

receiving parcel data from a second source;

converting the parcel data from the second source into the format for storage in the common format database, including

determining spatial accuracy of the parcel data,

projecting the parcel data into a common projection,

rechecking spatial accuracy of the projected parcel data,

repairing geometries of the parcel data,

integrating the repaired parcel data,

formatting available attribute data for the parcel data,

appending the parcel data to a temporary feature class,

integrating the appended parcel data, and

repairing geometries of the second integrated parcel data;

storing the converted parcel data from the first source and the converted parcel data from the second source in the common format database;

removing redundant parcel data between the parcel data from the first and second source; and

retrieving parcel data from the common format database in response to a user request,

wherein converting the parcel data from at least the first source or the second source into the format for storage in the common format database includes

projecting the parcel data into a common projection, and

formatting available attribute data for the parcel data,

wherein storing the converted parcel data includes loading the converted parcel data into the common format database.