Paul Milstein Center for Real Estate
Columbia University's Graduate School of Business
Subprime Google Earth Maps
We provide Zip Code level maps describing the geographic distribution of Subprime mortgages. The Maps were created using the R Statistical Package, STATA© , and Shp2KML.
Viewing Instructions
1. Download the freely available Google Earth software from http://earth.google.com. This application will allow you to pan, orbit, and zoom to any point on the map.
2. Download a map file from the list below below:
- AveragePercentofHousingUnitswithSubp.kmz This map displays the average pecent of housing units within zip codes that have a subprime loans. Only zip codes in the largest 108 US Metropolitan Statistical Areas (MSAs) are displayed.
- PercentofHousingUnitsinForeclosureor.kmz This map displays the percent of housing units within zip codes that have loans that are in foreclosure or are 90+ days delinquent. Only zip codes in New York state, and within the MSAs within New York state, are displayed.
- PercentofHousingUnitstoResetwithinth.kmz This map displays the percent of housing units within zip codes that have loans that are set to reset in the next year. Only zip codes in New York state, and within the MSAs within New York state, are displayed.
3. Once downloaded, open the map file in Google Earth by selecting “file > open” from the menu bar and then selecting the downloaded file.
NOTE: Some of the Map files are very large, it may take a minute or two for the maps to load. Please be patient.
- LoanPerformance: Subprime counts
- Geolytics 2000 U.S. Census: Housing Units
- U.S. Census: ZCTA Shape Files
Snapshots from the maps above (click to enlarge)
USA Percent Housing Units with Subprime Loans
Florida Percent Housing Units with Subprime Loans
Los Angeles and Las Vegas Percent Housing Units with Subprime Loans
North East Percent Housing Units with Subprime Loans
New York State Percent Housing Units with Subprime Loans
New York City Percent Housing Units with Subprime Loans
Manhattan Percent Housing Units with Subprime Loans
Buffalo-Rochester Percent Housing Units with Subprime Loans
Albany Percent Housing Units with Subprime Loans
New York State Percent Housing Units with Loans in Foreclosure or 90+ Delinquent
New York City Percent Housing Units with Loans in Foreclosure or 90+ Delinquent
Buffalo-Rochester Percent Housing Units with Loans in Foreclosure or 90+ Delinquent
Albany Percent Housing Units with Loans in Foreclosure or 90+ Delinquent
New York State Percent Housing Units with Loans to Reset within the Next Year
New York City Percent Housing Units with Loans to Reset within the Next Year
Buffalo-Rochester Percent Housing Units with Loans to Reset within the Next Year
Albany Percent Housing Units with Loans to Reset within the Next Year










