Commits

Branch selector

 master

User selector

All users

Datepicker

All time

Commit History

Commits on May 22, 2014

• Updated acs2011_5yr scripts to create sequences with geoid field and populate field on table load.

  leehach

  committed
  11328be

  Copy full SHA for 11328be

• sql_insert_into_tables now adds geoid value on table load. This approach is *much* faster than updating after load.

  leehach

  committed
  b1f9941

  Copy full SHA for b1f9941

• Corrected parameters for sql_update_geoid_storage_tables() in README

  leehach

  committed
  14e3428

  Copy full SHA for 14e3428

Commits on May 15, 2014

• Added single view which returns all tracts in MSAs with associated MSA code and name.

  leehach

  committed
  20d4b76

  Copy full SHA for 20d4b76

Commits on Dec 3, 2013

• Minor formatting changes to README.

  leehach

  committed
  a274ec2

  Copy full SHA for a274ec2

• Substantial edits to README. Cleaned up Overview, described new features and future plans.

  leehach

  committed
  5c93575

  Copy full SHA for 5c93575

• Scripts for spatial support

  leehach

  committed
  2c90329

  Copy full SHA for 2c90329

Commits on Nov 23, 2013

• Create geometry columns in geoheader table, update README

  leehach

  committed
  a6a18ca

  Copy full SHA for a6a18ca

• Add scripts to download TIGER/Line water features from Census and use them to clip Census tracts to shoreline.

  leehach

  committed
  8b33c0b

  Copy full SHA for 8b33c0b

Commits on Nov 19, 2013

• Minor addition to README.

  leehach

  committed
  624494f

  Copy full SHA for 624494f

• First commit adding PostGIS support. See README for details.

  leehach

  committed
  67647fa

  Copy full SHA for 67647fa

Commits on Nov 11, 2013

• Error in parameter list for DROP FUNCTION sql_update_geoid_storage_tables()

  leehach

  committed
  c71ecb7

  Copy full SHA for c71ecb7

• Added geoid field to all sequence (estimate and moe) tables. Geoid

  Show description for 4731936
  leehach

  committed
  4731936

  Copy full SHA for 4731936

• Added explicit field list to INSERT statement generated by sql_parse_tmp_geoheader(). Preparatory for adding geometry support, in which case implicit column ordering can no longer be assumed.

  leehach

  committed
  bf0d568

  Copy full SHA for bf0d568

• Added omnibus import function which creates staging tables, imports data, transfers data to final storage, and cleans up (drops) staging tables. Documentation added to README.

  leehach

  committed
  b5c7d05

  Copy full SHA for b5c7d05

• Merge branch 'import_log'

  leehach

  committed
  fbf6042

  Copy full SHA for fbf6042

• Stubbed comprehensive import/insert script, need to merge with master to use functions added there.

  leehach

  committed
  ffdd2a9

  Copy full SHA for ffdd2a9

Commits on Nov 10, 2013

• Minor formatting change to README.

  leehach

  committed
  c6f9ba3

  Copy full SHA for c6f9ba3

• Added optional parameters to sql_drop_import_tables() and sql_create_import_tables() to restrict drop/create by sequence or by estimate/MOE.

  leehach

  committed
  301c23f

  Copy full SHA for 301c23f

• Added import_log table and sql_populate_import_log() function to keep track of files successfully imported.

  leehach

  committed
  b682684

  Copy full SHA for b682684

• Updated meta-script README.

  leehach

  committed
  65ccbfa

  Copy full SHA for 65ccbfa

• Added several maintenance functions to DROP, TRUNCATE, or set autovaccum on sequence storage tables.

  leehach

  committed
  99f3a45

  Copy full SHA for 99f3a45

• Added explict column list to INSERTs in preparation for adding geometry columns (which would screw up implicit column list since raw Census files lack geometry).

  leehach

  committed
  4b4a0ed

  Copy full SHA for 4b4a0ed

Commits on Nov 9, 2013

• Fixed determination of first field in sequence to account for acs2012_1yr not beginning at seq_position=1 for some sequences (?).

  leehach

  committed
  1d95476

  Copy full SHA for 1d95476

• Use UNLOGGED staging tables for Postgres>=9.1. Fixed determination of first field in sequence to account for acs2012_1yr not beginning at seq_position=1 for some sequences (?).

  leehach

  committed
  8c9c332

  Copy full SHA for 8c9c332

• All SQL-creating functions in meta-scripts no longer return (sometimes lengthy) SQL statement if exec=TRUE. SQL statement only returned if exec=FALSE.

  leehach

  committed
  2d133ae

  Copy full SHA for 2d133ae

• Added data dictionary of ACS 2012 1-year, will allow meta-script import.

  leehach

  committed
  1a3051c

  Copy full SHA for 1a3051c

• Minor changes to experimental (array and hstore) storage methods

  leehach

  committed
  9cd786c

  Copy full SHA for 9cd786c

Commits on Apr 2, 2013

• Beginning to add capability for array-based data store.

  leehach

  committed
  0175fbc

  Copy full SHA for 0175fbc

• Import scripts had hard-coded filename base (e.g. 20115, for ACS 2011 5-year). Added getter function to define filename base per schema, and adjusted meta-scripts to read filename base when dynamic…

  Show description for 8fdafc3
  leehach

  committed
  8fdafc3

  Copy full SHA for 8fdafc3

Commits on Feb 21, 2013

• Replaced idiosyncratic filepath with <census_upload_root> placeholder for ACS 2011; added README.md to ACS 2011 folder

  leehach

  committed
  25440fa

  Copy full SHA for 25440fa

Commits on Feb 17, 2013

• Added import scripts for ACS 2011 5-year data product

  leehach

  committed
  efe2d66

  Copy full SHA for efe2d66

• Simplified main README, moved instructions on use of meta-scripts to the meta-scripts folder

  leehach

  committed
  8ec34ea

  Copy full SHA for 8ec34ea

• Adding ACS 2011 support files, change to meta-script to support ACS 2011

  leehach

  committed
  bb9067b

  Copy full SHA for bb9067b

Commits on Jul 23, 2012

• Added state-specific import scripts to acs2010_5yr; Cleanup of deleted files

  

  unknown

  authored and

  unknown

  committed
  4dacdb6

  Copy full SHA for 4dacdb6

Pagination

Previous

Next