Data
Set: ystmap
Last Modified: 1 Nov 2001
Modified By: Tony Morosco
Data transformation performed by: Lisa
Lackey, Ann Dennis, Tony Morosco
* = Denotes fields that are required for
CalFlora Database
Blank values in Data Entered = data not
available
Data tables:
[TableName]![FieldName]
Source data --
converted to result data by matching value in source to result in named table.
Field
by Field Transcription Notes
Cooperative Yellow Starthistle Mapping Project
Original Data provided as two
files YSTMAP2000.txt (individual positive yst
occurrence observations) and qYSTSurveyMetadata.xls (description of
original component datasets from contributing individuals and organizations).
Original Data
|
Table:Field |
Field Description |
|
YSTMAP2000:FileNum |
ID of primary dataset, links to Metadata table |
|
YSTMAP2000:ObsevationDate |
Date-Either day or year |
|
YSTMAP2000:County |
Text-County name in caps |
|
YSTMAP2000:Acres |
definition unknown, not transcribed |
|
YSTMAP2000:Meters |
definition unknown, not transcribed |
|
YSTMAP2000:PointInfo |
Various text, not transcribed |
|
YSTMAP2000:Comment |
Various text, not transcribed |
|
YSTMAP2000:Latitude |
Floating pt Latitude in dd |
|
YSTMAP2000:Longitude |
Floating pt Longitude in dd |
|
qYSTSurveyMetadata:FileNum |
ID of primary dataset |
|
qYSTSurveyMetadata:FirstName |
First name of observer or compiler of primary dataset |
|
qYSTSurveyMetadata:LastName |
observer’s last name |
|
qYSTSurveyMetadata:Organization |
observer’s organization |
|
qYSTSurveyMetadata:phone |
observer’s phone number, not transcribed |
|
qYSTSurveyMetadata:email |
observer’s email, not transcribed |
|
qYSTSurveyMetadata:SurveyType |
Survey method: detection/survey |
|
qYSTSurveyMetadata:SourceType |
Description of primary data medium, not transcribed |
|
qYSTSurveyMetadata:OriginalProjectionCoordinateSystem |
Description of primary location data, not transcribed |
|
qYSTSurveyMetadata:OriginalDatum |
Description
of primary location data, not transcribed |
|
Req? |
CalFlora Occ Field |
Field Type |
Data Entered |
|
|
* |
dataset |
text, |
Assigned: “ystmap” |
|
|
* |
source |
text, |
Assigned: “Cooperative Yellow Starthistle Mapping Project" |
|
|
|
source_id |
text, |
Null: No unique record ID provided |
|
|
* |
sequence_num |
Integer |
Assigned: line number in YSTMAP2000 table |
|
|
|
orig_nomen |
text, |
"Jepson" |
|
|
* |
orig_name |
text, |
Assigned: “Centaurea solstitialis L.” |
|
|
* |
rslvd_genus |
text, |
Assigned: “Centaurea” |
|
|
* |
rslvd_species |
text, |
Assigned: “solstitialis” |
|
|
* |
rslvd_author1 |
text, |
Assigned: “L.” |
|
|
* |
rslvd_rank |
text, |
- |
|
|
* |
rslvd_ssp_var |
text, |
- |
|
|
* |
rslvd_author2 |
text, |
- |
|
|
|
rslvd_taxon |
text, |
Assigned: “Centaurea solstitialis” |
|
|
|
orig_plants |
text, |
- |
|
|
|
orig_adp |
text, |
- |
|
|
* |
orig_date |
text, |
[YSTMAP2000:ObsevationDate |
|
|
* |
orig_location |
text, |
Concatenation: “Lat=” YSTMAP2000:Latitude “, Long=” YSTMAP2000:Longitude |
|
|
* |
orig_loc_form |
text, |
Assigned “lldd” |
|
|
* |
orig_loc_prec |
double precision, |
Assigned: “1” ha |
|
|
|
orig_loc_desc |
text, |
Null - (none provided) |
|
|
|
orig_habitat |
text, |
- |
|
|
|
orig_elev |
integer, |
- |
|
|
|
orig_elev_form |
text, |
- |
|
|
location and site info |
||||
|
* |
county |
text, |
Formatted: YSTMAP2000:County three letter code from lookup table |
|
|
|
lat |
real, |
YSTMAP2000:Latitude |
|
|
|
long |
real, |
YSTMAP2000:Longitude |
|
|
|
Utm_zone |
Integer |
Assigned “10” from proj conversion |
|
|
|
utm10_x |
real, |
Filled from transformation using ‘proj +proj=utm +lon_0=123W -v -f %.0f < YST-ll-extract.ll > YST-utms.txt’ |
|
|
|
utm10_y |
real, |
Filled from transformation using ‘proj +proj=utm +lon_0=123W -v -f %.0f < YST-ll-extract.ll > YST-utms.txt’ |
|
|
|
elevation |
integer, |
- |
|
|
|
elev_source |
text, |
- |
|
|
|
site_info_avail |
text, |
- |
|
|
misc. |
||||
|
* |
observ_type |
text, |
qYSTSurveyMetadata:SurveyType =
“detection” assigned “undirected search”, SurveyType = “survey” assigned ”directed search” |
|
|
* |
observ_date |
date, |
Formatted:
YSTMAP2000:ObsevationDate |
|
|
* |
date_prec |
text, |
Result of evaluation of YSTMAP2000:ObsevationDate |
|
|
* |
doc_type |
text, |
Assigned: “reported” |
|
|
* |
textsoup |
text, |
- |
|
|
* |
index_date |
date |
"2001-10-31" |
|
|
|
auth_collector |
text |
Concatenation: qYSTSurveyMetadata:FirstName, qYSTSurveyMetadata:LastName, qYSTSurveyMetadata:Organization |
|
|
|
collectn |
text |
- |
|
|
|
Orig_date |
Text |
YSTMAP2000:ObsevationDate |
|
|
|
orig_county |
text |
YSTMAP2000:County |
|
|
|
plot_id |
text |
- |
|
|
|
plot_size |
double |
- |
|