Sillson

Sillson

Sillson

-- Create the table
CREATE TABLE IF NOT EXISTS `StateBoundaries` (
  `State` varchar(10) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `MinLat` varchar(50) DEFAULT NULL,
  `MaxLat` varchar(50) DEFAULT NULL,
  `MinLon` varchar(50) DEFAULT NULL,
  `MaxLon` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Sillson

library(slippymath)
library(sf)
library(purrr)
library(curl)
library(glue)
library(raster)
library(rgdal)

# pass map.bounds() & zoom from leaflet
# xmin <- map.getBounds()["_southWest"]['lat']

Sillson

CREATE TEMPORARY FUNCTION capitalize(str STRING)
RETURNS STRING
LANGUAGE js AS """
  return str.replace(
      /\\w\\S*/g,
      function(txt) {
          return txt.charAt(0).toUpperCase() + txt.substr(1).toLowerCase();
      }
  );
""";

Sillson

Libraries for a modern geospatial workflow

Distribution

• Writing, Running, and Distributing
• Tox driven development
• Publishing python libraries

Numpy

Sillson

CREATE OR REPLACE FUNCTION jsonb_array_to_text_array(
  p_input jsonb
) RETURNS TEXT[] AS $BODY$

DECLARE v_output text[];

BEGIN

  SELECT array_agg(ary)::text[]
  INTO v_output

Sillson

BEGIN transaction;

DO $$DECLARE r record;
  BEGIN
    FOR r IN SELECT table_name,constraint_name
             FROM information_schema.constraint_table_usage
             WHERE table_name IN ('table_1', 'table_2', 'table_3') /* here be the tables to select. refactor if you want to select all */
             AND constraint_name ~'\d$' /* pattern matcher */
    LOOP
      EXECUTE 'ALTER TABLE ' || quote_ident(r.table_name)|| ' DROP CONSTRAINT '|| quote_ident(r.constraint_name) || ';';

Sillson

CREATE OR REPLACE VIEW public.active_locks AS 
 SELECT t.schemaname,
    t.relname,
    l.locktype,
    l.page,
    l.virtualtransaction,
    l.pid,
    l.mode,
    l.granted
   FROM pg_locks l

Sillson

## Boot chumps from your heroku free dynos 

## PS the app
heroku ps -a [APP]

## Find that one-off process, snag that pid
=== run: one-off processes (1)
run.4570 (Free): up 2016/03/03 10:01:16 -0800 (~ 8m ago): bin/rails console

## Tossed like a chump