Revision 13685
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 6859 | 6859 |
-- Name: COLUMN analytical_stem_view."stateProvince"; Type: COMMENT; Schema: public; Owner: - |
| 6860 | 6860 |
-- |
| 6861 | 6861 |
|
| 6862 |
COMMENT ON COLUMN analytical_stem_view."stateProvince" IS 'from DwC';
|
|
| 6862 |
COMMENT ON COLUMN analytical_stem_view."stateProvince" IS 'stateProvince@DwC@vegpath.org';
|
|
| 6863 | 6863 |
|
| 6864 | 6864 |
|
| 6865 | 6865 |
-- |
| 6866 | 6866 |
-- Name: COLUMN analytical_stem_view.county; Type: COMMENT; Schema: public; Owner: - |
| 6867 | 6867 |
-- |
| 6868 | 6868 |
|
| 6869 |
COMMENT ON COLUMN analytical_stem_view.county IS 'from DwC';
|
|
| 6869 |
COMMENT ON COLUMN analytical_stem_view.county IS 'county@DwC@vegpath.org';
|
|
| 6870 | 6870 |
|
| 6871 | 6871 |
|
| 6872 | 6872 |
-- |
| 6873 | 6873 |
-- Name: COLUMN analytical_stem_view.locality; Type: COMMENT; Schema: public; Owner: - |
| 6874 | 6874 |
-- |
| 6875 | 6875 |
|
| 6876 |
COMMENT ON COLUMN analytical_stem_view.locality IS 'from DwC';
|
|
| 6876 |
COMMENT ON COLUMN analytical_stem_view.locality IS 'locality@DwC@vegpath.org';
|
|
| 6877 | 6877 |
|
| 6878 | 6878 |
|
| 6879 | 6879 |
-- |
| 6880 | 6880 |
-- Name: COLUMN analytical_stem_view."decimalLatitude"; Type: COMMENT; Schema: public; Owner: - |
| 6881 | 6881 |
-- |
| 6882 | 6882 |
|
| 6883 |
COMMENT ON COLUMN analytical_stem_view."decimalLatitude" IS 'from DwC';
|
|
| 6883 |
COMMENT ON COLUMN analytical_stem_view."decimalLatitude" IS 'decimalLatitude@DwC@vegpath.org';
|
|
| 6884 | 6884 |
|
| 6885 | 6885 |
|
| 6886 | 6886 |
-- |
| 6887 | 6887 |
-- Name: COLUMN analytical_stem_view."decimalLongitude"; Type: COMMENT; Schema: public; Owner: - |
| 6888 | 6888 |
-- |
| 6889 | 6889 |
|
| 6890 |
COMMENT ON COLUMN analytical_stem_view."decimalLongitude" IS 'from DwC';
|
|
| 6890 |
COMMENT ON COLUMN analytical_stem_view."decimalLongitude" IS 'decimalLongitude@DwC@vegpath.org';
|
|
| 6891 | 6891 |
|
| 6892 | 6892 |
|
| 6893 | 6893 |
-- |
| 6894 | 6894 |
-- Name: COLUMN analytical_stem_view."coordinateUncertaintyInMeters"; Type: COMMENT; Schema: public; Owner: - |
| 6895 | 6895 |
-- |
| 6896 | 6896 |
|
| 6897 |
COMMENT ON COLUMN analytical_stem_view."coordinateUncertaintyInMeters" IS 'from DwC';
|
|
| 6897 |
COMMENT ON COLUMN analytical_stem_view."coordinateUncertaintyInMeters" IS 'coordinateUncertaintyInMeters@DwC@vegpath.org';
|
|
| 6898 | 6898 |
|
| 6899 | 6899 |
|
| 6900 | 6900 |
-- |
| ... | ... | |
| 6943 | 6943 |
-- Name: COLUMN analytical_stem_view."locationID"; Type: COMMENT; Schema: public; Owner: - |
| 6944 | 6944 |
-- |
| 6945 | 6945 |
|
| 6946 |
COMMENT ON COLUMN analytical_stem_view."locationID" IS 'from DwC';
|
|
| 6946 |
COMMENT ON COLUMN analytical_stem_view."locationID" IS 'locationID@DwC@vegpath.org';
|
|
| 6947 | 6947 |
|
| 6948 | 6948 |
|
| 6949 | 6949 |
-- |
| 6950 | 6950 |
-- Name: COLUMN analytical_stem_view."locationName"; Type: COMMENT; Schema: public; Owner: - |
| 6951 | 6951 |
-- |
| 6952 | 6952 |
|
| 6953 |
COMMENT ON COLUMN analytical_stem_view."locationName" IS 'from DwC';
|
|
| 6953 |
COMMENT ON COLUMN analytical_stem_view."locationName" IS 'locationName@DwC@vegpath.org';
|
|
| 6954 | 6954 |
|
| 6955 | 6955 |
|
| 6956 | 6956 |
-- |
| ... | ... | |
| 6978 | 6978 |
-- Name: COLUMN analytical_stem_view."eventDate"; Type: COMMENT; Schema: public; Owner: - |
| 6979 | 6979 |
-- |
| 6980 | 6980 |
|
| 6981 |
COMMENT ON COLUMN analytical_stem_view."eventDate" IS 'from DwC';
|
|
| 6981 |
COMMENT ON COLUMN analytical_stem_view."eventDate" IS 'eventDate@DwC@vegpath.org';
|
|
| 6982 | 6982 |
|
| 6983 | 6983 |
|
| 6984 | 6984 |
-- |
| ... | ... | |
| 6992 | 6992 |
-- Name: COLUMN analytical_stem_view."slopeAspect"; Type: COMMENT; Schema: public; Owner: - |
| 6993 | 6993 |
-- |
| 6994 | 6994 |
|
| 6995 |
COMMENT ON COLUMN analytical_stem_view."slopeAspect" IS 'from VegX';
|
|
| 6995 |
COMMENT ON COLUMN analytical_stem_view."slopeAspect" IS 'slopeAspect@VegX@vegpath.org';
|
|
| 6996 | 6996 |
|
| 6997 | 6997 |
|
| 6998 | 6998 |
-- |
| 6999 | 6999 |
-- Name: COLUMN analytical_stem_view."slopeGradient"; Type: COMMENT; Schema: public; Owner: - |
| 7000 | 7000 |
-- |
| 7001 | 7001 |
|
| 7002 |
COMMENT ON COLUMN analytical_stem_view."slopeGradient" IS 'from VegX';
|
|
| 7002 |
COMMENT ON COLUMN analytical_stem_view."slopeGradient" IS 'slopeGradient@VegX@vegpath.org';
|
|
| 7003 | 7003 |
|
| 7004 | 7004 |
|
| 7005 | 7005 |
-- |
| ... | ... | |
| 7013 | 7013 |
-- Name: COLUMN analytical_stem_view."samplingProtocol"; Type: COMMENT; Schema: public; Owner: - |
| 7014 | 7014 |
-- |
| 7015 | 7015 |
|
| 7016 |
COMMENT ON COLUMN analytical_stem_view."samplingProtocol" IS 'from DwC';
|
|
| 7016 |
COMMENT ON COLUMN analytical_stem_view."samplingProtocol" IS 'samplingProtocol@DwC@vegpath.org';
|
|
| 7017 | 7017 |
|
| 7018 | 7018 |
|
| 7019 | 7019 |
-- |
| ... | ... | |
| 7076 | 7076 |
-- Name: COLUMN analytical_stem_view."occurrenceID"; Type: COMMENT; Schema: public; Owner: - |
| 7077 | 7077 |
-- |
| 7078 | 7078 |
|
| 7079 |
COMMENT ON COLUMN analytical_stem_view."occurrenceID" IS 'from DwC';
|
|
| 7079 |
COMMENT ON COLUMN analytical_stem_view."occurrenceID" IS 'occurrenceID@DwC@vegpath.org';
|
|
| 7080 | 7080 |
|
| 7081 | 7081 |
|
| 7082 | 7082 |
-- |
| 7083 | 7083 |
-- Name: COLUMN analytical_stem_view."recordedBy"; Type: COMMENT; Schema: public; Owner: - |
| 7084 | 7084 |
-- |
| 7085 | 7085 |
|
| 7086 |
COMMENT ON COLUMN analytical_stem_view."recordedBy" IS 'from DwC';
|
|
| 7086 |
COMMENT ON COLUMN analytical_stem_view."recordedBy" IS 'recordedBy@DwC@vegpath.org';
|
|
| 7087 | 7087 |
|
| 7088 | 7088 |
|
| 7089 | 7089 |
-- |
| 7090 | 7090 |
-- Name: COLUMN analytical_stem_view."recordNumber"; Type: COMMENT; Schema: public; Owner: - |
| 7091 | 7091 |
-- |
| 7092 | 7092 |
|
| 7093 |
COMMENT ON COLUMN analytical_stem_view."recordNumber" IS 'from DwC';
|
|
| 7093 |
COMMENT ON COLUMN analytical_stem_view."recordNumber" IS 'recordNumber@DwC@vegpath.org';
|
|
| 7094 | 7094 |
|
| 7095 | 7095 |
|
| 7096 | 7096 |
-- |
| ... | ... | |
| 7118 | 7118 |
-- Name: COLUMN analytical_stem_view."identifiedBy"; Type: COMMENT; Schema: public; Owner: - |
| 7119 | 7119 |
-- |
| 7120 | 7120 |
|
| 7121 |
COMMENT ON COLUMN analytical_stem_view."identifiedBy" IS 'from DwC';
|
|
| 7121 |
COMMENT ON COLUMN analytical_stem_view."identifiedBy" IS 'identifiedBy@DwC@vegpath.org';
|
|
| 7122 | 7122 |
|
| 7123 | 7123 |
|
| 7124 | 7124 |
-- |
| 7125 | 7125 |
-- Name: COLUMN analytical_stem_view."dateIdentified"; Type: COMMENT; Schema: public; Owner: - |
| 7126 | 7126 |
-- |
| 7127 | 7127 |
|
| 7128 |
COMMENT ON COLUMN analytical_stem_view."dateIdentified" IS 'from DwC';
|
|
| 7128 |
COMMENT ON COLUMN analytical_stem_view."dateIdentified" IS 'dateIdentified@DwC@vegpath.org';
|
|
| 7129 | 7129 |
|
| 7130 | 7130 |
|
| 7131 | 7131 |
-- |
| 7132 | 7132 |
-- Name: COLUMN analytical_stem_view."identificationRemarks"; Type: COMMENT; Schema: public; Owner: - |
| 7133 | 7133 |
-- |
| 7134 | 7134 |
|
| 7135 |
COMMENT ON COLUMN analytical_stem_view."identificationRemarks" IS 'from DwC';
|
|
| 7135 |
COMMENT ON COLUMN analytical_stem_view."identificationRemarks" IS 'identificationRemarks@DwC@vegpath.org';
|
|
| 7136 | 7136 |
|
| 7137 | 7137 |
|
| 7138 | 7138 |
-- |
| ... | ... | |
| 7237 | 7237 |
-- Name: COLUMN analytical_stem_view."reproductiveCondition"; Type: COMMENT; Schema: public; Owner: - |
| 7238 | 7238 |
-- |
| 7239 | 7239 |
|
| 7240 |
COMMENT ON COLUMN analytical_stem_view."reproductiveCondition" IS 'from DwC';
|
|
| 7240 |
COMMENT ON COLUMN analytical_stem_view."reproductiveCondition" IS 'reproductiveCondition@DwC@vegpath.org';
|
|
| 7241 | 7241 |
|
| 7242 | 7242 |
|
| 7243 | 7243 |
-- |
| ... | ... | |
| 7265 | 7265 |
-- Name: COLUMN analytical_stem_view."occurrenceRemarks"; Type: COMMENT; Schema: public; Owner: - |
| 7266 | 7266 |
-- |
| 7267 | 7267 |
|
| 7268 |
COMMENT ON COLUMN analytical_stem_view."occurrenceRemarks" IS 'from DwC';
|
|
| 7268 |
COMMENT ON COLUMN analytical_stem_view."occurrenceRemarks" IS 'occurrenceRemarks@DwC@vegpath.org';
|
|
| 7269 | 7269 |
|
| 7270 | 7270 |
|
| 7271 | 7271 |
-- |
| 7272 | 7272 |
-- Name: COLUMN analytical_stem_view."coverPercent"; Type: COMMENT; Schema: public; Owner: - |
| 7273 | 7273 |
-- |
| 7274 | 7274 |
|
| 7275 |
COMMENT ON COLUMN analytical_stem_view."coverPercent" IS 'from VegX';
|
|
| 7275 |
COMMENT ON COLUMN analytical_stem_view."coverPercent" IS 'coverPercent@VegX@vegpath.org';
|
|
| 7276 | 7276 |
|
| 7277 | 7277 |
|
| 7278 | 7278 |
-- |
| ... | ... | |
| 7349 | 7349 |
-- Name: COLUMN analytical_stem_view."individualCount"; Type: COMMENT; Schema: public; Owner: - |
| 7350 | 7350 |
-- |
| 7351 | 7351 |
|
| 7352 |
COMMENT ON COLUMN analytical_stem_view."individualCount" IS 'from DwC';
|
|
| 7352 |
COMMENT ON COLUMN analytical_stem_view."individualCount" IS 'individualCount@DwC@vegpath.org';
|
|
| 7353 | 7353 |
|
| 7354 | 7354 |
|
| 7355 | 7355 |
-- |
Also available in: Unified diff
schemas/public_.sql: analytical_stem_view: populated links from unrenamed term names, using the steps at wiki.vegpath.org/VegBIEN_schema_refactoring#data-dictionary-populate-links-from-unrenamed-term-names