Maps!

I am a member of CoreNet Global, specifically the Northern California Chapter.  It is the world’s leading professional association for corporate real estate (CRE) and workplace executives.  I like Corenet because their membership consists of high level CRE people and companies as well as Service Providers like architects and other consultants.  The Northern California Chapter is one of the largest chapters in the world.

CoreNet is really good about sending out real estate reports and market indicator reports to their members on a regular basis.  These reports are sometimes available other places on the web and sometimes not, but either way, they do a great job of aggregating important information on the real estate market and distributing that to their members.

With the latest data deluge, I decided to play around with mapping some of the data using a website called GeoCommons.  GeoCput ommons make it easy to put data onto a map.  For instance, Colliers International releases reports on office vacancy every quarter.  They include a table of data for 50 or markets showing various metrics such as vacancy rates, square footage under construction, etc.  I took this table of data and put it into GeoCommons.  I had to fumble around with pdf (I found a way to copy tabular data out of a pdf), Excel and another website called batchgeocode.com (I used this to take the cities provided in the report and obtain a lat/long value for each, since GeoCommons requires a lat and long).

The final result is below.  Pretty cool, eh?  I only put one layer of data in this map.  I could have added any of the metrics found in the report, but it got messy quick with lots of transparent bubbles and such.  You can still see those other metrics when you click on the cities.