<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Aptos;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:12.0pt;
font-family:"Aptos",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:2114200526;
mso-list-template-ids:-1363494492;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal>Yes submitting a PR would be great.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></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=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> Thursday, March 20, 2025 12:43 PM<br><b>To:</b> 'Sandro Santilli' <strk@kbt.io><br><b>Cc:</b> lr@pcorp.us; postgis-devel@lists.osgeo.org<br><b>Subject:</b> Re: Migrating TIGER from Oracle to POSTGIS<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></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<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal><span style='color:black'>Thanks Sandro.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='color:black'>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<o:p></o:p></span></p></div><div><ul type=disc><li class=MsoNormal style='color:black;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1;list-style-type:"- "'>Ability to assign a user defined ID to the topology<o:p></o:p></li></ul></div><div><ul type=disc><li class=MsoNormal style='color:black;mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo1;list-style-type:"- "'>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.<o:p></o:p></li></ul></div><div><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='color:black'>Do you want me to submit a PR, so we can start reviewing and providing feedback? <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='color:black'>I also need to discuss how the upgrade path will work out. I think the <b>FACE</b>, <b>EDGE_DATA</b>, <b>NODE </b>and <b>RELATION </b>tables are the 4 that need to be updated to allow INT8 IDs, but I maybe overlooking other upgrade items.<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='color:black'><o:p> </o:p></span></p></div><div id=Signature><div id=divtagdefaultwrapper><div class=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=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'><o:p></o:p></span></p></div><p style='background:white'><span style='font-family:"Calibri",sans-serif;color:black'><o:p> </o:p></span></p><div><p class=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,<o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:black'>Spatial Data Systems, DITD<o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='font-size:10.0pt;font-family:"Arial",sans-serif;color:black'>U.S. Census Bureau <o:p></o:p></span></p></div><div><p class=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 <o:p></o:p></span></p></div><div><p class=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> <o:p></o:p></span></p></div><div><p class=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><o:p></o:p></span></p></div><div><p class=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><o:p></o:p></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'><o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></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<o:p></o:p></span></p><div class=MsoNormal align=center style='text-align:center'><hr size=2 width="98%" align=center></div><div id=divRplyFwdMsg><p class=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> Thursday, March 20, 2025 11:34<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:lr@pcorp.us">lr@pcorp.us</a> <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>>; <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> <o:p></o:p></p><div><p class=MsoNormal> <o:p></o:p></p></div></div><div><div><p class=MsoNormal><span style='font-size:11.0pt'>On Wed, Mar 19, 2025 at 08:34:27PM +0000, Ayorinde O Adesugba (CENSUS/DITD FED) wrote:<br><br>> I am know getting some error related to edgering.<br>> It seems there is a mismatch in the recursive query with integer and int8.<br>> I will send the exact error but it seems like the GetFace3'Edges is calling into c code.<br><br>We do have C code that runs SQL, see topology/postgis_topology.c<br><br>--strk;<o:p></o:p></span></p></div></div></div></div></body></html>