Skip to content

Instantly share code, notes, and snippets.

@dlebauer

dlebauer/example_search_result.csv

Created April 11, 2014 05:46
Show Gist options
  • Save dlebauer/10442773 to your computer and use it in GitHub Desktop.
Save dlebauer/10442773 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
example_search_result.csv
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 1 column, instead of 2 in line 2.
"# David LeBauer, Dan Wang, and Michael Dietze, 2010. Biofuel Ecophysiological Traits and Yields Database Version 1.0. Energy Biosciences Institute, Urbana, IL"
#
# Contact:,[email protected]
#
# SQL query:,"SELECT ""traits_and_yields_view"".* FROM ""traits_and_yields_view"" WHERE (access_level >= 4) AND ((LOWER(traits_and_yields_view.scientificname) LIKE '%switchgrass%' OR LOWER(traits_and_yields_view.commonname) LIKE '%switchgrass%' OR LOWER(traits_and_yields_view.trait) LIKE '%switchgrass%' OR LOWER(traits_and_yields_view.trait_description) LIKE '%switchgrass%' OR LOWER(traits_and_yields_view.city) LIKE '%switchgrass%' OR LOWER(traits_and_yields_view.sitename) LIKE '%switchgrass%'))"
#
# Date of query:,2014-04-11 00:42:35 -0500
#
sitename,city,lat,lon,scientificname,commonname,genus,author,citation_year,treatment,date,month,year,dateloc,trait,mean,units,n,statname,stat,notes
Grassland Soil & Water Research Laboratory,Temple,31.05,-97.35,Panicum virgatum,switchgrass,Panicum,Kiniry,1999,Switch1,1995-06-05 19:00:00 -0500,6.0,1995.0,5.0,leafN,0.850,percent,4,"",[missing],""
Grassland Soil & Water Research Laboratory,Temple,31.05,-97.35,Panicum virgatum,switchgrass,Panicum,Kiniry,1999,Switch1,1995-06-22 19:00:00 -0500,6.0,1995.0,5.0,leafN,0.830,percent,4,"",[missing],""
Grassland Soil & Water Research Laboratory,Temple,31.05,-97.35,Panicum virgatum,
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment