Re: [Qgis-user] Storing data to postgis from Qgis

2014-12-30 Thread Brent Wood
qgis-user@lists.osgeo.org Sent: Tuesday, December 30, 2014 6:10 PM Subject: Re: [Qgis-user] Storing data to postgis from Qgis Leknin,  Thanks for the reply. I've followed your recipe and indeed I can paste my selected features as a new memory layer (thanks Jan) and then import the layer via

Re: [Qgis-user] Storing data to postgis from Qgis

2014-12-30 Thread Jan Michálek
In db manager you can import data in new table or add features to an existing table. Or you can add empty column to a table, select in qgis desktop, open atribute table, display selected features on top and edit empty column by your atributes. 2014-12-30 6:10 GMT+01:00 David Kramer

Re: [Qgis-user] Storing data to postgis from Qgis

2014-12-30 Thread David Kramer
Hi Brent, Thanks for the reply. I'm doing this in QGIS because I have an old-school map that shows areas of interest that need to be somehow captured into the db. The example with the franchise and states was a simple illustration of the problem, not a specification of the actual problem :).

Re: [Qgis-user] Storing data to postgis from Qgis

2014-12-30 Thread David Kramer
On Tue, Dec 30, 2014 at 5:24 AM, Jan Michálek godzilalal...@gmail.com wrote: In db manager you can import data in new table or add features to an existing table. Or you can add empty column to a table, select in qgis desktop, open atribute table, display selected features on top and edit

Re: [Qgis-user] Storing data to postgis from Qgis

2014-12-30 Thread Junior Delaz
Hi, It's not (yet) possible to append data to an existing table through DBManager. i may not understand well your question but What about adding both source and destination tables and just select features, copy and paste them from the source table to the detination one? 2014-12-30 17:59 GMT+01:00

Re: [Qgis-user] Storing data to postgis from Qgis

2014-12-30 Thread David Kramer
Hi Junior, It's not as simple as copying data between two tables. If it were purely a relational db I wouldn't need QGIS, there's a GIS component. Based on a paper map I have to select a bunch of polygons (think states, regions, countries, whatever) and use the selection to add new rows to a db

Re: [Qgis-user] Storing data to postgis from Qgis

2014-12-29 Thread Leknín Řepánek
Edit copy features paste features as new layer import layer from db manager On Mon, Dec 29, 2014 at 11:09:12AM -0800, David Kramer wrote: noob question, apologies in advance I'm using Qgis as a front end to postgis. I can load layers from postgis and visualize them just fine in Qgis. I'd

Re: [Qgis-user] Storing data to postgis from Qgis

2014-12-29 Thread Jan Michálek
Use As new memory layer 2014-12-29 20:25 GMT+01:00 Leknín Řepánek godzilalal...@gmail.com: Edit copy features paste features as new layer import layer from db manager On Mon, Dec 29, 2014 at 11:09:12AM -0800, David Kramer wrote: noob question, apologies in advance I'm using Qgis as a

Re: [Qgis-user] Storing data to postgis from Qgis

2014-12-29 Thread David Kramer
Leknin, Thanks for the reply. I've followed your recipe and indeed I can paste my selected features as a new memory layer (thanks Jan) and then import the layer via db manager into postgis. This is tremendously useful, but is not quite what I'm looking for. I don't really want to create a new