Update!

Midsummer update: Lots of things going on here in science world.  Mostly I’ve been working with PetroMod to create some basin history models of the Williston Basin, which is fun because I get to dig way into how PetroMod works and how different variables affect hydrocarbon generation and migration.

 

Formation tops to Petra, reshaped with R

To import formation tops to Petra, your input file needs to be set up as one row per well, one column per formation top, and each value being the depth measurement.  In the example below, I am trying to rough out the depths of formations in Wyoming using only the TD (total depth) and BOTFORM (formation at total depth).  Not the most precise method of building structural maps, but it will work on a large scale.

Input file has one row per well, columns api_full, TD, and BOTFORM (at least). 

Caution: I tried to run this on the full WY well dataset (111,000 rows) and R used all 36 GB of my RAM and then crashed.  It’s advisable to subset first.

#Read data in
wells<-read.csv(“Wyoming_allwells_headers.csv”);
#Simple sample
ws<-head(wells);
#Remember column names
names (ws);
#Required libraries
library(reshape);
 
#Example: reshape the sample, because the whole dataset is over 100,000 rows.
#Melt according to API and formation at TD
wsr<-melt(ws,c(“api_full”,”BOTFORM”),”TD”);
#Cast into a new data frame
wsc<-cast(wsr, api_full ~ BOTFORM);
 
Output will be one row per well, one column for each formation name in BOTFORM, and TD as the value.
 
I can add more information if there are questions.  Reshape steps are from http://stackoverflow.com/a/1533577/2152245.

Bored? Run a Spatial Analysis!

I’m not bored, so I won’t be today.  Someone could, however, look at the early success of the Great Rides Fargo bikeshare program and compare:

  • the footprint of the stations, according to population density versus Grand Forks (or the nearby city of your choice)
  • the footprint of the stations, according to how much area it would cover in Grand Forks (or the nearby city of your choice)

That might be enough to start thinking seriously about bikeshare in other areas.  Why not Grand Forks (another great hashtag)?  Why not Winnipeg?

Dealing with many “Mail Delivery Failed” addresses

When spammers sign up for your website, you get a lot of junk email addresses.  If you then institute a newsletter module, you may get several hundred “mail delivery failed” messages.  

In Apple mail, you can select all the individual messages and click “forward” to compile them into a single email.  (If you use conversations, first do View->Expand All Conversations in order to select individual messages.)  Then copy that, paste into http://eel.surf7.net.my/, and you’ll get a list of the email addresses that bounced, which you can then bulk unsubscribe.  This works for me with the Drupal Simplenews module.

How do we know what other people know? (rough cut)

…without talking to them, of course.  [Note: This has been sitting in my queue since September; I’m going to publish it as-is so it counts as “done.”]

  1. Papers (external)
  2. Reports (internal)
  3. Blogging

Blogging is like talking to them, but what’s the impetus to get a blogging (internal or external) program going?  The NSF problem: how do you know it will work (i.e., help everyone know what everyone else is good at) without doing it first?  Blogging as a fun part of work, not as a chore.

Purpose:

  • to help make skills more widely known in-house
  • internal development
  • internal culture
  • not aimed at promotion of organization

    • however, good bloggers are good ambassadors to the public and future partners
    • external blogging is useful to draw in experts from outside the organization
  • Good points: https://blogin.co/
  • More good points: http://en.wikipedia.org/wiki/Corporate_blog#Internal_blogs
     

Time commitments and return.

Personality of bloggers and readers–some people like to write, some like to read, some are a mix.  Some would rather just talk to you.

Do some searching on this, maybe case studies are out there?

This is not what I am talking about (internal blogging for an external blog).

http://humancapitalist.com/the-future-of-corporate-learning-must-include-the-internal-blog/
 

Light Pollution Resources

Mostly for my own edification.  I’ve been living in town for almost nine years, and the excess light is starting to get to me.  I can’t be the only one.  I will try to grow this resource as I read more.

Overview

  • http://en.wikipedia.org/wiki/Light_pollution
  • Ornamental LED lighting/LEDs vs. HPS http://www.universetoday.com/107372/leds-light-pollution-solution-or-night-sky-nemesis/
  • Brief slideshow http://www.slideshare.net/CarmenLucindaAustin/light-pollution-kinds-consequences-solutions

Why Reduce Light Pollution?

  • Biology http://ottawacitizen.com/news/local-news/bright-idea-new-ottawa-street-lights-will-cause-more-light-pollution-physicist
  • Biology http://e360.yale.edu/feature/bringing_back_the_night__a_fight_against_light_pollution/2681/
  • Astronomy http://cosmicmatters.keckobservatory.org/2006/dec/06dec_2.htm

Fixture Design Solutions

  • http://www.gizmag.com/led-streetlamp/27246/
  • http://en.wikipedia.org/wiki/Light_pollution#Improving_lighting_fixtures
  • http://www.powerhousegrowers.com/reducing-light-pollution-urban-cities/
  • Engineering aspects http://ecmweb.com/lighting-amp-control/latest-light-pollution

Behavioral/Policy Solutions

Philosophy