Project

General

Profile

Statistics
| Revision:
Name Size Revision Age Author Comment
  BOUNDARY 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  COND 11843 almost 11 years Aaron Marcuse-Kubitza inputs/FIA/COND/postprocess.sql: filtering form...
  COND_DWM_CALC 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  COUNTY 11396 about 11 years Aaron Marcuse-Kubitza fix: bin/map: put template: comment out the "Pu...
  DWM_COARSE_WOODY_DEBRIS 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  DWM_DUFF_LITTER_FUEL 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  DWM_FINE_WOODY_DEBRIS 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  DWM_MICROPLOT_FUEL 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  DWM_RESIDUAL_PILE 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  DWM_TRANSECT_SEGMENT 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  DWM_VISIT 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  LICHEN_LAB 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  LICHEN_PLOT_SUMMARY 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  LICHEN_SPECIES_SUMMARY 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  LICHEN_VISIT 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  OZONE_BIOSITE_SUMMARY 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  OZONE_PLOT 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  OZONE_PLOT_SUMMARY 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  OZONE_SPECIES_SUMMARY 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  OZONE_VALIDATION 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  OZONE_VISIT 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  P2VEG_SUBPLOT_SPP 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  P2VEG_SUBP_STRUCTURE 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  PLOT 11396 about 11 years Aaron Marcuse-Kubitza fix: bin/map: put template: comment out the "Pu...
  PLOTGEOM 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  PLOTSNAP 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  POP_ESTN_UNIT 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  POP_EVAL 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  POP_EVAL_ATTRIBUTE 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  POP_EVAL_GRP 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  POP_EVAL_TYP 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  POP_PLOT_STRATUM_ASSGN 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  POP_STRATUM 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  REF_CITATION 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  REF_FIADB_VERSION 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  REF_FOREST_TYPE 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  REF_FOREST_TYPE_GROUP 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  REF_HABTYP_DESCRIPTION 11396 about 11 years Aaron Marcuse-Kubitza fix: bin/map: put template: comment out the "Pu...
  REF_HABTYP_PUBLICATION 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  REF_INVASIVE_SPECIES 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  REF_LICHEN_SPECIES 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  REF_LICHEN_SPP_COMMENTS 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  REF_PLANT_DICTIONARY 11396 about 11 years Aaron Marcuse-Kubitza fix: bin/map: put template: comment out the "Pu...
  REF_POP_ATTRIBUTE 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  REF_POP_EVAL_TYP_DESCR 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  REF_RESEARCH_STATION 11396 about 11 years Aaron Marcuse-Kubitza fix: bin/map: put template: comment out the "Pu...
  REF_SPECIES 11396 about 11 years Aaron Marcuse-Kubitza fix: bin/map: put template: comment out the "Pu...
  REF_SPECIES_GROUP 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  REF_STATE_ELEV 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  REF_UNIT 11396 about 11 years Aaron Marcuse-Kubitza fix: bin/map: put template: comment out the "Pu...
  SEEDLING 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  SITETREE 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  SOILS_EROSION 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  SOILS_LAB 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  SOILS_SAMPLE_LOC 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  SOILS_VISIT 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  SUBPLOT 11396 about 11 years Aaron Marcuse-Kubitza fix: bin/map: put template: comment out the "Pu...
  SUBP_COND 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  SUBP_COND_CHNG_MTRX 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  SURVEY 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  Source 11396 about 11 years Aaron Marcuse-Kubitza fix: bin/map: put template: comment out the "Pu...
  TREE 11871 almost 11 years Aaron Marcuse-Kubitza inputs/FIA/TREE/run: documented import() runtim...
  TREE_REGIONAL_BIOMASS 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  VEG_PLOT_SPECIES 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  VEG_QUADRAT 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  VEG_SUBPLOT 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  VEG_SUBPLOT_SPP 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  VEG_VISIT 10091 over 11 years Aaron Marcuse-Kubitza added inputs/*/*/header.csv for CSV inputs, whi...
  _archive 11705 about 11 years Aaron Marcuse-Kubitza copyright scrub: inputs/: removed data provider...
  _src 11705 about 11 years Aaron Marcuse-Kubitza copyright scrub: inputs/: removed data provider...
  logs 8801 over 11 years Aaron Marcuse-Kubitza inputs/input.Makefile: SVN: add, %/add: */logs:...
  taxon_observation.** 11396 about 11 years Aaron Marcuse-Kubitza fix: bin/map: put template: comment out the "Pu...
  verify 6805 almost 12 years Aaron Marcuse-Kubitza input.Makefile: SVN: add: verify: Also ignore *...
Makefile 27 Bytes 10081 over 11 years Aaron Marcuse-Kubitza added inputs/FIA/table.run (for use by table su...
fia_extract.tar.gz.md5 33 Bytes 7571 almost 12 years Aaron Marcuse-Kubitza inputs/: Added .md5 files for all .zip, .gz
fia_extract.tar.gz.url 69 Bytes 7585 almost 12 years Aaron Marcuse-Kubitza Added inputs/FIA/fia_extract.tar.gz.url
import_order.txt 144 Bytes 10950 about 11 years Aaron Marcuse-Kubitza inputs/FIA/occurrence_all/: renamed to taxon_ob...
map.csv 88 Bytes 8205 over 11 years Aaron Marcuse-Kubitza Added inputs/FIA/map.csv, which maps shared col...
new_terms.csv 17.8 KB 11788 almost 11 years Aaron Marcuse-Kubitza **/new_terms.csv, unmapped_terms.csv updated (u...
run 151 Bytes 10083 over 11 years Aaron Marcuse-Kubitza added inputs/FIA/run
table.run 81 Bytes 10081 over 11 years Aaron Marcuse-Kubitza added inputs/FIA/table.run (for use by table su...
unmapped_terms.csv 10.5 KB 11788 almost 11 years Aaron Marcuse-Kubitza **/new_terms.csv, unmapped_terms.csv updated (u...
  • svn:ignore: *

Latest revisions

# Date Author Comment
11970 01/20/2014 11:33 AM Aaron Marcuse-Kubitza

moved everything into /trunk/ to create the standard svn layout, for use with tools that require this (eg. git-svn). IMPORTANT: do NOT do an `svn up`. instead, re-use your working copy's existing files with `svn switch` (http://svnbook.red-bean.com/en/1.6/svn.ref.svn.c.switch.html).

11871 12/09/2013 03:37 PM Aaron Marcuse-Kubitza

inputs/FIA/TREE/run: documented import() runtime (1.5 h), which includes table cleanup runtime (1 h)

11843 12/05/2013 11:38 PM Aaron Marcuse-Kubitza

inputs/FIA/COND/postprocess.sql: filtering formula: documented that this was created by Brad, and provided the URL to it on nimoy

11788 11/26/2013 11:11 PM Aaron Marcuse-Kubitza

**/new_terms.csv, unmapped_terms.csv updated (using `make missing_mappings`)

11705 11/21/2013 12:24 AM Aaron Marcuse-Kubitza

copyright scrub: inputs/: removed data provider-owned schema and documentation files, which are not BIEN copyright and should not be part of what is submitted for open-sourcing. these files will remain accessible via the web interface (fs.vegpath.org), but will not be in the repository.

11396 10/21/2013 07:14 PM Aaron Marcuse-Kubitza

fix: bin/map: put template: comment out the "Put template:" label so that the output is valid XML, and displays properly in a browser rather than showing a syntax error

11107 09/29/2013 08:58 PM Aaron Marcuse-Kubitza

bugfix: mappings/VegCore-VegBIEN.csv: nest all taxonoccurrences inside a stratum event, so that the parent locationevent is always fully populated before child locationevents point to it. (previously, a stub parent event was created when the child event was imported first, which blocked the fully-populated parent event from being inserted later on.) this uses auto-folding (for VegBank/CVS) and auto-forwarding (for other datasources) to prune empty stratum events for taxonoccurrences that don't have strata. (see wiki.vegpath.org/Auto-folding, wiki.vegpath.org/Auto-forwarding for more info about these normalization techniques.) note that the inserted row counts stay exactly the same for all datasources except VegBank (which was being fixed), indicating that this signficant change to the mappings did not change the semantics of the import of taxonoccurrences.

10950 09/14/2013 09:26 PM Aaron Marcuse-Kubitza

inputs/FIA/occurrence_all/: renamed to taxon_observation.** to clarify what an occurrence is. taxon_observation has the same meaning as in VegCore, where each taxon_determination is considered a separate taxon_observation of the associated specimen or vouchered plant (vegpath.org/VegCore/ERD/). (note that having multiple taxon_determinations only makes sense when there is something to reobserve.) the .** is SQL dotpath syntax (wiki.vegpath.org/SQL_dotpaths) for the recursive expansion of all tables to which taxon_observation has forward fkeys (i.e. "the left-join").

10949 09/14/2013 09:01 PM Aaron Marcuse-Kubitza

inputs/FIA/occurrence_all/postprocess.sql: use :table_str var instead of hardcoding the table name as occurrence_all, to avoid needing to change this file when renaming the view

10948 09/14/2013 05:38 PM Aaron Marcuse-Kubitza

inputs/FIA/occurrence_all/postprocess.sql: renamed occurrence_all--row_num to just row_num because this is for the entire view, rather than a specific table in it, and thus does not need a disambiguating table prefix. this also avoids embedding the view name in its own columns.

View revisions

Also available in: Atom