If your paths follow the street map close enough, you should create a small buffer around each street segment and count the number of paths crossing through the buffer.
Something along these lines should do (un-tested): Select streettable.ID, count(*) from streettable, pathtable where pathtable.obj partly within Buffer(streettable.obj, 20, 0.02, "mi") group by streettable.ID Kind regards Uffe Kousgaard www.routeware.dk ----- Original Message ----- From: "Richard Block" <[EMAIL PROTECTED]> To: ">" < <[EMAIL PROTECTED]> Sent: Friday, January 16, 2004 5:29 PM Subject: MI-L Travel Paths I am working on the new journey to crime module in Crimestat. I would like to count the number of offenders that travel along each street line segment from home to incident. I have the base Chicago street map and a layer of travel paths. The paths goes from node to node along the street grid and includes frequency of trips, but each street segment is not identified along the path. Each path is an object. I would like to sum the trips for each street segment. I tried several within or contains query. None seemed to work. Any ideas? Thanks --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9956 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9958
