Project

General

Profile

Statistics
| Revision:

root @ 4739

Name Size Revision Age Author Comment
  _archive 1598 almost 13 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 4696 over 12 years Aaron Marcuse-Kubitza Removed no longer used ucase_first
  config 272 about 13 years Aaron Marcuse-Kubitza Moved bien_password to new config dir
  inputs 4727 over 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: Added placepath (analogous...
  lib 4614 over 12 years Aaron Marcuse-Kubitza lib/mappings.Makefile: missing_mappings: Displa...
  mappings 4733 over 12 years Aaron Marcuse-Kubitza mappings/VegBank-VegBIEN.csv: Added place->loca...
  schemas 4739 over 12 years Aaron Marcuse-Kubitza schemas/vegbien.sql: analytical_db_view: Use ne...
  to_do 4524 over 12 years Aaron Marcuse-Kubitza to_do/timeline.doc: Updated to reflect addition...
  validation 4523 over 12 years Aaron Marcuse-Kubitza Added validation/
Makefile 9.91 KB 4613 over 12 years Aaron Marcuse-Kubitza root Makefile: Maps validation: Removed no long...
README.TXT 10.9 KB 4677 over 12 years Aaron Marcuse-Kubitza README.TXT: Data import: Added steps to record ...
map 1.22 KB 3475 over 12 years Aaron Marcuse-Kubitza root map: Run bin/map with a nice increment of ...
new_terms.csv 8.09 KB 4714 over 12 years Aaron Marcuse-Kubitza Updated aggregated unmapped_terms.csv, new_term...
unmapped_terms.csv 5.91 KB 4714 over 12 years Aaron Marcuse-Kubitza Updated aggregated unmapped_terms.csv, new_term...

Latest revisions

# Date Author Comment
4739 09/17/2012 10:14 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_db_view: Use new denormalized placepath table instead of place, which significantly reduces the number of joins
4738 09/17/2012 10:11 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: location: Removed stateprovince, country because these are now in placepath (as well as in place.rank)
4737 09/17/2012 10:01 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_db_view: LEFT JOIN locationcoords and locationplace so that locations will be included even if they don't have one of these two determinations
4736 09/17/2012 10:00 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: analytical_db_view: Fixed bug where method was being joined instead of left-joined, causing only rows with a method to be included
4735 09/17/2012 09:44 AM Aaron Marcuse-Kubitza

Regenerated vegbien.ERD exports
4734 09/17/2012 09:41 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: locationplace: Added identifier_id, so that different identifiers (e.g. the data provider and GNRS) can provide separate locationplaces even if the standardized name happens to be the same as the original name
4733 09/17/2012 09:31 AM Aaron Marcuse-Kubitza

mappings/VegBank-VegBIEN.csv: Added place->locationplace renaming
4732 09/17/2012 09:30 AM Aaron Marcuse-Kubitza

mappings/VegBIEN-VegBank.csv: Reversed the order of the columns so it's a more natural forward renaming, and renamed the file to VegBank-VegBIEN.csv to reflect the new column order
4731 09/17/2012 09:27 AM Aaron Marcuse-Kubitza

mappings/VegBIEN-VegBank.csv: Fixed order of plantconcept->taxon renaming because the VegBIEN column is on the right
4730 09/17/2012 09:26 AM Aaron Marcuse-Kubitza

schemas/vegbien.sql: Renamed namedplace to place for simplicity and consistency with placepath and locationplace

View all revisions | View revisions

Also available in: Atom