Skip to content

Instantly share code, notes, and snippets.

@jatorre

jatorre/intersection_in_h3.sql

Created February 4, 2021 15:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jatorre/b0c6901234e3058601db5cc12c59bf32 to your computer and use it in GitHub Desktop.
Save jatorre/b0c6901234e3058601db5cc12c59bf32 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
intersection_in_h3.sql
--We create some fake isochrones
with pois AS (
SELECT ST_GEOGFROMGEOJSON('{"type":"MultiPolygon","coordinates":[[[[-3.9519882,40.262146],[-3.9358521,40.262146],[-3.9337921,40.2614594],[-3.9324188,40.2600861],[-3.9303589,40.2593994],[-3.9276123,40.2593994],[-3.9255524,40.2587128],[-3.9241791,40.2573395],[-3.9221191,40.2566528],[-3.9193726,40.2566528],[-3.9173126,40.2573395],[-3.9131927,40.2614594],[-3.9090729,40.2628326],[-3.9076996,40.2642059],[-3.9035797,40.2655792],[-3.8967133,40.2724457],[-3.8925934,40.273819],[-3.8912201,40.2751923],[-3.8871002,40.2765656],[-3.8857269,40.2779388],[-3.883667,40.2786255],[-3.8781738,40.2786255],[-3.8761139,40.2793121],[-3.8747406,40.2806854],[-3.8706207,40.2820587],[-3.8665009,40.2861786],[-3.862381,40.2875519],[-3.8610077,40.2916718],[-3.8568878,40.2957916],[-3.8562012,40.2978516],[-3.8562012,40.3033447],[-3.8568878,40.3054047],[-3.8610077,40.306778],[-3.8637543,40.3095245],[-3.8651276,40.3136444],[-3.8665009,40.3150177],[-3.8678741,40.3191376],[-3.8692474,40.3205109],[-3.8699341,40.3225708],[-3.8699341,40.3253174],[-3.8692474,40.3273773],[-3.8678741,40.3287506],[-3.8678741,40.3301239],[-3.8699341,40.3308105],[-3.8754272,40.3308105],[-3.8774872,40.3301239],[-3.8774872,40.3287506],[-3.8761139,40.3273773],[-3.8761139,40.326004],[-3.8802338,40.3246307],[-3.8816071,40.3232574],[-3.883667,40.3225708],[-3.8857269,40.3232574],[-3.8871002,40.3273773],[-3.8884735,40.3273773],[-3.8912201,40.3246307],[-3.8919067,40.3225708],[-3.8919067,40.3198242],[-3.8925934,40.3177643],[-3.8967133,40.3136444],[-3.8980865,40.3095245],[-3.9035797,40.3040314],[-3.9076996,40.3026581],[-3.9090729,40.3012848],[-3.9111328,40.3005981],[-3.9248657,40.3005981],[-3.9269257,40.3012848],[-3.9276123,40.3033447],[-3.9269257,40.3054047],[-3.9248657,40.3060913],[-3.9138794,40.3060913],[-3.9118195,40.306778],[-3.9104462,40.3081512],[-3.9063263,40.3095245],[-3.9035797,40.3122711],[-3.9022064,40.316391],[-3.8980865,40.3205109],[-3.8973999,40.3225708],[-3.8973999,40.3253174],[-3.8967133,40.3273773],[-3.89534,40.3287506],[-3.8946533,40.3308105],[-3.8946533,40.3335571],[-3.89534,40.3356171],[-3.8980865,40.3383636],[-3.9022064,40.3397369],[-3.9035797,40.3438568],[-3.904953,40.3452301],[-3.9056396,40.34729],[-3.904953,40.34935],[-3.9028931,40.3500366],[-3.9008331,40.34935],[-3.8994598,40.3479767],[-3.89534,40.3466034],[-3.8912201,40.3424835],[-3.8891602,40.3417969],[-3.8864136,40.3417969],[-3.8843536,40.3424835],[-3.8816071,40.3452301],[-3.8816071,40.3466034],[-3.8829803,40.3479767],[-3.883667,40.3500366],[-3.8829803,40.3520966],[-3.8809204,40.3527832],[-3.8754272,40.3527832],[-3.8733673,40.3534698],[-3.8692474,40.3575897],[-3.8651276,40.358963],[-3.8651276,40.3603363],[-3.8692474,40.3644562],[-3.8706207,40.368576],[-3.8802338,40.3781891],[-3.8816071,40.382309],[-3.8857269,40.3864288],[-3.8871002,40.3905487],[-3.8884735,40.3905487],[-3.8898468,40.3891754],[-3.8939667,40.3878021],[-3.89534,40.3864288],[-3.8994598,40.3850555],[-3.904953,40.3795624],[-3.9063263,40.3754425],[-3.9104462,40.3713226],[-3.9118195,40.3672028],[-3.9159393,40.3658295],[-3.916626,40.3637695],[-3.9159393,40.3617096],[-3.9118195,40.3575897],[-3.9111328,40.3555298],[-3.9118195,40.3534698],[-3.9138794,40.3527832],[-3.916626,40.3527832],[-3.9186859,40.3534698],[-3.9200592,40.3575897],[-3.9241791,40.358963],[-3.9255524,40.3603363],[-3.9276123,40.3610229],[-3.9303589,40.3610229],[-3.9324188,40.3603363],[-3.9337921,40.358963],[-3.9358521,40.3582764],[-3.9413452,40.3582764],[-3.9434052,40.358963],[-3.9461517,40.3617096],[-3.9461517,40.3630829],[-3.9440918,40.3637695],[-3.9358521,40.3637695],[-3.9337921,40.3644562],[-3.9324188,40.3658295],[-3.9303589,40.3665161],[-3.9276123,40.3665161],[-3.9255524,40.3672028],[-3.9228058,40.3699493],[-3.9214325,40.3740692],[-3.9173126,40.3754425],[-3.9118195,40.3809357],[-3.9104462,40.3850555],[-3.9063263,40.3891754],[-3.904953,40.3932953],[-3.9028931,40.3939819],[-3.9001465,40.3939819],[-3.8980865,40.3946686],[-3.8967133,40.3960419],[-3.8925934,40.3974152],[-3.8925934,40.3987885],[-3.8939667,40.4001617],[-3.8946533,40.4022217],[-3.8946533,40.4049683],[-3.89534,40.4070282],[-3.8980865,40.4097748],[-3.9001465,40.4104614],[-3.9028931,40.4104614],[-3.904953,40.4111481],[-3.9076996,40.4138947],[-3.9076996,40.4152679],[-3.9056396,40.4159546],[-3.8946533,40.4159546],[-3.8925934,40.4166412],[-3.8898468,40.4193878],[-3.8884735,40.4235077],[-3.8871002,40.424881],[-3.8857269,40.4290009],[-3.8843536,40.4303741],[-3.8829803,40.434494],[-3.8816071,40.4358673],[-3.8809204,40.4379272],[-3.8809204,40.4434204],[-3.8816071,40.4454803],[-3.8829803,40.4468536],[-3.8843536,40.4509735],[-3.8884735,40.4523468],[-3.8912201,40.4550934],[-3.8912201,40.4564667],[-3.8891602,40.4571533],[-3.8864136,40.4571533],[-3.8843536,40.45784],[-3.8843536,40.4592133],[-3.8857269,40.4605865],[-3.8864136,40.4626465],[-3.8857269,40.4647064],[-3.883667,40.4653931],[-3.8816071,40.4647064],[-3.8774872,40.4605865],[-3.8733673,40.4592133],[-3.871994,40.45784],[-3.8706207,40.45784],[-3.8692474,40.4592133],[-3.8671875,40.4598999],[-3.8644409,40.4598999],[-3.862381,40.4592133],[-3.8610077,40.45784],[-3.8568878,40.4564667],[-3.8541412,40.4537201],[-3.8527679,40.4496002],[-3.8500214,40.4468536],[-3.8479614,40.446167],[-3.8314819,40.446167],[-3.829422,40.4468536],[-3.8253021,40.4509735],[-3.8211823,40.4523468],[-3.819809,40.4564667],[-3.8156891,40.4605865],[-3.8150024,40.4626465],[-3.8150024,40.4653931],[-3.8143158,40.467453],[-3.8115692,40.4701996],[-3.8101959,40.4701996],[-3.8088226,40.4688263],[-3.8067627,40.4681396],[-3.7957764,40.4681396],[-3.7937164,40.4688263],[-3.78685,40.4756927],[-3.78479,40.4763794],[-3.7792969,40.4763794],[-3.7772369,40.4756927],[-3.7765503,40.4736328],[-3.7772369,40.4715729],[-3.7813568,40.4701996],[-3.7827301,40.4688263],[-3.78685,40.467453],[-3.78685,40.4660797],[-3.78479,40.4653931],[-3.7683105,40.4653931],[-3.7662506,40.4647064],[-3.765564,40.4626465],[-3.7662506,40.4605865],[-3.7683105,40.4598999],[-3.78479,40.4598999],[-3.78685,40.4605865],[-3.7882233,40.4619598],[-3.7902832,40.4626465],[-3.7923431,40.4619598],[-3.7937164,40.4605865],[-3.7957764,40.4598999],[-3.8012695,40.4598999],[-3.8033295,40.4592133],[-3.8040161,40.4571533],[-3.8040161,40.4489136],[-3.8047028,40.4468536],[-3.8067627,40.446167],[-3.8088226,40.4468536],[-3.8101959,40.4482269],[-3.8115692,40.4482269],[-3.8129425,40.4468536],[-3.8150024,40.446167],[-3.8204956,40.446167],[-3.8225555,40.4454803],[-3.8253021,40.4427338],[-3.8253021,40.4413605],[-3.8239288,40.4399872],[-3.8225555,40.4358673],[-3.8204956,40.4351807],[-3.8150024,40.4351807],[-3.8129425,40.4358673],[-3.8115692,40.4372406],[-3.8095093,40.4379272],[-3.8074493,40.4372406],[-3.806076,40.4358673],[-3.8040161,40.4351807],[-3.8019562,40.4358673],[-3.8005829,40.4372406],[-3.796463,40.4386139],[-3.7950897,40.4399872],[-3.7930298,40.4406738],[-3.7902832,40.4406738],[-3.7882233,40.4413605],[-3.78685,40.4427338],[-3.78479,40.4434204],[-3.7792969,40.4434204],[-3.7772369,40.4427338],[-3.7765503,40.4406738],[-3.7772369,40.4386139],[-3.7792969,40.4379272],[-3.78479,40.4379272],[-3.78685,40.4372406],[-3.7882233,40.4358673],[-3.7923431,40.434494],[-3.7937164,40.4303741],[-3.7978363,40.4290009],[-3.7992096,40.4269409],[-3.7998962,40.424881],[-3.7992096,40.4235077],[-3.796463,40.4207611],[-3.7950897,40.4166412],[-3.7930298,40.4159546],[-3.7875366,40.4159546],[-3.7854767,40.4152679],[-3.7841034,40.4138947],[-3.7799835,40.4125214],[-3.7744904,40.4070282],[-3.7731171,40.4029083],[-3.7710571,40.4022217],[-3.765564,40.4022217],[-3.763504,40.4029083],[-3.7621307,40.4042816],[-3.7600708,40.4049683],[-3.7580109,40.4042816],[-3.7566376,40.4001617],[-3.7525177,40.3987885],[-3.7511444,40.3946686],[-3.7490845,40.3939819],[-3.7463379,40.3939819],[-3.744278,40.3946686],[-3.7429047,40.3960419],[-3.7408447,40.3967285],[-3.7387848,40.3960419],[-3.7374115,40.3946686],[-3.7353516,40.3939819],[-3.7298584,40.3939819],[-3.7277985,40.3946686],[-3.7264252,40.3960419],[-3.7223053,40.3974152],[-3.7223053,40.3987885],[-3.7236786,40.4001617],[-3.7243652,40.4022217],[-3.7243652,40.413208],[-3.7236786,40.4152679],[-3.7216187,40.4159546],[-3.7195587,40.4152679],[-3.7188721,40.413208],[-3.7188721,40.4049683],[-3.7181854,40.4029083],[-3.7161255,40.4022217],[-3.7106323,40.4022217],[-3.7085724,40.401535],[-3.7071991,40.4001617],[-3.7051392,40.3994751],[-3.7030792,40.4001617],[-3.7030792,40.401535],[-3.7044525,40.4029083],[-3.7051392,40.4049683],[-3.7044525,40.4070282],[-3.7023926,40.4077148],[-3.699646,40.4077148],[-3.6975861,40.4070282],[-3.6962128,40.4056549],[-3.6920929,40.4042816],[-3.6907196,40.4029083],[-3.6893463,40.4029083],[-3.687973,40.4042816],[-3.6859131,40.4049683],[-3.6831665,40.4049683],[-3.6811066,40.4042816],[-3.6797333,40.4029083],[-3.67836,40.4029083],[-3.6776733,40.4049683],[-3.6776733,40.4077148],[-3.6769867,40.4097748],[-3.6728668,40.4111481],[-3.6714935,40.4125214],[-3.6694336,40.413208],[-3.666687,40.413208],[-3.6646271,40.4138947],[-3.6639404,40.4159546],[-3.6646271,40.4180145],[-3.6687469,40.4193878],[-3.6687469,40.4207611],[-3.666687,40.4214478],[-3.6639404,40.4214478],[-3.6618805,40.4221344],[-3.6618805,40.4235077],[-3.6632538,40.424881],[-3.6639404,40.4269409],[-3.6639404,40.4324341],[-3.6632538,40.434494],[-3.6611938,40.4351807],[-3.6591339,40.434494],[-3.6584473,40.4324341],[-3.6584473,40.4296875],[-3.6577606,40.4276276],[-3.6563873,40.4262543],[-3.655014,40.4221344],[-3.6522675,40.4193878],[-3.6502075,40.4187012],[-3.6474609,40.4187012],[-3.645401,40.4180145],[-3.6440277,40.4166412],[-3.6419678,40.4159546],[-3.6392212,40.4159546],[-3.6371613,40.4166412],[-3.635788,40.4180145],[-3.633728,40.4187012],[-3.6309814,40.4187012],[-3.6289215,40.4180145],[-3.6275482,40.4166412],[-3.6254883,40.4159546],[-3.6227417,40.4159546],[-3.6206818,40.4166412],[-3.6193085,40.4180145],[-3.6172485,40.4187012],[-3.614502,40.4187012],[-3.612442,40.4193878],[-3.6110687,40.4207611],[-3.6069489,40.4221344],[-3.6055756,40.4235077],[-3.6014557,40.424881],[-3.600769,40.4269409],[-3.600769,40.4296875],[-3.6000824,40.4317474],[-3.5987091,40.4331207],[-3.5973358,40.4372406],[-3.5952759,40.4379272],[-3.5932159,40.4372406],[-3.5925293,40.4351807],[-3.5925293,40.4296875],[-3.5932159,40.4276276],[-3.5945892,40.4262543],[-3.5959625,40.4221344],[-3.5987091,40.4193878],[-3.602829,40.4180145],[-3.6035156,40.4159546],[-3.602829,40.4138947],[-3.600769,40.413208],[-3.5925293,40.413208],[-3.5904694,40.4125214],[-3.5890961,40.4111481],[-3.5870361,40.4104614],[-3.5842896,40.4104614],[-3.5822296,40.4097748],[-3.5808563,40.4084015],[-3.5767365,40.4070282],[-3.5739899,40.4042816],[-3.5733032,40.4022217],[-3.5739899,40.4001617],[-3.5760498,40.3994751],[-3.5781097,40.4001617],[-3.579483,40.401535],[-3.5836029,40.4029083],[-3.5849762,40.4042816],[-3.5870361,40.4049683],[-3.5897827,40.4049683],[-3.5918427,40.4056549],[-3.5932159,40.4070282],[-3.5952759,40.4077148],[-3.5980225,40.4077148],[-3.6000824,40.4084015],[-3.6014557,40.4097748],[-3.6035156,40.4104614],[-3.6090088,40.4104614],[-3.6110687,40.4097748],[-3.6110687,40.4084015],[-3.6096954,40.4070282],[-3.6090088,40.4049683],[-3.6096954,40.4029083],[-3.612442,40.4001617],[-3.614502,40.3994751],[-3.6199951,40.3994751],[-3.6220551,40.3987885],[-3.6248016,40.3960419],[-3.6248016,40.3946686],[-3.6227417,40.3939819],[-3.6199951,40.3939819],[-3.6179352,40.3932953],[-3.6165619,40.391922],[-3.614502,40.3912354],[-3.6090088,40.3912354],[-3.6069489,40.3905487],[-3.6055756,40.3891754],[-3.6014557,40.3878021],[-3.600769,40.3857422],[-3.600769,40.3829956],[-3.6000824,40.3809357],[-3.5980225,40.380249],[-3.5952759,40.380249],[-3.5932159,40.3809357],[-3.5890961,40.3850555],[-3.5870361,40.3857422],[-3.5849762,40.3850555],[-3.5842896,40.3829956],[-3.5849762,40.3809357],[-3.5890961,40.3768158],[-3.5897827,40.3747559],[-3.5890961,40.3726959],[-3.5849762,40.3713226],[-3.5836029,40.3699493],[-3.581543,40.3692627],[-3.5760498,40.3692627],[-3.5739899,40.368576],[-3.5684967,40.3630829],[-3.5684967,40.3617096],[-3.5705566,40.3610229],[-3.5733032,40.3610229],[-3.5753632,40.3617096],[-3.5767365,40.3630829],[-3.5787964,40.3637695],[-3.5842896,40.3637695],[-3.5863495,40.3644562],[-3.5877228,40.3658295],[-3.5897827,40.3665161],[-3.5925293,40.3665161],[-3.5945892,40.3672028],[-3.5959625,40.368576],[-3.5980225,40.3692627],[-3.6000824,40.368576],[-3.6151886,40.3534698],[-3.6172485,40.3527832],[-3.6227417,40.3527832],[-3.6248016,40.3520966],[-3.6261749,40.3507233],[-3.6282349,40.3500366],[-3.6309814,40.3500366],[-3.6330414,40.34935],[-3.6330414,40.3479767],[-3.6289215,40.3438568],[-3.6282349,40.3417969],[-3.6282349,40.3390503],[-3.6275482,40.3369904],[-3.6261749,40.3369904],[-3.6248016,40.3383636],[-3.6227417,40.3390503],[-3.614502,40.3390503],[-3.612442,40.3383636],[-3.612442,40.3369904],[-3.6151886,40.3342438],[-3.6172485,40.3335571],[-3.6199951,40.3335571],[-3.6220551,40.3328705],[-3.6234283,40.3314972],[-3.6254883,40.3308105],[-3.6282349,40.3308105],[-3.6302948,40.3301239],[-3.6316681,40.3287506],[-3.635788,40.3273773],[-3.6412811,40.3218842],[-3.6426544,40.3177643],[-3.645401,40.3150177],[-3.6474609,40.3143311],[-3.6495209,40.3150177],[-3.6502075,40.3170776],[-3.6495209,40.3191376],[-3.6481476,40.3205109],[-3.6467743,40.3246307],[-3.6385345,40.3328705],[-3.6344147,40.3342438],[-3.633728,40.3363037],[-3.633728,40.3390503],[-3.6344147,40.3411102],[-3.6399078,40.3466034],[-3.6419678,40.34729],[-3.6440277,40.3466034],[-3.645401,40.3452301],[-3.6495209,40.3438568],[-3.6536407,40.3397369],[-3.6577606,40.3383636],[-3.6605072,40.3356171],[-3.6605072,40.3342438],[-3.6591339,40.3328705],[-3.6577606,40.3287506],[-3.6563873,40.3273773],[-3.6563873,40.326004],[-3.6591339,40.3232574],[-3.6605072,40.3232574],[-3.6646271,40.3273773],[-3.6660004,40.3273773],[-3.6701202,40.3232574],[-3.6714935,40.3232574],[-3.6721802,40.3253174],[-3.6721802,40.328064],[-3.6728668,40.3301239],[-3.6742401,40.3301239],[-3.67836,40.326004],[-3.6824799,40.3246307],[-3.6838531,40.3232574],[-3.687973,40.3218842],[-3.6893463,40.3177643],[-3.6934662,40.316391],[-3.6941528,40.3143311],[-3.6941528,40.3115845],[-3.6948395,40.3095245],[-3.6989594,40.3081512],[-3.7003326,40.306778],[-3.7023926,40.3060913],[-3.7044525,40.306778],[-3.7058258,40.3081512],[-3.7071991,40.3081512],[-3.7085724,40.3040314],[-3.7106323,40.3033447],[-3.7161255,40.3033447],[-3.7181854,40.3026581],[-3.7223053,40.2985382],[-3.7243652,40.2978516],[-3.7271118,40.2978516],[-3.7291718,40.2971649],[-3.730545,40.2957916],[-3.7346649,40.2944183],[-3.7353516,40.2923584],[-3.7353516,40.2868652],[-3.7346649,40.2848053],[-3.732605,40.2841187],[-3.7271118,40.2841187],[-3.7250519,40.283432],[-3.7236786,40.2793121],[-3.720932,40.2765656],[-3.7188721,40.2758789],[-3.699646,40.2758789],[-3.6975861,40.2765656],[-3.6948395,40.2793121],[-3.6941528,40.2813721],[-3.6941528,40.2978516],[-3.6934662,40.2999115],[-3.6914063,40.3005981],[-3.6893463,40.2999115],[-3.6886597,40.2978516],[-3.6886597,40.295105],[-3.687973,40.293045],[-3.6865997,40.2916718],[-3.6865997,40.2902985],[-3.687973,40.2889252],[-3.6886597,40.2868652],[-3.6886597,40.2841187],[-3.687973,40.2820587],[-3.6865997,40.2820587],[-3.6838531,40.2848053],[-3.6824799,40.2889252],[-3.6742401,40.2971649],[-3.6701202,40.2985382],[-3.6632538,40.3054047],[-3.6591339,40.306778],[-3.6577606,40.3081512],[-3.6557007,40.3088379],[-3.6529541,40.3088379],[-3.6508942,40.3081512],[-3.6508942,40.306778],[-3.6563873,40.3012848],[-3.6605072,40.2999115],[-3.6673737,40.293045],[-3.6714935,40.2916718],[-3.6769867,40.2861786],[-3.67836,40.2820587],[-3.687973,40.2724457],[-3.6886597,40.2703857],[-3.6886597,40.2511597],[-3.687973,40.2490997],[-3.6865997,40.2477264],[-3.6859131,40.2456665],[-3.6859131,40.2429199],[-3.6865997,40.24086],[-3.6886597,40.2401733],[-3.6907196,40.24086],[-3.6920929,40.2449799],[-3.6934662,40.2463531],[-3.6941528,40.2484131],[-3.6941528,40.2676392],[-3.6948395,40.2696991],[-3.6968994,40.2703857],[-3.6989594,40.2696991],[-3.7003326,40.2683258],[-3.7044525,40.2669525],[-3.7058258,40.2655792],[-3.7078857,40.2648926],[-3.7106323,40.2648926],[-3.7126923,40.2655792],[-3.7168121,40.2696991],[-3.7181854,40.2696991],[-3.7195587,40.2655792],[-3.7264252,40.2587128],[-3.7264252,40.2573395],[-3.7223053,40.2559662],[-3.7181854,40.2518463],[-3.7140656,40.250473],[-3.7133789,40.2484131],[-3.7140656,40.2463531],[-3.7161255,40.2456665],[-3.7188721,40.2456665],[-3.720932,40.2463531],[-3.7250519,40.250473],[-3.7291718,40.2518463],[-3.730545,40.2532196],[-3.7319183,40.2532196],[-3.7332916,40.2490997],[-3.7346649,40.2477264],[-3.7353516,40.2456665],[-3.7353516,40.2374268],[-3.7360382,40.2353668],[-3.7380981,40.2346802],[-3.7401581,40.2353668],[-3.7408447,40.2374268],[-3.7408447,40.2484131],[-3.7401581,40.250473],[-3.7387848,40.2518463],[-3.7380981,40.2539063],[-3.7380981,40.2566528],[-3.7387848,40.2587128],[-3.7408447,40.2593994],[-3.7435913,40.2593994],[-3.7456512,40.2587128],[-3.7470245,40.2573395],[-3.7490845,40.2566528],[-3.7511444,40.2573395],[-3.7525177,40.2587128],[-3.7545776,40.2593994],[-3.7573242,40.2593994],[-3.7593842,40.2587128],[-3.7607574,40.2545929],[-3.7621307,40.2532196],[-3.7628174,40.2511597],[-3.7621307,40.2490997],[-3.7580109,40.2477264],[-3.7573242,40.2456665],[-3.7580109,40.2436066],[-3.7600708,40.2429199],[-3.7628174,40.2429199],[-3.7648773,40.2422333],[-3.7662506,40.24086],[-3.7683105,40.2401733],[-3.7703705,40.24086],[-3.7717438,40.2449799],[-3.7731171,40.2449799],[-3.7744904,40.24086],[-3.7786102,40.2367401],[-3.7792969,40.2346802],[-3.7792969,40.229187],[-3.7799835,40.2271271],[-3.7813568,40.2257538],[-3.7820435,40.2236938],[-3.7820435,40.2182007],[-3.7827301,40.2161407],[-3.7854767,40.2133942],[-3.7875366,40.2127075],[-3.7895966,40.2133942],[-3.7902832,40.2154541],[-3.7902832,40.2182007],[-3.7895966,40.2202606],[-3.7882233,40.2216339],[-3.7875366,40.2236938],[-3.7875366,40.2264404],[-3.78685,40.2285004],[-3.7854767,40.2298737],[-3.78479,40.2319336],[-3.78479,40.2401733],[-3.7854767,40.2422333],[-3.7895966,40.2436066],[-3.7902832,40.2456665],[-3.7895966,40.2477264],[-3.7875366,40.2484131],[-3.78479,40.2484131],[-3.7827301,40.2490997],[-3.7813568,40.250473],[-3.7772369,40.2518463],[-3.7758636,40.2532196],[-3.7738037,40.2539063],[-3.7710571,40.2539063],[-3.7689972,40.2545929],[-3.7689972,40.2559662],[-3.7731171,40.2600861],[-3.7738037,40.262146],[-3.7731171,40.2642059],[-3.7689972,40.2683258],[-3.7689972,40.2696991],[-3.7744904,40.2751923],[-3.7765503,40.2758789],[-3.7792969,40.2758789],[-3.7813568,40.2751923],[-3.7827301,40.273819],[-3.78479,40.2731323],[-3.7957764,40.2731323],[-3.7978363,40.2724457],[-3.7992096,40.2710724],[-3.8012695,40.2703857],[-3.8040161,40.2703857],[-3.806076,40.2696991],[-3.8074493,40.2683258],[-3.8095093,40.2676392],[-3.8150024,40.2676392],[-3.8170624,40.2669525],[-3.8211823,40.2628326],[-3.8253021,40.2614594],[-3.8280487,40.2587128],[-3.8287354,40.2566528],[-3.8287354,40.2484131],[-3.829422,40.2463531],[-3.8307953,40.2449799],[-3.8314819,40.2429199],[-3.8307953,40.24086],[-3.8280487,40.2381134],[-3.8259888,40.2374268],[-3.8232422,40.2374268],[-3.8211823,40.2367401],[-3.819809,40.2353668],[-3.817749,40.2346802],[-3.8095093,40.2346802],[-3.8074493,40.2339935],[-3.8047028,40.2312469],[-3.8040161,40.229187],[-3.8047028,40.2271271],[-3.8067627,40.2264404],[-3.8088226,40.2271271],[-3.8101959,40.2285004],[-3.8115692,40.2285004],[-3.8129425,40.2243805],[-3.8143158,40.2243805],[-3.8170624,40.2271271],[-3.8184357,40.2312469],[-3.8204956,40.2319336],[-3.8259888,40.2319336],[-3.8280487,40.2326202],[-3.829422,40.2339935],[-3.8314819,40.2346802],[-3.8342285,40.2346802],[-3.8362885,40.2339935],[-3.839035,40.2312469],[-3.8404083,40.2271271],[-3.8431549,40.2243805],[-3.8445282,40.2243805],[-3.8472748,40.2271271],[-3.8479614,40.229187],[-3.8479614,40.2374268],[-3.8486481,40.2394867],[-3.850708,40.2401733],[-3.8527679,40.2394867],[-3.8596344,40.2326202],[-3.8637543,40.2312469],[-3.8665009,40.2285004],[-3.8671875,40.2264404],[-3.8671875,40.2182007],[-3.8665009,40.2161407],[-3.862381,40.2147675],[-3.8610077,40.2106476],[-3.8596344,40.2092743],[-3.8589478,40.2072144],[-3.8596344,40.2051544],[-3.8616943,40.2044678],[-3.8637543,40.2051544],[-3.8651276,40.2065277],[-3.8665009,40.2065277],[-3.8678741,40.2024078],[-3.8699341,40.2017212],[-3.871994,40.2024078],[-3.8761139,40.2065277],[-3.8774872,40.2065277],[-3.8788605,40.2051544],[-3.8809204,40.2044678],[-3.8829803,40.2051544],[-3.8843536,40.2065277],[-3.8864136,40.2072144],[-3.8919067,40.2072144],[-3.8939667,40.207901],[-3.8946533,40.2099609],[-3.8946533,40.2127075],[-3.8939667,40.2147675],[-3.8898468,40.2188873],[-3.8884735,40.2230072],[-3.8871002,40.2243805],[-3.8857269,40.2285004],[-3.8843536,40.2298737],[-3.8829803,40.2339935],[-3.8802338,40.2367401],[-3.8761139,40.2381134],[-3.8754272,40.2401733],[-3.8754272,40.2429199],[-3.8761139,40.2449799],[-3.8816071,40.250473],[-3.8857269,40.2518463],[-3.8898468,40.2559662],[-3.8919067,40.2566528],[-3.9028931,40.2566528],[-3.904953,40.2559662],[-3.9063263,40.2545929],[-3.9083862,40.2539063],[-3.9303589,40.2539063],[-3.9324188,40.2545929],[-3.9337921,40.2559662],[-3.9358521,40.2566528],[-3.9468384,40.2566528],[-3.9488983,40.2573395],[-3.9502716,40.2587128],[-3.9543915,40.2600861],[-3.9547348,40.2614594],[-3.9537048,40.262146],[-3.9519882,40.262146]]]]}') geojson,1200 ra,'concesionario leganes' as name union all
SELECT ST_GEOGFROMGEOJSON('{"type":"MultiPolygon","coordinates":[[[[-3.8788605,40.337677],[-3.8768005,40.3404236],[-3.8685608,40.3486633],[-3.8658142,40.3569031],[-3.8616943,40.3582764],[-3.850708,40.3582764],[-3.8465881,40.3569031],[-3.8438416,40.3541565],[-3.8397217,40.3527832],[-3.8342285,40.3527832],[-3.8301086,40.3514099],[-3.8287354,40.34729],[-3.8287354,40.3417969],[-3.8273621,40.337677],[-3.8218689,40.3321838],[-3.8191223,40.3321838],[-3.8163757,40.3349304],[-3.8136292,40.3349304],[-3.8122559,40.3308105],[-3.8122559,40.3253174],[-3.8108826,40.3211975],[-3.8053894,40.3157043],[-3.8012695,40.3143311],[-3.7957764,40.3143311],[-3.7916565,40.3129578],[-3.7916565,40.3102112],[-3.7957764,40.3088379],[-3.817749,40.3088379],[-3.8218689,40.3074646],[-3.8218689,40.304718],[-3.8136292,40.2964783],[-3.8122559,40.2923584],[-3.8136292,40.2882385],[-3.817749,40.2868652],[-3.8218689,40.2882385],[-3.8246155,40.2909851],[-3.8328552,40.2937317],[-3.841095,40.3019714],[-3.8438416,40.3019714],[-3.8465881,40.2992249],[-3.8493347,40.2992249],[-3.8520813,40.3074646],[-3.8562012,40.3088379],[-3.8616943,40.3088379],[-3.8658142,40.3102112],[-3.8685608,40.3129578],[-3.8726807,40.3143311],[-3.8781738,40.3143311],[-3.8822937,40.3157043],[-3.883667,40.3198242],[-3.883667,40.3308105],[-3.8829803,40.3349304],[-3.8788605,40.337677]]]]}') geojson,400 as ra,'mostoles' as name union all
SELECT ST_GEOGFROMGEOJSON('{"type":"MultiPolygon","coordinates":[[[[-4.0766144,40.2278137],[-4.0745544,40.2305603],[-4.0718079,40.2333069],[-4.0690613,40.2415466],[-4.0663147,40.2442932],[-4.0635681,40.252533],[-4.058075,40.2580261],[-4.0498352,40.2607727],[-4.0415955,40.2690125],[-4.0374756,40.2703857],[-4.0209961,40.2703857],[-4.0168762,40.271759],[-4.0168762,40.2745056],[-4.025116,40.2772522],[-4.025116,40.2799988],[-4.0168762,40.2827454],[-4.0031433,40.2964783],[-3.9990234,40.2978516],[-3.9880371,40.2978516],[-3.9839172,40.2992249],[-3.9756775,40.3074646],[-3.9729309,40.3074646],[-3.9701843,40.304718],[-3.9660645,40.3033447],[-3.9605713,40.3033447],[-3.9564514,40.304718],[-3.9537048,40.3129578],[-3.9482117,40.3184509],[-3.9454651,40.3184509],[-3.9427185,40.3157043],[-3.9399719,40.3157043],[-3.9344788,40.3211975],[-3.9317322,40.3294373],[-3.9289856,40.3321838],[-3.926239,40.3404236],[-3.9234924,40.3431702],[-3.9234924,40.3459167],[-3.9276123,40.34729],[-3.9385986,40.34729],[-3.9427185,40.3486633],[-3.9454651,40.3569031],[-3.9537048,40.3651428],[-3.9564514,40.3733826],[-3.9605713,40.3747559],[-3.9660645,40.3747559],[-3.9701843,40.3761292],[-3.9729309,40.3788757],[-3.9811707,40.3816223],[-3.9839172,40.3843689],[-3.992157,40.3871155],[-3.9949036,40.3898621],[-4.0031433,40.3926086],[-4.0045166,40.3967285],[-4.0031433,40.4008484],[-3.9990234,40.4022217],[-3.9949036,40.4008484],[-3.992157,40.3981018],[-3.9839172,40.3953552],[-3.9811707,40.3926086],[-3.9770508,40.3912354],[-3.9715576,40.3912354],[-3.9674377,40.3898621],[-3.959198,40.3816223],[-3.9550781,40.380249],[-3.949585,40.380249],[-3.9454651,40.3816223],[-3.9427185,40.3843689],[-3.9344788,40.3871155],[-3.9234924,40.3981018],[-3.9234924,40.4008484],[-3.9289856,40.4063416],[-3.9372253,40.4090881],[-3.9399719,40.4118347],[-3.9427185,40.4118347],[-3.9454651,40.4090881],[-3.949585,40.4077148],[-3.9550781,40.4077148],[-3.959198,40.4063416],[-3.9619446,40.403595],[-3.9660645,40.4022217],[-3.9825439,40.4022217],[-3.9866638,40.403595],[-3.9866638,40.4063416],[-3.9811707,40.4118347],[-3.9729309,40.4145813],[-3.9701843,40.4173279],[-3.9619446,40.4200745],[-3.959198,40.422821],[-3.9509583,40.4255676],[-3.9482117,40.4283142],[-3.9454651,40.4283142],[-3.9427185,40.4255676],[-3.9385986,40.4241943],[-3.9331055,40.4241943],[-3.9289856,40.4255676],[-3.926239,40.4338074],[-3.9221191,40.4351807],[-3.916626,40.4351807],[-3.9125061,40.436554],[-3.9097595,40.4393005],[-3.9056396,40.4406738],[-3.9001465,40.4406738],[-3.8946533,40.4420471],[-3.8919067,40.4447937],[-3.89328,40.4475403],[-3.8960266,40.4502869],[-3.9001465,40.4516602],[-3.9111328,40.4516602],[-3.9152527,40.4530334],[-3.9179993,40.45578],[-3.9221191,40.4571533],[-3.926239,40.45578],[-3.9289856,40.4530334],[-3.9331055,40.4516602],[-3.9440918,40.4516602],[-3.9482117,40.4530334],[-3.949585,40.4571533],[-3.9482117,40.4612732],[-3.9440918,40.4626465],[-3.9001465,40.4626465],[-3.8960266,40.4640198],[-3.8960266,40.4667664],[-3.9015198,40.4722595],[-3.9097595,40.4750061],[-3.9125061,40.4777527],[-3.916626,40.479126],[-3.9385986,40.479126],[-3.9427185,40.4804993],[-3.9454651,40.4832458],[-3.949585,40.4846191],[-3.9550781,40.4846191],[-3.959198,40.4859924],[-3.9605713,40.4901123],[-3.959198,40.4942322],[-3.9550781,40.4956055],[-3.9440918,40.4956055],[-3.9399719,40.4942322],[-3.9372253,40.4914856],[-3.9344788,40.4914856],[-3.9317322,40.4942322],[-3.9276123,40.4956055],[-3.916626,40.4956055],[-3.9125061,40.4969788],[-3.9125061,40.4997253],[-3.9179993,40.5052185],[-3.926239,40.5079651],[-3.9317322,40.5134583],[-3.9317322,40.5162048],[-3.9276123,40.5175781],[-3.916626,40.5175781],[-3.9125061,40.5162048],[-3.9097595,40.5134583],[-3.9070129,40.5134583],[-3.9042664,40.521698],[-3.9001465,40.5230713],[-3.8946533,40.5230713],[-3.8905334,40.5244446],[-3.8905334,40.5271912],[-3.89328,40.5299377],[-3.8960266,40.5381775],[-3.8987732,40.5409241],[-3.9015198,40.5491638],[-3.9042664,40.5519104],[-3.9056396,40.5560303],[-3.9042664,40.5601501],[-3.9001465,40.5615234],[-3.8960266,40.5601501],[-3.89328,40.5519104],[-3.8905334,40.5491638],[-3.8877869,40.5409241],[-3.8850403,40.5381775],[-3.8822937,40.5299377],[-3.8795471,40.5271912],[-3.8781738,40.5230713],[-3.8781738,40.5175781],[-3.8768005,40.5134583],[-3.874054,40.5107117],[-3.8726807,40.5065918],[-3.8726807,40.5010986],[-3.8713074,40.4969788],[-3.8630676,40.4942322],[-3.8548279,40.4859924],[-3.8465881,40.4832458],[-3.8452148,40.479126],[-3.8465881,40.4750061],[-3.850708,40.4736328],[-3.8548279,40.4750061],[-3.8575745,40.4777527],[-3.8616943,40.479126],[-3.8658142,40.4777527],[-3.8671875,40.4736328],[-3.8658142,40.4695129],[-3.8575745,40.4667664],[-3.8520813,40.4612732],[-3.850708,40.4571533],[-3.850708,40.4516602],[-3.8493347,40.4475403],[-3.8438416,40.4420471],[-3.8397217,40.4406738],[-3.8356018,40.4420471],[-3.8163757,40.4612732],[-3.8122559,40.4626465],[-3.808136,40.4612732],[-3.808136,40.4585266],[-3.8108826,40.45578],[-3.8136292,40.4475403],[-3.8218689,40.4447937],[-3.8273621,40.4393005],[-3.8273621,40.436554],[-3.8191223,40.4338074],[-3.817749,40.4296875],[-3.8191223,40.4255676],[-3.8218689,40.422821],[-3.8218689,40.4200745],[-3.8136292,40.4173279],[-3.8108826,40.4145813],[-3.8026428,40.4118347],[-3.7998962,40.403595],[-3.7971497,40.403595],[-3.7889099,40.4118347],[-3.78479,40.413208],[-3.7806702,40.4118347],[-3.7724304,40.403595],[-3.7696838,40.403595],[-3.7669373,40.4118347],[-3.7628174,40.413208],[-3.7518311,40.413208],[-3.7477112,40.4145813],[-3.7449646,40.4173279],[-3.7367249,40.4200745],[-3.7339783,40.4283142],[-3.7298584,40.4296875],[-3.7257385,40.4283142],[-3.7229919,40.4255676],[-3.7147522,40.422821],[-3.7147522,40.4200745],[-3.7174988,40.4173279],[-3.7202454,40.4090881],[-3.7284851,40.4063416],[-3.7312317,40.403595],[-3.7394714,40.4008484],[-3.7449646,40.3953552],[-3.7463379,40.3912354],[-3.7463379,40.3857422],[-3.7449646,40.3816223],[-3.7408447,40.380249],[-3.7353516,40.380249],[-3.7312317,40.3816223],[-3.7284851,40.3898621],[-3.7243652,40.3912354],[-3.7188721,40.3912354],[-3.7147522,40.3926086],[-3.7120056,40.3953552],[-3.7078857,40.3967285],[-3.7037659,40.3953552],[-3.7023926,40.3912354],[-3.7037659,40.3871155],[-3.7120056,40.3788757],[-3.7133789,40.3747559],[-3.7120056,40.370636],[-3.7078857,40.3692627],[-3.7023926,40.3692627],[-3.6982727,40.370636],[-3.6955261,40.3788757],[-3.6927795,40.3788757],[-3.690033,40.3761292],[-3.6872864,40.3761292],[-3.6845398,40.3788757],[-3.6817932,40.3788757],[-3.6763,40.3733826],[-3.6735535,40.3651428],[-3.6708069,40.3651428],[-3.657074,40.3788757],[-3.6529541,40.380249],[-3.6488342,40.3788757],[-3.6474609,40.3747559],[-3.6488342,40.370636],[-3.6598206,40.3596497],[-3.6680603,40.3569031],[-3.6694336,40.3527832],[-3.6694336,40.34729],[-3.6680603,40.3431702],[-3.6653137,40.3431702],[-3.6625671,40.3459167],[-3.6543274,40.3486633],[-3.6515808,40.3514099],[-3.6488342,40.3514099],[-3.6474609,40.34729],[-3.6488342,40.3431702],[-3.6625671,40.3294373],[-3.6639404,40.3253174],[-3.6639404,40.3198242],[-3.6625671,40.3157043],[-3.6584473,40.3143311],[-3.6543274,40.3157043],[-3.6488342,40.3211975],[-3.6460876,40.3294373],[-3.6378479,40.337677],[-3.6351013,40.3459167],[-3.6309814,40.34729],[-3.6268616,40.3459167],[-3.624115,40.3431702],[-3.6199951,40.3417969],[-3.6090088,40.3417969],[-3.6048889,40.3431702],[-3.6021423,40.3459167],[-3.5980225,40.34729],[-3.5925293,40.34729],[-3.5884094,40.3459167],[-3.5884094,40.3431702],[-3.5939026,40.337677],[-3.5980225,40.3363037],[-3.6090088,40.3363037],[-3.6131287,40.3349304],[-3.6158752,40.3321838],[-3.624115,40.3294373],[-3.6268616,40.3266907],[-3.6351013,40.3239441],[-3.6405945,40.3184509],[-3.6433411,40.3102112],[-3.6460876,40.3074646],[-3.6460876,40.304718],[-3.6405945,40.2992249],[-3.6364746,40.2978516],[-3.6323547,40.2992249],[-3.6296082,40.3074646],[-3.6254883,40.3088379],[-3.6213684,40.3074646],[-3.6158752,40.3019714],[-3.6131287,40.2937317],[-3.6103821,40.2909851],[-3.6090088,40.2868652],[-3.6103821,40.2827454],[-3.614502,40.2813721],[-3.6186218,40.2827454],[-3.6213684,40.2909851],[-3.624115,40.2909851],[-3.6268616,40.2882385],[-3.6309814,40.2868652],[-3.6351013,40.2882385],[-3.6378479,40.2909851],[-3.6419678,40.2923584],[-3.6474609,40.2923584],[-3.6515808,40.2937317],[-3.6543274,40.2964783],[-3.6584473,40.2978516],[-3.6625671,40.2964783],[-3.6680603,40.2909851],[-3.6708069,40.2827454],[-3.6790466,40.2799988],[-3.6845398,40.2745056],[-3.6859131,40.2703857],[-3.6859131,40.2593994],[-3.6845398,40.2552795],[-3.6763,40.252533],[-3.6735535,40.2442932],[-3.6653137,40.2415466],[-3.6625671,40.2388],[-3.6543274,40.2360535],[-3.6529541,40.2319336],[-3.6543274,40.2278137],[-3.6584473,40.2250671],[-3.6625671,40.2209473],[-3.6653137,40.2168274],[-3.6694336,40.2154541],[-3.6749268,40.2154541],[-3.6790466,40.2140808],[-3.6817932,40.2113342],[-3.6845398,40.2113342],[-3.690033,40.2168274],[-3.6927795,40.2250671],[-3.6968994,40.2264404],[-3.7078857,40.2264404],[-3.7120056,40.2278137],[-3.7147522,40.2360535],[-3.7188721,40.2374268],[-3.7243652,40.2374268],[-3.7284851,40.2360535],[-3.7394714,40.2250671],[-3.7408447,40.2209473],[-3.7408447,40.2044678],[-3.7394714,40.2003479],[-3.7257385,40.186615],[-3.7257385,40.1838684],[-3.7298584,40.1824951],[-3.7353516,40.1824951],[-3.7394714,40.1838684],[-3.7504578,40.1948547],[-3.7518311,40.1989746],[-3.7518311,40.2209473],[-3.7504578,40.2250671],[-3.7477112,40.2278137],[-3.7477112,40.2305603],[-3.7518311,40.2319336],[-3.7628174,40.2319336],[-3.7669373,40.2305603],[-3.7696838,40.2223206],[-3.7779236,40.219574],[-3.7792969,40.2154541],[-3.7792969,40.2044678],[-3.7779236,40.2003479],[-3.7724304,40.1948547],[-3.7641907,40.1921082],[-3.7628174,40.1879883],[-3.7641907,40.1838684],[-3.7683105,40.1824951],[-3.7724304,40.1838684],[-3.775177,40.186615],[-3.7779236,40.186615],[-3.7806702,40.1838684],[-3.7834167,40.1838684],[-3.7861633,40.186615],[-3.7902832,40.1879883],[-3.7944031,40.186615],[-3.8053894,40.1756287],[-3.808136,40.1673889],[-3.8136292,40.1618958],[-3.817749,40.1605225],[-3.8218689,40.1618958],[-3.8232422,40.1660156],[-3.8218689,40.1701355],[-3.8191223,40.1728821],[-3.8163757,40.1811218],[-3.8136292,40.1838684],[-3.8122559,40.1879883],[-3.8122559,40.1934814],[-3.8136292,40.1976013],[-3.8163757,40.1976013],[-3.8191223,40.1948547],[-3.8273621,40.1921082],[-3.8301086,40.1893616],[-3.8342285,40.1879883],[-3.850708,40.1879883],[-3.8548279,40.186615],[-3.8630676,40.1783752],[-3.8671875,40.177002],[-3.8726807,40.177002],[-3.8768005,40.1756287],[-3.8822937,40.1701355],[-3.8850403,40.1618958],[-3.89328,40.1591492],[-3.8946533,40.1550293],[-3.89328,40.1509094],[-3.8905334,40.1481628],[-3.8891602,40.144043],[-3.8891602,40.1220703],[-3.8905334,40.1179504],[-3.8946533,40.1165771],[-3.8987732,40.1179504],[-3.9001465,40.1220703],[-3.8987732,40.1261902],[-3.8960266,40.1289368],[-3.8946533,40.1330566],[-3.8960266,40.1371765],[-3.8987732,40.1399231],[-3.9015198,40.1481628],[-3.9097595,40.1509094],[-3.9125061,40.153656],[-3.9207458,40.1564026],[-3.926239,40.1618958],[-3.9276123,40.1660156],[-3.9276123,40.177002],[-3.926239,40.1811218],[-3.9207458,40.186615],[-3.9125061,40.1893616],[-3.9015198,40.2003479],[-3.9015198,40.2030945],[-3.9097595,40.2058411],[-3.9125061,40.2085876],[-3.9152527,40.2085876],[-3.9179993,40.2058411],[-3.9221191,40.2044678],[-3.926239,40.2058411],[-3.9289856,40.2085876],[-3.9372253,40.2113342],[-3.9399719,40.2140808],[-3.9482117,40.2168274],[-3.9482117,40.219574],[-3.9440918,40.2209473],[-3.9221191,40.2209473],[-3.9179993,40.219574],[-3.9152527,40.2168274],[-3.9125061,40.2168274],[-3.9097595,40.219574],[-3.9056396,40.2209473],[-3.9015198,40.219574],[-3.8987732,40.2168274],[-3.8960266,40.2168274],[-3.89328,40.2250671],[-3.8795471,40.2388],[-3.8781738,40.2429199],[-3.8795471,40.2470398],[-3.883667,40.2484131],[-3.8891602,40.2484131],[-3.89328,40.2470398],[-3.8960266,40.2442932],[-3.9001465,40.2429199],[-3.9111328,40.2429199],[-3.9152527,40.2442932],[-3.9234924,40.252533],[-3.9276123,40.2539063],[-3.9550781,40.2539063],[-3.959198,40.2552795],[-3.9619446,40.2580261],[-3.9660645,40.2593994],[-3.9701843,40.2580261],[-3.9729309,40.2552795],[-3.9770508,40.2539063],[-3.9825439,40.2539063],[-3.9866638,40.252533],[-3.992157,40.2470398],[-3.992157,40.2442932],[-3.9894104,40.2415466],[-3.9880371,40.2374268],[-3.9894104,40.2333069],[-3.9935303,40.2319336],[-3.9976501,40.2333069],[-4.0003967,40.2415466],[-4.0031433,40.2442932],[-4.0058899,40.252533],[-4.0113831,40.2580261],[-4.0155029,40.2593994],[-4.0264893,40.2593994],[-4.0306091,40.2607727],[-4.0333557,40.2635193],[-4.0361023,40.2635193],[-4.0525818,40.2470398],[-4.0553284,40.2388],[-4.0690613,40.2250671],[-4.0718079,40.2168274],[-4.0759277,40.2154541],[-4.0800476,40.2168274],[-4.0814209,40.2209473],[-4.0807343,40.2250671],[-4.0766144,40.2278137]]]]}') geojson,1200 ra,'mostoles' as name union all
SELECT ST_GEOGFROMGEOJSON('{"type":"MultiPolygon","coordinates":[[[[-3.873024,40.3424835],[-3.871994,40.3438568],[-3.8699341,40.3445435],[-3.8671875,40.3445435],[-3.8651276,40.3452301],[-3.8644409,40.34729],[-3.8644409,40.3500366],[-3.8651276,40.3520966],[-3.8692474,40.3534698],[-3.8692474,40.3548431],[-3.8651276,40.358963],[-3.8651276,40.3603363],[-3.8665009,40.3617096],[-3.8678741,40.3658295],[-3.8692474,40.3672028],[-3.8699341,40.3692627],[-3.8692474,40.3713226],[-3.8671875,40.3720093],[-3.8651276,40.3713226],[-3.8637543,40.3672028],[-3.8582611,40.3617096],[-3.8568878,40.3617096],[-3.8555145,40.3630829],[-3.8534546,40.3637695],[-3.850708,40.3637695],[-3.8486481,40.3644562],[-3.8472748,40.368576],[-3.8459015,40.368576],[-3.8445282,40.3672028],[-3.8431549,40.3672028],[-3.8417816,40.368576],[-3.8397217,40.3692627],[-3.8342285,40.3692627],[-3.8321686,40.3699493],[-3.8280487,40.3740692],[-3.8259888,40.3747559],[-3.8232422,40.3747559],[-3.8211823,40.3740692],[-3.8211823,40.3726959],[-3.8253021,40.368576],[-3.8259888,40.3665161],[-3.8259888,40.3637695],[-3.8253021,40.3617096],[-3.8232422,40.3610229],[-3.8204956,40.3610229],[-3.8184357,40.3617096],[-3.8143158,40.3658295],[-3.8101959,40.3672028],[-3.8074493,40.3699493],[-3.8074493,40.3713226],[-3.8115692,40.3754425],[-3.8129425,40.3795624],[-3.8150024,40.380249],[-3.8204956,40.380249],[-3.8225555,40.3809357],[-3.8239288,40.382309],[-3.8280487,40.3836823],[-3.8335419,40.3891754],[-3.8349152,40.3932953],[-3.8362885,40.3946686],[-3.8369751,40.3967285],[-3.8362885,40.3987885],[-3.8349152,40.4001617],[-3.8335419,40.4042816],[-3.8307953,40.4070282],[-3.829422,40.4070282],[-3.8266754,40.4042816],[-3.8266754,40.4029083],[-3.8280487,40.401535],[-3.8280487,40.4001617],[-3.8259888,40.3994751],[-3.8232422,40.3994751],[-3.8211823,40.3987885],[-3.8211823,40.3974152],[-3.8253021,40.3932953],[-3.8259888,40.3912354],[-3.8253021,40.3891754],[-3.8225555,40.3864288],[-3.8204956,40.3857422],[-3.8122559,40.3857422],[-3.8101959,40.3850555],[-3.8005829,40.3754425],[-3.7992096,40.3754425],[-3.7985229,40.3775024],[-3.7985229,40.380249],[-3.7978363,40.382309],[-3.7937164,40.3836823],[-3.7923431,40.3850555],[-3.7902832,40.3857422],[-3.7875366,40.3857422],[-3.7854767,40.3864288],[-3.7786102,40.3932953],[-3.7744904,40.3946686],[-3.7717438,40.3974152],[-3.7703705,40.401535],[-3.7683105,40.4022217],[-3.765564,40.4022217],[-3.763504,40.4029083],[-3.7621307,40.4042816],[-3.7600708,40.4049683],[-3.7545776,40.4049683],[-3.7525177,40.4042816],[-3.7525177,40.4029083],[-3.7552643,40.4001617],[-3.7593842,40.3987885],[-3.7600708,40.3967285],[-3.7600708,40.3939819],[-3.7607574,40.391922],[-3.7648773,40.3905487],[-3.7676239,40.3878021],[-3.7689972,40.3836823],[-3.7710571,40.3829956],[-3.7738037,40.3829956],[-3.7758636,40.382309],[-3.7758636,40.3809357],[-3.7731171,40.3781891],[-3.7689972,40.3768158],[-3.7676239,40.3754425],[-3.763504,40.3740692],[-3.7628174,40.3720093],[-3.7628174,40.3692627],[-3.7621307,40.3672028],[-3.7600708,40.3658295],[-3.7580109,40.3651428],[-3.7573242,40.3665161],[-3.7566376,40.368576],[-3.7545776,40.3692627],[-3.7525177,40.368576],[-3.7511444,40.3672028],[-3.7490845,40.3665161],[-3.7463379,40.3665161],[-3.744278,40.3658295],[-3.7429047,40.3644562],[-3.7408447,40.3637695],[-3.7380981,40.3637695],[-3.7360382,40.3644562],[-3.7346649,40.3658295],[-3.732605,40.3665161],[-3.7133789,40.3665161],[-3.711319,40.3658295],[-3.7106323,40.3637695],[-3.711319,40.3617096],[-3.7133789,40.3610229],[-3.7161255,40.3610229],[-3.7181854,40.3603363],[-3.7195587,40.358963],[-3.7216187,40.3582764],[-3.7236786,40.358963],[-3.7250519,40.3603363],[-3.7271118,40.3610229],[-3.732605,40.3610229],[-3.7346649,40.3603363],[-3.7360382,40.358963],[-3.7380981,40.3582764],[-3.7408447,40.3582764],[-3.7429047,40.3575897],[-3.7456512,40.3548431],[-3.7456512,40.3534698],[-3.744278,40.3520966],[-3.744278,40.3507233],[-3.7456512,40.34935],[-3.7470245,40.3452301],[-3.7490845,40.3445435],[-3.7518311,40.3445435],[-3.753891,40.3438568],[-3.7552643,40.3424835],[-3.7593842,40.3411102],[-3.7600708,40.3390503],[-3.7593842,40.3369904],[-3.7580109,40.3356171],[-3.7573242,40.3335571],[-3.7580109,40.3314972],[-3.7648773,40.3246307],[-3.7648773,40.3232574],[-3.7628174,40.3225708],[-3.7607574,40.3232574],[-3.7593842,40.3246307],[-3.7573242,40.3253174],[-3.7552643,40.3246307],[-3.753891,40.3232574],[-3.7518311,40.3225708],[-3.7490845,40.3225708],[-3.7470245,40.3218842],[-3.7463379,40.3198242],[-3.7463379,40.3115845],[-3.7470245,40.3095245],[-3.7490845,40.3088379],[-3.7518311,40.3088379],[-3.753891,40.3081512],[-3.7552643,40.3040314],[-3.7580109,40.3012848],[-3.7600708,40.2999115],[-3.7614441,40.2985382],[-3.7607574,40.2971649],[-3.7593842,40.293045],[-3.7580109,40.2916718],[-3.7566376,40.2875519],[-3.753891,40.2848053],[-3.7497711,40.283432],[-3.7483978,40.2820587],[-3.7463379,40.2813721],[-3.7353516,40.2813721],[-3.7332916,40.2806854],[-3.7319183,40.2793121],[-3.7298584,40.2786255],[-3.7271118,40.2786255],[-3.7250519,40.2779388],[-3.7243652,40.2758789],[-3.7250519,40.273819],[-3.7271118,40.2731323],[-3.7291718,40.273819],[-3.730545,40.2751923],[-3.732605,40.2758789],[-3.7463379,40.2758789],[-3.7483978,40.2751923],[-3.7497711,40.2710724],[-3.7518311,40.2703857],[-3.753891,40.2710724],[-3.7545776,40.2731323],[-3.7545776,40.2758789],[-3.7552643,40.2779388],[-3.7621307,40.2848053],[-3.763504,40.2889252],[-3.7744904,40.2999115],[-3.7758636,40.2999115],[-3.7786102,40.2971649],[-3.7792969,40.295105],[-3.7792969,40.2868652],[-3.7799835,40.2848053],[-3.7820435,40.2841187],[-3.7875366,40.2841187],[-3.7895966,40.283432],[-3.7909698,40.2820587],[-3.7930298,40.2813721],[-3.7957764,40.2813721],[-3.7978363,40.2820587],[-3.8019562,40.2861786],[-3.8040161,40.2868652],[-3.8067627,40.2868652],[-3.8088226,40.2875519],[-3.8095093,40.2896118],[-3.8088226,40.2916718],[-3.8074493,40.293045],[-3.806076,40.2971649],[-3.8040161,40.2978516],[-3.8019562,40.2971649],[-3.8005829,40.2957916],[-3.7992096,40.2957916],[-3.7978363,40.2971649],[-3.7937164,40.2985382],[-3.7923431,40.3026581],[-3.7909698,40.3040314],[-3.7909698,40.3054047],[-3.7950897,40.306778],[-3.796463,40.3081512],[-3.7985229,40.3088379],[-3.8005829,40.3081512],[-3.8019562,40.306778],[-3.8040161,40.3060913],[-3.8067627,40.3060913],[-3.8088226,40.3054047],[-3.8101959,40.3040314],[-3.8122559,40.3033447],[-3.8143158,40.3040314],[-3.8150024,40.3060913],[-3.8143158,40.3081512],[-3.8129425,40.3095245],[-3.8129425,40.3108978],[-3.8170624,40.3122711],[-3.8184357,40.3136444],[-3.819809,40.3136444],[-3.8239288,40.3095245],[-3.8280487,40.3081512],[-3.8280487,40.306778],[-3.8129425,40.2916718],[-3.8122559,40.2896118],[-3.8129425,40.2875519],[-3.8150024,40.2868652],[-3.8170624,40.2875519],[-3.8239288,40.2944183],[-3.8253021,40.2944183],[-3.8266754,40.2902985],[-3.8287354,40.2896118],[-3.8307953,40.2902985],[-3.8314819,40.2923584],[-3.8314819,40.295105],[-3.8321686,40.2971649],[-3.8349152,40.2999115],[-3.839035,40.3012848],[-3.8404083,40.3026581],[-3.8424683,40.3033447],[-3.8445282,40.3026581],[-3.8459015,40.3012848],[-3.8479614,40.3005981],[-3.8500214,40.3012848],[-3.850708,40.3033447],[-3.8500214,40.3054047],[-3.8486481,40.306778],[-3.8479614,40.3088379],[-3.8486481,40.3108978],[-3.8527679,40.3122711],[-3.8541412,40.316391],[-3.8568878,40.3191376],[-3.8610077,40.3205109],[-3.8637543,40.3232574],[-3.8637543,40.3246307],[-3.862381,40.326004],[-3.8616943,40.328064],[-3.8616943,40.3308105],[-3.8610077,40.3328705],[-3.8596344,40.3342438],[-3.8589478,40.3363037],[-3.8589478,40.3390503],[-3.8596344,40.3411102],[-3.8616943,40.3417969],[-3.8637543,40.3411102],[-3.8651276,40.3397369],[-3.8671875,40.3390503],[-3.8726807,40.3390503],[-3.8747406,40.3397369],[-3.8750839,40.3411102],[-3.873024,40.3424835]]]]}') geojson,800 ra,'concesionario alcorcon' as name union all
SELECT ST_GEOGFROMGEOJSON('{"type":"MultiPolygon","coordinates":[[[[-3.873024,40.3424835],[-3.871994,40.3438568],[-3.8699341,40.3445435],[-3.8671875,40.3445435],[-3.8651276,40.3452301],[-3.862381,40.3479767],[-3.8610077,40.3520966],[-3.8596344,40.3520966],[-3.8582611,40.3507233],[-3.8568878,40.3507233],[-3.8555145,40.3520966],[-3.8513947,40.3534698],[-3.8500214,40.3548431],[-3.8479614,40.3555298],[-3.8424683,40.3555298],[-3.8404083,40.3562164],[-3.839035,40.3575897],[-3.8369751,40.3582764],[-3.8232422,40.3582764],[-3.8211823,40.358963],[-3.8143158,40.3658295],[-3.8101959,40.3672028],[-3.8074493,40.3699493],[-3.8074493,40.3713226],[-3.8115692,40.3754425],[-3.8129425,40.3795624],[-3.8150024,40.380249],[-3.8204956,40.380249],[-3.8225555,40.3809357],[-3.8239288,40.382309],[-3.8280487,40.3836823],[-3.8335419,40.3891754],[-3.8349152,40.3932953],[-3.8369751,40.3939819],[-3.8424683,40.3939819],[-3.8445282,40.3946686],[-3.8452148,40.3967285],[-3.8445282,40.3987885],[-3.8424683,40.3994751],[-3.8369751,40.3994751],[-3.8349152,40.4001617],[-3.8335419,40.4042816],[-3.8225555,40.4152679],[-3.8204956,40.4159546],[-3.8184357,40.4152679],[-3.817749,40.413208],[-3.817749,40.4104614],[-3.8184357,40.4084015],[-3.8225555,40.4070282],[-3.8253021,40.4042816],[-3.8259888,40.4022217],[-3.8253021,40.4001617],[-3.8232422,40.3994751],[-3.8204956,40.3994751],[-3.8184357,40.4001617],[-3.8170624,40.401535],[-3.8150024,40.4022217],[-3.8129425,40.401535],[-3.8122559,40.3994751],[-3.8129425,40.3974152],[-3.8150024,40.3967285],[-3.8204956,40.3967285],[-3.8225555,40.3960419],[-3.8253021,40.3932953],[-3.8259888,40.3912354],[-3.8253021,40.3891754],[-3.8225555,40.3864288],[-3.8204956,40.3857422],[-3.8122559,40.3857422],[-3.8101959,40.3850555],[-3.8005829,40.3754425],[-3.7992096,40.3754425],[-3.7895966,40.3850555],[-3.7854767,40.3864288],[-3.7841034,40.3878021],[-3.7820435,40.3884888],[-3.7799835,40.3878021],[-3.7792969,40.3857422],[-3.7799835,40.3836823],[-3.7827301,40.3809357],[-3.78685,40.3795624],[-3.7895966,40.3768158],[-3.7902832,40.3747559],[-3.7902832,40.3720093],[-3.7895966,40.3699493],[-3.7875366,40.3692627],[-3.7792969,40.3692627],[-3.7772369,40.3699493],[-3.7772369,40.3713226],[-3.7813568,40.3726959],[-3.7841034,40.3754425],[-3.7841034,40.3768158],[-3.7820435,40.3775024],[-3.7792969,40.3775024],[-3.7772369,40.3781891],[-3.7731171,40.382309],[-3.7710571,40.3829956],[-3.765564,40.3829956],[-3.763504,40.382309],[-3.7593842,40.3781891],[-3.7573242,40.3775024],[-3.7518311,40.3775024],[-3.7497711,40.3768158],[-3.7483978,40.3754425],[-3.7470245,40.3754425],[-3.7401581,40.382309],[-3.7387848,40.382309],[-3.7374115,40.3809357],[-3.7353516,40.380249],[-3.7332916,40.3809357],[-3.7319183,40.382309],[-3.7298584,40.3829956],[-3.7271118,40.3829956],[-3.7250519,40.3836823],[-3.7236786,40.3850555],[-3.7216187,40.3857422],[-3.7188721,40.3857422],[-3.7168121,40.3850555],[-3.7161255,40.3829956],[-3.7161255,40.380249],[-3.7154388,40.3781891],[-3.711319,40.3740692],[-3.711319,40.3726959],[-3.7154388,40.3713226],[-3.7161255,40.3692627],[-3.7154388,40.3672028],[-3.7133789,40.3665161],[-3.699646,40.3665161],[-3.6975861,40.3672028],[-3.6968994,40.3692627],[-3.6968994,40.3747559],[-3.6962128,40.3768158],[-3.6941528,40.3775024],[-3.6920929,40.3768158],[-3.6914063,40.3747559],[-3.6914063,40.3720093],[-3.6907196,40.3699493],[-3.6865997,40.368576],[-3.6824799,40.3644562],[-3.6811066,40.3644562],[-3.6804199,40.3665161],[-3.6811066,40.368576],[-3.6824799,40.3699493],[-3.6831665,40.3720093],[-3.6824799,40.3740692],[-3.6804199,40.3747559],[-3.67836,40.3740692],[-3.6756134,40.3713226],[-3.6749268,40.3692627],[-3.6749268,40.3665161],[-3.6742401,40.3644562],[-3.6721802,40.3637695],[-3.6701202,40.3644562],[-3.6687469,40.3658295],[-3.6646271,40.3672028],[-3.6632538,40.368576],[-3.6591339,40.3699493],[-3.6577606,40.3713226],[-3.6557007,40.3720093],[-3.6536407,40.3713226],[-3.6529541,40.3692627],[-3.6536407,40.3672028],[-3.6577606,40.3658295],[-3.6618805,40.3617096],[-3.6660004,40.3603363],[-3.6673737,40.358963],[-3.6694336,40.3582764],[-3.6749268,40.3582764],[-3.6769867,40.3575897],[-3.6769867,40.3562164],[-3.6701202,40.34935],[-3.6694336,40.34729],[-3.6701202,40.3452301],[-3.6721802,40.3445435],[-3.6742401,40.3452301],[-3.6838531,40.3548431],[-3.6859131,40.3555298],[-3.6886597,40.3555298],[-3.6907196,40.3548431],[-3.6914063,40.3527832],[-3.6914063,40.3500366],[-3.6920929,40.3479767],[-3.6941528,40.34729],[-3.6962128,40.3479767],[-3.6968994,40.3500366],[-3.6968994,40.3527832],[-3.6975861,40.3548431],[-3.6989594,40.3562164],[-3.7003326,40.3603363],[-3.7023926,40.3610229],[-3.7161255,40.3610229],[-3.7181854,40.3603363],[-3.7188721,40.3582764],[-3.7188721,40.3500366],[-3.7195587,40.3479767],[-3.7236786,40.3466034],[-3.7243652,40.3445435],[-3.7243652,40.3390503],[-3.7236786,40.3369904],[-3.7216187,40.3363037],[-3.7195587,40.3369904],[-3.7181854,40.3383636],[-3.7161255,40.3390503],[-3.7133789,40.3390503],[-3.711319,40.3397369],[-3.7099457,40.3411102],[-3.7085724,40.3411102],[-3.7058258,40.3383636],[-3.7051392,40.3363037],[-3.7051392,40.3335571],[-3.7058258,40.3314972],[-3.7099457,40.3301239],[-3.7099457,40.3287506],[-3.7078857,40.328064],[-3.7023926,40.328064],[-3.7003326,40.3273773],[-3.699646,40.3253174],[-3.7003326,40.3232574],[-3.7023926,40.3225708],[-3.7078857,40.3225708],[-3.7099457,40.3218842],[-3.711319,40.3205109],[-3.7133789,40.3198242],[-3.7216187,40.3198242],[-3.7236786,40.3191376],[-3.7250519,40.3177643],[-3.7264252,40.3177643],[-3.7271118,40.3198242],[-3.7271118,40.3253174],[-3.7277985,40.3273773],[-3.7319183,40.3314972],[-3.7332916,40.3356171],[-3.7346649,40.3356171],[-3.744278,40.326004],[-3.7483978,40.3246307],[-3.7483978,40.3232574],[-3.7456512,40.3205109],[-3.7415314,40.3191376],[-3.7408447,40.3170776],[-3.7415314,40.3150177],[-3.7435913,40.3143311],[-3.7463379,40.3143311],[-3.7483978,40.3150177],[-3.7497711,40.316391],[-3.7511444,40.316391],[-3.7525177,40.3150177],[-3.7566376,40.3136444],[-3.7580109,40.3095245],[-3.7607574,40.306778],[-3.7628174,40.3060913],[-3.7710571,40.3060913],[-3.7731171,40.3054047],[-3.7731171,40.3040314],[-3.7689972,40.3026581],[-3.7580109,40.2916718],[-3.7573242,40.2896118],[-3.7580109,40.2875519],[-3.7600708,40.2868652],[-3.7621307,40.2875519],[-3.7744904,40.2999115],[-3.7786102,40.3012848],[-3.7799835,40.3026581],[-3.7813568,40.3026581],[-3.7820435,40.3005981],[-3.7820435,40.295105],[-3.7827301,40.293045],[-3.7882233,40.2875519],[-3.7902832,40.2868652],[-3.7923431,40.2875519],[-3.7978363,40.293045],[-3.7985229,40.295105],[-3.7978363,40.2971649],[-3.7937164,40.2985382],[-3.7909698,40.3012848],[-3.7902832,40.3033447],[-3.7909698,40.3054047],[-3.7950897,40.306778],[-3.796463,40.3081512],[-3.7985229,40.3088379],[-3.8005829,40.3081512],[-3.8012695,40.3060913],[-3.8012695,40.3033447],[-3.8019562,40.3012848],[-3.8047028,40.2985382],[-3.8067627,40.2978516],[-3.8095093,40.2978516],[-3.8115692,40.2985382],[-3.8129425,40.2999115],[-3.8143158,40.2999115],[-3.8170624,40.2971649],[-3.8170624,40.2957916],[-3.8156891,40.2944183],[-3.8150024,40.2923584],[-3.8156891,40.2902985],[-3.817749,40.2896118],[-3.819809,40.2902985],[-3.8211823,40.2909851],[-3.8225555,40.2896118],[-3.8239288,40.2875519],[-3.8280487,40.2861786],[-3.829422,40.2820587],[-3.8349152,40.2765656],[-3.8369751,40.2758789],[-3.8397217,40.2758789],[-3.8417816,40.2765656],[-3.8424683,40.2786255],[-3.8417816,40.2806854],[-3.8376617,40.2820587],[-3.8349152,40.2848053],[-3.8342285,40.2868652],[-3.8349152,40.2889252],[-3.8362885,40.2902985],[-3.8369751,40.2923584],[-3.8362885,40.2944183],[-3.8349152,40.2957916],[-3.8342285,40.2978516],[-3.8349152,40.2999115],[-3.8376617,40.3026581],[-3.8397217,40.3033447],[-3.8424683,40.3033447],[-3.8445282,40.3026581],[-3.8459015,40.3012848],[-3.8479614,40.3005981],[-3.8500214,40.3012848],[-3.850708,40.3033447],[-3.8500214,40.3054047],[-3.8472748,40.3081512],[-3.8452148,40.3088379],[-3.8424683,40.3088379],[-3.8404083,40.3095245],[-3.8404083,40.3108978],[-3.8417816,40.3122711],[-3.8424683,40.3143311],[-3.8417816,40.316391],[-3.8397217,40.3170776],[-3.8376617,40.316391],[-3.8335419,40.3122711],[-3.8321686,40.3122711],[-3.8307953,40.3136444],[-3.8266754,40.3150177],[-3.8266754,40.316391],[-3.829422,40.3191376],[-3.8314819,40.3198242],[-3.8369751,40.3198242],[-3.839035,40.3205109],[-3.8404083,40.3218842],[-3.8424683,40.3225708],[-3.8452148,40.3225708],[-3.8472748,40.3232574],[-3.8486481,40.3273773],[-3.8500214,40.3287506],[-3.8513947,40.3328705],[-3.8596344,40.3411102],[-3.8616943,40.3417969],[-3.8637543,40.3411102],[-3.8651276,40.3397369],[-3.8671875,40.3390503],[-3.8726807,40.3390503],[-3.8747406,40.3397369],[-3.8750839,40.3411102],[-3.873024,40.3424835]]]]}') geojson,800 ra,'concesionario leganes' as name union all
SELECT ST_GEOGFROMGEOJSON('{"type":"MultiPolygon","coordinates":[[[[-3.960228,40.262146],[-3.9358521,40.262146],[-3.9337921,40.2614594],[-3.9324188,40.2600861],[-3.9303589,40.2593994],[-3.9276123,40.2593994],[-3.9255524,40.2587128],[-3.9241791,40.2573395],[-3.9221191,40.2566528],[-3.9193726,40.2566528],[-3.9173126,40.2573395],[-3.9104462,40.2642059],[-3.9083862,40.2648926],[-3.9056396,40.2648926],[-3.9035797,40.2655792],[-3.8967133,40.2724457],[-3.8925934,40.273819],[-3.8912201,40.2751923],[-3.8871002,40.2765656],[-3.8857269,40.2779388],[-3.883667,40.2786255],[-3.8781738,40.2786255],[-3.8761139,40.2793121],[-3.8747406,40.2806854],[-3.8706207,40.2820587],[-3.8665009,40.2861786],[-3.862381,40.2875519],[-3.8610077,40.2916718],[-3.860321,40.293045],[-3.8616943,40.2944183],[-3.8644409,40.295105],[-3.8665009,40.2957916],[-3.8678741,40.2999115],[-3.8692474,40.2999115],[-3.8706207,40.2985382],[-3.8726807,40.2978516],[-3.8747406,40.2985382],[-3.8761139,40.3026581],[-3.8802338,40.3040314],[-3.8829803,40.306778],[-3.8843536,40.3108978],[-3.8857269,40.3122711],[-3.8864136,40.3143311],[-3.8857269,40.316391],[-3.8843536,40.3177643],[-3.8843536,40.3191376],[-3.8871002,40.3218842],[-3.8891602,40.3225708],[-3.8912201,40.3218842],[-3.8925934,40.3177643],[-3.8967133,40.3136444],[-3.8973999,40.3115845],[-3.8973999,40.3060913],[-3.8980865,40.3040314],[-3.9022064,40.3026581],[-3.9035797,40.2985382],[-3.9056396,40.2978516],[-3.9083862,40.2978516],[-3.9104462,40.2985382],[-3.9118195,40.2999115],[-3.9138794,40.3005981],[-3.916626,40.3005981],[-3.9186859,40.2999115],[-3.9200592,40.2985382],[-3.9221191,40.2978516],[-3.9241791,40.2985382],[-3.9255524,40.2999115],[-3.9269257,40.2999115],[-3.928299,40.2985382],[-3.9303589,40.2978516],[-3.9331055,40.2978516],[-3.9351654,40.2971649],[-3.9365387,40.2957916],[-3.9385986,40.295105],[-3.949585,40.295105],[-3.9516449,40.2957916],[-3.9523315,40.2978516],[-3.9516449,40.2999115],[-3.949585,40.3005981],[-3.9440918,40.3005981],[-3.9420319,40.3012848],[-3.9406586,40.3026581],[-3.9385986,40.3033447],[-3.9331055,40.3033447],[-3.9310455,40.3040314],[-3.9269257,40.3081512],[-3.9248657,40.3088379],[-3.9221191,40.3088379],[-3.9200592,40.3081512],[-3.9186859,40.306778],[-3.9173126,40.306778],[-3.9159393,40.3081512],[-3.9138794,40.3088379],[-3.9083862,40.3088379],[-3.9063263,40.3095245],[-3.9035797,40.3122711],[-3.9022064,40.316391],[-3.8980865,40.3205109],[-3.8973999,40.3225708],[-3.8973999,40.3253174],[-3.8967133,40.3273773],[-3.89534,40.3287506],[-3.8946533,40.3308105],[-3.89534,40.3328705],[-3.8967133,40.3342438],[-3.8980865,40.3383636],[-3.9001465,40.3390503],[-3.9056396,40.3390503],[-3.9076996,40.3397369],[-3.9076996,40.3411102],[-3.9063263,40.3424835],[-3.9063263,40.3438568],[-3.9104462,40.3452301],[-3.9118195,40.34935],[-3.9228058,40.3603363],[-3.9248657,40.3610229],[-3.9303589,40.3610229],[-3.9324188,40.3603363],[-3.9337921,40.358963],[-3.9358521,40.3582764],[-3.9413452,40.3582764],[-3.9434052,40.358963],[-3.9440918,40.3610229],[-3.9434052,40.3630829],[-3.9413452,40.3637695],[-3.9358521,40.3637695],[-3.9337921,40.3644562],[-3.9324188,40.3658295],[-3.9303589,40.3665161],[-3.9276123,40.3665161],[-3.9255524,40.3672028],[-3.9241791,40.368576],[-3.9200592,40.3699493],[-3.9173126,40.3726959],[-3.9159393,40.3768158],[-3.9090729,40.3836823],[-3.9076996,40.3878021],[-3.9063263,40.3891754],[-3.904953,40.3932953],[-3.9028931,40.3939819],[-3.9001465,40.3939819],[-3.8980865,40.3946686],[-3.8967133,40.3960419],[-3.8925934,40.3974152],[-3.8925934,40.3987885],[-3.8939667,40.4001617],[-3.8946533,40.4022217],[-3.8946533,40.4049683],[-3.89534,40.4070282],[-3.8994598,40.4084015],[-3.9008331,40.4097748],[-3.904953,40.4111481],[-3.9063263,40.4125214],[-3.9104462,40.4138947],[-3.9111328,40.4159546],[-3.9104462,40.4180145],[-3.9083862,40.4187012],[-3.9063263,40.4180145],[-3.904953,40.4166412],[-3.9028931,40.4159546],[-3.9008331,40.4166412],[-3.8967133,40.4207611],[-3.8946533,40.4214478],[-3.8919067,40.4214478],[-3.8898468,40.4221344],[-3.8871002,40.424881],[-3.8857269,40.4290009],[-3.8843536,40.4303741],[-3.8829803,40.434494],[-3.8816071,40.4358673],[-3.8809204,40.4379272],[-3.8809204,40.4434204],[-3.8816071,40.4454803],[-3.8829803,40.4468536],[-3.8829803,40.4482269],[-3.8816071,40.4496002],[-3.8816071,40.4509735],[-3.8857269,40.4523468],[-3.8864136,40.4544067],[-3.8857269,40.4564667],[-3.8843536,40.45784],[-3.8843536,40.4592133],[-3.8857269,40.4605865],[-3.8864136,40.4626465],[-3.8857269,40.4647064],[-3.883667,40.4653931],[-3.8816071,40.4647064],[-3.8774872,40.4605865],[-3.8733673,40.4592133],[-3.871994,40.45784],[-3.8699341,40.4571533],[-3.8589478,40.4571533],[-3.8568878,40.4564667],[-3.8541412,40.4537201],[-3.8527679,40.4496002],[-3.8472748,40.4441071],[-3.8452148,40.4434204],[-3.8424683,40.4434204],[-3.8404083,40.4441071],[-3.839035,40.4454803],[-3.8376617,40.4454803],[-3.8362885,40.4441071],[-3.8349152,40.4441071],[-3.8335419,40.4454803],[-3.829422,40.4468536],[-3.8253021,40.4509735],[-3.8211823,40.4523468],[-3.819809,40.4564667],[-3.8156891,40.4605865],[-3.8143158,40.4647064],[-3.8115692,40.467453],[-3.8095093,40.4681396],[-3.7957764,40.4681396],[-3.7937164,40.4688263],[-3.78685,40.4756927],[-3.78479,40.4763794],[-3.7792969,40.4763794],[-3.7772369,40.4756927],[-3.7765503,40.4736328],[-3.7772369,40.4715729],[-3.7813568,40.4701996],[-3.7827301,40.4688263],[-3.78685,40.467453],[-3.78685,40.4660797],[-3.78479,40.4653931],[-3.7792969,40.4653931],[-3.7772369,40.4647064],[-3.7765503,40.4626465],[-3.7772369,40.4605865],[-3.7792969,40.4598999],[-3.78479,40.4598999],[-3.78685,40.4605865],[-3.7882233,40.4619598],[-3.7902832,40.4626465],[-3.7923431,40.4619598],[-3.7937164,40.4605865],[-3.7957764,40.4598999],[-3.8012695,40.4598999],[-3.8033295,40.4592133],[-3.8040161,40.4571533],[-3.8040161,40.4516602],[-3.8047028,40.4496002],[-3.8067627,40.4489136],[-3.8150024,40.4489136],[-3.8170624,40.4482269],[-3.8184357,40.4468536],[-3.8225555,40.4454803],[-3.8280487,40.4399872],[-3.8280487,40.4386139],[-3.8253021,40.4358673],[-3.8232422,40.4351807],[-3.817749,40.4351807],[-3.8156891,40.434494],[-3.8143158,40.4331207],[-3.8129425,40.4331207],[-3.8115692,40.434494],[-3.8095093,40.4351807],[-3.8040161,40.4351807],[-3.8019562,40.4358673],[-3.8005829,40.4372406],[-3.796463,40.4386139],[-3.7950897,40.4399872],[-3.7930298,40.4406738],[-3.7875366,40.4406738],[-3.7854767,40.4399872],[-3.7854767,40.4386139],[-3.7882233,40.4358673],[-3.7923431,40.434494],[-3.7937164,40.4303741],[-3.7957764,40.4296875],[-3.8012695,40.4296875],[-3.8033295,40.4290009],[-3.8033295,40.4276276],[-3.8019562,40.4262543],[-3.8012695,40.4241943],[-3.8012695,40.4214478],[-3.8005829,40.4193878],[-3.7950897,40.4138947],[-3.7930298,40.413208],[-3.7909698,40.4138947],[-3.7895966,40.4152679],[-3.7875366,40.4159546],[-3.7854767,40.4152679],[-3.7841034,40.4138947],[-3.7799835,40.4125214],[-3.7786102,40.4084015],[-3.7744904,40.4070282],[-3.7731171,40.4029083],[-3.7710571,40.4022217],[-3.7683105,40.4022217],[-3.7662506,40.4029083],[-3.765564,40.4049683],[-3.765564,40.4077148],[-3.7648773,40.4097748],[-3.7621307,40.4125214],[-3.7600708,40.413208],[-3.7545776,40.413208],[-3.7525177,40.4125214],[-3.7511444,40.4111481],[-3.7497711,40.4111481],[-3.7490845,40.413208],[-3.7490845,40.4159546],[-3.7483978,40.4180145],[-3.7463379,40.4187012],[-3.7298584,40.4187012],[-3.7277985,40.4193878],[-3.7277985,40.4207611],[-3.7319183,40.4221344],[-3.7332916,40.4235077],[-3.7374115,40.424881],[-3.7387848,40.4290009],[-3.7401581,40.4303741],[-3.7408447,40.4324341],[-3.7408447,40.4406738],[-3.7415314,40.4427338],[-3.7429047,40.4441071],[-3.7435913,40.446167],[-3.7429047,40.4482269],[-3.7408447,40.4489136],[-3.7387848,40.4482269],[-3.7360382,40.4454803],[-3.7353516,40.4434204],[-3.7353516,40.4406738],[-3.7346649,40.4386139],[-3.730545,40.434494],[-3.7291718,40.4303741],[-3.7277985,40.4303741],[-3.7264252,40.4317474],[-3.7243652,40.4324341],[-3.7223053,40.4317474],[-3.7181854,40.4276276],[-3.7168121,40.4276276],[-3.7154388,40.4290009],[-3.7133789,40.4296875],[-3.711319,40.4290009],[-3.7058258,40.4235077],[-3.7051392,40.4214478],[-3.7058258,40.4193878],[-3.7099457,40.4152679],[-3.711319,40.4111481],[-3.7154388,40.4097748],[-3.720932,40.4042816],[-3.720932,40.4029083],[-3.7188721,40.4022217],[-3.7106323,40.4022217],[-3.7085724,40.401535],[-3.7071991,40.4001617],[-3.7051392,40.3994751],[-3.7030792,40.4001617],[-3.7017059,40.4042816],[-3.699646,40.4049683],[-3.6975861,40.4042816],[-3.6948395,40.401535],[-3.6941528,40.3994751],[-3.6948395,40.3974152],[-3.6962128,40.3960419],[-3.6962128,40.3946686],[-3.6920929,40.3932953],[-3.6907196,40.391922],[-3.6893463,40.391922],[-3.687973,40.3932953],[-3.6859131,40.3939819],[-3.6838531,40.3932953],[-3.6824799,40.391922],[-3.6811066,40.391922],[-3.6769867,40.3960419],[-3.6749268,40.3967285],[-3.6721802,40.3967285],[-3.6701202,40.3960419],[-3.6694336,40.3939819],[-3.6701202,40.391922],[-3.6728668,40.3891754],[-3.6769867,40.3878021],[-3.67836,40.3836823],[-3.6797333,40.382309],[-3.6804199,40.380249],[-3.6797333,40.3781891],[-3.67836,40.3768158],[-3.6769867,40.3726959],[-3.6756134,40.3713226],[-3.6749268,40.3692627],[-3.6749268,40.3665161],[-3.6742401,40.3644562],[-3.6721802,40.3637695],[-3.6701202,40.3644562],[-3.6701202,40.3658295],[-3.6714935,40.3672028],[-3.6714935,40.368576],[-3.6673737,40.3699493],[-3.6660004,40.3713226],[-3.6639404,40.3720093],[-3.6584473,40.3720093],[-3.6563873,40.3726959],[-3.655014,40.3768158],[-3.6522675,40.3795624],[-3.6502075,40.380249],[-3.6474609,40.380249],[-3.645401,40.3809357],[-3.6440277,40.382309],[-3.6399078,40.3836823],[-3.6385345,40.3878021],[-3.6344147,40.3891754],[-3.6330414,40.3932953],[-3.6316681,40.3946686],[-3.6302948,40.3987885],[-3.6282349,40.3994751],[-3.6261749,40.3987885],[-3.6248016,40.3946686],[-3.6234283,40.3932953],[-3.6227417,40.3912354],[-3.6234283,40.3891754],[-3.6275482,40.3878021],[-3.6282349,40.3857422],[-3.6282349,40.3829956],[-3.6289215,40.3809357],[-3.6309814,40.380249],[-3.633728,40.380249],[-3.635788,40.3795624],[-3.6371613,40.3781891],[-3.6392212,40.3775024],[-3.6419678,40.3775024],[-3.6440277,40.3768158],[-3.645401,40.3754425],[-3.6495209,40.3740692],[-3.6495209,40.3726959],[-3.6474609,40.3720093],[-3.6447144,40.3720093],[-3.6426544,40.3713226],[-3.6412811,40.3672028],[-3.6399078,40.3658295],[-3.6392212,40.3637695],[-3.6392212,40.3610229],[-3.6385345,40.358963],[-3.6371613,40.3575897],[-3.6364746,40.3555298],[-3.6371613,40.3534698],[-3.6392212,40.3527832],[-3.6412811,40.3534698],[-3.6426544,40.3575897],[-3.6481476,40.3630829],[-3.6495209,40.3630829],[-3.6508942,40.3617096],[-3.655014,40.3603363],[-3.6563873,40.3562164],[-3.6584473,40.3555298],[-3.6611938,40.3555298],[-3.6632538,40.3548431],[-3.6646271,40.3534698],[-3.6660004,40.3534698],[-3.6673737,40.3541565],[-3.6687469,40.3527832],[-3.6694336,40.3500366],[-3.6694336,40.34729],[-3.6687469,40.3452301],[-3.6660004,40.3424835],[-3.6639404,40.3417969],[-3.6618805,40.3424835],[-3.6605072,40.3438568],[-3.6563873,40.3452301],[-3.6522675,40.34935],[-3.6502075,40.3500366],[-3.6481476,40.34935],[-3.6474609,40.34729],[-3.6481476,40.3452301],[-3.6536407,40.3397369],[-3.6577606,40.3383636],[-3.6605072,40.3356171],[-3.6618805,40.3314972],[-3.6639404,40.3308105],[-3.6721802,40.3308105],[-3.6742401,40.3301239],[-3.67836,40.326004],[-3.6824799,40.3246307],[-3.6838531,40.3232574],[-3.687973,40.3218842],[-3.6886597,40.3198242],[-3.6886597,40.3088379],[-3.687973,40.306778],[-3.6838531,40.3054047],[-3.6831665,40.3033447],[-3.6838531,40.3012848],[-3.687973,40.2999115],[-3.6886597,40.2978516],[-3.687973,40.2957916],[-3.6852264,40.293045],[-3.6831665,40.2923584],[-3.6804199,40.2923584],[-3.67836,40.293045],[-3.6742401,40.2971649],[-3.6701202,40.2985382],[-3.6618805,40.306778],[-3.6605072,40.3108978],[-3.6584473,40.3115845],[-3.6557007,40.3115845],[-3.6536407,40.3122711],[-3.6508942,40.3150177],[-3.6495209,40.3191376],[-3.6481476,40.3205109],[-3.6467743,40.3246307],[-3.6385345,40.3328705],[-3.6364746,40.3335571],[-3.633728,40.3335571],[-3.6316681,40.3328705],[-3.6309814,40.3308105],[-3.6316681,40.3287506],[-3.635788,40.3273773],[-3.6385345,40.3246307],[-3.6399078,40.3205109],[-3.6440277,40.316391],[-3.645401,40.3122711],[-3.6495209,40.3081512],[-3.6495209,40.306778],[-3.6412811,40.2985382],[-3.6371613,40.2971649],[-3.6364746,40.295105],[-3.6371613,40.293045],[-3.6392212,40.2923584],[-3.6419678,40.2923584],[-3.6440277,40.293045],[-3.645401,40.2944183],[-3.6495209,40.2957916],[-3.6508942,40.2999115],[-3.6536407,40.3026581],[-3.655014,40.3026581],[-3.6563873,40.3012848],[-3.6605072,40.2999115],[-3.6673737,40.293045],[-3.6714935,40.2916718],[-3.6769867,40.2861786],[-3.67836,40.2820587],[-3.687973,40.2724457],[-3.6886597,40.2703857],[-3.6886597,40.2511597],[-3.687973,40.2490997],[-3.6811066,40.2422333],[-3.6811066,40.24086],[-3.6852264,40.2394867],[-3.6859131,40.2374268],[-3.6852264,40.2353668],[-3.6838531,40.2339935],[-3.6831665,40.2319336],[-3.6838531,40.2298737],[-3.6852264,40.2285004],[-3.6852264,40.2271271],[-3.6838531,40.2257538],[-3.6831665,40.2236938],[-3.6831665,40.2182007],[-3.6838531,40.2161407],[-3.6859131,40.2154541],[-3.687973,40.2161407],[-3.6886597,40.2182007],[-3.6886597,40.2209473],[-3.6893463,40.2230072],[-3.6907196,40.2243805],[-3.6920929,40.2285004],[-3.6941528,40.229187],[-3.699646,40.229187],[-3.7017059,40.2298737],[-3.711319,40.2394867],[-3.7133789,40.2401733],[-3.7271118,40.2401733],[-3.7291718,40.2394867],[-3.730545,40.2353668],[-3.7346649,40.2339935],[-3.7374115,40.2312469],[-3.7387848,40.2271271],[-3.7415314,40.2243805],[-3.7435913,40.2236938],[-3.7456512,40.2243805],[-3.7463379,40.2264404],[-3.7456512,40.2285004],[-3.744278,40.2298737],[-3.7429047,40.2339935],[-3.7415314,40.2353668],[-3.7408447,40.2374268],[-3.7408447,40.2484131],[-3.7401581,40.250473],[-3.7387848,40.2518463],[-3.7380981,40.2539063],[-3.7380981,40.2566528],[-3.7387848,40.2587128],[-3.7401581,40.2587128],[-3.7415314,40.2545929],[-3.744278,40.2518463],[-3.7463379,40.2511597],[-3.7483978,40.2518463],[-3.7497711,40.2532196],[-3.7511444,40.2532196],[-3.7525177,40.2518463],[-3.7545776,40.250473],[-3.7559509,40.2490997],[-3.7552643,40.2477264],[-3.7511444,40.2436066],[-3.7470245,40.2422333],[-3.7463379,40.2401733],[-3.7470245,40.2381134],[-3.7490845,40.2374268],[-3.7573242,40.2374268],[-3.7593842,40.2381134],[-3.7607574,40.2394867],[-3.7621307,40.2394867],[-3.763504,40.2381134],[-3.765564,40.2374268],[-3.7738037,40.2374268],[-3.7758636,40.2367401],[-3.7786102,40.2339935],[-3.7792969,40.2319336],[-3.7792969,40.229187],[-3.7786102,40.2271271],[-3.7772369,40.2257538],[-3.7765503,40.2236938],[-3.7772369,40.2216339],[-3.7786102,40.2202606],[-3.7799835,40.2161407],[-3.7827301,40.2133942],[-3.78685,40.2120209],[-3.7875366,40.2099609],[-3.7875366,40.196228],[-3.7882233,40.1941681],[-3.7923431,40.1927948],[-3.7937164,40.1914215],[-3.7978363,40.1900482],[-3.7992096,40.1886749],[-3.8012695,40.1879883],[-3.8033295,40.1886749],[-3.8040161,40.1907349],[-3.8033295,40.1927948],[-3.8005829,40.1955414],[-3.796463,40.1969147],[-3.7950897,40.2010345],[-3.7937164,40.2024078],[-3.7937164,40.2037811],[-3.7978363,40.2051544],[-3.7985229,40.2072144],[-3.7978363,40.2092743],[-3.796463,40.2106476],[-3.7950897,40.2147675],[-3.7937164,40.2161407],[-3.7937164,40.217514],[-3.7957764,40.2182007],[-3.7985229,40.2182007],[-3.8005829,40.2188873],[-3.8088226,40.2271271],[-3.8095093,40.229187],[-3.8088226,40.2312469],[-3.8067627,40.2319336],[-3.8047028,40.2312469],[-3.7950897,40.2216339],[-3.7930298,40.2209473],[-3.7902832,40.2209473],[-3.7882233,40.2216339],[-3.7882233,40.2230072],[-3.7895966,40.2243805],[-3.7902832,40.2264404],[-3.7902832,40.229187],[-3.7895966,40.2312469],[-3.7854767,40.2326202],[-3.78479,40.2346802],[-3.78479,40.2401733],[-3.7854767,40.2422333],[-3.7875366,40.2429199],[-3.7902832,40.2429199],[-3.7923431,40.2436066],[-3.7930298,40.2456665],[-3.7930298,40.2484131],[-3.7923431,40.250473],[-3.7895966,40.2532196],[-3.7854767,40.2545929],[-3.7854767,40.2559662],[-3.7895966,40.2600861],[-3.7902832,40.262146],[-3.7902832,40.2648926],[-3.7909698,40.2669525],[-3.7930298,40.2676392],[-3.7957764,40.2676392],[-3.7978363,40.2683258],[-3.7992096,40.2696991],[-3.8012695,40.2703857],[-3.8033295,40.2696991],[-3.8088226,40.2642059],[-3.8101959,40.2600861],[-3.8129425,40.2573395],[-3.8150024,40.2566528],[-3.817749,40.2566528],[-3.819809,40.2559662],[-3.8211823,40.2545929],[-3.8232422,40.2539063],[-3.8259888,40.2539063],[-3.8280487,40.2545929],[-3.8280487,40.2559662],[-3.8266754,40.2573395],[-3.8259888,40.2593994],[-3.8266754,40.2614594],[-3.8287354,40.262146],[-3.8307953,40.2614594],[-3.8314819,40.2593994],[-3.8314819,40.2566528],[-3.8321686,40.2539063],[-3.8342285,40.2518463],[-3.8369751,40.2511597],[-3.8479614,40.2511597],[-3.8500214,40.250473],[-3.850708,40.2484131],[-3.8500214,40.2463531],[-3.8459015,40.2449799],[-3.8445282,40.2436066],[-3.8424683,40.2429199],[-3.8369751,40.2429199],[-3.8349152,40.2422333],[-3.8335419,40.24086],[-3.829422,40.2394867],[-3.8280487,40.2381134],[-3.8259888,40.2374268],[-3.8232422,40.2374268],[-3.8211823,40.2367401],[-3.819809,40.2353668],[-3.8156891,40.2339935],[-3.8156891,40.2326202],[-3.817749,40.2319336],[-3.8259888,40.2319336],[-3.8280487,40.2326202],[-3.829422,40.2339935],[-3.8314819,40.2346802],[-3.8342285,40.2346802],[-3.8362885,40.2339935],[-3.8376617,40.2326202],[-3.8397217,40.2319336],[-3.8417816,40.2326202],[-3.8431549,40.2367401],[-3.8472748,40.2381134],[-3.8486481,40.2394867],[-3.850708,40.2401733],[-3.8527679,40.2394867],[-3.8596344,40.2326202],[-3.8637543,40.2312469],[-3.8665009,40.2285004],[-3.8671875,40.2264404],[-3.8671875,40.2127075],[-3.8678741,40.2106476],[-3.8699341,40.2099609],[-3.871994,40.2106476],[-3.8726807,40.2127075],[-3.8726807,40.2264404],[-3.8733673,40.229187],[-3.8754272,40.2312469],[-3.8774872,40.2312469],[-3.8788605,40.2271271],[-3.8802338,40.2257538],[-3.8816071,40.2216339],[-3.8829803,40.2202606],[-3.8843536,40.2161407],[-3.8884735,40.2120209],[-3.8898468,40.207901],[-3.8912201,40.2065277],[-3.8919067,40.2044678],[-3.8919067,40.2017212],[-3.8925934,40.1996613],[-3.8939667,40.1996613],[-3.8967133,40.2024078],[-3.8973999,40.2044678],[-3.8973999,40.2127075],[-3.8967133,40.2147675],[-3.8925934,40.2161407],[-3.8898468,40.2188873],[-3.8884735,40.2230072],[-3.8871002,40.2243805],[-3.8857269,40.2285004],[-3.8843536,40.2298737],[-3.8829803,40.2339935],[-3.8802338,40.2367401],[-3.8761139,40.2381134],[-3.8754272,40.2401733],[-3.8754272,40.2429199],[-3.8761139,40.2449799],[-3.8816071,40.250473],[-3.8857269,40.2518463],[-3.8912201,40.2573395],[-3.8919067,40.2593994],[-3.8919067,40.2648926],[-3.8925934,40.2669525],[-3.8939667,40.2669525],[-3.8967133,40.2642059],[-3.8973999,40.262146],[-3.8967133,40.2600861],[-3.89534,40.2587128],[-3.89534,40.2573395],[-3.8973999,40.2566528],[-3.9028931,40.2566528],[-3.904953,40.2559662],[-3.9063263,40.2545929],[-3.9083862,40.2539063],[-3.9303589,40.2539063],[-3.9324188,40.2545929],[-3.9337921,40.2559662],[-3.9358521,40.2566528],[-3.9468384,40.2566528],[-3.9488983,40.2573395],[-3.9502716,40.2587128],[-3.9516449,40.2587128],[-3.9530182,40.2573395],[-3.9550781,40.2566528],[-3.9571381,40.2573395],[-3.9585114,40.2587128],[-3.9626312,40.2600861],[-3.9629745,40.2614594],[-3.9619446,40.262146],[-3.960228,40.262146]]]]}') geojson,1200 ra,'concesionario alcorcon' as name union all
SELECT ST_GEOGFROMGEOJSON('{"type":"MultiPolygon","coordinates":[[[[-3.9598846,40.2648926],[-3.9385986,40.2648926],[-3.9344788,40.2635193],[-3.9317322,40.2607727],[-3.9276123,40.2593994],[-3.9221191,40.2593994],[-3.9179993,40.2607727],[-3.9152527,40.2635193],[-3.9070129,40.2662659],[-3.8987732,40.2745056],[-3.8905334,40.2772522],[-3.8877869,40.2799988],[-3.883667,40.2813721],[-3.8781738,40.2813721],[-3.874054,40.2827454],[-3.874054,40.2854919],[-3.8850403,40.2964783],[-3.89328,40.2992249],[-3.8960266,40.3019714],[-3.8987732,40.3019714],[-3.9015198,40.2992249],[-3.9056396,40.2978516],[-3.9276123,40.2978516],[-3.9317322,40.2964783],[-3.9344788,40.2937317],[-3.9372253,40.2937317],[-3.9427185,40.2992249],[-3.9427185,40.3019714],[-3.9344788,40.304718],[-3.9317322,40.3074646],[-3.9276123,40.3088379],[-3.9111328,40.3088379],[-3.9070129,40.3102112],[-3.9056396,40.3143311],[-3.9070129,40.3184509],[-3.9097595,40.3211975],[-3.9111328,40.3253174],[-3.9097595,40.3294373],[-3.9015198,40.3321838],[-3.9015198,40.3349304],[-3.9097595,40.337677],[-3.9125061,40.3459167],[-3.9234924,40.3569031],[-3.9317322,40.3596497],[-3.9331055,40.3637695],[-3.9317322,40.3678894],[-3.9234924,40.370636],[-3.9125061,40.3816223],[-3.9097595,40.3898621],[-3.9042664,40.3953552],[-3.8960266,40.3981018],[-3.8946533,40.4022217],[-3.8960266,40.4063416],[-3.9042664,40.4090881],[-3.9070129,40.4118347],[-3.9152527,40.4145813],[-3.916626,40.4187012],[-3.9152527,40.422821],[-3.9125061,40.422821],[-3.9097595,40.4200745],[-3.9056396,40.4187012],[-3.9015198,40.4200745],[-3.8987732,40.422821],[-3.8905334,40.4255676],[-3.8850403,40.4310608],[-3.883667,40.4351807],[-3.883667,40.4516602],[-3.8850403,40.45578],[-3.8877869,40.4585266],[-3.8891602,40.4626465],[-3.8877869,40.4667664],[-3.883667,40.4681396],[-3.8795471,40.4667664],[-3.8768005,40.4585266],[-3.8726807,40.4571533],[-3.8671875,40.4571533],[-3.8630676,40.45578],[-3.8616943,40.4516602],[-3.8630676,40.4475403],[-3.8713074,40.4447937],[-3.8726807,40.4406738],[-3.8726807,40.4351807],[-3.874054,40.4310608],[-3.8768005,40.4283142],[-3.8795471,40.4200745],[-3.8822937,40.4173279],[-3.8822937,40.4145813],[-3.874054,40.4118347],[-3.8658142,40.403595],[-3.8616943,40.4022217],[-3.8232422,40.4022217],[-3.8191223,40.4008484],[-3.8191223,40.3981018],[-3.8218689,40.3953552],[-3.8232422,40.3912354],[-3.8218689,40.3871155],[-3.8191223,40.3843689],[-3.8191223,40.3816223],[-3.8232422,40.380249],[-3.8273621,40.3816223],[-3.8356018,40.3898621],[-3.8397217,40.3912354],[-3.8562012,40.3912354],[-3.860321,40.3898621],[-3.8630676,40.3871155],[-3.8713074,40.3843689],[-3.8713074,40.3816223],[-3.8630676,40.3788757],[-3.8575745,40.3733826],[-3.8575745,40.370636],[-3.860321,40.3678894],[-3.860321,40.3651428],[-3.8548279,40.3596497],[-3.8520813,40.3596497],[-3.8493347,40.3623962],[-3.841095,40.3651428],[-3.8328552,40.3733826],[-3.8287354,40.3747559],[-3.8246155,40.3733826],[-3.8218689,40.3651428],[-3.8191223,40.3651428],[-3.8136292,40.370636],[-3.8108826,40.3788757],[-3.8067627,40.380249],[-3.8012695,40.380249],[-3.7971497,40.3816223],[-3.7944031,40.3843689],[-3.7861633,40.3871155],[-3.7834167,40.3898621],[-3.7792969,40.3912354],[-3.775177,40.3898621],[-3.775177,40.3871155],[-3.7779236,40.3843689],[-3.7806702,40.3761292],[-3.7889099,40.3733826],[-3.7902832,40.3692627],[-3.7889099,40.3651428],[-3.7861633,40.3651428],[-3.7834167,40.3678894],[-3.7792969,40.3692627],[-3.775177,40.3678894],[-3.7724304,40.3651428],[-3.7683105,40.3637695],[-3.7408447,40.3637695],[-3.7367249,40.3623962],[-3.7367249,40.3596497],[-3.7449646,40.3569031],[-3.7449646,40.3541565],[-3.742218,40.3514099],[-3.742218,40.3486633],[-3.7463379,40.34729],[-3.7738037,40.34729],[-3.7779236,40.3459167],[-3.7834167,40.3404236],[-3.78479,40.3363037],[-3.7834167,40.3321838],[-3.7792969,40.3308105],[-3.7738037,40.3308105],[-3.7696838,40.3294373],[-3.7669373,40.3266907],[-3.7628174,40.3253174],[-3.7518311,40.3253174],[-3.7477112,40.3239441],[-3.7463379,40.3198242],[-3.7477112,40.3157043],[-3.7559509,40.3129578],[-3.7614441,40.3074646],[-3.7614441,40.304718],[-3.7573242,40.3033447],[-3.7518311,40.3033447],[-3.7477112,40.3019714],[-3.7463379,40.2978516],[-3.7477112,40.2937317],[-3.7504578,40.2909851],[-3.7504578,40.2882385],[-3.742218,40.2854919],[-3.7394714,40.2827454],[-3.7353516,40.2813721],[-3.7243652,40.2813721],[-3.7202454,40.2799988],[-3.7174988,40.2772522],[-3.7133789,40.2758789],[-3.7023926,40.2758789],[-3.6982727,40.2772522],[-3.6955261,40.2799988],[-3.6914063,40.2813721],[-3.6872864,40.2799988],[-3.6859131,40.2758789],[-3.6872864,40.271759],[-3.6914063,40.2703857],[-3.7133789,40.2703857],[-3.7174988,40.2690125],[-3.7202454,40.2607727],[-3.7257385,40.2552795],[-3.7298584,40.2539063],[-3.7353516,40.2539063],[-3.7394714,40.2552795],[-3.7394714,40.2580261],[-3.7312317,40.2662659],[-3.7298584,40.2703857],[-3.7312317,40.2745056],[-3.7353516,40.2758789],[-3.7394714,40.2745056],[-3.742218,40.2662659],[-3.7504578,40.2635193],[-3.7641907,40.2497864],[-3.7683105,40.2484131],[-3.7724304,40.2497864],[-3.7724304,40.252533],[-3.7696838,40.2552795],[-3.7683105,40.2593994],[-3.7683105,40.2648926],[-3.7696838,40.2690125],[-3.7724304,40.2690125],[-3.775177,40.2662659],[-3.7834167,40.2635193],[-3.7861633,40.2607727],[-3.7889099,40.2607727],[-3.7916565,40.2635193],[-3.7957764,40.2648926],[-3.8012695,40.2648926],[-3.8053894,40.2635193],[-3.8136292,40.2552795],[-3.817749,40.2539063],[-3.8287354,40.2539063],[-3.8328552,40.252533],[-3.8356018,40.2497864],[-3.8438416,40.2470398],[-3.8438416,40.2442932],[-3.8397217,40.2429199],[-3.8342285,40.2429199],[-3.8301086,40.2415466],[-3.8287354,40.2374268],[-3.8301086,40.2333069],[-3.8342285,40.2319336],[-3.8383484,40.2333069],[-3.841095,40.2360535],[-3.8452148,40.2374268],[-3.850708,40.2374268],[-3.8548279,40.2360535],[-3.8658142,40.2250671],[-3.8671875,40.2209473],[-3.8671875,40.2154541],[-3.8685608,40.2113342],[-3.8713074,40.2113342],[-3.8726807,40.2154541],[-3.8726807,40.2264404],[-3.874054,40.2305603],[-3.8768005,40.2305603],[-3.8795471,40.2223206],[-3.8822937,40.219574],[-3.8850403,40.2113342],[-3.8905334,40.2058411],[-3.8946533,40.2044678],[-3.8987732,40.2058411],[-3.9001465,40.2099609],[-3.8987732,40.2140808],[-3.8905334,40.2223206],[-3.8877869,40.2305603],[-3.8795471,40.2388],[-3.8781738,40.2429199],[-3.8795471,40.2470398],[-3.8877869,40.2497864],[-3.8905334,40.252533],[-3.8946533,40.2539063],[-3.9550781,40.2539063],[-3.959198,40.2552795],[-3.9646912,40.2607727],[-3.9653778,40.2635193],[-3.9633179,40.2648926],[-3.9598846,40.2648926]]]]}') geojson,800 ra,'mostoles' as name union all
SELECT ST_GEOGFROMGEOJSON('{"type":"MultiPolygon","coordinates":[[[[-3.8311386,40.3555298],[-3.8259888,40.3555298],[-3.8239288,40.3562164],[-3.819809,40.3603363],[-3.817749,40.3610229],[-3.8067627,40.3610229],[-3.8047028,40.3603363],[-3.8033295,40.358963],[-3.7992096,40.3575897],[-3.7978363,40.3562164],[-3.7937164,40.3548431],[-3.7909698,40.3520966],[-3.7902832,40.3500366],[-3.7902832,40.34729],[-3.7909698,40.3452301],[-3.7923431,40.3438568],[-3.7923431,40.3424835],[-3.7902832,40.3417969],[-3.78479,40.3417969],[-3.7827301,40.3411102],[-3.7799835,40.3383636],[-3.7792969,40.3363037],[-3.7799835,40.3342438],[-3.7820435,40.3335571],[-3.78479,40.3335571],[-3.78685,40.3328705],[-3.7875366,40.3308105],[-3.78685,40.3287506],[-3.7841034,40.326004],[-3.7799835,40.3246307],[-3.7744904,40.3191376],[-3.7738037,40.3170776],[-3.7744904,40.3150177],[-3.7765503,40.3143311],[-3.7786102,40.3150177],[-3.7827301,40.3191376],[-3.78479,40.3198242],[-3.7875366,40.3198242],[-3.7895966,40.3205109],[-3.7909698,40.3246307],[-3.7923431,40.326004],[-3.7930298,40.328064],[-3.7930298,40.3308105],[-3.7937164,40.3328705],[-3.7978363,40.3342438],[-3.7992096,40.3356171],[-3.8012695,40.3363037],[-3.8033295,40.3356171],[-3.806076,40.3328705],[-3.806076,40.3314972],[-3.8047028,40.3301239],[-3.8040161,40.328064],[-3.8047028,40.326004],[-3.8067627,40.3253174],[-3.8088226,40.326004],[-3.8129425,40.3301239],[-3.8143158,40.3301239],[-3.8156891,40.326004],[-3.817749,40.3253174],[-3.8232422,40.3253174],[-3.8253021,40.326004],[-3.8266754,40.3273773],[-3.8287354,40.328064],[-3.8314819,40.328064],[-3.8335419,40.3287506],[-3.8342285,40.3308105],[-3.8342285,40.3417969],[-3.8335419,40.3438568],[-3.8321686,40.3452301],[-3.8321686,40.3466034],[-3.8335419,40.3479767],[-3.8342285,40.3500366],[-3.8342285,40.3527832],[-3.8338852,40.3548431],[-3.8328552,40.3555298],[-3.8311386,40.3555298]]]]}') as geojson,400 ra,'concesionario alcorcon' as name union all
SELECT ST_GEOGFROMGEOJSON('{"type":"MultiPolygon","coordinates":[[[[-3.8119125,40.3610229],[-3.8067627,40.3610229],[-3.8047028,40.3603363],[-3.8033295,40.358963],[-3.7992096,40.3575897],[-3.7978363,40.3562164],[-3.7937164,40.3548431],[-3.7895966,40.3507233],[-3.7882233,40.3507233],[-3.7854767,40.3534698],[-3.7841034,40.3575897],[-3.7827301,40.358963],[-3.7813568,40.3630829],[-3.7792969,40.3637695],[-3.7772369,40.3630829],[-3.7758636,40.3617096],[-3.7738037,40.3610229],[-3.7683105,40.3610229],[-3.7662506,40.3603363],[-3.7648773,40.3562164],[-3.7628174,40.3555298],[-3.7600708,40.3555298],[-3.7580109,40.3548431],[-3.7566376,40.3534698],[-3.7552643,40.3534698],[-3.7511444,40.3575897],[-3.7490845,40.3582764],[-3.7470245,40.3575897],[-3.7463379,40.3555298],[-3.7470245,40.3534698],[-3.7483978,40.3520966],[-3.7483978,40.3507233],[-3.744278,40.34935],[-3.7435913,40.34729],[-3.744278,40.3452301],[-3.7463379,40.3445435],[-3.7518311,40.3445435],[-3.753891,40.3438568],[-3.7552643,40.3397369],[-3.7593842,40.3383636],[-3.7593842,40.3369904],[-3.7580109,40.3356171],[-3.7580109,40.3342438],[-3.7621307,40.3328705],[-3.7628174,40.3308105],[-3.7628174,40.328064],[-3.763504,40.326004],[-3.7676239,40.3246307],[-3.7683105,40.3225708],[-3.7676239,40.3205109],[-3.7662506,40.3191376],[-3.765564,40.3170776],[-3.7662506,40.3150177],[-3.7683105,40.3143311],[-3.7765503,40.3143311],[-3.7786102,40.3150177],[-3.7827301,40.3191376],[-3.78685,40.3205109],[-3.7923431,40.326004],[-3.7937164,40.3301239],[-3.7978363,40.3314972],[-3.7985229,40.3335571],[-3.7985229,40.3363037],[-3.7992096,40.3383636],[-3.8005829,40.3383636],[-3.8019562,40.3369904],[-3.806076,40.3356171],[-3.8074493,40.3342438],[-3.8095093,40.3335571],[-3.8122559,40.3335571],[-3.8143158,40.3342438],[-3.8150024,40.3363037],[-3.8143158,40.3383636],[-3.8101959,40.3397369],[-3.8101959,40.3411102],[-3.8115692,40.3424835],[-3.8122559,40.3445435],[-3.8115692,40.3466034],[-3.8095093,40.34729],[-3.8067627,40.34729],[-3.8047028,40.3479767],[-3.8040161,40.3500366],[-3.8047028,40.3520966],[-3.8074493,40.3548431],[-3.8095093,40.3555298],[-3.8122559,40.3555298],[-3.8143158,40.3562164],[-3.8150024,40.3582764],[-3.8146591,40.3603363],[-3.8136292,40.3610229],[-3.8119125,40.3610229]]]]}') geojson,400 ra,'concesionario leganes' as name
),
--lets filter the POIs for the sake of dynamicness
pois_filtered AS (SELECT * FROM pois WHERE name<>'concesionario leganes'),
--We "raterize" the isochrones
h3s AS (SELECT jslibs.h3.ST_H3_POLYFILLFROMGEOG(geojson,9) as h3, ra,name FROM pois_filtered),
--We aggregate the cells to have unique H3s and get the min time to the POIs per cell
h3aggs AS (
SELECT min(ra) as min_ra, h3
FROM h3s,UNNEST(h3) as h3 GROUP BY h3),
--We fake an H3 coverage of Madrid with population
madrid_pop_h3 AS (SELECT h3,fhoffa.x.random_int(0,1000) as population
FROM (SELECT jslibs.h3.ST_H3_POLYFILLFROMGEOG(geometry,9) as madrid FROM `bigquery-public-data.geo_openstreetmap.planet_layers` WHERE osm_id=349055 AND layer_code=1104)
as q, unnest(madrid) as h3),
--We join Madrid with the distances h3
pops_and_ras AS (SELECT h3aggs.h3, h3aggs.min_ra, madrid_pop_h3.population FROM h3aggs INNER JOIN madrid_pop_h3 ON h3aggs.h3 = madrid_pop_h3.h3)
--we calculate the KPI of how far, wighted by population, are people from the POIs
SELECT sum(population), sum(population*min_ra)/sum(population) FROM pops_and_ras
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment