Return to Data Formats

Tobin Property Ownership and Lease Tract Data Model

TOBIN International, Ltd.
1626 Broadway, Suite 500
Denver, Colorado 80202-4725
(303) 831-3555


March, 1997

1.Table of Contents

Topic

Section

Table of Contents

1

File Delivery Description

2

Property Ownership Data Model

3

Property Ownership Header Model

4

Property Ownership Tract Table

5

Grantor/Grantee/Assignor/Assignee/Depth Table

6

Property Geopolitical Table

7

Property Tract Polygon Sequence Number Table

8

Property Annotations Table

9

Address Table (occurs three times in the models)

10

Property Tract ARC/INFO Table

11

Digital Lease Data Model

12

Lease Header Table

13

Lease Tract Table

14

Lease Tract ARC/INFO Table

15

Lease Annotations Table

16

Lease Annotations Relate Table

17

Lessor/Assignor/Depth Table

18

Lease Tract Geopolitical Table

19

Lease Tract Polygon Sequence Number Table

20

Lessee/Assignee/Depth Table

21

 

2.File Delivery Description

 

3. Property Ownership Data Model

ownlse01.gif (8197 bytes)

 

3. Property Ownership Header Table

Field Type Field Length Decimal Places Field Name Field Descriptions
C 11 n/a PCN Property Control Number (unique)
C 15 n/a AGENCY_ID Agency identification number
I 2 n/a AGENCY_TYPE Agency type number
C 15 n/a APPRAISAL_DIST Appraisal District identification number
I 2 n/a ATTRIBUTE_META Source for the attribute data
D 8 n/a REVISION_DATE Last update to the data
C 1 n/a 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.

 

4. Property Ownership Tract Table

Field Type Field Length Decimal Places Field Name Field Descriptions
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

 

5. Grantor/Grantee/Assignor/Assignee/Depth Table

Field Type Field Length Decimal Places Field Name Field Descriptions
C 11 - *** PCN Property Control Number (unique)
C 3 - *** PTCN Property Tract Control Number (unique)
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

 

6. Property Geopolitical Table

Field Type Field Length Decimal Places Field Name Field Descriptions
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

 

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

 

7. Property Tract Polygon Sequence Number Table

Field Type Field Length Decimal Places Field Name Field Descriptions
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 - 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

 

8. Address Table

Field Type Field Length Decimal Places Field Name Field Descriptions
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

Information in an Arc/Info region format with a tract sub-class region and associated attribute information:

 

9. Property Tract Info Table

Field Type Field Length Decimal Places Field Name Field Descriptions
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

 

10. Property Annotations Table

Field Type Field Length Decimal Places Field Name Field Descriptions
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

 

11. Lease Header Table

Field Type Field Length Decimal Places Field Name Field Descriptions
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

 

12. Lease Tract Table

Field Type Field Length Decimal Places Field Name Field Descriptions
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

 

Digital Lease Data Model

ownlse02.gif (10083 bytes)

 

 

13. Lease Annotation Relate Table

Field Type Field Length Decimal Places Field Name Field Descriptions
I 10 - Anno_ID Annotation Identifier
C 11 - LCN Lease Control Number
C 3 - LTCN Lease Tract Control Number

 

14. Table Lease Annotations

Field Type Field Length Decimal Places Field Name Field Descriptions
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 Annontation String
C 99 - Anno_Text Annotation Text String

Information in an Arc/Info region format with sub-classes (called "tract" and "lease") and associated attribute information.

 

15. Lease Tract ARC/INFO Table

Field Type Field Length Decimal Places Field Name Field Descriptions
C 11 - LCN Lease Control Number (unique)
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.

 

16. Lessor/Assignor/Depth Table

Field Type Field Length Decimal Places Field Name Field Descriptions
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

 

17. Lease Tract Geopolitical Table

Field Type Field Length Decimal Places Field Name Field Descriptions
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

 

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

 

18. Lease Tract Polygon Sequence Number Table

Field Type Field Length Decimal Places Field Name Field Descriptions
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 - 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

 

19. Lessee/Assignee/Depth Table

Field Type Field Length Decimal Places Field Name Field Descriptions
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 Lessess/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_FORM 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

 

21. Appendix A

USGS, Tobin Jeffersonian Survey Meridian Code Cross Reference

USGS Code Tobin Code Meridian 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 15 Washington 1803
33 6 Willamette 1851
34 12 Wind River 1800
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

 

21. Appendix A

USGS, Tobin Jeffersonian Survey Meridian Code Cross Reference

USGS Code Tobin Code Meridian 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 Louisianna

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

 

Appendix B

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
SURVEY_TYPE JEF=Jeffersonian
(includes Alaska Onshore)
CAR=Carter
TEX=Texas

Offshore Types:
GOM=Gulf of Mexico
ATL=Atlanta
PAC=Pacific
ALK=Alaska Offshore
DOM=Dominion
(Canada)
PROPERTY GEOPOLITICAL

PROPERTY TRACT POLYGON
SEQUENCE NUMBER

LEASE TRACT GEOPOLITICAL

LEASE TRACT POLYGON
SEQUENCE NUMBER
POLY_META 1=Midland Map
2=Tobin Map
PROPERTY TRACT POLYGON
SEQUENCE NUMBER

LEASE TRACT POLYGON
SEQUENCE NUMBER

 

©2002 Tobin International, Ltd. All Rights Reserved Worldwide