BonapartesGull_Autumn

Metadata also available as

Metadata:

Identification_Information:
Citation:
Citation_Information:
Originator:
The British Columbia Marine Conservation Analysis (BCMCA), a Tides Canada Initiatives Project
Publication_Date: 03/2010
Title: BonapartesGull_Autumn
Geospatial_Data_Presentation_Form: vector digital data
Online_Linkage:
\\vancouverserver\gis\BCMCA\data4Marxan_May2010\Seabirds\nearshore_marxan_features.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 socio-economic 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 Bonaparte's gull autumn sites (September, October), process and summarize weighted densities by BCMCA planning unit to help inform the marine feature identified at the BCMCA Seabirds Workshop. Data presented as 2 km x 2 km planning units for MARXAN analysis.
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.BC Ferry Swartz Bay to Tsawwassen (transects_poly150.shp). 4.Victoria Capital Region District Harbours Atlas. (Bird_survey_polygons.shp).
Time_Period_of_Content:
Time_Period_Information:
Single_Date/Time:
Calendar_Date: unknown
Currentness_Reference: ground condition
Status:
Progress: In work
Maintenance_and_Update_Frequency: Unknown
Spatial_Domain:
Bounding_Coordinates:
West_Bounding_Coordinate: -130.811407
East_Bounding_Coordinate: -122.356580
North_Bounding_Coordinate: 54.421448
South_Bounding_Coordinate: 48.268224
Keywords:
Theme:
Theme_Keyword_Thesaurus:
REQUIRED: Reference to a formally registered thesaurus or a similar authoritative source of theme keywords.
Theme_Keyword: Bonaparte's gull
Theme_Keyword: autumn
Theme_Keyword: weighted densities
Place:
Place_Keyword: British Columbia
Access_Constraints:
This dataset is subject to the terms and conditions of a data license agreement.
Use_Constraints:
This dataset is subject to the terms and conditions of a data license agreement:
Point_of_Contact:
Contact_Information:
Contact_Organization_Primary:
Contact_Organization: British Columbia Marine Conservation Analysis
Contact_Person: Karin Bodtker
Contact_Position: 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: 604-696-5044
Contact_Electronic_Mail_Address: kbodtker@livingoceans.org
Native_Data_Set_Environment:
Microsoft Windows XP Version 5.1 (Build 2600) Service Pack 2; ESRI ArcCatalog 9.3.1.3500
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:
BC Ferry Swartz Bay to Tsawwassen. Dataset name: transects_poly150.shp. Metadata document: ferrySurveys_meta20080208.doc. Extent: Southern Strait of Georgia. Strip transects conducted aboard BC Ferry vessel transiting between the Swartz Bay and Tsawwassen terminals. Counts were conducted during four back to back crossings, on each of three consecutive days (for a total of 12 crossings) each month. The area (km2) surveyed was determined using the width on either side of vessel 150m. DBF table (Survey_data) contains estimated segment length, survey width, and area. Bird densities derived from counts/area (km sq). Spatial data supplied consists of line shapefile with original transect linework, and polygon shapefile with transects buffered to a 300m total width. Refer to original metadata document (listed above) for more information regarding survey background, methodology and data limitations.
Source_Information:
Source_Contribution:
Victoria Capital Region District Harbours Atlas. Dataset name: Bird_survey_polygons.shp. Metadata document: Not supplied, however, updated using ArcCatalog. CRD supplied 2 spatial polygon layers (Bird_survey_polygons & VEHEAP_Harbours_Sub_Areas), 2 DBF's (HARB9798 & HARB99), and 2 excel workbooks (Biird_S_Graphs & Bird_Survey_wo_Marine-Birds_By_Area_And_Season). Polygons used for displaying data from 1997-1999 bird surveys. Includes Portage Inlet, Gorge Waterway, Victoria Harbour, Esquimalt Harbour, and Esquimalt Lagoon. Note: Used HEIR (TRIM where there was no HEIR) shore combined with polygons digitized from un-projected file used for original survey.
Source_Information:
Source_Contribution: BCMCA 2 km x 2 km planning units for the Canadian Pacific EEZ.
Process_Step:
Process_Description:
<<The methods used to combine datasets to identify areal extents and densities of Bonaparte's gull autumn 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 = 'BOGU' with survey months >8 and <11. Exported selected species' records into a feature table. 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' autumn 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 survey tables. 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: Using MS Access query, selected all records within cwidat_bc table where SPECIES = 'BOGU' with survey months >8 and <11. Since the SEASON field within CWI dataset does not necessarily correlate with BCMCA specified "autumn" months, used the DATE field in query rather than season field. Exported selected species' records into a feature table.
Process_Step:
Process_Description:
Re-projected cwi_bc.shp from PCS Albers to NAD 1983 BC Environment Albers using Project tool. 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. A new field was created (UNIQUEID) in the spatial which correlates to the shoreunits listed in the SHOREUNIT2 field. Joined cwidat_bc feature table to spatial layer using UNIQUEID 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:
<<Prepared BC Ferry dataset: Added a new field within the Survey_data table to store the date (within first 6 digits of Transect_ID field) and calculated to read yyyy/mm/dd format. Selected all records within Survey_data where [BOGU] > 0, and survey months >8 and <11. Species' records meeting the criteria were exported into a feature table. 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' autumn specifications within each segment (i.e. each date instance was assigned a value of 1), and then grouped and ordered by Segment_ID. 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 Segment. A similar query to the above was used to calculate the surveys in which species were sighted. Data was recorded in various time intervals along a segment on a given survey date. In these cases, only the first unique survey date was given a count value of one to avoid redundant survey counts and for consistency with the total surveys count.
Process_Step:
Process_Description:
For each Segment_ID, summarized feature table by average bird counts. Included the number of surveys in which the species was sighted and the total number of survey tables. Added 4 fields using Add Field tool: Season, Feature, Data_Source, Dataset_ID. 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 the common name of the marine species as identified within species code attribute. 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. Joined feature table to spatial layer using Segment_ID field in the table and Segment field in the spatial and exported into a feature class. Re-project from NAD 1983 Albers to NAD 1983 BC Environment Albers using Project tool. Buffered line segments by 150m (radius) using Buffer tool.
Process_Step:
Process_Description:
<<Prepared CRD dataset: Prepared Year_Round_Calcs excel spreadsheet within Biird_S_Graphs.xls and imported to a geodatabase table. Re-formatted Date_field to string and (yyyy/mm/dd) format. Using Microsoft Access query builder, selected all Species equal to 'BOGU' with months >8 and <11. Species' records meeting the criteria were extracted into a feature table. To calculate the total number of surveys, two queries were created. The first query was created to record all instances of survey dates meeting the features' autumn specifications within each polygon (i.e. each date instance was assigned a value of 1), and then 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. A similar query to the above was used to calculate the surveys in which species were sighted. In some cases, data was recorded within a polygon on the same survey date, usually when there was more than one observer. In these cases, only the first unique survey date was given a count value of one to avoid redundant survey counts and for consistency with the total surveys count.
Process_Step:
Process_Description:
Re-projected Bird_surveys_polygons from NAD 1983 UTM Zone 10N to NAD 1983 BC Environment Albers using Project tool. For each polygon, summarized feature table by average bird counts. Included total species sighted and total number of survey tables. Added 4 new fields using Add Field tool: Season, Feature, Data_Source, Dataset_ID. 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 the common name of the marine species as identified within the Species field. 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. Joined feature tables to spatial layer using Poly field in spatial and Polygon field in table and exported to a feature class. Deleted unnecessary field using Delete Field tool.
Process_Step:
Process_Description:
<<Reviewed MBAOI, WCVI, Moulting Sea Ducks, LBCS, Burger data: Dataset was not used for feature creation as all data within MBAOI has already been received and processed. Dataset was not used for feature creation as all BOGU species identified did not meet the specified "autumn" month feature requirements.
Process_Step:
Process_Description:
Merged all prepared datasets using Merge tool to create one layer storing all Bonaparte's gull autumn 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.
Process_Step:
Process_Description: Created Metadata.
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]. Note: PSS data was not used to create feature as behaviour did not include on water counts (ie behaviour = 2).
Process_Step:
Process_Description: Updated 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: 
>Created Final Processed File:
Overlaid merged feature polygons with BCMCA planning units using Spatial Join tool. Tool parameter example: Target Feature = BCMCA PU, 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: Melissa Meneghetti
Contact_Organization: Coastal Resource Mapping
Process_Step:
Process_Description: 
>Created Marxan File:
Reviewed the distribution of the data in the final processed file using 5 quantiles as defined by BCMCA. Deleted the planning units with average densities that fell within the bottom quantile. Species was used to create the at-sea density feature. To avoid double representation, overlaid feature with at_sea_density.shp and deleted planning units from the marxan file that were identical to those planning units with densities greater than zero in the at sea density feature.
Process_Step:
Process_Description:
The distribution of average density values across the BCMCA planning units was examined for normality and it was found to be skewed (i.e., there were a few very large values which would have biased Marxan toward choosing these planning units to meet any target set). To account for this, the density values were transformed using a natural log function to normalize the data. Then the transformed values were shifted (if below zero) such that the lowest value was equal to 1 (i.e., a positive constant was added to each value). The values in the [Transform_Density] field are the result of this transformation and the distribution of these values across the planning units is near-normal.
Process_Contact:
Contact_Information:
Contact_Person_Primary:
Contact_Person: All steps performed by Melissa Meneghetti
Contact_Organization: Coastal Resource Mapping
Contact_Position: Spatial Analyst
Process_Step:
Process_Description: Unit ID updated to match new BCMCA planning unit IDs
Source_Used_Citation_Abbreviation:
O:\BCMCA\Data_Andy_temp_June07\Nearshore_metadata\BonapartesGull_Autumn.xml
Process_Date: June 2010
Process_Contact:
Contact_Information:
Contact_Person_Primary:
Contact_Person: Andy Pettersson
Contact_Organization: BCMCA
Contact_Position: GIS Contractor
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: 158
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: BonapartesGull_Autumn
Attribute:
Attribute_Label: OBJECTID_1
Attribute_Definition: Internal feature number.
Attribute_Definition_Source: ESRI
Attribute_Domain_Values:
Unrepresentable_Domain:
Sequential unique whole numbers that are automatically generated.
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: UNIT_ID
Attribute:
Attribute_Label: Shape
Attribute_Definition: Feature geometry.
Attribute_Definition_Source: ESRI
Attribute_Domain_Values:
Unrepresentable_Domain: Coordinates defining the features.
Attribute:
Attribute_Label: Cnt_UNIT_ID
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_DENSITY_km2
Attribute_Definition:
Sum of the density fields for each survey area by planning unit.
Attribute:
Attribute_Label: AVG_DENSITY_km2
Attribute_Definition: Weighted average by dividing the density sum by the survey sum.
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: LOG
Attribute_Definition:
The average density values were transformed using a natural log function in Arcmap to normalize the data.
Attribute:
Attribute_Label: TRANSFORM_DENSITY
Attribute_Definition:
The transformed values were shifted such that the lowest value was equal to 1 by applying a positive constant to all values to achieve a near-normal distribution.
Attribute:
Attribute_Label: ID
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_Person_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: 20100617
Metadata_Contact:
Contact_Information:
Contact_Organization_Primary:
Contact_Organization: Living Oceans Society (for BCMCA)
Contact_Person: Carrie Robb
Contact_Position: GIS Specialist
Contact_Address:
Address_Type: mailing and physical address
Address: 1405-207 W. Hastings St.
City: Vancouver
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
Generated by mp version 2.9.6 on Thu Aug 26 15:10:41 2010