davidheyman

Steps:
Set up EBS
21Created 1 TB EBS
	Created 64 Bit Amazon Linux AMI 2012.09 M1 Medium 3.7 gb ram, 2 ECUs

	Connect to ec2 instance via ssh
	chmod 400 IFS-KeyPair.pem
	ssh -v -i IFS-KeyPair.pem ec2-user@ec2-54-234-14-65.compute-1.amazonaws.com
	Note: Do not replace ec2-user with your user id. This is a AWS Amazon AMI requirement.

davidheyman

// Based on Glacier's example: http://docs.aws.amazon.com/AWSJavaScriptSDK/guide/examples.html#Amazon_Glacier__Multi-part_Upload
var fs = require('fs');
var AWS = require('aws-sdk');
AWS.config.loadFromPath('./aws-config.json');
var s3 = new AWS.S3();

// File
var fileName = '5.pdf';
var filePath = './' + fileName;
var fileKey = fileName;

davidheyman

INSERT INTO geo_header_sf1 (fileid, stusab, sumlev, geocomp, chariter, cifsn, logrecno, region, division, state, county, countycc, countysc, cousub, cousubcc, cousubsc, place, placecc, placesc, tract, blkgrp, block, iuc, concit, concitcc, concitsc, aianhh, aianhhfp, aianhhcc, aihhtli, aitsce, aits, aitscc, ttract, tblkgrp, anrc, anrccc, cbsa, cbsasc, metdiv, csa, necta, nectasc, nectadiv, cnecta, cbsapci, nectapci, ua, uasc, uatype, ur, cd, sldu, sldl, vtd, vtdi, reserve2, zcta5, submcd, submcdcc, sdelem, sdsec, sduni, arealand, areawatr, name, funcstat, gcuni, pop100, hu100, intptlat, intptlon, lsadc, partflag, reserve3, uga, statens, countyns, cousubns, placens, concitns, aianhhns, aitsns, anrcns, submcdns, cd113, cd114, cd115, sldu2, sldu3, sldu4, sldl2, sldl3, sldl4, aianhhsc, csasc, cnectasc, memi, nmemi, puma, reserved)
SELECT
trim(substring(data,1,6)) AS	fileid,
trim(substring(data,7,2)) AS	stusab,
trim(substring(data,9,3)) AS	sumlev,
trim(substring(data,12,2)) AS	geocomp,
trim(substring(data,14,3)) AS

davidheyman

Keybase proof

I hereby claim:

• I am davidheyman on github.
• I am davidheyman (https://keybase.io/davidheyman) on keybase.
• I have a public key whose fingerprint is E39B FE40 D15B 962B 189E 8C5C F0F2 DE54 5DED 409D

To claim this, I am signing this object:

davidheyman

sudo apt-get update
sudo apt-get upgrade

sudo apt-get install -y postgis postgresql-9.3-postgis-2.1 imagemagick

cd ~rails
git clone https://github.com/axismaps/cognita.git

cp ~rails/rails_project/config/database.yml ~rails/cognita/config/

davidheyman

# create transparency band
for f in *tif;
do
  gdal_translate -b 1 -ot Byte $f red.tif;
  gdal_translate -b 2 -ot Byte $f green.tif;
  gdal_translate -b 3 -ot Byte $f blue.tif;
  gdal_translate -a_nodata none $f no.tif;
  gdal_calc.py -A no.tif --outfile=mask.tif --calc="(A<=255)*255";
  gdal_merge.py -separate -o ../ToCompress/$f red.tif green.tif blue.tif mask.tif;
  sudo rm red.tif;

davidheyman

# Convert shp to topjson and simplify
mapshaper -i /Volumes/Storage/Box\ Sync/MapMaster\ data/World/Physical\ Environment/Vector/005_Water_Resources_Vulnerability/005_Water_Resources_Vulnerability.shp -simplify 5% -o data/world/005_water_resources.json format=topojson

# Load shapefiles in subdirectories into PostGIS
for f in *; do cd $f; for g in *.shp; do shp2pgsql -I -s 4326 $g `basename $g .shp` | psql -d mapmaster; cd ../; done; done

davidheyman

DROP VIEW IF EXISTS bivariate;
CREATE VIEW bivariate AS 
	SELECT gid, gdp, pop, aal_gdp, aal_pop, aal_gdp / gdp AS gdp_pct, aal_pop / pop AS pop_pct, geom
	FROM admin1
	INNER JOIN ( 
		SELECT aal AS aal_gdp, wb_adm1_co
		FROM flood
		WHERE analysis_sector = 'GDP' AND year = 2010 
	) AS fl ON admin1.adm1_code = fl.wb_adm1_co
	INNER JOIN (

davidheyman

"""Splits rasters into chunks and creates contours"""

import os
import argparse
import uuid
import re
from osgeo import gdal

def chunk():
    """Splits rasters into 5000 x 5000 chunks."""

davidheyman

from __future__ import print_function
import mercantile
import urllib
import time
import os


def download_tile(tileurl, tile, output_dir, pause=1):
    url = tileurl + '/{z}/{x}/{y}.png'.format(**tile.__dict__)
    local_path = url.replace(tileurl, output_dir)