Tag: map

Locations for 75000 dams

The last task I performed for AQUASTAT was to try to find the best way to estimate the anthropogenic¬†evaporation from dams. There will be a paper coming out soon, but in the meantime, I provide one of the fun outputs, a map of 75000 dams! ok okok… it’s not REALLY 75000 dams, this is an duplicate-containing amalgam of: AQUASTAT dams… Read more →

Excel is how I do maps…

Following the footsteps of this cool post I saw by¬†JohnNelsonIDV, I wanted to try to and make a map using Excel. Fast forward 2 days and the opportunity came up. Lo and behold, a Map of Reference Evapotranspiration built in Excel! Instructions: Read data file into Excel (skip top rows with metadata), make sure to delimit correctly so that each… Read more →

kml maker for Excel -> Google Earth

I made a userform that quickly and easily allows you to make a kml file that’s readable by google earth based on some excel dataset that has coordinates. Features: Simple and advanced modes userform for convenience Icons change when highlighted Allows html to be passed to popup contents, everything is customizable Issue a default icon, and change icons for specific… Read more →

%d bloggers like this: