Not that anyone cares, but just in case you were curious about my little problem, I solved it myself by: 1. Creating a grid using grid maker 2. Overlaying nodes onto the grid where streets cross the gridlines (EDIT OBJECTS>OVERLAY NODES) 3. Physically putting a point in a separate layer on every node on the gridline (any ideas on how to automate this greatly appreciated) 4. Overlaying nodes onto the street layer where a gridline crosses it 5. Running a SQL select query asking for both the point (from the label points layer created in step 3) and name of street (from the street layer.) 6. Taking off early on Friday afternoon!
Have a great weekend everyone, and good luck at MapPoint 2002 if you're going! Ryan Morgan Aerials Express www.AerialsExpress.com -----Original Message----- From: Ryan Morgan [mailto:rmorgan@;aerialsexpress.com] Sent: Thursday, November 14, 2002 10:45 AM To: MapInfo-L Subject: MI-L Geocoding Along Gridlines Here's a tough one for me: I'm trying to geocode points along gridlines where they intersect with streets. The MapInfo manual gives a huge hint on page 151 where it discusses creating points for intersections, however it is talking about the actual intersections of the streets themselves, not those that fall upon the gridlines. I have tried copying my gridlines to the actual table, creating two idenical tables and running the following SQL Select Query: Select columns: STR1.STREET + "&&" + STR2.STREET >From tables: STR1, STR2 Where Condition: STR1.obj Intersects STR2.obj and STR1.STREET <> STR2.STREET Into table named Grid_Points Then ungeocoding the new table by clearing the "Table is mappable" box, and re-geocoding the table where Grid_Points (the result of the query looks like "1&&Washington St") match STR1.STREET ( which is, "Washington St." What am I doing wrong? Thanks in advance for any help, I will summerize your replies. Ryan Morgan Aerials Express --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 4087 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 4117
