Understanding the long term trend with data

Hi All,

It would be great to have actual rates from various projects recorded over a period of time. This will help us to understand the trend of real estate prices.
The trend should be derived from data gathered from guys like us "on the street", not from some biased reports of property consultants.

The idea is that we can have a database-on-the-web to capture real estate rates.

With a few hours effort, I created a google spreadsheet to record the rates over time from a single project in Kothrud, Pune. The pricelists have been grabbed from the builder's website from March 2009 to June 2009.
The latest pricelist can be viewed here:
http://www.pethkarprojects.com/samrajya/availability.pdf

The spreadsheet can be viewed here:
http://spreadsheets.google.com/ccc?key=rmv0n4AJNHEfU_5RRg1I_bQ

Creating a chart, we can see that the rate is the same for the past 4 months!! Compare this with the boom period when rates used to increase every month. Definitely, real estate in Kothrud, Pune has flattened out.

The google spreadsheet is not appropriate for large amounts of data which can start pouring in from various cities, so I have also created a mysql database with multiple tables.

How to gather the data?
1. Quoted by builders - this can be done by gathering pricelists of the projects at exhibitions, or from the website of the builder.
From the pricelist, we need to calculate the carpet area (excluding terraces, balconies, and other non FSI related areas) and the total cost to the buyer (including stamp duty, registration, one time maintanenance etc i.e. everything).
The carpet area, total cost and date can be entered into the database.
Entering pricelists into the database will have to be done by moderators.

2. Posted anonymously by real buyers:
Anyone who has purchased a property can anonymously post the carpet area, total cost and date. The anonymous user is not allowed to enter data directly into the database, he can post in this blog and a few moderators like us who have write permission to the database will enter his post.
What if someone posts a misleading rate? I believe 1o people can lie, but 1000 people will not lie. When we have hundreds and thousands of unique users posting rates, the misleading posts become statistically insignificant. This is the same principle on which www.carwale.com operates.
Also a restriction is that a user can post only the rate for a property he has actually bought, so we can restrict posts to 1 post each month per email id.
People can also post links to builder's websites which have published pricelists.

There can be a discussion on how to allow anonymous posts.

We can have admin / moderators for each city, like I and someone else can do for Pune.

I can help with the perl code, sql and database, domain name, hosting, but I aint no website designer. Maybe we can form a team to collaborate on the website?