Project

General

Profile

Statistics
| Revision:

root @ 4408

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 4408 about 12 years Aaron Marcuse-Kubitza input.Makefile: Added $(inDatasrc)
  lib 4407 about 12 years Aaron Marcuse-Kubitza sql_io.py: cleanup_table(): Only clean up text ...
  mappings 4382 about 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
4408 09/04/2012 06:54 PM Aaron Marcuse-Kubitza

input.Makefile: Added $(inDatasrc)
4407 09/04/2012 06:40 PM Aaron Marcuse-Kubitza

sql_io.py: cleanup_table(): Only clean up text columns, to support staging tables with other column types
4406 09/04/2012 06:40 PM Aaron Marcuse-Kubitza

sql_gen.py: Added is_text_col()
4405 09/04/2012 06:29 PM Aaron Marcuse-Kubitza

sql_io.py: cleanup_table(): Add table to each column so its type can later be determined from the DB
4404 09/04/2012 06:13 PM Aaron Marcuse-Kubitza

inputs/NY/verify/specimens.ref: Regenerated from specimens.ref.sql. The counts have changed slightly because this is derived directly from the NY CSV file, rather than from the nybg_raw BIEN2 staging table.
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

View all revisions | View revisions

Also available in: Atom