<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body>
<p style="font-family:Calibri;font-size:10pt;color:#000000;margin:5pt;font-style:normal;font-weight:normal;text-decoration:none;" align="Center">
Census - General<br>
</p>
<br>
<div>
<div dir="ltr">Got it, thanks!</div>
<div dir="ltr"><br>
</div>
<div dir="ltr">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.</div>
</div>
<div id="ms-outlook-mobile-body-separator-line" dir="auto"><br>
</div>
<div id="ms-outlook-mobile-signature">
<div dir="ltr" style="">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;" dir="ltr"><font size="2" face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" style="line-height:1.5">
<hr style="border-left-width:medium;border-left-color:currentcolor;border-right-width:medium;border-right-color:currentcolor;width:361px">
</font></div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif;"><font size="2" face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" style="line-height:1.5"><em>Thanks,<span> </span></em></font></div>
<font size="2" style="font-family: Calibri, Arial, Helvetica, sans-serif; line-height: 1.5;">
<p style="margin-top:0px;margin-bottom:0px"><em><br>
</em></p>
<div style="margin:0px"><font size="2" face="Arial,sans-serif"><span style="font-size:10pt"><strong>Ayorinde Adesugba,<span> </span></strong>Special Assistant to ADC,</span></font></div>
<div style="margin:0px"><font size="2" face="Arial,sans-serif"><span style="font-size:10pt">Spatial Data Systems, DITD</span></font></div>
<div style="margin:0px"><font size="2" face="Arial,sans-serif"><span style="font-size:10pt">U.S. Census Bureau </span></font></div>
<div style="margin:0px"><font size="2" face="Arial,sans-serif"><span style="font-size:10pt">O:<span> </span><span dir="ltr" style="">301-763-2057</span></span></font><font size="2" face="Arial,sans-serif"><span style="font-size:10pt"> |</span></font><font size="2" face="Arial,sans-serif"><span style="font-size:10pt"><span> </span>M:<span> </span><span dir="ltr" style="">202-381-8034</span><span> </span>| </span></font><font size="2" face="Arial,sans-serif"><span style="font-size:10pt">F:<span> </span><span dir="ltr" style="">301-763-4710</span></span></font><font size="2" face="Arial,sans-serif"><span style="font-size:10pt"> </span></font></div>
<div style="margin:0px"><font size="2" face="Arial,sans-serif"><span style="font-size:10pt"><a href="mailto:ayorinde.o.adesugba@census.gov" data-auth="NotApplicable" style="">ay</a><a href="mailto:ayorinde.o.adesugba@census.gov" data-auth="NotApplicable" style="">orinde.o.adesugba@census.gov</a> </span></font></div>
<div style="margin:0px"><font size="2" face="Arial,sans-serif"><span style="font-size:10pt"><a href="http://www.census.gov/" data-auth="NotApplicable" style="">census.gov</a> |<span> </span><a href="https://twitter.com/uscensusbureau" data-auth="NotApplicable" title="https://twitter.com/uscensusbureau" style="">@uscensusbureau</a></span></font><font size="2" face="Arial,sans-serif"><span style="font-size:10pt">
|<span> </span><a href="https://2020census.gov/" data-auth="NotApplicable" title="https://2020census.gov" style="">2020Census.gov</a></span></font></div>
<span style="margin:0px"><font size="2" face="Arial,sans-serif"><span style="font-size:10pt">Connect with us on<span> </span></span></font><a href="http://www.census.gov/about/contact-us/social_media.html" data-auth="NotApplicable" style=""><font size="2" face="Arial,sans-serif"><span style="font-size:10pt">Social
Media</span></font></a></span></font><br>
</div>
</div>
<br>
<p style="font-family:Calibri;font-size:10pt;color:#000000;margin:5pt;font-style:normal;font-weight:normal;text-decoration:none;" align="Center">
Census - General<br>
</p>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> lr@pcorp.us <lr@pcorp.us><br>
<b>Sent:</b> Wednesday, March 19, 2025 4:29:29 PM<br>
<b>To:</b> Ayorinde O Adesugba (CENSUS/DITD FED) <Ayorinde.O.Adesugba@census.gov>; 'Sandro Santilli' <strk@kbt.io><br>
<b>Cc:</b> postgis-devel@lists.osgeo.org <postgis-devel@lists.osgeo.org><br>
<b>Subject:</b> RE: Migrating TIGER from Oracle to POSTGIS</font>
<div> </div>
</div>
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
@font-face
{font-family:Verdana}
@font-face
{font-family:Aptos}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0in;
font-size:12.0pt;
font-family:"Aptos",sans-serif}
a:link, span.x_MsoHyperlink
{color:blue;
text-decoration:underline}
span.x_EmailStyle20
{font-family:"Aptos",sans-serif;
color:windowtext}
.x_MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:1.0in 1.0in 1.0in 1.0in}
div.x_WordSection1
{}
-->
</style>
<div lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<table border="0" cellspacing="0" cellpadding="0" width="100%" align="left" style="background:revert!important; border:revert!important; bottom:revert!important; color:revert!important; direction:revert!important; display:revert!important; font-size:revert!important; height:revert!important; letter-spacing:revert!important; line-height:revert!important; margin:revert!important; opacity:revert!important; order:revert!important; outline:revert!important; overflow:revert!important; padding:revert!important; position:revert!important; tab-size:revert!important; table-layout:revert!important; text-align:revert!important; text-indent:revert!important; text-orientation:revert!important; text-overflow:revert!important; text-transform:revert!important; top:revert!important; vertical-align:revert!important; visibility:revert!important; white-space:revert!important; width:revert!important; word-break:revert!important; word-spacing:revert!important; writing-mode:revert!important; zoom:revert!important; border:0!important; display:table!important; width:100%!important; table-layout:fixed!important; border-collapse:seperate!important; float:none!important; border-spacing:0px 0px!important">
<tbody style="background:revert!important; border:revert!important; bottom:revert!important; color:revert!important; direction:revert!important; display:revert!important; font-size:revert!important; height:revert!important; letter-spacing:revert!important; line-height:revert!important; margin:revert!important; opacity:revert!important; order:revert!important; outline:revert!important; overflow:revert!important; padding:revert!important; position:revert!important; tab-size:revert!important; table-layout:revert!important; text-align:revert!important; text-indent:revert!important; text-orientation:revert!important; text-overflow:revert!important; text-transform:revert!important; top:revert!important; vertical-align:revert!important; visibility:revert!important; white-space:revert!important; width:revert!important; word-break:revert!important; word-spacing:revert!important; writing-mode:revert!important; zoom:revert!important; display:block!important">
<tr style="background:revert!important; border:revert!important; bottom:revert!important; color:revert!important; direction:revert!important; display:revert!important; font-size:revert!important; height:revert!important; letter-spacing:revert!important; line-height:revert!important; margin:revert!important; opacity:revert!important; order:revert!important; outline:revert!important; overflow:revert!important; padding:revert!important; position:revert!important; tab-size:revert!important; table-layout:revert!important; text-align:revert!important; text-indent:revert!important; text-orientation:revert!important; text-overflow:revert!important; text-transform:revert!important; top:revert!important; vertical-align:revert!important; visibility:revert!important; white-space:revert!important; width:revert!important; word-break:revert!important; word-spacing:revert!important; writing-mode:revert!important; zoom:revert!important">
<td valign="middle" width="1px" bgcolor="#A6A6A6" cellpadding="7px 2px 7px 2px" style="background:revert!important; border:revert!important; bottom:revert!important; color:revert!important; direction:revert!important; display:revert!important; font-size:revert!important; height:revert!important; letter-spacing:revert!important; line-height:revert!important; margin:revert!important; opacity:revert!important; order:revert!important; outline:revert!important; overflow:revert!important; padding:revert!important; position:revert!important; tab-size:revert!important; table-layout:revert!important; text-align:revert!important; text-indent:revert!important; text-orientation:revert!important; text-overflow:revert!important; text-transform:revert!important; top:revert!important; vertical-align:revert!important; visibility:revert!important; white-space:revert!important; width:revert!important; word-break:revert!important; word-spacing:revert!important; writing-mode:revert!important; zoom:revert!important; padding:7px 2px 7px 2px!important; background-color:#A6A6A6!important; width:0px!important">
</td>
<td valign="middle" width="100%" bgcolor="#EAEAEA" cellpadding="7px 5px 7px 15px" color="#212121" style="background:revert!important; border:revert!important; bottom:revert!important; color:revert!important; direction:revert!important; display:revert!important; font-size:revert!important; height:revert!important; letter-spacing:revert!important; line-height:revert!important; margin:revert!important; opacity:revert!important; order:revert!important; outline:revert!important; overflow:revert!important; padding:revert!important; position:revert!important; tab-size:revert!important; table-layout:revert!important; text-align:revert!important; text-indent:revert!important; text-orientation:revert!important; text-overflow:revert!important; text-transform:revert!important; top:revert!important; vertical-align:revert!important; visibility:revert!important; white-space:revert!important; width:revert!important; word-break:revert!important; word-spacing:revert!important; writing-mode:revert!important; zoom:revert!important; width:100%!important; background-color:#EAEAEA!important; padding:7px 5px 7px 15px!important; font-family:wf_segoe-ui_normal,Segoe UI,Segoe WP,Tahoma,Arial,sans-serif!important; font-size:12px!important; font-weight:normal!important; color:#212121!important; text-align:left!important; word-wrap:break-word!important">
<div style="background:revert!important; border:revert!important; bottom:revert!important; color:revert!important; direction:revert!important; display:revert!important; font-size:revert!important; height:revert!important; letter-spacing:revert!important; line-height:revert!important; margin:revert!important; opacity:revert!important; order:revert!important; outline:revert!important; overflow:revert!important; padding:revert!important; position:revert!important; tab-size:revert!important; table-layout:revert!important; text-align:revert!important; text-indent:revert!important; text-orientation:revert!important; text-overflow:revert!important; text-transform:revert!important; top:revert!important; vertical-align:revert!important; visibility:revert!important; white-space:revert!important; width:revert!important; word-break:revert!important; word-spacing:revert!important; writing-mode:revert!important; zoom:revert!important">
You don't often get email from lr@pcorp.us. <a href="https://aka.ms/LearnAboutSenderIdentification" style="background:revert!important; color:revert!important; direction:revert!important; display:revert!important; font-size:revert!important; opacity:revert!important; visibility:revert!important">
Learn why this is important</a> </div>
</td>
<td valign="middle" align="left" width="75px" bgcolor="#EAEAEA" cellpadding="7px 5px 7px 5px" color="#212121" style="background:revert!important; border:revert!important; bottom:revert!important; color:revert!important; direction:revert!important; display:revert!important; font-size:revert!important; height:revert!important; letter-spacing:revert!important; line-height:revert!important; margin:revert!important; opacity:revert!important; order:revert!important; outline:revert!important; overflow:revert!important; padding:revert!important; position:revert!important; tab-size:revert!important; table-layout:revert!important; text-align:revert!important; text-indent:revert!important; text-orientation:revert!important; text-overflow:revert!important; text-transform:revert!important; top:revert!important; vertical-align:revert!important; visibility:revert!important; white-space:revert!important; width:revert!important; word-break:revert!important; word-spacing:revert!important; writing-mode:revert!important; zoom:revert!important; width:75px!important; background-color:#EAEAEA!important; padding:7px 5px 7px 5px!important; font-family:wf_segoe-ui_normal,Segoe UI,Segoe WP,Tahoma,Arial,sans-serif!important; font-size:12px!important; font-weight:normal!important; color:#212121!important; text-align:left!important; word-wrap:break-word!important">
</td>
</tr>
</tbody>
</table>
<div>
<div class="x_WordSection1">
<p class="x_MsoNormal">The topology_comments.sql is autogenerated from the xml docs.</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">To fix it, you need to fix the references in the docs <a href="https://git.osgeo.org/gitea/postgis/postgis/src/branch/master/doc/extras_topology.xml">
https://git.osgeo.org/gitea/postgis/postgis/src/branch/master/doc/extras_topology.xml</a></p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">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</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"><a href="https://postgis.net/docs/manual-dev/en/ST_NewEdgesSplit.html">https://postgis.net/docs/manual-dev/en/ST_NewEdgesSplit.html</a></p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal">Need to change the input integer to bigint and the output to bigint, though the
</p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"><a href="https://git.osgeo.org/gitea/postgis/postgis/src/branch/master/doc/extras_topology.xml#L2271">https://git.osgeo.org/gitea/postgis/postgis/src/branch/master/doc/extras_topology.xml#L2271</a></p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"> </p>
<div style="border:none; border-left:solid blue 1.5pt; padding:0in 0in 0in 4.0pt">
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_MsoNormal"><b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif"> Ayorinde O Adesugba (CENSUS/DITD FED) <Ayorinde.O.Adesugba@census.gov>
<br>
<b>Sent:</b> Wednesday, March 19, 2025 1:44 PM<br>
<b>To:</b> Sandro Santilli <strk@kbt.io><br>
<b>Cc:</b> postgis-devel@lists.osgeo.org<br>
<b>Subject:</b> Re: Migrating TIGER from Oracle to POSTGIS</span></p>
</div>
</div>
<p class="x_MsoNormal"> </p>
<p align="center" style="margin:5.0pt; text-align:center"><span style="font-size:10.0pt; font-family:"Calibri",sans-serif; color:black">Census - General</span></p>
<p class="x_MsoNormal"> </p>
<div>
<p class="x_MsoNormal"><span style="color:black">Thanks.</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="color:black"> </span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="color:black">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.</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="color:black"> </span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="color:black">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.</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="color:black"> </span></p>
</div>
<div id="x_Signature">
<div id="x_divtagdefaultwrapper">
<div class="x_MsoNormal" align="center" style="text-align:center; background:white">
<span style="font-family:"Calibri",sans-serif; color:black">
<hr size="2" width="100%" align="center">
</span></div>
<div>
<p class="x_MsoNormal" style="background:white"><i><span style="font-size:10.0pt; font-family:"Verdana",sans-serif; color:black">Thanks,
</span></i><span style="font-size:10.0pt; font-family:"Verdana",sans-serif; color:black"></span></p>
</div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif; color:black"> </span></p>
<div>
<p class="x_MsoNormal" style="background:white"><b><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:black">Ayorinde Adesugba,
</span></b><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:black">Special Assistant to ADC,</span></p>
</div>
<div>
<p class="x_MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:black">Spatial Data Systems, DITD</span></p>
</div>
<div>
<p class="x_MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:black">U.S. Census Bureau </span></p>
</div>
<div>
<p class="x_MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:black">O: 301-763-2057 | M: 202-381-8034 | F: 301-763-4710 </span></p>
</div>
<div>
<p class="x_MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:black"><a href="mailto:ayorinde.o.adesugba@census.gov">ayorinde.o.adesugba@census.gov</a> </span></p>
</div>
<div>
<p class="x_MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:black"><a href="http://www.census.gov/" target="_blank">census.gov</a> |
<a href="https://twitter.com/uscensusbureau" title="https://twitter.com/uscensusbureau">
@uscensusbureau</a> | <a href="https://2020census.gov" title="https://2020census.gov">
2020Census.gov</a></span></p>
</div>
<div>
<p class="x_MsoNormal" style="background:white"><span style="font-size:10.0pt; font-family:"Arial",sans-serif; color:black">Connect with us on
<a href="http://www.census.gov/about/contact-us/social_media.html" target="_blank">
Social Media</a></span></p>
</div>
<p style="background:white"><span style="font-size:10.0pt; font-family:"Calibri",sans-serif; color:black"> </span><span style="font-family:"Calibri",sans-serif; color:black"></span></p>
</div>
</div>
<p class="x_MsoNormal"> </p>
<p align="center" style="margin:5.0pt; text-align:center"><span style="font-size:10.0pt; font-family:"Calibri",sans-serif; color:black">Census - General</span></p>
<div class="x_MsoNormal" align="center" style="text-align:center">
<hr size="2" width="98%" align="center">
</div>
<div id="x_divRplyFwdMsg">
<p class="x_MsoNormal"><b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black">From:</span></b><span style="font-size:11.0pt; font-family:"Calibri",sans-serif; color:black"> Sandro Santilli <<a href="mailto:strk@kbt.io">strk@kbt.io</a>><br>
<b>Sent:</b> Wednesday, March 19, 2025 13:18<br>
<b>To:</b> Ayorinde O Adesugba (CENSUS/DITD FED) <<a href="mailto:Ayorinde.O.Adesugba@census.gov">Ayorinde.O.Adesugba@census.gov</a>><br>
<b>Cc:</b> <a href="mailto:postgis-devel@lists.osgeo.org">postgis-devel@lists.osgeo.org</a> <<a href="mailto:postgis-devel@lists.osgeo.org">postgis-devel@lists.osgeo.org</a>><br>
<b>Subject:</b> Re: Migrating TIGER from Oracle to POSTGIS</span> </p>
<div>
<p class="x_MsoNormal"> </p>
</div>
</div>
<div>
<div>
<p class="x_MsoNormal"><span style="font-size:11.0pt">On Wed, Mar 19, 2025 at 12:02:36PM +0000, Ayorinde O Adesugba (CENSUS/DITD FED) wrote:<br>
<br>
> Is there a way to run a particular test (or tests)?<br>
<br>
For Topology we only have "regress tests", which can be run with the<br>
regress/run_test.pl script (run with no args to get help text)<br>
<br>
Example run of a single test from a build dir:<br>
<br>
${srcdir}/regress/run_test.pl \<br>
--topology \<br>
-v \<br>
${srcdir}/topology/test/regress/createtopology<br>
<br>
You'll need to have run `make staged-install` before, for the test<br>
script to find the postgis libraries and enabler scripts.<br>
<br>
> I am trying to modify a particular test, and it would be great<br>
> to focus on that test rather than kicking off the full suite.<br>
<br>
Makes sense.<br>
<br>
--strk;</span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>