BCMCA_ECO_Birds_TrumpeterSwan_Winter_plyData

Metadata:

• Identification_Information
• Data_Quality_Information
• Spatial_Data_Organization_Information
• Spatial_Reference_Information
• Entity_and_Attribute_Information
• Distribution_Information
• Metadata_Reference_Information

Identification_Information:

Citation:

Citation_Information:

Originator:

The British Columbia Marine Conservation Analysis (BCMCA), a Tides Canada Initiatives Project

Publication_Date: 03/2010

Title: BCMCA_ECO_Birds_TrumpeterSwan_Winter_plyData

Geospatial_Data_Presentation_Form: vector digital data

Series_Information:

Series_Name: Ecological Data

Publication_Information:

Publisher: BCMCA

Online_Linkage:

\\GIS_CARRIE\E\Andy_Bcmca\data_processed_namedStandardized\Seabirds\Final_Processed_File\Final_Processed_File.mdb

Description:

Abstract:

The British Columbia Marine Conservation Analysis (BCMCA) is a collaborative project assembling and analyzing spatial information about Canada's Pacific Ocean. The overall goal of the BCMCA is to identify marine areas of high conservation value and marine areas important to human use. Results of the project are intended to inform and help advance marine planning initiatives in BC by providing collaborative, peer-reviewed scientific analyses based on the best ecological and human use spatial data at scales relevant to a BC coast-wide analysis.

Purpose:

The purpose of this dataset is to incorporate all near shore data identifying Trumpeter Swan winter sites (December, January, February), process and summarize weighted densities by BCMCA planning unit to help inform the marine feature identified at the BCMCA Seabirds Workshop.

Supplemental_Information:

This dataset is a compilation of data collected by many people, for different purposes, using different survey techniques with different methodologies within each technique and, therefore, considerable care must be taken when using the data, even for site-specific inquiries. Refer to the original metadata document for data limitations and usage. Title or link is provided within source information. Data was collected, merged and buffered (if applicable) by target feature layer using the following data sources: 1.Bird Studies Canada (BSC) BC Coastal Waterbirds Survey (BCCWS_polygons.shp). 2.Coastal Waterbird Inventory Survey (cwi_bc.shp, cwidat_bc.dbf). 3.BCMCA Planning Units (dfo_bc_2K_4K_combined.shp).

Time_Period_of_Content:

Time_Period_Information:

Single_Date/Time:

Calendar_Date: unknown

Currentness_Reference: ground condition

Status:

Progress: Complete

Maintenance_and_Update_Frequency: None planned

Spatial_Domain:

Bounding_Coordinates:

West_Bounding_Coordinate: -132.774172

East_Bounding_Coordinate: -122.402538

North_Bounding_Coordinate: 54.600626

South_Bounding_Coordinate: 48.313215

Keywords:

Theme:

Theme_Keyword_Thesaurus:

REQUIRED: Reference to a formally registered thesaurus or a similar authoritative source of theme keywords.

Theme_Keyword: Trumpeter Swan

Theme_Keyword: winter

Theme_Keyword: weighted densities

Place:

Place_Keyword: British Columbia

Access_Constraints:

This dataset is subject to the terms and conditions of the data use agreements for the source datasets.

Use_Constraints:

This dataset is subject to the terms and conditions of the data use agreements for the source datasets.

Point_of_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Karin Bodtker

Contact_Organization: British Columbia Marine Conservation Analysis

Contact_Position: BCMCA Co-Chair

Contact_Address:

Address_Type: mailing and physical address

Address: 1405-207 West Hastings Street

City: Vancouver

State_or_Province: BC

Postal_Code: V6B 1H7

Country: Canada

Contact_Voice_Telephone: 6046965044

Contact_Electronic_Mail_Address: kbodtker@livingoceans.org

Native_Data_Set_Environment:

Microsoft Windows Vista Version 6.1 (Build 7600) ; ESRI ArcCatalog 9.3.1.4000

Data_Quality_Information:

Lineage:

Source_Information:

Source_Contribution:

Bird Studies Canada (BSC) BC Coastal Waterbirds Survey. Dataset name: BCCWS_polygons.shp. Metadata document: Coastal Waterbird Survey summary metadata March 2007.doc. Volunteer-based monitoring program for coastal waterbirds started in September 1999. The monthly surveys are shoreline-based for the period of September through April. Observers undertake surveys at sites with clearly defined boundaries once per month from September through April, and identify and count all coastal waterbirds with binoculars and/or spotting scope. Purpose is to obtain a relative index of coastal waterbird populations and information on the distribution and ecology of wintering coastal waterbirds in BC. Dataset supplied includes spatial layer. All bird occurrences and counts stored in a raw data format and included within excel spreadsheet; approx 75,000 records. Bird occurrences are documented by site location, rather than individual sighting locations and can be joined to spatial polygon data via SiteCode. Refer to original metadata document (listed above) for more information regarding survey background, methodology and data limitations.

Source_Information:

Source_Contribution:

Coastal Waterbird Inventory Survey. Dataset name: cwi_bc.shp. Associated tables: cwidat_bc.dbf, cwilut_bc.dbf. Metadata document: cwi_meatadata_26March07.doc. Extent: Coast Wide. Compilation of data from Duck Unlimited and Canadian Wildlife Service. Includes ground surveys (back to 1919), boat surveys, and aerial surveys. The surveys were conducted with the primary purpose of locating concentrations of waterbirds on the coast of British Columbia. Originally the data were received in five separate files (CWIF1.DBF, CWIF2.DBF, CWIF3.DBF, CWIF4.DBF, CWIF5.DBF) and were combined into above tables. Refer to original metadata document (listed above) for more information regarding survey background, methodology and data limitations.

Source_Information:

Source_Contribution:

Triennial Swan. Dataset name: aswcnt2006_vi.shp. Metadata document: triair_trus_vi_meta.doc. Extent: Vancouver Island Lower Mainland. The purpose of these surveys was to estimate population numbers of Trumpeter Swans wintering around Vancouver Island. Refer to original metadata document (listed above) for more information regarding survey background, methodology and data limitations.

Source_Information:

Source_Contribution:

BCMCA Planning Units. Dataset name: dfo_bc_2K_4K_combined.shp. Metadata document: None supplied. Shapefile contains the combined 2km and 4km planning unit grid cells with associated unit ID's.

Process_Step:

Process_Description:

<<The methods used to combine datasets to identify areal extents and densities of Trumpeter and Tundra Swan winter sites are as follows >>

Source_Used_Citation_Abbreviation:

\\CRMLTD03\E$\F\Crm1143\Source\080818_SourceDocs\Original_Data\Plants\BCMCA_Plants.gdb

Process_Step:

Process_Description:

>Prepared BC Coastal Waterbirds Survey dataset: 

Imported excel worksheets "BCCWS raw data 1, raw data 2, raw data 3" from Coastal Waterbird Survey data '99-'08.xls into a geodatabase. To join tables to spatial, created new field, SITECODE, in all 3 tables. Using field calculator, populated SITECODE field with following formula: [RegionCode]& [SiteNumber]. Create one field storing date (ymd) rather than 3 fields. Populated field using field calculator with the following formula: [Year_]&"/"& [Month_]&"/"& [Day_]. To combine all 3 tables into one table, used the Append tool and appended raw data 2 and raw data 3 to raw data 1 table. Deleted "Year_" Month_" and "Day_" fields using Delete Field tool. Added 3 new fields using Add Field tool: Feature, Data_Source, Dataset_ID. Populated fields using Calculate Field tool. Feature field calculated to equal the SpeciesCode field. Standardized the Feature field naming convention to equal the common name of the marine species rather than the abbreviated species code. Data_Source field calculated to equal the name of the dataset from which data was derived. Dataset_ID field calculated to equal the common dataset identifier as categorized by BCMCA.

Process_Step:

Process_Description:

Re-projected spatial layer from NAD 1983 Albers to NAD 1983 BC Environment Albers using Project tool. All polygons with the same Sitecode were merged so that there were no duplications in the Sitecode field. To ensure areas matched in both the spatial and the survey data, the total shape area in the spatial was summed where duplicate Sitecodes and cross-checked with area recorded in corresponding SiteCode records in raw excel data. Once the areas were verified, duplicate polygons were merged using merge operation (Advanced Editor toolbar) into one and Name field updated to reflect entire survey location. Duplicate SiteCode records were found in GIMA1 (3 records), GIMA2 (4 records), GISE1 (2 records), and QCMA4 (2 records).

Process_Step:

Process_Description:

Using MS Access query, selected all records within raw data table where SpeciesCode = TRUS Or SpeciesCode = 'TUSW' with survey months >11 or <3. Conducted queries separately and exported selected species' records into individual feature tables. To calculate the total number of surveys, two queries were created using Microsoft Access. The first query was created to record all instances of survey dates meeting the features' winter specifications within each survey polygon (i.e. each date instance was assigned a value of 1), grouped and ordered by polygon. To eliminate duplicate counts (i.e. each species recorded has a survey date), only the first date instance was assigned a value of one. The second query was created to count and sum all date instances within each grouped polygon.

Process_Step:

Process_Description:

For each SiteCode, summarized feature table to get the average bird counts. Included the number of surveys in which the species was sighted and the total number of surveys table. Joined feature table to spatial using SiteCode field and exported into a feature class. Added a new field, Season, and calculated to equal the season in which the feature is identified as specified by BCMCA. Note: a few records in the aspatial table did not have matching SiteCodes within the spatial layer. Deleted all unnecessary fields using Delete Fields tool.

Process_Step:

Process_Description:

<<Prepared Coastal Waterbird Inventory Survey dataset: Re-projected cwi_bc.shp from PCS Albers to NAD 1983 BC Environment Albers using Project tool. Using MS Access query, selected all records within cwidat_bc table where SPECIES = 'TRUS' or SPECIES = 'TUSW' And survey months >11 Or <3. Since the SEASON field within CWI dataset does not necessarily correlate with BCMCA specified "winter" months, used the DATE field in query rather than season field.

Source_Used_Citation_Abbreviation:

E:\F\Crm1143\Source\080818_SourceDocs\Original_Data\Seabirds\Metadata_temp\Harlequin Winter metadata.xml

Process_Step:

Process_Description:

Related 2 survey tables (cwilut_bc/cwidat_bc) to spatial, and extracted all spatial lines correlating to target feature into a separate feature class. Reviewed Digitized field and where "F2", spatial lines were merged according to each unique combination of SHOREUNITS2 field to create a one-to-one relationship with the survey data. New fields were created (UNIQUEID, NEWID) in order to provide a link to the corresponding survey data. Where applicable, all null and non-spatially linked shoreunits in the feature tables were deleted in order to maintain the same record count in both the spatial and table (refer to associated text file listing null and non-spatially linked records). Joined feature table to spatial layer using NEWID field and exported to a feature class. Added 5 new fields using Add Field tool: Season, Feature, DATA_SOURCE, Dataset_ID and Buffer_m. Populated fields using Calculate Field tool. Season field calculated to equal the season in which the feature is identified as specified by BCMCA. Feature field calculated to equal common name of the marine feature as identified within the COMNAME field. DATA_SOURCE calculated to equal the name of the dataset from which data was derived. Dataset_ID field calculated to equal the common dataset identifier as categorized by BCMCA. Buffer field calculated based on Survey_Method used: 50m radius (ground, air, and unknown surveys), 150m radius (boat surveys). Buffered shorelines using Buffer tool based on Buffer field. Deleted un-necessary fields using Delete Field tool.

Process_Step:

Process_Description:

<<Prepare Triennial Swan dataset: Re-project to NAD 1983 BC Environment Albers using Project tool. Convert shapefile to feature class using feature class to feature class tool. Keep TOTAL field. Added 6 new fields and populated: Season, Feature, Data_Source, Dataset_ID, Surveys_Species_Sighted, Surveys_Total. Season field calculated to equal the season in which the feature is identified as specified by BCMCA. Feature field calculated to equal the common name of the marine species. Data_Source field calculated to equal the name of the dataset from which the data was derived. Dataset_ID field calculated to equal the common dataset identifier as categorized by BCMCA. Standardized Feature field species naming convention by using the common name of the marine feature identified rather than the species abbreviation. Surveys_Species_Sighted and Surveys_Total fields calculated to 1. Buffer points by 50m (radius) using Buffer tool.

Process_Step:

Process_Description:

<<Reviewed BIEAP, CRD, MBAOI, Burger and PSS datasets: BIEAP and CRD datasets were not used to create feature as species identified did not meet the specified "winter" month feature requirements. All data within MBAOI has already been received and processed. Burger and PSS data was not used for feature creation as there were no Trumpter or Tundra Swan species identified.

Process_Step:

Process_Description:

Merged all prepared datasets using Merge tool to create one layer storing all Trumpeter and Tundra Swan winter sites. During merge process like fields were combined using Field Map window to eliminate duplicate or redundant column headings. Field map was also used to eliminate unnecessary fields not applicable for final feature layer requirements.Created Metadata.

Process_Step:

Process_Description: Created Metadata.

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person:

Steps up to and including this one completed by Melissa Meneghetti

Contact_Organization: Coastal Resource Mapping

Process_Step:

Process_Description:

The Trumpeter Swan feature was extracted from the Trumpeter_TundraSwan_Final feature class using Select By Attributes. Records where [FEATURE] = 'Trumpeter Swan' were exported to a new feature class.

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Mathew Evans

Contact_Organization: BCMCA

Contact_Position: GIS Contractor

Process_Step:

Process_Description:

Buffered points from the Triennial Swan Survey dataset were removed as the density values were determined to be erroneous for the buffered areas.

Source_Used_Citation_Abbreviation:

\\MELISSA-PC\C\Crm1247\CRM_Work_2010\Nearshore_Data\Nearshore_revised_nov2009.mdb

Process_Date: April 2010

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Carrie Robb

Contact_Organization: Living Oceans Society (for BCMCA)

Contact_Position: GIS Specialist

Process_Step:

Process_Description:

>Created Survey File:

Added 2 new fields: Area_km2 and Density_km2. Area_km2 calculated by multiplying the shape area (m2) by .000001. Density_km2 Density field calculated using the following formula: [nbird_Total / [Area_km2].

Process_Step:

Process_Description:

Overlaid merged feature polygons with BCMCA planning units using Spatial Join tool. Tool parameter example: Target Feature = dfo_bc_2k_4k_combined.shp, Join Features = feature layer, Join Operation = Join_One_to_Many, Match Option = Intersects. To create the final processed file, summarized data by planning unit ID and calculated the sum of the total surveys, the sum of the surveys species sighted, and the sum of the density. Added a new field: AVG_DENSITY_km2. Calculated field using the following formula: [sum_DENSITY_km2] / [sum_SURVEYS_TOTAL].

Process_Step:

Process_Description: Updated Metadata

Process_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person:

Steps up to and including this one were completed by Carrie Robb

Contact_Organization: Living Oceans Society (for BCMCA)

Contact_Position: GIS Specialist

Spatial_Data_Organization_Information:

Direct_Spatial_Reference_Method: Vector

Point_and_Vector_Object_Information:

SDTS_Terms_Description:

SDTS_Point_and_Vector_Object_Type: G-polygon

Point_and_Vector_Object_Count: 331

SDTS_Terms_Description:

SDTS_Point_and_Vector_Object_Type: Label point

Point_and_Vector_Object_Count: 39346

SDTS_Terms_Description:

SDTS_Point_and_Vector_Object_Type: GT-polygon composed of chains

Point_and_Vector_Object_Count: 39346

SDTS_Terms_Description:

SDTS_Point_and_Vector_Object_Type: Point

Point_and_Vector_Object_Count: 4

Spatial_Reference_Information:

Horizontal_Coordinate_System_Definition:

Planar:

Map_Projection:

Map_Projection_Name: Albers Conical Equal Area

Albers_Conical_Equal_Area:

Standard_Parallel: 50.000000

Standard_Parallel: 58.500000

Longitude_of_Central_Meridian: -126.000000

Latitude_of_Projection_Origin: 45.000000

False_Easting: 1000000.000000

False_Northing: 0.000000

Planar_Coordinate_Information:

Planar_Coordinate_Encoding_Method: coordinate pair

Coordinate_Representation:

Abscissa_Resolution: 0.000000

Ordinate_Resolution: 0.000000

Planar_Distance_Units: meters

Geodetic_Model:

Horizontal_Datum_Name: North American Datum of 1983

Ellipsoid_Name: Geodetic Reference System 80

Semi-major_Axis: 6378137.000000

Denominator_of_Flattening_Ratio: 298.257222

Vertical_Coordinate_System_Definition:

Altitude_System_Definition:

Altitude_Resolution: 0.000100

Altitude_Encoding_Method:

Explicit elevation coordinate included with horizontal coordinates

Entity_and_Attribute_Information:

Detailed_Description:

Entity_Type:

Entity_Type_Label: BCMCA_ECO_Birds_TrumpeterSwan_Winter_plyData

Attribute:

Attribute_Label: Shape_Area

Attribute_Definition: Area of feature in internal units squared.

Attribute_Definition_Source: ESRI

Attribute_Domain_Values:

Unrepresentable_Domain: Positive real numbers that are automatically generated.

Attribute:

Attribute_Label: FID_1

Attribute:

Attribute_Label: SHAPE_LENG

Attribute:

Attribute_Label: UNIT_ID

Attribute:

Attribute_Label: AREA

Attribute:

Attribute_Label: COST

Attribute:

Attribute_Label: STATUS

Attribute:

Attribute_Label: Shape

Attribute_Definition: Feature geometry.

Attribute_Definition_Source: ESRI

Attribute_Domain_Values:

Unrepresentable_Domain: Coordinates defining the features.

Attribute:

Attribute_Label: Count_

Attribute:

Attribute_Label: Sum_nbirds_avg

Attribute:

Attribute_Label: Sum_SURVEYS_SPECIES_SIGHTED

Attribute_Definition:

Sum of the survey in which species sighted fields for each survey area by planning unit.

Attribute:

Attribute_Label: Sum_SURVEYS_TOTAL

Attribute_Definition: Sum of the survey fields for each survey area by planning unit.

Attribute:

Attribute_Label: Sum_Dataset_ID

Attribute:

Attribute_Label: Sum_NEWID

Attribute:

Attribute_Label: Sum_TRANSNO

Attribute:

Attribute_Label: Sum_RECNO

Attribute:

Attribute_Label: Sum_ZONE_

Attribute:

Attribute_Label: Sum_SUBZONE

Attribute:

Attribute_Label: Sum_nbirds_Total

Attribute:

Attribute_Label: Sum_NEWID_1

Attribute:

Attribute_Label: Sum_AREA_km2

Attribute:

Attribute_Label: Sum_DENSITY_km2

Attribute_Definition:

Sum of the density fields for each survey area by planning unit.

Attribute:

Attribute_Label: Sum_Shape_Length

Attribute:

Attribute_Label: Sum_Shape_Area

Attribute:

Attribute_Label: Shape_Length

Attribute_Definition: Length of feature in internal units.

Attribute_Definition_Source: ESRI

Attribute_Domain_Values:

Unrepresentable_Domain: Positive real numbers that are automatically generated.

Attribute:

Attribute_Label: OBJECTID

Attribute_Definition: Internal feature number.

Attribute_Definition_Source: ESRI

Attribute_Domain_Values:

Unrepresentable_Domain:

Sequential unique whole numbers that are automatically generated.

Overview_Description:

Entity_and_Attribute_Detail_Citation:

Species' targeted season, moulting and staging months were defined using the following tech report: <http://www.bsc-eoc.org/library/bccwstrends2008.pdf>.

Distribution_Information:

Distributor:

Contact_Information:

Contact_Organization_Primary:

Contact_Organization: British Columbia Marine Conservation Analysis

Contact_Instructions: See www.bcmca.ca for distribution details

Resource_Description: Downloadable Data

Standard_Order_Process:

Digital_Form:

Digital_Transfer_Information:

Transfer_Size: 50.954

Metadata_Reference_Information:

Metadata_Date: 20101005

Metadata_Contact:

Contact_Information:

Contact_Person_Primary:

Contact_Person: Carrie Robb

Contact_Organization: Living Oceans Society (for BCMCA)

Contact_Position: GIS Specialist

Contact_Address:

Address_Type: mailing and physical address

Address: 1405-207 West Hastings Street

City: Vanvouver

State_or_Province: BC

Postal_Code: V6B 1H7

Country: Canada

Contact_Voice_Telephone: 604-696-5044

Contact_Electronic_Mail_Address: crobb@livingoceans.org

Metadata_Standard_Name: FGDC Content Standards for Digital Geospatial Metadata

Metadata_Standard_Version: FGDC-STD-001-1998

Metadata_Time_Convention: local time

Metadata_Extensions:

Online_Linkage: <http://www.esri.com/metadata/esriprof80.html>

Profile_Name: ESRI Metadata Profile

Metadata_Extensions:

Online_Linkage: <http://www.esri.com/metadata/esriprof80.html>

Profile_Name: ESRI Metadata Profile

Metadata_Extensions:

Online_Linkage: <http://www.esri.com/metadata/esriprof80.html>

Profile_Name: ESRI Metadata Profile