Revision 1064
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.my.sql | ||
|---|---|---|
| 732 | 732 |
previous_id int(11), |
| 733 | 733 |
dateaccuracy text, |
| 734 | 734 |
plotmethod_id int(11), |
| 735 |
methodnarrative text, |
|
| 736 |
taxonoccurrencearea double precision, |
|
| 737 |
coverdispersion text, |
|
| 738 | 735 |
autotaxoncover int(1), |
| 739 |
stemsizelimit double precision, |
|
| 740 |
stemarea double precision, |
|
| 741 |
stemsamplemethod text, |
|
| 742 | 736 |
originaldata text, |
| 743 | 737 |
effortlevel text, |
| 744 |
locationvalidationlevel int(11), |
|
| 745 | 738 |
floristicquality text, |
| 746 | 739 |
bryophytequality text, |
| 747 | 740 |
lichenquality text, |
| ... | ... | |
| 905 | 898 |
observationmeasureunits text, |
| 906 | 899 |
taxonclassincluded text, |
| 907 | 900 |
taxonclassexcluded text, |
| 908 |
covermethod_id int(11) |
|
| 901 |
covermethod_id int(11), |
|
| 902 |
samplingfactor double precision DEFAULT 1 NOT NULL, |
|
| 903 |
coverbasis text, |
|
| 904 |
stemsamplemethod text |
|
| 909 | 905 |
); |
| 910 | 906 |
|
| 911 | 907 |
|
| ... | ... | |
| 917 | 913 |
|
| 918 | 914 |
|
| 919 | 915 |
-- |
| 916 |
-- Name: COLUMN method.name; Type: COMMENT; Schema: public; Owner: - |
|
| 917 |
-- |
|
| 918 |
|
|
| 919 |
|
|
| 920 |
|
|
| 921 |
|
|
| 922 |
-- |
|
| 923 |
-- Name: COLUMN method.description; Type: COMMENT; Schema: public; Owner: - |
|
| 924 |
-- |
|
| 925 |
|
|
| 926 |
|
|
| 927 |
|
|
| 928 |
|
|
| 929 |
-- |
|
| 920 | 930 |
-- Name: COLUMN method.lengthunits; Type: COMMENT; Schema: public; Owner: - |
| 921 | 931 |
-- |
| 922 | 932 |
|
| ... | ... | |
| 924 | 934 |
|
| 925 | 935 |
|
| 926 | 936 |
-- |
| 937 |
-- Name: COLUMN method.mindiameter; Type: COMMENT; Schema: public; Owner: - |
|
| 938 |
-- |
|
| 939 |
|
|
| 940 |
|
|
| 941 |
|
|
| 942 |
|
|
| 943 |
-- |
|
| 944 |
-- Name: COLUMN method.minheight; Type: COMMENT; Schema: public; Owner: - |
|
| 945 |
-- |
|
| 946 |
|
|
| 947 |
|
|
| 948 |
|
|
| 949 |
|
|
| 950 |
-- |
|
| 951 |
-- Name: COLUMN method.maxdiameter; Type: COMMENT; Schema: public; Owner: - |
|
| 952 |
-- |
|
| 953 |
|
|
| 954 |
|
|
| 955 |
|
|
| 956 |
|
|
| 957 |
-- |
|
| 958 |
-- Name: COLUMN method.maxheight; Type: COMMENT; Schema: public; Owner: - |
|
| 959 |
-- |
|
| 960 |
|
|
| 961 |
|
|
| 962 |
|
|
| 963 |
|
|
| 964 |
-- |
|
| 927 | 965 |
-- Name: COLUMN method.observationtype; Type: COMMENT; Schema: public; Owner: - |
| 928 | 966 |
-- |
| 929 | 967 |
|
| ... | ... | |
| 959 | 997 |
|
| 960 | 998 |
|
| 961 | 999 |
-- |
| 1000 |
-- Name: COLUMN method.samplingfactor; Type: COMMENT; Schema: public; Owner: - |
|
| 1001 |
-- |
|
| 1002 |
|
|
| 1003 |
|
|
| 1004 |
|
|
| 1005 |
|
|
| 1006 |
-- |
|
| 1007 |
-- Name: COLUMN method.coverbasis; Type: COMMENT; Schema: public; Owner: - |
|
| 1008 |
-- |
|
| 1009 |
|
|
| 1010 |
|
|
| 1011 |
|
|
| 1012 |
|
|
| 1013 |
-- |
|
| 1014 |
-- Name: COLUMN method.stemsamplemethod; Type: COMMENT; Schema: public; Owner: - |
|
| 1015 |
-- |
|
| 1016 |
|
|
| 1017 |
|
|
| 1018 |
|
|
| 1019 |
|
|
| 1020 |
-- |
|
| 962 | 1021 |
-- Name: method_method_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 963 | 1022 |
-- |
| 964 | 1023 |
|
| ... | ... | |
| 1442 | 1501 |
length double precision, |
| 1443 | 1502 |
width double precision, |
| 1444 | 1503 |
radius double precision, |
| 1445 |
area double precision |
|
| 1504 |
area double precision, |
|
| 1505 |
samplearea double precision |
|
| 1446 | 1506 |
); |
| 1447 | 1507 |
|
| 1448 | 1508 |
|
| ... | ... | |
| 1461 | 1521 |
|
| 1462 | 1522 |
|
| 1463 | 1523 |
-- |
| 1524 |
-- Name: COLUMN plotmethod.description; Type: COMMENT; Schema: public; Owner: - |
|
| 1525 |
-- |
|
| 1526 |
|
|
| 1527 |
|
|
| 1528 |
|
|
| 1529 |
|
|
| 1530 |
-- |
|
| 1464 | 1531 |
-- Name: COLUMN plotmethod.shape; Type: COMMENT; Schema: public; Owner: - |
| 1465 | 1532 |
-- |
| 1466 | 1533 |
|
| ... | ... | |
| 1468 | 1535 |
|
| 1469 | 1536 |
|
| 1470 | 1537 |
-- |
| 1538 |
-- Name: COLUMN plotmethod.length; Type: COMMENT; Schema: public; Owner: - |
|
| 1539 |
-- |
|
| 1540 |
|
|
| 1541 |
|
|
| 1542 |
|
|
| 1543 |
|
|
| 1544 |
-- |
|
| 1545 |
-- Name: COLUMN plotmethod.width; Type: COMMENT; Schema: public; Owner: - |
|
| 1546 |
-- |
|
| 1547 |
|
|
| 1548 |
|
|
| 1549 |
|
|
| 1550 |
|
|
| 1551 |
-- |
|
| 1552 |
-- Name: COLUMN plotmethod.radius; Type: COMMENT; Schema: public; Owner: - |
|
| 1553 |
-- |
|
| 1554 |
|
|
| 1555 |
|
|
| 1556 |
|
|
| 1557 |
|
|
| 1558 |
-- |
|
| 1559 |
-- Name: COLUMN plotmethod.area; Type: COMMENT; Schema: public; Owner: - |
|
| 1560 |
-- |
|
| 1561 |
|
|
| 1562 |
|
|
| 1563 |
|
|
| 1564 |
|
|
| 1565 |
-- |
|
| 1566 |
-- Name: COLUMN plotmethod.samplearea; Type: COMMENT; Schema: public; Owner: - |
|
| 1567 |
-- |
|
| 1568 |
|
|
| 1569 |
|
|
| 1570 |
|
|
| 1571 |
|
|
| 1572 |
-- |
|
| 1471 | 1573 |
-- Name: plotmethod_plotmethod_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 1472 | 1574 |
-- |
| 1473 | 1575 |
|
Also available in: Unified diff
vegbien.sql: Moved locationevent method fields to plotmethod and method. Added comments to method/plotmethod fields, as provided by Michael Lee.