nycmeshnet / meshdb

A convenient, stable, and sane database for tracking Members and Nodes for use with robots and humans
https://db.nycmesh.net
MIT License
12 stars 14 forks source link

Some buildings have Nodes without primary nodes #563

Closed Andrew-Dickinson closed 2 months ago

Andrew-Dickinson commented 2 months ago

440 West 34th Street has NN363 as a node but has no primary node. That should not be possible

Andrew-Dickinson commented 2 months ago

Do a DB query to see how common this is

Andrew-Dickinson commented 2 months ago

Hmm looks like it only happens 7 times in the whole dataset

Andrew-Dickinson commented 2 months ago

Ah! Found it! Slight issue with how the BIN <-> Node mapping is done for NN assigned rows

Andrew-Dickinson commented 2 months ago

Resolved via #583