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


--
-- Structure for table `sc700_tmp`
--

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

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

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

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

--
-- Structure for table `sc700_owndat`
--

CREATE TABLE IF NOT EXISTS `sc700_owndat` (
  `MediaCreateDate` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ParcelID` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `TaxYear` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Sequence#` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Owner1` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Owner2` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AddressLine1` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AddressLine2` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ZipCode1` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ZipCode2` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `MailingNamePointer` 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,
  `DeactivateDate` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DateLastMaintenance` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `CityName` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `StateCode` 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 sc700_tmp to sc700_owndat
--

INSERT INTO `sc700_owndat` SELECT SUBSTRING(sc700string,1,11), SUBSTRING(sc700string,12,7), SUBSTRING(sc700string,19,5), SUBSTRING(sc700string,24,4), SUBSTRING(sc700string,28,40), SUBSTRING(sc700string,68,40), SUBSTRING(sc700string,108,80), SUBSTRING(sc700string,188,80), SUBSTRING(sc700string,268,5), SUBSTRING(sc700string,273,4), SUBSTRING(sc700string,277,6), SUBSTRING(sc700string,283,40), SUBSTRING(sc700string,323,40), SUBSTRING(sc700string,363,11), SUBSTRING(sc700string,374,11), SUBSTRING(sc700string,385,40), SUBSTRING(sc700string,425,2), SUBSTRING(sc700string,427,1) from `sc700_tmp`;