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

Message d'Alexandree Chèvremont
Le mercredi 5 mars, Catherine Grout et moi avons l'immense plaisir d'inviter Elise Domenach et les deux doctorantes dont je dirige le travail de thèse, Mélia Roger et Marianne Pistone, pour ce séminaire doctoral autour des spatialités. Lien Zoom en QR code sur l'affiche et ici : https://univ-lille-fr.zoom.us/j/97731941874...

#ecoute #environnement #corporalite #recherche #spatialite #séminaire

Join our Cloud HD Video Meeting

Zoom is the leader in modern enterprise video communications, with an easy, reliable cloud platform for video and audio conferencing, chat, and webinars across mobile, desktop, and room systems. Zoom Rooms is the original software-based conference room solution used around the world in board, conference, huddle, and training rooms, as well as executive offices and classrooms. Founded in 2011, Zoom helps businesses and organizations bring their teams together in a frictionless environment to get more done. Zoom is a publicly traded company headquartered in San Jose, CA.

Zoom Video

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

DjangoCon US 2024

DjangoCon US is a six-day international conference for the community by the community about the Django web framework, held each year in North America.

Paolo Melchiorre

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

DjangoCon US 2024

DjangoCon US is a six-day international conference for the community by the community about the Django web framework, held each year in North America.

Paolo Melchiorre

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

DjangoCon US 2024

DjangoCon US is a six-day international conference for the community by the community about the Django web framework, held each year in North America.

Paolo Melchiorre

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

Paolo Melchiorre - Maps with Django⁽¹⁾: GeoDjango, SpatiaLite & Leaflet

A quick-start guide to create a web map 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.

Paolo Melchiorre
#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

Kontur Population dataset

Global Population dataset represented by H3 hexagons with population counts at 400m resolution.

Kontur Inc.

#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