seedlot

0 rows


Description

A quantity of seed of a particular species and quality collected from either a natural stand or seed Orchard in a given time period.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
seedlot_number varchar 5 null
seedlot_collection_method.seedlot_number seedlot_coll_met_seedlot_fk R
seedlot_genetic_worth.seedlot_number seedlot_genet_worth_seedlot_fk R
seedlot_orchard.seedlot_number seedlot_orchard_seedlot_fk R
seedlot_owner_quantity.seedlot_number seedlot_owner_qty_seedlot_fk R
seedlot_parent_tree.seedlot_number seedlot_parent_tree_seedlot_fk R
seedlot_registration_a_class_save.seedlot_number registration_form_a_class_seedlot_fk R
seedlot_seed_plan_zone.seedlot_number seedlot_seedplan_zn_seedlot_fk R
seedlot_smp_mix.seedlot_number seedlot_smp_mix_seedlot_fk R
smp_mix.seedlot_number smp_mix_seedlot_fk R

The unique number (key) assigned to a quantity of seed of a particular species and quality from a given location collected at a given time.

seedlot_status_code varchar 3 null
seedlot_status_list.seedlot_status_code seedlot_seedlot_status_code_fk R

A code which represents the current status of a lot.

applicant_client_number varchar 8 null

A sequentially assigned number which uniquely identifies a Ministry client (applicant).

applicant_locn_code varchar 2 null

A code to uniquely identify, within each client (applicant), the addresses of different divisions or locations at which the client operates. The location code is sequentially assigned starting with “00” for the client´s permanent address.

applicant_email_address varchar 100 null

Email address of client applying to register the Seedlot

vegetation_code varchar 8 null

A code which represents a species of tree or brush.

genetic_class_code varchar 1 null
genetic_class_list.genetic_class_code seedlot_genetic_class_code_fk R

A code which represents the Genetic Quality of material (seed or cuttings). “A” class represents superior Orchard produced seed or cuttings. “B” class represents naturally collected seed or cuttings.

seedlot_source_code varchar 3 null
seedlot_source_list.seedlot_source_code seedlot_seedlot_source_code_fk R

A code to indicate if an Orchard Seedlot is from tested Parent Trees, untested or custom.

to_be_registrd_ind bool 1 null

An indicator which represents whether a Seedlot is intended to be registered for crown land reforestation use (“Y” yes) or not (“N” no).

bc_source_ind bool 1 null

Indicates whether the source of the Seedlot is within British Columbia

collection_client_number varchar 8 null

A sequentially assigned number which uniquely identifies a Ministry client (collection).

collection_locn_code varchar 2 null

A code to uniquely identify, within each client (collection), the addresses of different divisions or locations at which the client operates. The location code is sequentially assigned starting with “00” for the client´s permanent address.

collection_start_date timestamp 29,6 null

The actual start date (year, month, and day) that the cones (source for seedlots) were collected.

collection_end_date timestamp 29,6 null

The actual end date (year, month, and day) that the cones (source for seedlots) were collected.

no_of_containers numeric 6,2 null

The number of containers (sacks of cones) that were collected.

vol_per_container numeric 6,2 null

The volume of cones, in hectolitres, that were collected per container (as reported on the cone collection form).

clctn_volume numeric 6,2 null

A code which represents the number of trees that the Seedlot was collected from.

seedlot_comment varchar 2000 null

A free format text field used to enter general comments for a Seedlot.

interm_strg_client_number varchar 8 null

A sequentially assigned number which uniquely identifies a Ministry client (interm storage).

interm_strg_locn_code varchar 2 null

A code to uniquely identify, within each client (interm storage), the addresses of different divisions or locations at which the client operates. The location code is sequentially assigned starting with “00” for the client´s permanent address.

interm_strg_st_date timestamp 29,6 null

The actual start date (year, month, and day) when the cone was stored during interim storage.

interm_strg_end_date timestamp 29,6 null

The actual end date (year, month, and day) when the cone was stored during interim storage.

interm_facility_code varchar 3 null

A code which represents the type of facility where the seed was stored during interim storage.

female_gametic_mthd_code varchar 4 null
gametic_methodology_list.gametic_methodology_code seedlot_female_game_mthd_cd_fk R

Code that describes the female gametic contribution method code for a Seedlot.

male_gametic_mthd_code varchar 4 null
gametic_methodology_list.gametic_methodology_code seedlot_male_game_mthd_cd_fk R

Code that describes the male gametic contribution method code for a Seedlot.

controlled_cross_ind bool 1 null

Indicates whether the lot was produced through controlled crosses.

biotech_processes_ind bool 1 null

Indicates if biotechnological processes been used to produce this lot.

pollen_contamination_ind bool 1 null

Indicates if pollen contamination was present in the seed Orchard

pollen_contamination_pct int4 10 null

The proportion of contaminant pollen present in the seed Orchard.

contaminant_pollen_bv numeric 4,1 null

The estimated Breeding Value of the contaminant pollen in an Orchard.

pollen_contamination_mthd_code varchar 4 null

Code that describes the pollen contamination method.

total_parent_trees int4 10 null

The total number of parents contributing to the Seedlot.

smp_success_pct int4 10 null

The estimated success (percent) of the supplemental mass pollination mix on the Parent Trees in the Orchard.

effective_pop_size numeric 5,1 null

The calculated number of parents contributing to the Seedlot, representing the genetic variety.

smp_parents_outside int4 10 null

The number of Parent Trees from outside an Orchard used in the supplemental mass pollination mix.

non_orchard_pollen_contam_pct int4 10 null

Non-orchard pollen contamination (%) for the Seedlot.

extractory_client_number varchar 8 null

A sequentially assigned number which uniquely identifies a Ministry client (extractory).

extractory_locn_code varchar 2 null

A code to uniquely identify, within each client (extractory), the addresses of different divisions or locations at which the client operates. The location code is sequentially assigned starting with “00” for the client´s permanent address.

extraction_st_date timestamp 29,6 null

The actual start date (year, month, and day) when the seed was extracted from the cones.

extraction_end_date timestamp 29,6 null

The actual end date (year, month, and day) when the seed was extracted from the cones.

temporary_strg_client_number varchar 8 null

A sequentially assigned number which uniquely identifies a Ministry client (storage).

temporary_strg_locn_code varchar 2 null

A code to uniquely identify, within each client (storage), the addresses of different divisions or locations at which the client operates. The location code is sequentially assigned starting with “00” for the client´s permanent address.

temporary_strg_start_date timestamp 29,6 null

Commencement date of temporary Seedlot storage.

temporary_strg_end_date timestamp 29,6 null

End date of Seedlot temporary storage.

declared_userid varchar 30 null

The userid of the individual that declares the following: - that the information is true and correct - that they are the owner of the lot or are authorized by the owner(s) to submit the Seedlot application.

declared_timestamp timestamp 29,6 null

The date and time that the following were declared by the declarer: - that the information is true and correct - that they are the owner of the lot or are authorized by the owner(s) to submit the Seedlot application.

entry_userid varchar 30 null

The userid of the individual that entered the Seedlot.

entry_timestamp timestamp 29,6 null

The time and date a Seedlot was entered onto the system.

update_userid varchar 30 null

The userid of the individual that changed the Seedlot.

update_timestamp timestamp 29,6 CURRENT_TIMESTAMP

The time and date a Seedlot was last updated on the system.

revision_count int4 10 null

A counter used to ensure data integrity. This item should be incremented during each update.

interm_strg_locn varchar 55 null

The location where the tree seed was stored during interim storage. Can be used if users did not enter a registered client data.

seed_plan_unit_id int2 5 null

A unique identifier which is assigned to a Seed Planning Unit.

bgc_zone_code varchar 4 null

The Biogeoclimatic Zone of the Seedlot collection area.

bgc_subzone_code varchar 3 null

The Biogeoclimatic Subzone of the Seedlot collection area.

variant varchar 1 null

A division of biogeoclimatic information, with multiple variants in a BGC Subzone.

bec_version_id int2 5 null

A sequence generated identifier for each BEC version.

elevation int2 5 null

The representative elevation in meters where the seed lot originated, which is also the mean area of use elevation for natural stand lots. For orchard seed lots it is a weighted average of the contributing parent trees source elevations.

latitude_degrees int2 5 null

The representative latitude (degrees) where the seed lot originated, which is also the mean area of use latitude for natural stand lots. For orchard seed lots it is a weighted average of the contributing parent trees source latitudes.

latitude_minutes int2 5 null

The representative latitude (minutes) where the seed lot originated, which is also the mean area of use latitude for natural stand lots. For orchard seed lots it is a weighted average of the contributing parent trees source latitudes.

latitude_seconds int2 5 null

The representative latitude (seconds) where the seed lot originated, which is also the mean area of use latitude for natural stand lots. For orchard seed lots it is a weighted average of the contributing parent trees source latitudes.

longitude_degrees int2 5 null

The representative longitude (degrees) where the seed lot originated, which is also the mean area of use longitude for natural stand lots. For orchard seed lots it is a weighted average of the contributing parent trees source longitudes.

longitude_minutes int2 5 null

The representative longitude (minutes) where the seed lot originated, which is also the mean area of use longitude for natural stand lots. For orchard seed lots it is a weighted average of the contributing parent trees source longitudes.

longitude_seconds int2 5 null

The representative longitude (seconds) where the seed lot originated, which is also the mean area of use longitude for natural stand lots. For orchard seed lots it is a weighted average of the contributing parent trees source longitudes.

collection_elevation int2 5 null

The representative elevation in meters of the Seedlot collection area. For orchard seedlots it is a weighted average of the contributing parent trees source elevations.

collection_elevation_min int2 5 null

The representative minimum elevation in meters of the Seedlot collection area. For orchard seedlots it is a weighted average of the contributing parent trees source elevations.

collection_elevation_max int2 5 null

The representative maximum elevation in meters of the Seedlot collection area. For orchard seedlots it is a weighted average of the contributing parent trees source elevations.

collection_latitude_deg int2 5 null

The representative latitude (degrees) of the Seedlot collection area. For orchard seedlots it is a weighted average of the contributing parent trees source latitude.

collection_latitude_min int2 5 null

The representative latitude (minutes) of the Seedlot collection area. For orchard seedlots it is a weighted average of the contributing parent trees source latitude.

collection_latitude_sec int2 5 null

The representative latitude (seconds) of the Seedlot collection area. For orchard seedlots it is a weighted average of the contributing parent trees source latitude.

collection_latitude_code varchar 1 null

A code which specifies whether the exotic origin latitude is north (N) or south (S).

collection_longitude_deg int2 5 null

The representative longitude (degrees) of the Seedlot collection area. For orchard seedlots it is a weighted average of the contributing parent trees source longitude.

collection_longitude_min int2 5 null

The representative longitude (minutes) of the Seedlot collection area. For orchard seedlots it is a weighted average of the contributing parent trees source longitude.

collection_longitude_sec int2 5 null

The representative longitude (seconds) of the Seedlot collection area. For orchard seedlots it is a weighted average of the contributing parent trees source longitude.

collection_longitude_code varchar 1 null

A code which specifies whether the exotic origin longitude is east (E) or west (W).

elevation_min int2 5 null

The minimum elevation of the seedlot area of use. For lots from natural stands, this is calculated using the transfer limits. For lots from tested parent trees (orchards) either use Seed Planning Unit minimum or the collection latitude.

elevation_max int2 5 null

The maximum elevation of the seedlot area of use. For lots from natural stands, this is calculated using the transfer limits. For lots from tested parent trees (orchards) either use Seed Planning Unit minimum or the collection latitude.

latitude_deg_min int2 5 null

The minimum latitude (degrees) of the seedlot area of use. For lots from natural stands, this is calculated using the transfer limits. For lots from tested parent trees (orchards) either use Seed Planning Unit minimum or the collection latitude.

latitude_min_min int2 5 null

The minimum latitude (minutes) of the seedlot area of use. For lots from natural stands, this is calculated using the transfer limits. For lots from tested parent trees (orchards) either use Seed Planning Unit minimum or the collection latitude.

latitude_sec_min int2 5 null

The minimum latitude (seconds) of the seedlot area of use. For lots from natural stands, this is calculated using the transfer limits. For lots from tested parent trees (orchards) either use Seed Planning Unit minimum or the collection latitude.

latitude_deg_max int2 5 null

The maximum latitude (degrees) of the seedlot area of use. For lots from natural stands, this is calculated using the transfer limits. For lots from tested parent trees (orchards) either use Seed Planning Unit minimum or the collection latitude.

latitude_min_max int2 5 null

The maximum latitude (minutes) of the seedlot area of use. For lots from natural stands, this is calculated using the transfer limits. For lots from tested parent trees (orchards) either use Seed Planning Unit minimum or the collection latitude.

latitude_sec_max int2 5 null

The maximum latitude (seconds) of the seedlot area of use. For lots from natural stands, this is calculated using the transfer limits. For lots from tested parent trees (orchards) either use Seed Planning Unit minimum or the collection latitude.

longitude_deg_min int2 5 null

The minimum longitude (degrees) of the seedlot area of use. For lots from natural stands, this is calculated using the transfer limits. For lots from tested parent trees (orchards) either use Seed Planning Unit minimum or the collection latitude.

longitude_min_min int2 5 null

The minimum longitude (minutes) of the seedlot area of use. For lots from natural stands, this is calculated using the transfer limits. For lots from tested parent trees (orchards) either use Seed Planning Unit minimum or the collection latitude.

longitude_sec_min int2 5 null

The minimum longitude (seconds) of the seedlot area of use. For lots from natural stands, this is calculated using the transfer limits. For lots from tested parent trees (orchards) either use Seed Planning Unit minimum or the collection latitude.

longitude_deg_max int2 5 null

The maximum longitude (degrees) of the seedlot area of use. For lots from natural stands, this is calculated using the transfer limits. For lots from tested parent trees (orchards) either use Seed Planning Unit minimum or the collection latitude.

longitude_min_max int2 5 null

The maximum longitude (minutes) of the seedlot area of use. For lots from natural stands, this is calculated using the transfer limits. For lots from tested parent trees (orchards) either use Seed Planning Unit minimum or the collection latitude.

longitude_sec_max int2 5 null

The maximum longitude (seconds) of the seedlot area of use. For lots from natural stands, this is calculated using the transfer limits. For lots from tested parent trees (orchards) either use Seed Planning Unit minimum or the collection latitude.

smp_mean_bv_growth numeric 4,1 null

The breeding value for the Growth trait calculated from the supplemental mass pollination mix applied to parent trees.

area_of_use_comment varchar 2000 null

Comments on Seedlot area of use.

approved_timestamp timestamp 29,6 null
approved_userid varchar 30 null
mean_geom geometry 2147483647 null

The 3D mean geom of parent trees.

bgc_zone_description varchar 120 NULL::character varying

The description of the BEC zone.

Indexes

Constraint Name Type Sort Column(s)
seedlot_pk Primary key Asc seedlot_number

Relationships