Queries with spatial filters

Get the map unit key and name at a single, manually-defined point (-121.77100 37.368402).

SELECT mukey, muname
FROM mapunit
WHERE mukey IN (
SELECT * from SDA_Get_Mukey_from_intersection_with_WktWgs84('point(-121.77100 37.368402)')
)

##     mukey                                        muname
## 1 1882921 Diablo clay, 15 to 30 percent slopes, MLRA 15