Copyright © 2006 Armin Burger, Steffen Macke
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. A copy of the license is available from the Free Software Foundation (http://www.gnu.org).
$Date: 2005-04-06 07:05:32 +0200 (Wed, 06 Apr 2005) $
Table of Contents
The AV PostGIS Extension allows to use PostGIS databases from ArcView 3.*.
The DC Processing Extension is available from http://avpgcon.sourceforge.net. It is free software released under the terms of the MIT license - the full source code is available (Open Source).
This manual describes version 1.13.1 of the DC Processing Extension.
The extension provided the following functionality:
| Retrieve PostGIS data as shapefile and load them into ArcView, including data refresh |
| Re-project and re-encode PostGIS data and create shapefiles |
| Identify and editing of attribute information directly on the database |
ArcView version 3.0, 3.1, 3.2 or 3.3 is required in order to use the AV PostGIS Extension.
A PostgreSQL database witht the PostGIS extension is required.
![[Note]](images/note.png) | Note |
|---|---|
This extension will not work with ArcGIS ArcView 8.* or 9.*. |
How to install the AV PostGIS Extension using either the installer or manually.
How to install the AV PostGIS Extension using the installer.
Download the installer and execute it.
Select your ArcView installation folder.
Save the extension file (avpgcon.avx) in the
ArcView extensions directory (Usually this is
c:\esri\av_gis30\arcview\ext32).
Copy the following files to the ArcView bin32
directory:
pgsql2shp.exe |
shp2pgsql.exe |
libpq.dll |
libiconv-2.dll |
psql.exe |
Copy avpgcon.ini in the ArcView
etc directory. Adapt default values according to
your database. The avpgcon.ini file only serves to
define default values.
The extension has to be loaded to your ArcView project before you can use it.
Load the Extension into ArcView ( -> )
In the View GUI, there will be a new menu called "PostGIS-Connect" (If necessary, open a view to see it).
In additon, there will be a new menus called "DC Processing" in the Project and Table GUIs.
For more information on Extensions, see your ArcView Documentation.
Table of Contents
If you want to use a port other than 5432, add the port number after the host separated with a @. Eg. localhost@5444.
The functions provided by the AV PostGIS Extension.
Functions added to the View GUI by the extension.
To the right there are 2 new buttons.
In the dialogs, all mandatory entries are marked with an '*' sign after the item name.
With the '+' button you can load postgis themes. In the 'Add...' dialog you have to specify host, database, user etc.
Next, choose the database table and the fields.
If the geometry column is specified in the ini file then that value will be taken. Otherwise the extension tries to retrieve this information from the database, what is a bit slower.
You can select a different reference system than the one stored in the database using re-projection of the data and get the shapefile in your defined coordinate system. The reference systems are read from the PostGIS table 'spatial_ref_sys'. In the select dialog you can narrow the displayed systems using the 'LIKE' textbox.
For 'WHERE' you can define additional WHERE clauses, i.e. additional filters on attributes (don't write the 'WHERE', it is inserted automatically).
The shapefiles have to be written to a temporary dir, the default project home dir is inserted in the textfield. Be careful using the same name in different views, because the files in the temp directory from one will overwrite the ones from another view.
With the refresh button you can refresh the loaded theme to new view extents.
The properties of a PostGIS Theme can be changed with the menu PostGIS-Connect -> PostGIS Theme Properties.
![[Caution]](images/caution.png) | Caution |
|---|---|
Note that there's also a possible security aspect: the password is written as object tag to every PostGIS theme and therefore readable in the ArcView project file. This could be avoided using an external en/decryption procedure. |
Refresh contents of PostGIS themes that have been previously added (Section 2.1.1, “Add PostGIS Theme”).
Change parameters of PostGIS themes that have been previously added (Section 2.1.1, “Add PostGIS Theme”).
The version number shall be derived from the packaged PostGIS version plus an additional digit for the actual extension.
A basic debug functionality can be set in the INI file. This will write a file avpgcon.log to the system TEMP directory.
PostgreSQL releases with security fixes trigger new AV PostGIS Connection extension releases.
A
- add, Add PostGIS Theme
- avpgcon.ini, Edit INI File
C
- connection, Connection
D
- development, Development
E
- extension, Loading the Extension
F
- files
- avpgcon.ini, Edit INI File
G
- general, General
I
- identify, PostGIS Identify
- installation, Installation
- installer, Installation Using the Installer
- manual, Manual Installation
- introduction, Introduction
L
- license, Introduction
- load extension, Loading the Extension
N
- news, What's New?
P
- preferences, Edit INI File
- properties, PostGIS Theme Properties
R
- reference, Reference
- refresh, Refresh PostGIS Themes
- requirements, Requirements
S
- security, Add PostGIS Theme
- shapefile, Add PostGIS Theme
T
- theme, Add PostGIS Theme
- properties, PostGIS Theme Properties
V
- version number, Development