Re: [Qgis-user] Visibility of items in SQL Database
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 should match otherwise they are filtered when connecting to the dataset. 2. Check the geometry types are also the same as what is being recorded in geometry_columns table. "select .STGeometryType() from ". This is often the case for us and usually is a issue with geometry collections particularly if you use tools like FME to fix geometry as it tends to mangle things further. 3. Check geometry validity within SQL Server. I think that QGIS filters out invalid geometry in some cases so you won't detect it in qgis if they are filtered. I am not 100% sure this happens with newer versions of QGIS but I have seen it in the past. "select .IsValidDetailed() from where .STIsValid() = 0" Hope that helps Luke On Wed, Jun 9, 2021 at 8:20 AM Johanna Botman wrote: > 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 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. 08:39 skrev 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 > > canvas > > I can cut and paste from DB1 to DB2 and the items display in DB2. > > I can manually create an item in an affected table in DB1 and it will > > display. > > When I hover with my Add [polygon/line/point] tool, the square to show > > where the vertices (for snapping) are displayed as I move my cursor > > over them. > > When I run the Validate Geometry tool, the results are that I have > > valid geometry and those layers are displayed. > > In SQL server manager I can see the spatial results for those tables > > in DB1. > > Projections are the same for each DB > > There are no Layer Scale Visibility settings in play for either DB > > It does not affect all tables in DB1. > > > > Can anyone suggest some further troubleshooting strategies? > > *Johanna Botman* > > > > Assets / GIS Officer ? Melton City Council > > > *** > The information in this message is privileged and confidential, intended > only for the use of the individual or entity named above. If you are not > the intended recipient you are hereby notified to delete the message and > that any dissemination, copying or use of its content is strictly > prohibited. If you have received this message in error please notify the > Melton City Council. > > *** > ___ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > -- *Luke Bassett* * *Melbourne Australia ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Visibility of items in SQL Database
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 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. 08:39 skrev 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 > canvas > I can cut and paste from DB1 to DB2 and the items display in DB2. > I can manually create an item in an affected table in DB1 and it will > display. > When I hover with my Add [polygon/line/point] tool, the square to show > where the vertices (for snapping) are displayed as I move my cursor > over them. > When I run the Validate Geometry tool, the results are that I have > valid geometry and those layers are displayed. > In SQL server manager I can see the spatial results for those tables > in DB1. > Projections are the same for each DB > There are no Layer Scale Visibility settings in play for either DB > It does not affect all tables in DB1. > > Can anyone suggest some further troubleshooting strategies? > *Johanna Botman* > > Assets / GIS Officer ? Melton City Council *** The information in this message is privileged and confidential, intended only for the use of the individual or entity named above. If you are not the intended recipient you are hereby notified to delete the message and that any dissemination, copying or use of its content is strictly prohibited. If you have received this message in error please notify the Melton City Council. *** ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] How to edit oracle table data from view
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: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html > ___ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] How to edit oracle table data from view
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: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] How to edit oracle table data from view
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 the main table and I cannot edit my view clicking on the visible geometry (I guess because it is a view and I cannot do it directly from a view table). Is there any other method, more friendly of what I’m doing now? Thank you _ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Visibility of items in SQL Database
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. 08:39 skrev 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 canvas I can cut and paste from DB1 to DB2 and the items display in DB2. I can manually create an item in an affected table in DB1 and it will display. When I hover with my Add [polygon/line/point] tool, the square to show where the vertices (for snapping) are displayed as I move my cursor over them. When I run the Validate Geometry tool, the results are that I have valid geometry and those layers are displayed. In SQL server manager I can see the spatial results for those tables in DB1. Projections are the same for each DB There are no Layer Scale Visibility settings in play for either DB It does not affect all tables in DB1. Can anyone suggest some further troubleshooting strategies? ** ** *Johanna Botman* Assets / GIS Officer – Melton City Council *** The information in this message is privileged and confidential, intended only for the use of the individual or entity named above. If you are not the intended recipient you are hereby notified to delete the message and that any dissemination, copying or use of its content is strictly prohibited. If you have received this message in error please notify the Melton City Council. *** ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Highlighting GetFeatureInfo
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 offers their data as WMS and WFS, is it possible to start a GetFeature-request from the WFS instead of a GetFeatureInfo-Request from the WMS? Can I configure the identify features button for WMS-layers? Greetings, Christoph ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user