Name: PSMFC_FishFacilities_20260310

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This dataset includes various facilities used for fisheries management in the Columbia Basin, as well as key hydroelectric dams throughout the Basin. For the purposes of this dataset, a facility is a fixed or semi-fixed location where fish are managed, counted or passed, and generally where there is at least one data record in a Pacific States Marine Fisheries Commission(PSMFC) database. Not all dams fall neatly within this definition, but are included since they are a significant factor in fish distribution. A primary objective of this dataset is to link PSMFC's Columbia Basin fish data programs through a common location framework, while eliminating the redundancy of location data being mapped and managed by the individual program. While the facility location data will be managed by the PSMFC GIS Center as a single dataset, facilities can be separated and published into multiple map layers based on facility type or other attributes. Sources for these point data came primarily from Programs within the Pacific States Marine Fisheries Commission (PSMFC), including StreamNet, PIT Tag Information System(PTAGIS), and the Regional Mark Processing Center(RMPC), and their various state and federal partners. Locations have been checked and in some cases modified, to more closely match available imagery and/or regional hydrography, as appropriate. Inclusion in the dataset or depiction in the mapper does not mean that the facility is currently active. Basic types of fish facilities currently include:Hatcheries, acclimation / release sitesDams (categorized further for display purposes)Fish traps & collection facilities (including screw traps, weir traps, etc.)Fish passage facilities (including fish ladders and juvenile fish bypasses)PTAGIS instream remote detection facilities** Note that not all PTAGIS sites are depicted in this dataset.We strive for accuracy and completeness, but expect that improvements to the dataset can be made. If you have any corrections, additions, suggestions, or concerns, please contact gis@psmfc.org

Service Item Id: 5407f4e9ef274799932353e1ab93c5ea

Copyright Text: PSMFC GIS, StreamNet, PTAGIS, RMPC

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -1.3876864131642837E7
YMin: 3914598.1048862864
XMax: -1.1850919350668766E7
YMax: 6814333.853309394
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: FacSubType
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: <all other values>
UniqueValueInfos:
• Value: 100
  Label: hatchery
  Description: N/A
  Symbol:
  
• Value: 101
  Label: acclimation and/or release site
  Description: N/A
  Symbol:
  
• Value: 200
  Label: major dam
  Description: N/A
  Symbol:
  
• Value: 201
  Label: dam
  Description: N/A
  Symbol:
  
• Value: 202
  Label: other dam
  Description: N/A
  Symbol:
  
• Value: 300
  Label: screw trap
  Description: N/A
  Symbol:
  
• Value: 301
  Label: weir trap
  Description: N/A
  Symbol:
  
• Value: 302
  Label: fish collection facility
  Description: N/A
  Symbol:
  
• Value: 303
  Label: other trap
  Description: N/A
  Symbol:
  
• Value: 304
  Label: hatchery ladder/trap
  Description: N/A
  Symbol:
  
• Value: 400
  Label: fish ladder
  Description: N/A
  Symbol:
  
• Value: 401
  Label: juvenile fish bypass
  Description: N/A
  Symbol:
  
• Value: 500
  Label: instream remote detection site
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [FacName]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: baseline
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 150000.0
Max. Scale: 0.0

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: FacType

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FacID ( type: esriFieldTypeInteger, alias: Facility ID )
• HatchID ( type: esriFieldTypeSmallInteger, alias: HatchID )
• HATCHID_1 ( type: esriFieldTypeDouble, alias: HATCHERY ID )
• FacName ( type: esriFieldTypeString, alias: Facility Name, length: 255 )
• Hatch_Name ( type: esriFieldTypeString, alias: Hatch_Name, length: 1073741822 )
• FacAltName ( type: esriFieldTypeString, alias: Alternate Name, length: 255 )
• PTAGIS_INT ( type: esriFieldTypeString, alias: PTAGIS Int Site Code, length: 3 )
• ShortLabel ( type: esriFieldTypeString, alias: Short Label, length: 180 )
• FacStatus ( type: esriFieldTypeSmallInteger, alias: Status , Coded Values: [1: open] , [2: proposed] , [3: removed from dataset] , ...2 more... )
• FacType ( type: esriFieldTypeSmallInteger, alias: Facility Type , Coded Values: [1: hatchery] , [2: dam] , [3: fish trap] , ...3 more... )
• FacSubType ( type: esriFieldTypeSmallInteger, alias: Facility SubType , Coded Values: [100: hatchery] , [101: acclimation and/or release site] , [200: major dam] , ...12 more... )
• AR_Type ( type: esriFieldTypeSmallInteger, alias: Acclimation Relase Site Type , Coded Values: [1: artificial pond(s)] , [2: natural pond(s)] , [3: net pen(s)] , ...4 more... )
• FacComment ( type: esriFieldTypeString, alias: Facility Comments, length: 255 )
• LocationID ( type: esriFieldTypeString, alias: LocationID, length: 13 )
• MEAS ( type: esriFieldTypeInteger, alias: MEAS )
• DAMID ( type: esriFieldTypeInteger, alias: DAMID )
• StateDamID ( type: esriFieldTypeString, alias: State DamID, length: 50 )
• DataStream ( type: esriFieldTypeString, alias: Data Stream, length: 255 )
• DS_Type ( type: esriFieldTypeString, alias: Data Stream Type, length: 50 )
• DS2 ( type: esriFieldTypeString, alias: Data Stream2, length: 255 )
• DS2_Type ( type: esriFieldTypeString, alias: Data Stream2 Type, length: 50 )
• Wiki_URL ( type: esriFieldTypeString, alias: Wikipedia URL, length: 255 )
• WikiURLTyp ( type: esriFieldTypeString, alias: Wiki URL Type, length: 50 )
• Fac_URL ( type: esriFieldTypeString, alias: Facility URL, length: 255 )
• FacURLType ( type: esriFieldTypeString, alias: Facility URL Type, length: 100 )
• FPC_Code ( type: esriFieldTypeString, alias: FPC Code, length: 5 )
• FPC_HC ( type: esriFieldTypeString, alias: FPC Hatchery Code, length: 10 )
• FPC_RSC ( type: esriFieldTypeString, alias: FPC Release Site Code, length: 10 )
• FPC_FC_URL ( type: esriFieldTypeString, alias: FPC Fish Count URL, length: 255 )
• PTAGIS_MRR ( type: esriFieldTypeString, alias: PTAGIS MRR Site Code, length: 10 )
• RMIS_CODE ( type: esriFieldTypeString, alias: RMIS Code, length: 100 )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude )
• ColBasin ( type: esriFieldTypeSmallInteger, alias: Columbia Basin )
• FacAngle ( type: esriFieldTypeSmallInteger, alias: FacAngle )
• CreateDate ( type: esriFieldTypeDate, alias: Create Date, length: 8 )
• EditDate ( type: esriFieldTypeDate, alias: Edit Date, length: 8 )
• YearRemove ( type: esriFieldTypeSmallInteger, alias: YearRemove )
• Fac_Info ( type: esriFieldTypeString, alias: Facility Info Type, length: 255 )
• FacInfoURL ( type: esriFieldTypeString, alias: Facility_Info_URL, length: 255 )
• StateProv ( type: esriFieldTypeString, alias: State Province Name, length: 35 )
• County ( type: esriFieldTypeString, alias: County Name, length: 255 )
• HUC12 ( type: esriFieldTypeString, alias: HUC12, length: 12 )
• HUC12_Name ( type: esriFieldTypeString, alias: HUC12 Name, length: 120 )
• HUC8 ( type: esriFieldTypeString, alias: HUC8, length: 8 )
• HUC8_Name ( type: esriFieldTypeString, alias: HUC8 Name, length: 255 )
• Shape_Length_1 ( type: esriFieldTypeDouble, alias: Shape_Length )
• Shape_Area_1 ( type: esriFieldTypeDouble, alias: Shape_Area )
• StreamName ( type: esriFieldTypeString, alias: Stream Name, length: 100 )
• TribToName ( type: esriFieldTypeString, alias: TribToName, length: 60 )
• StTribName ( type: esriFieldTypeString, alias: Stream and Trib Name, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Fish_Flag ( type: esriFieldTypeSmallInteger, alias: Fish_Flag )
• LLID_Type ( type: esriFieldTypeSmallInteger, alias: LLID_Type , Coded Values: [0: Lat/Long coincident with current hydro (<1 m off)] , [1: Lat/Long off of hydro (snap)] , [2: Lat/Long off of hydro (multi-snap)] , ...2 more... )
• LocSnapDst ( type: esriFieldTypeInteger, alias: Snap Distance )
• GISNotes ( type: esriFieldTypeString, alias: GIS Notes, length: 255 )
• DataSrcAgency ( type: esriFieldTypeString, alias: DataSrcAgency, length: 255 )
• DataSrcID ( type: esriFieldTypeString, alias: DataSrcID, length: 255 )
• QAQC_Level ( type: esriFieldTypeSmallInteger, alias: QAQC_Level )
• QAQC_Comments ( type: esriFieldTypeString, alias: QAQC_Comments, length: 255 )
• WDFWFacID ( type: esriFieldTypeString, alias: WDFWFacID, length: 255 )
• LocatedInWater ( type: esriFieldTypeString, alias: LocatedInWater, length: 255 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• NAME ( type: esriFieldTypeString, alias: NAME, length: 25 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Types:

ID: 1
Name: hatchery
Domains:
• FacStatus:
  Inherited
• FacSubType:
  Coded Values: [100: hatchery] , [101: acclimation and/or release site]
• AR_Type:
  Inherited
• LLID_Type:
  Inherited

---

ID: 2
Name: dam
Domains:
• FacStatus:
  Inherited
• FacSubType:
  Coded Values: [200: major dam (> 100ft NID dam height)] , [201: dam (20-100ft NID dam height)] , [202: minor dam (<20ft NID dam height)] , ...1 more...
• AR_Type:
  Inherited
• LLID_Type:
  Inherited

---

ID: 3
Name: fish trap
Domains:
• FacStatus:
  Inherited
• FacSubType:
  Coded Values: [300: screw trap] , [301: weir trap] , [302: fish collection facility] , ...2 more...
• AR_Type:
  Inherited
• LLID_Type:
  Inherited

---

ID: 4
Name: fish passage facility
Domains:
• FacStatus:
  Inherited
• FacSubType:
  Coded Values: [400: fish ladder] , [401: juvenile fish bypass]
• AR_Type:
  Inherited
• LLID_Type:
  Inherited

---

ID: 5
Name: PIT tag detection site
Domains:
• FacStatus:
  Inherited
• FacSubType:
  Coded Values: [500: PTAGIS instream remote detection site]
• AR_Type:
  Inherited
• LLID_Type:
  Inherited

---

ID: 9
Name: other (pending review)
Domains:
• FacStatus:
  Inherited
• FacSubType:
  Coded Values: [900: other (pending review)]
• AR_Type:
  Inherited
• LLID_Type:
  Inherited

---

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

  Iteminfo   Thumbnail   Metadata