Migrating TIGER from Oracle to POSTGIS

[lr at pcorp.us]

Yes submitting a PR would be great.

 

From: Ayorinde O Adesugba (CENSUS/DITD FED) <Ayorinde.O.Adesugba at census.gov>

Sent: Thursday, March 20, 2025 12:43 PM
To: 'Sandro Santilli' <strk at kbt.io>
Cc: lr at pcorp.us; postgis-devel at lists.osgeo.org
Subject: Re: Migrating TIGER from Oracle to POSTGIS

 

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 <mailto:strk at kbt.io> >
Sent: Thursday, March 20, 2025 11:34
To: Ayorinde O Adesugba (CENSUS/DITD FED) <Ayorinde.O.Adesugba at census.gov
<mailto:Ayorinde.O.Adesugba at census.gov> >
Cc: lr at pcorp.us <mailto:lr at pcorp.us>  <lr at pcorp.us <mailto:lr at pcorp.us> >;
postgis-devel at lists.osgeo.org <mailto:postgis-devel at lists.osgeo.org>
<postgis-devel at lists.osgeo.org <mailto: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/94d029c7/attachment-0001.htm>