Name: hp_fishpassagesubmissions
Display Field: StreamName
Type: Feature Layer
Geometry Type: esriGeometryPoint
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description: hp_fishpassagesubmissions
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -18750375.6688627
YMin: -18741678.5682382
XMax: 18959106.0838524
YMax: 6601035.07025549
Spatial Reference: 102100 (3857)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"ece29ca0202a94c2b7ad7aaf28743677","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAgAAAAICAYAAADED76LAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAfklEQVQYlW3PwQmDUBCE4U8R3s27Woa2EV5NaSLg2T5SgZahlhDJQXJ5LxjIXAZmd4f9K7+6YcOSgyp5jzE57Biw5YWxU/ZRUCtMjmZ1zmirdNVHQacEUfDwatDnBrXCP1XpoX1yNFEAT28pX3LDsDrnVJuH9yvFhvZC8cX8ALWhHOrjsaFsAAAAAElFTkSuQmCC","contentType":"image/png","width":6,"height":6,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: true
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- SiteId (type: esriFieldTypeString, alias: Site ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- SiteLatitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SiteLongitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- UserLatitude (type: esriFieldTypeDouble, alias: User Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- UserLongitude (type: esriFieldTypeDouble, alias: User Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FeatureType (type: esriFieldTypeString, alias: Feature Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- StreamName (type: esriFieldTypeString, alias: Stream Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- TributaryToName (type: esriFieldTypeString, alias: Tributary to Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- FishUseCode (type: esriFieldTypeSmallInteger, alias: Fish Use, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Missing], [10: Yes], [20: No], ... 1 more ...)
- FishUseCriteriaCode (type: esriFieldTypeSmallInteger, alias: Fish Use Criteria, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [10: Other], [11: Biological], [12: Physical], ... 1 more ...)
- RoadName (type: esriFieldTypeString, alias: Road Name, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- RoadMilePostMeasurement (type: esriFieldTypeDouble, alias: Mile Post, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FishPassageBarrierStatusCode (type: esriFieldTypeSmallInteger, alias: Fish Passage Barrier, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: NA], [10: Yes], [20: No], ... 1 more ...)
- FishPassageBarrierReasonCode (type: esriFieldTypeSmallInteger, alias: Barrier Reason, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [10: WS Drop], [11: Slope], ... 15 more ...)
- PercentFishPassableCode (type: esriFieldTypeSmallInteger, alias: Percent Passable, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: N/A], [10: 0], [20: 33], ... 3 more ...)
- SignificantReachCode (type: esriFieldTypeSmallInteger, alias: Significant Reach, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: NA], [10: Yes], [20: No], ... 1 more ...)
- OwnerTypeCode (type: esriFieldTypeSmallInteger, alias: Owner Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: City], [2: County], [3: Federal], ... 9 more ...)
- DataSource (type: esriFieldTypeString, alias: Data Source, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- SurveyDate (type: esriFieldTypeString, alias: Survey Date, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- PotentialSpecies (type: esriFieldTypeString, alias: Potential Species, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
- BarrierCorrectionTypeCode (type: esriFieldTypeSmallInteger, alias: Barrier Correction Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Culvert removed crossing abandoned], [2: Culvert replaced with bridge], [3: Culvert replaced with culvert], ... 6 more ...)
- BarrierCorrectionYear (type: esriFieldTypeSmallInteger, alias: Barrier Correction Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
- BarrierCorrectionYearsText (type: esriFieldTypeString, alias: Barrier Correction Years, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- HydraulicProjectApprovalId (type: esriFieldTypeString, alias: HPA #, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- UserCommentText (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- SubmitterFullName (type: esriFieldTypeString, alias: Full Name, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
- SubmitterOrganizationName (type: esriFieldTypeString, alias: Organization Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- SubmitterPhoneNumber (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- SubmitterEmail (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ReviewStatusCode (type: esriFieldTypeSmallInteger, alias: Submission Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unsubmitted], [1: Open], [2: In Progress], ... 3 more ...)
- CreateDateTime (type: esriFieldTypeDate, alias: Date Created, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- DataSubmissionTypeCode (type: esriFieldTypeSmallInteger, alias: Submission Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Barrier Correction], [2: New Site], [3: Attribute Edit])
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Templates:
Name: hp_fishpassagesubmissions
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 6/11/2025 4:51:23 PM
Schema Last Edit Date: 11/21/2022 10:46:44 PM
Data Last Edit Date: 6/11/2025 4:51:23 PM
Supported Operations:
Add Features
Apply Edits
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat