Snow Plow Routes: Best Practice and advice for mapping multiple routes

[TamiMaddio]

I would like to use my city centerline to map our snow plow routes.  I don't want to duplicate the centerline when there are multiple routes for the same segments on a map and also I want to use the centerline/plow route to quatify the miles plowed by lane miles.  The street area is kept in a seperate table.

Does anyone have any advice for best practice for doing this?

I am thinking about creating a table with a record for each segment/plow route # and relating it to the centerline and the external table.  Then using cartographic representations to create the map based on the plow route.  I haven't used catrographic representations before so I'm not sure if I'm going down the correct path with this.

Thanks.

[ScottOppmann]

There are two primary ways we've seen users implement a solution to this problem.  They either use dynamic segmentation to identify the routes along your road centerlines.  Or, use a series of simple features managed in a topology on top of your primary road centerlines.   While the simple features approach may require you to duplicate the geometry, it is a pretty simple way to maintain the information by non-GIS users. 

We'll begin to incorporate additional public works layers like snow routes in our solution offering in late 2013 and early 2014 and will provide some tools to make this easier going forward.  Hope this helps in the near term.

Scott