it works fine.
On Wed, 29 Apr, 2020, 6:36 pm Ujaval Gandhi, <uja...@spatialthoughts.com> wrote: > You will have to subset the data to make it usable in QGIS. An easy and > fast way would be to use the 'Clip' algorithm from Processing Toolbox. It > can read input data directly from disk (without loading it in QGIS) and > clip using another layer with AOI polygons. I tried it on my machine and it > could read the geopackage and clip it to a state in 2 minutes (see > screenshot) > > [image: Logo] <https://spatialthoughts.com/> > Ujaval Gandhi > Spatial Thoughts > mobile: +91-8095684687 > email: uja...@spatialthoughts.com > [image: LinkedIn icon] <https://www.linkedin.com/in/spatialthoughts/> [image: > Twitter icon] <https://twitter.com/spatialthoughts> > Subscribe to our newsletter http://bit.ly/spatialthoughts-newsletter > > > On Wed, Apr 29, 2020 at 10:15 AM Devdatta Tengshe <devda...@tengshe.in> > wrote: > >> 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 <nikhil...@gmail.com> 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 datameet+unsubscr...@googlegroups.com. >>> 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 datameet+unsubscr...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/datameet/CAOQOUMskj2DFwMiojD87w0LaUAt%3DDZyWt2MWekQ-6Eq1h6CXBw%40mail.gmail.com >> <https://groups.google.com/d/msgid/datameet/CAOQOUMskj2DFwMiojD87w0LaUAt%3DDZyWt2MWekQ-6Eq1h6CXBw%40mail.gmail.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 datameet+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/datameet/CALymcQCZa4kMFb-uc5Wx7xEh2D_j-OgeCAFMDM%3DP5Jk%2BN3FZVw%40mail.gmail.com > <https://groups.google.com/d/msgid/datameet/CALymcQCZa4kMFb-uc5Wx7xEh2D_j-OgeCAFMDM%3DP5Jk%2BN3FZVw%40mail.gmail.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 datameet+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/CA%2B4SsQBx5sgvbrx4MoGjL7z7NdZUyf8fmsPO3Wg9YT8eqVM_Fg%40mail.gmail.com.