Welcome to MapForums!

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

## Offset two pushpin data sets

This is a discussion on Offset two pushpin data sets within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have two data sets with the same latitute/longitude values. Does anyone know a method to create a small offset ...

1. Junior Member White Belt
Join Date
Jul 2004
Posts
9

## Offset two pushpin data sets

I have two data sets with the same latitute/longitude values. Does anyone know a method to create a small offset in the second data set's lat/long before importing into MapPoint? I tried multiplying the lat/long with a small number, which works, but obviously the offset will vary depending on your location. I have access to lat/long, heading, speed and altitude.

Thanks,

Gary

2. Junior Member White Belt
Join Date
Jul 2007
Posts
8

## Re: Offset two pushpin data sets

Don't multiply. Just add a constant value to the latitude. Latitude values are constant unlike longitude( not that it matters if you are plotting two locations so close to each other) 1 degree of latitude is roughly 69 miles.(111302 m) So .000001 degrees would add 1 meter in latitude.

3. Junior Member White Belt
Join Date
Jul 2004
Posts
9

## Re: Offset two pushpin data sets

Thanks jonp54,
My data sets are drive routes and changing only the latitude works sometimes. I guess there is no real simple solution so, I will get the geometry books out and create a function using the lat/long distance equations and the bearing.

4. Junior Member White Belt
Join Date
Aug 2007
Posts
1

## Weird Data problem

Sorry - I wanted to post this as a new thread but couldn't figure out how - here is my dilemna (MapPoint2006)

I have an EXCEL file of about 1000 rows of zipcodes and policy counts. When I import the data into Map Point, I chose 5 discrete ranges, and then I locate a specific office location and draw a 15-mile radius. When I go to print the file or save the file some of the previous shaded areas lose their shading. I can't figure out why. If I don't save the file and print from the screen, some of the shaded areas continue to show as shaded, some are lost. I don't remember having this problem ever

HELP!

Mark