Multiple Sequences
Hello Support:
Some of my extractor patterns are generating multiple sequences. For some extractor patterns I'm interested in the first sequence and others the last sequence. For extractor patterns where I'm interested in the last sequence it's working fine because as you know it is saving the last sequence. Is it possible to save the first sequence?
By the way, I've tried to extract only the first sequnce but was not able to consistently.
Thanks,
Adrian
Adrian, I think I can picture
Adrian,
I think I can picture what you're describing but it would be helpful to see some examples. What we'll need in your examples are
- samples of the HTML text you are extracting
- the extractor pattern being applied to said sample
- which option you are choosing when invoking a script (eg. Before pattern is applied, etc.)
- the script you are using to interact with the extracted data
It's probably best to start with the situation in which you are wanting the first of a sequence but not able to grab it because it moves to the next or last.
Please be sure to nest all code in the <code> tag.
-Scott
Example...
Hi Scott,
The sample of the HTML is as follows:
X-Powered-By: Servlet/2.5 JSP/2.1
Date: Fri, 23 Apr 2010 01:36:06 GMT
Connection: close
Transfer-Encoding: chunked
Server: Apache
Content-Type: text/html; charset=ISO-8859-1
<script type='text/javascript' src='/ajax/interface/DWRController.js'></script>
<script type='text/javascript' src='/ajax/engine.js'></script>
<script type='text/javascript' src='/ajax/util.js'></script>
<script language="JavaScript" src="scripts/common_navigation.js"></script>
<form name="frmDocImage" method="post" action="please_wait.jsp">
<input type="hidden" name="page"/>
<input type="hidden" name="index"/>
<input type="hidden" name="date"/>
<input type="hidden" name="docno"/>
<input type="hidden" name="secDoc"/>
</form>
<form name="frmFCDetailLink" method="post" action="please_wait.jsp">
<input type="hidden" name="gotopage"/>
<input type="hidden" name="searchvalue"/>
<input type="hidden" name="searchpage"/>
<input type="hidden" name="state"/>
<input type="hidden" name="county"/>
<input type="hidden" name="FC_FOLIO_NUMBER"/>
<input type="hidden" name="storeSearch"/>
</form>
<form name="frmPropDetail" method="post" action="please_wait.jsp">
<input type="hidden" name="type"/>
<input type="hidden" name="currentpage"/>
<input type="hidden" name="newpage"/>
<input type="hidden" name="page"/>
</form>
<form name="frmPropSrchDetail" method="post" action="/searchdetail">
<input type="hidden" name="index"/>
</form>
<form name="frmPropDetButton" method="post" action="please_wait.jsp">
<input type="hidden" name="page"/>
</form>
<form name="frmPropDetIndexedButton" method="post" action="please_wait.jsp">
<input type="hidden" name="page"/>
<input type="hidden" name="index"/>
</form>
<script language="JavaScript">
var adminRecLimit = "1000";
var adminGplRecLimit="1000"
</script>
<script type='text/javascript' src='/ajax/interface/DWRController.js'></script>
<script type='text/javascript' src='/ajax/engine.js'></script>
<script type='text/javascript' src='/ajax/util.js'></script>
<!--Google Analytics-->
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
var pageTracker = null;
</script>
<!--Analytics id: <b>< System.getProperty("rlj_googleanalytics_id") %></b> Request URI ==>< request.getRequestURI()%> -->
<script type="text/javascript">
if(_gat!=null){
pageTracker = _gat._getTracker("UA-4658228-1");
}
if(pageTracker!=null)
{
pageTracker._initData();
}
// function trackRealistEvents()
// {
// //alert('trackRealistEvents(sk)');
// if(pageTracker!=null)
// {
// pageTracker._trackPageview();
// }
// }
function trackRealistEvents(pageRef)
{
if(pageTracker!=null)
{
pageTracker._trackPageview(pageRef);
}
}
</script>
<script type="text/javascript">
trackRealistEvents("/PropertyDetail");
</script>
<!-- Refactoring Comps, this shows the Header of comps only and when the session is null-->
<!--
//* - 05/12/2004 - Shiny - ICP 11952 - Changes made for MAC Compatibility
-->
<!-- To avoid caching in the browser //Start Changes made for ICP 21261-->
<!-- End of caching code in the browser //End Changes made for ICP 21261-->
<style>
#topLink {
color:#FFFFFF;
}
</style>
<html>
<head>
<title>Realist</title>
<link rel=stylesheet type="text/css" href="/css/realist.css" title="windows">
<link rel=stylesheet type="text/css" href="/css/realistMac.css" title="mac">
<script language="JavaScript" src="/scripts/foreclosureFlags.js"></script>
<script language="JavaScript" src="/scripts/iehover-fix.js"></script>
<script>
changeStylesForMac();
window.status = 'Realist';
</script>
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0"
>
<div class="screen">
<table border="0" cellspacing="0" cellpadding="0" width="100%">
<!-- HEADER PART CODE STARTS HERE-->
<tr bgColor="#003399">
<td>
<TABLE cellSpacing=0 cellPadding=0 width=780 border=0 >
<TBODY>
<TR>
<TD width=277 height="75px">
<IMG id="img_header1" src="/loadImage?fileName=socalmls.jpg" border="0">
</TD>
<TD align=middle width=100> </TD>
<TD vAlign=bottom align=right>
<TABLE cellSpacing=0 cellPadding=0 border=0
height="20">
<TBODY>
<TR style="font-size:10px; color:#FFFFFF; font-family:Arial, Helvetica, sans-serif;">
<TD colspan="10" height="50px">
<img src="/images/realistlogo.gif"
border="0" align="right" style="margin-top:5px; margin-bottom:7px;" alt="Realist">
</TD>
</TR>
<TR style="font-size:10px; color:#FFFFFF; font-family:Arial, Helvetica, sans-serif;">
<TD style="font-size:11px;"><strong>Hello, Adrian**</strong></TD>
<TD> | </TD>
<!--<TD><a href="Realist_UploadLogo.htm" style="font-size:10px; color:#FFFFFF; font-family:Arial, Helvetica, sans-serif; text-decoration:underline;">Preferences</a></TD>-->
<td ><a href="/preferences.jsp?displayType=both&displayButtons=preferences" style="color:#FFFFFF;">Preferences</a></td>
<TD> | </TD>
<!--<TD style="text-decoration:underline;">FAQ</TD>-->
<td class="topLink"><a href="/faq.jsp" style="color:#FFFFFF;">FAQ</a></td>
<TD> | </TD>
<td align="center"><a href="/contact.jsp" style="color:#FFFFFF;">Contact Us</a></td>
<TD> | </TD>
<TD align="center"><a href="/auth?loginType=logout" style="color:#FFFFFF;">Close Window</a></TD>
<TD><IMG height=8 src="/images/spacer.gif" width=3 border=0> </TD>
</TR>
</TBODY>
</TABLE>
</TD>
</TR>
</tbody>
</table>
</td>
</tr>
<!-- HEADER PART CODE ENDS HERE-->
<!-- MENU PART CODE STARTS HERE-->
<tr>
<td>
<!--
//* - 15/11/2006 - Suresh Kumar N - Redesigning of Realist User Interface
-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<link rel=stylesheet type="text/css" href="/css/realistMac.css" title="mac">
<link rel="stylesheet" type="text/css" href="/css/realist.css" />
<style type="text/css">
html .realistcssmenu {height: 1%; z-index:100; } /*Holly Hack for IE7 and below*/
</style>
<script type="text/javascript" src="/scripts/realistHover.js"></script>
<script type="text/javascript" src="/scripts/realistmenu.js" />
<script language="JavaScript" src="/scripts/foreclosureFlags.js"></script>
<!--<SCRIPT src="/scripts/iehover-fix.js" type=text/javascript></SCRIPT>-->
<script>
changeStylesForMac()
</script>
<table border="0" cellpadding="0" cellspacing="0" width="100%" height=20>
<tr>
<Td>
<DIV id="realistmenu1" class="realistcssmenu" >
<UL>
<LI>
<A
href="/home.jsp?tabAction=HOME">Home</A></LI>
<LI onmouseover="hide_dropdowns('in')" onmouseout="hide_dropdowns('out')"><A
href="#nogo" align="center">Searches</A>
<UL>
<LI><A href="/searchaddress.jsp?firsttime=yes&tabAction=SEARCHES">Address</A></LI>
<LI><A href="/searchstreet.jsp?firsttime=yes&tabAction=SEARCHES">Street</A></LI>
<LI><A href="/searchowner.jsp?firsttime=yes&tabAction=SEARCHES">Owner Name</A></LI>
<LI><A href="/searchphone.jsp?firsttime=yes&tabAction=SEARCHES">Phone Number</A></LI>
<LI><A href="/searchapn.jsp?firsttime=yes&tabAction=SEARCHES">APN/Tax ID/Folio</A></LI>
<LI><A href="/searchgeneral.jsp?firsttime=yes&tabAction=SEARCHES">General Query</A></LI>
<LI><A href="/searchforeclosure.jsp?firsttime=yes&tabAction=SEARCHES">Foreclosure Activity</A></LI>
<LI><A href="/gpl_streetmap.jsp?firsttime=yes&fromPage=gplStreetMap&tabAction=SEARCHES">Realist Map</A></LI>
</UL>
</LI>
<LI><A
href="/search.jsp?firsttime=yes&tabAction=SAVEDSEARCHES">Saved Searches</A></LI>
<LI><A
href="#nogo">Calculators</A> <UL>
<LI><A href="/mortgage_qual.jsp?tabAction=CALCULATORS">Mortgage Qualification</A></LI>
<LI><A href="/mortgage_amort.jsp?tabAction=CALCULATORS">Mortgage Amortization</A></LI>
</UL>
</LI>
<LI><A
href="/update?updatetype=exportmgr&tabAction=EXPORTMANAGER">Export Manager</A> </LI>
<LI><A
href="#nogo" align="center">Realist ValueMap</A>
<UL>
<LI><A href="/servicesHomeVDX.jsp?tabAction=VALUEMAP">My ValueMap</A></LI>
<LI><A href="/searchHomeVDX.jsp?tabAction=VALUEMAP">Search</A></LI>
</UL>
</LI>
</UL>
</DIV>
</Td>
</tr>
</table>
</td>
</tr>
<!-- MENU PART CODE ENDS HERE-->
<tr><td>
<table width="790" border="0" height = "40px" cellspacing="0" cellpadding="0" align="left">
<tr>
<!--added to to hide vertical line & left align breadcrumbs for following list of pages-->
<td width="120" align="left" valign="top"></td>
<td width="1" bgcolor="#C0C0C0"><br></td><!-- vertical line -->
<td width="10"> </td><td width="630" align="left" valign="center" class="breadcrumb">
<a href="/home.jsp">Home</a> <img src="images/arrow.gif" width="19"
height="9" border="0" align="bottom">
<a href="/search.jsp">Saved Searches</a> <img src="images/arrow.gif" width="19"
height="9" border="0" align="bottom">
<a href="/searchgeneral.jsp">General Query</a> <img src="images/arrow.gif" width="19"
height="9" border="0" align="bottom">
<a href="/propertylist.jsp">Property List</a> <img src="images/arrow.gif" width="19"
height="9" border="0" align="bottom">
Property Detail
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</body>
</html>
<!-- Refactoring- show only the PopUp header part -->
<!-- End of Refactoring comps -->
<style type="text/css" media="Print">
#normalprint
{
display: none !important;
}
#fullprint
{
display:block !important;
}
#reportprint
{
display: none !important;
}
</style>
<script language="JavaScript" src="scripts/foreclosureFlags.js"> </script>
<div class="print" align="center">
<!--ICP Commercialist-->
</div>
<table width="600" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="120" valign="top">
<div style="width:125px;" class="screen">
<br>
<form action="/propertydetail.jsp" class="formtext">
<input type="hidden" name="refreshlist" value="yes">
<input type="hidden" name="index" value="2">
<input type="submit" value="Refresh Page" class="submitbutton"><br><br>
<input type="checkbox" name="301"
value="301"
checked> Owner Info<br>
<input type="checkbox" name="302"
value="302"
checked> Location Info<br>
<input type="checkbox" name="303"
value="303"
checked> Tax Info<br>
<input type="checkbox" name="304"
value="304"
checked> Characteristics<br>
<input type="checkbox" name="306"
value="306"
checked> Last Market Sale<br>
<input type="checkbox" name="308"
value="308"
checked> Sales History<br>
<input type="checkbox" name="309"
value="309"> Mortgage History<br>
</form>
</div>
</td>
<td style="font-size:2px;width:1px" bgcolor="#C0C0C0" class="leftmargin"> <br></td><!-- vertical line -->
<td valign="top" align="left">
<div id="main" style="width:625" >
<a name="top"></a>
<table width="600" border="0" cellspacing="0" cellpadding="0" align="center" style="padding-left:50px">
<tr>
<td class="forminstructions" align="center">
<div class="screen">
<!--
* --------------------------------------------------------------------------*/
* - 01/13/2005 - Shiny - ICP 27540 - Handle Streetmap display for properties without Property address
* --------------------------------------------------------------------------*/
-->
<script>
var salesHistType = "lastFourSales";
var fcHistType = "lastFourSales";
function sendPropMail()
{
var url = "/update?updatetype=email&type=EmailPropertyDetail&salesHistType="+salesHistType+"&fcHistType="+fcHistType;
window.location=url;
}
function printPage()
{
var normal=document.getElementById("normalprint");
var full= document.getElementById("fullprint");
window.print();
}
</script>
<table border="0" cellspacing="2" cellpadding="0" width="600">
<tr>
<td colspan="5" class="forminstructions" align="center">
<input type="button" value="Previous" class="submitbutton"
onClick="propSearchDetNav('1');">
<input type="button" value="Next" class="submitbutton"
onClick="propSearchDetNav('3');">
<!-- Add the "Record 1 of 70" -->
Record 2 of 999
<a href="#" onclick="printPage()"><img src="images/printer.gif" width="42" height="34" border="0" alt="Print this page." align="absmiddle"></a>
<a href="javascript:sendPropMail()">
<img src="images/email.jpg" width="32" height="25" border="0" alt="Email This Report" align="absmiddle"></a>
<input type="checkbox" name="chkPid_AAJ4yHAAMAAHfsTAAN0" id="selectPropTop" value="AAJ4yHAAMAAHfsTAAN0"
title="By checking the Checkbox the property will be selected within the Property list along with any additional properties selected"
onclick="updateCheckedMapTop('1', 'propertylist', 'AAJ4yHAAMAAHfsTAAN0');" false >
<label title="By checking the Checkbox the property will be selected within the Property list along with any additional properties selected"> Include in List </label>
<!--End Changes for ICP 18486-->
<br><br>
<!-- start of buttons -->
<!-- Added parameter for ICP 23191 -->
<input type="button" value="Comparable Properties" class="submitbutton"
onClick="window.location='/update?updatetype=prefcomp&type=compfilter&index=2&fromPage=detail'">
<!--ICP Commercialist-->
<input type="button" value="Neighbors" class="submitbutton"
onClick="window.location='/update?updatetype=prefneighbor&type=neighborfilter&index=2&fromPage=detail'"> <!--ICP 24656 -->
<br><br>
<input type="button" value="Realist Map" class="submitbutton"
onClick="javascript:propDetFeatures('streetmap');"> <!-- Changes for ICP 27540-->
<input type="button" value="Flood Map" class="submitbutton"
onClick="javascript:propDetFeatures('floodmap');">
<!-- Start Changes For ICP XXXX-- Handling the Browser Back Button From Assessor Map And Zoning Map Page -->
<input type="button" value="Assessor Map" class="submitbutton"
onClick="javascript:propDetFeatureswithIndex('assessormap','2');">
<!-- End Changes For ICP XXXX-- Handling the Browser Back Button From Assessor Map And Zoning Map Page -->
<br><br>
<!--ICP Commercialist-->
<input type="button" value="Neighborhood Profile" class="submitbutton"
onClick="window.location='/neighborprofile?SirsInfoType=search'">
<input type="button" value="Get Directions" class="submitbutton" onClick="javascript:propDetFeatures('drivingmap');">
<input type="button" value="Value Map" class="submitbutton" onClick="window.open('ValueMap.jsp?streetaddress= 4213 E 1st St&citystatezip=Los Angeles, CA 90063-1411','valueMapReport','width=1000,height=800,scrollbars=yes')">
<!-- end of buttons -->
<br><br>
</td>
</tr>
</table>
</div>
</td>
</tr>
</table>
<table border="0" width="700" cellspacing="0" cellpadding="0" align=center>
<tr><td class="detailpagetitle">Property Detail Report </td></tr>
<tr><td>
<div style="width:700px" id="fullprint" >
<table border="0" width="500" cellspacing="2" cellpadding="0" align=center>
<tr>
<td valign="middle" class="detailaddress"><label class="detailproplocatedat">Subject Property</label>
<br><br> 4213 E 1st St<br>
Los Angeles, CA 90063-1411<br>
Los Angeles County</td>
<td width="2%"></td><td align="center" valign="top"><img class="detailMap" src="/rlveimager?lat=34.037284&lon=-118.175246&path=detail&mapType=S" scrolling="no" /></td>
</tr>
</table>
</div>
<div style="display:none;font-size:11px;FONT-WEIGHT: bold;color:black;FONT-FAMILY: Verdana, Geneva, Arial, Helvetica, sans-serif; TEXT-DECORATION: none;"
align="center" id="normalprint">
<span> 4213 E 1st St Los Angeles, CA 90063-1411</span><br><span>Los Angeles County</span>
</div>
</td></tr>
</table>
<img width="700px" src="/images/border.jpeg" height="7px" style="padding-top:10px">
<table width="700" border="0" cellspacing="0" cellpadding="0">
<tr align="center">
<td valign="top" class="pagetitlebluelarge" align="center" colspan="6"><br>Multiple Building Card Property Summary<br><br></td>
</tr>
<script>
changeStylesForMac()
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
function completeSalesHistory()
{
var objSalesHist = document.getElementsByTagName("table");
var objAllSalesHist = document.getElementsByTagName("table");
if(objSalesHist.length > 0)
{
for(var ct = 0; ct<objSalesHist.length; ct++)
{
objName = objSalesHist[ct].id;
if(objName!=null && objName!="undefined")
{
if(objName.search("Sales History")!=-1)
{
objSalesHist[ct].style.display="none";
}
}
}
}
if(objAllSalesHist.length > 0)
{
for(var ct = 0; ct<objAllSalesHist.length; ct++)
{
objName = objAllSalesHist[ct].id;
if(objName!=null && objName!="undefined")
{
if(objName.search("All_Sales")!=-1)
{
objAllSalesHist[ct].style.display="block";
}
}
}
}
salesHistType = "Complete";
}
function lastFourSales()
{
var objSalesHist = document.getElementsByTagName("table");
var objAllSalesHist = document.getElementsByTagName("table");
if(objSalesHist.length > 0)
{
for(var ct = 0; ct<objSalesHist.length; ct++)
{
objName = objSalesHist[ct].id;
if(objName!=null && objName!="undefined")
{
if(objName.search("Sales History")!=-1)
{
objSalesHist[ct].style.display="block";
}
}
}
}
if(objAllSalesHist.length > 0)
{
for(var ct = 0; ct<objAllSalesHist.length; ct++)
{
objName = objAllSalesHist[ct].id;
if(objName!=null && objName!="undefined")
{
if(objName.search("All_Sales")!=-1)
{
objAllSalesHist[ct].style.display="none";
}
}
}
}
salesHistType = "lastFourSales";
}
function completeForeclosureHistory(showCompHistory)
{
var objFCHist = document.getElementsByTagName("table");
if(objFCHist.length > 0)
{
for(var ct = 0; ct<objFCHist.length; ct++)
{
objName = objFCHist[ct].id;
if(objName!=null && objName!="undefined")
{
if(objName.search("All_FCHistory")!=-1)
{
if(showCompHistory == 1) {
objFCHist[ct].style.display="block";
fcHistType = "FCComplete";
} else if(showCompHistory == 0) {
objFCHist[ct].style.display="none";
fcHistType = "lastFourFCSales";
}
}
}
}
}
changeHistoryLabel();
}
function changeHistoryLabel()
{
var objForeClosure=document.getElementById("fcHistory");
if(objForeClosure != "undefined")
{
if(objForeClosure.innerHTML!="undefined" && objForeClosure.innerHTML.indexOf("More History") != -1)
{
objForeClosure.innerHTML="<b><a href='#' onclick='completeForeclosureHistory(0);return false;'>Less History</a></b>"
}
else if(objForeClosure.innerHTML!="undefined" && objForeClosure.innerHTML.indexOf("Less History") != -1)
{
objForeClosure.innerHTML="<b><a href='#' onclick='completeForeclosureHistory(1);return false;'>More History</a></b>"
}
}
}
</script>
</table>
<table id="Owner Info" name="Owner Info" border="0" cellspacing="1" cellpadding="0" width="700">
<tr>
<td colspan="7"><font size="1px"></font></td>
</tr>
<tr>
<td colspan="7" class="detailreportheader">Owner Info:</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Owner Name<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">Garcia Raymond</td>
<td class="detailreport" width="24%" valign="top">Tax Billing Zip<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">91367</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Mail Owner Name<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">RAYMOND GARCIA</td>
<td class="detailreport" width="24%" valign="top">Tax Billing Zip+4<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">4162</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Owner Phone<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">(818) 887-0031</td>
<td class="detailreport" width="24%" valign="top">Annual Tax<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">$2,419</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Tax Billing Address<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">23301 Clarendon St </td>
<td class="detailreport" width="24%" valign="top">County Use Code<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">Duplex</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Tax Billing City & State<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">Woodland Hills CA</td>
<td class="detailreport" width="24%" valign="top">Universal Land Use<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">Duplex</td>
</tr>
</table>
<table id="Location Info" name="Location Info" border="0" cellspacing="1" cellpadding="0" width="700">
<tr>
<td colspan="7"><font size="1px"></font></td>
</tr>
<tr>
<td colspan="7" class="detailreportheader">Location Info:</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Zoning<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">Lcc3*</td>
<td class="detailreport" width="24%" valign="top">TGNO<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">635-E6</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Tract Number<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">5329</td>
<td class="detailreport" width="24%" valign="top">Census Tract<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">5310.00</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">School District<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">Los Angeles</td>
<td class="detailreport" width="24%" valign="top">Carrier Route<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">C042</td>
</tr>
</table>
<table id="Tax Info" name="Tax Info" border="0" cellspacing="1" cellpadding="0" width="700">
<tr>
<td colspan="7"><font size="1px"></font></td>
</tr>
<tr>
<td colspan="7" class="detailreportheader">Tax Info:</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Tax ID<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">5234-007-037</td>
<td class="detailreport" width="24%" valign="top">Total Assessment<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">$133,025</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Tax Year<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">2009</td>
<td class="detailreport" width="24%" valign="top">% Improv<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">40%</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Annual Tax<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">$2,419</td>
<td class="detailreport" width="24%" valign="top">Tax Area<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">932</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Assessment Year<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">2009</td>
<td class="detailreport" width="24%" valign="top">Legal Description<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">*tr=5329*(Ex Of St) Lot 18</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Land Assessment<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">$80,351</td>
<td class="detailreport" width="24%" valign="top">Lot Number<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">18</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Improved Assessment<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">$52,674</td>
<td class="detailreport" width="24%" valign="top">Block ID<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">9</td>
</tr>
<table id="Characteristics" name="Characteristics" border="0" cellspacing="1" cellpadding="0" width="700"><tr><td colspan="7"><font size="1px"></font></td></tr><tr><td colspan="7" class="detailreportheader">Characteristics:</td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Lot Acres<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td><td class="detailreport_results" width="25%" valign="top">.1235</td><td class="detailreport" width="24%" valign="top">Lot Sq Ft<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td><td class="detailreport_results" width="25%" valign="top">5,380</td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Building Sq Ft<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td><td class="detailreport_results" width="25%" valign="top">901</td><td class="detailreport" width="24%" valign="top">Gross Bldg Area<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td><td class="detailreport_results" width="25%" valign="top">901</td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Total Units<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td><td class="detailreport_results" width="25%" valign="top">2</td><td class="detailreport" width="24%" valign="top">Bedrooms<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td><td class="detailreport_results" width="25%" valign="top">2</td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Total Baths<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td><td class="detailreport_results" width="25%" valign="top">2</td><td class="detailreport" width="24%" valign="top">Year Built<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td><td class="detailreport_results" width="25%" valign="top">1928</td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Full Baths<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td><td class="detailreport_results" width="25%" valign="top">2</td><td class="detailreport" width="24%" valign="top">Topography<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td><td class="detailreport_results" width="25%" valign="top">Rolling/Hilly</td></tr>
</table>
<table id="Last Market Sale" name="Last Market Sale" border="0" cellspacing="1" cellpadding="0" width="700">
<tr>
<td colspan="7"><font size="1px"></font></td>
</tr>
<tr>
<td colspan="7" class="detailreportheader">Last Market Sale:</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Owner Name<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">Garcia Raymond</td>
</table>
<table id="All_Sales" name="All_Sales" border="0" cellspacing="1" cellpadding="0" width="700" style=" display:none;">
<tr>
<td colspan="4" class="detailreportheader">Sales History:</td>
<td colspan="4" class="detailreportheader" align="right"><a href="javascript:lastFourSales();">Less History</a></td>
</tr>
<tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Recording Date<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;">:</td><td class="detailreport_results" width="19%" valign="top">09/30/1991</td><td class="detailreport_results" width="19%" valign="top"></td><td class="detailreport_results" width="19%" valign="top"></td><td class="detailreport_results" width="19%" valign="top"></td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Nominal<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;">:</td><td class="detailreport_results" width="19%" valign="top">Y</td><td class="detailreport_results" width="19%" valign="top"></td><td class="detailreport_results" width="19%" valign="top"></td><td class="detailreport_results" width="19%" valign="top"></td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Buyer Name<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;">:</td><td class="detailreport_results" width="19%" valign="top">Garcia Raymond</td><td class="detailreport_results" width="19%" valign="top"></td><td class="detailreport_results" width="19%" valign="top"></td><td class="detailreport_results" width="19%" valign="top"></td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Seller Name<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;">:</td><td class="detailreport_results" width="19%" valign="top">Garcia Joseph</td><td class="detailreport_results" width="19%" valign="top"></td><td class="detailreport_results" width="19%" valign="top"></td><td class="detailreport_results" width="19%" valign="top"></td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Document No<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;">:</td><td class="detailreport_results" width="19%" valign="top"><a href="#" onclick="docImageValidation('2','19910930','1539942','000001539942');">1539942</a></td><td class="detailreport_results" width="19%" valign="top"><a href="#" onclick="docImageValidation('2','','','');"></a></td><td class="detailreport_results" width="19%" valign="top"><a href="#" onclick="docImageValidation('2','','','');"></a></td><td class="detailreport_results" width="19%" valign="top"><a href="#" onclick="docImageValidation('2','','','');"></a></td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Document Type<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;">:</td><td class="detailreport_results" width="19%" valign="top">Quit Claim Deed</td><td class="detailreport_results" width="19%" valign="top"></td><td class="detailreport_results" width="19%" valign="top"></td><td class="detailreport_results" width="19%" valign="top"></td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" colspan="5"> </td></tr>
</table>
<table id="Sales History" name="Sales History" border="0" cellspacing="1" cellpadding="0" width="700">
<tr>
<td colspan="8"><font size="1px"></font></td>
</tr>
<tr>
<td colspan="8" class="detailreportheader">Sales History:</td>
</tr>
<tr>
<td width="2%"> </td>
<td width="24%" class="detailreport" valign="top">Recording Date<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results" width="19%" valign="top">09/30/1991</td>
<td class="detailreport_results" width="19%" valign="top"></td>
<td class="detailreport_results" width="19%" valign="top"></td>
<td class="detailreport_results" width="19%" valign="top"></td>
</tr>
<tr>
<td width="2%"> </td>
<td width="24%" class="detailreport" valign="top">Nominal<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results" width="19%" valign="top">Y</td>
<td class="detailreport_results" width="19%" valign="top"></td>
<td class="detailreport_results" width="19%" valign="top"></td>
<td class="detailreport_results" width="19%" valign="top"></td>
</tr>
<tr>
<td width="2%"> </td>
<td width="24%" class="detailreport" valign="top">Buyer Name<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results" width="19%" valign="top">Garcia Raymond</td>
<td class="detailreport_results" width="19%" valign="top"></td>
<td class="detailreport_results" width="19%" valign="top"></td>
<td class="detailreport_results" width="19%" valign="top"></td>
</tr>
<tr>
<td width="2%"> </td>
<td width="24%" class="detailreport" valign="top">Seller Name<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results" width="19%" valign="top">Garcia Joseph</td>
<td class="detailreport_results" width="19%" valign="top"></td>
<td class="detailreport_results" width="19%" valign="top"></td>
<td class="detailreport_results" width="19%" valign="top"></td>
</tr>
<tr>
<td width="2%"> </td>
<td width="24%" class="detailreport" valign="top">Document No<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results" width="19%" valign="top">
<a href="#" onclick="docImageValidation('2','19910930','1539942','000001539942');">1539942</a>
</td><td class="detailreport_results" width="19%" valign="top">
</td><td class="detailreport_results" width="19%" valign="top">
</td><td class="detailreport_results" width="19%" valign="top">
</td></tr>
<tr>
<td width="2%"> </td>
<td width="24%" class="detailreport" valign="top">Document Type<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results" width="19%" valign="top">Quit Claim Deed</td>
<td class="detailreport_results" width="19%" valign="top"></td>
<td class="detailreport_results" width="19%" valign="top"></td>
<td class="detailreport_results" width="19%" valign="top"></td>
</tr>
<tr align="center">
<td valign="top" class="pagetitlebluelarge" align="center" colspan="6"><br>Building 1
of 2<br><br></td>
</tr>
<script>
changeStylesForMac()
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
function completeSalesHistory()
{
var objSalesHist = document.getElementsByTagName("table");
var objAllSalesHist = document.getElementsByTagName("table");
if(objSalesHist.length > 0)
{
for(var ct = 0; ct<objSalesHist.length; ct++)
{
objName = objSalesHist[ct].id;
if(objName!=null && objName!="undefined")
{
if(objName.search("Sales History")!=-1)
{
objSalesHist[ct].style.display="none";
}
}
}
}
if(objAllSalesHist.length > 0)
{
for(var ct = 0; ct<objAllSalesHist.length; ct++)
{
objName = objAllSalesHist[ct].id;
if(objName!=null && objName!="undefined")
{
if(objName.search("All_Sales")!=-1)
{
objAllSalesHist[ct].style.display="block";
}
}
}
}
salesHistType = "Complete";
}
function lastFourSales()
{
var objSalesHist = document.getElementsByTagName("table");
var objAllSalesHist = document.getElementsByTagName("table");
if(objSalesHist.length > 0)
{
for(var ct = 0; ct<objSalesHist.length; ct++)
{
objName = objSalesHist[ct].id;
if(objName!=null && objName!="undefined")
{
if(objName.search("Sales History")!=-1)
{
objSalesHist[ct].style.display="block";
}
}
}
}
if(objAllSalesHist.length > 0)
{
for(var ct = 0; ct<objAllSalesHist.length; ct++)
{
objName = objAllSalesHist[ct].id;
if(objName!=null && objName!="undefined")
{
if(objName.search("All_Sales")!=-1)
{
objAllSalesHist[ct].style.display="none";
}
}
}
}
salesHistType = "lastFourSales";
}
function completeForeclosureHistory(showCompHistory)
{
var objFCHist = document.getElementsByTagName("table");
if(objFCHist.length > 0)
{
for(var ct = 0; ct<objFCHist.length; ct++)
{
objName = objFCHist[ct].id;
if(objName!=null && objName!="undefined")
{
if(objName.search("All_FCHistory")!=-1)
{
if(showCompHistory == 1) {
objFCHist[ct].style.display="block";
fcHistType = "FCComplete";
} else if(showCompHistory == 0) {
objFCHist[ct].style.display="none";
fcHistType = "lastFourFCSales";
}
}
}
}
}
changeHistoryLabel();
}
function changeHistoryLabel()
{
var objForeClosure=document.getElementById("fcHistory");
if(objForeClosure != "undefined")
{
if(objForeClosure.innerHTML!="undefined" && objForeClosure.innerHTML.indexOf("More History") != -1)
{
objForeClosure.innerHTML="<b><a href='#' onclick='completeForeclosureHistory(0);return false;'>Less History</a></b>"
}
else if(objForeClosure.innerHTML!="undefined" && objForeClosure.innerHTML.indexOf("Less History") != -1)
{
objForeClosure.innerHTML="<b><a href='#' onclick='completeForeclosureHistory(1);return false;'>More History</a></b>"
}
}
}
</script>
</table>
<table id="Owner Info" name="Owner Info" border="0" cellspacing="1" cellpadding="0" width="700">
<tr>
<td colspan="7"><font size="1px"></font></td>
</tr>
<tr>
<td colspan="7" class="detailreportheader">Owner Info:</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Owner Name<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">Garcia Raymond</td>
<td class="detailreport" width="24%" valign="top">Tax Billing Zip+4<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">4162</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Mail Owner Name<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">RAYMOND GARCIA</td>
<td class="detailreport" width="24%" valign="top">Annual Tax<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">$2,419</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Owner Phone<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">(818) 887-0031</td>
<td class="detailreport" width="24%" valign="top">County Use Code<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">Duplex</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Tax Billing City & State<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">Woodland Hills CA</td>
<td class="detailreport" width="24%" valign="top">Universal Land Use<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">Duplex</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Tax Billing Zip<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">91367</td>
</table>
<table id="Location Info" name="Location Info" border="0" cellspacing="1" cellpadding="0" width="700">
<tr>
<td colspan="7"><font size="1px"></font></td>
</tr>
<tr>
<td colspan="7" class="detailreportheader">Location Info:</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Zoning<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">Lcc3*</td>
<td class="detailreport" width="24%" valign="top">TGNO<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">635-E6</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Tract Number<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">5329</td>
<td class="detailreport" width="24%" valign="top">Census Tract<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">5310.00</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">School District<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">Los Angeles</td>
</table>
<table id="Tax Info" name="Tax Info" border="0" cellspacing="1" cellpadding="0" width="700">
<tr>
<td colspan="7"><font size="1px"></font></td>
</tr>
<tr>
<td colspan="7" class="detailreportheader">Tax Info:</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Tax ID<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">5234-007-037</td>
<td class="detailreport" width="24%" valign="top">Total Assessment<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">$133,025</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Tax Year<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">2009</td>
<td class="detailreport" width="24%" valign="top">% Improv<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">40%</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Annual Tax<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">$2,419</td>
<td class="detailreport" width="24%" valign="top">Tax Area<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">932</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Assessment Year<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">2009</td>
<td class="detailreport" width="24%" valign="top">Legal Description<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">*tr=5329*(Ex Of St) Lot 18</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Land Assessment<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">$80,351</td>
<td class="detailreport" width="24%" valign="top">Lot Number<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">18</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Improved Assessment<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">$52,674</td>
<td class="detailreport" width="24%" valign="top">Block ID<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">9</td>
</tr>
<table id="Characteristics" name="Characteristics" border="0" cellspacing="1" cellpadding="0" width="700"><tr><td colspan="7"><font size="1px"></font></td></tr><tr><td colspan="7" class="detailreportheader">Characteristics:</td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Lot Acres<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td><td class="detailreport_results" width="25%" valign="top">.1235</td><td class="detailreport" width="24%" valign="top">Lot Sq Ft<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td><td class="detailreport_results" width="25%" valign="top">5,380</td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Building Sq Ft<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td><td class="detailreport_results" width="25%" valign="top">490</td><td class="detailreport" width="24%" valign="top">Gross Bldg Area<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td><td class="detailreport_results" width="25%" valign="top">901</td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Total Units<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td><td class="detailreport_results" width="25%" valign="top">1</td><td class="detailreport" width="24%" valign="top">Bedrooms<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td><td class="detailreport_results" width="25%" valign="top">1</td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Total Baths<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td><td class="detailreport_results" width="25%" valign="top">1</td><td class="detailreport" width="24%" valign="top">Year Built<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td><td class="detailreport_results" width="25%" valign="top">1928</td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Topography<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td><td class="detailreport_results" width="25%" valign="top">Rolling/Hilly</td></tr>
</table>
<table id="Last Market Sale" name="Last Market Sale" border="0" cellspacing="1" cellpadding="0" width="700">
<tr>
<td colspan="7"><font size="1px"></font></td>
</tr>
<tr>
<td colspan="7" class="detailreportheader">Last Market Sale:</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Owner Name<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">Garcia Raymond</td>
</table>
<table id="All_Sales" name="All_Sales" border="0" cellspacing="1" cellpadding="0" width="700" style=" display:none;">
<tr>
<td colspan="4" class="detailreportheader">Sales History:</td>
<td colspan="4" class="detailreportheader" align="right"><a href="javascript:lastFourSales();">Less History</a></td>
</tr>
<tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Recording Date<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;">:</td><td class="detailreport_results" width="19%" valign="top">09/30/1991</td><td class="detailreport_results" width="19%" valign="top"></td><td class="detailreport_results" width="19%" valign="top"></td><td class="detailreport_results" width="19%" valign="top"></td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Nominal<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;">:</td><td class="detailreport_results" width="19%" valign="top">Y</td><td class="detailreport_results" width="19%" valign="top"></td><td class="detailreport_results" width="19%" valign="top"></td><td class="detailreport_results" width="19%" valign="top"></td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Buyer Name<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;">:</td><td class="detailreport_results" width="19%" valign="top">Garcia Raymond</td><td class="detailreport_results" width="19%" valign="top"></td><td class="detailreport_results" width="19%" valign="top"></td><td class="detailreport_results" width="19%" valign="top"></td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Seller Name<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;">:</td><td class="detailreport_results" width="19%" valign="top">Garcia Joseph</td><td class="detailreport_results" width="19%" valign="top"></td><td class="detailreport_results" width="19%" valign="top"></td><td class="detailreport_results" width="19%" valign="top"></td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Document No<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;">:</td><td class="detailreport_results" width="19%" valign="top"><a href="#" onclick="docImageValidation('2','19910930','1539942','000001539942');">1539942</a></td><td class="detailreport_results" width="19%" valign="top"><a href="#" onclick="docImageValidation('2','','','');"></a></td><td class="detailreport_results" width="19%" valign="top"><a href="#" onclick="docImageValidation('2','','','');"></a></td><td class="detailreport_results" width="19%" valign="top"><a href="#" onclick="docImageValidation('2','','','');"></a></td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" width="24%" valign="top">Document Type<label style="display:none">:</label></td><td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;">:</td><td class="detailreport_results" width="19%" valign="top">Quit Claim Deed</td><td class="detailreport_results" width="19%" valign="top"></td><td class="detailreport_results" width="19%" valign="top"></td><td class="detailreport_results" width="19%" valign="top"></td></tr><tr><td class="detailreport_results" width="2%"> </td><td class="detailreport" colspan="5"> </td></tr>
</table>
<table id="Sales History" name="Sales History" border="0" cellspacing="1" cellpadding="0" width="700">
<tr>
<td colspan="8"><font size="1px"></font></td>
</tr>
<tr>
<td colspan="8" class="detailreportheader">Sales History:</td>
</tr>
<tr>
<td width="2%"> </td>
<td width="24%" class="detailreport" valign="top">Recording Date<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results" width="19%" valign="top">09/30/1991</td>
<td class="detailreport_results" width="19%" valign="top"></td>
<td class="detailreport_results" width="19%" valign="top"></td>
<td class="detailreport_results" width="19%" valign="top"></td>
</tr>
<tr>
<td width="2%"> </td>
<td width="24%" class="detailreport" valign="top">Nominal<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results" width="19%" valign="top">Y</td>
<td class="detailreport_results" width="19%" valign="top"></td>
<td class="detailreport_results" width="19%" valign="top"></td>
<td class="detailreport_results" width="19%" valign="top"></td>
</tr>
<tr>
<td width="2%"> </td>
<td width="24%" class="detailreport" valign="top">Buyer Name<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results" width="19%" valign="top">Garcia Raymond</td>
<td class="detailreport_results" width="19%" valign="top"></td>
<td class="detailreport_results" width="19%" valign="top"></td>
<td class="detailreport_results" width="19%" valign="top"></td>
</tr>
<tr>
<td width="2%"> </td>
<td width="24%" class="detailreport" valign="top">Seller Name<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results" width="19%" valign="top">Garcia Joseph</td>
<td class="detailreport_results" width="19%" valign="top"></td>
<td class="detailreport_results" width="19%" valign="top"></td>
<td class="detailreport_results" width="19%" valign="top"></td>
</tr>
<tr>
<td width="2%"> </td>
<td width="24%" class="detailreport" valign="top">Document No<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results" width="19%" valign="top">
<a href="#" onclick="docImageValidation('2','19910930','1539942','000001539942');">1539942</a>
</td><td class="detailreport_results" width="19%" valign="top">
</td><td class="detailreport_results" width="19%" valign="top">
</td><td class="detailreport_results" width="19%" valign="top">
</td></tr>
<tr>
<td width="2%"> </td>
<td width="24%" class="detailreport" valign="top">Document Type<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results" width="19%" valign="top">Quit Claim Deed</td>
<td class="detailreport_results" width="19%" valign="top"></td>
<td class="detailreport_results" width="19%" valign="top"></td>
<td class="detailreport_results" width="19%" valign="top"></td>
</tr>
<tr align="center">
<td valign="top" class="pagetitlebluelarge" align="center" colspan="6"><br>Building 2
of 2<br><br></td>
</tr>
<script>
changeStylesForMac()
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
function completeSalesHistory()
{
var objSalesHist = document.getElementsByTagName("table");
var objAllSalesHist = document.getElementsByTagName("table");
if(objSalesHist.length > 0)
{
for(var ct = 0; ct<objSalesHist.length; ct++)
{
objName = objSalesHist[ct].id;
if(objName!=null && objName!="undefined")
{
if(objName.search("Sales History")!=-1)
{
objSalesHist[ct].style.display="none";
}
}
}
}
if(objAllSalesHist.length > 0)
{
for(var ct = 0; ct<objAllSalesHist.length; ct++)
{
objName = objAllSalesHist[ct].id;
if(objName!=null && objName!="undefined")
{
if(objName.search("All_Sales")!=-1)
{
objAllSalesHist[ct].style.display="block";
}
}
}
}
salesHistType = "Complete";
}
function lastFourSales()
{
var objSalesHist = document.getElementsByTagName("table");
var objAllSalesHist = document.getElementsByTagName("table");
if(objSalesHist.length > 0)
{
for(var ct = 0; ct<objSalesHist.length; ct++)
{
objName = objSalesHist[ct].id;
if(objName!=null && objName!="undefined")
{
if(objName.search("Sales History")!=-1)
{
objSalesHist[ct].style.display="block";
}
}
}
}
if(objAllSalesHist.length > 0)
{
for(var ct = 0; ct<objAllSalesHist.length; ct++)
{
objName = objAllSalesHist[ct].id;
if(objName!=null && objName!="undefined")
{
if(objName.search("All_Sales")!=-1)
{
objAllSalesHist[ct].style.display="none";
}
}
}
}
salesHistType = "lastFourSales";
}
function completeForeclosureHistory(showCompHistory)
{
var objFCHist = document.getElementsByTagName("table");
if(objFCHist.length > 0)
{
for(var ct = 0; ct<objFCHist.length; ct++)
{
objName = objFCHist[ct].id;
if(objName!=null && objName!="undefined")
{
if(objName.search("All_FCHistory")!=-1)
{
if(showCompHistory == 1) {
objFCHist[ct].style.display="block";
fcHistType = "FCComplete";
} else if(showCompHistory == 0) {
objFCHist[ct].style.display="none";
fcHistType = "lastFourFCSales";
}
}
}
}
}
changeHistoryLabel();
}
function changeHistoryLabel()
{
var objForeClosure=document.getElementById("fcHistory");
if(objForeClosure != "undefined")
{
if(objForeClosure.innerHTML!="undefined" && objForeClosure.innerHTML.indexOf("More History") != -1)
{
objForeClosure.innerHTML="<b><a href='#' onclick='completeForeclosureHistory(0);return false;'>Less History</a></b>"
}
else if(objForeClosure.innerHTML!="undefined" && objForeClosure.innerHTML.indexOf("Less History") != -1)
{
objForeClosure.innerHTML="<b><a href='#' onclick='completeForeclosureHistory(1);return false;'>More History</a></b>"
}
}
}
</script>
</table>
<table id="Owner Info" name="Owner Info" border="0" cellspacing="1" cellpadding="0" width="700">
<tr>
<td colspan="7"><font size="1px"></font></td>
</tr>
<tr>
<td colspan="7" class="detailreportheader">Owner Info:</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Owner Name<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">Garcia Raymond</td>
<td class="detailreport" width="24%" valign="top">Tax Billing Zip+4<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">4162</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Mail Owner Name<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">RAYMOND GARCIA</td>
<td class="detailreport" width="24%" valign="top">Annual Tax<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">$2,419</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Owner Phone<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">(818) 887-0031</td>
<td class="detailreport" width="24%" valign="top">County Use Code<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">Duplex</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Tax Billing City & State<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">Woodland Hills CA</td>
<td class="detailreport" width="24%" valign="top">Universal Land Use<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">Duplex</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Tax Billing Zip<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">91367</td>
</table>
<table id="Location Info" name="Location Info" border="0" cellspacing="1" cellpadding="0" width="700">
<tr>
<td colspan="7"><font size="1px"></font></td>
</tr>
<tr>
<td colspan="7" class="detailreportheader">Location Info:</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Zoning<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">Lcc3*</td>
<td class="detailreport" width="24%" valign="top">TGNO<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">635-E6</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Tract Number<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">5329</td>
<td class="detailreport" width="24%" valign="top">Census Tract<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">5310.00</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">School District<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">Los Angeles</td>
</table>
<table id="Tax Info" name="Tax Info" border="0" cellspacing="1" cellpadding="0" width="700">
<tr>
<td colspan="7"><font size="1px"></font></td>
</tr>
<tr>
<td colspan="7" class="detailreportheader">Tax Info:</td>
</tr>
<tr>
<td width="2%"> </td>
<td class="detailreport" width="24%" valign="top">Tax ID<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">5234-007-037</td>
<td class="detailreport" width="24%" valign="top">Total Assessment<label style="display:none">:</label></td>
<td style="FONT-SIZE: 12px; COLOR: #8D8E90; LINE-HEIGHT: 18px; FONT-FAMILY: Arial, Helvetica, sans-serif;font-weight:bold; padding-left:4px;padding-right:4px;
vertical-align:top;" width="1%">:</td>
<td class="detailreport_results"width="25%" valign="top">$133,025</td>
The response exceeded the maximum length and was truncated. If you'd like to view the full response, click the "Display Response in Browser" button, then view the source in your web browser.
The extractor pattern I apply is as follows:
vertical-align:top;" width="1%">:</td><td class="detailreport_results" width="25%" valign="top">~@BUILDING_SQ_FT@~</td>
The above extractor pattern produces three sequences: 901, 490, and 411.
The option I use to invoke the script is as follows:
But I apply this script after a few other extractors have been applied.
I'm using a typical "write to a file" script. Such as the following:
//Use the following if not using web interface
outputFile = "C:/Documents and Settings/Adrian/Desktop/XXX/XXX/XXX.csv";
//Error catching.
try
{
//Set-up file to be written.
File file = new File ( outputFile );
fileExists = file.exists();
//Open up the file to be appended.
out = new FileWriter( file, true );
session.log( "Writing data to a file." );
//Write headers only one time.
if (!fileExists)
{
// Write out the headers.
out.write("\"" + "BLDG_SQFT_LOW" + "\"" + ",");
out.write("\"" + "BLDG_SQFT_HIGH" + "\"" + ",");
out.write("\"" + "TOTAL_RECORDS" + "\"" + ",");
out.write("\"" + "ADDRESS" + "\"" + ",");
out.write("\"" + "CITY" + "\"" + ",");
out.write("\"" + "STATE" + "\"" + ",");
out.write("\"" + "ZIP" + "\"" + ",");
out.write("\"" + "OWNER_NAME" + "\"" + ",");
out.write("\"" + "OWNER_NAME_TWO" + "\"" + "," );
out.write("\"" + "MAIL_OWNER_NAME" + "\"" + ",");
out.write("\"" + "TAX_BILL_ADDRESS" + "\"" + ",");
out.write("\"" + "TAX_BILL_CITY_STATE" + "\"" + ",");
out.write("\"" + "TAX_BILL_ZIP" + "\"" + ",");
out.write("\"" + "TAX_BILL_ZIP_FOUR" + "\"" + ",");
out.write("\"" + "COUNTY_USE_CODE" + "\"" + ",");
out.write("\"" + "UNIVERSAL_LAND_USE" + "\"" + ",");
out.write("\"" + "TGNO" + "\"" + ",");
out.write("\"" + "APN" + "\"" + ",");
out.write("\"" + "LOT_SQ_FT" + "\"" + ",");
out.write("\"" + "BUILDING_SQ_FT" + "\"" + ",");
out.write("\"" + "GROSS_BUILDING_AREA" + "\"" + ",");
out.write("\"" + "TOTAL_UNITS" + "\"" + ",");
out.write("\"" + "BEDROOMS" + "\"" + ",");
out.write("\"" + "TOTAL_BATHS" + "\"" + ",");
out.write("\"" + "FULL_BATHS" + "\"" + ",");
out.write("\"" + "YEAR_BUILT" + "\"" + ",");
out.write("\"" + "LAST_MARKET_SALE_RECORDING_DATE" + "\"" + ",");
out.write("\"" + "LAST_MARKET_SALE_SETTLEMENT_DATE" + "\"" + ",");
out.write("\"" + "LAST_MARKET_SALE_SALE_PRICE" + "\"" + ",");
out.write("\"" + "LAST_MARKET_SALE_DEED_TYPE" + "\"" + ",");
out.write("\"" + "LAST_MARKET_SALE_BUYER_NAME" + "\"" + ",");
out.write("\"" + "LAST_MARKET_SALE_SELLER_NAME" + "\"" + ",");
out.write( "\n" );
}
//Remove comma
String [] variables = {"ADDRESS","CITY","STATE","ZIP","OWNER_NAME","OWNER_NAME_TWO","MAIL_OWNER_NAME","TAX_BILL_ADDRESS","TAX_BILL_CITY_STATE","TAX_BILL_ZIP","TAX_BILL_ZIP_FOUR","COUNTY_USE_CODE","UNIVERSAL_LAND_USE","TGNO","LOT_SQ_FT","BUILDING_SQ_FT","GROSS_BUILDING_AREA","TOTAL_UNITS","BEDROOMS","TOTAL_BATHS","FULL_BATHS","YEAR_BUILT","LAST_MARKET_SALE_RECORDING_DATE","LAST_MARKET_SALE_SETTLEMENT_DATE","LAST_MARKET_SALE_SALE_PRICE","LAST_MARKET_SALE_DEED_TYPE","LAST_MARKET_SALE_BUYER_NAME","LAST_MARKET_SALE_SELLER_NAME"};
i = 0;
// Iterate through each variable in the array above
while (i < variables.length){
//Get the variables to be fixed
value = session.getVariable(variables[i]);
//Log the UNFIXED values
session.log("UNFIXED: " + variables[i] + " = " + value);
if(value != null){
//Remove non-numerical elements
value = value.replaceAll(",", "");
// Set variables with new values
dataRecord.put(variables[i], value);
session.setVariable(variables[i], value);
//Log the FIXED values
session.log("FIXED " + variables[i] + " = " + session.getVariable(variables[i]));
}
i++;
}
//Replace text
String [] variables = {"MAIL_OWNER_NAME"};
i = 0;
// Iterate through each variable in the array above
while (i < variables.length){
//Get the variables to be fixed
value = session.getVariable(variables[i]);
//Log the UNFIXED values
session.log("UNFIXED: " + variables[i] + " = " + value);
if(value != null){
//Remove non-numerical elements
value = value.replaceAll("&", "& ");
// Set variables with new values
dataRecord.put(variables[i], value);
session.setVariable(variables[i], value);
//Log the FIXED values
session.log("FIXED " + variables[i] + " = " + session.getVariable(variables[i]));
}
i++;
}
//Remove hyphen
String [] variables = {"APN"};
i = 0;
// Iterate through each variable in the array above
while (i < variables.length){
//Get the variables to be fixed
value = session.getVariable(variables[i]);
//Log the UNFIXED values
session.log("UNFIXED: " + variables[i] + " = " + value);
if(value != null){
//Remove non-numerical elements
value = value.replaceAll("-", "");
// Set variables with new values
dataRecord.put(variables[i], value);
session.setVariable(variables[i], value);
//Log the FIXED values
session.log("FIXED " + variables[i] + " = " + session.getVariable(variables[i]));
}
i++;
}
//Write columns.
out.write( session.getVariable( "BLDG_SQFT_LOW" ) + "," );
out.write( session.getVariable( "BLDG_SQFT_HIGH" ) + "," );
out.write( session.getVariable( "TOTAL_RECORDS" ) + "," );
out.write( session.getVariable( "ADDRESS" ) + "," );
out.write( session.getVariable( "CITY" ) + "," );
out.write( session.getVariable( "STATE" ) + "," );
out.write( session.getVariable( "ZIP" ) + "," );
out.write( session.getVariable( "OWNER_NAME" ) + "," );
out.write( session.getVariable( "OWNER_NAME_TWO" ) + "," );
out.write( session.getVariable( "MAIL_OWNER_NAME" ) + "," );
out.write( session.getVariable( "TAX_BILL_ADDRESS" ) + "," );
out.write( session.getVariable( "TAX_BILL_CITY_STATE" ) + "," );
out.write( session.getVariable( "TAX_BILL_ZIP" ) + "," );
out.write( session.getVariable( "TAX_BILL_ZIP_FOUR" ) + "," );
out.write( session.getVariable( "COUNTY_USE_CODE" ) + "," );
out.write( session.getVariable( "UNIVERSAL_LAND_USE" ) + "," );
out.write( session.getVariable( "TGNO" ) + "," );
out.write( session.getVariable( "APN" ) + "," );
out.write( session.getVariable( "LOT_SQ_FT" ) + "," );
out.write( session.getVariable( "BUILDING_SQ_FT" ) + "," );
out.write( session.getVariable( "GROSS_BUILDING_AREA" ) + "," );
out.write( session.getVariable( "TOTAL_UNITS" ) + "," );
out.write( session.getVariable( "BEDROOMS" ) + "," );
out.write( session.getVariable( "TOTAL_BATHS" ) + "," );
out.write( session.getVariable( "FULL_BATHS" ) + "," );
out.write( session.getVariable( "YEAR_BUILT" ) + "," );
out.write( session.getVariable( "LAST_MARKET_SALE_RECORDING_DATE" ) + "," );
out.write( session.getVariable( "LAST_MARKET_SALE_SETTLEMENT_DATE" ) + "," );
out.write( session.getVariable( "LAST_MARKET_SALE_SALE_PRICE" ) + "," );
out.write( session.getVariable( "LAST_MARKET_SALE_DEED_TYPE" ) + "," );
out.write( session.getVariable( "LAST_MARKET_SALE_BUYER_NAME" ) + "," );
out.write( session.getVariable( "LAST_MARKET_SALE_SELLER_NAME" ) + "," );
out.write( "\n" );
//Close up the file.
out.close();
//Clear variables.
session.setVariable("BLDG_SQFT_LOW","");
session.setVariable("BLDG_SQFT_HIGH","");
session.setVariable("TOTAL_RECORDS","");
session.setVariable("ADDRESS","");
session.setVariable("CITY","");
session.setVariable("STATE","");
session.setVariable("ZIP","");
session.setVariable("OWNER_NAME","");
session.setVariable("OWNER_NAME_TWO","");
session.setVariable("MAIL_OWNER_NAME","");
session.setVariable("TAX_BILL_ADDRESS","");
session.setVariable("TAX_BILL_CITY_STATE","");
session.setVariable("TAX_BILL_ZIP","");
session.setVariable("TAX_BILL_ZIP_FOUR","");
session.setVariable("COUNTY_USE_CODE","");
session.setVariable("UNIVERSAL_LAND_USE","");
session.setVariable("TGNO","");
session.setVariable("APN","");
session.setVariable("LOT_SQ_FT","");
session.setVariable("BUILDING_SQ_FT","");
session.setVariable("GROSS_BUILDING_AREA","");
session.setVariable("TOTAL_UNITS","");
session.setVariable("BEDROOMS","");
session.setVariable("TOTAL_BATHS","");
session.setVariable("FULL_BATHS","");
session.setVariable("YEAR_BUILT","");
session.setVariable("LAST_MARKET_SALE_RECORDING_DATE","");
session.setVariable("LAST_MARKET_SALE_SETTLEMENT_DATE","");
session.setVariable("LAST_MARKET_SALE_SALE_DATE","");
session.setVariable("LAST_MARKET_SALE_DEED_TYPE","");
session.setVariable("LAST_MARKET_SALE_BUYER_NAME","");
session.setVariable("LAST_MARKET_SALE_SELLER_NAME","");
}
catch( Exception e )
{
session.log( "An error occurred while writing the data to a file: " + e.getMessage() );
}
The above information will write out 411 but what I want is the first one which is 901.
I hope I included enough information.
Regards,
Adrian
Adrian, It's interesting.
Adrian,
It's interesting. Todd and I were just discussing this potential point of confusion. Right now we say you can invoke a script "After each pattern application". I suggested we change that to say, "After each pattern match". In so doing I think it helps clarify the other option, "After pattern is applied".
See, when applying a pattern you can have two potential outcomes: As few as one matches or no match at all. Therefore, when invoking a script "After pattern is applied" you not only call your script every time, regardless of whether the extractor found any matches, but you also call your script after all potential matches have matched regardless of how many matches there may have been.
So, with this option your script will only be called once. If you're saving your matches as session variables and there are more than one set of matches, only the very last set of matches will be set as session variables since the session variable's values get overwritten each time the pattern matches.
Now, if instead you invoke your script "After each pattern application" (or "After each pattern match"), your script will be called as many times as the number of matches or it will not be called at all if the extractor does not match. Invoking your script this way will allow you to handle the results of each match (901, 490, & 411) individually.
In order for this to work it's necessary that you combine your extractor patterns for this scrapeable file into one extractor pattern. You may opt to use the special ~@DATARECORD@~ token which allows you to refer to sub-extractor matches as part of your dataset in your script. This also allows you to refer to the variables that matched using dataRecord.get rather than session.getVariable...saving you from clearing your variables after each loop.
Combine all extractor patterns into one and you call your script "After each pattern application". For each match, you might evaluate on a value of one of the variables in order to decide whether or not to write that dataset's data to the database.
For example you could have the following at the top of your script...
if (Integer.parseInt( dataRecord.get("BUILDING_SQ_FT") ) > 500)
{
session.log("Insert my data into the database");
//////
//All your insert into db code goes here.
////
///
///
//
}
else
{
session.log("Don't insert my data because the building sqft ain't enough");
//
//Nothing more than a message needs to go here.
}
Hope this helps.
-Scott