try to match two organizations

We have a list of organization data we keep inside our company, over the 
years, the data is getting dirty. Now we pruchased an official list of the 
organization, we want to match the organizations in these two lists, so we 
can do some data clean up. I am thinking to use the latitude and longtitude 
to match an organization. Here is what I am going to do: I will feed the 
address of the organizations in list1 to mappoint, and feed the address of 
organization in list2 to mappoint, populate each organization with the lon. 
and lat. data in each list. Then I will use the lat. and lon. to match the 
organization.
 Would someone comment on my approach? Will it work? Is there a better way 
to do it using Mappoint?

Thanks for the reply. I only need to match one main address. It is the 
address the organization registered. I only need to match the name of the 
organizations. I can not use the text of the names because they are not 
exactly the same....this is why I am thinking about the long. and the lat. 
data. 
Thanks.

"Michael R Mattys" wrote:

> "yuqlin" <yuqlin@discussions.microsoft.com> wrote in
message
> news:834A8CDA-956D-4564-8278-6D86C3E786B2@microsoft.com...
> 
> > We have a list of organization data we keep inside our company, over
the
> > years, the data is getting dirty. Now we pruchased an official list of
the
> > organization, we want to match the organizations in these two lists,
so we
> > can do some data clean up. I am thinking to use the latitude and 
> > longtitude
> > to match an organization. Here is what I am going to do: I will feed
the
> > address of the organizations in list1 to mappoint, and feed the
address of
> > organization in list2 to mappoint, populate each organization with the

> > lon.
> > and lat. data in each list. Then I will use the lat. and lon. to match
the
> > organization.
> > Would someone comment on my approach? Will it work? Is there a better
way
> > to do it using Mappoint?
> >
> > Thanks.
> 
> 
> It is quite common for organizations to have one address and many building
> numbers or suites. Some of these may be on the 4th and 14th floors of a
> highrise complex. The solution would might involve a NAC/Universal address
> as described here: http://en.wikipedia.org/wiki/Natural_Area_Code
> 
> -- 
> Michael R. Mattys
> MapPoint & Access Dev
> www.mattysconsulting.com 
> 
> 

"yuqlin" <yuqlin@discussions.microsoft.com> wrote in message 
news:834A8CDA-956D-4564-8278-6D86C3E786B2@microsoft.com...
> We have a list of organization data we keep inside our company, over the
> years, the data is getting dirty. Now we pruchased an official list of the
> organization, we want to match the organizations in these two lists, so we
> can do some data clean up. I am thinking to use the latitude and 
> longtitude
> to match an organization. Here is what I am going to do: I will feed the
> address of the organizations in list1 to mappoint, and feed the address of
> organization in list2 to mappoint, populate each organization with the 
> lon.
> and lat. data in each list. Then I will use the lat. and lon. to match the
> organization.
> Would someone comment on my approach? Will it work? Is there a better way
> to do it using Mappoint?

That would work, but could be tedious with large lists to work through. I 
would probably import the 2 lists into an Access DB and run a >Search for 
Duplicates query.

"Michael R Mattys" <mmattys-at-rochester.rr.com> wrote in
message 
news:47cc3c96$0$1088$4c368faf@roadrunner.com...
> "yuqlin" <yuqlin@discussions.microsoft.com> wrote in
message
> news:834A8CDA-956D-4564-8278-6D86C3E786B2@microsoft.com...
>
>> We have a list of organization data we keep inside our company, over
the
>> years, the data is getting dirty. Now we pruchased an official list of

>> the
>> organization, we want to match the organizations in these two lists, so

>> we
>> can do some data clean up. I am thinking to use the latitude and 
>> longtitude
>> to match an organization. Here is what I am going to do: I will feed
the
>> address of the organizations in list1 to mappoint, and feed the address

>> of
>> organization in list2 to mappoint, populate each organization with the

>> lon.
>> and lat. data in each list. Then I will use the lat. and lon. to match

>> the
>> organization.
>> Would someone comment on my approach? Will it work? Is there a better
way
>> to do it using Mappoint?
>>
>> Thanks.
>
>
> It is quite common for organizations to have one address and many building
> numbers or suites. Some of these may be on the 4th and 14th floors of a
> highrise complex. The solution would might involve a NAC/Universal address
> as described here: http://en.wikipedia.org/wiki/Natural_Area_Code
>
> -- 
> Michael R. Mattys
> MapPoint & Access Dev
> www.mattysconsulting.com

Not familiar with NAC, it is proprietary in nature and it is limited to only 
18 countries.
The only thing that NAC really offers over lat/long or UTM and its 
extensions (eg Grid Reference System) is altitude and a shorter 'address' 

"yuqlin" <yuqlin@discussions.microsoft.com> wrote in message
news:834A8CDA-956D-4564-8278-6D86C3E786B2@microsoft.com...

> We have a list of organization data we keep inside our company, over the
> years, the data is getting dirty. Now we pruchased an official list of the
> organization, we want to match the organizations in these two lists, so we
> can do some data clean up. I am thinking to use the latitude and 
> longtitude
> to match an organization. Here is what I am going to do: I will feed the
> address of the organizations in list1 to mappoint, and feed the address of
> organization in list2 to mappoint, populate each organization with the 
> lon.
> and lat. data in each list. Then I will use the lat. and lon. to match the
> organization.
> Would someone comment on my approach? Will it work? Is there a better way
> to do it using Mappoint?
>
> Thanks.


It is quite common for organizations to have one address and many building
numbers or suites. Some of these may be on the 4th and 14th floors of a
highrise complex. The solution would might involve a NAC/Universal address
as described here: http://en.wikipedia.org/wiki/Natural_Area_Code

-- 
Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com