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

This preview shows page 1 - 2 out of 2 pages.

The preview shows page 1 - 2 out of 2 pages.
Mike Brassil – CS102 SQL CODEExercise 14@@ -190,7 +190,7 @@ FROMus_counties_2010_shpORDER BY square_miles DESCLIMIT 5;-- Listing 14-16: Find the county belonging to a pair of-- Listing 14-16: Using ST_Within() to find the county bSELECT 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 gSELECT ST_GeometryType(geom)FROM santafe_linearwater_2016@@ -239,7 +239,7 @@ FROM santafe_linearwater_2016 waterWHERE 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 whereSELECT water.fullname AS waterway,
End of preview. Want to read all 2 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
KORTH
Tags
Mike Brassil

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture