Medina County Engineer

MetaData on Databases, Coverages, & INFO Tables.

II..ArcStorm database County - Library County - Layer Parcel - Polygon items. Notes: Standard Arc/INFO & ArcStorm items are Not defined here. All items apply to the entire parcel unless noted.

A..TDN - The tax district number. Three digits. (See enclosed chart)

B..BKN - The book number. Two digits and one letter. (See enclosed chart)

C..PGN - The page number. Two digits.

D..SPN - The sequential parcel number. Three digits.

E..PPN_MODIFIER - The possible modifier letter. One letter.

1..E - PARTIALLY Tax exempt parcel.

2..T - Temporary parcel number.

3..C - New construction on an exempt parcel.

F..STAR - Overlap, undershoot, or other conflict with neighboring parcel(s). Six digits.

1..0 - Not starred.

2..1 - Starred but no description entered in computer yet.

3..> 1 - Starred and description is in computer.

G..SUBDV_LOT# - Sublot number, ie. allotments, additions, subdivisions, plats, replats, or any lot tied to a name. Six characters.

H..CITY_LOT# - City lot number. Five characters.

I..VILLAGE_LOT# - Village lot number. Five characters.

J..DEED_ACRE - Acreage of parcel or portion of parcel as specified within the deed. Fourteen digits with six digits after the decimal point.

K..LOT_FLG - Modifier for special labeling of lot/sublot. One digit.

1..1 - Block..

2..2 - Outlot.

3..3 - Vacated.

4..4 - Sublot.

5..5 - Parcel.

6..6 - Acre.

L..SUBDV_NAME - Subdivision, allotment, or etc. name. Seventy characters.

M..R_O_W - Indicator of whether or not the particular polygon is within a right-of- way. Single digit.

1..0 - Not within r-o-w.

2..1 - Within road r-o-w.

3..2 - Within railroad r-o-w.

N..TRANS_DATE1 - Newest recorded transfer date. Eight digit date.

O..TRANS_DATE2 - Second newest recorded transfer date. Eight digit date.

P..ADDRESS - Road name the parcel is addressed to. Fifty characters. Prefix, road name, & type.

Q..FIRST# - First number given to the road. Six characters.

R..SECOND# - Second number given to the road. Six characters.

S..LAKE - Possible lake name of polygon. Thirty characters.

T..RIVER - Possible river name of polygon. Thirty characters.

III..ArcStorm database County - Library County - Layer Parcel - Polygon redefined items.

A..PPN+ - Complete parcel number. Twelve characters.

B..LOCATION - General location of parcel determined from BKN without the character. Two digits.

C..PPN - Parcel number without modifier. Eleven characters.

IV..ArcStorm database County - Library County - Layer Parcel - Arc items. Notes: Standard Arc/INFO, COGO, & ArcStorm items are Not defined here. All items apply to individual arcs unless noted.

A..FTR_CODE - Used to determine the type of arc and the symbol for which to draw it with. Three digits. (See enclosed chart)

B..CURVE - Used to determine if the arc is a curve for arcs which have not been COGO'ed yet. One digit.

C..RD_NAME - Road name if arc is the centerline of a road. Fifty characters.

D..LOW_E - Lowest even house number if arc is a centerline. Five digits.

E..HI_E - Highest even house number if arc is a centerline. Five digits.

F..LOW_O - Lowest odd house number if arc is a centerline. Five digits.

G..HI_O - Highest odd house number if arc is a centerline. Five digits.

V..ArcStorm database County - Library County - Layer Parcel - Annotation.Lotdim items. Note: Standard Arc/INFO & ArcStorm items are Not defined here.

VI..ArcStorm database County - Library County - Layer House - Point items. Notes: Standard Arc/INFO & ArcStorm items are Not defined here. All items apply to individual house numbers.

A..ADD_# - The numeric part of the house number. Eight digits with two after the decimal point.

B..ADD_LETT - Any portion of the house number after the initial numeric portion. Five characters.

C..ADDRESS - The road name that the house is numbered on. Fifty characters.

D..PRINT - Used after checkout or during issuing to determine which addresses to print. Single digit.

VII..ArcStorm database County - Library County - Layer House - Point redefined items.

A..ADD_CODE - The complete house number. Thirteen characters.

VIII..ArcStorm database County - Infotable Owner - INFO items. Notes: Standard ArcStorm items are Not defined here. All items apply to individual owners unless stated otherwise.

A..PPN+ - The complete parcel number. Twelve characters.

B..F_NAME - The owner(s) first name & middle initial. Eighty characters.

C..L_NAME - The owner last name or complete company name. Eighty characters.

D..OWNER_TRUST - Used to determine whether the owner is listed as a trustee. Single digit.

1..0 - Not trustee.

2..1 - Trustee.

3..2 - Co-Trustee.

E..OWNER_PERC - Percentage of interest that the owner has in the parcel. Six digits with two after the decimal point.

1..999 - Mineral rights.

2..888 - Life Estate.

3..777 - Estate in Entirety.

4..555 - Torrenized land.

5..444 - 99-year lease.

F..OLD_OWNER - Used after checkout to track the original owner of the land before a transfer was done. Five digits.

IX..ArcStorm database County - Infotable Owner - INFO redefined items.

A..PPN - Parcel number without modifier. Eleven characters.

B..OWNER - Complete owner name plus percentage and trusteeship. One hundred & sixty seven characters.

X..Coverages BKN<##> - Polygon items. Note: Standard Arc/INFO items are Not defined here.

A..BKN - Book number. (See enclosed chart)

B..PGN - Page number.

XI..Coverages BKN<##> - Polygon redefined items.

A..BKPG - Complete book & page number.

XII..Coverage Tract - Polygon items. Notes: Standard Arc/INFO items are Not defined here. All items apply to individual township subdivided portions unless noted otherwise.

A..TRACT_NAME - Possible tract name. Twenty Characters.

B..TRACT_NUM - Possible tract number. Three digits.

C..LARGE_LOT - Possible large lot number. Three digits.

D..LOT - Possible lot number. Three digits.

E..SECTION_MOD - Possible section directional modifier. Four characters.

F..SECTION# - Possible section number. Three digits.

G..LOC_CALLED - Name of location used to determine whether the portion is tracked by Lot/Tract or not.

XIII..Coverage Tract - Polygon redefined items.

A..SECTION - Complete possible section information. Seven characters.

B..TRACT - Complete possible tract information. Twenty three characters.

C..TRCTLOT - Tract, large lot, lot, & section information concatenated. Thirty six characters.

XIV..Infotable Sch_dist - INFO items. Note: All records apply to individual tax districts unless noted.

A..TDN - Tax district number. Three digits. (See enclosed chart)

B..SCHOOL_D - School district name. Thirty characters.

C..LOC_NAME - Township, village, or city name. Thirty characters.

D..LOC_# - Location number of area. Two digits.

E..XMIN - Minimum easting for area. Seven digits.

F..YMIN - Minimum northing for area. Six digits.

G..XMAX - Maximum easting for area. Seven digits.

H..YMAX - Maximum northing for area. Six digits.

I..LOC_CALLED - Name of location used to determine whether the portion is tracked by Lot/Tract or not.

XV..Coverage TDN - Polygon items. Notes : Standard Arc/INFO items are Not defined here. All items apply to individual taxing districts unless noted.

A..TDN - Tax district number. Three digits. (See enclosed chart)

B..CITY - Used to determine if the district is in a city/village or not and what color to shade it with. Two digits.

1..0 - No shading & not in a city/village.

2..## - Number of shade & within a city/village.

XVI..Coverage Mjroad - Arc items. Notes : Standard Arc/INFO items are Not defined here. All items apply to individual road centerlines unless noted. These are only major roads.

A..MAINTRES - Maintenance responsibility. Single character.

1..S - State.

B..ROADNAME - Name of road. Twenty characters.

C..FCLASS - Functional classification of road. Three characters.

D..NOT_CITY - Used to determine if the road is in a city/village or not. Single digit.

1..0 - In city/village.

2..1 - Not in city/village.

XVII..Coverage River - . Notes: Standard Arc/INFO items are Not defined here.
This coverage was created during/incorporating the 2002 Contour data.

A..LAYER - Original CAD-digitized layer name. 31 characters.

B..NAME - River or Stream name if determined. 35 characters

C..RIVER_STREAM - River/Stream flag. Six characters.

D..HIDDEN - Is the segment hidden, ie. culvert, flag. Single digit.

XVIII..Coverage Medcocen - Arc items. Notes: Standard Arc/INFO items are Not defined here. All items apply to individual road centerlines unless noted.

A..MAINTRES - Maintenance responsibility. Single character. Only Partially supported at this time.

1..S - State.

B..ROADNAME - Name of road. Twenty characters.

C..FCLASS - Functional classification of road. Three characters.

D..NOT_CITY - Used to determine if the road is in a city/village or not. Single digit.

1..0 - In city/village.

2..1 - Not in city/village

XIX..Infotable Adrs_ppn - INFO items. Notes: Standard Arc/INFO items are Not defined here. All items apply to individual address points unless noted.

A..ADD_# - Address number allowing for two decimal places. Five digits and two digits after the decimal place.

B..ADD_LETT - Address letter and any following numbers (ie. A2). Five characters.

C..ADDRESS_ADRS - Address point road name. Fifty characters.

D..TDN - Tax district. Three digits. (See enclosed chart)

E..BKN - The book number. Two digits and one letter. (See enclosed chart)

F..PGN - The page number. Two digits.

G..SPN - The sequential parcel number. Three digits.

H..PPN_MODIFIER - The possible modifier letter. One letter.

1..E - Tax exempt parcel.

2..T - Temporary parcel number.

3..C - New construction on an exempt parcel.

I..R_O_W - Indicator of whether or not the particular polygon is within a right-of-way. Single digit.

1..0 - Not within r-o-w.

2..1 - Within road r-o-w.

3..2 - Within railroad r-o-w.

J..FIRST# - First number given to the road. Six characters.

K..SECOND# - Second number given to the road. Six characters.

XX..Infotable Adrs_ppn - INFO redefined items.

A..ADD_CODE - The complete house number. Thirteen characters.

B..PPN+ - Complete parcel number. Twelve characters.

C..ADD_INT - The beginning integer portion of the address number. Five integers.

D..PPN - Parcel number without modifier. Eleven characters.