Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Originally a KML from https://www.google.com/maps/d/u/0/viewer?ll=49.26375687304295%2C-123.2493595915005&spn=0.014028%2C0.038066&msa=0&iwloc=0004d8b88fe8029eba263&mid=1fmvuTk4654NGRwoIon6yadBx_LY&z=17</SPAN></P><P><SPAN>Description from original source: This interactive map portrays locations on the UBC Vancouver campus where students can find water fountains and bottle-filling stations.</SPAN></P><P><SPAN>The field values are:</SPAN></P><TABLE STYLE="margin:0 0 0 0;"><TBODY><TR><TD STYLE="padding:0 0 0 0;"><P STYLE="margin:0 0 0 0;"><SPAN STYLE="font-size:8pt">NAME</SPAN></P></TD><TD STYLE="padding:0 0 0 0;"><P STYLE="margin:0 0 0 0;"><SPAN STYLE="font-size:10pt">Water Fountain name extracted and modified from the original source. Names are not unique and are based on the building code where the water fountain is located</SPAN></P></TD></TR><TR><TD STYLE="padding:0 0 0 0;"><P STYLE="margin:0 0 0 0;"><SPAN STYLE="font-size:8pt">TYPE</SPAN></P></TD><TD STYLE="padding:0 0 0 0;"><P STYLE="margin:0 0 0 0;"><SPAN STYLE="font-size:10pt">Derived from original data source. There are 6 types: Water Fountain (standard fountain not requiring a water bottle), Water Dispenser (used for filling water bottles only), Inside Washroom (standard fountain inside a washroom), Kitchenette (kitchen sink, may or may not be public use), Filtered Water (branded and cooled public use water bottle filling station) and Cafe Outlet (public water bottle filling station located in a cafe)</SPAN></P></TD></TR><TR><TD STYLE="padding:0 0 0 0;"><P STYLE="margin:0 0 0 0;"><SPAN STYLE="font-size:8pt">NEAR_ROOM</SPAN></P></TD><TD STYLE="padding:0 0 0 0;"><P STYLE="margin:0 0 0 0;"><SPAN STYLE="font-size:10pt">Location descriptions often include more than one room if the building has more than one water fountain of this type. If this is the case, one fountain has been created per room in the building and a near room describes which room this fountain is located close to</SPAN></P></TD></TR><TR><TD STYLE="padding:0 0 0 0;"><P STYLE="margin:0 0 0 0;"><SPAN STYLE="font-size:8pt">LOCATION_DESC</SPAN></P></TD><TD STYLE="padding:0 0 0 0;"><P STYLE="margin:0 0 0 0;"><SPAN STYLE="font-size:10pt">Derived from original data source. In many cases, this describes which rooms in a building water fountains are located close to. If there was not a room listed as a "near room," this value describes were in the building a fountain is located often using floor numbers, elevators and stair wells as a guide to locating the water fountain</SPAN></P></TD></TR><TR><TD STYLE="padding:0 0 0 0;"><P STYLE="margin:0 0 0 0;"><SPAN STYLE="font-size:8pt">BLDG_UID</SPAN></P></TD><TD STYLE="padding:0 0 0 0;"><P STYLE="margin:0 0 0 0;"><SPAN STYLE="font-size:10pt">Spatial join with v_building_Buildings. This is the BLDG_UID of the building the fountain intersects with</SPAN></P></TD></TR><TR><TD STYLE="padding:0 0 0 0;"><P STYLE="margin:0 0 0 0;"><SPAN STYLE="font-size:8pt">BLDG_NAME</SPAN></P></TD><TD STYLE="padding:0 0 0 0;"><P STYLE="margin:0 0 0 0;"><SPAN STYLE="font-size:10pt">Spatial join with v_building_Buildings. This is the Building Name of the building the fountain intersects with</SPAN></P></TD></TR><TR><TD STYLE="padding:0 0 0 0;"><P STYLE="margin:0 0 0 0;"><SPAN STYLE="font-size:8pt">STATUS</SPAN></P></TD><TD STYLE="padding:0 0 0 0;"><P STYLE="margin:0 0 0 0;"><SPAN STYLE="font-size:10pt">Describes if the fountain is currently active using the value "Current" if the fountain is active. All fountains imported from original source are assumed to be "Current" as of import</SPAN></P></TD></TR><TR><TD STYLE="padding:0 0 0 0;"><P STYLE="margin:0 0 0 0;"><SPAN STYLE="font-size:8pt">FTN_UID</SPAN></P></TD><TD STYLE="padding:0 0 0 0;"><P STYLE="margin:0 0 0 0;"><SPAN STYLE="font-size:10pt">Unique ID for each water fountain feature</SPAN></P></TD></TR></TBODY></TABLE><P><SPAN /></P></DIV></DIV></DIV>
Service Item Id: 76103db79c7243be81de3d58ee8aa0e5
Copyright Text: Author of original Google map: Andrea Cheng, B.Sc. in Applied Biology
Acknowledgements from original map: Thank you to the UBC SEEDS Program, UBC Student Housing and Hospitality Services, UBC Building Operations, UBC Waste Action Plan, AMS Sustainability, Dr. Mark Johnson and Ashlee Jollymore.