Name: Trends4GIS_Escdata

Display Field: StreamName

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

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