############################ MODEL TO OBS SCATTERPLOT ##############################
### AMET CODE: R_Scatterplot.r 
###
### This script is part of the AMET-AQ system.  This script creates a single model-to-obs
### scatterplot. This script will plot a single species for multiple  networks on a single
### plot.  Additionally, summary statistics are also included on the plot. The script will
### also allow a second run to plotted on top of the first run. Output format is png, pdf
### or both.
###
### Last Updated by Wyat Appel: June, 2019
#####################################################################################
Loading required package: RMySQL
Loading required package: DBI
Loading required package: fields
Loading required package: spam
Loading required package: dotCall64
Loading required package: grid
Spam version 2.5-1 (2019-12-12) is loaded.
Type 'help( Spam)' or 'demo( spam)' for a short introduction 
and overview of this package.
Help for individual functions is also obtained by adding the
suffix '.spam' to the function name, e.g. 'help( chol.spam)'.

Attaching package: ‘spam’

The following objects are masked from ‘package:base’:

    backsolve, forwardsolve

Loading required package: maps
See https://github.com/NCAR/Fields for
 an extensive vignette, other supplements and source code 
Warning message:
In FUN(X[[i]], ...) :
  failed to assign RegisteredNativeSymbol for toeplitz to toeplitz since toeplitz is already defined in the ‘spam’ namespace
[1] "SELECT d.network,d.stat_id,s.lat,s.lon,d.ob_dates,d.ob_datee,d.ob_hour,d.month , d.PM_TOT_ob, d.PM_TOT_mod ,d.POCode,s.state from  PXM_LandUse_AQ  as d, site_metadata as s  WHERE d.PM_TOT_ob is not NULL and d.network='AQS_Hourly' and s.stat_id=d.stat_id and d.ob_dates BETWEEN 20100310 and 20100410 and d.ob_datee BETWEEN 20100310 and 20100410 and ob_hour between 0 and 23  ORDER BY stat_id,ob_dates,ob_hour"
Error in .local(conn, statement, ...) : 
  could not run statement: Unknown column 'd.PM_TOT_ob' in 'field list'
Calls: query_dbase ... db_Query -> dbSendQuery -> dbSendQuery -> .local -> .Call
Execution halted