Excellent! Now let's get to know some basic functions we can use to work with polygons. The first is ST_Perimeter. It returns the perimeter of the polygon (in other words, the length of the linestrings that constitute the polygon).
SELECT
ST_Perimeter(
ST_Transform(
boundaries,26910))
FROM sf_hotels
WHERE id = 1;
In the query above, we show the perimeter of the hotel with id = 1. Note that we changed the SRID to obtain the result in meters.
There is a beautiful Japanese Tea Garden in Golden Gate Park. Check how many meters of reed fence would be needed to surround it and thus make it even more mysterious and secluded. Display the name column and the length of the fence expressed in meters. Name the column fence_length.
Use the sf_sights table.
Use ST_Perimeter combined with ST_Transform. Remember that the SRID should be 26910.
