Re: [Qgis-user] Opengeo (Geoserver) - QGIS 1:n relations
Jonathan Moules-3 wrote > Hi Pedro, > Generally speaking GeoServer doesn't do 1:n relationships. > At the base level, any GeoServer layer represents just one database table. > > There are 3 exceptions: > 1) Where GeoServer has been pointed to a View (see Alex's reply) > 2) Where you have a layergroup. As their name suggests these contain many > layers grouped together to appear as one. > 3) If you're using an SQLView - > http://docs.geoserver.org/stable/en/user/data/database/sqlview.html > > I've not used the OpenGeo plugin so don't know what it's doing when it > does the 1:n relationship business. > > Cheers, > Jonathan > > -Original Message- > From: > qgis-user-bounces@.osgeo > [mailto: > qgis-user-bounces@.osgeo > ] On Behalf Of Pedro > Sent: Monday, June 08, 2015 3:00 PM > To: > qgis-user@.osgeo > Subject: [Qgis-user] Opengeo (Geoserver) - QGIS 1:n relations > > Hi, > > I'm using Opengeo plugin in QGIS top publish at Geoserver. > Have a problem that I don't know how to handle it. > > At QGIS Project Properties established a relationship between two postgis > tables (1:n). > So when when I open an object editor got the information from the two > tables. (just 1 table have a geometry column). > > By submitting the project to the Geoserver (with OpenGeo plugin) it takes > the individual layers, i.e., it lose the relationship between the tables. > > Are you aware if there is a way to keep this 1:n relationship in > Geoserver? > > http://lists.osgeo.org/mailman/listinfo/qgis-user Jonathan and Alex, appreciate your insights. Based on that I will try to built something that "emulate" the 1:n relationship. Not quite related but another problem emerged when using the OpenGeo plugin... I would like to give a different name (alias) to the columns of my tables and I did that at QGIS Layer Properties, but when I save the style in a .sld file but such information is not stored in the file (in a .qml style file all the information is stored). So, as anyone know if it's possible to give aliases to columns at geoserver (or any kind of workaround like converting qml file to sld...) ? Thanks, Pedro -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Opengeo-Geoserver-QGIS-1-n-relations-tp5209762p5210950.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Opengeo (Geoserver) - QGIS 1:n relations
Hi Pedro, Generally speaking GeoServer doesn't do 1:n relationships. At the base level, any GeoServer layer represents just one database table. There are 3 exceptions: 1) Where GeoServer has been pointed to a View (see Alex's reply) 2) Where you have a layergroup. As their name suggests these contain many layers grouped together to appear as one. 3) If you're using an SQLView - http://docs.geoserver.org/stable/en/user/data/database/sqlview.html I've not used the OpenGeo plugin so don't know what it's doing when it does the 1:n relationship business. Cheers, Jonathan -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Pedro Sent: Monday, June 08, 2015 3:00 PM To: qgis-user@lists.osgeo.org Subject: [Qgis-user] Opengeo (Geoserver) - QGIS 1:n relations Hi, I'm using Opengeo plugin in QGIS top publish at Geoserver. Have a problem that I don't know how to handle it. At QGIS Project Properties established a relationship between two postgis tables (1:n). So when when I open an object editor got the information from the two tables. (just 1 table have a geometry column). By submitting the project to the Geoserver (with OpenGeo plugin) it takes the individual layers, i.e., it lose the relationship between the tables. Are you aware if there is a way to keep this 1:n relationship in Geoserver? Thanks, Pedro -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Opengeo-Geoserver-QGIS-1-n-relations-tp5209762.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user This message has been scanned for viruses by MailControl - www.mailcontrol.com Click https://www.mailcontrol.com/sr/+wtcOCPVva7GX2PQPOmvUikZGg4PuPFT2FIMF37VyACsgpHXbY13Nm94V2BI4XbQuc0HPsxnq8AgL4AI7al!HQ== to report this email as spam. HR Wallingford and its subsidiaries uses faxes and emails for confidential and legally privileged business communications. They do not of themselves create legal commitments. Disclosure to parties other than addressees requires our specific consent. We are not liable for unauthorised disclosures nor reliance upon them. If you have received this message in error please advise us immediately and destroy all copies of it. HR Wallingford Limited Howbery Park, Wallingford, Oxfordshire, OX10 8BA, United Kingdom Registered in England No. 02562099 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Opengeo (Geoserver) - QGIS 1:n relations
On 06/08/2015 07:00 AM, Pedro wrote: > Hi, > > I'm using Opengeo plugin in QGIS top publish at Geoserver. > Have a problem that I don't know how to handle it. > > At QGIS Project Properties established a relationship between two postgis > tables (1:n). > So when when I open an object editor got the information from the two > tables. (just 1 table have a geometry column). > > By submitting the project to the Geoserver (with OpenGeo plugin) it takes > the individual layers, i.e., it lose the relationship between the tables. > > Are you aware if there is a way to keep this 1:n relationship in Geoserver? > > > Thanks, > Pedro > You probably need to create a Postgis view yourself that mimics what the plugin did. Then add this view directly to geoserver. Other than that sounds like a feature request to OpenGeo for adding more features to their plugin. Thanks, -Alex ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Opengeo (Geoserver) - QGIS 1:n relations
Hi, I'm using Opengeo plugin in QGIS top publish at Geoserver. Have a problem that I don't know how to handle it. At QGIS Project Properties established a relationship between two postgis tables (1:n). So when when I open an object editor got the information from the two tables. (just 1 table have a geometry column). By submitting the project to the Geoserver (with OpenGeo plugin) it takes the individual layers, i.e., it lose the relationship between the tables. Are you aware if there is a way to keep this 1:n relationship in Geoserver? Thanks, Pedro -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Opengeo-Geoserver-QGIS-1-n-relations-tp5209762.html Sent from the Quantum GIS - User mailing list archive at Nabble.com. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
