Re: [Qgis-user] Backing up GIS Data

[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:
http://www.ubuntugeek.com/autopostgresqlbackup-backup-your-postgresql-databases-dailyweekly-and-monthly.html

https://sourceforge.net/projects/autopgsqlbackup/
https://gist.github.com/matthewlehner/3091458

Cheers,
Ricardo Pinho
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

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

[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 nightlies are rebuilt with current dependencies whenever a commit
(backport) has happened in the meantime.  So you can resort to those for
"unstable" distributions (ie. distributions that have changed between
releases).

The next regular rebuild is on 29.7. for the 2.14.1 and 2.16.1 point releases.


Jürgen

-- 
Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Norden http://www.norbit.de
QGIS release manager (PSC)  GermanyIRC: jef on FreeNode 



pgpfqJnpbToo1.pgp
Description: PGP signature
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

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

[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,
> Marian
> 

They are stored on linux in ~/.qgis2/qgis.db, a sqlite 3 database. 
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

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

[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 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 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 situation with no working grass  
and saga in the toolbox.


Using Linux Mint 17

Anyone an idea how to solve this, or is it just again waiting till  
things get sorted out by itself in some weeks?


Cheers
Bernd







--
Bernd Vogelgesang
Siedlerstraße 2
91083 Baiersdorf/Igelsdorf
Tel: 09133-825374
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

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

[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 linux knowledge) but What
> about to uninstall also these dependencies?. Perhaps you can get an empty
> "field" in order to  "seed" QGIS
>
> If it's useful: I have Ubuntu 16.04 and QGIS 2.16: related libraries
> installed are libspatialte7 (depends libgeos-c1v5 >=3.4.2) . I don't have
> libgdalh, instead it, libgdali.
>
> Good luck
>
> Carlos
>
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

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

[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 it's useful: I have Ubuntu 16.04 and QGIS 2.16: related libraries
installed are libspatialte7 (depends libgeos-c1v5 >=3.4.2) . I don't have
libgdalh, instead it, libgdali.

Good luck

Carlos
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

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

[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 :

> 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: libgeos-c1v5
> 
> and this causes the dependency problem: libgeos-c1v5 breaks libgeos-c1 as
> the error message shows below. 
> 
> Is there another workaround or is it necessary to change package
> dependencies in the build environment?
> 
> Regards,
> Otto
> 
> Am Fri, 15 Jul 2016 08:52:23 -0500
> schrieb 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 :
> > 
> > > Hi Jürgen,
> > >
> > > yes, entry in /etc/apt/sources.list is
> > >
> > > deb http://qgis.org/ubuntugis-ltr trusty main
> > > deb http://ppa.launchpad.net/ubuntugis/ubuntugis-unstable/ubuntu trusty
> > > main
> > > [...]
> > >
> > > error message is:
> > >
> > > 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: Error, pkgProblemResolver::Resolve generated breaks,
> > > this may be caused by held packages.
> > >
> > > Is it because there are still dependencies building and not yet
> > > available?
> > >
> > > Regards,
> > > Otto
> > >
> > > Am Fri, 15 Jul 2016 15:19:08 +0200
> > > schrieb 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
> > > ___
> > > Qgis-user mailing list
> > > Qgis-user@lists.osgeo.org
> > > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> > > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

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

[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 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 situation with no working 
grass and saga in the toolbox.


Using Linux Mint 17

Anyone an idea how to solve this, or is it just again waiting till 
things get sorted out by itself in some weeks?


Cheers
Bernd




--
Angelos Tzotsos, PhD
OSGeo Charter Member
http://users.ntua.gr/tzotsos

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

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

[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: libgeos-c1v5

and this causes the dependency problem: libgeos-c1v5 breaks libgeos-c1 as
the error message shows below. 

Is there another workaround or is it necessary to change package
dependencies in the build environment?

Regards,
Otto

Am Fri, 15 Jul 2016 08:52:23 -0500
schrieb 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 :
> 
> > Hi Jürgen,
> >
> > yes, entry in /etc/apt/sources.list is
> >
> > deb http://qgis.org/ubuntugis-ltr trusty main
> > deb http://ppa.launchpad.net/ubuntugis/ubuntugis-unstable/ubuntu trusty
> > main
> > [...]
> >
> > error message is:
> >
> > 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: Error, pkgProblemResolver::Resolve generated breaks,
> > this may be caused by held packages.
> >
> > Is it because there are still dependencies building and not yet
> > available?
> >
> > Regards,
> > Otto
> >
> > Am Fri, 15 Jul 2016 15:19:08 +0200
> > schrieb 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
> > ___
> > Qgis-user mailing list
> > Qgis-user@lists.osgeo.org
> > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

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

[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:* 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 Custom CRS from Setting menu. However it would
> be a time consuming job to add them one by one but then I have to
> distribute them to around 50 computers.
>
> In time these projections will be updated with new parameter values. No
> need to explain how long job will be if this is done manually.
>
>
>
> 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,
>
> Marian
>
> --
> This electronic message, as well as any transmitted files included in the
> electronic message, may contain privileged or confidential information and
> is intended solely for the use of the individual(s) or entity to which it
> is addressed. If you have received this electronic message in error please
> notify the sender immediately and delete the electronic message. Any
> unauthorized copying, disclosure or distribution of the electronic message
> is strictly forbidden. NAV CANADA accepts no liability for any damage
> caused by any virus and/or other malicious code transmitted by this
> electronic communication.
>
> Le présent message électronique et tout fichier qui peut y être joint
> peuvent contenir des renseignements privilégiés ou confidentiels destinés à
> l’usage exclusif des personnes ou des organismes à qui ils s’adressent. Si
> vous avez reçu ce message électronique par erreur, veuillez en informer
> l’expéditeur immédiatement et supprimez le. Toute reproduction, divulgation
> ou distribution du présent message électronique est strictement interdite.
> NAV CANADA n’assume aucune responsabilité en cas de dommage causé par tout
> virus ou autre programme malveillant transmis par ce message électronique.
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

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

[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 Custom CRS from Setting menu. However it would be a 
time consuming job to add them one by one but then I have to distribute them to 
around 50 computers.
In time these projections will be updated with new parameter values. No need to 
explain how long job will be if this is done manually.

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,
Marian


This electronic message, as well as any transmitted files included in the 
electronic message, may contain privileged or confidential information and is 
intended solely for the use of the individual(s) or entity to which it is 
addressed. If you have received this electronic message in error please notify 
the sender immediately and delete the electronic message. Any unauthorized 
copying, disclosure or distribution of the electronic message is strictly 
forbidden. NAV CANADA accepts no liability for any damage caused by any virus 
and/or other malicious code transmitted by this electronic communication.

Le présent message électronique et tout fichier qui peut y être joint peuvent 
contenir des renseignements privilégiés ou confidentiels destinés à l’usage 
exclusif des personnes ou des organismes à qui ils s’adressent. Si vous avez 
reçu ce message électronique par erreur, veuillez en informer l’expéditeur 
immédiatement et supprimez le. Toute reproduction, divulgation ou distribution 
du présent message électronique est strictement interdite. NAV CANADA n’assume 
aucune responsabilité en cas de dommage causé par tout virus ou autre programme 
malveillant transmis par ce message électronique.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

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

[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 :

> Hi Jürgen,
>
> yes, entry in /etc/apt/sources.list is
>
> deb http://qgis.org/ubuntugis-ltr trusty main
> deb http://ppa.launchpad.net/ubuntugis/ubuntugis-unstable/ubuntu trusty
> main
> [...]
>
> error message is:
>
> 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: Error, pkgProblemResolver::Resolve generated breaks, this may
> be caused by held packages.
>
> Is it because there are still dependencies building and not yet available?
>
> Regards,
> Otto
>
> Am Fri, 15 Jul 2016 15:19:08 +0200
> schrieb 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
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] PostGIS Queries

[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 being scanned.

Jim

On July 15, 2016 9:15:55 AM EDT, Richard McDonnell  
wrote:
>Need a little help, this may not be the forum, but I thought I would 
>throw it out there!
>I am looking to minimise the search area in this query
>
>SELECT objectid
>FROM
>level_1_20151206 AS A, water_polygon AS Z
>WHERE
>(SELECT ST_Overlaps (A.the_geom, Z.geom));
>
>What I want to do is use the extent of A's geometry to limit the search
>
>for overlaps with Z if that makes sense!?
>These are both large National coverage datasets.
>Any help suggestions welcomed!!
>
>Regards,
>
>Richard.
>
>
>
>OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
>OPW - Looking to the future - Caring for the past
>
>***
>Email Disclaimer: http://www.opw.ie/en/disclaimer/
>
>___
>Qgis-user mailing list
>Qgis-user@lists.osgeo.org
>List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Problems with ubuntu-unstable again

[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 situation with no working grass and  
saga in the toolbox.


Using Linux Mint 17

Anyone an idea how to solve this, or is it just again waiting till things  
get sorted out by itself in some weeks?


Cheers
Bernd

--
Bernd Vogelgesang
Siedlerstraße 2
91083 Baiersdorf/Igelsdorf
Tel: 09133-825374
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Backing up GIS Data

[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 -
  
It's a wise and smart decision to use Postgres/PostGis for
  storing and using spatial data.

As for backup: Do *exactly* as Jeff writes :-). "Point in
  time" backups are nice, but not the best backup solution for
  Postgres databases. Jeff's solution is. 

  
  
  Regards
  
  Bo Victor Thomsen
  AestasGIS
  Denmark
   
  
  
  
  
  
  
  
  Den 14/07/16 kl. 21:26 skrev Jeff
McKenna:
  
  Hi Tyler, 

This is a good question, and an important one, and don't feel
bad about posting it here - likely we can all learn from this
discussion, as it definitely involves the whole QGIS community.


I have quite a lot of experience backing up databases,
especially PostgreSQL/PostGIS databases.  I can tell you that it
is for sure important to run "pg_dump" as a daily backup (in
addition to your whole server image/backup) - that pg_dump has
saved me and my clients hundreds of times, and it is very
portable and easy to access (as opposed to your whole
image/machine backup).  One very important point (that's I've
learned from experience) when using pg_dump is to *always* use
the custom binary/compressed output format (the "--format=c"
commandline switch for pg_dump).  I've had 


I have always used the default "plain" format for pg_dump backups.
When time comes to migrate data to a new installation, it allows me
to edit the SQL backup file: restore only some of the tables, change
owners, schema names, even change the database name. This is just a
minor convenience. Am I making a mistake? Should I move to the
binary format to insure reliability?   

Thanks

  terrible times with the other output format types,
especially when restoring a database from a Windows server to a
Linux server etc (with hardcoded paths inside the backup).  I
live by that format, swear by it, from experience, moving so
many client databases from one machine to another. 

Another mailing list to keep in mind is the PostGIS mailing
list, where these backup topics also pop up from time to time -
and discussions are more geo-related, so are very helpful, than
just the generic PostgreSQL mailing list. 

So, definitely implement an additional backup process using
pg_dump (you can experiment restoring it through the
"pg_restore" command), you won't regret the effort spent. 

Happy QGIS-ing, 

-jeff 


  
  
  
  
  
  ___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user


  
Micha Silver
Arava Drainage Authority
+972-523-665918
  

  

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

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

[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 Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
Software Engineer   D-26506 Norden http://www.norbit.de
QGIS release manager (PSC)  GermanyIRC: jef on FreeNode 



pgpko2DdR0fdU.pgp
Description: PGP signature
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] package dependency conflict QGIS 2.14.4

[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: Error, pkgProblemResolver::Resolve generated breaks, this may
be caused by held packages.

Regards,
Otto
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Importing CSV files

[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
CC: richard.mcdonn...@opw.ie; qgis-user@lists.osgeo.org

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.
regardsWerner
On Fri, Jul 15, 2016 at 2:26 PM, Phillip Money  
wrote:



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 QGIS Nodego. Thanks for your help, but 
I am still stumped about the csv file. 

Phillip


From: werner.ma...@gmail.com
Date: Fri, 15 Jul 2016 14:17:35 +0200
Subject: Re: [Qgis-user] Importing CSV files
To: richard.mcdonn...@opw.ie
CC: phillip.mo...@hotmail.com; qgis-user@lists.osgeo.org

Hi Richard,
Surely QGIS is able to import it - but you forgot about that sentence in his 
first post:"I have set up a csvt file with "String", "Integer", "Integer", 
"Integer" "

Using a csvt is sometimes very handy - but as already written "86%" is 
unfortunately no integer ;)
regardsWerner

On Fri, Jul 15, 2016 at 2:14 PM, Richard McDonnell  
wrote:

  

  
  
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 perfectly see attribute table below







I hope the above settings work, I am running QGIS 2.14 by the way,
shouldn't make a difference though.

Regards,



Richard.



On 15/07/2016 13:03, Phillip Money
  wrote:



  
Richard,

  


I am using Add delimited Text Layer. 



Here is a snippet of the data.



LGA_NAME;Non-Indigenous;Aboriginal;Torres Strait Islander

Albury (C);93%;2%;0%

Armidale Dumaresq (A);88%;6%;0%

Ashfield (A);93%;1%;0%

Auburn (C);93%;1%;0%

Ballina (A);93%;3%;0%

Balranald (A);87%;6%;0%

Bankstown (C);94%;1%;0%

Bathurst Regional (A);91%;4%;0%



I had the data separated by commas, but changed it to
semi-colons. Neither worked. I also change the date to numerical
format as in .93. That didn't work either. 

  
  

On 15 July 2016 at 22:00, Richard
  McDonnell 
  wrote:

  
 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 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 null values. I have tried a lot of
  things, but can't get past this.

  

  

  For example, I have tried converting the
  percentages to numbers and bringing them in that
  way; same thing happens.

  

  

  I would appreciate any help.

  

  

  Regards

  

  

  Phillip Money

  

  







  


  ___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
  

Re: [Qgis-user] Importing CSV files

[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 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 QGIS Nodego.
> Thanks for your help, but I am still stumped about the csv file.
>
> Phillip
>
>
> --
> From: werner.ma...@gmail.com
> Date: Fri, 15 Jul 2016 14:17:35 +0200
> Subject: Re: [Qgis-user] Importing CSV files
> To: richard.mcdonn...@opw.ie
> CC: phillip.mo...@hotmail.com; qgis-user@lists.osgeo.org
>
>
> Hi Richard,
>
> Surely QGIS is able to import it - but you forgot about that sentence in
> his first post:
> "I have set up a csvt file with "String", "Integer", "Integer", "Integer" "
>
> Using a csvt is sometimes very handy - but as already written "86%" is
> unfortunately no integer ;)
>
> regards
> Werner
>
>
> On Fri, Jul 15, 2016 at 2:14 PM, Richard McDonnell <
> richard.mcdonn...@opw.ie> wrote:
>
> 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 perfectly see attribute table below
>
>
>
> I hope the above settings work, I am running QGIS 2.14 by the way,
> shouldn't make a difference though.
> Regards,
>
> Richard.
>
> On 15/07/2016 13:03, Phillip Money wrote:
>
> Richard,
>
> I am using Add delimited Text Layer.
>
> Here is a snippet of the data.
>
> LGA_NAME;Non-Indigenous;Aboriginal;Torres Strait Islander
> Albury (C);93%;2%;0%
> Armidale Dumaresq (A);88%;6%;0%
> Ashfield (A);93%;1%;0%
> Auburn (C);93%;1%;0%
> Ballina (A);93%;3%;0%
> Balranald (A);87%;6%;0%
> Bankstown (C);94%;1%;0%
> Bathurst Regional (A);91%;4%;0%
>
> I had the data separated by commas, but changed it to semi-colons. Neither
> worked. I also change the date to numerical format as in .93. That didn't
> work either.
>
> On 15 July 2016 at 22:00, Richard McDonnell 
> wrote:
>
> 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 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 null values. I have tried a lot of things, but can't get past this.
>
>
> For example, I have tried converting the percentages to numbers and
> bringing them in that way; same thing happens.
>
>
> I would appreciate any help.
>
>
> Regards
>
>
> Phillip Money
>
>
>
>
> ___
> Qgis-user mailing listqgis-u...@lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
> --
> *Richard McDonnell*
> *GIS Specialist PgD GIS AssocSCSI*
> *OPW FRM Data Management*
> *52 Stephens Green, Dublin 2.*
> TEL: 01 6476543
> OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
> OPW - Looking to the future - Caring for the past
> 
> Email Disclaimer: http://www.opw.ie/en/disclaimer/
>
>
>
> --
> *Richard McDonnell*
> *GIS Specialist PgD GIS AssocSCSI*
> *OPW FRM Data Management*
> *52 Stephens Green, Dublin 2.*
> TEL: 01 6476543
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
>
LGA_NAME;Non-Indigenous;Aboriginal;Torres Strait Islander
Albury (C);93;2;0
Armidale Dumaresq (A);88;6;0
Ashfield (A);93;1;0
Auburn (C);93;1;0
Ballina (A);93;3;0
Balranald (A);87;6;0
Bankstown (C);94;1;0
Bathurst Regional (A);91;4;0


test.csvt
Description: Binary data
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Importing CSV files

[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 QGIS Nodego. Thanks for your help, but 
I am still stumped about the csv file. 

Phillip


From: werner.ma...@gmail.com
Date: Fri, 15 Jul 2016 14:17:35 +0200
Subject: Re: [Qgis-user] Importing CSV files
To: richard.mcdonn...@opw.ie
CC: phillip.mo...@hotmail.com; qgis-user@lists.osgeo.org

Hi Richard,
Surely QGIS is able to import it - but you forgot about that sentence in his 
first post:"I have set up a csvt file with "String", "Integer", "Integer", 
"Integer" "

Using a csvt is sometimes very handy - but as already written "86%" is 
unfortunately no integer ;)
regardsWerner

On Fri, Jul 15, 2016 at 2:14 PM, Richard McDonnell  
wrote:

  

  
  
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 perfectly see attribute table below







I hope the above settings work, I am running QGIS 2.14 by the way,
shouldn't make a difference though.

Regards,



Richard.



On 15/07/2016 13:03, Phillip Money
  wrote:



  
Richard,

  


I am using Add delimited Text Layer. 



Here is a snippet of the data.



LGA_NAME;Non-Indigenous;Aboriginal;Torres Strait Islander

Albury (C);93%;2%;0%

Armidale Dumaresq (A);88%;6%;0%

Ashfield (A);93%;1%;0%

Auburn (C);93%;1%;0%

Ballina (A);93%;3%;0%

Balranald (A);87%;6%;0%

Bankstown (C);94%;1%;0%

Bathurst Regional (A);91%;4%;0%



I had the data separated by commas, but changed it to
semi-colons. Neither worked. I also change the date to numerical
format as in .93. That didn't work either. 

  
  

On 15 July 2016 at 22:00, Richard
  McDonnell 
  wrote:

  
 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 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 null values. I have tried a lot of
  things, but can't get past this.

  

  

  For example, I have tried converting the
  percentages to numbers and bringing them in that
  way; same thing happens.

  

  

  I would appreciate any help.

  

  

  Regards

  

  

  Phillip Money

  

  







  


  ___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

   

  -- 

Richard McDonnell

GIS Specialist PgD GIS
AssocSCSI

OPW FRM Data Management

52 Stephens Green, Dublin 2.

TEL: 01 6476543
  
OPW - Ag féachaint don am atá le teacht - Ag caomhnú
ón am atá thart

OPW - Looking to the future - Caring for the past



Email Disclaimer: http://www.opw.ie/en/disclaimer/
 

Re: [Qgis-user] Importing CSV files

[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 surely be read like you want it.

regards
Werner

On Fri, Jul 15, 2016 at 2:03 PM, Phillip Money
 wrote:
> Here is the sample.
>
> LGA_NAME;Non-Indigenous;Aboriginal;Torres Strait Islander
> Albury (C);93%;2%;0%
> Armidale Dumaresq (A);88%;6%;0%
> Ashfield (A);93%;1%;0%
> Auburn (C);93%;1%;0%
> Ballina (A);93%;3%;0%
> Balranald (A);87%;6%;0%
> Bankstown (C);94%;1%;0%
> Bathurst Regional (A);91%;4%;0%
>
> I had the data separated by commas, but changed it to semi-colons. Neither
> worked. I also change the date to numerical format as in .93. That didn't
> work either.
>
> On 15 July 2016 at 21:56, Werner Macho  wrote:
>>
>> Hi!
>>
>> Can you give a sample of the csv file?
>> For example if there is 40% inside the column it can't be a integer ..
>>
>> Would be good to have a look how the data looks like.
>>
>> regards
>> Werner
>>
>> On Fri, Jul 15, 2016 at 1:29 PM, Phillip Money
>>  wrote:
>> > 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
>> > null values. I have tried a lot of things, but can't get past this.
>> >
>> >
>> > For example, I have tried converting the percentages to numbers and
>> > bringing
>> > them in that way; same thing happens.
>> >
>> >
>> > I would appreciate any help.
>> >
>> >
>> > Regards
>> >
>> >
>> > Phillip Money
>> >
>> >
>> >
>> > ___
>> > Qgis-user mailing list
>> > Qgis-user@lists.osgeo.org
>> > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>> > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Importing CSV files

[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 perfectly see attribute table below



I hope the above settings work, I am running QGIS 2.14 by the way, 
shouldn't make a difference though.

Regards,

Richard.

On 15/07/2016 13:03, Phillip Money wrote:

Richard,

I am using Add delimited Text Layer.

Here is a snippet of the data.

LGA_NAME;Non-Indigenous;Aboriginal;Torres Strait Islander
Albury (C);93%;2%;0%
Armidale Dumaresq (A);88%;6%;0%
Ashfield (A);93%;1%;0%
Auburn (C);93%;1%;0%
Ballina (A);93%;3%;0%
Balranald (A);87%;6%;0%
Bankstown (C);94%;1%;0%
Bathurst Regional (A);91%;4%;0%

I had the data separated by commas, but changed it to semi-colons. 
Neither worked. I also change the date to numerical format as in .93. 
That didn't work either.


On 15 July 2016 at 22:00, Richard McDonnell > wrote:


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 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 null values. I have tried a lot
of things, but can't get past this.


For example, I have tried converting the percentages to numbers
and bringing them in that way; same thing happens.


I would appreciate any help.


Regards


Phillip Money




___
Qgis-user mailing list
Qgis-user@lists.osgeo.org 
List info:http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe:http://lists.osgeo.org/mailman/listinfo/qgis-user


-- 
*_Richard McDonnell_*

*GIS Specialist PgD GIS AssocSCSI*
*OPW FRM Data Management*
*52 Stephens Green, Dublin 2.*
TEL: 01 6476543
OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
OPW - Looking to the future - Caring for the past

Email Disclaimer: http://www.opw.ie/en/disclaimer/




--
*_Richard McDonnell_*
*GIS Specialist PgD GIS AssocSCSI*
*OPW FRM Data Management*
*52 Stephens Green, Dublin 2.*
TEL: 01 6476543

OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
OPW - Looking to the future - Caring for the past

***
Email Disclaimer: http://www.opw.ie/en/disclaimer/

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Importing CSV files

[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 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 null values. I have tried a lot of things, but can't 
get past this.



For example, I have tried converting the percentages to numbers and 
bringing them in that way; same thing happens.



I would appreciate any help.


Regards


Phillip Money




___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user


--
*_Richard McDonnell_*
*GIS Specialist PgD GIS AssocSCSI*
*OPW FRM Data Management*
*52 Stephens Green, Dublin 2.*
TEL: 01 6476543

OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
OPW - Looking to the future - Caring for the past

***
Email Disclaimer: http://www.opw.ie/en/disclaimer/

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Contour symbology

[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 wrote:
>
> 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.
>
> Thanks
> Lester
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
>
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Importing CSV files

[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 null values. I have 
tried a lot of things, but can't get past this.




For example, I have tried converting the percentages to numbers and bringing 
them in that way; same thing happens.


I would appreciate any help.


Regards


Phillip Money


  ___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Contour symbology

[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)
> "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.
> 
> Thanks
> Lester
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

  ___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Contour symbology

[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.

Thanks
Lester
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] QGIS Sponsor Offer

[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, there is no current, official and validated installation
and configuration manual for QGIS server on Windows 2012 server.

Offer of sponsoring.
I hereby offer unlimited admin access to a Windows 2012 R2 server in the
cloud, to install QGIS and QGIS Server, configure it and publish one QGIS
project, and document and publish reproduceable step by step-instructions
for this platform.
Admin access will be granted for a reasonable time, to anyone in the QGIS
community who wants to do this, and has sufficient QGIS and Windows
experience. I will decide who gets access, and will monitor and follow up
on the process.
The resulting documentation will of course be offered as part of the QGIS
Server manual.
The candidate may select which web server to use, even if I would prefer
IIS.
The candidate may also select the kind of data source for the published WMS
service.
I will provide one vanilla Windows 2012 server cloud machine for a
reasonable period of time.

Regards, Mats.E
-- 


*GisKraft*, GIS och webbkonsult
Mats Elfström, Väpplingvägen 21, SE-227 38 LUND, Sweden
tel: +46 70 595 39 35 / web: www.giskraft.com
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

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

[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
All the best.

-- 
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

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

[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 people or so; sorry to say it), I sincerely hope the next version of
QGIS is in Chinese instead, and thus serves many billions. OpenSource is
well served then. The EU-centrism ain’t so funny, in GIS, R and beyond.



Equally serious, I do not believe that QGIS, overall, is so powerful on the
actual database side of things.

If possible here, I would highly appreciate to learn specific and powerful
links on HOW QGIS relates and works with databases, and what the underlying
concept, idea and visions are ?

Thanks in advance for that.



In addition, in case you know of latest ISO metadata (XML I assume; I see
virus filter issues in that) approaches to QGIS and tabs and packages I
would die for learning about it for sure, too.

It’s so much needed.



Envision Chinese GIS data all available and documented with metadata open
source for everybody to use…

why not ?



Thanks in advance; very best regards

   Falk Huettmann



Falk Huettmann PhD, Associate Professor

-EWHALE lab- Biology and Wildlife Dept., Institute of Arctic Biology

419 IRVING I, University of Alaska Fairbanks AK 99775-7000 USA

Email fhuettm...@alaska.edu  Phone 907 474 7882 Fax 907 474 6716





*From:* Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] *On Behalf Of *Bo
Victor Thomsen
*Sent:* Thursday, July 14, 2016 9:04 PM
*To:* qgis-user@lists.osgeo.org
*Subject:* Re: [Qgis-user] Backing up GIS Data



As an old GIS database dog -

   - It's a wise and smart decision to use Postgres/PostGis for storing and
   using spatial data.
   - As for backup: Do *exactly* as Jeff writes :-). "Point in time"
   backups are nice, but not the best backup solution for Postgres databases.
   Jeff's solution is.


Regards

Bo Victor Thomsen
AestasGIS
Denmark










Den 14/07/16 kl. 21:26 skrev Jeff McKenna:

Hi Tyler,

This is a good question, and an important one, and don't feel bad about
posting it here - likely we can all learn from this discussion, as it
definitely involves the whole QGIS community.

I have quite a lot of experience backing up databases, especially
PostgreSQL/PostGIS databases.  I can tell you that it is for sure important
to run "pg_dump" as a daily backup (in addition to your whole server
image/backup) - that pg_dump has saved me and my clients hundreds of times,
and it is very portable and easy to access (as opposed to your whole
image/machine backup).  One very important point (that's I've learned from
experience) when using pg_dump is to *always* use the custom
binary/compressed output format (the "--format=c" commandline switch for
pg_dump).  I've had terrible times with the other output format types,
especially when restoring a database from a Windows server to a Linux
server etc (with hardcoded paths inside the backup).  I live by that
format, swear by it, from experience, moving so many client databases from
one machine to another.

Another mailing list to keep in mind is the PostGIS mailing list, where
these backup topics also pop up from time to time - and discussions are
more geo-related, so are very helpful, than just the generic PostgreSQL
mailing list.

So, definitely implement an additional backup process using pg_dump (you
can experiment restoring it through the "pg_restore" command), you won't
regret the effort spent.

Happy QGIS-ing,

-jeff
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user