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`;
Page 1 of 8