Moncton city council has voted to give the Rising Tide Community Initiative $6 million over three years to fund affordable housing project.