| 7078 |
7078 |
--
|
| 7079 |
7079 |
|
| 7080 |
7080 |
CREATE VIEW analytical_plot AS
|
| 7081 |
|
SELECT analytical_stem.datasource AS "datasource__@Brad__.identifier_examples@vegpath.org",
|
| 7082 |
|
analytical_stem.country AS "country__@DwC__@vegpath.org",
|
| 7083 |
|
analytical_stem.state_province AS "stateProvince__@DwC__@vegpath.org",
|
| 7084 |
|
analytical_stem.county AS "county__@DwC__@vegpath.org",
|
| 7085 |
|
analytical_stem.locality AS "locality__@DwC__@vegpath.org",
|
| 7086 |
|
analytical_stem.latitude AS "decimalLatitude__@DwC__@vegpath.org",
|
| 7087 |
|
analytical_stem.longitude AS "decimalLongitude__@DwC__@vegpath.org",
|
| 7088 |
|
analytical_stem.coord_uncertainty_m AS "coordinateUncertaintyInMeters__@DwC__@vegpath.org",
|
| 7089 |
|
analytical_stem.georef_sources AS "georeferenceSources__@DwC__@vegpath.org",
|
| 7090 |
|
analytical_stem.georef_protocol AS "georeferenceProtocol__@DwC__@vegpath.org",
|
| 7091 |
|
analytical_stem.is_geovalid AS geovalid_bien,
|
| 7092 |
|
analytical_stem.is_new_world AS "isNewWorld_bien",
|
| 7093 |
|
analytical_stem.project_id AS "projectID__@VegX__.plotObservation@vegpath.org",
|
| 7094 |
|
analytical_stem.project_contributors AS "projectContributor[s]__@VegBank__@vegpath.org",
|
| 7095 |
|
analytical_stem.location_id AS "locationID__@DwC__@vegpath.org",
|
| 7096 |
|
analytical_stem.plot_name AS "plotName__@VegX__.plot@vegpath.org",
|
| 7097 |
|
analytical_stem.subplot AS "subplot__@SALVIAS__.Plot_data@vegpath.org",
|
| 7098 |
|
analytical_stem.is_location_cultivated AS location__cultivated__bien,
|
| 7099 |
|
analytical_stem.event_date AS "eventDate__@DwC__@vegpath.org",
|
| 7100 |
|
analytical_stem.elevation_m AS "(-minimum-)ElevationInMeters__@DwC__@vegpath.org",
|
| 7101 |
|
analytical_stem.slope_aspect_deg AS "slopeAspect[_deg]__@VegX__.plot@vegpath.org",
|
| 7102 |
|
analytical_stem.slope_gradient_deg AS "slopeGradient[_deg]__@VegX__.plot@vegpath.org",
|
| 7103 |
|
analytical_stem.plot_area_ha AS "plot.area[_ha]__@VegX__@vegpath.org",
|
| 7104 |
|
analytical_stem.sampling_protocol AS "samplingProtocol__@DwC__@vegpath.org",
|
| 7105 |
|
analytical_stem.temperature_c AS "temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org",
|
| 7106 |
|
analytical_stem.precip_mm AS "precip_mm__@SALVIAS__.Plot_metadata@vegpath.org",
|
| 7107 |
|
analytical_stem.stratum_name AS "stratumName__@VegX__.stratum@vegpath.org",
|
| 7108 |
|
analytical_stem.community_concept_name AS "communityConcept.name__@VegX__.communityDet@vegpath.org",
|
| 7109 |
|
analytical_stem.observation_contributors AS "observationContributor[s]__@VegBank__@vegpath.org",
|
| 7110 |
|
analytical_stem.recorded_by AS "recordedBy__@DwC__@vegpath.org",
|
| 7111 |
|
analytical_stem.record_number AS "recordNumber__@DwC__@vegpath.org",
|
| 7112 |
|
analytical_stem.date_collected AS "(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org",
|
| 7113 |
|
analytical_stem.verbatim_family AS "[verbatim_]family__@DwC__@vegpath.org",
|
| 7114 |
|
analytical_stem.verbatim_scientific_name AS "[verbatim_]scientificName__@DwC__@vegpath.org",
|
| 7115 |
|
analytical_stem.identified_by AS "identifiedBy__@DwC__@vegpath.org",
|
| 7116 |
|
analytical_stem.date_identified AS "dateIdentified__@DwC__@vegpath.org",
|
| 7117 |
|
analytical_stem.identification_remarks AS "identificationRemarks__@DwC__@vegpath.org",
|
| 7118 |
|
analytical_stem.family_matched AS "Family_matched__@TNRS__@vegpath.org",
|
| 7119 |
|
analytical_stem.name_matched AS "Name_matched__@TNRS__@vegpath.org",
|
| 7120 |
|
analytical_stem.name_matched_author AS "Name_matched_author__@TNRS__@vegpath.org",
|
|
7081 |
SELECT analytical_stem.datasource,
|
|
7082 |
analytical_stem.country,
|
|
7083 |
analytical_stem.state_province,
|
|
7084 |
analytical_stem.county,
|
|
7085 |
analytical_stem.locality,
|
|
7086 |
analytical_stem.latitude,
|
|
7087 |
analytical_stem.longitude,
|
|
7088 |
analytical_stem.coord_uncertainty_m,
|
|
7089 |
analytical_stem.georef_sources,
|
|
7090 |
analytical_stem.georef_protocol,
|
|
7091 |
analytical_stem.is_geovalid,
|
|
7092 |
analytical_stem.is_new_world,
|
|
7093 |
analytical_stem.project_id,
|
|
7094 |
analytical_stem.project_contributors,
|
|
7095 |
analytical_stem.location_id,
|
|
7096 |
analytical_stem.plot_name,
|
|
7097 |
analytical_stem.subplot,
|
|
7098 |
analytical_stem.is_location_cultivated,
|
|
7099 |
analytical_stem.event_date,
|
|
7100 |
analytical_stem.elevation_m,
|
|
7101 |
analytical_stem.slope_aspect_deg,
|
|
7102 |
analytical_stem.slope_gradient_deg,
|
|
7103 |
analytical_stem.plot_area_ha,
|
|
7104 |
analytical_stem.sampling_protocol,
|
|
7105 |
analytical_stem.temperature_c,
|
|
7106 |
analytical_stem.precip_mm,
|
|
7107 |
analytical_stem.stratum_name,
|
|
7108 |
analytical_stem.community_concept_name,
|
|
7109 |
analytical_stem.observation_contributors,
|
|
7110 |
analytical_stem.recorded_by,
|
|
7111 |
analytical_stem.record_number,
|
|
7112 |
analytical_stem.date_collected,
|
|
7113 |
analytical_stem.verbatim_family,
|
|
7114 |
analytical_stem.verbatim_scientific_name,
|
|
7115 |
analytical_stem.identified_by,
|
|
7116 |
analytical_stem.date_identified,
|
|
7117 |
analytical_stem.identification_remarks,
|
|
7118 |
analytical_stem.family_matched,
|
|
7119 |
analytical_stem.name_matched,
|
|
7120 |
analytical_stem.name_matched_author,
|
| 7121 |
7121 |
analytical_stem.scrubbed_family,
|
| 7122 |
7122 |
analytical_stem.scrubbed_genus,
|
| 7123 |
|
analytical_stem.scrubbed_species_binomial_with_morphospecies AS "speciesBinomialWithMorphospecies__@VegCore__@vegpath.org",
|
|
7123 |
analytical_stem.scrubbed_species_binomial_with_morphospecies,
|
| 7124 |
7124 |
analytical_stem.scrubbed_taxon_name_no_author,
|
| 7125 |
7125 |
analytical_stem.scrubbed_author,
|
| 7126 |
|
analytical_stem.growth_form AS "[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org",
|
| 7127 |
|
analytical_stem.reproductive_condition AS "reproductiveCondition__@DwC__@vegpath.org",
|
| 7128 |
|
analytical_stem.is_cultivated AS cultivated_bien,
|
| 7129 |
|
analytical_stem.is_cultivated_basis AS "cultivatedBasis_bien",
|
| 7130 |
|
analytical_stem.occurrence_remarks AS "occurrenceRemarks__@DwC__@vegpath.org",
|
| 7131 |
|
analytical_stem.cover_percent AS "coverPercent__@VegX__.attribute.ordinal@vegpath.org",
|
| 7132 |
|
analytical_stem.stem_dbh_cm AS "stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org",
|
| 7133 |
|
analytical_stem.stem_height_m AS "stemHeight[_m]__@VegBank__.stemCount@vegpath.org",
|
| 7134 |
|
analytical_stem.tag AS "[tag=]identificationLabel__@VegX__.individual@vegpath.org",
|
| 7135 |
|
analytical_stem.relative_x_m AS "relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org",
|
| 7136 |
|
analytical_stem.relative_y_m AS "relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org",
|
| 7137 |
|
analytical_stem.taxon_observation_id AS "taxonObservation[.id]__@VegBank__@vegpath.org",
|
| 7138 |
|
analytical_stem.taxon_name_usage_concept_author_code AS "taxonNameUsageConcept.authorCode__@VegX__@vegpath.org",
|
| 7139 |
|
analytical_stem.aggregate_organism_observation_id AS "aggregateOrganismObservation.id__@VegX__@vegpath.org",
|
| 7140 |
|
analytical_stem.individual_organism_observation_id AS "individualOrganismObservation.id__@VegX__@vegpath.org",
|
| 7141 |
|
analytical_stem.individual_id AS "individualID__@DwC__@vegpath.org",
|
| 7142 |
|
analytical_stem.individual_count AS "individualCount__@DwC__@vegpath.org",
|
| 7143 |
|
analytical_stem.stem_code AS "stemCode__@VegBank__.stemLocation@vegpath.org"
|
|
7126 |
analytical_stem.growth_form,
|
|
7127 |
analytical_stem.reproductive_condition,
|
|
7128 |
analytical_stem.is_cultivated,
|
|
7129 |
analytical_stem.is_cultivated_basis,
|
|
7130 |
analytical_stem.occurrence_remarks,
|
|
7131 |
analytical_stem.cover_percent,
|
|
7132 |
analytical_stem.stem_dbh_cm,
|
|
7133 |
analytical_stem.stem_height_m,
|
|
7134 |
analytical_stem.tag,
|
|
7135 |
analytical_stem.relative_x_m,
|
|
7136 |
analytical_stem.relative_y_m,
|
|
7137 |
analytical_stem.taxon_observation_id,
|
|
7138 |
analytical_stem.taxon_name_usage_concept_author_code,
|
|
7139 |
analytical_stem.aggregate_organism_observation_id,
|
|
7140 |
analytical_stem.individual_organism_observation_id,
|
|
7141 |
analytical_stem.individual_id,
|
|
7142 |
analytical_stem.individual_count,
|
|
7143 |
analytical_stem.stem_code
|
| 7144 |
7144 |
FROM analytical_stem;
|
| 7145 |
7145 |
|
| 7146 |
7146 |
|
| 7147 |
7147 |
--
|
| 7148 |
|
-- Name: COLUMN analytical_plot."datasource__@Brad__.identifier_examples@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7149 |
|
--
|
| 7150 |
|
|
| 7151 |
|
COMMENT ON COLUMN analytical_plot."datasource__@Brad__.identifier_examples@vegpath.org" IS '"the person [or] institution that provided the data [to this database] (the *proximate* data provider)"';
|
| 7152 |
|
|
| 7153 |
|
|
| 7154 |
|
--
|
| 7155 |
|
-- Name: COLUMN analytical_plot."country__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7156 |
|
--
|
| 7157 |
|
|
| 7158 |
|
COMMENT ON COLUMN analytical_plot."country__@DwC__@vegpath.org" IS 'http://geoscrub.geoscrub_output.acceptedCountry__@VegBIEN__@vegpath.org;
|
| 7159 |
|
"The name of the country or major administrative unit in which the Location occurs"';
|
| 7160 |
|
|
| 7161 |
|
|
| 7162 |
|
--
|
| 7163 |
|
-- Name: COLUMN analytical_plot."stateProvince__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7164 |
|
--
|
| 7165 |
|
|
| 7166 |
|
COMMENT ON COLUMN analytical_plot."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"';
|
| 7167 |
|
|
| 7168 |
|
|
| 7169 |
|
--
|
| 7170 |
|
-- Name: COLUMN analytical_plot."county__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7171 |
|
--
|
| 7172 |
|
|
| 7173 |
|
COMMENT ON COLUMN analytical_plot."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"';
|
| 7174 |
|
|
| 7175 |
|
|
| 7176 |
|
--
|
| 7177 |
|
-- Name: COLUMN analytical_plot."locality__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7178 |
|
--
|
| 7179 |
|
|
| 7180 |
|
COMMENT ON COLUMN analytical_plot."locality__@DwC__@vegpath.org" IS '"The specific description of the place"';
|
| 7181 |
|
|
| 7182 |
|
|
| 7183 |
|
--
|
| 7184 |
|
-- Name: COLUMN analytical_plot."decimalLatitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7185 |
|
--
|
| 7186 |
|
|
| 7187 |
|
COMMENT ON COLUMN analytical_plot."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"';
|
| 7188 |
|
|
| 7189 |
|
|
| 7190 |
|
--
|
| 7191 |
|
-- Name: COLUMN analytical_plot."decimalLongitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7192 |
|
--
|
| 7193 |
|
|
| 7194 |
|
COMMENT ON COLUMN analytical_plot."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"';
|
| 7195 |
|
|
| 7196 |
|
|
| 7197 |
|
--
|
| 7198 |
|
-- Name: COLUMN analytical_plot."coordinateUncertaintyInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7199 |
|
--
|
| 7200 |
|
|
| 7201 |
|
COMMENT ON COLUMN analytical_plot."coordinateUncertaintyInMeters__@DwC__@vegpath.org" IS 'for a point observation, this is the fuzziness of the coordinates. for a plot (or other shape), this is the radius of the circle that circumscribes the entire plot, or the fuzziness, whichever is greater. note that the DwC definition is confusingly worded: it uses the ambiguous term Location, which sometimes refers to the asserted named place, but which they intended to refer to the plot or point.';
|
| 7202 |
|
|
| 7203 |
|
|
| 7204 |
|
--
|
| 7205 |
|
-- Name: COLUMN analytical_plot."georeferenceSources__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7206 |
|
--
|
| 7207 |
|
|
| 7208 |
|
COMMENT ON COLUMN analytical_plot."georeferenceSources__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of maps, gazetteers, or other resources used to georeference the Location, described specifically enough to allow anyone in the future to use the same resources"';
|
| 7209 |
|
|
| 7210 |
|
|
| 7211 |
|
--
|
| 7212 |
|
-- Name: COLUMN analytical_plot."georeferenceProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7213 |
|
--
|
| 7214 |
|
|
| 7215 |
|
COMMENT ON COLUMN analytical_plot."georeferenceProtocol__@DwC__@vegpath.org" IS '"A description or reference to the methods used to determine the spatial footprint, coordinates, and uncertainties"';
|
| 7216 |
|
|
| 7217 |
|
|
| 7218 |
|
--
|
| 7219 |
|
-- Name: COLUMN analytical_plot.geovalid_bien; Type: COMMENT; Schema: public; Owner: -
|
| 7220 |
|
--
|
| 7221 |
|
|
| 7222 |
|
COMMENT ON COLUMN analytical_plot.geovalid_bien IS 'whether the coordinates are within the boundary of the asserted named places';
|
| 7223 |
|
|
| 7224 |
|
|
| 7225 |
|
--
|
| 7226 |
|
-- Name: COLUMN analytical_plot."isNewWorld_bien"; Type: COMMENT; Schema: public; Owner: -
|
| 7227 |
|
--
|
| 7228 |
|
|
| 7229 |
|
COMMENT ON COLUMN analytical_plot."isNewWorld_bien" IS 'whether the country is in the Americas';
|
| 7230 |
|
|
| 7231 |
|
|
| 7232 |
|
--
|
| 7233 |
|
-- Name: COLUMN analytical_plot."projectID__@VegX__.plotObservation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7234 |
|
--
|
| 7235 |
|
|
| 7236 |
|
COMMENT ON COLUMN analytical_plot."projectID__@VegX__.plotObservation@vegpath.org" IS 'http://project.sourceaccessioncode__@VegBIEN__.public@vegpath.org;
|
| 7237 |
|
"A reference to a specific ''project''"';
|
| 7238 |
|
|
| 7239 |
|
|
| 7240 |
|
--
|
| 7241 |
|
-- Name: COLUMN analytical_plot."projectContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7242 |
|
--
|
| 7243 |
|
|
| 7244 |
|
COMMENT ON COLUMN analytical_plot."projectContributor[s]__@VegBank__@vegpath.org" IS '"intersection entit[ies] used to ''link'' a party with a specific project wherein vegetation plots are described"';
|
| 7245 |
|
|
| 7246 |
|
|
| 7247 |
|
--
|
| 7248 |
|
-- Name: COLUMN analytical_plot."locationID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7249 |
|
--
|
| 7250 |
|
|
| 7251 |
|
COMMENT ON COLUMN analytical_plot."locationID__@DwC__@vegpath.org" IS '"An identifier for the set of location information (data associated with dcterms:Location)"';
|
| 7252 |
|
|
| 7253 |
|
|
| 7254 |
|
--
|
| 7255 |
|
-- Name: COLUMN analytical_plot."plotName__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7256 |
|
--
|
| 7257 |
|
|
| 7258 |
|
COMMENT ON COLUMN analytical_plot."plotName__@VegX__.plot@vegpath.org" IS '"Name or label for a plot"';
|
| 7259 |
|
|
| 7260 |
|
|
| 7261 |
|
--
|
| 7262 |
|
-- Name: COLUMN analytical_plot."subplot__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7263 |
|
--
|
| 7264 |
|
|
| 7265 |
|
COMMENT ON COLUMN analytical_plot."subplot__@SALVIAS__.Plot_data@vegpath.org" IS 'http://location.authorlocationcode__@VegBIEN__.public@vegpath.org;
|
| 7266 |
|
"Code for subplot, line, or any other subsample or subdivision of plot"';
|
| 7267 |
|
|
| 7268 |
|
|
| 7269 |
|
--
|
| 7270 |
|
-- Name: COLUMN analytical_plot.location__cultivated__bien; Type: COMMENT; Schema: public; Owner: -
|
| 7271 |
|
--
|
| 7272 |
|
|
| 7273 |
|
COMMENT ON COLUMN analytical_plot.location__cultivated__bien IS 'whether the occurrence''s *location* was flagged as cultivated. note that this refers just to the cultivated status of the *location*; the occurrence may be cultivated even if the location isn''t.';
|
| 7274 |
|
|
| 7275 |
|
|
| 7276 |
|
--
|
| 7277 |
|
-- Name: COLUMN analytical_plot."eventDate__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7278 |
|
--
|
| 7279 |
|
|
| 7280 |
|
COMMENT ON COLUMN analytical_plot."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."';
|
| 7281 |
|
|
| 7282 |
|
|
| 7283 |
|
--
|
| 7284 |
|
-- Name: COLUMN analytical_plot."(-minimum-)ElevationInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7285 |
|
--
|
| 7286 |
|
|
| 7287 |
|
COMMENT ON COLUMN analytical_plot."(-minimum-)ElevationInMeters__@DwC__@vegpath.org" IS 'the "elevation (altitude, usually above sea level), in meters"';
|
| 7288 |
|
|
| 7289 |
|
|
| 7290 |
|
--
|
| 7291 |
|
-- Name: COLUMN analytical_plot."slopeAspect[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7292 |
|
--
|
| 7293 |
|
|
| 7294 |
|
COMMENT ON COLUMN analytical_plot."slopeAspect[_deg]__@VegX__.plot@vegpath.org" IS '"Representative azimuth of slope gradient (0-360 degrees) or as a cardinal direction (e.g. N, S, NE)"';
|
| 7295 |
|
|
| 7296 |
|
|
| 7297 |
|
--
|
| 7298 |
|
-- Name: COLUMN analytical_plot."slopeGradient[_deg]__@VegX__.plot@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7299 |
|
--
|
| 7300 |
|
|
| 7301 |
|
COMMENT ON COLUMN analytical_plot."slopeGradient[_deg]__@VegX__.plot@vegpath.org" IS '"Representative inclination of slope in degrees"';
|
| 7302 |
|
|
| 7303 |
|
|
| 7304 |
|
--
|
| 7305 |
|
-- Name: COLUMN analytical_plot."plot.area[_ha]__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7306 |
|
--
|
| 7307 |
|
|
| 7308 |
|
COMMENT ON COLUMN analytical_plot."plot.area[_ha]__@VegX__@vegpath.org" IS '"Total area of the plot"';
|
| 7309 |
|
|
| 7310 |
|
|
| 7311 |
|
--
|
| 7312 |
|
-- Name: COLUMN analytical_plot."samplingProtocol__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7313 |
|
--
|
| 7314 |
|
|
| 7315 |
|
COMMENT ON COLUMN analytical_plot."samplingProtocol__@DwC__@vegpath.org" IS '"The name of, reference to, or description of the method or protocol used during an Event"';
|
| 7316 |
|
|
| 7317 |
|
|
| 7318 |
|
--
|
| 7319 |
|
-- Name: COLUMN analytical_plot."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7320 |
|
--
|
| 7321 |
|
|
| 7322 |
|
COMMENT ON COLUMN analytical_plot."temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org" IS '"Temperature during observation [...] [in] Celsius"';
|
| 7323 |
|
|
| 7324 |
|
|
| 7325 |
|
--
|
| 7326 |
|
-- Name: COLUMN analytical_plot."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7327 |
|
--
|
| 7328 |
|
|
| 7329 |
|
COMMENT ON COLUMN analytical_plot."precip_mm__@SALVIAS__.Plot_metadata@vegpath.org" IS '"Total annual precipitation, in mm"';
|
| 7330 |
|
|
| 7331 |
|
|
| 7332 |
|
--
|
| 7333 |
|
-- Name: COLUMN analytical_plot."stratumName__@VegX__.stratum@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7334 |
|
--
|
| 7335 |
|
|
| 7336 |
|
COMMENT ON COLUMN analytical_plot."stratumName__@VegX__.stratum@vegpath.org" IS '"Name associated with this stratum"';
|
| 7337 |
|
|
| 7338 |
|
|
| 7339 |
|
--
|
| 7340 |
|
-- Name: COLUMN analytical_plot."communityConcept.name__@VegX__.communityDet@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7341 |
|
--
|
| 7342 |
|
|
| 7343 |
|
COMMENT ON COLUMN analytical_plot."communityConcept.name__@VegX__.communityDet@vegpath.org" IS '"A textual label for a community type. A community type is an abstract grouping of organisms that tend to co-occur on the landscape due to shared ecological requirements or preferences."';
|
| 7344 |
|
|
| 7345 |
|
|
| 7346 |
|
--
|
| 7347 |
|
-- Name: COLUMN analytical_plot."observationContributor[s]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7348 |
|
--
|
| 7349 |
|
|
| 7350 |
|
COMMENT ON COLUMN analytical_plot."observationContributor[s]__@VegBank__@vegpath.org" IS '"intersection[s] that link[] a party with a specific plot observation event"';
|
| 7351 |
|
|
| 7352 |
|
|
| 7353 |
|
--
|
| 7354 |
|
-- Name: COLUMN analytical_plot."recordedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7355 |
|
--
|
| 7356 |
|
|
| 7357 |
|
COMMENT ON COLUMN analytical_plot."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."';
|
| 7358 |
|
|
| 7359 |
|
|
| 7360 |
|
--
|
| 7361 |
|
-- Name: COLUMN analytical_plot."recordNumber__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7362 |
|
--
|
| 7363 |
|
|
| 7364 |
|
COMMENT ON COLUMN analytical_plot."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."';
|
| 7365 |
|
|
| 7366 |
|
|
| 7367 |
|
--
|
| 7368 |
|
-- Name: COLUMN analytical_plot."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7369 |
|
--
|
| 7370 |
|
|
| 7371 |
|
COMMENT ON COLUMN analytical_plot."(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org" IS 'the "date-time (Common Era calendar) in a date-time period during which an organism or group of organisms was collected or observed"';
|
| 7372 |
|
|
| 7373 |
|
|
| 7374 |
|
--
|
| 7375 |
|
-- Name: COLUMN analytical_plot."[verbatim_]family__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7376 |
|
--
|
| 7377 |
|
|
| 7378 |
|
COMMENT ON COLUMN analytical_plot."[verbatim_]family__@DwC__@vegpath.org" IS '"The full scientific name of the family in which the taxon is classified [*before* any TNRS scrubbing]"';
|
| 7379 |
|
|
| 7380 |
|
|
| 7381 |
|
--
|
| 7382 |
|
-- Name: COLUMN analytical_plot."[verbatim_]scientificName__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7383 |
|
--
|
| 7384 |
|
|
| 7385 |
|
COMMENT ON COLUMN analytical_plot."[verbatim_]scientificName__@DwC__@vegpath.org" IS '"The full scientific name [*before* any TNRS scrubbing], with authorship and date information if known. When forming part of an Identification, this should be the name in lowest level taxonomic rank that can be determined."';
|
| 7386 |
|
|
| 7387 |
|
|
| 7388 |
|
--
|
| 7389 |
|
-- Name: COLUMN analytical_plot."identifiedBy__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7390 |
|
--
|
| 7391 |
|
|
| 7392 |
|
COMMENT ON COLUMN analytical_plot."identifiedBy__@DwC__@vegpath.org" IS '"A list (concatenated and separated) of names of people, groups, or organizations who assigned the Taxon to the subject"';
|
| 7393 |
|
|
| 7394 |
|
|
| 7395 |
|
--
|
| 7396 |
|
-- Name: COLUMN analytical_plot."dateIdentified__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7397 |
|
--
|
| 7398 |
|
|
| 7399 |
|
COMMENT ON COLUMN analytical_plot."dateIdentified__@DwC__@vegpath.org" IS '"The date on which the subject was identified as representing the Taxon"';
|
| 7400 |
|
|
| 7401 |
|
|
| 7402 |
|
--
|
| 7403 |
|
-- Name: COLUMN analytical_plot."identificationRemarks__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7404 |
|
--
|
| 7405 |
|
|
| 7406 |
|
COMMENT ON COLUMN analytical_plot."identificationRemarks__@DwC__@vegpath.org" IS '"Comments or notes about the Identification"';
|
| 7407 |
|
|
| 7408 |
|
|
| 7409 |
|
--
|
| 7410 |
|
-- Name: COLUMN analytical_plot."Family_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7411 |
|
--
|
| 7412 |
|
|
| 7413 |
|
COMMENT ON COLUMN analytical_plot."Family_matched__@TNRS__@vegpath.org" IS 'http://TNRS.taxon_scrub.matchedFamily__@VegBIEN__.public@vegpath.org;
|
| 7414 |
|
"The closest matching family in the TNRS database to the family submitted"';
|
| 7415 |
|
|
| 7416 |
|
|
| 7417 |
|
--
|
| 7418 |
|
-- Name: COLUMN analytical_plot."Name_matched__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7419 |
|
--
|
| 7420 |
|
|
| 7421 |
|
COMMENT ON COLUMN analytical_plot."Name_matched__@TNRS__@vegpath.org" IS '"Scientific name with the highest match score. May be an exact match or a fuzzy match."';
|
| 7422 |
|
|
| 7423 |
|
|
| 7424 |
|
--
|
| 7425 |
|
-- Name: COLUMN analytical_plot."Name_matched_author__@TNRS__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7426 |
|
--
|
| 7427 |
|
|
| 7428 |
|
COMMENT ON COLUMN analytical_plot."Name_matched_author__@TNRS__@vegpath.org" IS '"Standard authority for the matched name"';
|
| 7429 |
|
|
| 7430 |
|
|
| 7431 |
|
--
|
| 7432 |
|
-- Name: COLUMN analytical_plot.scrubbed_family; Type: COMMENT; Schema: public; Owner: -
|
| 7433 |
|
--
|
| 7434 |
|
|
| 7435 |
|
COMMENT ON COLUMN analytical_plot.scrubbed_family IS 'the family of the TNRS accepted or matched name';
|
| 7436 |
|
|
| 7437 |
|
|
| 7438 |
|
--
|
| 7439 |
|
-- Name: COLUMN analytical_plot.scrubbed_genus; Type: COMMENT; Schema: public; Owner: -
|
| 7440 |
|
--
|
| 7441 |
|
|
| 7442 |
|
COMMENT ON COLUMN analytical_plot.scrubbed_genus IS 'the genus of the TNRS accepted or matched name';
|
| 7443 |
|
|
| 7444 |
|
|
| 7445 |
|
--
|
| 7446 |
|
-- Name: COLUMN analytical_plot."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7447 |
|
--
|
| 7448 |
|
|
| 7449 |
|
COMMENT ON COLUMN analytical_plot."speciesBinomialWithMorphospecies__@VegCore__@vegpath.org" IS 'http://TNRS.taxon_scrub.scrubbed_morphospecies_binomial__@VegBIEN__.public@vegpath.org;
|
| 7450 |
|
"combine the `taxon` plus `morphospecies` to produce a unique string, `taxonMorphospecies`";
|
| 7451 |
|
a morphospecies is a custom species name assigned in the field by the collector (which does not validate to anything in TNRS)';
|
| 7452 |
|
|
| 7453 |
|
|
| 7454 |
|
--
|
| 7455 |
|
-- Name: COLUMN analytical_plot.scrubbed_taxon_name_no_author; Type: COMMENT; Schema: public; Owner: -
|
| 7456 |
|
--
|
| 7457 |
|
|
| 7458 |
|
COMMENT ON COLUMN analytical_plot.scrubbed_taxon_name_no_author IS 'the taxon name without author of the TNRS accepted or matched name';
|
| 7459 |
|
|
| 7460 |
|
|
| 7461 |
|
--
|
| 7462 |
|
-- Name: COLUMN analytical_plot.scrubbed_author; Type: COMMENT; Schema: public; Owner: -
|
| 7463 |
|
--
|
| 7464 |
|
|
| 7465 |
|
COMMENT ON COLUMN analytical_plot.scrubbed_author IS 'the author of the TNRS accepted or matched name';
|
| 7466 |
|
|
| 7467 |
|
|
| 7468 |
|
--
|
| 7469 |
|
-- Name: COLUMN analytical_plot."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7470 |
|
--
|
| 7471 |
|
|
| 7472 |
|
COMMENT ON COLUMN analytical_plot."[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org" IS '"Growth form"; "Closed pick list"';
|
| 7473 |
|
|
| 7474 |
|
|
| 7475 |
|
--
|
| 7476 |
|
-- Name: COLUMN analytical_plot."reproductiveCondition__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7477 |
|
--
|
| 7478 |
|
|
| 7479 |
|
COMMENT ON COLUMN analytical_plot."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."';
|
| 7480 |
|
|
| 7481 |
|
|
| 7482 |
|
--
|
| 7483 |
|
-- Name: COLUMN analytical_plot.cultivated_bien; Type: COMMENT; Schema: public; Owner: -
|
| 7484 |
|
--
|
| 7485 |
|
|
| 7486 |
|
COMMENT ON COLUMN analytical_plot.cultivated_bien IS 'whether the occurrence was flagged as cultivated';
|
| 7487 |
|
|
| 7488 |
|
|
| 7489 |
|
--
|
| 7490 |
|
-- Name: COLUMN analytical_plot."cultivatedBasis_bien"; Type: COMMENT; Schema: public; Owner: -
|
| 7491 |
|
--
|
| 7492 |
|
|
| 7493 |
|
COMMENT ON COLUMN analytical_plot."cultivatedBasis_bien" IS 'why the occurrence was flagged as cultivated';
|
| 7494 |
|
|
| 7495 |
|
|
| 7496 |
|
--
|
| 7497 |
|
-- Name: COLUMN analytical_plot."occurrenceRemarks__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7498 |
|
--
|
| 7499 |
|
|
| 7500 |
|
COMMENT ON COLUMN analytical_plot."occurrenceRemarks__@DwC__@vegpath.org" IS '"Comments or notes about the Occurrence"';
|
| 7501 |
|
|
| 7502 |
|
|
| 7503 |
|
--
|
| 7504 |
|
-- Name: COLUMN analytical_plot."coverPercent__@VegX__.attribute.ordinal@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7505 |
|
--
|
| 7506 |
|
|
| 7507 |
|
COMMENT ON COLUMN analytical_plot."coverPercent__@VegX__.attribute.ordinal@vegpath.org" IS '"Average cover of the index in percent"';
|
| 7508 |
|
|
| 7509 |
|
|
| 7510 |
|
--
|
| 7511 |
|
-- Name: COLUMN analytical_plot."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7512 |
|
--
|
| 7513 |
|
|
| 7514 |
|
COMMENT ON COLUMN analytical_plot."stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org" IS '"Diameter at breast height of this stem (usually taken at 1.3 meters, but may vary)"';
|
| 7515 |
|
|
| 7516 |
|
|
| 7517 |
|
--
|
| 7518 |
|
-- Name: COLUMN analytical_plot."stemHeight[_m]__@VegBank__.stemCount@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7519 |
|
--
|
| 7520 |
|
|
| 7521 |
|
COMMENT ON COLUMN analytical_plot."stemHeight[_m]__@VegBank__.stemCount@vegpath.org" IS '"The measured height of the stem in meters"';
|
| 7522 |
|
|
| 7523 |
|
|
| 7524 |
|
--
|
| 7525 |
|
-- Name: COLUMN analytical_plot."[tag=]identificationLabel__@VegX__.individual@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7526 |
|
--
|
| 7527 |
|
|
| 7528 |
|
COMMENT ON COLUMN analytical_plot."[tag=]identificationLabel__@VegX__.individual@vegpath.org" IS '"A label that is associated with an individual (e.g. a numerical tree tag)"';
|
| 7529 |
|
|
| 7530 |
|
|
| 7531 |
|
--
|
| 7532 |
|
-- Name: COLUMN analytical_plot."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7533 |
|
--
|
| 7534 |
|
|
| 7535 |
|
COMMENT ON COLUMN analytical_plot."relativeX[_m]__@VegX__.individualOrganismObs@vegpath.org" IS '"The X-coordinate of the related item position in m. The user will enter the relative position of related item with respect to the plot origin (in meters) with the x-axis defined by the plot azimuth."';
|
| 7536 |
|
|
| 7537 |
|
|
| 7538 |
|
--
|
| 7539 |
|
-- Name: COLUMN analytical_plot."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7540 |
|
--
|
| 7541 |
|
|
| 7542 |
|
COMMENT ON COLUMN analytical_plot."relativeY[_m]__@VegX__.individualOrganismObs@vegpath.org" IS '"The Y-coordinate of the relatedSpatialItem position in m. The user will enter the relative position of relatedSpatialItems with respect to the plot origin (in meters) with the y-axis defined by the plot azimuth."';
|
| 7543 |
|
|
| 7544 |
|
|
| 7545 |
|
--
|
| 7546 |
|
-- Name: COLUMN analytical_plot."taxonObservation[.id]__@VegBank__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7547 |
|
--
|
| 7548 |
|
|
| 7549 |
|
COMMENT ON COLUMN analytical_plot."taxonObservation[.id]__@VegBank__@vegpath.org" IS '"identifier assigned [by the datasource] to each unique observation of a taxon in a plot"';
|
| 7550 |
|
|
| 7551 |
|
|
| 7552 |
|
--
|
| 7553 |
|
-- Name: COLUMN analytical_plot."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7554 |
|
--
|
| 7555 |
|
|
| 7556 |
|
COMMENT ON COLUMN analytical_plot."taxonNameUsageConcept.authorCode__@VegX__@vegpath.org" IS '"Verbatum short code used by the author to signify the species at time of observation"';
|
| 7557 |
|
|
| 7558 |
|
|
| 7559 |
|
--
|
| 7560 |
|
-- Name: COLUMN analytical_plot."aggregateOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7561 |
|
--
|
| 7562 |
|
|
| 7563 |
|
COMMENT ON COLUMN analytical_plot."aggregateOrganismObservation.id__@VegX__@vegpath.org" IS 'the ID for "An observation applying to all occurrences of an organism based on an aggregation factor. It contains an AggregateValue, which is an assessment of the overall occurrence of an organism in a Plot (e.g. number of stems, percentage cover, total biomass, basal area)."';
|
| 7564 |
|
|
| 7565 |
|
|
| 7566 |
|
--
|
| 7567 |
|
-- Name: COLUMN analytical_plot."individualOrganismObservation.id__@VegX__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7568 |
|
--
|
| 7569 |
|
|
| 7570 |
|
COMMENT ON COLUMN analytical_plot."individualOrganismObservation.id__@VegX__@vegpath.org" IS 'the ID for "An observation applying to one occurrence of an organism (or part of an organism). It is a container for measurements made on the organism (e.g. diameter, height, crown dimensions, biomass, growth form, number of stems)."';
|
| 7571 |
|
|
| 7572 |
|
|
| 7573 |
|
--
|
| 7574 |
|
-- Name: COLUMN analytical_plot."individualID__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7575 |
|
--
|
| 7576 |
|
|
| 7577 |
|
COMMENT ON COLUMN analytical_plot."individualID__@DwC__@vegpath.org" IS '"An identifier for an individual or named group of individual organisms represented in the Occurrence"';
|
| 7578 |
|
|
| 7579 |
|
|
| 7580 |
|
--
|
| 7581 |
|
-- Name: COLUMN analytical_plot."individualCount__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7582 |
|
--
|
| 7583 |
|
|
| 7584 |
|
COMMENT ON COLUMN analytical_plot."individualCount__@DwC__@vegpath.org" IS '"The number of individuals represented present at the time of the Occurrence"';
|
| 7585 |
|
|
| 7586 |
|
|
| 7587 |
|
--
|
| 7588 |
|
-- Name: COLUMN analytical_plot."stemCode__@VegBank__.stemLocation@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7589 |
|
--
|
| 7590 |
|
|
| 7591 |
|
COMMENT ON COLUMN analytical_plot."stemCode__@VegBank__.stemLocation@vegpath.org" IS 'http://stemobservation.authorstemcode__@VegBIEN__.public@vegpath.org;
|
| 7592 |
|
"Name or code applied to a specific stem in the plot. This is generally a numeric label to associate a field data entry with a stem in the database."';
|
| 7593 |
|
|
| 7594 |
|
|
| 7595 |
|
--
|
| 7596 |
7148 |
-- Name: analytical_specimen; Type: VIEW; Schema: public; Owner: -
|
| 7597 |
7149 |
--
|
| 7598 |
7150 |
|
| 7599 |
7151 |
CREATE VIEW analytical_specimen AS
|
| 7600 |
|
SELECT analytical_stem.datasource AS "datasource__@Brad__.identifier_examples@vegpath.org",
|
| 7601 |
|
analytical_stem.country AS "country__@DwC__@vegpath.org",
|
| 7602 |
|
analytical_stem.state_province AS "stateProvince__@DwC__@vegpath.org",
|
| 7603 |
|
analytical_stem.county AS "county__@DwC__@vegpath.org",
|
| 7604 |
|
analytical_stem.locality AS "locality__@DwC__@vegpath.org",
|
| 7605 |
|
analytical_stem.latitude AS "decimalLatitude__@DwC__@vegpath.org",
|
| 7606 |
|
analytical_stem.longitude AS "decimalLongitude__@DwC__@vegpath.org",
|
| 7607 |
|
analytical_stem.coord_uncertainty_m AS "coordinateUncertaintyInMeters__@DwC__@vegpath.org",
|
| 7608 |
|
analytical_stem.georef_sources AS "georeferenceSources__@DwC__@vegpath.org",
|
| 7609 |
|
analytical_stem.georef_protocol AS "georeferenceProtocol__@DwC__@vegpath.org",
|
| 7610 |
|
analytical_stem.is_geovalid AS geovalid_bien,
|
| 7611 |
|
analytical_stem.is_new_world AS "isNewWorld_bien",
|
| 7612 |
|
analytical_stem.is_location_cultivated AS location__cultivated__bien,
|
| 7613 |
|
analytical_stem.event_date AS "eventDate__@DwC__@vegpath.org",
|
| 7614 |
|
analytical_stem.elevation_m AS "(-minimum-)ElevationInMeters__@DwC__@vegpath.org",
|
| 7615 |
|
analytical_stem.temperature_c AS "temperature[_C]__@VegX__.plotObs.obsCond@vegpath.org",
|
| 7616 |
|
analytical_stem.precip_mm AS "precip_mm__@SALVIAS__.Plot_metadata@vegpath.org",
|
| 7617 |
|
analytical_stem.custodial_institution_codes AS "[custodial_]institutionCode[s]__@DwC__@vegpath.org",
|
| 7618 |
|
analytical_stem.collection_code AS "collectionCode__@DwC__@vegpath.org",
|
| 7619 |
|
analytical_stem.catalog_number AS "catalogNumber__@DwC__@vegpath.org",
|
| 7620 |
|
analytical_stem.occurrence_id AS "occurrenceID__@DwC__@vegpath.org",
|
| 7621 |
|
analytical_stem.recorded_by AS "recordedBy__@DwC__@vegpath.org",
|
| 7622 |
|
analytical_stem.record_number AS "recordNumber__@DwC__@vegpath.org",
|
| 7623 |
|
analytical_stem.date_collected AS "(-Earliest-)DateCollected__-2007-04-17__@DwC__.hist@vegpath.org",
|
| 7624 |
|
analytical_stem.verbatim_family AS "[verbatim_]family__@DwC__@vegpath.org",
|
| 7625 |
|
analytical_stem.verbatim_scientific_name AS "[verbatim_]scientificName__@DwC__@vegpath.org",
|
| 7626 |
|
analytical_stem.identified_by AS "identifiedBy__@DwC__@vegpath.org",
|
| 7627 |
|
analytical_stem.date_identified AS "dateIdentified__@DwC__@vegpath.org",
|
| 7628 |
|
analytical_stem.identification_remarks AS "identificationRemarks__@DwC__@vegpath.org",
|
| 7629 |
|
analytical_stem.family_matched AS "Family_matched__@TNRS__@vegpath.org",
|
| 7630 |
|
analytical_stem.name_matched AS "Name_matched__@TNRS__@vegpath.org",
|
| 7631 |
|
analytical_stem.name_matched_author AS "Name_matched_author__@TNRS__@vegpath.org",
|
|
7152 |
SELECT analytical_stem.datasource,
|
|
7153 |
analytical_stem.country,
|
|
7154 |
analytical_stem.state_province,
|
|
7155 |
analytical_stem.county,
|
|
7156 |
analytical_stem.locality,
|
|
7157 |
analytical_stem.latitude,
|
|
7158 |
analytical_stem.longitude,
|
|
7159 |
analytical_stem.coord_uncertainty_m,
|
|
7160 |
analytical_stem.georef_sources,
|
|
7161 |
analytical_stem.georef_protocol,
|
|
7162 |
analytical_stem.is_geovalid,
|
|
7163 |
analytical_stem.is_new_world,
|
|
7164 |
analytical_stem.is_location_cultivated,
|
|
7165 |
analytical_stem.event_date,
|
|
7166 |
analytical_stem.elevation_m,
|
|
7167 |
analytical_stem.temperature_c,
|
|
7168 |
analytical_stem.precip_mm,
|
|
7169 |
analytical_stem.custodial_institution_codes,
|
|
7170 |
analytical_stem.collection_code,
|
|
7171 |
analytical_stem.catalog_number,
|
|
7172 |
analytical_stem.occurrence_id,
|
|
7173 |
analytical_stem.recorded_by,
|
|
7174 |
analytical_stem.record_number,
|
|
7175 |
analytical_stem.date_collected,
|
|
7176 |
analytical_stem.verbatim_family,
|
|
7177 |
analytical_stem.verbatim_scientific_name,
|
|
7178 |
analytical_stem.identified_by,
|
|
7179 |
analytical_stem.date_identified,
|
|
7180 |
analytical_stem.identification_remarks,
|
|
7181 |
analytical_stem.family_matched,
|
|
7182 |
analytical_stem.name_matched,
|
|
7183 |
analytical_stem.name_matched_author,
|
| 7632 |
7184 |
analytical_stem.scrubbed_family,
|
| 7633 |
7185 |
analytical_stem.scrubbed_genus,
|
| 7634 |
7186 |
analytical_stem.scrubbed_taxon_name_no_author,
|
| 7635 |
7187 |
analytical_stem.scrubbed_author,
|
| 7636 |
|
analytical_stem.growth_form AS "[growth_form=]habit__@SALVIAS__.Plot_data@vegpath.org",
|
| 7637 |
|
analytical_stem.reproductive_condition AS "reproductiveCondition__@DwC__@vegpath.org",
|
| 7638 |
|
analytical_stem.is_cultivated AS cultivated_bien,
|
| 7639 |
|
analytical_stem.is_cultivated_basis AS "cultivatedBasis_bien",
|
| 7640 |
|
analytical_stem.occurrence_remarks AS "occurrenceRemarks__@DwC__@vegpath.org",
|
| 7641 |
|
analytical_stem.stem_dbh_cm AS "stem_dbh[_cm]__@SALVIAS__.Plot_data@vegpath.org",
|
| 7642 |
|
analytical_stem.stem_height_m AS "stemHeight[_m]__@VegBank__.stemCount@vegpath.org",
|
| 7643 |
|
analytical_stem.tag AS "[tag=]identificationLabel__@VegX__.individual@vegpath.org"
|
|
7188 |
analytical_stem.growth_form,
|
|
7189 |
analytical_stem.reproductive_condition,
|
|
7190 |
analytical_stem.is_cultivated,
|
|
7191 |
analytical_stem.is_cultivated_basis,
|
|
7192 |
analytical_stem.occurrence_remarks,
|
|
7193 |
analytical_stem.stem_dbh_cm,
|
|
7194 |
analytical_stem.stem_height_m,
|
|
7195 |
analytical_stem.tag
|
| 7644 |
7196 |
FROM analytical_stem;
|
| 7645 |
7197 |
|
| 7646 |
7198 |
|
| 7647 |
7199 |
--
|
| 7648 |
|
-- Name: COLUMN analytical_specimen."datasource__@Brad__.identifier_examples@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7649 |
|
--
|
| 7650 |
|
|
| 7651 |
|
COMMENT ON COLUMN analytical_specimen."datasource__@Brad__.identifier_examples@vegpath.org" IS '"the person [or] institution that provided the data [to this database] (the *proximate* data provider)"';
|
| 7652 |
|
|
| 7653 |
|
|
| 7654 |
|
--
|
| 7655 |
|
-- Name: COLUMN analytical_specimen."country__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7656 |
|
--
|
| 7657 |
|
|
| 7658 |
|
COMMENT ON COLUMN analytical_specimen."country__@DwC__@vegpath.org" IS 'http://geoscrub.geoscrub_output.acceptedCountry__@VegBIEN__@vegpath.org;
|
| 7659 |
|
"The name of the country or major administrative unit in which the Location occurs"';
|
| 7660 |
|
|
| 7661 |
|
|
| 7662 |
|
--
|
| 7663 |
|
-- Name: COLUMN analytical_specimen."stateProvince__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7664 |
|
--
|
| 7665 |
|
|
| 7666 |
|
COMMENT ON COLUMN analytical_specimen."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"';
|
| 7667 |
|
|
| 7668 |
|
|
| 7669 |
|
--
|
| 7670 |
|
-- Name: COLUMN analytical_specimen."county__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7671 |
|
--
|
| 7672 |
|
|
| 7673 |
|
COMMENT ON COLUMN analytical_specimen."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"';
|
| 7674 |
|
|
| 7675 |
|
|
| 7676 |
|
--
|
| 7677 |
|
-- Name: COLUMN analytical_specimen."locality__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7678 |
|
--
|
| 7679 |
|
|
| 7680 |
|
COMMENT ON COLUMN analytical_specimen."locality__@DwC__@vegpath.org" IS '"The specific description of the place"';
|
| 7681 |
|
|
| 7682 |
|
|
| 7683 |
|
--
|
| 7684 |
|
-- Name: COLUMN analytical_specimen."decimalLatitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7685 |
|
--
|
| 7686 |
|
|
| 7687 |
|
COMMENT ON COLUMN analytical_specimen."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"';
|
| 7688 |
|
|
| 7689 |
|
|
| 7690 |
|
--
|
| 7691 |
|
-- Name: COLUMN analytical_specimen."decimalLongitude__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7692 |
|
--
|
| 7693 |
|
|
| 7694 |
|
COMMENT ON COLUMN analytical_specimen."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"';
|
| 7695 |
|
|
| 7696 |
|
|
| 7697 |
|
--
|
| 7698 |
|
-- Name: COLUMN analytical_specimen."coordinateUncertaintyInMeters__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7699 |
|
--
|
| 7700 |
|
|
| 7701 |
|
COMMENT ON COLUMN analytical_specimen."coordinateUncertaintyInMeters__@DwC__@vegpath.org" IS 'for a point observation, this is the fuzziness of the coordinates. for a plot (or other shape), this is the radius of the circle that circumscribes the entire plot, or the fuzziness, whichever is greater. note that the DwC definition is confusingly worded: it uses the ambiguous term Location, which sometimes refers to the asserted named place, but which they intended to refer to the plot or point.';
|
| 7702 |
|
|
| 7703 |
|
|
| 7704 |
|
--
|
| 7705 |
|
-- Name: COLUMN analytical_specimen."georeferenceSources__@DwC__@vegpath.org"; Type: COMMENT; Schema: public; Owner: -
|
| 7706 |
|
--
|
| 7707 |
|
|
fix: schemas/public_.sql: analytical_plot, analytical_specimen: updated column names to be the same as analytical_stem, which these are a subset of