We have a few hundred people using S&T 2009. We export data from a database and then run it through a bunch of complex macros to clean the data and make it compatible with streets and trips. When streets do not exist we add GPS data into the address so the pins map correctly, however if I could some how get a list of all the streets in S&T's database for ontario I would then know for what streets I would have to add gps data prior to exporting to S&T. Anyone know if there is anyway to suck this data out of S&T into a excel file or something like that?
Thanks,
Thanks,
I doubt if that would solve your problem completely, although it would be a start. Just because a street is in the database does not mean the particular address or intersection will be in there. If a street extends into a new development that isn't in the database, the street numbers and crossing roads for the new development won't show up.
Sorry, I don't know the format of the Streets&Trips database. You could ask this same question on Microsoft's Mappoint forum to see if anyone has done it. It's the same database in Mappoint.
...ken...
Sorry, I don't know the format of the Streets&Trips database. You could ask this same question on Microsoft's Mappoint forum to see if anyone has done it. It's the same database in Mappoint.
...ken...
Quote:
When streets do not exist we add GPS data into the address so the pins map correctly
The problem is that we don't have GPS data on every street, so until we try and map it we don't know that it doesnt exist. Once we find out the street doesn't exist then when we go there we can get a gps fix on it. It would just be good to know in advance so we could ask the customer to provide more information. It was a thought anyway
Similar Topics