readme.md

City of Toronto Tennis Courts (mapped)

View the map: http://geojson.io/#id=gist:MarkyC/d4089b11a07495bd8225bc7074b44a65

Github also renders a map: https://gist.github.com/MarkyC/d4089b11a07495bd8225bc7074b44a65#file-map-geojson

Dataset

I used the GIS Coordinate column from the excel file here

https://open.toronto.ca/dataset/tennis-courts-facilities/

Database

There's a sample query based on the 2017 version of this dataset

generate_geojson.sql

WITH points(point) as
(VALUES  
(st_makepoint(-79.27436958, 43.78822902)),
(st_makepoint(-79.27384777, 43.78834572)),
(st_makepoint(-79.2741961, 43.78826694)),
(st_makepoint(-79.27402261, 43.78830584)),
(st_makepoint(-79.27471885, 43.78837437)),
(st_makepoint(-79.36940737, 43.78104482)),
(st_makepoint(-79.36920626, 43.7810446)),
(st_makepoint(-79.36960369, 43.78104273)),
(st_makepoint(-79.55932899, 43.73918301)),
(st_makepoint(-79.55915929, 43.73921704)),
(st_makepoint(-79.55898813, 43.73925533)),
(st_makepoint(-79.48371466, 43.70687532)),
(st_makepoint(-79.48355031, 43.70691474)),
(st_makepoint(-79.46594992, 43.73347393)),
(st_makepoint(-79.46576904, 43.7335125)),
(st_makepoint(-79.46613499, 43.73343332)),
(st_makepoint(-79.32872459, 43.7127046)),
(st_makepoint(-79.32836587, 43.71278966)),
(st_makepoint(-79.32854523, 43.71274767)),
(st_makepoint(-79.32818502, 43.71283273)),
(st_makepoint(-79.44785017, 43.78095139)),
(st_makepoint(-79.45041331, 43.74503774)),
(st_makepoint(-79.4502322, 43.74507693)),
(st_makepoint(-79.45005278, 43.74511489)),
(st_makepoint(-79.37023902, 43.74226248)),
(st_makepoint(-79.37042673, 43.74227984)),
(st_makepoint(-79.37061739, 43.74229827)),
(st_makepoint(-79.37004836, 43.74224083)),
(st_makepoint(-79.44393144, 43.72874555)),
(st_makepoint(-79.44411684, 43.72870831)),
(st_makepoint(-79.38916925, 43.77333209)),
(st_makepoint(-79.38898146, 43.77335291)),
(st_makepoint(-79.38879115, 43.7733719)),
(st_makepoint(-79.29981954, 43.66648471)),
(st_makepoint(-79.29970757, 43.66616962)),
(st_makepoint(-79.30014124, 43.66642434)),
(st_makepoint(-79.29966176, 43.66651565)),
(st_makepoint(-79.30017926, 43.66607656)),
(st_makepoint(-79.29955018, 43.66620031)),
(st_makepoint(-79.30002257, 43.66610649)),
(st_makepoint(-79.29986479, 43.66613891)),
(st_makepoint(-79.30029697, 43.66639488)),
(st_makepoint(-79.29997732, 43.66645526)),
(st_makepoint(-79.57282593, 43.73963457)),
(st_makepoint(-79.57300183, 43.73964508)),
(st_makepoint(-79.57317772, 43.73965323)),
(st_makepoint(-79.36062091, 43.78425411)),
(st_makepoint(-79.36080585, 43.78421242)),
(st_makepoint(-79.36101903, 43.78416565)),
(st_makepoint(-79.36120257, 43.78412599)),
(st_makepoint(-79.36043879, 43.78429479)),
(st_makepoint(-79.3609386199999, 43.78447053)),
(st_makepoint(-79.37004767, 43.69491972)),
(st_makepoint(-79.37022193, 43.69488858)),
(st_makepoint(-79.38346836, 43.80245351)),
(st_makepoint(-79.3831121, 43.80254596)),
(st_makepoint(-79.38328949, 43.80250081)),
(st_makepoint(-79.52668419, 43.59107692)),
(st_makepoint(-79.52651125, 43.59111657)),
(st_makepoint(-79.26167067, 43.69734175)),
(st_makepoint(-79.26149843, 43.6972874)),
(st_makepoint(-79.56817889, 43.63577967)),
(st_makepoint(-79.56835937, 43.63573996)),
(st_makepoint(-79.350482, 43.74688475)),
(st_makepoint(-79.35027049, 43.74662137)),
(st_makepoint(-79.35022668, 43.7462813)),
(st_makepoint(-79.35065248, 43.74681414)),
(st_makepoint(-79.3500562, 43.74635394)),
(st_makepoint(-79.35044096, 43.74655076)),
(st_makepoint(-79.35068563, 43.7465042)),
(st_makepoint(-79.21069851, 43.77790543)),
(st_makepoint(-79.2108597, 43.77787322)),
(st_makepoint(-79.21102262, 43.77784226)),
(st_makepoint(-79.21118207, 43.7778113)),
(st_makepoint(-79.31643439, 43.78318136)),
(st_makepoint(-79.31661479, 43.78314203)),
(st_makepoint(-79.31680113, 43.78309844)),
(st_makepoint(-79.32223635, 43.74617333)),
(st_makepoint(-79.32205759, 43.74612631)),
(st_makepoint(-79.32187882, 43.7460793)),
(st_makepoint(-79.32169845, 43.74603228)),
(st_makepoint(-79.51973629, 43.68180381)),
(st_makepoint(-79.51991181, 43.68177043)),
(st_makepoint(-79.5195622, 43.68183755)),
(st_makepoint(-79.46412423, 43.72125733)),
(st_makepoint(-79.46398795, 43.72094404)),
(st_makepoint(-79.31857675, 43.75465025)),
(st_makepoint(-79.3187532, 43.75465777)),
(st_makepoint(-79.31892797, 43.7546677)),
(st_makepoint(-79.31840364, 43.75464274)),
(st_makepoint(-79.43209297, 43.69276269)),
(st_makepoint(-79.43228245, 43.69276447)),
(st_makepoint(-79.43190496, 43.69276013)),
(st_makepoint(-79.43171562, 43.69275805)),
(st_makepoint(-79.51558725, 43.72667812)),
(st_makepoint(-79.51579084, 43.72664878)),
(st_makepoint(-79.44453868, 43.73217841)),
(st_makepoint(-79.44471978, 43.73214282)),
(st_makepoint(-79.14071308, 43.78075502)),
(st_makepoint(-79.14053983, 43.78079369)),
(st_makepoint(-79.14036527, 43.78083141)),
(st_makepoint(-79.28797574, 43.71424347)),
(st_makepoint(-79.28780285, 43.71427791)),
(st_makepoint(-79.43724255, 43.74607317)),
(st_makepoint(-79.43715821, 43.74575261)),
(st_makepoint(-79.43706756, 43.74609762)),
(st_makepoint(-79.4377540499999, 43.7460710099999)),
(st_makepoint(-79.35462275, 43.80817872)),
(st_makepoint(-79.35444092, 43.80822115)),
(st_makepoint(-79.35426285, 43.80826358)),
(st_makepoint(-79.54453829, 43.63367398)),
(st_makepoint(-79.54471884, 43.63367446)),
(st_makepoint(-79.54435773, 43.63367349)),
(st_makepoint(-79.3293701, 43.78371774)),
(st_makepoint(-79.32955125, 43.78368034)),
(st_makepoint(-79.32992251, 43.78360557)),
(st_makepoint(-79.32973957, 43.78364296)),
(st_makepoint(-79.32954913, 43.78338698)),
(st_makepoint(-79.29952726, 43.68948392)),
(st_makepoint(-79.29936857, 43.68951967)),
(st_makepoint(-79.23582959, 43.77364966)),
(st_makepoint(-79.23600388, 43.77361482)),
(st_makepoint(-79.23617819, 43.77357658)),
(st_makepoint(-79.33053051, 43.69275676)),
(st_makepoint(-79.33035647, 43.69279369)),
(st_makepoint(-79.33018244, 43.69283195)),
(st_makepoint(-79.3298765, 43.69289791)),
(st_makepoint(-79.33003038, 43.69286493)),
(st_makepoint(-79.36319467, 43.7983579)),
(st_makepoint(-79.36300923, 43.798396)),
(st_makepoint(-79.36356406, 43.79828506)),
(st_makepoint(-79.36337684, 43.79832221)),
(st_makepoint(-79.37212088, 43.79987628)),
(st_makepoint(-79.37228451, 43.79982223)),
(st_makepoint(-79.37199512, 43.80009529)),
(st_makepoint(-79.37182843, 43.80015155)),
(st_makepoint(-79.3882133799999, 43.7002781)),
(st_makepoint(-79.43336469, 43.66552997)),
(st_makepoint(-79.43321393, 43.66556227)),
(st_makepoint(-79.36837521, 43.76289732)),
(st_makepoint(-79.36873573, 43.76280196)),
(st_makepoint(-79.36855478, 43.76284914)),
(st_makepoint(-79.36896576, 43.76272618)),
(st_makepoint(-79.55680307, 43.64148251)),
(st_makepoint(-79.55714908, 43.64140228)),
(st_makepoint(-79.55697536, 43.64144219)),
(st_makepoint(-79.33057174, 43.6930204)),
(st_makepoint(-79.49447972, 43.68489355)),
(st_makepoint(-79.49415347, 43.68497573)),
(st_makepoint(-79.4939135, 43.68503246)),
(st_makepoint(-79.49417278, 43.68439943)),
(st_makepoint(-79.49374903, 43.68507159)),
(st_makepoint(-79.49358994, 43.68511072)),
(st_makepoint(-79.49431525, 43.68493464)),
(st_makepoint(-79.49418044, 43.68463135)),
(st_makepoint(-79.49344705, 43.68480351)),
(st_makepoint(-79.4943503, 43.68459222)),
(st_makepoint(-79.49360883, 43.68476438)),
(st_makepoint(-79.4937733, 43.68472526)),
(st_makepoint(-79.49401866, 43.68467048)),
(st_makepoint(-79.40448996, 43.70661165)),
(st_makepoint(-79.40444737, 43.70645559)),
(st_makepoint(-79.20512064, 43.73925131)),
(st_makepoint(-79.20494263, 43.73927616)),
(st_makepoint(-79.20547834, 43.73919678)),
(st_makepoint(-79.20530032, 43.73922404)),
(st_makepoint(-79.31545755, 43.67524372)),
(st_makepoint(-79.31514043, 43.67530674)),
(st_makepoint(-79.31498338, 43.67533715)),
(st_makepoint(-79.31482482, 43.67536867)),
(st_makepoint(-79.31529899, 43.67527522)),
(st_makepoint(-79.32754101, 43.76476268)),
(st_makepoint(-79.32715291, 43.76485512)),
(st_makepoint(-79.32770613, 43.76472408)),
(st_makepoint(-79.3273265, 43.76481347)),
(st_makepoint(-79.5210539, 43.75060517)),
(st_makepoint(-79.52087301, 43.75064812)),
(st_makepoint(-79.52069048, 43.75068987)),
(st_makepoint(-79.59067546, 43.72097009)),
(st_makepoint(-79.59084844, 43.72092927)),
(st_makepoint(-79.4992761, 43.76208644)),
(st_makepoint(-79.49945699, 43.76204464)),
(st_makepoint(-79.49963788, 43.76200189)),
(st_makepoint(-79.49913432, 43.76182292)),
(st_makepoint(-79.594631, 43.75489768)),
(st_makepoint(-79.59480264, 43.75486407)),
(st_makepoint(-79.4527847, 43.67549825)),
(st_makepoint(-79.55350695, 43.65079124)),
(st_makepoint(-79.5533441, 43.65082595)),
(st_makepoint(-79.39801876, 43.76097542)),
(st_makepoint(-79.39784524, 43.76101514)),
(st_makepoint(-79.42218776, 43.7916127)),
(st_makepoint(-79.42200266, 43.79165397)),
(st_makepoint(-79.42182164, 43.79169326)),
(st_makepoint(-79.56338019, 43.75171399)),
(st_makepoint(-79.56300766, 43.75179731)),
(st_makepoint(-79.56319324, 43.75175565)),
(st_makepoint(-79.49165743, 43.75228304)),
(st_makepoint(-79.4914723, 43.75232443)),
(st_makepoint(-79.49129307, 43.75236582)),
(st_makepoint(-79.34082717, 43.76261796)),
(st_makepoint(-79.34119708, 43.76254773)),
(st_makepoint(-79.34101005, 43.76258248)),
(st_makepoint(-79.42056678, 43.75112814)),
(st_makepoint(-79.41980058, 43.75093872)),
(st_makepoint(-79.42015919, 43.7509837)),
(st_makepoint(-79.41997924, 43.75096121)),
(st_makepoint(-79.42040271, 43.75105238)),
(st_makepoint(-79.39161271, 43.61994414)),
(st_makepoint(-79.39143161, 43.61994672)),
(st_makepoint(-79.39125428, 43.61994929)),
(st_makepoint(-79.39162156, 43.62027446)),
(st_makepoint(-79.39144423, 43.62027704)),
(st_makepoint(-79.39126124, 43.6202796)),
(st_makepoint(-79.35833134, 43.76750943)),
(st_makepoint(-79.35850808, 43.76746534)),
(st_makepoint(-79.3581529, 43.76755352)),
(st_makepoint(-79.35797107, 43.76759884)),
(st_makepoint(-79.35773597, 43.76765972)),
(st_makepoint(-79.3827995, 43.77045308)),
(st_makepoint(-79.38297846, 43.77041819)),
(st_makepoint(-79.3832873, 43.77070369)),
(st_makepoint(-79.38292305, 43.77077651)),
(st_makepoint(-79.38316163, 43.77038331)),
(st_makepoint(-79.38310412, 43.7707401)),
(st_makepoint(-79.38330525, 43.7701849)),
(st_makepoint(-79.42168089, 43.78115217)),
(st_makepoint(-79.42204373, 43.78107388)),
(st_makepoint(-79.42186159, 43.7811125)),
(st_makepoint(-79.42222587, 43.78103527)),
(st_makepoint(-79.4213229, 43.7812605599999)),
(st_makepoint(-79.17830386, 43.76865502)),
(st_makepoint(-79.1781287, 43.76869324)),
(st_makepoint(-79.17844403, 43.76896506)),
(st_makepoint(-79.17826701, 43.76900594)),
(st_makepoint(-79.1780863, 43.76904681)),
(st_makepoint(-79.17788151, 43.76916026)),
(st_makepoint(-79.45912098, 43.65052748)),
(st_makepoint(-79.45989398, 43.65085718)),
(st_makepoint(-79.45952418, 43.65159082)),
(st_makepoint(-79.46444305, 43.65062803)),
(st_makepoint(-79.4655711, 43.64990844)),
(st_makepoint(-79.45920169, 43.65063237)),
(st_makepoint(-79.45962547, 43.65074445)),
(st_makepoint(-79.45936505, 43.65162632)),
(st_makepoint(-79.46427629, 43.65062464)),
(st_makepoint(-79.46533762, 43.64979837)),
(st_makepoint(-79.4597674, 43.65080404)),
(st_makepoint(-79.46410494, 43.65061904)),
(st_makepoint(-79.46531587, 43.64996623)),
(st_makepoint(-79.46506191, 43.64988604)),
(st_makepoint(-79.45947835, 43.65045818)),
(st_makepoint(-79.42386171, 43.67600872)),
(st_makepoint(-79.42434907, 43.67591044)),
(st_makepoint(-79.42418514, 43.67594249)),
(st_makepoint(-79.42402269, 43.67597667)),
(st_makepoint(-79.37236378, 43.71048744)),
(st_makepoint(-79.37216519, 43.71048671)),
(st_makepoint(-79.52497017, 43.76514772)),
(st_makepoint(-79.5253303, 43.76506784)),
(st_makepoint(-79.52514788, 43.76510664)),
(st_makepoint(-79.52479819, 43.66432332)),
(st_makepoint(-79.52470132, 43.66442558)),
(st_makepoint(-79.52460818, 43.66451972)),
(st_makepoint(-79.52451475, 43.66461408)),
(st_makepoint(-79.62273738, 43.72510473)),
(st_makepoint(-79.62290601, 43.72505645)),
(st_makepoint(-79.26813575, 43.80358865)),
(st_makepoint(-79.26826301, 43.80349256)),
(st_makepoint(-79.26838416, 43.80339647)),
(st_makepoint(-79.4561931, 43.76201193)),
(st_makepoint(-79.45601642, 43.76204844)),
(st_makepoint(-79.49602765, 43.63025972)),
(st_makepoint(-79.4958745, 43.63029993)),
(st_makepoint(-79.34429257, 43.66106283)),
(st_makepoint(-79.34430515, 43.6609382)),
(st_makepoint(-79.32022022, 43.66479575)),
(st_makepoint(-79.3200583, 43.66483427)),
(st_makepoint(-79.38784785, 43.70128115)),
(st_makepoint(-79.38768735, 43.70131072)),
(st_makepoint(-79.38834643, 43.70119)),
(st_makepoint(-79.38850865, 43.7011592)),
(st_makepoint(-79.38801006, 43.70125159)),
(st_makepoint(-79.38817227, 43.70122327)),
(st_makepoint(-79.30049027, 43.66623551)),
(st_makepoint(-79.55510716, 43.69890333)),
(st_makepoint(-79.55494425, 43.69894107)),
(st_makepoint(-79.36145799, 43.75597655)),
(st_makepoint(-79.36126894, 43.75600256)),
(st_makepoint(-79.36164705, 43.75594958)),
(st_makepoint(-79.36183476, 43.75592454)),
(st_makepoint(-79.52659864, 43.60090678)),
(st_makepoint(-79.52676603, 43.60086738)),
(st_makepoint(-79.43823951, 43.6336196)),
(st_makepoint(-79.43810085, 43.6335481)),
(st_makepoint(-79.43782879, 43.63341275)),
(st_makepoint(-79.43796043, 43.63347914)),
(st_makepoint(-79.50740475, 43.65812054)),
(st_makepoint(-79.50724031, 43.65815782)),
(st_makepoint(-79.30543122, 43.80589994)),
(st_makepoint(-79.3052636, 43.80595373)),
(st_makepoint(-79.30509599, 43.80600753)),
(st_makepoint(-79.30493064, 43.80605969)),
(st_makepoint(-79.30476529, 43.80611349)),
(st_makepoint(-79.54852371, 43.74722517)),
(st_makepoint(-79.54870436, 43.74718294)),
(st_makepoint(-79.54888657, 43.747143)),
(st_makepoint(-79.39916151, 43.72059609)),
(st_makepoint(-79.39901512, 43.7205392)),
(st_makepoint(-79.3993069, 43.72065371)),
(st_makepoint(-79.3990207, 43.72079089)),
(st_makepoint(-79.34929962, 43.70293604)),
(st_makepoint(-79.34943813, 43.70285323)),
(st_makepoint(-79.3491577, 43.70301761)),
(st_makepoint(-79.34901919, 43.70310166)),
(st_makepoint(-79.34873536, 43.70326479)),
(st_makepoint(-79.34887728, 43.70318323)),
(st_makepoint(-79.40793756, 43.79762628)),
(st_makepoint(-79.40775187, 43.79760746)),
(st_makepoint(-79.40812584, 43.79764604)),
(st_makepoint(-79.51464923, 43.63832196)),
(st_makepoint(-79.51451789, 43.63840702)),
(st_makepoint(-79.41093783, 43.71532333)),
(st_makepoint(-79.41129872, 43.71540619)),
(st_makepoint(-79.41103906, 43.71541304)),
(st_makepoint(-79.41074681, 43.71529366)),
(st_makepoint(-79.23197752, 43.80349764)),
(st_makepoint(-79.23180428, 43.80353729)),
(st_makepoint(-79.23163103, 43.80357694)),
(st_makepoint(-79.2176839, 43.80884495)),
(st_makepoint(-79.21793821, 43.80901631)),
(st_makepoint(-79.21781194, 43.80892936)),
(st_makepoint(-79.49021165, 43.62075451)),
(st_makepoint(-79.49008945, 43.62084742)),
(st_makepoint(-79.48996698, 43.62094273)),
(st_makepoint(-79.4940859, 43.71612334)),
(st_makepoint(-79.49390429, 43.71615853)),
(st_makepoint(-79.49372407, 43.71619372)),
(st_makepoint(-79.56345715, 43.68950431)),
(st_makepoint(-79.56357188, 43.68940418)),
(st_makepoint(-79.56369369, 43.68931038)),
(st_makepoint(-79.29532472, 43.69191706)),
(st_makepoint(-79.29516321, 43.69195455)),
(st_makepoint(-79.29549318, 43.69187832)),
(st_makepoint(-79.29499476, 43.69199203)),
(st_makepoint(-79.29511541, 43.69166907)),
(st_makepoint(-79.3058628, 43.75386682)),
(st_makepoint(-79.30569425, 43.75390303)),
(st_makepoint(-79.30603482, 43.75383187)),
(st_makepoint(-79.26657777, 43.7804893)),
(st_makepoint(-79.26640424, 43.78052596)),
(st_makepoint(-79.2662307, 43.78056261)),
(st_makepoint(-79.28106877, 43.74695746)),
(st_makepoint(-79.2812399, 43.74692237)),
(st_makepoint(-79.2809009, 43.74699374)),
(st_makepoint(-79.35406526, 43.79802626)),
(st_makepoint(-79.35369188, 43.7981083)),
(st_makepoint(-79.35387566, 43.79806812)),
(st_makepoint(-79.58780012, 43.64341557)),
(st_makepoint(-79.58794771, 43.64334501)),
(st_makepoint(-79.57917903, 43.63202211)),
(st_makepoint(-79.57882863, 43.6319731)),
(st_makepoint(-79.57900318, 43.63199695)),
(st_makepoint(-79.493644, 43.60917779)),
(st_makepoint(-79.49348227, 43.6092118)),
(st_makepoint(-79.4938036, 43.60914378)),
(st_makepoint(-79.4935712, 43.60893539)),
(st_makepoint(-79.43456388, 43.79164456)),
(st_makepoint(-79.43438119, 43.79168405)),
(st_makepoint(-79.43419849, 43.79172451)),
(st_makepoint(-79.38236127, 43.69325809)),
(st_makepoint(-79.38282529, 43.69315927)),
(st_makepoint(-79.38267109, 43.69319256)),
(st_makepoint(-79.3825169, 43.6932248)),
(st_makepoint(-79.38297804, 43.69312702)),
(st_makepoint(-79.38223315, 43.69358275)),
(st_makepoint(-79.37227743, 43.65512985)),
(st_makepoint(-79.37211602, 43.6551667)),
(st_makepoint(-79.24578847, 43.77006118)),
(st_makepoint(-79.24596241, 43.770025)),
(st_makepoint(-79.24613777, 43.76998679)),
(st_makepoint(-79.47183506, 43.71827696)),
(st_makepoint(-79.47166319, 43.71830252)),
(st_makepoint(-79.40805249, 43.7662024)),
(st_makepoint(-79.3029781, 43.68261507)),
(st_makepoint(-79.30330383, 43.68254627)),
(st_makepoint(-79.3034667, 43.68251079)),
(st_makepoint(-79.30281523, 43.68265055)),
(st_makepoint(-79.30314096, 43.68258176)),
(st_makepoint(-79.49046919, 43.65111594)),
(st_makepoint(-79.49029291, 43.65114304)),
(st_makepoint(-79.49020169, 43.65082075)),
(st_makepoint(-79.49036348, 43.65057076)),
(st_makepoint(-79.35078455, 43.78203982)),
(st_makepoint(-79.35088216, 43.78174711)),
(st_makepoint(-79.35071429, 43.78176402)),
(st_makepoint(-79.35095007, 43.78201949)),
(st_makepoint(-79.39928015, 43.6969922)),
(st_makepoint(-79.39944322, 43.69695834)),
(st_makepoint(-79.50956085, 43.61631438)),
(st_makepoint(-79.50973223, 43.61627647)),
(st_makepoint(-79.4953937, 43.63924231)),
(st_makepoint(-79.49554973, 43.63920899)),
(st_makepoint(-79.49523155, 43.63927564)),
(st_makepoint(-79.49570423, 43.63917566)),
(st_makepoint(-79.31915436, 43.75468027)),
(st_makepoint(-79.51906095, 43.71397485)),
(st_makepoint(-79.51924618, 43.71394288)),
(st_makepoint(-79.51942956, 43.71391357)),
(st_makepoint(-79.54979383, 43.71129856)),
(st_makepoint(-79.54384713, 43.7125728)),
(st_makepoint(-79.54961871, 43.71133286)),
(st_makepoint(-79.5436765, 43.71261212)),
(st_makepoint(-79.54350184, 43.71265415)),
(st_makepoint(-79.5433256, 43.71269488)),
(st_makepoint(-79.54408584, 43.71256193)),
(st_makepoint(-79.28492538, 43.69675134)),
(st_makepoint(-79.2847669, 43.69681044)),
(st_makepoint(-79.28460568, 43.69687151)),
(st_makepoint(-79.49893224, 43.59861493)),
(st_makepoint(-79.49903764, 43.59885933)),
(st_makepoint(-79.4990875, 43.59898665)),
(st_makepoint(-79.49897992, 43.59873166)),
(st_makepoint(-79.54023202, 43.67270221)),
(st_makepoint(-79.54009938, 43.67279909)),
(st_makepoint(-79.50594856, 43.62657891)),
(st_makepoint(-79.39151097, 43.67626161)),
(st_makepoint(-79.39375401, 43.67670885)),
(st_makepoint(-79.39480268, 43.67641771)),
(st_makepoint(-79.39167044, 43.67623209)),
(st_makepoint(-79.39415521, 43.67651494)),
(st_makepoint(-79.39463389, 43.67645071)),
(st_makepoint(-79.39199285, 43.67616925)),
(st_makepoint(-79.39419435, 43.67663285)),
(st_makepoint(-79.39518075, 43.67642083)),
(st_makepoint(-79.39183345, 43.67620134)),
(st_makepoint(-79.39371361, 43.67659003)),
(st_makepoint(-79.39501196, 43.6764529)),
(st_makepoint(-79.46973613, 43.65990043)),
(st_makepoint(-79.46959546, 43.65984686)),
(st_makepoint(-79.46977542, 43.65960104)),
(st_makepoint(-79.469913, 43.65965168)),
(st_makepoint(-79.47368631, 43.64468087)),
(st_makepoint(-79.4735216, 43.64471571)),
(st_makepoint(-79.47336239, 43.64475056)),
(st_makepoint(-79.47320318, 43.64478442)),
(st_makepoint(-79.45320245, 43.78603914)),
(st_makepoint(-79.45338247, 43.78600336)),
(st_makepoint(-79.37869472, 43.68336863)),
(st_makepoint(-79.37994518, 43.68307411)),
(st_makepoint(-79.3788488, 43.68333821)),
(st_makepoint(-79.380109, 43.68304016)),
(st_makepoint(-79.37823572, 43.68346108)),
(st_makepoint(-79.37854389, 43.68339788)),
(st_makepoint(-79.3783898, 43.68342948)),
(st_makepoint(-79.37808326, 43.6834915)),
(st_makepoint(-79.37913189, 43.6833129199999)),
(st_makepoint(-79.53885664, 43.65842435)),
(st_makepoint(-79.53851445, 43.65850203)),
(st_makepoint(-79.53868482, 43.65846444)),
(st_makepoint(-79.50806035, 43.59518774)),
(st_makepoint(-79.50810273, 43.59528723)),
(st_makepoint(-79.60500827, 43.75253274)),
(st_makepoint(-79.60517885, 43.75249406)),
(st_makepoint(-79.6048405, 43.75257244)),
(st_makepoint(-79.3210754, 43.76370464)),
(st_makepoint(-79.32089574, 43.76375187)),
(st_makepoint(-79.32071609, 43.76379702)),
(st_makepoint(-79.32053786, 43.76384321)),
(st_makepoint(-79.32073912, 43.7641261)),
(st_makepoint(-79.38942478, 43.79258616)),
(st_makepoint(-79.38960763, 43.79254746)),
(st_makepoint(-79.38978902, 43.7925098)),
(st_makepoint(-79.47774834, 43.6682714)),
(st_makepoint(-79.47790956, 43.66823581)),
(st_makepoint(-79.24216212, 43.70539961)),
(st_makepoint(-79.24148536, 43.70551391)),
(st_makepoint(-79.24231327, 43.70533757)),
(st_makepoint(-79.24164947, 43.70545661)),
(st_makepoint(-79.241436, 43.705082)),
(st_makepoint(-79.51095312, 43.67606649)),
(st_makepoint(-79.51079362, 43.67612267)),
(st_makepoint(-79.51063253, 43.67617656)),
(st_makepoint(-79.51047145, 43.67623045)),
(st_makepoint(-79.35245229, 43.79104936)),
(st_makepoint(-79.35208602, 43.79107756)),
(st_makepoint(-79.35190224, 43.79109397)),
(st_makepoint(-79.35226979, 43.791063)),
(st_makepoint(-79.49813585, 43.75574249)),
(st_makepoint(-79.49794742, 43.75573101)),
(st_makepoint(-79.21050726, 43.78812802)),
(st_makepoint(-79.21016463, 43.78819659)),
(st_makepoint(-79.21033594, 43.78816355)),
(st_makepoint(-79.33870752, 43.79754498)),
(st_makepoint(-79.33839605, 43.79727486)),
(st_makepoint(-79.33853096, 43.79758545)),
(st_makepoint(-79.33857261, 43.79723299)),
(st_makepoint(-79.54507528, 43.68209369)),
(st_makepoint(-79.54471192, 43.6821057)),
(st_makepoint(-79.54489458, 43.68210005)),
(st_makepoint(-79.54826365, 43.60279773)),
(st_makepoint(-79.548098, 43.60283347)),
(st_makepoint(-79.40880188, 43.68389191)),
(st_makepoint(-79.40898792, 43.68348744)),
(st_makepoint(-79.40865961, 43.68355863)),
(st_makepoint(-79.40912582, 43.68381754)),
(st_makepoint(-79.40833568, 43.68363142)),
(st_makepoint(-79.40847139, 43.68396151)),
(st_makepoint(-79.40882158, 43.68352224)),
(st_makepoint(-79.40842725, 43.6843336599999)),
(st_makepoint(-79.44403272, 43.64914108)),
(st_makepoint(-79.44420452, 43.64910508)),
(st_makepoint(-79.51584331, 43.74150002)),
(st_makepoint(-79.51565282, 43.74151166)),
(st_makepoint(-79.51546554, 43.74152445)),
(st_makepoint(-79.40808359, 43.64165035)),
(st_makepoint(-79.40812439, 43.64176999)),
(st_makepoint(-79.30172608, 43.78739564)),
(st_makepoint(-79.30224552, 43.78727862)),
(st_makepoint(-79.30207177, 43.78731762)),
(st_makepoint(-79.30189802, 43.78735663)),
(st_makepoint(-79.53258882, 43.72176497)),
(st_makepoint(-79.5327753, 43.72172188)),
(st_makepoint(-79.55206435, 43.728233)),
(st_makepoint(-79.55214685, 43.72812245)),
(st_makepoint(-79.57833983, 43.72454631)),
(st_makepoint(-79.57828845, 43.72443877)),
(st_makepoint(-79.57838913, 43.72464952)),
(st_makepoint(-79.57823597, 43.72433532)),
(st_makepoint(-79.50187352, 43.64156439)),
(st_makepoint(-79.50171338, 43.64159927)),
(st_makepoint(-79.31574876, 43.73584145)),
(st_makepoint(-79.31556661, 43.73580419)),
(st_makepoint(-79.31538136, 43.73576582)),
(st_makepoint(-79.45201697, 43.66656969)),
(st_makepoint(-79.4518412, 43.66660468)),
(st_makepoint(-79.19832595, 43.79144095)),
(st_makepoint(-79.19841049, 43.79165315)),
(st_makepoint(-79.19836698, 43.79153961)),
(st_makepoint(-79.19828573, 43.79133618)),
(st_makepoint(-79.2546493, 43.75602336)),
(st_makepoint(-79.25501447, 43.75601397)),
(st_makepoint(-79.25483345, 43.75601697)),
(st_makepoint(-79.33898719, 43.75037038)),
(st_makepoint(-79.33887823, 43.75048245)),
(st_makepoint(-79.52004616, 43.64786247)),
(st_makepoint(-79.51971138, 43.64780415)),
(st_makepoint(-79.51987877, 43.64783271)),
(st_makepoint(-79.30645837, 43.71094165)),
(st_makepoint(-79.30662604, 43.71090506)),
(st_makepoint(-79.39991418, 43.7511488)),
(st_makepoint(-79.40009349, 43.75111807)),
(st_makepoint(-79.40026841, 43.75108627)),
(st_makepoint(-79.40044478, 43.75105873)),
(st_makepoint(-79.4005946899999, 43.75105109)),
(st_makepoint(-79.36764193, 43.70548294)),
(st_makepoint(-79.36778565, 43.70584616)),
(st_makepoint(-79.36781241, 43.70545653)),
(st_makepoint(-79.36760438, 43.70587412)),
(st_makepoint(-79.36724402, 43.70592692)),
(st_makepoint(-79.36742528, 43.70590052)),
(st_makepoint(-79.4124157, 43.64666355)),
(st_makepoint(-79.41210347, 43.64638662)),
(st_makepoint(-79.41274034, 43.64660007)),
(st_makepoint(-79.41257699, 43.64663403)),
(st_makepoint(-79.53424727, 43.69490251)),
(st_makepoint(-79.43700745, 43.70753823)),
(st_makepoint(-79.43648387, 43.70764761)),
(st_makepoint(-79.43683292, 43.70757429)),
(st_makepoint(-79.4366584, 43.70760914)),
(st_makepoint(-79.3932826, 43.72913182)),
(st_makepoint(-79.39278297, 43.72923712)),
(st_makepoint(-79.39294951, 43.72920202)),
(st_makepoint(-79.39311606, 43.72916692)),
(st_makepoint(-79.39261495, 43.72927222)),
(st_makepoint(-79.54741676, 43.64415629)),
(st_makepoint(-79.40645841, 43.7907447)),
(st_makepoint(-79.40629124, 43.79078244)),
(st_makepoint(-79.55918125, 43.6632802)),
(st_makepoint(-79.55883277, 43.66325771)),
(st_makepoint(-79.55935271, 43.66329134)),
(st_makepoint(-79.55900879, 43.66326918)),
(st_makepoint(-79.56621687, 43.64120715)),
(st_makepoint(-79.5664128, 43.64116249)),
(st_makepoint(-79.56601794, 43.64125181)),
(st_makepoint(-79.1260191, 43.79254947)),
(st_makepoint(-79.1258758, 43.79247869)),
(st_makepoint(-79.12573065, 43.79240655)),
(st_makepoint(-79.56768523, 43.68273695)),
(st_makepoint(-79.56751607, 43.68277467)),
(st_makepoint(-79.56784829, 43.68269768)),
(st_makepoint(-79.51895738, 43.687485)),
(st_makepoint(-79.51878336, 43.68752235)),
(st_makepoint(-79.51912878, 43.68744812)),
(st_makepoint(-79.51842254, 43.69772494)),
(st_makepoint(-79.5182457, 43.69769094)),
(st_makepoint(-79.51798228, 43.69778001)),
(st_makepoint(-79.51780543, 43.69774732)),
(st_makepoint(-79.54205012, 43.68821725)),
(st_makepoint(-79.54194438, 43.68798899)),
(st_makepoint(-79.54199936, 43.68810581)),
(st_makepoint(-79.54188849, 43.68786656)),
(st_makepoint(-79.40853245, 43.76610166)),
(st_makepoint(-79.40830732, 43.76615155)),
(st_makepoint(-79.40875218, 43.76605895)),
(st_makepoint(-79.408818, 43.766041)),
(st_makepoint(-79.317182, 43.76992939)),
(st_makepoint(-79.31748896, 43.77006925)),
(st_makepoint(-79.31733634, 43.76999932)),
(st_makepoint(-79.34849634, 43.67597123)),
(st_makepoint(-79.34832335, 43.67600946)),
(st_makepoint(-79.42408744, 43.67658129)),
(st_makepoint(-79.40548109, 43.74010831)),
(st_makepoint(-79.40534608, 43.73967306)),
(st_makepoint(-79.40510564, 43.74016446)),
(st_makepoint(-79.40515836, 43.73969896)),
(st_makepoint(-79.40529337, 43.74013566)),
(st_makepoint(-79.40499951, 43.73994187)))
select concat('{"type":"Feature","properties":{},"geometry":', st_asgeojson(point), '}') from points;

map.geojson