SC706_SALES contains the most current property sales information exported from the Fiscal Office CAMA system
Visit: Fiscal Office CAMA Data Downloads
Run Report: SC706_SALES


--
-- Structure for table `sc706_tmp`
--

CREATE TABLE IF NOT EXISTS `sc706_tmp` (
  `sc706string` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--------------------------------------------------------------

-- UPLOAD SC706_SALES.DAT to /home/YourFolderName/SC706_SALES.DAT
-- Run SQL query against database using phpMyAdmin
LOAD DATA LOCAL INFILE '/home/[ YourFolderName ]/SC706_SALES.DAT' INTO TABLE `sc706_tmp`;

--------------------------------------------------------------

--
-- Structure for table `sc706_sales`
--

CREATE TABLE IF NOT EXISTS `sc706_sales` (
  `MediaCreateDate` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ParcelID` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TransferNumber` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OldYear` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OldSequence` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `NewYear` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `NewSequence` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TransactionDate` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `BookNumber` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PageNumber` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OldOwnerName` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OwnerName1` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SaleDate` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SalePrice` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SourceCode` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SaleType` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SaleValidity` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Note1` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Note2` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LastMaintenanceDate` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RecordSeperator` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--------------------------------------------------------------

--
-- Insert sc706_tmp to sc706_sales
--

INSERT INTO `sc706_sales` SELECT SUBSTRING(sc706string,1,11), SUBSTRING(sc706string,12,7), SUBSTRING(sc706string,19,9), SUBSTRING(sc706string,28,5), SUBSTRING(sc706string,33,4), SUBSTRING(sc706string,37,5), SUBSTRING(sc706string,42,4), SUBSTRING(sc706string,46,11), SUBSTRING(sc706string,57,8), SUBSTRING(sc706string,65,8), SUBSTRING(sc706string,73,40), SUBSTRING(sc706string,113,40), SUBSTRING(sc706string,153,11), SUBSTRING(sc706string,164,11), SUBSTRING(sc706string,175,1), SUBSTRING(sc706string,176,1), SUBSTRING(sc706string,177,2), SUBSTRING(sc706string,179,40), SUBSTRING(sc706string,219,40), SUBSTRING(sc706string,259,11), SUBSTRING(sc706string,270) from `sc706_tmp`;

Page 8 of 19