# Geographic Information System A computer-based system that combines maps and databases to capture, store, analyze, and visualize geographically referenced spatial data. This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles. ## Loongson loong64 packages on apt.postgresql.org DevFeed: [Loongson loong64 packages on apt.postgresql.org]() Original publisher: [Read original article]() Author: Apt Postgresql Org Published: 2026-08-19T00:00:00Z Content type: news Language: en Sources: [PostgreSQL news]() Topics: [apt](), [PostgreSQL](), [cpu](), [Geographic Information System](), [Exception]() Tags: [apt](), [architecture](), [community](), [postgresql]() ### AI overview apt.postgresql.org now provides PostgreSQL packages for the Loongson loong64 architecture. The GIS package stack is still awaiting the next PostGIS release. ### Source excerpt We have a new architecture on apt.postgresql.org: Loongson loong64, a Chinese processor architecture. The build host for the architecture is running on a Loongson 3B6000 board provided by the loongfans.cn community. Bootstrapping the PostgreSQL packages was completed earlier this month and everything is in place to be used via apt.postgresql.org. The exception is the GIS stack of packages (postgis, pgrouting, mobilitydb, pgsql-ogr-fdw) which are currently still waiting for the next postgis release. Enjoy, Christoph ## How to bypass SSL for PROJ reprojection DevFeed: [How to bypass SSL for PROJ reprojection]() Original publisher: [Read original article]() Author: Robin Wilson Published: 2026-03-23T16:23:36Z Content type: tutorial Language: en Sources: [Robin Wilson]() Topics: [Geographic Information System](), [Security](), [SSL](), [import](), [Linux](), [osx](), [Windows]() Tags: [academic](), [command](), [computing](), [gis](), [how-to](), [import](), [linux](), [osx](), [remote-sensing](), [security](), [ssl](), [windows]() ### AI overview This tutorial explains how to temporarily disable SSL verification for PROJ during coordinate reprojection when self-signed or misconfigured certificates cause downloads of conversion data to fail. It notes the security trade-off and points to setting a PROJ environment variable. ### Source excerpt A friend was using GDAL's ogr2ogr command to import some data to PostGIS recently, and as part of the import they were doing a reprojection of the data. They got the following error: PROJ: Cannot open https://cdn.proj.org/uk_os_OSTN15_NTv2_OSGBtoETRS.tif: schannel: the certificate or certificate chain is based on an untrusted root They've had various SSL errors on [...] ## State of Geospatial in ClickHouse in March 2026 DevFeed: [State of Geospatial in ClickHouse in March 2026]() Original publisher: [Read original article]() Author: Mark Needham Published: 2026-03-04T00:00:00Z Content type: article Language: en Sources: [ClickHouse Blog]() Topics: [clickhouse](), [Geographic Information System]() Tags: [analytics](), [batch](), [clickhouse](), [history](), [points](), [production](), [speed](), [storage](), [tools]() ### AI overview This article surveys ClickHouse's geospatial capabilities as of March 2026, covering its type system, spatial functions, grid-based indexing systems such as H3 and S2, WKT and WKB support, version history, production readiness, and limitations. ### Source excerpt Everything you need to know about ClickHouse as a geospatial analytics engine: its type system, indexing grids, strengths, and limitations. ## Pharmacy late-night opening hours analysis featured in the Financial Times DevFeed: [Pharmacy late-night opening hours analysis featured in the Financial Times]() Original publisher: [Read original article]() Author: Robin Wilson Published: 2026-02-04T14:10:37Z Content type: article Language: en Sources: [Robin Wilson]() Topics: [Data analysis](), [geospatial](), [Geographic Information System](), [Python](), [pandas]() Tags: [academic](), [analysis](), [article](), [data](), [data-analysis](), [geospatial](), [gis](), [pandas](), [python]() ### AI overview The article describes an analysis of NHS data on community pharmacy opening hours in England. It reports that the number of pharmacies open past 9pm on weekdays fell by approximately 95% between 2022 and 2025, leaving large areas without late-night pharmacy access. The analysis used Python, pandas, geospatial tools and mapping libraries, and was featured in the Financial Times. ### Source excerpt Some data analysis I've done has been featured in the Financial Times today - see this article (the link may not work any more unless you have a FT subscription - sorry). The brief story is that I had terrible back pain over Christmas, and spoke to an out-of-hours GP on the phone who prescribed [...] ## Enterprise Geospatial Solutions with QGIS and Angular DevFeed: [Enterprise Geospatial Solutions with QGIS and Angular]() Original publisher: [Read original article]() Author: brakmic Published: 2025-03-10T16:53:01Z Content type: tutorial Language: en Sources: [Harris Brakmic - Coding]() Topics: [geospatial](), [Geographic Information System](), [Angular](), [Docker Compose](), [Kubernetes](), [Web Development](), [JavaScript]() Tags: [angular](), [cloud-native](), [coding](), [docker](), [frontend](), [gis](), [javascript](), [kubernetes](), [qgis]() ### AI overview This article explains how to combine QGIS Desktop and Server with Docker Compose and Kubernetes to build scalable geospatial applications. It also covers an Angular or minimal JavaScript web client and map rendering with OpenLayers. ### Source excerpt This article shows how to combine QGIS Desktop/Server with Docker Compose and Kubernetes to build scalable geospatial applications. It also covers creating a web client using Angular (or a minimal JavaScript approach), integrating OpenLayers for map rendering, and ensuring all components work seamlessly together. ## Postgres as a Graph Database: (Ab)using pgRouting DevFeed: [Postgres as a Graph Database: (Ab)using pgRouting]() Original publisher: [Read original article]() Author: Paul Copplestone Published: 2025-02-25T07:00:00Z Content type: tutorial Language: en Sources: [Supabase Blog]() Topics: [Databases](), [graph-database](), [Graphs](), [Geographic Information System](), [Algorithms](), [Neo4j]() Tags: [algorithm](), [geospatial](), [graph-database](), [graphs](), [how-to](), [learn](), [postgres](), [routing]() ### AI overview This article explains how pgRouting, a Postgres extension commonly used with PostGIS, can provide lightweight graph functionality. It covers shortest-path and network analysis, GIS applications, task scheduling with dependency graphs, critical-path analysis, and the use of Dijkstra's algorithm. ### Source excerpt Learn how to use pgRouting as a lightweight graph database solution in Postgres. ## GIS in Go DevFeed: [GIS in Go]() Original publisher: [Read original article]() Published: 2021-11-01T00:00:00Z Content type: tutorial Language: en Sources: [William Kennedy]() Topics: [Geographic Information System](), [Go Language](), [CSV]() Tags: [ardan-labs](), [blog](), [csv](), [gis](), [go](), [go-programming](), [golang](), [programming]() ### AI overview A Go tutorial that loads GPS route data from a CSV file, resamples it into fewer time-based points, and generates an HTML map using Leaflet. ### Source excerpt Introduction You are jogging and want to show off your route to your friends. Let's imagine the data you have for your route is a CSV file in the following format: Listing 1: track.csv time,lat,lng,height 2015-08-20 03:48:07.235,32.519585,35.015021,136.1999969482422 2015-08-20 03:48:24.734,32.519606,35.014954,126.5999984741211 2015-08-20 03:48:25.660,32.519612,35.014871,123.0 2015-08-20 03:48:26.819,32.519654,35.014824,120.5 2015-08-20 03:48:27.828,32.519689,35.014776,118.9000015258789 2015-08-20 03:48:29.720,32.519691,35.014704,119.9000015258789 2015-08-20 03:48:30.669,32.519734,35.014657,120.9000015258789 Listing 1 shows the first few lines of track.csv. Each line contains a time stamp in UTC, latitude, longitude and height above sea level in meters. ## Spatial, Pluggable SQLite DevFeed: [Spatial, Pluggable SQLite]() Original publisher: [Read original article]() Author: Shai Almog Published: 2018-05-07T00:00:00Z Content type: article Language: en Sources: [CodeName One]() Topics: [SQLite](), [Geographic Information System](), [Databases](), [SQL](), [Security]() Tags: [android](), [encryption](), [gis](), [ios](), [security](), [sql](), [sqlite]() ### AI overview The article describes a pluggable SQLite solution for Codename One applications that adds spatial query support for GIS use cases on Android and iOS. It also discusses encryption as a potential extension because the native SQL databases are not encrypted by default. ### Source excerpt One of our enterprise accounts is working on a complex GIS application that needs fine grained control over mapping. In this case features such as native maps aren't useful. For some GIS applications the old MapComponent is more useful as it allows working with domain specific data. One of the features he needed was spatial support in the builtin SQL database. When we initially implemented sqlite support we just delegated all the SQL calls to the OS native equivalents and called it a day. This works well for 98% of the cases but there are two big use cases that are missing by default in Android & iOS: Spatial queries & Security. ## Dear Postgres DevFeed: [Dear Postgres]() Original publisher: [Read original article]() Author: Map Published: 2017-10-12T20:55:56Z Content type: opinion Language: en Sources: [Craig Kerstiens]() Topics: [Databases](), [Database](), [data](), [Geographic Information System](), [JSON](), [functions](), [XML]() Tags: [b-tree](), [database](), [databases](), [gis](), [indexes](), [json](), [jsonb](), [location-based](), [postgres](), [postgresql](), [window-functions]() ### AI overview An appreciative commentary on Postgres describes how it has expanded beyond traditional relational database capabilities while retaining a focus on data durability, standards, and steady improvement. The article discusses indexes, GIS and PostGIS, analytical features such as window functions and CTEs, and JSON and JSONB support. ### Source excerpt Dear Postgres, I've always felt an affinity for you in my 9 years of working with you. I know others have known you longer, but that doesn't mean they love you more. Years ago when others complained about your rigidness or that you weren't as accommodating as others I found solace in your steadfast values: Don't lose data Adhere to standards Move forward with a balancing act between new fads of the day while still continuously improving You've been there and seen it all. Years ago you were being disrupted by XML databases. As companies made heavy investment into what such a document database would do for their organization you proceeded to "simply" add a datatype that accomplished the same and brought your years of progress along with it. In the early years you had the standard format of index b-tree that most database engines leveraged. Then quietly but confidently you started adding more. Then came K-nearest neighbor, generalized inverted indexes (GIN), and generalized search-tree (GiST), only to be followed by space partitioned GiST and block range indexes (BRIN). Now the only question is which do I use? All the while there was this other camp using for something that felt cool but outside my world: GIS. GIS, geographical information systems, I thought was something only civil engineers used. Then GPS came along, then the iPhone and location based devices came along and suddenly I wanted to find out the nearest path to my Peets, or manage geographical region for my grocery delivery service. PostGIS had been there all along building up this powerful feature set, sadly to this day I still mostly marvel from the sideline at this whole other feature set I long to take advantage of... one day... one day. A little over 5 years ago I fell in love with your fastly improving analytical capabilities. No you weren't an MPP system yet, but here came window functions and CTEs, then I almost understood recursive CTEs (still working on that one). I can iterate over data in a recurs ## PGDay France 2012 DevFeed: [PGDay France 2012]() Original publisher: [Read original article]() Author: Dimitri Fontaine PostgreSQL Major Contributor; Author Published: 2012-06-08T14:17:00Z Content type: article Language: fr Sources: [Dimitri Fontaine]() Topics: [PostgreSQL](), [Replication](), [Geographic Information System](), [Math and Logic]() Tags: [conference](), [gis](), [postgresql](), [replication](), [users]() ### AI overview A brief report on pgday.fr, the French PostgreSQL Conference held in Lyon, describing its seven-talk program, topics including GIS, fuzzy logic, and replication, and the author's replication presentation. The event was attended by about 60 people and included discussions with users with varied needs. ### Source excerpt The french PostgreSQL Conference, pgday.fr, was yesterday in Lyon. We had a very good time and a great schedule with a single track packed with 7 talks, addressing a diverse set of PostgreSQL related topics, from GIS to fuzzy logic, including replication. You might have guessed it already, I did talk about replication. Here's the slide deck I did use, it's in french, sorry if you don't grok that language. The conference was very nice and did go smoothly, even if we were "only" 60 of us I had the pleasure to meet with different users with very different set of needs. Very happy to have been there! ## PostgreSQL: Data is Important DevFeed: [PostgreSQL: Data is Important]() Original publisher: [Read original article]() Author: Square Engineering Published: 2011-06-06T16:00:00Z Content type: article Language: en Sources: [Square Corner Blog RSS Feed]() Topics: [PostgreSQL](), [SQL](), [Web](), [Replication](), [Geographic Information System]() Tags: [algorithms](), [architecture](), [consistency](), [data](), [durability](), [engineering](), [full-text-search](), [gis](), [postgresql](), [replication](), [search](), [sql](), [statement](), [types](), [web]() ### AI overview This article presents a case for using PostgreSQL in a modern web architecture. It describes PostgreSQL features including migration support, indexes, transactional DDL, constraints, streaming replication, query planning, PostGIS, and full-text search. ### Source excerpt A case for PostgreSQL in a modern web architecture.