I have GPS tracking solution and most my customers in US. My reverse-geocoding solution pretty basic:
- Table with US ZIP database
- Procedure in SQL Server where I search for city/state closest to reported lat/lon
Now I need to add Canada to my service coverage. I will buy Canadian postal codes and plan to store it in separate table.
So, straight-forward solution will be to:
- Check if there is close US city/state and report
- If not found - check in Canada table
This solution will put extra load on server for those canadian users since US table will be queried first.
For various reasons I don't want to merge tables.
However, if you look at map - you can tell that Canada is above USA :)
So, I was wondering if I can use some hard-coded numbers to know immedeately where this point is.
Right? Wrong? Other ideas on how to tackle this?