[SCM] postgis.net branch website updated. clarity-final-188-g8d7838e

[git at osgeo.org]

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "postgis.net".

The branch, website has been updated
       via  8d7838eeda67e8481e5218795de3c389909980f9 (commit)
      from  59afecfb5f09b9ef4cf53049a1a87ae86d4c3f8d (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 8d7838eeda67e8481e5218795de3c389909980f9
Author: Regina Obe <lr at pcorp.us>
Date:   Mon Jun 22 16:50:09 2026 -0400

    PostGIS Tiger Geocoder 2025.1 release

diff --git a/content/news/2026/06-22_postgis-tiger-geocoder-2025.1.md b/content/news/2026/06-22_postgis-tiger-geocoder-2025.1.md
new file mode 100644
index 0000000..876ce05
--- /dev/null
+++ b/content/news/2026/06-22_postgis-tiger-geocoder-2025.1.md
@@ -0,0 +1,81 @@
+---
+title: PostGIS Tiger Geocoder 2025.1
+layout: post
+category: news
+tags: [release,tiger_geocoder, tiger-2025, tiger-2025.1]
+author: Regina Obe
+date: "2026-06-22"
+thumbnail:
+---
+
+The PostGIS development team is pleased to provide `postgis_tiger_geocoder` extension.
+This is the very first release since the break from the PostGIS core.
+This version requires PostgreSQL 16 and above and should work with any supported PostGIS version.
+
+PostGIS 3.6 series is the last series to include `postgis_tiger_geocoder`.
+PostGIS 3.7 will be shipped without `postgis_tiger_geocoder`.
+
+Moving forward `postgis_tiger_geocoder` has its own dedicated repo at [OSGeo Gitea postgis_tiger_geocoder](https://gitea.osgeo.org/postgis/postgis_tiger_geocoder)
+under the PostGIS org.
+
+The versioning model has also changed to be versioned based on the year of the [Census US Tiger dataset](https://www.census.gov/geographies/mapping-files/time-series/geo/tiger-line-file.html) that is current at time of it's release.
+
+<!--more-->
+
+* **2025.1** [source]({{< loc "postgis.release_source">}}/postgis_tiger_geocoder/postgis_tiger_geocoder-2025.1.tar.gz) [md5]({{< loc "postgis.dev_download">}}/postgis_tiger_geocoder/postgis_tiger_geocoder-2025.1.tar.gz.md5) [NEWS](https://gitea.osgeo.org/postgis/postgis_tiger_geocoder/src/tag/2025.1/NEWS.md) [README](https://gitea.osgeo.org/postgis/postgis_tiger_geocoder/src/tag/2025.1/README.md) [docs](https://gitea.osgeo.org/postgis/postgis_tiger_geocoder/src/tag/2025.1/postgis_tiger_geocoder.md)
+
+For installing, refer to [Installing the extension](https://gitea.osgeo.org/postgis/postgis_tiger_geocoder/src/tag/2025.1/README.md#installing-the-extension)
+
+If you are upgrading from an older release do:
+
+```sql
+ALTER EXTENSION postgis_tiger_geocoder UPDATE;
+```
+
+If you get an `ERROR:  extension "postgis_tiger_geocoder" has no update path from version "x to version "2025.1"`
+or you are upgrading from a development version, do:
+
+```sql
+ALTER EXTENSION postgis_tiger_geocoder UPDATE TO "ANY";
+ALTER EXTENSION postgis_tiger_geocoder UPDATE;
+```
+
+
+## Breaking Changes
+
+- Remove support for PostgreSQL < 16 (Regina Obe)
+- `postgis_tiger_geocoder` moved out of the main PostGIS tree into its own
+  repository during the PostGIS 3.7 cycle (Paul Ramsey, Regina Obe)
+- quote_ident tiger loader schema and table names (Paul Ramsey)
+- No longer set search path of database to include tiger.
+  Users are expected to do this themselves.
+- Refer to [README](https://gitea.osgeo.org/postgis/postgis_tiger_geocoder#readme) for guidance (Regina Obe)
+
+## Security
+
+- [GT-26](https://gitea.osgeo.org/postgis/postgis_tiger_geocoder/pulls/26), quote_ident tiger loader schema and table names (Paul Ramsey)
+- [GT-3](https://gitea.osgeo.org/postgis/postgis_tiger_geocoder/pulls/3), Prefix operators with system name space (Paul Ramsey)
+
+## Enhancements
+
+- [TR-6013](https://trac.osgeo.org/postgis/ticket/6013), update the geocoder to load TIGER 2025 data (Regina Obe)
+
+## Bug Fixes
+
+- [GT-2](https://gitea.osgeo.org/postgis/postgis_tiger_geocoder/issues/2), strip trailing country
+  names before built-in `normalize_address()` parsing
+- [GT-10](https://gitea.osgeo.org/postgis/postgis_tiger_geocoder/issues/10), support `SH` and compact
+  `SH121` input for state-highway geocoding
+- [GT-13](https://gitea.osgeo.org/postgis/postgis_tiger_geocoder/issues/13), generate SP-GiST indexes
+  for `missing_indexes_generate_script()` LIKE-search helpers
+- [GT-20](https://gitea.osgeo.org/postgis/postgis_tiger_geocoder/issues/20), escape user-provided address fragments before
+  interpolating them into `normalize_address()` regular expressions
+- [GT-24](https://gitea.osgeo.org/postgis/postgis_tiger_geocoder/pulls/24), create `tiger_data` schema from shell tiger loader scripts
+			  (Darafei Praliaskouski)
+- [TR-1599](https://trac.osgeo.org/postgis/ticket/1599), [73892dce](https://gitea.osgeo.org/postgis/postgis_tiger_geocoder/commit/73892dce), improve country-aware address normalization in `normalize_address()`
+  and related wrapper paths (Darafei Praliaskouski)
+- [TR-2459](https://trac.osgeo.org/postgis/ticket/2459), [73892dce](https://gitea.osgeo.org/postgis/postgis_tiger_geocoder/commit/73892dce), speed up `pagc_normalize_address()` by avoiding redundant wrapper
+  parsing while preserving ZIP+4 and country details from the structured parser
+  (Darafei Praliaskouski)
+- [TR-1461](https://trac.osgeo.org/postgis/ticket/1461), [73892dce](https://gitea.osgeo.org/postgis/postgis_tiger_geocoder/commit/73892dce), `geocode_intersection()` now tolerates irregular spacing in highway
+  names such as `I- 635` vs `I-635` (Darafei Praliaskouski)

-----------------------------------------------------------------------

Summary of changes:
 .../2026/06-22_postgis-tiger-geocoder-2025.1.md    | 81 ++++++++++++++++++++++
 1 file changed, 81 insertions(+)
 create mode 100644 content/news/2026/06-22_postgis-tiger-geocoder-2025.1.md


hooks/post-receive
-- 
postgis.net