<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<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 style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thanks Sandro.</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I will setup my account and start collaborating online.</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I have started playing with the code locally - including the test suite. Is there a way to run a particular test (or tests)? 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.</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div id="divtagdefaultwrapper" dir="ltr" style="font-family:Calibri, Arial, Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);background-color:rgb(255, 255, 255)">
<hr style="margin-right: 0px; margin-left: 0px;">
<div style="margin-right: 0px; margin-left: 0px; font-family: "Default Sans Serif", Verdana, Arial, Helvetica, sans-serif; font-size: 13px;">
<i>Thanks, </i></div>
<p style="margin: 0px;"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 13px;"><i><br>
</i></span></p>
<div style="margin: 0px; font-family: Arial, sans-serif; font-size: 10pt;"><b>Ayorinde Adesugba,
</b>Special Assistant to ADC,</div>
<div style="margin: 0px; font-family: Arial, sans-serif; font-size: 10pt;">Spatial Data Systems, DITD</div>
<div style="margin: 0px; font-family: Arial, sans-serif; font-size: 10pt;">U.S. Census Bureau </div>
<div style="margin: 0px; font-family: Arial, sans-serif; font-size: 10pt;">O: 301-763-2057 | M: 202-381-8034 | F: 301-763-4710 </div>
<div style="margin: 0px; font-family: Arial, sans-serif; font-size: 10pt;"><a href="mailto:ayorinde.o.adesugba@census.gov" id="OWA8999aa7f-9518-2886-d628-162ea3141ad3" class="OWAAutoLink">ayorinde.o.adesugba@census.gov</a> </div>
<div style="margin: 0px; font-family: Arial, sans-serif; font-size: 10pt;"><a href="http://www.census.gov/" target="_blank" id="OWAff397c04-9a64-cfb9-c7b1-a32334d33b4f" class="OWAAutoLink">census.gov</a> |
<a href="https://twitter.com/uscensusbureau" id="OWA7f880641-dcb7-7043-f476-b6fe665506c6" class="OWAAutoLink" title="https://twitter.com/uscensusbureau">
@uscensusbureau</a> | <a href="https://2020census.gov" id="OWA546b6b36-e9d5-9167-f86c-54856552ef73" class="OWAAutoLink" title="https://2020census.gov">
2020Census.gov</a></div>
<div style="margin: 0px; font-family: Arial, sans-serif; font-size: 10pt;">Connect with us on
<a href="http://www.census.gov/about/contact-us/social_media.html" target="_blank" id="OWAcc16fbc9-2ebc-175e-58d5-6124b5e34eb0" class="OWAAutoLink">
Social Media</a></div>
<p style="margin: 0px;"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 13px;"> </span></p>
</div>
</div>
<div id="appendonsend"></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> Sandro Santilli <strk@kbt.io><br>
<b>Sent:</b> Wednesday, March 19, 2025 06:01<br>
<b>To:</b> Ayorinde O Adesugba (CENSUS/DITD FED) <Ayorinde.O.Adesugba@census.gov><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>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">[You don't often get email from strk@kbt.io. Learn why this is important at
<a href="https://aka.ms/LearnAboutSenderIdentification">https://aka.ms/LearnAboutSenderIdentification</a> ]<br>
<br>
On Mon, Mar 17, 2025 at 11:52:20AM +0000, Ayorinde O Adesugba (CENSUS/DITD FED) wrote:<br>
<br>
> Thanks for the response. I do not have the authority to hire or<br>
> recommend a contracting company, but I am definitely open to contributing<br>
> time and code to make the topology extension better for all users.<br>
<br>
Good to hear !<br>
Could you maybe also help us improving the documentation ? it looks<br>
like the link to TIGER is broken on the PostGIS Manual (I guess Census<br>
US changed the URL of a page): <a href="https://trac.osgeo.org/postgis/ticket/5866">
https://trac.osgeo.org/postgis/ticket/5866</a><br>
<br>
> If you can send any links/documentation of the process - I can start<br>
> looking into it.<br>
<br>
I thought I answered this mail already but don't see it in my archive<br>
so here it is again:<br>
<br>
1. We plan things via Trac tickets so you'd start by stating you're<br>
working on an enhancement to switch topology primitive identifeirs<br>
to 64bit, with a comment to this 10 years old ticket:<br>
<a href="https://trac.osgeo.org/postgis/ticket/3110">https://trac.osgeo.org/postgis/ticket/3110</a><br>
<br>
2. To ease review from other PostGIS developers and the broader OSGeo<br>
developers community we prefer changes to be proposed via pull<br>
requests on the official git hoster here:<br>
<a href="https://git.osgeo.org/gitea/postgis/postgis">https://git.osgeo.org/gitea/postgis/postgis</a><br>
<br>
3. This mailing list can be used to gather comments / brainstorm or<br>
discussions that are not too specific to a proposed changeset.<br>
<br>
You'll see that in order to interact with Trac (point 1) and Gitea<br>
(point 2) you'll need an OSGeo UserID ( <a href="https://id.osgeo.org/">https://id.osgeo.org/</a> ).<br>
If you don't have one, register on <a href="https://id.osgeo.org/ldap/create">https://id.osgeo.org/ldap/create</a><br>
<br>
> I have made a few alterations to table definitions and<br>
> the topology.topogeometry type<br>
<br>
We'll need to provide proper upgrade paths, which is going to be the<br>
biggest task. And you'll need to learn a bit about the testsuite to<br>
provide tests to ensure thee bigger identifiers work.<br>
<br>
Happy hacking !<br>
<br>
--strk;<br>
</div>
</span></font></div>
</body>
</html>