Patches and updates
ArcView Database Access Extension for ArcView 3.0a (PC) and 3.0b (Unix)
The ArcView Database Access 1.0a extension extends ArcView 3.0a (3.0b for UNIX) to support Spatial Database Engine (SDE) 3.x. The Database Themes extension (provided with ArcView 3.0a/3.0b for Unix) supports SDE 2.x.
The ArcView Database Access extension is available FREE on the Web to all users of SDE 3 and ArcView 3.0a (PC) and 3.0b (Unix).
- If you have ArcView 3.1 or ArcView 3.2, Database Access Extension 2.0 is included, and you should not download this version.
- To use this extension you must have ArcView 3.0a installed on your computer. You can Download ArcView 3.0a from this support site.
- The ArcView Dialog Designer extension for Unix is included in the ArcView 3.0b software update. You can Download ArcView 3.0b for Unix from this support site.
When you retrieve data from a database, you can now see it in a database table. Database tables share the existing Table user interface but do not support all of the functions provided such as indexing. A copy of your data is not written locally the way it is now using the SQL Connect functionality. You will only be able to see a portion of the retrieved data in one database table at a time, but you can increase the number of records displayed in the table as is appropriate. You will be able to create database tables from database themes clicking the Open Theme Table button.
Database Themes Display Query Results
When you query a database you retrieve a set of fields and records. A database theme represents the set of records and displays the spatial data contained by one of the fields. The data retrieved can be the product of joining several tables in the database together. Creating a database theme is similar to creating an SQL SELECT statement. When creating a database theme from an SDE database you can now specify spatial constraints in addition to attribute constraints.
Accessing Data from Many Databases at the Same Time
You can now connect to many SDE databases at the same time. This means you can have several database themes visible in a view whose source data is located in different SDE databases. If you have an SDE connection to a database, you can handle nonspatial data using the same connection. You do not need to create an additional ODBC connection to the database to work with nonspatial tables.
Spatial Data Is Integrated with Attribute Data
In an SDE database, any table can be turned into a spatial table by adding a spatial column to it. Spatial data can now be truly integrated in your database design.
Area of Interest Support
Since you can apply spatial constraints to database themes, we are providing Area of Interest support through Avenue requests only. Using the current functionality, when you set an Area of Interest the same restraints are applied to all the themes in a view. This functionality is too limiting for database themes, which do not have tiles and which support theme-based Areas of Interest. Using Avenue you can apply different spatial constraints to each theme in the view and multiple spatial constraints to one theme. The spatial constraints are not limited to rectangles, either; for example, you could create a spatial filter using a buffer generated around the selected features in a theme.
Installation Instruction for Windows
- Download the Database Access Extension for Windows file
- Run the avdba10a.exe program downloaded by double-clicking on the file.
- Follow the install instructions on the screen.
Installation Instructions for Unix
- Download the TAR and compressed file for your platform.
- Copy the file into you existing arcview3 directory.% cp filename.tar.Z $AVHOME
- Uncompress the Z file% uncompress filename.tar.Z
- Untar the TAR file in your current arcview3 directory. This ensures the existing files are updated.% tar xvf filename.tar.Z
- Open and read the dba.html file for more information about setting up the ArcView Database Access extension with SDE Version 3. This file is located in $AVHOME/avdocs.
NOTE: Files range in size from 2 to 5 MB.
- Database Access Extension for Windows - EXE - 3640 kb
- Database Access Extension for Digital Unix - Z - 3292 kb
- Database Access Extension for HP-UX - Z - 2814 kb
- Database Access Extension for IBM RS/6000 AIX - Z - 2774 kb
- Database Access Extension for SGI IRIX - Z - 2936 kb
- Database Access Extension for Sun Solaris - Z - 2491 kb