Name: Trends4GIS_Hatchret

Display Field: StreamAndTribNames

Type: Table

Geometry Type: N/A

Description: N/A

Service Item Id: 6e60158738974e9688754b7328a2145f

Copyright Text: N/A

Default Visibility: false

Max Result Window: N/A

Max Record Count: 2000

Standard Max Record Count No Geometry: N/A

Max Record Count Factor: 1

Standard MaxRecord Count: 32000

Tile Max Record Count: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: false

Has Last Edit Time: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: N/A

Fields:

• OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
• trendid ( nullable: false, alias: trendid, type: esriFieldTypeInteger )
• popid ( nullable: true, alias: popid, type: esriFieldTypeInteger )
• LocationID ( nullable: false, length: 13, alias: LocationID, type: esriFieldTypeString )
• endyear ( nullable: true, alias: endyear, type: esriFieldTypeSmallInteger )
• StreamAndTribNames ( nullable: true, length: 160, alias: StreamAndTribNames, type: esriFieldTypeString )
• RiverMiles ( nullable: true, length: 75, alias: RiverMiles, type: esriFieldTypeString )
• Species ( nullable: true, length: 50, alias: Species, type: esriFieldTypeString )
• Run ( nullable: true, length: 50, alias: Run, type: esriFieldTypeString )
• SubRun ( nullable: true, length: 50, alias: SubRun, type: esriFieldTypeString )
• Production ( nullable: true, length: 50, alias: Production, type: esriFieldTypeString )
• LifeStage ( nullable: true, length: 50, alias: LifeStage, type: esriFieldTypeString )
• LifeHistoryType ( nullable: false, length: 80, alias: LifeHistoryType, type: esriFieldTypeString )
• DataCategory ( nullable: true, length: 25, alias: DataCategory, type: esriFieldTypeString )
• TrendComment ( nullable: true, length: 1073741822, alias: TrendComment, type: esriFieldTypeString )
• HistoricalStatus ( nullable: true, length: 250, alias: HistoricalStatus, type: esriFieldTypeString )
• TrendStatus ( nullable: true, length: 250, alias: TrendStatus, type: esriFieldTypeString )
• StatusComment ( nullable: true, length: 83, alias: StatusComment, type: esriFieldTypeString )
• Hatchery ( nullable: false, length: 100, alias: Hatchery, type: esriFieldTypeString )
• Dam ( nullable: true, length: 65, alias: Dam, type: esriFieldTypeString )
• BPAProjNum ( nullable: true, length: 50, alias: BPAProjNum, type: esriFieldTypeString )
• PopulationName ( nullable: true, length: 120, alias: PopulationName, type: esriFieldTypeString )
• CompiledBy ( nullable: false, length: 15, alias: CompiledBy, type: esriFieldTypeString )
• KeyDate ( nullable: true, length: 10, alias: KeyDate, type: esriFieldTypeString )
• BeginDate ( nullable: true, length: 10, alias: BeginDate, type: esriFieldTypeString )
• EndDate ( nullable: true, length: 10, alias: EndDate, type: esriFieldTypeString )
• NullFlag ( nullable: false, length: 3, alias: NullFlag, type: esriFieldTypeString )
• Total ( nullable: true, alias: Total, type: esriFieldTypeInteger )
• Females ( nullable: true, alias: Females, type: esriFieldTypeInteger )
• Males ( nullable: true, alias: Males, type: esriFieldTypeInteger )
• Jacks ( nullable: true, alias: Jacks, type: esriFieldTypeInteger )
• Unknown_ ( nullable: true, alias: Unknown_, type: esriFieldTypeInteger )
• Morts ( nullable: true, alias: Morts, type: esriFieldTypeInteger )
• BeginSpawn ( nullable: true, length: 10, alias: BeginSpawn, type: esriFieldTypeString )
• EndSpawn ( nullable: true, length: 10, alias: EndSpawn, type: esriFieldTypeString )
• FemalesSpawned ( nullable: true, alias: FemalesSpawned, type: esriFieldTypeInteger )
• MalesSpawned ( nullable: true, alias: MalesSpawned, type: esriFieldTypeInteger )
• JacksSpawned ( nullable: true, alias: JacksSpawned, type: esriFieldTypeInteger )
• EggsTaken ( nullable: true, alias: EggsTaken, type: esriFieldTypeInteger )
• Comments ( nullable: true, length: 1000, alias: Comments, type: esriFieldTypeString )
• ASNID ( nullable: false, alias: ASNID, type: esriFieldTypeInteger )
• AgeStructure ( nullable: false, length: 56, alias: AgeStructure, type: esriFieldTypeString )
• AsSource ( nullable: true, length: 100, alias: AsSource, type: esriFieldTypeString )
• AgingMethod ( nullable: false, length: 37, alias: AgingMethod, type: esriFieldTypeString )
• RefID ( nullable: false, alias: RefID, type: esriFieldTypeInteger )
• Citation ( nullable: true, length: 1073741822, alias: Citation, type: esriFieldTypeString )
• CitationURL ( nullable: true, length: 1000, alias: CitationURL, type: esriFieldTypeString )
• Agency ( nullable: true, length: 15, alias: Agency, type: esriFieldTypeString )
• SNLoadDate ( nullable: true, length: 10, alias: SNLoadDate, type: esriFieldTypeString )
• LastUpdated ( nullable: true, length: 10, alias: LastUpdated, type: esriFieldTypeString )
• LastModifiedOn ( nullable: true, length: 10, alias: LastModifiedOn, type: esriFieldTypeString )
• id ( nullable: true, length: 36, alias: id, type: esriFieldTypeString )
• publish ( nullable: false, length: 3, alias: publish, type: esriFieldTypeString )
• apikey ( nullable: true, length: 36, alias: apikey, type: esriFieldTypeString )

Relationships:

• Trends_SuperCodes (5) -- Related To: Time Series (grouped stream locations) (2)
• Trends_Waterbodies (7) -- Related To: Time Series (lake and area locations) (3)
• Trends4GIS (9) -- Related To: Trends4GIS (4)
• Trends_Lines (3) -- Related To: Time Series (stream locations) (1)
• Trends_Points (0) -- Related To: Time Series (point locations) (0)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata