Overview

The estimated time to complete this lab is 45 minutes.

In this lab, you will create a column, a set of simple measures using distinct count, max, min, calculate and divide. You also will set up a Date table used for Time intelligence and Quick measure.

  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:

ORDER	FIELD	DATA FORM	DESCRIPTION
1	OBJECTID		Unique identifier for each record
2	DATE_CAPTURED	date	Date of capture
3	SCIENTIFIC_NAME	text x 50	Scientific name
4	COMMON_NAME	text x 50	Common name
5	CAPTURE_METHOD	text x 50	Method of capture
6	TOTAL_LENGTH	float	Length (cm) between the tip of snout and the tip of tail
7	HEAD_LENGTH	float	Length (cm) between the tip of snout and the end of dorsal cranial platform
8	SEX	float	Female or male
9	SNOUT_VENT_LENGTH	text x 1	Length (cm) between the tip of snout and the beginning of vent (cloaca)
10	TAIL_COMPLETE	text x 1	Whether the tail is complete or not
12	REGION	text x 50	The region for management zones are Katherine, Nhulunbuy, Darwin, Borroloola and Other/Unknown
13	ZONE_NAME	text x 50	The capture zones are divided into 9 zones: Upper Harbour, Lower Harbour, Shoal Bay, Management Zone, Katherine, Borroloola, Litchfield, Nhulunbuy and Outside Management Zone.
14	ZONE_CODE	number	The code for capture zones
15	GROUP_NAME	text x 50	The location group of traps inside the capture zones
16	LOCATION	text x 50	The location area of traps inside the location group