B
BennyEz
I've seen similar posts on here about doing this however I haven't
seen much as far as solutions go. What I need is simple. Have a table
full of Sites (sites being buildings with a physical address). I would
GeoCode the site address (DONE) either real time or GeoCode the
address and place the site's Long and Lat in the table along with the
rest of the site's info.
I need to come up with some sort of global map that has Lat and Long
on it so that I can write a function mapping the actual Lat and Long
to the Visio Map.
I can do this with Google Maps and other software easily enough
however the person driving this has already said that those solutions
will not be acceptable. He wants the generated diagram easily imported
into a PPT or other office app. He also wants layers to be created.
Say we have other objects we want to map. We can do so and hide the
layers. With visio he can determine which layers he wants to see.
Again, all stuff that could be done with Google maps. Again however,
this is not allowed. For starters, this won't be available to the
public and therefore violates Google's AUP.
Some thoughts I've already had:
1) Not very accurate but easiest
Each country will be a shape. Link the sites to a country and place
them somewhere in the middle of the country shape.
2) More accurate, more complex
Create a world map with Long and Lat lines as shapes. Write a
function that takes a number like Lat (totally made up) 23.998394849
and finds which lat lines it is between. Then maps the decimal to the
exact location. Does the same with Long and therefore figure out the
Long and lat and places the shape.
I see #2 being my way of going however it's hard to come up with that
map. Ecpecially making it vector which would be the best result.
Thanks for any insight anyone has.
seen much as far as solutions go. What I need is simple. Have a table
full of Sites (sites being buildings with a physical address). I would
GeoCode the site address (DONE) either real time or GeoCode the
address and place the site's Long and Lat in the table along with the
rest of the site's info.
I need to come up with some sort of global map that has Lat and Long
on it so that I can write a function mapping the actual Lat and Long
to the Visio Map.
I can do this with Google Maps and other software easily enough
however the person driving this has already said that those solutions
will not be acceptable. He wants the generated diagram easily imported
into a PPT or other office app. He also wants layers to be created.
Say we have other objects we want to map. We can do so and hide the
layers. With visio he can determine which layers he wants to see.
Again, all stuff that could be done with Google maps. Again however,
this is not allowed. For starters, this won't be available to the
public and therefore violates Google's AUP.
Some thoughts I've already had:
1) Not very accurate but easiest
Each country will be a shape. Link the sites to a country and place
them somewhere in the middle of the country shape.
2) More accurate, more complex
Create a world map with Long and Lat lines as shapes. Write a
function that takes a number like Lat (totally made up) 23.998394849
and finds which lat lines it is between. Then maps the decimal to the
exact location. Does the same with Long and therefore figure out the
Long and lat and places the shape.
I see #2 being my way of going however it's hard to come up with that
map. Ecpecially making it vector which would be the best result.
Thanks for any insight anyone has.