Re: [Qgis-user] Backing up GIS Data

2016-07-15 Thread Ricardo Pinho
Hi, If you are using postgresql on ubuntu you can easily install: autopostgresqlbackup script that configures a cron job for you to automatically backup postgresql (daily, weekly, monthly). And you can easily configure by editing a file: /etc/default/autopostresqlbackup More details:

Re: [Qgis-user] Problems with ubuntu-unstable again

2016-07-15 Thread Jürgen E . Fischer
Hi Bernd, On Fri, 15. Jul 2016 at 18:36:06 +0200, Bernd Vogelgesang wrote: > Will the rebuilding be triggered automatically, or do I have to > "trigger" someone to have a look at it ? No, the dependencies are not actively tracked and therefore no automatic rebuilds are triggered. But the

Re: [Qgis-user] Define custom projections using a script

2016-07-15 Thread KOSZA Antal
2016. 07. 13, szerda keltezéssel 12.21-kor Tudorache, Marian ezt írta: >   > I am looking to a possible file in QGIS where those custom > projections are store so I can modify it using a python script. > Can someone tell me how and where those projections are stored in > QGIS? >   > Thanks, >

Re: [Qgis-user] Problems with ubuntu-unstable again

2016-07-15 Thread Bernd Vogelgesang
Hi Angelos, thanx for the information! Will the rebuilding be triggered automatically, or do I have to "trigger" someone to have a look at it ? Cheers Bernd Am 15.07.2016, 17:31 Uhr, schrieb Angelos Tzotsos : Hi Bernd, Yesterday, GDAL 2.1.0 landed on UbuntuGIS

Re: [Qgis-user] package dependency conflict QGIS 2.14.4

2016-07-15 Thread Carlos Cerdán
Used repositories, only: deb http://qgis.org/debian xenial main 2016-07-15 11:01 GMT-05:00 Carlos Cerdán : > > > >> Is there another workaround or is it necessary to change package >> dependencies in the build environment? >> > > > Sorry, I don't have another trick (limited

Re: [Qgis-user] package dependency conflict QGIS 2.14.4

2016-07-15 Thread Carlos Cerdán
> Is there another workaround or is it necessary to change package > dependencies in the build environment? > Sorry, I don't have another trick (limited linux knowledge) but What about to uninstall also these dependencies?. Perhaps you can get an empty "field" in order to "seed" QGIS If

Re: [Qgis-user] package dependency conflict QGIS 2.14.4

2016-07-15 Thread Otto Dassau
Hi, just got the hint from Angelos, that ubuntuGIS unstable yesterday got updated to GDAL 2.1.0 and GEOS 3.5.0, so a re-built of the packages in qgis.org should solve my problems. @Jürgen: Could you do that? Thanks, Otto Am Fri, 15 Jul 2016 16:38:35 +0200 schrieb Otto Dassau

Re: [Qgis-user] Problems with ubuntu-unstable again

2016-07-15 Thread Angelos Tzotsos
Hi Bernd, Yesterday, GDAL 2.1.0 landed on UbuntuGIS Unstable (Trusty), so packages on repositories depending on UbuntuGIS will need to be re-built. Best, Angelos On 07/15/2016 04:23 PM, Bernd Vogelgesang wrote: Hi, some days ago, I updated to 2.16 from the repositories. Everything worked

Re: [Qgis-user] package dependency conflict QGIS 2.14.4

2016-07-15 Thread Otto Dassau
Hi Carlos, thanks for your suggestion, but this doesn't seem to help, probably because qgis packages depend on libgeos-c1 and libgdal1h see http://qgis.org/ubuntugis-ltr/lists/qgis2_trusty_main_amd64_Packages and libgdal1h : Depends: libspatialite5 (>= 2.4.0) and libspatialite5 : Depends:

Re: [Qgis-user] Define custom projections using a script

2016-07-15 Thread Régis Haubourg
Hi, projections are stored in SQLite db's. Some python script will do the trick for sure. Régis Le 15 juil. 2016 4:02 PM, "Tudorache, Marian" a écrit : > Anybody could help me with this? > > > > Thanks, > > Marian > > > > *From:* Tudorache, Marian > *Sent:*

Re: [Qgis-user] Define custom projections using a script

2016-07-15 Thread Tudorache, Marian
Anybody could help me with this? Thanks, Marian From: Tudorache, Marian Sent: July-13-16 12:21 PM To: qgis-user@lists.osgeo.org Subject: Define custom projections using a script Hi everyone, I have a big list with custom projections that have to be added in QGIS. I know how to do this using

Re: [Qgis-user] package dependency conflict QGIS 2.14.4

2016-07-15 Thread Carlos Cerdán
Hi Otto: Try uninstalling all QGIS stuff, even GRASS. After that, clean your repositories and left just your prefered one; update and install again QGIS. That workaround was my salvation in similar cases (Ubuntu 1x.04 and QGIS 2.x). All the best Carlos 2016-07-15 8:27 GMT-05:00 Otto Dassau

Re: [Qgis-user] PostGIS Queries

2016-07-15 Thread James Keener
I would need double check if overlaps uses an index. If it does you can use explain to figure out which table is being fill y scanned and adjust the order in the statement accordingly. If it doesn't, then you can use something that does (e.g. &&) and ensure that the smaller table is the one

[Qgis-user] Problems with ubuntu-unstable again

2016-07-15 Thread Bernd Vogelgesang
Hi, some days ago, I updated to 2.16 from the repositories. Everything worked fine. Then yesterday, an update for saga came in. Checked today, saga is not working in the toolbox. Removing, reinstalling, fiddling, disabling/enabling ubuntu-unstable etc etc -> finally ending up again in a

Re: [Qgis-user] Backing up GIS Data

2016-07-15 Thread Micha Silver
Hi  -- Original Message -- Subject: Re: [Qgis-user] Backing up GIS Data Date: Fri, 15 Jul 2016 07:04:20 +0200 To: Qgis-user From: Bo Victor Thomsen As an old GIS database dog -

Re: [Qgis-user] package dependency conflict QGIS 2.14.4

2016-07-15 Thread Jürgen E . Fischer
Hi Otto, On Fri, 15. Jul 2016 at 15:09:29 +0200, Otto Dassau wrote: > trying to update QGIS packages (2.14.4) from ubuntgis-ltr repository on > ubuntu 14.04 gives a dependency conflict. Did you also add the ubuntugis repository? Jürgen -- Jürgen E. Fischer norBIT GmbH

[Qgis-user] package dependency conflict QGIS 2.14.4

2016-07-15 Thread Otto Dassau
Hi, trying to update QGIS packages (2.14.4) from ubuntgis-ltr repository on ubuntu 14.04 gives a dependency conflict. Do other people have the same problem? The following packages have unmet dependencies: libgeos-c1v5 : Breaks: libgeos-c1 (< 3.4.2-8~) but 3.4.2-4ubuntu1 is to be installed E:

Re: [Qgis-user] Importing CSV files

2016-07-15 Thread Phillip Money
Thanks Werner and Richard for your help so far. I will have to pursue this tomorrow as it is late here in Australia. I will respond tomorrow. Phillip From: werner.ma...@gmail.com Date: Fri, 15 Jul 2016 14:53:03 +0200 Subject: Re: [Qgis-user] Importing CSV files To: phillip.mo...@hotmail.com

Re: [Qgis-user] Importing CSV files

2016-07-15 Thread Werner Macho
Find attached the working csv and csvt file - And remember - this csv is now NOT to be loaded with delimited text but rather as a "normal" vector layer. regards Werner On Fri, Jul 15, 2016 at 2:26 PM, Phillip Money wrote: > Richard and Werner. > > I left the csvt

Re: [Qgis-user] Importing CSV files

2016-07-15 Thread Phillip Money
Richard and Werner. I left the csvt file as "String", "Integer", "Integer", "Integer". I converted the percentages to numbers. It still didn't work. At Richard's suggestion, I converted the csv file to a text file and it worked. I can't understand why it didn't work with a CSV file. I am using

Re: [Qgis-user] Importing CSV files

2016-07-15 Thread Werner Macho
Hi! As I wrote in my first guess - ""87%" is not an integer while "87" is. As long as you have the "%" sign after the digits it will not be read as integer. You can try to read it as String - and convert it afterwards - or you get rid of the "%" sign. Something like: Balranald (A);87;6;0 will

Re: [Qgis-user] Importing CSV files

2016-07-15 Thread Richard McDonnell
Phillip, I have copied out what you sent, paste it into notepad and saved it as a txt file. I then imported it into QGIS using Add delimited Text Layer, making sure to select *Custom delimiters*, and selecting*Semicolon*. One other thing I done was select *No geometry. *This has worked

Re: [Qgis-user] Importing CSV files

2016-07-15 Thread Richard McDonnell
Phillip, Can you supply a sample of the data, also what version are you running of QGIS. The other thing is are you using *Add delimited Text Layer* or are you just loading the CSV directly? Regards, Richard. On 15/07/2016 12:29, Phillip Money wrote: I have a CSV file with four columns. The

Re: [Qgis-user] Contour symbology

2016-07-15 Thread Lester Anderson
That worked perfectly! Many thanks Andreas On 15 July 2016 at 12:32, Neumann, Andreas wrote: > Hi Lester, > > How about just adding > > AND Elev != 0 > > to the rule? Perhaps the first part should be in parenthesis () > > Andreas > > On 2016-07-15 13:07, Lester Anderson

[Qgis-user] Importing CSV files

2016-07-15 Thread Phillip Money
I have a CSV file with four columns. The first column is text, and the succeeding columns are percentages. I have set up a csvt file with "String", "Integer", "Integer", "Integer" When I import the file into QGIS as a delimited text layer, QGIS strips out all the percentages. They come in as

Re: [Qgis-user] Contour symbology

2016-07-15 Thread Neumann, Andreas
Hi Lester, How about just adding AND Elev != 0 to the rule? Perhaps the first part should be in parenthesis () Andreas On 2016-07-15 13:07, Lester Anderson wrote: > Hello, > > I have a rule-based line symbology set up as below: > > "Elev" % 500 = 0 (thick lines - every 500m) >

[Qgis-user] Contour symbology

2016-07-15 Thread Lester Anderson
Hello, I have a rule-based line symbology set up as below: "Elev" % 500 = 0 (thick lines - every 500m) "Elev" % 500 <> 0 (thin lines - all other lines) Is there a quick way to not draw the 0 contour as it is not the same level of detail as the coastline. Basically do all contours except 0.

[Qgis-user] QGIS Sponsor Offer

2016-07-15 Thread Mats Elfström
Hi! I made this offer a couple of months ago, but it probably got buried in the thread because no one has responded. I still think it would be good for the QGIS community to get updated and working installation instructions for QGIS Server, and this is my contribution. Background To my knowledge,

Re: [Qgis-user] Metadata and databases; thanks RE: Backing up GIS Data

2016-07-15 Thread Paolo Cavallini
Il 15/07/2016 08:47, Falk Huettmann ha scritto: > While some QGIS users might still try to learn Danish terms (a peculiar > language that is just spoken by some > > ~60mio people or so; sorry to say it) I think you overestimated by a factor of 10: https://en.wikipedia.org/wiki/Danish_language

[Qgis-user] Metadata and databases; thanks RE: Backing up GIS Data

2016-07-15 Thread Falk Huettmann
Hi there, Thanks, I am fully with the notion of back-ups and data management, specifically, metadata (a topic we pushed for over a decade but it has no good uptake, still). While some QGIS users might still try to learn Danish terms (a peculiar language that is just spoken by some ~60mio