GPS Coordinates

[Zan03]

Hi All,

I have 300 buildings all over Toronto... we are in the process of setting quadrants and dividing the buildings accordingly.

The quadrants are set from one highway to three others (setting the North, east, south, west diameters).

I've gathered the coordinates for all buildings but need to figure out which one fits into which quadrant...

I don't know how to go about this...

Any suggestions?

Format ex:

1 BENVENUTO UNIT (Lat)43.6818436 (Long)-79.4003071
2 FERNDALE AVENUE (Lat)43.1556978 (Long)-79.2123856

[zbor]

Define borders of quadrants (i.e. 43.500000 and 79.3000000) and you can subtract any coordinate with borders getting right quadrant (++, +-, -+ and -- as North, East, West, South)

[Richard Buttrey]

Hi,

It should be relatively simple once we know the quadrant boundaries. Can I suggest you upload a workbook containing the building co-ordinates so that we can see the layout and decide how best to manipulate them. Also include the quadrant boundary definitions, and if possible a visual map extract to give some sort of context to the task.

Regards

[Zan03]

Thanks for the feedback guys,

an example of a quadrant is as follows:

South:
Latitude: 43.737
Longitude: -79.427

West:
Latitude: 43.754
Longitude: -79.530

East:
Latitude: 43.800
Longitude: -79.343

North:
Latitude: 43.824
Longitude: -79.464

I've attached a work sheet with a sample of buildings and their coordinates...

I'd appreciate any suggestions, im completely stuck!

Thanks,

Zanna

[zbor]

Since I've never been at Toront you should define boundaries Take some characteristic points at the map and read coordinates... Some stree or river or something that split town into left and right and up and down....

[DP978]

You need to pick one Lat line and one Long line and set those to 0.

So if 43.8 if the center line between North and south subtract 48.3 from all Lat values, negative values end up in the south, positives in the north. Do a similar thing for East and West.

Lets assume you pick -79.4 as your Long value, I am going to assume anything more negative is West, less negative is east.

you would do the following -

For location (43.743, -79.427)

( 43.743 - 43.8 ) = - (South)
( (-79.427) - (- 79.4) = - (West)

[zbor]

Here, maybe this picture will make it easier to imagine...

http://baseballanalysts.com/archives/AA-KGB.png

You must define axis (need at least 2 points for each)

[Zan03]

DP978,

Thanks, i'm going to give it a try...
But as i have 7 quadrants, would your method prove to be too time consuming?
Or is that the only way?

[Zan03]

Zbor,

Funny enough, that image did help!
Genious...

Thanks,

[Zan03]

You need to pick one Lat line and one Long line and set those to 0.

So if 43.8 if the center line between North and south subtract 48.3 from all Lat values, negative values end up in the south, positives in the north. Do a similar thing for East and West.

Lets assume you pick -79.4 as your Long value, I am going to assume anything more negative is West, less negative is east.

you would do the following -

For location (43.743, -79.427)

( 43.743 - 43.8 ) = - (South)
( (-79.427) - (- 79.4) = - (West)

Thanks for taking the time to explain in great detail... I see what you're saying (took a while! You know what they say about women and maps..... haha) I'm going try your method with my data... i'm sure it'll work just fine... if not, i'll be back! =)

Thanks again,

Zanna

[DP978]

DP978,

Thanks, i'm going to give it a try...
But as i have 7 quadrants, would your method prove to be too time consuming?
Or is that the only way?

You have to be careful with 7 quadrants since cutting somethign with 2 axis will give you overlap in other quadrants.

You may need higher powered math using Radians to slice your quadrants into pie pieces, or if you need rectangles you are going to have to use many conditional statements.

[Zan03]

I decided to stick to 4 quadrants for now.. as the other 3 are small and can be done manually (while i create the conditional statements, etc for future use).

[DP978]

Good choice ;-)

Let us know if you have trouble.

[Richard Buttrey]

Hi,

Does the attached help?


Regards

[Zan03]

Thanks for the example Richard!
Definitely helps...I'm going to continue plugging in all my data.

Thanks for spending the time! Really appreciate it!

-Zanna