Several "The Loop" layers can be derived from the trails layer using the following definition queries.


Layer Name                                      Definition Query

The Loop Hard Surface Trail                     "LOOP" = 'Y' AND "STATUS" = 'OPEN'               AND "SURFACE" = 'HARD'
The Loop Soft Surface Trail                     "LOOP" = 'Y' AND "STATUS" = 'OPEN'               AND "SURFACE" = 'SOFT'

The Loop Under Construction Hard Surface Trail  "LOOP" = 'Y' AND "STATUS" = 'UNDER CONSTRUCTION' AND "SURFACE" = 'HARD'
The Loop Under Construction Soft Surface Trail  "LOOP" = 'Y' AND "STATUS" = 'UNDER CONSTRUCTION' AND "SURFACE" = 'SOFT'

The Loop Planned Hard Surface Trail             "LOOP" = 'Y' AND "STATUS" = 'PLANNED'            AND "SURFACE" = 'HARD'
The Loop Planned Soft Surface Trail             "LOOP" = 'Y' AND "STATUS" = 'PLANNED'            AND "SURFACE" = 'SOFT'

The Loop Conceptual Hard Surface Trail          "LOOP" = 'Y' AND "STATUS" = 'CONCEPT'            AND "SURFACE" = 'HARD'
The Loop Conceptual Soft Surface Trail          "LOOP" = 'Y' AND "STATUS" = 'CONCEPT'            AND "SURFACE" = 'SOFT'