Project

General

Profile

Statistics
| Revision:

root @ 4403

Name Size Revision Age Author Comment
  _archive 1598 over 12 years Aaron Marcuse-Kubitza Moved _archive/tapir2flatClient/trunk/client/ t...
  analysis 3076 over 12 years Aaron Marcuse-Kubitza Added top-level analysis dir for range modeling
  backups 4200 over 12 years Aaron Marcuse-Kubitza backups/: svn:ignore: Also ignore .*, which inc...
  bin 4395 about 12 years Aaron Marcuse-Kubitza Added make_analytical_db
  config 272 almost 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 4403 about 12 years Aaron Marcuse-Kubitza inputs/NY/verify/specimens.ref.sql: Retrofitted...
  lib 4388 over 12 years Aaron Marcuse-Kubitza sql_io.py: null_strs: Added 'UNKNOWN'
  mappings 4382 over 12 years Aaron Marcuse-Kubitza mappings/Veg+-VegCore.csv: Remapped CTFS Quadra...
  schemas 4400 about 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: analytical_db_view: Switch...
  to_do 4091 over 12 years Aaron Marcuse-Kubitza to_do/: svn:ignore OpenOffice lock files
Makefile 10.1 KB 3764 over 12 years Aaron Marcuse-Kubitza root Makefile, input.Makefile: Maps validation:...
README.TXT 10.1 KB 4396 about 12 years Aaron Marcuse-Kubitza README.TXT: After a new import: Use bin/make_an...
map 1.22 KB 3475 over 12 years Aaron Marcuse-Kubitza root map: Run bin/map with a nice increment of ...

Latest revisions

# Date Author Comment
4403 09/04/2012 06:11 PM Aaron Marcuse-Kubitza

inputs/NY/verify/specimens.ref.sql: Retrofitted to use PostgreSQL instead of MySQL syntax, since this now runs on the PostgreSQL staging tables
4402 09/04/2012 06:09 PM Aaron Marcuse-Kubitza

input.Makefile: Verification of import: Added `%.ref: %.ref.sql` rule to make datasource's summary statistics from its staging tables. (This was previously run on a MySQL installation of the datasource, and thus limited to MySQL inputs, but we are now able to use the staging tables for this.)
4401 09/04/2012 06:04 PM Aaron Marcuse-Kubitza

input.Makefile: Verification of import: $(verify): Factored psql command with output format settings into separate $(psqlExport) var
4400 09/04/2012 05:57 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_db_view: Switched join order of location and party (datasource) tables, to facilitate using a nested loop join to fill in the datasource names
4399 09/04/2012 05:55 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: party: Added party_datasource index on just the organizationname to facilitate querying just the datasources
4398 09/04/2012 04:25 PM Aaron Marcuse-Kubitza

schemas/vegbien.sql: make_analytical_db(): Removed explicit schema reference so that the function can be redirected to use the current (rotated) schema using the search_path
4397 08/31/2012 08:32 PM Aaron Marcuse-Kubitza

schemas/Makefile: Removed no longer needed analytical_db, which has been replaced by bin/make_analytical_db
4396 08/31/2012 08:31 PM Aaron Marcuse-Kubitza

README.TXT: After a new import: Use bin/make_analytical_db instead of `make schemas/analytical_db`, and run it asynchronously because it takes a long time
4395 08/31/2012 08:29 PM Aaron Marcuse-Kubitza

Added make_analytical_db
4394 08/31/2012 08:22 PM Aaron Marcuse-Kubitza

schemas/Makefile: Analytical DB: analytical_db: Time the creation of the analytical DB

View all revisions | View revisions

Also available in: Atom