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
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
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:
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:
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
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.
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
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