|
| | | FW_LEGAL_DESC ATTRIBUTE DATA FORMAT | | | | Required Fields: |
| | | | | | | * = Both PLS and NON-PLS |
| | | | | | | Ñ = Just PLS |
| | | | | | | · = Just NON-PLS |
|
| Position | R | Item | Framework Column Name | Oracle Datatype | Column Short Name | Description | Description Definition Table |
| 1 | * | legal area description shape record number | lad_shape_id | NUMBER(10) | ladshpid | Identifier to associate tabular data record with the Legal Area Description polygon record in the Legal Area Desc shape file |
| 2 | | framework legal area desc number | fw_legal_desc_id | NUMBER(10) | fwladid | Identifier for Legal Area Descripion records in the Framework system. |
| 3 | | legal area description shape parent id | fw_legal_desc_parent_id | NUMBER(10) | fwladpntid | Number to identify parent legal area description shape record |
| 4 | * | legal area description type code | legal_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) |
| 5 | | legal area description label text | legal_desc_label_txt | VARCHAR2(50) | ladlabltxt | Text definition of the legal area description |
| 6 | Ñ | PLS township whole number | pls_twp_whole_no | NUMBER(2) | plstwpwlno | The Township Number indicates the number of rows of townships, north or south from a Public Land Survey System Origin. |
| 7 | Ñ | PLS township fraction code | pls_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 code | pls_twp_dir_cd | VARCHAR2(2) | plstwpdrcd | 'N' North | PLS_TWP_DIR_CODE |
| | | | | | 'S' South |
| 9 | Ñ | PLS range whole number | pls_rng_whole_no | NUMBER(2) | plsrngwlno | The Range Number indicates the number of columns of townships, east or west from a Public Land Survey System Origin. |
| 10 | Ñ | PLS range fraction code | pls_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 code | pls_rng_dir_cd | VARCHAR2(2) | plsrngdrcd | 'E' East | PLS_RANGE_DIR_CODE |
| | | | | | 'W' West |
| 12 | Ñ | PLS township duplicate status flag | pls_twp_dup_stat_flg | VARCHAR2(1) | plstwpdflg | 'Y' A flag, when filled, indicates PLS township is a duplicate. |
| 13 | | PLS township subdivision type code | pls_twp_subdiv_type_cd | NUMBER(2) | plstwpstcd | '1' Section | PLS_TWP_SUBDIV_TY_CODE |
| | | | | | '2' Donation land claim |
| | | | | | '3' Tract |
| | | | | | '4' Protracted Block |
| 14 | | PLS township subdivision number | pls_twp_subdiv_no | NUMBER(8) | plstwpsdno | Public land survey township subdivision number |
| 15 | | PLS township subdivision name | pls_twp_subdiv_nm | VARCHAR2(240) | plstwpsdnm | Public land survey township subdivision name |
| 16 | | PLS township subdivision duplicate status flag | pls_twp_subdiv_dup_stat_flg | VARCHAR2(1) | plssddsflg | "Y" indicated that the PLS township subdivision is a duplicate. "N" equals false. |
| 17 | | section subdivision type code | sect_subdiv_type_cd | NUMBER(2) | sectsdtycd | '1' Aliquot part | PLS_SECT_SUBDIV_TY_CODE |
| | | | | | '2' Government Lot |
| | | | | | '3' Government Parcel |
| 18 | | PLS aliquot 1/2 1/4 code | pls_aliquot_2_4_cd | VARCHAR2(2) | plsal4cd | 'NE' NE1/4 Northeast quarter | PLS_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 |
| 19 | | PLS aliquot 1/8 1/16 code | PLS_aliquot_8_16_cd | VARCHAR2(2) | plsal16cd | 'NE' NE1/4 Northeast quarter | PLS_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 |
| 20 | | PLS aliquot 1/32 1/64 code | PLS_aliquot_32_64_cd | VARCHAR2(2) | plsal64cd | 'NE' NE1/4 Northeast quarter | PLS_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 |
| 21 | | PLS aliquot 1/128 1/256 code | PLS_aliquot_128_256_cd | VARCHAR2(2) | plsal256cd | 'NE' NE1/4 Northeast quarter | PLS_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 |
| 22 | | PLS aliquot 1/512 1/1024 code | PLS_aliquot_512_1024_cd | VARCHAR2(2) | plsal1024cd | 'NE' NE1/4 Northeast quarter | PLS_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 |
| 23 | | PLS lot/parcel number | PLS_lot_prcl_no | NUMBER(8) | plstlotpno | The 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. |
| 24 | | PLS lot/parcel duplicate status flag | PLS_lot_prcl_dup_stat_flg | VARCHAR2(1) | plslpdsflg | This 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 Plat | NON_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. |
| 27 | | Non PLS Place name | non_pls_place_nm | VARCHAR2(240) | nonplsplnm | Some Non-PLSS Described Areas are designated by a name. For example, subdivisions normally have a name, e.g. "Wright's Addition to Rochester." |
| 28 | | Non PLS number text | non_pls_no_txt | VARCHAR2(240) | nonplsntxt | Some Non-PLSS Described Areas are designated by a number or letter. For example, Block A or Lot 10. |
| 29 | | Subdivision/Tract | non_pls_subdivision_tract | VARCHAR2(8) | nonplsubtr | Subdivision or Tract designation. Only used for Non PLS Types '25' and '29' |
| 30 | | Block | non_pls_block | VARCHAR2(8) | nonplsblk | Block designation. Only used for Non PLS Types '3','25' |
| 31 | | Lot | non_pls_lot | VARCHAR2(8) | nonplslot | Lot designation. Only used for Non PLS Types '13','3','25' |
| 32 | | Non PLS established date | non_pls_est_dt | DATE | nonplsetdt | Established date ('CCYYMMDD') |
| 33 | | Non PLS portion text | non_pls_portion_txt | VARCHAR2(240) | nonplsptxt | Text description of Non-PLS portion |
| 34 | | Area | fw_legal_desc_area | NUMBER(12,2) | fwladarea | Documented Area |
| 35 | | Area measure id | area_umeas_id | NUMBER(2) | areaumeaid | 4 m^2, Square meters | unit_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 |
| 36 | | Area measure method code | area_measmeth_cd | NUMBER(2) | areammetcd | 1 Calculation | meas_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 |
| 37 | | Area measure accuracy code | area_meas_accuracy_cd | NUMBER(2) | areamaccd | 0' Accuacy not known | meas_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 id | doc_id | NUMBER(10) | docid | Number to identify document from the data transfer standard document file |