Aboard the USS Enterprise-D, the arboretum was on Deck 17, section 21 alpha. It contained a number of different types of plant life, including Cyprion cactus and roses. There was also a small pond. (TNG: "Genesis", "Dark Page")
Civilians were allowed to staff positions in the arboretum. Keiko O'Brien was head of the plant biology lab while she was aboard the ship. (TNG: "Night Terrors") Children such as Clara Sutter were also allowed to help with small projects in the arboretum. (TNG: "Imaginary Friend")
In 2371, Odo spent some time in an arboretum after discovering his people's homeworld. (DS9: "The Search, Part II") Later in that year and following his transfer to Deep Space 9, Miles O'Brien drew up plans to turn one of the station's cargo bays into an arboretum to cheer up Keiko, who missed being able to do botanical research. However, these plans were abandoned when Julian Bashir convinced Miles that an arboretum could only afford Keiko a mere hobbyist's level of research opportunities, when what she really craved was an extended field expedition. (DS9: "The House of Quark")
The botany lab viewed in "The Man Trap" was a redress of the sickbay set, with an extra doorway added to the right of the opaque cabinet.
The refit Enterprise seen in Star Trek: The Motion Picture appeared to have an arboretum in the lower part of its engineering hull, as trees were seen beyond the several large viewports on each side of the hull. This appears to be the original intention of designer Andrew Probert, and is confirmed in this image and many non-canon publications such as Mr. Scott's Guide to the Enterprise.
Some blueprints have identified the two large blue windows below the main shuttlebay on the Enterprise-D model as the arboretum windows, although the set had no such windows. It is possible there is more than one arboretum on the Galaxy-class.