private synchronized IAddress searchForAddress(
      IAddress searchCriteria, String searchTypeText, String listItem, String searchStatus)
      throws PresentationLogicException {
    // LOG.info("getAddressByPostcode:");

    if (searchCriteria == null) throw new PresentationLogicException("No Search Criteria given.");

    // select
    // AMBIGLIST,ORGANISATION,SUBBUILDING,BUILDINGNAME,BUILDINGNUMBER,DEPSTREET,STREET,DEPLOCALITY,LOCALITY,POSTTOWN,COUNTY,POSTCODE,ADDR,ADDKEY,ORGKEY,LISTTYPE,SEARCHSTATUS,LISTCOUNT,AMBIGLIST,BARCODE,ADEPOS,ADESCORE,ADPNRLOC,MSCORE,FFLAG,RESCODE,ERRNO,ERRTEXT,COUNTRY,COUNTRYCODE,MATCHLVL,PCLVL,INPCLVL,PCCHGLVL,PCCHGTYP,VANITYFLAGS,ELEMS_UNMATCHED,ELEMS_MATCHED,ELEMS_CORRECT,ELEMS_MISSPELLED,ELEMS_MISSING,FIELDSTATUS,OUTPUTSTATUS,ADDFMT_ABBR,ADDFMT_CONC,ADDFMT_TRUN,ADDFMT_ELIM,ADMINNUMBER,TRADNUMBER,LONLOCOUT,ADMINCOUNTY,TRADCOUNTY from PCLOOKUP where POSTCODE=

    StringBuilder l_query = new StringBuilder();
    StringBuilder l_restQuery = new StringBuilder();
    StringBuilder l_queryType = new StringBuilder();

    l_query.append(
        "AMBIGLIST,ORGANISATION,SUBBUILDING,BUILDINGNAME,BUILDINGNUMBER,"
            + "DEPSTREET,STREET,DEPLOCALITY,LOCALITY,POSTTOWN,COUNTY,"
            + "POSTCODE(PP=16),ADDR,ADDKEY,ORGKEY,LISTTYPE,SEARCHSTATUS,"
            + "LISTCOUNT,AMBIGLIST,BARCODE,ADEPOS,ADESCORE,ADPNRLOC,"
            + "MSCORE,FFLAG,RESCODE,ERRNO,ERRTEXT,COUNTRY,COUNTRYCODE,"
            + "MATCHLVL,PCLVL,INPCLVL,PCCHGLVL,PCCHGTYP,VANITYFLAGS,"
            + "ELEMS_UNMATCHED,ELEMS_MATCHED,ELEMS_CORRECT,"
            + "ELEMS_MISSPELLED,ELEMS_MISSING,FIELDSTATUS,"
            + "OUTPUTSTATUS,ADDFMT_ABBR,ADDFMT_CONC,ADDFMT_TRUN,"
            + "ADDFMT_ELIM,ADMINNUMBER,TRADNUMBER,LONLOCOUT,ADMINCOUNTY,"
            + "TRADCOUNTY,PCG,DHA,OLDPCG,OLDDHA from "); // WDEV-14455

    String postcode = "";
    String Addr = "";
    String buildingNumber = "";
    String street = "";
    String postTown = "";
    String county = "";

    l_restQuery.append("");

    if (searchTypeText.equals("SEARCH")) {
      if (searchCriteria.getAddressSearchText() != null
          && searchCriteria.getAddressSearchText() != "") {
        Addr = searchCriteria.getAddressSearchText();
        if (l_restQuery.length() == 0) l_restQuery.append(" WHERE ADDR=" + "\"" + Addr + "\"");
      }
    } else if (searchTypeText.equals("SELECT")) {
      if (searchCriteria.getAddressPostCode() != null) {
        postcode = searchCriteria.getAddressPostCode().toString();
        l_restQuery.append(" WHERE POSTCODE=" + "\"" + postcode + "\"");
      }

      if (searchStatus != null && !searchStatus.equals("")) {
        if (l_restQuery.length() == 0)
          l_restQuery.append(" WHERE SEARCHSTATUS=" + "\"" + searchStatus + "\"");
        else l_restQuery.append(",SEARCHSTATUS=" + "\"" + searchStatus + "\"");
      }

      if (searchCriteria.getAddressBuildingNumber() != null
          && searchCriteria.getAddressBuildingNumber() != "") {
        buildingNumber = searchCriteria.getAddressBuildingNumber().toString();
        if (l_restQuery.length() == 0)
          l_restQuery.append(" WHERE BUILDINGNUMBER=" + "\"" + buildingNumber + "\"");
        else l_restQuery.append(",BUILDINGNUMBER=" + "\"" + buildingNumber + "\"");
      }
      if (searchCriteria.getAddressStreet() != null && searchCriteria.getAddressStreet() != "") {
        street = searchCriteria.getAddressStreet().toString();
        if (l_restQuery.length() == 0) l_restQuery.append(" WHERE STREET=" + "\"" + street + "\"");
        else l_restQuery.append(",STREET=" + "\"" + street + "\"");
      }

      if (searchCriteria.getAddressPostTown() != null
          && searchCriteria.getAddressPostTown() != "") {
        postTown = searchCriteria.getAddressPostTown().toString();
        if (l_restQuery.length() == 0)
          l_restQuery.append(" WHERE POSTTOWN=" + "\"" + postTown + "\"");
        else l_restQuery.append(",POSTTOWN=" + "\"" + postTown + "\"");
      }
      if (searchCriteria.getAddressCounty() != null && searchCriteria.getAddressCounty() != "") {
        county = searchCriteria.getAddressCounty().toString();
        if (l_restQuery.length() == 0) l_restQuery.append(" WHERE COUNTY=" + "\"" + county + "\"");
        else l_restQuery.append(",COUNTY=" + "\"" + county + "\"");
      }

      // ListItem for Ambiguity selection
      if (listItem != null && listItem != "") {
        if (l_restQuery.length() == 0)
          l_restQuery.append(" WHERE LISTITEM=" + "\"" + listItem + "\"");
        else l_restQuery.append(",LISTITEM=" + "\"" + listItem + "\"");
      }
    } else if (searchTypeText.equals("PCLOOKUP")) {
      if (searchCriteria.getAddressPostCode() != null) {
        postcode = searchCriteria.getAddressPostCode().toString();
        l_restQuery.append(" WHERE POSTCODE=" + "\"" + postcode + "\"");
      }
    }

    l_queryType.append(searchTypeText);

    l_query.append(l_queryType);
    l_query.append(l_restQuery);

    try {
      parseQuery(l_query.toString());
      LOG.info("CAPSCAN Query: " + l_query.toString());
    } catch (Exception e) {
      LOG.error(e.getMessage());
      return null;
    }

    capscan.client.McConnection addressManagerConnection = null;

    try {
      // WDEV-17607
      addressManagerConnection = AddressManager.getConnection();
      if (addressManagerConnection == null
          || (addressManagerConnection != null && addressManagerConnection.errno() != 0)
          || (addressManagerConnection != null && addressManagerConnection.errno() != 1)) {
        AddressManager.connect(
            EnvironmentConfig.getCapscanServerName(),
            EnvironmentConfig.getCapscanPool(),
            McConnection.STATELESS);
        addressManagerConnection = AddressManager.getConnection();
      }
      // WDEV-17607
    } catch (Exception e) {
      LOG.error(e.getMessage());
      return null;
    }

    if (addressManagerConnection == null) {
      LOG.error(
          "Error getting Address Manager connection. Please see server logs for more information.");
      return null;
    }

    // WDEV-19795
    int EventId =
        createSystemLogEntry(
                SystemLogType.PostCodeLookup,
                SystemLogLevel.INFORMATION,
                "Postcode lookup:"
                    + select.toString()
                    + " "
                    + where.toString()
                    + " "
                    + data.toString())
            .getSystemLogEventId();
    // WDEV-19795

    resultsSearch = addressManagerConnection.search(searchType, select, where, data, 15);

    if (resultsSearch != null
        && addressManagerConnection != null
        && addressManagerConnection.errno() == capscan.client.McConnection.OK) {
      // Display results
      // int count = results.length;

      //
      // use for logging search query at level ERROR

      String pools[] = addressManagerConnection.pools();
      LOG.info("QUERY RESULTS");
      pools = addressManagerConnection.pools();
      String column;
      int count = 0;
      int i;
      int k;
      int j;
      count = resultsSearch.length;

      for (j = k = 0; j < pools.length; j++) {
        if (pools.length > 1) {
          LOG.info("Pool " + pools[j] + ":\r\n");
        }

        for (i = 0; k < count && i < select.size(); i++, k++) {
          column = (String) select.elementAt(i);
          LOG.info(column + ":\r\n");
          if (column.equals("AMBIGLIST")) {
            printAmbigList(resultsSearch[k]);
          } else {
            LOG.info("\t" + resultsSearch[k] + "\r\n");
          }
        }
      }

      if (select.size() > 1) {
        String strSubBuildingName = getColumnValue("SUBBUILDING");
        boolean displaystrSubBuildingName = false;

        String strBuildingName = getColumnValue("BUILDINGNAME");
        if (strSubBuildingName != null && !strSubBuildingName.equals("")) {
          if (!strBuildingName.equals("")) {
            // WDEV-17696
            if (ConfigFlag.DOM.HEARTS_REPLICATE_PATIENTS.getValue()) {
              if (strSubBuildingName != null
                  && strBuildingName != null
                  && ConfigFlag.DOM.HEARTS_ADDRESS_LINE_MAXLEN != null) {
                if (strSubBuildingName.length() + strBuildingName.length()
                    <= ConfigFlag.DOM.HEARTS_ADDRESS_LINE_MAXLEN.getValue()) {
                  searchCriteria.setAddressBuildingName(
                      strSubBuildingName + ", " + strBuildingName);
                  displaystrSubBuildingName = true;
                } else searchCriteria.setAddressBuildingName(strBuildingName);
              } else searchCriteria.setAddressBuildingName(strBuildingName);
            } else searchCriteria.setAddressBuildingName(strBuildingName);
          } else searchCriteria.setAddressBuildingName(strSubBuildingName);
        } else {
          searchCriteria.setAddressBuildingName(strBuildingName);
        }

        searchCriteria.setAddressBuildingNumber(getColumnValue("BUILDINGNUMBER"));
        searchCriteria.setAddressLocality(getColumnValue("LOCALITY"));
        // WDEV-15963
        // support for DEPSTREET
        if (getColumnValue("DEPSTREET") != null && !getColumnValue("DEPSTREET").equals(""))
          searchCriteria.setAddressStreet(
              getColumnValue("DEPSTREET") + "," + getColumnValue("STREET"));
        else searchCriteria.setAddressStreet(getColumnValue("STREET"));

        // WDEV-17553
        searchCriteria.setAddressPostTown(getColumnValue("POSTTOWN"));
        if (getColumnValue("POSTTOWN") != null
            && !getColumnValue("POSTTOWN").equals(getColumnValue("COUNTY")))
          searchCriteria.setAddressCounty(getColumnValue("COUNTY"));
        else searchCriteria.setAddressCounty("");

        // WDEV-15963
        searchCriteria.setAddressPostCode(getColumnValue("POSTCODE(PP=16)"));
        searchCriteria.setAddressSearchText(getColumnValue("SEARCHSTATUS"));

        // WDEV-17696
        if (displaystrSubBuildingName)
          searchCriteria.setAddressOrganisation(getColumnValue("ORGANISATION"));
        else if (getColumnValue("ORGANISATION") != null) {

          String strSubBuildingNameNoComma =
              strSubBuildingName != null && strSubBuildingName.length() > 0
                  ? "," + strSubBuildingName
                  : ""; // WDEV-19643
          searchCriteria.setAddressOrganisation(
              !getColumnValue("ORGANISATION").equals("")
                  ? getColumnValue("ORGANISATION") + strSubBuildingNameNoComma
                  : strSubBuildingName);
        }
        // WDEV-14455
        if (ConfigFlag.UI.CAPSCAN_USE_OLDPCT_CODE.getValue()) {
          searchCriteria.setPCTcode(stripspaces(getColumnValue("OLDPCG")));
        } else {
          searchCriteria.setPCTcode(stripspaces(getColumnValue("PCG")));
        }
      }
    } else {
      if (addressManagerConnection != null) {
        LOG.error("error: " + addressManagerConnection.strerror(addressManagerConnection.errno()));
        return null;
      } else {
        LOG.error("error: connection null");
        return null;
      }
    }

    return searchCriteria;
  }
  /*
   * (non-Javadoc)
   * WDEV-21978
   * WDEV-21975
   * @see ims.framework.interfaces.IAddressProvider#validPostcode(java.lang.String)
   * Validate post code
   * Receives post code and returns it if valid. return null if invalid
   *
   * if EnvironmentConfig.getCapscanServerName() is blank, will return blank (for non PDS forms)
   */
  public String validPostcode(String postCode) {

    select = new Vector<String>();
    where = new Vector();
    data = new Vector();
    String r = "";

    String l_query =
        "SELECT AMBIGLIST,ORGANISATION,SUBBUILDING,BUILDINGNAME,BUILDINGNUMBER,"
            + "DEPSTREET,STREET,DEPLOCALITY,LOCALITY,POSTTOWN,COUNTY,"
            + "POSTCODE(PP=16),ADDR,ADDKEY,ORGKEY,LISTTYPE,SEARCHSTATUS,"
            + "LISTCOUNT,AMBIGLIST,BARCODE,ADEPOS,ADESCORE,ADPNRLOC,"
            + "MSCORE,FFLAG,RESCODE,ERRNO,ERRTEXT,COUNTRY,COUNTRYCODE,"
            + "MATCHLVL,PCLVL,INPCLVL,PCCHGLVL,PCCHGTYP,VANITYFLAGS,"
            + "ELEMS_UNMATCHED,ELEMS_MATCHED,ELEMS_CORRECT,"
            + "ELEMS_MISSPELLED,ELEMS_MISSING,FIELDSTATUS,"
            + "OUTPUTSTATUS,ADDFMT_ABBR,ADDFMT_CONC,ADDFMT_TRUN,"
            + "ADDFMT_ELIM,ADMINNUMBER,TRADNUMBER,LONLOCOUT,ADMINCOUNTY,"
            + "TRADCOUNTY,PCG,DHA,OLDPCG,OLDDHA from BROWSE WHERE POSTCODE=\""
            + stripspaces(postCode)
            + "\"";

    try {
      parseQuery(l_query.toString());
      LOG.info("CAPSCAN Query: " + l_query.toString());
    } catch (Exception e) {
      LOG.error(e.getMessage());
      // WDEV-23175
      int EventId =
          createSystemLogEntry(
                  SystemLogType.APPLICATION,
                  SystemLogLevel.INFORMATION,
                  "Postcode lookup:" + e.getMessage())
              .getSystemLogEventId();
      return postCode; // WDEV-23175 - On any exception return the postcode to allow the user to
      // continue
      // WDEV-23175
    }

    capscan.client.McConnection addressManagerConnection = null;
    try {
      addressManagerConnection = AddressManager.getConnection();
      if (addressManagerConnection == null
          || (addressManagerConnection != null && addressManagerConnection.errno() != 0)
          || (addressManagerConnection != null && addressManagerConnection.errno() != 1)) {
        AddressManager.connect(
            EnvironmentConfig.getCapscanServerName(),
            EnvironmentConfig.getCapscanPool(),
            McConnection.STATELESS);
        addressManagerConnection = AddressManager.getConnection();
      }
    } catch (Exception e) {
      LOG.error(e.getMessage());
      // WDEV-23175
      int EventId =
          createSystemLogEntry(
                  SystemLogType.APPLICATION,
                  SystemLogLevel.INFORMATION,
                  "Postcode lookup:" + e.getMessage())
              .getSystemLogEventId();
      return postCode; // WDEV-23175 - On any exception return the postcode to allow the user to
      // continue
      // WDEV-23175
    }

    if (addressManagerConnection == null) {
      LOG.error(
          "Error getting Address Manager connection. Please see server logs for more information.");
      // WDEV-23175
      int EventId =
          createSystemLogEntry(
                  SystemLogType.APPLICATION,
                  SystemLogLevel.INFORMATION,
                  "Error getting Address Manager connection. Please see server logs for more information.")
              .getSystemLogEventId();
      return postCode; // WDEV-23175 - On any exception return the postcode to allow the user to
      // continue
      // WDEV-23175
    }

    int EventId =
        createSystemLogEntry(
                SystemLogType.PostCodeLookup,
                SystemLogLevel.INFORMATION,
                "Postcode lookup:"
                    + select.toString()
                    + " "
                    + where.toString()
                    + " "
                    + data.toString())
            .getSystemLogEventId();

    // WDEV-23175 resultsSearch = null even with valid connection
    try {
      resultsSearch = addressManagerConnection.search(searchType, select, where, data, 15);
      r = getColumnValue("POSTCODE(PP=16)");
    } catch (
        Exception e2) // WDEV-23175 catch any other exceptions (e.g expired licence - you will get a
    // connection but results will be null)
    {
      LOG.error(
          "Error getting results from CAPSCAN server connection. Got the connection but no results.  Please check CAPSCAN licence"
              + e2.getMessage());
      // WDEV-23175
      EventId =
          createSystemLogEntry(
                  SystemLogType.APPLICATION,
                  SystemLogLevel.INFORMATION,
                  "Error getting results from CAPSCAN server connection. Got the connection but no results.  Please check CAPSCAN licence"
                      + e2.getMessage())
              .getSystemLogEventId();
      return postCode; // Return the postCode to allow the user to continue
      // WDEV-23175
    }

    if (!stripspaces(postCode).equals(stripspaces(r))) {
      return null;
    } else {
      return r;
    }
  }
  @SuppressWarnings("static-access")
  private HashMap<String, String> searchForDistance(IAddress searchCriteria, String units) {

    StringBuilder l_query = new StringBuilder();
    StringBuilder l_restQuery = new StringBuilder();

    l_query.append(units + ",NEARESTRECORDS from PSEARCH");

    if (searchCriteria.getAddressPostCode() == null) return null;

    String strPostCode = stripspaces(searchCriteria.getAddressPostCode().toString());

    if (strPostCode.length() > 7) {
      strPostCode = strPostCode.substring(0, 7); // only take full postcode for nearcode criteria
    }

    l_restQuery.append(" WHERE ADDR=" + "\"" + strPostCode + "\"");

    // apply radius
    if (ConfigFlag.UI.CAPSCAN_DIST_SEARCH_RADIUS.getValue() != ""
        && !ConfigFlag.UI.CAPSCAN_DIST_SEARCH_RADIUS.getValue().equals("-1"))
      l_restQuery.append(",RADIUS=" + ConfigFlag.UI.CAPSCAN_DIST_SEARCH_RADIUS.getValue());

    // apply maxrecords
    if (ConfigFlag.UI.CAPSCAN_DIST_MAX_RECORDS.getValue() != "")
      l_restQuery.append(",MAXRECORDS=" + ConfigFlag.UI.CAPSCAN_DIST_MAX_RECORDS.getValue());

    l_query.append(l_restQuery);

    try {
      parseQuery(l_query.toString());
      LOG.info("Nearcode Query: " + l_query.toString());
    } catch (Exception e) {
      LOG.error(e.getMessage());
      return null;
    }

    capscan.client.NcConnection distanceManagerConnection = null;

    try {
      // WDEV-17607
      distanceManagerConnection = AddressManager.getncConnection();
      if (distanceManagerConnection == null
          || (distanceManagerConnection != null && distanceManagerConnection.errno() != 0)) {
        AddressManager.ncConnect(
            EnvironmentConfig.getCapscanServerName(),
            EnvironmentConfig.getCapscanDistPool(),
            NcConnection.STATELESS);
        distanceManagerConnection = AddressManager.getncConnection();
      }
      // WDEV-17607

      distanceManagerConnection = AddressManager.getncConnection();
    } catch (Exception e) {
      LOG.error(e.getMessage());
      return null;
    }

    if (distanceManagerConnection == null) {
      LOG.error(
          "Error getting Distance Manager connection. Please see server logs for more information.");
      return null;
    }

    resultsSearch = distanceManagerConnection.search(searchType, select, where, data, 15);

    if (resultsSearch != null
        && distanceManagerConnection != null
        && distanceManagerConnection.errno() == capscan.client.NcConnection.OK) {
      if (select.size() > 1) {
        // fill Map here
        String pools[] = distanceManagerConnection.pools();
        LOG.info("QUERY RESULTS");
        pools = distanceManagerConnection.pools();
        String column;
        int count = 0;
        int k;
        int j;
        count = resultsSearch.length;
        StringBuffer strUnitDistances, strCodes;

        strUnitDistances = new StringBuffer();
        strCodes = new StringBuffer();

        for (j = k = 0; j < pools.length; j++) {
          if (pools.length > 1) {
            LOG.info("Pool " + pools[j] + ":\r\n");
          }

          // Get unit distances first
          for (k = 0; k < count; k++) {
            if (k < select.size()) column = (String) select.elementAt(k);
            else column = "";
            if (column.equals("MILES") || column.equals("KILOMETERS"))
              strUnitDistances.append(resultsSearch[k]);
          }

          // get corresponding codes
          for (k = 0; k < count; k++) {
            if (k < select.size()) column = (String) select.elementAt(k);
            else column = "";
            if (column.equals("NEARESTRECORDS")) strCodes.append(resultsSearch[k]);
          }
        }

        putResultDistanceAndCode(strUnitDistances, strCodes);
      }
    } else {
      if (distanceManagerConnection != null) {
        LOG.error(
            "error: " + distanceManagerConnection.strerror(distanceManagerConnection.errno()));
        return null;
      } else {
        LOG.error("error: connection null");
        return null;
      }
    }

    if (resultMap == null) return null;

    return new HashMap<String, String>(resultMap);
  }
  private synchronized String[] getCoOrds(IAddress searchCriteria, LatitudeLogitudeFormat[] lformat)
      throws DomainRuntimeException {
    // DEGREES DEG
    // RADIANS RAD
    // SPACES  SPA Spaces instead of colons
    // SYMBOLS SYM Degrees, Minutes and Seconds symbols instead of colons
    // OSGB36  Ordnance Survey of Great Britain (default) datum (default)
    // WGS84   World Geodetic Standard 1984 datum

    LOG.info("getLatitudeLogitude:");

    if (searchCriteria == null && searchCriteria.getAddressPostCode() == null)
      throw new DomainRuntimeException("No Search Criteria given.");

    StringBuilder l_query = new StringBuilder();
    StringBuilder l_latitudeQuery = new StringBuilder();
    StringBuilder l_longitudeQuery = new StringBuilder();

    String strPostCode = stripspaces(searchCriteria.getAddressPostCode().toString());

    if (lformat == null) {
      l_query.append(" LATITUDE(DEG),LONGITUDE(DEG) from ");
    } else if (lformat.length == 1) {
      switch (lformat[0].getId()) {
        case LatitudeLogitudeFormat.EDEGREES:
          l_query.append(" LATITUDE(DEG),LONGITUDE(DEG) from ");
          break;
        case LatitudeLogitudeFormat.ERADIANS:
          l_query.append(" LATITUDE(RAD),LONGITUDE(RAD) from ");
          break;
        case LatitudeLogitudeFormat.ESPACES:
          l_query.append(" LATITUDE(SPA),LONGITUDE(SPA) from ");
          break;
        case LatitudeLogitudeFormat.ESYMBOLS:
          l_query.append(" LATITUDE(SYM),LONGITUDE(SYM) from ");
          break;
        default:
          l_query.append(" LATITUDE(DEG),LONGITUDE(DEG) from ");
          break;
      }
    } else if (lformat.length == 2) {
      // two formats specified
      switch (lformat[0].getId()) {
        case LatitudeLogitudeFormat.EDEGREES:
          l_latitudeQuery.append(" LATITUDE(DEG,");
          l_longitudeQuery.append(" LONGITUDE(DEG,");
          break;
        case LatitudeLogitudeFormat.ERADIANS:
          l_latitudeQuery.append(" LATITUDE(RAD,");
          l_longitudeQuery.append(" LONGITUDE(RAD,");
          break;
        case LatitudeLogitudeFormat.ESPACES:
          l_latitudeQuery.append(" LATITUDE(SPA,");
          l_longitudeQuery.append(" LONGITUDE(SPA,");
          break;
        case LatitudeLogitudeFormat.ESYMBOLS:
          l_latitudeQuery.append(" LATITUDE(SYM,");
          l_longitudeQuery.append(" LONGITUDE(SYM,");
          break;
        default:
          l_query.append(" LATITUDE(DEG),LONGITUDE(DEG) from ");
          break;
      }
      switch (lformat[1].getId()) {
        case LatitudeLogitudeFormat.ESPACES:
          l_latitudeQuery.append("SPA)");
          l_longitudeQuery.append("SPA)");
          break;
        case LatitudeLogitudeFormat.ESYMBOLS:
          l_latitudeQuery.append("SYM)");
          l_longitudeQuery.append("SYM)");
          break;
        case LatitudeLogitudeFormat.EOSGB36:
          l_latitudeQuery.append("OSGB36)");
          l_longitudeQuery.append("OSGB36)");
          break;
        case LatitudeLogitudeFormat.EWGS84:
          l_latitudeQuery.append("WGS84)");
          l_longitudeQuery.append("WGS84)");
          break;
        default:
          if (l_query.toString() == "") l_query.append(" LATITUDE(DEG),LONGITUDE(DEG) from ");
          else break;
          break;
      }
    }

    try {
      l_query.append("PCLOOKUP WHERE POSTCODE = " + strPostCode);
      parseQuery(l_query.toString());
      LOG.info("CAPSCAN GEO Query: " + l_query.toString());
    } catch (Exception e) {
      throw new DomainRuntimeException(e.getMessage());
    }

    capscan.client.McConnection addressManagerConnection = null;

    try {
      addressManagerConnection = AddressManager.getConnection();
    } catch (Exception e) {
      LOG.error(e.getMessage());
      return null;
    }

    if (addressManagerConnection == null) {
      LOG.error(
          "Error getting Address Manager connection. Please see server logs for more information.");
      return null;
    }

    resultsSearch = addressManagerConnection.search(searchType, select, where, data, 15);

    return resultsSearch;
  }