Name: Trends4GIS_Escdata

Display Field: StreamName

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 )
• StreamName ( nullable: false, length: 100, alias: StreamName, type: esriFieldTypeString )
• 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: false, 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 )
• TrendStat ( nullable: true, length: 250, alias: TrendStat, 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 )
• BeginDate ( nullable: true, length: 10, alias: BeginDate, type: esriFieldTypeString )
• EndDate ( nullable: true, length: 10, alias: EndDate, type: esriFieldTypeString )
• MilesSurveyed ( nullable: true, alias: MilesSurveyed, type: esriFieldTypeDouble )
• TimesSurveyed ( nullable: true, alias: TimesSurveyed, type: esriFieldTypeSmallInteger )
• NullFlag ( nullable: false, length: 3, alias: NullFlag, type: esriFieldTypeString )
• SampleMethod ( nullable: true, length: 60, alias: SampleMethod, type: esriFieldTypeString )
• CalcMethod ( nullable: true, length: 50, alias: CalcMethod, type: esriFieldTypeString )
• CountValue ( nullable: true, alias: CountValue, type: esriFieldTypeDouble )
• CountCILowLim ( nullable: true, alias: CountCILowLim, type: esriFieldTypeDouble )
• CountCIUpLim ( nullable: true, alias: CountCIUpLim, type: esriFieldTypeDouble )
• CountCILevel ( nullable: true, alias: CountCILevel, type: esriFieldTypeDouble )
• CountCIDistType ( nullable: true, length: 30, alias: CountCIDistType, type: esriFieldTypeString )
• RepeatSpawners ( nullable: true, alias: RepeatSpawners, type: esriFieldTypeInteger )
• CountPerMile ( nullable: true, alias: CountPerMile, type: esriFieldTypeDouble )
• 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 )
• CountComment ( nullable: true, length: 83, alias: CountComment, 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 )
• TrendStatID ( nullable: true, alias: TrendStatID, type: esriFieldTypeSmallInteger )

Relationships:

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

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

  Iteminfo   Thumbnail   Metadata