Re: [Qgis-user] Options when loading layers into PostGIS with DBManager

2020-04-20 Thread Michael Dufty 
Thanks Bo,
What are the risks of DB Manager?  I’m using it exactly because it is point and 
click, the layers to be loaded are saved all over the place and need to be 
found and identified one by one in QGIS projects, so seems much easier to do 
from within qgis if it is reasonably safe.  I figure they can always be 
reloaded from the original source if something goes wrong.

Michael Dufty
Senior Environmental Engineer

[cid:image001.jpg@01D61741.BF897CA0]
MBS ENVIRONMENTAL
4 Cook Street, West Perth  WA 6005

t:+61 8 9226-3166
f:+61 8 9226-3177

e:   mdu...@mbsenvironmental.com.au
w:   www.mbsenvironmental.com.auhttp://www.mbsenvironmental.com.au/>
Disclaimer:
The information contained in this message is intended for those to whom it is 
addressed. It may contain confidential or privileged information and if you are 
not the intended recipient, you must not copy, distribute or take any action in 
reliance on it. If you received this message in error please destroy it and 
reply to the sender immediately or contact Martinick Bosch Sell Pty Ltd. on +61 
8 9226 3166 immediately. All care has been taken to ensure that this message 
and any attachments are virus free; we do not accept responsibility for any 
virus infections caused by receipt of this message

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

Re: [Qgis-user] Options when loading layers into PostGIS with DBManager

2020-04-20 Thread Paolo Cavallini 
Hi Michael,
it should "just work" with all the defaults, as you mention. Exceptions
are the id issue you noticed and the SINGLE/MULTI option: usually you
want SINGLE for points.
Cheers.

Il 19/04/20 17:05, Michael Dufty ha scritto:
> Answering my own question again.
> 
> It does look like leaving everything alone works pretty well.
> 
> Primary key unchecked results in a primary key being set up with the id
> column as shown in grey.  This caused a problem when the layer had a
> pre-existing non-unique id column.  Works fine if the existing id column
> has unique values, or does not exist.
> 
> Leaving the geometry column unticked seems to create a geom column (as
> shown in grey).
> 
> If a spatial index is needed and wasn’t ticked, a warning will show in
> db manager afterwards and it is easy to create one from there.
> 
>  
> 
> Just needs the documentation update to say not to worry about it.  A bit
> like the lack of documentation on how to upgrade an existing install. 
> It doesn’t seem to matter what you do, but you can waste a lot of time
> trying to look it up if too cautious.
> 
>  
> 
> *Michael Dufty*
> 
> *Senior Environmental Engineer*
> 
>  
> 
>   
> 
> *MBS ENVIRONMENTAL**
> *4 Cook Street, West Perth  WA 6005

> t:+61 8 9226-3166
> f:+61 8 9226-3177
> 
>  
> 
> e:   mdu...@mbsenvironmental.com.au <mailto:mdu...@mbsenvironmental.com.au>
> w:   www.mbsenvironmental.com.au
> http://www.mbsenvironmental.com.au/>
> 
> Disclaimer: 
> The information contained in this message is intended for those to whom
> it is addressed. It may contain confidential or privileged information
> and if you are not the intended recipient, you must not copy, distribute
> or take any action in reliance on it. If you received this message in
> error please destroy it and reply to the sender immediately or contact
> Martinick Bosch Sell Pty Ltd. on +61 8 9226 3166 immediately. All care
> has been taken to ensure that this message and any attachments are virus
> free; we do not accept responsibility for any virus infections caused by
> receipt of this message//
> 
>  
> 
> *From:*Michael Dufty 
> *Sent:* Sunday, 19 April 2020 4:43 PM
> *To:* qgis-user@lists.osgeo.org
> *Subject:* [Qgis-user] Options when loading layers into PostGIS with
> DBManager
> 
>  
> 
> Hi,
> 
> I am trying out saving data in PostGIS, and have got stuck on the upload
> “import layer/file” dialog in DB Manager.
> 
>  
> 
> Can anyone recommend a good reference on what options should be selected?
> 
> It seems to fall into a gap between PostGIS documentation and QGIS
> documentation and I can’t find any information on what should be
> selected in what circumstances.
> 
>  
> 
> In particular
> 
> Primary key – should this be ticked and the existing id field selected?
> What happens if it is left unticked?
> 
> Geometry column – is this needed? Objects still seem to have geometry if
> it is left out.
> 
> Create spatial index – this sounds like a good idea, but the one youtube
> tutorial I found (Klas Karlson) he left it unticked and said the layer
> already had everything.  Is it needed for some source formats and not
> others eg shapefile vs geopackage?
> 
>  
> 
> Convert field names to lower case doesn’t sound very useful, but I
> presume it is there for a reason, does anyone know the circumstances
> that would be needed?
> 
>  
> 
> Cheers,
> 
>  
> 
>  
> 
> *Michael Dufty*
> 
> *Senior Environmental Engineer*
> 
>  
> 
>   
> 
> *MBS ENVIRONMENTAL**
> *4 Cook Street, West Perth  WA 6005

> t:+61 8 9226-3166
> f:+61 8 9226-3177
> 
>  
> 
> e:   mdu...@mbsenvironmental.com.au <mailto:mdu...@mbsenvironmental.com.au>
> w:   www.mbsenvironmental.com.au
> http://www.mbsenvironmental.com.au/>
> 
> Disclaimer: 
> The information contained in this message is intended for those to whom
> it is addressed. It may contain confidential or privileged information
> and if you are not the intended recipient, you must not copy, distribute
> or take any action in reliance on it. If you received this message in
> error please destroy it and reply to the sender immediately or contact
> Martinick Bosch Sell Pty Ltd. on +61 8 9226 3166 immediately. All care
> has been taken to ensure that this message and any attachments are virus
> free; we do not accept responsibility for any virus infections caused by
> receipt of this message//
> 
>  
> 
> 
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> 

-- 
Paolo Cavallini - QGIS.ORG Chair
www.faunalia.eu:
training, support, development on QGIS, PostGIS and more
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Options when loading layers into PostGIS with DBManager

2020-04-20 Thread Paolo Cavallini 
Another easy option is to use Processing, with its batch capabilities.
Cheers.

Il 19/04/20 18:08, Bo Victor Thomsen ha scritto:
> Hi Michael -
> 
> 
> All your questions are pertinent and needs to be redressed.
> 
> 
> However one small personal nitpick: If I had a task involving importing
> 200 or more  layers into Postgres from some other data-source I would
> never use DBManager import with it's manual point-and-click. That's
> simply to risky
> 
> 
> I would use a command-line tool OGR2OGR, which is  included in the QGIS
> installation: https://gdal.org/drivers/vector/pg.html. It can be started
> using the shortcut "OSGeo4W Shell" placed in the same program group as QGIS.
> 
> 
> 
> -- 
> Med venlig hilsen / Kind regards
> 
> Bo Victor Thomsen
> 
> 
> Den 19-04-2020 kl. 16:35 skrev Michael Dufty:
>> Thanks Jorge,
>> The DB manager also 'just works' apparently regardless of which boxed
>> I tick.  I'd just like to know what is going on or if I'm setting
>> myself up for a problem later on if I load up 200 layers with the
>> wrong boxes ticked.
>>
>> Looking more closely, it has got text greyed out if you don't check a
>> box, which may mean it is setting it to the defaults shown, and you
>> only check the box if you want to change it.
>>
>> It would be nice to know more rather than guessing.
>>
>> ----------------
>> *From:* Jorge Gustavo Rocha 
>> *Sent:* Sunday, 19 April 2020 5:41 PM
>> *To:* qgis-user@lists.osgeo.org 
>> *Subject:* Re: [Qgis-user] Options when loading layers into PostGIS
>> with DBManager
>>  
>>
>> Hi Michael,
>>
>> An alternative is to use the "Browser panel". I use it to drag layers
>> from the Layer panel into Postgresql. You don't have to choose any
>> parameters. It just works.
>>
>> Regards,
>>
>> Jorge Gustavo
>>
>> On 19/04/20 09:42, Michael Dufty wrote:
>>>
>>> Hi,
>>>
>>> I am trying out saving data in PostGIS, and have got stuck on the
>>> upload “import layer/file” dialog in DB Manager.
>>>
>>>  
>>>
>>> Can anyone recommend a good reference on what options should be selected?
>>>
>>> It seems to fall into a gap between PostGIS documentation and QGIS
>>> documentation and I can’t find any information on what should be
>>> selected in what circumstances.
>>>
>>>  
>>>
>>> In particular
>>>
>>> Primary key – should this be ticked and the existing id field
>>> selected? What happens if it is left unticked?
>>>
>>> Geometry column – is this needed? Objects still seem to have geometry
>>> if it is left out.
>>>
>>> Create spatial index – this sounds like a good idea, but the one
>>> youtube tutorial I found (Klas Karlson) he left it unticked and said
>>> the layer already had everything.  Is it needed for some source
>>> formats and not others eg shapefile vs geopackage?
>>>
>>>  
>>>
>>> Convert field names to lower case doesn’t sound very useful, but I
>>> presume it is there for a reason, does anyone know the circumstances
>>> that would be needed?
>>>
>>>  
>>>
>>> Cheers,
>>>
>>>  
>>>
>>>  
>>>
>>> *Michael Dufty*
>>>
>>> *Senior Environmental Engineer*
>>>
>>>  
>>>
>>> 
>>>
>>> *MBS ENVIRONMENTAL**
>>> *4 Cook Street, West Perth  WA 6005

>>> t:+61 8 9226-3166
>>> f:+61 8 9226-3177
>>>
>>>  
>>>
>>> e:   mdu...@mbsenvironmental.com.au
>>> <mailto:mdu...@mbsenvironmental.com.au>
>>> w:   www.mbsenvironmental.com.au
>>>
>>> Disclaimer: 
>>> The information contained in this message is intended for those to
>>> whom it is addressed. It may contain confidential or privileged
>>> information and if you are not the intended recipient, you must not
>>> copy, distribute or take any action in reliance on it. If you
>>> received this message in error please destroy it and reply to the
>>> sender immediately or contact Martinick Bosch Sell Pty Ltd. on +61 8
>>> 9226 3166 immediately. All care has been taken to ensure that this
>>> message and any attachments are virus free; we do not accept
>>> responsibility for any virus infections caused by receipt of this
>>> message//
>

Re: [Qgis-user] Options when loading layers into PostGIS with DBManager

2020-04-19 Thread Bo Victor Thomsen 

Hi Michael -


All your questions are pertinent and needs to be redressed.


However one small personal nitpick: If I had a task involving importing 
200 or more  layers into Postgres from some other data-source I would 
never use DBManager import with it's manual point-and-click. That's 
simply to risky



I would use a command-line tool OGR2OGR, which is  included in the QGIS 
installation: https://gdal.org/drivers/vector/pg.html. It can be started 
using the shortcut "OSGeo4W Shell" placed in the same program group as QGIS.




--
Med venlig hilsen / Kind regards

Bo Victor Thomsen


Den 19-04-2020 kl. 16:35 skrev Michael Dufty:

Thanks Jorge,
The DB manager also 'just works' apparently regardless of which boxed 
I tick.  I'd just like to know what is going on or if I'm setting 
myself up for a problem later on if I load up 200 layers with the 
wrong boxes ticked.


Looking more closely, it has got text greyed out if you don't check a 
box, which may mean it is setting it to the defaults shown, and you 
only check the box if you want to change it.


It would be nice to know more rather than guessing.


*From:* Jorge Gustavo Rocha 
*Sent:* Sunday, 19 April 2020 5:41 PM
*To:* qgis-user@lists.osgeo.org 
*Subject:* Re: [Qgis-user] Options when loading layers into PostGIS 
with DBManager


Hi Michael,

An alternative is to use the "Browser panel". I use it to drag layers 
from the Layer panel into Postgresql. You don't have to choose any 
parameters. It just works.


Regards,

Jorge Gustavo

On 19/04/20 09:42, Michael Dufty wrote:


Hi,

I am trying out saving data in PostGIS, and have got stuck on the 
upload “import layer/file” dialog in DB Manager.


Can anyone recommend a good reference on what options should be selected?

It seems to fall into a gap between PostGIS documentation and QGIS 
documentation and I can’t find any information on what should be 
selected in what circumstances.


In particular

Primary key – should this be ticked and the existing id field 
selected? What happens if it is left unticked?


Geometry column – is this needed? Objects still seem to have geometry 
if it is left out.


Create spatial index – this sounds like a good idea, but the one 
youtube tutorial I found (Klas Karlson) he left it unticked and said 
the layer already had everything. Is it needed for some source 
formats and not others eg shapefile vs geopackage?


Convert field names to lower case doesn’t sound very useful, but I 
presume it is there for a reason, does anyone know the circumstances 
that would be needed?


Cheers,

*Michael Dufty*

*Senior Environmental Engineer*



*MBS ENVIRONMENTAL**
*4 Cook Street, West Perth  WA 6005

t:+61 8 9226-3166
f:+61 8 9226-3177

e: mdu...@mbsenvironmental.com.au 
<mailto:mdu...@mbsenvironmental.com.au>

w: www.mbsenvironmental.com.au

Disclaimer:
The information contained in this message is intended for those to 
whom it is addressed. It may contain confidential or privileged 
information and if you are not the intended recipient, you must not 
copy, distribute or take any action in reliance on it. If you 
received this message in error please destroy it and reply to the 
sender immediately or contact Martinick Bosch Sell Pty Ltd. on +61 8 
9226 3166 immediately. All care has been taken to ensure that this 
message and any attachments are virus free; we do not accept 
responsibility for any virus infections caused by receipt of this 
message//



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org  <mailto:Qgis-user@lists.osgeo.org>
List info:https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe:https://lists.osgeo.org/mailman/listinfo/qgis-user

--
Logo <https://www.geomaster.pt>   
*Geomaster*
*Jorge Gustavo Rocha* | Software Engineer
*e:*j...@geomaster.pt <mailto:j...@geomaster.pt> | *m:*+351 910 333 888
*g:*41.54094,-8.40490 | *v: *510 906 109
*a: *Rua António Cândido Pinto, 67, 4715-400 Braga


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


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

Re: [Qgis-user] Options when loading layers into PostGIS with DBManager

2020-04-19 Thread Michael Dufty 
Answering my own question again.
It does look like leaving everything alone works pretty well.
Primary key unchecked results in a primary key being set up with the id column 
as shown in grey.  This caused a problem when the layer had a pre-existing 
non-unique id column.  Works fine if the existing id column has unique values, 
or does not exist.
Leaving the geometry column unticked seems to create a geom column (as shown in 
grey).
If a spatial index is needed and wasn’t ticked, a warning will show in db 
manager afterwards and it is easy to create one from there.

Just needs the documentation update to say not to worry about it.  A bit like 
the lack of documentation on how to upgrade an existing install.  It doesn’t 
seem to matter what you do, but you can waste a lot of time trying to look it 
up if too cautious.

Michael Dufty
Senior Environmental Engineer

[cid:image001.jpg@01D6169E.C91D6900]
MBS ENVIRONMENTAL
4 Cook Street, West Perth  WA 6005

t:+61 8 9226-3166
f:+61 8 9226-3177

e:   mdu...@mbsenvironmental.com.au<mailto:mdu...@mbsenvironmental.com.au>
w:   www.mbsenvironmental.com.auhttp://www.mbsenvironmental.com.au/>
Disclaimer:
The information contained in this message is intended for those to whom it is 
addressed. It may contain confidential or privileged information and if you are 
not the intended recipient, you must not copy, distribute or take any action in 
reliance on it. If you received this message in error please destroy it and 
reply to the sender immediately or contact Martinick Bosch Sell Pty Ltd. on +61 
8 9226 3166 immediately. All care has been taken to ensure that this message 
and any attachments are virus free; we do not accept responsibility for any 
virus infections caused by receipt of this message

From: Michael Dufty 
Sent: Sunday, 19 April 2020 4:43 PM
To: qgis-user@lists.osgeo.org
Subject: [Qgis-user] Options when loading layers into PostGIS with DBManager

Hi,
I am trying out saving data in PostGIS, and have got stuck on the upload 
“import layer/file” dialog in DB Manager.

Can anyone recommend a good reference on what options should be selected?
It seems to fall into a gap between PostGIS documentation and QGIS 
documentation and I can’t find any information on what should be selected in 
what circumstances.

In particular
Primary key – should this be ticked and the existing id field selected? What 
happens if it is left unticked?
Geometry column – is this needed? Objects still seem to have geometry if it is 
left out.
Create spatial index – this sounds like a good idea, but the one youtube 
tutorial I found (Klas Karlson) he left it unticked and said the layer already 
had everything.  Is it needed for some source formats and not others eg 
shapefile vs geopackage?

Convert field names to lower case doesn’t sound very useful, but I presume it 
is there for a reason, does anyone know the circumstances that would be needed?

Cheers,


Michael Dufty
Senior Environmental Engineer

[cid:image001.jpg@01D6169E.C91D6900]
MBS ENVIRONMENTAL
4 Cook Street, West Perth  WA 6005

t:+61 8 9226-3166
f:+61 8 9226-3177

e:   mdu...@mbsenvironmental.com.au<mailto:mdu...@mbsenvironmental.com.au>
w:   www.mbsenvironmental.com.auhttp://www.mbsenvironmental.com.au/>
Disclaimer:
The information contained in this message is intended for those to whom it is 
addressed. It may contain confidential or privileged information and if you are 
not the intended recipient, you must not copy, distribute or take any action in 
reliance on it. If you received this message in error please destroy it and 
reply to the sender immediately or contact Martinick Bosch Sell Pty Ltd. on +61 
8 9226 3166 immediately. All care has been taken to ensure that this message 
and any attachments are virus free; we do not accept responsibility for any 
virus infections caused by receipt of this message

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

Re: [Qgis-user] Options when loading layers into PostGIS with DBManager

2020-04-19 Thread Michael Dufty 
Thanks Jorge,
The DB manager also 'just works' apparently regardless of which boxed I tick.  
I'd just like to know what is going on or if I'm setting myself up for a 
problem later on if I load up 200 layers with the wrong boxes ticked.

Looking more closely, it has got text greyed out if you don't check a box, 
which may mean it is setting it to the defaults shown, and you only check the 
box if you want to change it.

It would be nice to know more rather than guessing.


From: Jorge Gustavo Rocha 
Sent: Sunday, 19 April 2020 5:41 PM
To: qgis-user@lists.osgeo.org 
Subject: Re: [Qgis-user] Options when loading layers into PostGIS with DBManager


Hi Michael,

An alternative is to use the "Browser panel". I use it to drag layers from the 
Layer panel into Postgresql. You don't have to choose any parameters. It just 
works.

Regards,

Jorge Gustavo

On 19/04/20 09:42, Michael Dufty wrote:

Hi,

I am trying out saving data in PostGIS, and have got stuck on the upload 
“import layer/file” dialog in DB Manager.



Can anyone recommend a good reference on what options should be selected?

It seems to fall into a gap between PostGIS documentation and QGIS 
documentation and I can’t find any information on what should be selected in 
what circumstances.



In particular

Primary key – should this be ticked and the existing id field selected? What 
happens if it is left unticked?

Geometry column – is this needed? Objects still seem to have geometry if it is 
left out.

Create spatial index – this sounds like a good idea, but the one youtube 
tutorial I found (Klas Karlson) he left it unticked and said the layer already 
had everything.  Is it needed for some source formats and not others eg 
shapefile vs geopackage?



Convert field names to lower case doesn’t sound very useful, but I presume it 
is there for a reason, does anyone know the circumstances that would be needed?



Cheers,





Michael Dufty

Senior Environmental Engineer



[cid:part1.109C90E4.CCE4590B@geomaster.pt]

MBS ENVIRONMENTAL
4 Cook Street, West Perth  WA 6005

t:+61 8 9226-3166
f:+61 8 9226-3177



e:   mdu...@mbsenvironmental.com.au<mailto:mdu...@mbsenvironmental.com.au>
w:   www.mbsenvironmental.com.au

Disclaimer:
The information contained in this message is intended for those to whom it is 
addressed. It may contain confidential or privileged information and if you are 
not the intended recipient, you must not copy, distribute or take any action in 
reliance on it. If you received this message in error please destroy it and 
reply to the sender immediately or contact Martinick Bosch Sell Pty Ltd. on +61 
8 9226 3166 immediately. All care has been taken to ensure that this message 
and any attachments are virus free; we do not accept responsibility for any 
virus infections caused by receipt of this message





___
Qgis-user mailing list
Qgis-user@lists.osgeo.org<mailto:Qgis-user@lists.osgeo.org>
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

--
[Logo]<https://www.geomaster.pt>
Geomaster
Jorge Gustavo Rocha | Software Engineer
e: j...@geomaster.pt<mailto:j...@geomaster.pt> | m: +351 910 333 888
g: 41.54094,-8.40490 | v: 510 906 109
a: Rua António Cândido Pinto, 67, 4715-400 Braga
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Options when loading layers into PostGIS with DBManager

2020-04-19 Thread Jorge Gustavo Rocha 
Hi Michael,

An alternative is to use the "Browser panel". I use it to drag layers
from the Layer panel into Postgresql. You don't have to choose any
parameters. It just works.

Regards,

Jorge Gustavo

On 19/04/20 09:42, Michael Dufty wrote:
>
> Hi,
>
> I am trying out saving data in PostGIS, and have got stuck on the
> upload “import layer/file” dialog in DB Manager.
>
>  
>
> Can anyone recommend a good reference on what options should be selected?
>
> It seems to fall into a gap between PostGIS documentation and QGIS
> documentation and I can’t find any information on what should be
> selected in what circumstances.
>
>  
>
> In particular
>
> Primary key – should this be ticked and the existing id field
> selected? What happens if it is left unticked?
>
> Geometry column – is this needed? Objects still seem to have geometry
> if it is left out.
>
> Create spatial index – this sounds like a good idea, but the one
> youtube tutorial I found (Klas Karlson) he left it unticked and said
> the layer already had everything.  Is it needed for some source
> formats and not others eg shapefile vs geopackage?
>
>  
>
> Convert field names to lower case doesn’t sound very useful, but I
> presume it is there for a reason, does anyone know the circumstances
> that would be needed?
>
>  
>
> Cheers,
>
>  
>
>  
>
> *Michael Dufty*
>
> *Senior Environmental Engineer*
>
>  
>
>   
>
> *MBS ENVIRONMENTAL**
> *4 Cook Street, West Perth  WA 6005

> t:+61 8 9226-3166
> f:+61 8 9226-3177
>
>  
>
> e:   mdu...@mbsenvironmental.com.au
> 
> w:   www.mbsenvironmental.com.au
> http://www.mbsenvironmental.com.au/>
>
> Disclaimer: 
> The information contained in this message is intended for those to
> whom it is addressed. It may contain confidential or privileged
> information and if you are not the intended recipient, you must not
> copy, distribute or take any action in reliance on it. If you received
> this message in error please destroy it and reply to the sender
> immediately or contact Martinick Bosch Sell Pty Ltd. on +61 8 9226
> 3166 immediately. All care has been taken to ensure that this message
> and any attachments are virus free; we do not accept responsibility
> for any virus infections caused by receipt of this message//
>
>  
>
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-- 
Email Signature
Logo  
*Geomaster*
*Jorge Gustavo Rocha* | Software Engineer
*e:*j...@geomaster.pt | *m:*+351 910 333 888
*g:*41.54094,-8.40490 | *v: *510 906 109
*a: * Rua António Cândido Pinto, 67, 4715-400 Braga

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

[Qgis-user] Options when loading layers into PostGIS with DBManager

2020-04-19 Thread Michael Dufty 
Hi,
I am trying out saving data in PostGIS, and have got stuck on the upload 
“import layer/file” dialog in DB Manager.

Can anyone recommend a good reference on what options should be selected?
It seems to fall into a gap between PostGIS documentation and QGIS 
documentation and I can’t find any information on what should be selected in 
what circumstances.

In particular
Primary key – should this be ticked and the existing id field selected? What 
happens if it is left unticked?
Geometry column – is this needed? Objects still seem to have geometry if it is 
left out.
Create spatial index – this sounds like a good idea, but the one youtube 
tutorial I found (Klas Karlson) he left it unticked and said the layer already 
had everything.  Is it needed for some source formats and not others eg 
shapefile vs geopackage?

Convert field names to lower case doesn’t sound very useful, but I presume it 
is there for a reason, does anyone know the circumstances that would be needed?

Cheers,


Michael Dufty
Senior Environmental Engineer

[cid:image001.jpg@01D61669.130A2F20]
MBS ENVIRONMENTAL
4 Cook Street, West Perth  WA 6005

t:+61 8 9226-3166
f:+61 8 9226-3177

e:   mdu...@mbsenvironmental.com.au
w:   www.mbsenvironmental.com.auhttp://www.mbsenvironmental.com.au/>
Disclaimer:
The information contained in this message is intended for those to whom it is 
addressed. It may contain confidential or privileged information and if you are 
not the intended recipient, you must not copy, distribute or take any action in 
reliance on it. If you received this message in error please destroy it and 
reply to the sender immediately or contact Martinick Bosch Sell Pty Ltd. on +61 
8 9226 3166 immediately. All care has been taken to ensure that this message 
and any attachments are virus free; we do not accept responsibility for any 
virus infections caused by receipt of this message

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