John Franco Saraceno OneGneissGuy

## .dockerfile
FROM python:3.8.5-slim-buster as base

LABEL maintainer="Your Name <Your@Name.com>" \
      version="1.0.0"

RUN apt-get update && apt-get install tzdata -y --no-install-recommends
ENV TZ="America/Los_Angeles"

ENV PIP_NO_CACHE_DIR=1
ENV PIP_DISABLE_PIP_VERSION_CHECK=1

## git_update.sh
#!/bin/sh
if [ $# != 2 ]; then
  echo "\nchris k's git update automater sh script. Edit to put a bunch of \`git add blah'"
  echo "lines in the body then evoke with the branch name and commit description\n"
  echo "Usage: $0 <branch_name> <\"Description of update\">\n"
  echo "	branch_name: the name of the git branch to be created"
  echo "	Description: Text for: git commit -m \"Description of update\""
  echo ""
  echo "Example:"
  BRANCH="core_override"

## description.md

      
              2 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                OneGneissGuy
                / description.md
            
            
              Created
              April 5, 2019 23:16
                — forked from mangecoeur/description.md
            
              
                Pandas PostgresSQL support for loading to DB using fast COPY FROM method
              
          
    This small subclass of the Pandas sqlalchemy-based SQL support for reading/storing tables uses the Postgres-specific "COPY FROM" method to insert large amounts of data to the database. It is much faster that using INSERT. To acheive this, the table is created in the normal way using sqlalchemy but no data is inserted. Instead the data is saved to a temporary CSV file (using Pandas' mature CSV support) then read back to Postgres using Psychopg2 support for COPY FROM STDIN.

  
## exif_gps.py
import exifread

# based on https://gist.github.com/erans/983821

def _get_if_exist(data, key):
    if key in data:
        return data[key]

    return None

## ds18b20-nodemcu-v1.0-esp8266-arduino-ide.cpp
//nodeMCU v1.0 (black) with Arduino IDE
//stream temperature data DS18B20 with 1wire on ESP8266 ESP12-E (nodeMCU v1.0)
//shin-ajaran.blogspot.com
//nodemcu pinout https://github.com/esp8266/Arduino/issues/584
#include <ESP8266WiFi.h>
#include <OneWire.h>
#include <DallasTemperature.h>

//Def
#define myPeriodic 15 //in sec | Thingspeak pub is 15sec

## lm35-to-thingspeak.lua
--- Config
SSID       = "YOUR_WIFI_NAME"
PASSWORD   = "YOUR_WIFI_PASSWORD"
TIMEOUT    = 30000000 -- 30s

--- Station modes
STAMODE = {
  STATION_IDLE             = 0,
  STATION_CONNECTING       = 1,
  STATION_WRONG_PASSWORD   = 2,

## MQTT_Temp_Hum_Baro_Sensor.ino
#include <ESP8266WiFi.h>
#include <Wire.h>
#include <PubSubClient.h>
#include <Adafruit_Sensor.h>
#include <Adafruit_BME280.h>

#define wifi_ssid "YOUR_WIFI_SSID"
#define wifi_password "YOUR_WIFI_PASSWORD"

#define mqtt_server "YOUR_MQTT_SERVER_HOST"

## buoyspectraplotter.py
import urllib.request as request
import json
import matplotlib.pyplot as plt
import matplotlib.colors as colors
import matplotlib.cm as cm
import numpy as np

class BuoySpectraPlotter:

    def __init__(self, buoy_station):

## useful_pandas_snippets.py
# List unique values in a DataFrame column
pd.unique(df.column_name.ravel())

# Convert Series datatype to numeric, getting rid of any non-numeric values
df['col'] = df['col'].astype(str).convert_objects(convert_numeric=True)

# Grab DataFrame rows where column has certain values
valuelist = ['value1', 'value2', 'value3']
df = df[df.column.isin(valuelist)]

## SM_data.py
# -*- coding: utf-8 -*-
"""
:DESCRIPTION:Code for managing soil moisture data
:REQUIRES:
:TODO:More error handling
:AUTHOR: John Franco Saraceno
:ORGANIZATION: U.S. Geological Survey, United States Department of Interior
:CONTACT: saraceno@usgs.gov
:VERSION: 1.0
Fri Jul 29 18:48:40 2016
	FROM python:3.8.5-slim-buster as base

	LABEL maintainer="Your Name <Your@Name.com>" \
	version="1.0.0"

	RUN apt-get update && apt-get install tzdata -y --no-install-recommends
	ENV TZ="America/Los_Angeles"

	ENV PIP_NO_CACHE_DIR=1
	ENV PIP_DISABLE_PIP_VERSION_CHECK=1
	#!/bin/sh
	if [ $# != 2 ]; then
	echo "\nchris k's git update automater sh script. Edit to put a bunch of \`git add blah'"
	echo "lines in the body then evoke with the branch name and commit description\n"
	echo "Usage: $0 <branch_name> <\"Description of update\">\n"
	echo " branch_name: the name of the git branch to be created"
	echo " Description: Text for: git commit -m \"Description of update\""
	echo ""
	echo "Example:"
	BRANCH="core_override"
	import exifread

	# based on https://gist.github.com/erans/983821

	def _get_if_exist(data, key):
	if key in data:
	return data[key]

	return None
	//nodeMCU v1.0 (black) with Arduino IDE
	//stream temperature data DS18B20 with 1wire on ESP8266 ESP12-E (nodeMCU v1.0)
	//shin-ajaran.blogspot.com
	//nodemcu pinout https://github.com/esp8266/Arduino/issues/584
	#include <ESP8266WiFi.h>
	#include <OneWire.h>
	#include <DallasTemperature.h>

	//Def
	#define myPeriodic 15 //in sec \| Thingspeak pub is 15sec
	--- Config
	SSID = "YOUR_WIFI_NAME"
	PASSWORD = "YOUR_WIFI_PASSWORD"
	TIMEOUT = 30000000 -- 30s

	--- Station modes
	STAMODE = {
	STATION_IDLE = 0,
	STATION_CONNECTING = 1,
	STATION_WRONG_PASSWORD = 2,
	#include <ESP8266WiFi.h>
	#include <Wire.h>
	#include <PubSubClient.h>
	#include <Adafruit_Sensor.h>
	#include <Adafruit_BME280.h>

	#define wifi_ssid "YOUR_WIFI_SSID"
	#define wifi_password "YOUR_WIFI_PASSWORD"

	#define mqtt_server "YOUR_MQTT_SERVER_HOST"
	import urllib.request as request
	import json
	import matplotlib.pyplot as plt
	import matplotlib.colors as colors
	import matplotlib.cm as cm
	import numpy as np

	class BuoySpectraPlotter:

	def __init__(self, buoy_station):
	# List unique values in a DataFrame column
	pd.unique(df.column_name.ravel())

	# Convert Series datatype to numeric, getting rid of any non-numeric values
	df['col'] = df['col'].astype(str).convert_objects(convert_numeric=True)

	# Grab DataFrame rows where column has certain values
	valuelist = ['value1', 'value2', 'value3']
	df = df[df.column.isin(valuelist)]
	# -- coding: utf-8 --
	"""
	:DESCRIPTION:Code for managing soil moisture data
	:REQUIRES:
	:TODO:More error handling
	:AUTHOR: John Franco Saraceno
	:ORGANIZATION: U.S. Geological Survey, United States Department of Interior
	:CONTACT: saraceno@usgs.gov
	:VERSION: 1.0
	Fri Jul 29 18:48:40 2016