Project Overview
The Company:
A leading US-based real estate information services firm
Industry:
Real Estate Intelligence and Analytics
Services:
Parcel Mapping
Business Needs
Parcel-mapped database with GIS-data and metadata from various countries existed in huge volumes. The client was looking to standardize its parcel information management, streamline the process of data upload on its website, and drive meaningful property analytics and intelligence.
The Challenges
- Latest, accurate, and verified information wasn’t available.
- There was a constant fluctuation in volumes of property data.
- Strong domain knowledge of the US property documents was a prerequisite.
- Datasets were highly unstructured with inconsistencies across the records.
Solutions and Results
Want to build perfect databases of parcel maps?
Speak to us today- The received property database was subjected to preliminary analysis to get insight into anomalies.
- Address and lender/borrower details were verified against authentic sources and duplicate data was removed.
- Zip codes were manually researched through USPS websites and appended to the database. Similarly property owner details were obtained through relevant sources using client credentials.
- Macro-based file indexing was implemented to standardize data and rectify discrepancies.
- Factors like county-based zip code formats, writing style were taken into consideration.
- Special tools streamlined the checking of predefined and standard formats for each entry in the voluminous database.
- Discovering deviation from standard format, the tools triggered alerts.
- Non-detected anomalous entries were addressed manually.
- Random entry verification was conducted by a senior QC expert, completing the QC process.
- Finally, indexed files were prepared for all counties, saved to a specified path and appended to the client’s database.
Business Impact
270K records monthly successfully processed
98% parcel mapping accuracy achieved
All milestones reached within deadlines
