#spatialite — Public Fediverse posts

oh boy, `spatialite` doesn't use a geographic index? You need to do this complicated nested queries to use it?

🤯🤯🤯

Maybe I need to switch to #postgis
#sqlite #gis #spatialite

The video recording of my talk "Maps with Django" presented in Durham, USA, during DjangoCon US 2024 is finally online 🚀

I talked about Django, Maps, GeoDjango, SQLite, SpatiaLite, PostgreSQL, PostGIS and Leaflet 🗺️
https://www.paulox.net/2024/09/24/djangocon-us-2024/

CC @djangocon

#DjangoCon #DjangoConUS #Django #Maps #GeoDjango #SQLite #SpatiaLite #PostgreSQL #PostGIS #Leaflet

This morning I presented the talk "Maps with Django" at DjangoCon US 2024 in Durham, North Carolina (US) 🇺🇲

It was a great experience, and I thank the organizers and volunteers 🤗

You can find slides and info here 👇
https://www.paulox.net/2024/09/24/djangocon-us-2024/

#Django #DjangoCon #GeoDjango #Maps #DjangoConUS #DjangoConUS2024 #GIS #PostGIS #PostgreSQL #SQLite #SpatiaLite

CC @djangocon

Today at 11:30 EST I'll be giving my talk "Maps with Django" at DjangoCon US 2024 in Durham, North Carolina 🇺🇲

I'll wait for you in the "Grand Ballroom III" of the Durham Convention Center, or you can watch it online ☺️

More info 👇
https://www.paulox.net/2024/09/24/djangocon-us-2024/

#DjangoCon #DjangoConUS #DjangoCon2024 #GeoDjango #Django #Maps #Leaflet #PostgGIS #PostgreSQL #SQLite #SpatiaLite #GIS #GDAL

I have updated my articles on maps with Django with some small improvements and updated dependencies, including Django 5.0 and Python 3.12 🗺️

The first article 👇
https://www.paulox.net/2020/12/08/maps-with-django-part-1-geodjango-spatialite-and-leaflet/

#Django #Map #Python #GeoDjango #GIS #Leaflet #GeoJSON #SpatiaLite #SQLite

@muvlon @Codeberg #spatialite is distributed as #fossil

#sqlite people. When dealing with geographic data, is #spatialite the plug-in/library of choice/repute or are there other viable options that should be considered.

Not a 30daymapchallenge map, so not intentionally bad 😀

Using #qgis and #spatialite to do a decile plot of the earth's population. Each band is 10% of all people. It's centered on Almaty which is supposedly the point closest to everyone on earth.

Population data is from Kontur https://www.kontur.io/portfolio/population-dataset/

MapChallenge people, that's a great dataset for day 29 😉

Code for query is in alt-text

#30DayMapChallenge Day 1 : Points.

Cantons of Switzerland, using a x/y rank plot (pseudo cartogram), using #QGIS and #spatialite.

This technique plots points by rank(x) and rank(y), so they keep their geographic relationship, but also spreads them out like a cartogram.

Using data copyright #openstreetmap contributors

About Polygon Indexing: Comments on a new geospatial library with interesting indexing
https://simonwillison.net/2023/Sep/23/tg-polygon-indexing/
#spatialite #database #rtree #maps #gis #+

#Geoveille #Rediff #Topos #Géographie #geography #Spatialité

À la recherche de l’espace perdu… Lecture géographique de Marcel Proust, chez MondesSociaux par Lionel Dupuy #Chôra https://sms.hypotheses.org/19303

This weird looking thing is a pseudo-cartogram of #scotland. Using #qgis, #spatialite and data copyright #openstreetmap contributors.

Each building's x coordinate is its rank over the longitudes, y coordinate is its rank over the latitudes. Then projected to EPSG:3857 as a 1400 x 1400km square.

The blob on the left is Glasgow, the blob on the right is Edinburgh

Met #qgis en #spatialite heb je alles waar je ooit een gis systeem voor nodig had. En het werkt beter ook. Omdat het open source is is er een hele gemeenschap die de foutjes eruit poetst. Ik gebruik het thusi om bij te houden waar ik allemaal geweest ben. Hieronder een wereldkaart met de landen die ik de laatste 20 jaar bezocht, een kaartje van m'n recente ritten door de Eifel en een kaartje met mijn sporen in 2023.

TIL how to use a spatial index with an attached database in #spatialite https://github.com/eyeseast/til/blob/main/sql/cross-database-spatial-index.md Going to be very handy.

Sandro Furieri is the main author of #spatialite, a geospatial database based on #sqlite, released in 2008 for the first time.

Thanks that, here we manage a growing (now 48GBs) multi-years and multi-sites in-field soil moisture database, for scientific use. Thanks Sandro and Spatialite/Sqlite folks.

#gis #foss4g

@marcbeldata Did you try with #PostGIS ? It is made for this kind of operations. Leveraging #QGIS and #PostGIS together is more than often the best solution, and the most efficient.
You could try #Spatialite too if you do not want any server component.

As for #PostGIS and #QGIS, you can do a lot coupling them, not only computing. See e.g. @CabiecesJ presentation at FOSS4G 2022 ( as soon as the content is pushed online ) : https://talks.osgeo.org/foss4g-2022/talk/ZGCKEE/

I finally updated the first article on web maps with Django and SpatiaLite (SQLite) that I wrote in 2020. I tested the guide with Python 3.11, Django 4.1 and Ubuntu 22.10 and made some small improvements. ✨

I hope you find it interesting. 🤞

Any feedback is welcome. ✅

Happy reading. 👍

https://www.paulox.net/2020/12/08/maps-with-django-part-1-geodjango-spatialite-and-leaflet/

#Python #Django #Map #SpatiaLite #SQLite #GeoDjango #GIS #Leaflet #Javascript

i had big plans for ST_GeneratePoints, but it's not in #spatialite.

whomp, whomp.

https://postgis.net/docs/ST_GeneratePoints.html

I wrote a series of #articles on how to build #maps with #Django 🗺️

The first article in the series is "Maps with Django (1): GeoDjango, SpatiaLite, Leaflet" 🍃

A quickstart #guide to create a #webmap with the #Python based web framework Django using its module #GeoDjango, the #SQLite database with its spatial extension #SpatiaLite and #Leaflet, a #JavaScript library for interactive maps. 👇

https://www.paulox.net/2020/12/08/maps-with-django-part-1-geodjango-spatialite-and-leaflet/

I've just published:
"Maps with Django (part 1): GeoDjango, SpatiaLite and Leaflet"
A quickstart guide to create a web #map 🗺️ with #Django 🦄 using its module #GeoDjango 🌍, the #SQLite 🪶 database with its spatial extension #SpatiaLite 🌐 and #Leaflet 🍃
https://www.paulox.net/2020/12/08/maps-with-django-part-1-geodjango-spatialite-and-leaflet/