0

I have two tables in mapinfo:

Client ( Id, X, Y, storeId)
Store (StoreId, StoreName, X, Y)

I need to get closest Store (minimum distance between client and store) to every client and store it into Client table, I can't use excel, spss or anything else than mapinfo.

Do you have any idea?

Brian Tompsett - 汤莱恩
  • 5,753
  • 72
  • 57
  • 129
javoros
  • 3
  • 3
  • Closest distance between a Store and a Client is challenging already but very doable. But closest Store for many Clients is difficulty squared and requires a lot of imagination. Have you tried anything by the way? – Edper Oct 30 '13 at 23:46
  • Yes, I've tried creating a intermediate table that has all client with calculated distance related to any store but when you do this you lost IdStore and you'll never know what store is the closest – javoros Oct 31 '13 at 04:41
  • try to show your work then. I guess you made a query also? – Edper Oct 31 '13 at 04:44
  • For this kind of operations you can use Oracle Spatial if you have already an oracle database for storing map informations. Once I have worked with MapInfo in .Net and we had used oracle spatial for geometric operations of data stored on database. Of course there should be some kind of Mapbasic queries also for realizing this operation if you store the data in mapinfo tables. – Ardahan Kisbet Jun 18 '19 at 06:47

0 Answers0