Database Reference
In-Depth Information
Looking at the linear data in a Desktop GIS, we see some categories for trail use:
We want to retain this information as well as the name. Unfortunately, the
la-
bel_name
field is a messy field with a variety of related names concatenated with
an ampersand (
&
),as shown in the following query:
SELECT DISTINCT label_name FROM chp02.trails
WHERE label_name LIKE '%&%' LIMIT 10;
It will return the following output:
label_name