Zillow to PresCat mapping

[NealHumphrey]

We need a mapping to connect properties in the Preservation Catalog to Zillow data.

• [ ] Test JOIN the PresCat table(s) to the Zip Code-based rent data from zillow ( needs to occur after #14 ). Make sure that all PresCat properties can be connected to zip-code based rent data. If not, make a list of un-matched zip codes

• [ ] Create a mapping table or series of tables to connect the PresCat 'project' table to the zillow neighborhood level data. Their are multiple potential ways to do this, so try to find the easiest option. Try to get the most detailed level of data possible, but if it is significantly easier to use 'neighborhood cluster' that may provide a much faster option - make note of tradeoff in accuracy. While it may be easiest to do this manually, preference is for a code-based solution so that it can be updated.

Data sources:

• Zillow distributes their neighborhood shape files: http://www.zillow.com/howto/api/neighborhood-boundaries.htm
• PresCat 'property' table has Lat/Lon - can use GIS to find which neighborhood the property is in.
• DC distributes shape files of 'neighborhood clusters.' These are larger than the zillow neighborhoods. But, neighborhood cluster is already contained in the tabular data of the PresCat 'projects' table. Might be able to manually map Zillow neighborhood to Neighborhood Cluster with a one-to-many relationship (won't work if neighborhoods aren't fully contained w/in clusters, though). http://opendata.dc.gov/datasets/f6c703ebe2534fc3800609a07bad8f5b_17 .
• The PresCat 'Parcel' table has the Master Address Repository ID, which can be used with the MAR API to get relevant location info: http://octo.dc.gov/service/master-address-repository

[NealHumphrey]

Lots of related issues: #149 and #59 and #148 and #147

[NealHumphrey]

I'm marking this as 'Ready' but the description needs some updating to fit with current process. Contact me if you want to work on this. Core concept is we need to have a function that can be used as part of the Cleaners that we can pass it an address or a lat/lon and it will do geocoding of that address as compared to the Zillow shapefiles.