SC732_OWNALL contains property ownership information exported from Fiscal Office CAMA system
Visit: Fiscal Office CAMA Data Downloads
Run Report: SC732_OWNALL


--
-- Structure for table `sc732_tmp`
--

CREATE TABLE IF NOT EXISTS `sc732_tmp` (
  `sc732string` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

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

--
-- Structure for table `sc732_ownall`
--

CREATE TABLE IF NOT EXISTS `sc732_ownall` (
  `MediaCreateDate` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ParcelID` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TaxYear` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Owner1` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Owner2` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TypeOfOwner1` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TypeOfOwner2` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TypeOfOwner3` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TypeOfOwner4` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tMaritalStatus` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `MultiOwnerCode` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `OwnerSeqNumber` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AddressLine1` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AddressLine2` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AddressLine3` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RecordSeperator` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Insert sc732_tmp to sc732_ownall
--

INSERT INTO `sc732_ownall` SELECT SUBSTRING(sc732string,1,11), SUBSTRING(sc732string,12,7), SUBSTRING(sc732string,19,5), SUBSTRING(sc732string,24,40), SUBSTRING(sc732string,64,40), SUBSTRING(sc732string,104,3), SUBSTRING(sc732string,107,3), SUBSTRING(sc732string,110,3), SUBSTRING(sc732string,113,3), SUBSTRING(sc732string,116,1), SUBSTRING(sc732string,117,6), SUBSTRING(sc732string,123,4), SUBSTRING(sc732string,127,134), SUBSTRING(sc732string,261,80), SUBSTRING(sc732string,341,123), SUBSTRING(sc732string,464,1) from `sc732_tmp`;