Name: Trends4GIS_Hatchret

Display Field: StreamAndTribNames

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 6e60158738974e9688754b7328a2145f

Copyright Text: null

Default Visibility: false

MaxRecordCount: 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 TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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 Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

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

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