Project

General

Profile

« Previous | Next » 

Revision 13688

schemas/public_.sql: analytical_stem_view: populated definitions of linked DwC terms from DwC data dictionary

View differences:

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