It's been over 10 years since I last used an #arcgis product. Over this time I've been well served by #rstats (sf, terra), #gdal, #qgis and the likes.
The company I work for acquired some #esri licenses so I thought I'd give it a try. Fired up ArcPro, downloaded a well known geopackage […]
The company I work for acquired some #esri licenses so I thought I'd give it a try. Fired up ArcPro, downloaded a well known geopackage […]
Original post on datasci.social
datasci.social
November 12, 2025 at 12:37 AM
Interrogative: is there a way to read the entirety of a geopackage* into R and then write a geoparquet file out?
#rspatial
* I have 20 layers
#rspatial
* I have 20 layers
October 16, 2025 at 7:42 PM
Interrogative: is there a way to read the entirety of a geopackage* into R and then write a geoparquet file out?
#rspatial
* I have 20 layers
#rspatial
* I have 20 layers
learned about #PocketBase - a one-file #backend using #sqlite as #database
it automatically creates an #API - optionally with #authentication
could be a base for a minimalistic #geodata server based on #geopackage #gpkg
#ogc #gischat #spatial #geospatial
https://pocketbase.io/
it automatically creates an #API - optionally with #authentication
could be a base for a minimalistic #geodata server based on #geopackage #gpkg
#ogc #gischat #spatial #geospatial
https://pocketbase.io/
PocketBase - Open Source backend in 1 file
Open Source backend in 1 file with realtime database, authentication, file storage and admin dashboard
pocketbase.io
October 14, 2025 at 7:17 PM
learned about #PocketBase - a one-file #backend using #sqlite as #database
it automatically creates an #API - optionally with #authentication
could be a base for a minimalistic #geodata server based on #geopackage #gpkg
#ogc #gischat #spatial #geospatial
https://pocketbase.io/
it automatically creates an #API - optionally with #authentication
could be a base for a minimalistic #geodata server based on #geopackage #gpkg
#ogc #gischat #spatial #geospatial
https://pocketbase.io/
Last step in getting shinyApp to autogenerate layers (find layers in geopackage |> create reactive data |> create observations |> display layer) is now working for the test layer. Soon, both known and unknown layers will be picked up via st_layers() and displayed automatically in the map 😁
#rspatial
#rspatial
October 4, 2025 at 7:17 PM
Last step in getting shinyApp to autogenerate layers (find layers in geopackage |> create reactive data |> create observations |> display layer) is now working for the test layer. Soon, both known and unknown layers will be picked up via st_layers() and displayed automatically in the map 😁
#rspatial
#rspatial
It told me try uploading something smaller than 25MB. I was dragging and dropping to a new repo. (geopackage = 48.9 MB (51,314,688 bytes)... 🤔)
September 15, 2025 at 3:29 PM
It told me try uploading something smaller than 25MB. I was dragging and dropping to a new repo. (geopackage = 48.9 MB (51,314,688 bytes)... 🤔)
So, github can't handle my 50MB geopackage. So, creating a repo for uploading to posit connect cloud is a no go.
September 15, 2025 at 3:00 PM
So, github can't handle my 50MB geopackage. So, creating a repo for uploading to posit connect cloud is a no go.
📦 ¿Aún usas mil shapefiles? Con GeoPackage puedes guardar todas tus capas en un solo archivo .gpkg.
Te enseñamos cómo hacerlo en QGIS paso a paso.
#QGIS #GeoPackage #SIG #Geoinnova #GestiónDeDatos
Te enseñamos cómo hacerlo en QGIS paso a paso.
#QGIS #GeoPackage #SIG #Geoinnova #GestiónDeDatos
September 11, 2025 at 1:02 PM
📦 ¿Aún usas mil shapefiles? Con GeoPackage puedes guardar todas tus capas en un solo archivo .gpkg.
Te enseñamos cómo hacerlo en QGIS paso a paso.
#QGIS #GeoPackage #SIG #Geoinnova #GestiónDeDatos
Te enseñamos cómo hacerlo en QGIS paso a paso.
#QGIS #GeoPackage #SIG #Geoinnova #GestiónDeDatos
Upload vector data in all major formats—no conversion needed. GeoJSON, SHP (in ZIP), GPX, KML, and GeoPackage are fully supported. Just upload it, and automatic processing takes care of the rest.
Find out more: maptiler.link/4mktqXc
Find out more: maptiler.link/4mktqXc
September 2, 2025 at 3:42 PM
Upload vector data in all major formats—no conversion needed. GeoJSON, SHP (in ZIP), GPX, KML, and GeoPackage are fully supported. Just upload it, and automatic processing takes care of the rest.
Find out more: maptiler.link/4mktqXc
Find out more: maptiler.link/4mktqXc
I was a bit surprised to see that searches for "census geopackage" and "tiger geopackage" in Bluesky turned up zero results. May this post remedy that situation!
5/5
5/5
August 29, 2025 at 10:29 AM
I was a bit surprised to see that searches for "census geopackage" and "tiger geopackage" in Bluesky turned up zero results. May this post remedy that situation!
5/5
5/5
TIL the US Census Bureau is releasing its latest TIGER/Line data in GeoPackage format! 🧵
www.census.gov/geographies/...
1/5
www.census.gov/geographies/...
1/5
TIGER/Line GeoPackages
View the available TIGER/Line GeoPackages from the Geography program.
www.census.gov
August 29, 2025 at 10:29 AM
TIL the US Census Bureau is releasing its latest TIGER/Line data in GeoPackage format! 🧵
www.census.gov/geographies/...
1/5
www.census.gov/geographies/...
1/5
The new mayoralties haven't been implemented yet. Wait until 2028 at least...
If you mean the 'ancient' historic counties... they're available in the Ordnance Survey boundaries geopackage opendata download. But, I wouldn't recommend them, far too many bad memories of lorded gents and nepotism.
If you mean the 'ancient' historic counties... they're available in the Ordnance Survey boundaries geopackage opendata download. But, I wouldn't recommend them, far too many bad memories of lorded gents and nepotism.
August 23, 2025 at 8:16 PM
The new mayoralties haven't been implemented yet. Wait until 2028 at least...
If you mean the 'ancient' historic counties... they're available in the Ordnance Survey boundaries geopackage opendata download. But, I wouldn't recommend them, far too many bad memories of lorded gents and nepotism.
If you mean the 'ancient' historic counties... they're available in the Ordnance Survey boundaries geopackage opendata download. But, I wouldn't recommend them, far too many bad memories of lorded gents and nepotism.
You mean in addition to my recent discoveries re dropping triggers to update attributes in a geopackage (@jakubnowosad.com), loading data based on viewable map (@coatless.bsky.social), the excellent {mapgl} 📦 (@kylewalker.bsky.social), spatial extensions in duckdb and r packages incl. {ducksf}...
August 23, 2025 at 7:59 PM
You mean in addition to my recent discoveries re dropping triggers to update attributes in a geopackage (@jakubnowosad.com), loading data based on viewable map (@coatless.bsky.social), the excellent {mapgl} 📦 (@kylewalker.bsky.social), spatial extensions in duckdb and r packages incl. {ducksf}...
Also, is just me or does neither allow for a spatial filter and an SQL (attribute) filter at the same time?
August 21, 2025 at 9:34 PM
Also, is just me or does neither allow for a spatial filter and an SQL (attribute) filter at the same time?
Stack ATM : :django: :firefox: :mastodon: :python: :signalapp: :thunderbird: :gdal: :geopackage: :geopandas: :geotribu: :grass: :osgeo: :osm: :postgis: :postgres: :qgis: :qgis_fr: 🤙 # mapstodon # EmojiFlex
Interest | Match | Feed
Interest | Match | Feed
Origin
mapstodon.space
August 21, 2025 at 6:58 AM
Stack ATM : :django: :firefox: :mastodon: :python: :signalapp: :thunderbird: :gdal: :geopackage: :geopandas: :geotribu: :grass: :osgeo: :osm: :postgis: :postgres: :qgis: :qgis_fr: 🤙 # mapstodon # EmojiFlex
Interest | Match | Feed
Interest | Match | Feed
Origin
mapstodon.space
August 21, 2025 at 6:58 AM
Error: near "routes_geom_insert": syntax error
*phew* panic over:
Added single quotes to DROP TRIGGER statement and now back in business with larger geopackage with awkward spaces in table names that breaks the SQL.
#rspatial geopackage joys 😂
*phew* panic over:
Added single quotes to DROP TRIGGER statement and now back in business with larger geopackage with awkward spaces in table names that breaks the SQL.
#rspatial geopackage joys 😂
August 8, 2025 at 11:01 AM
Error: near "routes_geom_insert": syntax error
*phew* panic over:
Added single quotes to DROP TRIGGER statement and now back in business with larger geopackage with awkward spaces in table names that breaks the SQL.
#rspatial geopackage joys 😂
*phew* panic over:
Added single quotes to DROP TRIGGER statement and now back in business with larger geopackage with awkward spaces in table names that breaks the SQL.
#rspatial geopackage joys 😂
@brodriguesco.bsky.social
Will `T` have native geospatial support?
Something that can deal with the SQL triggers in a geopackage, whilst efficiently updating attributes, would be awesome 😆
Will `T` have native geospatial support?
Something that can deal with the SQL triggers in a geopackage, whilst efficiently updating attributes, would be awesome 😆
August 2, 2025 at 10:03 PM
@brodriguesco.bsky.social
Will `T` have native geospatial support?
Something that can deal with the SQL triggers in a geopackage, whilst efficiently updating attributes, would be awesome 😆
Will `T` have native geospatial support?
Something that can deal with the SQL triggers in a geopackage, whilst efficiently updating attributes, would be awesome 😆
Or that a geopackage can contain more than one layer 🤣
July 27, 2025 at 12:03 PM
Or that a geopackage can contain more than one layer 🤣
I do not think so. But you can check the code at gist.github.com/Nowosad/357f...
update_gkpg.R
GitHub Gist: instantly share code, notes, and snippets.
gist.github.com
July 27, 2025 at 11:25 AM
Can confirm your solution works a treat! So many thanks 😁
July 25, 2025 at 10:48 AM
Can confirm your solution works a treat! So many thanks 😁
Trying to update a specific record in a table in a geopackage. Hoping st_write in the {sf} package has the answer but can't make sense of the options...
As an example, I'd like to do something like:
UPDATE 'TSS Checklist' SET TSS = 'D1' WHERE USRN IN ('00200001')
Any ideas #rspatial?
#rstats
As an example, I'd like to do something like:
UPDATE 'TSS Checklist' SET TSS = 'D1' WHERE USRN IN ('00200001')
Any ideas #rspatial?
#rstats
July 23, 2025 at 2:46 PM
I do try to use geopackage for GIS when I can, though that probably doesn't count.
When used to look after the Voter File, we offered state sqlite snapshots, mostly so people could use dbplyr (there was probably a better flat file solution, but I didn't know much about that at the time.)
When used to look after the Voter File, we offered state sqlite snapshots, mostly so people could use dbplyr (there was probably a better flat file solution, but I didn't know much about that at the time.)
July 22, 2025 at 8:10 PM
I do try to use geopackage for GIS when I can, though that probably doesn't count.
When used to look after the Voter File, we offered state sqlite snapshots, mostly so people could use dbplyr (there was probably a better flat file solution, but I didn't know much about that at the time.)
When used to look after the Voter File, we offered state sqlite snapshots, mostly so people could use dbplyr (there was probably a better flat file solution, but I didn't know much about that at the time.)
I did something analogous here, where I needed to subset geopackage based on user input (a depth layer), then use that to pare down some in-memory NCDF data.
github.com/CGC-UMCES/me...
github.com/CGC-UMCES/me...
metaboscape-application/R/helpers/slice_ncdf.R at main · CGC-UMCES/metaboscape-application
Contribute to CGC-UMCES/metaboscape-application development by creating an account on GitHub.
github.com
July 18, 2025 at 10:41 PM
I did something analogous here, where I needed to subset geopackage based on user input (a depth layer), then use that to pare down some in-memory NCDF data.
github.com/CGC-UMCES/me...
github.com/CGC-UMCES/me...
Geopackages are just fancy SQLite dbs. You could write the simplified geometry to a separate layer (i.e. table) in the geopackage and query it by index
July 18, 2025 at 10:34 PM
Geopackages are just fancy SQLite dbs. You could write the simplified geometry to a separate layer (i.e. table) in the geopackage and query it by index
hahahaha... well, I was thinking of saving as an RDS and then having an actionButton to output as geopackage... but it's great to see your resilience 🤣
July 18, 2025 at 10:30 PM
hahahaha... well, I was thinking of saving as an RDS and then having an actionButton to output as geopackage... but it's great to see your resilience 🤣