|
|
Arizona |
Geographic Information Services
|
Quick links to:
|
Arizona Grandfathered Groundwater
Rights
|
|
|
|
· 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.
- The CD-ROM can be used with any personal computer or workstation operating system.
- The documentation can be read using any Web browser.
- The database tables are in dBaseIV format files (.dbf) and can be used with most database software to look up information about each well (including location coordinates). This database has been tested with Microsoft Access 2000 2000
- The map shapefiles (.shp) can be used with most GIS and some CAD software to map the well locations. You can also use the freeArcExplorer viewer to look at the well locations on this CD-ROM.
- Three identical ESRI ArcView version 3.2x project files (.apr) containing all of the maps and related tables are included on the CD-ROM. Use the one that corresponds to the drive designation of your CD-ROM (ie. use drive_e.apr if your CD-ROM is drive E:, etc.)
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.
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 |
|
|
|
|
|
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 |
|
|
FILE_STATUS |
2 |
C |
Code that lets you know the information on the status of the GFR (See File Status codes in Code Explanations) |
|
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) |
|
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 |
|
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
|
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
|
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
|
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
|
Code |
Explanation |
|
|
A |
NorthEast |
|
|
B |
NorthWest |
|
|
C |
SouthWest |
|
|
D |
SouthEast |
|
Understanding how to use the Quad Codes
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
Visit our ADWR Web Site