Re: [GRASS-user] Migrating to new RDBMS

2018-10-30 Thread Rich Shepard
Running db.test also fails: db.test test=test1 Using DB driver: pg CREATE TABLE grass_test1 (i1 INTEGER, d1 DOUBLE PRECISION, c1 VARCHAR(20)) DBMI-PostgreSQL driver error: Connection failed. FATAL: database "willamette_river_hg" does not exist How do I find where grass is looking for the

Re: [GRASS-user] Migrating to new RDBMS

2018-10-30 Thread Rich Shepard
On Tue, 30 Oct 2018, Markus Metz wrote: db.connect only sets the default database, it does not test if it exists or is accessible. For PG, you need to use db.login first in order to actually use the PG database. Markus M, Sigh. Neither without or with a username it still fails: db.login

Re: [GRASS-user] Migrating to new RDBMS

2018-10-30 Thread Markus Metz
On Tue, Oct 30, 2018 at 10:37 PM Rich Shepard wrote: > > On Tue, 30 Oct 2018, Rich Shepard wrote: > > > I was thinking of working within grass rather than at the bash prompt. > > You're right: I know the difference between double and single quotes but > > blew it on this instance. > >I'm

Re: [GRASS-user] Migrating to new RDBMS

2018-10-30 Thread Rich Shepard
On Tue, 30 Oct 2018, Rich Shepard wrote: WARNING: Unable to open database by driver no database is open no database is open WARNING: Copy table failed Oops! I forgot to include this information: GRASS 7.7.svn (willamette_basin):~/data/grassdata/willamette_basin > db.connect -p driver:

Re: [GRASS-user] Migrating to new RDBMS

2018-10-30 Thread Rich Shepard
On Tue, 30 Oct 2018, Rich Shepard wrote: I was thinking of working within grass rather than at the bash prompt. You're right: I know the difference between double and single quotes but blew it on this instance. I'm still missing something. From the grass shell the command, db.connect

Re: [GRASS-user] Migrating to new RDBMS [RESOLVED]

2018-10-30 Thread Rich Shepard
On Tue, 30 Oct 2018, Markus Metz wrote: db.copy does not need db.connect. The reason for the error is that the variable $HOME is not expanded because it is within single quotes. Use double quotes instead of single quotes for the from_database argument and it should work. Markus, I was

Re: [GRASS-user] Migrating to new RDBMS

2018-10-30 Thread Markus Metz
On Tue, Oct 30, 2018 at 9:41 PM Rich Shepard wrote: > >I started grass7.7.svn (r73623) and set db.connect to use driver=pg and > database='willamette_river_hg'. Then I copied the vector files (g.copy > vect=current_file,current_file_pg) per the migration instructions on the > databaseintro

[GRASS-user] Migrating to new RDBMS

2018-10-30 Thread Rich Shepard
I started grass7.7.svn (r73623) and set db.connect to use driver=pg and database='willamette_river_hg'. Then I copied the vector files (g.copy vect=current_file,current_file_pg) per the migration instructions on the databaseintro manual page. Trying to run db.copy to add attribute tables to

Re: [GRASS-user] v.patch and keeping the attributes

2018-10-30 Thread Markus Metz
On Tue, Oct 30, 2018 at 9:13 PM Markus Neteler wrote: > > On Tue, Oct 30, 2018 at 5:36 PM Markus Neteler wrote: > > On Tue, Oct 30, 2018 at 10:26 AM Mira Kattwinkel: > > > > > > Thanks a lot! > > > > > > I just did not interpret the paragraph "When using the -a flag..." correctly. > > > > > >

Re: [GRASS-user] v.patch and keeping the attributes

2018-10-30 Thread Markus Neteler
On Tue, Oct 30, 2018 at 5:36 PM Markus Neteler wrote: > On Tue, Oct 30, 2018 at 10:26 AM Mira Kattwinkel: > > > > Thanks a lot! > > > > I just did not interpret the paragraph "When using the -a flag..." > > correctly. > > > > Maybe a note in the manual that v.patch takes care of the cats etc.

Re: [GRASS-user] v.patch and keeping the attributes

2018-10-30 Thread Markus Neteler
Hi Mira, On Tue, Oct 30, 2018 at 10:26 AM Mira Kattwinkel wrote: > > Thanks a lot! > > I just did not interpret the paragraph "When using the -a flag..." correctly. > > Maybe a note in the manual that v.patch takes care of the cats etc. would be > helpful. if you could send a (draft) text

Re: [GRASS-user] v.patch and keeping the attributes

2018-10-30 Thread Markus Metz
On Tue, Oct 30, 2018 at 2:21 PM Mira Kattwinkel < kattwinkel-m...@uni-landau.de> wrote: > > Dear Markus, > > I saw that you updated v.patch to ignore the order of columns some months ago. However, I updated my grass to version 7.4.2. (on Linux Mint 18) and still get "ERROR: Column names differ" >

Re: [GRASS-user] accent encoding with ps.map

2018-10-30 Thread Frank David
Le 30/10/2018 à 15:38, Rich Shepard a écrit : On Tue, 30 Oct 2018, Frank David wrote: I think some point are missing or lack of documentation. I think about [read] command, display layer order, language support, unit of position in the page (inch/cm), etc. Some improvement would be great,

Re: [GRASS-user] accent encoding with ps.map

2018-10-30 Thread Rich Shepard
On Tue, 30 Oct 2018, Frank David wrote: I think some point are missing or lack of documentation. I think about [read] command, display layer order, language support, unit of position in the page (inch/cm), etc. Some improvement would be great, like line thickness from column for example, accent

Re: [GRASS-user] v.patch and keeping the attributes

2018-10-30 Thread Mira Kattwinkel
Dear Markus, I saw that you updated v.patch to ignore the order of columns some months ago. However, I updated my grass to version 7.4.2. (on Linux Mint 18) and still get "ERROR: Column names differ" I am sure that they are the same, only the order is different. Do you have any suggestions?

Re: [GRASS-user] accent encoding with ps.map

2018-10-30 Thread Rich Shepard
On Tue, 30 Oct 2018, Frank David wrote: - map scale units, for example "kilomètre" is displayed "kilomÄ"tre". I dont'see how to solve that - for a selecting field in vector map, like [where myfield = "classé"] (does not work) while [where myfield = "classe"] (works if I change my "é" with "e"

Re: [GRASS-user] Drawing a vector line with bearing/distance

2018-10-30 Thread Laurent C.
Thank you Helmut. As I understand, m.cogo works only for geographical coordinates. Since I am using a projected location, I just calculated the new coordinates using basic trigonometry. It short distances, so I guess that is alright. Laurent Le mer. 17 oct. 2018 à 13:40, Helmut Kudrnovsky a

Re: [GRASS-user] zonal statistics for multiple areas

2018-10-30 Thread Alessandro Sebastiani
Thanks a lot for your help! Il giorno mar 30 ott 2018 alle ore 11:49 Nikos Alexandris < n...@nikosalexandris.net> ha scritto: > * Alessandro Sebastiani [2018-10-29 > 21:32:51 +0100]: > > >thank you all for your suggestions. > >Dear Nikos, I have some 0-1 rasters that represents presence-absence

Re: [GRASS-user] zonal statistics for multiple areas

2018-10-30 Thread Nikos Alexandris
* Alessandro Sebastiani [2018-10-29 21:32:51 +0100]: thank you all for your suggestions. Dear Nikos, I have some 0-1 rasters that represents presence-absence of different land covers. Each raster's resolution is 10x10m, thus i want to compute the sum in order to obtain the surface covered by

[GRASS-user] accent encoding with ps.map

2018-10-30 Thread Frank David
Hello all, I'm using ps.map and I notice that accent are not well supported in 3 cases : - map scale units, for example "kilomètre" is displayed "kilomÄ"tre". I dont'see how to solve that - for a selecting field in vector map, like [where myfield = "classé"] (does not work) while [where

Re: [GRASS-user] append data after a v.in.ascii import

2018-10-30 Thread Frank David
Le 28/10/2018 à 22:33, Markus Metz a écrit : On Sat, Oct 27, 2018 at 10:00 AM Frank David > wrote: > > > Le 26/10/2018 à 21:11, Markus Metz a écrit : > > > > On Fri, Oct 26, 2018 at 7:17 PM Frank David > wrote: > > > If you want

Re: [GRASS-user] v.patch and keeping the attributes

2018-10-30 Thread Mira Kattwinkel
Thanks a lot! I just did not interpret the paragraph  "When using the /-a/ flag..." correctly. Maybe a note in the manual that v.patch takes care of the cats etc. would be helpful. Mira On 29/10/18 20:35, Markus Metz wrote: On Mon, Oct 29, 2018 at 6:13 PM Mira Kattwinkel