FW_POINT ATTRIBUTE DATA FORMAT
PositionRItemFramework Column NameOracle DatatypeColumn Short NameDescriptionDescription Definition Table
1*point shape numberpoint_shape_id NUMBER(10) pointshpidIdentifier of the associated spatial point in the point shape file
2framework point idfw_point_idNUMBER(10)fwpointidIdentifier for Point records in the Framework system.
3corner idcorner_idNUMBER(10)corneridIdentifier to define corners
4corner label textcorner_label_txtVARCHAR2(64)cnrlbltxtThe corner label text is text about the name or description of a point.
5*point typepoint_type_cd NUMBER(2) pointtycd'1' Geodetic Control Pointcoord_point_ty_code
'2' Significant Coordinated Location
'3' Corner Point
6*point coordinate latitudepoint_latitude_coord NUMBER(14,11) pntlatcordThe angle which the normal at the Point, projected to the ellipsoid, makes with the plane of the geodetic equator. Positive Latitudes will be understood to be the angle measured north from the equator. The ellipsoid used shall be the Geodetic Reference System of 1980 (GRS 80). The datum for coordinates shall be the North American Datum of 1983 (NAD 83). This is a double precision number with units being decimal degrees.
7*point coordinate longitudepoint_longitude_coord NUMBER(15,11) pntlngcordThe angle between the plane of the geodetic meridian passing through the Point and the plane of the Meridian of Greenwich. Positive Longitudes will be understood to be the angle measured east from Greenwich. The ellipsoid for determining Longitude shall be the Geodetic Reference System of 1980 (GRS 80). The datum for coordinates shall be the North American Datum of 1983 (NAD 83). This is a double precision number with units being decimal degrees.
8point coordinate verticalpoint_vert_coord NUMBER(7,3) pntvrtcordThe vertical distance from a datum to the Point. A vertical datum is any level surface (as for example, mean sea level) taken as a surface of reference from which to reckon elevations. The datum shall be the North American Vertical Datum of 1988 (NAVD 88). The unit shall be the meter.
9point established datepoint_established_dt DATE pntestdtThe date the point was established.(CCYYMMDD)
10point project namepoint_project_nm VARCHAR2(240)pntprojnmProject Name in which the point was measured.
11geodetic point namegeopoint_nm VARCHAR2(40) geopntnmUp to 40 characters of text which represent the name used to identify the control point
12geodetic point alias textgeopoint_alias_txt VARCHAR2(40) geopntatxtUp to 40 characters of text which represent an alternate form of the name used to identify the control point. These alias entries arise due to non-standard naming conventions used by various agencies and individuals.
13geodetic point id textgeopoint_pid_txt VARCHAR2(16) geopntptxtAn alphanumeric designator given by an agency to identify the Geodetic Control Point
14significant coordinated point namesigncoord_nm VARCHAR2(30) sigcordnmSignificant coordinated location name
15significant coordinated point descriptionsigncoord_desc VARCHAR2(240)sigcordescSignificant coordinated location description
16corner point accept flagcnrpoint_accept_flg VARCHAR2(1) cnrpntaflgThis flag indicates if the Corner Point is accepted as the location of the Corner.
17corner point accept datecnrpoint_accept_dt DATE cnrpntadtDate the corner point was accepted (CCYYMMDD)
18corner point dispute flagcnrpoint_dispute_flg VARCHAR2(1) cnrpntdflgFlag to represent a disputed corner point
19*monument status codecnrpoint_mon_stat_cd NUMBER(2)cnrpntmscd'1' Monumentedcorner_point_mon_stat_code
'2' Not monumented
'3' Monumentation unknown
20*horizontal coordinate system type codehorz_meas_type_cd NUMBER(2) hzmtypecd'1' Geographic Coordinatehorz_meas_ty_code
'2' Plane Coordinate
21plane coordinate system idplane_coord_syst_id NUMBER(2)plcrdsysid'1' UTM, 10plane_coord_syst?
'2' UTM, 11Table is empty in cadastre.
'3' SPCS27, 1101Need to still check code values.
'4' SPCS27, 1102
'5' SPCS27, 1103
'6' SPCS27, 3601
'7' SPCS27, 3602
'8' SPCS27, 4601
'9' SPCS27, 4602
'10' SPCS83, 1101
'11' SPCS83, 1102
'12' SPCS83, 1103
'13' SPCS83, 3601
'14' SPCS83, 3602
'15' SPCS83, 4601
'16' SPCS83, 4602
22*horizontal datum type codehorz_meas_datum_type_cd NUMBER(2) hzmdatycd'1' NAD 83 North American Datum of 1983horz_meas_datum_ty_code
'2' NAD 27 North American Datum of 1927
'3' NAD 83 North American Datum of 1983 (1991)
23measured latitudehorz_meas_geo_lat_coord NUMBER(14,11)hzmgltcordA geographic north-south coordinate is a latitude, defined as the angle which the normal at the Point, projected to the ellipsoid, makes with the plane of the geodetic equator.
24measured longitudehorz_meas_geo_long_coord NUMBER(15,11)hzmglgcord A geographic east-west coordinate is a longitude, defined as the angle between the plane of the geodetic meridian passing through the Point and the plane of the Meridian of Greenwich.
25measured plane easting coordinatehorz_meas_plane_ew_x_coord NUMBER(10,3)hzmpewxcrdThis is the coordinate describing the east-west position of the point.
26measured plane northing coordinatehorz_meas_plane_ns_y_coord NUMBER(10,3)hzmpnsycrdThis is the coordinate describing the north-south position of the point
27*horizontal plane coordinate unithorz_umeas_id NUMBER(2)hzumeasid 3 Int metric metersunit_of_meas
100 Int metric kilometersmeas_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
28*horizontal measurement method codehorz_measmeth_cdNUMBER(2)hzmmethcd 1 Calculationmeas_meth_code
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
29*horizontal measurement accuracyhorz_meas_accuracy_cdNUMBER(2)hzmaccycd0' Accuracy 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 .01meters
'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
30vertical z coordinatevert_meas_z_coordNUMBER(8,3)vrtmzcordThe vertical distance from a datum to the Point
31vertical measurement accepted flagvert_meas_accepted_flgVARCHAR2(1)vrtmaccflg'Y' Accepted as the best representation of the point
32vertical coordinate datum codevert_meas_datum_cdNUMBER(2)vrtmdatcd 1 National Geodetic Vertical Datum of 1929vert_meas_datum_code
2 North America Vertical Datum of 1988
3 Tidal datum defined by phase of tide
4 3 dimentional figure formed by rotating an elipse
5 Local Datum holding an arbritary elev.
33vertical measurement unitvert_umeas_idNUMBER(2)vrtumeasid 3 Int metric metersunit_of_meas
100 Int metric kilometersmeas_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
34vertical measurement method codevert_measmeth_cdNUMBER(2)vrtmmethcd 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
35vertical measurement accuracyvert_meas_accuracy_cdNUMBER(2)vrtmaccycd0' Accuracy 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 .01meters
'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
36monument established datemonument_set_dateDATEmonsetdtThe date on which the monument was erected. (CCYYMMDD)
37monument type codemonument_type_cdNUMBER(2)montypecd'1' Othersurvey_monument_ty_code
'2' Aluminum CapTable is empty in cadastre.
'3' Aluminum MarkerNeed to still check code values.
'4' Astro Pier
'5' Axle
'6' Azimuth Mark Disk
'7' Baseline Pier Disk
'8' Bench Mark Disk
'9' Bolt
'10' Boundry Marker Disk
'11' Brass Cap
'12' Calibration Base Line
'13' Cap and Bolt
'14' Chiseled Circle
'15' Chiseled Cross
'16' Chiseled Square
'17' Chiseled Triangle
'18' Clay Tile Pipe
'19' Concrete Post
'20' Disk
'21' Drill Hole
'22' Earthenware Pot
'23' Fence Post
'24' Flange-encased Rod
'25' Glass Bottle
'26' Gravity Reference Mark Disk
'27' Gravity Plug
'28' Gravity Station Disk
'29' Horizintal Control Disk
'30' Iron Pipe
'31' Iron Post
'32' Magnetic Station Disk
'33' Marked Stone
'34' Metal Rod
'35' Nail
'36' Nos Hydrographic Survey Disk
'37' Pipe Cap
'38' PK nail
'39' Rebar
'40' Reference Mark Disk
'41' Rivet
'42' Rock
'43' Rock Cairn
'44' Spike
'45' Steel Pin
'46' Stone Monument
'47' Survey Disk
'48' Tidal Station Disk
'49' Topographic Station Disk
'50' Traverse Station Disk
'51' Tree
'52' Triangulation Station Disk
'53' Water cap
'54' Wooden Hub
'55' Wooden Stake
'56' Vertical control Disk
38monument setting type codemonument_setting_type_cdNUMBER(3)monsetycd'1' unspecified shallowsurvey_monument_setting_code
'2' driven into the groundTable is empty in cadastre.
'3' imbedded in the groundNeed to still check code values.
'4' surrounded by a mass of concrete
'5' set into the top of an irregular mass of concrete
'6' set into the top of an irregular mass of concrete
'7' set into the top of a round concrete monument
'8' set into the top of a square concrete monument
'9' top of a prefabricated concrete post imbedded in
'10' top of prefabricated concrete post surrounded by concrete
'11' top of prefabricated conrete post imbedded in concrete
'12' set in prefabricated concrete block imbedded in ground
'13' set in prefabricated concrete block surrounded by concrete
'14' set in prefabricated concrete block imbedded in concrete
'15' a metal rod driven into the ground
'16' metal rod with base plate buried/screwed in ground
'17' set in top of metal pipe driven in ground'
'18' top of metal pipe imbedded in ground
'19' top of metal pipe surrounded by concrete
'20' top of metal pipe imbeded in concrete
'21' in cnct at cent. of clay tile pipe in wood pile in marsh
'22' in cnct. incenter of clay tile pipe imbedded in ground
'23' in cnct. at cntr. of clay tile pipe surr.by cnct.
'24' set in cnct. at cntr. of clay tile pipe imbedded in concrete
'30' light structures
'31' pavements (street, sidewalk, curb, apron,etc.)
'32' retaining walls, etc. = concrete ledge
'33' piles and poles
'34' footings/foundation walls of small/med structures
'35' mat foundations, etc. = concrete slab
'36' massive structures
'37' massive retaining walls
'38' abutments and piers of large bridges
'39' tunnels
'40' massive structures with deep foundations')
'41' large structures with foundations on bedrock
'45' unspecified depth
'46' copper-clad steel rod
'47' galvanized steel pipe
'48' galvanized steel rod
'49' stainless steel rod
'50' aluminum alloy rod
'55' unspecified pipe/rod in sleeve
'56' copper clad steel rod in sleeve
'57' galvanized steel pipe in sleeve
'58' galvanized steel rod in sleeve
'59' stainless steel rod in sleeve
'60' aluminum alloy rod in sleeve
'65' unspecified rock
'66' in rock outcrop
'67' set in drill hole in rock outcrop
'68' set in drill hole in rock outcropmarked by chiseled cross
'69' in drill hole in rock outcrop marked by chiseled triangle
'70' set in drill hole in rock outcrop marked by chiseled circle
'71' set in drill hole in rock outcrop marked by chiseled square
'73' in a rock ledge
'74' set in drill hole in rock ledge
'75' set in drill hole in rock ledge crossing of chisel
'76' set in drill hole in rock ledge marked bychiseled
'77' set in drill hole in rock ledge marked bychiseled
'78' set in drill hole in rock ledge marked bya chiseled lines
'80' in a boulder
'81' set in a drill hole in a boulder
'82' set in a drill hole in a boulder marked by a chiseled cross
'83' in a drill hole in a boulder marked by a chiseled triangle
'84' set in a drill hole in a boulder marked by a chiseled circle
'85' set in a drill hole in a boulder marked by a chiseled square
'87' in a partially exposed boulder
'88' in a drill hole in a partially exposed boulder
'89' drill hole in partly exposed boulder mrkd by a chisel cross
'90' drill hole in partly exposed boulder mrkd by a chisal triangle
'91' drill hole in partly exposed boulder mrkd by a chisal circle
'92' drill hole in partly exposed boulder mrkd by a chisal square
'93' in bedrock
'94' set in drill hole in bedrock
'95' set in concrete in a depression in rock outcrop
'96' set in concrete in a depression in rock ledge
'97' set in concrete in a depression in boulder
'98' set in concrete in a depression inpart exposed bou
'99' set in concrete in a depression in bedrock
39monument stamping textmonument_stamping_txtVARCHAR2(50)momstmptxtThe stamping field should contain the exact stamping as it appears on the survey monument. If there is no stamping, make no entry here; however, if the marker is a type that is normally stamped, enter a short note about its being unstamped in the accompanying descriptive text.
40monument description textmonument_desc_txtVARCHAR2(240)mondesctxtEvery effort must be made to provide enough information for easy recovery of the point. A well written description should contain: any information about the specific setting or exact location of the mark if the coded values are not sufficient to describe it completely. When distance estimates or measurements are given in metric units, English equivalencies must follow in parentheses. Property ownership and contact point telephone numbers are desirable when private property must be crossed or occupied.
41monument accessory textmonument_accessory_txtVARCHAR2(240)monacsytxtDistance and direction to, inscription, and designation of any monumented reference marks, reference objects, witness posts. Vertical reference to some nearby object (or the ground).
42monument access textmonument_access_txtVARCHAR2(240)monaccstxtEvery effort must be made to provide enough information for easy recovery of the point. A well written description should contain: (1) one or more references to some well known, readily available, location in terms of distances and directions. Intersections of prominent highways, landmarks, and public buildings in nearby towns prominent highways, landmarks, and public buildings in nearby towns are examples of such locations. In some cases, this location will require some description; (2) detailed directions concerning how one would proceed to the mark site from one or more of these prominent locations; When distance estimates or measurements are given in metric units, English equivalencies must follow in parentheses. Property ownership and contact point telephone numbers are desirable when private.
43monument recovery daterecov_dtDATErecovdtThe date of the Monument Recovery.(CCYYMMDD)
44monument recovery condition coderecov_type_cdNUMBER(2)recovtycd'1' Goodmonument_recov_cond_code
'2' Not recovered, not foundTable is empty in cadastre.
'3' Poor, Disturbed, Mutilated, Requires MaintenanceNeed to still check code values.
'4' Destroyed, marker separated from setting.
'5' Not Monumented --Monument Removed
45monument recovery condition textrecov_condition_txtVARCHAR2(40)recovcntxtThis provides a text field to describe in detail the changes in the monument condition, monument surroundings, and access to the monument.
46*document iddoc_idNUMBER(10)docidNumber to identify document record.