[postgis-users] RE: ole db, arccatalog and arcmap
Hartmut Tschauner
tschaun at hotmail.com
Fri Feb 11 22:13:33 PST 2005
Hi,
The PostgreSQL OLEDB Provider does not support rowsets, which ArcGIS and
other commercial software look for in a data source. That's why you can
establish a connection, but it will always look empty to ArcGIS, regardless
of whether you're trying to load spatial or non-spatial data.
I am just about to finish an extension to ArcMap that loads spatial and
non-spatial data from PostGIS and PostgreSQL (as well as other databases)
into ArcMap. It does not use a live OLEDB connection, but caches data in
local scratch workspaces (personal geodatabase, i.e., Microsoft Jet format).
Another version for ArcScene will follow; the extension supports Z- and
M-aware geometries. I'm working on one more known bug and I still have to
write the help texts. If you're interested I can send you a copy. I will
also post an announcement to this list and ESRI ArcScripts when the
extension is finished.
Cheers,
Hartmut
Hartmut Tschauner
Dept. of Archaeology
Seoul National University
Gwanak-gu, Sillimdong 56-1
Seoul, 151-742
Korea
ph. +82 (2) 880-9260
-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
postgis-users-request at postgis.refractions.net
Sent: Saturday, February 12, 2005 5:00 AM
To: postgis-users at postgis.refractions.net
Subject: postgis-users Digest, Vol 28, Issue 26
Send postgis-users mailing list submissions to
postgis-users at postgis.refractions.net
To subscribe or unsubscribe via the World Wide Web, visit
http://postgis.refractions.net/mailman/listinfo/postgis-users
or, via email, send a message with subject or body 'help' to
postgis-users-request at postgis.refractions.net
You can reach the person managing the list at
postgis-users-owner at postgis.refractions.net
When replying, please edit your Subject line so it is more specific than
"Re: Contents of postgis-users digest..."
Today's Topics:
1. Re: PostgreSQL 7.1 support (alex bodnaru)
2. Re: Small speed comparison (Markus Schaber)
3. Re: Small speed comparison (Markus Schaber)
4. Re: Small speed comparison (strk at refractions.net)
5. ole db, arccatalog and arcmap (Ieuan Williams)
6. RE: ole db, arccatalog and arcmap (Craig Miller)
7. transform function (Jean-Denis Giguere)
----------------------------------------------------------------------
Message: 1
Date: Fri, 11 Feb 2005 01:22:41 +0200
From: alex bodnaru <alexbodn at 012.net.il>
Subject: Re: [postgis-users] PostgreSQL 7.1 support
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID: <1108077761.7809.10.camel at localhost.localdomain>
Content-Type: text/plain
hi markus,
On Wed, 2005-02-09 at 17:23 +0100, Markus Schaber wrote:
> BTW, why do you think the patch method is not reliable?
>
..
> As the differences are rather small (see the patch), I think managing
> two different versions is not worth the effort.
>
the patch is a diff between two files, so you have to maintain them both,
anyway.
> I think it may be possible to achieve this using reflection and a
> Functor-like approach. This way we could even create a single jar file
> that works with both jdbc variants. But we would need both jdbc
> variants at compile time (or deliver our own derived Stub files of
> them with PostGIS for compilation that must not be packed into the jar).
>
we might make a small jar with only the different stuff, then append this
jar to the CLASSPATH, after the original pgjdbc.
btw, the original pgjdbc version should be automatically detected, as the
latest pgjdbc##.jar in /usr/share/java.
> I'll do some further experimentation on that.
>
thanks, please tell me if i could help.
best wishes,
alex
------------------------------
Message: 2
Date: Fri, 11 Feb 2005 11:39:30 +0100
From: Markus Schaber <schabios at logi-track.com>
Subject: Re: [postgis-users] Small speed comparison
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID: <420C8B62.1050904 at logi-track.com>
Content-Type: text/plain; charset="iso-8859-15"
Hi,
I re-ran my benchmarks with a 1.0.0 CVS checkout from today morning, to see
the impact of the alignment issues. I simply added the new timings after the
quoting of the old ones. The hardware setup is the same, and the table was
not changed, so the test environment should be comparable.
Please note that all Geometries are polygonal, so this does not say anything
about other geometries.
> lwgeom=# select geom from adminbndy1;
> Zeit: 8629,822 ms
> Zeit: 6401,693 ms
Zeit: 10556,032 ms
Zeit: 6301,014 ms
Zeit: 5809,858 ms
> lwgeom=# select asBinary(geom) from adminbndy1;
> Zeit: 11648,607 ms
> Zeit: 7845,229 ms
Zeit: 7604,296 ms
Zeit: 7465,358 ms
Zeit: 8062,700 ms
> lwgeom=# select asEWKB(geom) from adminbndy1;
> Zeit: 7824,009 ms
> Zeit: 7308,423 ms
Zeit: 7191,243 ms
Zeit: 7342,762 ms
Zeit: 7214,146 ms
> lwgeom=# select asText(geom) from adminbndy1;
> Zeit: 33655,132 ms
> Zeit: 33154,569 ms
Zeit: 32816,896 ms
Zeit: 32792,680 ms
Zeit: 32645,417 ms
> lwgeom=# select asEWKT(geom) from adminbndy1;
> Zeit: 34402,441 ms
Zeit: 37156,399 ms
Zeit: 35210,384 ms
Zeit: 33757,256 ms
> lwgeom=# select asEWKB(geom)::bytea from adminbndy1;
> Zeit: 7444,995 ms
Zeit: 8681,531 ms
Zeit: 7225,146 ms
Zeit: 7230,526 ms
I woult not try to read too much out of those results (as the test
environment was not 100% clean), but it seems go be a slight speedup. I
could think of three possible reasons:
- Possibly, some optimizations at other places between my first test CVS
checkout (start of january) and now overrule the effect of your
alignment work.
- The new code somehow allows better use of processor caches and/or
pipelines
- My processor (Mobile Intel Pentium 4 @ 2Ghz) profits from the better
alignment speed-wise.
Personally, I would think that the third variant is the most likely one.
Can anyone do some similar tests on another hardware?
Markus
--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 z|rich phone +41-43-888 62 52 | fax
+41-43-888 62 53 mailto:schabios at logi-track.com | www.logi-track.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 256 bytes
Desc: OpenPGP digital signature
Url :
http://lists.refractions.net/pipermail/postgis-users/attachments/20050211/ef
f8908d/signature-0001.bin
------------------------------
Message: 3
Date: Fri, 11 Feb 2005 11:46:20 +0100
From: Markus Schaber <schabios at logi-track.com>
Subject: Re: [postgis-users] Small speed comparison
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID: <420C8CFC.2010406 at logi-track.com>
Content-Type: text/plain; charset="iso-8859-15"
Hi,
I also re-ran the JDBC tests, here are the results:
> Creating JDBC connection to lwgeom... fetching...
> Result 0: 83 rows fetched in 22.572s.
> Result 1: 83 rows fetched in 22.187s.
> Result 2: 83 rows fetched in 21.975s.
> Result 3: 83 rows fetched in 23.475s.
Creating JDBC connection to lwgeom... fetching...
Result 0: 83 rows fetched in 23.375s.
Result 1: 83 rows fetched in 22.783s.
Result 2: 83 rows fetched in 22.684s.
Result 3: 83 rows fetched in 22.675s.
The timings seem to be roughly the same, no significant speed decrease.
Markus
--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 z|rich phone +41-43-888 62 52 | fax
+41-43-888 62 53 mailto:schabios at logi-track.com | www.logi-track.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 256 bytes
Desc: OpenPGP digital signature
Url :
http://lists.refractions.net/pipermail/postgis-users/attachments/20050211/7f
fd08eb/signature-0001.bin
------------------------------
Message: 4
Date: Fri, 11 Feb 2005 11:49:58 +0100
From: strk at refractions.net
Subject: Re: [postgis-users] Small speed comparison
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID: <20050211104958.GA870 at freek.keybit.net>
Content-Type: text/plain; charset=iso-8859-1
I'm happy to hear about this, speed was my primary concern.
I'd exclude your first guess, second and third could be, also consider the
reduced levels of indirection now that points scan is done using real
objects vs. pointers.
Would people having problems with qgis and mapserver try their tests again ?
--strk;
On Fri, Feb 11, 2005 at 11:39:30AM +0100, Markus Schaber wrote:
> Hi,
>
> I re-ran my benchmarks with a 1.0.0 CVS checkout from today morning,
> to see the impact of the alignment issues. I simply added the new
> timings after the quoting of the old ones. The hardware setup is the
> same, and the table was not changed, so the test environment should be
comparable.
>
> Please note that all Geometries are polygonal, so this does not say
> anything about other geometries.
>
> > lwgeom=# select geom from adminbndy1;
> > Zeit: 8629,822 ms
> > Zeit: 6401,693 ms
>
> Zeit: 10556,032 ms
> Zeit: 6301,014 ms
> Zeit: 5809,858 ms
>
> > lwgeom=# select asBinary(geom) from adminbndy1;
> > Zeit: 11648,607 ms
> > Zeit: 7845,229 ms
>
> Zeit: 7604,296 ms
> Zeit: 7465,358 ms
> Zeit: 8062,700 ms
>
> > lwgeom=# select asEWKB(geom) from adminbndy1;
> > Zeit: 7824,009 ms
> > Zeit: 7308,423 ms
>
> Zeit: 7191,243 ms
> Zeit: 7342,762 ms
> Zeit: 7214,146 ms
>
> > lwgeom=# select asText(geom) from adminbndy1;
> > Zeit: 33655,132 ms
> > Zeit: 33154,569 ms
>
> Zeit: 32816,896 ms
> Zeit: 32792,680 ms
> Zeit: 32645,417 ms
>
> > lwgeom=# select asEWKT(geom) from adminbndy1;
> > Zeit: 34402,441 ms
>
> Zeit: 37156,399 ms
> Zeit: 35210,384 ms
> Zeit: 33757,256 ms
>
> > lwgeom=# select asEWKB(geom)::bytea from adminbndy1;
> > Zeit: 7444,995 ms
>
> Zeit: 8681,531 ms
> Zeit: 7225,146 ms
> Zeit: 7230,526 ms
>
> I woult not try to read too much out of those results (as the test
> environment was not 100% clean), but it seems go be a slight speedup.
> I could think of three possible reasons:
>
> - Possibly, some optimizations at other places between my first test CVS
> checkout (start of january) and now overrule the effect of your
> alignment work.
>
> - The new code somehow allows better use of processor caches and/or
> pipelines
>
> - My processor (Mobile Intel Pentium 4 @ 2Ghz) profits from the better
> alignment speed-wise.
>
> Personally, I would think that the third variant is the most likely one.
>
> Can anyone do some similar tests on another hardware?
>
> Markus
>
>
> --
> markus schaber | dipl. informatiker
> logi-track ag | rennweg 14-16 | ch 8001 z|rich phone +41-43-888 62 52
> | fax +41-43-888 62 53 mailto:schabios at logi-track.com |
> www.logi-track.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
------------------------------
Message: 5
Date: Fri, 11 Feb 2005 11:21:17 +0000
From: Ieuan Williams <ieuan.williams at gmail.com>
Subject: [postgis-users] ole db, arccatalog and arcmap
To: postgis-users at postgis.refractions.net
Message-ID: <cd3a33a90502110321f6b8b34 at mail.gmail.com>
Content-Type: text/plain; charset=US-ASCII
Has anybody managed to connect to a postgresql/postgis db from arcmap.
I've set up an ole db data link (using 1.0.0.15) in arccatalog to a
postrgesql 8/postgis (on win2k), the test connection comes back as
successful, but when I try to use this connection in arcmap no tables from
the database are shown. Has anybody got any ideas?
Thanks
Ieuan
------------------------------
Message: 6
Date: Fri, 11 Feb 2005 08:27:29 -0800
From: "Craig Miller" <craig.miller at spatialminds.com>
Subject: RE: [postgis-users] ole db, arccatalog and arcmap
To: "'Ieuan Williams'" <ieuan.williams at gmail.com>, "'PostGIS Users
Discussion'" <postgis-users at postgis.refractions.net>
Message-ID:
<ALEXANDRIAFVjCRGryW00000005 at ALEXANDRIA.spatialminds.local>
Content-Type: text/plain; charset="us-ascii"
That data provider doesn't support the OGIS extensions to OLEDB.
Are you looking to view tables, or feature tables? If it is the latter then
it won't work. If it is the former, in theory it should work.
--Craig
-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Ieuan
Williams
Sent: Friday, February 11, 2005 3:21 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] ole db, arccatalog and arcmap
Has anybody managed to connect to a postgresql/postgis db from arcmap.
I've set up an ole db data link (using 1.0.0.15) in arccatalog to a
postrgesql 8/postgis (on win2k), the test connection comes back as
successful, but when I try to use this connection in arcmap no tables from
the database are shown. Has anybody got any ideas?
Thanks
Ieuan
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
------------------------------
Message: 7
Date: Fri, 11 Feb 2005 12:47:56 -0500
From: Jean-Denis Giguere <jdenisgiguere at fastmail.fm>
Subject: [postgis-users] transform function
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID: <420CEFCC.8040103 at fastmail.fm>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Greetings,
I would like to reproject data obtained with ogr2ogr. Sadly, I get all
result with an empty geometry description.
ogr2ogr generate spatial_ref_sys entry with the following fields : oid, srid
and srtext (not proj4text).
If I change the srid to a value generated by spatial_ref_sys.sql, everything
works well. Do we need the proj4text column in spatial_ref_sys to use
transform function ?
Jean-Denis
--
Jean-Denis Giguhre
Itudiant en giomatique
appliquie ` l'environnement
Stagiaire ` l'Agence de diveloppement
de riseaux locaux de services de santi
et de services sociaux de l'Estrie
Til. 829-3400 42008
Courriel. jdenisgiguere at fastmail.fm
------------------------------
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
End of postgis-users Digest, Vol 28, Issue 26
*********************************************
More information about the postgis-users
mailing list