@avlcharlie I truncated the error message to fit in the 500 character limit of chaos.social. This failure probably needs a longer post for context; terse version follows:
I found I can drag a layer in QGis to my local #PostGIS database and drop it into the a DB instance. Poof! The data goes from a KML or whatever, into a fully-formed PostgreSQL object.
Until now, when the layer came from ESRI formatted x/y content. I *think* the CRS map projection being over 1000000 hit a bump. To be continued.

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

#introduction

Oslandia is a French SME specializing in OpenSource Geographical Systems ( #GIS ). We design and implement IT systems to manage geographical data.

We are an opensource editor of #QGIS, experts of #PostGIS, #GDAL, #Python, Web 3D visualization & more …

Our team of ~30 (great) people is distributed all over France & full remote is at the heart of our organization.

More info : https://oslandia.com and linkedin

We will post company updates and GIS-related infos

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

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

A configurable, dockerised, simple map server with scripts to import and filter data from #OpenStreetMap...

https://github.com/instantiator/world-server

This repository contains scripts to launch a #postgis geo database and #pg_tileserv tile server in #Docker containers, and to fetch and import data from #OSM.

You can configure it to use any data source, and modify the filter script to determine what sort of places to import.

Looks like the #opensource #spatial database #PostGIS updated its documentation to for #openSUSE with build packages in Open Build Service. https://postgis.net/documentation/getting_started/install_opensuse/

My talk "Maps with Django (and PostGIS)" from CitusCon 2023 is available for viewing on the conference YouTube channel https://youtu.be/R1UtDG75yIw

#PostgreSQL #Django #Maps #Leaflet #PostGiS #GeoDjango #CitusCon #PythonSpeakingTour

CC @clairegiordano

This looks pretty cool:

https://postgrest.org/en/stable/index.html

Any #gischat or #postGIS folks play with this? Anyone got a live-running Swagger-style (or otherwise) endpoint demo that I can play with? Paging @pwramsey cuz I don't know any better...

Happy #GISDay, the holiday where the even bigger party is the next day. Hope to see lots of y'all tomorrow for #PostGIS day https://info.crunchydata.com/postgis-day-2022. There's still time to hear me talk about #PgSTAC, @vincentsarago@twitter.com talk about #TiFeatures/#TiMVT and lots of other great talks!

#introduction

Originally an applied maths engineer, I created and run @oslandia since 2009, focusing on #Opensource Geographical Information Systems (namely #QGIS, #PostGIS ) .

I care about #FOSS4G, #GIS, #OpenSource, #maps, #OSGeo, #spatial on technical & general levels, as well as open organizations and innovative work methods.

I live in France, work remote since 2009, and speak , , & . Favorite projection : octant projection with Reuleaux triangles

#Introduction I'm a spatial data scientist and part of the #SpaceSyntax Lab at the #Bartlett School of Architecture, UCL.

I'm interested in quantifying and analysing the built environment to study how space shapes human behaviour. Currently focused on the intersections of the #BuiltEnvironment with #Health and #WellBeing.

I love open-source tools #R, #PostGIS, and #QGIS.

I also organise the online space syntax lab seminars #SSLS, so watch out for announcements!

https://www.ucl.ac.uk/bartlett/architecture/events/2022/oct/space-syntax-lab-seminars-autumn-2022

Here's a new #introduction from my from the new mapstodon.space instance:

I'm Josh Carlson. I'm a GIS Developer for Kendall County, Illinois, USA, where I manage our GIS portal and keep the tax maps up to date, among many other things.

We're an #esri org, but I like to push #QGIS, #PostGIS, and #OpenStreetMap whenever possible.

Outside of work, I map, knit, forage, fiddle with Python, read, cook, and cycle. I try my best to keep up with my wife and three young sons.

I only wear socks I knit.