Revision 13688
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 4208 | 4208 |
|
| 4209 | 4209 |
|
| 4210 | 4210 |
-- |
| 4211 |
-- Name: COLUMN analytical_stem_view.`stateProvince@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4212 |
-- |
|
| 4213 |
|
|
| 4214 |
|
|
| 4215 |
|
|
| 4216 |
|
|
| 4217 |
-- |
|
| 4218 |
-- Name: COLUMN analytical_stem_view.`county@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4219 |
-- |
|
| 4220 |
|
|
| 4221 |
|
|
| 4222 |
|
|
| 4223 |
|
|
| 4224 |
-- |
|
| 4225 |
-- Name: COLUMN analytical_stem_view.`locality@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4226 |
-- |
|
| 4227 |
|
|
| 4228 |
|
|
| 4229 |
|
|
| 4230 |
|
|
| 4231 |
-- |
|
| 4232 |
-- Name: COLUMN analytical_stem_view.`decimalLatitude@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4233 |
-- |
|
| 4234 |
|
|
| 4235 |
|
|
| 4236 |
|
|
| 4237 |
|
|
| 4238 |
-- |
|
| 4239 |
-- Name: COLUMN analytical_stem_view.`decimalLongitude@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4240 |
-- |
|
| 4241 |
|
|
| 4242 |
|
|
| 4243 |
|
|
| 4244 |
|
|
| 4245 |
-- |
|
| 4246 |
-- Name: COLUMN analytical_stem_view.`coordinateUncertaintyInMeters@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4247 |
-- |
|
| 4248 |
|
|
| 4249 |
|
|
| 4250 |
|
|
| 4251 |
|
|
| 4252 |
-- |
|
| 4211 | 4253 |
-- Name: COLUMN analytical_stem_view.`coordinateSource_bien`; Type: COMMENT; Schema: public; Owner: - |
| 4212 | 4254 |
-- |
| 4213 | 4255 |
|
| ... | ... | |
| 4250 | 4292 |
|
| 4251 | 4293 |
|
| 4252 | 4294 |
-- |
| 4295 |
-- Name: COLUMN analytical_stem_view.`locationID@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4296 |
-- |
|
| 4297 |
|
|
| 4298 |
|
|
| 4299 |
|
|
| 4300 |
|
|
| 4301 |
-- |
|
| 4253 | 4302 |
-- Name: COLUMN analytical_stem_view.`subplot@SALVIAS@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
| 4254 | 4303 |
-- |
| 4255 | 4304 |
|
| ... | ... | |
| 4271 | 4320 |
|
| 4272 | 4321 |
|
| 4273 | 4322 |
-- |
| 4323 |
-- Name: COLUMN analytical_stem_view.`eventDate@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4324 |
-- |
|
| 4325 |
|
|
| 4326 |
|
|
| 4327 |
|
|
| 4328 |
|
|
| 4329 |
-- |
|
| 4274 | 4330 |
-- Name: COLUMN analytical_stem_view.`elevationInMeters`; Type: COMMENT; Schema: public; Owner: - |
| 4275 | 4331 |
-- |
| 4276 | 4332 |
|
| ... | ... | |
| 4285 | 4341 |
|
| 4286 | 4342 |
|
| 4287 | 4343 |
-- |
| 4344 |
-- Name: COLUMN analytical_stem_view.`samplingProtocol@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4345 |
-- |
|
| 4346 |
|
|
| 4347 |
|
|
| 4348 |
|
|
| 4349 |
|
|
| 4350 |
-- |
|
| 4288 | 4351 |
-- Name: COLUMN analytical_stem_view.`temperature_C`; Type: COMMENT; Schema: public; Owner: - |
| 4289 | 4352 |
-- |
| 4290 | 4353 |
|
| ... | ... | |
| 4341 | 4404 |
|
| 4342 | 4405 |
|
| 4343 | 4406 |
-- |
| 4407 |
-- Name: COLUMN analytical_stem_view.`occurrenceID@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4408 |
-- |
|
| 4409 |
|
|
| 4410 |
|
|
| 4411 |
|
|
| 4412 |
|
|
| 4413 |
-- |
|
| 4414 |
-- Name: COLUMN analytical_stem_view.`recordedBy@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4415 |
-- |
|
| 4416 |
|
|
| 4417 |
|
|
| 4418 |
|
|
| 4419 |
|
|
| 4420 |
-- |
|
| 4421 |
-- Name: COLUMN analytical_stem_view.`recordNumber@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4422 |
-- |
|
| 4423 |
|
|
| 4424 |
|
|
| 4425 |
|
|
| 4426 |
|
|
| 4427 |
-- |
|
| 4344 | 4428 |
-- Name: COLUMN analytical_stem_view.`dateCollected`; Type: COMMENT; Schema: public; Owner: - |
| 4345 | 4429 |
-- |
| 4346 | 4430 |
|
| ... | ... | |
| 4362 | 4446 |
|
| 4363 | 4447 |
|
| 4364 | 4448 |
-- |
| 4449 |
-- Name: COLUMN analytical_stem_view.`identifiedBy@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4450 |
-- |
|
| 4451 |
|
|
| 4452 |
|
|
| 4453 |
|
|
| 4454 |
|
|
| 4455 |
-- |
|
| 4456 |
-- Name: COLUMN analytical_stem_view.`dateIdentified@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4457 |
-- |
|
| 4458 |
|
|
| 4459 |
|
|
| 4460 |
|
|
| 4461 |
|
|
| 4462 |
-- |
|
| 4463 |
-- Name: COLUMN analytical_stem_view.`identificationRemarks@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4464 |
-- |
|
| 4465 |
|
|
| 4466 |
|
|
| 4467 |
|
|
| 4468 |
|
|
| 4469 |
-- |
|
| 4365 | 4470 |
-- Name: COLUMN analytical_stem_view.`Family_matched@TNRS@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
| 4366 | 4471 |
-- |
| 4367 | 4472 |
|
| ... | ... | |
| 4460 | 4565 |
|
| 4461 | 4566 |
|
| 4462 | 4567 |
-- |
| 4568 |
-- Name: COLUMN analytical_stem_view.`reproductiveCondition@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4569 |
-- |
|
| 4570 |
|
|
| 4571 |
|
|
| 4572 |
|
|
| 4573 |
|
|
| 4574 |
-- |
|
| 4463 | 4575 |
-- Name: COLUMN analytical_stem_view.threatened_bien; Type: COMMENT; Schema: public; Owner: - |
| 4464 | 4576 |
-- |
| 4465 | 4577 |
|
| ... | ... | |
| 4481 | 4593 |
|
| 4482 | 4594 |
|
| 4483 | 4595 |
-- |
| 4596 |
-- Name: COLUMN analytical_stem_view.`occurrenceRemarks@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4597 |
-- |
|
| 4598 |
|
|
| 4599 |
|
|
| 4600 |
|
|
| 4601 |
|
|
| 4602 |
-- |
|
| 4484 | 4603 |
-- Name: COLUMN analytical_stem_view.`diameterBreastHeight_cm`; Type: COMMENT; Schema: public; Owner: - |
| 4485 | 4604 |
-- |
| 4486 | 4605 |
|
| ... | ... | |
| 4551 | 4670 |
|
| 4552 | 4671 |
|
| 4553 | 4672 |
-- |
| 4673 |
-- Name: COLUMN analytical_stem_view.`individualCount@DwC@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
|
| 4674 |
-- |
|
| 4675 |
|
|
| 4676 |
|
|
| 4677 |
|
|
| 4678 |
|
|
| 4679 |
-- |
|
| 4554 | 4680 |
-- Name: COLUMN analytical_stem_view.`stemCode@stemlocation@VegBank@vegpath.org`; Type: COMMENT; Schema: public; Owner: - |
| 4555 | 4681 |
-- |
| 4556 | 4682 |
|
| trunk/schemas/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 |
|
| trunk/schemas/vegbien.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