<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div><style></style></div><div>Our NG911 seems to work the same way as traditional E911, just over SIP instead of TDM.</div><div data-marker="__SIG_PRE__"><br><br>-----<br>Mike Hammett<br>Intelligent Computing Solutions<br>http://www.ics-il.com<br><br><br><br>Midwest Internet Exchange<br>http://www.midwest-ix.com<br><br></div><div><br></div><hr id="zwchr" data-marker="__DIVIDER__"><div data-marker="__HEADERS__"><b>From: </b>"Nathan Anderson" <nathana@fsr.com><br><b>To: </b>"Mike Hammett" <voiceops@ics-il.net><br><b>Cc: </b>"voiceops" <voiceops@voiceops.org><br><b>Sent: </b>Tuesday, October 18, 2022 7:17:42 PM<br><b>Subject: </b>RE: [VoiceOps] 911 Database Stuff<br></div><div><br></div><div data-marker="__QUOTED_TEXT__"><div><p class="MsoNormal"><span style="font-size:11pt;font-family:'calibri' ,;color:#1f497d">I still am not completely up to speed on the NG911 stuff admittedly, so take with grain of salt & whoever is in the know please educate me, but...</span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:'calibri' ,;color:#1f497d"> </span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:'calibri' ,;color:#1f497d">My understanding has always been that E911 database cruft is not a big deal because each E911 aggregator essentially maintains their own database, and the lookups are done at the time of the 911 call & the source of the call is taken into account (however the carrier is trunked to the E911 SP; e.g., the particular SIP peer if trunking between carrier and E911 provider is done via IP), so even if two carriers use the same E911 aggregator and have conflicting entries for the same TN in their database, the correct address will still get sent to the PSAP, because the query that's executed isn't <i>merely</i> "where TN = xxx" but is the equivalent of "where account = yyy and TN = xxx".</span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:'calibri' ,;color:#1f497d"> </span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:'calibri' ,;color:#1f497d">For NG911, wasn't pre-provisioning & a central(-ish) database done away with anyway, with the address being transmitted by the endpoint itself at the moment it places the call? (Not sure how or if this works with circuit-switched/SS7, but at least with SIP I think the endpoint just transmits it as an XML payload in the SIP INVITE, or something along those lines.)</span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:'calibri' ,;color:#1f497d"> </span></p><p class="MsoNormal"><span style="font-size:11pt;font-family:'calibri' ,;color:#1f497d">-- Nathan</span></p><p class="MsoNormal"><a name="_MailEndCompose"><span style="font-size:11pt;font-family:'calibri' ,;color:#1f497d"> </span></a></p><div><div style="border:none;border-top:solid #b5c4df 1pt;padding:3pt 0in 0in 0in"><p class="MsoNormal"><b><span style="font-size:10pt;font-family:'tahoma' ,">From:</span></b><span style="font-size:10pt;font-family:'tahoma' ,"> VoiceOps [mailto:voiceops-bounces@voiceops.org] <b>On Behalf Of </b>Mike Hammett via VoiceOps<br><b>Sent:</b> Tuesday, October 18, 2022 3:22 PM<br><b>To:</b> voiceops@voiceops.org<br><b>Subject:</b> [VoiceOps] 911 Database Stuff</span></p></div></div><p class="MsoNormal"> </p><div><p class="MsoNormal"><span style="font-size:10pt;font-family:'arial' ,;color:black">Going through a migration from E911 to NG911, I've been peering into what and how we do 911, both old and new. </span></p><div><p class="MsoNormal"><span style="font-size:10pt;font-family:'arial' ,;color:black"> </span></p></div><div><p class="MsoNormal"><span style="font-size:10pt;font-family:'arial' ,;color:black">A) Not all services have a web UI for you to make changes. Intrado does, but the new one does not. Only way is to upload SOI files. I guess we gotta figure out how to do that.</span></p></div><div><p class="MsoNormal"><span style="font-size:10pt;font-family:'arial' ,;color:black">B) We have more entries than we have TNs.</span></p></div><div><p class="MsoNormal"><span style="font-size:10pt;font-family:'arial' ,;color:black">C) People are bad at documentation.</span></p></div><div><p class="MsoNormal"><span style="font-size:10pt;font-family:'arial' ,;color:black"> </span></p></div><div><p class="MsoNormal"><span style="font-size:10pt;font-family:'arial' ,;color:black">I'm assuming we should be deleting records for customers that disconnected service. I'm not sure we've done that, based on the records that I see.</span></p></div><div><p class="MsoNormal"><span style="font-size:10pt;font-family:'arial' ,;color:black">For customers that port away, I'm assuming we're supposed to be unlocking the TN for the new provider to take over the record.</span></p></div><div><p class="MsoNormal"><span style="font-size:10pt;font-family:'arial' ,;color:black">If I unlock it, but the new provider never migrates away, what do I do with it?</span></p></div><div><p class="MsoNormal"><span style="font-size:10pt;font-family:'arial' ,;color:black">What happens if a provider inserts a duplicate record?</span></p></div><div><p class="MsoNormal"><span style="font-size:10pt;font-family:'arial' ,;color:black"> </span></p><div><p class="MsoNormal"><span style="font-size:10pt;font-family:'arial' ,;color:black"><br><br>-----<br>Mike Hammett<br>Intelligent Computing Solutions<br><a href="http://www.ics-il.com" target="_blank" rel="nofollow noopener noreferrer">http://www.ics-il.com</a><br><br><br><br>Midwest Internet Exchange<br><a href="http://www.midwest-ix.com" target="_blank" rel="nofollow noopener noreferrer">http://www.midwest-ix.com</a><br><br><br></span></p></div><p class="MsoNormal"><span style="font-size:10pt;font-family:'arial' ,;color:black"> </span></p></div></div></div><br></div></div></body></html>