Re: [Qgis-user] Visibility of items in SQL Database

2021-06-08 Thread Luke
Hey Johanna Some things to check 1. Your records have a srid recorded that aligns with the srid recorded for the dataset. You can check this by querying in SQL Server with query "select .STSrid from ". Compare this with what you have recorded in the geometry_columns table for the table. They

Re: [Qgis-user] Visibility of items in SQL Database

2021-06-08 Thread Johanna Botman
Thanks Bo Victor for that suggestion, but that is not the problem. I should have mentioned that I had already tried changing the symbology. Johanna Botman Assets / GIS Officer - Melton City Council Hi Johanna - I suspect, you have some symbology issues with the layer/table from DB1 Try to

Re: [Qgis-user] How to edit oracle table data from view

2021-06-08 Thread Dario C
Thank you. Is it something you add directly in the view sql code or you need to do a new view with this code? Il giorno mar 8 giu 2021 alle ore 16:58 uclaros ha scritto: > Hi, > you could add an "Instead of update" trigger on your view to modify your > data table. > > > > -- > Sent from:

Re: [Qgis-user] How to edit oracle table data from view

2021-06-08 Thread uclaros
Hi, you could add an "Instead of update" trigger on your view to modify your data table. -- Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info:

[Qgis-user] How to edit oracle table data from view

2021-06-08 Thread Dario
Hi, I have thousands of alphanumeric datas in a oracle table. Then I have a view for linking this data to a geometry data table, still in oracle. I’m working in qgis reading my oracle view, but, every time I have to edit some data (main alphanumeric table), I have to search by expression inside

Re: [Qgis-user] Visibility of items in SQL Database

2021-06-08 Thread Bo Victor Thomsen
Hi Johanna - I suspect, you have some symbology issues with the layer/table from DB1 Try to change the symbology from "whatever it is now" to a "Single symbol" for the DB1 layer and check if your missing objects appear Med venlig hilsen / Kind regards Bo Victor Thomsen Den 08-06-2021 kl.

[Qgis-user] Highlighting GetFeatureInfo

2021-06-08 Thread Christoph Jung
Hello everyone, Imagine I have a WMS-Layer in QGIS. If I click on an object, the response of the GetFeatureInfo-Requests contains no geometry data, i.e. the object will not be highlighted in the map. Is there a possibility to highlight the clicked object of a WMS-Layer? If a service provider

[Qgis-user] Visibility of items in SQL Database

2021-06-08 Thread Johanna Botman
Hi, I have a situation where I have two SQL databases and I have to move data from one to the other. Always the same direction from DB1 to DB2 My issue is that the items show in some tables in DB1 but do not display in QGIS. I can select from the table, but I can't select items on the QGIS