Name: reach_entry_repeat

Display Field: objectid

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• CREW (type: esriFieldTypeString, alias: Crew Members, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RCH_NUM (type: esriFieldTypeInteger, alias: Reach #, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REACH_UNIT (type: esriFieldTypeInteger, alias: UNIT #, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RESURVEY (type: esriFieldTypeString, alias: Resurvey?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• SURVEY_TYPE (type: esriFieldTypeString, alias: Survey Conducted, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Habitat: Habitat Only], [Snorkel: Snorkel Only], [Shared: Shared Survey], ... 3 more ...)
• FISH_SURVEY_TYPE (type: esriFieldTypeString, alias: Fish Survey Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [None: None], [Snorkel: Snorkled], [E-fish: Electrofished])
• MusselPresence (type: esriFieldTypeString, alias: Mussel Presence, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [0: No mussels observed], [1: Few mussels observed (1-50)], [2: Many mussels observed (51-200)], ... 1 more ...)
• MusselSizeClass (type: esriFieldTypeString, alias: Observed Mussel Size (select all that apply), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SHELLS_RETAINED (type: esriFieldTypeString, alias: Shells Retained?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• ASIAN_CLAMS (type: esriFieldTypeString, alias: Asian Clams Observed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• BV_ACTV (type: esriFieldTypeString, alias: Beaver Activity Age (select all that apply), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BV_ACTV_OBS (type: esriFieldTypeString, alias: Beaver Activity Observed (select all that apply), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BV_OTHER (type: esriFieldTypeString, alias: Other Beaver Activity Observed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AMPHIB_OBS (type: esriFieldTypeString, alias: Amphibians Observed (select all that apply), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AMPHIB_OTHER (type: esriFieldTypeString, alias: Other Amphibians Observed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CRAYFISH (type: esriFieldTypeString, alias: Crayfish Observed (select all that apply), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CHAN_FORM (type: esriFieldTypeString, alias: Channel Form, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [CH: CH - Constrained by Hill slope], [CB: CB - Constrained by Bedrock], [US: US - Unconstrained predominantly Single channel], ... 5 more ...)
• VALLEY_FM (type: esriFieldTypeString, alias: Valley Form, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [MV: MV - Moderate V-shaped valley], [OV: OV - Open V-shaped valley], [SV: SV - Steep V-shaped valley or bedrock gorge], ... 3 more ...)
• VWI (type: esriFieldTypeString, alias: Valley Width Index (VWI), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: 1], [1.5: 1.5], [2: 2], ... 36 more ...)
• VEG_CL_DOM (type: esriFieldTypeString, alias: Dominant Vegetation Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [N: N - No vegetation (bare soil, rock)], [B: B - SageBrush (sagebrush, greasewood, rabbit brush, etc.)], [G: G - Annual Grasses, herbs, and forbs], ... 20 more ...)
• VEG_CL_SUB (type: esriFieldTypeString, alias: Sub Dominant Vegetation Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [N: N - No vegetation (bare soil, rock)], [B: B - SageBrush (sagebrush, greasewood, rabbit brush, etc.)], [G: G - Annual Grasses, herbs, and forbs], ... 20 more ...)
• LAND_DOM (type: esriFieldTypeString, alias: Dominant Land Use, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AG: AG - Agriculture crop or dairy land], [TH: TH - Timber harvest (not yet replanted)], [YT: YT - Young forest trees (<15 cm dbh)], ... 22 more ...)
• LAND_SUB (type: esriFieldTypeString, alias: Sub Dominant Land Use, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AG: AG - Agriculture crop or dairy land], [TH: TH - Timber harvest (not yet replanted)], [YT: YT - Young forest trees (<15 cm dbh)], ... 22 more ...)
• WATER_TEMP (type: esriFieldTypeString, alias: Water Temperature (◦C), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 32 more ...)
• STR_FLOW (type: esriFieldTypeString, alias: Stream Flow, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [DR: Dry], [PD: Puddled - series of isolated pools], [LF: Low Flow - surface water flowing across 50-75% of the active channel surface], ... 4 more ...)
• START_10T (type: esriFieldTypeInteger, alias: Start UTM easting, SQL Type: sqlTypeOther, nullable: true, editable: true)
• START_UTM (type: esriFieldTypeInteger, alias: Start UTM northing, SQL Type: sqlTypeOther, nullable: true, editable: true)
• END_10T (type: esriFieldTypeInteger, alias: End UTM easting, SQL Type: sqlTypeOther, nullable: true, editable: true)
• END_UTM (type: esriFieldTypeInteger, alias: End UTM northing, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REACH_NOTE_Entry (type: esriFieldTypeString, alias: Reach Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• REACH_NOTE (type: esriFieldTypeString, alias: REACH_NOTE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Relationships:

• _2024_AQI_Survey_Entry_reach_entry_repeat (11) -- Related To: _2024_AQI_Survey_Entry (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/17/2024 3:27:41 PM

Schema Last Edit Date: 10/17/2024 3:27:41 PM

Data Last Edit Date: 10/17/2024 3:28:42 PM

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