|
|
| GeoCommunity Mailing List |
| |
| Mailing List Archives |
| Subject: | [gislist] SUM:join database |
| Date: |
04/16/2004 12:00:01 AM |
| From: |
Bigyan Kar |
|
|
Hi Monica and everyone,
I would like to pay special thanks to Mr. Richard Nicoll, Ted Cisine, =
Bill Medina, RICK GRAY and all other listers who has provided assistance =
and share their thoughts with me. Here is the sum to my question if =
anyone needs it as a future reference.=20
From: Bigyan Kar [mailto:bigyan@annova-tech.com]
Sent: 15 April 2004 11:19
To: gislist@lists.geocomm.com
Subject: [gislist] join database
Hi Listers,
I have two databases such as=20
-- Database1: place names and their latitude and longitude
-- Database2: place names with their population data.
Now, I want to join these two databases as per the place names, those
found both in database1 and database2. Please note that there are some
place names in database2 those are not available in database1 or vice
versa. Can anyone suggest me a VBA macro tool for excel or any avenue
script which does this automatically.
Regards,
Bigyan Kar
From: "Richard Nicoll" <RichardNicoll@CasellaGroup.com>
To: "Bigyan Kar" <bigyan@annova-tech.com>
Sent: Thursday, April 15, 2004 4:22 PM
Subject: RE: [gislist] join database
> Hi Bigyan
>=20
> This is called geocoding and basically as you state works by linking =
two
> tables based on a common field (in this case your place name).
>=20
> This can be done easily in ArcView3.2 without the need for avenue.
> First turn both your databases into dbf tables and add them to ArcView
> (if your databases are relational you will have to do the tables
> individually as geocoding does not support relationships within =
dbf's).
> Once you have both the tables open within ArcView3.2, select both the
> place name fields and click on the 'join' button. This will append =
all
> records to the selected table based on a common value, known as an
> inside join (only those which match are brought across). Outer joins
> (which brings across all) are not supported in ArcView3.2 to the best =
of
> my knowledge.
>=20
> If your place names vary slightly (such as capital letters or =
incorrect
> spelling) you can apply a basic 'fuzzy logic' routine whereby you can
> state parameters for a match, such as 80% similarity of ascii values.
> To do this within ArcView3.2 select VIEW > GEOCODE ADDRESSES in the =
view
> window.
>=20
> Hope this helps!
>=20
> Rich
From: "Ted Cisine" <ted.cisine@co.robeson.nc.us>
To: "Bigyan Kar" <bigyan@annova-tech.com>
Sent: Thursday, April 15, 2004 5:44 PM
Subject: RE: [gislist] join database
> If you are using ArcGIS 8.x you can do a normal join go to advanced, =
and
> choose only join where record exists in both tables. Good luck.
>=20
> Ted
From: "Bill Medina" <wmedina@kci.com>
To: "Bigyan Kar" <bigyan@annova-tech.com>
Sent: Thursday, April 15, 2004 5:57 PM
Subject: RE: [gislist] join database
> You can use vlookup command in excel, or link tables in Avenue or =
ArcGIS.
From: "Monica Barricarte" <monica-barricarte@ca.nacdnet.org>
To: "'Bigyan Kar'" <bigyan@annova-tech.com>
Sent: Thursday, April 15, 2004 8:01 PM
Subject: RE: [gislist] join database
Please let me know any answers you get thanks
monica
Cachuma Resource Conservation District
920 East Stowell Rd.
Santa Maria, CA 93454
phone (805) 928 9269 x 120
fax (805) 928 9644=20
From: "RICK GRAY" <RGRAY@ridgetownc.uoguelph.ca>
To: <bigyan@annova-tech.com>: <gislist@lists.geocomm.com>
Sent: Thursday, April 15, 2004 8:32 PM
Subject: Re: [gislist] join database
> Bigyan,
>=20
> Easy to do in Excel.
>=20
> If you put your data in two spreadsheets (easier if they are in the =
same
> workbook), then make sure they are sorted alphabetically by =
placename, then use
> the INDEX and MATCH functionality of Excel.
>=20
> I have attached a spreadsheet with some sample data and formulas to =
match and
> move the data.
>=20
> You will notice that you get a #NA in the cells that do not have a =
match in the
> other data set.
>=20
> If you still have problems, let me know.
>=20
>=20
> Rick Gray
> GIS Specialist, Ontario Weather Network
> http://www.ownweb.ca=20
> GIS Instructor
> Ridgetown College, University of Guelph
> http://www.ridgetowncollege.com/=20
>=20
> Tel. 519-674-1554
> E-mail: rgray@ridgetownc.uoguelph.ca=20
>=20
> Ridgetown: -81.883 W, 42.450 N
> From: Bigyan Kar [mailto:bigyan@annova-tech.com]
> Sent: 15 April 2004 15:29
> To: Richard Nicoll
> Subject: Re: [gislist] join database
>=20
>=20
> Hi Rich,
>=20
> Yes, I have gone through your explained method and that worked well =
for
> me.
> Thank you very much for sharing your thoughts and views..
>=20
> With best regards,
&
|
|
Sponsored by:
For information
regarding
advertising rates
Click Here!
|
