= a postgis table "myTable" with a QGis filter ("myFilter"
> applied to it) to a new postgis *table*
> I was hoping to find an (automated!) way to convert the layer to a new
> postgis *view*, something like:
>create or replace view "myView"
>as se
You can also use the QGIS database tool from the menu...to get to the SQL
query gui...construct your query through that - add table, add a condition
(where blah = blah)...then you have the ability to create a view in the
postgis database.rather than writing sql query using pgadmin etc...
On Th
Yeah I do a "long way" around for this.
Add the layer - add delimited text layer(or use the geoprocessing task)
Plot those points in its original projection.
Export that layer to the new grid / projection you want to generate the
coordinates.
Add new fields to this new layer, then use field ca
> https://docs.qgis.org/3.16/en/docs/user_manual/working_with_vector/functions_list.html#now
>
> https://docs.qgis.org/3.16/en/docs/user_manual/working_with_vector/functions_list.html#age
>
> Alexandre Neto
> User support
> www.qcooperative.net
>
>
> tim dunlevie escrev
Hi guys,
I am trying to symbolise a map based on a date field ('-MM-DD') versus
Current_Date
I want to colour polygons based on these categories:
- day / month within 3 months of CURRENT_DATE (today).
- day / month within 6 months of CURRENT_DATE
- day / month within 9 months of CURRENT_DATE
Hi mate,
There's a 'Geoscience' plugin which has a function that allows you to
create a local grid from coordinates ?
Local XY, Grid XY...
Does that help?
Tim
On Mon, Jan 10, 2022 at 9:22 PM Grant Boxer wrote:
> Is there a plugin for QGIS that takes two pairs of coordinates, one in
> local (Ca
Hi guys,
About to host a PostGIS db on our server, and want users to connect to the
db in QGIS.
Is there a way I can push out a script (?) to all user's machines that sets
the connection to the postgis db for QGIS?
Rather than manually entering authentication on each machine?
I have one generic ro
Hi all,
I have an index of rasters.
I have added an action to the QGIS dataset which will open the raster
directly into QGIS.
The script I use is this:
from qgis.utils import iface
qgis.utils.iface.addRasterLayer('[% path %]')
index =
QgsProject.instance().mapLayersByName('Catalogue_Raster_Aeria
Hi all,
Was wondering if someone has a similar experience.
I'm testing storing raster data in my PostGIS db as an 'out-db' option.
It seems to work via the raster2pgsql command line.
The table is generated and I can see the table thru the QGIS browser/DB
Manager.
However, if I drag/drop onto the m
