[Qgis-user] script filegdb to spatial lite

[Martin Bain]

Matt,
Have a look into the ogr2ogr.exe which is installed with QGIS.

It’s a command line program that converts formats.  You could make a batch script to get the data you want one layer at a time into a single spatialite db.  I’m afraid you got a bit of work to do to figure out the options for your input and output formats.

Here’s a sample I found on my hard drive that I did some time ago to get data from a SQL Server table into Spatialite, to give you an idea of what’s involved.  I don’t remember what all options are :P

C:\OSGeo4W\bin\ogr2ogr.exe -f SQlite "C:\output7.sqlite" "MSSQL:server=xxxx;database=zzzz;trusted_connection=yes;" -sql "SELECT * FROM lOT" -a_srs "EPSG:28356" -dsco SPATIALITE=yes -nln "LOT" -nlt PROMOTE_TO_MULTI -geomfield SP_GEOMETRY –append

Good luck.

From: Qgis-user [mailto:qgis-user-bounces at lists.osgeo.org] On Behalf Of Matt Boyd
Sent: Thursday, 9 November 2017 2:53 PM
To: qgis-user <qgis-user at lists.osgeo.org>
Subject: [Qgis-user] script filegdb to spatial lite

Hi QGISers,
I'm working from a corporate dataset, mostly geodatabases located on a network drive.
I'd like to make a portable version of the datasets that I use that's updated either automaticaly, or whenever I run a script.
I'm not 100% sure how spatialite works. Is everything in a single file database? I'd like to just create a script only grabbing the data I specify from the network drive and save that locally.
I don't do the database updating so it's only a one way process.

Has anyone done something like this? are there shortcuts?

Thanks
Matt

This email is intended for the named recipient only.  The information it contains may be confidential.  If you are not the intended recipient you must not reproduce or distribute any part of this email, disclose its contents to any other party or take any action in reliance on it.  If you have received this email in error, please contact the sender immediately and delete the message.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20171109/ab11d99b/attachment.html>