/**
   * Get the lastest border wait times from the database.
   *
   * @param view
   * @param result
   */
  private void getBorderWaits(BorderWaitView view, List<GenericRow> result) {
    ArrayList<BorderWaitItem> northboundBorderWaitItems = new ArrayList<BorderWaitItem>();
    ArrayList<BorderWaitItem> southboundBorderWaitItems = new ArrayList<BorderWaitItem>();
    BorderWaitItem item;

    int numResults = result.size();

    for (int i = 0; i < numResults; i++) {
      item = new BorderWaitItem();

      String direction = result.get(i).getString(BorderWaitColumns.BORDER_WAIT_DIRECTION);
      int route = result.get(i).getInt(BorderWaitColumns.BORDER_WAIT_ROUTE);

      item.setTitle(result.get(i).getString(BorderWaitColumns.BORDER_WAIT_TITLE));
      item.setLane(result.get(i).getString(BorderWaitColumns.BORDER_WAIT_LANE));
      item.setUpdated(result.get(i).getString(BorderWaitColumns.BORDER_WAIT_UPDATED));
      item.setWait(result.get(i).getInt(BorderWaitColumns.BORDER_WAIT_TIME));

      if (direction.equalsIgnoreCase("northbound")) {
        item.setRouteIcon(USRouteIcon.get(route));
        northboundBorderWaitItems.add(item);
      } else {
        item.setRouteIcon(CanadaRouteIcon.get(route));
        southboundBorderWaitItems.add(item);
      }
    }

    view.hideProgressIndicator();
    view.renderNorthbound(northboundBorderWaitItems);
    view.renderSouthbound(southboundBorderWaitItems);
    view.refresh();
  }