Skip to main content
Advanced Search
Search Terms
Content Type

Exact Matches
Tag Searches
Date Options
Updated after
Updated before
Created after
Created before

Search Results

14 total results found

MeshDB Schema Design

6 - Services & Software MeshDB

(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

6 - Services & Software 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

6 - Services & Software 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

6 - Services & Software MeshDB

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

6 - Services & Software MeshDB

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

6 - Services & Software MeshDB

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

6 - Services & Software MeshDB

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

6 - Services & Software MeshDB

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

6 - Services & Software MeshDB

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

6 - Services & Software MeshDB

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

6 - Services & Software MeshDB

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

6 - Services & Software 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?

6 - Services & Software MeshDB

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

2 - Install & Maintenance Guides

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...