Skip to content

Instantly share code, notes, and snippets.

@Sambhunath-Sahoo

Sambhunath-Sahoo/geoapify_query

Created September 15, 2025 15:44
Show Gist options
  • Save Sambhunath-Sahoo/8ed735be86001dcf0fd8c98710c000b6 to your computer and use it in GitHub Desktop.
Save Sambhunath-Sahoo/8ed735be86001dcf0fd8c98710c000b6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
geoapify_query
select "tblcandidate"."id"
from "tblcandidate"
where (
"tblcandidate"."accountid" = 5
and (GEOGRAPHY_CONTAINS(('POLYGON((-73.972543 40.791302, -73.972933 40.791365, -73.973128 40.79139, -73.973543 40.791462, -73.973935 40.791583, -73.974216 40.791648, -73.974543 40.791737, -73.974841 40.791677, -73.975143 40.791575, -73.975543 40.791518, -73.976037 40.791469, -73.976052 40.791466, -73.976543 40.791406, -73.976886 40.791318, -73.977247 40.791271, -73.977543 40.791209, -73.977763 40.791196, -73.978462 40.790975, -73.978526 40.790958, -73.978543 40.790953, -73.978561 40.790957, -73.978594 40.790975, -73.97919 40.791328, -73.979543 40.791488, -73.98003 40.791488, -73.980056 40.791488, -73.980543 40.791488, -73.980941 40.791373, -73.981267 40.791251, -73.981543 40.79116, -73.981684 40.791116, -73.981771 40.790975, -73.982299 40.790731, -73.982543 40.790669, -73.983005 40.790437, -73.983237 40.789975, -73.9834 40.789832, -73.983543 40.78977, -73.983952 40.789566, -73.984134 40.789566, -73.984134 40.789384, -73.984338 40.788975, -73.984416 40.788848, -73.984543 40.788792, -73.98491 40.788608, -73.985176 40.788608, -73.985176 40.788342, -73.98536 40.787975, -73.985388 40.78782, -73.985388 40.78713, -73.985409 40.786975, -73.985466 40.786898, -73.985543 40.786864, -73.985765 40.786753, -73.986321 40.786753, -73.986321 40.786197, -73.986432 40.785975, -73.986479 40.785911, -73.986543 40.785885, -73.986723 40.785795, -73.987363 40.785795, -73.987363 40.785155, -73.987453 40.784975, -73.98746 40.784892, -73.98746 40.784058, -73.987465 40.783975, -73.987494 40.783926, -73.987543 40.783902, -73.987689 40.783829, -73.988397 40.783829, -73.988397 40.783121, -73.98847 40.782975, -73.988498 40.78293, -73.988543 40.782907, -73.98868 40.782838, -73.989406 40.782838, -73.989406 40.782112, -73.989474 40.781975, -73.989477 40.78191, -73.989477 40.781041, -73.98948 40.780975, -73.989504 40.780936, -73.989543 40.780915, -73.989605 40.780913, -73.99048 40.780913, -73.990543 40.78091, -73.990611 40.780907, -73.991475 40.780907, -73.991543 40.780904, -73.991684 40.780834, -73.992402 40.780834, -73.992402 40.780116, -73.992472 40.779975, -73.992402 40.779834, -73.992402 40.779116, -73.991684 40.779116, -73.991543 40.779046, -73.991475 40.779043, -73.990611 40.779043, -73.990543 40.77904, -73.990504 40.779014, -73.990492 40.778975, -73.990511 40.778943, -73.990543 40.778927, -73.99064 40.778878, -73.991446 40.778878, -73.991446 40.778072, -73.991495 40.777975, -73.991511 40.777943, -73.991543 40.777924, -73.991644 40.777874, -73.992442 40.777874, -73.992442 40.777076, -73.992492 40.776975, -73.99251 40.776943, -73.992543 40.776928, -73.992637 40.776881, -73.993449 40.776881, -73.993449 40.776069, -73.993496 40.775975, -73.993498 40.77593, -73.993498 40.77502, -73.993499 40.774975, -73.993516 40.774948, -73.993543 40.774934, -73.993624 40.774894, -73.994462 40.774894, -73.994462 40.774056, -73.994502 40.773975, -73.994517 40.77395, -73.994543 40.773938, -73.994617 40.773901, -73.995468 40.773901, -73.995468 40.77305, -73.995506 40.772975, -73.995507 40.772939, -73.995507 40.772011, -73.995508 40.771975, -73.995521 40.771953, -73.995543 40.771942, -73.99561 40.771908, -73.996476 40.771908, -73.996476 40.771042, -73.99651 40.770975, -73.996511 40.770943, -73.996511 40.770007, -73.996511 40.769975, -73.996523 40.769955, -73.996543 40.769945, -73.996603 40.769915, -73.997483 40.769915, -73.997483 40.769035, -73.997513 40.768975, -73.997514 40.768946, -73.997514 40.768004, -73.997515 40.767975, -73.997525 40.767957, -73.997543 40.767948, -73.997562 40.767956, -73.997573 40.767975, -73.997604 40.768036, -73.997604 40.768914, -73.998482 40.768914, -73.998543 40.768945, -73.998574 40.768944, -73.999512 40.768944, -73.999543 40.768944, -73.999575 40.768943, -74.000511 40.768943, -74.000543 40.768942, -74.000608 40.76891, -74.001478 40.76891, -74.001478 40.76804, -74.00151 40.767975, -74.001522 40.767955, -74.001543 40.767945, -74.001604 40.767914, -74.002482 40.767914, -74.002482 40.767036, -74.002513 40.766975, -74.002514 40.766946, -74.002514 40.766004, -74.002516 40.765975, -74.002525 40.765957, -74.002543 40.765947, -74.002571 40.765947, -74.003515 40.765947, -74.003543 40.765947, -74.0036 40.765918, -74.004486 40.765918, -74.004486 40.765032, -74.004514 40.764975, -74.004515 40.764947, -74.004515 40.764003, -74.004515 40.763975, -74.004514 40.763946, -74.004543 40.763945, -74.004603 40.763915, -74.005483 40.763915, -74.005483 40.763035, -74.005513 40.762975, -74.005513 40.762945, -74.005513 40.762005, -74.005513 40.761975, -74.005483 40.761915, -74.005483 40.761035, -74.004603 40.761035, -74.004543 40.761005, -74.004524 40.760994, -74.004514 40.760975, -74.004523 40.760955, -74.004543 40.760944, -74.004576 40.760942, -74.00551 40.760942, -74.005543 40.760939, -74.005579 40.760939, -74.006507 40.760939, -74.006543 40.760939, -74.006615 40.760903, -74.007471 40.760903, -74.007471 40.760047, -74.007507 40.759975, -74.007506 40.759938, -74.007506 40.759012, -74.007505 40.758975, -74.007467 40.758899, -74.007467 40.758051, -74.006619 40.758051, -74.006543 40.758013, -74.006519 40.757999, -74.006508 40.757975, -74.006508 40.75794, -74.006508 40.75701, -74.006508 40.756975, -74.006519 40.756951, -74.006543 40.756937, -74.006618 40.7569, -74.007468 40.7569, -74.007468 40.75605, -74.007505 40.755975, -74.007517 40.755949, -74.007543 40.755933, -74.007626 40.755892, -74.00846 40.755892, -74.00846 40.755058, -74.008501 40.754975, -74.008501 40.754933, -74.008501 40.754017, -74.008501 40.753975, -74.008513 40.753945, -74.008543 40.753927, -74.008594 40.753924, -74.009492 40.753924, -74.009543 40.753921, -74.009651 40.753867, -74.010435 40.753867, -74.010435 40.753083, -74.010489 40.752975, -74.010488 40.752921, -74.010488 40.75203, -74.010488 40.751975, -74.010503 40.751935, -74.010543 40.75191, -74.010674 40.751844, -74.011412 40.751844, -74.011412 40.751106, -74.011478 40.750975, -74.011412 40.750844, -74.011412 40.750106, -74.010674 40.750106, -74.010543 40.75004, -74.010502 40.750016, -74.010484 40.749975, -74.010501 40.749933, -74.010543 40.749906, -74.010615 40.749903, -74.011471 40.749903, -74.011543 40.7499, -74.011693 40.749825, -74.012393 40.749825, -74.012393 40.749125, -74.012468 40.748975, -74.012465 40.748897, -74.012465 40.748053, -74.012461 40.747975, -74.012456 40.747888, -74.012456 40.747062, -74.012451 40.746975, -74.012448 40.74688, -74.012448 40.74607, -74.012445 40.745975, -74.012348 40.74578, -74.012348 40.74517, -74.011738 40.74517, -74.011543 40.745073, -74.011481 40.745037, -74.011455 40.744975, -74.011478 40.74491, -74.011543 40.744863, -74.011665 40.744853, -74.01242 40.744853, -74.012543 40.74484, -74.012812 40.744706, -74.013274 40.744706, -74.013274 40.744244, -74.013408 40.743975, -74.013274 40.743706, -74.013274 40.743244, -74.012812 40.743244, -74.012543 40.74311, -74.012463 40.743055, -74.012428 40.742975, -74.012427 40.742859, -74.012427 40.742091, -74.012427 40.741975, -74.012446 40.741878, -74.012543 40.741776, -74.012941 40.741577, -74.013145 40.741577, -74.013145 40.741373, -74.013344 40.740975, -74.013145 40.740577, -74.013145 40.740373, -74.012941 40.740373, -74.012543 40.740174, -74.012445 40.740073, -74.012424 40.739975, -74.012418 40.73985, -74.012418 40.7391, -74.012411 40.738975, -74.012279 40.738711, -74.012279 40.738239, -74.011807 40.738239, -74.011543 40.738107, -74.011471 40.738047, -74.011442 40.737975, -74.011439 40.737871, -74.011439 40.737079, -74.011435 40.736975, -74.01143 40.736862, -74.01143 40.736088, -74.011424 40.735975, -74.01143 40.735862, -74.01143 40.735088, -74.011435 40.734975, -74.01146 40.734892, -74.011543 40.73482, -74.011853 40.734665, -74.012233 40.734665, -74.012233 40.734285, -74.012388 40.733975, -74.012419 40.733851, -74.012543 40.73373, -74.012817 40.733701, -74.013269 40.733701, -74.013543 40.733663, -74.014002 40.733434, -74.014231 40.732975, -74.014002 40.732516, -74.013543 40.732287, -74.013269 40.732249, -74.012817 40.732249, -74.012543 40.73222, -74.012337 40.732181, -74.011749 40.732181, -74.011543 40.732153, -74.01144 40.732078, -74.011387 40.731975, -74.011406 40.731838, -74.011543 40.731688, -74.012006 40.731512, -74.01208 40.731512, -74.012208 40.73131, -74.012481 40.730975, -74.01242 40.730852, -74.012174 40.730344, -74.011979 40.729975, -74.011817 40.729701, -74.011543 40.729334, -74.011314 40.729204, -74.011036 40.728975, -74.010735 40.728783, -74.010543 40.728667, -74.010166 40.728352, -74.009798 40.727975, -74.009679 40.727839, -74.009543 40.727698, -74.009171 40.727347, -74.008952 40.726975, -74.008766 40.726752, -74.008543 40.726629, -74.008122 40.726396, -74.007555 40.725975, -74.00755 40.725968, -74.007543 40.725958, -74.007104 40.725414, -74.006549 40.724975, -74.006546 40.724972, -74.006543 40.724965, -74.006522 40.724954, -74.005943 40.724575, -74.005543 40.724464, -74.005171 40.724603, -74.004785 40.724733, -74.004543 40.724818, -74.004436 40.724868, -74.00365 40.724868, -74.003543 40.724894, -74.003471 40.724903, -74.003246 40.724975, -74.002748 40.72518, -74.002543 40.725238, -74.002234 40.725284, -74.001889 40.725321, -74.001543 40.725378, -74.001213 40.725305, -74.000766 40.725198, -74.000543 40.725147, -74.000367 40.725151, -73.999762 40.725194, -73.999543 40.725198, -73.99929 40.725228, -73.998864 40.725296, -73.998543 40.725332, -73.998233 40.725285, -73.997839 40.724975, -73.99769 40.724828, -73.997543 40.724725, -73.997279 40.724711, -73.996923 40.724595, -73.996543 40.724584, -73.996157 40.724589, -73.995902 40.724616, -73.995543 40.724621, -73.99524 40.724672, -73.994847 40.724671, -73.994543 40.724709, -73.994229 40.724661, -73.993789 40.724729, -73.993543 40.724647, -73.993159 40.724359, -73.992709 40.724141, -73.992543 40.724049, -73.992455 40.724063, -73.991813 40.724245, -73.991543 40.724278, -73.991149 40.724369, -73.990963 40.724395, -73.990543 40.72452, -73.990215 40.724648, -73.989762 40.724756, -73.989543 40.724825, -73.989433 40.724865, -73.989239 40.724975, -73.988787 40.725219, -73.988543 40.725332, -73.988066 40.725452, -73.988028 40.72546, -73.987543 40.725599, -73.987225 40.725657, -73.986811 40.725707, -73.986543 40.725751, -73.986364 40.725796, -73.985563 40.725955, -73.985543 40.725959, -73.985531 40.725963, -73.985508 40.725975, -73.984896 40.726328, -73.984543 40.726451, -73.984181 40.726614, -73.983595 40.726923, -73.983543 40.726949, -73.983522 40.726955, -73.983447 40.726975, -73.982731 40.727163, -73.982543 40.727234, -73.982157 40.727361, -73.981994 40.727426, -73.981543 40.727546, -73.981223 40.727655, -73.980642 40.727975, -73.980576 40.728008, -73.980543 40.728019, -73.980482 40.728036, -73.979769 40.728201, -73.979543 40.728275, -73.979094 40.728424, -73.979006 40.728439, -73.978543 40.728692, -73.97831 40.728742, -73.977821 40.728697, -73.977543 40.728732, -73.977377 40.728809, -73.976978 40.728975, -73.976675 40.729107, -73.976543 40.729148, -73.976369 40.729149, -73.97562 40.729052, -73.975543 40.729052, -73.975482 40.729036, -73.975096 40.728975, -73.974639 40.728879, -73.974543 40.72884, -73.974472 40.728904, -73.974219 40.728975, -73.973672 40.729104, -73.973543 40.729125, -73.973314 40.729204, -73.972939 40.729371, -73.972543 40.729471, -73.972067 40.729499, -73.971929 40.729589, -73.971543 40.729668, -73.971391 40.729823, -73.971341 40.729975, -73.971408 40.73011, -73.971543 40.730177, -73.971826 40.730692, -73.971844 40.730975, -73.971813 40.731245, -73.971813 40.731705, -73.971788 40.731975, -73.972032 40.732464, -73.972032 40.732486, -73.972054 40.732486, -73.972543 40.73273, -73.972663 40.732855, -73.972694 40.732975, -73.972844 40.733277, -73.972844 40.733674, -73.973241 40.733674, -73.973543 40.733824, -73.973624 40.733894, -73.973644 40.733975, -73.973638 40.73407, -73.973638 40.73488, -73.973632 40.734975, -73.973598 40.73503, -73.973543 40.735058, -73.973454 40.735064, -73.972632 40.735064, -73.972543 40.735072, -73.97235 40.735168, -73.971736 40.735168, -73.971736 40.735782, -73.97164 40.735975, -73.971626 40.736058, -73.971626 40.736892, -73.971616 40.736975, -73.971611 40.737043, -73.971611 40.737907, -73.971607 40.737975, -73.971603 40.738035, -73.971603 40.738915, -73.971598 40.738975, -73.971595 40.739028, -73.971595 40.739923, -73.971593 40.739975, -73.971591 40.740023, -73.971591 40.740927, -73.971589 40.740975, -73.971587 40.741019, -73.971587 40.741931, -73.971586 40.741975, -73.97157 40.742002, -73.971543 40.742016, -73.971462 40.742056, -73.970624 40.742056, -73.970624 40.742894, -73.970584 40.742975, -73.97057 40.743002, -73.970543 40.743016, -73.97046 40.743058, -73.969626 40.743058, -73.969626 40.743892, -73.969584 40.743975, -73.969582 40.744014, -73.969582 40.744936, -73.969579 40.744975, -73.969567 40.744999, -73.969543 40.745011, -73.969472 40.745046, -73.968614 40.745046, -73.968614 40.745904, -73.968579 40.745975, -73.968566 40.745998, -73.968543 40.746008, -73.968476 40.746042, -73.96761 40.746042, -73.96761 40.746908, -73.967576 40.746975, -73.967565 40.746997, -73.967543 40.747011, -73.967472 40.747046, -73.966614 40.747046, -73.966614 40.747904, -73.966579 40.747975, -73.966565 40.747997, -73.966543 40.748008, -73.966477 40.748041, -73.965609 40.748041, -73.965609 40.748909, -73.965576 40.748975, -73.965575 40.749007, -73.965575 40.749943, -73.965574 40.749975, -73.965564 40.749996, -73.965543 40.750007, -73.965479 40.750039, -73.964607 40.750039, -73.964607 40.750911, -73.964575 40.750975, -73.964564 40.750996, -73.964543 40.751008, -73.964477 40.751041, -73.963608 40.751041, -73.963608 40.75191, -73.963576 40.751975, -73.963565 40.751997, -73.963543 40.752011, -73.963472 40.752046, -73.962614 40.752046, -73.962614 40.752904, -73.962578 40.752975, -73.962567 40.752999, -73.962543 40.753013, -73.962466 40.753052, -73.96162 40.753052, -73.96162 40.753898, -73.961581 40.753975, -73.96157 40.754002, -73.961543 40.754018, -73.961497 40.754021, -73.960589 40.754021, -73.960543 40.754026, -73.960441 40.754077, -73.959645 40.754077, -73.959645 40.754873, -73.959594 40.754975, -73.959578 40.75501, -73.959543 40.755032, -73.959337 40.755181, -73.958973 40.755406, -73.958748 40.75577, -73.9586 40.755975, -73.958598 40.75603, -73.958598 40.75692, -73.958596 40.756975, -73.958581 40.757013, -73.958543 40.75704, -73.958412 40.757106, -73.957673 40.757106, -73.957673 40.757845, -73.957608 40.757975, -73.957587 40.758019, -73.957543 40.758044, -73.957405 40.758113, -73.956681 40.758113, -73.956681 40.758837, -73.956612 40.758975, -73.956591 40.759023, -73.956543 40.759054, -73.956386 40.759132, -73.9557 40.759132, -73.9557 40.759818, -73.955622 40.759975, -73.955599 40.760031, -73.955543 40.760068, -73.955356 40.760162, -73.954729 40.760162, -73.954729 40.760789, -73.954636 40.760975, -73.954612 40.761044, -73.954543 40.76109, -73.954313 40.761205, -73.953773 40.761205, -73.953773 40.761745, -73.953658 40.761975, -73.953632 40.762064, -73.953543 40.762125, -73.953244 40.762274, -73.952842 40.762274, -73.952842 40.762676, -73.952692 40.762975, -73.95266 40.763092, -73.952543 40.763189, -73.952115 40.763403, -73.951971 40.763403, -73.951971 40.763547, -73.951757 40.763975, -73.951722 40.764154, -73.951543 40.764419, -73.951172 40.764604, -73.950987 40.764975, -73.950928 40.76536, -73.950894 40.765624, -73.950843 40.765975, -73.95082 40.766252, -73.950547 40.766971, -73.950547 40.766975, -73.95055 40.766982, -73.950867 40.767651, -73.951031 40.767975, -73.951211 40.768307, -73.951331 40.768763, -73.951411 40.768975, -73.95144 40.769078, -73.951543 40.769508, -73.951665 40.769853, -73.951736 40.769975, -73.952088 40.77043, -73.952121 40.770553, -73.952302 40.770975, -73.95236 40.771158, -73.952543 40.771958, -73.952547 40.771971, -73.95255 40.771975, -73.952568 40.772, -73.952972 40.772546, -73.953211 40.772975, -73.953327 40.773191, -73.953543 40.773797, -73.953588 40.77393, -73.953603 40.773975, -73.953639 40.774071, -73.953814 40.774704, -73.953955 40.774975, -73.954164 40.775354, -73.954449 40.775881, -73.9545 40.775975, -73.954515 40.776003, -73.954543 40.7761, -73.954737 40.776781, -73.954855 40.776975, -73.95508 40.777438, -73.95515 40.777582, -73.955342 40.777975, -73.955406 40.778112, -73.955543 40.778533, -73.955638 40.77888, -73.955685 40.778975, -73.955818 40.77925, -73.955962 40.779556, -73.956175 40.779975, -73.956286 40.780232, -73.956543 40.780867, -73.956568 40.78095, -73.956577 40.780975, -73.956602 40.781034, -73.956855 40.781663, -73.957 40.781975, -73.957152 40.782366, -73.95735 40.782782, -73.957435 40.782975, -73.957464 40.783054, -73.957543 40.783242, -73.957719 40.783799, -73.957779 40.783975, -73.958077 40.784441, -73.958543 40.784693, -73.958924 40.784594, -73.959096 40.784528, -73.959543 40.784445, -73.959893 40.784325, -73.960101 40.783975, -73.960348 40.78378, -73.960543 40.78371, -73.961033 40.783465, -73.961278 40.782975, -73.961418 40.78285, -73.961543 40.782812, -73.961704 40.782814, -73.962299 40.782731, -73.962543 40.782734, -73.962728 40.78279, -73.962974 40.782975, -73.963034 40.783466, -73.963025 40.783493, -73.963205 40.783975, -73.963318 40.7842, -73.963543 40.784313, -73.96394 40.784578, -73.964146 40.784578, -73.964543 40.784692, -73.964695 40.784823, -73.964806 40.784975, -73.965051 40.785467, -73.965543 40.785712, -73.965685 40.785833, -73.965767 40.785975, -73.965818 40.78625, -73.965818 40.7867, -73.9659 40.786975, -73.965763 40.787196, -73.965543 40.787408, -73.965222 40.787654, -73.965173 40.787975, -73.965071 40.788447, -73.96509 40.788522, -73.964697 40.788975, -73.965173 40.789345, -73.96547 40.789902, -73.965517 40.789975, -73.965526 40.789992, -73.965543 40.79001, -73.965581 40.790013, -73.966306 40.790212, -73.966543 40.790223, -73.966721 40.790153, -73.967442 40.789975, -73.967522 40.789954, -73.967543 40.789952, -73.967579 40.789939, -73.968267 40.789699, -73.968543 40.789582, -73.968829 40.789689, -73.969037 40.789975, -73.969246 40.790272, -73.969543 40.790464, -73.97 40.790432, -73.970086 40.790432, -73.970543 40.790404, -73.970903 40.790335, -73.971216 40.790302, -73.971543 40.790248, -73.972004 40.790514, -73.972304 40.790975, -73.972368 40.79115, -73.972543 40.791302, -74.015543 40.769119, -74.015833 40.769685, -74.016447 40.769879, -74.016543 40.769933, -74.016664 40.769854, -74.017084 40.769516, -74.017543 40.7694, -74.017759 40.769191, -74.017816 40.768975, -74.018135 40.768567, -74.018543 40.768418, -74.018802 40.768234, -74.018897 40.767975, -74.01916 40.767592, -74.019543 40.767431, -74.019949 40.767381, -74.020185 40.766975, -74.02025 40.766682, -74.020396 40.766122, -74.020431 40.765975, -74.020476 40.765908, -74.020543 40.765883, -74.020628 40.76589, -74.020722 40.765975, -74.020798 40.76623, -74.020933 40.766585, -74.021025 40.766975, -74.021019 40.767451, -74.020972 40.767546, -74.020956 40.767975, -74.02108 40.768438, -74.021543 40.768828, -74.021976 40.768542, -74.022055 40.768487, -74.022543 40.768228, -74.022704 40.768137, -74.022823 40.767975, -74.023174 40.767606, -74.023543 40.767105, -74.023594 40.767026, -74.023629 40.766975, -74.02413 40.766562, -74.024543 40.766473, -74.024938 40.76637, -74.025343 40.766175, -74.025543 40.766101, -74.025642 40.766074, -74.025865 40.765975, -74.026203 40.765635, -74.026281 40.765237, -74.026393 40.764975, -74.026439 40.764871, -74.026252 40.764266, -74.026292 40.763975, -74.026402 40.763834, -74.026543 40.763771, -74.027035 40.763467, -74.027214 40.762975, -74.027343 40.762775, -74.027543 40.762657, -74.027963 40.762395, -74.02814 40.761975, -74.028308 40.761741, -74.028543 40.761633, -74.028951 40.761383, -74.029126 40.760975, -74.029265 40.760697, -74.029543 40.760541, -74.029917 40.760601, -74.030416 40.760848, -74.030543 40.760885, -74.030639 40.760879, -74.031447 40.760879, -74.031543 40.760872, -74.031653 40.760865, -74.032433 40.760865, -74.032543 40.760856, -74.032781 40.760737, -74.033305 40.760737, -74.033305 40.760213, -74.033424 40.759975, -74.033424 40.759856, -74.033424 40.759094, -74.033424 40.758975, -74.033375 40.758807, -74.033375 40.758143, -74.033261 40.757975, -74.033401 40.757833, -74.033543 40.757761, -74.03379 40.757222, -74.033863 40.756975, -74.034026 40.756492, -74.03402 40.756452, -74.03411 40.756408, -74.034543 40.756073, -74.034648 40.75608, -74.034695 40.755975, -74.034721 40.755797, -74.034664 40.755096, -74.034696 40.754975, -74.034696 40.754822, -74.034543 40.754683, -74.034162 40.754356, -74.03369 40.753975, -74.033621 40.753897, -74.033543 40.753829, -74.033121 40.753397, -74.03267 40.752975, -74.032625 40.752893, -74.032543 40.752715, -74.032338 40.75218, -74.03225 40.751975, -74.031901 40.751617, -74.031543 40.751287, -74.031373 40.751145, -74.031209 40.750975, -74.030868 40.75065, -74.030543 40.750297, -74.030323 40.750195, -74.029869 40.749975, -74.029648 40.74987, -74.029543 40.749853, -74.029455 40.749888, -74.029293 40.749975, -74.028809 40.750241, -74.028543 40.750336, -74.028044 40.750477, -74.02804 40.750478, -74.027543 40.750621, -74.027288 40.75072, -74.026718 40.750975, -74.026602 40.751034, -74.026543 40.751055, -74.026385 40.751133, -74.025932 40.751364, -74.025543 40.751541, -74.025243 40.751676, -74.024705 40.751975, -74.024594 40.752026, -74.024543 40.752046, -74.024403 40.752115, -74.023888 40.75232, -74.023543 40.752574, -74.023451 40.752067, -74.022638 40.75207, -74.022543 40.752027, -74.022432 40.752086, -74.021654 40.752086, -74.021742 40.752776, -74.021655 40.752975, -74.021742 40.753174, -74.021654 40.753864, -74.022432 40.753864, -74.022543 40.753923, -74.022624 40.753894, -74.022825 40.753975, -74.023064 40.754454, -74.023543 40.754693, -74.023681 40.754837, -74.023709 40.754975, -74.023876 40.755308, -74.023876 40.755642, -74.02421 40.755642, -74.024543 40.755809, -74.02469 40.755828, -74.025396 40.755828, -74.025543 40.755843, -74.025665 40.755853, -74.026421 40.755853, -74.026543 40.755862, -74.02661 40.755908, -74.026629 40.755975, -74.026594 40.756026, -74.026543 40.756045, -74.026403 40.756115, -74.025682 40.756115, -74.025682 40.756836, -74.025613 40.756975, -74.025585 40.757017, -74.025543 40.757033, -74.025488 40.75703, -74.024598 40.75703, -74.024543 40.757027, -74.024493 40.757025, -74.023593 40.757025, -74.023543 40.757023, -74.023495 40.757023, -74.022591 40.757023, -74.022543 40.757023, -74.022446 40.757072, -74.02164 40.757072, -74.02164 40.757878, -74.021591 40.757975, -74.02159 40.758022, -74.02159 40.758928, -74.021589 40.758975, -74.021575 40.759007, -74.021543 40.759026, -74.021441 40.759077, -74.020644 40.759077, -74.020644 40.759874, -74.020594 40.759975, -74.020579 40.760011, -74.020543 40.760033, -74.020481 40.760037, -74.019605 40.760037, -74.019543 40.760042, -74.019473 40.760045, -74.018613 40.760045, -74.018543 40.760048, -74.018396 40.760122, -74.017689 40.760122, -74.017689 40.760829, -74.017616 40.760975, -74.017618 40.76105, -74.017618 40.7619, -74.01762 40.761975, -74.017698 40.76213, -74.017698 40.76282, -74.018388 40.76282, -74.018543 40.762898, -74.01859 40.762928, -74.018612 40.762975, -74.018603 40.763035, -74.018543 40.763089, -74.018417 40.763101, -74.017669 40.763101, -74.017543 40.763116, -74.017261 40.763257, -74.016825 40.763257, -74.016825 40.763693, -74.016684 40.763975, -74.016656 40.764088, -74.016543 40.764177, -74.016139 40.764379, -74.015947 40.764379, -74.015947 40.764571, -74.015745 40.764975, -74.015947 40.765379, -74.015947 40.765571, -74.016139 40.765571, -74.016543 40.765773, -74.016661 40.765857, -74.016701 40.765975, -74.016672 40.766104, -74.016543 40.766234, -74.016049 40.766481, -74.015802 40.766975, -74.015801 40.767233, -74.015543 40.767663, -74.015335 40.767767, -74.015231 40.767975, -74.015267 40.768251, -74.015461 40.768894, -74.015476 40.768975, -74.015505 40.769013, -74.015543 40.769119, -74.002543 40.785163, -74.002727 40.785159, -74.003308 40.78521, -74.003543 40.785205, -74.00369 40.785122, -74.004362 40.785156, -74.004543 40.785112, -74.004622 40.785054, -74.004771 40.784975, -74.005194 40.784626, -74.005543 40.784545, -74.005905 40.784613, -74.006334 40.784766, -74.006543 40.784818, -74.006696 40.784822, -74.007457 40.78489, -74.007543 40.784892, -74.007956 40.784388, -74.008085 40.783975, -74.008302 40.783734, -74.008543 40.783655, -74.008854 40.783664, -74.009336 40.783768, -74.009543 40.783777, -74.009854 40.783664, -74.010267 40.783699, -74.010543 40.78314, -74.01066 40.783092, -74.011303 40.783215, -74.011543 40.783175, -74.01171 40.783142, -74.012238 40.782975, -74.012442 40.782874, -74.012543 40.782819, -74.012767 40.782751, -74.013188 40.782621, -74.013543 40.782515, -74.014021 40.782497, -74.014059 40.782491, -74.014543 40.782477, -74.014951 40.782383, -74.015203 40.782315, -74.015543 40.782232, -74.015735 40.782167, -74.016454 40.781975, -74.016526 40.781958, -74.016543 40.781955, -74.016573 40.781945, -74.017321 40.781753, -74.017543 40.781668, -74.017997 40.781521, -74.018063 40.781495, -74.018543 40.78137, -74.018871 40.781304, -74.019316 40.781202, -74.019543 40.781155, -74.019669 40.781101, -74.019818 40.780975, -74.019921 40.780597, -74.019974 40.780406, -74.020091 40.779975, -74.020051 40.779483, -74.020049 40.779469, -74.020013 40.778975, -74.019984 40.778534, -74.019922 40.778354, -74.019879 40.777975, -74.019972 40.777546, -74.020018 40.77745, -74.02007 40.776975, -74.020005 40.776513, -74.01998 40.776412, -74.019907 40.775975, -74.019753 40.775765, -74.019543 40.775667, -74.019101 40.775417, -74.018809 40.774975, -74.018727 40.774791, -74.018546 40.773978, -74.018545 40.773975, -74.018544 40.773974, -74.018543 40.773973, -74.018536 40.773969, -74.017874 40.773644, -74.017543 40.773265, -74.017419 40.773099, -74.017357 40.772975, -74.017238 40.77267, -74.017138 40.77238, -74.016954 40.771975, -74.016768 40.77175, -74.016543 40.771434, -74.016046 40.771478, -74.016042 40.771476, -74.015543 40.771496, -74.01531 40.771742, -74.015269 40.771975, -74.014825 40.772257, -74.014543 40.772319, -74.014161 40.772593, -74.014019 40.772975, -74.013806 40.773238, -74.013543 40.773298, -74.01332 40.773198, -74.013185 40.772975, -74.012972 40.772546, -74.012543 40.772356, -74.01214 40.772378, -74.01196 40.772392, -74.011543 40.772413, -74.011177 40.772341, -74.010667 40.772099, -74.010543 40.77206, -74.010373 40.772145, -74.009713 40.772145, -74.009713 40.772805, -74.009628 40.772975, -74.009596 40.773028, -74.009543 40.773057, -74.009378 40.77314, -74.008707 40.77314, -74.008707 40.773811, -74.008625 40.773975, -74.008707 40.77414, -74.008707 40.774811, -74.009378 40.774811, -74.009543 40.774893, -74.009591 40.774927, -74.009607 40.774975, -74.009606 40.775039, -74.009606 40.775912, -74.009606 40.775975, -74.009582 40.776014, -74.009543 40.776036, -74.00942 40.776098, -74.008666 40.776098, -74.008666 40.776852, -74.008604 40.776975, -74.008585 40.777017, -74.008543 40.777043, -74.008407 40.777111, -74.007679 40.777111, -74.007679 40.777839, -74.007611 40.777975, -74.007592 40.778024, -74.007543 40.778054, -74.007385 40.778133, -74.006701 40.778133, -74.006701 40.778817, -74.006622 40.778975, -74.006602 40.779034, -74.006543 40.779076, -74.006342 40.779176, -74.005744 40.779176, -74.005744 40.779774, -74.005644 40.779975, -74.005617 40.780049, -74.005543 40.780101, -74.005401 40.780117, -74.004685 40.780117, -74.004543 40.780138, -74.004216 40.780302, -74.003869 40.780302, -74.003869 40.780649, -74.003706 40.780975, -74.003685 40.781117, -74.003543 40.781388, -74.003152 40.781584, -74.002956 40.781975, -74.002785 40.782217, -74.002543 40.782602, -74.002294 40.782726, -74.00217 40.782975, -74.002002 40.783434, -74.001989 40.783529, -74.001873 40.783975, -74.002 40.784432, -74.002004 40.784514, -74.002243 40.784975, -74.002398 40.78512, -74.002543 40.785163, -73.955543 40.749509, -73.955917 40.749601, -73.956371 40.749803, -73.956543 40.749862, -73.956654 40.749864, -73.957432 40.749864, -73.957543 40.749866, -73.957761 40.749757, -73.958325 40.749757, -73.958325 40.749193, -73.958434 40.748975, -73.958469 40.748901, -73.958543 40.748851, -73.958791 40.748727, -73.959295 40.748727, -73.959295 40.748223, -73.959419 40.747975, -73.959416 40.747848, -73.959416 40.747102, -73.959413 40.746975, -73.959437 40.746869, -73.959543 40.746783, -73.959927 40.746591, -73.960159 40.746591, -73.960159 40.746359, -73.960351 40.745975, -73.960274 40.745706, -73.960274 40.745244, -73.960094 40.744975, -73.960393 40.744825, -73.960543 40.744769, -73.960954 40.744564, -73.961132 40.744564, -73.961132 40.744386, -73.961337 40.743975, -73.961454 40.743886, -73.961543 40.743864, -73.961765 40.743753, -73.962321 40.743753, -73.962321 40.743197, -73.962432 40.742975, -73.962439 40.742871, -73.962439 40.742079, -73.962445 40.741975, -73.962434 40.741866, -73.962434 40.741084, -73.96242 40.740975, -73.962449 40.740881, -73.962543 40.740799, -73.962895 40.740623, -73.963191 40.740623, -73.963191 40.740327, -73.963367 40.739975, -73.963361 40.739793, -73.963361 40.739157, -73.963353 40.738975, -73.963322 40.738754, -73.963322 40.738196, -73.963277 40.737975, -73.963032 40.737486, -73.962543 40.737241, -73.962271 40.737247, -73.961815 40.737247, -73.961543 40.737252, -73.9611 40.737532, -73.960981 40.737537, -73.960543 40.737666, -73.960357 40.737789, -73.960299 40.737975, -73.96 40.738432, -73.959543 40.738649, -73.959244 40.738676, -73.958765 40.738753, -73.958543 40.738775, -73.958379 40.738812, -73.957884 40.738975, -73.957713 40.739145, -73.957543 40.739212, -73.957281 40.739237, -73.956805 40.739237, -73.956543 40.739268, -73.956198 40.73932, -73.955888 40.73932, -73.955543 40.739393, -73.955079 40.739511, -73.954849 40.739669, -73.954543 40.739828, -73.954509 40.739941, -73.954425 40.739975, -73.954391 40.740127, -73.954313 40.740745, -73.954249 40.740975, -73.954322 40.741196, -73.95432 40.741752, -73.954364 40.741975, -73.954436 40.742082, -73.954543 40.742186, -73.954988 40.74253, -73.95539 40.742822, -73.955543 40.742934, -73.955563 40.742955, -73.955575 40.742975, -73.955585 40.743017, -73.955669 40.743849, -73.955717 40.743975, -73.955793 40.744225, -73.955908 40.74461, -73.956021 40.744975, -73.955678 40.74511, -73.955543 40.745154, -73.955285 40.745233, -73.954935 40.745367, -73.954543 40.745462, -73.954112 40.745406, -73.953818 40.74525, -73.953543 40.745175, -73.953214 40.745304, -73.952959 40.745391, -73.952543 40.745585, -73.95231 40.745742, -73.952049 40.745975, -73.951845 40.746277, -73.951543 40.746602, -73.95135 40.746782, -73.95125 40.746975, -73.951391 40.747127, -73.951543 40.747306, -73.951909 40.747609, -73.952337 40.747975, -73.952442 40.748076, -73.952543 40.748123, -73.952607 40.748039, -73.952615 40.747975, -73.953101 40.747533, -73.953543 40.747457, -73.95383 40.747688, -73.953925 40.747975, -73.95413 40.748388, -73.954543 40.748545, -73.954803 40.748715, -73.95491 40.748975, -73.955164 40.749354, -73.955543 40.749509, -74.026543 40.741187, -74.026673 40.741105, -74.026946 40.740975, -74.027374 40.740806, -74.027543 40.740768, -74.027892 40.740626, -74.028104 40.740536, -74.028543 40.740367, -74.028816 40.740248, -74.029359 40.739975, -74.02947 40.739902, -74.029543 40.739862, -74.029847 40.739671, -74.030095 40.739527, -74.030543 40.739166, -74.030677 40.739109, -74.031037 40.738975, -74.031424 40.738857, -74.031543 40.738828, -74.031783 40.738735, -74.032167 40.738599, -74.032543 40.738435, -74.032821 40.738253, -74.033224 40.737975, -74.033349 40.737781, -74.033543 40.737523, -74.033837 40.737269, -74.033933 40.736975, -74.034213 40.736645, -74.034543 40.73625, -74.034681 40.736113, -74.034792 40.735975, -74.034701 40.735817, -74.034543 40.735744, -74.034075 40.735507, -74.034037 40.735481, -74.033543 40.735357, -74.033238 40.73528, -74.032848 40.73528, -74.032543 40.735229, -74.032398 40.73512, -74.032336 40.734975, -74.032128 40.734561, -74.032128 40.73439, -74.031957 40.73439, -74.031543 40.734182, -74.031423 40.734095, -74.031367 40.733975, -74.03139 40.733822, -74.031543 40.733637, -74.031848 40.73328, -74.031826 40.732975, -74.031909 40.732609, -74.031825 40.732257, -74.032083 40.731975, -74.031884 40.731634, -74.031543 40.731274, -74.031361 40.731157, -74.030543 40.730975, -74.030049 40.731481, -74.029853 40.731975, -74.029804 40.732236, -74.029804 40.732714, -74.029768 40.732975, -74.029657 40.733089, -74.029543 40.73311, -74.029422 40.733096, -74.028664 40.733096, -74.028543 40.733085, -74.028435 40.733083, -74.027651 40.733083, -74.027543 40.733081, -74.027332 40.733186, -74.026754 40.733186, -74.026754 40.733764, -74.026649 40.733975, -74.026605 40.734037, -74.026543 40.73406, -74.026372 40.734146, -74.025714 40.734146, -74.025714 40.734804, -74.025628 40.734975, -74.025621 40.735053, -74.025543 40.735155, -74.025182 40.735336, -74.024903 40.735336, -74.024903 40.735615, -74.024723 40.735975, -74.024675 40.736107, -74.024543 40.736224, -74.024045 40.736473, -74.024041 40.736473, -74.024041 40.736477, -74.023792 40.736975, -74.024041 40.737473, -74.024041 40.737477, -74.024045 40.737477, -74.024543 40.737726, -74.024751 40.737767, -74.025335 40.737767, -74.025543 40.737797, -74.025651 40.737867, -74.025714 40.737975, -74.025742 40.738174, -74.025742 40.738776, -74.025779 40.738975, -74.02576 40.739192, -74.025543 40.739547, -74.025278 40.73971, -74.025196 40.739975, -74.025225 40.740293, -74.025543 40.740903, -74.025576 40.740942, -74.025685 40.740975, -74.026358 40.74116, -74.026543 40.741187, -74.014543 40.71927, -74.014822 40.719254, -74.015234 40.719284, -74.015543 40.71927, -74.015824 40.719256, -74.01624 40.719278, -74.016543 40.719266, -74.016871 40.719303, -74.017293 40.718975, -74.017334 40.718766, -74.017334 40.718184, -74.017363 40.717975, -74.017443 40.717876, -74.017543 40.717838, -74.017816 40.717702, -74.01827 40.717702, -74.01827 40.717248, -74.018406 40.716975, -74.018423 40.716855, -74.018423 40.716095, -74.018436 40.715975, -74.018479 40.715911, -74.018543 40.715884, -74.018725 40.715793, -74.019361 40.715793, -74.019361 40.715157, -74.019452 40.714975, -74.019361 40.714793, -74.019361 40.714157, -74.018725 40.714157, -74.018543 40.714066, -74.018478 40.71404, -74.018431 40.713975, -74.018419 40.713851, -74.018419 40.713099, -74.018404 40.712975, -74.018352 40.712784, -74.018352 40.712166, -74.018239 40.711975, -74.018124 40.711556, -74.018151 40.711367, -74.017744 40.710975, -74.017624 40.710894, -74.017543 40.710885, -74.017405 40.710837, -74.016817 40.710701, -74.016543 40.710562, -74.016163 40.710596, -74.015961 40.710557, -74.015543 40.710579, -74.015207 40.710639, -74.014687 40.710831, -74.014543 40.710867, -74.014482 40.710914, -74.014425 40.710975, -74.01394 40.711372, -74.013543 40.711586, -74.013224 40.711656, -74.012766 40.711752, -74.012543 40.711799, -74.012414 40.711846, -74.012209 40.711975, -74.011869 40.712301, -74.011543 40.712731, -74.011432 40.712864, -74.011388 40.712975, -74.011409 40.713109, -74.011543 40.713533, -74.011631 40.713887, -74.011639 40.713975, -74.011611 40.714043, -74.011543 40.714147, -74.011148 40.71458, -74.010821 40.714975, -74.011141 40.715377, -74.011543 40.715629, -74.011696 40.715822, -74.011772 40.715975, -74.011873 40.716305, -74.011958 40.71656, -74.012077 40.716975, -74.012246 40.717272, -74.012404 40.717836, -74.012458 40.717975, -74.012475 40.718043, -74.012543 40.718182, -74.012993 40.718525, -74.013121 40.718553, -74.013543 40.718723, -74.013696 40.718822, -74.013794 40.718975, -74.014265 40.719253, -74.014543 40.71927, -73.972543 40.791302))'), location))
)
@Sambhunath-Sahoo
Copy link
Author

ALTER TABLE tblcandidate
ADD COLUMN location POINT NULL ;

image

This is how we currently do it. This is working for us, but for this case, it is breaking

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment