Brent,
I haven't designed the schema yet, so I haven't made any decisions as to
whether to use views, stored queries, tables etc. My question revolves
around adding and editing maps, not so much the design of the underlying
data storage. I absolutely do need to be able to create and edit visual
ma
t opening such views as
layers will automatically pick up any changes made which impact on the view
contents.
Cheers
Brent Wood
From: Jan Michálek
To: David Kramer
Cc: qgis-user
Sent: Wednesday, December 31, 2014 2:24 AM
Subject: Re: [Qgis-user] Storing data to postgis from Qgis
In
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 ta
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
On Tue, Dec 30, 2014 at 5:24 AM, Jan Michálek
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 empty column by
> your a
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 :).
Thx
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 :
> Leknin,
>
0, 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 db manager into postgis. This is tremendously
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 tab
Use "As new memory layer"
2014-12-29 20:25 GMT+01:00 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:
> >
> >
> > I'm using Qgis as a front end to postgis. I can load layers fro
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:
>
>
> 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 like to select some features from
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 like to select some features from
a layer and store the results back in a table in postgis. So for example I
would load a table of states, select several of them in Qgis using the
se
12 matches
Mail list logo