Migrating TIGER from Oracle to POSTGIS

[Ayorinde O Adesugba (CENSUS/DITD FED)]

Census - General

Thanks Sandro.

I will setup my account and start collaborating online.

I have started playing with the code locally - including the test suite. Is there a way to run a particular test (or tests)? I am trying to modify a particular test, and it would be great to focus on that test rather than kicking off the full suite.

________________________________
Thanks,


Ayorinde Adesugba, Special Assistant to ADC,
Spatial Data Systems, DITD
U.S. Census Bureau
O: 301-763-2057 | M: 202-381-8034 | F: 301-763-4710
ayorinde.o.adesugba at census.gov<mailto:ayorinde.o.adesugba at census.gov>
census.gov<http://www.census.gov/> | @uscensusbureau<https://twitter.com/uscensusbureau>  | 2020Census.gov<https://2020census.gov>
Connect with us on Social Media<http://www.census.gov/about/contact-us/social_media.html>




Census - General

________________________________
From: Sandro Santilli <strk at kbt.io>
Sent: Wednesday, March 19, 2025 06:01
To: Ayorinde O Adesugba (CENSUS/DITD FED) <Ayorinde.O.Adesugba at census.gov>
Cc: postgis-devel at lists.osgeo.org <postgis-devel at lists.osgeo.org>
Subject: Re: Migrating TIGER from Oracle to POSTGIS

[You don't often get email from strk at kbt.io. Learn why this is important at https://aka.ms/LearnAboutSenderIdentification ]

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;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20250319/e86c81c7/attachment.htm>