Exploring Manhattan with Excel Power Map • ©[blogs.office.com]

New York is an iconic city with a rich history of innovation. I have a lot of family in New York and grew up visiting the city. Now that I’m living in Seattle, thousands of miles away, I don’t get to visit very often. However, I thought it might be fun to see if I could explore New York from the comfort of my desk using Excel. Through a little Internet searching, I discovered New York City’s “PLUTO” dataset. Created by the Department of City Planning, the PLUTO dataset includes information on every building in the city—more than 500,000 in total. I downloaded the dataset as CSV files and using Power Query for Excel, imported the data directly into Excel. I focused on the data file containing the borough of Manhattan as I’m most familiar with it. The dataset has a separate row for each building complex in the city and about 80 columns of information for each one.

via Exploring Manhattan with Excel Power Map – Office Blogs.

Tags: , ,

About plerudulier

Primarily interested in interacting and engaging with people about issues related to profession but also charity, environment, ... you get the idea.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Me & My SharePoint [FrontEnd]

© Christian Stahl - All about SharePoint branding & customizations

La Petite Espagne de la plaine saint denis

L'immigration espagnole à Saint-Denis / La emigración española a Francia

Valeurs de la culture

Carnet de recherches de Dominique Sagot-Duvauroux

Papilles en Balade

Dans ma cuisine, dans mes balades, en Bourgogne et ailleurs... Suivez mes papilles !

J'ai pris parti

A gauche toute!

dominik schachtsiek

My website more focussed on expertise - less opinionated as www.opinionated-alchemist.com

The Travelographer and Me

He does photos, I do words

Pensée positive, Un peu de sens ...

Positiver , nuancer, se decupler.

panta rei

les dits de la clepsydre

Pogoer 2.0: Wes Eichenwald's blog

Testing the limits of optimism against a bucketful of tragedy

a fresh drawing everyday

since october 2010, I´m posting a sketch per day

Le Comptoir

« Le comptoir d'un café est le parlement du peuple » Honoré de Balzac

Rapid Innovation in digital time

Accelerating Innovation in harmony

Bibliothèque de combat

Amassez des trésors dans le Ciel (Mt 6, 20)

Le coin lecture d'Arsène

La sélection du CDI décortiquée pour vous !

%d bloggers like this: