Overview

The estimated time to complete this lab is 20 minutes.

In this lab, you will create a Measures table to store future calculations and update fields/tables to make them easier to use.

 This data describes the daily captures within the Northern Territory Crocodile Capture Zones.                                                                                                                                    

The captures are also noted as a yearly cumulative total for each Crocodile Capture Zone.

Custodian:     Parks and Wildlife Commission of the Northern Territory

Agency:         Department of Environment, Parks and Water Security. Northern Territory Government

Metadata:     http://www.ntlis.nt.gov.au/metadata/export_data?type=html&metadata_id=C67DB1A044D43F3BE05

View:             https://nrmaps.nt.gov.au/nrmaps.html

The capture zones can be viewed in NR Maps. See folder: Parks and Culture > Wildlife.

This dataset features date, region and other crocodile capture components making perfect real data for training materials.

Data description:

ORDERFIELDDATA FORMDESCRIPTION
1OBJECTID Unique identifier for each record
2DATE_CAPTUREDdateDate of capture
3SCIENTIFIC_NAMEtext x 50Scientific name
4COMMON_NAMEtext x 50Common name
5CAPTURE_METHODtext x 50Method of capture
6TOTAL_LENGTHfloatLength (cm) between the tip of snout and the tip of tail
7HEAD_LENGTHfloatLength (cm) between the tip of snout and the end of dorsal cranial platform
8SEXfloatFemale or male
9SNOUT_VENT_LENGTHtext x 1Length (cm) between the tip of snout and the beginning of vent (cloaca)
10TAIL_COMPLETEtext x 1Whether the tail is complete or not
12REGIONtext x 50The region for management zones are Katherine, Nhulunbuy, Darwin, Borroloola and Other/Unknown
13ZONE_NAMEtext x 50The capture zones are divided into 9 zones: Upper Harbour, Lower Harbour, Shoal Bay, Management Zone, Katherine, Borroloola, Litchfield, Nhulunbuy and Outside Management Zone.
14ZONE_CODEnumberThe code for capture zones
15GROUP_NAMEtext x 50The location group of traps inside the capture zones
16LOCATIONtext x 50The location area of traps inside the location group