1

In QGIS 3.0, when I am saving a layer as a GeoPackage when using the Points to Path tool.

Points to Path tool, save to GeoPackage

The 'Paths' parameter is pre-filled with something like this,

ogr:dbname='C:/Paths/Paths.gpkg' table="1119" (geom) sql=

Where do I find information on the parameters allowed in this field? It would be great to use the SQL option to only choose the geometry I want here. I haven't found a solution in the QGIS docs (the newest ones). Where else could I look?

2
  • When do you see this? If I do "Layer" "Save As" and choose the format as "GeoPackage", I don't see a "Paths" parameter anywhere. Dialog has Format, File Name, Layer Name, CRS, Extent, Layer Options [DESC, FID, GEOMETRY_NAME,IDENTIFIER, SPATAL_INDEX], Custom options [Data source, Layer]. Can you add a screenshot of what you are doing?
    – Spacedman
    Mar 18, 2018 at 18:32
  • Good suggestion, question updated
    – cndnflyr
    Mar 18, 2018 at 20:10

1 Answer 1

2

The key aspect is the ogr part - that tells you that you're in GDAL/OGR land. Its a happy place, with two kinds of SQL support.

Firstly, there is the old SQL, which you can find documented at http://www.gdal.org/ogr_sql.html

Then there is the new SQLite kind, which you can find documented at http://www.gdal.org/ogr_sql_sqlite.html

1
  • e.g sql='SELECT * FROM streams WHERE name IS NOT NULL'
    – Stonetip
    Jan 19, 2020 at 19:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.