Name: Scotch_Broom_Site_Survey_SURF_2024

Display Field: objectid

Type: Table

Has Views: true

Source Schema Changes Allowed: true

Views

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)
• username_information (type: esriFieldTypeString, alias: username_information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• report_datetime (type: esriFieldTypeDate, alias: Report date and time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• site_county (type: esriFieldTypeString, alias: Site County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [county_jefferson: Jefferson], [county_grays_harbor: Grays Harbor], [county_clallum: Clallum], ... 1 more ...)
• site_county_other (type: esriFieldTypeString, alias: Specify other., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• site_weather (type: esriFieldTypeString, alias: Weather at time of collection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [weather_sunny: Mostly Sunny], [weather_overcast: Overcast], [weather_rainy: Mostly Rainy], ... 2 more ...)
• site_weather_other (type: esriFieldTypeString, alias: Specify other., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• site_location (type: esriFieldTypeString, alias: What site is this location being collected?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Reade_Hill: Reade Hill], [Westport: Westport], [Ocean_Shores: Ocean Shores], ... 1 more ...)
• site_location_other (type: esriFieldTypeString, alias: Specify other., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• transect_id_number (type: esriFieldTypeInteger, alias: Site Transect Number:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPS_startpoint_id (type: esriFieldTypeString, alias: Transect Starting point Latitude and Longitude, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GPS_transect_direction (type: esriFieldTypeInteger, alias: Transect Bearing (using magnetic north), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Step_point_note (type: esriFieldTypeString, alias: Record the following point information:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GPS_Step_point_number (type: esriFieldTypeInteger, alias: Step Point Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• location (type: esriFieldTypeGeometry, alias: Location of Point along Transect, SQL Type: sqlTypeOther, nullable: true, editable: true)
• point_logtime_total (type: esriFieldTypeString, alias: Total time logged at point , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Scotchbroom_yes_no (type: esriFieldTypeString, alias: Scotch Broom Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Scotchbroom_yes: Yes], [Scotchbroom_no: No])
• Scotchbroom_height (type: esriFieldTypeString, alias: Height of Scotch Broom, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [less_than_3ft: Less than 3ft (Aprox. ~1m)], [Between_3ft_6ft: Between 3ft and 6 ft (Aprox. ~1m-2m)], [Between_6ft_12ft: Between 6ft and 12 ft (Approx. ~2m-4m)], ... 1 more ...)
• Scotchbroom_age (type: esriFieldTypeString, alias: Age of Scotch Broom, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [seedling: seedling], [juvenile: juvenile], [mature: mature], ... 2 more ...)
• Scotchbroom_characteristics (type: esriFieldTypeString, alias: Characteristics of Scotch Broom, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Other_Notes (type: esriFieldTypeString, alias: Other notes or comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• data_note (type: esriFieldTypeString, alias: Surrounding Vegetation Data Only needs to be submitted Once per Transect.*A good idea is to take this data while recording length of transect & before submitting point data. However, this data can be submitted along with the point ata as well in case it is needed. , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• soil_sample_yes_no (type: esriFieldTypeString, alias: Soil Sample/plug Collected:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [soil_sample_yes: Yes], [soil_sample_no: No])
• soil_sample_quantity (type: esriFieldTypeInteger, alias: How many Soil Samples along Transect were collected, SQL Type: sqlTypeOther, nullable: true, editable: true)
• soil_sample_labeled (type: esriFieldTypeString, alias: Please note how soil samples were labeled for this transect, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• canopy_cover (type: esriFieldTypeString, alias: Primary Canopy Cover along Transect, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [canopy_open: Open], [canopy_partially_open: Partially Open], [canopy_dense: Dense])
• Plot_Surrounding_Habitat (type: esriFieldTypeString, alias: Land cover types along transect, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Plot_Surrounding_Habitat_other_notes (type: esriFieldTypeString, alias: Other notes regarding Land Cover, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• veg_yes_no (type: esriFieldTypeString, alias: Was there surrounding Vegetation along transect?:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Surrounding_veg_yes: Yes], [Surrounding_veg_no: No])
• Plot_Vegetation (type: esriFieldTypeString, alias: Please select all other vegetation observed along transect:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Plot_vegetation_other (type: esriFieldTypeString, alias: Other Notes regarding surrounding vegetation:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Plot_vegetation_genus_species (type: esriFieldTypeString, alias: Specific Family, Genus, or Species observed:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Fungi_yes_no (type: esriFieldTypeString, alias: Was there surrounding Fungi along transect?:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Fungi_yes: Yes], [Fungi_no: No])
• plot_fungi (type: esriFieldTypeString, alias: Please Select type of Fungi that was observed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• plot_fungi_other (type: esriFieldTypeString, alias: Other ntoes reggarding fungi Observed (substrate, stem, no stem, other characteristics, etc., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dms_text (type: esriFieldTypeString, alias: Degrees Minutes and Seconds, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dd_text (type: esriFieldTypeString, alias: Decimal Degrees, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ddm_text (type: esriFieldTypeString, alias: Degrees and Decimal Minutes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• utm_text (type: esriFieldTypeString, alias: UTM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• usng (type: esriFieldTypeString, alias: USNG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• mgrs (type: esriFieldTypeString, alias: MGRS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• altitude (type: esriFieldTypeDouble, alias: Altitude (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_positions (type: esriFieldTypeInteger, alias: Total logged positions, SQL Type: sqlTypeOther, 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)
• Plot_vegetation_genus_species_other (type: esriFieldTypeString, alias: Specify other., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• genus_specie_list (type: esriFieldTypeString, alias: Fungi Genus and Species, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• low_shrubs (type: esriFieldTypeString, alias: Lower growing shrubs OR wildflowers, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• deciduous_trees (type: esriFieldTypeString, alias: Observations of deciduoius trees:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• conifer_trees (type: esriFieldTypeString, alias: Observation of conifer trees, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• site_location_clallum (type: esriFieldTypeString, alias: Specific Location in Jefferson County:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Reade_Hill: Reade Hill], [forks: Forks], [other: Other])
• site_location_clallum_other (type: esriFieldTypeString, alias: Specify other., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• descriptive_notes_clallum (type: esriFieldTypeString, alias: Location details or descriptive notes: :, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• site_location_jefferson (type: esriFieldTypeString, alias: Specific Location in Jefferson County:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [kalaloch: Kalaloch], [ruby_beach: Ruby Beach], [other: Other])
• site_location_jefferson_other (type: esriFieldTypeString, alias: Specify other., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• descriptive_notes_jefferson (type: esriFieldTypeString, alias: Location details or descriptive notes: :, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• site_location_gh (type: esriFieldTypeString, alias: Specific Location in Grays harbor County:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Ocean_Shores: Ocean Shores], [Westport: Westport], [Grayland: Grayland], ... 3 more ...)
• site_location_gh_other (type: esriFieldTypeString, alias: Specify other., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• descriptive_notes_gh (type: esriFieldTypeString, alias: Location details or descriptive notes: :, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)

Relationships:

• Scotch_Broom_Site_Survey_SURF_2024_properties (1) -- Related To: properties (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/15/2025 2:14:38 PM

Schema Last Edit Date: 4/15/2025 2:14:38 PM

Data Last Edit Date: 4/15/2025 2:14:38 PM

Supported Operations:   Add Features   Apply Edits   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat