Latest Contributions by lukekaim

The goal is to summarize an event table by attribute. I wish the Dissolve Route Event tool also let one summarize similarly to how the Dissolve Management tool works. Let’s say I have road condition as an event table. Fair, medium and poor are the attribute values in the event table. I want to summarize road condition by route summing all the distances. I would also like to do this at the network level. The current workflow that I am using to achieve this is to take the event table convert it to a feature class and then run Dissolve Management. It would be helpful to have a tool to do this and not have to convert it to a feature class. I know I could make a custom tool to do this using a join and insert cursor without having to convert the event table to a feature class, but I would think this functionality could be built into the Dissolve Route Event tool. This should be similar to the dissolve management tool which allows one to sum values.  ... View more

Hi Everyone,   We are using dynamic segmentation for transportation data. Is it possible to define an arc segments to two different routes in ArcGIS? How do you store overlapping routes with Esri? If you have a bus route and, then a driving route how would you model that in GIS? I know you can have events on top of each other, but how do you store overlapping routes correctly in a database design approach? See image for an example of overlapping routes. In pure database design I would have three tables. The first table would store lines. The second table would store the route name. The third table would store line-route table. In this way one could store overlapping routes and have a third normal form database design. How do Esri geoprocessing tools work with an architecture like this? Specifically how would Overlay Route Events tool work with three tables? If Esri does not support this, then how do you correctly model overlapping routes? ... View more