Tabular Data: hwdsb.rooms.csv

Dataset Overview

hwdsb.rooms.csv

Tabular dataset imported from csv source.

Import Type:
FILE

Source Type:
csv

Table Name:
tabular_data_68c0bec56e38d

Status:
Completed

Table Structure

Column	Data Type	Nullable
`id`	integer	No
`___SchoolID`	text	Yes
`DisplayName`	text	Yes
`SPSCODE`	text	Yes
`PlanSetName`	text	Yes
`FloorNumber`	text	Yes
`Code`	text	Yes
`Name`	text	Yes
`IsInstructional`	text	Yes
`Area`	text	Yes
`AreaType`	text	Yes
`ParentRoomNumber`	text	Yes
`SchoolRoomNumber`	text	Yes
`IsRoomUsageReportable`	text	Yes
`created_at`	timestamp without time zone	Yes

Data Preview

Showing first 100 rows of 13,306 total rows

id	___SchoolID	DisplayName	SPSCODE	PlanSetName	FloorNumber	Code	Name	IsInstructional	Area
1	7538	Adelaide Hoodless ES	6	Main Floor	1			0	24732.000
2	7538	Adelaide Hoodless ES	6	Second Floor	2			0	18740.000
3	7538	Adelaide Hoodless ES	6	Lower Level	0			0	18868.000
4	7539	Allan A Greenleaf ES	10	Main Floor	1			0	35517.000
5	7539	Allan A Greenleaf ES	10	Main Floor	1	109	Kindergarten	1	1157.000
6	7539	Allan A Greenleaf ES	10	Main Floor	1	108	Kindergarten	1	1169.000
7	7539	Allan A Greenleaf ES	10	Main Floor	1	107	Kindergarten	1	1219.000
8	7539	Allan A Greenleaf ES	10	Main Floor	1	108A	Washroom	0	34.000
9	7539	Allan A Greenleaf ES	10	Main Floor	1	107A	Washroom	0	34.000
10	7539	Allan A Greenleaf ES	10	Main Floor	1	105	Mechanical	0	36.000
11	7539	Allan A Greenleaf ES	10	Main Floor	1	101	Mechanical	0	109.000
12	7539	Allan A Greenleaf ES	10	Main Floor	1	103	Electrical	0	178.000
13	7539	Allan A Greenleaf ES	10	Main Floor	1	150G	Office	0	143.000
14	7539	Allan A Greenleaf ES	10	Main Floor	1	150F	Office	0	189.000
15	7539	Allan A Greenleaf ES	10	Main Floor	1	150D	Storage	0	174.000
16	7539	Allan A Greenleaf ES	10	Main Floor	1	150A	Kitchen	0	111.000
17	7539	Allan A Greenleaf ES	10	Main Floor	1	149	Washroom	0	67.000
18	7539	Allan A Greenleaf ES	10	Main Floor	1	150B	Staff Room	0	161.000
19	7539	Allan A Greenleaf ES	10	Main Floor	1	150E	Meeting Room	0	188.000
20	7539	Allan A Greenleaf ES	10	Main Floor	1	148	Custodial Area	0	121.000
21	7539	Allan A Greenleaf ES	10	Main Floor	1	150C	Mechanical	0	36.000
22	7539	Allan A Greenleaf ES	10	Main Floor	1	150	Office	0	725.000
23	7539	Allan A Greenleaf ES	10	Main Floor	1	146	Staff Room	1	983.000
24	7539	Allan A Greenleaf ES	10	Main Floor	1	.	Storage	0	21.000
25	7539	Allan A Greenleaf ES	10	Main Floor	1	145	Mechanical	0	23.000
26	7539	Allan A Greenleaf ES	10	Main Floor	1	143	Custodial Area	0	78.000
27	7539	Allan A Greenleaf ES	10	Main Floor	1	139	Mechanical	0	36.000
28	7539	Allan A Greenleaf ES	10	Main Floor	1	142	Staff Male Washroom	0	122.000
29	7539	Allan A Greenleaf ES	10	Main Floor	1	141	Female Staff Washroom	0	143.000
30	7539	Allan A Greenleaf ES	10	Main Floor	1	140	Special Education	1	727.000
31	7539	Allan A Greenleaf ES	10	Main Floor	1	136	Classroom	1	769.000
32	7539	Allan A Greenleaf ES	10	Main Floor	1	134	Classroom	1	769.000
33	7539	Allan A Greenleaf ES	10	Main Floor	1	138	Special Needs Washroom	0	163.000
34	7539	Allan A Greenleaf ES	10	Main Floor	1	140A	Office	0	170.000
35	7539	Allan A Greenleaf ES	10	Main Floor	1	137A	Office	0	151.000
36	7539	Allan A Greenleaf ES	10	Main Floor	1	137	Classroom	1	788.000
37	7539	Allan A Greenleaf ES	10	Main Floor	1	135	Mechanical	0	36.000
38	7539	Allan A Greenleaf ES	10	Main Floor	1	133	Classroom	1	769.000
39	7539	Allan A Greenleaf ES	10	Main Floor	1	131	Classroom	1	769.000
40	7539	Allan A Greenleaf ES	10	Main Floor	1	132	Mechanical	0	36.000
41	7539	Allan A Greenleaf ES	10	Main Floor	1	130	Classroom	1	759.000
42	7539	Allan A Greenleaf ES	10	Main Floor	1	128	Classroom	1	778.000
43	7539	Allan A Greenleaf ES	10	Main Floor	1	129	Mechanical	0	36.000
44	7539	Allan A Greenleaf ES	10	Main Floor	1	116C	Gym Storage	0	590.000
45	7539	Allan A Greenleaf ES	10	Main Floor	1	118B	Office	0	98.000
46	7539	Allan A Greenleaf ES	10	Main Floor	1	118C	Staff Washroom	0	76.000
47	7539	Allan A Greenleaf ES	10	Main Floor	1	118A	Boys Changeroom	0	355.000
48	7539	Allan A Greenleaf ES	10	Main Floor	1	118	Boys Washroom	0	307.000
49	7539	Allan A Greenleaf ES	10	Main Floor	1	120C	Staff Washroom	0	76.000
50	7539	Allan A Greenleaf ES	10	Main Floor	1	120B	Office	0	98.000
51	7539	Allan A Greenleaf ES	10	Main Floor	1	120A	Girls Changeroom	0	355.000
52	7539	Allan A Greenleaf ES	10	Main Floor	1	120	Girls Washroom	0	373.000
53	7539	Allan A Greenleaf ES	10	Main Floor	1	116A/B	Gymnasium	1	3200.000
54	7539	Allan A Greenleaf ES	10	Main Floor	1	124	Stage	0	1305.000
55	7539	Allan A Greenleaf ES	10	Main Floor	1	126	Storage	0	172.000
56	7539	Allan A Greenleaf ES	10	Main Floor	1	125	Custodial Area	0	128.000
57	7539	Allan A Greenleaf ES	10	Main Floor	1	123	Elevator	0	65.000
58	7539	Allan A Greenleaf ES	10	Main Floor	1	122	Corridor	0	142.000
59	7539	Allan A Greenleaf ES	10	Main Floor	1	112	Storage	0	145.000
60	7539	Allan A Greenleaf ES	10	Main Floor	1	113	Kindergarten	1	1273.000
61	7539	Allan A Greenleaf ES	10	Main Floor	1	113A	Washroom	0	34.000
62	7539	Allan A Greenleaf ES	10	Main Floor	1	114	Mechanical	0	24.000
63	7539	Allan A Greenleaf ES	10	Main Floor	1	111	Storage	0	270.000
64	7539	Allan A Greenleaf ES	10	Main Floor	1	110	Vestibule	0	82.000
65	7539	Allan A Greenleaf ES	10	Main Floor	1	.	Corridor	0	822.000
66	7539	Allan A Greenleaf ES	10	Main Floor	1	115	Stair	0	347.000
67	7539	Allan A Greenleaf ES	10	Main Floor	1	100	Vestibule	0	137.000
68	7539	Allan A Greenleaf ES	10	Main Floor	1	.	Corridor	0	2241.000
69	7539	Allan A Greenleaf ES	10	Main Floor	1	147	Stair	0	348.000
70	7539	Allan A Greenleaf ES	10	Main Floor	1	116B	Gymnasium	0	3200.000
71	7539	Allan A Greenleaf ES	10	Main Floor	1	.	Corridor	0	2099.000
72	7539	Allan A Greenleaf ES	10	Main Floor	1	127	Stairs	0	398.000
73	7539	Allan A Greenleaf ES	10	Second Floor	2	NULL	NULL	0	32327.000
74	7539	Allan A Greenleaf ES	10	Second Floor	2			0	2883.000
75	7539	Allan A Greenleaf ES	10	Second Floor	2	234	Classroom	1	768.000
76	7539	Allan A Greenleaf ES	10	Second Floor	2	232	Mechanical Room	0	60.000
77	7539	Allan A Greenleaf ES	10	Second Floor	2	233	Classroom	1	763.000
78	7539	Allan A Greenleaf ES	10	Second Floor	2	231	Classroom	1	771.000
79	7539	Allan A Greenleaf ES	10	Second Floor	2	230B	Resource Area	0	197.000
80	7539	Allan A Greenleaf ES	10	Second Floor	2	230A	Office	0	183.000
81	7539	Allan A Greenleaf ES	10	Second Floor	2	229	Computer Lab	1	762.000
82	7539	Allan A Greenleaf ES	10	Second Floor	2	228	Electrical Room	0	70.000
83	7539	Allan A Greenleaf ES	10	Second Floor	2	227	Resource Area	1	326.000
84	7539	Allan A Greenleaf ES	10	Second Floor	2	225A	Office	0	78.000
85	7539	Allan A Greenleaf ES	10	Second Floor	2	223	Mens Staff Washroom	0	122.000
86	7539	Allan A Greenleaf ES	10	Second Floor	2	222	Womens Staff Washroom	0	143.000
87	7539	Allan A Greenleaf ES	10	Second Floor	2	225	Classroom (Music)	1	1041.000
88	7539	Allan A Greenleaf ES	10	Second Floor	2	221	Art Room	1	1057.000
89	7539	Allan A Greenleaf ES	10	Second Floor	2	220	Mechanical Room	0	62.000
90	7539	Allan A Greenleaf ES	10	Second Floor	2	221A	Storage	0	151.000
91	7539	Allan A Greenleaf ES	10	Second Floor	2	219	Classroom	1	788.000
92	7539	Allan A Greenleaf ES	10	Second Floor	2	217	Mechanical Room	0	36.000
93	7539	Allan A Greenleaf ES	10	Second Floor	2	218	Classroom	1	769.000
94	7539	Allan A Greenleaf ES	10	Second Floor	2	216	Classroom	1	769.000
95	7539	Allan A Greenleaf ES	10	Second Floor	2	214	Mechanical Room	0	36.000
96	7539	Allan A Greenleaf ES	10	Second Floor	2	215	Classroom	1	769.000
97	7539	Allan A Greenleaf ES	10	Second Floor	2	213	Science Room	1	986.000
98	7539	Allan A Greenleaf ES	10	Second Floor	2	212	Mechanical Room	0	36.000
99	7539	Allan A Greenleaf ES	10	Second Floor	2	211A	Office	0	142.000
100	7539	Allan A Greenleaf ES	10	Second Floor	2	213A	Office	0	158.000

Export Options

CSV Export

Download data as comma-separated values

Export CSV

Excel Export

Download data as Excel spreadsheet

Export Excel

JSON Export

Download data as JSON format

Export JSON

SQL Export

Download data as SQL INSERT statements

Export SQL

API Endpoints

REST API Endpoints

GET /api/tabular.php?id=12

Get all data from the tabular dataset

GET /api/tabular.php?id=12&limit=100&offset=0

Get paginated data with limit and offset

GET /api/tabular.php?id=12&columns=column1,column2

Get specific columns from the dataset

POST /api/tabular.php?id=12&action=query

Query data with custom filters (POST body: JSON filters)

Response Format

{
  "success": true,
  "data": [...],
  "total_rows": 13306,
  "limit": 100,
  "offset": 0
}

Authentication

API endpoints require authentication. Include your API key in the request header: Authorization: Bearer YOUR_API_KEY

No Documents Available

No documents have been uploaded for this tabular dataset yet.

Raster

GeoTIFF

Tabular

ArcGIS

Upload Vector

URL Import

PostGIS Import

Remote PostGIS