Layer: Freshwater Fish (ID:0)

View In: Map Viewer

Name: Freshwater Fish

Display Field: catchname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: The New Zealand Freshwater Fish Database (NZFFD), managed by NIWA, contains over 34,000 freshwater fish observationsfor New Zealand, and over 1800 for Nelson City region.Data stored include:the location of the sample sites, the fish species present, information of their abundance and size, sampling methods,physical description of each site In recent years, data from the River Environment Classification (REC) has also been linked to the NZFFD, adding further environmental information to each NZFFD record.About the data:The source of truth for this data is the NZ Freshwater Fish Database https://nzffdms.niwa.co.nz/The data has been downloaded for Nelson City only and then summarised by the Nelson City Council.It is planned to be updated annually. This copy was extracted 2/8/2017in CSV format.Workflow to update data:Download Data https://nzffdms.niwa.co.nz/as CSVConvert downloaded data as Excel (XLS or XLSX)Run Tool "Create Fish Database" (G:\Projects\EnvironmentalMonitoring\EnvironmentalMonitoringSites\Dev)What the tool is doing:Creating a backup ('CopyFeature')Converting Excel sheet to Point Feature ('Excel to Table' > 'Make XY Event Layer' > 'Feature to Point')Clipping the Pint Feature to NCC Extent ('Clip')Project to NZDM ('Project') Note: Original reference system is NZMGAdd field for 'scientific name' and 'common name' ('Add Field') (see 'Source Data' for more information)Insert new values for 'scientific name' and 'common name' ('Field Calculator')Overwrite old feature data ('Delete feature' > 'Append')Source DataThe source data can be downloaded on the NIWA web page https://nzffdms.niwa.co.nz/or https://nzffdms.niwa.co.nz/searchThe data includes information about the date of observation, stream name, catchment number, locality, data source, coordinates and height, method and species code.Catchment number important for Nelson are: 573, 575.02, 157.6, 577, 578, 578.01, 578.02, 578.021, 579, 580, 581, 581.02, 581.03, 583, 583.01 and 583.02The species codes were decoded for better understanding (see workflow step 3.6). A full list of species can be found as XLS at NIWAThe source reference system is NZGM and has to be reprojected to NZDM (see workflow step 3.4)

Copyright Text: NIWA - New Zealand Freshwater Fish Database (NZFFD) https://nzffdms.niwa.co.nz

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[133,0,11,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
card (type: esriFieldTypeInteger, alias: card, SQL Type: sqlTypeOther, nullable: true, editable: true)
m (type: esriFieldTypeInteger, alias: m, SQL Type: sqlTypeOther, nullable: true, editable: true)
y (type: esriFieldTypeInteger, alias: y, SQL Type: sqlTypeOther, nullable: true, editable: true)
catchname (type: esriFieldTypeString, alias: catchname, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
catch (type: esriFieldTypeString, alias: catch, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
locality (type: esriFieldTypeString, alias: locality, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
time (type: esriFieldTypeString, alias: time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
org (type: esriFieldTypeString, alias: org, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
map (type: esriFieldTypeString, alias: map, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
east (type: esriFieldTypeInteger, alias: east, SQL Type: sqlTypeOther, nullable: true, editable: true)
north (type: esriFieldTypeInteger, alias: north, SQL Type: sqlTypeOther, nullable: true, editable: true)
altitude (type: esriFieldTypeInteger, alias: altitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
penet (type: esriFieldTypeInteger, alias: penet, SQL Type: sqlTypeOther, nullable: true, editable: true)
fishmeth (type: esriFieldTypeString, alias: fishmeth, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
effort (type: esriFieldTypeInteger, alias: effort, SQL Type: sqlTypeOther, nullable: true, editable: true)
pass (type: esriFieldTypeInteger, alias: pass, SQL Type: sqlTypeOther, nullable: true, editable: true)
spcode (type: esriFieldTypeString, alias: spcode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
abund (type: esriFieldTypeString, alias: abund, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
number (type: esriFieldTypeInteger, alias: number, SQL Type: sqlTypeOther, nullable: true, editable: true)
minl (type: esriFieldTypeInteger, alias: minl, SQL Type: sqlTypeOther, nullable: true, editable: true)
maxl (type: esriFieldTypeInteger, alias: maxl, SQL Type: sqlTypeOther, nullable: true, editable: true)
nzreach (type: esriFieldTypeInteger, alias: nzreach, SQL Type: sqlTypeOther, nullable: true, editable: true)
ORIG_FID (type: esriFieldTypeInteger, alias: ORIG_FID, SQL Type: sqlTypeOther, nullable: true, editable: true)
ScientificName (type: esriFieldTypeString, alias: ScientificName, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
CommonName (type: esriFieldTypeString, alias: CommonName, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/25/2019 1:41:47 AM

Schema Last Edit Date: 3/25/2019 1:41:47 AM

Data Last Edit Date: 3/25/2019 1:41:47 AM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat