rails c
# https://stackoverflow.com/questions/4316940/create-a-devise-user-from-ruby-console
Admin.create!(email: "[email protected]", name: "First Last", password: "T0pSecr3t", password_confirmation: "T0pSecr3t")
exit

class AddExtensions < ActiveRecord::Migration[5.2]
  def change
    enable_extension :citext
    # enable_extension :postgis
  end
end

# update tree_plot db migration to be:
class CreateTreePlots < ActiveRecord::Migration[5.2]
  def change
    create_table :tree_plots do |t|
      t.string :plot_name,    null: false
      t.citext :plot_code,    null: false
      t.integer :elevation_m, null: false
      t.decimal :latitude,    precision: 12, scale: 8, null: false
      t.decimal :longitude,   precision: 12, scale: 8, null: false

      t.timestamps
    end
    add_index :tree_plots, :plot_code, unique: true
    add_index :tree_plots, [:latitude, :longitude]
  end
end

require 'csv'
csv_plot_data = File.read(Rails.root.join('db', 'data', 'LETS_Tree_Plots.csv'))
csv_plot = CSV.parse(csv_plot_data, :headers => true, :encoding => 'ISO-8859-1')
csv_plot.each do |row|
  plot = TreePlot.new
  plot.plot_name   = row['plot']
  plot.plot_code   = row['plot']
  plot.elevation_m = row['elevation_m']
  plot.latitude    = row['latitude']
  plot.longitude   = row['longitude']
  if plot.save
    puts "SAVED: #{plot.inspect}"
  else
    puts "ERROR: #{plot.inspect}, #{plot.error.messages}"
  end
end
puts "There are now #{TreePlot.count} plots"
# to leave type
exit

# adjust migration (add index)
class CreateTreeSpecies < ActiveRecord::Migration[5.2]
  def change
    create_table :tree_species do |t|
      t.string :species_name, null: false
      t.citext :species_code, null: false
      t.citext :foilage_strategy
      t.citext :foilage_type
      t.citext :taxonomy

      t.timestamps
    end
    add_index :tree_species, :species_code, unique: true
  end
end

# copy into the console
require 'csv'
csv_species_data = File.read(Rails.root.join('db', 'data', 'LETS_Tree_Species.csv'))
csv_species = CSV.parse(csv_species_data, :headers => true, :encoding => 'ISO-8859-1')
csv_species.each do |row|
  species = TreeSpecy.new
  species.species_name     = row['species_code']
  species.species_code     = row['species_code'].downcase
  case row['foilage_strategy'].downcase
  when 'deciduous'
    # species.taxonomy        = ''
    species.foilage_type     = 'broad leaf'
    species.foilage_strategy = 'deciduous'
  when 'conifer'
    species.taxonomy        = 'cone'
    species.foilage_type     = 'needle'
    species.foilage_strategy = 'evergreen'
  else
    species.taxonomy        = 'unknown'
    species.foilage_type     = 'unknown'
    species.foilage_strategy = 'unknown'
  end
  if species.save
    puts "SAVED: #{species.inspect}"
  else
    puts "ERROR: #{species.inspect}\n\t#{species.error.messages}"
  end
end
puts "There are now #{TreeSpecy.count} tree species"
exit

class CreateTreeMeasurements < ActiveRecord::Migration[5.2]
  def change
    create_table :tree_measurements do |t|
      t.integer  :circumfrence_cm
      t.date     :measurement_date, null: false
      t.citext   :subquadrat
      t.integer  :tree_label
      t.references :tree_specy, foreign_key: true
      t.references :tree_plot,  foreign_key: true

      t.timestamps
    end
    add_index :tree_measurements, :circumfrence_cm
    add_index :tree_measurements, :measurement_date
    add_index :tree_measurements, [ :tree_specy_id, :tree_plot_id,
                                    :subquadrat, :tree_label,
                                    :measurement_date ],
                                  unique: true,
                                  name: 'unique_tree_entries'
  end
end

require 'csv'
csv_tree_data = File.read( Rails.root.join('db', 'data', 'LETS_Tree_Measurements.csv') )
csv_tree = CSV.parse(csv_tree_data, headers: true, encoding: 'ISO-8859-1')
csv_tree.each do |row|
  tree = TreeMeasurement.new
  tree.subquadrat       = row['subquadrat']
  tree.tree_label       = row['tree_label']
  tree.circumfrence_cm  = row['circumfrence_cm']
  tree.measurement_date = Date.strptime(row['date'].to_s, '%m/%d/%Y')
  tree.tree_specy_id    = TreeSpecy.find_by(species_code: row['species_code']).id
  tree.tree_plot_id     = TreePlot.find_by(plot_code: row['plot']).id
  if tree.save
    puts "Saved"
    # puts "SAVED: #{tree.inspect}"
  else
    puts "ERROR"
    # puts "ERROR: #{tree.inspect}\n\t#{tree.error.messages}"
  end
end
puts "There are now #{TreeMeasurement.count} tree measurements"
exit

# pre-load related data
def index
  @tree_measurements = TreeMeasurement.includes(:tree_plot).
                                        includes(:tree_specy).all
end

# app/models/tree_measurement.rb
require 'csv'

class TreeMeasurement < ApplicationRecord
  belongs_to :tree_specy
  belongs_to :tree_plot

  def tree_plot_code
    tree_plot.plot_code
  end
  def tree_species_code
    tree_specy.species_code
  end
  def tree_foilage_strategy
    tree_specy.foilage_strategy
  end
  def tree_elevation_m
    tree_plot.elevation_m
  end
  def tree_latitude
    tree_plot.latitude
  end
  def tree_longitude
    tree_plot.longitude
  end
  def self.to_csv( options={headers: true} )
    attributes = %w{  tree_plot_code tree_species_code tree_foilage_strategy
                      subquadrat tree_label circumfrence_cm
                      tree_elevation_m tree_latitude tree_longitude
                      measurement_date }
    CSV.generate(options) do |csv|
      csv << attributes
      all.each do |tree|
        csv << attributes.map{ |attr| tree.send(attr) }
      end
    end
  end
end

# app/controllers/tree_measurements_controller.rb
def index
  @tree_measurements = TreeMeasurement.includes(:tree_plot).
                                        includes(:tree_specy).all
  respond_to do |format|
    format.html
    format.json
    format.csv { send_data @tree_measurements.to_csv,
                      filename: "lets_tree_measurements-#{Date.today}.csv" }
  end
end

# Gemfile
gem 'devise'

# apps/controllers/application_controller.rb
class ApplicationController < ActionController::Base
  protect_from_forgery with: :exception
  before_action :authenticate_admin!
end

# apps/controllers/tree_measurements_controller.rb
class TreeMeasurementsController < ApplicationController
  before_action :authenticate_admin!, except: [:index]

rails c
# https://stackoverflow.com/questions/4316940/create-a-devise-user-from-ruby-console
Admin.create!(email: "[email protected]", name: "First Last", password: "T0pSecr3t", password_confirmation: "T0pSecr3t")
exit