Skip To Navigation Exiting Navigation

Joyce Morgan, CFA

Content

Real Estate Layout

Duval County Real Estate Combined File Layout

Pipe Delimited (TXT)

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000011Row Type Identifier



2Parcel Number (Real Estate Number)
PARCELSTRAP

3Section
DETAILSECTION

4Township
DETAILTOWNSHIP

5Range
DETAILRANGE

6Tile Number
DETAILMAP_ID

7Confidentiality Flag
STRAP_IDXCONF_FLG

8Mailing Address 1
MAILADDR_1

9Mailing Address 2
MAILADDR_2

10City
MAILCITY

11State
MAILSTATE

12Zip Code
MAILZIP

13Property Use Code (PUSE)
PARCELDOR_CD

14Subdivision Number
DETAILSUB

15Subdivision Name
LU_SUBDSCR

16Plat Book
DETAILPLAT_BK

17Plat Book Page
DETAILPLAT_PG

18Neighborhood Code2PARCELNH_CD

19Percentage Capped2PARCELPCT_SOH

20Primary Valuation Method
PARCELINC_FLG

21Cap Base Year
PARCELBASE_YR

22Total Market Value
PARCELASD_VAL

23Assessed Value
PARCELSOH_VAL

24Building Value
PARCELBLD_VAL

25Total Just Value (Greenbelt Value)
PARCELJST_VAL

26School Taxable
PARCEL_TAXTAX_DIST = 02

27County/Municipal Taxable
PARCEL_TAXTAX_DIST = 06 OR 07 OR 16

28SJRWMD/FIND Table
PARCEL_TAXTAX_DIST = 41

29Taxing District Code
PARCELMILL_CD

30GIS Square Feet
DETAILSQFT

31Doc Acres
DETAILACREAGE


Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000021Row Type Identifier



2Parcel Number (Real Estate Number)
LEGAL_LNSTRAP

3Legal Line Number
LEGAL_LNNUM

4Entire Legal Description
LEGAL_LNDSCR

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000031Row Type Identifier



2Parcel Number (Real Estate Number)
OWNERSTRAP

3Line Number
OWNERLN_NUM

4Grantee (Owner Name)
OWNERNAME

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
 *000041 Row Type Identifier



2Parcel Number (Real Estate Number)
SITESTRAP
 3Site Address Number
SITESTR_NUM
 4Site Address Prefix
SITESTR_PFX
 5Site Address Street Name
SITESTR
 6Site Address Street Type
SITESTR_SFX
 7Site Address Unit Number
SITESTR_UNIT
 8Site Address City
SITECITY
 9Site Zip Code
SITEZIP
 10Building Num
SITEBLD_NUM

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000051Row Type Identifier




2Parcel Number (Real Estate Number)

BLDSTRAP

3Building Number
BLD
NUM

4Building Type Code (BUSE)
BLD
IMPR_TP

5BUSE Description
LU_IMPRDSCR

6Building Style Code
BLD
IMPR_MDL_CD

7Building Class Code
BLD
CLASS

8Quality Code
BLD
QA_CD

9Actual Year Built
BLD
ACT

10Effective Year Built
BLD
EFF

11% of Completion (Decimal)2BLD
PCT_COMP

12Building Value
BLD
DPR_VAL

13Building Heated Area
BLD
HEAT_AR

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000061Row Type Identifier




2Parcel Number (Real Estate Number)

BLD_CD_SE
STRAP

3Building Number Reference
BLD_CD_SE
BLD_NUM

4Structural Element Category Code
BLD_CD_SE
TP

5Structural Element Type Code
BLD_CD_SE
CD

6Element Type Description
LU_STRCT_ELDSCR

7% of Element (Decimal)2BLD_CD_SE
PCT

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000071Row Type Identifier




2Parcel Number (Real Estate Number)

BLD_UT_SESTRAP

3Building Number Reference

BLD_UT_SE
BLD_NUM

4Utility Structure Code

BLD_UT_SE

5Structural Description (Bedroom)

LU_STRCT_EL_TP

6Number of Structural Units (Bath/Stories)2BLD_UT_SE
UTS

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000081Row Type Identifier




2Parcel Number (Real Estate Number)

BLD_SARSTRAP

3Building Number Reference
BLD_SAR
BLD_NUM

4Subarea Structure Code
BLD_SAR
SAR_CD

5Subarea Code Description
LU_SARDSCR

6Actual Area
BLD_SAR
ACT_AR

7Effective Area
BLD_SAR
EFF_AR

8Heated Area
BLD_SAR
HEAT_AR

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000091Row Type Identifier




2Parcel Number (Real Estate Number)

CONDO_UNITSTRAP

3Building Number
CONDO_UNIT
BLD_NUM

4Condominium Number
CONDO_UNIT
COMPLEX_ID

5Condominium Type
CONDO_UNIT
CONDO_TYPE

6Total Value
CONDO_UNIT
TOT_VAL

7Condo View Code
CONDO_UNIT
VIEW_CD

8Percentage of Adjustment
CONDO_UNIT
PCT_COND

9Bedroom
LU_CONDBEDS

10Bathroom
LU_COND
BATHS

11Area
LU_COND
AREA

12Floor Adjustment
LU_COND
PCT_ADJ

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000101Row Type Identifier




2Parcel Number (Real Estate Number)

CONDO_AMENITYSTRAP

3Building Number
CONDO_AMENITY
BLD_NUM

4Amenity Item Code
CONDO_AMENITY
AMENITY

5Amenity Unit
CONDO_AMENITY
UTS

6Amenity Type
CONDO_AMENITY
TP

7Amenity Value
CONDO_AMENITY
VAL

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000111Row Type Identifier




2Parcel Number (Real Estate Number)

XFOBSTRAP

3Building # Reference (if applicable)
XFOB
BLD_NUM

4Extra Feature Category Code
XFOB
CD

5Short Description of Feature
LU_XFOBS_DSCR

6Extra Feature Grade Code
XFOB
GRADE

7Feature Length
XFOB
LN

8Feature Width

XFOB
WD

9Number of Feature Units
2XFOB
UTS

10Price Per Unit
2XFOB
KEY_PRC

11Actual Year Built
XFOB
YR_BLT

12Effective Year Built
XFOB
YR_EFF

13Depreciated Value
XFOB
DPR_VAL

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000121Row Type Identifier




2Parcel Number (Real Estate Number)

LND_C
STRAP

3Land Use Code (LUSE)
LND_C
USE_CD

4Land Use Description
LU_LND_USEDSCR

5Zoning Code
LND_C
ZONE

6Unit Type Code
LND_C
TP

7Front Feet Amount2LND_C
FRNT

8Depth2LND_C
DPTH

9Number of Units2LND_C
UTS

10Price Per Unit2LND_C
UNIT_PRC

11Land Value
LND_C
VAL

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000131Row Type Identifier




2Parcel Number (Real Estate Number)

LND_ASTRAP

3Land Use Code (LUSE)
LND_A
USE_CD

4Land Use Description
LU_LND_USEDSCR

5Zoning Code
LND_A
ZONE

6Unit Type Code
LND_A
TP

7Number of Units2LND_A
UTS

8Price Per Unit2LND_A
UNIT_PRC

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000141Row Type Identifier



(Market AG Land)2Parcel Number (Real Estate Number)

LND_MSTRAP

3Land Use Code (LUSE)
LND_MUSE_CD

4LUSE Description
LU_LND_USEDSCR

5Zoning Code
LND_M
ZONE

6Unit Type Code
LND_M
TP

7Number of Units2LND_M
UTS

8Price Per Unit2LND_M
UNIT_PRC

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000151Row Type Identifier




2Parcel Number (Real Estate Number)

PERSONAL_XSTRAP

3Exemption Code
PERSONAL_X
CD

4Exemption Description
LU_PERSONAL_X
DSCR

5% of Exemption (Decimal)2PERSONAL_X
PCT_OWN

6Exemption Amount
PERSONAL_X
EX_VAL

7Exemption Override Amount
PERSONAL_X
FIX_EX_VAL

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000161Row Type Identifier




2Parcel Number (Real Estate Number)

PCHARSTRAP

3Category
PCHARCD

4Characteristic Type
PCHARTP

5Characteristic Description
LU_PCHAR_TPDSCR

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000171Row Type Identifier




2Parcel Number (Real Estate Number)
12SALESSTRAP

3Sale ID Number
12SALES
SALE_ID

4Grantor Name50SALES
GRANTOR

5Book of Sale5SALES
OR_BK

6Page of Sale5SALES
OR_PG

7Qualification Code2SALES
REA_CD

8Improvement Code1SALES
VI

9Instrument2SALES
TRNS_CD

10Instrument Description
LU_INSTRDSCR

11Deed Type1SALESQSRC_CD