Revision 13688
Added by Aaron Marcuse-Kubitza over 10 years ago
public_.sql | ||
---|---|---|
6856 | 6856 |
|
6857 | 6857 |
|
6858 | 6858 |
-- |
6859 |
-- Name: COLUMN analytical_stem_view."stateProvince@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
6860 |
-- |
|
6861 |
|
|
6862 |
COMMENT ON COLUMN analytical_stem_view."stateProvince@DwC@vegpath.org" IS '"The name of the next smaller administrative region than country (state, province, canton, department, region, etc.) in which the Location occurs"'; |
|
6863 |
|
|
6864 |
|
|
6865 |
-- |
|
6866 |
-- Name: COLUMN analytical_stem_view."county@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
6867 |
-- |
|
6868 |
|
|
6869 |
COMMENT ON COLUMN analytical_stem_view."county@DwC@vegpath.org" IS '"The full, unabbreviated name of the next smaller administrative region than stateProvince (county, shire, department, etc.) in which the Location occurs"'; |
|
6870 |
|
|
6871 |
|
|
6872 |
-- |
|
6873 |
-- Name: COLUMN analytical_stem_view."locality@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
6874 |
-- |
|
6875 |
|
|
6876 |
COMMENT ON COLUMN analytical_stem_view."locality@DwC@vegpath.org" IS '"The specific description of the place"'; |
|
6877 |
|
|
6878 |
|
|
6879 |
-- |
|
6880 |
-- Name: COLUMN analytical_stem_view."decimalLatitude@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
6881 |
-- |
|
6882 |
|
|
6883 |
COMMENT ON COLUMN analytical_stem_view."decimalLatitude@DwC@vegpath.org" IS '"The geographic latitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"'; |
|
6884 |
|
|
6885 |
|
|
6886 |
-- |
|
6887 |
-- Name: COLUMN analytical_stem_view."decimalLongitude@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
6888 |
-- |
|
6889 |
|
|
6890 |
COMMENT ON COLUMN analytical_stem_view."decimalLongitude@DwC@vegpath.org" IS '"The geographic longitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location"'; |
|
6891 |
|
|
6892 |
|
|
6893 |
-- |
|
6894 |
-- Name: COLUMN analytical_stem_view."coordinateUncertaintyInMeters@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
6895 |
-- |
|
6896 |
|
|
6897 |
COMMENT ON COLUMN analytical_stem_view."coordinateUncertaintyInMeters@DwC@vegpath.org" IS '"The horizontal distance (in meters) from the given decimalLatitude and decimalLongitude describing the smallest circle containing the whole of the Location"'; |
|
6898 |
|
|
6899 |
|
|
6900 |
-- |
|
6859 | 6901 |
-- Name: COLUMN analytical_stem_view."coordinateSource_bien"; Type: COMMENT; Schema: public; Owner: - |
6860 | 6902 |
-- |
6861 | 6903 |
|
... | ... | |
6898 | 6940 |
|
6899 | 6941 |
|
6900 | 6942 |
-- |
6943 |
-- Name: COLUMN analytical_stem_view."locationID@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
6944 |
-- |
|
6945 |
|
|
6946 |
COMMENT ON COLUMN analytical_stem_view."locationID@DwC@vegpath.org" IS '"An identifier for the set of location information (data associated with dcterms:Location)"'; |
|
6947 |
|
|
6948 |
|
|
6949 |
-- |
|
6901 | 6950 |
-- Name: COLUMN analytical_stem_view."subplot@SALVIAS@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
6902 | 6951 |
-- |
6903 | 6952 |
|
... | ... | |
6919 | 6968 |
|
6920 | 6969 |
|
6921 | 6970 |
-- |
6971 |
-- Name: COLUMN analytical_stem_view."eventDate@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
6972 |
-- |
|
6973 |
|
|
6974 |
COMMENT ON COLUMN analytical_stem_view."eventDate@DwC@vegpath.org" IS '"The date-time or interval during which an Event occurred. For occurrences, this is the date-time when the event was recorded."'; |
|
6975 |
|
|
6976 |
|
|
6977 |
-- |
|
6922 | 6978 |
-- Name: COLUMN analytical_stem_view."elevationInMeters"; Type: COMMENT; Schema: public; Owner: - |
6923 | 6979 |
-- |
6924 | 6980 |
|
... | ... | |
6933 | 6989 |
|
6934 | 6990 |
|
6935 | 6991 |
-- |
6992 |
-- Name: COLUMN analytical_stem_view."samplingProtocol@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
6993 |
-- |
|
6994 |
|
|
6995 |
COMMENT ON COLUMN analytical_stem_view."samplingProtocol@DwC@vegpath.org" IS '"The name of, reference to, or description of the method or protocol used during an Event"'; |
|
6996 |
|
|
6997 |
|
|
6998 |
-- |
|
6936 | 6999 |
-- Name: COLUMN analytical_stem_view."temperature_C"; Type: COMMENT; Schema: public; Owner: - |
6937 | 7000 |
-- |
6938 | 7001 |
|
... | ... | |
6989 | 7052 |
|
6990 | 7053 |
|
6991 | 7054 |
-- |
7055 |
-- Name: COLUMN analytical_stem_view."occurrenceID@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
7056 |
-- |
|
7057 |
|
|
7058 |
COMMENT ON COLUMN analytical_stem_view."occurrenceID@DwC@vegpath.org" IS '"An identifier for the Occurrence (as opposed to a particular digital record of the occurrence). In the absence of a persistent global unique identifier, construct one from a combination of identifiers in the record that will most closely make the occurrenceID globally unique."'; |
|
7059 |
|
|
7060 |
|
|
7061 |
-- |
|
7062 |
-- Name: COLUMN analytical_stem_view."recordedBy@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
7063 |
-- |
|
7064 |
|
|
7065 |
COMMENT ON COLUMN analytical_stem_view."recordedBy@DwC@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations responsible for recording the original Occurrence. The primary collector or observer, especially one who applies a personal identifier (recordNumber), should be listed first."'; |
|
7066 |
|
|
7067 |
|
|
7068 |
-- |
|
7069 |
-- Name: COLUMN analytical_stem_view."recordNumber@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
7070 |
-- |
|
7071 |
|
|
7072 |
COMMENT ON COLUMN analytical_stem_view."recordNumber@DwC@vegpath.org" IS '"An identifier given to the Occurrence at the time it was recorded. Often serves as a link between field notes and an Occurrence record, such as a specimen collector''s number."'; |
|
7073 |
|
|
7074 |
|
|
7075 |
-- |
|
6992 | 7076 |
-- Name: COLUMN analytical_stem_view."dateCollected"; Type: COMMENT; Schema: public; Owner: - |
6993 | 7077 |
-- |
6994 | 7078 |
|
... | ... | |
7010 | 7094 |
|
7011 | 7095 |
|
7012 | 7096 |
-- |
7097 |
-- Name: COLUMN analytical_stem_view."identifiedBy@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
7098 |
-- |
|
7099 |
|
|
7100 |
COMMENT ON COLUMN analytical_stem_view."identifiedBy@DwC@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations who assigned the Taxon to the subject"'; |
|
7101 |
|
|
7102 |
|
|
7103 |
-- |
|
7104 |
-- Name: COLUMN analytical_stem_view."dateIdentified@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
7105 |
-- |
|
7106 |
|
|
7107 |
COMMENT ON COLUMN analytical_stem_view."dateIdentified@DwC@vegpath.org" IS '"The date on which the subject was identified as representing the Taxon"'; |
|
7108 |
|
|
7109 |
|
|
7110 |
-- |
|
7111 |
-- Name: COLUMN analytical_stem_view."identificationRemarks@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
7112 |
-- |
|
7113 |
|
|
7114 |
COMMENT ON COLUMN analytical_stem_view."identificationRemarks@DwC@vegpath.org" IS '"Comments or notes about the Identification"'; |
|
7115 |
|
|
7116 |
|
|
7117 |
-- |
|
7013 | 7118 |
-- Name: COLUMN analytical_stem_view."Family_matched@TNRS@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
7014 | 7119 |
-- |
7015 | 7120 |
|
... | ... | |
7108 | 7213 |
|
7109 | 7214 |
|
7110 | 7215 |
-- |
7216 |
-- Name: COLUMN analytical_stem_view."reproductiveCondition@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
7217 |
-- |
|
7218 |
|
|
7219 |
COMMENT ON COLUMN analytical_stem_view."reproductiveCondition@DwC@vegpath.org" IS '"The reproductive condition of the biological individual(s) represented in the Occurrence. Recommended best practice is to use a controlled vocabulary."'; |
|
7220 |
|
|
7221 |
|
|
7222 |
-- |
|
7111 | 7223 |
-- Name: COLUMN analytical_stem_view.threatened_bien; Type: COMMENT; Schema: public; Owner: - |
7112 | 7224 |
-- |
7113 | 7225 |
|
... | ... | |
7129 | 7241 |
|
7130 | 7242 |
|
7131 | 7243 |
-- |
7244 |
-- Name: COLUMN analytical_stem_view."occurrenceRemarks@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
7245 |
-- |
|
7246 |
|
|
7247 |
COMMENT ON COLUMN analytical_stem_view."occurrenceRemarks@DwC@vegpath.org" IS '"Comments or notes about the Occurrence"'; |
|
7248 |
|
|
7249 |
|
|
7250 |
-- |
|
7132 | 7251 |
-- Name: COLUMN analytical_stem_view."diameterBreastHeight_cm"; Type: COMMENT; Schema: public; Owner: - |
7133 | 7252 |
-- |
7134 | 7253 |
|
... | ... | |
7199 | 7318 |
|
7200 | 7319 |
|
7201 | 7320 |
-- |
7321 |
-- Name: COLUMN analytical_stem_view."individualCount@DwC@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
|
7322 |
-- |
|
7323 |
|
|
7324 |
COMMENT ON COLUMN analytical_stem_view."individualCount@DwC@vegpath.org" IS '"The number of individuals represented present at the time of the Occurrence"'; |
|
7325 |
|
|
7326 |
|
|
7327 |
-- |
|
7202 | 7328 |
-- Name: COLUMN analytical_stem_view."stemCode@stemlocation@VegBank@vegpath.org"; Type: COMMENT; Schema: public; Owner: - |
7203 | 7329 |
-- |
7204 | 7330 |
|
Also available in: Unified diff
schemas/public_.sql: analytical_stem_view: populated definitions of linked DwC terms from DwC data dictionary