Name: Inspection

Display Field: BOXNUM

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• BOXNUM (type: esriFieldTypeString, alias: Box Number, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• DATE (type: esriFieldTypeDate, alias: Date of Inspection, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: true)
• TIME (type: esriFieldTypeString, alias: Time of Inspection, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• OBSERVER (type: esriFieldTypeString, alias: Observer Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SPECIES (type: esriFieldTypeString, alias: Bird Species, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [MOBL: Mountain Bluebird], [BCCH: Black-capped Chickadee], [HOWR: House Wren], ... 9 more ...)
• NESTSTAGE (type: esriFieldTypeString, alias: Stage of Nest, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [NONE: No Nest], [STARTED: Nest Started], [COMPLETE: Nest Completed], ... 2 more ...)
• NUMEGG (type: esriFieldTypeSmallInteger, alias: Number of Eggs, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 15])
• NUMYOUNG (type: esriFieldTypeSmallInteger, alias: Number of Young, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 15])
• AGEYOUNG (type: esriFieldTypeSmallInteger, alias: Age of Young (days from hatch), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 25])
• NUMFLEDGE (type: esriFieldTypeSmallInteger, alias: Number of Fledged Young, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 15])
• FATE (type: esriFieldTypeString, alias: Fate of Nest, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Fledge Success: Fledge Success], [Nest Failure: Nest Failure])
• FAILURE (type: esriFieldTypeString, alias: Nest Failure Code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [01: 01 - House Sparrow], [02: 02 - Tree Swallow], [03: 03 - Mammal (other than squirrel/weasel)], ... 26 more ...)
• ADULTS (type: esriFieldTypeString, alias: Are adults present? If so, provide details., SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• FEMBAND (type: esriFieldTypeSmallInteger, alias: Is the female banded?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• FEMBANDNUM (type: esriFieldTypeString, alias: Female Band Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FEMCOLOUR (type: esriFieldTypeString, alias: Female Band Colours, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MALEBAND (type: esriFieldTypeSmallInteger, alias: Is the male banded?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No], [3: Unknown])
• MALEBANDNUM (type: esriFieldTypeString, alias: Male Band Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MALECOLOUR (type: esriFieldTypeString, alias: Male Band Colours, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• YOUNGBAND (type: esriFieldTypeDate, alias: Date Young Banded, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• YOUNGBANDNUM (type: esriFieldTypeString, alias: Young Band Numbers, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• BOXMGMT (type: esriFieldTypeString, alias: Box Management, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• OTHER (type: esriFieldTypeString, alias: Other Notes, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• BOXID (type: esriFieldTypeGUID, alias: GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Inspection
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• BOXNUM:
• DATE: -2209161600000

Relationships:

• Box (0) -- Related To: Bird Box (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/24/2017 3:32:21 PM

Schema Last Edit Date: 6/24/2017 3:32:21 PM

Data Last Edit Date: 6/24/2017 3:32:21 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Add Features   Update Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat