Saturday, October 26, 2019
ParkScore and ParkView
How does your community 'score' in terms of access to public parks? Have a look at ParkScore and ParkView (by The Trust For Public Land).
Thursday, October 24, 2019
Wednesday, October 23, 2019
City Streets
The direction of streets in cities can tell you a lot about its geography and history: Urban Street Network Orientation is a nice data viz of that.
MS Excel and Google Sheets on Steroids!
I admit: I use MS Excel a lot and I'm still amazed how much more there is 'under the hood' in terms of functions, analysis options, and charting tricks - here are a few good ones I came across recently:
- An Empty Bar (Ann K. Emery)
- Removing the Double Y Axis (Ann K. Emery)
- VLookup (Ann K. Emery)
- From Data to Charts in 5 minutes (Ann K. Emery)
- Excel Elbow Grease (great tricks by Ann K. Emery)
- Muted Grid Lines and Area Charts (Ann K. Emery)
- Number Formatting / Conditional Formatting (Ann K. Emery)
- Formatting Months, Days, and Years in Excel (Ann K. Emery)
- Label Axis and/or Data? (Ann K. Emery)
- Formatting Names (Ann K. Emery)
- Sorting and Filtering your Spreadsheets (Ann K. Emery)
- Place Labels Directly On Line Graph (Ann K. Emery)
- Custom Color Codes in Excel (Anne K. Emery)
- Categorize values with =IF() and =VLOOKUP() (Ann K. Emery)
- How to Use Vlookup in MS Excel (Anne K. Emery)
- How to match data with VLOOKUP in Excel & Google Sheets (Lisa Charlotte Muth)
- Sparklines and Data Bars (Ann K. Emery)
- Add Dotted Lines to Line Graphs (Ann K. Emery)
- Direct Labeling in Excel (Stephanie Evergreen)
- Make a Pictogram in Excel (Stephanie Evergreen)
- Fast Small Multiple Graphs (Stephanie Evergreen)
- Easy Dot Plots in MS Excel (Stephanie Evergreen)
- Dumbbell Dot Plots in MS Excel I (Stephanie Evergreen)
- Dumbbell Dot Plots in MS Excel II (Stephanie Evergreen)
- Dumbbell Dot Plots Way Easier (Stephanie Evergreen)
- Make a Slopegraph in Excel (Stephanie Evergreen)
- How to make a scatter plot in Excel (Storytelling with Data)
- Adding a Benchmark Line (Stephanie Evergreen)
- Customizing Colors (Stephanie Evergreen)
- Showing Standard Deviation (Stephanie Evergreen)
- Confidence Intervals to Dot Plots (Stephanie Evergreen)
- Margin of Error in Excel with “Slider Plots” (Andrew Forsman)
- Directly Labeling Excel Charts (Jonathan Schwabish)
- Edit a ledgend in Excel (Storytelling with Data)
- Swimmer Plots (Jon Peltier)
- Pivot Tables (Jon Peltier)
- Interactive data dashboards (Ben Collins)
- Supercategory axis labels (Cole Nussbaumer Knaflic)
- Plotting value within range (Cole Nussbaumer Knaflic)
- Embedding a vertical reference line in Excel (Elizabeth Ricks)
- How to do it in Excel: a shaded range (Elizabeth Ricks)
- How to do it in Excel: adding data labels (Elizabeth Ricks)
- Data prep for MS Excel / Google Sheets (Chartable)
- Extract Text from Data Columns (Chartable)
- Create a dot plot (Storytelling with Data)
- Save As Template (Stephanie Evergreen)
Tuesday, October 22, 2019
Mer de Glace: 1919 to 2019
More details here: Misusing the Georeference Tool for Historic Image Alignment
 |
| https://www.esri.com/arcgis-blog/products/arcgis-pro/mapping/misusing-the-georeference-tool-for-historic-image-alignment/ |
Friday, October 18, 2019
Atmosphere, Oceans, and Continents
The EarthWindMap (https://earth.nullschool.net/) is awesome, especially the ability to visualize different atmospheric levels and weather variables. Now we have KCM-earth to compare ocean and wind currents between today and the Early Cretaceous.
Tuesday, October 15, 2019
1-Minute Map Hacks
John Nelson put together a series of quick videos called 1-Minute Map Hacks with some neat tips and tricks. My favs: 1) How to Fix Overly-Busy Coastlines, 2) How to Tweak a Projection, and 3) Georeference Images.
Saturday, October 12, 2019
How years compare with the 20th Century average
I really like this animated chart: How years compare with the 20th Century average. It would be great as a Youtube video or animated GIF.
Thursday, October 10, 2019
Remote Pixel
Remote Pixel lets you view Landsat and Sentinel-2 images, perform basic analysis, and download the raw tif files. All that in a simple interface!
Wednesday, October 9, 2019
Mapping Photographs
This is nothing new, but here are a few nice examples:
Here's the How-To from Maps Mania.