CREATE TABLE Prop_Asmt_Data_With_Header (
PAID Char (12),
PBKEY Char (12),
PARENT Char (12),
PLINKID Char (40),
OWNER_NAME Char (166),
OWNER_NAME2 Char (166),
FNAME Char (166),
MNAME Char (166),
LNAME Char (166),
FNAME2 Char (166),
MNAME2 Char (166),
LNAME2 Char (166),
OWNTYPE Char (1),
OWNID Char (12),
OWNID2 Char (12),
OWNVEST_CD Char (5),
TAX_ADDR Char (80),
TAX_ADD_NUMBER Char (13),
TAX_PREDIR Char (2),
TAX_STREETNAME Char (60),
TAX_STRTYPE Char (40),
TAX_POSTDIR Char (2),
TAX_UNIT_DES Char (4),
TAX_UNIT_NUM Char (15),
TAX_CITY Char (30),
TAX_STATE Char (2),
TAX_ZIPCODE Char (7),
TAX_PLUS4 Char (4),
ADDRESS Char (80),
ADD_NUMBER Char (13),
PREDIR Char (2),
STREETNAME Char (60),
STRTYPE Char (15),
POSTDIR Char (2),
UNIT_DES Char (4),
UNIT_NUM Char (15),
CITY Char (30),
STATE Char (2),
ZIPCODE Char (5),
PLUS4 Char (4),
VACANT Char (1),
PROP_CAT Char (1),
PROP_ABS_OWN_CD Char (1),
PROP_APN Char (45),
OLD_APN Char (31),
ALT_OLD_APN_IND Char (20),
PROP_APNSEQNBR Char (3),
FIPS Char (5),
GEOID Char (15),
PROP_ZONING Char (230),
PROP_ST_LANDUSE Char (4),
PROP_LU_DESC Char (45),
PROP_LU_CODE Char (8),
LAT Decimal(11,6),
LON Decimal(11,6),
LOC_CODE Char (4),
LEGAL_MAPREF Char (15),
LEGAL_ASSDESC Char (125),
LEGAL_BRIEFDESC Char (400),
LEGAL_LOT Char (2),
LEGAL_LOTNUM Char (7),
LEGAL_LNDLOT Char (10),
LEGAL_TCTNUM Char (10),
LEGAL_BLK Char (7),
LEGAL_SEC Char (7),
LEGAL_DIS Char (12),
LEGAL_UNIT Char (6),
LEGAL_PHASE Char (7),
LEGAL_SUB Char (40),
LEGAL_TWPMUNI Char (30),
LEGAL_SECTWPRANMER Char (30),
PROP_ACRES Decimal(15,6),
PROP_SQFT Decimal(20,4),
PROP_FRONTFT Decimal(15,4),
PROP_DEPTHFT Decimal(15,4),
BLDG_VIEW Char (100),
PROP_INFL Char (10),
BLDG_YRBLD Char (4),
BLDG_EFFYRBLD Char (4),
BLDG_NAME Char (230),
BLDG_COUNT Integer,
BLDG_SQFT Integer,
BLDG_SQFT_CODE Char (2),
BLDG_STYLE Char (100),
BLDG_STORIES Char (10),
BLDG_UNITNBR Char (10),
BLDG_QLTY Char (2),
BLDG_TYPE Char (3),
BLDG_IMPCD Char (3),
BLDG_MOBHOME Char (1),
BLDG_COND Char (3),
BLDG_CNSTR Char (100),
BLDG_EXTNW Char (3),
ROOF_FRAME Char (3),
ROOF_COVER Char (100),
ROOF_SHAPE Char (100),
LIVINGSQFT Integer,
GROSSSQFT Integer,
ADJGROSSSQFT Integer,
BLDG_AREA1 Integer,
BLDG_AREAIND1 Char (2),
BLDG_AREA2 Integer,
BLDG_AREAIND2 Char (2),
BLDG_AREA3 Integer,
BLDG_AREAIND3 Char (2),
BLDG_AREA4 Integer,
BLDG_AREAIND4 Char (2),
BLDG_AREA5 Integer,
BLDG_AREAIND5 Char (2),
BLDG_AREA6 Integer,
BLDG_AREAIND6 Char (2),
BLDG_AREA7 Integer,
BLDG_AREAIND7 Char (2),
BSMT_TYPE Char (100),
BSMTSQFT Integer,
BLDG_FND Char (3),
BLDG_CLASS Char (1),
INT_WALL Char (1),
FLOOR_TYPE Char (100),
ROOM_CT Integer,
BEDRM_CT Integer,
ROOM_OTHER Char (5),
BATH_CT Decimal(7,2),
BATHPAR_CT Integer,
BATHFIX_CT Integer,
PLUMBFIX_CT Char (3),
COOL_TYPE Char (100),
PROP_FRPL Char (2),
PROP_FRPLTYPE Char (3),
PROP_GAR Char (100),
PRKG_SQFT Integer,
PRKG_SPACES Integer,
POOL Char (1),
POOL_TYPE Char (100),
HEAT_TYPE Char (100),
ENERGY_TYPE Char (100),
FUEL_TYPE Char (3),
SEWER_TYPE Char (20),
WATER_TYPE Char (20),
ELEVATOR Char (1),
AMENITIES Char (10),
BLDG_OTHER1 Char (2),
BLDG_OTHER1_AREA Char (9),
BLDG_OTHER2 Char (2),
BLDG_OTHER2_AREA Char (9),
BLDG_OTHER3 Char (2),
BLDG_OTHER3_AREA Char (9),
BLDG_OTHER4 Char (2),
BLDG_OTHER4_AREA Char (9),
BLDG_OTHER5 Char (2),
BLDG_OTHER5_AREA Char (9),
EXT_FEAT1 Char (2),
EXT_FEAT1_AREA Char (9),
EXT_FEAT2 Char (2),
EXT_FEAT2_AREA Char (9),
EXT_FEAT3 Char (2),
EXT_FEAT3_AREA Char (9),
EXT_FEAT4 Char (2),
EXT_FEAT4_AREA Char (9),
PROP_LASTUPDATE Date,
TAX_ACCT_NUM Char (30),
TAPE_CUT_DATE Date,
REC_DATE Date,
DOC_TYPE Char (25),
SALE_AMT LargeInt,
SALE_CD Char (2),
REC_BK_NUM Char (10),
REC_PG_NUM Char (10),
REC_DOC_NUM Char (20),
PRIOR_SALE_REC_DATE Date,
PRIOR_SALE_DOC_TYPE Char (2),
PRIOR_SALE_AMT LargeInt,
PRIOR_SALE_CD Char (2),
PRIOR_SALE_BK_NUM Char (10),
PRIOR_SALE_PG_NUM Char (10),
PRIOR_SALE_DOC_NUM Char (20),
TAX_AMT Decimal(15,2),
TAX_YR Char (4),
TAX_DEL_YR Char (4),
ASSESS_YR Char (4),
ASSED_VAL LargeInt,
ASSED_LANDVAL LargeInt,
ASSED_IMPVAL LargeInt,
MRKETVAL_YR Char (4),
MRKTVAL_TOTAL LargeInt,
MRKTVAL_LAND LargeInt,
MRKTVAL_IMP LargeInt,
APPRAISED_VAL LargeInt,
APPRAISED_VAL_LAND LargeInt,
APPRAISED_VAL_IMP LargeInt,
REPLACE_CALC LargeInt,
REPLACE_CONF Char (10),
TAX_EXEMPT_CODE Char (4),
CA_EXEMPT Char (1),
TAXRATE_CODE Char (18),
SYN_PROP_RECORD Char (1),
AVM_VALUE Integer,
AVM_RANGE_HIGH Integer,
AVM_RANGE_LOW Integer,
AVM_CONF_SCORE Integer,
AVM_UPDATE_DT Date,
NEW_CONST Char (1),
HOA_YN Char (1),
HOA_PHONE Char (14),
HOA_DUES_1 Decimal(15,2),
HOA_DUES_2 Decimal(15,2),
HOA_PERIOD_1 Char (20),
HOA_PERIOD_2 Char (20),
PROP_INCOME Decimal(15,2),
PROP_RENTAL Char (1),
PROP_LEASE_AMT Decimal(15,2),
PROP_LEASE_PERIOD Char (15),
PROP_PRICE_SQFT Decimal(15,2),
SRC_ADDRESS Char (80),
SRC_CITY Char (30),
SRC_STATE Char (2),
SRC_ZIPCODE Char (5),
WKT Char (30)
) file "C:\Temp\Property_Attributes_Assessment\Prop_Asmt_Data_With_Header.TAB" TYPE NATIVEX Charset "UTF-8" Locale "en-US"
Create Map For Prop_Asmt_Data_With_Header CoordSys Earth Projection 1, 104
Browse * From Prop_Asmt_Data_With_Header