Skip to content

Instantly share code, notes, and snippets.

View dlebauer's full-sized avatar
😀

David LeBauer dlebauer

😀
View GitHub Profile
@dlebauer
dlebauer / all_s4_6_traits.sql
Last active May 4, 2022 16:07
two approaches to retrieving canopy height + canopy cover data
\copy (select raw_date, sitename, cultivar, trait, method, mean
from traits_and_yields_view_private
sitename like '%Season 4%' and sitename ~ 'Range (20|30)$')
to ~/season4traits.csv delimiter ',' csv header;
\copy (select raw_date, sitename, cultivar, trait, method, mean
from traits_and_yields_view_private
sitename like '%Season 6%' and sitename ~ 'Range (20|30)$')
to ~/season6traits.csv delimiter ',' csv header;
@dlebauer
dlebauer / latex_demo.tex
Created November 2, 2011 19:58
A demonstration file for use with testing / debugging latex documents. Uses lipsum for demo text and [demo] option to the graphicx package
\documentclass{article}
\usepackage{caption}% http://ctan.org/pkg/caption
\usepackage{lipsum}% http://ctan.org/pkg/lipsum
\usepackage[demo]{graphicx}% http://ctan.org/pkg/graphicx
\begin{document}
\tableofcontents
\section{First section}
\lipsum[1]
\begin{figure}[p]
\centering \includegraphics{image1}