Table | Name | Field Alias | Data Type | Description |
Flora.Phytophthora | PARK_ID | | Character | Unique identifier for reserves created in the Protected Area Information System (PAIS) |
Flora.Phytophthora | BIOREGION | | Character | IBRA or IMCRA Region code derived from a spatial overlay between the regions and the species observations. Where there is overlap of the regions for Offshore Islands IBRA took precedence. |
Flora.Phytophthora | BIOREGIONNAME | | Character | IBRA or IMCRA Region name derived from a spatial overlay between the regions and the species observations. Where there is overlap of the regions for Offshore Islands IBRA took precedence. |
Flora.Phytophthora | FLORACODE | | Character | Generated from a combination of the first 2 letters of the database (eg SU = Survey), the first letter of the taxon group (eg P = Plant) and the unique identifier from that database (eg Opportune uses SIGHTINGNR, Survey uses VISITNR and SPSEQNR, Plant Population uses POPULATIONNR and VISITNR and Reserves uses PLANTSPNR). For example, SUP10814-55, or OPP226709. |
Flora.Phytophthora | NSXCODE | | Character | Unique code for each taxonomic entity (species name) in the database used to allow record taxonomy to be updated as changes occur. |
Flora.Phytophthora | LATITUDE | | Integer | The latitude coordinate of the sighting in GDA94 and decimal degrees. |
Flora.Phytophthora | LONGITUDE | | Integer | The longitude coordinate of the sighting in GDA94 and decimal degrees. |
Flora.Phytophthora | MGAZONE | | Integer | The Map Grid of Australia 1994 Zone that the Eastings and Northings relate to, eg Zone 52, 53 or 54. |
Flora.Phytophthora | EASTING | | Integer | The easting (x) coordinate of the sighting in Map Grid of Australia 1994 coordinate system. |
Flora.Phytophthora | NORTHING | | Integer | The northing (y) coordinate of the sighting in Map Grid of Australia 1994 coordinate system. |
Flora.Phytophthora | SIGHTINGDATE | | Date | The date the sighting occurred. Always check the DATEACCURACY where SIGHTINGDATE is the 1st of a month or year. |
Flora.Phytophthora | DATEACCURACY | | Character | Accuracy of the sighting date. If SIGHTING DATE is the 1st of a month or year it may be that the record was observed on that day (D), sometime that month (M), sometime that year (Y), sometime that decade (T) or sometime that century (C). |
Flora.Phytophthora | SIGHTINGNR | | Integer | Only populated for Opportune records, (where SOURCE = OP). It is a unique identifier generated in the database for each unique species record |
Flora.Phytophthora | RELIABNR | | Number | Estimation of positional accuracy of the coordinates (In Reserves this field is generated by spatially determining the maximum distance from the centroid to the boundary of the reserve). The description of these codes is available in RELIABDESC. |
Flora.Phytophthora | RELIABDESC | | Character | Description of RELIABNR, and relates to the positional reliability of the coordinates, (eg 0-5m, 1-10km, etc). |
Flora.Phytophthora | SPRELIABCODE | | Character | The reliability that the species was correctly identified. A filter has been applied to the dataset so that only records with "Y" Or "A" Or "P" and 1-4 are included. Plant Population codes are 1=Voucher in a state herbarium: ID by herbarium staff or taxonomist, 2=ID by herbarium staff or taxonomist, 3=ID by experienced field botanist, 4=Unconfirmed field sighting, and 5=Correct ID doubtful. |
Flora.Phytophthora | OBSERVER | | Character | The person(s) who observed the species. |
Flora.Phytophthora | ISCURRENT | | Character | Currency of the species name. Indicates whether any taxonomic changes have occurred since the observation. Y = taxonomy still current. N = taxonomy has been updated and the record taxonomy needs to be resolved. |
Flora.Phytophthora | ISINDIGENOUS | | Character | Identification of species as introduced/native: introduced = *, native = blank. |
Flora.Phytophthora | SPECIES | | Character | Taxonomic name for species observed (combined GENUSNAME and SPECIESNAME). Eg. "Phytothora cinnamomi". Taxonomic names that no longer are current (ISCURRENT=N) have (NC) appended after the species name |
Flora.Phytophthora | GENUSNAME | | Character | Taxonomic genus of species observed. Eg "Phytopthora". |
Flora.Phytophthora | SPECIESNAME | | Character | Taxonomic species name (doesn't include genus) of species observed. Eg "cinnamomi". |
Flora.Phytophthora | SIGHTINGCOM | | Character | Describes the status of the Phythopthora record i.e. tested and confirmed, tested and not confirmed, or not tested and not confirmed |
Flora.Phytophthora | SURVEYNR | | Integer | Survey number given to records collected ina particular way or purpose, generally within the survey databae but data could be stored in other databases. |
Flora.Phytophthora | LOCATIONCOMM | | Character | Location Description. |
Flora.Phytophthora | HABITATCOM | | Character | Describes habitat community information |
Flora.Phytophthora | GENLOC | | Character | Generated location information using SA gazetteer and nearest location analysis. |
Flora.Phytophthora | RESERVENAME | | Character | Reserve name concatenated with Block Name |
Flora.Phytophthora | NRMDISTRICT | | Character | NRM districts are a subdivision of NRM regions and are derived via spatial overlay of the species observations with the NRM Regions spatial dataset. |
Flora.Phytophthora | NRMREGION | | Character | NRM regions derived via spatial overlay of the species observations with the NRM Regions spatial dataset. |
Flora.Phytophthora | ISDENATURED | | Character | This flags to users species that have been classified as environmentally sensitive and their distribution to the public should be limited to 0.1 decimal degree. When DEWNR delivers data to the public these records will be denatured to 0.1 decimal degree. Definition of content is 'Environmentally Sensitive - One decimal degree' or 'N'. |
Flora.Phytophthora | SOURCE | | Character | Source of database record derived eg. from Opportune (OP), Reserves (RE), Survey (SU), State Herbarium (AD), Plant Population (PP), Roadside (RV) data bases. |
Flora.Phytophthora | PATCHID | | Integer | Populated for records from the Survey and Opportune datasets. It is a Unique identifier for each site, where there may have been several species recorded. |
Flora.Phytophthora | VISITNR | | Integer | Identifies the unique visit identifier of the database for the visit, that is used in the FLORACODE. |
Flora.Phytophthora | SPECIESTYPE | | Character | Identifies the taxa group (e.g.P = Plants) of the observation, that is used in the FLORACODE. |
Flora.Phytophthora | HERBREGION | | Character | Herbarium Region generated by a spatial overlaying of the species observations and Herbarium regions spatial dataset. |
Flora.Phytophthora | BIOSUBREGION | | Character | The IBRA subregion code or IMCRA code used as part of the Regional Species Conservation assessment project. This is based on IBRA subregions version 6.2 and IMCRA regions. |
Flora.Phytophthora | BIOSUBREGIONNAME | | Character | IBRA subregion or IMCRA region name used as part of the Regional Species Conservation assessment project. This is based on IBRA subregions version 6.2 and IMCRA regions. |
Flora.Phytophthora | DISTRIBNCODE | | Character | Identifies permissions for access based on surveys. DISTRIBUTNCODE = 1 = CODE 1:DISTRIBUTE ACCORDING TO DENR POLICY -need to confirmSELECT 1 FROM DUAL;
DISTRIBUTNCODE = 2 = CODE 2:DISTRIBUTE ACCORDING TO DENR POLICYSELECT 1 FROM DUAL;
DISTRIBUTNCODE = 3 = CODE 3:DISTRIBUTE ACCORDING TO DENR POLICY -DENR only & approved clientsSELECT 1 FROM DUAL;
DISTRIBUTNCODE = 4= CODE 4:DISTRIBUTE ACCORDING TO DENR POLICY -GOVTSELECT 1 FROM DUAL;
DISTRIBUTNCODE = 5 = CODE 5:DISTRIBUTE ACCORDING TO DENR POLICY -see specific conditions and DISTRIBUTNCODE = TEMP = CODE TEMP:CONTACT OWNER TO CLARIFY. |
Flora.Phytophthora | DISTRIBNDESC | | Binary | The DISTRIBUTNDESC provides extra information to the DISTRIBNCODE, to clarify the code. |
Flora.Phytophthora | RESERVETYPE | | Character | Reserve type for Reserve (if the sighting was recorded within the boundaries of a Reserve). CP = Conservation Park, CR = Conservation Reserve, GR = Game Reserve, HA = Heritage Agreement, LF = Locality Forest, LG = Local Government Reserve, LR, = Local Reserve, NF = Native Forest, NT = National Trust, NP = National Park, RP = Recreation Park, RR = Regional Reserve, WA = Wilderness Area. This is derived via a spatial overlay of the sighting with the appropriate spatial dataset. For qualification on roadside vegetation species locations refer to the details under PARK_ID. |
Flora.Phytophthora | RESERVECODE | | Long Integer | Reserve Code for Reserve is a number designated for each reserve (if the sighting was recorded within the boundaries of a Reserve). Reserve Code uniquely identifies the Reserve (e.g. 1012). This is derived via a spatial overlay of the sighting with the appropriate spatial dataset. For qualification on roadside vegetation species locations refer to the details under PARK_ID. |
Flora.Phytophthora | SPSEQNR | | Long Integer | Unique species number from the database that is used in the FLORACODE. |
Flora.Phytophthora | POPULATIONNR | | Long Integer | Only populated for Plant Population records, (where SOURCE = PP). It is a unique identifier for each plant population recorded. |