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 
-01-01 added for observations of year only (1999, 2000).

*

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

-