building_networks

14 rows where network_id = "2.3"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link building network_id
100454388,2.3 100454388 Mall Channel 2.3
ESC,2.3 ESC Mall Channel 2.3
I-SAW-WBQ,2.3 I-SAW-WBQ Mall Channel 2.3
MALL-W1H_p,2.3 MALL-W1H_p Mall Channel 2.3
STM-100363526,2.3 STM-100363526 Mall Channel 2.3
STM-100363528,2.3 STM-100363528 Mall Channel 2.3
STM-100363537,2.3 STM-100363537 Mall Channel 2.3
STM-100363544,2.3 STM-100363544 Mall Channel 2.3
STM-100363556,2.3 STM-100363556 Mall Channel 2.3
STM-100388110,2.3 STM-100388110 Mall Channel 2.3
STM-100392613,2.3 STM-100392613 Mall Channel 2.3
STM-100395319,2.3 STM-100395319 Mall Channel 2.3
STM-100398457,2.3 STM-100398457 Mall Channel 2.3
STM-100435138,2.3 STM-100435138 Mall Channel 2.3

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE building_networks (
	building VARCHAR(100) NOT NULL, 
	network_id VARCHAR(100) NOT NULL, 
	PRIMARY KEY (building, network_id), 
	FOREIGN KEY(building) REFERENCES building (id), 
	FOREIGN KEY(network_id) REFERENCES network (id)
);