Re: [Qgis-user] Model Designer - GDAL - Vector Conversion

[Johanna Botman via Qgis-user]

Thank you for the follow up, Nicolas,

I’ll spend a little more time on learning to insert that ID column. I tried the 
Convert to Geopackage and then to TAB files, but that was not satisfactory. The 
ID column was still missing

Johanna Botman
Assets / GIS Officer – Melton City Council

From: Nicolas Cadieux 
Sent: Thursday, 10 March 2022 9:25 AM
To: Johanna Botman 
Cc: Brent Wood ; qgis-user@lists.osgeo.org
Subject: Re: [Qgis-user] Model Designer - GDAL - Vector Conversion


You don't often get email from 
njacadieux.git...@gmail.com<mailto:njacadieux.git...@gmail.com>. Learn why this 
is important<http://aka.ms/LearnAboutSenderIdentification>
Hi,
To my knowledge, the tab file does not need a FID column to work.  I may be 
wrong but a geopackage must have a FID column.  I am sure you could create that 
field afterwards in the model or create a geopackage and then a tab file.
Nicolas Cadieux
https://gitlab.com/njacadieux<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgitlab.com%2Fnjacadieux&data=04%7C01%7Cjohannab%40melton.vic.gov.au%7Cae271fe7ceb24fff072908da021ba93c%7C3c254d694e4641f79684759dce781c6a%7C0%7C0%7C637824615822762561%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=9c4yD6%2BappZe3O6nztd2pReFpgLP4qjZNe5VWREHH3E%3D&reserved=0>


Le 8 mars 2022 à 18:54, Johanna Botman via Qgis-user 
mailto:qgis-user@lists.osgeo.org>> a écrit :

Hi Brent,
I think that is the way that I have to go. I was hoping that it would be a good 
use of the Modeller

Johanna Botman
Assets / GIS Officer – Melton City Council
From: Brent Wood mailto:brent.w...@niwa.co.nz>>
Sent: Wednesday, 9 March 2022 10:50 AM
To: qgis-user@lists.osgeo.org<mailto:qgis-user@lists.osgeo.org>; Johanna Botman 
mailto:johan...@melton.vic.gov.au>>
Subject: Re: Model Designer - GDAL - Vector Conversion

You don't often get email from 
brent.w...@niwa.co.nz<mailto:brent.w...@niwa.co.nz>. Learn why this is 
important<http://aka.ms/LearnAboutSenderIdentification>
Have you considered a script or batch file using ogr2ogr to do this for you?

Brent Wood

Principal Technician, Fisheries
NIWA
DDI:  +64 (4) 3860529

From: Qgis-user 
mailto:qgis-user-boun...@lists.osgeo.org>> 
on behalf of Johanna Botman via Qgis-user 
mailto:qgis-user@lists.osgeo.org>>
Sent: Wednesday, March 9, 2022 12:41
To: qgis-user@lists.osgeo.org<mailto:qgis-user@lists.osgeo.org> 
mailto:qgis-user@lists.osgeo.org>>
Subject: [Qgis-user] Model Designer - GDAL - Vector Conversion


I am trying to use the Model Designer to automate the creation of Tab files 
from SQL Database Tables.

I am using GDAL – Vector Conversion – Convert format

The resulting Tab file is missing the Primary Key field.

If use that same algorithm to export to a Geopackage, the PK is there.

I know that I can right click the SQL Table and select Export. That Tab file 
contains the PK. I need to export 30 tables so am looking for some automation.



Why does the algorithm produce a table without the key field?



Johanna Botman

Assets / GIS Officer – Melton City Council

***
The information in this message is privileged and confidential, intended only 
for the use of the individual or entity named above. If you are not the 
intended recipient you are hereby notified to delete the message and that any 
dissemination, copying or use of its content is strictly prohibited. If you 
have received this message in error please notify the Melton City Council.
***
___
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] Model Designer - GDAL - Vector Conversion

[Nicolas Cadieux via Qgis-user]

Hi,
To my knowledge, the tab file does not need a FID column to work.  I may be 
wrong but a geopackage must have a FID column.  I am sure you could create that 
field afterwards in the model or create a geopackage and then a tab file.  

Nicolas Cadieux
https://gitlab.com/njacadieux

> Le 8 mars 2022 à 18:54, Johanna Botman via Qgis-user 
>  a écrit :
> 
> 
> Hi Brent,
> I think that is the way that I have to go. I was hoping that it would be a 
> good use of the Modeller
>  
> Johanna Botman
>  
> Assets / GIS Officer – Melton City Council
>  
>  
>  
> From: Brent Wood  
> Sent: Wednesday, 9 March 2022 10:50 AM
> To: qgis-user@lists.osgeo.org; Johanna Botman 
> Subject: Re: Model Designer - GDAL - Vector Conversion
>  
> You don't often get email from brent.w...@niwa.co.nz. Learn why this is 
> important
> Have you considered a script or batch file using ogr2ogr to do this for you?
>  
> Brent Wood
> 
> Principal Technician, Fisheries
> NIWA
> DDI:  +64 (4) 3860529
> From: Qgis-user  on behalf of Johanna 
> Botman via Qgis-user 
> Sent: Wednesday, March 9, 2022 12:41
> To: qgis-user@lists.osgeo.org 
> Subject: [Qgis-user] Model Designer - GDAL - Vector Conversion
>  
> I am trying to use the Model Designer to automate the creation of Tab files 
> from SQL Database Tables.
> I am using GDAL – Vector Conversion – Convert format
> The resulting Tab file is missing the Primary Key field.
> If use that same algorithm to export to a Geopackage, the PK is there.
> I know that I can right click the SQL Table and select Export. That Tab file 
> contains the PK. I need to export 30 tables so am looking for some automation.
>  
> Why does the algorithm produce a table without the key field?
>  
>  
>  
> Johanna Botman
>  
> Assets / GIS Officer – Melton City Council
>  
>  
>  
>  
>  
> 
> ***
> The information in this message is privileged and confidential, intended only 
> for the use of the individual or entity named above. If you are not the 
> intended recipient you are hereby notified to delete the message and that any 
> dissemination, copying or use of its content is strictly prohibited. If you 
> have received this message in error please notify the Melton City Council.
> ***
> 
> 
> Brent Wood 
> Principal Technician - GIS and Spatial Data Management
> Programme Leader - Environmental Information Delivery
> +64-4-386-0529
> 
> National Institute of Water & Atmospheric Research Ltd (NIWA)
> 301 Evans Bay Parade Hataitai Wellington New Zealand
> Connect with NIWA: niwa.co.nz Facebook LinkedIn Twitter Instagram
> To ensure compliance with legal requirements and to maintain cyber security 
> standards, NIWA's IT systems are subject to ongoing monitoring, activity 
> logging and auditing. This monitoring and auditing service may be provided by 
> third parties. Such third parties can access information transmitted to, 
> processed by and stored on NIWA's IT systems
> 
> ***
> The information in this message is privileged and confidential, intended only 
> for the use of the individual or entity named above. If you are not the 
> intended recipient you are hereby notified to delete the message and that any 
> dissemination, copying or use of its content is strictly prohibited. If you 
> have received this message in error please notify the Melton City Council.
> ***
> 
> ___
> 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] Model Designer - GDAL - Vector Conversion

[Richard Duivenvoorde via Qgis-user]

On 3/9/22 00:41, Johanna Botman via Qgis-user wrote:

I am trying to use the Model Designer to automate the creation of Tab files 
from SQL Database Tables.

I am using GDAL – Vector Conversion – Convert format

The resulting Tab file is missing the Primary Key field.

If use that same algorithm to export to a Geopackage, the PK is there.

I know that I can right click the SQL Table and select Export. That Tab file 
contains the PK. I need to export 30 tables so am looking for some automation.

Why does the algorithm produce a table without the key field?


Hi Johanna,

Are you using 'Convert Format' which 'uses' ogr2ogr to convert?

Because in that dialog you can add 'Advanced parameters' and if I am right you 
can add specific driver params there.

The 'tab'-driver though:
https://gdal.org/drivers/vector/mitab.html
does not mention a primary key...

I also found:
https://github.com/OSGeo/gdal/issues/2651
which mentions a  -preserve_fid (advanced param)
see https://gdal.org/programs/ogr2ogr.html

So you can actually add some specific gdal params there...?

HTH, Regards,

Richard Duivenvoorde



___
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] Model Designer - GDAL - Vector Conversion

[Johanna Botman via Qgis-user]

Hi Brent,
I think that is the way that I have to go. I was hoping that it would be a good 
use of the Modeller

Johanna Botman

Assets / GIS Officer - Melton City Council



From: Brent Wood 
Sent: Wednesday, 9 March 2022 10:50 AM
To: qgis-user@lists.osgeo.org; Johanna Botman 
Subject: Re: Model Designer - GDAL - Vector Conversion

You don't often get email from brent.w...@niwa.co.nz. Learn why this is 
important
Have you considered a script or batch file using ogr2ogr to do this for you?

Brent Wood

Principal Technician, Fisheries
NIWA
DDI:  +64 (4) 3860529

From: Qgis-user  on behalf of Johanna Botman 
via Qgis-user 
Sent: Wednesday, March 9, 2022 12:41
To: qgis-user@lists.osgeo.org 
Subject: [Qgis-user] Model Designer - GDAL - Vector Conversion


I am trying to use the Model Designer to automate the creation of Tab files 
from SQL Database Tables.

I am using GDAL - Vector Conversion - Convert format

The resulting Tab file is missing the Primary Key field.

If use that same algorithm to export to a Geopackage, the PK is there.

I know that I can right click the SQL Table and select Export. That Tab file 
contains the PK. I need to export 30 tables so am looking for some automation.



Why does the algorithm produce a table without the key field?







Johanna Botman



Assets / GIS Officer - Melton City Council











***
The information in this message is privileged and confidential, intended only 
for the use of the individual or entity named above. If you are not the 
intended recipient you are hereby notified to delete the message and that any 
dissemination, copying or use of its content is strictly prohibited. If you 
have received this message in error please notify the Melton City Council.
***
[Image removed by 
sender.]
Brent Wood
Principal Technician - GIS and Spatial Data Management
Programme Leader - Environmental Information Delivery
+64-4-386-0529

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: 
niwa.co.nz
 
Facebook
 
LinkedIn
 
Twitter
 
Instagram
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can acc

Re: [Qgis-user] Model Designer - GDAL - Vector Conversion

[Brent Wood via Qgis-user]

Have you considered a script or batch file using ogr2ogr to do this for you?

Brent Wood

Principal Technician, Fisheries
NIWA
DDI:  +64 (4) 3860529

From: Qgis-user  on behalf of Johanna Botman 
via Qgis-user 
Sent: Wednesday, March 9, 2022 12:41
To: qgis-user@lists.osgeo.org 
Subject: [Qgis-user] Model Designer - GDAL - Vector Conversion


I am trying to use the Model Designer to automate the creation of Tab files 
from SQL Database Tables.

I am using GDAL – Vector Conversion – Convert format

The resulting Tab file is missing the Primary Key field.

If use that same algorithm to export to a Geopackage, the PK is there.

I know that I can right click the SQL Table and select Export. That Tab file 
contains the PK. I need to export 30 tables so am looking for some automation.



Why does the algorithm produce a table without the key field?







Johanna Botman



Assets / GIS Officer – Melton City Council











***
The information in this message is privileged and confidential, intended only 
for the use of the individual or entity named above. If you are not the 
intended recipient you are hereby notified to delete the message and that any 
dissemination, copying or use of its content is strictly prohibited. If you 
have received this message in error please notify the Melton City Council.
***

[https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] 

Brent Wood
Principal Technician - GIS and Spatial Data Management
Programme Leader - Environmental Information Delivery
+64-4-386-0529

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz 
Facebook 
LinkedIn 
Twitter 
Instagram
To ensure compliance with legal requirements and to maintain cyber security 
standards, NIWA's IT systems are subject to ongoing monitoring, activity 
logging and auditing. This monitoring and auditing service may be provided by 
third parties. Such third parties can access information transmitted to, 
processed by and stored on NIWA's IT systems
___
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