Revision 3910
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 165 | 165 |
taxonoccurrence_id int(11) NOT NULL, |
| 166 | 166 |
collectiondate timestamp NULL, |
| 167 | 167 |
cover double precision, |
| 168 |
linecover double precision, |
|
| 168 | 169 |
basalarea double precision, |
| 169 | 170 |
biomass double precision, |
| 170 | 171 |
inferencearea double precision, |
| ... | ... | |
| 173 | 174 |
coverindex_id int(11), |
| 174 | 175 |
occurrencestatus_dwc text DEFAULT 'present' NOT NULL, |
| 175 | 176 |
method_id int(11), |
| 176 |
linecover double precision, |
|
| 177 | 177 |
accessioncode text |
| 178 | 178 |
); |
| 179 | 179 |
|
| ... | ... | |
| 186 | 186 |
|
| 187 | 187 |
|
| 188 | 188 |
-- |
| 189 |
-- Name: COLUMN aggregateoccurrence.occurrencestatus_dwc; Type: COMMENT; Schema: public; Owner: -
|
|
| 189 |
-- Name: COLUMN aggregateoccurrence.linecover; Type: COMMENT; Schema: public; Owner: -
|
|
| 190 | 190 |
-- |
| 191 | 191 |
|
| 192 | 192 |
|
| 193 | 193 |
|
| 194 | 194 |
|
| 195 | 195 |
-- |
| 196 |
-- Name: COLUMN aggregateoccurrence.linecover; Type: COMMENT; Schema: public; Owner: -
|
|
| 196 |
-- Name: COLUMN aggregateoccurrence.occurrencestatus_dwc; Type: COMMENT; Schema: public; Owner: -
|
|
| 197 | 197 |
-- |
| 198 | 198 |
|
| 199 | 199 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 386 | 386 |
taxonoccurrence_id integer NOT NULL, |
| 387 | 387 |
collectiondate timestamp with time zone, |
| 388 | 388 |
cover double precision, |
| 389 |
linecover double precision, |
|
| 389 | 390 |
basalarea double precision, |
| 390 | 391 |
biomass double precision, |
| 391 | 392 |
inferencearea double precision, |
| ... | ... | |
| 394 | 395 |
coverindex_id integer, |
| 395 | 396 |
occurrencestatus_dwc occurrencestatus_dwc DEFAULT 'present'::occurrencestatus_dwc NOT NULL, |
| 396 | 397 |
method_id integer, |
| 397 |
linecover double precision, |
|
| 398 | 398 |
accessioncode text |
| 399 | 399 |
); |
| 400 | 400 |
|
| ... | ... | |
| 407 | 407 |
|
| 408 | 408 |
|
| 409 | 409 |
-- |
| 410 |
-- Name: COLUMN aggregateoccurrence.occurrencestatus_dwc; Type: COMMENT; Schema: public; Owner: -
|
|
| 410 |
-- Name: COLUMN aggregateoccurrence.linecover; Type: COMMENT; Schema: public; Owner: -
|
|
| 411 | 411 |
-- |
| 412 | 412 |
|
| 413 |
COMMENT ON COLUMN aggregateoccurrence.occurrencestatus_dwc IS 'The extent to which the taxon is present. See <http://code.google.com/p/darwincore/wiki/Occurrence#occurrenceStatus>.';
|
|
| 413 |
COMMENT ON COLUMN aggregateoccurrence.linecover IS 'The distance in m along which this occurrence intercepts a line subplot.';
|
|
| 414 | 414 |
|
| 415 | 415 |
|
| 416 | 416 |
-- |
| 417 |
-- Name: COLUMN aggregateoccurrence.linecover; Type: COMMENT; Schema: public; Owner: -
|
|
| 417 |
-- Name: COLUMN aggregateoccurrence.occurrencestatus_dwc; Type: COMMENT; Schema: public; Owner: -
|
|
| 418 | 418 |
-- |
| 419 | 419 |
|
| 420 |
COMMENT ON COLUMN aggregateoccurrence.linecover IS 'The distance in m along which this occurrence intercepts a line subplot.';
|
|
| 420 |
COMMENT ON COLUMN aggregateoccurrence.occurrencestatus_dwc IS 'The extent to which the taxon is present. See <http://code.google.com/p/darwincore/wiki/Occurrence#occurrenceStatus>.';
|
|
| 421 | 421 |
|
| 422 | 422 |
|
| 423 | 423 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: aggregateoccurrence: Reordered linecover so it's near cover instead of at the end