[postgis-users] Accessing PostGIS from ArcView

[Armin Burger]

Hisaji,

I know that determining some database values could cause errors
depending on the installation. I will have a closer look at potential
error possibilities. And add at least a comment to the readme about
preassumed tables/fields. I always used shp2pgsql for the initial
database creation and added other tables later with the same structure.

To the second question (i hope I understood you right): When loading a
PostGIS theme as first theme into the view then the view has no really
valid extent. Therefore then all values of the table are loaded (i.e.,
no spatial query is sent to the database). If there is already  a theme
in the view, then there is an extent and only the data for this spatial
extent are loaded from the db.

Armin





> Thank you very much, Mr. Leeming and Mr. Burger.

>  I found and got AV Post GIS Connect Extension's new zip file from
> http://digilander.iol.it/arminburger/download/avpgcon.zip and
installed
> it.

>  It works very fine.

>  And I also tried to modified "AVPGCon.AddThmDlg.OK" for the case
> "spatial_ref_sys" table has no record like this.

> '------------------------------
> ' GET DEFAULT REF SYS FROM DB
> '------------------------------

> ---------------------------------------------------------------------

> ' THEN FROM SELECT VIA GID FIELD
> if(pgRefSys0 <> nil) then  '<<--- ADD
>  if (pgRefSys0.Count = 0) then
>    sridQuery = "SELECT SRID("+pgGeoCol+") FROM " + pgTable + " where
> gid=0"
>    pgRefSys0 =
> av.Run("AVPGCon.ReturnValues",{conList,sridQuery,pgTable})
>    if (pgRefSys0.Count = 0) then
>      pgRefSys0 = "-1"
>    end
>  end
> else                  '<<--- ADD
>  pgRefSys0 = "-1"     '<<--- ADD
> end                   '<<--- ADD


>  I have one question about AV Post GIS Connect Extension. AV Post GIS
> Connect Extension seemed First loaded map file's extent detemines
> following loaded maps' extent. Is this right?

>  Best regards.



> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users