Re: [Qgis-developer] Oracle provider tests
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 07/06/2013 16:39, Jürgen E. Fischer ha scritto: > QGIS needs a specific CRS (ie. SRID) and a defined geometry type (point, line, > polygon) for each layer and offers what it finds in the database or requires > to > enter what is undefined. You can only select the lines that are fully > defined. > > That's very similar in the PostGIS and Oracle dialogs. It's just that Oracle > doesn't have "standard" constraints, that limit the usable geometry types and > SRIDs in a column and therefore also doesn't have a metadata table that > carries > that information, while PostGIS tables are usually quite constrainted. > > So for Oracle everything except the geometry columns themselves need to be > scanned, while for PostGIS that can be taken from the metadata table in the > usual case with applied constraints. > > If you create geometry column in PostGIS 2 with SRID 0 (meaning any) and type > GEOMETRY (any geometry type) the outcome might be quite similar and you get a > couple of lines for that column, each with a different combination of > available > geometry type and SRID combinations in the table plus another line where you > can enter geometry types and SRIDs that you don't already have. Hi. I think these notes should be added to the User Manual. Otto, do you agree? All the best. - -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlGx+P0ACgkQ/NedwLUzIr5OFgCeI9Y6OfzicTSI4Vef9PNc/Vx7 CggAn1SqdYxoQ396bhyI+NqMXEUeAtES =emp1 -END PGP SIGNATURE- ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Oracle provider tests
Hi Andreas, On Fri, 07. Jun 2013 at 16:09:25 +0200, Andreas Neumann wrote: > If yes, you have to choose the geometry type and the primary key column - > otherwise you cannot select and add the layer. Same with Postgis, but with > Postgis there is some good autodetection (depending on the QGIS version). QGIS needs a specific CRS (ie. SRID) and a defined geometry type (point, line, polygon) for each layer and offers what it finds in the database or requires to enter what is undefined. You can only select the lines that are fully defined. That's very similar in the PostGIS and Oracle dialogs. It's just that Oracle doesn't have "standard" constraints, that limit the usable geometry types and SRIDs in a column and therefore also doesn't have a metadata table that carries that information, while PostGIS tables are usually quite constrainted. So for Oracle everything except the geometry columns themselves need to be scanned, while for PostGIS that can be taken from the metadata table in the usual case with applied constraints. If you create geometry column in PostGIS 2 with SRID 0 (meaning any) and type GEOMETRY (any geometry type) the outcome might be quite similar and you get a couple of lines for that column, each with a different combination of available geometry type and SRID combinations in the table plus another line where you can enter geometry types and SRIDs that you don't already have. But the oracle provider isn't very widely used, so there are probably still things that could use attention. Jürgen -- Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-31 Dipl.-Inf. (FH) Rheinstraße 13Fax. +49-4931-918175-50 Software Engineer D-26506 Norden http://www.norbit.de committ(ed|ing) to Quantum GIS IRC: jef on FreeNode -- norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH Rheinstrasse 13, 26506 Norden GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502 ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Oracle provider tests
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 07/06/2013 16:12, rldhont ha scritto: > Hi Andreas, > > Thanks for this information. > > I have the table listing but I don't that I have to choose the geometry type > and the > primary key column. Do I have to select the SRS ? Yes, that's the point. Apart from a few small Oracle-related quirks, and very minor issues I have mentioned, it works very well. All the best. - -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlGx6wAACgkQ/NedwLUzIr6uRACfdGVKYXL3PvD5aDhAKOeuhLHO 1tcAnA14YV5ptD0L8mS1hpgx8LWsWsAv =xbfO -END PGP SIGNATURE- ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Oracle provider tests
Hi Andreas, Thanks for this information. I have the table listing but I don't that I have to choose the geometry type and the primary key column. Do I have to select the SRS ? René-Luc D'Hont Le 07/06/2013 16:09, Andreas Neumann a écrit : Hi René, Did you get the table listing? If yes, you have to choose the geometry type and the primary key column - otherwise you cannot select and add the layer. Same with Postgis, but with Postgis there is some good autodetection (depending on the QGIS version). Andreas Am 07.06.2013 16:07, schrieb rldhont: Hi Paolo, I would like to know if you have some trouble to select Oracle layer in the Oracle connection dialog ? I have tested the Oracle Connection for a customer and I didn't be able to add Oracle Layer to my project because I can't select it. Regards, René-Luc D'Hont Le 07/06/2013 10:15, Paolo Cavallini a écrit : Il 06/06/2013 10:50, Paolo Cavallini ha scritto: Il 06/06/2013 10:03, Paolo Cavallini ha scritto: This happens with multipolygons, not with points. nor with lines. We also noticed that one extra line is listed for most or all geom tables, without the type of geometry. Also, many tables have both a polygon and a multipolygon layer (or line and multiline). Is this a known phenomenon? Any explanation? This seems to be related to the (possibly messy) way the tables have been managed, so probably a local phenomenon. All the best. -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Oracle provider tests
Hi René, Did you get the table listing? If yes, you have to choose the geometry type and the primary key column - otherwise you cannot select and add the layer. Same with Postgis, but with Postgis there is some good autodetection (depending on the QGIS version). Andreas Am 07.06.2013 16:07, schrieb rldhont: > Hi Paolo, > > I would like to know if you have some trouble to select Oracle layer in > the Oracle connection dialog ? > > I have tested the Oracle Connection for a customer and I didn't be able > to add Oracle Layer to my project because I can't select it. > > Regards, > René-Luc D'Hont > > Le 07/06/2013 10:15, Paolo Cavallini a écrit : > Il 06/06/2013 10:50, Paolo Cavallini ha scritto: Il 06/06/2013 10:03, Paolo Cavallini ha scritto: > This happens with multipolygons, not with points. nor with lines. We also noticed that one extra line is listed for most or all geom tables, without the type of geometry. Also, many tables have both a polygon and a multipolygon layer (or line and multiline). Is this a known phenomenon? Any explanation? > This seems to be related to the (possibly messy) way the tables have > been managed, so > probably a local phenomenon. > All the best. > -- Paolo Cavallini - Faunalia > www.faunalia.eu > Full contact details at www.faunalia.eu/pc > Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario >> ___ >> Qgis-developer mailing list >> Qgis-developer@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/qgis-developer > > ___ > Qgis-developer mailing list > Qgis-developer@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Oracle provider tests
Hi Paolo, I would like to know if you have some trouble to select Oracle layer in the Oracle connection dialog ? I have tested the Oracle Connection for a customer and I didn't be able to add Oracle Layer to my project because I can't select it. Regards, René-Luc D'Hont Le 07/06/2013 10:15, Paolo Cavallini a écrit : -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 06/06/2013 10:50, Paolo Cavallini ha scritto: Il 06/06/2013 10:03, Paolo Cavallini ha scritto: This happens with multipolygons, not with points. nor with lines. We also noticed that one extra line is listed for most or all geom tables, without the type of geometry. Also, many tables have both a polygon and a multipolygon layer (or line and multiline). Is this a known phenomenon? Any explanation? This seems to be related to the (possibly messy) way the tables have been managed, so probably a local phenomenon. All the best. - -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlGxlqgACgkQ/NedwLUzIr5yVACgjGGGezO5D8TwcMP/3eYy6Rzx 078An0l5WzwdJceYhVHpNHifIrbbZ/qr =Wdm0 -END PGP SIGNATURE- ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Oracle provider tests
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 06/06/2013 10:50, Paolo Cavallini ha scritto: > Il 06/06/2013 10:03, Paolo Cavallini ha scritto: > >> This happens with multipolygons, not with points. > > nor with lines. > We also noticed that one extra line is listed for most or all geom > tables, without the type of geometry. Also, many tables have both a > polygon and a multipolygon layer (or line and multiline). > Is this a known phenomenon? Any explanation? This seems to be related to the (possibly messy) way the tables have been managed, so probably a local phenomenon. All the best. - -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlGxlqgACgkQ/NedwLUzIr5yVACgjGGGezO5D8TwcMP/3eYy6Rzx 078An0l5WzwdJceYhVHpNHifIrbbZ/qr =Wdm0 -END PGP SIGNATURE- ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Oracle provider tests
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 06/06/2013 10:50, Paolo Cavallini ha scritto: > Il 06/06/2013 10:03, Paolo Cavallini ha scritto: > >> This happens with multipolygons, not with points. > > nor with lines. We also noticed that one extra line is listed for > most or all geom tables, without the type of geometry. Also, many > tables have both a polygon and a multipolygon layer (or line and > multiline). Is this a known phenomenon? Any explanation? Thanks, > and sorry for the flood of email. forgot to say: overall, a good success, much smoother than expected. Thanks a lot. - -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlGww4YACgkQ/NedwLUzIr7BSQCgumLs3Lr747bRAamMt6YB6IBb so0AoI8eZEl/in4pih8cIrUz29YPY77E =jq6o -END PGP SIGNATURE- ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Oracle provider tests
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 06/06/2013 10:03, Paolo Cavallini ha scritto: > This happens with multipolygons, not with points. nor with lines. We also noticed that one extra line is listed for most or all geom tables, without the type of geometry. Also, many tables have both a polygon and a multipolygon layer (or line and multiline). Is this a known phenomenon? Any explanation? Thanks, and sorry for the flood of email. - -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEUEARECAAYFAlGwTXIACgkQ/NedwLUzIr5oXQCfRYA9aqACp3beqRFWf6rGpgwN PAAAkwWRZs/1Rq4X4w+ZDDKnv7zByXs= =D5ZF -END PGP SIGNATURE- ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Oracle provider tests
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 06/06/2013 10:00, Paolo Cavallini ha scritto: > Another thing: tables registered with ESRI are seen as geometries, > but when loaded geometries are empty (alphanumeric tables ok). The > same data, extracted with a view, are loaded correctly by QGIS. This happens with multipolygons, not with points. All the best. - -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlGwQmIACgkQ/NedwLUzIr6PCACgupLzcj54b3AOvA5tQasGHc7E teUAn209q1yKp6gOcmuYod2s8u+cEbnW =HOQ9 -END PGP SIGNATURE- ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
Re: [Qgis-developer] Oracle provider tests
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 06/06/2013 09:53, Paolo Cavallini ha scritto: > Hi all. I have real life instance of Oracle to play with. I'm > finding several minor issues: Another thing: tables registered with ESRI are seen as geometries, but when loaded geometries are empty (alphanumeric tables ok). The same data, extracted with a view, are loaded correctly by QGIS. All the best. - -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlGwQY8ACgkQ/NedwLUzIr4WXQCeJPwy3Wk74PuW4S669/XrB7bc N0sAoIVPzpKxJVTXBlPxd1URGoTATyK+ =P+CN -END PGP SIGNATURE- ___ Qgis-developer mailing list Qgis-developer@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-developer
