Q:\docs\CadastreFW\Standards\Data Transfer Standard\fw

			FW_POINT ATTRIBUTE DATA FORMAT
Position	R	Item	Framework Column Name	Oracle Datatype	Column Short Name	Description	Description Definition Table
1	*	point shape number	point_shape_id	NUMBER(10)	pointshpid	Identifier of the associated spatial point in the point shape file
2		framework point id	fw_point_id	NUMBER(10)	fwpointid	Identifier for Point records in the Framework system.
3		corner id	corner_id	NUMBER(10)	cornerid	Identifier to define corners
4		corner label text	corner_label_txt	VARCHAR2(64)	cnrlbltxt	The corner label text is text about the name or description of a point.
5	*	point type	point_type_cd	NUMBER(2)	pointtycd	'1' Geodetic Control Point	coord_point_ty_code
						'2' Significant Coordinated Location
						'3' Corner Point
6	*	point coordinate latitude	point_latitude_coord	NUMBER(14,11)	pntlatcord	The 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 longitude	point_longitude_coord	NUMBER(15,11)	pntlngcord	The 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.
8		point coordinate vertical	point_vert_coord	NUMBER(7,3)	pntvrtcord	The 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.
9		point established date	point_established_dt	DATE	pntestdt	The date the point was established.(CCYYMMDD)
10		point project name	point_project_nm	VARCHAR2(240)	pntprojnm	Project Name in which the point was measured.
11		geodetic point name	geopoint_nm	VARCHAR2(40)	geopntnm	Up to 40 characters of text which represent the name used to identify the control point
12		geodetic point alias text	geopoint_alias_txt	VARCHAR2(40)	geopntatxt	Up 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.
13		geodetic point id text	geopoint_pid_txt	VARCHAR2(16)	geopntptxt	An alphanumeric designator given by an agency to identify the Geodetic Control Point
14		significant coordinated point name	signcoord_nm	VARCHAR2(30)	sigcordnm	Significant coordinated location name
15		significant coordinated point description	signcoord_desc	VARCHAR2(240)	sigcordesc	Significant coordinated location description
16		corner point accept flag	cnrpoint_accept_flg	VARCHAR2(1)	cnrpntaflg	This flag indicates if the Corner Point is accepted as the location of the Corner.
17		corner point accept date	cnrpoint_accept_dt	DATE	cnrpntadt	Date the corner point was accepted (CCYYMMDD)
18		corner point dispute flag	cnrpoint_dispute_flg	VARCHAR2(1)	cnrpntdflg	Flag to represent a disputed corner point
19	*	monument status code	cnrpoint_mon_stat_cd	NUMBER(2)	cnrpntmscd	'1' Monumented	corner_point_mon_stat_code
						'2' Not monumented
						'3' Monumentation unknown
20	*	horizontal coordinate system type code	horz_meas_type_cd	NUMBER(2)	hzmtypecd	'1' Geographic Coordinate	horz_meas_ty_code
		horizontal coordinate system type code				'2' Plane Coordinate
21		plane coordinate system id	plane_coord_syst_id	NUMBER(2)	plcrdsysid	'1' UTM, 10	plane_coord_syst?
						'2' UTM, 11	Table is empty in cadastre.
						'3' SPCS27, 1101	Need 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 code	horz_meas_datum_type_cd	NUMBER(2)	hzmdatycd	'1' NAD 83 North American Datum of 1983	horz_meas_datum_ty_code
						'2' NAD 27 North American Datum of 1927
						'3' NAD 83 North American Datum of 1983 (1991)
23		measured latitude	horz_meas_geo_lat_coord	NUMBER(14,11)	hzmgltcord	A 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.
24		measured longitude	horz_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.
25		measured plane easting coordinate	horz_meas_plane_ew_x_coord	NUMBER(10,3)	hzmpewxcrd	This is the coordinate describing the east-west position of the point.
26		measured plane northing coordinate	horz_meas_plane_ns_y_coord	NUMBER(10,3)	hzmpnsycrd	This is the coordinate describing the north-south position of the point
27	*	horizontal plane coordinate unit	horz_umeas_id	NUMBER(2)	hzumeasid	3 Int metric meters	unit_of_meas
						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
28	*	horizontal measurement method code	horz_measmeth_cd	NUMBER(2)	hzmmethcd	1 Calculation	meas_meth_code
		horizontal measurement method 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 accuracy	horz_meas_accuracy_cd	NUMBER(2)	hzmaccycd	0' Accuracy not known	meas_accuracy_level_code
		horizontal measurement accuracy				'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
30		vertical z coordinate	vert_meas_z_coord	NUMBER(8,3)	vrtmzcord	The vertical distance from a datum to the Point
31		vertical measurement accepted flag	vert_meas_accepted_flg	VARCHAR2(1)	vrtmaccflg	'Y' Accepted as the best representation of the point
32		vertical coordinate datum code	vert_meas_datum_cd	NUMBER(2)	vrtmdatcd	1 National Geodetic Vertical Datum of 1929	vert_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.
33		vertical measurement unit	vert_umeas_id	NUMBER(2)	vrtumeasid	3 Int metric meters	unit_of_meas
						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
34		vertical measurement method code	vert_measmeth_cd	NUMBER(2)	vrtmmethcd	1 Calculation	meas_meth_code
		vertical measurement method 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
35		vertical measurement accuracy	vert_meas_accuracy_cd	NUMBER(2)	vrtmaccycd	0' Accuracy 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 .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
36		monument established date	monument_set_date	DATE	monsetdt	The date on which the monument was erected. (CCYYMMDD)
37		monument type code	monument_type_cd	NUMBER(2)	montypecd	'1' Other	survey_monument_ty_code
						'2' Aluminum Cap	Table is empty in cadastre.
						'3' Aluminum Marker	Need 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
38		monument setting type code	monument_setting_type_cd	NUMBER(3)	monsetycd	'1' unspecified shallow	survey_monument_setting_code
						'2' driven into the ground	Table is empty in cadastre.
						'3' imbedded in the ground	Need 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
39		monument stamping text	monument_stamping_txt	VARCHAR2(50)	momstmptxt	The 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.
40		monument description text	monument_desc_txt	VARCHAR2(240)	mondesctxt	Every 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.
41		monument accessory text	monument_accessory_txt	VARCHAR2(240)	monacsytxt	Distance and direction to, inscription, and designation of any monumented reference marks, reference objects, witness posts. Vertical reference to some nearby object (or the ground).
42		monument access text	monument_access_txt	VARCHAR2(240)	monaccstxt	Every 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.
43		monument recovery date	recov_dt	DATE	recovdt	The date of the Monument Recovery.(CCYYMMDD)
44		monument recovery condition code	recov_type_cd	NUMBER(2)	recovtycd	'1' Good	monument_recov_cond_code
		monument recovery condition code				'2' Not recovered, not found	Table is empty in cadastre.
						'3' Poor, Disturbed, Mutilated, Requires Maintenance	Need to still check code values.
						'4' Destroyed, marker separated from setting.
						'5' Not Monumented --Monument Removed
45		monument recovery condition text	recov_condition_txt	VARCHAR2(40)	recovcntxt	This provides a text field to describe in detail the changes in the monument condition, monument surroundings, and access to the monument.
46	*	document id	doc_id	NUMBER(10)	docid	Number to identify document record.