Mike-Brassil-CS-102-SQL.docx - Mike Brassil – CS102 SQL...

Mike Brassil – CS102 SQL CODE
Exercise 14
@@ -190,7 +190,7 @@ FROM
us_counties_2010_shp
ORDER BY square_miles DESC
LIMIT 5;
-- Listing 14-16: Find the county belonging to a pair of
-- Listing 14-16: Using ST_Within() to find the county b
SELECT name10,
statefp10
@@ -219,7 +219,7 @@ WHERE ST_Within('SRID=4269;POINT(-11
--
-- Here, H3010: A natural flowing waterway
-- Listing 14-17: Use ST_GeometryType() to determine geo
-- Listing 14-17: Using ST_GeometryType() to determine g
SELECT ST_GeometryType(geom)
FROM santafe_linearwater_2016
@@ -239,7 +239,7 @@ FROM santafe_linearwater_2016 water
WHERE water.fullname = 'Santa Fe Riv'
ORDER BY roads.fullname;
-- Listing 14-19: Use ST_Intersection() to show where ro
-- Listing 14-19: Using ST_Intersection() to show where
SELECT water.fullname AS waterway,