New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 6)
E-GIS Data Dictionary Table Link Page
Tables linkages added by SNH (11/4/02)
Tables linkages expanded by KS2i (01/06/2003)
ACEQUIA_ASSOCIATION
ADJUDICATED_AREA
AERIAL_PHOTO_PRINTS_IMAGE
AQUIFER
ATTORNEY
BRIDGE
CITY_BOUNDARY
CITY_POINTS
CNSRV_IRR_DIST
CNSRV_IRR_DIST_IMAGE
CNSRV_IRR_DIST_MAP_BOUNDARY
CONTOURS
CONVEYANCE
COUNTY
CROP
CROP_INFO
DAM
DECLARED_GROUND_WATER_BASIN
DEM
DIGITAL_ORTHOPHOTOGRAMMETRY
DIGITAL_RASTER_GRAPHIC
EGIS_REGISTRY
EGIS_ROLE
EGIS_USER
EGIS_USER_MAP
EGIS_USER_ROLE
FEDLAND
FLOOD_BOUNDARY
GCDB_COORDS
GCDB_FIRST
GCDB_LADESC
GCDB_RECBND
GCDB_TWNSHP
GEODETIC_CONTROL
GEOLOGY
GW_MODELS
GW_MODEL_DETAIL
HIST_HYDRO_SURVEY_BOUNDARY
HYDRO_SURVEY_BOUNDARY
HYDRO_SURVEY_STATUS_HIST
HYDRO_SURVEY_IMAGES
IRS_IMAGE
LULC_GENERAL
METEOROLOGY
METEOROLOGY_DETAIL
OSE_DISTRICT
OWNER
3c732863-864b-4b34-866f-f40539dce001.xls Page 1 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 6)
OWNER_POU
OWNER_WR
POD
POD_PRIORITY
POU
POU_POD
PRIORITY
RAILWAY_TIGER
RESERVATION
ROADS_GPS
ROADS_TIGER
SOILS
STATE
STATELAND
STREAM
SUBDIVISION
SURFACE_WATER_BASIN
SURFACE_WATER_NETWORK
SURFACE_WATER_POINTS
USGS_WELL
VEGETATION
WATER_BODY
WATER_BODY_REACH
WATER_PLANNING_REGION
WATER_RIGHT
WEIR
WR_POD
WR_POU
WR_REGULATION
WETLANDS
WTR_RIGHT_STATUS_HIST
WUC_SURVEY
3c732863-864b-4b34-866f-f40539dce001.xls Page 2 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : ACEQUIA_ASSOCIATION
ACEQUIA ASSOCIATION: OSE generated table that provides information such as name and data established for the New Mexico Acequia Association (NMAA).
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
ACQA_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
The ploygon may
include the cultural
area or just the POUs
that are part of the
SHAPE Geometry Feature geometry. Yes System acequia.
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
Acequias are linked to
conveyances in the
CONVEYANCE
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System table.
ACQA_NAME Text 40 Name of association. No Yes Sys Admin
Previous name(s) of association, if Added based on AGIS
ACQA_PREV_NAME Text 65 any. Yes Sys Admin Report.
Boolean code to denote the
operational status of the acequia (Y Added based on AGIS
ACQA_STATUS Text 1 = active and N = inactive). Yes BOOLEAN_TYPE Sys Admin Report.
Boolean code to denote the historic
status of the acequia (Y = on the
Historic Register and N = not on Added based on AGIS
ACQA_HISTORIC Text 1 the historic register). Yes BOOLEAN_TYPE Sys Admin Report.
Added based on AGIS
CONTACT_FNAME Text 25 Contact's first name. Yes Sys Admin Report.
Added based on AGIS
CONTACT_LNAME Text 30 Contact's last name. Yes Sys Admin Report.
3c732863-864b-4b34-866f-f40539dce001.xls Page 3 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Contract's position (e.g., Added based on AGIS
CONTACT_POSITION Text 30 Mayordomo, Commissioner). Yes Sys Admin Report.
Added based on AGIS
ADDR1 Text 30 Contact's address, first line. Yes Sys Admin Report.
Added based on AGIS
ADDR2 Text 30 Contact's address, second line. Yes Sys Admin Report.
Added based on AGIS
CITY Text 15 Contact's city. Yes Sys Admin Report.
Contact's state two-letter Added based on AGIS
STATE Text 2 abbreviation. Yes STATE_CODE NM Sys Admin Report.
Added based on AGIS
ZIP Text 9 Contact's zip code. Yes Sys Admin Report.
Short Added based on AGIS
MEMBERS Integer 5,0 Number of acequia members. Yes Sys Admin Report.
Date the acequia was established.
If the day and/or month is not
known, the last day of the known
DATE_ESTD Date 8 month or year will be entered. Yes Sys Admin
Date the acequia became inactive,
if it is inactive. If the day and/or
month is not known, the last day of
the known month or year will be Added based on AGIS
DATE_INACTIVE Date 8 entered. Yes Sys Admin Report.
Date the acequia was established
under the existing name. This date
field will be null if the acequia has
not changed its name since it was
established. If the day and/or
month is not known, the last day of
the known month or year will be Added based on AGIS
DATE_NAME Date 8 entered. Yes Sys Admin Report.
3c732863-864b-4b34-866f-f40539dce001.xls Page 4 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : ADJUDICATED_AREA
ADJUDICATED AREA: OSE generated table that provides adjudication information for the survey area.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
ADJA_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Common name used to describe
ADJA_NAME Text 40 adjudication. No Yes LAP
Long ATTORNE
ATTY_ID Integer 10,0 Key from ATTORNEY table. No Y Sys Admin.
E-mail address for relevant district
ENG_EMAIL Text 40 engineer. Yes WRD
Basin section identifier. Used in
Hydro/Legal work to identify WRATS
BASIN_SECTION_HL Text 4 survey or portions. Yes (subfile)
Date Adjudication begun or is
planned to begin. If the day and/or
month is not known, the last day of
the known month or year will be
START_DATE Date 8 entered. Yes LAP
Date Partial Final Decree was filed
with the court or the best estimate
of when the adjudication will be
complete. If the day and/or month
is not known, the last day of the
known month or year will be
COMP_DATE Date 8 entered. Yes LAP
3c732863-864b-4b34-866f-f40539dce001.xls Page 5 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : AERIAL_PHOTO_PRINTS_IMAGE
AERIAL PHOTO PRINTS IMAGE: OSE generated table showing available Aerial photo prints.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
MSI_ID Integer 10,0 Primary key. No Yes System
NAME Text
Long 255 File name of the Photo. No System
IMAGE Integer 10,0 Unique raster identifier. No Yes System
Photo-Image name and/or
PHOTO_NAME Text 40 identifying number. No Sys Admin
Abbreviation of the government
organization or company name that
PROVIDER Text 4 provided the photogrammetry. Yes PROVIDER_ CODE Sys Admin
Acquisition date of imagery (i.e.,
the date the imagery was
photographed). If the day and/or
month is not known, the last day of
the known month or year will be
IMAGE_DATE Date 8 entered. Yes Sys Admin
The feature (usually DOQQs) that
was used to geo-reference the
SOURCE_MAP Text 3 irrigation map. SOURCE_TYPE_ CODE Sys Admin
Horizontal accuracy relative to the
controlling features per NSSDA in
REL_HORIZ_ACC Double 17,3 feet using an affine transformation. Yes Sys Admin
3c732863-864b-4b34-866f-f40539dce001.xls Page 6 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : AQUIFER
AQUIFER: OSE generated table that provides Aquifer name information collected from Hydrology Bureau.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
AQUIFER_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Long
ROCK_TYPE Integer 5,0 Rock type. Yes ROCK_TYPE_CODE HB
AQUIFER_TYPE Text 5 Aquifer type. No AQUIFER_TYPE_CODE HB
Table Name : ATTORNEY
ATTORNEY: OSE generated table that provides Attorney's name and email address.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
ATTY_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
First name of OSE/ISC Attorney in
ATTY_FIRST Text 40 charge of adjudication. Yes LAP
Last name of Attorney in charge of
ATTY_LAST Text 40 adjudication. Yes LAP
Email address of OSE/ISC
ATTY_EMAIL Text 40 Attorney in charge of adjudication. Yes LAP
3c732863-864b-4b34-866f-f40539dce001.xls Page 7 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : BRIDGE
BRIDGE: Data imported from New Mexico State Highway Transportation Department. Spatial accuracy is unknown.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
BR_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
SURFACE
Key from _WATER_
Long SURFACE_WATER_NETWORK NETWOR
SWN_ID Integer 10,0 table. No Yes K Sys Admin
BR_DESCRIPT Text 38 Bridge Description. Yes NMSHTD
BEG_MPNT Double 17,3 Beginning milepost in miles. Yes NMSHTD
DESIGN Text 2 Design type. Yes BR_DESIGN_ CODE NMSHTD
Lane Direction; only interpreted for
DIR Text 1 INTER STATE. Yes BR_DIR_CODE NMSHTD
Length of bridge in thousandths of
BR_LEN Double 17,3 a mile. Yes NMSHTD
Long
MATERIAL Integer 10,0 Material. Yes BR_MATERIAL_ CODE NMSHTD
Milepost location in miles. ( Note
that this attribute will differ from
MI_POST Double 17,3 actual mile point). Yes NMSHTD
PSTD_RTE_DIR Text 7 Posted Route. Yes NMSHTD
ROUTE Text 6 Route name. Yes NMSHTD
ROUTE_NBR Double 11,0 Route number. Yes NMSHTD
3c732863-864b-4b34-866f-f40539dce001.xls Page 8 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Route system (e.g., county road or
RTSYS Text 2 interstate). Yes RTSYS_CODE NMSHTD
Service on (e.g., highway or
SERV_ON Text 3 waterway). Yes SERV_ON_CODE NMSHTD
SERV_UNDER Text 3 Service under. Yes NMSHTD
STRUC_NBR Text 5 Internal Structure number. Yes NMSHTD
YR_BUILT Text 4 Year Built. Yes NMSHTD
YR_RECON Text 4 Year Reconstructed. Yes NMSHTD
Table Name : CITY_BOUNDARY
CITY BOUNDARY: Data imported from Earth Data Analysis Center (EDAC) / Census Bureau. Digitized from 1:100,000 quads.
Data Valid Values / Default Foreign
Column Name Size Brief Description Nulls Unique Source Comments
Type Code Table Value Key
Long
CTYBNDY_ID 10,0 Primary key. No Yes System
Integer
Long
OBJECTID 10,0 Unique feature identifier. No Yes System
Integer
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 Yes System
squared.
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Some null
NAME Text 66 Name of city. Yes EDAC / GNIS records found in
the data.
3c732863-864b-4b34-866f-f40539dce001.xls Page 9 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
EDAC does not
provide any
description.
PLACE Text 5 Yes
Numbers are
persent in this
field.
Note that the
data is missing
COUNTY Text 2 County name Yes COUNTY_CODE
from the EDAC
data.
Some null
Long
POP2000 6,0 2000 Population Yes records found in
Integer
the data.
3c732863-864b-4b34-866f-f40539dce001.xls Page 10 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : CITY_POINTS
CITY POINTS: Data imported from Earth Data Analysis Center / GNIS file. Digitized from 1:24,000 quads.
Data Valid Values / Default Foreign
Column Name Size Brief Description Nulls Unique Source Comments
Type Code Table Value Key
Long
CTYPNT_ID 10,0 Primary key. No Yes System
Integer
Long
OBJECTID 10,0 Unique feature identifier. No Yes System
Integer
SHAPE Geometry Feature geometry. Yes System
NAME Text 125 Name of city. Yes EDAC / GNIS
Code for the county wherein city is
COUNTY Text 2 No EDAC / GNIS
located. COUNTY_CODE
Population of city (only available
POP2000 Double 11,0 Yes EDAC / GNIS
for larger places).
Elevation of city, in feet, above or Note that datum
depth below sea level (NGVD 29) will change to
ELEVATN Double 11,0 Yes EDAC / GNIS
of the highest or lowest point, NAVD88 in
CTYPNT_ ELEVATN_
respectively, of the feature. RANGE
future.
STFIPS Text 3 State FIPS Code. Yes EDAC / GNIS
COFIPS Text 3 County FIPS Code. Yes EDAC / GNIS
TOPOQUAD Text 60 USGS Quadrangle Name. Yes EDAC / GNIS
3c732863-864b-4b34-866f-f40539dce001.xls Page 11 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : CNSRV_IRR_DIST
CONSERVANCY IRRIGATION DISTRICTS: Provides list of irrigation and conservancy districts.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
DIST_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Conservancy or irrigation district
NAME Text 5 name. No CNSRV_IRR_ CODE Sys Admin
Code denoting the type of district
(Conservancy (C) or Irrigation (I)
DIST_TYPE Text 3 District). No DIST_TYPE_ CODE Sys Admin
A code to denote an irrigation
district that cooperates with the
United States under the 1902
Reclamation Act (Y/N). All
conservancy districts will have null
IS_REC_LAW Text 1 values. Yes BOOLEAN_TYPE Sys Admin
Date of establishment. If the day
and/or month is not known, the last
day of the known month or year
DATE_ESTD Date 8 will be entered. Yes Sys Admin
3c732863-864b-4b34-866f-f40539dce001.xls Page 12 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : CNSRV_IRR_DIST_IMAGE
CONSERVANCY / IRRIGATION DISTRICTS IMAGES: Provides list of conservancy irrigation district map images.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
CIDI_ID Integer 10,0 Primary key. No Yes System
NAME Text
Long 255 File name of the Image. No System
IMAGE Integer 10,0 Unique raster identifier. No Yes System
Conservancy or irrigation district
name (link to CNSRV_IRR_CODE
IMAGE_NAME Text 5 table). No CNSRV_IRR_ CODE Sys Admin
Conservancy or irrigation district
MAP_NBR Text 20 map number or name. Yes Sys Admin
Date the irrigation map was
surveyed or created. If the day
and/or month is not known, the last DATE_RANGE
day of the known month or year (01/01/1900 to
MAP_DATE Date 8 will be entered. Yes 01/01/2099) Sys Admin
The feature (usually DOQQs) that
was used to geo-reference the
SOURCE_MAP Text 3 irrigation map. SOURCE_TYPE_ CODE Sys Admin
Horizontal accuracy relative to the
Short controlling feature per NSSDA in
REL_HORZ_ACC Integer 5,0 feet using an affine transformation. Yes Sys Admin
3c732863-864b-4b34-866f-f40539dce001.xls Page 13 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : CNSRV_IRR_DIST_MAP_BOUNDARY
CONSERVANCY / IRRIGATION DISTRICT MAP BOUNDARY: OSE/ISC generated table showing the boundaries of historic district maps along with general
information.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
CIDMB_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
The official name of the
DISTRICT_NAME Text 5 Conservancy or Irrigation District. No CNSRV_IRR_CODE HSB
District map name, typically shown
DISTRICT_MAP Text 75 on the map. Yes HSB
DIST_SUB_NAME Text 75 Sub-map name, only if applicable. Yes HSB
Map number that is unique for the
District. Typically, the number will
MAP_NBR Text 75 be shown on the map sheet. Yes HSB
Denominator of scale in a ratio
Long scale (e.g., 1:3,600 is recorded as
SCALE Integer 6,0 3600). Yes HSB
Date survey completed. Typically,
the date shown on the district map
sheet. If the day and/or month is
not known, the last day of the
known month or year will be
DATE_COMP Date 8 entered. Yes HSB
3c732863-864b-4b34-866f-f40539dce001.xls Page 14 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : CONTOURS
CONTOURS: Contour elevations generated from USGS 30 minute DEM.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
CONTOUR_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Short Elevation Value in meters above CONTOUR_ RANGE
CONTOUR Integer 5,0 NAVD88. Yes (850 to 4,020 meters) USGS
3c732863-864b-4b34-866f-f40539dce001.xls Page 15 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : CONVEYANCE
CONVEYANCE: OSE generated table for conveyances between POD features and POU features.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
CNVY_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Used to link the conveyance to the
associated acequia, irrigation ACQA _ID Added based on AGIS
ACQA_CIDI_ID Text 16 district, or conservancy district. Yes or CIDI_ID Report.
CNVY_NAME Text 40 Name of conveyance. Yes Sys Admin
Code to denote the physical
condition of the conveyance (e.g., Added based on AGIS
CNVY_CONDITION Text 1 good, poor). CNVY_COND_ CODE Sys Admin Report.
Short The conveyance section average Added based on AGIS
CNVY_GRADE Integer 5,0 gradient in percent slope. Yes Sys Admin Report.
Boolean code to denote the historic
status of the conveyance (Y = on
the Historic Register and N = not Added based on AGIS
CNVY_HISTORIC Text 1 on the historic register). Yes BOOLEAN_TYPE Sys Admin Report.
Type of material used to construct
CNVY_MAT Text 1 the conveyance. Yes CNVY_MAT_ CODE Sys Admin
Code to denote the conveyance
hierarchical order (e.g., madre, Added based on AGIS
CNVY_ORDER Text 1 contra). Yes CNVY_ORDER_ CODE Sys Admin Report.
Boolean code to denote the
operational status of the
conveyance (Y = active and N = Added based on AGIS
CNVY_STATUS Text 1 inactive). Yes BOOLEAN_TYPE Sys Admin Report.
Type of physical conveyance (e.g.,
CNVY_TYPE Text 2 ditch, pipe). Yes CNVY_TYPE_ CODE Sys Admin
3c732863-864b-4b34-866f-f40539dce001.xls Page 16 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Maximum capacity of the
conveyance in cubic feet per
FLW_CPTY_MAX Double 10,3 second. Yes Sys Admin
Entity responsible for the
OPERATOR Text 40 conveyance. Yes Sys Admin
Source of the graphic feature
location and shape. Usually a
SOURCE_MAP Text 3 hydrographic survey. Yes SOURCE_TYPE_ CODE Sys Admin
The date that the conveyance was
originally constructed or last
CNVY_DATE Date 8 rehabilitated. Yes Sys Admin
The date that the feature was
mapped or described. If the day
and/or month is not known, the last
day of the known month or year
SOURCE_DATE Date 8 will be entered. Yes Sys Admin
Horizontal accuracy per NSSDA in
HORZ_ACC Double 17,3 U.S. Survey Feet. Yes Sys Admin
The source of the accuracy estimate
(e.g., field verified or professional
SOURCE_ACC Text 3 estimate). Yes SOURCE_ACC_ CODE Sys Admin
3c732863-864b-4b34-866f-f40539dce001.xls Page 17 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : COUNTY
COUNTY: Data imported from Earth Data Analysis Center / Census Bureau. Digitized from 1:100,000 quads.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
COUNTY_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
NAME Text 20 County Name. No COUNTY_CODE EDAC/CB
Two letter code for county. These
numerical codes are presented in
"Counties, and County Equivalents
of the United States, Federal
Information Processing Standards
Both the County name
Publication 6-2", issued by the and code are provided
National Bureau of Standards to minimize response
COUNTY_CODE Text 2 (1973). No COUNTY_CODE Sys Admin time.
3c732863-864b-4b34-866f-f40539dce001.xls Page 18 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : CROP
CROP: OSE generated table containing CROP inventory data.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
CROP_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Long Key that identifies the place of use The POU may or may
POU_ID Integer 10,0 feature in the POU Table. No POU Sys Admin not exist in WATERS.
Crop code identifying the type of
crop irrigated. The crop code uses
an OSE-developed table that
groups crops by the botanical and
CROP_CODE Text 6 agronomical relationships. Yes CROP_CODE WU&C
Crop symbol (developed by OSE)
identifying the type of crop
irrigated. This crop symbol is
typically used to denote the crop
CROP_TYPE Text 3 types on maps. Yes CROP_TYPE_ CODE WU&C
A four letter code for the method
used to collect the crop data (e.g., CROP_COLLECT_
CROP_COLLECT Text 4 field survey or unverified reports). Yes CODE WU&C
Consumptive irrigation required in
CIR Double 10,3 acre-feet of water per acre. Yes WU&C
The last name of the individual
who conducted or reported the crop
REPT_NAME Text 40 inventory. Yes WU&C
3c732863-864b-4b34-866f-f40539dce001.xls Page 19 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
The organization that conducted or
REPT_ORG Text 3 reported the crop inventory. Yes CROP_ORG_ CODE WU&C
The base map used to control the
crop inventory (e.g., DOQQ or
SOURCE_MAP Text 3 Hydrographic Survey). Yes SOURCE_TYPE_ CODE WU&C
Date the crop survey was
conducted. If the day and/or month
is not known, the last day of the
known month or year will be
CROP_DATE Date 8 entered. Yes WU&C
Horizontal accuracy per NSSDA in
HORZ_ACC Double 17,3 feet. Yes WU&C
The source of the accuracy estimate
(e.g., field verified or professional
SOURCE_ACC Text 3 estimate). Yes SOURCE_ACC_ CODE WU&C
3c732863-864b-4b34-866f-f40539dce001.xls Page 20 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : CROP_INFO
CROP INFORMATION: OSE generated table, linked with CROP table to minimize data storage requirements since only few POUs need this information.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
CROP_INFO_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
Crop code identifying the type of
crop irrigated. The crop code uses
an OSE-developed table that
groups crops by the botanical and
CROP_CODE Text 6 agronomical relationships. No CROP_CODE Yes WU&C
Crop symbol (developed by OSE)
identifying the type of crop
irrigated. This crop symbol is
typically used to denote the crop
CROP_TYPE Text 3 types on maps. No CROP_TYPE_ CODE Yes WU&C
CROP_DESCR Text 255 Crop Description. No WU&C
NOTES Text 255 Notes about crop description. Yes WU&C
3c732863-864b-4b34-866f-f40539dce001.xls Page 21 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : DAM
DAM: Data imported from the National Inventory of Dams (NID) maintained by the Corps of Engineers.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
DAM_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
SURFACE
Key from _WATER_
Long SURFACE_WATER_NETWORK NETWOR
SWN_ID Integer 10,0 table. No Yes K Sys Admin
Official name of the dam. No
abbreviations used unless a part of
the official name. For dams that do
not have an official name, the
DAM_NAME Text 65 popular name is used. No NID/COE
Reservoir name or names in
common use other than the official
name of the dam. Names are
separated with semi-colons. Leave
OTHER_NAME Text 65 blank if not applicable. Yes NID/COE
Any previous reservoir or dam
name(s), if changed. Names are
FORM_NAME Text 65 separated with semi-colons. Yes NID/COE
Code indicating the type of dam (in
DAM_TYPE Text 2 order of importance): RE for Earth. Yes DAM_TYPE_ CODE NID/COE
3c732863-864b-4b34-866f-f40539dce001.xls Page 22 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Official name of the river or stream
on which the dam is built. If the
stream is unnamed, it is identified
as a tributary ("TR") to the named
river. If the dam is located off
stream, the name of the river or
stream is entered plus "-OS" or
RIVER Text 65 "OFFSTREAM". Yes NID/COE
Name of the nearest city, town, or
village that is most likely to be
affected by floods resulting from
CITY Text 65 the failure of the dam. Yes NID/COE
Name of the county in which the
COUNTY Text 65 dam is located. Yes NID/COE
The two letter abbreviation for the
state in which the dam is located. A
calculated field based on the field
STATE Text 10 item NIDID. No NID/COE
Official State or Agency
STATEID Text 25 identification number for the dam. Yes NID/COE
Dam location in terms of Section,
Township, and Range. Meridian
location is included if it is needed
TWS_RNG_SEC Text 65 to locate the dam. (Optional field) Yes NID/COE
Code indicating the position, type
of water right member and
CORE Text 1 certainty. Yes CORE_CODE NID/COE
3c732863-864b-4b34-866f-f40539dce001.xls Page 23 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Name of the principal firm(s) or
agency accomplishing design of
dam and major appurtenant
operating features, and major
modifications. The original
designer is listed first then
modification designers (if
applicable). The names are
DAM_DESIGN Text 65 separated with semi-colons. Yes NID/COE
Height of the dam, in feet to the
nearest foot, which is defined as the
vertical distance between the
lowest point on the crest of the dam
and the lowest point in the original
DAM_HEIGHT Double 17,0 streambed. Yes NID/COE
Structural height of the dam, in feet
to the nearest foot, which is defined
as the vertical distance from the
lowest point of the excavated
STR_HEIGHT Double 17,0 foundation to the top of the dam. Yes NID/COE
Hydraulic height of the dam, in feet
to the nearest foot, which is defined
as the vertical difference between
the maximum design water level
and the lowest point in the original
HYD_HEIGHT Double 17,0 streambed. Yes NID/COE
A calculated field based on the
maximum value of field items Dam
Height, Structural Height, and
Hydraulic Height, providing a
single height value to facilitate
NID_HEIGHT Double 17,3 database queries. Yes NID/COE
3c732863-864b-4b34-866f-f40539dce001.xls Page 24 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Length of the dam, in feet, which is
defined as the length along the top
of the dam. This length also
includes the spillway, power plant,
navigation lock, fish pass, etc.,
where these form part of the length
DAM_LENGTH Double 17,3 of the dam. Yes NID/COE
Distance from the dam to the
nearest affected City/Town/Village,
to the nearest mile (and tenth if
DISTANCE Double 17,0 appropriate). Yes NID/COE
Drainage area of the dam, in square
miles, which is defined as the area
that drains to a particular point (in
this case, the dam) on a river or
DRAIN_AREA Double 17,3 stream. Yes NID/COE
Code, indicating whether the dam
has an Emergency Action Plan
(EAP) developed by the dam
owner. An EAP is defined as a
plan of action to be taken to reduce
the potential for property damage
and loss of life in an area affected
EAP Text 2 by a dam failure or large flood. Yes EAP_CODE NID/COE
Code identifying which federal
agency was involved in the
construction of the dam. Codes are
concatenated if several agencies
FED_CONSTR Text 25 were involved. Yes NID/COE
Code identifying which federal
agency was involved in the design
of the dam. Codes are concatenated
FED_DESIGN Text 25 if several agencies were involved. Yes NID/COE
3c732863-864b-4b34-866f-f40539dce001.xls Page 25 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Code identifying federal fund
FED_FUND Text 25 source. Yes NID/COE
Code identifying which federal
agency is involved in the inspection
of the dam. Codes are concatenated
FED_INSP Text 25 if several agencies are involved. Yes NID/COE
Code identifying which federal
agency is involved in the operation
of the dam. Codes are concatenated
FED_OPER Text 25 if several agencies are involved. Yes NID/COE
Code identifying which federal
agency is involved in other aspects
of the dam. Codes are concatenated
FED_OTHER Text 25 if several owners are involved. Yes NID/COE
Code identifying which federal
agency partly or wholly owns the
dam. Codes are concatenated if
FED_OWN Text 25 several owners are involved. Yes NID/COE
Code identifying which federal
agency is involved in the regulation
of the dam. Codes are concatenated
FED_REG Text 25 if several agencies are involved. Yes NID/COE
Code for the material upon which
FOUND_MAT Text 2 dam is founded, and certainty. Yes FOUND_CODE NID/COE
Code indicating the potential
hazard to the downstream area
resulting from failure or
misoperation of the dam or
HAZARD Text 1 facilities. Yes HAZARD_CODE NID/COE
3c732863-864b-4b34-866f-f40539dce001.xls Page 26 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Date of the most recent inspection
of the dam prior to the transmittal
of the data by the submitting
agency. Date fields require day,
month and year information, and
various alphanumeric or numeric
combinations are used. If the day
and/or month is not known, the last
day of the known month or year
INSP_DATE Date 8 will be entered. Yes NID/COE
Scheduled frequency interval for
periodic inspections, in years.
NOTE: Replacement for "Phase I
INSP_FREQ Double 17,3 Inspection" field. Yes NID/COE
Latitude (NAD83) at dam
centerline as a single value in
LATITUDE Double 17,9 decimal degrees. Yes NID/COE
Longitude (NAD83) at dam
centerline as a single value in
LONGITUDE Double 17,9 decimal degrees. Yes NID/COE
Number of cubic feet per second
(cu ft/sec) which the spillway is
capable of discharging when the
reservoir is at its maximum
MAX_DIS Double 17,3 designed water surface elevation. Yes NID/COE
Maximum storage, in acre-feet,
which is defined as the total storage
space in a reservoir below the
normal retention level, including
dead and inactive storage and
excluding any flood control or
MAX_STOR Double 17,3 surcharge storage. Yes NID/COE
3c732863-864b-4b34-866f-f40539dce001.xls Page 27 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Normal storage, in acre-feet, which
is defined as the total storage space
in a reservoir below the maximum
attainable water surface elevation,
NORM_STOR Double 17,3 including any surcharge storage. Yes NID/COE
A calculated field based on the
maximum value of field items
Maximum Storage and Normal
storage, providing a single storage
NID_STOR Double 10,3 value to facilitate database queries. Yes NID/COE
The official NID identification
number for the dam, known
formerly as the National ID. This is
a required field, and must have an
entry for each dam included in the
NID. This field is used as the
unique identifier for each dam
record. The first two characters of
the identity are the state two-letter
abbreviation, based on the location
of the dam. The last five characters
of the identity are a unique number
NID_ID Text 7 (AB#####). No Yes NID/COE
Number of existing navigation
NO_LOCKS Double 17,0 locks for the project. Yes NID/COE
Length of the primary navigation
LEN_LOCKS Double 17,3 lock to the nearest foot. Yes NID/COE
Width of the primary navigation
WID_LOCKS Double 17,3 lock to the nearest foot. Yes NID/COE
Code(s) that describe the type of
spillway and controlled outlet OUTLET_GATES_
OUT_GATES Text 1 gates. Yes TYPE_CODE NID/COE
OWN_NAME Text 65 Name of the owner of the dam. Yes NID/COE
OWN_TYPE Text 1 Code indicating owner type. Yes OWN_TYPE_ CODE NID/COE
3c732863-864b-4b34-866f-f40539dce001.xls Page 28 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Code indicating whether the dam is
a private dam located on federal
PRIV_DAM Text 1 property. Yes BOOLEAN_TYPE NID/COE
Codes indicating the purposes for
PURPOSES Text 1 which the reservoir is used. Yes PURPOSES_CODE NID/COE
Code identifying the federal or state
source agency that has provided the
SOURCE Text 25 field data on the dam. Yes NID/COE
Code that describes the type of SPILLWAY_TYPE_
SPILL_TYPE Text 1 spillway. Yes CODE NID/COE
Width of the spillway, to the
nearest foot, available for discharge
when the reservoir is at its
maximum designed water surface
SPILL_WIDTH Double 17,3 elevation. Yes NID/COE
Name of the primary state agency
with regulatory or approval
ST_REG_AG Text 65 authority over the dam. Yes NID/COE
Code indicating whether the dam is
"State Regulated" under the
ST_REG_DAM Text 1 National Dam Safety Program. Yes BOOLEAN_TYPE NID/COE
Surface area, in acres, of the
impoundment at its normal
SURF_AREA Double 17,3 retention level. Yes NID/COE
Total number of cubic yards
occupied by the materials used in
the dam structure. Portions of
powerhouse, locks, and spillways
are included only if they are an
integral part of the dam and
VOL Double 17,3 required for structural stability. Yes NID/COE
3c732863-864b-4b34-866f-f40539dce001.xls Page 29 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Year when the original main dam
YR_COMPL Text 4 structure was completed. No NID/COE
Year (four digit) when major
modifications or rehabilitation of
dam or major control structures
were completed. Major
modifications are defined as
structural, foundation, or
mechanical construction activity
which significantly restores the
project to original condition;
changes the project's operation;
capacity or structural characteristics
(e.g., spillway or seismic
modification); or increase the Note that the attribute
longevity, stability, or safety of the size of 65 is from the
YR_MOD Text 65 dam and appurtenant structures. Yes NID/COE source agency.
3c732863-864b-4b34-866f-f40539dce001.xls Page 30 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : DECLARED_GROUND_WATER_BASIN
DECLARED GROUND WATER BASIN: OSE generated table providing information on Declared Ground Water Basins for the State of New Mexico. Each
groundwater basin has multiple polygons representing the date the polygon area was added to the basin.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
DGWB_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Basin designator of the Water
Right file number (a three letter WATERS
BASIN Text 3 code). Yes DGWB_CODE Yes (BASIN)
WATERS
BASIN_DESC Text 20 Basin name used by OSE. Yes (BASIN)
Short DIST_NBR_ RANGE (0 WATERS
DIST_NBR Integer 5,0 District number assigned by OSE. Yes to 5) (BASIN)
Domestic outside water use WATERS
DOM_OUTSIDE_USE Text 1 allowed in this basin (Y/N). Yes BOOLEAN_TYPE N (BASIN)
Must match
Standard domestic meter condition DOM_STD_MTR_ WATERS WATERS, but it is
DOM_STD_MTR_COND Text 2 requirement for this basin. Yes COND_CODE (BASIN) not yet implemented.
Date the portion of the basin was
declared. If the day and/or month
is not known, the last day of the
known month or year will be
DCLD_DATE Date 8 entered. Sys Admin
Boolean code to denote if this is a
IS_SUB_BASIN Text 1 sub basin (Y/N) No BOOLEAN_TYPE N Sys Admin
3c732863-864b-4b34-866f-f40539dce001.xls Page 31 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : DEM
DEM: Data imported from the U. S. Geological Survey (USGS).
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
DEM_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Long Elevation value in meters above Datum will change to
ELEVATION Integer 5,0 NGVD29. No ELVTN_M_ RANGE USGS NAVD88.
Table Name : DIGITAL_ORTHOPHOTOGRAMMETRY
DIGITAL ORTHOPHOTOGRAMMETRY: OSE generated table for available digital orthophotogrammetry.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
DOP_ID Integer 10,0 Primary key. No Yes System
NAME Text
Long 255 File name of the Image. No System
IMAGE Integer 10,0 Unique raster identifier. No Yes System
Photo-image name or identifying
number (e.g., "Bitter Lake, SW" for
IMAGE_NAME Text 40 a USGS DOQQ). No Yes Sys Admin
Abbreviation of the government
organization or company name that
PROVIDER Text 4 provided the photogrammetry. Yes PROVIDER_CODE Sys Admin
3c732863-864b-4b34-866f-f40539dce001.xls Page 32 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Acquisition date. If the day and/or
month is not known, the last day of
the known month or year will be
ACQ_DATE Date 8 entered. Yes Sys Admin
Horizontal data accuracy per
HORZ_ACC Double 17,3 NSSDA to the nearest foot. Yes Sys Admin
The source of the accuracy estimate
(e.g., field verified or professional
SOURCE_ACC Text 3 estimate). Yes SOURCE_ACC_ CODE Sys Admin
3c732863-864b-4b34-866f-f40539dce001.xls Page 33 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : DIGITAL_RASTER_GRAPHIC
DIGITAL RASTER GRAPHIC: The DRGs are imported from USGS and will be merged into a seamless file by EDAC. Scanned 1:24,000 quads.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
DRG_ID Integer 10,0 Primary key. No Yes System
NAME Text
Long 255 File name of the Image. No System
IMAGE Integer 10,0 Unique raster identifier. No Yes System
Depending on how
EDAC merges
(1:100,000,
1:250,000, or other)
the DRGs, this field
USGS Quadrangle name (e.g., may need to be
QUAD_NAME Text 40 "Bitter Lake"). No USGS/ EDAC modified.
Table Name : EGIS_REGISTRY
EGIS REGISTRY: Data related to all parameters and setting of EGIS, used by EGIS based applications.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
EGIS_REG_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
Name of the EGIS registry
PRM_NAME Text 50 parameter. No Yes Sys Admin
Data type of EGIS registry
PRM_TYPE Text 20 parameter. No String Sys Admin
PRM_VALUE Text 255 Value of EGIS registry parameter. No Sys Admin
Default value of EGIS registry
DEFAULT_PRM_VALUE Text 255 parameter. Yes Sys Admin
3c732863-864b-4b34-866f-f40539dce001.xls Page 34 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : EGIS_ROLE
EGIS_ROLE: OSE generated table for parameters and setting of EGIS, used by Query and Display application.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
This has role codes PUBLIC and
ROLE_CODE Text 16 EGIS currently. No Sys Admin
Role code description of PUBLIC
ROLE_DESC Text 50 and EGIS roles. Yes Sys Admin
Table Name : EGIS_USER
EGIS_USER: OSE generated table for parameters and setting of EGIS, used by Query and Display application.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
Used ID to login into Query and
USER_ID Text 50 Display application. No Yes Sys Admin
USER_FNAME Text 50 User's first name Yes Sys Admin
USER_LNAME Text 50 User's last name No Sys Admin
CREATED_DATE Date 8 User created date Yes Sys Admin
3c732863-864b-4b34-866f-f40539dce001.xls Page 35 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : EGIS_USER_MAP
EGIS_USER_MAP: OSE generated table for parameters and setting of EGIS, used by Query and Display application.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
USER_ID Text 50 Key from EGIS_USER table. No Yes Sys Admin
VIEW_NAME Text 50 Map view name. No Sys Admin
Name of Arc XML file created by
AXL_FILE_NAME Text 255 Java viewer client. No Sys Admin
Boolean code to denote initial map
view.
IS_DEFAULT Text 1 (Y = Default and N = Not Default). Yes BOOLEAN_TYPE Sys Admin
CREATED_DATE Date 8 Map view created date Yes Sys Admin
MODIFIED_DATE Date 8 Map view modified date Yes Sys Admin
COMMENTS Text 1000 Comments. Yes Sys Admin
Table Name : EGIS_USER_ROLE
EGIS_USER_ROLE: OSE generated table for parameters and setting of EGIS, used by Query and Display application.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
USER_ID Text 50 Key from EGIS_USER table. No Yes Sys Admin
ROLE_CODE Text 16 Key from EGIS_ROLE table. No Sys Admin
3c732863-864b-4b34-866f-f40539dce001.xls Page 36 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : FEDLAND
FEDLAND: Data imported from the Bureau of Land Management, New Mexico. Scanned from 1:100,000 BLM maps.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
FEDLAND_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Name denoting the administering
agency and use of the federal lands
NAME Text 50 (e.g., BLM wilderness). Yes BLM
Code denoting administering
LABEL Text 5 agency. Yes FEDLAND_CODE BLM
Table Name : FLOOD_BOUNDARY
FLOOD BOUNDARY: Data imported from Federal Emergency Management Agency (FEMA).
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
FB_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
FB_NAME Text 40 Flood boundary area name. No FEMA
3c732863-864b-4b34-866f-f40539dce001.xls Page 37 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : GCDB_COORDS
GCDB_COORDS: Data imported from the Geographic Coordinate Database (GCDB), BLM Land Survey Information Data Base. Table and field names follow the
Federal Geographic Data Committee (FGDC) format. This layer contains control locations for the township specified in LNDKEY.
Data Valid Values / Default Foreign
Column Name Type
Long Size Brief Description Nulls Code Table Value Unique Key Source Comments
GCDB_COORDS_ID Integer
Long 10,0 Primary key. No Yes System
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System Point
Concatenation of State + Principal
Meridian + Township + Range.
Used to relate the various GCDB
LNDKEY Text 16 layers. Yes No GCDB, BLM
PNTID Text 6 Control Point/Station ID. No GCDB, BLM
Longitude in decimal degrees,
EAST Double 14,9 NAD83. Yes GCDB, BLM
Latitude in decimal degrees,
NORTH Double 14,9 NAD83. Yes GCDB, BLM
Elevation in feet above NGVD27.
However, the BLM has used an
average elevation of 5000 feet for ELVTN_FT_ RANGE
ELEV Double 9,3 all townships in New Mexico. No (2,800 to 13,200 feet) 5000 GCDB, BLM
Northing error in feet based on the
Geographic Measurement
Management (GMM) software
which performs a least square
analysis of the recorded plat data
Note that BLM is
and reports a positional uncertainty considering the
at the 95 percent level of reporting of NSSDA
YACC Double 9,3 confidence. Yes GCDB, BLM in the future.
3c732863-864b-4b34-866f-f40539dce001.xls Page 38 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Easting error in feet based on the
Geographic Measurement
Management (GMM) software
which performs a least square
analysis of the recorded plat data
Note that BLM is
and reports a positional uncertainty considering the
at the 95 percent level of reporting of NSSDA
XACC Double 9,3 confidence. Yes GCDB, BLM in the future.
HDATUM Text 5 Horizontal Datum Yes No GCDB, BLM
The source of the accuracy estimate
(e.g., field verified or professional
SOURCE_ACC Text 3 estimate). Yes SOURCE_ACC_ CODE Sys Admin
NSSDA computed
GCDB horizontal accuracy per from ERROR_N and
HORZ_ACC Double 17,3 NSSDA, in feet. Yes Sys Admin ERROR_E.
Table Name : GCDB_FIRST
GCDB_FIRST: Data imported from the Geographic Coordinate Database (GCDB), BLM Land Survey Information Data Base. Table and field names follow the
Federal Geographic Data Committee (FGDC) format. This table contains polygons aggregated into section features.
Data Valid Values / Default Foreign
Column Name Type
Long Size Brief Description Nulls Code Table Value Unique Key Source Comments
GCDB_FIRST_ID Integer
Long 10,0 Primary key. No Yes System
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature feature in
Area of geometry. internal units Yes System
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Concatenation of State + Principal
Meridian + Township + Range.
Used to relate the various GCDB
LNDKEY Text 16 layers. Yes No GCDB, BLM
SECTION_NO_ CODE
SECTN Text 3 Section number. Yes (001 to 036) GCDB, BLM
3c732863-864b-4b34-866f-f40539dce001.xls Page 39 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
SECFRT Text 1 Section Fraction Yes GCDB, BLM
SECDUP Text 1 Duplicate Section Yes GCDB, BLM
Table Name : GCDB_LADESC
GCDB_LADESC: Data imported from the Geographic Coordinate Database (GCDB), BLM Land Survey Information Data Base. Table and field names follow the
Federal Geographic Data Committee (FGDC) format.
Data Valid Values / Default Foreign
Column Name Type
Long Size Brief Description Nulls Code Table Value Unique Key Source Comments
GCDB_LADESC_ID Integer
Long 10,0 Primary key. No Yes System
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System Polygon
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Concatenation of State + Principal
Meridian + Township + Range.
Used to relate the various GCDB
LNDKEY Text 16 layers. Yes No GCDB, BLM
SECTION_NO_ CODE
SECTN Text 3 Section number. Yes (001 to 036) GCDB, BLM
QUARTER Text 2 Quarter section Designator Yes QTR_SEC_CODE GCDB, BLM
3c732863-864b-4b34-866f-f40539dce001.xls Page 40 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
QQUARTER Text 2 Quarter-quarter section Designator. Yes QTR_SEC_CODE GCDB, BLM
NOMLOC Text 1 Nominal location. Yes NOM_LOC_CODE GCDB, BLM
SURSYS Text 2 Survey system type. Yes SURVEY_TYPE GCDB, BLM
SURNUM Text 5 Survey system number. Yes GCDB, BLM
SURSUF Text 2 Survey system suffix. Yes GCDB, BLM
SURNOTE Text 3 Survey system note. Yes GCDB, BLM
LADESCAR Double 9,2 Land description area acreage. Yes
Note that land
grants have been
added to this
version of the
GRANT_NAME Text 52 Name of the land grant. Yes NMOSE GCDB by OSE.
SURVEY_APPROVED Date Date the survey was approved. Yes GCDB, BLM
GRANT_CONFIRMED Date Date the grant was confirmed. Yes NMOSE
3c732863-864b-4b34-866f-f40539dce001.xls Page 41 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : GCDB_RECBND
GCDB_RECBND: Data imported from the Geographic Coordinate Database (GCDB), BLM Land Survey Information Data Base. Table and field names follow the
Federal Geographic Data Committee (FGDC) format. This table contains survey lines used to construct the GCDB polygons.
Data Valid Values / Default Foreign
Column Name Type
Long Size Brief Description Nulls Code Table Value Unique Key Source Comments
GCDB_RB_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System Line
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Concatenation of State + Principal
Meridian + Township + Range.
Used to relate the various GCDB
LNDKEY Text 16 layers. Yes No GCDB, BLM
Used for
Type of GCDB line (e.g., Section, cartographic
LNTYP Text 1 Quarter, etc). Yes LNTYPE_ CODE No GCDB, BLM display.
3c732863-864b-4b34-866f-f40539dce001.xls Page 42 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : GCDB_TWNSHP
GCDB_TWNSHP: Data imported from the Geographic Coordinate Database (GCDB), BLM Land Survey Information Data Base. Table and field names follow the
Federal Geographic Data Committee (FGDC) format. Layer contains polygons aggregated into a single feature representing the township boundary.
Data Valid Values / Default Foreign
Column Name Type
Long Size Brief Description Nulls Code Table Value Unique Key Source Comments
GCDB_TWP_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System Polygon
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Concatenation of State + Principal
Meridian + Township + Range.
Used to relate the various GCDB
LNDKEY Text 16 layers. Yes No GCDB, BLM
TOWN_NO_CODE (001
TOWN Text 3 Township number. Yes to 034) GCDB, BLM
TOWN_DIR_CODE (N
TWNDIR Text 1 Township direction. Yes or S) No GCDB, BLM
TOWN_FRAC_ CODE
TWNFRT Text 1 Township fraction. Yes (0 to 3) GCDB, BLM
RANGE_NO_CODE
RANGE Text 3 Range number. Yes (001 to 038) GCDB, BLM
RANGE_DIR_ CODE (E
RNGDIR Text 1 Range direction. Yes or W) GCDB, BLM
RANGE_FRAC_ CODE
RNGFRT Text 1 Range fraction. Yes (0 to 3) GCDB, BLM
TWNDUP Text 1 Township duplicate code. Yes TOWNSHIP_CODE GCDB, BLM
23 (New Mexico
Principal Meridian
PRIMER Text 2 Principal meridian code. Yes and Baseline) 23 GCDB, BLM
3c732863-864b-4b34-866f-f40539dce001.xls Page 43 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : GEODETIC_CONTROL
GEODETIC CONTROL: OSE generated table for maintaining miscellaneous geodetic control points.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
GC_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
PT_DESIGNATION Text 18 Name of the Point. Yes HSB
Latitude of the point in decimal LATITUDE_ RANGE
LATITUDE Double 17,9 degrees north. No (31.2 to 37.1) HSB
Longitude of the point in decimal LONGITUDE_ RANGE (-
LONGITUDE Double 17,9 degrees west, a negative number. No 191 to -102) HSB
NORTHING_ RANGE(
Northing coordinate in UTM 3,471,000 to 4,100,000
NORTHING Double 10,3 meters (NAD83(92)). Yes meters) HSB
EASTING_RANGE
Easting coordinate in UTM meters (115,000 to 682,000
EASTING Double 10,3 (NAD83(92)). Yes meters) HSB
Code for the county that the control
COUNTY Text 2 point is located. No COUNTY_CODE HSB
Elevation in feet (assumed to be
ELEV Double 8,1 NGVD29). Yes HSB
Long
YEAR_SURVY Integer 5,0 Year surveyed. Yes HSB
Hyperlinked reference to scanned
Horizontal Control Station
DOC_REFERENCE Text 255 Records. Yes HSB
3c732863-864b-4b34-866f-f40539dce001.xls Page 44 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : GEOLOGY
GEOLOGY: Data imported from USGS, BLM, and reformatted for EGIS. Digitized from 1:250,000 quads.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
GLGY_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
NAME Text 8 Formation Name. No USGS / BLM
P1 Double 11,0 GSMAP shorthand attribute. Yes USGS / BLM
Table Name : GW_MODELS
GROUND WATER MODELS: OSE/ISC generated table showing the groundwater models.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
GW_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Common name of groundwater
MODEL_NAME Text 40 model. No HB
Type of groundwater model (e.g.,
MODEL_TYPE Text 4 ModFlow 2000). Yes GW_MODELS_ CODE HB
3c732863-864b-4b34-866f-f40539dce001.xls Page 45 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
The number of layers used in the
MODEL_LAYERS Text 2 model. Yes HB
The name(s) of the aquifers
simulated in the model. Multiple
aquifer names are separated by a
AQUIFERS_SIMULATED Text 75 comma. Yes HB
Last name of the responsible
modeler to contact for technical
CONTACT Text 30 assistance. Yes HB
The number of the OSE Technical
Report that describes the
GW_REF Text 3 groundwater model. Yes HB
Flag indicating that this model is
available (Y) or under development
STATUS_FLAG Text 1 (N). Yes BOOLEAN_TYPE HB
Date that the model was completed
or is planned to be completed. If
the day and/or month is not known,
the last day of the known month or
GW_DATE Date 8 year will be entered. Yes HB
3c732863-864b-4b34-866f-f40539dce001.xls Page 46 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : GW_MODEL_DETAIL
GROUND WATER MODEL DETAIL: Groundwater model grids for attaching detailed cell-level modeling data.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
GW_DTL_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
Long GW_
GW_ID Integer 10,0 Relate key to GW_MODEL Table. No Yes MODELS System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Long
ROW_NBR Integer 5,0 Row in the model. No OSE
Long
COLUMN_NBR Integer 5,0 Column in the model. No OSE
A unique number for each cell
within a given model. This number
is used to link model inputs and
SEQNUM Double 10,0 outputs. No OSE
3c732863-864b-4b34-866f-f40539dce001.xls Page 47 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : HIST_HYDRO_SURVEY_BOUNDARY
HYDROGRAPHIC SURVEY BOUNDARY: OSE generated table showing the boundaries of historic hydrographic surveys along with general information.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
HIST_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
SURVEYS Text 75 Hydrographic survey name. Yes HSB
SURVEY_NBR Text 5 Hydrographic survey number.
CAUSE_NUMBER Text 30 Court Case Number HSB
Short No of sheets for the Hydrographic
NO_OF_SHEETS Integer 5,0 surveys HSB
Sheet number and number of
SHEET_NBR Text 10 sheets. (e.g. 1 of 4) HSB
SCALE Text 10 Denominator of scale Yes HSB
YEAR_COMP Text 4 Survey completed year. Yes HSB
3c732863-864b-4b34-866f-f40539dce001.xls Page 48 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : HYDRO_SURVEY_BOUNDARY
HYDROGRAPHIC SURVEY BOUNDARY: OSE generated table showing the boundaries of historic hydrographic surveys along with general information.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
HSB_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. No System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. No System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. No System
HSB
/WATERS
SURV_NAME Text 75 Hydrographic survey map name. No (POD)
Sub-survey name only if
applicable. For example, "Part 1 of
SUB_NAME Text 75 2". Yes HSB
Survey number that is unique for
the survey basin. Typically, the
number will be shown on the
SHEET_NBR Text 75 hydrographic survey sheet. Yes HSB
Denominator of scale in a ratio
Long scale (e.g., 1:3,600 is recorded as
SCALE Integer 6,0 3600). Yes HSB
The existing legal status of the
Hydrographic Survey (see Code
Table). The primary steps are LEGAL_ STATUS_
LEGAL_STATUS Text 2 preliminary, published, adjudicated Yes CODE HSB
3c732863-864b-4b34-866f-f40539dce001.xls Page 49 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
The existing status of the
conversion process from hardcopy
to EGIS. The process steps are:
imaging, geo-rectification, survey
vectorization, filing map
vectorization, linking with CONVERT_ STATUS_ Data Develop-
CONVERT_ STATUS Text 2 WATERS, and quality assurance. Yes CODE ment Team
The date that applies to the
CONVERT_STATUS. If no action
has been taken, the date will be Data Develop-
LAST_STATUS_ DATE Date 8 null. No ment Team
Date survey completed. Typically,
the date shown on the hydrographic
survey sheet. If the day and/or
month is not known, the last day of
the known month or year will be
DATE_COMP Date 8 entered. Yes HSB
COMMENTS Text 100 General comment space Yes HSB
Table Name : HYDRO_SURVEY_STATUS_HIST
HYDRO_SURVEY_PRODUCTION: OSE generated relationship table relating hydrographic surveys with the production history.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
HSS_HIST_ID Integer 10,0 Primary Key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
HYDRO_
SURVEY_
Long BOUNDARY
HSB_ID Integer 10,0 Relate key. No Table.
3c732863-864b-4b34-866f-f40539dce001.xls Page 50 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
The previous status of the
conversion process from hardcopy
to EGIS. The process steps are:
imagining, geo-rectification, survey
vectorization, filing map digization,
OLD_CONVERT_ linking with WATERS, and quality CONVERT_ STATUS_ Data Develop-
STATUS Text 2 assurance. Yes CODE ment Team
The status of the latest conversion
process from hardcopy to EGIS.
The process steps are: geo-
rectification, survey digitization,
filing map vectorization, linking
NEW_CONVERT_ with WATERS, and quality CONVERT_ STATUS_ Data Develop-
STATUS Text 2 assurance. Yes CODE ment Team
The group that provided the Data Develop-
PROVIDER Text 4 conversion services. No PROVIDER_ CODE ment Team
The date that applies to the
CONVERT_STATUS_CODE. If
no action has been taken, the date Data Develop-
CHANGE_DATE Date 8 will be null. Yes ment Team
3c732863-864b-4b34-866f-f40539dce001.xls Page 51 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : HYDRO_SURVEY_IMAGES
HYDROGRAPHIC SURVEY IMAGES: OSE generated table of geo-rectified hydrographic survey images.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
HSI_ID Integer 10,0 Primary key. No Yes System
NAME Text
Long 255 File name of the Image. No System
IMAGE Integer 10,0 Unique raster identifier. No Yes System
HYDRO_
Survey number linking the image to SURVEY_
HYDRO_SURVEY_ BOUNDA
SURV_NBR Text 50 BOUNDARY. Yes RY HSB
Date the hydrographic survey was
geo-referenced. If the day and/or
month is not known, the last day of DATE_RANGE
the known month or year will be (01/01/1900 to
ACQ_DATE Date 8 entered. Yes 01/01/2099) HSB
The feature (usually DOQQs) that
was used to geo-reference the
SOURCE_MAP Text 3 hydrographic survey. No SOURCE_TYPE_ CODE HSB
Horizontal accuracy relative to the
controlling feature per NSSDA in
feet. The relative accuracy is
Short computed from an affine
REL_HORZ_ACC Integer 5,0 transformation. Yes HSB
3c732863-864b-4b34-866f-f40539dce001.xls Page 52 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : IRS_IMAGE
IRS IMAGE: OSE generated table showing IRS imagery.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
MSI_ID Integer 10,0 Primary key. No Yes System
NAME Text
Long 255 File name of the Image. No System
IMAGE Integer 10,0 Unique raster identifier. No Yes System
Photo-Image name and/or
IMAGE_NAME Text 40 identifying number. No Sys Admin
Abbreviation of the government
organization or company name that
PROVIDER Text 4 provided the photogrammetry. Yes PROVIDER_ CODE Sys Admin
Acquisition date of imagery (i.e.,
the date the imagery was
photographed). If the day and/or
month is not known, the last day of
the known month or year will be
IMAGE_DATE Date 8 entered. Yes Sys Admin
Horizontal data accuracy per
HORZ_ACC Double 17,3 NSSDA in feet. Yes Sys Admin
The source of the accuracy estimate
(e.g., field verified or professional
SOURCE_ACC Text 3 estimate). Yes SOURCE_ACC_ CODE Sys Admin
3c732863-864b-4b34-866f-f40539dce001.xls Page 53 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : LULC_GENERAL
LAND USE LAND COVER GENERAL: Data imported from USGS, EDAC. Reported as digitized data from 1:250,000 and 1:100,000 quads. 1:250,000 is used since
the individual source locations are not specified.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
LULC_GEN_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
LU_TYPE Text 1 Land use Land cover type. No LU_TYPE_CODE USGS / EDAC
LU_SUB_TYPE Text 2 Land use sub type. Yes LU_SUB_TYPE_ CODE USGS / EDAC
3c732863-864b-4b34-866f-f40539dce001.xls Page 54 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : METEOROLOGY
METEOROLOGY: Data imported from the National Climate Data Center and reformatted for EGIS.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Valid values based on
long-term historic
records. The range of
values has been
increased by 20
Long percent on the low and
MET_ID Integer 10,0 Primary key. No Yes System high values.
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Station name as provided by the
STATION_NAME Text 32 National Climate Data Center. No NCDC
Station identifier as assigned by the
COOPID Double 11,0 National Climatic Data Center. Yes Yes NCDC
Long Station elevation above NAVD88 ELVTN_M_ RANGE
ELEVATION Integer 5,0 in meters. Yes (850 to 4020 Meters) NCDC
Station Latitude in decimal degrees LATITUDE_ RANGE
LATITUDE Double 17,9 relative to NAD83(92). Yes (31.20 to 37.10) NCDC
Station longitude in decimal LONGITUDE_ RANGE (-
LONGITUDE Double 17,9 degrees relative to NAD83(92). Yes 190.20 to -102.80) NCDC
Mean annual evaporation in ANL_EVAP_ RANGE
MN_ANL_EVP Double 17,3 hundredths of inches. Yes (9000 to 15500) NCDC
Mean annual temperature in tenths ANL_TEMP_ RANGE
MN_ANL_TMP Double 10,3 of degree F. Yes (300 to 800) NCDC
3c732863-864b-4b34-866f-f40539dce001.xls Page 55 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
ANL_PRECP_ RANGE
ANL_TOT_PRCP Double 10,3 Annual total precipitation. Yes (250 to 4000) NCDC
Table Name : METEOROLOGY_DETAIL
METEOROLOGY DETAIL: Data imported from the National Climate Data Center and reformatted for EGIS.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
MET_DTL_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
Long METEOR
MET_ID Integer 10,0 Key from METEOROLOGY table. No OLOGY NCDC
Code for meteorology type (i.e.,
evaporation, temperature, or
MET_TYPE Text 1 precipitation). No MET_TYPE_CODE NCDC
UNITS Text 2 Units of measurement. Yes MET_UNITS_ CODE NCDC
JANUARY Double 10,3 Monthly mean units in January. Yes NCDC
FEBRUARY Double 10,3 Monthly mean units in February. Yes NCDC
MARCH Double 10,3 Monthly mean units in March. Yes NCDC
APRIL Double 10,3 Monthly mean units in April. Yes NCDC
MAY Double 10,3 Monthly mean units in May. Yes NCDC
JUNE Double 10,3 Monthly mean units in June. Yes NCDC
JULY Double 10,3 Monthly mean units in July. Yes NCDC
AUGUST Double 10,3 Monthly mean units in August. Yes NCDC
SEPTEMBER Double 10,3 Monthly mean units in September. Yes NCDC
OCTOBER Double 10,3 Monthly mean units in October. Yes NCDC
NOVEMBER Double 10,3 Monthly mean units in November. Yes NCDC
DECEMBER Double 10,3 Monthly mean units in December. Yes NCDC
MON_MEAN Double 10,3 Mean Monthly units in the month. No NCDC
3c732863-864b-4b34-866f-f40539dce001.xls Page 56 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
MON_TOTAL Double 10,3 Total units measured in the month. Yes NCDC
YR_MSRD Text 4 Year Measured. No NCDC
Table Name : OSE_DISTRICT
OSE DISTRICT: OSE generated table showing OSE district boundaries.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
OSE_DIST_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
NAME Text 40 District Name. No WRD
WRD /
Short DIST_NBR_ RANGE (0 WATERS
DIST_NBR Integer 5,0 District Number. Yes to 5) (BASIN)
3c732863-864b-4b34-866f-f40539dce001.xls Page 57 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : OWNER
OWNER: OSE generated table providing information about water right owners.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
OWN_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
Long WATERS
OWN_REC_NBR Integer 10,0 Owner record number. Yes (OWN NAME)
WATERS
OWN_FNAME Text 25 Owner's first name. Yes (OWN NAME)
WATERS
OWN_LNAME Text 30 Owner's last name. Yes (OWN NAME)
WATERS
ADDR1 Text 30 Primary owner's address, first line. Yes (OWN NAME)
WATERS
ADDR2 Text 30 Owner's address, second line. Yes (OWN NAME)
WATERS
CITY Text 15 Owner's city. Yes (OWN NAME)
Owner's state two-letter WATERS
STATE Text 2 abbreviation. Yes STATE_CODE NM (OWN NAME)
WATERS
ZIP Text 9 Owner's zip code. Yes (OWN NAME)
3c732863-864b-4b34-866f-f40539dce001.xls Page 58 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
WATERS
CONTACT_LNAME Text 30 Owner's contact last name. Yes (OWN NAME)
WATERS
CONTACT_FNAME Text 25 Owner's contact first name. Yes (OWN NAME)
DATA_SOURCE Text 3 Owner source (EGIS or WAT). No SOURCE_TYPE_CODE WAT WRD
WATERS
OWN_END_DATE Date 8 Change of owner date. Yes (OWN NAME)
Table Name : OWNER_POU
OWNER and PLACE OF USE Relationship table: OSE generated table showing the relationship between OWNER and POUs.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Existing water rights
with no POU location
will be assigned a
Long location coincident
OWN_POU_ID Integer 10,0 Primary key. No Yes System with the POD.
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
Long PLACE_O
POU_ID Integer 10,0 Key from PLACE_OF_USE table. No F_USE Sys Admin
Long
OWN_ID Integer 10,0 Key from OWNER table. No OWNER Sys Admin
3c732863-864b-4b34-866f-f40539dce001.xls Page 59 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : OWNER_WR
OWNER and WATER RIGHT Relationship table: OSE generated table providing the relationship between OWNER and WATER RIGHT.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
OWN_WR_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
Long WATER_
WR_ID Integer 10,0 Key from WATER_RIGHT table. No RIGHT Sys Admin
Long
OWN_ID Integer 10,0 Key from OWNER table. No OWNER Sys Admin
Table Name : POD
POINT OF DIVERSION: OSE generated table.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
POD_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
POD record number as defined in
Long WATERS. Defines individual WATERS
POD_REC_NBR Integer 10,0 PODs within a water right. Yes (POD)
SURFACE
Key from _WATER_
Long SURFACE_WATER_NETWORK NETWOR
SWN_ID Integer 10,0 table. Yes K WRD
DECLARE
Key from D_GROU
Long DECLARED_GROUND_WATER NDWATE
DGWB_ID Integer 10,0 _BASIN table. Yes R_BASIN WRD
3c732863-864b-4b34-866f-f40539dce001.xls Page 60 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
POD basin portion of the POD file WATERS
POD_BASIN Text 3 number. No DGWB_CODE (POD)
The Point of Diversion number.
The first POD number is usually WATERS
POD_NBR Text 5 the same as the water right number. Yes (POD)
POD suffix of Point of Diversion
file number used to represent
supplemental PODs. The first
supplemental number is an "S". All
subsequent supplemental numbers
are derived by adding consecutive
numbers after the "S" (e.g., S1, S2.
S3...Sn). However, this
convention has not been
consistently applied and any
combination of letters, numbers,
and symbols is possible. Common
exceptions are the use of "X"
instead of "S" for domestic PODs,
the use of dashes (-), and the use of
"CLW" for change of location. WATERS Must match
POD_SUFFIX Text 10 This field is defined in WATERS. Yes (POD) WATERS.
WATERS Added to
(POD)/GCDB, improve query
TWS Text 3 Township number and direction. Yes BLM response time.
WATERS Added to
(POD)/GCDB, improve query
RNG Text 3 Range number and direction. Yes BLM response time.
WATERS Added to
(POD)/GCDB, improve query
SEC Text 2 Section number. Yes BLM response time.
3c732863-864b-4b34-866f-f40539dce001.xls Page 61 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
WATERS Must match
PLSS_GRANT Text 30 Land grant name. Yes (POD) WATERS.
WATERS
Approved diversion amount in acre- (TRN_ Must match
APPROVE_DIV Double 10,3 feet per year. Yes QUANTITY) WATERS.
Point of diversion type
POD_TYPE Text 2 (groundwater or surface water). Yes POD_TYPE_CODE WRD
SW_TYPE Text 5 Surface water type (Spring/Stream). Yes SW_TYPE_CODE WRD
Ditch name populated from
WATERS, but may be enhanced WATERS
DITCH_NAME Text 30 outside of WATERS. Yes (POD)
Depth to water at completion of
construction, to the nearest foot as WATERS
DEPTH_WATER Double 6,1 defined in WATERS. Yes (POD)
Total depth of well to the nearest WATERS
DEPTH_WELL Double 6,1 foot as defined in WATERS. Yes (POD)
Elevation of well above NAVD88 ELVTN_FT_ RANGE WATERS
ELEVATION Double 7,2 in feet. Yes (2,800 to 13,200 feet) (POD)
Estimated yield in gallons per WATERS
ESTIMATE_YIELD Double 5,1 minute as defined in WATERS. Yes (POD)
Type of groundwater (e.g., artesian,
shallow, dry, or mixed) as defined GRND_WTR_ WATERS
GRND_WTR_SRC Text 1 in WATERS. Yes SRC_CODE (POD)
Maximum amount of water in acre-
feet per year that can be diverted WATERS
RESTRCT Double 8,3 from POD as defined in WATERS. Yes (POD)
3c732863-864b-4b34-866f-f40539dce001.xls Page 62 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
WATERS
Maximum artesian diversion in acre- (ANNUAL_ Added to
MAX_ARTESIAN_DIV Double 10,3 feet per year. Yes ACCT) accommodate RA.
Short Percent of shallow groundwater as WATERS Added to
PERCENT_SHALLOW Integer 5,0 defined in WATERS. Yes 100 (POD) accommodate RA.
Hydrographic survey tract number WATERS
TRACT_NBR Text 10 as defined in WATERS. Yes (POD)
Sub Type of groundwater (e.g.,
GRND_WTR_SRC_STYP illegal, plugged, not in use) as GRND_WTR_SRC_STY
E Text 2 defined in WATERS. Yes PE_CODE Sys Admin
WATERS Reconciliation Status
(i.e., the degree to which the
mapped POD matches with the WTR_RCL_STAT_COD
WTR_RCL_STAT Text 2 transaction data in WATERS). Yes E WRD
This attribute can be
used to identify
controlling features
(e.g., GCDB) that may
Source of the graphic feature
physically move in the
location and shape. The source is future as more
typically a filing map or accurate data become
SOURCE_MAP Text 3 hydrographic survey. Yes SOURCE_TYPE_ CODE WRD available.
The unique number or name of the
source document for delineating the
feature. This is typically a WATERS
MAP_NBR Text 50 hydrographic survey map number. Yes (POD)
The date that the feature was
mapped or described as shown on
the document used to delineate the
POD (typically, a hydrographic
SOURCE_DATE Date 8 survey, filing map, or GPS survey). Yes WRD
3c732863-864b-4b34-866f-f40539dce001.xls Page 63 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
The scale of the source maps used
to delineate the POU, reported as
the denominator of the ratio scale
Long (e.g., 1:24,000 is reported as
SOURCE_SCALE Integer 6 24000). Yes WRD
Smallest PLSS quarter information
SMALLEST_PLSS_QTR Text 10 available in WATERS. Yes System
Comments related to WATERS
WTR_RCL_COMMENTS Text 255 synchronization. Yes WRD
Date well construction started as WATERS
START_DATE Date 8 defined in WATERS. Yes (POD)
Date completed (well digging
completed, for instance) as defined WATERS
FINISH_DATE Date 8 in WATERS. Yes (POD)
Date plugged (date well is plugged,
for instance) as defined in WATERS
PLUG_DATE Date 8 WATERS. Yes (POD)
Proof of completion of well / works WATERS
PCW_RCV_DATE Date 8 date as defined in WATERS. Yes (POD)
System date as defined in WATERS
SYS_DATE Date 8 WATERS. Yes (POD)
POD horizontal accuracy per
HORZ_ACC Double 17,3 NSSDA in feet. Yes WRD
The source of the accuracy estimate
(e.g., field verified or professional
SOURCE_ACC Text 3 estimate). Yes SOURCE_ACC_ CODE WRD
COMMENTS Text 255 Comments. Yes WRD
3c732863-864b-4b34-866f-f40539dce001.xls Page 64 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : POD_PRIORITY
POD and PRIORITY DATA table: OSE generated table providing relationship between POD and PRIORITY.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
POD_PRIOR_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
POINT_OF
_
Long Key from DIVERSIO
POD_ID Integer 10,0 POINT_OF_DIVERSION table. No N Sys Admin
Long
PRIORITY_ID Integer 10,0 Key from PRIORITY table. No PRIORITY Sys Admin
Long
POD_REC_NBR Integer 10,0 POD_REC_NBR from POD table. No Sys Admin
Long PRIOR_REC_NBR from
PRIOR_REC_NBR Integer 10,0 PRIORITY table. No Sys Admin
Table Name : POU
PLACE OF USE: OSE generated table providing information about the Place of Use (POU).
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
POU_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Place of use record number as
defined in WATERS. Defines
Long individual POUs within a water WATERS
PLA_REC_NBR Integer 10,0 right. Yes (PLACE)
3c732863-864b-4b34-866f-f40539dce001.xls Page 65 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Basin designator of the file WATERS
BASIN Text 3 number. No DGWB_CODE (PLACE)
Number of the Water Right file as WATERS
NBR Text 5 defined in WATERS. Yes (PLACE)
Suffix of the file number as defined
in WATERS. A suffix usually
implies that the associated water
right has been moved or WATERS
SUFFIX Text 5 commingled. Yes (PLACE)
WATERS Added to
(PLACE)/ improve query
PLA_TWS Text 3 Township number and direction. Yes GCDB, BLM time.
WATERS Added to
(PLACE)/ improve query
PLA_RNG Text 3 Range number and direction. Yes GCDB, BLM time.
WATERS Added to
(PLACE)/ improve query
PLA_SEC Text 2 Section number. Yes GCDB, BLM time.
WRD/
Acreage irrigated as recorded by WATERS
ACRES Double 8,3 OSE. Yes (PLACE)
Amount of water in acre-feet per
year allowed to be diverted as WATERS
DIV Double 8,3 defined in WATERS. Yes (PLACE)
Consumptive use in acre-feet per WATERS
CU Double 8,3 year as defined in WATERS. Yes (PLACE)
Source status (e.g., adjudicated, WRD/
licensed, permitted, and not a WATERS
CURR_STATUS Text 3 right). Yes CURR_STATUS_ CODE ADJ (PLACE)
Acres approved for irrigation by
APPROVE_ACRES Double 8,3 OSE. Yes WRD
Other legal description, alternate
description as defined in WATERS Must match
ALT_LOCATION Text 72 WATERS. Yes (PLACE) WATERS.
3c732863-864b-4b34-866f-f40539dce001.xls Page 66 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Note that GRANTS is
also a GCDB
attribute. Consider
Land grant name as defined in WATERS deleting attribute from
PLSS_GRANT Text 30 WATERS. Yes (POD) WATERS.
Consider making this
attribute a Parcel ID in
Hydrographic survey tract number EGIS and/or
TRACT_NBR Text 10 as defined in WATERS. Yes WRD WATERS.
Specific to RA. This
WTR_RIGHT_ TYPE_ issue needs to be
WTR_RIGHT_TYPE Text 2 Type of water right. Yes CODE WRD resolved in WATERS.
Specific to RA. This
Source of Water (e.g., artificial, issue needs to be
WTR_SOURCE Text 30 artesian, supplemental). Yes WTR_SOURCE_ CODE WRD resolved in WATERS.
Subfile number as shown on source
SUB_FILE_NO Text 40 document. Yes WRD
Date of adjudication as shown on
SOURCE_ADJ_DATE Date 8 source document. Yes WRD
The type of source document from
which the graphic feature location
was located (typically, a
hydrographic survey, filing map, or
SOURCE_MAP Text 3 GPS survey). Yes SOURCE_TYPE_ CODE WRD
The unique number or name of the
source document for delineating the
feature. This is typically a
MAP_NBR Text 50 hydrographic survey map number. Yes WRD
The date that the feature was
mapped or described. Typically,
this is the date found on the filing
map, hydrographic survey, or other
SOURCE_DATE Date 8 source. Yes WRD
3c732863-864b-4b34-866f-f40539dce001.xls Page 67 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
The scale of the source maps used
to delineate the POU, reported as
the denominator of the ratio scale
Long (e.g., 1:24,000 is reported as
SOURCE_SCALE Integer 6 24000). Yes WRD
Smallest PLSS quarter information
SMALLEST_PLSS_QTR Text 10 available in WATERS. Yes System
POU horizontal accuracy per
HORZ_ACC Double 17,3 NSSDA in feet. Yes WRD
The source of the accuracy estimate
(e.g., field verified or professional
SOURCE_ACC Text 3 estimate). Yes SOURCE_ACC_ CODE WRD
Ignore for EGIS total acreage
IGNORE_ACREAGE Text 1 calculations (Y/N). Yes BOOLEAN_TYPE WRD
Water Reconciliation Processed PROCESS_STATUS_CO
PROCESS_STATUS Text 1 Status (Y/N). No DE WRD
COMMENTS Text 255 Comments. Yes WRD
3c732863-864b-4b34-866f-f40539dce001.xls Page 68 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : POU_POD
PLACE OF USE and POINT OF DIVERSION Relationship table: OSE generated table providing the relationship between POU and POD.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
POU_POD_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
POINT_OF
_
Long Key from DIVERSIO
POD_ID Integer 10,0 POINT_OF_DIVERSION table. No N Sys Admin
Long PLACE_O
POU_ID Integer 10,0 Key from PLACE_OF_USE table. No F_USE Sys Admin
Long CONVEY
CNVY_ID Integer 10,0 Key from CONVEYANCE table. Yes ANCE Sys Admin
The approved diversion of each Consider adding to
POU_POD_DIV Double 17,3 POD for the related POU. Yes WATERS WATERS.
Table Name : PRIORITY
PRIORITY DATA table: OSE generated table providing priority date information.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
PRIORITY_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
Long Unique priority record number as WATERS
PRIOR_REC_NBR Integer 10,0 defined in WATERS. No (PRIORITY)
Basin designator of the file WATERS
BASIN Text 3 number. No DGWB_CODE (PRIORITY)
Number of the Water Right file as WATERS
NBR Text 50 defined in WATERS. No (PRIORITY)
3c732863-864b-4b34-866f-f40539dce001.xls Page 69 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Suffix of the file number as defined
in WATERS. A suffix usually
implies that the associated water
right has been moved or WATERS
SUFFIX Text 5 commingled. Yes (PRIORITY)
Priority Date available from POD WATERS
PRIORITY_DATE Date 8 record. Yes (PRIORITY)
Water rights status type code for
Adjudicated, Licensed, Permitted, WATERS
STATUS Text 3 or Declared. No CURR_STATUS_CODE (PRIORITY)
Approved diversion amount in acre- WATERS
DIV Double 8,3 feet per year. No (PRIORITY)
Acres irrigated as recorded by OSE WATERS
ACRES Double 8,3 as defined in WATERS. Yes (PRIORITY)
WATERS
USER_ID Text 8 User ID as defined in WATERS. No (PRIORITY)
System date as defined in WATERS
SYSTEM_DATE Date 8 WATERS. No (PRIORITY)
3c732863-864b-4b34-866f-f40539dce001.xls Page 70 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : RAILWAY_TIGER
RAILWAY DLG: Data imported from the USGS, Railroad Information Service. The data is derived from 1:2,000,000 DLGs.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
TLID Integer 10,0 Primary key. No Yes Census
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
FENAME Text 30 The name of the railroad. Yes Census
Type of railroad (i.e., in tunnel or
CFCC Text 3 not). Yes RAILROAD_TYPE Census
The first character of the Census
CFCC1 Text 1 Feature Classification Code.
The first two characters of the No No Census
Census Feature Classification
CFCC2 Text 2 Code. No No Census
Table Name : RESERVATION
RESERVATION: Data imported from the Bureau of Land Management, New Mexico. Digitized from 1:100,000 BLM maps.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
RSRVTN_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Name of the reservation/trust
NAME Text 50 land/community. Yes BLM
3c732863-864b-4b34-866f-f40539dce001.xls Page 71 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Function or purpose of reservation
TYPE Text 2 (e.g., Indian land, park, forest). Yes RESERVATION_ CODE BLM
The managing authority of
reservation lands (e.g., tribe, ADMIN_STATUS_COD
ADMIN_STATUS Text 4 federal, county). Yes E BLM
Was a feature added or modified as
part of a photo revision
PHOTO_CATEGORY Text 1 assignment? (Y/N). Yes BOOLEAN_TYPE BLM
Table Name : ROADS_GPS
GPS ROADS: Temporary data imported from the New Mexico Highway Transportation Department (NMHTD). Reported as GPS data, but recommend display is
1:100,000.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
ROADS_GPS_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Posted route name as provided by
the New Mexico State Highway
and Transportation Department
NAME Text 40 (NMSHTD). Yes EDAC
The alternate name is the secondary
name or the NMSHTD route
designation (i.e., interstate) as
ALT_NAME Text 40 provided by NMSHTD. Yes EDAC
LINEAGE Text 4 Lineage of the feature. LINEAGE_CODE NMHTD
ROAD_SOURCE_
SOURCE Text 4 Source of the feature. CODE NMHTD
3c732863-864b-4b34-866f-f40539dce001.xls Page 72 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : ROADS_TIGER
E911 ROADS: This data set is still under construction. Once completed, this dataset will become the default dataset for the road network. Note that database changes
are still possible as the dataset is developed. Spatial accuracy is not clear.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
ROADS_TIGER_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes No System
Long TIGER/Line Unique Identification
TLID Integer 10 Number. No Yes Census
Long County-based node from which the
FNODE Integer 8 line segment begins. No No Census
Long County-based node where the line
TNODE Integer 8 segment ends. No No Census
Feature direction prefix, like "S" in
FEDIRP Text 2 "S. Main St." Yes DIR_CODE No Census
Feature name, such as the "Main"
FENAME Text 30 in "Main Street". Yes No Census
Feature type, such as the "St" in
FETYPE Text 4 "Main St". Yes ROAD_TYPE_ CODE No Census
Feature direction, such as the "W"
FEDIRS Text 2 in "First St W". Yes DIR_CODE No Census
The Census Feature Classification
CFCC Text 3 Class. No CFCC_CODE No Census
Long The FROM address on the left side
FRADDL Integer 10 of the road. Yes No Census
Long The TO address on the left side of
TOADDL Integer 10 the road. Yes No Census
Long The FROM address on the right
FRADDR Integer 10 side of the road. Yes No Census
Long The TO address on the right side of
TOADDR Integer 10 the road. Yes No Census
3c732863-864b-4b34-866f-f40539dce001.xls Page 73 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
The Zip Code on the left side of the
ZIPL Text 5 road. Yes No Census
The Zip Code on the right side of
ZIPR Text 5 the road. Yes No Census
The first character of the Census
CFCC1 Text 1 Feature Classification Code.
The first two characters of the No No Census
Census Feature Classification
CFCC2 Text 2 Code. No No Census
TIGER_SOURCE_
SOURCE Text 1 Linear Segment Source Code. No CODE No Census
Table Name : SOILS
SOILS: Data imported from the Natural Resource Conservation Services (NRCS) using a mapping scale of 1:12,000 to 1:63,360.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
SOIL_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
SOILTYPE Text 45 Type of soil Yes USDA
3c732863-864b-4b34-866f-f40539dce001.xls Page 74 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : STATE
STATE: Data imported from the Earth Data Analysis Center (EDAC) / Bureau of Census and derived from 1:100,000 DLGs.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
STATE_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
NAME Text 20 State name. No EDAC / CB
STATE_CODE Text 2 State Code. No STATE_CODE Yes EDAC / CB
Table Name : STATELAND
STATELAND: Data imported from the Bureau of Land Management (BLM), New Mexico. Digitized from 1:100,000 BLM maps.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
STATELAND_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
LABEL Text 3 Code of the administering agency. Yes STATELAND_ CODE BLM
3c732863-864b-4b34-866f-f40539dce001.xls Page 75 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : STREAM
STREAM: Data imported from the National Hydrographic Dataset (NHD), USGS, and reformatted for EGIS. Based on 1:100,000 or 1:24,000 DLGs.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
STREAM_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
SURFACE
Key from _WATER_
Long SURFACE_WATER_NETWORK NETWOR
SWN_ID Integer 10,0 table. No Yes K Sys Admin
NAME Text 99 Name of stream feature. No NHD, USGS
Unique Identifier of the transport
RCH_COM_ID Double 11,0 reach and coastline reach. No NHD, USGS
Unique identifier of the NHD water
WB_COM_ID Double 11,0 body. No NHD, USGS
Numeric value that encodes the
type and values for a set of
FCODE Text 5 characteristics for an NHD feature. Yes STREAM_FCODE NHD, USGS
3c732863-864b-4b34-866f-f40539dce001.xls Page 76 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
STREAM_FTYPE_
FTYPE Text 2 Type of NHD waterbody feature. Yes CODE NHD, USGS
Long Length of the NHD feature, in
METERS Integer 10,0 meters. Yes NHD, USGS
Long Added to facilitate
STREAM_LEVEL Integer 5,0 Stream level classification Yes No NHD, USGS query and display.
Source of the graphic feature
location and shape. Usually the
NHD, unless the spatial accuracy
SOURCE_MAP Text 3 has been improved by OSE. Yes SOURCE_TYPE_ CODE NHD NHD, USGS
The source of the accuracy estimate
(e.g., field verified or professional
SOURCE_ACC Text 3 estimate). Yes SOURCE_ACC_ CODE Sys Admin
Stream horizontal accuracy per
HORZ_ACC Double 17,3 NSSDA in feet. Yes Sys Admin
3c732863-864b-4b34-866f-f40539dce001.xls Page 77 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : SUBDIVISION
SUBDIVISION: OSE generated table used to store subdivision review information.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
SUBDIV_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
WATERS
(SUB
SUBDIV_NAME Text 40 Name of sub division. No DIVISION)
WATERS
(SUB
SUBDIV_TYPE Text 1 Subdivision size. Yes SUBDIV_TYPE_ CODE DIVISION)
WATERS
(SUB
OWN_FNAME Text 25 Owner's first name. Yes DIVISION)
WATERS
(SUB
OWN_LNAME Text 30 Owner's last name. No DIVISION)
Date the subdivision review was
received by OSE. If the day and/or
month is not known, the last day of WATERS
the known month or year will be (SUB
DATE_RCV Date 8 entered. Yes DIVISION)
WATERS
(SUB
WR_ESTABLISH Text 1 Water right established (Y/N). Yes BOOLEAN_TYPE N DIVISION)
WATERS
(SUB
SUBDIV_STATUS Text 3 Status. (TBD). Yes DIVISION)
3c732863-864b-4b34-866f-f40539dce001.xls Page 78 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
WATERS
(SUB
MIN_LOT_SIZE Double 7,2 Minimum lot size in acres. Yes DIVISION)
WATERS
(SUB
MAX_LOT_SIZE Double 7,2 Maximum lot size in acres. Yes DIVISION)
WATERS
(SUB
WTR_SUPPLY_COM Text 4 The entity supplying the water. Yes WTR_SUPPLY_ CODE DIVISION)
WATERS
(SUB
SUBDIV_ACRES Double 8,3 Total acres in subdivision. Yes DIVISION)
WATERS
(SUB
PARCELS Double 7,2 Number of parcels in subdivision. Yes DIVISION)
WATERS
(SUB
USE_RESTRICT Double 7,2 Use restriction in subdivision. Yes DIVISION)
Date that the OSE opinion was
offered. If the day and/or month is
not known, the last day of the WATERS
known month or year will be (SUB
DATE_OPINION Date 8 entered. Yes DIVISION)
WATERS
(SUB
WTR_UTIL Text 25 Water utility name. Yes DIVISION)
WATERS
(SUB_
COMMENTS Text 255 Comments. Yes COMM)
3c732863-864b-4b34-866f-f40539dce001.xls Page 79 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : SURFACE_WATER_BASIN
SURFACE WATER BASIN: Data imported from the National Hydrographic Dataset (NHD), USGS, and reformatted for EGIS. Based on 1:100,000 or 1:24,000
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
SWB_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Long Hydrologic Unit Code: 8-digit code
HUC Integer 8,0 defined uniquely for each basin. Yes Yes USGS
Long Hydrologic Region (first 2-digits of
HUC2 Integer 5,0 the HUC). Yes USGS
Long Hydrologic Subregion (first 4-digits
HUC4 Integer 5,0 of the HUC). Yes USGS
Long Accounting Unit (first 6-digits of
HUC6 Integer 6,0 the HUC). Yes USGS
REG_NAME Text 60 Hydrologic Region Name. Yes USGS
SUB_NAME Text 60 Hydrologic Subregion Name. Yes USGS
ACC_NAME Text 60 Accounting Unit Name. Yes USGS
CAT_NAME Long
Text 60 Category Unit Name. Yes USGS
HYDRO_UNIT Integer 10,0 Hydology Unit Yes USGS
3c732863-864b-4b34-866f-f40539dce001.xls Page 80 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : SURFACE_WATER_NETWORK
SURFACE WATER NETWORK: Data imported from the National Hydrographic Dataset (NHD), USGS, and reformatted for EGIS. Based on 1:100,000 or 1:24,000
DLGs.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
SWN_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
Unique Identifier of the NHD
COM_ID Double 11,0 feature of reach. No Yes NHD / USGS Yes
3c732863-864b-4b34-866f-f40539dce001.xls Page 81 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : SURFACE_WATER_POINTS
SURFACE WATER POINTS: Data imported from the National Hydrographic Dataset (NHD), USGS, and reformatted for EGIS. Based on 1:100,000 or 1:24,000
DLGs.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
SWP_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
SURFACE
_
Key from WATER_
Long SURFACE_WATER_NETWORK NETWOR
SWN_ID Integer 10,0 table. No Yes K Sys Admin
NAME Text 99 Text of the point landmark name. Yes NHD
Numeric value that encodes the
type and values for a set of
characteristics for an NHD feature
(e.g., spring/seep[hot],
FCODE Text 5 spring/seep/[sulpher]) No SWP_FCODE NHD
Type of NHD waterbody feature
FTYPE Text 2 (e.g., gauge, spring, well). No SWP_FTYPE_ CODE NHD
Identifier of the point landmark
GNIS_ID Text 8 name. Yes Yes NHD
3c732863-864b-4b34-866f-f40539dce001.xls Page 82 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : USGS_WELL
USGS WELL: Data imported from the National Hydrographic Dataset (NHD), USGS, and reformatted for EGIS. Based on 1:100,000 or 1:24,000 DLGs.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
USGS_WL_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
USGS_WL_NAME Text 40 Text of the point landmark name. Yes NHD, USGS
Link to wells (POD) tracked by
WATERS. The field is null if no
POD_NBR Text 5 known link exists. Yes POD NHD, USGS
Identifier of the point landmark
GNIS_ID Text 8 name. Yes Yes NHD, USGS
Five digit number; the first three
digits encode the feature type and
FCODE Double 11,0 the last two encode values. Yes NHD, USGS
Source of the well's position. In
most cases this will be the USGS
SOURCE_MAP Text 3 quad. No SOURCE_TYPE_ CODE NHD, USGS
The source of the accuracy estimate
(e.g., field verified or professional
SOURCE_ACC Text 3 estimate). Yes SOURCE_ACC_ CODE Sys Admin
USGS well horizontal accuracy per
HORZ_ACC Double 17,3 NSSDA in feet. Yes Sys Admin
3c732863-864b-4b34-866f-f40539dce001.xls Page 83 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name: VEGETATION
VEGETATION: Data imported from Earth Data Analysis Center (EDAC) using data digitized from 1:1,000,000 vegetation maps.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
VEG_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
VEG_NAME Text 30 Name of vegetation category. No EDAC
Numeric code for each vegetation
VEG_CODE Text 3 category. No VEGETATION_ CODE EDAC
Acreage of each vegetation
category as calculated from area
ACRES Double 11,0 attribute. Yes EDAC
Table Name : WATER_BODY
WATER BODY: Data imported from the National Hydrographic Dataset (NHD), USGS, and reformatted for EGIS. Based on 1:100,000 DLGs.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
WB_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
3c732863-864b-4b34-866f-f40539dce001.xls Page 84 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
SURFACE
Key from _WATER_
Long SURFACE_WATER_NETWORK NETWOR
SWN_ID Integer 10,0 table. No Yes K Sys Admin
WB_NAME Text 99 Name of water body. Yes NHD, USGS
Unique Identifier of the water body
RCH_COM_ID Double 11,0 reach. Yes NHD, USGS
GNIS_ID Text 8 GNIS identifier of the waterbody. Yes NHD, USGS
Five digit number; the first three
digits encode the feature type and
FCODE Text 5 the last two encode values. Yes WB_FCODE NHD, USGS
Type of NHD waterbody feature
FTYPE Text 2 (e.g., Estuary, Reservoir, etc.). Yes WB_FTYPE_ CODE NHD, USGS
SQ_KM Double 17,3 Area in square kilometers. Yes NHD, USGS
Height category of the water
surface that is the basis for the
STAGE Text 2 elevation. Yes WB_STAGE_ CODE NHD, USGS
Note: datum will be
Elevation of the waterbody, in changed to NAVD88
ELEV Double 13,3 meters above NGVD29. Yes NHD, USGS in future.
Source of the water body feature
location and shape. In most cases
SOURCE_MAP Text 3 this will be the NHD. Yes SOURCE_TYPE_ CODE NHD NHD, USGS
The source of the accuracy estimate
(e.g., field verified or professional
SOURCE_ACC Text 3 estimate). Yes SOURCE_ACC_ CODE Sys Admin
Waterbody horizontal accuracy per
HORZ_ACC Double 17,3 NSSDA in feet. Yes Sys Admin
3c732863-864b-4b34-866f-f40539dce001.xls Page 85 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : WATER_BODY_REACH
WATER BODY REACH: Data imported from the National Hydrographic Dataset (NHD), USGS, and reformatted for EGIS. Based on 1:100,000 or 1:24,000 DLGs.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
WBR_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Key from SURFACE
Long SURFACE_WATER_NETWORK _WTR_
SWN_ID Integer 10,0 table. No Yes NTWRK Sys Admin
NAME Text 99 Text of the waterbody reach name. Yes NHD, USGS
GNIS identifier of the waterbody
GNIS_ID Text 8 reach name. Yes NHD, USGS
Unique Identifier of the NHD
COM_ID Double 10,0 feature of reach. No Yes NHD, USGS
Numeric code that uniquely
RCH_CODE Text 14 identifies a reach. No Yes NHD, USGS
Area of the waterbody region, in
SQ_KM Double 17,3 square kilometers. Yes NHD, USGS
Date that the RCH_CODE was
assigned. If the day and/or month
is not known, the last day of the
known month or year will be
RCH_DATE Date 8 entered. Yes NHD, USGS
3c732863-864b-4b34-866f-f40539dce001.xls Page 86 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : WATER_PLANNING_REGION
WATER PLANNING REGION: OSE generated table providing information about the water planning regions.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
WPR_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Name of water planning region
NAME Text 40 name. No ISC
STATUS Text 8 Status of regional plan. Yes WPR_STATUS_ CODE ISC
Date that the existing regional plan
was approved by OSE. If the day
and/or month is not known, the last
day of the known month or year
DATE_COMP Date 8 will be entered. Yes ISC
3c732863-864b-4b34-866f-f40539dce001.xls Page 87 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : WATER_RIGHT
WATER RIGHT: OSE generated table that provides water rights information.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
WR_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
Basin designator of the Water
Right file number (a three letter WATERS
BASIN Text 3 code). No DGWB_CODE (SUMMARY)
Number of the Water Right file as WATERS
NBR Text 5 defined in WATERS. No (SUMMARY)
Suffix of the file number as defined
in WATERS. A suffix usually
implies that the associated water
right has been moved or WATERS
SUFFIX Text 5 commingled. Yes (SUMMARY)
Water rights current status type
code for Adjudicated, Licensed, WATERS
CURR_STATUS Text 3 Permitted, or Declared. Yes CURR_STATUS_CODE (SUMMARY)
The primary use of water (e.g., WATERS
USE Text 3 irrigation). Yes USE_CODE (SUMMARY)
Amount of land in acres, allowed
for irrigation as defined in WATERS
TOTAL_ACRES Double 8,3 WATERS. Yes (SUMMARY)
3c732863-864b-4b34-866f-f40539dce001.xls Page 88 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Total consumptive use in acre-feet WATERS
TOTAL_CU Double 10,3 per year as defined in WATERS. Yes (SUMMARY)
Amount of water in acre-feet per
year allowed to be diverted as WATERS
TOTAL_DIV Double 10,3 defined in WATERS. Yes (SUMMARY)
Amount of land in acres, allowed
for irrigation as defined in POU
EGIS_TOTAL_ACRES Double 8,3 table. Yes WRD
WATERS Reconciliation Status
(i.e., the degree to which the
mapped POD matches with the WTR_RCL_STAT_COD
WTR_RCL_STAT Text 2 transaction data in WATERS). Yes E WRD
Comments related to WATERS
WTR_RCL_COMMENTS Text 255 synchronization. Yes WRD
Distance between centroid of
POU_SPATIAL_ WATERS derived POUs and EGIS
VARIANCE Double 10,3 POUs. Yes WRD
Source of Water Right (EGIS or
DATA_SOURCE Text 3 WAT) No SOURCE_TYPE_CODE WAT WRD
Water Right record number as
Long defined in WATERS - Summary WATERS
SUM_REC_NBR Integer 10,0 table. Yes (SUMMARY)
3c732863-864b-4b34-866f-f40539dce001.xls Page 89 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : WEIR
WEIR: Data imported from the National Hydrographic Dataset (NHD), USGS, and reformatted for EGIS. Based on 1:100,000 or 1:24,000 DLGs.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
WEIR_ID Integer 10,0 Primary key. No Yes
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes
SHAPE Geometry Feature geometry. Yes
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes
Key from SURFACE
Long SURFACE_WATER_NETWORK _WTR_
SWN_ID Integer 10,0 table. No Yes NTWRK
NAME Text 40 Name of Weir. Yes NHD, USGS
Table Name : WR_POD
WATER RIGHT and POINT OF DIVERSION Relationship table: OSE generated table providing the relationship between WATER RIGHT and POD.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
WR_POD_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
Long WATER_
WR_ID Integer 10,0 Key from WATER_RIGHT table. No RIGHT Sys Admin
Long
POD_ID Integer 10,0 Key from POD table. No POD Sys Admin
3c732863-864b-4b34-866f-f40539dce001.xls Page 90 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : WR_POU
WATER RIGHT and PLACE OF USE Relationship table: OSE generated table providing the relationship between WATER RIGHT and POU.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
WR_POU_ID Integer
Long 10,0 Primary key. No Yes System
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
Long WATER _
WR_ID Integer
Long 10,0 Key from WATER_RIGHT table. No RIGHT Sys Admin
POU_ID Integer 10,0 Key from POU table. No POU Sys Admin
Table Name : WR_REGULATION
WATER RIGHT REGULATION: OSE generated table providing details about CMA (Critical Management Area) / SCA (Special Condition Area).
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
WREG_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Geologic Unit or units condition
GEOLOGIC_UNIT Text 37 area covers. Yes No Water Rights
Last date condition area was
MODIFIED_DATE Date 8 modified. Yes No Water Rights
Reference document that pertains
DOC_REFERENCE Text 150 to condition area. Yes No Water Rights
EFFECT_DATE Date 8 Date condition area is effective. Yes No Water Rights
Special requirements used in
processing an application for a well
REQUIREMENTS Text 254 permit. Yes No Water Rights
3c732863-864b-4b34-866f-f40539dce001.xls Page 91 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Abbreviation of the OSE District
Office responsible for management
DISTRICT_OFFICE Text 6 of the SCA. Yes DIST_OFFICE_ CODE No Water Rights
Date SCA / CMA came into
CREATED_DATE Date 8 existence. Yes No Water Rights
Jurisdiction responsible for
JURISDICTION Text 50 administering regulatory permit. Yes No Water Rights
Purpose the SCA / CMA was
ESTD_PURPOSE Text 50 established. Yes No Water Rights
Whether or not regulation limits
DOM_WELL_LIMIT Text 1 domestic wells. No BOOLEAN_TYPE No Water Rights
Whether or not regulation limits
WELL_LIMIT Text 1 non-domestic wells. No BOOLEAN_TYPE No Water Rights
SOURCE_DOC Text 36 Source document. No No Water Rights
ACRES Double 10,3 Actual acreage. Yes No Water Rights
Type of regulation or condition
REG_TYPE Text 4 area. No REG_TYPE_CODE No Water Rights
NAME Text 40 Long name of condition area. No No Water Rights
ALT_NAME Text 30 Alternate name of condition area. No No Water Rights
3c732863-864b-4b34-866f-f40539dce001.xls Page 92 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : WETLANDS
WETLANDS: Data imported from the U. S. Fish and Wildlife Service and generalized with no specific spatial accuracy.
Data Valid Values / Default Foreign
Column Name Type
Long Size Brief Description Nulls Code Table Value Unique Key Source Comments
WETLAND_ID Integer
Long 10,0 Primary key. No Yes System
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
SHAPE Geometry Feature geometry. Yes System
Area of feature in internal units
SHAPE_AREA Double 17,3 squared. Yes System
SHAPE_LENGTH Double 17,3 Length of feature in internal units. Yes System
Valid wetland classification code
based on Photo interpretation
Conventions for the National
DOMAIN_NAME Text 40 Wetlands Inventory, March 1990. Yes USFWS
Flag specifying that a polygon is a
IS_WETLAND Text 1 wetland. No BOOLEAN_TYPE Y USFWS
Classification of the wetland based
on Cowardin, L.M., V. Carter, F.
Golet, and E. LaRoe. 1979.
Classification of wetlands and
deepwater habitats of the United
WETLAND_CLS Text 40 States. U.S. Fish Wildlife Service. Yes USFWS
3c732863-864b-4b34-866f-f40539dce001.xls Page 93 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : WTR_RIGHT_STATUS_HIST
WATER RIGHT STATUS HISTORY: OSE generated table providing information about the state of the water right.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
WRSH_ID Integer 10,0 Primary key. No Yes System
Long
WR_ID Integer 10,0 Key from Water Right table. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
Basin designator of the Water
Right file number (a three letter WATER_ WATERS
BASIN Text 3 code). No DGWB_CODE RIGHT (HISTORY)
Number of the Water Right file as WATER_ WATERS
NBR Text 5 defined in WATERS. No RIGHT (HISTORY)
Suffix of the file number as defined
in WATERS. A suffix usually
implies that the associated water
right has been moved or WATER_ WATERS
SUFFIX Text 5 commingled. Yes RIGHT (HISTORY)
Subfile number at the completion
of the adjudication
(BASIN_SECTION_HL +
SUBFILE_TXT +
SUBFILE_HL_SFX) as defined in
SUBFILE Text 24 WRATS. Yes WRATS
Water rights status type code for WATERS Must match
STATUS Text 3 Adjudicated, Licensed, Permitted, Yes CURR_STATUS_ (SUMMARY) WATERS.
WATERS Must match
TRANS_DESC Text 30 Description of the transaction. Yes (HISTORY) WATERS.
WATERS Must match
DOCUMENT_CODE Text 5 Document Code. Yes (HISTORY) WATERS.
Date a water right document was WATERS
FILE_DATE Date 8 filed with OSE. (HISTORY)
3c732863-864b-4b34-866f-f40539dce001.xls Page 94 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
The primary use of water (e.g., WATERS Must match
USE Text 3 irrigation). Yes USE_CODE (HISTORY) WATERS.
Amount of water in acre-feet per
year allowed to be diverted as WATERS Must match
TOTAL_DIV Double 10,3 defined in WATERS. Yes (HISTORY) WATERS.
Total consumptive use in acre-feet WATERS Must match
TOTAL_CU Double 10,3 per year as defined in WATERS. Yes (HISTORY) WATERS.
Amount of land in acres, allowed
for irrigation as defined in WATERS Must match
TOTAL_ACRES Double 8,3 WATERS. Yes (HISTORY) WATERS.
Rate of Diversion of water in acre- WATERS Must match
DIV_RATE Double 8,3 feet. Yes (HISTORY) WATERS.
Date that adjudication action is WATERS Must match
ACTION_DATE Date 8 taken as defined in WATERS. Yes (SUMMARY) WATERS.
Latest Date affidavit of publication
was received as defined in WATERS Must match
DATE_AOP_RCV Date 8 WATERS. Yes (TRN_TITLE) WATERS.
Latest Date license was issued as WATERS Must match
ORDER_DATE Date 8 defined in WATERS. Yes (TRN_TITLE) WATERS.
Latest Date well completed as WATERS Must match
FINISH_DATE Date 9 defined in WATERS. Yes (TRN_TITLE) WATERS.
3c732863-864b-4b34-866f-f40539dce001.xls Page 95 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Table Name : WUC_SURVEY
WUC SURVEY: OSE generated table that provides water use and consumptive use information.
Data Valid Values / Default Foreign
Column Name Type Size Brief Description Nulls Code Table Value Unique Key Source Comments
Long
WUC_SRVY_ID Integer 10,0 Primary key. No Yes System
Long
OBJECTID Integer 10,0 Unique feature identifier. No Yes System
Long PLACE_O
POU_ID Integer 10,0 Key from PLACE_OF_USE table. No F_USE Sys Admin
Water use categories (e.g., Codes derived and
agriculture, domestic, industrial, combined from
CATEGORY Text 2 and mining). No WUC_CODE WRD multiple sources.
Water use sub categories (e.g., Codes derived and
construction, dairies, dewatering, combined from
SUB_CATEGORY Text 5 non-profit). No WUC_SUB_CODE WRD multiple sources.
Ground water component of
Long acreage irrigated with combined
AGWC Integer 10,0 water in acres. Yes WU & C
Long Acreage irrigated with ground
AGWO Integer 10,0 water only in acres. Yes WU & C
Surface water component of
Long acreage irrigated with combined
ASWC Integer 10,0 water in acres. Yes WU & C
Long Acreage irrigated with surface
ASWO Integer 10,0 water only. Yes WU & C
Consumptive irrigation requirement
for acreage irrigated with ground
water in acre-feet per year of water,
CIRGW Double 17,3 per irrigated acre. Yes WU & C
Consumptive irrigation requirement
for acreage irrigated with surface
water in acre-feet per year of water,
CIRSW Double 17,3 per irrigated acre. Yes WU & C
3c732863-864b-4b34-866f-f40539dce001.xls Page 96 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Surface water conveyance loss
from stream or reservoir to farm
Long head gate in acre-feet per year.
CLSW Integer 10,0 CLSW=TPWSW-TFWSW Yes WU & C
Depletion factor, ground water
portion presented as a ratio of total RATIO_RANGE
DFGW Double 4,3 depletion. Yes (0 to 1) WU & C
Depletion factor, surface water
presented as a ratio of total RATIO_RANGE
DFSW Double 4,3 depletion. Yes (0 to 1) WU & C
Depletion, ground water in acre-
DGW Double 17,3 feet per year. Yes WU & C
Off-farm conveyance efficiency
presented as a ratio. See OSE RATIO_RANGE (0 to
EC Double 4,3 TR49 for details. Yes 1) WU & C
On-farm conveyance efficiency
presented as a ratio. See OSE TR RATIO_RANGE (0 to
EF Double 4,3 49 for details. Yes 1) WU & C
Project efficiency presented as a RATIO_RANGE
EJ Double 4,3 ratio. See OSE TR 49 for details. Yes (0 to 1) WU & C
Per capita water use in gallons per
day is computed for Public Water
Short and Self-supplied Domestic water
GPCD Integer 5,0 uses as specified in OSE TR 49. Yes WU & C
Groundwater ratio presented as a RATIO_RANGE
GWR Double 4,3 ratio of the total diversion. Yes (0 to 1) WU & C
Incidental depletion factor, below
farm. A coefficient as described in RATIO_RANGE
IDFBF Double 4,3 OSE TR 49. Yes (0 to 1) WU & C
Incidental depletion factor, canals
and laterals, from stream or
reservoir to farm head gate. A
coefficient as described in OSE TR RATIO_RANGE
IDFCL Double 4,3 49. Yes (0 to 1) WU & C
3c732863-864b-4b34-866f-f40539dce001.xls Page 97 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Sum of incidental depletion factors.
A coefficient as described in OSE RATIO_RANGE
IDFGWC Double 4,3 TR 49. Yes (0 to 1) WU & C
Incidental depletion factor, which
applies to ground water
withdrawals only. A coefficient as RATIO_RANGE
IDFGWO Double 4,3 described in OSE TR 49. Yes (0 to 1) WU & C
Incidental depletion factor, on
farm. A coefficient as described in RATIO_RANGE
IDFOF Double 4,3 OSE TR 49. Yes (0 to 1) WU & C
Sum of incidental depletion factors,
which apply to surface water
withdrawals. A coefficient as RATIO_RANGE
IDFSW Double 4,3 described in OSE TR 49. Yes (0 to 1) WU & C
IRRIG_TYPE Text 1 Type of irrigation system. Yes IRRIG_TYPE_ CODE WU & C
Groundwater withdrawals are
MGW Text 1 measured (Y/N). Yes BOOLEAN_TYPE WU & C
Surface water withdrawals are
MSW Text 1 measured (Y/N). Yes BOOLEAN_TYPE WU & C
Population. This attribute only
applies to Public Water and Self-
Long supplied Domestic water uses as
POP Integer 10,0 specified in OSE TR 49. Yes WU & C
Long Return flow, ground water in acre-
RFGW Integer 10,0 feet per year. Yes WU & C
Long Return flow, surface water in acre-
RFSW Integer 10,0 feet per year. Yes WU & C
Surface water ratio presented as a RATIO_RANGE
SWR Double 4,3 ratio of the total diversion. Yes (0 to 1) WU & C
Long
TAI Integer 10,0 Total acreage irrigated as mapped. Yes WU & C
Total depletion in acre-feet per
TD Double 17,3 year. Yes WU & C
3c732863-864b-4b34-866f-f40539dce001.xls Page 98 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Total farm depletion, ground water Note: this
in acre-feet per year. attribute is not in
Long TFDGW=CIRGW(1+IDFOF)* Table 9 of OSE
TFDGW Integer 10,0 (AGWO+AGWC) Yes TR 49.
Total farm depletion, surface water Note: this
in acre-feet per year. attribute is not in
Long TFDSW=CIRSW(1+IDFOF)* Table 9 of OSE
TFDSW Integer 10,0 (ASWO+ASWC) Yes TR 49.
Total farm withdrawal, surface
water in acre-feet per year.
Long TFWSW=CIRSW(ASWO+ASWC)
TFWSW Integer 10,0 /EF Yes WU & C
Total farm withdrawal, ground Note: this
water in acre-feet per year. attribute is not in
Long TFWGW=CIRGW(AGWO+AGW Table 8 of OSE
TFWGW Integer 10,0 C)/EF Yes WU & C TR 49.
Total project depletion, ground
water in acre-feet per year.
TPDGW=CIRGW(1+IDFGWO)*
Long (AGWO)+CIRGW*(1+IDFGWC)*
TPDGW Integer 10,0 (AGWC) Yes WU & C
Total project depletion, surface
water in acre-feet per year.
Long TPDSW=CIRSW(1+IDFSW)*
TPDSW Integer 10,0 (ASWO+ASWC) Yes WU & C
Total project withdrawal, ground
water in acre-feet per year.
Long TPWGW=TFWGW, assuming the
TPWGW Integer 10,0 source of water is on-farm. Yes WU & C
Total project withdrawal, surface
water in acre-feet per year.
Long TPWSW=TFWSW/EC, where
TPWSW Integer 10,0 EC > 0. Yes WU & C
Long Total return flow in acre-feet per
TRF Integer 10,0 year. Yes WU & C
3c732863-864b-4b34-866f-f40539dce001.xls Page 99 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Total withdrawal in acre-feet per
TW Double 17,3 year. Yes WU & C
Withdrawal, ground water in acre-
WGW Double 17,3 feet per year. Yes WU & C
Withdrawal, surface water in acre-
WSW Double 17,3 feet per year. Yes WU & C
WTC Text 2 Water transfer code. No WTC_CODE WRD
Date that water use and
conservation data was last revised
DATE_REVISED Date 8 for the place of use. Yes WU & C
3c732863-864b-4b34-866f-f40539dce001.xls Page 100 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Data Dictionary Working Copy (Version 7)
Expansion of "Source" field Codes:
BLM Bureau of Land Management USFWS U. S. Fish and Wildlife Service
CB Census Bureau USGS United States Geological Survey
COE Corps of Engineers WATERS Water Admin. and Technical Engineering Records System
EDAC Earth Data Analysis Center WRATS Water Right Adjudication Transaction System
FEMA Federal Emergency Management Agency WRD Water Right Division
FIPS Federal Information Processing Standards WU&C Water Use and Conservation Bureau
GCDB Geographic Coordinate Database
GNIS Geographic Name Information System
HB Hydrology Bureau
HSB Hydrographic Survey Bureau
ISC Interstate Stream Commission
LAP Legal Adjudication Program
NAD27 North American Datum of 1927
NAD83 North American Datum of 1983
NAVD88 North American Vertical Datum of 1988
NCDC National Climatic Data Center
NGS National Geodetic Survey
NGVD29 National Geodetic Vertical Datum of 1929
NHD National Hydrographic Data Set
NID National Inventory of Dams
NMSHTD New Mexico State Highway Transportation
NRCS Natural Resource Conservation Services
NSSDA National Standard for Spatial Data Accuracy
OSE New Mexico Office of the State Engineer
PLSS Public Land Survey System
POD Point of Diversion
POU Place of Use
RIS Railroad Information System
Sys Admin EGIS System Administrator
System Computer System
Topologically Integrated Geographic Encoding and
TIGER Referencing
3c732863-864b-4b34-866f-f40539dce001.xls Page 101 of 142 September 15, 2003
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: ADMIN_STATUS_CODE
Codes for the Managing Authority of reservation lands (e.g.: tribe, federal, county).
Code Value Code Description
CNTY County
FED Federal
NAT Native Corporation
REG Regional
ST State
TRB Tribe/Bia
Code table: AQUIFER_TYPE_CODE
Codes for Boolean Data type valid values.
Code Value Code Description
101 Basin and Range aquifers
102 Rio Grande aquifer system
103 Estancia Basin Aquifer
104 Westwater - Gallup
105 Capitan Reef
107 High Plains aquifer
108 Pecos River Basin alluvial aquifer
301 Colorado Plateaus aquifers
402 Roswell Basin aquifer system
999 Not a Major Aquifer
Code table: BOOLEAN_TYPE
Codes for Boolean Data type valid values.
Code Value Code Description
N No
Y Yes
Code table: BR_DESIGN_CODE
Codes for Bridge Design type.
Code Value Code Description
01 Slab
02 Stringer Multi Beam
03 Girder
04 Tee
05 Box
06 Frame
07 Orthotropic
08 Truss
09 Arch
10 Suspension
11 Stayed
12 Movable
13 Tunnel
14 Culvert
15 Mixed
16 Segmental
17 Channel
3c732863-864b-4b34-866f-f40539dce001.xls Page 102 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: BR_DESIGN_CODE
Codes for Bridge Design type.
Code Value Code Description
18 Other
19 19 - Unknown
22 22 - Unknown
Code table: BR_DIR_CODE
Codes for Lane Direction; only interpreted for INTER STATE.
Code Value Code Description
N North
S South
E East
W West
Code table: BR_MATERIAL_CODE
Codes for Bridge Material type.
Code Value Code Description
1 Concrete Cast in Place
2 Concrete Precasting Panels
3 Open Grating
4 Closed Grating
5 Steel Plate
6 Corrugated Steel
7 Aluminium
8 Timber
9 Other
Code table: CFCC_CODE
Codes for CFCC values.
Code Value Code Description
A11 Interstate highway, unseparated
A12 Interstate highway, unseparated, in tunnel
A13 Interstate highway, unseparated, underpassing
A14 Interstate highway, unseparated, with rail line in center
A15 Interstate highway, separated
A16 Interstate highway, separated, in tunnel
A17 Interstate highway, separated, underpassing
A18 Interstate highway, separated, with rail line in center
A20 Primary road without limited access, U.S. and State highway, major category
used alone when the minor category could not be determined
A21 Primary road without limited access, U.S. and State highways, unseparated
A22 Primary road without limited access, U.S. and State highways, unseparated, in
tunnel
A23 Primary road without limited access, U.S. and State highways, unseparated,
underpassing
A24 Primary road without limited access, U.S. and State highways, unseparated, with
rail line in center
3c732863-864b-4b34-866f-f40539dce001.xls Page 103 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
A25 Primary road without limited access, U.S. and State highways, separated
Code table: CFCC_CODE
Codes for CFCC values.
Code Value Code Description
A26 Primary road without limited access, U.S. and State highways, separated, in
tunnel
A27 Primary road without limited access, U.S. and State highways, separated,
underpassing
A28 Primary road without limited access, U.S. and State highways, separated, with
rail line in center
A31 Secondary and connecting road, State and county highways, unseparated
A33 Secondary and connecting road, State and county highways, unseparated,
underpassing
A35 Secondary and connecting road, State and county highways, separated
A38 Secondary and connecting road, State and county highway, separated, with rail
line in center
A41 Local street, unseparated
A42 Local street, unseparated, in tunnel
A43 Local street, unseparated, underpassing
A44 Local street, unseparated, with rail line in center
A45 Local street, separated
A46 Local street, separated, in tunnel
A47 Local street, separated, underpassing
A48 Local street, separated, with rail line in center
A51 Vehicular trail, 4WD only, unseparated
A52 Vehicular trail, 4WD only, unseparated, in tunnel
A53 Vehicular trail, 4WD only, unseparated, underpassing
Road with characteristic unspecified, major category used alone when the minor
A60 category could not be determined
A61 Cul-de-sac
A62 Traffic circle, roundabout
A63 Access ramp
A64 Service drive on highway
A65 Ferry crossing
Other thoroughfare, major category used alone when the minor category could
A70 not be determined
A71 Walkway or trail for pedestrians
A72 Stairway for pedestrians
A73 Alley, road for service vehicles
A74 Driveway, service, or access road, usually privately owned
B11 Railroad main track
B12 Railroad main track, in tunnel
B13 Railroad main track, underpassing
B21 Railroad spur track
B22 Railroad spur track, in tunnel
B23 Railroad spur track, underpassing
B31 Railroad yard track
B32 Railroad yard track, in tunnel
B33 Railroad yard track, underpassing
3c732863-864b-4b34-866f-f40539dce001.xls Page 104 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
B50 Other rail line
P31 P31 - Unknown
Code table: CFCC_CODE
Codes for CFCC values.
Code Value Code Description
P41 P41 - Unknown
P51 P51 - Unknown
P73 P51 - Unknown
P74 P74 - Unknown
Code table: CNSRV_IRR_CODE
Codes for Conservancy district name.
Code Value Code Description
AHCD Arch Huley Conservation District
CID Carlsbad Irrigation District
EBID Elephant Butte Irrigation District
FSID Fort Sumner Irrigation District
HID Hammond Irrigation District
MRGCD Middle Rio Grande Conservancy District
NIIP Navajo Indian Irrigation Project
PRID Pine River Irrigation District
PVACD Pecos Valley Artesian Conservancy District
PVID Pojoaque Valley Irrigation District
SID Storrie Irrigation District
VCD Vermejo Conservancy District
Code table: CNVY_COND_CODE
Codes for Conveyance Condition.
Code Value Code Description
E Excellent or new
G Good
F Fair
P Poor
U Unuseable
Code table: CNVY_ORDER_CODE
Codes for Conveyance Order.
Code Value Code Description
M Madre
C Contra
D Desaguas
S Sobrantes
Code table: CNVY_MAT_CODE
Codes for Conveyance Material.
Code Value Code Description
C Concrete
E Earth
M Metal
3c732863-864b-4b34-866f-f40539dce001.xls Page 105 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
O Other
W Wood
Code table: CNVY_TYPE_CODE
Codes for Type of Conveyance.
Code Value Code Description
C Canal
DH Ditch
DR Drain
O Other
P Pipe
RI River
Code table: CONVERT_STATUS_CODE
Codes for noting the status of hydrographic survey conversion process.
Code Value Code Description
FM All known filing maps have been digitized.
GR The survey has been geo-rectified
HS All POUs, PODs, and Conveyance features have been digitized
IM The survey has been imaged.
LW The PODs and Water Rights have been linked with WATERS.
QA The quality assurance has been completed by OSE.
Code table: CORE_CODE
Codes indicating the position, type of watertight member and certainty.
Code Value Code Description
A Bituminous Concrete
C Concrete
E Earth
F Upstream Facing
H Homogenous Dam
I Core
K Known
M Metal
P Plastic
X Unknown
Z Estimated
Code table: COUNTY_CODE
Codes for the County that the control point is located.
Code Value Code Description
BE Bernalillo
CA Catron
CH Chaves
CI Cibola
CO Colfax
CU Curry
DA Dona Ana
3c732863-864b-4b34-866f-f40539dce001.xls Page 106 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
DB De Baca
Code table: COUNTY_CODE
Codes for the County that the control point is located.
Code Value Code Description
ED Eddy
GR Grant
GU Guadalupe
HA Harding
HI Hidalgo
LA Los Alamos
LE Lea
LI Lincoln
LU Luna
MK McKinley
MO Mora
OT Otero
QU Quay
RA Rio Arriba
RO Roosevelt
SA Sandoval
SF Santa Fe
SI Sierra
SJ San Juan
SM San Miguel
SO Socorro
TA Taos
TO Torrance
UN Union
VA Valencia
XX Unknown
Code table: CROP_CODE
Crop codes identifying the type of crop irrigated. The crop code uses an OSE-developed table that groups
crops by the botanical and agronomical relationships.
Code Value Code Description
1.00 Plowed (Idle) Ground
104.00 Corn (Grain)
107.00 Sorghum (Grain)
120.00 Spring small Grain
140.00 Winter Small Grain
203.00 Cotton
205.00 Sugar Beets
209.00 Misc. Field Crops
221.00 Christmas Trees
223.00 Nursery Stock
276.00 Dry Beans/Misc. Legumes
281.00 Turfgrass/Lawn (Cool Season)
282.00 Turfgrass/Lawn (Warm Season)
301.00 Alfalfa
3c732863-864b-4b34-866f-f40539dce001.xls Page 107 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
302.00 New Alfalfa
304.00 Hay (all other)
Code table: CROP_CODE
Crop codes identifying the type of crop irrigated. The crop code uses an OSE-developed table that groups
crops by the botanical and agronomical relationships.
Code Value Code Description
306.00 Irrigated Planted Pasture
307.00 Irrigated Native Pasture
308.00 Sudan Grass
309.00 Misc. Pasture Grass
321.00 Corn (Silage)
324.00 Sorghum (Silage)
418.00 Berries
420.00 Misc. Fruit Orchards
481.00 Vineyards
484.00 Melons
557.00 Misc. Herbs and Spices
608.00 Peanuts
609.00 Pecan Orchards
610.00 Pistachio Orchards
718.00 Lettuce
722.00 Onions
727.00 Chile
728.00 Potatoes
739.00 Misc. Vegetables and Garden
801.00 Cattail/Bullrush
802.00 Forested Wetlands
803.00 Salt Cedar
804.00 Shrub Wetlands
805.00 Wet Flats (mud flats with little or no vegetation)
901.00 Dry Farmed
902.00 Fallow
903.00 Not Irrigated
904.00 Out Areas
905.00 Plowed Ground
906.00 Swamp/Seeped Land
Code table: CROP_COLLECT_CODE
Codes for the method used to collect the crop data (e.g.: field survey or unverified reports).
Code Value Code Description
RPTS Unverified Reports
SURV Field Survey
UNK Unknown
Code table: CROP_ORG_CODE
Codes for the organization that conducted or reported the crop inventory.
Code Value Code Description
BIA Bureau of Indian Affairs
BOR U.S. Bureau of Reclamation.
3c732863-864b-4b34-866f-f40539dce001.xls Page 108 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
CO County agriculture extension agent.
CON Contractor working for OSE.
Code table: CROP_ORG_CODE
Codes for the organization that conducted or reported the crop inventory.
Code Value Code Description
DIS District (irrigation, conservancy, or acequia).
DOA U.S. Department of Agriculture
HSB Hydrographic Survey Bureau
ISC Interstate Stream Commission
NAS National Agricultural Statistical Service
NRC National Resources Conservation Service
OTH Other
UNK Unknown
UNM University of New Mexico
WUC Water Use and Conservation
Code table: CROP_TYPE_CODE
Codes for Crop symbol (developed by OSE) identifying the type of crop irrigated. This crop symbol is
typically used to denote the crop types on maps.
Code Value Code Description
A Alfalfa
An New Alfalfa
B Dry Beans/Misc. Legumes
Ber Berries
Cat Cattail/Bullrush
Cg Corn (Grain)
Ch Chile
Co Cotton
Cs Corn (Silage)
Ct Christmas Trees
Dry Dry Farmed
F Fallow
Fc Misc. Field Crops
Fo Misc. Fruit Orchards
Fw Forested Wetlands
Gr Vineyards
H Hay (all other)
Hs Misc. Herbs and Spices
INP Irrigated Native Pasture
IPP Irrigated Planted Pasture
L Lettuce
M Melons
MPG Misc. Pasture Grass
MV Misc. Vegetables and Garden
NI Not Irrigated
NS Nursery Stock
O Onions
Out Out Areas
P Peanuts
Pe Pecan Orchards
3c732863-864b-4b34-866f-f40539dce001.xls Page 109 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
PG Plowed (Idle) Ground
Pi Pistachio Orchards
Code table: CROP_TYPE_CODE
Codes for Crop symbol (developed by OSE) identifying the type of crop irrigated. This crop symbol is
typically used to denote the crop types on maps.
Code Value Code Description
Po Potatoes
S Swamp/Seeped Land
Sb Sugar Beets
Sc Salt Cedar
Sg Sorghum (Grain)
Sgs Sudan Grass
Ss Sorghum (Silage)
SSG Spring Small Grain
Sw Shrub Wetlands
Tc Turfgrass/Lawn (Cool Season)
Tw Turfgrass/Lawn (Warm Season)
Wf Wet Flats (mud flats with little or no vegetation)
WSG Winter Small Grain
Code table: CURR_STATUS_CODE
Codes for the Source status (e.g.: adjudicated, licensed, permitted, and not a right) as defined in WATERS.
Code Value Code Description
ADJ Adjudicated
APP Application
APR Application Being Protested
CAN Cancelled
DCL Declaration
DED Dedicated
DEN Denied
EXP Expired
LIC Licensed
NOI Notice of Intention
NOT Not implies that there is no status (i.e., no right or a violation)
PBU Proof of Beneficial Use
PMT Permit
PRG Purged Conversion Record
REN Renumbered
RET Retired
TRN Transferred
UNK Unknown
WTD Withdrawn
Code table: DAM_TYPE_CODE
Codes for the type of dam (in order of importance).
Code Value Code Description
CB Buttress
CN Concrete
ER Rockfill
3c732863-864b-4b34-866f-f40539dce001.xls Page 110 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
MS Masonry
MV Multi-Arch
3c732863-864b-4b34-866f-f40539dce001.xls Page 111 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: DAM_TYPE_CODE
Codes for the type of dam (in order of importance).
Code Value Code Description
OT Other
PG Gravity
RE Earthen
ST Stone
TC Timber Crib
VA Arch
BL BL - Unknown
Code table: DGWB_CODE
Codes for Declared Ground Water Basin designator of the file number.
Code Value Code Description
A Animas
B Bluewater
C Carlsbad
CC Curry County
CP Capitan
CR Canadian River
E Estancia
FS Fort Sumner
G Gallup
GSF Gila San Francisco
H Hondo
HS Hot Springs Artesian
HU Hueco
J Jal
L Lea County
LA Las Animas Creek
LRG Lower Rio Grande
LV Lordsburg Valley
M Mimbres
MRG Middle Rio Grande
NGR Northern Rio Grande
NH Nutt Hockett
P Portales
PL Playas Valley
PN Penasco
RA Roswell Artesian
RG Rio Grande
S Sandia
SB Salt Basin
SD Surface Declaration
SJ San Juan
SP Surface Permit
SS San Simon
T Tularosa
TU Tucumcari
UP Upper Pecos
3c732863-864b-4b34-866f-f40539dce001.xls Page 112 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: DGWB_CODE
Codes for Declared Ground Water Basin designator of the file number.
Code Value Code Description
VV Virden Valley
Code table: DIR_CODE
Codes used for street directions.
Code Value Code Description
N North
S South
E East
W West
NE Northeast
NW Northwest
SE Southeast
SW Southwest
Code table: DIST_TYPE_CODE
Codes for the type of district.
Code Value Code Description
C Conservancy District
I Irrigation District
UNK Unknown
Code table: DIST_OFFICE_CODE
Codes for district offices.
Code Value Code Description
ABQ Albuquerque Office
AZ Aztec Sub-Office
DMG Deming Office
LC Las Cruces Office
ROS Roswell Office
SF Santa Fe Office
3c732863-864b-4b34-866f-f40539dce001.xls Page 113 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: DOM_STD_MTR_COND_CODE
Codes for Standard Domestic Meter condition requirement for this basin.
Code Value Code Description
MO Monthly metering requirement, being developed
QR Quarterly metering requirement, being developed
YR Yearly metering requirement, being developed
Code table: EAP_CODE
Codes indicating whether the dam has an Emergency Action Plan (EAP) developed by the dam owner. An
EAP is defined as a plan of action to be taken to reduce the potential for property damage and loss of life in
an area affected by a dam failure or large flood.
Code Value Code Description
N No
NR Not required by submitting agency
Y Yes
Code table: FEDLAND_CODE
Codes denoting administering agency.
Code Value Code Description
BLM Bureau of Land Management
BLMA BLM Acquired
BLMW BLM Wilderness
BOR Bureau of Reclamation
DOA Department of Agriculture
FSW Forest Service Wilderness
M Military
NFS National Forest Service
NP National Park
NPW National Park Wilderness
USFW US Fish & Wildlife
USFWW US Fish & Wildlife Wilderness
UNK Unknown
Code table: FOUND_CODE
Codes for the material upon which dam is founded, and certainty.
Code Value Code Description
K Known
R Rock
RS Rock Soil
S Soil
U Unknown
Z Estimated
Code table:GRND_WTR_SRC_CODE
Codes for Type of groundwater (e.g.: artesian, shallow, dry, or mixed) as defined in WATERS.
Code Value Code Description
A Artesian
D Dry
M Mixed
3c732863-864b-4b34-866f-f40539dce001.xls Page 114 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table:GRND_WTR_SRC_CODE
Codes for Type of groundwater (e.g.: artesian, shallow, dry, or mixed) as defined in WATERS.
Code Value Code Description
S Shallow
Code table: GRND_WTR_SRC_STYPE_CODE
Codes for Sub Type of groundwater (e.g.: illegal, plugged, not in use) as defined in WATERS.
Code Value Code Description
I Illegal
P Plugged
NU Not in Use
Code table: GW_MODELS_CODE
Codes for types of groundwater models used by OSE.
Code Value Code Description
1988 ModFlow 1988
1996 ModFlow 1996
2000 ModFlow 2000
OT Other or unknown
Code table: HAZARD_CODE
Codes indicating the potential hazard to the downstream area resulting from failure or misoperation of the
Code Value Code Description
H High
L Low
S Significant
Code table: IRRIG_TYPE_CODE
Codes for Types of Irrigation System.
Code Value Code Description
D Drip
F Flood
S Sprinkler
Code table: LEGAL_STATUS_CODE
Codes for noting the status of hydrographic survey
Code Value Code Description
AD Adjudicated
FL Filed with the court
IS in Inter Se
WP Work in progress
Code table: LINEAGE_CODE
Codes for lineage of the roads data.
Code Value Code Description
GPS GPS collected data
SAT Satellite Imagery
3c732863-864b-4b34-866f-f40539dce001.xls Page 115 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: LINEAGE_CODE
Codes for lineage of the roads data.
Code Value Code Description
RTGR Rectified TIGER collected data
ORTH Orthophoto collected data
OTHR Other
Code table : LNTYPE_CODE
Codes for GCDB RECBND LNTYP field.
Code Value Code Description
0 Township/Range line
1 Section Line
2 Quarter Section Line
3 Lot Line
4 Blank line used to close polygons where there is no survey data
Code table: LU_SUB_TYPE_CODE
Codes for Land use sub type.
Code Value Code Description
11 Residential
12 Commercial and Services
13 Industrial
14 Transportation, Communication, Utilities
15 Industrial and Commercial Complexes
16 Mixed Urban Or Built-Up Land
17 Other Urban Or Built-Up Land
21 Cropland and Pasture
22 Orchards, Groves, Vineyards, Nurseries and Ornamental Horticultural Areas
23 Confined Feeding Operations
24 Other Agricultural Land
31 Herbaceous Rangeland
32 Shrub and Brush Rangeland
33 Mixed Rangeland
41 Deciduous Forest Land
42 Evergreen Forest Land
43 Mixed Forest Land
51 Streams and Canals
52 Lakes
53 Reservoirs
54 Bays and Estuaries
61 Forested Wetland
62 Nonforested Wetland
71 Dry Salt Flats
72 Beaches
73 Sandy Areas Not Beaches
74 Bare Exposed Rock
75 Strip Mines, Quarries, Gravel Pits
76 Transitional Areas
77 77 - Unknown
3c732863-864b-4b34-866f-f40539dce001.xls Page 116 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: LU_SUB_TYPE_CODE
Codes for Land use sub type.
Code Value Code Description
81 Shrub and Brush Tundra
82 Herbaceous Tundra
83 Bare Ground
84 Wet Tundra
85 Mixed Tundra
91 Perennial Snowfields
92 Glaciers
0 0 - Unknown
Code table: LU_TYPE_CODE
Codes for Land use Land cover type.
Code Value Code Description
1 Urban or Built-Up Land
2 Agricultural Land
3 Range Land
4 Forest Land
5 Water
6 Wetland
7 Barren Land
8 Tundra
9 Perennial Snow Or Ice
0 0 - Unknown
Code table: MET_TYPE_CODE
Codes for Meteorology type (i.e., evaporation, humidity, temperature, or precipitation).
Code Value Code Description
E Evaporation
H Humidity
P Precipitation
T Temp
Code table: MET_UNITS_CODE
Codes for Meteorology units.
Code Value Code Description
HI Hundredths of inches
TF Tenths of Degrees F
Code table: NOM_LOC_CODE
Codes for Nominal location.
Code Value Code Description
A NENE
B NWNE
C SWNE
D SENE
E NENW
F NWNW
3c732863-864b-4b34-866f-f40539dce001.xls Page 117 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: NOM_LOC_CODE
Codes for Nominal location.
Code Value Code Description
G SWNW
H SENW
I NESW
J NWSW
K SWSW
L SESW
M NESE
N NWSE
O SWSE
P SESE
Q All 16 Nominal Locations
Code table: OUTLET_GATES_TYPE_CODE
Codes that describe the type of Spillway and Controlled outlet gates.
Code Value Code Description
B Bascule
D Drum
F Flap
L Vertical Lift
N Needle
O Other Controlled
R Roller
S Slide
T Tainter
U Uncontrolled
V Value
X None
Code table: OWN_TYPE_CODE
Codes indicating Owner type.
Code Value Code Description
F Federal
L Local Government
P Private
S State
U Public Utility
Code table: POD_TYPE_CODE
Codes for Point of Diversion type (groundwater or surface water).
Code Value Code Description
GW Ground Water
SW Surface Water
3c732863-864b-4b34-866f-f40539dce001.xls Page 118 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: PROCESS_STATUS_CODE
Codes for POU Process Status.
Code Value Code Description
P Pending
Y Processed
Code table: PROVIDER_CODE
Codes for Abbreviation of the government organization or company name that provided the
Code Value Code Description
AERO Aero-Metrics, Inc.
ASI ASI, Inc.
BHI Bohannan-Huston, Inc.
EA Ebert & Associates
EQS Enerquest Systems
FEMA Federal Emergency Management Agency
HSB Hydrographic Survey Bureau
IKON Space Imaging, Inc.
IRS Indian Remote Sensing Satellite, Indian Department of Space
LAND LANDSAT, NASA
MER Merrick & Company
NMSH New Mexico Highway and Transportation
NMSL New Mexico State Lands
NOAA National Oceanic and Atmospheric Administration
NRCS Natural Resource Conservation Service
PWT Pacific Western Technologies
UNK Unknown
USDA U. S. Department of Agriculture
USFS U. S. Forest Service
USGS U. S. Geological Survey
WSI Weston Solutions, Inc
Code table: PURPOSES_CODE
Codes indicating the purposes for which the reservoir is used.
Code Value Code Description
C Flood Control Management
D Debris Control
F Wild Life Pond
H Hydro Electric
I Irrigation
N Navigation
O Other
P Small Farm Pond
R Recreation
S Water Supply
T Tailings
B B - Unknown
3c732863-864b-4b34-866f-f40539dce001.xls Page 119 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: QTR_SEC_CODE
Codes for Quarter section.
Code Value Code Description
NW NW
NE NE
SW SW
SE SE
Code table: RAILROAD_TYPE
Codes for Type of Railroad (i.e., in tunnel or not).
Code Value Code Description
RR Railroad
RT Railroad in tunnel
Code table: RANGE_DIR_CODE
Codes for Range Direction.
Code Value Code Description
E East
W West
Code table: RANGE_FRAC_CODE
Codes for Range Fractions.
Code Value Code Description
0 Not a Fractional Range
1 1/4 Range
2 1/2 Range
3 3/4 Range
Code table: RANGE_NO_CODE
Codes for PLSS Range Numbers.
Code Value Code Description
001 001
002 002
003 003
004 004
005 005
006 006
007 007
008 008
009 009
010 010
011 011
012 012
013 013
014 014
015 015
016 016
017 017
3c732863-864b-4b34-866f-f40539dce001.xls Page 120 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: RANGE_NO_CODE
Codes for PLSS Range Numbers.
Code Value Code Description
018 018
019 019
020 020
021 021
022 022
023 023
024 024
025 025
026 026
027 027
028 028
029 029
030 030
031 031
032 032
033 033
034 034
035 035
036 036
037 037
038 038
Code table: REG_TYPE_CODE
Codes for Regulation Types.
Code Value Code Description
CMA Critical Management Area
SCA Special Condition Area
Code table: RESERVATION_CODE
Codes for Function or Purpose of Reservation (e.g.: Indian land, park, forest).
Code Value Code Description
FO Forest
GL Grass Land
IL Indian Land
ML Military
PK Park
PR Prison
US Unspecified
WD Wilderness
WL Wildlife
Code table: ROAD_SOURCE_CODE
Codes for source of roads data.
Code Value Code Description
BNCO Bernalillo Co data (GPS data)
CSF City of Santa Fe (Ortho data)
3c732863-864b-4b34-866f-f40539dce001.xls Page 121 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: ROAD_SOURCE_CODE
Codes for source of roads data.
Code Value Code Description
EDAC Earth Data Analysis Center (Original GPS or AGIS data)
GPSP Bad code, should all be EDAC
IIRS Indian IRC-C (5m panchromatic satellite imagery)
NMHD New Mexico State Highway and Transportation Department (New GPS data)
SFCO Santa Fe County (GPS data)
RTGR Bad code for rectified TIGER, should be USCB for US Census Bureau
USCB USCB - Unknown
Code table: ROAD_TYPE_CODE
Codes for FETYPE field.
Code Value Code Description
Aly Alley
Arc Arcade
Ave Avenue
Blvd Boulevard
Br Branch
Byp Bypass
Cir Circle
Ct Court
Ctr Center
Cv Cove
Dr Drive
Expy Expressway
Fwy Freeway
Grd Grade
Hwy Highway
Ln Lane
Loop Loop
Mal Mall
Ovps Overpass
Pass Pass
Path Path
Pky Parkway
Pl Place
Plz Plaza
RMRd Ramp Road
Rd Road
Row Row
Rte Route
Run Run
Spur Spur
Sq Square
St Street
Ter Terrace
Trce Terraces
Trl Trail
Tunl Tunnel
3c732863-864b-4b34-866f-f40539dce001.xls Page 122 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: ROAD_TYPE_CODE
Codes for FETYPE field.
Code Value Code Description
Walk Walk
Way Way
Xing Xing
Code table: ROCK_TYPE_CODE
Codes for Rock_Type field in Aquifer table.
Code Value Code Description
100 Unconsolidated sand and gravel aquifers
300 Sandstone aquifers
400 Carbonate-rock aquifers
999 Unknown
Code table: RTSYS_CODE
Codes for Route System (e.g.: county road or interstate).
Code Value Code Description
BL Business Loop
CO County Road
FL Federal Aid Local
FR Frontage Road
IN Interstate
NM State
US US Routes
Code table: SECTION_NO_CODE
Codes for PLSS Section Numbers.
Code Value Code Description
001 001
002 002
003 003
004 004
005 005
006 006
007 007
008 008
009 009
010 010
011 011
012 012
013 013
014 014
015 015
016 016
017 017
018 018
019 019
3c732863-864b-4b34-866f-f40539dce001.xls Page 123 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: SECTION_NO_CODE
Codes for PLSS Section Numbers.
Code Value Code Description
020 020
021 021
022 022
023 023
024 024
025 025
026 026
027 027
028 028
029 029
030 030
031 031
032 032
033 033
034 034
035 035
036 036
Code table: SERV_ON_CODE
Codes indicating the type of Bridge Service (e.g.: on highway or waterway).
Code Value Code Description
HPD Highway Pedestrian
HRR Highway Railroad
HWY Highway
RR Railroad
WWY Waterway
OVP OVP - Unknown
Code table: SOURCE_ACC_CODE
Codes for the Source of the Accuracy Estimate (e.g.: field verified or professional estimate).
Code Value Code Description
EST Professional Estimate
REP Reported by Group Providing Data
UNK Unknown
VER Field Verified Using NSSDA Methodology
Code table: SOURCE_TYPE_CODE
Codes for the feature (usually DOQQs) that was used to geo-reference maps.
Code Value Code Description
DOQ DOQQ
DRG USGS Quadrangle Or Digital Raster Graphic
FSK Filing Map (Sketch)
FFK Filing Map ("Move from" Sketch)
FSV Filing Map (Surveyed)
FFV Filing Map ("Move from" Survey)
FSL Filing Map (Surveyed Sketch)
3c732863-864b-4b34-866f-f40539dce001.xls Page 124 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: SOURCE_TYPE_CODE
Codes for the feature (usually DOQQs) that was used to geo-reference maps.
Code Value Code Description
FSM Filing Map ("Move from" Surveyed Sketch)
GIS Existing or Previous Version of EGIS
GPS GPS Survey
HYD Hydrographic Survey
INV Inventory Map
LSM Land Surveyor's Map
MAP Irrigation or Conservation District Map
NHD National Hydrographic Data Set
PHO Photogrammetry
PLS Public Land Survey System as Defined by GCDB
PRV Provisional POU
SAT Satellite Imagery
SUB Subdivision Map
WAT Written Description from WATERS
Code table: SPILLWAY_TYPE_CODE
Codes that describe the type of Spillway.
Code Value Code Description
C Controlled
N None
U Uncontrolled
Code table: STATELAND_CODE
Codes of the Administering Agency.
Code Value Code Description
S State of New Mexico
SP State Park
SGF State Department of Game and Fish Wildlife Management Areas
Code table: STATE_CODE
Codes for Owner's State as two-letter abbreviations.
Code Value Code Description
AK Alaska
AL Alabama
AR Arkansas
AZ Arizona
CA California
CO Colorado
CT Connecticut
DC Washington.,D.C
DE Delaware
ES Eastern States
FL Florida
GA Georgia
HI Hawaii
IA Iowa
3c732863-864b-4b34-866f-f40539dce001.xls Page 125 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: STATE_CODE
Codes for Owner's State as two-letter abbreviations.
Code Value Code Description
ID Idaho
IL Illinois
IN Indiana
KS Kansas
KY Kentucky
LA Louisiana
MA Massachusetts
MD Maryland
ME Maine
MI Michigan
MN Minnesota
MO Missouri
MS Mississippi
MT Montana
NC North Carolina
ND North Dakota
NE Nebraska
NH New Hampshire
NJ New Jersey
NM New Mexico
NV Nevada
NY New York
OH Ohio
OK Oklahoma
OR Oregon
PA Pennsylvania
RI Rhode Island
SC South Carolina
SD South Dakota
TN Tennessee
TX Texas
UT Utah
VA Virginia
VT Vermont
WA Washington
WI Wisconsin
WV West Virginia
WY Wyoming
Code table: STREAM_FCODE
Codes for Numeric value that encodes the type and values for a set of characteristics for an NHD feature.
Code Value Code Description
33400 Connector
33600 Canal Ditch
33601 Canal Ditch (Aqueduct)
33602 Canal Ditch (Unspecified)
42800 Pipeline
3c732863-864b-4b34-866f-f40539dce001.xls Page 126 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: STREAM_FCODE
Codes for Numeric value that encodes the type and values for a set of characteristics for an NHD feature.
Code Value Code Description
42801 Pipeline (Aqueduct at Near)
42802 Pipeline (Aqueduct Elevated)
42803 Pipeline (Aqueduct Underground)
42804 Pipeline (Aqueduct Underwater)
42805 Pipeline (General at Near)
42806 Pipeline (General Elevated)
42807 Pipeline (General Underground)
42808 Pipeline (General Underwater)
42809 Pipeline (Penstock at Near)
42810 Pipeline (Penstock Elevated)
42811 Pipeline (Penstock Underground)
42812 Pipeline (Penstock Underwater)
42813 Pipeline (Siphon Unspecified)
46000 Stream River
46001 Stream River (Intermittent Definite)
46002 Stream River Intermittent Indefinite)
46003 Stream River Intermittent Not Applicable)
46004 Stream River (Positional Definite)
46005 Stream River (Positional Indefinite)
46006 Stream River (Positional Not Applicable)
55800 Artificial Path
Code table: STREAM_FTYPE_CODE
Codes for types of NHD waterbody feature.
Code Value Code Description
1 Artificial Path
2 Canal/Ditch (1-Dim)
3 Connector
4 Pipeline
5 Stream/River (1-Dim)
Code table: SUBDIV_TYPE_CODE
Codes of the Subdivision sizes.
Code Value Code Description
1
Subdivisions with more than 499 lots that are less than 10 acres each on average.
2 Subdivisions with 25 to 499 lots that are less than 10 acres each on average.
3 Subdivisions with 2 to 24 lots that are less than 10 acres on average.
4 Subdivisions that have more than 24 lots that are 10 acres or more on average.
5 Subdivisions that have 2 to 24 lots that are 10 acres or more on average.
D A single lot development of any size.
3c732863-864b-4b34-866f-f40539dce001.xls Page 127 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: SURVEY_TYPE
Codes for Survey Type.
Code Value Code Description
A Aliquot Parts
AA Tract - (Other than Cadastral Survey) (Reserved)
AB Sections
B Aliquot Parts less than 40 Acres
C Coal (Reserved)
D Allotment (Reserved)
E Metes and Bounds (Reserved)
F Farm Unit (Reserved)
G Land Grant (Reserved)
H Homestead Entry Survey
I Indian Allotment
J Small Tract and Small Holding Claim (Reserved)
K Block and Lot within a Townsite
L Lot
M Mineral Survey
N Townsite
O Fractional Part of a Section
P Parcel
Q Donation Land Claim
R Private Land (Reserved)
S United States Survey (Reserved)
T Tracts - (Cadastral Surveyed)
U Unsurveyed - Protracted
W Water
X Exchange Survey (Reserved)
Y Townsite Outlot (Reserved)
Z Unsurveyed - Unprotracted (Relictions Samples) (Reserved)
Code table: SW_TYPE_CODE
Codes for Surface Water Type (Spring/Stream).
Code Value Code Description
SPRNG Spring
STRM Stream
Code table: SWP_FCODE
Codes for numeric value that encodes the type and values for a set of characteristics for an NHD feature
(e.g.: spring/seep[hot], spring/seep/[sulpher]).
Code Value Code Description
36600 Fumarole
36700 Gauging Station
36900 Gate
36901 Gate (Dry Dock)
36902 Gate (Flood Gate)
36903 Gate (Lock)
36904 Gate (Tidegate)
3c732863-864b-4b34-866f-f40539dce001.xls Page 128 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: SWP_FCODE
Codes for numeric value that encodes the type and values for a set of characteristics for an NHD feature
(e.g.: spring/seep[hot], spring/seep/[sulpher]).
Code Value Code Description
36905 Gate (Unspecified)
37000 Geyser
39800 Lock Chamber
40900 Mud Pot
43100 Rapids
45800 Spring Seep
45801 Spring Seep (Unspecified)
45802 Spring Seep (Alkaline)
45803 Spring Seep (Hot)
45804 Spring Seep (Sulphur)
48700 Waterfall
48800 Well
48801 Well (Heat)
48802 Well (Flowing)
48803 Well (Alkaline)
48804 Well (Hot)
48805 Well (Sulphur)
48806 Well (Unspecified)
48501 48501 - Unknown
Code table: SWP_FTYPE_CODE
Codes for types of NHD Waterbody feature (e.g.: gauge, spring, well).
Code Value Code Description
1 Fumerole
2 Gauging Station
3 Gate
4 Geyser
5 Lock Chamber
6 Mudpot
7 Rapids
9 Spring/Seep
10 Waterfall
11 Well
12 12 - Unknown
Code table: TOWN_DIR_CODE
Codes for PLSS Township Direction (N or S).
Code Value Code Description
N North
S South
3c732863-864b-4b34-866f-f40539dce001.xls Page 129 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: TOWN_FRAC_CODE
Codes for PLSS Township Fractions.
Code Value Code Description
0 Not a Fractional Tier
1 1/4 Tier
2 1/2 Tier
3 3/4 Tier
Code table: TOWN_NO_CODE
Codes for PLSS Township Numbers.
Code Value Code Description
001 001
002 002
003 003
004 004
005 005
006 006
007 007
008 008
009 009
010 010
011 011
012 012
013 013
014 014
015 015
016 016
017 017
018 018
019 019
020 020
021 021
022 022
023 023
024 024
025 025
026 026
027 027
028 028
029 029
030 030
031 031
032 032
033 033
034 034
3c732863-864b-4b34-866f-f40539dce001.xls Page 130 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: TIGER_SOURCE_CODE
Codes for Tiger Source Field.
Code Value Code Description
A Updated 1980 GBF/DIME-File
B USGS 1:100,000-Scale DLG-3 File
C Other USGS Map
J Pre-1990 Census Updates
K Post-1990 Census Updates (1990-1994)
L Pre-Census 2000 Local Official Updates (1995-Census 2000)
M Pre-Census 2000 field Operations (1995-Census 2000)
N Pre-Census 2000 Office Update Operations (1995-Census 2000)
O Post-Census 2000 (2000-2002)
Code table: TOWNSHIP_CODE
Codes describing Township duplication frequency.
Code Value Code Description
A First Duplicate (Second Occurrence of Same Township)
B Second Duplicate (Third Occurrence of Same Township)
(BLANK) Not a Duplicate Township
Code table: USE_CODE
The primary use of water (e.g., irrigation).
Code Value Code Description
AGR Agriculture other than irrigation
BPW Brine production well
COM Commercial
CON Construction
CPS Cathodic protection well
DAI Dairy operation
DEW Dewatering well
DOM 72-12-1 Domestic one household
EXP Exploration
FCD Flood control
FGP Fish and game propogation
FPO Feed pen operation
HWY Highway construction
IND Industrial
INJ Injection
IRR Irrigation
MDW Community type use - mdwca, private or commercial supplied
MFG Manufacturing
MIL Military - military installations
MIN Mining or milling or oil
MOB Mobile home parks
MON Monitoring well
MPP Meat packing plant
MUL 72-12-1 Multiple domestic households
MUN Municipal - city or county supplied water
NON Non-profit organizational use
3c732863-864b-4b34-866f-f40539dce001.xls Page 131 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: USE_CODE
The primary use of water (e.g., irrigation).
Code Value Code Description
NOT No use of right or pod
NRT No right
OBS Observation
OFM Oil field maintenance
OIL Oil production
POL Pollution control well
POU Poultry and egg operation
PPP Petroleum processing plant
PRO 72-12-1 Prospecting or development of natural resource
PUB 72-12-1 Construction of public works
REC Recreation
SAN 72-12-1 Sanitary in conjunction with a commercial use
SCH School use - public, private, parochial, & universities
SRO Secondary recovery of oil
STK 72-12-1 Livestock watering
STO Storage
SUB Subdivision
UTL Public utility
Code table: VEGETATION_CODE
Numeric code for each Vegetation category.
Code Value Code Description
3 Sand Dunes
12 Lava Beds
36 Alpine Tundra
95 Urban, Farmland or Open Water
117 Great Basin Desert Scrub
120 Subalpine Coniferous Forest
140 Plains-Mesa Sand Scrub
189 Plains-Mesa Grassland
192 Closed Basin Scrub
240 Montane Grassland
288 Chihuahuan Desert Scrub
300 Montane Scrub
354 Montane Coniferous Forest
392 Juniper Savanna (Ecotone)
441 Coniferous and Mixed Woodland
583 Desert Grassland (Ecotone)
Code table: WB_FCODE
Codes for Five digit number; the first three digits encode the feature type and the last two encode values.
Code Value Code Description
36100 Playa
37800 Icemass
37801 Icemass (Alpine Glacier)
37802 Icemass (Continental Ice Shelf)
3c732863-864b-4b34-866f-f40539dce001.xls Page 132 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: WB_FCODE
Codes for Five digit number; the first three digits encode the feature type and the last two encode values.
Code Value Code Description
37803 Icemass (Continental Ice Sheet)
37804 Icemass (Pack Ice)
37805 Icemass (Snowfield)
37806 Icemass (Unspecified)
39000 Lake Pond
39001 Lake Pond (Intermittent Salt)
39002 Lake Pond (Intermittent)
39003 Lake Pond (Perennial Salt)
39004 Lake Pond (Perennial)
43600 Reservoir
43601 Reservoir (Aquaculture Unspecified)
43602 Reservoir (Pool Nonearthen)
43603 Reservoir (Pool Unspecified)
43604 Reservoir (Disposal-Tailings Pond Earthen)
43605 Reservoir (Disposal-Tailings Pond Unspecified)
43606 Reservoir (Disposal-Unspecified)
43607 Reservoir (Evaporator Unspecified)
43608 Reservoir (Swimming Pool Nonearthen)
43609 Reservoir (Treatment Cooling Pond Unspecified)
43610 Reservoir (Treatment Filtration Pond Unspecified)
43611 Reservoir (Treatment Settling Pond Unspecified)
43612 Reservoir (Treatment Sewage Pond Unspecified)
43613 Reservoir (Water Storage Nonearthen Covered Unspecified)
43614 Reservoir (Water Storage Earthen Not Covered Intermittent)
43615 Reservoir (Water Storage Earthen Not Covered Perennial)
43616 Reservoir (Water Storage Nonearthen Not Covered Unspecified)
43617 Reservoir (Water Storage All Unspecified)
43618 Reservoir (Earthen)
43619 Reservoir (Nonearthen)
43620 Reservoir (Unspecified)
43621 Reservoir (All Unspecified Perennial)
44500 Sea Ocean
44501 Sea Ocean (Reef Pool)
44502 Sea Ocean (Unspecified)
46600 Swamp Marsh
48400 Wash
49300 Estuary
53700 Area of Complex Channels
33602 33602 - Unknown
46003 46003 - Unknown
46006 46006 - Unknown
Code table: WB_FTYPE_CODE
Codes describing types of NHD waterbody feature (e.g.: Estuary, Reservoir, etc.).
Code Value Code Description
1 Estuary
2 Ice Mass
3c732863-864b-4b34-866f-f40539dce001.xls Page 133 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: WB_FTYPE_CODE
Codes describing types of NHD waterbody feature (e.g.: Estuary, Reservoir, etc.).
Code Value Code Description
3 Lake/Pond
4 Reservoir
5 Area of Complex Channels
6 Canal/Ditch (2-Dim)
7 Sea/Ocean
8 Swamp/River
9 Playa
10 Wash
Code table: WB_STAGE_CODE
Codes for height category of the water surface that is the basis for the elevation.
Code Value Code Description
1 Average Water Elevation
2 Date of Photography
3 High Water Elevation
4 Normal Pool
5 Spill Way Elevation
Code table: WTR_RIGHT_TYPE_CODE
Codes for Type of Water Right.
Code Value Code Description
B Basic
S Supplemental
BS Basic and Supplemental
Code table: WTR_SOURCE_CODE
Codes for Source of Water (e.g.: artificial, artesian, supplemental).
Code Value Code Description
ARF Artificial
ART Artesian
ATS Artesian Supplemental
SHA Shallow
SHS Shallow Supplemental
SUR Surface
SUS Surface Supplemental
Code table: WPR_STATUS_CODE
Codes for Status of Water Planning Regional plan.
Code Value Code Description
Complete Complete
Planned Planned
Underway Underway
Unknown Unknown
3c732863-864b-4b34-866f-f40539dce001.xls Page 134 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: WTC_CODE
Codes describing types of Water transfer that occurred.
Code Value Code Description
0 No Water Transfer Occurred (No water transfers occurred).
Water Imported Across State, County or River (Water is imported across a state
1
or county line or river basin boundary).
Water Exported Across State, County or River (Water is exported across a state or
2
county line, or river basin boundary).
Water Delivery not Included in Withdrawal (Water delivered to customers (e.g.: a
water utility, commercial and industrial enterprises, or individual residences)
3
outside of the city or village in which the water supplier is based is not included in
the withdrawal shown).
Water Delivery Included in Withdrawal (Water delivered to customers outside of
the city or village in which the water suppler is based is included in the
4
withdrawal shown, and the population reported also reflects the additional
population served).
Water Delivery Without Reasonable Estimate (Water delivered to customers
outside of the city or village in which the water suppler is based is included in the
5 withdrawal shown, but a reasonable estimate of the additional population served
is unavailable or customers served are commercial and industrial enterprises for
which population figures are not relevant).
All Water Distributed From Outside Utility (All of the water distributed in the
6
community is received from another water utility).
Part of Outside Water Distributed Included in Withdrawal (Part of the water
7 distributed in this community is received from another water utility and is
included in the withdrawal shown).
Part of Water Distributed from Outside (Part of the water distributed in this
8
community is received from another water utility).
Water Provided to Seasonal Visitors (Water is provided to seasonal visitors in
addition to the established residential population. The withdrawal shown reflects
9
the total water used; however, the population and per capita use reported are based
on the number of residents who live in the community year-round).
Military Water Supplied to Civilian Users (The military installation experience a
daily influx of civilian workers. The withdrawal shown reflects the total water
10
use; however, the population and per capita use reported are based on the number
of military personnel and their families who live on the installation year-round).
Code table: WTR_RCL_STAT_CODE
Codes for WATERS Reconciliation Status (i.e., the degree to which the mapped POU matches with the
Code Value Code Description
A1 Completely Acceptable Match
Completely Acceptable Attribute Match. PLSS call in WATERS was incorrectly
A2
or not entered
Completely Acceptable Attribute Match. Spatial coincidence based on centroid
A3 variance is not reliable as a single POU is far way from all other POUs and it's
position is correct as per the provided source
3c732863-864b-4b34-866f-f40539dce001.xls Page 135 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: WTR_RCL_STAT_CODE
Codes for WATERS Reconciliation Status (i.e., the degree to which the mapped POU matches with the
Code Value Code Description
Completely Acceptable Attribute Match. Spatial variance of centroids is within 1
A4
mile
B1 Apparently Acceptable Match
Apparently Acceptable Match. PLSS call in WATERS was incorrectly entered or
B2
not entered
Apparently Acceptable Match. Spatial coincidence based on centroid variance is
B3 not reliable as a single POU is far way from all other POUs and it's position is
correct as per the provided source
B4 Apparently Acceptable Match. Spatial variance of centroids is within 1 mile
C1 No Match
D1 Inconsistent Data
F No Match Possible
H Historical
P Pending
Code table: WTR_SUPPLY_CODE
Codes for the Entity Supplying the Water.
Code Value Code Description
1 Individual Domestic Wells
2 Existing Water Utility
3 Shared Wells
4 New Community Water
Code table: WUC_CODE
Codes for Water use categories (e.g.: agriculture, domestic, industrial, and mining).
Code Value Code Description
IR Agriculture
CO Self-Supplied Commercial
DO Self-Supplied Domestic
IN Industrial
MI Mining, Milling, or Oil
PO Power
PS Public Water Supply
RE Reservoir Evaporation
LS Livestock
Code table: WUC_SUB_CODE
Codes for Water use sub categories (e.g.: construction, daries, dewatering, non-profit).
Code Value Code Description
AGR Agriculture other than Irrigation
BPW Brine Production Well
CON Construction
CPS Cathodic Protection Well
DAI Dairies
3c732863-864b-4b34-866f-f40539dce001.xls Page 136 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Code Tables Working Copy (Version 7)
Code table: WUC_SUB_CODE
Codes for Water use sub categories (e.g.: construction, daries, dewatering, non-profit).
Code Value Code Description
DEW Dewatering Well
EXP Exploration
FPO Feed Pen Operation
GP Gas Processing Plants
HWY Highway Construction
INJ Injection
IR Irrigation
MDWCA Mutual Domestic Water Consumers Associations
MFG Manufacturing
MIL Military Installations
MHP Mobile Home Parks
MON Monitoring Well
MUN Municipal-City or County Supplied Water
NON Non-Profit Organization Use
NOT No Use of Right or Pod
NRT No Right
O Other
OBS Observation
OFM Oil Field Maintenance
OIL Oil Production
OR Oil Refineries
OWD Oil and Gas Well Drilling
PIP Oil and Natural Gas Pipelines & Compressor Stations
POL Pollution Control Well
POU Poultry and Egg Operations
PRO Prospecting or Development of Natural Resources
PUB Construction of Public Works
REC Recreation
SAN Sanitary in Conjunction with a Commercial Use
SCH School Use - Public, Private, Parochial, and Universities
SG Sand and Gravel Washing
SP Stock Ponds
SRO Secondary Recovery of Oil
LS Livestock Watering
STO Storage
SUB Subdivision
UTL Public Utility
3c732863-864b-4b34-866f-f40539dce001.xls Page 137 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS)
Valid Values Tables Working Copy (Version 7)
Range Table Min Value Max Value
ANL_EVAP_RANGE 9000 15500
ANL_PRECP_RANGE 250 4000
ANL_TEMP_RANGE 300 800
CONTOUR_RANGE 850 4020
CTYPNT_ELEVATN_RANGE 2790 13190
DATE_RANGE 1/1/1900 1/1/2099
DIST_NBR_RANGE 0 5
EASTING_RANGE 115000 682000
ELLP_HT_RANGE 820 4000
ELVTN_FT_RANGE 2800 13200
ELVTN_M_RANGE 850 4020
GD_HT_M_RANGE -35 -15
LATITUDE_RANGE 31.20 37.1
LONGITUDE_RANGE -190.20 -102.8
NORTHING_RANGE 3471000 4100000
ORTH_HT_M_RANGE 850 4020
RATIO_RANGE 0 1
3c732863-864b-4b34-866f-f40539dce001.xls Page 138 of 142 8/18/2009
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Change Log
Date
Sl No Version Modified Table Name Column Name Action Initiated by
1 Ver 4.0 31-Jan-02 POU curr_status Text(3) Source changed to WRD from WATERS(Place) KS2i
2 Ver 4.0 31-Jan-02 Geodetic_Control Doc_reference Text(255) Field Width changed to 255 from 50. KS2i
3 Ver 4.0 31-Jan-02 Wtr_Right_Status_Hist DATE_AOP_RCV Date(8) Removed KS2i
4 Ver 4.0 31-Jan-02 Wtr_Right_Status_Hist ORDER_DATE Date(8) Removed KS2i
5 Ver 4.0 31-Jan-02 Wtr_Right_Status_Hist FINISH_DATE Date(8) Removed KS2i
6 Ver 4.0 31-Jan-02 Wtr_Right_Status_Hist TRANS_DESC Text(30) Newly added from WATERS(History) table KS2i
7 Ver 4.0 31-Jan-02 Wtr_Right_Status_Hist DOCUMENT_CODE Text(5) Newly added from WATERS(History) table KS2i
8 Ver 4.0 31-Jan-02 Wtr_Right_Status_Hist USE Text(3) Newly added from WATERS(History) table KS2i
9 Ver 4.0 31-Jan-02 Wtr_Right_Status_Hist TOTAL_DIV Double(10,3) Newly added from WATERS(History) table KS2i
10 Ver 4.0 31-Jan-02 Wtr_Right_Status_Hist TOTAL_CU Double(10,3) Newly added from WATERS(History) table KS2i
11 Ver 4.0 31-Jan-02 Wtr_Right_Status_Hist TOTAL_ACRES Double(8,3) Newly added from WATERS(History) table KS2i
12 Ver 4.0 31-Jan-02 Wtr_Right_Status_Hist DIV_RATE Double (8,3) Newly added from WATERS(History) table KS2i
13 Ver 4.0 31-Jan-02 SOURCE_TYPE_CODE FFK (Filing Map ("Move from" Sketch) New code value is added KS2i
14 Ver 4.0 31-Jan-02 SOURCE_TYPE_CODE FFV (Filing Map ("Move from" Survey) New code value is added KS2i
Field Width changed to 30 from 3 to accommodate
15 Ver 4.0 31-Jan-02 POU_FEATURE WTR_SOURCE Text(30) multiple sources, specific to RA. KS2i
16 POU_FEATURE & POU These two table combined KS2i
17 Ver 5.0 04-Nov-02 ACEQUIA_ASSOCIATION ACQA_PREV_NAME Added attribute based on AGIS Report. ANB
18 Ver 5.0 04-Nov-02 ACQA_STATUS Added attribute based on AGIS Report. ANB
19 Ver 5.0 04-Nov-02 ACQA_HISTORIC Added attribute based on AGIS Report. ANB
20 Ver 5.0 04-Nov-02 CONTACT_FNAME Added attribute based on AGIS Report. ANB
21 Ver 5.0 04-Nov-02 CONTACT_LNAME Added attribute based on AGIS Report. ANB
22 Ver 5.0 04-Nov-02 CONTACT_POSITION Added attribute based on AGIS Report. ANB
23 Ver 5.0 04-Nov-02 ADDR1 Added attribute based on AGIS Report. ANB
24 Ver 5.0 04-Nov-02 ADDR2 Added attribute based on AGIS Report. ANB
25 Ver 5.0 04-Nov-02 CITY Added attribute based on AGIS Report. ANB
26 Ver 5.0 04-Nov-02 STATE Added attribute based on AGIS Report. ANB
27 Ver 5.0 04-Nov-02 ZIP Added attribute based on AGIS Report. ANB
28 Ver 5.0 04-Nov-02 MEMBERS Added attribute based on AGIS Report. ANB
29 Ver 5.0 04-Nov-02 DATE_INACTIVE Added attribute based on AGIS Report. ANB
30 Ver 5.0 04-Nov-02 DATE_NAME Added attribute based on AGIS Report. ANB
31 Ver 5.0 04-Nov-02 CONVEYANCE CNVY_KEY Added attribute based on AGIS Report. ANB
32 Ver 5.0 04-Nov-02 CNVY_CONDITION Added attribute based on AGIS Report. ANB
33 Ver 5.0 04-Nov-02 CNVY_GRADE Added attribute based on AGIS Report. ANB
34 Ver 5.0 04-Nov-02 CNVY_HISTORIC Added attribute based on AGIS Report. ANB
35 Ver 5.0 04-Nov-02 CONVY_ORDER Added attribute based on AGIS Report. ANB
36 Ver 5.0 04-Nov-02 CONVY_STATUS Added attribute based on AGIS Report. ANB
37 Ver 5.0 04-Nov-02 GCDB_LINE Table deleted - see replacement tables. ANB
38 Ver 5.0 04-Nov-02 GCDB_POINT Table deleted - see replacement tables. ANB
39 Ver 5.0 04-Nov-02 GCDB_POLYGON Table deleted - see replacement tables. ANB
40 Ver 5.0 04-Nov-02 GCDB_QTR Table deleted - see replacement tables. ANB
41 Ver 5.0 04-Nov-02 GCDB_SECT Table deleted - see replacement tables. ANB
42 Ver 5.0 04-Nov-02 GCDB_TWP Table deleted - see replacement tables. ANB
43 Ver 5.0 01-Nov-02 GCDB_COORDS These changes were made to conform to changes by ANB
BLM. In addition, the 'Land Grants' have been
incorporated into these tables. Note that the addition
of Land Grants is not part of the BLM supplied data. November 1, 2002
3c732863-864b-4b34-866f-f40539dce001.xls Page 139 of 142
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Change Log
Date
Sl No Version Modified Table Name Column Name Action Initiated by
These changes were made to conform to changes by
44 Ver 5.0 01-Nov-02 GCDB_FIRST ANB
BLM. In addition, the 'Land Grants' have been
45 Ver 5.0 01-Nov-02 GCDB_LADESC ANB
incorporated into these tables. Note that the addition
46 Ver 5.0 01-Nov-02 GCDB_RECBND ANB
of Land Grants is not part of the BLM supplied data.
47 Ver 5.0 01-Nov-02 GCDB_TWNSHP ANB
Propose deleting since the meter tables would have to
48 Ver 5.0 01-Nov-02 POD MTR_AMT be copied from WATERS. ANB
Propose deleting since the meter tables would have to
49 Ver 5.0 01-Nov-02 POD YTD_MTR_AMT be copied from WATERS. ANB
50 Ver 5.0 01-Nov-02 STREAM STREAM_LEVEL Attribute added to aid in query and display. ANB
51 Ver 5.0 01-Nov-02 CNVY_COND_CODE Codes added based on AGIS Report. ANB
52 Ver 5.0 01-Nov-02 CNVY_ORDER_CODE ANB
53 Ver 5.0 01-Nov-02 CROP_CODE 800 series added to account for phreatophytes. ANB
New codes added to correspond with new 800 series
54 Ver 5.0 01-Nov-02 CROP_TYPE_CODE (phreatophytes) crops. ANB
Code table deleted since it is redundant with
55 Ver 5.0 01-Nov-02 DATA_SOURCE_CODE SOURCE_TYPE_CODE. ANB
56 Ver 5.0 01-Nov-02 LNTYPE_CODE Codes added to support new GCDB tables. ANB
57 Ver 5.0 01-Nov-02 RANGE_NO_CODE Codes added to support new GCDB tables. ANB
58 Ver 5.0 01-Nov-02 TOWN_DIR_CODE Codes added to support new GCDB tables. ANB
59 Ver 5.0 01-Nov-02 TOWN_FRAC_CODE Codes added to support new GCDB tables. ANB
60 Ver 5.0 01-Nov-02 TOWN_RNG_CODE Codes added to support new GCDB tables. ANB
61 Ver 5.0 07-Nov-02 PRIORITY_SOURCE_CODE Code table deleted since it is not used in this version. KS2i
Field length increased from 10 to 75 based on Aquifer
62 Ver 5.0 07-Nov-02 AQUIFER AQUIFER shape file data. KS2i
63 Ver 5.0 07-Nov-02 GCDB_COORDS GCDB_COORDS_ID Primary key field added. KS2i
64 Ver 5.0 07-Nov-02 GCDB_FIRST GCDB_FIRST_ID Primary key field added. KS2i
65 Ver 5.0 07-Nov-02 GCDB_LADESC GCDB_LADESC_ID Primary key field added. KS2i
66 Ver 5.0 07-Nov-02 GCDB_RECBND GCDB_RB_ID Primary key field added. KS2i
67 Ver 5.0 07-Nov-02 GCDB_TWNSHP GCDB_TWP_ID Primary key field added. KS2i
Field length increased from 30 to 75 based on EGIS
68 Ver 5.0 07-Nov-02 HYDRO_SURVEY_BOUNDARY SURV_MAP data conversion experience. KS2i
Coded table changed to SOURCE_TYPE_CODE and
69 Ver 5.0 07-Nov-02 OWNER DATA_SOURCE field length changed to 3. KS2i
Coded table changed to SOURCE_TYPE_CODE and
70 Ver 5.0 07-Nov-02 WATER_RIGHT DATA_SOURCE field length changed to 3. KS2i
Field length increased from 4 to 10 based on EGIS
71 Ver 5.0 07-Nov-02 POD TRACT_NO data conversion experience. KS2i
Field length increased from 4 to 10 based on EGIS
72 Ver 5.0 07-Nov-02 POU TRACT_NO data conversion experience. KS2i
309.00 (Misc. Pasture Grass) is new code added based
73 Ver 5.0 07-Nov-02 CROP_CODE on MRG crop layer conversion issue resolution. KS2i
3c732863-864b-4b34-866f-f40539dce001.xls Page 140 of 142 November 1, 2002
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Change Log
Date
Sl No Version Modified Table Name Column Name Action Initiated by
MPG (Misc. Pasture Grass) is new code added based
74 Ver 5.0 07-Nov-02 CROP_TYPE_CODE on MRG crop layer conversion issue resolution. KS2i
Code table name changed from TOWN_RNG_CODE
to TOWN_NO_CODE based on its reference in EGIS
75 Ver 5.0 07-Nov-02 TOWN_NO_CODE Data Dictionary. KS2i
76 Ver 5.0 18-Nov-02 GCDB_LADESC Field added for WATERS Synchronization
TOWN application. KS2i
Field added for WATERS Synchronization
TWNDIR application. KS2i
Field added for WATERS Synchronization
RANGE application. KS2i
Field added for WATERS Synchronization
RNGDIR application. KS2i
Field added for WATERS Synchronization
SECTN application. KS2i
Field length increased from 1 to 2 based on
SURSYS SURVEY_TYPE code table entries. KS2i
Field length increased from 2 to 4 based on source
HUC4 data information. KS2i
Field length increased from 2 to 6 based on source
77 Ver 5.0 18-Nov-02 SURFACE_WATER_BASIN HUC6 data information. KS2i
78 SDE is reading this field as "Bridge.len" hance
Ver 5.0 22-Nov-02 BRIDGE LEN changed to "BR_LEN" KS2i
79 Changed field length from 1 to 2 for accommodating
the Roswell WATERS Synchonzation reclassification
Ver 5.0 22-Nov-02 POD WTR_RCL_STAT codes. KS2i
80 Changed field length from 1 to 2 to accommodate the
Roswell WATERS Synchonzation reclassification
Ver 5.0 22-Nov-02 WATER_RIGHT WTR_RCL_STAT codes. KS2i
81 Ver 5.0 22-Nov-02 TOWN_NO_CODE Added 001 to 025 codes based on source data. KS2i
82 Ver 5.0 22-Nov-02 RANGE_NO_CODE Added 001 to 020 codes based on source data. KS2i
83
Ver 5.0 09-Dec-02 AERIAL_PHOTO_PRINTS_IMAGE PHOTO_NAME Renamed this field from NAME to PHOTO_NAME KS2i
84
Ver 5.0 09-Dec-02 ALL IMAGE TABLES NAME and IMAGE These two columns added to all raster business tables. KS2i
Added two codes values 19 and 20 with description as
BR_DESIGN_CODE 'Unknown'. KS2i
Added code value "OVP" with description as
85 Ver 5.0 09-Dec-02 BRIDGE SERV_ON_CODE. "Unknown". KS2i
86 Ver 5.0 09-Dec-02 CITY_ BOUNDARY Table design changed KS2i
87 Ver 5.0 09-Dec-02 CITY_POINTS Table design changed KS2i
88 Ver 5.0 09-Dec-02 CNSRV_IRR_DIST_MAP_BOUNDARY Added new table. KS2i
89 Ver 5.0 09-Dec-02 COUNTY COUNTY_NAME/COUNTY_CODE Removed unique constraint for these fields. KS2i
3c732863-864b-4b34-866f-f40539dce001.xls Page 141 of 142 November 1, 2002
New Mexico Office of the State Engineer / Interstate Stream Commission (OSE/ISC)
Enterprisewide Geographic Information System (E-GIS) Change Log
Date
Sl No Version Modified Table Name Column Name Action Initiated by
Ver 5.0 09-Dec-02 DAM_TYPE_CODE Added code "BL" with description as "Unknown". KS2i
Removed AllowNulls constraint for these two
Ver 5.0 09-Dec-02 RIVER/COUNTY columns. KS2i
90 Ver 5.0 09-Dec-02 DAM PURPOSES_CODE Added code "B" with description as "Unknown". KS2i
Ver 5.0 09-Dec-02 IS_SUB_BASIN New collumn added. KS2i
91 Ver 5.0 09-Dec-02 DECLARED_GROUND_WATER_BASIN BASIN_DESC Removed code table DGWB_CODE. KS2i
92 Ver 5.0 09-Dec-02 FEDLAND NAME Removed AllowNulls constraint. KS2i
93 Ver 5.0 09-Dec-02 GCDB_COORDS LNDKEY Removed AllowNulls constraint. KS2i
94 Ver 5.0 09-Dec-02 GCDB_FIRST LNDKEY Removed AllowNulls constraint. KS2i
95 Ver 5.0 09-Dec-02 GCDB_LADESC LNDKEY Removed AllowNulls constraint. KS2i
96 Ver 5.0 09-Dec-02 GCDB_RECBND LNDKEY Removed AllowNulls constraint. KS2i
97 Ver 5.0 09-Dec-02 GCDB_TWNSHP LNDKEY Removed AllowNulls constraint. KS2i
98 Ver 5.0 09-Dec-02 HIST_HYDRO_SURVEY_BOUNDARY New table added. KS2i
99 Ver 5.0 09-Dec-02 GW_MODLES GW_DATE Removed AllowNulls constraint. KS2i
100 Ver 5.0 09-Dec-02 POU NBR Removed AllowNulls constraint. KS2i
101 Ver 5.0 09-Dec-02 PRIORITY PRIORITY_DATE Removed AllowNulls constraint. KS2i
102 Ver 5.0 09-Dec-02 RAILWAY_TIGER FENAME Removed AllowNulls constraint. KS2i
103 Ver 5.0 09-Dec-02 RESERVATION NAME Removed AllowNulls constraint. KS2i
104 Ver 5.0 09-Dec-02 ROADS_GPS NAME Removed AllowNulls constraint. KS2i
105 Ver 5.0 09-Dec-02 SURFACE_WATER_BASIN HYDRO_UNIT Added this collumn based on latest data. KS2i
106 Ver 5.0 17-Dec-02 GW_MODELS STATUS_FLAG Removed default value "Y" KS2i
107 Ver 5.0 17-Dec-02 WATER_RIGHT/POD WTR_RCL_STAT Reclassification status codes added. KS2i
Added new code "USCB" with description as
108 Ver 5.0 17-Dec-02 ROADS_GPS SOURCE "Unknown" to ROAD_SOURCE_CODE table. KS2i
Added all codes from WATERS database status table
109 Ver 5.0 23-Dec-02 WATER_RIGHT/POU CURR_STATUS to CURR_STATUS_CODE table. KS2i
Code table deleted because CURR_STATUS_CODE
110 Ver 5.0 23-Dec-02 WATER_RIGHT/WTR_RIGHT_STATUS_HIST WRS_STATUS_TYPE_CODE table has all values. KS2i
3c732863-864b-4b34-866f-f40539dce001.xls Page 142 of 142 November 1, 2002