Property Ownership and Lease Tract ASCII Data Distribution Tape Format
Version 1.07
05/02/97
Table of Contents
| Table of Contents | 1 |
|
| File Delivery Description | 2 |
|
| Property Ownership Data Model | 3 |
|
| Property Ownership Header Table | 4 |
|
| Property Ownership Tract Table | 5 |
|
| Grantor/Grantee/Assignor/Assignee/Depth Table | 6 |
|
| Property Geopolitical Table | 7 |
|
| Property Tract Polygon Sequence Number Table | 9 |
|
| Property Annotations Table | 10 |
|
| Address Table (occurs three times in the models) | 11 |
|
| Property Tract Arc/Info Table | 12 |
|
| Digital Lease Data Model | 13 |
|
| Lease Header Table | 14 |
|
| Lease Tract Table | 15 |
|
| Lease Tract Arc/Info Table | 16 |
|
| Lease Annotations Table | 17 |
|
| Lease Annotation Relate Table | 18 |
|
| Lessor/Assignor/Depth Table | 19 |
|
| Lease Tract Geopolitical Table | 20 |
|
| Lease Tract Polygon Sequence Number Table | 21 |
|
| Lessee/Assignee/Depth Table | 22 |
Appendices
(includes cross-reference to TOBIN Survey Meridian Codes)
Legend
*** These fields form unique primary key
N Numeric field
D Date field
C Character field
I Integer field
TBD To Be Determined
Percentages are stored as 100% =1.000000000
File Delivery Description
TOBIN Property Ownership and Lease Tract records are made up entirely of printable ASCII characters.
No unnecessary blanks or zeros will be depicted in the data. Fields which are legitimately blank will be represented by two consecutive pipes. A blank field at the end of a table will contain only a line feed (or a line feed and carriage return for DOS machines).
Latitude/longitude coordinate locations will be carried to 6 decimal places. Latitude values in the southern hemisphere, and longitude values in the northern hemisphere, will be preceded by a negative sign. For example, the point 88.444111 west longitude and 33.555000 north latitude would be represented in a pipe file as "|33.555000|-88.444111|".
Dates will be 8-character numeric fields of the form "YYYYMMDD", where YYYY is the year, MM is the month ("01" is January, "12" is December, etc.), and DD is the day of the month from "01" to "31".
The following Lease Database Model files are included in all lease and property data deliveries:
Property file names:
Property Ownership Header stctypa.hdr
Property Ownership Tract stctypa.tct
Grantor/Grantee/Assignor/Assignee/Depth stctypa.gtr
Property Geopolitical table stctypa.geo
Property Tract Polygon Sequence number stctypa.seq
Property Annotations stctypa.ann
Lease file names:
Lease header stctyla.hdr
Lease Tract stctyla.tct
Lessor/Assignor/Depth stctyla.lsr
Lease Tract Geopolitical table stctyla.geo
Lease Tract Polygon Sequence number stctyla.seq
Lessee/Assignee/Depth stctyla.lse
Lease Annotation Points stctyla.ann
Property Ownership DataModel
| (relationship) | ||||||
|
(one) |
PROPERTY OWNERSHIP TABLE PCN#
|
|||||
½ |
||||||
½ |
||||||
½ |
||||||
| (many)
|
TRACT TABLE PCN# / PTCN#
|
|||||
½ |
||||||
| (many) | ½ |
|||||
½ |
½ |
½ |
½ |
|||
½ |
½ |
½ |
½ |
|||
GRANTOR/DEPTH TABLE PCN# / PTCN#
|
GEOPOLITICAL PCN#, PTCN#, POLY#
|
POLY SEQ # |
GEOGRAPHICAL DESCRIPTION USING PCN# / PTCN#
|
|||
½ |
||||||
½ |
||||||
½ |
||||||
ADDRESS TABLE
|
(many)
|
|||||
Property Ownership Header Table
| Field | Field | Decimal | Field | Field |
| Type | Length | Places | Name | Description |
| C | 11 | PCN | Property Control Number (unique) | |
| C | 15 | AGENCY_ID | Agency identification number | |
| I | 2 | AGENCY_TYPE | Agency type number | |
| C | 15 | APPRAISAL_DIST | Appraisal District identification number | |
| I | 2 | ATTRIBUTE_META | Source for the attribute data | |
| D | 8 | REVISION_DATE | Last update to the data | |
| C | 1 | REVISION_TYPE | Type of update being provided | |
| N | 10 | 3 | DEED_ACRES | Acres reported on the deed document |
| N | 10 | 3 | CALC_ACRES | The sum of the calculated acres that make up the tracts of the property ownership polygon. |
| N | 9 | 6 | SW_LAT_OWN | Southwest latitude corner of the property ownership polygon. |
| N | 11 | 6 | SW_LONG_OWN | Southwest longitude corner of the property ownership polygon. |
| N | 9 | 6 | NE_LAT_OWN | Northeast latitude corner of the property ownership polygon. |
| N | 11 | 6 | NE_LONG_OWN | Northeast longitude corner of the property ownership polygon. |
| D | 8 | OWN_DATE | Instrument date of the deed document | |
| D | 8 | CAPTURE_DATE | TOBIN capture date of the deed document |
Property Ownership Tract Table
| Field | Field | Decimal | Field | Field |
| Type | Length | Places | Name | Description |
| C | 11 | *** PCN | Property Control Number (unique) | |
| C | 3 | *** PTCN | Property Tract Control Number (unique) | |
| I | 3 | POLY_SEQ_ID | Tract polygon sequence number | |
| C | 2 | STATUS_TR | Property status of the tract | |
| D | 8 | EXT_DATE | Extension date of the tract | |
| D | 8 | ACQ_DATE | Acquisition date of the tract | |
| N | 9 | 6 | SW_LAT_TRACT | Southwest latitude corner of the tract |
| N | 11 | 6 | SW_LONG_TRACT | Southwest longitude corner of the tract |
| N | 9 | 6 | NE_LAT_TRACT | Northeast latitude corner of the tract |
| N | 11 | 6 | NE_LONG_TRACT | Northeast longitude corner of the tract |
| N | 10 | 3 | CALC_ACRES | Calculated acres for the tract polygon |
Grantor/Grantee/Assignor/Assignee/Depth Table
| Field | Field | Decimal | Field | Field |
| Type | Length | Places | Name | Description |
| C | 11 | *** PCN | Property Control Number (unique) | |
| C | 3 | *** PTCN | Property Tract Control Number (unique) | |
| C | 40 | GRANTOR_NAME | Grantor name on deed document | |
| C | 40 | ASSIGNR_NAME | Assignor name | |
| C | 8 | ADDRESS_ID_OR | Address identification number | |
| I | 6 | GROUP_ID_OR | Group identification for multiple Grantors/Assignors | |
| D | 8 | DATE_OPEN_OR | Date of ownership | |
| D | 8 | DATE_CLOSE_OR | Date ownership transferred | |
| C | 40 | GRANTEE_NAME | Grantee name on deed document | |
| C | 40 | ASSIGNE_NAME | Assignee name | |
| C | 8 | ADDRESS_ID_EE | Address identification number | |
| I | 6 | GROUP_ID_EE | Group identification for multiple Grantees/Assignees | |
| D | 8 | DATE_OPEN_EE | Date of ownership | |
| D | 8 | DATE_CLOSE_EE | Date ownership transferred | |
| N | 9 | 7 | SURF_INT | Surface ownership interest percentage |
| N | 9 | 7 | MIN_INT | Mineral interest percentage |
| C | 1 | UNIT_DEPTH | Units of measurement describing the depth | |
| I | 8 | FROM_DEPTH | Starting depth of the tract | |
| C | 8 | FROM_FORM | Starting formation of the tract | |
| C | 35 | FROM_FORM_NAME | Starting formation name of the tract | |
| C | 1 | INDICATOR_FROM | Where in the starting depth | |
| I | 8 | TO_DEPTH | Ending depth of the tract | |
| C | 8 | TO_FORM | Ending formation of the tract | |
| C | 35 | TO_FORM_NAME | Ending formation name of the tract | |
| C | 1 | INDICATOR_TO | Where in the ending depth | |
| C | 40 | RESTRICT_DEPTH | Restriction of the depth |
Property geopolitical table
| Field | Field | Decimal | Field | Field |
| Type | Length | Places | Name | Description |
| C | 11 | *** PCN | Property Control Number (unique) | |
| C | 3 | *** PTCN | Property Tract Control Number (unique) | |
| I | 3 | POLY_SEQ_ID | Tract polygon sequence number | |
| I | 2 | ST_CODE | State code | |
| I | 3 | CTY_CODE | County code | |
| C | 3 | SURVEY_TYPE | Type of survey system for the tract, Jeffersonian, Carter, Texas, Offshore |
Carter or Jeffersonian:
| C | 60 | GRANT | Grant name | |
| I | 3 | MERIDIAN | Survey system | |
| C | 10 | TOWNSHIP_NAME | Township number or name | |
| C | 1 | TOWNSHIP_DIR | Township direction | |
| C | 10 | RANGE_NAME | Range number or name | |
| C | 1 | RANGE_DIR | Range direction | |
| C | 10 | SEC_NAME | Section number, name or tract |
Dominion System: (TBD)
Offshore:
| C | 10 | AREA_NAME | Area name | |
C |
10 | OFF_BLOCK_NAME | Offshore block name |
Texas:
| C | 4 | RRD_NUM | Railroad District Number | |
| C | 60 | SURVEY_NAME | Survey name | |
| C | 8 | TX_BLOCK_NAME | Texas block name | |
| C | 60 | GRANTEE | Grantee name | |
| C | 1 | LEAGUE_FLAG | League flag (When populated, League Name can be found in the SURVEY_NAME field) | |
| C | 8 | TX_SEC_NAME | Texas section number, name or tract | |
| C | 8 | ABSTRCT_NUM | Abstract / Scrap number |
Property geopolitical table
(Cont.)
Additional Survey Nomenclature:
(The following fields are provided for any of the above survey type)
| CLot / Quartering description | ||||||
| C | 132 | METE_BOUND | Free form mete and bound description (TBD) | |||
| C | 8 | TRACT_NUM | Tract number | |||
| C | 8 | LOT_NUM | Lot number | |||
| C | 8 | SLOT_NUM | Sub-lot number | |||
Property Tract Polygon Sequence Number Table
| Field | Field | Decimal | Field | Field |
| Type | Length | Places | Name | Description |
| C | 11 | *** PCN | Property Control Number (unique) | |
| C | 3 | *** PTCN | Property Tract Control Number (unique) | |
| I | 3 | POLY_SEQ_ID | Tract polygon sequence number | |
| I | 2 | SEQ_ID | Agency tract sequence number | |
| I | 2 | ST_CODE | State Code | |
| I | 3 | CTY_CODE | County Code | |
| C | 3 | SURVEY_TYPE | Type of survey system for the tract | |
| D | 8 | RCD_DATE | Recording date | |
| C | 10 | VOLUME | Volume of recording in the courthouse | |
| C | 10 | BOOK | Book of recording in the courthouse | |
| C | 4 | PAGE | Page of recording in the courthouse | |
| C | 20 | FILE | File of recording in the courthouse | |
| D | 8 | REVISION_DATE | Last update to the data | |
| C | 1 | REVISION_TYPE | Type of update being provided | |
| I | 2 | ATTRIBUTE_META | Source for the attribute data | |
| I | 2 | POLY_META | Source for the polygon data |
Address Table
| Field | Field | Decimal | Field | Field |
| Type | Length | Places | Name | Description |
| C | 8 | ADDRESS_ID | Address identification number | |
| C | 40 | NAME | Grantor, Grantee, Lessor, Lessee, Assignor or Assignee names | |
| C | 40 | ADDRESS_1 | First line of the address | |
| C | 40 | ADDRESS_2 | Second line of the address | |
| C | 40 | ADDRESS_3 | Third line of the address | |
| C | 40 | CONTACT_PERSON | Person to be contracted | |
| N | 9 | ZIP_CODE | Zip code for the address | |
| N | 10 | PHONE_NUM | Phone number for the contact | |
| D | 8 | REVISION_DATE | Revision date |
Property Tract Info Table
Information in an Arc/Info region format with a tract sub-class region and associated attribute information:
| Field | Field | Decimal | Field | Field |
| Type | Length | Places | Name | Description |
| Tract region subclass: | ||||
| C | 11 | *** PCN | Property Control Number (unique) | |
| C | 3 | *** PTCN | Property Tract Control Number (unique) | |
| I | 3 | POLY_SEQ_ID | Tract polygon sequence number |
*** These fields combine to create PCN_ID, the concatenated 14 - digit string.
Annotation layer sub-classes:
IGDS
PROPERTY ANNOTATIONS TABLE
| Field | Field | Decimal | Field | Field |
| Type | Length | Places | Name | Description |
| I | 10 | Anno_ID | Annotation Identifier | |
| N | 11 | 6 | Anno_Long | Longitude for Annotation Anchor Point |
| N | 9 | 6 | Anno_Lat | Latitude for Annotation Anchor Point |
| N | 11 | 6 | Anno_Rotate | Rotation for Annotation String |
| N | 8 | 6 | Anno_Size | Size of Characters in
Annotation String |
| C | 99 | Anno_Text | Annotation Text String | |
Digital Lease Data Model
| (Relationship) | ||||||||
| (one) |
LEASE HEADER TABLE LCN# |
|||||||
| |
| |
|||||||
| (many) |
TRACT TABLE LCN# / LTCN# |
GEOGRAPHICAL DESCRIPTION USING LCN#
|
||||||
| |
| |
|||||||
| |
| |
|||||||
| |
| |
(many) |
| |
| |
||||
| |
| |
| |
| |
| |
||||
LESSOR / DEPTH TABLE LCN# / LTCN# |
GEOPOLITICAL LCN#, LTCN#, POLY# |
POLY SEQ# |
LESSEE / DEPTH TABLE LCN# / LTCN# |
GEOGRAPHICAL DESCRIPTION USING LCN# / LTCN# |
||||
| |
| |
|||||||
ADDRESS TABLE |
(many) |
ADDRESS TABLE |
(many) |
|||||
Lease Header Table
| Field | Field | Decimal | Field | Field |
| Type | Length | Places | Name | Description |
| C | 11 | LCN | Lease Control Number (unique) | |
| C | 15 | AGENCY_ID | Agency identification number | |
| I | 2 | AGENCY_TYPE | Agency type | |
| C | 15 | APPRAISAL_DIST | Appraisal District identification number | |
| I | 2 | ATTRIBUTE_META | Source for the attribute data | |
| D | 8 | REVISION_DATE | Last update to the data | |
| C | 1 | REVISION_TYPE | Type of update being provided | |
| N | 10 | 3 | DEED_ACRES | Acres reported on the lease document |
| N | 10 | 3 | CALC_ACRES | The sum of the calculated acres that make up the tracts of that lease |
| I | 2 | NUM_TRACTS | Number of tracts for the lease | |
| N | 9 | 6 | SW_LAT_LSE | Southwest latitude corner of the lease |
| N | 11 | 6 | SW_LONG_LSE | Southwest longitude corner of the lease |
| N | 9 | 6 | NE_LAT_LSE | Northeast latitude corner of the lease |
| N | 11 | 6 | NE_LONG_LSE | Northeast longitude corner of the lease |
| C | 2 | LSE_TYPE | Type of lease ownership | |
| D | 8 | EFF_DATE | Effective date of the lease | |
| D | 8 | EXPR_DATE | Expiration date of the lease document | |
| D | 8 | INSTR_DATE | Instrument date of the lease document | |
| D | 8 | CAPTURE_DATE | TOBIN capture date of the lease document | |
| C | 1 | TERM_UNIT | Units describing the term of the lease | |
| D | 8 | TERM_DATE | Lease term | |
| N | 12 | 2 | BONUS_AMT | Bonus amount on the lease document |
| N | 12 | 2 | RENT_AMT | Rental amount on the lease document |
| N | 11 | 9 | ROY_PERCENT | Percentage of royalty on the lease document |
Lease Tract Table
| Field | Field | Decimal | Field | Field |
| Type | Length | Places | Name | Description |
| C | 11 | *** LCN | Lease Control Number (unique) | |
| C | 3 | *** LTCN | Lease Tract Control Number (unique) | |
| I | 3 | POLY_SEQ_ID | Tract polygon sequence number | |
| C | 2 | STATUS_TR | Lease status of the tract | |
| D | 8 | EXT_DATE | Extension date of the tract | |
| N | 9 | 6 | SW_LAT_TRACT | Southwest latitude corner of the tract |
| N | 11 | 6 | SW_LONG_TRACT | Southwest longitude corner of the tract |
| N | 9 | 6 | NE_LAT_TRACT | Northeast latitude corner of the tract |
| N | 11 | 6 | NE_LONG_TRACT | Northeast longitude corner of the tract |
| N | 10 | 3 | CALC_ACRES | Calculated acres for the tract polygon |
LEASE ANNOTATION RELATE TABLE
| Field | Field | Decimal | Field | Field |
| Type | Length | Places | Name | Description |
| I | 10 | Anno_ID | Annotation Identifier | |
| C | 11 | LCN | Lease Control Number | |
| C | 3 | LTCN | Lease Tract Control Number | |
TABLE LEASE ANNOTATIONS
| Field | Field | Decimal | Field | Field |
| Type | Length | Places | Name | Description |
| I | 10 | Anno_ID | Annotation | |
| N | 11 | 6 | Anno_Long | Longitude for Annotation Anchor Point |
| N | 9 | 6 | Anno_Lat | Latitude for Annotation Anchor Point |
| N | 11 | 6 | Anno_Rotate | Rotation for Annotation String |
| N | 8 | 6 | Anno_Size | Size of Characters in
Annotation String |
| C | 99 | Anno_Text | Annotation Text String | |
Lease Tract Arc/Info Table
Information in an Arc/Info region format with sub-classes (called "tract" and "lease") and associated attribute information.
| Field | Field | Decimal | Field | Field |
| Type | Length | Places | Name | Description |
| Lease region sub-class: | ||||
| C | 11 | LCN | Lease Control Number (unique) | |
| Tract region sub-class: | ||||
| C | 11 | *** LCN | Lease Control Number (unique) | |
| C | 3 | *** LTCN | Lease Tract Control Number (unique) | |
| I | 3 | POLY_SEQ_ID | Tract polygon sequence number |
*** These fields combine to create LCN_ID, the concatenated 14 - digit string.
Annotation layer sub-classes:
IGDS
To describe those areas in the lease coverage that are between or within regions, but are not leased, we will populate the appropriate fields with zeros. This will occur in the Lease Control Number (LCN) and the Lease Tract Control Number (LTCN) fields where the two combine to form a unique primary key (LCN_ID). The combined field length in this case will be 14.
Lessor/assignor/depth table
| Field | Field | Decimal | Field | Field |
| Type | Length | Places | Name | Description |
| C | 11 | *** LCN | Lease Control Number (unique) | |
| C | 3 | ***LTCN | Lease Tract Control Number (unique) | |
| C | 40 | LESSOR_NAME | Lessor name on the lease document | |
| C | 40 | ASSIGNR_NAME | Assignor name | |
| C | 8 | ADDRESS_ID | Address identification number | |
| I | 6 | GROUP_ID | Group identification for multiple Lessors/Assignors | |
| D | 8 | DATE_OPEN | Date of ownership | |
| D | 8 | DATE_CLOSE | Date ownership transferred | |
| N | 9 | 7 | MIN_INT | Mineral interest percentage |
| C | 1 | UNIT_DEPTH | Units of measurement describing the depth | |
| I | 8 | FROM_DEPTH | Starting depth of the tract | |
| C | 8 | FROM_FORM | Starting formation of the tract | |
| C | 35 | FROM_FORM_NAME | Starting formation name of the tract | |
| C | 1 | INDICATOR_FROM | Where in the starting depth | |
| I | 8 | TO_DEPTH | Ending depth of the tract | |
| C | 8 | TO_FORM | Ending formation of the tract | |
| C | 35 | TO_FORM_NAME | Ending formation name of the tract | |
| C | 1 | INDICATOR_TO | Where in the ending depth | |
| C | 40 | RESTRICT_DEPTH | Restriction of the depth |
Lease Tract geopolitical table
| Field | Field | Decimal | Field | Field |
| Type | Length | Places | Name | Description |
| C | 11 | *** LCN | Lease Control Number (unique) | |
| C | 3 | *** LTCN | Lease Tract Control Number (unique) | |
| I | 3 | POLY_SEQ_ID | Tract polygon sequence number | |
| I | 2 | ST_CODE | State code | |
| I | 3 | CTY_CODE | County code | |
| C | 3 | SURVEY_TYPE | Type of survey system for the tract Jeffersonian, Carter, Texas, Offshore |
Carter or Jeffersonian:
| C | 60 | GRANT | Grant name | |
| I | 3 | MERIDIAN | Survey system | |
| C | 10 | TOWNSHIP_NAME | Township number or name | |
| C | 1 | TOWNSHIP_DIR | Township direction | |
| C | 10 | RANGE_NAME | Range number or name | |
| C | 1 | RANGE_DIR | Range direction | |
| C | 10 | SEC_NAME | Section number, name or tract |
Dominion System: (TBD)
Offshore:
| C | 10 | AREA_NAME | Area name | |
C |
10 | OFF_BLOCK_NAME | Offshore block name |
Texas:
| C | 4 | RRD_NUM | Railroad District Number | |
| C | 60 | SURVEY_NAME | Survey name | |
| C | 8 | TX_BLOCK_NAME | Texas block name | |
| C | 60 | GRANTEE | Grantee name | |
| C | 1 | LEAGUE_FLAG | League flag (When populated, League Name can be found in the SURVEY_NAME field) | |
| C | 8 | TX_SEC_NAME | Texas section number, name or tract | |
| C | 8 | ABSTRCT_NUM | Abstract / Scrap number |
Lease Tract geopolitical table
(cont).
Additional Survey Nomenclature:
(The following fields are provided for any of the above survey type)
| C | 132 | QTR_QTR | Lot / Quartering description | |
| C | 132 | METE_BOUND | Free form mete and bound description (TBD) | |
| C | 8 | TRACT_NUM | Tract number | |
| C | 8 | LOT_NUM | Lot number | |
| C | 8 | SLOT_NUM | Sub-lot number |
Lease Tract Polygon Sequence Number Table
| Field | Field | Decimal | Field | Field |
| Type | Length | Places | Name | Description |
| C | 11 | *** LCN | Lease Control Number (unique) | |
| C | 3 | *** LTCN | Lease Tract Control Number (unique) | |
| I | 3 | POLY_SEQ_ID | Tract polygon sequence number | |
| I | 2 | SEQ_ID | Agency tract sequence number | |
| I | 2 | ST_CODE | State code | |
| I | 3 | CTY_CODE | County Code | |
| C | 3 | SURVEY_TYPE | Type of survey system for the tract | |
| D | 8 | RCD_DATE | Recording date | |
| C | 10 | VOLUME | Volume of recording in the courthouse | |
| C | 10 | BOOK | Book of recording in the courthouse | |
| C | 4 | PAGE | Page of recording in the courthouse | |
| C | 20 | FILE | File of recording in the courthouse | |
| D | 8 | REVISION_DATE | Last update to the data | |
| C | 1 | REVISION_TYPE | Type of update being provided | |
| I | 2 | ATTRIBUTE_META | Source for the attribute data | |
| I | 2 | POLY_META | Source for the polygon data |
Lessee/Assignee/Depth Table
| Field | Field | Decimal | Field | Field |
| Type | Length | Places | Name | Description |
| C | 11 | *** LCN | Lease Control Number (unique) | |
| C | 3 | ***LTCN | Lease Tract Control Number (unique) | |
| C | 40 | LESSEE_NAME | Lessee name on the lease document | |
| C | 8 | ADDRESS_ID | Address identification number | |
| I | 6 | GROUP_ID | Group identification for multiple Lessees/Assignees | |
| D | 8 | DATE_OPEN | Date of ownership | |
| D | 8 | DATE_CLOSE | Date ownership transferred | |
| C | 1 | UNIT_DEPTH | Units of measurement describing the depth | |
| I | 8 | FROM_DEPTH | Starting depth of the tract | |
| C | 8 | FROM_FORM | Starting formation of the tract | |
| C | 35 | FROM_FORM_NAME | Starting formation name of the tract | |
| C | 1 | INDICATOR_FROM | Where in the starting depth | |
| I | 8 | TO_DEPTH | Ending depth of the tract | |
| C | 8 | TO_FORM | Ending formation of the tract | |
| C | 35 | TO_FORM_NAME | Ending formation name of the tract | |
| C | 1 | INDICATOR_TO | Where in the ending depth | |
| C | 40 | RESTRICT_DEPTH | Restriction of the depth | |
| C | 40 | ASSIGNE_NAME | Assignee name | |
| C | 2 | ASSIGN_TYPE | Assignee type record/working interest | |
| N | 10 | 8 | WORK_INT | Working interest percentage |
| N | 10 | 8 | ORR_INT | Over-riding royalty percentage |
| N | 10 | 3 | NET_ACRES | Net acres for the assignee |
| N | 10 | 8 | NRI_ASIGN | Net revenue interest per assignee |
Appendix A
USGS, TOBIN JEFFERSONIAN SURVEY MERIDIAN CODE CROSS REFERENCE
USGS |
TOBIN |
MERIDIAN | ||
Code |
Code |
Name | ||
01 |
37 |
1st Principal 1799 | ||
01 |
46 |
1st Principal 1819 | ||
02 |
28 |
2nd Principal 1805 | ||
03 |
27 |
3rd Principal 1805 | ||
04 |
26 |
4th Principal 1815 | ||
05 |
9 |
5th Principal 1815 | ||
06 |
11 |
6th Principal 1855 | ||
07 |
10 |
Black Hills 1878 | ||
08 |
7 |
Boise 1867 | ||
09 |
32 |
Chickasaw 1833 | ||
10 |
31 |
Choctaw 1821 | ||
11 |
22 |
Cimarron 1881 | ||
12 |
5 |
Copper River 1905 | ||
13 |
3 |
Fairbanks 1910 | ||
14 |
19 |
Gila and Salt Lake 1865 | ||
15 |
17 |
Humboldt 1853 | ||
16 |
34 |
Huntsville 1807 | ||
17 |
23 |
Indian 1870 | ||
18 |
24 |
Louisiana 1807 | ||
19 |
36 |
Michigan 1815 | ||
20 |
8 |
Montana 1867 | ||
21 |
16 |
Mount Diablo 1851 | ||
22 |
20 |
Navajo 1869 | ||
23 |
21 |
New Mexico 1855 | ||
24 |
30 |
St. Helena 1819 | ||
25 |
33 |
St. Stephens 1805 | ||
26 |
14 |
Salt Lake 1855 | ||
27 |
18 |
San Bernardino 1852 | ||
28 |
4 |
Seward 1911 | ||
29 |
35 |
Tallahassee 1824 | ||
30 |
13 |
Uinta Special 1875 | ||
31 |
15 |
Ute 1880 | ||
32 |
29 |
Washington 1803 | ||
33 |
6 |
Willamette 1851 | ||
34 |
12 |
Wind River 1875 | ||
37 |
44 |
Muskingum River 1800 | ||
42 |
45 |
Ellicott’s 1785 | ||
43 |
43 |
Twelve Miles Square 1805 | ||
44 |
2 |
Kateel River 1956 | ||
45 |
1 |
Umiat 1956 | ||
46 |
25 |
4th Principal 1831 |
Appendix A
USGS, TOBIN JEFFERSONIAN SURVEY MERIDIAN CODE CROSS REFERENCE
USGS |
TOBIN |
MERIDIAN | ||
Code |
Code |
Name | ||
xx |
38 |
Territory North of River 1798 | ||
xx |
40 |
Symmes Purchase/Miami 1802 | ||
xx |
41 |
Scioto 1799 | ||
xx |
39 |
Territory East of River 1802 | ||
48 |
42 |
Ohio 1797 | ||
105 |
TBD |
Sisseton Indian Reservation | ||
123 |
221 |
Ute Indian Reservation | ||
205 |
TBD |
Sisseton Indian Reservation | ||
xx |
90 |
Tennessee | ||
xx |
91 |
Kentucky | ||
xx |
124 |
Louisiana |
A value of "xx" means the USGS has not assigned a code to that area.
Note:
At some point in the future, meridian codes for the TOBIN Jeffersonian survey data layers will be modified to adhere to the USGS Jeffersonian survey meridian codes.
Appendix B
Values related to various tables within the TOBIN Property Ownership and Lease Data Database Model:
| Attribute / Field Name | Values | Table (s) |
| ATTRIBUTE_META | 1 = Midland Map 2 = Tobin Map 3 = Tobin LRS |
PROPERTY OWNERSHIP HEADER |
| PROPERTY TRACT POLYGON SEQUENCE NUMBER | ||
| LEASE HEADER | ||
| LEASE TRACT POLYGON SEQUENCE NUMBER | ||
| REVISION_TYPE | I = Initial issue | PROPERTY OWNERSHIP HEADER |
| PROPERTY TRACT POLYGON SEQUENCE NUMBER | ||
| LEASE HEADER | ||
| LEASE TRACT POLYGON SEQUENCE NUMBER | ||
| TERM_UNIT | M = Months Y = Years D = Days NULL = Unknown |
LEASE HEADER |
| STATUS_TR | AL = Active Lease | PROPERTY OWNERSHIP TRACT |
| LEASE TRACT | ||
| UNIT_DEPTH | F = Feet | GRANTOR/GRANTEE/ ASSIGNOR/ASSIGNEE/ DEPTH |
| LESSOR/ASSIGNOR/DEPTH | ||
| LESSEE/ASSIGNEE/DEPTH |
Appendix B
Values related to various tables within the TOBIN Property Ownership and Lease Data Database Model:
| Attribute / Field Name | Values | Table (s) |
| SURVEY_TYPE | JEF = Jeffersonian (includes Alaska Onshore) | PROPERTY GEOPOLITICAL |
| CAR = Carter TEX = Texas |
PROPERTY TRACT POLYGON SEQUENCE NUMBER | |
| Offshore Types: | ||
| GOM = Gulf of Mexico ATL = Atlantic |
LEASE TRACT GEOPLITICAL | |
| PAC = Pacific ALK = Alaska Offshore DOM = Dominion (Canada) |
LEASE TRACT POLYGON SEQUENCE NUMBER | |
| POLY_META | 1 = Midland Map 2 = Tobin Map |
PROPERTY TRACT POLYGON SEQUENCE NUMBER |
| LEASE TRACT POLYGON SEQUENCE NUMBER |
Version 1.07
05/02/97