Joining tables using LAT/LONG

Hi yosiasz

You get a polygon by stringing long lat pairs separated by a comma.

The earth is a globe. the order of the points that define the polygon matters. Suppose you want to create a polygon of the North Pole. Depending on the order of the points (West-ward or East-ward) the system will interpret the polygon as defining the North Pole - as intended - or the whole planet, except the North Pole.

Agreed. A certain Order is indeed necessary

Hi Harris,

Good Morning.
I appreciate your attention on this topic.

I like to project my response time performance (let’s say) by City/State/Country based on Lat/long in transaction table.

More specifically, I want to make a group Green/Yellow/Red based on response time within 7/10/15 minutes by City/State/Country.
I have lat/long in all level data. But that is not one-to-one match.
How could I match my individual lat/long point of transaction table against lat/long in respective city/state/country lat/long.

Then I could say City a,b,c are green, d,x are Yellow… Again State I,P are Red.. based on my transaction table lat/long.

I hope this makes sense.

Regards
Jaynal

there has to be some way of mapping !!!

this has been going on for
" Hundreds of Years "
I mean Lat Long and Maps

Needs some Research and Development !!!!
I have never done this !!! dont have that much idea

:slight_smile: :slight_smile: