-
Notifications
You must be signed in to change notification settings - Fork 2
/
OQ_Sample_Data.sql
297 lines (283 loc) · 92.4 KB
/
OQ_Sample_Data.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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
CREATE SCHEMA IF NOT EXISTS oq_sample;
SET client_encoding = 'UTF8';
-- NOTE file on_toronto_jarek_2019_03_21.osm.gz contains osm data to be imported and loaded to PostGIS for Test2.
DROP TABLE IF EXISTS oq_sample.oq_s1a_building;
CREATE TABLE oq_sample.oq_s1a_building (
id bigint NOT NULL,
version integer NOT NULL,
user_id integer NOT NULL,
tstamp timestamp without time zone NOT NULL,
changeset_id bigint NOT NULL,
tags public.hstore,
nodes bigint[],
linestring public.geometry(LineString,4326)
);
-- source of data, OpenStreetMap, license ODbL
INSERT INTO oq_sample.oq_s1a_building
SELECT id::bigint, version, user_id, tstamp, changeset_id::bigint, tags::hstore, nodes::bigint[],
--linestring --ST_AsEWKT(linestring) --
ST_GeomFromText(linestring, 4326)
FROM
(VALUES
(5649357, 10, 76077, '2016-11-04 15:20:40'::timestamp, 43407999, '"name"=>"Bansley Avenue", "lanes"=>"2", "highway"=>"residential", "surface"=>"asphalt"', '{42074884,3005945528,949007458,42074909,4482597179,4482597178,244216951,243888625}', 'LINESTRING(-79.4420326 43.693129,-79.4420865 43.6930509,-79.4422835 43.6927609,-79.4428422 43.6918097,-79.4428656 43.6917773,-79.4428924 43.691756,-79.4429399 43.6917367,-79.4437333 43.6915529)'),
(10252716, 16, 1679, '2014-03-15 12:48:44'::timestamp, 21120326, '"name"=>"Alameda Avenue", "lanes"=>"1", "oneway"=>"yes", "source"=>"geobase/statscan", "highway"=>"residential", "surface"=>"asphalt", "maxspeed"=>"30"', '{2711909651,949007441,2719431271}', 'LINESTRING(-79.4380907 43.6925981,-79.4375913 43.6913202,-79.4374748 43.6910235)'),
(66246064, 1, 1679, '2010-07-06 03:59:57'::timestamp, 5148080, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"odd"', '{803313207,803318329}', 'LINESTRING(-79.4440656 43.692672,-79.4440979 43.6927637)'),
(10252800, 11, 40964, '2018-09-03 14:26:56'::timestamp, 62255931, '"hgv"=>"no", "name"=>"Glenora Avenue", "lanes"=>"2", "highway"=>"residential", "surface"=>"asphalt"', '{85167620,2711768691,247128989,2711910045,2711910047,949007459,85169389}', 'LINESTRING(-79.4388474 43.6915136,-79.4387567 43.691566,-79.4387412 43.6916059,-79.4387612 43.6917193,-79.4388278 43.6918576,-79.4390342 43.6923043,-79.4393411 43.693109)'),
(22735758, 20, 2316730, '2019-02-10 00:37:38'::timestamp, 67064006, '"name"=>"Vaughan Road", "lanes"=>"2", "highway"=>"tertiary", "surface"=>"asphalt", "maxspeed"=>"40"', '{49573646,2711766883,6269087401,6269087399,6269087400,250040029}', 'LINESTRING(-79.4408253 43.6926125,-79.4406397 43.6925175,-79.4406237 43.6925088,-79.4406078 43.6925002,-79.4405913 43.692491,-79.4402887 43.6923161)'),
(22735816, 8, 1679, '2014-03-10 22:26:02'::timestamp, 21037890, '"name"=>"Eleanor Avenue", "lanes"=>"2", "highway"=>"residential", "surface"=>"asphalt"', '{243888722,949007431,2711906142,243888723}', 'LINESTRING(-79.441926 43.6919227,-79.4411474 43.6921025,-79.4407462 43.6921879,-79.4406383 43.6922076)'),
(22735821, 8, 5633991, '2018-10-28 13:47:18'::timestamp, 63956413, '"name"=>"Ashbury Avenue", "lanes"=>"1", "oneway"=>"yes", "source"=>"Geobase_Import_2009", "highway"=>"residential", "surface"=>"asphalt", "attribution"=>"GeoBase®", "statscan:rbuid"=>"484989", "geobase:acquisitionTechnique"=>"Vector Data"', '{243888733,243888757}', 'LINESTRING(-79.439917 43.6905711,-79.4430387 43.6898601)'),
(23146015, 11, 76077, '2016-11-01 08:56:03'::timestamp, 43325295, '"name"=>"Oakwood Avenue", "lanes"=>"1", "oneway"=>"yes", "source"=>"GeoBase NRN", "highway"=>"residential", "surface"=>"asphalt", "attribution"=>"GeoBase®"', '{243888723,2711766328,4475029985,250040029}', 'LINESTRING(-79.4406383 43.6922076,-79.4404521 43.6922844,-79.4403775 43.6922989,-79.4402887 43.6923161)'),
(43806951, 3, 9266764, '2019-01-09 18:44:08'::timestamp, 66178384, '"source"=>"CanVec_Import_2009", "amenity"=>"school", "building"=>"school", "attribution"=>"Natural Resources Canada", "canvec:CODE"=>"2010422", "canvec:UUID"=>"17475319dcea48d783a782be6a484c05"', '{555341665,4482597440,4482597441,4482597439,4482597438,4482597436,4482597437,4482597435,4482597433,4482597431,4482597432,4482597430,4482597429,555341663,4482597418,4482597420,4482597417,4482597416,4482597410,4482597411,4482597408,4482597407,4482597406,4482597405,4482597403,4482597404,4482597399,4482597400,4482597398,4482597397,4482597391,4482597392,4482597390,4482597389,4482597183,4482597184,4482597182,4482597181,555341634,555341630,555341637,555341639,555341641,555341643,4482597186,4482597185,4482597187,4482597188,4482597394,4482597393,4482597395,4482597396,4482597402,4482597401,555341653,6196791137,555341651,6196791136,555341660,4482597413,4482597414,555341658,555341655,4482597427,4482597419,4482597421,4482597424,4482597423,4482597426,4482597428,555341673,555341676,555341674,555341670,555341668,555341665}', 'LINESTRING(-79.443181 43.69289,-79.443131 43.692874,-79.443122 43.692888,-79.442973 43.692839,-79.442981 43.692825,-79.442923 43.692806,-79.442914 43.69282,-79.442766 43.692772,-79.442775 43.692757,-79.442723 43.69274,-79.442715 43.692752,-79.442601 43.692715,-79.442609 43.692701,-79.442562 43.692686,-79.442604 43.692617,-79.442625 43.692623,-79.442647 43.692588,-79.442625 43.69258,-79.442701 43.692458,-79.442725 43.692466,-79.442746 43.692431,-79.442698 43.692415,-79.442735 43.692355,-79.442717 43.692349,-79.442749 43.692297,-79.44277 43.692304,-79.442825 43.692215,-79.442873 43.692231,-79.442897 43.692192,-79.442877 43.692185,-79.442945 43.692075,-79.442964 43.692082,-79.442989 43.692042,-79.442969 43.692036,-79.443037 43.691926,-79.443059 43.691933,-79.443082 43.691895,-79.443063 43.691889,-79.443099 43.69183,-79.443204 43.691865,-79.443234 43.691816,-79.4433 43.691838,-79.443268 43.691888,-79.443373 43.691922,-79.443337 43.691981,-79.443317 43.691975,-79.443294 43.692012,-79.443314 43.692019,-79.443246 43.692127,-79.443227 43.692121,-79.443202 43.692162,-79.44322 43.692167,-79.443151 43.692277,-79.443133 43.692271,-79.44311 43.692309,-79.443276 43.692364,-79.443297 43.692371,-79.443257 43.692435,-79.443236 43.692428,-79.443189 43.692504,-79.443221 43.692514,-79.443182 43.692576,-79.442934 43.692495,-79.442891 43.692564,-79.443047 43.692615,-79.443039 43.692627,-79.443096 43.692646,-79.443105 43.692632,-79.443254 43.69268,-79.443246 43.692694,-79.443294 43.69271,-79.443248 43.692785,-79.443318 43.692807,-79.443297 43.692841,-79.443226 43.692818,-79.443181 43.69289)'),
(43886052, 3, 1679, '2014-03-15 12:48:45'::timestamp, 21120326, '', '{557762666,557762664,557762662,2719431265,2719431266,2719431268,2719431270,557762648,557762646,557762644,557762642,557762640,557762660,557762652,557762650,557762666}', 'LINESTRING(-79.4364778 43.6913781,-79.4360923 43.6904088,-79.4362049 43.6903159,-79.4362335 43.6903307,-79.4363683 43.6904005,-79.4368177 43.6906334,-79.4371917 43.6908245,-79.4372085 43.6908331,-79.4372382 43.6909193,-79.4371476 43.6909375,-79.4371879 43.6910322,-79.4372836 43.6910067,-79.4374094 43.6913162,-79.4370016 43.691389,-79.4369562 43.6912688,-79.4364778 43.6913781)'),
(66245347, 1, 1679, '2010-07-06 03:57:55'::timestamp, 5148080, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"odd"', '{803317364,803312473}', 'LINESTRING(-79.4395431 43.6920721,-79.4401351 43.6924102)'),
(66245350, 2, 368874, '2018-10-31 19:38:29'::timestamp, 64062783, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"even"', '{803312779,803311645,6028524892,6028524894,6028524893,6028524897,803316479}', 'LINESTRING(-79.4410304 43.692592,-79.4413315 43.6927182,-79.4417641 43.6928995,-79.4418204 43.6929231,-79.4418452 43.6929335,-79.4418669 43.6929426,-79.4419506 43.6929777)'),
(66245412, 1, 1679, '2010-07-06 03:58:04'::timestamp, 5148080, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"odd"', '{803314126,803312533,803315312,803311449,803314870}', 'LINESTRING(-79.4435447 43.6915164,-79.4429445 43.6916479,-79.4428173 43.691708,-79.4427421 43.6917851,-79.4422486 43.692604)'),
(66245449, 1, 1679, '2010-07-06 03:58:10'::timestamp, 5148080, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"odd"', '{803313847,803315624}', 'LINESTRING(-79.4406249 43.692745,-79.4395092 43.692984)'),
(66245554, 1, 1679, '2010-07-06 03:58:23'::timestamp, 5148080, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"even"', '{803314709,803311464}', 'LINESTRING(-79.4434045 43.6934313,-79.4444621 43.6937722)'),
(66245578, 1, 1679, '2010-07-06 03:58:26'::timestamp, 5148080, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"even"', '{803311480,803312349}', 'LINESTRING(-79.439206 43.6924121,-79.4394335 43.6929544)'),
(66245624, 1, 1679, '2010-07-06 03:58:31'::timestamp, 5148080, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"odd"', '{803314103,803314074}', 'LINESTRING(-79.4418506 43.6918896,-79.4413047 43.6920091)'),
(66245710, 1, 1679, '2010-07-06 03:58:48'::timestamp, 5148080, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"even"', '{803317417,803318593}', 'LINESTRING(-79.4389306 43.6917553,-79.4391 43.6921592)'),
(66245722, 1, 1679, '2010-07-06 03:58:50'::timestamp, 5148080, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"even"', '{803315283,803314248,803313249,803319305}', 'LINESTRING(-79.443992 43.6926406,-79.4437806 43.6926806,-79.4436955 43.6927147,-79.44345 43.6931099)'),
(66245749, 1, 1679, '2010-07-06 03:58:54'::timestamp, 5148080, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"even"', '{803318821,803317821,803317400,803318916}', 'LINESTRING(-79.4436131 43.691685,-79.4430006 43.6918246,-79.442958 43.6918656,-79.4424667 43.6926809)'),
(66245789, 1, 1679, '2010-07-06 03:59:02'::timestamp, 5148080, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"odd"', '{803318465,803313791}', 'LINESTRING(-79.4402297 43.6924651,-79.4406335 43.6927005)'),
(66245798, 1, 1679, '2010-07-06 03:59:03'::timestamp, 5148080, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"even"', '{803319699,803317564}', 'LINESTRING(-79.4398677 43.6919186,-79.4403311 43.6921863)'),
(66245834, 1, 1679, '2010-07-06 03:59:10'::timestamp, 5148080, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"odd"', '{803313170,803316517}', 'LINESTRING(-79.4441315 43.6928517,-79.4445002 43.693748)'),
(66245937, 1, 1679, '2010-07-06 03:59:29'::timestamp, 5148080, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"odd"', '{803316716,803317144}', 'LINESTRING(-79.4389605 43.6917405,-79.4394451 43.6920178)'),
(66246010, 1, 1679, '2010-07-06 03:59:45'::timestamp, 5148080, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"even"', '{803312090,803311973,803319681}', 'LINESTRING(-79.4422847 43.6930825,-79.4424649 43.693151,-79.4430047 43.6933015)'),
(66246046, 1, 1679, '2010-07-06 03:59:54'::timestamp, 5148080, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"even"', '{803319134,803319290}', 'LINESTRING(-79.4419206 43.6920578,-79.4413781 43.6921767)'),
(66246130, 1, 1679, '2010-07-06 04:00:09'::timestamp, 5148080, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"even"', '{803314609,803318433}', 'LINESTRING(-79.4408694 43.6923407,-79.4409627 43.6925217)'),
(66246157, 1, 1679, '2010-07-06 04:00:13'::timestamp, 5148080, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"odd"', '{803313554,803319709}', 'LINESTRING(-79.4420999 43.6928447,-79.4420352 43.6929492)'),
(66246287, 1, 1679, '2010-07-06 04:00:32'::timestamp, 5148080, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"odd"', '{803314414,803319845,803311591}', 'LINESTRING(-79.4401605 43.6915597,-79.4403991 43.6921761,-79.4404211 43.6921716)'),
(66246490, 1, 1679, '2010-07-06 04:00:51'::timestamp, 5148080, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"even"', '{803313456,803319198}', 'LINESTRING(-79.4391333 43.6915035,-79.4395786 43.6917584)'),
(66246499, 1, 1679, '2010-07-06 04:00:52'::timestamp, 5148080, '"source"=>"CanVec 6.0 - NRCan", "addr:interpolation"=>"odd"', '{803314340,803316928}', 'LINESTRING(-79.438616 43.6916002,-79.4389007 43.6922878)'),
(81458344, 3, 4973384, '2017-01-11 04:37:32'::timestamp, 45071534, '"note"=>"Lane East Oakwood South Vaughan", "lanes"=>"1", "source"=>"CanVec 6.0 - NRCan", "highway"=>"service", "surface"=>"paved"', '{949007486,949007482,949007467}', 'LINESTRING(-79.4398181 43.6915773,-79.4398508 43.6915994,-79.4399097 43.6916811)'),
(81458345, 4, 4667454, '2016-10-28 07:58:55'::timestamp, 43244997, '"name"=>"Lane South Vaughan West Bansley", "lanes"=>"1", "source"=>"CanVec 6.0 - NRCan", "highway"=>"service", "surface"=>"paved", "alt_name"=>"Lane S Vaughan W Bansley"', '{949007458,949007451}', 'LINESTRING(-79.4422835 43.6927609,-79.443323 43.6930965)'),
(81458350, 3, 4973384, '2017-01-03 09:48:56'::timestamp, 44869224, '"name"=>"Lane East Oakwood South Vaughan", "note"=>"Lane E Oakwood S Vaughan", "lanes"=>"1", "source"=>"CanVec 6.0 - NRCan", "highway"=>"service", "surface"=>"paved"', '{949007467,949007445}', 'LINESTRING(-79.4399097 43.6916811,-79.4400393 43.6918275)'),
(81458352, 3, 4973384, '2017-01-11 04:37:33'::timestamp, 45071534, '"note"=>"Lane East Glenora North Vaughan", "lanes"=>"1", "source"=>"CanVec 6.0 - NRCan", "highway"=>"service", "surface"=>"paved"', '{949007441,949007434,949007478}', 'LINESTRING(-79.4375913 43.6913202,-79.4381792 43.6916054,-79.4384515 43.6913205)'),
(81458355, 3, 4973384, '2017-01-03 09:48:56'::timestamp, 44869224, '"name"=>"Lane East Oakwood South Vaughan", "note"=>"Lane E Oakwood S Vaughan", "lanes"=>"1", "source"=>"CanVec 6.0 - NRCan", "highway"=>"service", "surface"=>"paved"', '{949007467,949007450}', 'LINESTRING(-79.4399097 43.6916811,-79.4396028 43.6919401)'),
(81458356, 3, 4973384, '2017-01-11 04:37:33'::timestamp, 45071534, '"note"=>"Lane South Belvidere West Glenora", "lanes"=>"1", "source"=>"CanVec 6.0 - NRCan", "highway"=>"service", "surface"=>"paved"', '{949007463,949007459}', 'LINESTRING(-79.4394663 43.6922365,-79.4390342 43.6923043)'),
(81458357, 4, 4667454, '2016-10-28 07:58:54'::timestamp, 43244997, '"name"=>"Lane South Vaughan East Bansley", "lanes"=>"1", "source"=>"CanVec 6.0 - NRCan", "highway"=>"service", "surface"=>"paved", "alt_name"=>"Lane S Vaughan E Bansley"', '{949007431,949007488,949007458}', 'LINESTRING(-79.4411474 43.6921025,-79.4412867 43.6924017,-79.4422835 43.6927609)'),
(265525875, 1, 1679, '2014-03-10 19:50:56'::timestamp, 21036812, '"access"=>"customers", "amenity"=>"parking", "parking"=>"surface", "surface"=>"asphalt"', '{2711766325,2711766320,2711766324,2711766327,2711766325}', 'LINESTRING(-79.4404678 43.6922117,-79.4404285 43.6921288,-79.4402023 43.6921765,-79.4403343 43.6922412,-79.4404678 43.6922117)'),
(265525959, 4, 9266764, '2019-01-09 18:44:18'::timestamp, 66178384, '"building"=>"retail", "building:levels"=>"1"', '{2711766375,6196764396,6196764395,6196764394,6196764393,2711766373,6196764392,6196764391,2711766372,6196764390,6196764389,2711766371,2711766374,2711766375}', 'LINESTRING(-79.44017 43.692147,-79.440105 43.692105,-79.440108 43.692102,-79.440099 43.692096,-79.440094 43.6921,-79.440075 43.692088,-79.440086 43.692079,-79.440036 43.692047,-79.440155 43.691945,-79.440336 43.691907,-79.440342 43.691923,-79.440353 43.691921,-79.440422 43.692092,-79.44017 43.692147)'),
(265527515, 2, 9266764, '2019-01-09 18:44:18'::timestamp, 66178384, '"name"=>"New Dawn Moravian Church", "amenity"=>"place_of_worship", "building"=>"church", "religion"=>"christian"', '{6196760871,6196760870,2711768695,6196760869,2711768693,6196760868,6196760867,6196760866,6196760865,6196760864,6196760863,6196760862,6196760861,6196760860,6196760859,2711768692,6196760858,6196760857,6196760856,6196760855,6196760854,2711768694,6196760853,6196760852,6196760851,6196760850,6196760849,6196760848,6196760871}', 'LINESTRING(-79.438375 43.691936,-79.438372 43.691928,-79.438351 43.691933,-79.438292 43.691795,-79.43831 43.691791,-79.438309 43.691787,-79.438379 43.691771,-79.438381 43.691776,-79.438487 43.691752,-79.438484 43.691744,-79.438499 43.691741,-79.438498 43.691739,-79.438547 43.691728,-79.438548 43.691732,-79.438561 43.691729,-79.438571 43.691753,-79.438562 43.691755,-79.438606 43.691858,-79.438615 43.691856,-79.438626 43.69188,-79.438612 43.691883,-79.438615 43.691889,-79.43857 43.691899,-79.438568 43.691893,-79.438551 43.691897,-79.438548 43.691889,-79.438445 43.691913,-79.438448 43.69192,-79.438375 43.691936)'),
(265533075, 1, 1679, '2014-03-10 22:24:35'::timestamp, 21037881, '"access"=>"private", "amenity"=>"parking", "parking"=>"surface", "surface"=>"asphalt"', '{2711904325,2711904322,2711904321,2711904323,2711904325}', 'LINESTRING(-79.4432745 43.6930408,-79.4425468 43.6928141,-79.4425731 43.6927701,-79.4433008 43.6929968,-79.4432745 43.6930408)'),
(265533171, 1, 1679, '2014-03-10 22:29:23'::timestamp, 21037915, '"access"=>"private", "highway"=>"footway"', '{2711910045,2711910046}', 'LINESTRING(-79.4387612 43.6917193,-79.4386223 43.6917554)'),
(265533172, 1, 1679, '2014-03-10 22:29:23'::timestamp, 21037915, '"access"=>"private", "highway"=>"footway"', '{2711910049,2711910047}', 'LINESTRING(-79.4386615 43.691883,-79.4388278 43.6918576)'),
(265631257, 3, 2316730, '2019-02-10 00:37:38'::timestamp, 67064006, '"lit"=>"yes", "name"=>"Oakwood Avenue", "lanes"=>"4", "highway"=>"secondary", "surface"=>"asphalt"', '{49573646,6269087397,6269087396,6269087395,6269087398,6269087394,6269087393,2711766885,118295162}', 'LINESTRING(-79.4408253 43.6926125,-79.4408384 43.6926653,-79.4408408 43.6926749,-79.4408436 43.6926856,-79.4408464 43.6926957,-79.4408496 43.6927062,-79.4408561 43.6927273,-79.4408662 43.6927583,-79.4408763 43.6927862)'),
(265631778, 1, 1679, '2014-03-11 12:14:55'::timestamp, 21047732, '"lit"=>"yes", "name"=>"Oakwood Avenue", "lanes"=>"4", "highway"=>"secondary", "surface"=>"asphalt"', '{243888723,2711766882,49573646}', 'LINESTRING(-79.4406383 43.6922076,-79.4407727 43.6924911,-79.4408253 43.6926125)'),
(265631779, 2, 76077, '2016-11-01 08:56:04'::timestamp, 43325295, '"lit"=>"yes", "name"=>"Oakwood Avenue", "lanes"=>"2", "highway"=>"secondary", "surface"=>"asphalt", "maxspeed"=>"50"', '{118234284,243888773,243888733,243888665,243888723}', 'LINESTRING(-79.4395182 43.6895386,-79.4396036 43.6897405,-79.439917 43.6905711,-79.4402763 43.6914364,-79.4406383 43.6922076)'),
(266380256, 1, 1679, '2014-03-15 12:48:44'::timestamp, 21120326, '"access"=>"private", "highway"=>"footway"', '{2719431268,2719431267}', 'LINESTRING(-79.4368177 43.6906334,-79.4369453 43.6905097)'),
(266380257, 1, 1679, '2014-03-15 12:48:44'::timestamp, 21120326, '"access"=>"private", "highway"=>"footway"', '{2719431270,2719431269}', 'LINESTRING(-79.4371917 43.6908245,-79.4373257 43.6907061)'),
(266380258, 1, 1679, '2014-03-15 12:48:44'::timestamp, 21120326, '"access"=>"private", "highway"=>"footway"', '{2719431264,2719431263,2719431265}', 'LINESTRING(-79.4364378 43.6903186,-79.4362519 43.690313,-79.4362335 43.6903307)'),
(266380259, 1, 1679, '2014-03-15 12:48:44'::timestamp, 21120326, '"access"=>"private", "highway"=>"footway"', '{2719431262,2719431264,2719431266}', 'LINESTRING(-79.4365039 43.6902676,-79.4364378 43.6903186,-79.4363683 43.6904005)'),
(273195606, 1, 1679, '2014-04-09 22:07:07'::timestamp, 21598870, '"access"=>"private", "leisure"=>"playground"', '{2780705025,2780705027,2780705030,2780705032,2780705034,2780705036,2780705037,2780705040,2780705042,2780705044,2780705025}', 'LINESTRING(-79.4436156 43.6917459,-79.4436414 43.6918012,-79.4436659 43.691812,-79.4436945 43.691812,-79.4437306 43.6917953,-79.4437257 43.6917772,-79.4437162 43.6917599,-79.4436494 43.6917181,-79.4436231 43.6917155,-79.4436136 43.6917274,-79.4436156 43.6917459)'),
(296783396, 3, 1679, '2015-06-25 05:29:13'::timestamp, 32200941, '"name"=>"Vaughan Road", "lanes"=>"2", "highway"=>"residential", "surface"=>"asphalt", "maxspeed"=>"40", "hgv:conditional"=>"no @ (19:00-07:00)"', '{42074884,41364237,2711766884,49573646}', 'LINESTRING(-79.4420326 43.693129,-79.4414876 43.692931,-79.4409926 43.6926917,-79.4408253 43.6926125)'),
(401062487, 1, 3551880, '2016-03-01 14:36:42'::timestamp, 37552498, '"source"=>"StatCan 92-500-X", "addr:interpolation"=>"even"', '{4035314895,4035314899}', 'LINESTRING(-79.443185 43.693403,-79.443298 43.693442)'),
(401062753, 1, 3551880, '2016-03-01 14:36:55'::timestamp, 37552498, '"source"=>"StatCan 92-500-X", "addr:interpolation"=>"odd"', '{4035313646,4035313674}', 'LINESTRING(-79.443686 43.691717,-79.443974 43.692435)'),
(451427175, 3, 5633991, '2018-06-20 10:36:35'::timestamp, 60013364, '"name"=>"D''Arcy McGee Catholic School", "phone"=>"+1-416-393-5318", "amenity"=>"school", "website"=>"https://www.tcdsb.org/schools/darcymcgee/", "operator"=>"Toronto Catholic District School Board", "addr:city"=>"Toronto", "addr:street"=>"Bansley Avenue", "addr:housenumber"=>"20"', '{4482597442,4482597434,4482597180,4482597176,4482597177,4482597409,4482597412,4482597415,4482597442}', 'LINESTRING(-79.4432773 43.6930602,-79.442368 43.6927606,-79.44293 43.6918171,-79.4436354 43.6916464,-79.4437024 43.6916649,-79.4440055 43.6924396,-79.4439693 43.6924862,-79.4435428 43.6925735,-79.4432773 43.6930602)'),
(639843855, 2, 9266764, '2019-01-09 18:44:19'::timestamp, 66178384, '"name"=>"Supernatural", "amenity"=>"restaurant", "building"=>"commercial"', '{6028524857,6196765159,6196765158,6196765157,6196765156,6196751576,6028524856,6028524857}', 'LINESTRING(-79.441045 43.692606,-79.440999 43.692586,-79.441095 43.692469,-79.441108 43.692454,-79.441154 43.692474,-79.4411536 43.6924745,-79.441141 43.692489,-79.441045 43.692606)'),
(639843857, 2, 9266764, '2019-01-09 18:44:19'::timestamp, 66178384, '"name"=>"Hair Pleasure", "building"=>"retail"', '{6196765177,6028524862,6196751574,6028524861,6196765174,6196765173,6196765175,6196765176,6196765177}', 'LINESTRING(-79.441132 43.692644,-79.441087 43.692624,-79.4411318 43.6925571,-79.4411749 43.6925071,-79.441191 43.692514,-79.441204 43.692498,-79.441239 43.692514,-79.441229 43.692525,-79.441132 43.692644)'),
(639843858, 2, 9266764, '2019-01-09 18:44:19'::timestamp, 66178384, '"name"=>"One Love Sports Bar", "amenity"=>"restaurant", "building"=>"retail"', '{6196765182,6196765177,6196765176,6196765175,6028524864,6028524865,6028524863,6028524866,6196765181,6196765182}', 'LINESTRING(-79.441199 43.692673,-79.441132 43.692644,-79.441229 43.692525,-79.441239 43.692514,-79.44125 43.692501,-79.44131 43.692527,-79.441291 43.69255,-79.441248 43.692603,-79.441254 43.692606,-79.441199 43.692673)'),
(639843859, 2, 9266764, '2019-01-09 18:44:19'::timestamp, 66178384, '"name"=>"Crystal", "amenity"=>"restaurant", "building"=>"retail"', '{6196765190,6196765182,6196765181,6196765180,6196765179,6196765178,6196765189,6196765190}', 'LINESTRING(-79.44127 43.692703,-79.441199 43.692673,-79.441254 43.692606,-79.441295 43.692556,-79.441355 43.692581,-79.441302 43.692645,-79.441314 43.69265,-79.44127 43.692703)'),
(639843862, 2, 9266764, '2019-01-09 18:44:19'::timestamp, 66178384, '"name"=>"5 Points", "amenity"=>"restaurant", "building"=>"retail"', '{6196765359,6196765192,6196765191,6028524874,6028524876,6028524875,6028524871,6196765358,6196765359}', 'LINESTRING(-79.441423 43.69277,-79.441338 43.692733,-79.441366 43.692698,-79.44138 43.692704,-79.441469 43.692596,-79.441536 43.692625,-79.441477 43.692698,-79.441481 43.692699,-79.441423 43.69277)'),
(639843863, 2, 9266764, '2019-01-09 18:44:19'::timestamp, 66178384, '"building"=>"retail"', '{6028524883,6196765359,6196765358,6028524879,6028524881,6028524882,6028524880,6028524878,6028524883}', 'LINESTRING(-79.441525 43.692814,-79.441423 43.69277,-79.441481 43.692699,-79.441501 43.692708,-79.441566 43.692629,-79.441642 43.692662,-79.441616 43.692694,-79.441621 43.692697,-79.441525 43.692814)'),
(639843864, 2, 9266764, '2019-01-09 18:44:20'::timestamp, 66178384, '"building"=>"apartments", "addr:street"=>"Vaughan Road", "addr:housenumber"=>"642"', '{6028524890,6028524889,6028524888,6196765362,6196765361,6196765360,6028524887,6028524890}', 'LINESTRING(-79.441718 43.692882,-79.441572 43.692838,-79.4417 43.692614,-79.441722 43.692621,-79.441733 43.692603,-79.441734 43.6926,-79.441858 43.692637,-79.441718 43.692882)'),
(639843867, 1, 368874, '2018-10-31 19:38:28'::timestamp, 64062783, '"building"=>"apartments"', '{6028524901,6028524900,6028524899,6028524898,6028524901}', 'LINESTRING(-79.4419938 43.6930185,-79.4421427 43.6927615,-79.4420408 43.6927324,-79.4418731 43.6929807,-79.4419938 43.6930185)'),
(661894732, 1, 9266764, '2019-01-09 18:39:20'::timestamp, 66178326, '"building"=>"retail"', '{6196764421,6196751573,6196764378,6196764377,6196764376,6196764415,6196764420,6196764421}', 'LINESTRING(-79.440155 43.692517,-79.4401261 43.6924491,-79.439781 43.692527,-79.43975 43.69246,-79.440173 43.692367,-79.440264 43.692418,-79.440355 43.692472,-79.440155 43.692517)'),
(661894733, 1, 9266764, '2019-01-09 18:39:20'::timestamp, 66178326, '"building"=>"retail"', '{6028524862,6028524857,6196751576,6196751575,6028524861,6196751574,6028524862}', 'LINESTRING(-79.441087 43.692624,-79.441045 43.692606,-79.4411536 43.6924745,-79.4411882 43.6924924,-79.4411749 43.6925071,-79.4411318 43.6925571,-79.441087 43.692624)'),
(661895265, 1, 9266764, '2019-01-09 18:39:53'::timestamp, 66178326, '"building"=>"detached"', '{6196760443,6196760442,6196760441,6196760440,6196760439,6196760438,6196760437,6196760443}', 'LINESTRING(-79.437873 43.691769,-79.437864 43.691737,-79.437889 43.691734,-79.437882 43.691707,-79.438002 43.69169,-79.438018 43.691748,-79.4379 43.691765,-79.437873 43.691769)'),
(661895266, 1, 9266764, '2019-01-09 18:39:53'::timestamp, 66178326, '"building"=>"detached"', '{6196760451,6196760450,6196760449,6196760448,6196760447,6196760446,6196760445,6196760444,6196760451}', 'LINESTRING(-79.437905 43.691837,-79.437892 43.691787,-79.437919 43.691783,-79.437918 43.691779,-79.43804 43.691762,-79.438055 43.691819,-79.437933 43.691836,-79.437932 43.691833,-79.437905 43.691837)'),
(661895285, 1, 9266764, '2019-01-09 18:39:54'::timestamp, 66178326, '"building"=>"detached"', '{6196760821,6196760820,6196760819,6196760818,6196760817,6196760816,6196760815,6196760814,6196760813,6196760812,6196760821}', 'LINESTRING(-79.437933 43.691899,-79.437924 43.691863,-79.437953 43.691859,-79.437947 43.691839,-79.438066 43.691822,-79.438072 43.691842,-79.438111 43.691836,-79.43812 43.691872,-79.438082 43.691877,-79.437964 43.691894,-79.437933 43.691899)'),
(661895286, 1, 9266764, '2019-01-09 18:39:54'::timestamp, 66178326, '"building"=>"detached"', '{6196760829,6196760828,6196760827,6196760826,6196760825,6196760824,6196760823,6196760822,6196760829}', 'LINESTRING(-79.438011 43.692015,-79.438009 43.692009,-79.438001 43.69201,-79.437986 43.691966,-79.437994 43.691965,-79.437989 43.691949,-79.438118 43.691925,-79.438141 43.691991,-79.438011 43.692015)'),
(661895287, 1, 9266764, '2019-01-09 18:39:54'::timestamp, 66178326, '"building"=>"detached"', '{6196760837,6196760836,6196760835,6196760834,6196760833,6196760832,6196760831,6196760830,6196760837}', 'LINESTRING(-79.438059 43.692078,-79.438059 43.692076,-79.438045 43.692078,-79.438035 43.69204,-79.438049 43.692038,-79.438048 43.692033,-79.438197 43.692013,-79.438208 43.692059,-79.438059 43.692078)'),
(661895288, 1, 9266764, '2019-01-09 18:39:54'::timestamp, 66178326, '"building"=>"detached"', '{6196760847,6196760846,6196760845,6196760844,6196760843,6196760842,6196760841,6196760840,6196760839,6196760838,6196760847}', 'LINESTRING(-79.438081 43.692169,-79.43806 43.692084,-79.438072 43.692083,-79.438183 43.692068,-79.438193 43.692075,-79.438227 43.69207,-79.438247 43.692138,-79.438213 43.692143,-79.438202 43.692153,-79.438096 43.692167,-79.438081 43.692169)'),
(661895289, 1, 9266764, '2019-01-09 18:39:54'::timestamp, 66178326, '"building"=>"detached"', '{6196760876,6196760875,6196760874,6196760873,6196760872,6196760876}', 'LINESTRING(-79.438503 43.69202,-79.43849 43.691977,-79.438529 43.691962,-79.438703 43.691935,-79.438718 43.691987,-79.438503 43.69202)'),
(661895290, 1, 9266764, '2019-01-09 18:39:54'::timestamp, 66178326, '"building"=>"detached"', '{6196760990,6196760989,6196760988,6196760987,6196760986,6196760985,6196760884,6196760883,6196760882,6196760881,6196760880,6196760879,6196760878,6196760877,6196760990}', 'LINESTRING(-79.438568 43.692069,-79.438567 43.692066,-79.438525 43.692063,-79.438519 43.692043,-79.438524 43.692042,-79.438518 43.692022,-79.438556 43.692016,-79.438555 43.692014,-79.438698 43.691992,-79.438699 43.691996,-79.438727 43.691991,-79.438741 43.692039,-79.438714 43.692043,-79.438715 43.692047,-79.438568 43.692069)'),
(661895291, 1, 9266764, '2019-01-09 18:39:54'::timestamp, 66178326, '"building"=>"detached"', '{6196760997,6196760996,6196760995,6196760994,6196760993,6196760992,6196760991,6196760997}', 'LINESTRING(-79.438611 43.692156,-79.438602 43.69212,-79.43859 43.692121,-79.438579 43.692081,-79.438739 43.692059,-79.438759 43.692136,-79.438653 43.692151,-79.438611 43.692156)'),
(661895292, 1, 9266764, '2019-01-09 18:39:54'::timestamp, 66178326, '"building"=>"detached"', '{6196761010,6196761009,6196761008,6196761007,6196761006,6196761005,6196761004,6196761003,6196761002,6196761001,6196761000,6196760999,6196760998,6196761010}', 'LINESTRING(-79.438112 43.692257,-79.438092 43.692172,-79.438107 43.69217,-79.438214 43.692157,-79.438224 43.692163,-79.438259 43.69216,-79.438287 43.692158,-79.438291 43.692186,-79.438268 43.692188,-79.438274 43.692228,-79.438242 43.692231,-79.438234 43.692242,-79.438124 43.692255,-79.438112 43.692257)'),
(661895293, 1, 9266764, '2019-01-09 18:39:54'::timestamp, 66178326, '"building"=>"detached"', '{6196761024,6196761023,6196761022,6196761021,6196761020,6196761019,6196761018,6196761017,6196761016,6196761015,6196761014,6196761013,6196761012,6196761011,6196761024}', 'LINESTRING(-79.438141 43.692348,-79.43812 43.692263,-79.438136 43.692261,-79.438247 43.692246,-79.438257 43.692252,-79.43829 43.692249,-79.438296 43.692279,-79.438343 43.692273,-79.43835 43.692304,-79.438306 43.692309,-79.438308 43.692318,-79.438271 43.692322,-79.438266 43.692332,-79.438158 43.692346,-79.438141 43.692348)'),
(661895294, 1, 9266764, '2019-01-09 18:39:55'::timestamp, 66178326, '"building"=>"detached"', '{6196761034,6196761033,6196761032,6196761031,6196761030,6196761029,6196761028,6196761027,6196761026,6196761025,6196761034}', 'LINESTRING(-79.438171 43.692438,-79.438148 43.692354,-79.438164 43.692352,-79.438278 43.692335,-79.438282 43.692341,-79.438321 43.692335,-79.438339 43.692405,-79.438304 43.692411,-79.438298 43.692419,-79.438189 43.692435,-79.438171 43.692438)'),
(661895295, 1, 9266764, '2019-01-09 18:39:55'::timestamp, 66178326, '"building"=>"detached"', '{6196761038,6196761037,6196761036,6196761035,6196761038}', 'LINESTRING(-79.438218 43.692517,-79.438193 43.692456,-79.438366 43.692417,-79.438392 43.692478,-79.438218 43.692517)'),
(661895297, 1, 9266764, '2019-01-09 18:39:55'::timestamp, 66178326, '"building"=>"detached"', '{6196761051,6196761050,6196761049,6196761048,6196761051}', 'LINESTRING(-79.438607 43.692259,-79.438586 43.692179,-79.438781 43.692152,-79.438802 43.692232,-79.438607 43.692259)'),
(661895298, 1, 9266764, '2019-01-09 18:39:55'::timestamp, 66178326, '"building"=>"detached"', '{6196761060,6196761059,6196761058,6196761057,6196761056,6196761055,6196761054,6196761053,6196761052,6196761060}', 'LINESTRING(-79.438293 43.692672,-79.438271 43.692619,-79.438396 43.692591,-79.438396 43.692593,-79.438441 43.692583,-79.438457 43.692622,-79.438412 43.692632,-79.438417 43.692644,-79.438296 43.692671,-79.438293 43.692672)'),
(661895299, 1, 9266764, '2019-01-09 18:39:55'::timestamp, 66178326, '"building"=>"detached"', '{6196761068,6196761067,6196761066,6196761065,6196761064,6196761063,6196761062,6196761061,6196761068}', 'LINESTRING(-79.438321 43.692731,-79.438298 43.692676,-79.438443 43.692644,-79.438449 43.692658,-79.438472 43.692653,-79.438481 43.692675,-79.438458 43.69268,-79.438466 43.692699,-79.438321 43.692731)'),
(661895300, 1, 9266764, '2019-01-09 18:39:55'::timestamp, 66178326, '"building"=>"detached"', '{6196761077,6196761076,6196761075,6196761074,6196761073,6196761072,6196761071,6196761070,6196761069,6196761077}', 'LINESTRING(-79.438972 43.691825,-79.438937 43.691803,-79.438953 43.691789,-79.438936 43.691779,-79.438964 43.691754,-79.439024 43.691703,-79.439076 43.691735,-79.439034 43.691772,-79.438988 43.691811,-79.438972 43.691825)'),
(661895301, 1, 9266764, '2019-01-09 18:39:55'::timestamp, 66178326, '"building"=>"detached"', '{6196761081,6196761080,6196761079,6196761078,6196761081}', 'LINESTRING(-79.439067 43.691935,-79.439021 43.691906,-79.439161 43.691788,-79.439207 43.691817,-79.439067 43.691935)'),
(661895302, 1, 9266764, '2019-01-09 18:39:55'::timestamp, 66178326, '"building"=>"semi"', '{6196761187,6196761186,6196761185,6196761084,6196761083,6196761082,6196761187}', 'LINESTRING(-79.439236 43.691954,-79.439184 43.691922,-79.43915 43.691951,-79.4391 43.69192,-79.439218 43.691819,-79.43932 43.691882,-79.439236 43.691954)'),
(661895303, 1, 9266764, '2019-01-09 18:39:55'::timestamp, 66178326, '"building"=>"detached"', '{6196761191,6196761190,6196761189,6196761188,6196761191}', 'LINESTRING(-79.439108 43.692184,-79.439079 43.692112,-79.439175 43.692092,-79.439204 43.692164,-79.439108 43.692184)'),
(661895304, 1, 9266764, '2019-01-09 18:39:55'::timestamp, 66178326, '"building"=>"semi"', '{6196761201,6196761200,6196761199,6196761198,6196761197,6196761196,6196761195,6196761194,6196761193,6196761192,6196761201}', 'LINESTRING(-79.439302 43.692058,-79.439258 43.692031,-79.439282 43.69201,-79.439233 43.691981,-79.439325 43.6919,-79.43934 43.691887,-79.439442 43.691948,-79.439424 43.691964,-79.439334 43.692042,-79.439325 43.692037,-79.439302 43.692058)'),
(661895305, 1, 9266764, '2019-01-09 18:39:55'::timestamp, 66178326, '"building"=>"detached"', '{6196761207,6196761206,6196761205,6196761204,6196761203,6196761202,6196761207}', 'LINESTRING(-79.438662 43.692367,-79.438652 43.692333,-79.438668 43.692331,-79.438658 43.692299,-79.438853 43.69227,-79.438872 43.692335,-79.438662 43.692367)'),
(661895306, 1, 9266764, '2019-01-09 18:39:55'::timestamp, 66178326, '"building"=>"detached"', '{6196761215,6196761214,6196761213,6196761212,6196761211,6196761210,6196761209,6196761208,6196761215}', 'LINESTRING(-79.438755 43.692437,-79.438725 43.69237,-79.438846 43.692342,-79.438848 43.692346,-79.438868 43.692341,-79.438883 43.692374,-79.438862 43.692379,-79.438875 43.692409,-79.438755 43.692437)'),
(661895307, 1, 9266764, '2019-01-09 18:39:55'::timestamp, 66178326, '"building"=>"detached"', '{6196761222,6196761221,6196761220,6196761219,6196761218,6196761217,6196761216,6196761222}', 'LINESTRING(-79.438736 43.692501,-79.438725 43.692475,-79.438767 43.692465,-79.43876 43.692448,-79.438828 43.692433,-79.438899 43.692417,-79.438918 43.69246,-79.438736 43.692501)'),
(661895308, 1, 9266764, '2019-01-09 18:39:55'::timestamp, 66178326, '"building"=>"detached"', '{6196761234,6196761233,6196761232,6196761231,6196761230,6196761229,6196761228,6196761227,6196761226,6196761225,6196761224,6196761223,6196761234}', 'LINESTRING(-79.438812 43.692552,-79.438808 43.692542,-79.438786 43.692547,-79.438775 43.692521,-79.438797 43.692516,-79.438787 43.692494,-79.438899 43.692469,-79.43891 43.692495,-79.438935 43.69249,-79.438943 43.692508,-79.438917 43.692514,-79.438923 43.692527,-79.438812 43.692552)'),
(661895309, 1, 9266764, '2019-01-09 18:39:55'::timestamp, 66178326, '"building"=>"detached"', '{6196761238,6196761237,6196761236,6196761235,6196761238}', 'LINESTRING(-79.438837 43.692623,-79.438811 43.692562,-79.438926 43.692535,-79.438953 43.692596,-79.438837 43.692623)'),
(661895310, 1, 9266764, '2019-01-09 18:39:56'::timestamp, 66178326, '"building"=>"detached"', '{6196761250,6196761249,6196761248,6196761247,6196761246,6196761245,6196761244,6196761243,6196761242,6196761241,6196761240,6196761239,6196761250}', 'LINESTRING(-79.438867 43.692689,-79.438862 43.692677,-79.438833 43.692683,-79.438825 43.692663,-79.438854 43.692657,-79.438844 43.692632,-79.438954 43.692607,-79.43896 43.692619,-79.438986 43.692613,-79.438995 43.692634,-79.438966 43.69264,-79.438976 43.692664,-79.438867 43.692689)'),
(661895311, 1, 9266764, '2019-01-09 18:39:56'::timestamp, 66178326, '"building"=>"detached"', '{6196761258,6196761257,6196761256,6196761255,6196761254,6196761253,6196761252,6196761251,6196761258}', 'LINESTRING(-79.439165 43.692272,-79.439163 43.692266,-79.439143 43.692271,-79.439109 43.692194,-79.439131 43.692189,-79.43913 43.692186,-79.439254 43.692158,-79.439292 43.692242,-79.439165 43.692272)'),
(661895312, 1, 9266764, '2019-01-09 18:39:56'::timestamp, 66178326, '"building"=>"detached"', '{6196761264,6196761263,6196761262,6196761261,6196761260,6196761259,6196761264}', 'LINESTRING(-79.439227 43.69235,-79.43921 43.692302,-79.439367 43.692273,-79.439382 43.692315,-79.439318 43.692327,-79.43932 43.692333,-79.439227 43.69235)'),
(661895313, 1, 9266764, '2019-01-09 18:39:56'::timestamp, 66178326, '"building"=>"detached"', '{6196761274,6196761273,6196761272,6196761271,6196761270,6196761269,6196761268,6196761267,6196761266,6196761265,6196761274}', 'LINESTRING(-79.439234 43.692423,-79.439214 43.692375,-79.439241 43.692369,-79.439393 43.692336,-79.439409 43.692333,-79.439426 43.692373,-79.439413 43.692376,-79.439353 43.692389,-79.439355 43.692395,-79.439261 43.692416,-79.439234 43.692423)'),
(661895314, 1, 9266764, '2019-01-09 18:39:56'::timestamp, 66178326, '"building"=>"detached"', '{6196761287,6196761286,6196761285,6196761284,6196761283,6196761282,6196761281,6196761280,6196761279,6196761278,6196761277,6196761276,6196761275,6196761287}', 'LINESTRING(-79.439319 43.692549,-79.439316 43.692544,-79.439292 43.692549,-79.439276 43.692508,-79.439299 43.692503,-79.439298 43.692499,-79.439376 43.692483,-79.439413 43.692475,-79.439425 43.692505,-79.439407 43.69251,-79.439409 43.692516,-79.439393 43.692519,-79.439398 43.692532,-79.439319 43.692549)'),
(661895315, 1, 9266764, '2019-01-09 18:39:56'::timestamp, 66178326, '"building"=>"detached"', '{6196761291,6196761290,6196761289,6196761288,6196761291}', 'LINESTRING(-79.439325 43.692626,-79.4393 43.692571,-79.439449 43.692536,-79.439473 43.692592,-79.439325 43.692626)'),
(661895319, 1, 9266764, '2019-01-09 18:39:56'::timestamp, 66178326, '"building"=>"detached"', '{6196761324,6196761323,6196761322,6196761321,6196761320,6196761319,6196761318,6196761317,6196761324}', 'LINESTRING(-79.438349 43.692805,-79.438326 43.692749,-79.43848 43.692715,-79.438486 43.692731,-79.43851 43.692726,-79.43852 43.69275,-79.438496 43.692756,-79.438503 43.692771,-79.438349 43.692805)'),
(661895320, 1, 9266764, '2019-01-09 18:39:56'::timestamp, 66178326, '"building"=>"detached"', '{6196761332,6196761331,6196761330,6196761329,6196761328,6196761327,6196761326,6196761325,6196761332}', 'LINESTRING(-79.438373 43.692863,-79.438357 43.692827,-79.438378 43.692823,-79.43837 43.692804,-79.438521 43.692771,-79.438539 43.692813,-79.438508 43.69282,-79.438513 43.692833,-79.438373 43.692863)'),
(661895321, 1, 9266764, '2019-01-09 18:39:56'::timestamp, 66178326, '"building"=>"detached"', '{6196761340,6196761339,6196761338,6196761337,6196761336,6196761335,6196761334,6196761333,6196761340}', 'LINESTRING(-79.438425 43.692933,-79.4384 43.692874,-79.438521 43.692847,-79.438527 43.692861,-79.438561 43.692854,-79.438578 43.692893,-79.438542 43.692901,-79.438544 43.692906,-79.438425 43.692933)'),
(661895322, 1, 9266764, '2019-01-09 18:39:56'::timestamp, 66178326, '"building"=>"detached"', '{6196761346,6196761345,6196761344,6196761343,6196761342,6196761341,6196761346}', 'LINESTRING(-79.43847 43.693188,-79.438464 43.693173,-79.438422 43.693073,-79.438492 43.693058,-79.438534 43.693159,-79.438539 43.693173,-79.43847 43.693188)'),
(661895323, 1, 9266764, '2019-01-09 18:39:56'::timestamp, 66178326, '"building"=>"detached"', '{6196761354,6196761353,6196761352,6196761351,6196761350,6196761349,6196761348,6196761347,6196761354}', 'LINESTRING(-79.43858 43.693165,-79.438573 43.693149,-79.438525 43.69303,-79.438592 43.693016,-79.43861 43.693061,-79.438613 43.693061,-79.438643 43.693135,-79.438649 43.693151,-79.43858 43.693165)'),
(661895324, 1, 9266764, '2019-01-09 18:39:56'::timestamp, 66178326, '"building"=>"detached"', '{6196761365,6196761364,6196761363,6196761362,6196761361,6196761360,6196761359,6196761358,6196761357,6196761356,6196761355,6196761365}', 'LINESTRING(-79.438649 43.693149,-79.438643 43.693134,-79.438614 43.693062,-79.4386 43.693027,-79.438644 43.693018,-79.43865 43.693032,-79.438666 43.693029,-79.438673 43.693047,-79.438682 43.693045,-79.438712 43.69312,-79.438718 43.693134,-79.438649 43.693149)'),
(661895329, 1, 9266764, '2019-01-09 18:39:57'::timestamp, 66178326, '"building"=>"detached"', '{6196761605,6196761604,6196761603,6196761602,6196761601,6196761600,6196761599,6196761598,6196761597,6196761596,6196761595,6196761605}', 'LINESTRING(-79.438891 43.69275,-79.438885 43.692735,-79.438864 43.69274,-79.438856 43.692722,-79.438878 43.692717,-79.438867 43.692692,-79.438977 43.692667,-79.438988 43.692692,-79.43901 43.692687,-79.439024 43.69272,-79.439001 43.692725,-79.438891 43.69275)'),
(661895331, 1, 9266764, '2019-01-09 18:39:57'::timestamp, 66178326, '"building"=>"detached"', '{6196761613,6196761612,6196761611,6196761610,6196761609,6196761608,6196761607,6196761606,6196761613}', 'LINESTRING(-79.438901 43.692829,-79.438884 43.692791,-79.438926 43.692782,-79.438917 43.692761,-79.439008 43.692741,-79.439018 43.692765,-79.439031 43.692762,-79.439046 43.692796,-79.438901 43.692829)'),
(661895332, 1, 9266764, '2019-01-09 18:39:57'::timestamp, 66178326, '"building"=>"detached"', '{6196761627,6196761626,6196761625,6196761624,6196761623,6196761622,6196761621,6196761620,6196761619,6196761618,6196761617,6196761616,6196761615,6196761614,6196761627}', 'LINESTRING(-79.438761 43.69312,-79.438754 43.693105,-79.438749 43.693092,-79.438729 43.693044,-79.438734 43.693043,-79.438716 43.692999,-79.438769 43.692987,-79.438782 43.69302,-79.438793 43.693017,-79.438797 43.693029,-79.438817 43.693077,-79.438823 43.69309,-79.438785 43.693099,-79.438792 43.693113,-79.438761 43.69312)'),
(661895334, 1, 9266764, '2019-01-09 18:39:57'::timestamp, 66178326, '"building"=>"detached"', '{6196761634,6196761633,6196761632,6196761631,6196761630,6196761629,6196761628,6196761634}', 'LINESTRING(-79.438834 43.693114,-79.438789 43.692995,-79.438777 43.692966,-79.438838 43.692953,-79.438849 43.692982,-79.438855 43.692981,-79.4389 43.6931,-79.438834 43.693114)'),
(661895335, 1, 9266764, '2019-01-09 18:39:57'::timestamp, 66178326, '"building"=>"detached"', '{6196761644,6196761643,6196761642,6196761641,6196761640,6196761639,6196761638,6196761637,6196761636,6196761635,6196761644}', 'LINESTRING(-79.438923 43.693093,-79.438872 43.692973,-79.438877 43.692972,-79.438874 43.692963,-79.438917 43.692953,-79.43892 43.692962,-79.43895 43.692955,-79.438995 43.693059,-79.438971 43.693064,-79.438978 43.69308,-79.438923 43.693093)'),
(661895336, 1, 9266764, '2019-01-09 18:39:57'::timestamp, 66178326, '"building"=>"detached"', '{6196761648,6196761647,6196761646,6196761645,6196761648}', 'LINESTRING(-79.439024 43.693074,-79.438971 43.692951,-79.43905 43.692933,-79.439103 43.693056,-79.439024 43.693074)'),
(661895337, 1, 9266764, '2019-01-09 18:39:57'::timestamp, 66178326, '"building"=>"detached"', '{6196761652,6196761651,6196761650,6196761649,6196761652}', 'LINESTRING(-79.439112 43.693054,-79.439053 43.692917,-79.439136 43.692898,-79.439195 43.693035,-79.439112 43.693054)'),
(661895463, 1, 9266764, '2019-01-09 18:40:05'::timestamp, 66178326, '"building"=>"semi"', '{6196764335,6196764334,6196764333,6196764332,6196764331,6196764330,6196764335}', 'LINESTRING(-79.439451 43.69211,-79.439351 43.69205,-79.43944 43.691971,-79.439453 43.69196,-79.439553 43.69202,-79.439539 43.692033,-79.439451 43.69211)'),
(661895464, 1, 9266764, '2019-01-09 18:40:06'::timestamp, 66178326, '"building"=>"semi"', '{6196764342,6196764341,6196764340,6196764339,6196764338,6196764337,6196764336,6196764342}', 'LINESTRING(-79.439555 43.692172,-79.439464 43.692118,-79.439554 43.692039,-79.439562 43.692044,-79.439575 43.692033,-79.439658 43.692082,-79.439641 43.692096,-79.439555 43.692172)'),
(661895465, 1, 9266764, '2019-01-09 18:40:06'::timestamp, 66178326, '"building"=>"yes"', '{6196764354,6196764353,6196764352,6196764351,6196764350,6196764349,6196764348,6196764347,6196764346,6196764345,6196764344,6196764343,6196764354}', 'LINESTRING(-79.439666 43.692196,-79.439595 43.692153,-79.439657 43.692099,-79.439659 43.6921,-79.439678 43.692083,-79.439728 43.692113,-79.439709 43.69213,-79.439729 43.692142,-79.439706 43.692162,-79.439719 43.69217,-79.43969 43.692196,-79.439676 43.692187,-79.439666 43.692196)'),
(661895466, 1, 9266764, '2019-01-09 18:40:06'::timestamp, 66178326, '"building"=>"commercial"', '{6196764360,6196764359,6196764358,6196764357,6196764356,6196764355,6196764360}', 'LINESTRING(-79.439879 43.691955,-79.439824 43.691921,-79.439825 43.691919,-79.439737 43.691864,-79.439916 43.691712,-79.440023 43.691833,-79.439879 43.691955)'),
(661895467, 1, 9266764, '2019-01-09 18:40:06'::timestamp, 66178326, '"building"=>"detached"', '{6196764364,6196764363,6196764362,6196764361,6196764364}', 'LINESTRING(-79.439335 43.692678,-79.439315 43.692633,-79.439513 43.692587,-79.439534 43.692632,-79.439335 43.692678)'),
(661895468, 1, 9266764, '2019-01-09 18:40:06'::timestamp, 66178326, '"building"=>"detached"', '{6196764372,6196764371,6196764370,6196764369,6196764368,6196764367,6196764366,6196764365,6196764372}', 'LINESTRING(-79.439396 43.692737,-79.439389 43.692722,-79.439379 43.692724,-79.439366 43.692694,-79.439373 43.692693,-79.439373 43.692691,-79.439534 43.692653,-79.439555 43.6927,-79.439396 43.692737)'),
(661895469, 1, 9266764, '2019-01-09 18:40:06'::timestamp, 66178326, '"building"=>"retail"', '{6196764375,6196764374,6196764373,6196764376,6196764375}', 'LINESTRING(-79.439644 43.692483,-79.439553 43.692265,-79.439861 43.692197,-79.440173 43.692367,-79.439644 43.692483)'),
(661895470, 1, 9266764, '2019-01-09 18:40:06'::timestamp, 66178326, '"building"=>"commercial"', '{6196764388,6196764387,6196764386,6196764385,6196764384,6196764383,6196764382,6196764381,6196764380,6196764379,6196764388}', 'LINESTRING(-79.440094 43.691942,-79.439995 43.691867,-79.440058 43.69182,-79.44009 43.691804,-79.439982 43.691542,-79.440176 43.691499,-79.440286 43.69176,-79.440331 43.691865,-79.440126 43.691911,-79.440132 43.691919,-79.440094 43.691942)'),
(661895471, 1, 9266764, '2019-01-09 18:40:06'::timestamp, 66178326, '"building"=>"retail"', '{6196764402,6196764401,6196764400,6196764399,6196764398,6196764397,6196764402}', 'LINESTRING(-79.4405901 43.6918092,-79.4405721 43.6917702,-79.4407051 43.6917402,-79.4407271 43.6917342,-79.4407451 43.6917742,-79.4407181 43.6917802,-79.4405901 43.6918092)'),
(661895472, 1, 9266764, '2019-01-09 18:40:06'::timestamp, 66178326, '"building"=>"retail"', '{6196764410,6196764409,6196764408,6196764407,6196764406,6196764405,6196764404,6196764403,6196764410}', 'LINESTRING(-79.4406017 43.6918639,-79.4405797 43.6918139,-79.4406737 43.6917929,-79.4407667 43.6917719,-79.4408287 43.6917569,-79.4408507 43.6918069,-79.4407897 43.6918209,-79.4406987 43.6918419,-79.4406017 43.6918639)'),
(661895473, 1, 9266764, '2019-01-09 18:40:06'::timestamp, 66178326, '"building"=>"retail"', '{6196764971,6196764414,6196764413,6196764412,6196764411,6196764970,6196764971}', 'LINESTRING(-79.440614 43.691906,-79.440597 43.691866,-79.440777 43.691826,-79.44079 43.691857,-79.440709 43.691876,-79.440713 43.691884,-79.440614 43.691906)'),
(661895474, 1, 9266764, '2019-01-09 18:40:06'::timestamp, 66178326, '"building"=>"retail"', '{6196764428,6196764427,6196764426,6196764425,6196764424,6196764423,6196764422,6196764421,6196764420,6196764430,6196764419,6196764418,6196764417,6196764416,6196764428}', 'LINESTRING(-79.440208 43.692632,-79.440204 43.692623,-79.440185 43.692579,-79.440082 43.692603,-79.440028 43.692615,-79.440001 43.692552,-79.440051 43.692541,-79.440155 43.692517,-79.440355 43.692472,-79.440508 43.692555,-79.440329 43.692595,-79.440336 43.692612,-79.440286 43.692623,-79.440282 43.692615,-79.440208 43.692632)'),
(661895475, 1, 9266764, '2019-01-09 18:40:06'::timestamp, 66178326, '"building"=>"retail"', '{6196764439,6196764438,6196764437,6196764436,6196764435,6196764434,6196764433,6196764432,6196764431,6196764430,6196764429,6196764439}', 'LINESTRING(-79.440426 43.692694,-79.440421 43.692683,-79.440384 43.692692,-79.440369 43.692656,-79.44041 43.692647,-79.440514 43.692623,-79.440505 43.692601,-79.440372 43.692631,-79.440355 43.69259,-79.440508 43.692555,-79.440659 43.692642,-79.440426 43.692694)'),
(661895476, 1, 9266764, '2019-01-09 18:40:06'::timestamp, 66178326, '"building"=>"detached"', '{6196764447,6196764446,6196764445,6196764444,6196764443,6196764442,6196764441,6196764440,6196764447}', 'LINESTRING(-79.439428 43.692972,-79.439386 43.692871,-79.439421 43.692864,-79.439415 43.692849,-79.43945 43.692842,-79.439456 43.692856,-79.439495 43.692848,-79.439536 43.692948,-79.439428 43.692972)'),
(661895477, 1, 9266764, '2019-01-09 18:40:06'::timestamp, 66178326, '"building"=>"detached"', '{6196764460,6196764459,6196764458,6196764457,6196764456,6196764455,6196764454,6196764453,6196764452,6196764451,6196764450,6196764449,6196764448,6196764460}', 'LINESTRING(-79.439555 43.69296,-79.439546 43.692938,-79.43954 43.692939,-79.439506 43.692858,-79.43949 43.692823,-79.439547 43.692811,-79.439552 43.692824,-79.439564 43.692821,-79.439572 43.692841,-79.439586 43.692838,-79.439621 43.692923,-79.439574 43.692934,-79.439582 43.692954,-79.439555 43.69296)'),
(661895478, 1, 9266764, '2019-01-09 18:40:06'::timestamp, 66178326, '"building"=>"detached"', '{6196764468,6196764467,6196764466,6196764465,6196764464,6196764463,6196764462,6196764461,6196764468}', 'LINESTRING(-79.439734 43.692919,-79.439726 43.6929,-79.439719 43.692902,-79.439685 43.692818,-79.439764 43.692801,-79.439797 43.692882,-79.439758 43.692891,-79.439766 43.692912,-79.439734 43.692919)'),
(661895479, 1, 9266764, '2019-01-09 18:40:06'::timestamp, 66178326, '"building"=>"detached"', '{6196764478,6196764477,6196764476,6196764475,6196764474,6196764473,6196764472,6196764471,6196764470,6196764469,6196764478}', 'LINESTRING(-79.439834 43.692895,-79.439826 43.692876,-79.439798 43.692807,-79.439819 43.692803,-79.439811 43.692783,-79.439862 43.692772,-79.439869 43.692789,-79.439898 43.692859,-79.439858 43.692868,-79.439867 43.692888,-79.439834 43.692895)'),
(661895480, 1, 9266764, '2019-01-09 18:40:07'::timestamp, 66178326, '"building"=>"detached"', '{6196764490,6196764489,6196764488,6196764487,6196764486,6196764485,6196764484,6196764483,6196764482,6196764481,6196764480,6196764479,6196764490}', 'LINESTRING(-79.439927 43.692869,-79.43989 43.69278,-79.439898 43.692778,-79.439886 43.69275,-79.43995 43.692737,-79.439962 43.692765,-79.439971 43.692763,-79.439963 43.692744,-79.440008 43.692734,-79.440016 43.692753,-79.440035 43.692749,-79.440071 43.692838,-79.439927 43.692869)'),
(661895496, 1, 9266764, '2019-01-09 18:40:08'::timestamp, 66178326, '"building"=>"detached"', '{6196764642,6196764641,6196764640,6196764639,6196764638,6196764637,6196764636,6196764635,6196764642}', 'LINESTRING(-79.440096 43.692833,-79.440059 43.692743,-79.440078 43.692739,-79.44007 43.692721,-79.440114 43.692711,-79.440122 43.692731,-79.440138 43.692727,-79.440175 43.692815,-79.440096 43.692833)'),
(661895497, 1, 9266764, '2019-01-09 18:40:08'::timestamp, 66178326, '"building"=>"detached"', '{6196764654,6196764653,6196764652,6196764651,6196764650,6196764649,6196764648,6196764647,6196764646,6196764645,6196764644,6196764643,6196764654}', 'LINESTRING(-79.440275 43.692792,-79.440263 43.692763,-79.440257 43.692765,-79.440253 43.692755,-79.440226 43.69269,-79.440221 43.692679,-79.440267 43.692669,-79.440273 43.692682,-79.440295 43.692677,-79.440327 43.692753,-79.440317 43.692755,-79.440327 43.69278,-79.440275 43.692792)'),
(661895502, 1, 9266764, '2019-01-09 18:40:08'::timestamp, 66178326, '"building"=>"retail"', '{6196764893,6196764892,6196764891,6196764890,6196764889,6196764888,6196764887,6196764893}', 'LINESTRING(-79.44046 43.692772,-79.440444 43.692733,-79.440389 43.692745,-79.440375 43.692711,-79.440428 43.692699,-79.440662 43.692647,-79.440729 43.692711,-79.44046 43.692772)'),
(661895510, 1, 9266764, '2019-01-09 18:40:08'::timestamp, 66178326, '"building"=>"retail"', '{6196764981,6196764975,6196764974,6196764973,6196764972,6196764971,6196764970,6196764969,6196764968,6196764978,6196764979,6196764980,6196764981}', 'LINESTRING(-79.440676 43.692035,-79.440673 43.691993,-79.440663 43.691996,-79.440651 43.691968,-79.440641 43.69197,-79.440614 43.691906,-79.440713 43.691884,-79.441001 43.691818,-79.441057 43.691949,-79.44105 43.691951,-79.440975 43.691968,-79.440847 43.691997,-79.440676 43.692035)'),
(661895512, 1, 9266764, '2019-01-09 18:40:09'::timestamp, 66178326, '"building"=>"retail"', '{6196764984,6196764983,6196764982,6196764981,6196764980,6196764979,6196764978,6196764977,6196764976,6196765087,6196765088,6196765089,6196764984}', 'LINESTRING(-79.44068 43.692078,-79.44067 43.692055,-79.440677 43.692053,-79.440676 43.692035,-79.440847 43.691997,-79.440975 43.691968,-79.44105 43.691951,-79.441061 43.691976,-79.440988 43.691992,-79.440994 43.692007,-79.440864 43.692036,-79.440688 43.692076,-79.44068 43.692078)'),
(661895513, 1, 9266764, '2019-01-09 18:40:09'::timestamp, 66178326, '"building"=>"retail"', '{6196765094,6196765089,6196765088,6196765087,6196765086,6196765085,6196765093,6196765094}', 'LINESTRING(-79.440709 43.692125,-79.440688 43.692076,-79.440864 43.692036,-79.440994 43.692007,-79.441037 43.691997,-79.441058 43.692046,-79.440901 43.692081,-79.440709 43.692125)'),
(661895514, 1, 9266764, '2019-01-09 18:40:09'::timestamp, 66178326, '"building"=>"retail"', '{6196765100,6196765099,6196765098,6196765097,6196765096,6196765095,6196765094,6196765093,6196765092,6196765091,6196765090,6196765100}', 'LINESTRING(-79.44076 43.692152,-79.440747 43.692152,-79.440734 43.69215,-79.440723 43.692148,-79.44071 43.692151,-79.4407 43.692127,-79.440709 43.692125,-79.440901 43.692081,-79.440917 43.692118,-79.440783 43.692148,-79.440773 43.692151,-79.44076 43.692152)'),
(661895515, 1, 9266764, '2019-01-09 18:40:09'::timestamp, 66178326, '"building"=>"semi"', '{6196765111,6196765110,6196765109,6196765108,6196765107,6196765106,6196765105,6196765104,6196765103,6196765102,6196765101,6196765111}', 'LINESTRING(-79.441135 43.692018,-79.441128 43.692002,-79.441088 43.691913,-79.441156 43.691898,-79.441151 43.691887,-79.441171 43.691882,-79.441169 43.691878,-79.441202 43.69187,-79.441209 43.691887,-79.441248 43.691975,-79.441255 43.69199,-79.441135 43.692018)'),
(661895516, 1, 9266764, '2019-01-09 18:40:09'::timestamp, 66178326, '"building"=>"semi"', '{6196765128,6196765127,6196765126,6196765125,6196765124,6196765123,6196765122,6196765121,6196765120,6196765119,6196765118,6196765117,6196765116,6196765115,6196765114,6196765113,6196765112,6196765128}', 'LINESTRING(-79.441283 43.691989,-79.441274 43.69197,-79.441269 43.691971,-79.44123 43.691885,-79.441236 43.691884,-79.441226 43.691862,-79.441257 43.691854,-79.441241 43.69182,-79.441287 43.691809,-79.441303 43.691845,-79.441353 43.691833,-79.441362 43.691852,-79.44138 43.691848,-79.44142 43.691937,-79.441349 43.691953,-79.441296 43.691966,-79.441304 43.691984,-79.441283 43.691989)'),
(661895517, 1, 9266764, '2019-01-09 18:40:09'::timestamp, 66178326, '"building"=>"retail"', '{6196765135,6196765131,6196765130,6196765129,6196765134,6196765135}', 'LINESTRING(-79.440826 43.692346,-79.440799 43.692297,-79.441013 43.692248,-79.441034 43.692287,-79.441028 43.692289,-79.440826 43.692346)'),
(661895518, 1, 9266764, '2019-01-09 18:40:09'::timestamp, 66178326, '"building"=>"retail"', '{6196765141,6196765135,6196765134,6196765133,6196765132,6196765140,6196765141}', 'LINESTRING(-79.440849 43.69239,-79.440826 43.692346,-79.441028 43.692289,-79.441047 43.692325,-79.44094 43.692356,-79.440944 43.692363,-79.440849 43.69239)'),
(661895519, 1, 9266764, '2019-01-09 18:40:09'::timestamp, 66178326, '"building"=>"retail"', '{6196765145,6196765141,6196765140,6196765139,6196765138,6196765137,6196765136,6196765144,6196765145}', 'LINESTRING(-79.44087 43.692429,-79.440849 43.69239,-79.440944 43.692363,-79.441025 43.69234,-79.441029 43.692346,-79.44108 43.692332,-79.441093 43.692356,-79.441045 43.692379,-79.44087 43.692429)'),
(661895520, 1, 9266764, '2019-01-09 18:40:09'::timestamp, 66178326, '"building"=>"retail"', '{6196765150,6196765145,6196765144,6196765143,6196765142,6196765149,6196765150}', 'LINESTRING(-79.440894 43.692472,-79.44087 43.692429,-79.441045 43.692379,-79.441064 43.692415,-79.440984 43.692438,-79.440988 43.692445,-79.440894 43.692472)'),
(661895521, 1, 9266764, '2019-01-09 18:40:09'::timestamp, 66178326, '"building"=>"retail"', '{6196765154,6196765150,6196765149,6196765148,6196765147,6196765146,6196765151,6196765152,6196765153,6196765154}', 'LINESTRING(-79.440914 43.69251,-79.440894 43.692472,-79.440988 43.692445,-79.441068 43.692422,-79.441083 43.692418,-79.441093 43.692436,-79.441078 43.692441,-79.441065 43.692456,-79.441053 43.692471,-79.440914 43.69251)'),
(661895522, 1, 9266764, '2019-01-09 18:40:09'::timestamp, 66178326, '"building"=>"retail"', '{6196765159,6196765155,6196765154,6196765153,6196765152,6196765151,6196765157,6196765158,6196765159}', 'LINESTRING(-79.440999 43.692586,-79.440942 43.692561,-79.440914 43.69251,-79.441053 43.692471,-79.441065 43.692456,-79.441078 43.692441,-79.441108 43.692454,-79.441095 43.692469,-79.440999 43.692586)'),
(661895523, 1, 9266764, '2019-01-09 18:40:09'::timestamp, 66178326, '"building"=>"semi"', '{6196765172,6196765171,6196765170,6196765169,6196765168,6196765167,6196765166,6196765165,6196765164,6196765163,6196765162,6196765161,6196765160,6196765172}', 'LINESTRING(-79.441277 43.692329,-79.441268 43.692309,-79.441234 43.692229,-79.441224 43.692207,-79.44137 43.692174,-79.441378 43.692193,-79.441415 43.692277,-79.441399 43.692281,-79.44141 43.692305,-79.441358 43.692317,-79.441346 43.692291,-79.441311 43.692299,-79.441319 43.692319,-79.441277 43.692329)'),
(661895524, 1, 9266764, '2019-01-09 18:40:09'::timestamp, 66178326, '"building"=>"retail"', '{6196765192,6196765190,6196765189,6196765188,6196765187,6196765186,6196765185,6196765184,6196765183,6196765191,6196765192}', 'LINESTRING(-79.441338 43.692733,-79.44127 43.692703,-79.441314 43.69265,-79.441358 43.692597,-79.441367 43.692586,-79.441413 43.692606,-79.441417 43.692601,-79.441438 43.692611,-79.441426 43.692626,-79.441366 43.692698,-79.441338 43.692733)'),
(661895525, 1, 9266764, '2019-01-09 18:40:09'::timestamp, 66178326, '"building"=>"semi"', '{6196765210,6196765209,6196765208,6196765207,6196765206,6196765205,6196765204,6196765203,6196765202,6196765201,6196765200,6196765199,6196765198,6196765197,6196765196,6196765195,6196765194,6196765193,6196765210}', 'LINESTRING(-79.441447 43.691955,-79.441437 43.691933,-79.441399 43.691847,-79.44141 43.691845,-79.441403 43.69183,-79.441449 43.691819,-79.441457 43.691836,-79.441498 43.691826,-79.441491 43.691811,-79.441522 43.691804,-79.441528 43.691819,-79.441547 43.691815,-79.441584 43.691899,-79.441593 43.691918,-79.441551 43.691928,-79.441542 43.691908,-79.441478 43.691923,-79.441487 43.691945,-79.441447 43.691955)'),
(661895526, 1, 9266764, '2019-01-09 18:40:10'::timestamp, 66178326, '"building"=>"detached"', '{6196765222,6196765221,6196765220,6196765219,6196765218,6196765217,6196765216,6196765215,6196765214,6196765213,6196765212,6196765211,6196765222}', 'LINESTRING(-79.441785 43.691876,-79.441776 43.691857,-79.441767 43.691859,-79.441728 43.691772,-79.441753 43.691767,-79.441746 43.691752,-79.441769 43.691747,-79.441776 43.691763,-79.441808 43.691756,-79.441846 43.691841,-79.441805 43.69185,-79.441813 43.691869,-79.441785 43.691876)'),
(661895527, 1, 9266764, '2019-01-09 18:40:10'::timestamp, 66178326, '"building"=>"semi"', '{6196765234,6196765233,6196765232,6196765231,6196765230,6196765229,6196765228,6196765227,6196765226,6196765225,6196765224,6196765223,6196765234}', 'LINESTRING(-79.441622 43.691914,-79.441614 43.691894,-79.441604 43.691896,-79.441566 43.69181,-79.441713 43.691776,-79.441751 43.691863,-79.441741 43.691865,-79.44175 43.691885,-79.441718 43.691892,-79.441709 43.691872,-79.441645 43.691887,-79.441654 43.691906,-79.441622 43.691914)'),
(661895528, 1, 9266764, '2019-01-09 18:40:10'::timestamp, 66178326, '"building"=>"semi"', '{6196765244,6196765243,6196765242,6196765241,6196765240,6196765239,6196765238,6196765237,6196765236,6196765235,6196765244}', 'LINESTRING(-79.4416 43.692235,-79.441564 43.692152,-79.441555 43.692131,-79.441602 43.69212,-79.441612 43.692142,-79.441666 43.69213,-79.441657 43.692109,-79.441703 43.692098,-79.441712 43.692119,-79.441747 43.692201,-79.4416 43.692235)'),
(661895529, 1, 9266764, '2019-01-09 18:40:10'::timestamp, 66178326, '"building"=>"detached"', '{6196765252,6196765251,6196765250,6196765249,6196765248,6196765247,6196765246,6196765245,6196765252}', 'LINESTRING(-79.441861 43.691857,-79.441853 43.691841,-79.441815 43.691755,-79.441806 43.691733,-79.441884 43.691715,-79.441893 43.691736,-79.441931 43.691821,-79.441939 43.691839,-79.441861 43.691857)'),
(661895530, 1, 9266764, '2019-01-09 18:40:10'::timestamp, 66178326, '"building"=>"detached"', '{6196765262,6196765261,6196765260,6196765259,6196765258,6196765257,6196765256,6196765255,6196765254,6196765253,6196765262}', 'LINESTRING(-79.44196 43.691834,-79.441953 43.691817,-79.441915 43.691732,-79.441942 43.691725,-79.441933 43.691706,-79.44197 43.691698,-79.441979 43.691718,-79.441996 43.691714,-79.442034 43.6918,-79.442041 43.691816,-79.44196 43.691834)'),
(661895531, 1, 9266764, '2019-01-09 18:40:10'::timestamp, 66178326, '"building"=>"detached"', '{6196765270,6196765269,6196765268,6196765267,6196765266,6196765265,6196765264,6196765263,6196765270}', 'LINESTRING(-79.44213 43.691797,-79.442042 43.691787,-79.442061 43.691696,-79.442082 43.691699,-79.442087 43.691678,-79.442121 43.691682,-79.442117 43.691703,-79.442149 43.691707,-79.44213 43.691797)'),
(661895532, 1, 9266764, '2019-01-09 18:40:10'::timestamp, 66178326, '"building"=>"semi"', '{6196765284,6196765283,6196765282,6196765281,6196765280,6196765279,6196765278,6196765277,6196765276,6196765275,6196765274,6196765273,6196765272,6196765271,6196765284}', 'LINESTRING(-79.441765 43.692199,-79.441728 43.692115,-79.44172 43.692097,-79.441763 43.692087,-79.441772 43.692107,-79.441808 43.692098,-79.441801 43.692081,-79.441804 43.69208,-79.441868 43.692065,-79.441876 43.692084,-79.441912 43.692076,-79.441936 43.692131,-79.441899 43.692139,-79.441911 43.692166,-79.441765 43.692199)'),
(661895533, 1, 9266764, '2019-01-09 18:40:10'::timestamp, 66178326, '"building"=>"semi"', '{6196765294,6196765293,6196765292,6196765291,6196765290,6196765289,6196765288,6196765287,6196765286,6196765285,6196765294}', 'LINESTRING(-79.441432 43.692273,-79.441396 43.69219,-79.441388 43.692172,-79.44143 43.692162,-79.441438 43.692181,-79.441474 43.692173,-79.441465 43.692152,-79.441536 43.692136,-79.441545 43.692157,-79.441581 43.692239,-79.441432 43.692273)'),
(661895534, 1, 9266764, '2019-01-09 18:40:10'::timestamp, 66178326, '"building"=>"detached"', '{6196765302,6196765301,6196765300,6196765299,6196765298,6196765297,6196765296,6196765295,6196765302}', 'LINESTRING(-79.44217 43.692551,-79.442029 43.692503,-79.442039 43.692487,-79.442014 43.692479,-79.442028 43.692458,-79.442055 43.692467,-79.442066 43.69245,-79.442205 43.692497,-79.44217 43.692551)'),
(661895535, 1, 9266764, '2019-01-09 18:40:10'::timestamp, 66178326, '"building"=>"detached"', '{6196765309,6196765308,6196765307,6196765306,6196765305,6196765304,6196765303,6196765309}', 'LINESTRING(-79.442163 43.692618,-79.441995 43.69256,-79.442006 43.692543,-79.441949 43.692523,-79.441973 43.692486,-79.44203 43.692506,-79.442198 43.692564,-79.442163 43.692618)'),
(661895536, 1, 9266764, '2019-01-09 18:40:10'::timestamp, 66178326, '"building"=>"detached"', '{6196765319,6196765318,6196765317,6196765316,6196765315,6196765314,6196765313,6196765312,6196765311,6196765310,6196765319}', 'LINESTRING(-79.442126 43.692677,-79.441995 43.692632,-79.442001 43.692622,-79.441967 43.692611,-79.441989 43.692578,-79.441998 43.692563,-79.442034 43.692575,-79.442139 43.692611,-79.442129 43.692626,-79.442154 43.692634,-79.442126 43.692677)'),
(661895548, 1, 9266764, '2019-01-09 18:40:11'::timestamp, 66178326, '"building"=>"yes"', '{6196765368,6196765367,6196765366,6196765365,6196765364,6196765363,6196765368}', 'LINESTRING(-79.441867 43.692933,-79.441763 43.692895,-79.441774 43.692879,-79.441846 43.692772,-79.44195 43.692809,-79.441879 43.692915,-79.441867 43.692933)'),
(661896900, 1, 9266764, '2019-01-09 18:41:39'::timestamp, 66178384, '"building"=>"detached"', '{6196791052,6196791051,6196791050,6196791049,6196791048,6196791047,6196791046,6196791045,6196791044,6196791052}', 'LINESTRING(-79.442465 43.692083,-79.442444 43.692076,-79.442294 43.692022,-79.442263 43.692011,-79.442279 43.691987,-79.442308 43.691997,-79.442331 43.691963,-79.442484 43.692018,-79.442505 43.692025,-79.442465 43.692083)'),
(661896901, 1, 9266764, '2019-01-09 18:41:39'::timestamp, 66178384, '"building"=>"detached"', '{6196791060,6196791059,6196791058,6196791057,6196791056,6196791055,6196791054,6196791053,6196791060}', 'LINESTRING(-79.442511 43.692022,-79.442362 43.691972,-79.442372 43.691957,-79.44234 43.691947,-79.442364 43.691909,-79.44252 43.69196,-79.44251 43.691975,-79.442535 43.691983,-79.442511 43.692022)'),
(661896902, 1, 9266764, '2019-01-09 18:41:39'::timestamp, 66178384, '"building"=>"detached"', '{6196791072,6196791071,6196791070,6196791069,6196791068,6196791067,6196791066,6196791065,6196791064,6196791063,6196791062,6196791061,6196791072}', 'LINESTRING(-79.442417 43.692149,-79.442401 43.692144,-79.442276 43.692099,-79.442288 43.692081,-79.442263 43.692073,-79.442249 43.692067,-79.442266 43.692043,-79.442279 43.692048,-79.442287 43.692037,-79.442309 43.692045,-79.442435 43.692089,-79.442453 43.692096,-79.442417 43.692149)'),
(661896903, 1, 9266764, '2019-01-09 18:41:39'::timestamp, 66178384, '"building"=>"detached"', '{6196791078,6196791077,6196791076,6196791075,6196791074,6196791073,6196791078}', 'LINESTRING(-79.442409 43.692217,-79.442391 43.692211,-79.442201 43.692147,-79.442228 43.692104,-79.442415 43.692167,-79.442436 43.692174,-79.442409 43.692217)'),
(661896904, 1, 9266764, '2019-01-09 18:41:39'::timestamp, 66178384, '"building"=>"detached"', '{6196791086,6196791085,6196791084,6196791083,6196791082,6196791081,6196791080,6196791079,6196791086}', 'LINESTRING(-79.442608 43.691822,-79.442593 43.691814,-79.442496 43.691768,-79.442462 43.691751,-79.442509 43.691699,-79.442541 43.691714,-79.442637 43.691761,-79.442655 43.69177,-79.442608 43.691822)'),
(661896905, 1, 9266764, '2019-01-09 18:41:39'::timestamp, 66178384, '"building"=>"detached"', '{6196791095,6196791094,6196791093,6196791092,6196791091,6196791090,6196791089,6196791088,6196791087,6196791095}', 'LINESTRING(-79.442594 43.691899,-79.442565 43.691889,-79.442457 43.691854,-79.442424 43.691843,-79.442457 43.69179,-79.442491 43.691801,-79.442595 43.691836,-79.44259 43.691843,-79.442622 43.691854,-79.442594 43.691899)'),
(661896906, 1, 9266764, '2019-01-09 18:41:39'::timestamp, 66178384, '"building"=>"detached"', '{6196791104,6196791103,6196791102,6196791101,6196791100,6196791099,6196791098,6196791097,6196791096,6196791104}', 'LINESTRING(-79.442555 43.691955,-79.442527 43.691946,-79.442423 43.691911,-79.44243 43.6919,-79.442395 43.691889,-79.442422 43.691845,-79.442456 43.691856,-79.442564 43.691892,-79.44259 43.691901,-79.442555 43.691955)'),
(661896907, 1, 9266764, '2019-01-09 18:41:39'::timestamp, 66178384, '"building"=>"detached"', '{6196791112,6196791111,6196791110,6196791109,6196791108,6196791107,6196791106,6196791105,6196791112}', 'LINESTRING(-79.442332 43.692342,-79.442311 43.692336,-79.442189 43.692295,-79.442206 43.692267,-79.442179 43.692258,-79.442197 43.692229,-79.44235 43.69228,-79.442368 43.692286,-79.442332 43.692342)'),
(661896908, 1, 9266764, '2019-01-09 18:41:39'::timestamp, 66178384, '"building"=>"detached"', '{6196791120,6196791119,6196791118,6196791117,6196791116,6196791115,6196791114,6196791113,6196791120}', 'LINESTRING(-79.442297 43.692394,-79.442131 43.692338,-79.442144 43.692317,-79.442107 43.692305,-79.442125 43.692276,-79.442161 43.692288,-79.442329 43.692344,-79.442328 43.692345,-79.442297 43.692394)'),
(661896909, 1, 9266764, '2019-01-09 18:41:39'::timestamp, 66178384, '"building"=>"detached"', '{6196791129,6196791128,6196791127,6196791126,6196791125,6196791124,6196791123,6196791122,6196791121,6196791129}', 'LINESTRING(-79.442244 43.692468,-79.442225 43.692461,-79.442083 43.692415,-79.442092 43.692401,-79.442074 43.692395,-79.442095 43.692361,-79.442109 43.692366,-79.442255 43.692413,-79.442274 43.692419,-79.442244 43.692468)'),
(661896910, 1, 9266764, '2019-01-09 18:41:39'::timestamp, 66178384, '"building"=>"detached"', '{6196791135,6196791134,6196791133,6196791132,6196791131,6196791130,6196791135}', 'LINESTRING(-79.442378 43.692273,-79.442357 43.692266,-79.442234 43.692225,-79.442268 43.692171,-79.442394 43.692214,-79.442412 43.69222,-79.442378 43.692273)'),
(661896911, 1, 9266764, '2019-01-09 18:41:40'::timestamp, 66178384, '"building"=>"yes"', '{6196791141,6196791140,6196791139,6196791138,6196791141}', 'LINESTRING(-79.442435 43.692916,-79.442349 43.692889,-79.442398 43.692809,-79.442483 43.692836,-79.442435 43.692916)'),
(661896912, 1, 9266764, '2019-01-09 18:41:40'::timestamp, 66178384, '"building"=>"house"', '{6196791149,6196791148,6196791147,6196791146,6196791145,6196791144,6196791143,6196791142,6196791149}', 'LINESTRING(-79.442299 43.693129,-79.442223 43.693107,-79.442243 43.69307,-79.442217 43.693063,-79.442242 43.693017,-79.442269 43.693024,-79.442283 43.692998,-79.442358 43.693019,-79.442299 43.693129)'),
(661896913, 1, 9266764, '2019-01-09 18:41:40'::timestamp, 66178384, '"building"=>"house"', '{6196791158,6196791157,6196791156,6196791155,6196791154,6196791153,6196791152,6196791151,6196791150,6196791158}', 'LINESTRING(-79.442381 43.693151,-79.442332 43.693136,-79.442338 43.693125,-79.442339 43.693123,-79.442326 43.69312,-79.442393 43.692997,-79.442468 43.693019,-79.442401 43.693141,-79.442389 43.693138,-79.442381 43.693151)'),
(661896914, 1, 9266764, '2019-01-09 18:41:40'::timestamp, 66178384, '"building"=>"house"', '{6196791162,6196791161,6196791160,6196791159,6196791162}', 'LINESTRING(-79.442524 43.692945,-79.442437 43.692917,-79.442476 43.692853,-79.442563 43.692881,-79.442524 43.692945)'),
(661896915, 1, 9266764, '2019-01-09 18:41:40'::timestamp, 66178384, '"building"=>"house"', '{6196791175,6196791174,6196791173,6196791172,6196791171,6196791170,6196791169,6196791168,6196791167,6196791166,6196791165,6196791164,6196791163,6196791175}', 'LINESTRING(-79.442532 43.693203,-79.442398 43.693165,-79.442409 43.693144,-79.442452 43.693066,-79.442474 43.693025,-79.442545 43.693045,-79.442522 43.693088,-79.442535 43.693092,-79.442546 43.693072,-79.442569 43.693079,-79.442558 43.693099,-79.442584 43.693107,-79.442542 43.693185,-79.442532 43.693203)'),
(661896916, 1, 9266764, '2019-01-09 18:41:40'::timestamp, 66178384, '"building"=>"house"', '{6196791183,6196791182,6196791181,6196791180,6196791179,6196791178,6196791177,6196791176,6196791183}', 'LINESTRING(-79.442656 43.693253,-79.442577 43.693229,-79.44263 43.693138,-79.442583 43.693123,-79.442647 43.693015,-79.442777 43.693055,-79.442735 43.693127,-79.442731 43.693125,-79.442656 43.693253)'),
(661896917, 1, 9266764, '2019-01-09 18:41:40'::timestamp, 66178384, '"building"=>"house"', '{6196791190,6196791189,6196791188,6196791187,6196791186,6196791185,6196791184,6196791190}', 'LINESTRING(-79.442819 43.693291,-79.442746 43.693269,-79.442673 43.693247,-79.442814 43.693006,-79.442887 43.693028,-79.442858 43.693078,-79.442931 43.6931,-79.442819 43.693291)'),
(661896924, 1, 9266764, '2019-01-09 18:41:40'::timestamp, 66178384, '"building"=>"house"', '{6196791254,6196791253,6196791250,6196791249,6196791248,6196791247,6196791246,6196791251,6196791254}', 'LINESTRING(-79.443027 43.69336,-79.442916 43.693325,-79.442822 43.693296,-79.44297 43.693043,-79.443017 43.693057,-79.443038 43.693022,-79.443196 43.693071,-79.443175 43.693108,-79.443027 43.69336)'),
(661896929, 1, 9266764, '2019-01-09 18:41:41'::timestamp, 66178384, '"building"=>"detached"', '{6196791388,6196791387,6196791386,6196791385,6196791284,6196791283,6196791282,6196791281,6196791280,6196791279,6196791278,6196791277,6196791388}', 'LINESTRING(-79.443398 43.693472,-79.443298 43.693441,-79.443342 43.693368,-79.443334 43.693365,-79.443357 43.693328,-79.443375 43.693334,-79.443383 43.693321,-79.443424 43.693334,-79.443417 43.693346,-79.443436 43.693352,-79.443426 43.693367,-79.443455 43.693376,-79.443398 43.693472)'),
(661896935, 1, 9266764, '2019-01-09 18:41:41'::timestamp, 66178384, '"building"=>"residential"', '{6196791453,6196791452,6196791451,6196791450,6196791449,6196791448,6196791447,6196791446,6196791445,6196791444,6196791443,6196791442,6196791441,6196791440,6196791439,6196791438,6196791453}', 'LINESTRING(-79.443906 43.692751,-79.443902 43.692742,-79.443866 43.69275,-79.44385 43.692712,-79.443827 43.692717,-79.443826 43.692716,-79.443818 43.692696,-79.443786 43.692703,-79.44378 43.692688,-79.443833 43.692676,-79.443831 43.69267,-79.443978 43.692638,-79.444 43.692633,-79.444012 43.69266,-79.443989 43.692665,-79.444015 43.692727,-79.443906 43.692751)'),
(661896946, 1, 9266764, '2019-01-09 18:41:42'::timestamp, 66178384, '"building"=>"yes"', '{6196791776,6196791775,6196791774,6196791773,6196791772,6196791771,6196791770,6196791769,6196791776}', 'LINESTRING(-79.443706 43.693035,-79.443547 43.692984,-79.443593 43.692909,-79.443603 43.692892,-79.443622 43.692898,-79.443612 43.692915,-79.443696 43.692942,-79.443722 43.693009,-79.443706 43.693035)'),
(661896947, 1, 9266764, '2019-01-09 18:41:42'::timestamp, 66178384, '"building"=>"yes"', '{6196791784,6196791783,6196791782,6196791781,6196791780,6196791779,6196791778,6196791777,6196791784}', 'LINESTRING(-79.443643 43.693144,-79.443502 43.693099,-79.443485 43.693093,-79.443515 43.693045,-79.44353 43.69305,-79.443629 43.693082,-79.443622 43.693094,-79.443665 43.693108,-79.443643 43.693144)'),
(661896948, 1, 9266764, '2019-01-09 18:41:42'::timestamp, 66178384, '"building"=>"residential"', '{6196791792,6196791791,6196791790,6196791789,6196791788,6196791787,6196791786,6196791785,6196791792}', 'LINESTRING(-79.443946 43.692838,-79.443942 43.692828,-79.443905 43.692836,-79.443878 43.692771,-79.443915 43.692763,-79.443911 43.692753,-79.444016 43.692729,-79.444053 43.692814,-79.443946 43.692838)'),
(661896949, 1, 9266764, '2019-01-09 18:41:42'::timestamp, 66178384, '"building"=>"residential"', '{6196791806,6196791805,6196791804,6196791803,6196791802,6196791801,6196791800,6196791799,6196791798,6196791797,6196791796,6196791795,6196791794,6196791793,6196791806}', 'LINESTRING(-79.443987 43.692929,-79.443977 43.692904,-79.443948 43.692911,-79.44394 43.69289,-79.443929 43.692867,-79.443958 43.69286,-79.44395 43.692841,-79.444078 43.692813,-79.44408 43.692819,-79.444103 43.692814,-79.444111 43.692833,-79.444092 43.692837,-79.444099 43.692855,-79.444118 43.692899,-79.443987 43.692929)'),
(661896950, 1, 9266764, '2019-01-09 18:41:42'::timestamp, 66178384, '"building"=>"residential"', '{6196791813,6196791812,6196791811,6196791810,6196791809,6196791808,6196791807,6196791813}', 'LINESTRING(-79.444007 43.69302,-79.443983 43.692962,-79.443999 43.692959,-79.443987 43.692931,-79.444119 43.692901,-79.444155 43.692987,-79.444023 43.693017,-79.444007 43.69302)'),
(661896951, 1, 9266764, '2019-01-09 18:41:42'::timestamp, 66178384, '"building"=>"residential"', '{6196791820,6196791819,6196791818,6196791817,6196791816,6196791815,6196791814,6196791820}', 'LINESTRING(-79.444044 43.693067,-79.444038 43.693053,-79.444008 43.69306,-79.443993 43.693025,-79.444021 43.693019,-79.444155 43.692989,-79.444176 43.693038,-79.444044 43.693067)'),
(661896952, 1, 9266764, '2019-01-09 18:41:42'::timestamp, 66178384, '"building"=>"residential"', '{6196791830,6196791829,6196791828,6196791827,6196791826,6196791825,6196791824,6196791823,6196791822,6196791821,6196791830}', 'LINESTRING(-79.44408 43.693155,-79.444066 43.693123,-79.444051 43.693126,-79.444046 43.693116,-79.444037 43.693094,-79.444053 43.69309,-79.444045 43.693071,-79.444176 43.693042,-79.444193 43.693083,-79.444212 43.693126,-79.44408 43.693155)'),
(661896953, 1, 9266764, '2019-01-09 18:41:42'::timestamp, 66178384, '"building"=>"detached"', '{6196791838,6196791837,6196791836,6196791835,6196791834,6196791833,6196791832,6196791831,6196791838}', 'LINESTRING(-79.443525 43.693488,-79.443465 43.693469,-79.443469 43.693463,-79.443458 43.69346,-79.44351 43.693372,-79.443596 43.693399,-79.443545 43.693486,-79.44353 43.693481,-79.443525 43.693488)'),
(661896954, 1, 9266764, '2019-01-09 18:41:42'::timestamp, 66178384, '"building"=>"detached"', '{6196791843,6196791842,6196791841,6196791840,6196791839,6196791843}', 'LINESTRING(-79.443622 43.693514,-79.443546 43.693491,-79.443614 43.693377,-79.443689 43.693401,-79.44368 43.693416,-79.443622 43.693514)'),
(661896955, 1, 9266764, '2019-01-09 18:41:42'::timestamp, 66178384, '"building"=>"detached"', '{6196791849,6196791848,6196791847,6196791846,6196791845,6196791844,6196791849}', 'LINESTRING(-79.443705 43.69354,-79.443668 43.693528,-79.443665 43.693533,-79.443623 43.693519,-79.443683 43.693417,-79.443763 43.693442,-79.443705 43.69354)'),
(661896956, 1, 9266764, '2019-01-09 18:41:42'::timestamp, 66178384, '"building"=>"detached"', '{6196791857,6196791856,6196791855,6196791854,6196791853,6196791852,6196791851,6196791850,6196791857}', 'LINESTRING(-79.443796 43.693568,-79.443754 43.693555,-79.443756 43.693552,-79.443725 43.693543,-79.443782 43.693447,-79.44386 43.693472,-79.443803 43.693567,-79.443798 43.693565,-79.443796 43.693568)'),
(661896957, 1, 9266764, '2019-01-09 18:41:42'::timestamp, 66178384, '"building"=>"residential"', '{6196791865,6196791864,6196791863,6196791862,6196791861,6196791860,6196791859,6196791858,6196791865}', 'LINESTRING(-79.444249 43.693271,-79.444081 43.693223,-79.444113 43.693164,-79.444259 43.693205,-79.444257 43.69321,-79.444267 43.693212,-79.444256 43.693232,-79.444268 43.693235,-79.444249 43.693271)'),
(661896958, 1, 9266764, '2019-01-09 18:41:42'::timestamp, 66178384, '"building"=>"residential"', '{6196791875,6196791874,6196791873,6196791872,6196791871,6196791870,6196791869,6196791868,6196791867,6196791866,6196791875}', 'LINESTRING(-79.444286 43.693364,-79.444117 43.693313,-79.44412 43.693309,-79.444084 43.693298,-79.444111 43.693251,-79.444146 43.693261,-79.444148 43.693258,-79.444295 43.693303,-79.444281 43.693327,-79.444304 43.693334,-79.444286 43.693364)'),
(661896959, 1, 9266764, '2019-01-09 18:41:42'::timestamp, 66178384, '"building"=>"detached"', '{6196791881,6196791880,6196791879,6196791878,6196791877,6196791876,6196791881}', 'LINESTRING(-79.443903 43.693627,-79.443896 43.693609,-79.443861 43.693525,-79.443923 43.693511,-79.443959 43.693598,-79.443966 43.693613,-79.443903 43.693627)'),
(661896960, 1, 9266764, '2019-01-09 18:41:42'::timestamp, 66178384, '"building"=>"detached"', '{6196791893,6196791892,6196791891,6196791890,6196791889,6196791888,6196791887,6196791886,6196791885,6196791884,6196791883,6196791882,6196791893}', 'LINESTRING(-79.444076 43.693645,-79.444064 43.693616,-79.444 43.69363,-79.443966 43.69355,-79.444001 43.693542,-79.443992 43.69352,-79.444034 43.693511,-79.444042 43.69353,-79.444077 43.693523,-79.444089 43.693552,-79.444117 43.693546,-79.444152 43.693629,-79.444076 43.693645)'),
(661896966, 1, 9266764, '2019-01-09 18:41:43'::timestamp, 66178384, '"building"=>"residential"', '{6196791949,6196791948,6196791947,6196791946,6196791949}', 'LINESTRING(-79.44431 43.693437,-79.44414 43.693385,-79.444172 43.693331,-79.444341 43.693383,-79.44431 43.693437)'),
(661896967, 1, 9266764, '2019-01-09 18:41:43'::timestamp, 66178384, '"building"=>"detached"', '{6196791953,6196791952,6196791951,6196791950,6196791953}', 'LINESTRING(-79.444292 43.693526,-79.444164 43.693487,-79.444199 43.693426,-79.444327 43.693466,-79.444292 43.693526)'),
(661896968, 1, 9266764, '2019-01-09 18:41:43'::timestamp, 66178384, '"building"=>"detached"', '{6196791962,6196791961,6196791960,6196791959,6196791958,6196791957,6196791956,6196791955,6196791967,6196791954,6196791962}', 'LINESTRING(-79.444218 43.693736,-79.444175 43.693631,-79.444192 43.693627,-79.444184 43.69361,-79.444201 43.693606,-79.444199 43.693601,-79.444228 43.693595,-79.444237 43.693617,-79.444251 43.693652,-79.44428 43.693722,-79.444218 43.693736)'),
(661896969, 1, 9266764, '2019-01-09 18:41:43'::timestamp, 66178384, '"building"=>"detached"', '{6196791968,6196791967,6196791966,6196791965,6196791964,6196791963,6196791968}', 'LINESTRING(-79.444294 43.693754,-79.444251 43.693652,-79.444242 43.693629,-79.444303 43.693615,-79.444311 43.693635,-79.444355 43.693741,-79.444294 43.693754)'),
(661897051, 1, 9266764, '2019-01-09 18:41:47'::timestamp, 66178384, '"building"=>"detached"', '{6196793166,6196793165,6196793164,6196793163,6196793162,6196793161,6196793160,6196793159,6196793158,6196793157,6196793156,6196793155,6196793166}', 'LINESTRING(-79.444448 43.693781,-79.444439 43.69376,-79.444433 43.693746,-79.444384 43.693756,-79.444375 43.693735,-79.444335 43.69364,-79.444393 43.693627,-79.444403 43.693651,-79.444454 43.693641,-79.444459 43.693654,-79.444499 43.69375,-79.444507 43.693768,-79.444448 43.693781)'),
(662766642, 1, 9266764, '2019-01-12 19:24:23'::timestamp, 66263537, '"building"=>"house"', '{6204498032,6204498031,6204498030,6204498029,6204498028,6204498027,6204498026,6204498025,6204498032}', 'LINESTRING(-79.437669 43.691156,-79.437639 43.691139,-79.437621 43.691086,-79.437678 43.691074,-79.437682 43.691085,-79.437694 43.69108,-79.437744 43.691033,-79.43778 43.691054,-79.437669 43.691156)'),
(662766643, 1, 9266764, '2019-01-12 19:24:23'::timestamp, 66263537, '"building"=>"house"', '{6204498039,6204498038,6204498037,6204498036,6204498035,6204498034,6204498033,6204498039}', 'LINESTRING(-79.437727 43.69125,-79.437676 43.691225,-79.437696 43.691204,-79.43767 43.691191,-79.437785 43.691069,-79.437829 43.691091,-79.437862 43.691107,-79.437727 43.69125)'),
(662766644, 1, 9266764, '2019-01-12 19:24:23'::timestamp, 66263537, '"building"=>"house"', '{6204498047,6204498046,6204498045,6204498044,6204498043,6204498042,6204498041,6204498040,6204498047}', 'LINESTRING(-79.437847 43.69128,-79.437785 43.691249,-79.437892 43.691137,-79.437905 43.691144,-79.437915 43.691134,-79.437941 43.691147,-79.437932 43.691157,-79.437954 43.691168,-79.437847 43.69128)'),
(662766645, 1, 9266764, '2019-01-12 19:24:23'::timestamp, 66263537, '"building"=>"house"', '{6204498054,6204498053,6204498052,6204498051,6204498050,6204498049,6204498048,6204498054}', 'LINESTRING(-79.437952 43.691468,-79.437881 43.691432,-79.437764 43.691373,-79.437975 43.691153,-79.438091 43.691211,-79.437915 43.691394,-79.437988 43.691431,-79.437952 43.691468)'),
(662766646, 1, 9266764, '2019-01-12 19:24:23'::timestamp, 66263537, '"building"=>"house"', '{6204498062,6204498061,6204498060,6204498059,6204498058,6204498057,6204498056,6204498055,6204498062}', 'LINESTRING(-79.43782 43.691608,-79.437811 43.691577,-79.437781 43.691581,-79.437767 43.691535,-79.437799 43.69153,-79.437791 43.691504,-79.437904 43.691486,-79.437935 43.691589,-79.43782 43.691608)'),
(662766647, 1, 9266764, '2019-01-12 19:24:23'::timestamp, 66263537, '"building"=>"house"', '{6204498070,6204498069,6204498068,6204498067,6204498066,6204498065,6204498064,6204498063,6204498070}', 'LINESTRING(-79.437869 43.691704,-79.43786 43.691676,-79.437829 43.691681,-79.437816 43.691637,-79.437847 43.691633,-79.43784 43.691609,-79.437968 43.691588,-79.437997 43.691684,-79.437869 43.691704)'),
(662766684, 1, 9266764, '2019-01-12 19:24:25'::timestamp, 66263537, '"building"=>"house"', '{6204498817,6204498816,6204498815,6204498814,6204498813,6204498812,6204498811,6204498810,6204498809,6204498817}', 'LINESTRING(-79.438005 43.69139,-79.437969 43.691371,-79.437984 43.691356,-79.437968 43.691348,-79.43809 43.691221,-79.438137 43.691245,-79.438085 43.691299,-79.43809 43.691302,-79.438019 43.691376,-79.438005 43.69139)'),
(662766685, 1, 9266764, '2019-01-12 19:24:25'::timestamp, 66263537, '"building"=>"house"', '{6204498829,6204498828,6204498827,6204498826,6204498825,6204498824,6204498823,6204498822,6204498821,6204498820,6204498819,6204498818,6204498829}', 'LINESTRING(-79.438159 43.691416,-79.438112 43.691391,-79.438125 43.691377,-79.43807 43.691349,-79.438152 43.691266,-79.438187 43.691284,-79.438198 43.691273,-79.438218 43.691283,-79.438259 43.691305,-79.438247 43.691317,-79.438253 43.69132,-79.438173 43.691401,-79.438159 43.691416)'),
(662766686, 1, 9266764, '2019-01-12 19:24:25'::timestamp, 66263537, '"building"=>"house"', '{6204498837,6204498836,6204498835,6204498834,6204498833,6204498832,6204498831,6204498830,6204498837}', 'LINESTRING(-79.438299 43.691464,-79.438244 43.691435,-79.43819 43.691407,-79.438268 43.691328,-79.438285 43.69131,-79.438339 43.691338,-79.438394 43.691366,-79.438379 43.691381,-79.438299 43.691464)'),
(662766687, 1, 9266764, '2019-01-12 19:24:25'::timestamp, 66263537, '"building"=>"house"', '{6204498844,6204498843,6204498842,6204498841,6204498840,6204498839,6204498838,6204498844}', 'LINESTRING(-79.438445 43.691532,-79.438374 43.691497,-79.438442 43.691425,-79.438457 43.691433,-79.438467 43.691422,-79.438522 43.69145,-79.438512 43.691461,-79.438445 43.691532)'),
(662766688, 1, 9266764, '2019-01-12 19:24:25'::timestamp, 66263537, '"building"=>"house"', '{6204498852,6204498851,6204498850,6204498849,6204498848,6204498847,6204498846,6204498845,6204498852}', 'LINESTRING(-79.438442 43.6917,-79.438416 43.69164,-79.438395 43.691644,-79.438379 43.691607,-79.4384 43.691603,-79.43839 43.691579,-79.438516 43.691551,-79.438567 43.691672,-79.438442 43.6917)'),
(662766701, 1, 9266764, '2019-01-12 19:24:26'::timestamp, 66263537, '"building"=>"yes"', '{6196761073,6204499301,6204499300,6204499299,6196761072,6196761073}', 'LINESTRING(-79.438964 43.691754,-79.438906 43.691719,-79.438875 43.691664,-79.43891 43.691634,-79.439024 43.691703,-79.438964 43.691754)'),
(662766702, 1, 9266764, '2019-01-12 19:24:26'::timestamp, 66263537, '"building"=>"semi"', '{6204499305,6204499304,6204499303,6204499302,6204499305}', 'LINESTRING(-79.439245 43.691528,-79.439115 43.691447,-79.439258 43.691327,-79.439387 43.691408,-79.439245 43.691528)'),
(662766880, 1, 9266764, '2019-01-12 19:24:36'::timestamp, 66263537, '"building:part"=>"yes"', '{6204502184,6204502183,6204502182,6204502179,6204502184}', 'LINESTRING(-79.439676 43.691105,-79.439656 43.691056,-79.439821 43.69102,-79.439841 43.69107,-79.439676 43.691105)'),
(662766881, 1, 9266764, '2019-01-12 19:24:36'::timestamp, 66263537, '"building"=>"apartments"', '{6204502486,6204502485,6204502184,6204502183,6204502182,6204502181,6204502180,6204502486}', 'LINESTRING(-79.439572 43.691272,-79.439518 43.691139,-79.439676 43.691105,-79.439656 43.691056,-79.439821 43.69102,-79.439965 43.690989,-79.44004 43.691171,-79.439572 43.691272)'),
(662766882, 1, 9266764, '2019-01-12 19:24:36'::timestamp, 66263537, '"building"=>"semi"', '{6204502493,6204502492,6204502491,6204502490,6204502489,6204502488,6204502487,6204502493}', 'LINESTRING(-79.439391 43.69162,-79.43926 43.691538,-79.439407 43.691415,-79.439471 43.691455,-79.439495 43.691434,-79.439562 43.691476,-79.439535 43.691499,-79.439391 43.69162)'),
(662766883, 1, 9266764, '2019-01-12 19:24:36'::timestamp, 66263537, '"building"=>"semi"', '{6204502497,6204502496,6204502495,6204502494,6204502497}', 'LINESTRING(-79.439539 43.691712,-79.439407 43.69163,-79.439555 43.691506,-79.439687 43.691588,-79.439539 43.691712)'),
(662766884, 1, 9266764, '2019-01-12 19:24:37'::timestamp, 66263537, '"building"=>"semi"', '{6204502501,6204502500,6204502499,6204502498,6204502501}', 'LINESTRING(-79.439686 43.691803,-79.439555 43.691721,-79.439703 43.691597,-79.439834 43.691679,-79.439686 43.691803)'),
(662766885, 1, 9266764, '2019-01-12 19:24:37'::timestamp, 66263537, '"building"=>"apartments"', '{6204502509,6204502508,6204502507,6204502506,6204502505,6204502504,6204502503,6204502502,6204502509}', 'LINESTRING(-79.439786 43.691425,-79.439764 43.691371,-79.439732 43.691378,-79.439721 43.691351,-79.43975 43.691345,-79.439736 43.69131,-79.440058 43.691241,-79.440105 43.691357,-79.439786 43.691425)'),
(662766895, 1, 9266764, '2019-01-12 19:24:37'::timestamp, 66263537, '"building"=>"retail"', '{6204502597,6204502590,6204502589,6204502588,6204502596,6204502597}', 'LINESTRING(-79.440497 43.691625,-79.440453 43.691523,-79.44084 43.691435,-79.440884 43.691537,-79.440712 43.691576,-79.440497 43.691625)'),
(662766896, 1, 9266764, '2019-01-12 19:24:37'::timestamp, 66263537, '"building"=>"retail"', '{6204502598,6204502597,6204502596,6204502595,6204502594,6204502593,6204502592,6204502591,6204502598}', 'LINESTRING(-79.440556 43.691761,-79.440497 43.691625,-79.440712 43.691576,-79.440748 43.691659,-79.440673 43.691676,-79.440679 43.691691,-79.440754 43.691674,-79.440771 43.691712,-79.440556 43.691761)'),
(662769058, 1, 9266764, '2019-01-12 19:26:50'::timestamp, 66263537, '"building"=>"house"', '{6204538620,6204538619,6204538618,6204538617,6204538616,6204538615,6204538614,6204538620}', 'LINESTRING(-79.442658 43.691767,-79.44246 43.691668,-79.442442 43.691659,-79.442458 43.691642,-79.442473 43.691649,-79.442495 43.691627,-79.442688 43.691723,-79.442658 43.691767)'),
(662769059, 1, 9266764, '2019-01-12 19:26:50'::timestamp, 66263537, '"building"=>"house"', '{6204538632,6204538631,6204538630,6204538629,6204538628,6204538627,6204538626,6204538625,6204538624,6204538623,6204538622,6204538621,6204538632}', 'LINESTRING(-79.442669 43.691689,-79.4426 43.691637,-79.442553 43.691602,-79.442564 43.691594,-79.442531 43.691569,-79.442582 43.691533,-79.442614 43.691557,-79.442618 43.691554,-79.442665 43.69159,-79.442714 43.691627,-79.442689 43.691645,-79.44271 43.691661,-79.442669 43.691689)'),
(662769060, 1, 9266764, '2019-01-12 19:26:50'::timestamp, 66263537, '"building"=>"house"', '{6204538645,6204538644,6204538643,6204538642,6204538641,6204538640,6204538639,6204538638,6204538637,6204538636,6204538635,6204538634,6204538633,6204538645}', 'LINESTRING(-79.442782 43.691658,-79.442774 43.691642,-79.442746 43.69165,-79.442732 43.691621,-79.442724 43.691624,-79.442684 43.691547,-79.442694 43.691545,-79.442684 43.691527,-79.442752 43.691508,-79.442762 43.691527,-79.442816 43.691631,-79.442813 43.691632,-79.44282 43.691647,-79.442782 43.691658)'),
(662769067, 1, 9266764, '2019-01-12 19:26:50'::timestamp, 66263537, '"building"=>"house"', '{6204538789,6204538788,6204538787,6204538786,6204538785,6204538684,6204538789}', 'LINESTRING(-79.443287 43.691252,-79.443271 43.691214,-79.443293 43.691209,-79.443286 43.691193,-79.443415 43.691164,-79.443438 43.691219,-79.443287 43.691252)'),
(662769068, 1, 9266764, '2019-01-12 19:26:50'::timestamp, 66263537, '"building"=>"house"', '{6204538800,6204538799,6204538798,6204538797,6204538796,6204538795,6204538794,6204538793,6204538792,6204538791,6204538790,6204538800}', 'LINESTRING(-79.442842 43.691636,-79.442834 43.691619,-79.442783 43.691508,-79.442795 43.691505,-79.442789 43.691493,-79.442841 43.691481,-79.442847 43.691493,-79.442898 43.691604,-79.442877 43.691609,-79.442885 43.691626,-79.442851 43.691634,-79.442842 43.691636)'),
(662769069, 1, 9266764, '2019-01-12 19:26:50'::timestamp, 66263537, '"building"=>"house"', '{6204538804,6204538803,6204538802,6204538801,6204538804}', 'LINESTRING(-79.442929 43.691614,-79.442871 43.691487,-79.442934 43.691471,-79.442992 43.691599,-79.442929 43.691614)'),
(662769070, 1, 9266764, '2019-01-12 19:26:51'::timestamp, 66263537, '"building"=>"house"', '{6204538815,6204538814,6204538813,6204538812,6204538811,6204538810,6204538809,6204538808,6204538807,6204538806,6204538805,6204538815}', 'LINESTRING(-79.443019 43.691596,-79.443011 43.691578,-79.442971 43.69149,-79.442985 43.691487,-79.442976 43.691469,-79.443012 43.69146,-79.44302 43.691479,-79.443043 43.691474,-79.443083 43.691561,-79.443042 43.691571,-79.44305 43.691588,-79.443019 43.691596)'),
(662769071, 1, 9266764, '2019-01-12 19:26:51'::timestamp, 66263537, '"building"=>"house"', '{6204538828,6204538827,6204538826,6204538825,6204538824,6204538823,6204538822,6204538821,6204538820,6204538819,6204538818,6204538817,6204538816,6204538828}', 'LINESTRING(-79.443303 43.691346,-79.443287 43.691308,-79.443308 43.691303,-79.443301 43.691286,-79.443319 43.691282,-79.44331 43.69126,-79.443449 43.691229,-79.443471 43.691224,-79.443487 43.691263,-79.443505 43.691306,-79.443482 43.691312,-79.443344 43.691342,-79.443342 43.691337,-79.443303 43.691346)'),
(662769072, 1, 9266764, '2019-01-12 19:26:51'::timestamp, 66263537, '"building"=>"house"', '{6204538836,6204538835,6204538834,6204538833,6204538832,6204538831,6204538830,6204538829,6204538836}', 'LINESTRING(-79.44323 43.691426,-79.443219 43.691401,-79.44321 43.691378,-79.443261 43.691367,-79.443263 43.691372,-79.44351 43.691317,-79.443528 43.69136,-79.443281 43.691415,-79.44323 43.691426)'),
(662769073, 1, 9266764, '2019-01-12 19:26:51'::timestamp, 66263537, '"building"=>"house"', '{6204538845,6204538844,6204538843,6204538842,6204538841,6204538840,6204538839,6204538838,6204538837,6204538845}', 'LINESTRING(-79.443433 43.691523,-79.443401 43.691447,-79.443376 43.691453,-79.443361 43.691416,-79.443386 43.69141,-79.443499 43.691385,-79.443525 43.691379,-79.443572 43.691493,-79.443549 43.691498,-79.443433 43.691523)')
) AS sample(id, version, user_id, tstamp, changeset_id, tags, nodes, linestring
);
CREATE TABLE oq_sample.ways AS SELECT * FROM oq_sample.oq_s1a_building;
DROP TABLE IF EXISTS oq_sample.nodes;
CREATE TABLE oq_sample.nodes
(
id bigint NOT NULL,
version integer NOT NULL,
user_id integer NOT NULL,
tstamp timestamp without time zone NOT NULL,
changeset_id bigint NOT NULL,
tags hstore,
geom geometry(Point,4326),
CONSTRAINT pk_nodes PRIMARY KEY (id)
);
INSERT INTO oq_sample.nodes
SELECT distinct (public.OQ_NodesTableFromWays(nodes, linestring)).*
FROM oq_sample.oq_s1a_building;
SELECT * FROM oq_sample.nodes;
DROP TABLE IF EXISTS oq_sample.way_nodes;
CREATE TABLE oq_sample.way_nodes
(
way_id bigint NOT NULL,
node_id bigint NOT NULL,
sequence_id integer NOT NULL,
CONSTRAINT pk_way_nodes PRIMARY KEY (way_id, sequence_id)
);
INSERT INTO oq_sample.way_nodes
SELECT (public.OQ_WaynodesTableFromWays(id, nodes)).*
FROM oq_sample.oq_s1a_building;
SELECT * FROM oq_sample.way_nodes;