Tax Data File Format
The Tax Data Files available for FTP download are made available as Fixed Length ASCII Text Files (flat files), and Microsoft Access Databases. The files are updated on a monthly basis. The extract data along with a detailed listing of file names, file contents, field names, field contents, and coding values for all available tax data files has been provided below.
Available Files - Current As Of: OCTOBER 27, 2009
|
NHCLTTAX |
- |
Property Data for all New Hanover County including all municipalities. |
|
CBCLTAX |
- |
Property Data for the Town of Carolina Beach, NC. |
|
FDCLTAX |
- |
Property Data for unincorporated areas of New Hanover County, NC. |
|
KBCLTAX |
- |
Property Data for the Town of Kure Beach, NC. |
|
WBCLTAX |
- |
Property Data for the Town of Wrightsville Beach, NC. |
|
WMCLTAX |
- |
Property Data for the City of Wilmington, NC |
|
*_MDB |
- |
Same Property Data above in MS Access MDB format
(above naming convention applies, NH, CB, KB, WB, WM) |
File Format for all Tax Data Files
|
FIELD
NAME |
#
CHAR |
FIELD
TYPE |
COMMENTS |
|
|
|
|
|
ACCOUNT-STATUS |
1 |
CHAR |
ALWAYS A (ACTIVE) |
|
PARCEL-TYPE |
1 |
CHAR |
ALWAYS R (REAL) |
|
PARCEL-MAP-NUMBER |
5 |
CHAR |
SELF EXPLANATORY |
|
PARCEL-BLOCK-NUMBER |
3 |
CHAR |
SELF EXPLANATORY |
|
PARCEL-LOT-NUMBER |
3 |
CHAR |
SELF EXPLANATORY |
|
PARCEL-SUBLOT-NUMBER |
3 |
CHAR |
SELF EXPLANATORY |
|
AREA-NGHBRHOOD |
4 |
CHAR |
NEIGHBORHOOD CODE |
|
MASTER-INDEX |
7 |
CHAR |
ALTERNATE KEY |
|
FILLER |
10 |
CHAR |
BLANKS |
|
SITUS-CITY-CODE |
3 |
CHAR |
CITY CODE |
|
|
|
*** (UNINCORPORATED) |
|
|
|
CB (CAROLINA BEACH) |
|
|
|
CH (CASTLE HAYNE) |
|
|
|
KB (KURE BEACH) |
|
|
|
WB (WRIGHTSVILLE BEACH) |
|
|
|
WM (WILMINGTON) |
|
FILLER |
8 |
CHAR |
BLANKS |
|
PARCEL-ST-NUMBER |
6 |
CHAR |
SITUS NUMBER |
|
PCA |
4 |
CHAR |
PROPERTY CLASS |
|
FILLER |
2 |
CHAR |
BLANKS |
|
EXEMPTION-CODE |
1 |
CHAR |
S (SENIOR CIT) OR BLANK |
|
REAL-ASSESSED-VAL |
8 |
NUM |
IF PCA = USE THEN THIS REFLECTS CLASSIFIED-MKT + |
|
|
|
EX-FEAT-VALUE + BLDG-VALUE ELSE THIS |
|
|
|
REFLECTS LAND VALUE + EX-FEAT-VALUE + BLDG-VALUE |
|
PERS-ASSESSED-VAL |
8 |
NUM |
SELF EXPLANATORY |
|
FILED-LATE-FLAG |
1 |
CHAR |
LATE FILING FLAG (Y OR N) |
|
FILLER |
2 |
CHAR |
BLANKS |
|
EXTRA-ID |
15 |
CHAR |
PARCEL IDENTIFICATION NUMBER (PIN) |
|
LAND-VALUE |
8 |
NUM |
ASSESSED LAND VALUE |
|
EX-FEAT-VALUE |
8 |
NUM |
ASSESSED FEATURES VALUE |
|
BLDG-VALUE |
8 |
NUM |
ASSESSED BUILDING VALUE |
|
CLASSIFIED-MKT |
8 |
NUM |
ASSESSED USE VALUE |
|
SALE-YEAR |
2 |
NUM |
MOST RECENT SALE YEAR |
|
SALE-MONTH |
2 |
NUM |
MOST RECENT SALE MONTH |
|
SALE-QUAL |
1 |
CHAR |
INDICATES WHETHER OR NOT SALE HAS BEEN QUALIFIED |
|
|
|
Q (QUALIFIED-YES) |
|
|
|
U (UNQUALIFIED-NO) |
|
SALE-INST |
2 |
CHAR |
TYPE OF DOCUMENT USED TO TRANSFER PROPERTY |
|
SALE-VORI |
1 |
CHAR |
V (VACANT) OR I (IMPROVED) PROPERTY |
|
SALE-BOOK-PAGE |
8 |
CHAR |
BOOK AND PAGE AT REGISTER OF DEEDS |
|
SALE-PRICE |
8 |
NUM |
MOST RECENT SALES PRICE |
|
NUM-SALES-RCRDS |
2 |
NUM |
# OF SALES FOR THIS PROPERTY |
|
FILLER |
14 |
CHAR |
BLANKS |
|
PARCEL-LEGAL1 |
27 |
CHAR |
LEGAL DESC OF PROPERTY (MAY ALSO INDICATE ACREAGE) |
|
PARCEL-LEGAL2 |
27 |
CHAR |
ADD'L LEGAL DESC OF PROPERTY (IF APPLICABLE) |
|
FILLER |
6 |
CHAR |
BLANKS |
|
NAME1 |
27 |
CHAR |
MOST CURRENT OWNER NAME |
|
NAME2 |
27 |
CHAR |
MOST CURRENT CO-OWNER NAME |
|
ST-ADDRESS |
27 |
CHAR |
MOST CURRENT OWNER ADDRESS |
|
CITY-STATE |
27 |
CHAR |
MOST CURRENT OWNER CITY/STATE |
|
CURR-OWN-ZIP |
6 |
CHAR |
MOST CURRENT OWNER ZIP |
|
JAN1-OWN |
27 |
CHAR |
JAN 1 OWNER NAME |
|
PAR-COUNTY |
2 |
CHAR |
ALWAYS NH |
|
ST-NAME |
20 |
CHAR |
SITUS STREET NAME |
|
TAX-DISTRICT |
2 |
CHAR |
TAX DISTRICT |
|
|
|
CB (CAROLINA BEACH) |
|
|
|
FD (FIRE DISTRICT) |
|
|
|
KB (KURE BEACH) |
|
|
|
WB (WRIGHTSVILLE BEACH) |
|
|
|
WM (WILMINGTON) |
|
PAR-ZONING |
5 |
CHAR |
CITY/COUNTY ZONING CODE AS DETERMINED BY PLANNING DEPT. |
|
PAR-LAND-VAL |
8 |
NUM |
APPRAISED LAND VALUE |
|
SPEC-FEAT-VAL |
8 |
NUM |
APPRAISED FEATURES VALUE |
|
PAR-IMP-VAL |
8 |
NUM |
APPRAISED BUILDINGS VALUE |
|
FILLER |
18 |
CHAR |
BLANKS |
|
SUBD-CODE |
6 |
CHAR |
SUBDIVISION CODE |
|
SUBD-NAME |
30 |
CHAR |
SUBDIVISION NAME |
|
FILLER |
47 |
CHAR |
BLANKS |
|
YR-BLT-ACTL |
4 |
NUM |
YEAR BUILT |
| FILLER |
4 |
CHAR |
BLANKS |
File Format for all Access Database Files
|
FIELD
NAME |
#
CHAR |
FIELD
TYPE |
COMMENTS |
|
|
|
|
|
ACCOUNT-STATUS |
1 |
CHAR |
ALWAYS A (ACTIVE) |
|
PARCEL-TYPE |
1 |
CHAR |
ALWAYS R (REAL |
|
MAPID |
18 |
CHAR |
TAX MAP ID / ALTERNATE ID |
|
MAPIDKEY |
15 |
CHAR |
TAX MAP ID / RELATIONSHIP KEY |
|
PID |
20 |
CHAR |
PARCEL IDENTIFIER |
|
PARCEL-MAP-NUMBER |
5 |
CHAR |
SELF EXPLANATORY |
|
PARCEL-BLOCK-NUMBER |
3 |
CHAR |
SELF EXPLANATORY |
|
PARCEL-LOT-NUMBER |
3 |
CHAR |
SELF EXPLANATORY |
|
PARCEL-SUBLOT-NUMBER |
3 |
CHAR |
SELF EXPLANATORY |
|
AREA-NGHBRHOOD |
4 |
CHAR |
NEIGHBORHOOD CODE |
|
MASTER-INDEX |
7 |
CHAR |
ALTERNATE KEY |
|
FILLER |
10 |
CHAR |
BLANKS |
|
SITUS-CITY-CODE |
3 |
CHAR |
CITY CODE |
|
|
|
*** (UNINCORPORATED) |
|
|
|
CB (CAROLINA BEACH) |
|
|
|
CH (CASTLE HAYNE) |
|
|
|
KB (KURE BEACH) |
|
|
|
WB (WRIGHTSVILLE BEACH) |
|
|
|
WM (WILMINGTON) |
|
FILLER |
8 |
CHAR |
BLANKS |
|
PARCEL-ST-NUMBER |
6 |
CHAR |
SITUS NUMBER |
|
PCA |
4 |
CHAR |
PROPERTY CLASS |
|
FILLER |
2 |
CHAR |
BLANKS |
|
EXEMPTION-CODE |
1 |
CHAR |
S (SENIOR CIT) OR BLANK |
|
REAL-ASSESSED-VAL |
8 |
NUM |
IF PCA = USE THEN THIS REFLECTS CLASSIFIED-MKT + |
|
|
|
EX-FEAT-VALUE + BLDG-VALUE ELSE THIS |
|
|
|
REFLECTS LAND VALUE + EX-FEAT-VALUE + BLDG-VALUE |
|
PERS-ASSESSED-VAL |
8 |
NUM |
SELF EXPLANATORY |
|
FILED-LATE-FLAG |
1 |
CHAR |
LATE FILING FLAG (Y OR N) |
|
FILLER |
2 |
CHAR |
BLANKS |
|
EXTRA-ID |
15 |
CHAR |
PARCEL IDENTIFICATION NUMBER (PIN) |
|
LAND-VALUE |
8 |
NUM |
ASSESSED LAND VALUE |
|
EX-FEAT-VALUE |
8 |
NUM |
ASSESSED FEATURES VALUE |
|
BLDG-VALUE |
8 |
NUM |
ASSESSED BUILDING VALUE |
|
CLASSIFIED-MKT |
8 |
NUM |
ASSESSED USE VALUE |
|
SALE-YEAR |
2 |
NUM |
MOST RECENT SALE YEAR |
|
SALE-MONTH |
2 |
NUM |
MOST RECENT SALE MONTH |
|
SALE-QUAL |
1 |
CHAR |
INDICATES WHETHER OR NOT SALE HAS BEEN QUALIFIED |
|
|
|
Q (QUALIFIED-YES) |
|
|
|
U (UNQUALIFIED-NO) |
|
SALE-INST |
2 |
CHAR |
TYPE OF DOCUMENT USED TO TRANSFER PROPERTY |
|
SALE-VORI |
1 |
CHAR |
V (VACANT) OR I (IMPROVED) PROPERTY |
|
SALE-BOOK-PAGE |
8 |
CHAR |
BOOK AND PAGE AT REGISTER OF DEEDS |
|
SALE-PRICE |
8 |
NUM |
MOST RECENT SALES PRICE |
|
NUM-SALES-RCRDS |
2 |
NUM |
# OF SALES FOR THIS PROPERTY |
|
FILLER |
14 |
CHAR |
BLANKS |
|
PARCEL-LEGAL1 |
27 |
CHAR |
LEGAL DESC OF PROPERTY (MAY ALSO INDICATE ACREAGE) |
|
PARCEL-LEGAL2 |
27 |
CHAR |
ADD'L LEGAL DESC OF PROPERTY (IF APPLICABLE) |
|
FILLER |
6 |
CHAR |
BLANKS |
|
NAME1 |
27 |
CHAR |
MOST CURRENT OWNER NAME |
|
NAME2 |
27 |
CHAR |
MOST CURRENT CO-OWNER NAME |
|
ST-ADDRESS |
27 |
CHAR |
MOST CURRENT OWNER ADDRESS |
|
CITY-STATE |
27 |
CHAR |
MOST CURRENT OWNER CITY/STATE |
|
CURR-OWN-ZIP |
6 |
CHAR |
MOST CURRENT OWNER ZIP |
|
JAN1-OWN |
27 |
CHAR |
JAN 1 OWNER NAME |
|
PAR-COUNTY |
2 |
CHAR |
ALWAYS NH |
|
ST-NAME |
20 |
CHAR |
SITUS STREET NAME |
|
TAX-DISTRICT |
2 |
CHAR |
TAX DISTRICT |
|
|
|
CB (CAROLINA BEACH) |
|
|
|
FD (FIRE DISTRICT) |
|
|
|
KB (KURE BEACH) |
|
|
|
WB (WRIGHTSVILLE BEACH) |
|
|
|
WM (WILMINGTON) |
|
PAR-ZONING |
5 |
CHAR |
CITY/COUNTY ZONING CODE AS DETERMINED BY PLANNING DEPT. |
|
PAR-LAND-VAL |
8 |
NUM |
APPRAISED LAND VALUE |
|
SPEC-FEAT-VAL |
8 |
NUM |
APPRAISED FEATURES VALUE |
|
PAR-IMP-VAL |
8 |
NUM |
APPRAISED BUILDINGS VALUE |
|
FILLER |
18 |
CHAR |
BLANKS |
|
SUBD-CODE |
6 |
CHAR |
SUBDIVISION CODE |
|
SUBD-NAME |
30 |
CHAR |
SUBDIVISION NAME |
|
FILLER |
47 |
CHAR |
BLANKS |
|
YR-BLT-ACTL |
4 |
NUM |
YEAR BUILT |
| FILLER |
4 |
CHAR |
BLANKS |