Migrating TIGER from Oracle to POSTGIS

[Ayorinde O Adesugba (CENSUS/DITD FED)]

Census - General

Thanks Sandro.

I have completed my first pass at making all the changes, and regression tests all pass. I added a few particular ones to support 2 new features

  *
Ability to assign a user defined ID to the topology
  *
Ability to add a layer with a user defined ID. MAFTIGER already has defined layer IDs, and we cannot rely on a sequence to provide new ones each time we create a copy of the database.

Do you want me to submit a PR, so we can start reviewing and providing feedback?

I also need to discuss how the upgrade path will work out. I think the FACE, EDGE_DATA, NODE and RELATION tables are the 4 that need to be updated to allow INT8 IDs, but I maybe overlooking other upgrade items.


________________________________
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: Thursday, March 20, 2025 11:34
To: Ayorinde O Adesugba (CENSUS/DITD FED) <Ayorinde.O.Adesugba at census.gov>
Cc: lr at pcorp.us <lr at pcorp.us>; postgis-devel at lists.osgeo.org <postgis-devel at lists.osgeo.org>
Subject: Re: Migrating TIGER from Oracle to POSTGIS

On Wed, Mar 19, 2025 at 08:34:27PM +0000, Ayorinde O Adesugba (CENSUS/DITD FED) wrote:

> I am know getting some error related to edgering.
> It seems there is a mismatch in the recursive query with integer and int8.
> I will send the exact error but it seems like the GetFace3'Edges is calling into c code.

We do have C code that runs SQL, see topology/postgis_topology.c

--strk;
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20250320/cadb8694/attachment.htm>