darkblue-b

darkblue-b

<script type="text/vnd.graphviz" id="graphviz">
digraph G {
  "browser" ->
  "http_request" ->
  "server" ->
  "routes" ->
  "controller" ->
  "model" -> "controller"
  "controller" -> "response"

darkblue-b

#!/bin/sh

CITY="HOLLYWOOD_CA"

#34.10256/-118.36805

##  W,S,E,N  ?
##  (south,west,north,east) from the Overpass wiki page

##  BONN_DE

darkblue-b

darkblue-b

import psycopg2
import random

conn = psycopg2.connect( 'dbname=ta_test' )
curs = conn.cursor()

tSQL_create0 = '''
drop table if exists tta cascade;
create table tta ( tta_item integer, pkey serial);

darkblue-b

tSQL = '''
drop table if exists region_{0}_grid cascade;
create table region_{0}_grid as
select distinct on (g.gridcode) g.gridcode as gid, 
  st_transform( ST_GeometryN(g.the_geom,1), 4326)::geometry(Polygon,4326) as geom 
from grid150m_uniq g, 
  tl_2010_06_county10_3310 c, region_defs r
where st_intersects( g.the_geom, c.geom ) AND 
  c.countyfp10 = r.fips AND
  r.region_id = {0};

darkblue-b

#!/usr/bin/python
##===========================================================
## Import ACS 2012 1 year extension
##  GPLv3 Oct 2013  -dbb
##
##  Useage:  python import_master_20121yr_9.py Sequence_Number_and_Table_Number_Lookup.txt work_dir
##     assumes an existing database 'census_acs_2012'  ; currently writes to public schema 
##
##  Note: results in ~1480 tables plus 1478 more per state, so
##    max_locks_per_transaction must be manually increased

darkblue-b

#!/usr/bin/python
##===========================================================
## Import ACS 2012 1 year extension
##  GPLv3 Oct 2013  -dbb
##
##  Useage:  python import_master_20121yr_8.py Sequence_Number_and_Table_Number_Lookup.txt work_dir
##     assumes an existing database 'census_acs_2012'  ; currently writes to public schema 
##
##  Note: results in ~1480 tables plus 1478 more per state, so
##    max_locks_per_transaction must be manually increased

darkblue-b

import sys,re

# more hacks
#  remove the last two lines from the saved output
#  psql
#  > create database pkgs1;
#  > \c pkgs1
#  pkgs1=# create table raw_parse (script_name text, action text, pkg_name text);
#  pkgs1=# copy raw_parse from '/home/user/out1.csv' with CSV delimiter E'\t';
#  pkgs1=# select pkg_name from raw_parse group by pkg_name having every(action <> 'REMOVE') order by pkg_name;

darkblue-b