Migrating TIGER from Oracle to POSTGIS

[lr at pcorp.us]

No it will not affect the C code.  So if the C code doesn't handle int8, it
still needs to be fixed.

 

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

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

 

Census - General

 

Got it, thanks!

 

Will this change affect the c code? 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.

 

  _____  

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   

ay <mailto:ayorinde.o.adesugba at census.gov> orinde.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
<http://www.census.gov/about/contact-us/social_media.html> Social Media

 

Census - General

  _____  

From: lr at pcorp.us <mailto:lr at pcorp.us>  <lr at pcorp.us <mailto:lr at pcorp.us> >
Sent: Wednesday, March 19, 2025 4:29:29 PM
To: Ayorinde O Adesugba (CENSUS/DITD FED) <Ayorinde.O.Adesugba at census.gov
<mailto:Ayorinde.O.Adesugba at census.gov> >; 'Sandro Santilli' <strk at kbt.io>
Cc: 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 

 

	
You don't often get email from lr at pcorp.us <mailto:lr at pcorp.us> . Learn why
this is important <https://aka.ms/LearnAboutSenderIdentification>  

	

The topology_comments.sql is autogenerated from the xml docs.

 

To fix it, you need to fix the references in the docs
https://git.osgeo.org/gitea/postgis/postgis/src/branch/master/doc/extras_top
ology.xml

 

e.g. I am not sure which one you are working on but for example this one if
you needed the edge to be bigint

 

https://postgis.net/docs/manual-dev/en/ST_NewEdgesSplit.html

 

Need to change the input integer to bigint  and the output to bigint, though
the 

 

https://git.osgeo.org/gitea/postgis/postgis/src/branch/master/doc/extras_top
ology.xml#L2271

 

 

 

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

 

Census - General

 

Thanks.

 

I am facing a more interesting challenge. The topology_comments.sql needs to
be updated, so that it references int8 (bigint) instead of integer for a few
functions that need to be updated.

 

How do I trigger the comment rebuild. I have been stuck on a test for over
2/3 hours cause the comment on the function no longer lines up with the new
signature for the function.

 

  _____  

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: Wednesday, March 19, 2025 13:18
To: Ayorinde O Adesugba (CENSUS/DITD FED) <Ayorinde.O.Adesugba at census.gov
<mailto:Ayorinde.O.Adesugba at census.gov> >
Cc: 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 12:02:36PM +0000, Ayorinde O Adesugba (CENSUS/DITD
FED) wrote:

> Is there a way to run a particular test (or tests)?

For Topology we only have "regress tests", which can be run with the
regress/run_test.pl script (run with no args to get help text)

Example run of a single test from a build dir:

  ${srcdir}/regress/run_test.pl \
    --topology \
    -v \
    ${srcdir}/topology/test/regress/createtopology

You'll need to have run `make staged-install` before, for the test
script to find the postgis libraries and enabler scripts.

> 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.

Makes sense.

--strk;

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20250319/d35435d1/attachment-0001.htm>