New answers tagged query
Note that while we usually talk of latitude and longitude, in that order, there are different conventions for this ordering, even within GIS, cartography and surveying. The convention in PostGIS, and others, is longitude then latitude relating to X and Y, respectively. Thus, for London try: SELECT * FROM planet_osm_point WHERE ST_X (ST_Transform ...
Selection by attributes: "field_name" LIKE 'C%' Field_name is attribute that contains your annotations.
Simply add the alias in quotes after the column name.
you cannot use equal with more than one value use either in or OR to do this "\"STATION_ID\" IN ('CAP', 'DDM')" "\"STATION_ID\" = 'CAP' OR \"STATION_ID\" = 'DDM'" note that I recommand using """ to clarify your strings """ "STATION_ID" IN ('CAP', 'DDM') """
As seen in the comments, it was a bug. You can see the bug in the bugtracker. It was fixed in the 2.1.2 release However, being caught by that bug outlined a fundamental issue in our design, and made it possible to realize that the app would not be performing well using such a generic type. I would not advise to use GeometryCollections unless you know ...
One way would be to use a relational database where you build the queries, then use those queries from QGIS. If your stuck with shapefile you can join them virtually with the Join tab of the layer properties. If your using QGIS 2.2 you can view the relation as a parent - child relationship in the attribute window.
Top 50 recent answers are included