Well done! Now, you know that the ST_Area function returns the area of a polygon, but what happens if we pass in a collection to this function? Simply put, it calculates the total area of all polygons in the collection! This simplifies matters quite a bit, eliminating the need to call an aggregate function like SUM if you already have a collection on hand. For instance:
SELECT id, ST_Area(ST_Transform(geo_data,26910)) FROM sf_chains;
For each collection, the query above will show its id and the total area of all polygons it contains.
What is the total area of all Tranquil Jewel Hotels in San Francisco (collection with id = 1)? Provide the answer in square meters.
Remember to use ST_Tranform with an SRID of 26910 before you calculate ST_Area.
