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 explorer, 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: https://github.com/nycmeshnet/meshdb/issues/639

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/40/