Project

General

Profile

« Previous | Next » 

Revision 10258

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/bien_web/bien_web.schema.sql: regenerated using bin/my2pg, to remove the *_index dummy columns so they don't create lots of OMIT#... staging table columns

View differences:

inputs/bien_web/bien_web.schema.sql
55 55 
  "collector" varchar(150) DEFAULT NULL,
56 56 
  "collectionNumber" varchar(50) DEFAULT NULL,
57 57 
  "identifiedBy" varchar(150) DEFAULT NULL,
58 
  "observationDate" date DEFAULT NULL,
58 
  "observationDate" text/*date*/ DEFAULT NULL,
59 59 
  "plotCode" varchar(100) DEFAULT NULL,
60 60 
  "plotAreaHa" double precision DEFAULT NULL,
61 61 
  "plotMinDbh" decimal(5,1) DEFAULT NULL,
......
78 78 
  "traitUnit" varchar(100) DEFAULT NULL,
79 79 
  "traitMethod" varchar(255) DEFAULT NULL,
80 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
81 
  /*KEY "observationID" ("observationID")*/CHECK (true),
82 
  /*KEY "dataSourceID" ("dataSourceID")*/CHECK (true),
83 
  /*KEY "dataSourceName" ("dataSourceName")*/CHECK (true),
84 
  /*KEY "dataSourceNamePrimary" ("dataSourceNamePrimary")*/CHECK (true),
85 
  /*KEY "plotID" ("plotID")*/CHECK (true),
86 
  /*KEY "observationType" ("observationType")*/CHECK (true),
87 
  /*KEY "bien2_taxonomyID" ("bien2_taxonomyID")*/CHECK (true),
88 
  /*KEY "bien2_DBPlotID" ("bien2_DBPlotID")*/CHECK (true),
89 
  /*KEY "bien2_ObservationID" ("bien2_ObservationID")*/CHECK (true),
90 
  /*KEY "bien2_OccurID" ("bien2_OccurID")*/CHECK (true),
91 
  /*KEY "taxonAuthorityVerbatim" ("taxonAuthorityVerbatim")*/CHECK (true),
92 
  /*KEY "higherPlantGroup" ("higherPlantGroup")*/CHECK (true),
93 
  /*KEY "family" ("family")*/CHECK (true),
94 
  /*KEY "genus" ("genus")*/CHECK (true),
95 
  /*KEY "species" ("species")*/CHECK (true),
96 
  /*KEY "taxon" ("taxon")*/CHECK (true),
97 
  /*KEY "taxonAuthor" ("taxonAuthor")*/CHECK (true),
98 
  /*KEY "taxonMorphospecies" ("taxonMorphospecies")*/CHECK (true),
99 
  /*KEY "rank" ("rank")*/CHECK (true),
100 
  /*KEY "acceptance" ("acceptance")*/CHECK (true),
101 
  /*KEY "country" ("country")*/CHECK (true),
102 
  /*KEY "stateProvince" ("stateProvince")*/CHECK (true),
103 
  /*KEY "collector" ("collector")*/CHECK (true),
104 
  /*KEY "identifiedBy" ("identifiedBy")*/CHECK (true),
105 
  /*KEY "plotCode" ("plotCode")*/CHECK (true),
106 
  /*KEY "plotAreaHa" ("plotAreaHa")*/CHECK (true),
107 
  /*KEY "plotMinDbh" ("plotMinDbh")*/CHECK (true),
108 
  /*KEY "plotMethod" ("plotMethod")*/CHECK (true),
109 
  /*KEY "isValidLatLong" ("isValidLatLong")*/CHECK (true),
110 
  /*KEY "isGeovalid" ("isGeovalid")*/CHECK (true),
111 
  /*KEY "isNewWorld" ("isNewWorld")*/CHECK (true),
112 
  /*KEY "isCultivated" ("isCultivated")*/CHECK (true),
113 
  /*KEY "isCultivatedReason" ("isCultivatedReason")*/CHECK (true),
114 
  /*KEY "bien2_TraitObservationID" ("bien2_TraitObservationID")*/CHECK (true),
115 
  /*KEY "traitName" ("traitName")*/CHECK (true),
116 
  /*KEY "traitMethod" ("traitMethod")*/CHECK (true),
117 
  /*KEY "traitUnit" ("traitUnit")*/CHECK (true)
118 118 
);
119 119 
/*!40101 SET character_set_client = @saved_cs_client */;
120 120 
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
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
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
inputs/bien_web/observation/map.csv
51 51 
traitValue,measurementValue,,
52 52 
traitUnit,*traitUnit,,
53 53 
traitMethod,*traitMethod,,
54 
observationID_index,OMIT#observationID_index,,Placeholder column created by MySQL to PostgreSQL translation
55 
dataSourceID_index,OMIT#dataSourceID_index,,Placeholder column created by MySQL to PostgreSQL translation
56 
dataSourceName_index,OMIT#dataSourceName_index,,Placeholder column created by MySQL to PostgreSQL translation
57 
dataSourceNamePrimary_index,OMIT#dataSourceNamePrimary_index,,Placeholder column created by MySQL to PostgreSQL translation
58 
plotID_index,OMIT#plotID_index,,Placeholder column created by MySQL to PostgreSQL translation
59 
observationType_index,OMIT#observationType_index,,Placeholder column created by MySQL to PostgreSQL translation
60 
bien2_taxonomyID_index,OMIT#bien2_taxonomyID_index,,Placeholder column created by MySQL to PostgreSQL translation
61 
bien2_DBPlotID_index,OMIT#bien2_DBPlotID_index,,Placeholder column created by MySQL to PostgreSQL translation
62 
bien2_ObservationID_index,OMIT#bien2_ObservationID_index,,Placeholder column created by MySQL to PostgreSQL translation
63 
bien2_OccurID_index,OMIT#bien2_OccurID_index,,Placeholder column created by MySQL to PostgreSQL translation
64 
taxonAuthorityVerbatim_index,OMIT#taxonAuthorityVerbatim_index,,Placeholder column created by MySQL to PostgreSQL translation
65 
higherPlantGroup_index,OMIT#higherPlantGroup_index,,Placeholder column created by MySQL to PostgreSQL translation
66 
family_index,OMIT#family_index,,Placeholder column created by MySQL to PostgreSQL translation
67 
genus_index,OMIT#genus_index,,Placeholder column created by MySQL to PostgreSQL translation
68 
species_index,OMIT#species_index,,Placeholder column created by MySQL to PostgreSQL translation
69 
taxon_index,OMIT#taxon_index,,Placeholder column created by MySQL to PostgreSQL translation
70 
taxonAuthor_index,OMIT#taxonAuthor_index,,Placeholder column created by MySQL to PostgreSQL translation
71 
taxonMorphospecies_index,OMIT#taxonMorphospecies_index,,Placeholder column created by MySQL to PostgreSQL translation
72 
rank_index,OMIT#rank_index,,Placeholder column created by MySQL to PostgreSQL translation
73 
acceptance_index,OMIT#acceptance_index,,Placeholder column created by MySQL to PostgreSQL translation
74 
country_index,OMIT#country_index,,Placeholder column created by MySQL to PostgreSQL translation
75 
stateProvince_index,OMIT#stateProvince_index,,Placeholder column created by MySQL to PostgreSQL translation
76 
collector_index,OMIT#collector_index,,Placeholder column created by MySQL to PostgreSQL translation
77 
identifiedBy_index,OMIT#identifiedBy_index,,Placeholder column created by MySQL to PostgreSQL translation
78 
plotCode_index,OMIT#plotCode_index,,Placeholder column created by MySQL to PostgreSQL translation
79 
plotAreaHa_index,OMIT#plotAreaHa_index,,Placeholder column created by MySQL to PostgreSQL translation
80 
plotMinDbh_index,OMIT#plotMinDbh_index,,Placeholder column created by MySQL to PostgreSQL translation
81 
plotMethod_index,OMIT#plotMethod_index,,Placeholder column created by MySQL to PostgreSQL translation
82 
isValidLatLong_index,OMIT#isValidLatLong_index,,Placeholder column created by MySQL to PostgreSQL translation
83 
isGeovalid_index,OMIT#isGeovalid_index,,Placeholder column created by MySQL to PostgreSQL translation
84 
isNewWorld_index,OMIT#isNewWorld_index,,Placeholder column created by MySQL to PostgreSQL translation
85 
isCultivated_index,OMIT#isCultivated_index,,Placeholder column created by MySQL to PostgreSQL translation
86 
isCultivatedReason_index,OMIT#isCultivatedReason_index,,Placeholder column created by MySQL to PostgreSQL translation
87 
bien2_TraitObservationID_index,OMIT#bien2_TraitObservationID_index,,Placeholder column created by MySQL to PostgreSQL translation
88 
traitName_index,OMIT#traitName_index,,Placeholder column created by MySQL to PostgreSQL translation
89 
traitMethod_index,OMIT#traitMethod_index,,Placeholder column created by MySQL to PostgreSQL translation
90 
traitUnit_index,OMIT#traitUnit_index,,Placeholder column created by MySQL to PostgreSQL translation
inputs/bien_web/observation/new_terms.csv
9 9 
isCultivated,cultivated,,
10 10 
isCultivatedReason,cultivatedBasis,,
11 11 
pctCover,coverPercent,,
12 
observationID_index,OMIT#observationID_index,,Placeholder column created by MySQL to PostgreSQL translation
13 
dataSourceID_index,OMIT#dataSourceID_index,,Placeholder column created by MySQL to PostgreSQL translation
14 
dataSourceName_index,OMIT#dataSourceName_index,,Placeholder column created by MySQL to PostgreSQL translation
15 
dataSourceNamePrimary_index,OMIT#dataSourceNamePrimary_index,,Placeholder column created by MySQL to PostgreSQL translation
16 
plotID_index,OMIT#plotID_index,,Placeholder column created by MySQL to PostgreSQL translation
17 
observationType_index,OMIT#observationType_index,,Placeholder column created by MySQL to PostgreSQL translation
18 
bien2_taxonomyID_index,OMIT#bien2_taxonomyID_index,,Placeholder column created by MySQL to PostgreSQL translation
19 
bien2_DBPlotID_index,OMIT#bien2_DBPlotID_index,,Placeholder column created by MySQL to PostgreSQL translation
20 
bien2_ObservationID_index,OMIT#bien2_ObservationID_index,,Placeholder column created by MySQL to PostgreSQL translation
21 
bien2_OccurID_index,OMIT#bien2_OccurID_index,,Placeholder column created by MySQL to PostgreSQL translation
22 
taxonAuthorityVerbatim_index,OMIT#taxonAuthorityVerbatim_index,,Placeholder column created by MySQL to PostgreSQL translation
23 
higherPlantGroup_index,OMIT#higherPlantGroup_index,,Placeholder column created by MySQL to PostgreSQL translation
24 
family_index,OMIT#family_index,,Placeholder column created by MySQL to PostgreSQL translation
25 
genus_index,OMIT#genus_index,,Placeholder column created by MySQL to PostgreSQL translation
26 
species_index,OMIT#species_index,,Placeholder column created by MySQL to PostgreSQL translation
27 
taxon_index,OMIT#taxon_index,,Placeholder column created by MySQL to PostgreSQL translation
28 
taxonAuthor_index,OMIT#taxonAuthor_index,,Placeholder column created by MySQL to PostgreSQL translation
29 
taxonMorphospecies_index,OMIT#taxonMorphospecies_index,,Placeholder column created by MySQL to PostgreSQL translation
30 
rank_index,OMIT#rank_index,,Placeholder column created by MySQL to PostgreSQL translation
31 
acceptance_index,OMIT#acceptance_index,,Placeholder column created by MySQL to PostgreSQL translation
32 
country_index,OMIT#country_index,,Placeholder column created by MySQL to PostgreSQL translation
33 
stateProvince_index,OMIT#stateProvince_index,,Placeholder column created by MySQL to PostgreSQL translation
34 
collector_index,OMIT#collector_index,,Placeholder column created by MySQL to PostgreSQL translation
35 
identifiedBy_index,OMIT#identifiedBy_index,,Placeholder column created by MySQL to PostgreSQL translation
36 
plotCode_index,OMIT#plotCode_index,,Placeholder column created by MySQL to PostgreSQL translation
37 
plotAreaHa_index,OMIT#plotAreaHa_index,,Placeholder column created by MySQL to PostgreSQL translation
38 
plotMinDbh_index,OMIT#plotMinDbh_index,,Placeholder column created by MySQL to PostgreSQL translation
39 
plotMethod_index,OMIT#plotMethod_index,,Placeholder column created by MySQL to PostgreSQL translation
40 
isValidLatLong_index,OMIT#isValidLatLong_index,,Placeholder column created by MySQL to PostgreSQL translation
41 
isGeovalid_index,OMIT#isGeovalid_index,,Placeholder column created by MySQL to PostgreSQL translation
42 
isNewWorld_index,OMIT#isNewWorld_index,,Placeholder column created by MySQL to PostgreSQL translation
43 
isCultivated_index,OMIT#isCultivated_index,,Placeholder column created by MySQL to PostgreSQL translation
44 
isCultivatedReason_index,OMIT#isCultivatedReason_index,,Placeholder column created by MySQL to PostgreSQL translation
45 
bien2_TraitObservationID_index,OMIT#bien2_TraitObservationID_index,,Placeholder column created by MySQL to PostgreSQL translation
46 
traitName_index,OMIT#traitName_index,,Placeholder column created by MySQL to PostgreSQL translation
47 
traitMethod_index,OMIT#traitMethod_index,,Placeholder column created by MySQL to PostgreSQL translation
48 
traitUnit_index,OMIT#traitUnit_index,,Placeholder column created by MySQL to PostgreSQL translation

Also available in: Unified diff