Search Results

(updated September 2024 based on schema changes) Background MeshDB is an software application which replaces the New Node Responses Google Sheet (the spreadsheet) as the source of truth for NYCMesh member, install, geolocation, device, and connection infor...

These instructions are for creating API access for automated systems. For human users, see How to Onboard Users to MeshDB Adding a new user for an application Navigate to the admin portal at db.nycmesh.net/admin/ and select add user Make a new user specif...

These instructions are for creating administrator console access for human users. For automated systems, see How to onboard applications to MeshDB Adding a new user for admin console access Navigate to the admin portal at db.nycmesh.net/admin/ and select add...

These instructions detail how to provision many Install requests at once. Usually this is done at large buildings where the mesh serves many apartments. Often we install the equipment all at once during a renovation or construction without an explicit request ...

These instructions are only needed when precise control of the exact NN is required. Most installs should just use the standard network number assignment form  Network numbers uniquely identify devices on the NYC Mesh network. They are used to compute IP addr...

When constructing or editing Node objects, users are presented with the following fields: Since manually locating these coordinates is tedious, MeshDB is able to automatically populate these fields from the Building object. To use this feature, simply scrol...

To add potential hubs and links to the map using MeshDB, you must create the appropriate database objects. The right way to do this depends on the current state of the data in the database, and the desired outcome. This page summarizes how to do various common...

When an install is completed, there are a few items to confirm are correct in MeshDB so that we have accurate information and an up-to-date map: Confirm that a network number has been assigned to the install (this is probably already done by the installer, ...

When an install leaves the mesh, MeshDB needs to be kept up-to-date to ensure we have accurate member count and contact information.  If an install has just dropped offline for a few hours, no action is needed. MeshDB does not attempt to track the status of t...

So you want to build an application which interacts with MeshDB data. Great!  First, familiarize yourself with the data schema that we use at a high level. You likely don't need to get into the intricacies of the various edge cases, but read the first section...

The data in MeshDB is best viewed using the tooling available at db.nycmesh.net: Admin Panel: https://db.nycmesh.net/admin Legacy Query form: https://forms.nycmesh.net/query  SQL Explorer: https://db.nycmesh.net/explorer/play/ However, for some applica...

MeshDB tracks the changes to all objects from all actors. Any change via the admin panel, API, or any automated process, will trigger an entry in the History table. To view the history for an object, navigate to the edit view for that object in the admin panel...