SC705_PARDAT contains the most current parcel information exported from the Fiscal Office CAMA system
Visit: Fiscal Office CAMA Data Downloads
Run Report: SC705_PARDAT


--
-- Table structure for table `sc705_tmp`
--

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

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

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

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

--
-- Table structure for table `sc705_pardat`
--

CREATE TABLE IF NOT EXISTS `sc705_pardat` (
  `MediaCreateDate` varchar(45) DEFAULT NULL,
  `ParcelID` varchar(45) DEFAULT NULL,
  `TaxYear` varchar(45) DEFAULT NULL,
  `SequenceNumber` varchar(45) DEFAULT NULL,
  `AlternateParcel` varchar(45) DEFAULT NULL,
  `PropertyStreetNumber` varchar(45) DEFAULT NULL,
  `PropertyStreetSuffix` varchar(45) DEFAULT NULL,
  `PropertyStreetDirection` varchar(45) DEFAULT NULL,
  `PropertyStreetName` varchar(45) DEFAULT NULL,
  `PropertyStreetNameSuffix` varchar(45) DEFAULT NULL,
  `NeighborhoodPrefix` varchar(45) DEFAULT NULL,
  `NeighborhoodSuffix` varchar(45) DEFAULT NULL,
  `ClassType` varchar(45) DEFAULT NULL,
  `LandUseCode` varchar(45) DEFAULT NULL,
  `MultipleLandUse` varchar(45) DEFAULT NULL,
  `LivingUnit` varchar(45) DEFAULT NULL,
  `ParcelTieback` varchar(45) DEFAULT NULL,
  `LandiscFrame` varchar(45) DEFAULT NULL,
  `Acres` varchar(45) DEFAULT NULL,
  `StreetSidewalkCode1` varchar(45) DEFAULT NULL,
  `StreetSidewalkCode2` varchar(45) DEFAULT NULL,
  `TrafficCode` varchar(45) DEFAULT NULL,
  `TopographyCode1` varchar(45) DEFAULT NULL,
  `TopographyCode2` varchar(45) DEFAULT NULL,
  `UtilityCode1` varchar(45) DEFAULT NULL,
  `UtilityCode2` varchar(45) DEFAULT NULL,
  `UtilityCode3` varchar(45) DEFAULT NULL,
  `MainBuildingCards` varchar(45) DEFAULT NULL,
  `PartialOwnership` varchar(45) DEFAULT NULL,
  `GrossBuildingDescription` varchar(45) DEFAULT NULL,
  `GrossBuildingValue` varchar(45) DEFAULT NULL,
  `MiscellaneousBuildings` varchar(45) DEFAULT NULL,
  `MiscellaneousBuildingsValue` varchar(45) DEFAULT NULL,
  `NoteCode1` varchar(45) DEFAULT NULL,
  `NoteCode2` varchar(45) DEFAULT NULL,
  `Note1` varchar(45) DEFAULT NULL,
  `Note2` varchar(45) DEFAULT NULL,
  `DeactivateDate` varchar(45) DEFAULT NULL,
  `LastMaintenanceDate` varchar(45) DEFAULT NULL,
  `LocationFactor` varchar(45) DEFAULT NULL,
  `FrontingLocationFactor` varchar(45) DEFAULT NULL,
  `ZipCode` varchar(45) DEFAULT NULL,
  `PropertyAddressStNameSufx2` varchar(45) DEFAULT NULL,
  `RegisteredOn` varchar(45) DEFAULT NULL,
  `RRExemption` varchar(45) DEFAULT NULL,
  `SendRRLetter` varchar(45) DEFAULT NULL,
  `RRNoticeSent` varchar(45) DEFAULT NULL,
  `RecordSeparator` varchar(45) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Insert sc705_tmp to sc705_pardat
--

INSERT INTO `sc705_pardat` SELECT SUBSTRING(sc705string,1,11), SUBSTRING(sc705string,12,7), SUBSTRING(sc705string,19,5), SUBSTRING(sc705string,24,4), SUBSTRING(sc705string,28,30), SUBSTRING(sc705string,58,11), SUBSTRING(sc705string,69,6), SUBSTRING(sc705string,75,2), SUBSTRING(sc705string,77,30), SUBSTRING(sc705string,107,8), SUBSTRING(sc705string,115,5), SUBSTRING(sc705string,120,3), SUBSTRING(sc705string,123,4), SUBSTRING(sc705string,127,4), SUBSTRING(sc705string,131,1), SUBSTRING(sc705string,132,4), SUBSTRING(sc705string,136,30), SUBSTRING(sc705string,166,10), SUBSTRING(sc705string,176,14), SUBSTRING(sc705string,190,2), SUBSTRING(sc705string,192,2), SUBSTRING(sc705string,194,2), SUBSTRING(sc705string,196,1), SUBSTRING(sc705string,197,1), SUBSTRING(sc705string,198,2), SUBSTRING(sc705string,200,2), SUBSTRING(sc705string,202,2), SUBSTRING(sc705string,204,5), SUBSTRING(sc705string,209,1), SUBSTRING(sc705string,210,21), SUBSTRING(sc705string,231,11), SUBSTRING(sc705string,242,3), SUBSTRING(sc705string,245,11), SUBSTRING(sc705string,256,2), SUBSTRING(sc705string,258,2), SUBSTRING(sc705string,260,40), SUBSTRING(sc705string,300,40), SUBSTRING(sc705string,340,11), SUBSTRING(sc705string,351,11), SUBSTRING(sc705string,362,2), SUBSTRING(sc705string,364,1), SUBSTRING(sc705string,365,5), SUBSTRING(sc705string,370,8), SUBSTRING(sc705string,378,20), SUBSTRING(sc705string,398,20), SUBSTRING(sc705string,418,20), SUBSTRING(sc705string,438,20), SUBSTRING(sc705string,458) from `sc705_tmp`;