Advanced Search
Search Results
14 total results found
MeshDB Schema Design
(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...
How to onboard API clients to MeshDB
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...
How to Onboard Users to MeshDB
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...
How to bulk create installs for large buildings
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 ...
How to assign a "vanity" network number
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...
How to avoid manually entering latitude/longitude/altitude when constructing Node objects
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...
How to add potential Hubs and Links to the map
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...
How to update MeshDB when an install is completed
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, ...
How to update MeshDB to indicate the loss of an install
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...
New Application Integration Guide
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...
How to Import/Export CSV files of MeshDB data
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...
How to View the Edit History for an Object in MeshDB
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...
The install I'm creating doesn't have a good email, what do I do?
In the case of institutional installs at large or small hubs, or when creating an install before a tenant moves in it is often required that we provision an install number before an email address is available. In these cases, it is tempting to manually the cre...
How to use an EoIP tunnel to send your device's traffic to another part of the mesh
In some situations, such as when troubleshooting traffic paths, or trying to bypass a LinkNYC captive portal, it is useful to send "interactive" traffic from a personal device such as a laptop or phone. This is also useful when trying to asses a qualitative se...