Searches use the specialized syntax of
PostgreSQL fulltext indexing and query system. Multiple MLRA symbols should be given as a comma-delimited list without spaces.
Searches are limited to the top 100 matches; open-ended queries could return many thousands of results.
Notes
- MLRA are derived via spatial intersection (SSURGO x MLRA polygons)
- MLRA-filtering is only possible for series used in the current SSURGO snapshot (component name)
- logical AND: &
- logical OR: |
- wildcard, e.g. rhy-something rhy:*
- search terms with spaces need doubled single quotes: ''san joaquin''
- combine search terms into a single expression: (grano:* | granite)
- exclude words or compound expressions: !
Example Queries
- iowa & smectitic & verti:* & Cg & ! saturated
- iowa & smectitic & verti:* & Cg & terrace
- (sulfi:* | sulfa:*) & aq:*
- Coarse-loamy & mixed & active & thermic & Mollic & Haploxeralfs
- sierra & nevada & (meta:* | metamorphic) & xer:* & thermic & lithic
- sierra & nevada & foothill & (grano:* | granite) & thermic
- rhyo:* & tuff:* & California & thermic
- paralithic & thermic & !mesic & mollic & epipedon
- (gypsum | gyp:*) (MLRA: 15,17)
- flood & plains & toe & slope