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
BLDNUM

4Building Type Code (BUSE)
BLDIMPR_TP

5BUSE Description
LU_IMPRDSCR

6Building Style Code
BLDIMPR_MDL_CD

7Building Class Code
BLDCLASS

8Quality Code
BLDQA_CD

9Actual Year Built
BLDACT

10Effective Year Built
BLDEFF

11% of Completion (Decimal)2BLDPCT_COMP

12Building Value
BLDDPR_VAL

13Building Heated Area
BLDHEAT_AR

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000061Row Type Identifier



2Parcel Number (Real Estate Number)
BLD_CD_SESTRAP

3Building Number Reference
BLD_CD_SEBLD_NUM

4Structural Element Category Code
BLD_CD_SETP

5Structural Element Type Code
BLD_CD_SECD

6Element Type Description
LU_STRCT_ELDSCR

7% of Element (Decimal)2BLD_CD_SEPCT

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000071Row Type Identifier



2Parcel Number (Real Estate Number)
BLD_UT_SESTRAP

3Building Number Reference
BLD_UT_SEBLD_NUM

4Utility Structure Code

BLD_UT_SE

5Structural Description (Bedroom)

LU_STRCT_EL_TP

6Number of Structural Units (Bath/Stories)2BLD_UT_SEUTS

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000081Row Type Identifier



2Parcel Number (Real Estate Number)
BLD_SARSTRAP

3Building Number Reference
BLD_SARBLD_NUM

4Subarea Structure Code
BLD_SARSAR_CD

5Subarea Code Description
LU_SARDSCR

6Actual Area
BLD_SARACT_AR

7Effective Area
BLD_SAREFF_AR

8Heated Area
BLD_SARHEAT_AR

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000091Row Type Identifier



2Parcel Number (Real Estate Number)
CONDO_UNITSTRAP

3Building Number
CONDO_UNITBLD_NUM

4Condominium Number
CONDO_UNITCOMPLEX_ID

5Condominium Type
CONDO_UNITCONDO_TYPE

6Total Value
CONDO_UNITTOT_VAL

7Condo View Code
CONDO_UNITVIEW_CD

8Percentage of Adjustment
CONDO_UNITPCT_COND

9Bedroom
LU_CONDBEDS

10Bathroom
LU_CONDBATHS

11Area
LU_CONDAREA

12Floor Adjustment
LU_CONDPCT_ADJ

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000101Row Type Identifier



2Parcel Number (Real Estate Number)
CONDO_AMENITYSTRAP

3Building Number
CONDO_AMENITYBLD_NUM

4Amenity Item Code
CONDO_AMENITYAMENITY

5Amenity Unit
CONDO_AMENITYUTS

6Amenity Type
CONDO_AMENITYTP

7Amenity Value
CONDO_AMENITYVAL

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000111Row Type Identifier



2Parcel Number (Real Estate Number)
XFOBSTRAP

3Building # Reference (if applicable)
XFOBBLD_NUM

4Extra Feature Category Code
XFOBCD

5Short Description of Feature
LU_XFOBS_DSCR

6Extra Feature Grade Code
XFOBGRADE

7Feature Length
XFOBLN

8Feature Width
XFOBWD

9Number of Feature Units2XFOBUTS

10Price Per Unit2XFOBKEY_PRC

11Actual Year Built
XFOB
YR_BLT

12Effective Year Built
XFOBYR_EFF

13Depreciated Value
XFOBDPR_VAL

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000121Row Type Identifier



2Parcel Number (Real Estate Number)
LND_CSTRAP

3Land Use Code (LUSE)
LND_CUSE_CD

4Land Use Description
LU_LND_USEDSCR

5Zoning Code
LND_CZONE

6Unit Type Code
LND_CTP

7Front Feet Amount2LND_CFRNT

8Depth2LND_CDPTH

9Number of Units2LND_CUTS

10Price Per Unit2LND_CUNIT_PRC

11Land Value
LND_CVAL

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000131Row Type Identifier



2Parcel Number (Real Estate Number)
LND_ASTRAP

3Land Use Code (LUSE)
LND_AUSE_CD

4Land Use Description
LU_LND_USEDSCR

5Zoning Code
LND_AZONE

6Unit Type Code
LND_ATP

7Number of Units2LND_AUTS

8Price Per Unit2LND_AUNIT_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_MZONE

6Unit Type Code
LND_MTP

7Number of Units2LND_MUTS

8Price Per Unit2LND_MUNIT_PRC

 

Row Type IdentifierField NumberDescriptionNumberOrigin TableField Name
*000151Row Type Identifier



2Parcel Number (Real Estate Number)
PERSONAL_XSTRAP

3Exemption Code
PERSONAL_XCD

4Exemption Description
LU_PERSONAL_XDSCR

5% of Exemption (Decimal)2PERSONAL_XPCT_OWN

6Exemption Amount
PERSONAL_XEX_VAL

7Exemption Override Amount
PERSONAL_XFIX_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 Number12SALESSALE_ID

4Grantor Name50SALESGRANTOR

5Book of Sale5SALESOR_BK

6Page of Sale5SALESOR_PG

7Qualification Code2SALESREA_CD

8Improvement Code1SALESVI

9Instrument2SALESTRNS_CD

10Instrument Description
LU_INSTRDSCR

11Deed Type1SALESQSRC_CD