-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathbuildings.sql
62 lines (61 loc) · 5.72 KB
/
buildings.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
DROP TABLE IF EXISTS buildings;
CREATE TABLE buildings (
id int,
building text,
geo_lat numeric,
geo_long numeric
);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (1, 'Allen House', 44.460132, -93.158479);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (2, 'Brooks House', 44.459634, -93.157958);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (3, 'Burton Hall', 44.460522, -93.156813);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (4, 'Cassat Hall', 44.460034, -93.151025);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (5, 'Clader House', 44.458679, -93.157736);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (6, 'Collier House', 44.459301, -93.158175);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (7, 'Colwell House', 44.458795, -93.158521);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (8, 'Davis Hall', 44.460105, -93.156682);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (9, 'Dixon House', 44.459146, -93.158216);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (10, 'Dow House', 44.458998, -93.158285);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (11, 'Eugster House', 44.460032, -93.157591);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (12, 'Evans Hall', 44.460518, -93.149714);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (13, 'Faculty Club', 44.458964, -93.149338);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (14, 'Faculty Club Annex', 44.459025, -93.149917);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (15, 'Goodhue Hall', 44.462356, -93.149601);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (16, 'Hill House', 44.458091, -93.155099);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (17, 'Hunt House', 44.458688, -93.158254);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (18, 'Huntington House', 44.458692, -93.155137);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (19, 'Memorial Hall', 44.460028, -93.151822);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (20, 'Musser Hall', 44.459913, -93.157234);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (21, 'Myers Hall', 44.460679, -93.150750);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (22, 'Nason House', 44.459799, -93.157502);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (23, 'Nourse Hall', 44.460471, -93.151879);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (24, 'Owens House', 44.459490, -93.158008);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (25, 'Parish House', 44.457667, -93.154666);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (26, 'Rice House', 44.458003, -93.155858);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (27, 'Scott House', 44.459871, -93.157713);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (28, 'Severance Hall', 44.460951, -93.156665);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (29, 'Watson Hall', 44.459343, -93.150368);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (30, 'Wilson House', 44.460306, -93.158092);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (31, 'Sayles', 44.461225, -93.156087);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (32, 'Rec', 44.464112, -93.149557);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (33, 'Libe', 44.462346, -93.154654);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (34, 'Weitz', 44.457108, -93.156158);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (35, 'LDC', 44.461024, -93.151393);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (36, 'Mudd', 44.460892, -93.152372);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (37, 'Olin', 44.461303, -93.152846);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (38, 'Hulings', 44.460834, -93.153118);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (39, 'Music', 44.461374, -93.153445);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (40, 'CMC', 44.462476, -93.153614);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (41, 'Laird', 44.462097, -93.153919);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (42, 'Leighton', 44.462073, -93.155571);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (43, 'Bald Spot', 44.460982, -93.154605);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (44, 'Cowling', 44.459929, -93.149681);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (45, 'Concert Hall', 44.460227, -93.153227);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (46, 'Chapel', 44.460231, -93.154729);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (47, 'Mini Bald Spot', 44.460469, -93.151296);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (48, 'Arb', 44.463551, -93.150009);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (49, 'Laird Football Stadium', 44.461717, -93.158474);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (50, 'Baseball/Softball Fields', 44.466131, -93.146956);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (51, 'Bell Field', 44.460103, -93.148772);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (52, 'Hill of Three Oaks', 44.463306, -93.147189);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (53, 'Little Bald Spot', 44.460381, -93.151221);
INSERT INTO buildings (id, building, geo_lat, geo_long) VALUES (54, 'Lyman Lakes', 44.462836, -93.151144);