HomeMicrosoft


Importing cross-street data into Microsoft Streets and Trips
bstubbs
I have a school Bus route that I want to bring into Microsoft Streets and Trips. The specific addresses (815 Simon Drive Cedar Hill Tx 75104, for example) come in fine. The cross-street addresses (Simon Dr & Stonewood Dr Cedar Hill Tx 75104, continuing the example) are all being plotted to a single location - it looks like they're going to the center of the Zip code. I can individually enter the cross-street data and it plots fine. What do I need to do to have all of the data import?

TIA.

Bob
Ken in Regina
Hi Bob,

Any "addresses" that S&T can't resolve to a location will all end up being assigned the same default location. That's always a sign that S&T wasn't able to resolve the "address". I'm not sure if the import routine is bright enough to distinguish between addresses and intersections. If it is, I apologize that I can't help you with the format you need to put the intersection information in so that it will be resolved correctly.

Is the intersection information in your import file in the exact same format as you enter it into the search routine in S&T? That is can you cut and paste it from your import file into the search box in S&T and it works exactly as pasted?

...ken...
bstubbs
Ken:

Well, I was using Column data from Excel to get the data into S&T. I concantenated that data into a new sheet with each address being a single cell, each address element separated with ";". I can then copy that string into the search routine and it works fine. I can't import the data from the new sheet in that, with the single cell, I can't tell it what each address "section" would mean. Worst case now is that I work within Excel and form the address string, then copy that data into S&T a single address at a time.

One interesting limitation to that way of working regards the "pin name" that I'm trying to associate with each stop. That name is the bus route name and stop sequence number (like "C-8, stop1"). When I formed the data string within Excel, I put that pin name as the first string segment, followed by the remainder of the address info. Using the search routine, that name data was stripped out. I had to add that in by changing the address properties.

From this, does that indicate anything to you as to how I can use the import feature directly?

Thanks.

Bob
Marvin Hlavac
Hi Bob, and welcome to the forums. I just experimented for a few minutes with importing from Excel to Streets & Trips, but I haven't found a way to import an intersection of two streets. It may not be possible, I'm not sure. Could you just use a street address instead? Or latitude/longitude coordinates?

The route name & bus stop ("C-8, stop1") should go both into one Excel cell, I believe.
bstubbs
Thanks.

I've started using Lat/Lon data to import the data into S&T and the import works great. Then I have to modify the properties of the stops to add the other data. Less than optimum but workable.

Bob
laptopgpsworld.com About