Protraction Report

Jarad Bond
2/5/2015

SDMS Protraction Tables

Table of Contents
The 'Table of contents' field needs to be updated!

Diagram AK GCDB Protraction

Table: pro_pt
Description:
Protraction Point is a theoretical PLSS rectangular point as identified on the official protraction diagrams, Alaska Canada Survey plat, or other supplemental information. A protraction point may be a township point, a section point, or an Alaska/Canada International Boundary point. 

A protraction point may also be a "construction point", used to define the section grid, but is not an official protraction point identified on the protraction diagram.  Construction points fall within the boundaries of Canada or beyond the Alaska coastline and are generally useful for creating geometries from regular township or section boundaries (such as aliquot parts).

The position of a protraction point was calculated based on where it is in the PLSS from initial meridian origin points. 

The latitude and longitude measurements and spatial point features stored in the shape field represent the original, unadjusted positions of points in the NAD27 datum.

Survey may contradict the positions of protraction points. When a protraction point is surveyed (pro_pt_cor stores this relationship), all protraction points within the township may be adjusted to a new position to better match the surveyed portions fo that township. If that happens, the new values are stored in pro_pt_adj. The most current positions are always stored in pro_pt_adj and if a point has not been adjusted with a new position, that table will contain the original position of the protracted point.

There are two tables that contain additional positions: pro_pt83 and pro_pt83_adj. They have similar properties to pro_pt and pro_pt_adj, respectively, containing the same position in the NAD83 datum.

FGDC Alias: None

FGDC Definition: None
List of Columns:
Name	Code	Data Type	
Pro Point Id	pro_pt_id	INTEGER	
Pro Point Name	pro_pt_name	CHAR(90)	
Pro Point Latitude	lat_meas	CHAR(16)	
Pro Point Longitude	long_meas	CHAR(17)	
Pro Point Dec Lat	dlat_meas	DEC(16,12)	
Pro Point Dec Long	dlong_meas	DEC(17,12)	
Pro Point Feature Id	objectid	INTEGER	
Protracted NAD27 Point Feature	shape	ST_POINT	
Input User Id	user_id	CHAR(10)	
Date Input	entered_date	DATE	
Modification User Id	modified_user_id	CHAR(10)	
Date Modified	modified_date	DATE	

List of Triggers:
Name	Code	
ins_propt_objectid	ins_propt_objectid	

Column: pro_pt_id
Description:
Protraction Point Id is a system-generated id to uniquely identify a protracted point.

FGDC Alias: None

FGDC Definition: None
Column: pro_pt_name
Description:
Protraction Point Name is a locational name for protraction points. It may reflect the name of actual surveys, such as the Alaska-Canadian International Boundary Survey.

FGDC Alias: None

FGDC Definition: None
Column: lat_meas
Description:
Protracted Point Latitude is the protracted latitude of a point on the polygon representing a protracted polygon in the NAD 27 datum.  It is formatted by degrees, minutes, decimal seconds (60 24 32.56 N).

FGDC Alias: None

FGDC Definition: None
Column: long_meas
Description:
Protracted Point Longitude is the longitude of a point on the polygon representing a protracted polygon in the NAD 27 datum. It is formatted by degrees, minutes, decimal seconds (149 24 32.56 W). Longitudes are stored as positive values (implied west longitude as opposed to actual value). East Longitudes are stored as west longitude values > 180 (implied east longitude (189 23 45.78 W).

FGDC Alias: None

FGDC Definition: None
Column: dlat_meas
Description:
Protracted Point Decimal Latitude is the protracted latitude of a point on the polygon representing a protracted polygon in the NAD 27 datum.  It is formatted by decimal degrees (60.243256).

FGDC Alias: None

FGDC Definition: None
Column: dlong_meas
Description:
Protracted Point Decimal Longitude is the longitude of a point on the polygon representing a protracted polygon in the NAD 27 datum. It is decimal degrees (-149.243256).

FGDC Alias: None

FGDC Definition: None
Column: objectid
Description:
This is a system field to identify a protracted point feature. This is the same as the pro_pt_id.

FGDC Alias: None

FGDC Definition: None
Column: shape
Description:
This stores the geospatial object representing the protracted point as a point feature in the NAD 27 datum. This represents the original (non-adjusted) coordinates.

FGDC Alias: None

FGDC Definition: None
Column: user_id
Description:
The system User ID of the person who entered the original data for this record.

FGDC Alias: None
FGDC Definition: None
Column: entered_date
Description:
The system date that the original data was entered for this record.

FGDC Alias: None
FGDC Definition: None
Column: modified_user_id
Description:
The system User ID of the person who modified the original data for this record.

FGDC Alias: None
FGDC Definition: None
Column: modified_date
Description:
The system date that the original data for this record was modified.

FGDC Alias: None
FGDC Definition: None

Trigger: ins_propt_objectid
Code Preview:
-- Populate objectid from primary key upon row insert
create trigger ins_propt_objectid 
insert on pro_pt
referencing new as new
for each row 
    (update pro_pt 
    set pro_pt.objectid = new.pro_pt_id
    where (pro_pt_id = new.pro_pt_id)
    );
/

Table: sec_pt
Description:
Relates a protracted section to the set of PLSS points that spatially describe that section. Most sections are spatially described with one polygon. A few sections are represented as multiple polygons. Section Polygon Number identifies the polygon that a point is describing.

A set of section points are sequentially ordered in a drawing order, with the first point repeated as last point, relative to a polygon.

In order to find the four corner points of a section or a specific corner, both the sec_pt and sec_cnstr_pt tables must be queried to ensure all valid corner points are found. Note that less than 1% of sections have construction points.

FGDC Alias: None

FGDC Definition: None
List of Columns:
Name	Code	Data Type	
Township Section Number	tin_sec_no	INTEGER	
Pro Point Id	pro_pt_id	INTEGER	
Township Index No	twp_tin_no	INTEGER	
Section PID No	sec_pt_pid_no	CHAR(6)	
Section Polygon Number	sec_pt_poly_no	SMALLINT	
Section Point Sequence No	sec_pt_seq_no	SMALLINT	
Section Point Quadrant Code	sec_pt_quad_cd	CHAR(2)	

Column: tin_sec_no
Description:
Unique identifier for a section in Alaska. Consists of a concatenation of township index number and the two digit, zero-filled section number. Note that while the township index  number is a five digit integer, it is not zero filled.

Ex: 133101

FGDC Alias: None

FGDC Definition: None
Column: pro_pt_id
Description:
Protraction Point Id is a system-generated id to uniquely identify a protracted point.

FGDC Alias: None

FGDC Definition: None
Column: twp_tin_no
Description:
Township TIN Number is an indexing system in Alaska for townships. Each township in the state has a unique 5 digit index number.

FGDC Alias: PLSS Township Id

FGDC Definition: The PLSS Township Id is a primary key which identifies each record in the Public Land Survey System Township entity.
Column: sec_pt_pid_no
Description:
Protracted PID Number is a numbering system for the PLSS rectangular grid, adopted by the BLM GCDB program nationally. The PID identifies the relative position of a point on the rectangular grid, within a given township. 100100 represents the southwest corner of a township. 700700 represents the northeast corner.

FGDC Alias: None

FGDC Definition: None
Column: sec_pt_poly_no
Description:
A sequential number identifying a polygon representing the spatial depiction of a Section. Most sections in Alaska have one polygon.

FGDC Alias: None

FGDC Definition: None
Column: sec_pt_seq_no
Description:
A number identifying the sequential ordering of points around a protracted polygon for a given section.

FGDC Alias: Sequence

FGDC Definition: The Sequence describes the location of the Corner within the Legal Area.
Column: sec_pt_quad_cd
Description:
Code that identifies the relative placement of a protraction corner point to a section. For instance, the southeast corner of a section is designated "SE". If this field is null, it implies it is not a corner point of the section.

FGDC Alias: None

FGDC Definition: None

Table: section
Description:
Protracted Section is a rectangular tract of land usually 1 mile square. It is a subdivision of a township. A protracted section's geometry and corner coordinates are mathmatically calculated from a protracted township. Corner coordinates do not represent surveyed positions, although they are used in determining surveyed positions.

FGDC Alias: PLSS Township First Division

FGDC Definition: Public Land Survey System Townships first divisions are normally Public Land Survey System Tracts or Public Land Survey System Sections. This entity is the primary or first subdivisions of a Public Land Survey System Township.
List of Columns:
Name	Code	Data Type	
Township Section Number	tin_sec_no	INTEGER	
Township Index No	twp_tin_no	INTEGER	
Section Number	sec_no	SMALLINT	
Section MTRS Code	sec_mtrs_txt	CHAR(13)	
Section Land Description Text	sec_desc_txt	CHAR(34)	
Section Protraction Origin Point Code	sec_org_point_cd	CHAR(2)	
Section Polygon Feature Id	objectid	INTEGER	
Section Polygon NAD27 Feature	shape	ST_MULTIPOLYGON	
Input User Id	user_id	CHAR(10)	
Date Input	entered_date	DATE	
Modification User Id	modified_user_id	CHAR(10)	
Date Modified	modified_date	DATE	

List of Triggers:
Name	Code	
ins_section_objectid	ins_section_objectid	

Column: tin_sec_no
Description:
Unique identifier for a section in Alaska. Consists of a concatenation of township index number and the two digit, zero-filled section number. Note that while the township index  number is a five digit integer, it is not zero filled.

Ex: 133101

FGDC Alias: None

FGDC Definition: None
Column: twp_tin_no
Description:
Township TIN Number is an indexing system in Alaska for townships. Each township in the state has a unique 5 digit index number.

FGDC Alias: PLSS Township Id

FGDC Definition: The PLSS Township Id is a primary key which identifies each record in the Public Land Survey System Township entity.
Column: sec_no
Description:
Section Number identifies a protracted "section" within a given township. Sections are generally numbered from 1-36.

FGDC Alias: PLSS Township First Division Suffix

FGDC Definition: The First Division Designator is the leter, number, or leter number combination that identifies the First Division.
Column: sec_mtrs_txt
Description:
This is a "zero filled" format description of a section. MTRS contains a formatted, concatenated grouping of meridian code, township, township direction, township fraction (if fractional), range, range direction, range fraction (if fractional), section number.

Ex: C017S011E01, C017[.5]S011[.5]E01

FGDC Alias: None

FGDC Definition: None
Column: sec_desc_txt
Description:
This is a label field for a section constructed by concatenating tier, range,  meridian and section number into a narrative description. 

The format is: SEC xx, Txxx{N/S}{2}, Rxxx{E/W}{2}, {C/S/F/K/U}M

Ex: SEC 10, T10N, R75W, SM

FGDC Alias: None

FGDC Definition: None
Column: sec_org_point_cd
Description:
Section Protraction Origin Point identifies which corner serves as the basis for protracting the aliquot part grid for that section. For instance, a SouthEast Origin Point means the aliquot part grid can be generated from the basis of the SouthEast corner of the section.

If the section is fractional (<> 640 ac), lots will be identified on the opposite portions of the section from the Origin Pt.

The Section Origin Point is most often the same as the Township Origin Point. It can vary where sections are fractional along boundaries other than the opposite boundaries from the Township Origin Point. This can occur along the Canadian border, or due to elongated sections or where merdians meet.

FGDC Alias: None

FGDC Definition: None
Column: objectid
Column: shape
Description:
This stores the geospatial objects representing the section as a multi-part polygon.

FGDC Alias: None

FGDC Definition: None
Column: user_id
Description:
The system User ID of the person who entered the original data for this record.

FGDC Alias: None

FGDC Definition: None
Column: entered_date
Description:
The system date that the original data was entered for this record.

FGDC Alias: None

FGDC Definition: None
Column: modified_user_id
Description:
The system User ID of the person who modified the original data for this record.

FGDC Alias: None

FGDC Definition: None
Column: modified_date
Description:
The system date that the original data for this record was modified.

FGDC Alias: None

FGDC Definition: None

Trigger: ins_section_objectid
Code Preview:
-- Populate objectid from primary key upon row insert
create trigger ins_section_objectid 
insert on section
referencing new as new
for each row 
    (update section 
    set section.objectid = new.tin_sec_no 
    where (tin_sec_no = new.tin_sec_no)
    );
/

Table: township
Description:
Township is a rectangular tract of land usually six miles square. It is identified by Principal Meridian. a row (tier or township), column (range), and direction from the meridian initial point. Township contains information about the protraction of a Township. 

FGDC Alias: Public Land Survey System Township

FGDC Definition: In the Public Land System a Township refers to a unit of land, that are nominally six miles on a side, usually containing 36 sections.

FGDC Business Rule: Public Land Survey SystemTownships will have a Public Land Survey System Origin and a State.
List of Columns:
Name	Code	Data Type	
Township Index No	twp_tin_no	INTEGER	
Meridian Cd	meridian_cd	CHAR(1)	
Protract Type Cd	pd_typ_cd	CHAR(1)	
Township Tier No	twp_tier_no	SMALLINT	
Township Direction	twp_dir_cd	CHAR(1)	
Township Fraction	twp_frac_cd	CHAR(1)	
Township Range No	twp_range_no	SMALLINT	
Township Range Direction	twp_range_dir_cd	CHAR(1)	
Township Range Fraction	twp_range_frc_cd	CHAR(1)	
Township MTR Code	twp_mtr_txt	CHAR(11)	
Township Description Text	twp_desc_txt	CHAR(22)	
Township Protraction Origin Point	twp_org_point_cd	CHAR(2)	
Township North Limit Section Grid Quantity	twp_nlimit_sec_qty	CHAR(1)	
Township Section South Limit	twp_slimit_sec_qty	CHAR(1)	
Township Section East Limit	twp_elimit_sec_qty	CHAR(1)	
Township Section West Limit	twp_wlimit_sec_qty	CHAR(1)	
Protraction Diagram Folio No	twp_pd_folio_no	CHAR(2)	
Protraction Sheet No	twp_pd_sheet_no	CHAR(3)	
Protraction Public Date	twp_pd_pub_date	DATE	
Township Polygon Feature Id	objectid	INTEGER	
Township NAD27 Polygon Feature	shape	ST_MULTIPOLYGON	
Input User Id	user_id	CHAR(10)	
Date Input	entered_date	DATE	
Modification User Id	modified_user_id	CHAR(10)	
Date Modified	modified_date	DATE	

List of Triggers:
Name	Code	
ins_twp_objectid	ins_twp_objectid	

Column: twp_tin_no
Description:
Township TIN Number is an indexing system in Alaska for townships. Each township in the state has a unique 5 digit index number.

FGDC Alias: PLSS Township Id

FGDC Definition: The PLSS Township Id is a primary key which identifies each record in the Public Land Survey System Township entity.
Column: meridian_cd
Description:
Meridian Code identifies a Principal Meridian in Alaska. There are five Principal Meridians in Alaska, each being unique to the state. They are Umiat, Fairbanks, Seward, Copper River, and Kateel River Meridians.

FGDC Alias: None

FGDC Definition: None
Column: pd_typ_cd
Description:
Protraction Diagram Type Code indicates the type of protraction, such as original, amended, or revised.

FGDC Alias: None

FGDC Definition: None
Column: twp_tier_no
Description:
Township Tier Number identifies the location, North or South, of a township from the Baseline.

FGDC Alias: Township Number

FGDC Definition: The Township Number indicates the number of rows of townships, north or south from a Public Land Survey System Origin.
Column: twp_dir_cd
Description:
Township Direction  indicates the direction the tier is relative to the Baseline.

FGDC Alias: Township Direction

FGDC Definition: The  direction of a row of Townships from a Public Land Survey System Origin.
Column: twp_frac_cd
Description:
Township Fraction indicates a type of township that is fractional in Tier dimensions due to the fit of the PLSS grid. 1/2 townships are fractional townships by definition.

FGDC Alias: Township Fraction

FGDC Definition: Township Fractions are created when there are gaps between surveyed Township boundaries or due to excess size in Townships that arose from executing original surveys.
Column: twp_range_no
Description:
Range Number identifies the location of a township east or west from the Principal Meridian.

FGDC Alias: Range Number

FGDC Definition: The Range Number indicates the number of columns of townships, east or west from a Public Land Survey System Origin.
Column: twp_range_dir_cd
Description:
Range Direction indicates the direction, East or West from the Principal Meridian.

FGDC Alias: Range Direction

FGDC Definition: The direction of a column of townships from a Public Land Survey System Origin.
Column: twp_range_frc_cd
Description:
Range Fraction is a type of township that is fractional in Range dimensions due to the fit of the PLSS grid. 1/2 Ranges are fractional ranges by definition.

FGDC Alias: Range Fraction

FGDC Definition: Fractions are created when there are gaps between surveyed Township boundaries or due to excess size in Townships that arose from executing original surveys.
Column: twp_mtr_txt
Description:
This is a "zero filled" format description of a township. MTR contains a formatted, concatenated grouping of meridian code, township, township direction, township fraction (if fractional), range, range direction, range fraction (if fractional).

Ex: C017S011E, C017[.5]S011[.5]E

FGDC Alias: None

FGDC Definition: None
Column: twp_desc_txt
Description:
This is a label field for a township constructed by concatenating tier, range and meridian into a narrative description. 

The format is: Txxx{N/S}{2}, Rxxx{E/W}{2}, {C/S/F/K/U}M

Ex: T10N, R75W, SM

FGDC Alias: None

FGDC Definition: None
Column: twp_org_point_cd
Description:
Protraction Origin Point identifies which corner serves as the basis for protracting the PLSS grid for that township. For instance, a SouthEast Origin Point generally means sections for that township were measured off at 80 chain intervals from the South East corner, leaving the remainder distance to the last row and column of the section grid.

FGDC Alias: None

FGDC Definition: None
Column: twp_nlimit_sec_qty
Description:
Section North Limit is used to indicate the northern row limit of section lines based on the protraction of the township from the point of origin.

FGDC Alias: None

FGDC Definition: None
Column: twp_slimit_sec_qty
Description:
Section South Limit is the is used to indicate the sourthern row limit of section lines based on the protraction of the township from the point of origin.

FGDC Alias: None

FGDC Definition: None
Column: twp_elimit_sec_qty
Description:
Section East Limit is used to indicate the eastern column limit of section lines based on the protraction of the township from the point of origin.

FGDC Alias: None

FGDC Definition: None
Column: twp_wlimit_sec_qty
Description:
Section West Limit is used to indicate the western column limit of section lines based on the protraction of the township from the point of origin.

FGDC Alias: None

FGDC Definition: None
Column: twp_pd_folio_no
Description:
Protraction Diagram Folio Number is a grouping of protraction diagram sheets. It forms part of the identification of a protraction diagram: Meridian, Folio, Sheet. (F 1-9).

FGDC Alias: None

FGDC Definition: None
Column: twp_pd_sheet_no
Description:
Protraction Diagram Sheet Number is a specific protraction diagram sheet. It forms part of  the identification of a protraction diagram: Meridian, Folio, Sheet (F 1-9). A protraction sheet is usually identified by a two-digit number. A suffix character may exist (13A).

FGDC Alias: None

FGDC Definition: None
Column: twp_pd_pub_date
Description:
Protraction Diagram Published Date is the date a protraction diagram was approved.

FGDC Alias: None

FGDC Definition: None
Column: objectid
Description:
This is a system field to identify a township polygon feature. This is the same as the township index number.

FGDC Alias: None

FGDC Definition: None
Column: shape
Description:
This stores the geospatial objects representing the township as a multi-part polygon.

FGDC Alias: None

FGDC Definition: None
Column: user_id
Description:
The system User ID of the person who entered the original data for this record.

FGDC Alias: None
FGDC Definition: None
Column: entered_date
Description:
The system date that the original data was entered for this record.

FGDC Alias: None
FGDC Definition: None
Column: modified_user_id
Description:
The system User ID of the person who modified the original data for this record.

FGDC Alias: None
FGDC Definition: None
Column: modified_date
Description:
The system date that the original data for this record was modified.

FGDC Alias: None
FGDC Definition: None

Trigger: ins_twp_objectid
Code Preview:
-- Populate objectid from primary key upon row insert
create trigger ins_twp_objectid 
insert on township
referencing new as new
for each row 
    (update township
    set township.objectid = new.twp_tin_no
    where (twp_tin_no = new.twp_tin_no)
    );
/

Table: twp_pt
Description:
Relates a protracted township to the set of PLSS points that spatially describe that township. Most townships are spatially described with one polygon. A few townships are represented as multiple polygons. Township Polygon Number identifies the polygon that a point is describing.

A set of township points are sequentially ordered in a drawing order, with the first point repeated as last point, relative to a polygon.

In order to find the four corner points of a township or a specific corner, both the sec_pt and sec_cnstr_pt tables must be queried to ensure all valid corner points are found. Note that less than 1% of townships have construction points.

FGDC Alias: None

FGDC Definition: None
List of Columns:
Name	Code	Data Type	
Township Index No	twp_tin_no	INTEGER	
Pro Point Id	pro_pt_id	INTEGER	
Township Point PID No	twp_pt_pid_no	CHAR(6)	
Township Point Polygon Number	twp_pt_poly_no	SMALLINT	
Township Point Sequence No	twp_pt_seq_no	SMALLINT	
Township Point Quadrant Code	twp_pt_quad_cd	CHAR(2)	

Column: twp_tin_no
Description:
Township TIN Number is an indexing system in Alaska for townships. Each township in the state has a unique 5 digit index number.

FGDC Alias: PLSS Township Id

FGDC Definition: The PLSS Township Id is a primary key which identifies each record in the Public Land Survey System Township entity.
Column: pro_pt_id
Description:
Protraction Point Id is a system-generated id to uniquely identify a protracted point.

FGDC Alias: None

FGDC Definition: None
Column: twp_pt_pid_no
Description:
Protracted PID Number is a numbering system for the PLSS rectangular grid, adopted by the BLM GCDB program nationally. The PID identifies the relative position of a point on the rectangular grid, within a given township. 100100 represents the southwest corner of a township. 700700 represents the northeast corner.

FGDC Alias: None

FGDC Definition: None
Column: twp_pt_poly_no
Description:
A sequential number identifying a polygon representing the spatial depiction of a Township. 

FGDC Alias: None

FGDC Definition: None
Column: twp_pt_seq_no
Description:
A number identifying the sequential ordering of points around a protracted polygon for a given township

FGDC Alias: Sequence

FGDC Definition: The Sequence describes the location of the Corner within the Legal Area.
Column: twp_pt_quad_cd
Description:
Code that identifies the relative placement of a protraction point to a township. For instance, the southeast corner of a township is designated "SE". If this field is null, it implies it is not a corner point of the township.

FGDC Alias: None

FGDC Definition: None