Hi Nikhil, While you can always connect to the GeoPackage via a sqlite connector, and Run Spatial SQL queries, the easiest way to create a subset, is using GDAL's ogr2ogr utility.
If you have Qgis Installed, you would have an Os4GeoShell (For linux and Mac, the command can be run in your regular shell). Here, you can use ogr2ogr to transform data quite quickly, and creating a spatial subset is as easy as passing the proper boundingbox, in a command like this: ogr2ogr -clipsrc 70.1 18.2 75.5 20.6 output.gpkg input.gpkg Regards, Devdatta On Wed, 29 Apr 2020 at 09:42, Nikhil VJ <[email protected]> wrote: > I'm reading more about the .gpkg format here: > > http://switchfromshapefile.org/#alternatives > > Question: If I have lat-long bounds for a smaller regions, then how do > extract that much part of data (one feature starting inside and continuing > outwards is ok, no need to chop)... without having to load up the complete > file into memory ? > > I understand this format is SQLite at its core. And that is known for > enabling us to query it without having to load the full data into memory. > I've been using osmconvert for extracting from .pbf, but afaik it doesn't > support .gpkg formats. > > Regards > Nikhil VJ > https://nikhilvj.co.in > > > On Tuesday, April 28, 2020 at 10:51:03 PM UTC+5:30, Justin wrote: >> >> @Deepak, open it, and walk away for about 30 minutes. It will open. Try >> to have your area of interested centered on your screen, zoom into it. Then >> select and export the section you need, otherwise it is a bit difficult to >> work with. >> > -- > Datameet is a community of Data Science enthusiasts in India. Know more > about us by visiting http://datameet.org > --- > You received this message because you are subscribed to the Google Groups > "datameet" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/datameet/014a86b6-ed55-4018-890e-7dcbf412dc38%40googlegroups.com > <https://groups.google.com/d/msgid/datameet/014a86b6-ed55-4018-890e-7dcbf412dc38%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Datameet is a community of Data Science enthusiasts in India. Know more about us by visiting http://datameet.org --- You received this message because you are subscribed to the Google Groups "datameet" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CAOQOUMskj2DFwMiojD87w0LaUAt%3DDZyWt2MWekQ-6Eq1h6CXBw%40mail.gmail.com.
