The Minnesota County Well Index
Database Dictionary

Home   |   Table Relationships   |   Data Tables   |   Code Tables   |   Views


Table: C5AD
The C5AD table contains the address for the well address. The contact and orowner's address can also be added. Historical well address are designated where the city has renumbered or changed street name. Currently data entry staff will only enter the well address from the Well and Boring Record filed with the Minnesota Department of Health.

 

Column Name

Type

Length

Precision

Scale

Null

Default

Code Table

Data Range

Description

C5AD_SEQ_NO

NUMBER

12

0

0

N

 

 

Primary Key

RELATEID

CHAR

10

 

 

N

 

 

Contains the Minnesota Unique Well Number

NAME

VARCHAR2

40

 

 

Y

 

 

Name for the address.  If it is well address, this is the same as WELLNAME.

ADDTYPE_C

CHAR

1

 

 

Y

 

ADDR_TYP

Indicates if the address is for the well, owner, contact

HOUSE_NO

CHAR

6

 

 

Y

 

 

House number

STREET

VARCHAR2

20

 

 

Y

 

 

Street name.

ROAD_TYPE

CHAR

2

 

 

Y

 

ROADTYPE

Code indicating the type of road (street, avenue, boulevard, etc.).

ROAD_DIR

CHAR

2

 

 

Y

 

MAP_DIR

Indicates the road specified in the address has a following direction indicator.

CITY

VARCHAR2

20

 

 

Y

 

MNCITY

The city/town/village name as used in the mailing address.

STATE

CHAR

2

 

 

Y

 

USSTATE

The state name for the address.

ZIPCODE

CHAR

10

 

 

Y

 

 

The zip code.

ENTRY_DATE

NUMBER

8

0

0

Y

 

 

Date the information was added.

UPDT_DATE

NUMBER

8

0

0

Y

 

 

Date the information was revised.

OTHER

VARCHAR2

20

 

 

Y

 

 

Additional address information such as PO box, apartment nummber,...
WELLID NUMBER 10 0 0 N   The Minnesota Unique Well Number and Foreign Key
OBJECTID NUMBER 38 0 0 N   ArcSDE An ObjectID is a unique, not null integer field used to uniquely identify rows in tables in a geodatabase


Home   |   Table Relationships   |   Data Tables   |   Code Tables   |   Views