topic Re: Trails database - too many fields! How to manage? in Data Management Questions

Trails database - too many fields! How to manage?

MegPeterson — Thu, 21 Oct 2021 17:18:37 GMT

Good morning, all!

I'm working on a trails database that has many (too many!) fields and am looking for a way to break some of them out, but still be able to symbolize on them. The general issue is this:

Our trails dataset has Surface, Bikes, ADA, Horses, Type, etc fields. Each attribute defines use along different segments of the same trail.

For example, for a trail from point A to point B, I need to split the line based on a Surface field when the trail changes from paved to dirt. But for a different map I may need to symbolize where bikes are and aren't allowed, splitting the line at a different location. The line is the same, but the splits are different for each field.

With literally 20+ fields in the file I don't want to have a million split lines. Any ideas on how to pull some fields out, but join, relate, create topology rules to bring them back in to symbolize, etc?

Thanks for any advice! Meg

Re: Trails database - too many fields! How to manage?

Steve_Salas — Thu, 21 Oct 2021 17:29:16 GMT

Sounds like a great case for linear referencing if you want to put (and maintain!) measure values on your trails https://pro.arcgis.com/en/pro-app/latest/help/data/linear-referencing/introduction-to-linear-referencing.htm

Re: Trails database - too many fields! How to manage?

MegPeterson — Thu, 21 Oct 2021 18:13:16 GMT

PERFECT! Thank you!

Re: Trails database - too many fields! How to manage?

ScottJones1 — Fri, 29 Oct 2021 16:00:26 GMT

Looking for a trails template that I can then use in Network Analysis. Did you build your own?

Re: Trails database - too many fields! How to manage?

MegPeterson — Fri, 29 Oct 2021 17:44:29 GMT

No, we're only revamping attribute values right now.