[Qgis-user] Issue with temporal query in a symbology rule

2015-11-17 Thread Neumann, Andreas
Hi, For a project I have point data for events with a start_time and end_time, both columns are of type timestamp without timezone (in PostgreSQL). I want to have three different rules for events in the past, current events and future events. Past and future events work fine, but I am

Re: [Qgis-user] Issue with temporal query in a symbology rule

2015-11-17 Thread Neumann, Andreas
hm - I found out that my query start_time <= now() AND end_time >= now() works fine if start_time, now() and end_time are on three different dates, but it fails if all are on the same day. Very strange. Anyone knows what's wrong? Andreas On 2015-11-17 16:51, Neumann, Andreas wrote: >

Re: [Qgis-user] Load ESRI Personal Geodatabase in QGIS 2.8.1

2015-11-17 Thread Saber Razmjooei
Hi there, There is a work-around to load 32-bit gdb files with QGIS 64-bit. You need to install MS Office 64-bit patch for Access. Regards, Saber From: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of burghardt.scho...@stadt.wolfsburg.de Sent: 17 November 2015

[Qgis-user] Load ESRI Personal Geodatabase in QGIS 2.8.1

2015-11-17 Thread Burghardt.Scholle
Hi Ulrike, yes, it is possible to open a pGDB in QGIS. However, the versions of QGIS and MS Access must be the same: 32bit QGIS = 32bit Access vs. QGIS 64bit = 64bit MS Access. Greetings Burghardt Von: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] Im Auftrag von Ulrike Assmann

Re: [Qgis-user] Issue with temporal query in a symbology rule

2015-11-17 Thread Jürgen E . Fischer
Hi Andreas, On Tue, 17. Nov 2015 at 17:01:31 +0100, Neumann, Andreas wrote: > > hm - I found out that my query > > start_time <= now() AND end_time >= now() I'd do: now() BETWEEN start_time AND end_time > works fine if start_time, now() and end_time are on three different > dates, but it

Re: [Qgis-user] Issue with temporal query in a symbology rule

2015-11-17 Thread Neumann, Andreas
Hi Jürgen, Thanks for your reply. I know that it works well on PostgreSQL - but I am talking about symbology rules in QGIS. Can I use Postgis syntax in QGIS rules? The QGIS query builder doesn't list "BETWEEN" as an operator. Andreas On 2015-11-17 18:17, Jürgen E. Fischer wrote: > Hi

Re: [Qgis-user] Issue with temporal query in a symbology rule

2015-11-17 Thread Jürgen E . Fischer
Hi Andreas, On Tue, 17. Nov 2015 at 19:24:20 +0100, Neumann, Andreas wrote: > I know that it works well on PostgreSQL - but I am talking about > symbology rules in QGIS. Can I use Postgis syntax in QGIS rules? The > QGIS query builder doesn't list "BETWEEN" as an operator. Oh, I completely

Re: [Qgis-user] HHK Geograf in QGIS

2015-11-17 Thread ralfwessels
Hi Sebastian, it should be possible when you transform your date into dxf format, but then you may loose some attribute data. If there is a possibility to import the data direct to PostgreSQL/PostGIS, I would prefer this method. ralf -- View this message in context:

[Qgis-user] Load ESRI Personal Geodatabase in QGIS 2.8.1

2015-11-17 Thread Ulrike Assmann
Dear list, I have a problem with opening a ESRI Personal Geodatabase with Annotation Layers in QGIS 2.8.1. I have tried to open it as vector layer: o as "Datei/file" using "MDB" and also o as "Datenbank/database" using type "ESRI-Personal-GeoDatabase", Might I have chosen an

Re: [Qgis-user] Load ESRI Personal Geodatabase in QGIS 2.8.1

2015-11-17 Thread Ulrike Assmann
Hello Burghardt, Lewis and Randy, thank you so much for your helpful answers. I have to check it now. Ulrike Am 17 Nov 2015 um 12:19 hat burghardt.scho...@stadt.wolfsburg.de geschrieben: Hi Ulrike,   yes, it is possible to open a pGDB in QGIS. However, the versions of QGIS and MS

Re: [Qgis-user] GRASS7 Plugin for QGIS 2.12 on Ubuntu

2015-11-17 Thread Jürgen E . Fischer
Hi Micha, On Wed, 18. Nov 2015 at 09:08:50 +0200, Micha Silver wrote: >I'd also like to know how to get the GRASS plugin installed. Using the >ubuntugis-unstable repo on Mint 17. That depends on which distribution Mint 17 uses and if GRASS7 is available for it. In our ubuntugis

Re: [Qgis-user] GRASS7 Plugin for QGIS 2.12 on Ubuntu

2015-11-17 Thread Micha Silver
I'd also like to know how to get the GRASS plugin installed. Using the ubuntugis-unstable repo on Mint 17. And same question on OSGeo4W ... On 11/16/2015 02:22 PM, Johannes Radinger wrote: Hi, I was wondering how one