Apartment Blog

News and Updates from MyApartmentMap

New Rental Data Tool

MyApartmentMap - Sep 23, 2009

Yesterday we released a new Rental Data tool on MyApartmentMap. You can use this tool to find the average rents in almost any area. You simply go to the city your interested in, for example you might want to see New York City Rental Statistics, and drag the marker around to see the minimum, maximum and average rents in that area. If your interested in some of the technology we used to create this tool. The backend uses MySQL with spatial extensions turned on. We store the latitude and longitude and then create a spatial index on these points. Without using spacial extensions doing radius searches with floating point longitude and latitudes would be impossible. In testing, I found that it could take 4-5 seconds per query whith a large database. The charts are all done with the Google Chart Api. I found this API to be great and really easy to use. I was amazed at the level of customization that could be had with merely passing url parameters. The backend is written all in Python and uses the GeoPy library. I find python is really great for quickly coding backend processes. Please don’t hesitate to contact me if you have any technical questions that I could help with.