(request
        :sender (agent-identifier :name iotestagent@%AP% )
        :receiver (agent-identifier :name ams@%AP% )
        :content
"
<?xml version='1.0' encoding='ISO-8859-1'?>

<!DOCTYPE QueryPlan SYSTEM 'QueryPlan.dtd'>

<QueryPlan>
  <UserAgent>
    <ue>'plan1.xml@hap'</ue>
  </UserAgent>
  <DSAMap>
    <me Extent='REINZ' DSAAddress='REINZ@hap' />
    <me Extent='NZLRI' DSAAddress='NZLRI@hap' />
    <me Extent='Geocode' DSAAddress='Geocode@hap' />
    <me Extent='Flood' DSAAddress='Hazards@hap' />
    <me Extent='Landslide' DSAAddress='Hazards@hap' />
  </DSAMap>
  <Result Name='8' />
  <QueryNode Name='0' Type='Select'>
    <Select>
      <se Index='0'>p1.zone.description</se>
      <se Index='1'>p1.Suburb</se>
      <se Index='2'>p1.StreetNumName</se>
    </Select>
    <From>
      <fe Extent='REINZ' Variable='p1' />
    </From>
    <Where>
      <we>p1 . Suburb = $ Suburb </we>
      <we>p1 . StreetNumName = $ Address </we>
    </Where>
  </QueryNode>
  <QueryNode Name='1' Type='SelectAt'>
    <UseInput>
      <Compare>
        <GetNode Name='0' Index='0' RefersTo='p1 . zone . description ' />
        <CompareWith>t10 . coarse </CompareWith>
      </Compare>
      <Compare>
        <GetNode Name='0' Index='1' RefersTo='p1 . Suburb ' />
        <CompareWith>t10 . fine </CompareWith>
      </Compare>
      <Compare>
        <GetNode Name='0' Index='2' RefersTo='p1 . StreetNumName ' />
        <CompareWith>t10 . address </CompareWith>
      </Compare>
    </UseInput>
    <Select>
      <se Index='0'>t10.easting</se>
      <se Index='1'>t10.northing</se>
      <se Index='2'>
        <GetNode Name='0' Index='1' RefersTo='p1 . Suburb ' />
      </se>
    </Select>
    <From>
      <fe Extent='Geocode' Variable='t10' />
    </From>
    <Where />
  </QueryNode>
  <QueryNode Name='2' Type='SelectAt'>
    <UseInput>
      <Compare>
        <GetNode Name='1' Index='0' RefersTo='t10 . easting ' />
        <CompareWith>t8 . easting </CompareWith>
      </Compare>
      <Compare>
        <GetNode Name='1' Index='1' RefersTo='t10 . northing ' />
        <CompareWith>t8 . northing </CompareWith>
      </Compare>
    </UseInput>
    <Select>
      <se Index='0'>
        <GetNode Name='1' Index='2' RefersTo='p1 . Suburb ' />
      </se>
      <se Index='1'>t8.landUse</se>
    </Select>
    <From>
      <fe Extent='NZLRI' Variable='t8' />
    </From>
    <Where />
  </QueryNode>
  <QueryNode Name='3' Type='SelectAt'>
    <UseInput>
      <Compare>
        <GetNode Name='2' Index='0' RefersTo='p1 . Suburb ' />
        <CompareWith>p2 . Suburb </CompareWith>
      </Compare>
    </UseInput>
    <Select>
      <se Index='0'>p2.zone.description</se>
      <se Index='1'>p2.Suburb</se>
      <se Index='2'>p2.StreetNumName</se>
      <se Index='3'>
        <GetNode Name='2' Index='1' RefersTo='t8 . landUse ' />
      </se>
      <se Index='4'>p2.SalePrice</se>
      <se Index='5'>p2.Area</se>
    </Select>
    <From>
      <fe Extent='REINZ' Variable='p2' />
    </From>
    <Where />
  </QueryNode>
  <QueryNode Name='4' Type='SelectAt'>
    <UseInput>
      <Compare>
        <GetNode Name='3' Index='0' RefersTo='p2 . zone . description ' />
        <CompareWith>t14 . coarse </CompareWith>
      </Compare>
      <Compare>
        <GetNode Name='3' Index='1' RefersTo='p2 . Suburb ' />
        <CompareWith>t14 . fine </CompareWith>
      </Compare>
      <Compare>
        <GetNode Name='3' Index='2' RefersTo='p2 . StreetNumName ' />
        <CompareWith>t14 . address </CompareWith>
      </Compare>
    </UseInput>
    <Select>
      <se Index='0'>t14.easting</se>
      <se Index='1'>t14.northing</se>
      <se Index='2'>
        <GetNode Name='3' Index='3' RefersTo='t8 . landUse ' />
      </se>
      <se Index='3'>
        <GetNode Name='3' Index='4' RefersTo='p2 . SalePrice ' />
      </se>
      <se Index='4'>
        <GetNode Name='3' Index='5' RefersTo='p2 . Area ' />
      </se>
      <se Index='5'>
        <GetNode Name='3' Index='2' RefersTo='p2 . StreetNumName ' />
      </se>
    </Select>
    <From>
      <fe Extent='Geocode' Variable='t14' />
    </From>
    <Where />
  </QueryNode>
  <QueryNode Name='5' Type='SelectAt'>
    <UseInput>
      <Compare>
        <GetNode Name='4' Index='0' RefersTo='t14 . easting ' />
        <CompareWith>t12 . easting </CompareWith>
      </Compare>
      <Compare>
        <GetNode Name='4' Index='1' RefersTo='t14 . northing ' />
        <CompareWith>t12 . northing </CompareWith>
      </Compare>
    </UseInput>
    <Select>
      <se Index='0'>
        <GetNode Name='4' Index='0' RefersTo='t14 . easting ' />
      </se>
      <se Index='1'>
        <GetNode Name='4' Index='1' RefersTo='t14 . northing ' />
      </se>
      <se Index='2'>
        <GetNode Name='4' Index='0' RefersTo='t14 . easting ' />
      </se>
      <se Index='3'>
        <GetNode Name='4' Index='1' RefersTo='t14 . northing ' />
      </se>
      <se Index='4'>
        <GetNode Name='4' Index='2' RefersTo='t8 . landUse ' />
      </se>
      <se Index='5'>t12.landUse</se>
      <se Index='6'>
        <GetNode Name='4' Index='3' RefersTo='p2 . SalePrice ' />
      </se>
      <se Index='7'>
        <GetNode Name='4' Index='4' RefersTo='p2 . Area ' />
      </se>
      <se Index='8'>
        <GetNode Name='4' Index='5' RefersTo='p2 . StreetNumName ' />
      </se>
    </Select>
    <From>
      <fe Extent='NZLRI' Variable='t12' />
    </From>
    <Where />
  </QueryNode>
  <QueryNode Name='6' Type='SelectAt'>
    <UseInput>
      <Compare>
        <GetNode Name='5' Index='0' RefersTo='t14 . easting ' />
        <CompareWith>t4 . easting </CompareWith>
      </Compare>
      <Compare>
        <GetNode Name='5' Index='1' RefersTo='t14 . northing ' />
        <CompareWith>t4 . northing </CompareWith>
      </Compare>
    </UseInput>
    <Select>
      <se Index='0'>
        <GetNode Name='5' Index='2' RefersTo='t14 . easting ' />
      </se>
      <se Index='1'>
        <GetNode Name='5' Index='3' RefersTo='t14 . northing ' />
      </se>
      <se Index='2'>
        <GetNode Name='5' Index='4' RefersTo='t8 . landUse ' />
      </se>
      <se Index='3'>
        <GetNode Name='5' Index='5' RefersTo='t12 . landUse ' />
      </se>
      <se Index='4'>
        <GetNode Name='5' Index='6' RefersTo='p2 . SalePrice ' />
      </se>
      <se Index='5'>
        <GetNode Name='5' Index='7' RefersTo='p2 . Area ' />
      </se>
      <se Index='6'>
        <GetNode Name='5' Index='8' RefersTo='p2 . StreetNumName ' />
      </se>
      <se Index='7'>t4.risk</se>
    </Select>
    <From>
      <fe Extent='Landslide' Variable='t4' />
    </From>
    <Where />
  </QueryNode>
  <QueryNode Name='7' Type='SelectAt'>
    <UseInput>
      <Compare>
        <GetNode Name='6' Index='0' RefersTo='t14 . easting ' />
        <CompareWith>t0 . easting </CompareWith>
      </Compare>
      <Compare>
        <GetNode Name='6' Index='1' RefersTo='t14 . northing ' />
        <CompareWith>t0 . northing </CompareWith>
      </Compare>
    </UseInput>
    <Select>
      <se Index='0'>
        <GetNode Name='6' Index='2' RefersTo='t8 . landUse ' />
      </se>
      <se Index='1'>
        <GetNode Name='6' Index='3' RefersTo='t12 . landUse ' />
      </se>
      <se Index='2'>
        <GetNode Name='6' Index='4' RefersTo='p2 . SalePrice ' />
      </se>
      <se Index='3'>
        <GetNode Name='6' Index='5' RefersTo='p2 . Area ' />
      </se>
      <se Index='4'>
        <GetNode Name='6' Index='6' RefersTo='p2 . StreetNumName ' />
      </se>
      <se Index='5'>t0.risk</se>
      <se Index='6'>
        <GetNode Name='6' Index='7' RefersTo='t4 . risk ' />
      </se>
    </Select>
    <From>
      <fe Extent='Flood' Variable='t0' />
    </From>
    <Where />
  </QueryNode>
  <QueryNode Name='8' Type='Join'>
    <Select>
      <se Index='0'>
        <GetNode Name='7' Index='2' RefersTo='p2 . SalePrice ' />
      </se>
      <se Index='1'>
        <GetNode Name='7' Index='3' RefersTo='p2 . Area ' />
      </se>
      <se Index='2'>
        <GetNode Name='7' Index='4' RefersTo='p2 . StreetNumName ' />
      </se>
      <se Index='3'>
        <GetNode Name='7' Index='5' RefersTo='t0 . risk ' />
      </se>
      <se Index='4'>
        <GetNode Name='7' Index='6' RefersTo='t4 . risk ' />
      </se>
    </Select>
    <Where>
      <we>
        <GetNode Name='7' Index='0' RefersTo='t8 . landUse ' />=
        <GetNode Name='7' Index='1' RefersTo='t12 . landUse ' />
      </we>
    </Where>
  </QueryNode>
</QueryPlan>"
:language mama
)