FW_BOUNDARY ATTRIBUTE DATA FORMAT | |||||||

Position | R | Item | Framework Column Name | Oracle Datatype | Column Short Name | Description | Description Definition Table |

1 | * | boundary shape id | boundary_shape_id | NUMBER(10) | bdryshpid | Identifier for the feature in the Boundary shape file | |

2 | framework line number | fw_boundary_id | NUMBER(10) | fwbdryid | Identifier from Framework for updating existing lines. | ||

3 | boundary established date | bdry_est_dt | DATE | bdryestdt | Date the boundary was established. (CCYYMMDD) | ||

4 | boundary offset left distance | bdry_offset_left_distance | NUMBER(6,3) | bdryoldist | The distance the Boundary is offset to the left of the described line or curve. This is useful for strip descriptions and rights of way. This is a distance measure in units defined by the Distance Unit and Distance Type. | ||

5 | boundary offset right distance | bdry_offset_right_distance | NUMBER(6,3) | bdryordist | The distance the Boundary is offset to the right of the described line or curve. This is useful for strip descriptions and rights of way. This is a distance measure in units defined by the Distance Unit and Distance Type. | ||

6 | boundary bounds text | bdry_bounds_txt | VARCHAR2(240) | bdrybndtxt | The text which describes a Boundary calling for adjoiners such as, "South along the edge of the Cowlitz River" or "along the land owned by Fred Perry" or "along the easterly right of way of Cedar Street". | ||

7 | boundary legal status txt | bdry_legal_status_txt | VARCHAR2(240) | bdrystatxt | The Boundary Legal Status identifies the Boundary's status from a legal or court perspective. Examples of legal status comments are Disputed, Adjudicated, and Computed. | ||

8 | boundary text | bdry_txt | VARCHAR2(40) | bdrytxt | Descriptive text | ||

9 | boundary elevation | bdry_elev | NUMBER(8,3) | bdryelev | Elevation of the boundary | ||

10 | vertical unit of measure code | vert_umeas_id | NUMBER(2) | vertumeaid | 3 Int metric meters | unit_of_meas | |

for boundary elevation | 100 Int metric kilometers | meas_sys_code | |||||

101 Int metric decimeters | |||||||

103 Int metric millimeters | |||||||

120 US leagues | |||||||

121 US nautical miles | |||||||

122 US miles | |||||||

123 US yards | |||||||

124 US feet | |||||||

125 US inches | |||||||

130 US survey miles | |||||||

131 US survey feet | |||||||

132 US survey chains | |||||||

133 US survey links | |||||||

134 US survey rods | |||||||

135 US survey poles | |||||||

136 US survey perches | |||||||

137 US survey fathoms | |||||||

11 | vertical measure method code | vert_measmeth_cd | NUMBER(2) | vertmmetcd | 1 Calculation | meas_meth_code | |

for boundary elevation | 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 | |||||||

12 | vertical measure accuracy code | vert_meas_accuracy_cd | NUMBER(2) | vertmaccd | 0' Accuacy not known | meas_accuracy_level_code | |

for boundary elevation | 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 | |||||||

13 | boundary measure type code | bdry_meas_type_cd | NUMBER(2) | bdrymtycd | '1' Straight Line | bdry_meas_ty_code | |

'2' Circular Curve | |||||||

'3' Spiral Curve | |||||||

'4' Along Feature | |||||||

14 | boundary measure length | bdry_meas_lng | NUMBER(10,2) | bdrymlng | Documented length of boundary line in LINEAR_UMEAS_ID units | ||

15 | linear unit of measure code | lin_umeas_id | NUMBER(2) | linumeasid | 3 Int metric meters | unit_of_meas | |

for boundary measure length | 100 Int metric kilometers | meas_sys_code | |||||

101 Int metric decimeters | |||||||

103 Int metric millimeters | |||||||

120 US leagues | |||||||

121 US nautical miles | |||||||

122 US miles | |||||||

123 US yards | |||||||

124 US feet | |||||||

125 US inches | |||||||

130 US survey miles | |||||||

131 US survey feet | |||||||

132 US survey chains | |||||||

133 US survey links | |||||||

134 US survey rods | |||||||

135 US survey poles | |||||||

136 US survey perches | |||||||

137 US survey fathoms | |||||||

16 | linear measure method code | lin_measmeth_cd | NUMBER(2) | linmmetcd | 1 Calculation | meas_meth_code | |

for boundary measure length | 2 Computerized Map Scaling | ||||||

3 Conventional Survey | |||||||

4 Digitized | |||||||

5 Geodetic GPS Survey | |||||||

6 Inertial Survey | |||||||

7 Mechanical Map Scaling | |||||||

8 Photo Pinned | |||||||

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 | |||||||

17 | linear measure accuracy code | lin_meas_accuracy_cd | NUMBER(2) | linmaccd | 0' Accuacy not known | meas_accuracy_level_code | |

for boundary measure length | 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 | |||||||

18 | * | boundary measure defining flag | bdry_meas_defining_flg | VARCHAR2(1) | bdrymdeflg | If a Boundary Measurement is part of the legal description for a parcel or if it appears on the survey which created the parcel, then the measurement can be said to define the boundary; the measurement can be called a "record" measurement. In such a case the defining flag is set. This flag is important for activities which relate to the record or official measurement of a line, such as proportioning lost corners. If a Boundary Measurement is a private surveyor's remeasurement, then the defining flag is not set. Default is False ("F") for no. If is true then value is "T". | |

19 | line angle direction angle | line_angle_dir_ang | NUMBER(8,5) | linadirang | The direction of a line is the angle between the line and an arbitrary chosen reference line. When the reference line is north or south and the angle is designated east or west, the direction is called the bearing. When the reference line is north or south and the angle is clockwise, the direction is called the azimuth. The direction is an angular measurement in units defined by the Direction Unit, Direction Quadrant, and Direction Type | ||

20 | boundary measurement | bdry_meas_dir_quad_cd | VARCHAR2(2) | bdrymdrqcd | 'N' N. Azimuth. | bdry_meas_dir_quad_code | |

direction quad code | 'S' S. Azimuth | ||||||

'NE' Northeast | |||||||

'SE' Southeast | |||||||

'SW' Southwest | |||||||

'NW' Northwest | |||||||

21 | boundary direction type code | bdry_dir_type_cd | NUMBER(2) | bdrydrtycd | '1' geodetic | bdry_meas_dir_ty_code | |

'2' grid | |||||||

'3' astronomic | |||||||

'4' Magnetic North | |||||||

'5' assumed | |||||||

'6' Astronomic (true) mean bearing | |||||||

'7' Referenced Meridian of another line in a survey | |||||||

22 | angular unit of measure code | angular_umeas_id | NUMBER(2) | angumeasid | 8 Int metric radians | unit_of_meas | |

600 US degrees | meas_sys_code | ||||||

601 US minutes | |||||||

602 US seconds | |||||||

23 | boundary distance type code | bdry_distance_type_cd | NUMBER(2) | bdrydstycd | '1' Ground | bdry_meas_dist_ty_code | |

'2' Geodetic | |||||||

'3' Grid distance | |||||||

24 | * | document id | doc_id | NUMBER(10) | docid | Number to identify document in the Document Data Transfer Standard file. |