Revision 6073
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/bien_web/observation/+header.csv | ||
|---|---|---|
| 1 |
dataSourceName,family,genus,species,taxon,taxonAuthor,taxonMorphospecies,country,stateProvince,countyParish,collector,collectionNumber,identifiedBy,observationDate,plotCode,plotAreaHa,plotMethod,latitude,longitude,elevation_m,isCultivated,isCultivatedReason,pctCover |
|
| inputs/bien_web/_MySQL/bien_web.schema.sql.make | ||
|---|---|---|
| 1 |
#!/bin/sh |
|
| 2 |
env server=nimoy schema=1 my2pg_export bien_web observation |
|
| 0 | 3 | |
| inputs/bien_web/_MySQL/bien_web.schema.sql | ||
|---|---|---|
| 1 |
-- MySQL dump 10.13 Distrib 5.5.28, for debian-linux-gnu (x86_64) |
|
| 2 |
-- |
|
| 3 |
-- Host: localhost Database: bien_web |
|
| 4 |
-- ------------------------------------------------------ |
|
| 5 |
-- Server version 5.5.28-0ubuntu0.12.04.2 |
|
| 6 |
|
|
| 7 |
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
|
| 8 |
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
|
| 9 |
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
|
| 10 |
/*!40101 SET NAMES latin1 */; |
|
| 11 |
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; |
|
| 12 |
/*!40103 SET TIME_ZONE='+00:00' */; |
|
| 13 |
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; |
|
| 14 |
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; |
|
| 15 |
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,POSTGRESQL' */; |
|
| 16 |
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; |
|
| 17 |
|
|
| 18 |
-- |
|
| 19 |
-- Table structure for table "observation" |
|
| 20 |
-- |
|
| 21 |
|
|
| 22 |
DROP TABLE IF EXISTS "observation"; |
|
| 23 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 24 |
/*!40101 SET character_set_client = utf8 */; |
|
| 25 |
CREATE TABLE "observation" ( |
|
| 26 |
"observationID" int(11) unsigned NOT NULL, |
|
| 27 |
"dataSourceID" int(11) unsigned DEFAULT NULL, |
|
| 28 |
"dataSourceName" varchar(100) DEFAULT NULL, |
|
| 29 |
"dataSourceNamePrimary" varchar(100) DEFAULT NULL, |
|
| 30 |
"plotID" int(11) unsigned DEFAULT NULL, |
|
| 31 |
"observationType" varchar(10) DEFAULT NULL COMMENT '=plot,specimen,trait)', |
|
| 32 |
"bien2_taxonomyID" int(11) unsigned DEFAULT NULL, |
|
| 33 |
"bien2_DBPlotID" int(11) unsigned DEFAULT NULL, |
|
| 34 |
"bien2_ObservationID" int(11) unsigned DEFAULT NULL, |
|
| 35 |
"bien2_OccurID" int(11) unsigned DEFAULT NULL, |
|
| 36 |
"bien2_TraitObservationID" int(11) unsigned DEFAULT NULL, |
|
| 37 |
"taxonAuthorityVerbatim" varchar(255) DEFAULT NULL, |
|
| 38 |
"higherPlantGroup" varchar(25) DEFAULT NULL, |
|
| 39 |
"family" varchar(100) DEFAULT NULL, |
|
| 40 |
"genus" varchar(100) DEFAULT NULL, |
|
| 41 |
"species" varchar(150) DEFAULT NULL, |
|
| 42 |
"taxon" varchar(200) DEFAULT NULL, |
|
| 43 |
"taxonAuthor" varchar(255) DEFAULT NULL, |
|
| 44 |
"taxonMorphospecies" varchar(255) DEFAULT NULL, |
|
| 45 |
"rank" varchar(50) DEFAULT NULL, |
|
| 46 |
"acceptance" varchar(2) DEFAULT NULL, |
|
| 47 |
"country" varchar(50) DEFAULT NULL, |
|
| 48 |
"stateProvince" varchar(100) DEFAULT NULL, |
|
| 49 |
"countyParish" varchar(100) DEFAULT NULL, |
|
| 50 |
"countryError" double DEFAULT NULL, |
|
| 51 |
"stateProvinceError" double DEFAULT NULL, |
|
| 52 |
"localityDescription" varchar(500) DEFAULT NULL, |
|
| 53 |
"collector" varchar(150) DEFAULT NULL, |
|
| 54 |
"collectionNumber" varchar(50) DEFAULT NULL, |
|
| 55 |
"identifiedBy" varchar(150) DEFAULT NULL, |
|
| 56 |
"observationDate" date DEFAULT NULL, |
|
| 57 |
"plotCode" varchar(100) DEFAULT NULL, |
|
| 58 |
"plotAreaHa" double DEFAULT NULL, |
|
| 59 |
"plotMinDbh" decimal(5,1) DEFAULT NULL, |
|
| 60 |
"plotMethod" varchar(100) DEFAULT NULL, |
|
| 61 |
"latitude" decimal(10,5) DEFAULT NULL, |
|
| 62 |
"longitude" decimal(10,5) DEFAULT NULL, |
|
| 63 |
"isValidLatLong" int(1) DEFAULT NULL, |
|
| 64 |
"isGeovalid" int(1) DEFAULT NULL, |
|
| 65 |
"isNewWorld" int(1) DEFAULT NULL, |
|
| 66 |
"elevation_m" decimal(6,1) DEFAULT NULL, |
|
| 67 |
"isCultivated" int(1) DEFAULT '0', |
|
| 68 |
"isCultivatedReason" varchar(255) DEFAULT NULL, |
|
| 69 |
"abund" int(11) DEFAULT NULL, |
|
| 70 |
"abund1" int(11) DEFAULT NULL, |
|
| 71 |
"abund2.5" int(11) DEFAULT NULL, |
|
| 72 |
"abund10" int(11) DEFAULT NULL, |
|
| 73 |
"pctCover" decimal(10,5) DEFAULT NULL, |
|
| 74 |
"traitName" varchar(200) DEFAULT NULL, |
|
| 75 |
"traitValue" varchar(100) DEFAULT NULL, |
|
| 76 |
"traitUnit" varchar(100) DEFAULT NULL, |
|
| 77 |
"traitMethod" varchar(255) DEFAULT NULL, |
|
| 78 |
PRIMARY KEY ("observationID"),
|
|
| 79 |
KEY "observationID" ("observationID"),
|
|
| 80 |
KEY "dataSourceID" ("dataSourceID"),
|
|
| 81 |
KEY "dataSourceName" ("dataSourceName"),
|
|
| 82 |
KEY "dataSourceNamePrimary" ("dataSourceNamePrimary"),
|
|
| 83 |
KEY "plotID" ("plotID"),
|
|
| 84 |
KEY "observationType" ("observationType"),
|
|
| 85 |
KEY "bien2_taxonomyID" ("bien2_taxonomyID"),
|
|
| 86 |
KEY "bien2_DBPlotID" ("bien2_DBPlotID"),
|
|
| 87 |
KEY "bien2_ObservationID" ("bien2_ObservationID"),
|
|
| 88 |
KEY "bien2_OccurID" ("bien2_OccurID"),
|
|
| 89 |
KEY "taxonAuthorityVerbatim" ("taxonAuthorityVerbatim"),
|
|
| 90 |
KEY "higherPlantGroup" ("higherPlantGroup"),
|
|
| 91 |
KEY "family" ("family"),
|
|
| 92 |
KEY "genus" ("genus"),
|
|
| 93 |
KEY "species" ("species"),
|
|
| 94 |
KEY "taxon" ("taxon"),
|
|
| 95 |
KEY "taxonAuthor" ("taxonAuthor"),
|
|
| 96 |
KEY "taxonMorphospecies" ("taxonMorphospecies"),
|
|
| 97 |
KEY "rank" ("rank"),
|
|
| 98 |
KEY "acceptance" ("acceptance"),
|
|
| 99 |
KEY "country" ("country"),
|
|
| 100 |
KEY "stateProvince" ("stateProvince"),
|
|
| 101 |
KEY "collector" ("collector"),
|
|
| 102 |
KEY "identifiedBy" ("identifiedBy"),
|
|
| 103 |
KEY "plotCode" ("plotCode"),
|
|
| 104 |
KEY "plotAreaHa" ("plotAreaHa"),
|
|
| 105 |
KEY "plotMinDbh" ("plotMinDbh"),
|
|
| 106 |
KEY "plotMethod" ("plotMethod"),
|
|
| 107 |
KEY "isValidLatLong" ("isValidLatLong"),
|
|
| 108 |
KEY "isGeovalid" ("isGeovalid"),
|
|
| 109 |
KEY "isNewWorld" ("isNewWorld"),
|
|
| 110 |
KEY "isCultivated" ("isCultivated"),
|
|
| 111 |
KEY "isCultivatedReason" ("isCultivatedReason"),
|
|
| 112 |
KEY "bien2_TraitObservationID" ("bien2_TraitObservationID"),
|
|
| 113 |
KEY "traitName" ("traitName"),
|
|
| 114 |
KEY "traitMethod" ("traitMethod"),
|
|
| 115 |
KEY "traitUnit" ("traitUnit")
|
|
| 116 |
); |
|
| 117 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 118 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
|
| 119 |
|
|
| 120 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
|
| 121 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
|
| 122 |
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |
|
| 123 |
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
|
| 124 |
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
|
| 125 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
|
| 126 |
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
|
| 127 |
|
|
| 128 |
-- Dump completed on 2012-11-08 11:45:19 |
|
| inputs/bien_web/bien_web.schema.sql | ||
|---|---|---|
| 1 |
SET standard_conforming_strings = off; |
|
| 2 |
SET escape_string_warning = off; |
|
| 3 |
-- MySQL dump 10.13 Distrib 5.5.28, for debian-linux-gnu (x86_64) |
|
| 4 |
-- |
|
| 5 |
-- Host: localhost Database: bien_web |
|
| 6 |
-- ------------------------------------------------------ |
|
| 7 |
-- Server version 5.5.28-0ubuntu0.12.04.2 |
|
| 8 |
|
|
| 9 |
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
|
| 10 |
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
|
| 11 |
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
|
| 12 |
SET NAMES 'latin1'; |
|
| 13 |
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; |
|
| 14 |
/*!40103 SET TIME_ZONE='+00:00' */; |
|
| 15 |
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; |
|
| 16 |
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; |
|
| 17 |
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO,POSTGRESQL' */; |
|
| 18 |
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; |
|
| 19 |
|
|
| 20 |
-- |
|
| 21 |
-- Table structure for table "observation" |
|
| 22 |
-- |
|
| 23 |
|
|
| 24 |
DROP TABLE IF EXISTS "observation"; |
|
| 25 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 26 |
/*!40101 SET character_set_client = utf8 */; |
|
| 27 |
CREATE TABLE "observation" ( |
|
| 28 |
"observationID" integer NOT NULL, |
|
| 29 |
"dataSourceID" integer DEFAULT NULL, |
|
| 30 |
"dataSourceName" varchar(100) DEFAULT NULL, |
|
| 31 |
"dataSourceNamePrimary" varchar(100) DEFAULT NULL, |
|
| 32 |
"plotID" integer DEFAULT NULL, |
|
| 33 |
"observationType" varchar(10) DEFAULT NULL, |
|
| 34 |
"bien2_taxonomyID" integer DEFAULT NULL, |
|
| 35 |
"bien2_DBPlotID" integer DEFAULT NULL, |
|
| 36 |
"bien2_ObservationID" integer DEFAULT NULL, |
|
| 37 |
"bien2_OccurID" integer DEFAULT NULL, |
|
| 38 |
"bien2_TraitObservationID" integer DEFAULT NULL, |
|
| 39 |
"taxonAuthorityVerbatim" varchar(255) DEFAULT NULL, |
|
| 40 |
"higherPlantGroup" varchar(25) DEFAULT NULL, |
|
| 41 |
"family" varchar(100) DEFAULT NULL, |
|
| 42 |
"genus" varchar(100) DEFAULT NULL, |
|
| 43 |
"species" varchar(150) DEFAULT NULL, |
|
| 44 |
"taxon" varchar(200) DEFAULT NULL, |
|
| 45 |
"taxonAuthor" varchar(255) DEFAULT NULL, |
|
| 46 |
"taxonMorphospecies" varchar(255) DEFAULT NULL, |
|
| 47 |
"rank" varchar(50) DEFAULT NULL, |
|
| 48 |
"acceptance" varchar(2) DEFAULT NULL, |
|
| 49 |
"country" varchar(50) DEFAULT NULL, |
|
| 50 |
"stateProvince" varchar(100) DEFAULT NULL, |
|
| 51 |
"countyParish" varchar(100) DEFAULT NULL, |
|
| 52 |
"countryError" double precision DEFAULT NULL, |
|
| 53 |
"stateProvinceError" double precision DEFAULT NULL, |
|
| 54 |
"localityDescription" varchar(500) DEFAULT NULL, |
|
| 55 |
"collector" varchar(150) DEFAULT NULL, |
|
| 56 |
"collectionNumber" varchar(50) DEFAULT NULL, |
|
| 57 |
"identifiedBy" varchar(150) DEFAULT NULL, |
|
| 58 |
"observationDate" date DEFAULT NULL, |
|
| 59 |
"plotCode" varchar(100) DEFAULT NULL, |
|
| 60 |
"plotAreaHa" double precision DEFAULT NULL, |
|
| 61 |
"plotMinDbh" decimal(5,1) DEFAULT NULL, |
|
| 62 |
"plotMethod" varchar(100) DEFAULT NULL, |
|
| 63 |
"latitude" decimal(10,5) DEFAULT NULL, |
|
| 64 |
"longitude" decimal(10,5) DEFAULT NULL, |
|
| 65 |
"isValidLatLong" integer DEFAULT NULL, |
|
| 66 |
"isGeovalid" integer DEFAULT NULL, |
|
| 67 |
"isNewWorld" integer DEFAULT NULL, |
|
| 68 |
"elevation_m" decimal(6,1) DEFAULT NULL, |
|
| 69 |
"isCultivated" integer DEFAULT '0', |
|
| 70 |
"isCultivatedReason" varchar(255) DEFAULT NULL, |
|
| 71 |
"abund" integer DEFAULT NULL, |
|
| 72 |
"abund1" integer DEFAULT NULL, |
|
| 73 |
"abund2.5" integer DEFAULT NULL, |
|
| 74 |
"abund10" integer DEFAULT NULL, |
|
| 75 |
"pctCover" decimal(10,5) DEFAULT NULL, |
|
| 76 |
"traitName" varchar(200) DEFAULT NULL, |
|
| 77 |
"traitValue" varchar(100) DEFAULT NULL, |
|
| 78 |
"traitUnit" varchar(100) DEFAULT NULL, |
|
| 79 |
"traitMethod" varchar(255) DEFAULT NULL, |
|
| 80 |
PRIMARY KEY ("observationID"),
|
|
| 81 |
"observationID_index" boolean, |
|
| 82 |
"dataSourceID_index" boolean, |
|
| 83 |
"dataSourceName_index" boolean, |
|
| 84 |
"dataSourceNamePrimary_index" boolean, |
|
| 85 |
"plotID_index" boolean, |
|
| 86 |
"observationType_index" boolean, |
|
| 87 |
"bien2_taxonomyID_index" boolean, |
|
| 88 |
"bien2_DBPlotID_index" boolean, |
|
| 89 |
"bien2_ObservationID_index" boolean, |
|
| 90 |
"bien2_OccurID_index" boolean, |
|
| 91 |
"taxonAuthorityVerbatim_index" boolean, |
|
| 92 |
"higherPlantGroup_index" boolean, |
|
| 93 |
"family_index" boolean, |
|
| 94 |
"genus_index" boolean, |
|
| 95 |
"species_index" boolean, |
|
| 96 |
"taxon_index" boolean, |
|
| 97 |
"taxonAuthor_index" boolean, |
|
| 98 |
"taxonMorphospecies_index" boolean, |
|
| 99 |
"rank_index" boolean, |
|
| 100 |
"acceptance_index" boolean, |
|
| 101 |
"country_index" boolean, |
|
| 102 |
"stateProvince_index" boolean, |
|
| 103 |
"collector_index" boolean, |
|
| 104 |
"identifiedBy_index" boolean, |
|
| 105 |
"plotCode_index" boolean, |
|
| 106 |
"plotAreaHa_index" boolean, |
|
| 107 |
"plotMinDbh_index" boolean, |
|
| 108 |
"plotMethod_index" boolean, |
|
| 109 |
"isValidLatLong_index" boolean, |
|
| 110 |
"isGeovalid_index" boolean, |
|
| 111 |
"isNewWorld_index" boolean, |
|
| 112 |
"isCultivated_index" boolean, |
|
| 113 |
"isCultivatedReason_index" boolean, |
|
| 114 |
"bien2_TraitObservationID_index" boolean, |
|
| 115 |
"traitName_index" boolean, |
|
| 116 |
"traitMethod_index" boolean, |
|
| 117 |
"traitUnit_index" boolean |
|
| 118 |
); |
|
| 119 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 120 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
|
| 121 |
|
|
| 122 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
|
| 123 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
|
| 124 |
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |
|
| 125 |
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
|
| 126 |
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
|
| 127 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
|
| 128 |
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
|
| 129 |
|
|
| 130 |
-- Dump completed on 2012-11-08 11:45:19 |
|
| inputs/bien_web/observation/header.csv | ||
|---|---|---|
| 1 |
observationID,dataSourceID,dataSourceName,dataSourceNamePrimary,plotID,observationType,bien2_taxonomyID,bien2_DBPlotID,bien2_ObservationID,bien2_OccurID,bien2_TraitObservationID,taxonAuthorityVerbatim,higherPlantGroup,family,genus,species,taxon,taxonAuthor,taxonMorphospecies,rank,acceptance,country,stateProvince,countyParish,countryError,stateProvinceError,localityDescription,collector,collectionNumber,identifiedBy,observationDate,plotCode,plotAreaHa,plotMinDbh,plotMethod,latitude,longitude,isValidLatLong,isGeovalid,isNewWorld,elevation_m,isCultivated,isCultivatedReason,abund,abund1,abund2.5,abund10,pctCover,traitName,traitValue,traitUnit,traitMethod,observationID_index,dataSourceID_index,dataSourceName_index,dataSourceNamePrimary_index,plotID_index,observationType_index,bien2_taxonomyID_index,bien2_DBPlotID_index,bien2_ObservationID_index,bien2_OccurID_index,taxonAuthorityVerbatim_index,higherPlantGroup_index,family_index,genus_index,species_index,taxon_index,taxonAuthor_index,taxonMorphospecies_index,rank_index,acceptance_index,country_index,stateProvince_index,collector_index,identifiedBy_index,plotCode_index,plotAreaHa_index,plotMinDbh_index,plotMethod_index,isValidLatLong_index,isGeovalid_index,isNewWorld_index,isCultivated_index,isCultivatedReason_index,bien2_TraitObservationID_index,traitName_index,traitMethod_index,traitUnit_index |
|
| inputs/bien_web/observation/map.csv | ||
|---|---|---|
| 1 | 1 |
bien_web,VegCore,Filter,Comments |
| 2 |
observationID,*observationID,, |
|
| 3 |
dataSourceID,*dataSourceID,, |
|
| 2 | 4 |
dataSourceName,institutionCode,, |
| 5 |
dataSourceNamePrimary,*dataSourceNamePrimary,, |
|
| 6 |
plotID,locationID,, |
|
| 7 |
observationType,*observationType,, |
|
| 8 |
bien2_taxonomyID,*bien2_taxonomyID,, |
|
| 9 |
bien2_DBPlotID,*bien2_DBPlotID,, |
|
| 10 |
bien2_ObservationID,*bien2_ObservationID,, |
|
| 11 |
bien2_OccurID,*bien2_OccurID,, |
|
| 12 |
bien2_TraitObservationID,*bien2_TraitObservationID,, |
|
| 13 |
taxonAuthorityVerbatim,*taxonAuthorityVerbatim,, |
|
| 14 |
higherPlantGroup,higherPlantGroup,, |
|
| 3 | 15 |
family,family,, |
| 4 | 16 |
genus,genus,, |
| 5 | 17 |
species,specificEpithet,, |
| 6 | 18 |
taxon,scientificName,, |
| 7 | 19 |
taxonAuthor,scientificNameAuthorship,, |
| 8 | 20 |
taxonMorphospecies,scientificNameWithMorphospecies,, |
| 21 |
rank,*rank,, |
|
| 22 |
acceptance,*acceptance,, |
|
| 9 | 23 |
country,country,, |
| 10 | 24 |
stateProvince,stateProvince,, |
| 11 | 25 |
countyParish,county,, |
| 26 |
countryError,*countryError,, |
|
| 27 |
stateProvinceError,*stateProvinceError,, |
|
| 28 |
localityDescription,*localityDescription,, |
|
| 12 | 29 |
collector,recordedBy,, |
| 13 | 30 |
collectionNumber,recordNumber,, |
| 14 | 31 |
identifiedBy,identifiedBy,, |
| 15 | 32 |
observationDate,dateCollected,, |
| 16 | 33 |
plotCode,plotName,, |
| 17 | 34 |
plotAreaHa,plotArea_ha,, |
| 35 |
plotMinDbh,*plotMinDbh,, |
|
| 18 | 36 |
plotMethod,samplingProtocol,, |
| 19 | 37 |
latitude,decimalLatitude,, |
| 20 | 38 |
longitude,decimalLongitude,, |
| 39 |
isValidLatLong,*isValidLatLong,, |
|
| 40 |
isGeovalid,*isGeovalid,, |
|
| 41 |
isNewWorld,isNewWorld,, |
|
| 21 | 42 |
elevation_m,elevationInMeters,, |
| 22 | 43 |
isCultivated,cultivated,, |
| 23 | 44 |
isCultivatedReason,cultivatedBasis,, |
| 45 |
abund,*abund,, |
|
| 46 |
abund1,*abund1,, |
|
| 47 |
abund2.5,*abund2.5,, |
|
| 48 |
abund10,*abund10,, |
|
| 24 | 49 |
pctCover,coverPercent,, |
| 50 |
traitName,*traitName,, |
|
| 51 |
traitValue,*traitValue,, |
|
| 52 |
traitUnit,*traitUnit,, |
|
| 53 |
traitMethod,*traitMethod,, |
|
| 54 |
observationID_index,*observationID_index,, |
|
| 55 |
dataSourceID_index,*dataSourceID_index,, |
|
| 56 |
dataSourceName_index,*dataSourceName_index,, |
|
| 57 |
dataSourceNamePrimary_index,*dataSourceNamePrimary_index,, |
|
| 58 |
plotID_index,*plotID_index,, |
|
| 59 |
observationType_index,*observationType_index,, |
|
| 60 |
bien2_taxonomyID_index,*bien2_taxonomyID_index,, |
|
| 61 |
bien2_DBPlotID_index,*bien2_DBPlotID_index,, |
|
| 62 |
bien2_ObservationID_index,*bien2_ObservationID_index,, |
|
| 63 |
bien2_OccurID_index,*bien2_OccurID_index,, |
|
| 64 |
taxonAuthorityVerbatim_index,*taxonAuthorityVerbatim_index,, |
|
| 65 |
higherPlantGroup_index,*higherPlantGroup_index,, |
|
| 66 |
family_index,*family_index,, |
|
| 67 |
genus_index,*genus_index,, |
|
| 68 |
species_index,*species_index,, |
|
| 69 |
taxon_index,*taxon_index,, |
|
| 70 |
taxonAuthor_index,*taxonAuthor_index,, |
|
| 71 |
taxonMorphospecies_index,*taxonMorphospecies_index,, |
|
| 72 |
rank_index,*rank_index,, |
|
| 73 |
acceptance_index,*acceptance_index,, |
|
| 74 |
country_index,*country_index,, |
|
| 75 |
stateProvince_index,*stateProvince_index,, |
|
| 76 |
collector_index,*collector_index,, |
|
| 77 |
identifiedBy_index,*identifiedBy_index,, |
|
| 78 |
plotCode_index,*plotCode_index,, |
|
| 79 |
plotAreaHa_index,*plotAreaHa_index,, |
|
| 80 |
plotMinDbh_index,*plotMinDbh_index,, |
|
| 81 |
plotMethod_index,*plotMethod_index,, |
|
| 82 |
isValidLatLong_index,*isValidLatLong_index,, |
|
| 83 |
isGeovalid_index,*isGeovalid_index,, |
|
| 84 |
isNewWorld_index,*isNewWorld_index,, |
|
| 85 |
isCultivated_index,*isCultivated_index,, |
|
| 86 |
isCultivatedReason_index,*isCultivatedReason_index,, |
|
| 87 |
bien2_TraitObservationID_index,*bien2_TraitObservationID_index,, |
|
| 88 |
traitName_index,*traitName_index,, |
|
| 89 |
traitMethod_index,*traitMethod_index,, |
|
| 90 |
traitUnit_index,*traitUnit_index,, |
|
| inputs/bien_web/observation/VegBIEN.csv | ||
|---|---|---|
| 1 | 1 |
bien_web,VegBIEN:/_simplifyPath:[next=parent_id]/path,Comments |
| 2 | 2 |
plotCode,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/1", |
| 3 |
plotID,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/2/_if[@name=""if locationID""]/cond/_exists", |
|
| 3 | 4 |
dataSourceName,"/location/_if[@name=""if subplot""]/else/authorlocationcode/_first/3/_alt/2/_if[@name=""if catalogNumber""]/then/_join/1", |
| 5 |
plotID,"/location/_if[@name=""if subplot""]/else/sourceaccessioncode/_if[@name=""if geovalidation""]/else", |
|
| 4 | 6 |
plotCode,"/location/_if[@name=""if subplot""]/then/parent_id/location/authorlocationcode", |
| 7 |
plotID,"/location/_if[@name=""if subplot""]/then/parent_id/location/sourceaccessioncode", |
|
| 5 | 8 |
plotAreaHa,/location/area_m2/_ha_to_m2/value, |
| 6 | 9 |
elevation_m,/location/elevation_m/_alt/1, |
| 7 | 10 |
plotMethod,/location/locationevent/*_id/method/name, |
| 8 | 11 |
plotCode,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/authorlocationcode/_if[@name=""if subplot""]/then", |
| 12 |
plotID,"/location/locationevent/_if[@name=""if subplot""]/then/_if[@name=""if has event""]/then/parent_id/locationevent/*_id/location/sourceaccessioncode/_if[@name=""if subplot""]/then", |
|
| 9 | 13 |
observationDate,/location/locationevent/taxonoccurrence/aggregateoccurrence/collectiondate/_alt/1/_*/date, |
| 10 | 14 |
pctCover,/location/locationevent/taxonoccurrence/aggregateoccurrence/cover_fraction/_percent_to_fraction/value, |
| 11 | 15 |
collectionNumber,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/collectionnumber, |
| 12 | 16 |
dataSourceName,/location/locationevent/taxonoccurrence/aggregateoccurrence/plantobservation/specimenreplicate/institution_id/party/organizationname, |
| 13 | 17 |
plotCode,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
| 18 |
plotID,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/cond/_exists", |
|
| 14 | 19 |
collectionNumber,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/1/_first/1", |
| 15 | 20 |
taxon,"/location/locationevent/taxonoccurrence/authortaxoncode/_if[@name=""if in plot""]/then/_first/2/_first/2", |
| 16 | 21 |
isCultivated,/location/locationevent/taxonoccurrence/iscultivated/_alt/1, |
| ... | ... | |
| 44 | 49 |
longitude,"/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/*_id/coordinates/_first/2/longitude_deg/_nullIf:[null=0,type=float]/value", |
| 45 | 50 |
country,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/country/_first/2, |
| 46 | 51 |
stateProvince,/location/locationplace/*_id/place/matched_place_id/place:[reference_id/reference/shortname=geoscrub]/stateprovince/_first/2, |
| 52 |
plotID,"/location/locationplace/*_id/place/placecode/_if[@name=""if geovalidation""]/then", |
|
| 47 | 53 |
stateProvince,/location/locationplace/*_id/place/stateprovince, |
| 54 |
plotID,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/1", |
|
| 48 | 55 |
plotCode,"/location/sourceaccessioncode/_join/1/_if[@name=""if subplot and unique only within parent""]/then/_first/2", |
| 56 |
abund,,** No join mapping for *abund ** |
|
| 57 |
abund1,,** No join mapping for *abund1 ** |
|
| 58 |
abund10,,** No join mapping for *abund10 ** |
|
| 59 |
abund2.5,,** No join mapping for *abund2.5 ** |
|
| 60 |
acceptance,,** No join mapping for *acceptance ** |
|
| 61 |
acceptance_index,,** No join mapping for *acceptance_index ** |
|
| 62 |
bien2_DBPlotID,,** No join mapping for *bien2_DBPlotID ** |
|
| 63 |
bien2_DBPlotID_index,,** No join mapping for *bien2_DBPlotID_index ** |
|
| 64 |
bien2_ObservationID,,** No join mapping for *bien2_ObservationID ** |
|
| 65 |
bien2_ObservationID_index,,** No join mapping for *bien2_ObservationID_index ** |
|
| 66 |
bien2_OccurID,,** No join mapping for *bien2_OccurID ** |
|
| 67 |
bien2_OccurID_index,,** No join mapping for *bien2_OccurID_index ** |
|
| 68 |
bien2_TraitObservationID,,** No join mapping for *bien2_TraitObservationID ** |
|
| 69 |
bien2_TraitObservationID_index,,** No join mapping for *bien2_TraitObservationID_index ** |
|
| 70 |
bien2_taxonomyID,,** No join mapping for *bien2_taxonomyID ** |
|
| 71 |
bien2_taxonomyID_index,,** No join mapping for *bien2_taxonomyID_index ** |
|
| 72 |
collector_index,,** No join mapping for *collector_index ** |
|
| 73 |
countryError,,** No join mapping for *countryError ** |
|
| 74 |
country_index,,** No join mapping for *country_index ** |
|
| 75 |
dataSourceID,,** No join mapping for *dataSourceID ** |
|
| 76 |
dataSourceID_index,,** No join mapping for *dataSourceID_index ** |
|
| 77 |
dataSourceNamePrimary,,** No join mapping for *dataSourceNamePrimary ** |
|
| 78 |
dataSourceNamePrimary_index,,** No join mapping for *dataSourceNamePrimary_index ** |
|
| 79 |
dataSourceName_index,,** No join mapping for *dataSourceName_index ** |
|
| 80 |
family_index,,** No join mapping for *family_index ** |
|
| 81 |
genus_index,,** No join mapping for *genus_index ** |
|
| 82 |
higherPlantGroup,,** No join mapping for higherPlantGroup ** |
|
| 83 |
higherPlantGroup_index,,** No join mapping for *higherPlantGroup_index ** |
|
| 84 |
identifiedBy_index,,** No join mapping for *identifiedBy_index ** |
|
| 49 | 85 |
isCultivatedReason,,** No join mapping for cultivatedBasis ** |
| 86 |
isCultivatedReason_index,,** No join mapping for *isCultivatedReason_index ** |
|
| 87 |
isCultivated_index,,** No join mapping for *isCultivated_index ** |
|
| 88 |
isGeovalid,,** No join mapping for *isGeovalid ** |
|
| 89 |
isGeovalid_index,,** No join mapping for *isGeovalid_index ** |
|
| 90 |
isNewWorld,,** No join mapping for isNewWorld ** |
|
| 91 |
isNewWorld_index,,** No join mapping for *isNewWorld_index ** |
|
| 92 |
isValidLatLong,,** No join mapping for *isValidLatLong ** |
|
| 93 |
isValidLatLong_index,,** No join mapping for *isValidLatLong_index ** |
|
| 94 |
localityDescription,,** No join mapping for *localityDescription ** |
|
| 95 |
observationID,,** No join mapping for *observationID ** |
|
| 96 |
observationID_index,,** No join mapping for *observationID_index ** |
|
| 97 |
observationType,,** No join mapping for *observationType ** |
|
| 98 |
observationType_index,,** No join mapping for *observationType_index ** |
|
| 99 |
plotAreaHa_index,,** No join mapping for *plotAreaHa_index ** |
|
| 100 |
plotCode_index,,** No join mapping for *plotCode_index ** |
|
| 101 |
plotID_index,,** No join mapping for *plotID_index ** |
|
| 102 |
plotMethod_index,,** No join mapping for *plotMethod_index ** |
|
| 103 |
plotMinDbh,,** No join mapping for *plotMinDbh ** |
|
| 104 |
plotMinDbh_index,,** No join mapping for *plotMinDbh_index ** |
|
| 105 |
rank,,** No join mapping for *rank ** |
|
| 106 |
rank_index,,** No join mapping for *rank_index ** |
|
| 107 |
species_index,,** No join mapping for *species_index ** |
|
| 108 |
stateProvinceError,,** No join mapping for *stateProvinceError ** |
|
| 109 |
stateProvince_index,,** No join mapping for *stateProvince_index ** |
|
| 110 |
taxonAuthor_index,,** No join mapping for *taxonAuthor_index ** |
|
| 111 |
taxonAuthorityVerbatim,,** No join mapping for *taxonAuthorityVerbatim ** |
|
| 112 |
taxonAuthorityVerbatim_index,,** No join mapping for *taxonAuthorityVerbatim_index ** |
|
| 50 | 113 |
taxonMorphospecies,,** No join mapping for scientificNameWithMorphospecies ** |
| 114 |
taxonMorphospecies_index,,** No join mapping for *taxonMorphospecies_index ** |
|
| 115 |
taxon_index,,** No join mapping for *taxon_index ** |
|
| 116 |
traitMethod,,** No join mapping for *traitMethod ** |
|
| 117 |
traitMethod_index,,** No join mapping for *traitMethod_index ** |
|
| 118 |
traitName,,** No join mapping for *traitName ** |
|
| 119 |
traitName_index,,** No join mapping for *traitName_index ** |
|
| 120 |
traitUnit,,** No join mapping for *traitUnit ** |
|
| 121 |
traitUnit_index,,** No join mapping for *traitUnit_index ** |
|
| 122 |
traitValue,,** No join mapping for *traitValue ** |
|
| inputs/bien_web/observation/test.xml.ref | ||
|---|---|---|
| 5 | 5 |
<path> |
| 6 | 6 |
<location> |
| 7 | 7 |
<authorlocationcode>$plotCode</authorlocationcode> |
| 8 |
<sourceaccessioncode>$plotID</sourceaccessioncode> |
|
| 8 | 9 |
<area_m2><_ha_to_m2><value>$plotAreaHa</value></_ha_to_m2></area_m2> |
| 9 | 10 |
<elevation_m>$elevation_m</elevation_m> |
| 10 | 11 |
<locationevent> |
| inputs/bien_web/observation/unmapped_terms.csv | ||
|---|---|---|
| 1 |
*observationID |
|
| 2 |
*dataSourceID |
|
| 3 |
*dataSourceNamePrimary |
|
| 4 |
*observationType |
|
| 5 |
*bien2_taxonomyID |
|
| 6 |
*bien2_DBPlotID |
|
| 7 |
*bien2_ObservationID |
|
| 8 |
*bien2_OccurID |
|
| 9 |
*bien2_TraitObservationID |
|
| 10 |
*taxonAuthorityVerbatim |
|
| 11 |
higherPlantGroup |
|
| 1 | 12 |
scientificNameWithMorphospecies |
| 13 |
*rank |
|
| 14 |
*acceptance |
|
| 15 |
*countryError |
|
| 16 |
*stateProvinceError |
|
| 17 |
*localityDescription |
|
| 18 |
*plotMinDbh |
|
| 19 |
*isValidLatLong |
|
| 20 |
*isGeovalid |
|
| 21 |
isNewWorld |
|
| 2 | 22 |
cultivatedBasis |
| 23 |
*abund |
|
| 24 |
*abund1 |
|
| 25 |
*abund2.5 |
|
| 26 |
*abund10 |
|
| 27 |
*traitName |
|
| 28 |
*traitValue |
|
| 29 |
*traitUnit |
|
| 30 |
*traitMethod |
|
| 31 |
*observationID_index |
|
| 32 |
*dataSourceID_index |
|
| 33 |
*dataSourceName_index |
|
| 34 |
*dataSourceNamePrimary_index |
|
| 35 |
*plotID_index |
|
| 36 |
*observationType_index |
|
| 37 |
*bien2_taxonomyID_index |
|
| 38 |
*bien2_DBPlotID_index |
|
| 39 |
*bien2_ObservationID_index |
|
| 40 |
*bien2_OccurID_index |
|
| 41 |
*taxonAuthorityVerbatim_index |
|
| 42 |
*higherPlantGroup_index |
|
| 43 |
*family_index |
|
| 44 |
*genus_index |
|
| 45 |
*species_index |
|
| 46 |
*taxon_index |
|
| 47 |
*taxonAuthor_index |
|
| 48 |
*taxonMorphospecies_index |
|
| 49 |
*rank_index |
|
| 50 |
*acceptance_index |
|
| 51 |
*country_index |
|
| 52 |
*stateProvince_index |
|
| 53 |
*collector_index |
|
| 54 |
*identifiedBy_index |
|
| 55 |
*plotCode_index |
|
| 56 |
*plotAreaHa_index |
|
| 57 |
*plotMinDbh_index |
|
| 58 |
*plotMethod_index |
|
| 59 |
*isValidLatLong_index |
|
| 60 |
*isGeovalid_index |
|
| 61 |
*isNewWorld_index |
|
| 62 |
*isCultivated_index |
|
| 63 |
*isCultivatedReason_index |
|
| 64 |
*bien2_TraitObservationID_index |
|
| 65 |
*traitName_index |
|
| 66 |
*traitMethod_index |
|
| 67 |
*traitUnit_index |
|
Also available in: Unified diff
inputs/bien_web/observation/: Regenerated from actual bien_web.observation schema on nimoy, which has additional columns