Sean, thanks for jumping in and answering John's questions. About choosing the right foam, I intentionally avoided the open cell vs. closed cell foam debate. I did this partly because it's worthy of an article all by itself, but mainly I didn't include it because, despite all the warnings the two sides issue about the other, I've never personally seen a problem caused by using open cell where they should've used closed cell or vice versa. I'm sure things like that happen; I just haven't seen it yet.
Spray Foam On Roof Deck
The United States has adapted to using sprayfoam insulation and a new technology called Wall Injection to retrofit existing wall construction by drilling small holes between wall studs in the structures framing and filling the void with a less aggressive expanding water based foam. This allows existing home and business owners to conserve energy by creating a thermal envelope in their existing structure.
The Canadian National Building Code references the CAN/ULC S705.2 National Application Standard which must be followed during all installations of 2lb medium density closed cell polyurethane foam. Every installer of CAN/ULC-S705.1 compliant medium density, spray applied foam must be licensed in order to spray foam and hold valid photo ID issued by their Quality Assurance Program (QAP) provider showing their license is in good standing.