Name: Trends4GIS

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 )
• LocationID ( type: esriFieldTypeString, alias: LocationID, length: 13 )
• BegFt ( type: esriFieldTypeInteger, alias: BegFt )
• EndFt ( type: esriFieldTypeInteger, alias: EndFt )
• LocTypeID ( type: esriFieldTypeSmallInteger, alias: LocTypeID )
• StreamName ( type: esriFieldTypeString, alias: StreamName, length: 100 )
• StreamAndTribNames ( type: esriFieldTypeString, alias: StreamAndTribNames, length: 160 )
• RiverMiles ( type: esriFieldTypeString, alias: RiverMiles, length: 75 )
• SpecieID ( type: esriFieldTypeSmallInteger, alias: SpecieID )
• Species ( type: esriFieldTypeString, alias: Species, length: 50 )
• SciName ( type: esriFieldTypeString, alias: SciName, length: 50 )
• ITIS_TSN ( type: esriFieldTypeString, alias: ITIS_TSN, length: 7 )
• RunID ( type: esriFieldTypeSmallInteger, alias: RunID )
• Run ( type: esriFieldTypeString, alias: Run, length: 50 )
• SubrunID ( type: esriFieldTypeSmallInteger, alias: SubrunID )
• SubRun ( type: esriFieldTypeString, alias: SubRun, length: 50 )
• ProdID ( type: esriFieldTypeSmallInteger, alias: ProdID )
• Production ( type: esriFieldTypeString, alias: Production, length: 50 )
• StageID ( type: esriFieldTypeSmallInteger, alias: StageID )
• Stage ( type: esriFieldTypeString, alias: Stage, length: 50 )
• LifeHistoryID ( type: esriFieldTypeSmallInteger, alias: LifeHistoryID )
• LifeHistoryType ( type: esriFieldTypeString, alias: LifeHistoryType, length: 80 )
• TrendID ( type: esriFieldTypeInteger, alias: TrendID )
• TrendTypeID ( type: esriFieldTypeSmallInteger, alias: TrendTypeID )
• TrendType ( type: esriFieldTypeString, alias: TrendType, length: 255 )
• TypeID ( type: esriFieldTypeSmallInteger, alias: TypeID )
• Type_ ( type: esriFieldTypeString, alias: Type_, length: 50 )
• CategoryID ( type: esriFieldTypeSmallInteger, alias: CategoryID )
• DataCategory ( type: esriFieldTypeString, alias: DataCategory, length: 25 )
• CompilerID ( type: esriFieldTypeSmallInteger, alias: CompilerID )
• CompiledBy ( type: esriFieldTypeString, alias: CompiledBy, length: 15 )
• Updated ( type: esriFieldTypeDate, alias: Updated, length: 8 )
• HistoricStatID ( type: esriFieldTypeSmallInteger, alias: HistoricStatID )
• HistoricStat ( type: esriFieldTypeString, alias: HistoricStat, length: 250 )
• TrendStatID ( type: esriFieldTypeSmallInteger, alias: TrendStatID )
• TrendStat ( type: esriFieldTypeString, alias: TrendStat, length: 250 )
• WQC ( type: esriFieldTypeInteger, alias: WQC )
• Years ( type: esriFieldTypeString, alias: Years, length: 9 )
• Observations ( type: esriFieldTypeInteger, alias: Observations )
• NewObs ( type: esriFieldTypeInteger, alias: NewObs )
• HatchID ( type: esriFieldTypeSmallInteger, alias: HatchID )
• Hatch_Name ( type: esriFieldTypeString, alias: Hatch_Name, length: 100 )
• DamID ( type: esriFieldTypeInteger, alias: DamID )
• Dam_Name ( type: esriFieldTypeString, alias: Dam_Name, length: 65 )
• SOTR ( type: esriFieldTypeSmallInteger, alias: SOTR )
• AgeD ( type: esriFieldTypeString, alias: AgeD, length: 5 )
• TrendCom ( type: esriFieldTypeString, alias: TrendCom, length: 83 )
• StatCom ( type: esriFieldTypeString, alias: StatCom, length: 83 )
• StreamAndTributaries ( type: esriFieldTypeString, alias: StreamAndTributaries, length: 255 )
• MapLabel ( type: esriFieldTypeString, alias: MapLabel, length: 1073741822 )
• MapURL ( type: esriFieldTypeString, alias: MapURL, length: 72 )
• NMFS_PopCode ( type: esriFieldTypeString, alias: NMFS_PopCode, length: 10 )
• PopID ( type: esriFieldTypeInteger, alias: PopID )
• BPAProjNum ( type: esriFieldTypeString, alias: BPAProjNum, length: 50 )
• DSID ( type: esriFieldTypeSmallInteger, alias: DSID )
• PopulationName ( type: esriFieldTypeString, alias: PopulationName, length: 120 )
• ESApopName ( type: esriFieldTypeString, alias: ESApopName, length: 255 )
• GISDate ( type: esriFieldTypeString, alias: GISDate, length: 8 )
• GeoDone ( type: esriFieldTypeString, alias: GeoDone, length: 3 )
• SNLoadDate ( type: esriFieldTypeDate, alias: SNLoadDate, length: 8 )
• id ( type: esriFieldTypeString, alias: id, length: 36 )
• apikey ( type: esriFieldTypeString, alias: apikey, length: 36 )
• Publish ( type: esriFieldTypeString, alias: Publish, length: 3 )
• ValidationDate ( type: esriFieldTypeDate, alias: ValidationDate, length: 8 )
• LastUpdated ( type: esriFieldTypeDate, alias: LastUpdated, length: 8 )
• Compiler ( type: esriFieldTypeString, alias: Compiler, length: 60 )
• EndYear ( type: esriFieldTypeSmallInteger, alias: EndYear )
• BPA_Priority ( type: esriFieldTypeSmallInteger, alias: BPA_Priority )
• TrendComFull ( type: esriFieldTypeString, alias: TrendComFull, length: 1073741822 )

Relationships:

• Trends4GIS_Escdata (8) -- Related To: Trends4GIS_Escdata (5)
• Trends4GIS_Hatchret (9) -- Related To: Trends4GIS_Hatchret (6)

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

  Iteminfo   Thumbnail   Metadata