FW_LEGAL_DESC ATTRIBUTE DATA FORMATRequired Fields:
* = Both PLS and NON-PLS
Ñ = Just PLS
· = Just NON-PLS
PositionRItemFramework Column NameOracle DatatypeColumn Short NameDescriptionDescription Definition Table
1*legal area description shape record numberlad_shape_idNUMBER(10) ladshpidIdentifier to associate tabular data record with the Legal Area Description polygon record in the Legal Area Desc shape file
2framework legal area desc numberfw_legal_desc_idNUMBER(10)fwladidIdentifier for Legal Area Descripion records in the Framework system.
3legal area description shape parent idfw_legal_desc_parent_idNUMBER(10)fwladpntidNumber to identify parent legal area description shape record
4*legal area description type codelegal_desc_type_cd NUMBER(2) ladtypecd'1' PLS Public Land Survey (Township, DLC, Section, Aliquot, etc.)LEGAL_AREA_DESC_TY_CODE
'2' Non-PLS Area (Indian Allotment, Aquatic, etc)
5legal area description label textlegal_desc_label_txt VARCHAR2(50) ladlabltxtText definition of the legal area description
6ÑPLS township whole number pls_twp_whole_no NUMBER(2) plstwpwlnoThe Township Number indicates the number of rows of townships, north or south from a Public Land Survey System Origin.
7ÑPLS township fraction codepls_twp_fract_cd NUMBER(2) plstwpfrcd'0' 0 No fraction PLS_FRACT_CODE
'1' 1/4 One-quarter
'2' 1/2 One-half
'3' 3/4 Three-quarter
8ÑPLS township direction codepls_twp_dir_cd VARCHAR2(2) plstwpdrcd'N' North PLS_TWP_DIR_CODE
'S' South
9ÑPLS range whole numberpls_rng_whole_no NUMBER(2) plsrngwlnoThe Range Number indicates the number of columns of townships, east or west from a Public Land Survey System Origin.
10ÑPLS range fraction codepls_rng_fract_cd NUMBER(2) plsrngfrcd'0' 0 No fraction PLS_FRACT_CODE
'1' 1/4 One-quarter
'2' 1/2 One-half
'3' 3/4 Three-quarter
11ÑPLS range direction codepls_rng_dir_cd VARCHAR2(2) plsrngdrcd'E' EastPLS_RANGE_DIR_CODE
'W' West
12ÑPLS township duplicate status flagpls_twp_dup_stat_flg VARCHAR2(1) plstwpdflg'Y' A flag, when filled, indicates PLS township is a duplicate.
13PLS township subdivision type codepls_twp_subdiv_type_cd NUMBER(2) plstwpstcd'1' SectionPLS_TWP_SUBDIV_TY_CODE
'2' Donation land claim
'3' Tract
'4' Protracted Block
14PLS township subdivision numberpls_twp_subdiv_no NUMBER(8) plstwpsdnoPublic land survey township subdivision number
15PLS township subdivision namepls_twp_subdiv_nm VARCHAR2(240) plstwpsdnmPublic land survey township subdivision name
16PLS township subdivision duplicate status flagpls_twp_subdiv_dup_stat_flg VARCHAR2(1) plssddsflg "Y" indicated that the PLS township subdivision is a duplicate. "N" equals false.
17section subdivision type codesect_subdiv_type_cdNUMBER(2)sectsdtycd'1' Aliquot partPLS_SECT_SUBDIV_TY_CODE
'2' Government Lot
'3' Government Parcel
18PLS aliquot 1/2 1/4 codepls_aliquot_2_4_cdVARCHAR2(2)plsal4cd'NE' NE1/4 Northeast quarterPLS_SECT_ALIQUOT_PART_CODE
'NW' NW1/4 Northwest quarter
'SW' SW1/4 Southwest quarter
'SE' SE1/4 Southeast quarter
'N2' N1/2 North half
'S2' S1/2 South half
'E2' E1/2 East half
'W2' W1/2 West half
19PLS aliquot 1/8 1/16 codePLS_aliquot_8_16_cdVARCHAR2(2)plsal16cd'NE' NE1/4 Northeast quarterPLS_SECT_ALIQUOT_PART_CODE
'NW' NW1/4 Northwest quarter
'SW' SW1/4 Southwest quarter
'SE' SE1/4 Southeast quarter
'N2' N1/2 North half
'S2' S1/2 South half
'E2' E1/2 East half
'W2' W1/2 West half
20PLS aliquot 1/32 1/64 codePLS_aliquot_32_64_cdVARCHAR2(2)plsal64cd'NE' NE1/4 Northeast quarterPLS_SECT_ALIQUOT_PART_CODE
'NW' NW1/4 Northwest quarter
'SW' SW1/4 Southwest quarter
'SE' SE1/4 Southeast quarter
'N2' N1/2 North half
'S2' S1/2 South half
'E2' E1/2 East half
'W2' W1/2 West half
21PLS aliquot 1/128 1/256 codePLS_aliquot_128_256_cdVARCHAR2(2)plsal256cd'NE' NE1/4 Northeast quarterPLS_SECT_ALIQUOT_PART_CODE
'NW' NW1/4 Northwest quarter
'SW' SW1/4 Southwest quarter
'SE' SE1/4 Southeast quarter
'N2' N1/2 North half
'S2' S1/2 South half
'E2' E1/2 East half
'W2' W1/2 West half
22PLS aliquot 1/512 1/1024 codePLS_aliquot_512_1024_cdVARCHAR2(2)plsal1024cd'NE' NE1/4 Northeast quarterPLS_SECT_ALIQUOT_PART_CODE
'NW' NW1/4 Northwest quarter
'SW' SW1/4 Southwest quarter
'SE' SE1/4 Southeast quarter
'N2' N1/2 North half
'S2' S1/2 South half
'E2' E1/2 East half
'W2' W1/2 West half
23PLS lot/parcel numberPLS_lot_prcl_noNUMBER(8)plstlotpnoThe integer identifying the Government Lot or Government Parcel as a unique subdivision of the Section in which it lies. Government Lots are numbered beginning with 1. Some Government Lots were left unnumbered.
24PLS lot/parcel duplicate status flagPLS_lot_prcl_dup_stat_flgVARCHAR2(1)plslpdsflgThis is a one character flag stating if the identifying number for this government lot is a duplicate. 'Y' indicates a duplicate record exists.
25·Non PLS type code non_pls_type_cd NUMBER(2) nonplstycd 1 Assessor PlatNON_PLS_TY_CODE
2 Binding Site Plan
3 Block
4 Cemetery
5 Condominium Subdivision
6 Condominium Unit
7 Farm Unit
8 Fractional Part or Area Description
9 Homestead Entry Survey
10 Indian Allotment
11 Irrigation Block
12 Lode Claim
13 Lot
14 Metes and Bounds Description
15 Mill Site
16 Mineral Claim
17 Mineral Survey
18 Military Reservation
19 Outlot
20 Placer Claim
21 Right of Way
22 Short Subdivision
23 Small Holding Claim
24 Small Tracts Act
25 Subdivision
26 Survey
27 Townsite
28 Strip Description
29 Tract Description
30 Irrigation Project
31 First Class Marine Tideland
32 Second Class Marine Tideland
33 Third Class Marine Tideland
34 First Class River Shoreland
35 Second Class River Shoreland
36 Harbor Area
37 Waterway
38 Marine Bedland
39 River Bedland
40 Lake Bedland
41 Aquatic Street
42 Public Place
43 First Class Abandoned Marine Tideland
44 Second Class Abandoned Marine Tideland
45 First Class Abandoned River Shoreland
46 Second Class Abandoned River Shoreland
47 Abandoned Bedland
48 Adjoiner Description
49 Aquatic Plate
50 Aquatic Plat
51 Point with Radius Description
52 First Class River Tideland
53 Second Class River Tideland
54 Third Class River Tideland
55 First Class Lake Shoreland
56 Second Class Lake Shoreland
57 First Class Abandoned River Tideland
58 Second Class Abandoned River Tideland
59 First Class Abandoned Lake Shoreland
60 Second Class Abandoned Lake Shoreland
61 Point with radius
26·Non PLS duplicate status flag non_pls_dup_stat_flg VARCHAR2(1) nonplsdflg'Y' A flag stating if this instance of a non-plss survey system area identifying number is a duplicate identifying number. "N" equals false.
27Non PLS Place namenon_pls_place_nm VARCHAR2(240) nonplsplnmSome Non-PLSS Described Areas are designated by a name. For example, subdivisions normally have a name, e.g. "Wright's Addition to Rochester."
28Non PLS number text non_pls_no_txt VARCHAR2(240) nonplsntxtSome Non-PLSS Described Areas are designated by a number or letter. For example, Block A or Lot 10.
29Subdivision/Tractnon_pls_subdivision_tractVARCHAR2(8)nonplsubtrSubdivision or Tract designation. Only used for Non PLS Types '25' and '29'
30Blocknon_pls_blockVARCHAR2(8)nonplsblkBlock designation. Only used for Non PLS Types '3','25'
31Lotnon_pls_lotVARCHAR2(8)nonplslotLot designation. Only used for Non PLS Types '13','3','25'
32Non PLS established date non_pls_est_dt DATE nonplsetdtEstablished date ('CCYYMMDD')
33Non PLS portion text non_pls_portion_txt VARCHAR2(240) nonplsptxtText description of Non-PLS portion
34Areafw_legal_desc_areaNUMBER(12,2)fwladareaDocumented Area
35Area measure idarea_umeas_idNUMBER(2)areaumeaid4 m^2, Square metersunit_of_meas
200 km^2, Square kilometers meas_sys_code
201 ha, hectares
202 a, ares
203 cm^2, Square centimeters
210 mi^2, Square miles
211 yd^2, Square yards
212 ft^2, Square feet
213 in^2, Square inches
220 US mi^2, Square US miles
221 US ac, US acres
222 US ft^2, Square US feet
36Area measure method codearea_measmeth_cdNUMBER(2)areammetcd 1 Calculationmeas_meth_code
2 Computerized Map Scaling
3 Conventional Survey
4 Digitized
5 Geodetic GPS Survey
6 Inertial Survey
7 Mechanical Map Scaling
9 Phototriangulation
10 Resource Grade GPS
11 Vectorized
12 Survey CoGo
14 Visual Estimation
15 Formula Prediction
16 Field Measurement
18 Field Estimation
19 Onsite Calculation
20 Office Estimation
21 Algorithm
999 Unknown
37Area measure accuracy codearea_meas_accuracy_cdNUMBER(2)areamaccd0' Accuacy not knownmeas_accuracy_level_code
1' 1-Millimeter, 95% < or = to .001 meter
2' 2-Millimeter, 95% < or = to .002 meter
3' 5-Millimeter, 95% < or = to .005 meter
4' 1-Centimeter, 95% < or = to .01 meters
5' 2-Centimeter, 95% < or = to .02 meters
6' 5-Centimeter, 95% < or = to .05 meters
7' 1-Decimeter, 95 % <or = to .10 meters
8' 2-Decimeter, 95% < or = .20 meters
9' 5-Decimeter, 95% < or = to .50 meters
10' 1-Meter, 95% < or = to 1.000 meters
11' 2-Meter, 95% < or = to 2.000 meters
12' 5-Meters, 95% < or = to 5.000 meters
13' 10-Meter, 95% < or = to 10.000 meters
14' 20-Meter, 95% < or = to 20.000 meters
15' 50-Meter, 95%, < or = to 50.000 meters
16' 100-Meter, 95% < or = to 100.0 meters
17' 100-Meter, 95%>100.000 meters
38*document iddoc_idNUMBER(10)docidNumber to identify document from the data transfer standard document file