Degrees of Connectivity

1st Degree

Installs connected directly to a node.

Examples with NN713:

In the Admin Panel, it would be listed in the "Installs" under a node: https://db.nycmesh.net/admin/meshapi/node/f6fdabaa-5537-431c-9c17-891451bcdaee/change/

SQL explorer Example: https://db.nycmesh.net/explorer/43/

2nd Degree: Nodes supported by a Node

Installs supported by a given node through one link.

Not really a way to do it in the Admin Panel directly, but you can check the "Links" table in an Install: https://db.nycmesh.net/admin/meshapi/node/f6fdabaa-5537-431c-9c17-891451bcdaee/change/

And then go through all the NNs listed there.

Without access to the OSPF data in the SQL Explorerexplorer, Example:it is impossible to get an accurate picture, since MeshDB alone has no concept of which nodes serve which. There is a ticket open to address this

Until that gets implemented, one thing you can do is this: To know which households a hub supports, put the NN into node explorer on this page: http://node-explorer.andrew.mesh.nycmesh.net/outage-analyzer?timestamp=

Then copy/paste the offline/rerouted NN lists into SQL explorer with this query: https://db.nycmesh.net/explorer/45/40/