Export File Formats

Field

Description

Family Number

Numeric, zero if a trip record

Species Number

Numeric, zero if a trip record

SubSpecies Number

Numeric, zero if a trip record

Species Common Name

String max 50 characters.  Blank if a trip record

Species Scientific Name

String Max 60 characters.  Blank if a trip record

Site Name

String max 75 characters

First Date Seen

Date

Last Date Seen

Date

First Time

Time in format hh:mm.  Blank if no time

Last Time

Time in format hh:mm.  Blank if no time

Number Seen

Numeric

Circa

Character, blank if Number Seen is an accurate count; C if Number Seen is approximate.

New Count

Count of number of new individuals included in Number Seen. Blank if no New Count entered.

Status

Zero or more Status codes separated by commas.

Ages

Zero or more Age entries separated by a ; character.  Age entries are of the format AgeCode,Sex,Count:

e.g. 1 adult male, 2 adult females and 4 immatures of unknown sex would be represented as:

Ad,M,1;Ad,F,2;Imm,?,4

Notes

String.  Unlimited

Repeat Record Indicator

Repeat Record Indicator. Set to R if the sighting is a repeat. i.e. New Count is not blank.

Observer Initials

One or more Observer Initials separated by commas. e.g. "JL,PS"

Map Reference

Display version of the trip Map Reference

Latitude

Trip Latitude in Degrees

Longitude

Trip Longitude in Degrees

Altitude

Trip Altitude

Field

Description

Family Number

Numeric

Species Number

Numeric

SubSpecies Number

Numeric

Species Common Name

String max 50 characters.  Blank if a trip record

Species Scientific Name

String Max 60 characters.  Blank if a trip record

Sightings Count

Numeric, number of sighting records referring to this species for this list.

Individuals Count

Numeric, total number of individuals seen.

First Date Recorded

Date.  First date this species seen

Last Date Recorded

Date.  Last date this species seen

Earliest Date in Year

String, Day and month followed by year e.g. "01/01 in 1995"

Latest Date in Year

String, Day and month followed by year e.g. "21/12 in 2001"

Status of record

e.g. Heard, Pending etc.

First Recorded Site Name

String (max 75 chars).  Name of site where first recorded

First Recorded State Name

String (max 75 chars).  Name of state where first recorded

First Recorded Country Name

String (max 75 chars).  Name of country where first recorded

First Recorded Faunal Zone Name

String (max 75 chars).  Name of faunal zone where first recorded

First Recorded Continent Name

String (max 75 chars).  Name of continent where first recorded

Last Recorded Site Name

String (max 75 chars).  Name of site where last recorded

Last Recorded State Name

String (max 75 chars).  Name of state where last recorded

Last Recorded Country Name

String (max 75 chars).  Name of country where last recorded

Last Recorded Faunal Zone Name

String (max 75 chars).  Name of faunal zone where last recorded

Last Recorded Continent Name

String (max 75 chars).  Name of continent where last recorded

Earliest Recorded Site Name

String (max 75 chars).  Name of site where recorded earliest in year

Earliest Recorded State Name

String (max 75 chars).  Name of state where recorded earliest in year

Earliest Recorded Country Name

String (max 75 chars).  Name of country where recorded earliest in year

Earliest Recorded Faunal Zone Name

String (max 75 chars).  Name of faunal zone where recorded earliest in year

Earliest Recorded Continent Name

String (max 75 chars).  Name of continent where recorded earliest in year

Latest Recorded Site Name

String (max 75 chars).  Name of site where recorded latest in year

Latest Recorded State Name

String (max 75 chars).  Name of state where recorded latest in year

Latest Recorded Country Name

String (max 75 chars).  Name of country where recorded latest in year

Latest Recorded Faunal Zone Name

String (max 75 chars).  Name of faunal zone where recorded latest in year

Latest Recorded Continent Name

String (max 75 chars).  Name of continent where recorded latest in year

Months Seen

String (max 48 chars). Months recorded separated by commas e.g. "Jan,Aug,Sep"

Years Seen

String (unlimited). Years recorded separated by commas e.g. "1991,2002,2003"

Field

Description

Name

String max 75 characters.  Name of the location

State Name

String max 75 characters.  Name of the state for the location

Country Name

String max 75 characters.  Name of the country for the location

NW Map Reference

String.  The map reference for the NW corner of the area, or the single point location.  

SE Map Reference

String.  The map reference for the SE corner of the area.  Blank if a single point reference was given.

Lowest Altitude

Numeric.  The lowest altitude within the area

Highest Altitude

Numeric.  The highest altitude within the area

Habitats

String.  List of the habitat codes separated by commas

Notes

String.  Location notes

Faunal Zone Name

String (max 75 chars).  Name of faunal zone for the location

Continent Name

String (max 75 chars).  Name of continent for the location

County Name

String (max 75 chars).  Name of county for the location

Parent Location Name

String (max 75 chars).  Name of the immediate parent location