Name: Advanced$

Display Field: Stream_Name

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectID

Unique ID Field:

Name : ObjectID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• Survey_Version (type: esriFieldTypeString, alias: Survey Version, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Stream_Name (type: esriFieldTypeString, alias: Stream Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Town (type: esriFieldTypeString, alias: Town, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Date (type: esriFieldTypeDouble, alias: Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Time (type: esriFieldTypeString, alias: Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• First_geopoint_X_value (type: esriFieldTypeDouble, alias: First geopoint X value, SQL Type: sqlTypeOther, nullable: true, editable: true)
• First_geopoint_Y_value (type: esriFieldTypeDouble, alias: First geopoint Y value, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Description_of_sample_location_ (type: esriFieldTypeString, alias: Description of sample location:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Names_of_collectors (type: esriFieldTypeString, alias: Names of collectors, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Minutes_at_stream_ (type: esriFieldTypeDouble, alias: Minutes at stream:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Minutes_sorting_and_identifying (type: esriFieldTypeDouble, alias: Minutes sorting and identifying macroinvertebrates:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Rocks (type: esriFieldTypeString, alias: Rocks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Tree_roots_and_undercut_banks (type: esriFieldTypeString, alias: Tree roots and undercut banks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Logs_and_branches (type: esriFieldTypeString, alias: Logs and branches, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Plants (type: esriFieldTypeString, alias: Plants, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Brush_legged_Mayfly (type: esriFieldTypeString, alias: Brush-legged Mayfly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen (type: esriFieldTypeString, alias: number seen, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Spiny_Crawler_Mayfly (type: esriFieldTypeString, alias: Spiny Crawler Mayfly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen1 (type: esriFieldTypeDouble, alias: number seen1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Two_tailed_Mayfly (type: esriFieldTypeString, alias: Two-tailed Mayfly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen2 (type: esriFieldTypeString, alias: number seen2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Roach_like_Stonefly (type: esriFieldTypeString, alias: Roach-like Stonefly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen3 (type: esriFieldTypeString, alias: number seen3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Common_Stonefly (type: esriFieldTypeString, alias: Common Stonefly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen4 (type: esriFieldTypeDouble, alias: number seen4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Giant_Stonefly (type: esriFieldTypeString, alias: Giant Stonefly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen5 (type: esriFieldTypeString, alias: number seen5, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Tiny_Stoneflies (type: esriFieldTypeString, alias: Tiny Stoneflies, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen6 (type: esriFieldTypeString, alias: number seen6, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Short_tailed_Stonefly (type: esriFieldTypeString, alias: Short-tailed Stonefly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen7 (type: esriFieldTypeString, alias: number seen7, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Other_Small_Stoneflies (type: esriFieldTypeString, alias: Other Small Stoneflies, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen8 (type: esriFieldTypeString, alias: number seen8, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Long_horned_Caddisfly (type: esriFieldTypeString, alias: Long-horned Caddisfly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen9 (type: esriFieldTypeString, alias: number seen9, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Free_living_Caddisfly (type: esriFieldTypeString, alias: Free-living Caddisfly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen10 (type: esriFieldTypeString, alias: number seen10, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Tortoise_shell_Caddisfly (type: esriFieldTypeString, alias: Tortoise-shell Caddisfly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen11 (type: esriFieldTypeString, alias: number seen11, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Log_Cabin_Caddisfly (type: esriFieldTypeString, alias: Log Cabin Caddisfly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen12 (type: esriFieldTypeString, alias: number seen12, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Wood_Panel_Caddisfly (type: esriFieldTypeString, alias: Wood Panel Caddisfly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen13 (type: esriFieldTypeDouble, alias: number seen13, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Watersnipe_Fly (type: esriFieldTypeString, alias: Watersnipe Fly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen14 (type: esriFieldTypeString, alias: number seen14, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Clubtail_Dragonfly (type: esriFieldTypeString, alias: Clubtail Dragonfly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen15 (type: esriFieldTypeString, alias: number seen15, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Sensitive____of_kinds_ (type: esriFieldTypeDouble, alias: Sensitive (# of kinds), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Minnow_Mayfly (type: esriFieldTypeString, alias: Minnow Mayfly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen16 (type: esriFieldTypeString, alias: number seen16, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Flat_headed_Mayfly (type: esriFieldTypeString, alias: Flat-headed Mayfly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen17 (type: esriFieldTypeString, alias: number seen17, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Prong_gilled_Mayfly (type: esriFieldTypeString, alias: Prong-gilled Mayfly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen18 (type: esriFieldTypeString, alias: number seen18, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Square_gilled_Mayfly (type: esriFieldTypeString, alias: Square-gilled Mayfly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen19 (type: esriFieldTypeString, alias: number seen19, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Little_Stout_Crawler (type: esriFieldTypeString, alias: Little Stout Crawler, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen20 (type: esriFieldTypeString, alias: number seen20, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Dobsonfly_and_Alderfly (type: esriFieldTypeString, alias: Dobsonfly and Alderfly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen21 (type: esriFieldTypeString, alias: number seen21, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Tubenet_Caddisfly (type: esriFieldTypeString, alias: Tubenet Caddisfly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen22 (type: esriFieldTypeDouble, alias: number seen22, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Netspinning_Caddisfly (type: esriFieldTypeString, alias: Netspinning Caddisfly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen23 (type: esriFieldTypeString, alias: number seen23, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Snailcase_Caddisfly (type: esriFieldTypeString, alias: Snailcase Caddisfly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen24 (type: esriFieldTypeString, alias: number seen24, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Other_Casemaking_Caddisflies (type: esriFieldTypeString, alias: Other Casemaking Caddisflies, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen25 (type: esriFieldTypeString, alias: number seen25, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Darner_Dragonfly (type: esriFieldTypeString, alias: Darner Dragonfly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen26 (type: esriFieldTypeString, alias: number seen26, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Jewelwings (type: esriFieldTypeString, alias: Jewelwings, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen27 (type: esriFieldTypeString, alias: number seen27, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Narrow_winged_Damselfly (type: esriFieldTypeString, alias: Narrow-winged Damselfly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen28 (type: esriFieldTypeString, alias: number seen28, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Blackfly (type: esriFieldTypeString, alias: Blackfly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen29 (type: esriFieldTypeString, alias: number seen29, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Cranefly (type: esriFieldTypeString, alias: Cranefly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen30 (type: esriFieldTypeString, alias: number seen30, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Nonbiting_Midge (type: esriFieldTypeString, alias: Nonbiting Midge, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen31 (type: esriFieldTypeString, alias: number seen31, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Aquatic_Dance_Fly (type: esriFieldTypeString, alias: Aquatic Dance Fly, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen32 (type: esriFieldTypeString, alias: number seen32, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Riffle_Beetle (type: esriFieldTypeString, alias: Riffle Beetle, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen33 (type: esriFieldTypeString, alias: number seen33, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Water_Penny (type: esriFieldTypeString, alias: Water Penny, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen34 (type: esriFieldTypeString, alias: number seen34, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Crayfish (type: esriFieldTypeString, alias: Crayfish, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen35 (type: esriFieldTypeString, alias: number seen35, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Limpet (type: esriFieldTypeString, alias: Limpet, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen36 (type: esriFieldTypeDouble, alias: number seen36, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Mud_Snail (type: esriFieldTypeString, alias: Mud Snail, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen37 (type: esriFieldTypeDouble, alias: number seen37, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Moderately_Sensitive____of_kind (type: esriFieldTypeDouble, alias: Moderately Sensitive (# of kinds), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Amphipod (type: esriFieldTypeString, alias: Amphipod, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen38 (type: esriFieldTypeString, alias: number seen38, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Isopod (type: esriFieldTypeString, alias: Isopod, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen39 (type: esriFieldTypeString, alias: number seen39, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Leech (type: esriFieldTypeString, alias: Leech, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen40 (type: esriFieldTypeString, alias: number seen40, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Aquatic_Worm (type: esriFieldTypeString, alias: Aquatic Worm, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen41 (type: esriFieldTypeString, alias: number seen41, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Red_Midge (type: esriFieldTypeString, alias: Red Midge, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen42 (type: esriFieldTypeString, alias: number seen42, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Other_Snails (type: esriFieldTypeString, alias: Other Snails, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• number_seen43 (type: esriFieldTypeDouble, alias: number seen43, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Tolerant____of_kinds_ (type: esriFieldTypeDouble, alias: Tolerant (# of kinds), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SENSITIVE____of_kinds_1 (type: esriFieldTypeDouble, alias: SENSITIVE (# of kinds)1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MODERATELY_SENSITIVE____of_ki_1 (type: esriFieldTypeDouble, alias: MODERATELY SENSITIVE (# of kinds)1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOLERANT____of_kinds_1 (type: esriFieldTypeDouble, alias: TOLERANT (# of kinds)1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDouble, alias: CreationDate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ObjectID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)

Templates:

Name: Advanced$
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/14/2023 4:18:02 PM

Schema Last Edit Date: 4/14/2023 4:18:02 PM

Data Last Edit Date: 4/14/2023 4:18:02 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat