|
|
| GeoCommunity Mailing List |
| |
| Mailing List Archives |
| Subject: | [gislist] Topical ArcGIS and MS Access question |
| Date: |
06/17/2004 09:55:01 AM |
| From: |
William Western |
|
|
This is a multi-part message in MIME format.
------=_NextPartTM-000-2287a9c4-c210-4a30-b91e-ab3f59bdb1cd Content-Type: text/plain: charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Hi Listers!,
=20
Here's a topic that I would love to get your thoughts and ideas on...
=20
I work for a Consulting company that specializes in Aquatic Environments. Currently, myself and another fellow are developing a substantial Information System to handle all environmental data (mostly aquatic) that we collect in the field...fish, lower trophic/benthic, water. MS Access is being used to store the bulk of the 'aspatial' data (although ultimately everything in this is spatial), while the spatial data (bathymetry, macrophytes beds, etc) is as you may have guessed being stored in a Personal Geodatabase using ArcGIS 8.3. I use an ODBC connection to bring the Access database into ArcGIS, and am capable of performing joins, relates and queries on the Access database right in ArcGIS. The spatial link between the two is provided by the Sampling sites which contain a UID and coordinates (and several other data fields), linking the tables in Access to a geographic location. Please note that I'm working on a budget with the tools that I have. So far, the system's interoperability is very good and I'm happy with it.
=20
Here's some seed questions I hope you can 'run with':
=20
(1) Interoperability - what are your thoughts on using connecting these software tools to build a large GIS?
(2) The Future - Do you see the ESRI Geodatabase and MS Access database becoming obsolete? (For example, if and when the Object Oriented Databases take over and Relational Databases disappear)
(3) Migration - How do you foresee migrating datasets from these packages into potential future packages?
=20
Have a great day and thanks in advance,
=20
Bill
------=_NextPartTM-000-2287a9c4-c210-4a30-b91e-ab3f59bdb1cd Content-Type: text/plain: charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline
_______________________________________________ gislist mailing list gislist@lists.geocomm.com http://lists.geocomm.com/mailman/listinfo/gislist
_________________________________ This list is brought to you by The GeoCommunity http://www.geocomm.com/
Get Access to the latest GIS & Geospatial Industry RFPs and bids http://www.geobids.com
------=_NextPartTM-000-2287a9c4-c210-4a30-b91e-ab3f59bdb1cd--
|
|

Sponsored by:

For information regarding advertising rates Click Here!
|