Description: Public Versions - Water Right Query System is the primary summary table of Montana water rights published through the Water Right Query System (WRQS). It contains one record for each water right, representing the single version of that right currently designated as the public version by the WRD business rules. Each record rolls the full version up into a flat, map- and report-ready row: basin and water right number, water right type and status, version type, priority and enforceable priority dates, current owners, purposes of use, source types and names, means of diversion, maximum flow rate (in native units and converted to both gallons per minute and cubic feet per second), maximum volume and acres, animal units, counts of points of diversion, places of use, irrigated places of use and reservoirs, associated ditches and Department of Revenue geocodes, the counties in which the right's features fall, issue and associated remarks, and hyperlinks to the public abstract report, the scanned water right file in FileNet, and the WRQS authorization and case views. The table is non-spatial; join it to WRQS_PODS, WRQS_POUS, or WRQS_RESERVOIRS on WRGT_ID_SEQ or WRKEY to map its contents.
Description: Owners - Water Right Query System is the owner index behind water right owner search in the Water Right Query System. It contains one record for each current owner of the public version of each Montana water right, so a right held by multiple owners produces multiple records. Owner names are carried in parsed form - last name or business name, first name, middle initial, and suffix - along with the customer type (individual, business, or government entity) and the internal ownership and customer identifiers, which makes the table usable for exact-match, partial-match, and grouped owner queries. Each record also repeats the full summary attribution of the parent water right, including basin and water right number, type and status, priority dates, purposes, sources, quantities, counties, remarks, and abstract, scan, authorization, and case links, so an owner search can return complete results without a further join. The table is non-spatial.
Description: The Water Right Query System Change Authorization Scanned Docs is a document index that connects Montana water rights to the scanned change authorization applications held in the DNRC FileNet document repository. It contains one record for each water right version whose version type is a change authorization, change of scope, or reduction and whose documents have been scanned. Each record identifies both the water right (basin, water right number, type, and status) and the change application (application identifier, basin, application type code and description, and the version type of the change), and supplies a constructed hyperlink to the scanned document. A water right key for the change application version is included so the record can be joined back to the version-level WRQS tables. The table is non-spatial.
Description: Geocodes - Water Right Query System relates Montana water rights to Department of Revenue geocodes, the parcel identifiers used in the state cadastral framework. It contains one record for each valid, currently effective geocode cross-referenced to the public version of a water right, with the geocode carried both unformatted and in the standard dash-delimited display format for joining to DOR cadastral data. Each record also repeats the full summary attribution of the parent water right - basin and water right number, type and status, priority dates, owners, purposes, sources, quantities, counties, remarks, and abstract, scan, authorization, and case links - so a parcel lookup returns complete water right information directly. The table is non-spatial; join it to the Department of Revenue parcel layer on the formatted geocode to map results.
Description: Other Versions - Water Right Query System carries the version history of Montana water rights. It contains one record for every water right version that holds an operating authority but is not the version currently designated as public, allowing users of the Water Right Query System to review how a right was described under earlier authorizations, change authorizations, and amendments. The attribution is identical to WRQS_PUBLIC_VERSIONS - basin and water right number, type and status, version type, priority and enforceable priority dates, owners, purposes, sources, means of diversion, quantities, feature counts, ditches, geocodes, counties, remarks, and abstract, scan, authorization, and case links - so the two tables can be unioned or compared version to version. The table is non-spatial.
Description: Cases - Water Right Query System indexes the legal and administrative cases attached to Montana water rights. It contains one record for each administrative water case or Montana Water Court case associated with a water right version, identifying the water right (basin, water right number, type, and status), the version to which the case is attached, and the case itself - internal case identifier, public case number, case type, and current case status. Because cases attach at the version level, a single water right can produce multiple records. The table is non-spatial and is used together with the case link in the version-level WRQS tables.
Description: Water Right Types - Water Right Query Systemappears to be a list-of-values lookup table supplying the set of water right type codes and their public descriptions used to populate the water right type filter in the Water Right Query System application, corresponding to the WRD_WATER_RIGHT_TYPES domain that populates the WR_TYPE attribute in the other WRQS tables. THIS DESCRIPTION IS UNVERIFIED. No create, truncate, or insert logic for this table exists in the three package bodies supplied (GIS_GWRAT_DAILY_UPDATES, GIS_WRD_SDE_DAILY_DSHDB, and GIS_WRD_SDE_DAILY_UPDATES), so its actual structure, contents, population method, and refresh cadence could not be determined from the available sources. Confirm against the table definition and its load process before publishing this description.