Migrating TIGER from Oracle to POSTGIS

[Sandro Santilli]

On Mon, Mar 17, 2025 at 11:52:20AM +0000, Ayorinde O Adesugba (CENSUS/DITD FED) wrote:

> Thanks for the response. I do not have the authority to hire or
> recommend a contracting company, but I am definitely open to contributing
> time and code to make the topology extension better for all users.

Good to hear !
Could you maybe also help us improving the documentation ? it looks
like the link to TIGER is broken on the PostGIS Manual (I guess Census
US changed the URL of a page): https://trac.osgeo.org/postgis/ticket/5866

> If you can send any links/documentation of the process - I can start
> looking into it.

I thought I answered this mail already but don't see it in my archive
so here it is again:

  1. We plan things via Trac tickets so you'd start by stating you're
     working on an enhancement to switch topology primitive identifeirs
     to 64bit, with a comment to this 10 years old ticket:
     https://trac.osgeo.org/postgis/ticket/3110

  2. To ease review from other PostGIS developers and the broader OSGeo 
     developers community we prefer changes to be proposed via pull
     requests on the official git hoster here:
     https://git.osgeo.org/gitea/postgis/postgis

  3. This mailing list can be used to gather comments / brainstorm or
     discussions that are not too specific to a proposed changeset.

You'll see that in order to interact with Trac (point 1) and Gitea
(point 2) you'll need an OSGeo UserID ( https://id.osgeo.org/ ).
If you don't have one, register on https://id.osgeo.org/ldap/create

> I have made a few alterations to table definitions and
> the topology.topogeometry type

We'll need to provide proper upgrade paths, which is going to be the
biggest task. And you'll need to learn a bit about the testsuite to
provide tests to ensure thee bigger identifiers work.

Happy hacking !

--strk;