Nick Your suggestion nearly worked. "Intersects" resulted in a lot of streets that only intersected a travel path being counted. Because the robber's travel path exactly coincided with the street network, I could use "entirely within" in the SQL and get the correct results. Dick
Richard Block Department of Sociology Loyola University 6525 N Sheridan Rd. Chicago IL 60626 Telephone 773 508 3454 FAX 773 508 7099 email [EMAIL PROTECTED] >>> "Nick Hall" <[EMAIL PROTECTED]> 01/16/04 11:13AM >>> group by statement loses link to map best way to think is that MapInfo only has 1 to 1 relationship therefore when you groupby objects disappear from query HTH Nick ps if you need to join it back to original data then save query as base table and then join back to original data using SQL -----Original Message----- From: Richard Block [mailto:[EMAIL PROTECTED] Sent: 16 January 2004 17:05 To: [EMAIL PROTECTED] Subject: RE: MI-L Travel Paths Thanks Nick Your suggestion worked well. One additional question. When I did the query I included the street segment object as output. The browser recognized that the line object was included, but the query was not mappable. Why not? Dick >>> "Nick Hall" <[EMAIL PROTECTED]> 01/16/04 10:43AM >>> Richard, try street.obj intersects path.obj (assuming street is a road length and path is the offenders line thing) group by street.id (or street name etc) select street.id, count(*) this should give you a number of paths each street segment has along it. HTH Nick -----Original Message----- From: Richard Block [mailto:[EMAIL PROTECTED] Sent: 16 January 2004 16:29 To: > 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: 10034
