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.

 
Data Sources  
  1.     LoanPerformance: Subprime counts
  2.     Geolytics 2000 U.S. Census: Housing Units 
  3.     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  

 

 

Sign in  |  Recent Site Activity  |  Terms  |  Report Abuse  |  Print page  |  Powered by Google Sites