ADWR Logo

 

Arizona
Department of
Water Resources

Geographic Information Services
"More than Maps"

Quick links to:
ADWR Home
Arizona State Agencies
U.S. State GIS Sites

Arizona Grandfathered Groundwater Rights
(GFRs) CD-ROM Database Guide
6th Edition - December 3, 2003

Table of Contents:

 

         Introduction

         How to use this database

         Database tables

58LOOKUP.DBF database table

60LOOKUP.DBF database table

         Code Explanations

         Understanding how to use the Quad Codes

         For more information or assistance


Introduction


Welcome to the Arizona Grandfathered Groundwater Rights database! This database contains the most frequently requested information on all of the GFRs in Arizona. You can use this database to look up the location of each GFR and information about the certificate number, file status, irrigated acres, owners, and other details. The information for the GFRs is collected by the Arizona Department of Water Resources and stored in two large, complex database systems:

Type

Software

Purpose

SQL

Oracle

Stores the description of every GFR

GIS

ARC/INFO

Stores the location of every GFR

This CD-ROM product contains information from both systems that has been consolidated, simplified and merged into one large table. None of the original information has been changed; it has simply been reformatted for greater convenience and ease of use. This CD-ROM does not duplicate all of the information in the Oracle database.


How to Use This Database


This database is designed to be used with most database and GIS software.

To copy this database to your hard drive:

6.    Make a new directory called adwrgfrs just below the root level.

7.    Copy all of the files from the CD-ROM adwrgfrs directory to the new directory.

8.    Use the appropriate ArcView Project file for the drive (ie. use drive_d.apr if you have copied the files to drive D:\adwrgfrs, etc.)

All information on this CD-ROM is Copyright 2003 by the State of Arizona, Department of Water Resources. You may use and share this database freely but cannot claim or imply that this information is your own. Nor can you alter this information in any way and then claim or imply that it is ours.

         Return to Top


Database Tables


File Types

No Color

ESRI shapefile file sets

 

Stand-alone database tables

 

Documentation files

 

ArcView Project files

 

Files found on this CD-ROM

FILE NAME

FILE FORMAT

DESCRIPTION

 

 

 

58lookup.dbf

dBaseIV database table

Main GFR information table for 58s (These are inside Active Management Areas)

60lookup.dbf

dBaseIV database table

Main GFR information table for 60s (These are inside Irrigation NonExpansion Areas)

adwrgfrs.htm

HTML text

Main database documentation Web page

adwrgfrs.mdb

Access 2000 database

Main Access 2000 database for 58s and 60s

amaina.dbf

dBaseIV database table

AMA and INA boundary polygon attributes

 

 

 

amaina.sbn

ESRI shapefile

AMA and INA boundary spatial index

amaina.sbx

ESRI shapefile

AMA and INA boundary spatial index

amaina.shp

ESRI shapefile

AMA and INA boundary polygons

 

 

 

amaina.shx

ESRI shapefile

AMA and INA boundary geometry index

arizona.dbf

dBaseIV database table

Arizona state boundary polygon attributes

arizona.sbn

ESRI shapefile

Arizona state boundary spatial index

 

 

 

arizona.sbx

ESRI Shapefile

Arizona state boundary spatial index

arizona.shp

ESRI shapefile

Arizona state boundary polygon

arizona.shx

ESRI shapefile

Arizona state boundary geometry index

cap.dbf

dBaseIV database table

Central Arizona Project Canal arc attributes

cap.sbn

ESRI shapefile

Central Arizona Project Canal spatial index

 

 

 

cap.sbx

ESRI shapefile

Central Arizona Project Canal spatial index

 

 

 

cap.shp

ESRI shapefile

Central Arizona Project Canal arc

cap.shx

ESRI shapefile

Central Arizona Project Canal geometry index

drive_c.apr

ESRI project file

ArcView 3.2x Project for files on drive C:

drive_d.apr

ESRI project file

ArcView 3.2x Project for files on drive D:

drive_e.apr

ESRI project file

ArcView 3.2x Project for files on drive E:

drive_n.apr

ESRI project file

ArcView 3.2x Project for files on drive N:

58FOXPRO.dbf

dBaseV database table

FoxPro .dbf

60FOXPRO.dbf

dBaseV database table

FoxPro .dbf

gfrs_ama.dbf

dBaseIV database table

Grandfathered Groundwater Rights in the Active Management Areas polygon attributes

gfrs_ama.sbn

ESRI shapefile

Grandfathered Groundwater Rights in the Active Management Areas spatial index

gfrs_ama.sbx

ESRI shapefile

Grandfathered Groundwater Rights in the Active Management Areas spatial index

 

 

 

gfrs_ama.shp

ESRI shapefile

Grandfathered Groundwater Rights in the Active Management Areas polygons

gfrs_ama.shx

ESRI shapefile

Grandfathered Groundwater Rights in the Active Management Areas geometry index

 

 

 

gfrs_ina.dbf

dBaseIV database table

Grandfathered Groundwater Rights in the Irrigation NonExpansion Areas polygon attributes

gfrs_ina.sbn

ESRI shapefile

Grandfathered Groundwater Rights in the Irrigation NonExpansion Areas spatial index

gfrs_ina.sbx

ESRI shapefile

Grandfathered Groundwater Rights in the Irrigation NonExpansion Areas spatial index

 

 

 

gfrs_ina.shp

ESRI shapefile

Grandfathered Groundwater Rights in the Irrigation NonExpansion Areas polygons

gfrs_ina.shx

ESRI shapefile

Grandfathered Groundwater Rights in the Irrigation NonExpansion Areas geometry index

irrdist.dbf

dBaseIV database table

Irrigation Districts polygon attributes

 

 

 

irrdist.sbn

ESRI shapefile

Irrigation Districts spatial index

 

 

 

irrdist.sbx

ESRI shapefile

Irrigation Districts spatial index

irrdist.shp

ESRI shapefile

Irrigation Districts polygons

irrdist.shx

ESRI shapefile

Irrigation Districts geometry index

quad.gif

GIF image

Illustration for adwrgfrs.htm

section.dbf

dBaseIV database table

section polygon attributes

section.sbn

ESRI shapefile

section spatial index

section.sbx

ESRI shapefile

section spatial index

section.shp

ESRI shapefile

section polygons

section.shx

ESRI shapefile

section geometry index

tinylogo.gif

GIF image

Illustration for adwrgfrs.htm

township.dbf

dBaseIV database table

township polygon attributes

township.sbn

ESRI shapefile

township spatial index

township.sbx

ESRI shapefile

township spatial index

township.shp

ESRI shapefile

township polygons

township.shx

ESRI shapefile

township geometry index

TYPE2_**.rtl

Microsoft Word document for each AMA

Type 2 GFR .rtl

TYPE2_**.xls

Microsoft Excel worksheet for each AMA

Type 2 GFR .xls

 

 

 

         Return to Top


58LOOKUP.DBF
This table is from the Oracle database

Field Name

Size

Type

Description

PROGRAM

2

C

ADWR program number (58 = Grandfathered Groundwater Right). Redundant but familiar prefix "58-" is used in some reports

CERTIFICATE

6

C

Unique GFR identification number

CONVEYANCE

4

C

Identifies how many times a GFR has changed in ownership

FILE_STATUS

2

C

Code that lets you know the information on the status of the GFR (See File Status codes in Code Explanations)

WATER_CATEGORY

1

C

Code that lets you know what type of GFR it is (See Water Category codes in Code Explanations)

MAP_LABEL

11

C

A concatenation of the Certificate and Conveyance field

YEAR

2

C

File status date in Oracle

IRR_ACRES

9.2

N

How many irrigated acres are in the right

RET_ACRES

9.2

N

How many retired acres are in the right (usually refers to a Type-1 right)

AMA_CODE

1

C

Code that lets you know what Active Management or Irrigation NonExpansion Area that the right is in (See Ama Code in Code Explanations)

QUAD_CODE

1

C

Code that lets you know what Quadrant of the Township Range and Section that the right is in (See the 'How to Understand Quad Codes' section)

TOWNSHIP

2

I

Township 1 - 41 north or 1 - 24 south

HALF_TOWN

1

C

There are a few half townships in Arizona

RANGE

2

I

Range 1 - 31 east or 1 - 24 west

HALF_RANG

1

C

There are a few half ranges in Arizona

SECTION

2

C

Section number 1 - 36

OWNER

61

C

Name of the current owner

ADDRESS1

40

C

Mailing address of the current owner

ADDRESS2

40

C

Mailing address of the current owner (Sometimes left blank)

CITY

20

C

City name of the current owner

STATE

2

C

Postal state abbreviation

ZIPCODE

6

C

Postal Zip Code

         Return to Top


60LOOKUP.DBF

NOTE: 60lookup.dbf contains all of the same field names as 58lookup.dbf

 


Code Explanations


Excluded and Irrigated Codes

Code

Explanation

0

Irrigated portion of the right

1

Non-irrigated portion of the right

2

No Right

3

Type 1 right

4

Type 1 Non-appurtenant

6

Irrigated portion of a partially developed right

7

Non-irrigation portion of a partially developed right

8

Withdrawn

9

Fully Developed

10

Irrigated portion of an extinguished right

11

Non-irrigated portion of an extinguished right

12

Type 1 extinguished right

13

Type 1 non-appurtenant portion of an extinguished right

File Status Codes Active

Return to 58LOOKUP.DBF

Code

 

Explanation

AA

Active

A right that has not yet been conveyed and is still capable of being used for its originally intended purpose

AC

Full Conveyance

All of the acres are conveyed to one new owner

AD

Partial Conveyance

Land that is split among more than one new owner

AE

Full Retirement

Applies to Type 1 only, the code is used when an IGFR is first retired to a Type 1

AF

Partially Retired

Used for a Type 1 or IGFR, indicates that not all Irrigation acres form the original IGFR have been retired

AG

Consolidated

Two or more rights have been consolidated into one

AO

Flood Substitution

An IGFR that has substituted some, or all of the originally certified acres for new ones persuant to A.R.S. 45-465.01

AP

CAP Substitution

An IGFR that has substituted acres pursuant to A.R.S. 45-452B

AQ

System Substitution

See A.R.S. 45-465.02

AR

Paritially Consolidated

Part of a right consolidated with another right

AS

Partially Developed

Used when part of the certified irrigation acres are no longer capable of being irrigated, but is still in the same ownership

AT

Partially Retired

 

AU

Partial Conveyance/Data Required

Split of the right/Have fee, need deed

AV

Partial Conveyance/Fee Required

Split of the right/Have deed, need fee

AW

Partial Conveyance/Data and Fee Missing

Split of the right/Data and Fee Missing

AX

Full Conveyance/Data Required

Full acreage/Data Required

AY

Full Conveyance/Fee Required

Full acreage/Fee Required

AZ

Full Conveyance/Data and Fee Missing

Full acreage/Data and Fee Missing

File Status Codes - Exempt

Code

 

Explanation

E0

Exempt

Due to the Small Rights Amendment

EF

Active Exempt to file

Data and fee missing.

File Status Codes - Inactive

Code

 

Explanation

IA

Inactive Inactive

Used in municipal sector to inactivate out of business or merged provider

II

Withdrawn

Voluntary; could be almost any type of right or permit

IM

Developed

Should apply to IGRs and Type 1s only; land has been developed and is no longer capable of being irrigated or capable of receiving Non-Irrigation water

IU

Inactive/Extinguished Pledged

A grandfathered right that has been extinguished for Assured Water Supply credits, and the credits have already been pledged

IV

Inactive/Extinguished not pledged

Same as above, but the credits have not been pledged

File Status Codes - Non_exempt=>An IGR that is under 10 acres in size but does not meet the other criteria for exemption under the Small Rights Amendment

Code

 

Explanation

NG

Non-Exempt/Consolidated

An IGR that resulted from the consolidation of two or more IGRs, ten acres or less in size, but does not qualify for exemption under the Small RIghts Amendment

N0

Non-exempt/Flood Substitution

An IGR that has substituted acres pursuant to A.R.S. 45-465.01 but does not qualify for the Small Rights Amendment

NA

Non-Exempt/Active

The IGR was probably originally Non-exempt and the data and fee received, but since has been placed in exempt status

NC

Non-Exempt/Full Conveyance

An IGR under ten acres that does not qualify for the exempt status, was conveyed in its entirety

ND

Non-Exempt/Partial Conveyance

Split of the right

NW

Non-Exempt/Partial Conveyance

Split of the right/Data and Fee Missing

NU

Non-Exempt/Partial Conveyance

Split of the Right/Data Missing

NV

Non-Exempt/Partial Conveyance

Split of the right/Fee Missing

NX

Non-Exempt/Full Conveyance

Full acreage/Data Missing

NY

Non-Exempt/Full Conveyance

Full acreage/Fee Missing

Water Categories

Return to 58LOOKUP.DBF

Code

Explanation

 

J

Irrigation Use GFR

 

K

Non-Irrigated Portion of Irrigation Use GFR

 

L

Type 1 GFR

 

M

Type 2 Non-Irrigation GFR

 

N

Type 2 Power

 

O

Type 2 Mineral Extraction

 

AMA Codes

Return to 58LOOKUP.DBF

Code

Explanation

 

A

Joseph City INA

 

B

Prescott AMA

 

C

Phoenix AMA

 

D

Pinal AMA

 

E

Tucson AMA

 

F

Douglas INA

 

G

Harquahala INA

 

H

Santa Cruz AMA

 

 

Code

Explanation

 

AMA

Active Management Area

 

INA

Irrigation NonExpanasion Area

 

Quad Codes

Return to 58LOOKUP.DBF

Code

Explanation

 

A

NorthEast

 

B

NorthWest

 

C

SouthWest

 

D

SouthEast

 

         Return to Top


Understanding how to use the Quad Codes


         Return to Top


For More Information


Thank you for your interest in the ADWR Grandfathered Groundwater Right Database.

We are always interested in hearing your comments, suggestions for improvements or about any problems you have encountered using this product. For more information about this product, assistance using the product or to report problems please contact:

Arizona Department of Water Resources

Bookstore

500 North Third Street

Phoenix, Arizona 85004

602-417-2485 phone

602-417-2488 fax

ecstephan@adwr.state.az.us

Visit our ADWR Web Site

         Return to Top