For Astrophotography we should have a clear dark sky with good seeing, good transparency and no light pollution.

Unfortunately, lack of regulations against light pollution makes it significant in most cities, so on humid nights transparency drops easily.
Negative effects of low transparency are two:

• in one hand part of the light from celestial objects is absorbed, reducing its brightness and
• on the other hand artificial lighting (light pollution) is reflected resulting in sky background brightness that covers fainter deep space objects.

You can see in this photo taken at my home in a low transparency night that artificial light scattered by air humidity makes it impossible to see the dimmest stars.

In contrast with that, in a good transparency night, although artificial lighting is the same, many more stars can be seen, since not only the stars look brighter but the background is darker.

For Deep Space Astrophotography sky transparency must be good.
Even wispy high cloud layers invisible to the naked eye at night reduce the transparency and make it impossible Deep Space astrophotography.

I use to evaluate sky transparency watching the stars visible through binoculars to confirm that it is good. If not you can do planetary astrophotography but not Deep Space.
The following photos show the difference between two images produced with the same camera, one taken with poor transparency and the other with good transparency.



For Canada and USA you can get forecast of several very useful astronomical weather parameters at Clear Sky Chart. 
Astronomical sky transparency of several locations is available at http://7timer.y234.cn/V3/ where you can create an "APanel" containing 72 hour forecast of several very useful astronomical weather parameters.