Re: [Qgis-user] Selecting records

2016-03-29 Thread Phil Wyatt
Thanks Pierma, I can sort the dates no worries, so that should work. Many thanks. Cheers - Phil, On the road with his iPad > On 30 Mar 2016, at 3:58 PM, Pierre-Marie Le Dantec > wrote: > > Hi Phil, > > For manipulating dates throught SQL you should use ISO

Re: [Qgis-user] Selecting records

2016-03-29 Thread Pierre-Marie Le Dantec
Hi Phil, For manipulating dates throught SQL you should use ISO format ("-MM-DD"). Then, you can use a virtual layer with : SELECT stationid, MAX(obs_date) FROM your_layer GROUP BY stationid Cheers, Pierma 2016-03-30 13:09 GMT+11:00 Phil (The Geek) Wyatt : > I

[Qgis-user] vector shp from NAD83 (CSRS98) to UTM WGS84

2016-03-29 Thread Azzurra Lentini
Hallo to all, do you know how I can transform vectorial data from NAD83 (CSRS98) to UTM wgs84? do you think if I do with reproject it would be ok?? or what u suggest?? thanks a lot -- Dr. Hydrogeologist AZZURRA LENTINI Expert of evaluation environmental hazards GIS application Haity Mobile Tel:

[Qgis-user] Selecting records

2016-03-29 Thread Phil (The Geek) Wyatt
I must be thick, but I can't get my head around this in QGIS Data stationid_ obs_date BK21 28/03/2016 BK21 29/03/2016 BK21 30/03/2016 BL22 28/03/2016 BL22 29/03/2016 BL22 30/03/2016 BL22 31/03/2016 How do I select the Maximum date for each station ID? The

[Qgis-user] qgis essen + postgis / long project init times

2016-03-29 Thread Florian Lohoff
Hi, i am having a hard time optimizing the qgis project startup times. postgres 9.4.6-0+deb8u1 postgis 2.1.4+dfsg-3 qgis 1:2.14.0+13jessie Database Machine is a seperate machine with 24Gigabyte and 8 Cores and a 8 Disk Raid 10 and a Germany osm2pgsql import. When starting qgis on a client and

Re: [Qgis-user] Query in QGIS

2016-03-29 Thread Nicolas Cadieux
Hi, If you use you use the openlayer plugin, make sure "on the fly CRS" is activated as the plugin will change the project CRS without telling you (look at the CRS in the lower right corner). OSM layer is always a good place to start if you want to make sure the data is in the right spot.

Re: [Qgis-user] Query in QGIS

2016-03-29 Thread Joris Hintjens
IS there a reason why u use your own map background? WHy not ue an open source map (OSM plugin gives you several) greetings Joris > Op 29 mrt. 2016, om 17:10 heeft Carlos Cerdán het > volgende geschreven: > > Another thing to check: > > - Is your map file (jpg image)

Re: [Qgis-user] creating a python plugin to autopopulate some of the Georeferencer properties

2016-03-29 Thread Eric Goddard
Problem solved, triggering from the raster menu didn't work, but going through the raster toolbar did work. for action in iface.rasterToolBar().actions(): if action.objectName() == 'mActionRunGeoref': georef = action georef.trigger() On Mon, Mar 28, 2016 at 12:36 PM, Eric Goddard

[QGIS-it-user] QGIS 14.1 con GRASS 6.4?!?!

2016-03-29 Thread Andrea Gagna
Ciao a tutti, Qualche settimana fa da Osgeo4W avevo installato la nuova versione 14.0 LTR che conteneva il QGis 14.0 associato al GRASS 7... Ieri sera ho fatto l'aggiornamento alla 14.1 ma il GRASS associato torna a essere un 6.4 (o altro, comunque un 6..)... Che senso ha? La 14.1 e' comunque

Re: [Qgis-user] Query in QGIS

2016-03-29 Thread Carlos Cerdán
Another thing to check: - Is your map file (jpg image) georeferenced?. If not, use Raster --> Georeferencer --> Georeferencer to do it. You must select the same SRC that your points are. Good luck Carlos Cerdán 2016-03-29 7:41 GMT-05:00 Nicolas Cadieux : >

Re: [Qgis-user] Query in QGIS

2016-03-29 Thread Nicolas Cadieux
Hi, List of things to check: Are long/lat inverted? Is your other map in the same CRS? (Coordinate Reference system?) If not, it can be fixed by making sure you have "CRS on the fly reprojection" activated in the options. Also make sure that QGIS "ask" for new layers that have no CRS).

[Qgis-user] Query in QGIS

2016-03-29 Thread Manoj Soni
Dear Users Greetings !! I am new to QGIS ( Version 2.8) . I have a map file (jpg image) of a district I also have an excel file having latitude and longitude of 20 Hospitals in that district. So far i have converted that excel file in to tab limited file. Then i added one layer in QGIS

[Qgis-user] qgis menu processing is gone

2016-03-29 Thread Rico Pietzsch
Hello, i'am new with qgis and use the german version of qgis 2.14 so i hope to translate menu keywords correct. i was looking for an tool/script to align a new object on lines from an wms layer so i found an advice to use an script. I am not sure wich it was ... respectly wich one i got via

Re: [Qgis-user] Qgis-server WMS max zoom level

2016-03-29 Thread Francesco Marigliano
I'm generating WMS directly from the server as you can see there Front-office: http://sit.cellole.geourba.it Back-office: http://cellole.geourba.it Tile layer URL: http://cellole.geourba.it/cgi-bin/qgis_mapserv.fcgi?map=/maps/cellole.qgs Il 29/03/2016 10:30, Paolo Cavallini ha scritto: Il

Re: [Qgis-user] Qgis-server WMS max zoom level

2016-03-29 Thread Paolo Cavallini
Il 29/03/2016 10:27, Francesco Marigliano ha scritto: > Hi Paolo, > > I'm working on an architecture based on Qgis server using Qgis webclient > as backoffice and Leaflet.js as front office. > The tiles are the same but as I said before in Leaflet maps I'm not able > to see their for zoom higher

Re: [Qgis-user] Qgis-server WMS max zoom level

2016-03-29 Thread Francesco Marigliano
Hi Paolo, I'm working on an architecture based on Qgis server using Qgis webclient as backoffice and Leaflet.js as front office. The tiles are the same but as I said before in Leaflet maps I'm not able to see their for zoom higher than 18. Thanks for your answer. Il 29/03/2016 10:18, Paolo

Re: [Qgis-user] Qgis-server WMS max zoom level

2016-03-29 Thread Paolo Cavallini
Il 29/03/2016 09:55, Francesco Marigliano ha scritto: > I'm working on a small project based on Leaflet and Qgis Server WMS and > I notice that it's not possible to show tiles for zoom > 18 but using > WMS from other services (like GeoServer) it works. Hi Francesco, are you using QGIS directly

[Qgis-user] Qgis-server WMS max zoom level

2016-03-29 Thread Francesco Marigliano
Hi all, I'm working on a small project based on Leaflet and Qgis Server WMS and I notice that it's not possible to show tiles for zoom > 18 but using WMS from other services (like GeoServer) it works. Thanks in advantage, F. --- Questa e-mail è stata controllata per individuare virus con