add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
129000 rows affected
example_id transaction_dt latitude longitude latlong most_recent
5961 14/06/2019 16:14:34 39.8550589352619 -74.0003704441225 POINT (-74.000370444122524 39.855058935261944) 1
5962 13/06/2019 16:14:34 39.8550589352619 -74.0003704441225 POINT (-74.000370444122524 39.855058935261944) 1
5963 12/06/2019 16:14:34 39.8550589352619 -74.0003704441225 POINT (-74.000370444122524 39.855058935261944) 1
5964 11/06/2019 16:14:34 39.8550589352619 -74.0003704441225 POINT (-74.000370444122524 39.855058935261944) 1
5971 14/06/2019 16:14:34 39.8552191771366 -73.9911420761936 POINT (-73.99114207619364 39.855219177136561) 1
5972 13/06/2019 16:14:34 39.8552191771366 -73.9911420761936 POINT (-73.99114207619364 39.855219177136561) 1
5973 12/06/2019 16:14:34 39.8552191771366 -73.9911420761936 POINT (-73.99114207619364 39.855219177136561) 1
5974 11/06/2019 16:14:34 39.8552191771366 -73.9911420761936 POINT (-73.99114207619364 39.855219177136561) 1
5951 14/06/2019 16:14:34 39.8552471360297 -74.0095979252562 POINT (-74.00959792525623 39.855247136029746) 1
5952 13/06/2019 16:14:34 39.8552471360297 -74.0095979252562 POINT (-74.00959792525623 39.855247136029746) 1
5953 12/06/2019 16:14:34 39.8552471360297 -74.0095979252562 POINT (-74.00959792525623 39.855247136029746) 1
5954 11/06/2019 16:14:34 39.8552471360297 -74.0095979252562 POINT (-74.00959792525623 39.855247136029746) 1
5981 14/06/2019 16:14:34 39.8557274780307 -73.9819349131332 POINT (-73.981934913133173 39.855727478030737) 1
5982 13/06/2019 16:14:34 39.8557274780307 -73.9819349131332 POINT (-73.981934913133173 39.855727478030737) 1
5983 12/06/2019 16:14:34 39.8557274780307 -73.9819349131332 POINT (-73.981934913133173 39.855727478030737) 1
5984 11/06/2019 16:14:34 39.8557274780307 -73.9819349131332 POINT (-73.981934913133173 39.855727478030737) 1
5941 14/06/2019 16:14:34 39.8557833288826 -74.0188024300137 POINT (-74.0188024300137 39.855783328882588) 1
5942 13/06/2019 16:14:34 39.8557833288826 -74.0188024300137 POINT (-74.0188024300137 39.855783328882588) 1
5943 12/06/2019 16:14:34 39.8557833288826 -74.0188024300137 POINT (-74.0188024300137 39.855783328882588) 1
5944 11/06/2019 16:14:34 39.8557833288826 -74.0188024300137 POINT (-74.0188024300137 39.855783328882588) 1
5991 14/06/2019 16:14:34 39.8565826210426 -73.9727709968065 POINT (-73.972770996806489 39.856582621042584) 1
5992 13/06/2019 16:14:34 39.8565826210426 -73.9727709968065 POINT (-73.972770996806489 39.856582621042584) 1
5993 12/06/2019 16:14:34 39.8565826210426 -73.9727709968065 POINT (-73.972770996806489 39.856582621042584) 1
5994 11/06/2019 16:14:34 39.8565826210426 -73.9727709968065 POINT (-73.972770996806489 39.856582621042584) 1
5931 14/06/2019 16:14:34 39.8566662301413 -74.0279619227726 POINT (-74.027961922772647 39.856666230141286) 1
5932 13/06/2019 16:14:34 39.8566662301413 -74.0279619227726 POINT (-74.027961922772647 39.856666230141286) 1
5933 12/06/2019 16:14:34 39.8566662301413 -74.0279619227726 POINT (-74.027961922772647 39.856666230141286) 1
5934 11/06/2019 16:14:34 39.8566662301413 -74.0279619227726 POINT (-74.027961922772647 39.856666230141286) 1
6001 14/06/2019 16:14:34 39.8577825588499 -73.9636722675078 POINT (-73.963672267507846 39.857782558849934) 1
6002 13/06/2019 16:14:34 39.8577825588499 -73.9636722675078 POINT (-73.963672267507846 39.857782558849934) 1
6003 12/06/2019 16:14:34 39.8577825588499 -73.9636722675078 POINT (-73.963672267507846 39.857782558849934) 1
6004 11/06/2019 16:14:34 39.8577825588499 -73.9636722675078 POINT (-73.963672267507846 39.857782558849934) 1
5921 14/06/2019 16:14:34 39.8578937260205 -74.0370544736288 POINT (-74.037054473628828 39.857893726020514) 1
5922 13/06/2019 16:14:34 39.8578937260205 -74.0370544736288 POINT (-74.037054473628828 39.857893726020514) 1
5923 12/06/2019 16:14:34 39.8578937260205 -74.0370544736288 POINT (-74.037054473628828 39.857893726020514) 1
5924 11/06/2019 16:14:34 39.8578937260205 -74.0370544736288 POINT (-74.037054473628828 39.857893726020514) 1
6011 14/06/2019 16:14:34 39.8593244185206 -73.9546605124076 POINT (-73.954660512407557 39.8593244185206) 1
6012 13/06/2019 16:14:34 39.8593244185206 -73.9546605124076 POINT (-73.954660512407557 39.8593244185206) 1
6013 12/06/2019 16:14:34 39.8593244185206 -73.9546605124076 POINT (-73.954660512407557 39.8593244185206) 1
6014 11/06/2019 16:14:34 39.8593244185206 -73.9546605124076 POINT (-73.954660512407557 39.8593244185206) 1
5911 14/06/2019 16:14:34 39.8594628775953 -74.0460583099265 POINT (-74.046058309926508 39.859462877595327) 1
5912 13/06/2019 16:14:34 39.8594628775953 -74.0460583099265 POINT (-74.046058309926508 39.859462877595327) 1
5913 12/06/2019 16:14:34 39.8594628775953 -74.0460583099265 POINT (-74.046058309926508 39.859462877595327) 1
5914 11/06/2019 16:14:34 39.8594628775953 -74.0460583099265 POINT (-74.046058309926508 39.859462877595327) 1
6021 14/06/2019 16:14:34 39.8612045082636 -73.9457573143311 POINT (-73.9457573143311 39.861204508263583) 1
6022 13/06/2019 16:14:34 39.8612045082636 -73.9457573143311 POINT (-73.9457573143311 39.861204508263583) 1
6023 12/06/2019 16:14:34 39.8612045082636 -73.9457573143311 POINT (-73.9457573143311 39.861204508263583) 1
6024 11/06/2019 16:14:34 39.8612045082636 -73.9457573143311 POINT (-73.9457573143311 39.861204508263583) 1
5901 14/06/2019 16:14:34 39.8613699277074 -74.0549518674478 POINT (-74.054951867447812 39.861369927707436) 1
5902 13/06/2019 16:14:34 39.8613699277074 -74.0549518674478 POINT (-74.054951867447812 39.861369927707436) 1
5903 12/06/2019 16:14:34 39.8613699277074 -74.0549518674478 POINT (-74.054951867447812 39.861369927707436) 1
5904 11/06/2019 16:14:34 39.8613699277074 -74.0549518674478 POINT (-74.054951867447812 39.861369927707436) 1
6031 14/06/2019 16:14:34 39.8634183261066 -73.9369840009815 POINT (-73.936984000981539 39.863418326106554) 1
6032 13/06/2019 16:14:34 39.8634183261066 -73.9369840009815 POINT (-73.936984000981539 39.863418326106554) 1
6033 12/06/2019 16:14:34 39.8634183261066 -73.9369840009815 POINT (-73.936984000981539 39.863418326106554) 1
6034 11/06/2019 16:14:34 39.8634183261066 -73.9369840009815 POINT (-73.936984000981539 39.863418326106554) 1
5891 14/06/2019 16:14:34 39.8636103097967 -74.0637138411498 POINT (-74.063713841149834 39.863610309796677) 1
5892 13/06/2019 16:14:34 39.8636103097967 -74.0637138411498 POINT (-74.063713841149834 39.863610309796677) 1
5893 12/06/2019 16:14:34 39.8636103097967 -74.0637138411498 POINT (-74.063713841149834 39.863610309796677) 1
5894 11/06/2019 16:14:34 39.8636103097967 -74.0637138411498 POINT (-74.063713841149834 39.863610309796677) 1
6041 14/06/2019 16:14:34 39.8659605704808 -73.9283615947162 POINT (-73.9283615947162 39.865960570480844) 1
6042 13/06/2019 16:14:34 39.8659605704808 -73.9283615947162 POINT (-73.9283615947162 39.865960570480844) 1
6043 12/06/2019 16:14:34 39.8659605704808 -73.9283615947162 POINT (-73.9283615947162 39.865960570480844) 1
6044 11/06/2019 16:14:34 39.8659605704808 -73.9283615947162 POINT (-73.9283615947162 39.865960570480844) 1
5881 14/06/2019 16:14:34 39.866178658638 -74.0723232353388 POINT (-74.0723232353388 39.86617865863802) 1
5882 13/06/2019 16:14:34 39.866178658638 -74.0723232353388 POINT (-74.0723232353388 39.86617865863802) 1
5883 12/06/2019 16:14:34 39.866178658638 -74.0723232353388 POINT (-74.0723232353388 39.86617865863802) 1
5884 11/06/2019 16:14:34 39.866178658638 -74.0723232353388 POINT (-74.0723232353388 39.86617865863802) 1
6051 14/06/2019 16:14:34 39.8688251526908 -73.9199107629876 POINT (-73.919910762987641 39.8688251526908) 1
6052 13/06/2019 16:14:34 39.8688251526908 -73.9199107629876 POINT (-73.919910762987641 39.8688251526908) 1
6053 12/06/2019 16:14:34 39.8688251526908 -73.9199107629876 POINT (-73.919910762987641 39.8688251526908) 1
6054 11/06/2019 16:14:34 39.8688251526908 -73.9199107629876 POINT (-73.919910762987641 39.8688251526908) 1
5871 14/06/2019 16:14:34 39.8690688229611 -74.080759413171 POINT (-74.080759413171023 39.86906882296109) 1
5872 13/06/2019 16:14:34 39.8690688229611 -74.080759413171 POINT (-74.080759413171023 39.86906882296109) 1
5873 12/06/2019 16:14:34 39.8690688229611 -74.080759413171 POINT (-74.080759413171023 39.86906882296109) 1
5874 11/06/2019 16:14:34 39.8690688229611 -74.080759413171 POINT (-74.080759413171023 39.86906882296109) 1
6061 14/06/2019 16:14:34 39.8720052112403 -73.9116517695578 POINT (-73.9116517695578 39.872005211240271) 1
6062 13/06/2019 16:14:34 39.8720052112403 -73.9116517695578 POINT (-73.9116517695578 39.872005211240271) 1
6063 12/06/2019 16:14:34 39.8720052112403 -73.9116517695578 POINT (-73.9116517695578 39.872005211240271) 1
6064 11/06/2019 16:14:34 39.8720052112403 -73.9116517695578 POINT (-73.9116517695578 39.872005211240271) 1
5861 14/06/2019 16:14:34 39.8722738799244 -74.089002145372 POINT (-74.089002145371992 39.872273879924428) 1
5862 13/06/2019 16:14:34 39.8722738799244 -74.089002145372 POINT (-74.089002145371992 39.872273879924428) 1
5863 12/06/2019 16:14:34 39.8722738799244 -74.089002145372 POINT (-74.089002145371992 39.872273879924428) 1
5864 11/06/2019 16:14:34 39.8722738799244 -74.089002145372 POINT (-74.089002145371992 39.872273879924428) 1
6071 14/06/2019 16:14:34 39.8754931279851 -73.9036044265936 POINT (-73.903604426593589 39.875493127985109) 1
6072 13/06/2019 16:14:34 39.8754931279851 -73.9036044265936 POINT (-73.903604426593589 39.875493127985109) 1
6073 12/06/2019 16:14:34 39.8754931279851 -73.9036044265936 POINT (-73.903604426593589 39.875493127985109) 1
6074 11/06/2019 16:14:34 39.8754931279851 -73.9036044265936 POINT (-73.903604426593589 39.875493127985109) 1
5851 14/06/2019 16:14:34 39.875786151413 -74.0970316580654 POINT (-74.0970316580654 39.875786151412953) 1
5852 13/06/2019 16:14:34 39.875786151413 -74.0970316580654 POINT (-74.0970316580654 39.875786151412953) 1
5853 12/06/2019 16:14:34 39.875786151413 -74.0970316580654 POINT (-74.0970316580654 39.875786151412953) 1
5854 11/06/2019 16:14:34 39.875786151413 -74.0970316580654 POINT (-74.0970316580654 39.875786151412953) 1
6081 14/06/2019 16:14:34 39.8792805460761 -73.8957880477504 POINT (-73.8957880477504 39.879280546076075) 1
6082 13/06/2019 16:14:34 39.8792805460761 -73.8957880477504 POINT (-73.8957880477504 39.879280546076075) 1
6083 12/06/2019 16:14:34 39.8792805460761 -73.8957880477504 POINT (-73.8957880477504 39.879280546076075) 1
6084 11/06/2019 16:14:34 39.8792805460761 -73.8957880477504 POINT (-73.8957880477504 39.879280546076075) 1
5841 14/06/2019 16:14:34 39.879597222123 -74.1048286796057 POINT (-74.104828679605731 39.879597222123031) 1
5842 13/06/2019 16:14:34 39.879597222123 -74.1048286796057 POINT (-74.104828679605731 39.879597222123031) 1
5843 12/06/2019 16:14:34 39.879597222123 -74.1048286796057 POINT (-74.104828679605731 39.879597222123031) 1
5844 11/06/2019 16:14:34 39.879597222123 -74.1048286796057 POINT (-74.104828679605731 39.879597222123031) 1
6091 14/06/2019 16:14:34 39.8833583896531 -73.888221402349 POINT (-73.888221402348975 39.8833583896531) 1
6092 13/06/2019 16:14:34 39.8833583896531 -73.888221402349 POINT (-73.888221402348975 39.8833583896531) 1
6093 12/06/2019 16:14:34 39.8833583896531 -73.888221402349 POINT (-73.888221402348975 39.8833583896531) 1
6094 11/06/2019 16:14:34 39.8833583896531 -73.888221402349 POINT (-73.888221402348975 39.8833583896531) 1
5831 14/06/2019 16:14:34 39.8836979593953 -74.1123744863092 POINT (-74.112374486309164 39.883697959395327) 1
5832 13/06/2019 16:14:34 39.8836979593953 -74.1123744863092 POINT (-74.112374486309164 39.883697959395327) 1
5833 12/06/2019 16:14:34 39.8836979593953 -74.1123744863092 POINT (-74.112374486309164 39.883697959395327) 1
5834 11/06/2019 16:14:34 39.8836979593953 -74.1123744863092 POINT (-74.112374486309164 39.883697959395327) 1
6101 14/06/2019 16:14:34 39.8877168852471 -73.8809226707491 POINT (-73.880922670749058 39.887716885247116) 1
6102 13/06/2019 16:14:34 39.8877168852471 -73.8809226707491 POINT (-73.880922670749058 39.887716885247116) 1
6103 12/06/2019 16:14:34 39.8877168852471 -73.8809226707491 POINT (-73.880922670749058 39.887716885247116) 1
6104 11/06/2019 16:14:34 39.8877168852471 -73.8809226707491 POINT (-73.880922670749058 39.887716885247116) 1
5821 14/06/2019 16:14:34 39.8880785347519 -74.1196509469795 POINT (-74.119650946979462 39.888078534751891) 1
5822 13/06/2019 16:14:34 39.8880785347519 -74.1196509469795 POINT (-74.119650946979462 39.888078534751891) 1
5823 12/06/2019 16:14:34 39.8880785347519 -74.1196509469795 POINT (-74.119650946979462 39.888078534751891) 1
5824 11/06/2019 16:14:34 39.8880785347519 -74.1196509469795 POINT (-74.119650946979462 39.888078534751891) 1
6111 14/06/2019 16:14:34 39.892345584843 -73.8739094010218 POINT (-73.873909401021763 39.892345584842978) 1
6112 13/06/2019 16:14:34 39.892345584843 -73.8739094010218 POINT (-73.873909401021763 39.892345584842978) 1
6113 12/06/2019 16:14:34 39.892345584843 -73.8739094010218 POINT (-73.873909401021763 39.892345584842978) 1
6114 11/06/2019 16:14:34 39.892345584843 -73.8739094010218 POINT (-73.873909401021763 39.892345584842978) 1
5811 14/06/2019 16:14:34 39.89272844709 -74.1266405661269 POINT (-74.126640566126937 39.892728447089972) 1
5812 13/06/2019 16:14:34 39.89272844709 -74.1266405661269 POINT (-74.126640566126937 39.892728447089972) 1
5813 12/06/2019 16:14:34 39.89272844709 -74.1266405661269 POINT (-74.126640566126937 39.892728447089972) 1
5814 11/06/2019 16:14:34 39.89272844709 -74.1266405661269 POINT (-74.126640566126937 39.892728447089972) 1
6121 14/06/2019 16:14:34 39.8972333905517 -73.8671984670204 POINT (-73.867198467020359 39.8972333905517) 1
6122 13/06/2019 16:14:34 39.8972333905517 -73.8671984670204 POINT (-73.867198467020359 39.8972333905517) 1
6123 12/06/2019 16:14:34 39.8972333905517 -73.8671984670204 POINT (-73.867198467020359 39.8972333905517) 1
6124 11/06/2019 16:14:34 39.8972333905517 -73.8671984670204 POINT (-73.867198467020359 39.8972333905517) 1
5801 14/06/2019 16:14:34 39.8976365474813 -74.1333265257813 POINT (-74.1333265257813 39.8976365474813) 1
5802 13/06/2019 16:14:34 39.8976365474813 -74.1333265257813 POINT (-74.1333265257813 39.8976365474813) 1
5803 12/06/2019 16:14:34 39.8976365474813 -74.1333265257813 POINT (-74.1333265257813 39.8976365474813) 1
5804 11/06/2019 16:14:34 39.8976365474813 -74.1333265257813 POINT (-74.1333265257813 39.8976365474813) 1
5481 14/06/2019 16:14:34 40.1026109522104 -74.1332015704258 POINT (-74.133201570425825 40.102610952210419) 1
5482 13/06/2019 16:14:34 40.1026109522104 -74.1332015704258 POINT (-74.133201570425825 40.102610952210419) 1
5483 12/06/2019 16:14:34 40.1026109522104 -74.1332015704258 POINT (-74.133201570425825 40.102610952210419) 1
5484 11/06/2019 16:14:34 40.1026109522104 -74.1332015704258 POINT (-74.133201570425825 40.102610952210419) 1
5171 14/06/2019 16:14:34 40.1071313366801 -73.872963566699 POINT (-73.872963566698971 40.107131336680133) 1
5172 13/06/2019 16:14:34 40.1071313366801 -73.872963566699 POINT (-73.872963566698971 40.107131336680133) 1
5173 12/06/2019 16:14:34 40.1071313366801 -73.872963566699 POINT (-73.872963566698971 40.107131336680133) 1
5174 11/06/2019 16:14:34 40.1071313366801 -73.872963566699 POINT (-73.872963566698971 40.107131336680133) 1
5471 14/06/2019 16:14:34 40.1075136606765 -74.1264886339523 POINT (-74.126488633952292 40.10751366067651) 1
5472 13/06/2019 16:14:34 40.1075136606765 -74.1264886339523 POINT (-74.126488633952292 40.10751366067651) 1
5473 12/06/2019 16:14:34 40.1075136606765 -74.1264886339523 POINT (-74.126488633952292 40.10751366067651) 1
5474 11/06/2019 16:14:34 40.1075136606765 -74.1264886339523 POINT (-74.126488633952292 40.10751366067651) 1
5181 14/06/2019 16:14:34 40.1117959294713 -73.8799588167048 POINT (-73.879958816704828 40.11179592947127) 1
5182 13/06/2019 16:14:34 40.1117959294713 -73.8799588167048 POINT (-73.879958816704828 40.11179592947127) 1
5183 12/06/2019 16:14:34 40.1117959294713 -73.8799588167048 POINT (-73.879958816704828 40.11179592947127) 1
5184 11/06/2019 16:14:34 40.1117959294713 -73.8799588167048 POINT (-73.879958816704828 40.11179592947127) 1
5461 14/06/2019 16:14:34 40.1121571192162 -74.1194695358892 POINT (-74.119469535889166 40.112157119216178) 1
5462 13/06/2019 16:14:34 40.1121571192162 -74.1194695358892 POINT (-74.119469535889166 40.112157119216178) 1
5463 12/06/2019 16:14:34 40.1121571192162 -74.1194695358892 POINT (-74.119469535889166 40.112157119216178) 1
5464 11/06/2019 16:14:34 40.1121571192162 -74.1194695358892 POINT (-74.119469535889166 40.112157119216178) 1
5191 14/06/2019 16:14:34 40.1161909066071 -73.8872446774006 POINT (-73.887244677400631 40.116190906607088) 1
5192 13/06/2019 16:14:34 40.1161909066071 -73.8872446774006 POINT (-73.887244677400631 40.116190906607088) 1
5193 12/06/2019 16:14:34 40.1161909066071 -73.8872446774006 POINT (-73.887244677400631 40.116190906607088) 1
5194 11/06/2019 16:14:34 40.1161909066071 -73.8872446774006 POINT (-73.887244677400631 40.116190906607088) 1
5451 14/06/2019 16:14:34 40.1165300877096 -74.1121612064384 POINT (-74.112161206438373 40.116530087709577) 1
5452 13/06/2019 16:14:34 40.1165300877096 -74.1121612064384 POINT (-74.112161206438373 40.116530087709577) 1
5453 12/06/2019 16:14:34 40.1165300877096 -74.1121612064384 POINT (-74.112161206438373 40.116530087709577) 1
5454 11/06/2019 16:14:34 40.1165300877096 -74.1121612064384 POINT (-74.112161206438373 40.116530087709577) 1
5201 14/06/2019 16:14:34 40.1203056275055 -73.8948035632537 POINT (-73.894803563253731 40.120305627505516) 1
5202 13/06/2019 16:14:34 40.1203056275055 -73.8948035632537 POINT (-73.894803563253731 40.120305627505516) 1
5203 12/06/2019 16:14:34 40.1203056275055 -73.8948035632537 POINT (-73.894803563253731 40.120305627505516) 1
5204 11/06/2019 16:14:34 40.1203056275055 -73.8948035632537 POINT (-73.894803563253731 40.120305627505516) 1
5441 14/06/2019 16:14:34 40.1206219786962 -74.1045812863513 POINT (-74.104581286351291 40.120621978696207) 1
5442 13/06/2019 16:14:34 40.1206219786962 -74.1045812863513 POINT (-74.104581286351291 40.120621978696207) 1
5443 12/06/2019 16:14:34 40.1206219786962 -74.1045812863513 POINT (-74.104581286351291 40.120621978696207) 1
5444 11/06/2019 16:14:34 40.1206219786962 -74.1045812863513 POINT (-74.104581286351291 40.120621978696207) 1
5211 14/06/2019 16:14:34 40.1241301282421 -73.9026172175202 POINT (-73.902617217520174 40.124130128242136) 1
5212 13/06/2019 16:14:34 40.1241301282421 -73.9026172175202 POINT (-73.902617217520174 40.124130128242136) 1
5213 12/06/2019 16:14:34 40.1241301282421 -73.9026172175202 POINT (-73.902617217520174 40.124130128242136) 1
5214 11/06/2019 16:14:34 40.1241301282421 -73.9026172175202 POINT (-73.902617217520174 40.124130128242136) 1
5431 14/06/2019 16:14:34 40.1244228833921 -74.0967480841038 POINT (-74.0967480841038 40.124422883392128) 1
5432 13/06/2019 16:14:34 40.1244228833921 -74.0967480841038 POINT (-74.0967480841038 40.124422883392128) 1
5433 12/06/2019 16:14:34 40.1244228833921 -74.0967480841038 POINT (-74.0967480841038 40.124422883392128) 1
5434 11/06/2019 16:14:34 40.1244228833921 -74.0967480841038 POINT (-74.0967480841038 40.124422883392128) 1
5221 14/06/2019 16:14:34 40.127655146052 -73.9106667566745 POINT (-73.910666756674487 40.127655146052042) 1
5222 13/06/2019 16:14:34 40.127655146052 -73.9106667566745 POINT (-73.910666756674487 40.127655146052042) 1
5223 12/06/2019 16:14:34 40.127655146052 -73.9106667566745 POINT (-73.910666756674487 40.127655146052042) 1
5224 11/06/2019 16:14:34 40.127655146052 -73.9106667566745 POINT (-73.910666756674487 40.127655146052042) 1
5421 14/06/2019 16:14:34 40.1279235960576 -74.0886805313313 POINT (-74.08868053133132 40.127923596057606) 1
5422 13/06/2019 16:14:34 40.1279235960576 -74.0886805313313 POINT (-74.08868053133132 40.127923596057606) 1
5423 12/06/2019 16:14:34 40.1279235960576 -74.0886805313313 POINT (-74.08868053133132 40.127923596057606) 1
5424 11/06/2019 16:14:34 40.1279235960576 -74.0886805313313 POINT (-74.08868053133132 40.127923596057606) 1
5231 14/06/2019 16:14:34 40.1308721421233 -73.918932716477 POINT (-73.918932716477045 40.13087214212328) 1
5232 13/06/2019 16:14:34 40.1308721421233 -73.918932716477 POINT (-73.918932716477045 40.13087214212328) 1
5233 12/06/2019 16:14:34 40.1308721421233 -73.918932716477 POINT (-73.918932716477045 40.13087214212328) 1
5234 11/06/2019 16:14:34 40.1308721421233 -73.918932716477 POINT (-73.918932716477045 40.13087214212328) 1
5411 14/06/2019 16:14:34 40.1311156366514 -74.0803981366358 POINT (-74.080398136635836 40.131115636651366) 1
5412 13/06/2019 16:14:34 40.1311156366514 -74.0803981366358 POINT (-74.080398136635836 40.131115636651366) 1
5413 12/06/2019 16:14:34 40.1311156366514 -74.0803981366358 POINT (-74.080398136635836 40.131115636651366) 1
5414 11/06/2019 16:14:34 40.1311156366514 -74.0803981366358 POINT (-74.080398136635836 40.131115636651366) 1
5241 14/06/2019 16:14:34 40.1337733226225 -73.9273950995621 POINT (-73.9273950995621 40.133773322622467) 1
5242 13/06/2019 16:14:34 40.1337733226225 -73.9273950995621 POINT (-73.9273950995621 40.133773322622467) 1
5243 12/06/2019 16:14:34 40.1337733226225 -73.9273950995621 POINT (-73.9273950995621 40.133773322622467) 1
5244 11/06/2019 16:14:34 40.1337733226225 -73.9273950995621 POINT (-73.9273950995621 40.133773322622467) 1
5401 14/06/2019 16:14:34 40.1339912717127 -74.0719209378814 POINT (-74.071920937881387 40.133991271712652) 1
5402 13/06/2019 16:14:34 40.1339912717127 -74.0719209378814 POINT (-74.071920937881387 40.133991271712652) 1
5403 12/06/2019 16:14:34 40.1339912717127 -74.0719209378814 POINT (-74.071920937881387 40.133991271712652) 1
5404 11/06/2019 16:14:34 40.1339912717127 -74.0719209378814 POINT (-74.071920937881387 40.133991271712652) 1
5251 14/06/2019 16:14:34 40.1363516578974 -73.9360334244253 POINT (-73.9360334244253 40.13635165789735) 1
5252 13/06/2019 16:14:34 40.1363516578974 -73.9360334244253 POINT (-73.9360334244253 40.13635165789735) 1
5253 12/06/2019 16:14:34 40.1363516578974 -73.9360334244253 POINT (-73.9360334244253 40.13635165789735) 1
5254 11/06/2019 16:14:34 40.1363516578974 -73.9360334244253 POINT (-73.9360334244253 40.13635165789735) 1
5391 14/06/2019 16:14:34 40.1365435334158 -74.0632694531001 POINT (-74.063269453100133 40.136543533415811) 1
5392 13/06/2019 16:14:34 40.1365435334158 -74.0632694531001 POINT (-74.063269453100133 40.136543533415811) 1
5393 12/06/2019 16:14:34 40.1365435334158 -74.0632694531001 POINT (-74.063269453100133 40.136543533415811) 1
5394 11/06/2019 16:14:34 40.1365435334158 -74.0632694531001 POINT (-74.063269453100133 40.136543533415811) 1
5261 14/06/2019 16:14:34 40.1386008998059 -73.9448267756848 POINT (-73.944826775684845 40.138600899805908) 1
5262 13/06/2019 16:14:34 40.1386008998059 -73.9448267756848 POINT (-73.944826775684845 40.138600899805908) 1
5263 12/06/2019 16:14:34 40.1386008998059 -73.9448267756848 POINT (-73.944826775684845 40.138600899805908) 1
5264 11/06/2019 16:14:34 40.1386008998059 -73.9448267756848 POINT (-73.944826775684845 40.138600899805908) 1
5381 14/06/2019 16:14:34 40.1387662367477 -74.054464630135 POINT (-74.054464630135 40.1387662367477) 1
5382 13/06/2019 16:14:34 40.1387662367477 -74.054464630135 POINT (-74.054464630135 40.1387662367477) 1
5383 12/06/2019 16:14:34 40.1387662367477 -74.054464630135 POINT (-74.054464630135 40.1387662367477) 1
5384 11/06/2019 16:14:34 40.1387662367477 -74.054464630135 POINT (-74.054464630135 40.1387662367477) 1
5271 14/06/2019 16:14:34 40.1405155971263 -73.9537538554862 POINT (-73.953753855486227 40.1405155971263) 1
5272 13/06/2019 16:14:34 40.1405155971263 -73.9537538554862 POINT (-73.953753855486227 40.1405155971263) 1
5273 12/06/2019 16:14:34 40.1405155971263 -73.9537538554862 POINT (-73.953753855486227 40.1405155971263) 1
5274 11/06/2019 16:14:34 40.1405155971263 -73.9537538554862 POINT (-73.953753855486227 40.1405155971263) 1
5371 14/06/2019 16:14:34 40.1406539947625 -74.0455277951493 POINT (-74.045527795149312 40.140653994762495) 1
5372 13/06/2019 16:14:34 40.1406539947625 -74.0455277951493 POINT (-74.045527795149312 40.140653994762495) 1
5373 12/06/2019 16:14:34 40.1406539947625 -74.0455277951493 POINT (-74.045527795149312 40.140653994762495) 1
5374 11/06/2019 16:14:34 40.1406539947625 -74.0455277951493 POINT (-74.045527795149312 40.140653994762495) 1
5281 14/06/2019 16:14:34 40.1420911090072 -73.9627930359167 POINT (-73.962793035916675 40.142091109007175) 1
5282 13/06/2019 16:14:34 40.1420911090072 -73.9627930359167 POINT (-73.962793035916675 40.142091109007175) 1
5283 12/06/2019 16:14:34 40.1420911090072 -73.9627930359167 POINT (-73.962793035916675 40.142091109007175) 1
5284 11/06/2019 16:14:34 40.1420911090072 -73.9627930359167 POINT (-73.962793035916675 40.142091109007175) 1
5361 14/06/2019 16:14:34 40.1422022318738 -74.0364806001375 POINT (-74.036480600137523 40.142202231873831) 1
5362 13/06/2019 16:14:34 40.1422022318738 -74.0364806001375 POINT (-74.036480600137523 40.142202231873831) 1
5363 12/06/2019 16:14:34 40.1422022318738 -74.0364806001375 POINT (-74.036480600137523 40.142202231873831) 1
5364 11/06/2019 16:14:34 40.1422022318738 -74.0364806001375 POINT (-74.036480600137523 40.142202231873831) 1
5291 14/06/2019 16:14:34 40.1433236164225 -73.9719224122925 POINT (-73.971922412292486 40.1433236164225) 1
5292 13/06/2019 16:14:34 40.1433236164225 -73.9719224122925 POINT (-73.971922412292486 40.1433236164225) 1
5293 12/06/2019 16:14:34 40.1433236164225 -73.9719224122925 POINT (-73.971922412292486 40.1433236164225) 1
5294 11/06/2019 16:14:34 40.1433236164225 -73.9719224122925 POINT (-73.971922412292486 40.1433236164225) 1
5351 14/06/2019 16:14:34 40.1434071951488 -74.0273449695742 POINT (-74.027344969574244 40.143407195148832) 1
5352 13/06/2019 16:14:34 40.1434071951488 -74.0273449695742 POINT (-74.027344969574244 40.143407195148832) 1
5353 12/06/2019 16:14:34 40.1434071951488 -74.0273449695742 POINT (-74.027344969574244 40.143407195148832) 1
5354 11/06/2019 16:14:34 40.1434071951488 -74.0273449695742 POINT (-74.027344969574244 40.143407195148832) 1
5301 14/06/2019 16:14:34 40.144210131601 -73.9811198571789 POINT (-73.981119857178868 40.144210131601) 1
5302 13/06/2019 16:14:34 40.144210131601 -73.9811198571789 POINT (-73.981119857178868 40.144210131601) 1
5303 12/06/2019 16:14:34 40.144210131601 -73.9811198571789 POINT (-73.981119857178868 40.144210131601) 1
5304 11/06/2019 16:14:34 40.144210131601 -73.9811198571789 POINT (-73.981119857178868 40.144210131601) 1
5341 14/06/2019 16:14:34 40.1442659635745 -74.0181430463418 POINT (-74.018143046341834 40.144265963574519) 1
5342 13/06/2019 16:14:34 40.1442659635745 -74.0181430463418 POINT (-74.018143046341834 40.144265963574519) 1
5343 12/06/2019 16:14:34 40.1442659635745 -74.0181430463418 POINT (-74.018143046341834 40.144265963574519) 1
5344 11/06/2019 16:14:34 40.1442659635745 -74.0181430463418 POINT (-74.018143046341834 40.144265963574519) 1
5311 14/06/2019 16:14:34 40.1447485054048 -73.9903630750002 POINT (-73.990363075000232 40.14474850540482) 1
5312 13/06/2019 16:14:34 40.1447485054048 -73.9903630750002 POINT (-73.990363075000232 40.14474850540482) 1
5313 12/06/2019 16:14:34 40.1447485054048 -73.9903630750002 POINT (-73.990363075000232 40.14474850540482) 1
5314 11/06/2019 16:14:34 40.1447485054048 -73.9903630750002 POINT (-73.990363075000232 40.14474850540482) 1
5331 14/06/2019 16:14:34 40.1447764552719 -74.0088971370793 POINT (-74.008897137079273 40.14477645527186) 1
5332 13/06/2019 16:14:34 40.1447764552719 -74.0088971370793 POINT (-74.008897137079273 40.14477645527186) 1
5333 12/06/2019 16:14:34 40.1447764552719 -74.0088971370793 POINT (-74.008897137079273 40.14477645527186) 1
5334 11/06/2019 16:14:34 40.1447764552719 -74.0088971370793 POINT (-74.008897137079273 40.14477645527186) 1
5321 14/06/2019 16:14:34 40.1449374326382 -73.9996296570964 POINT (-73.999629657096449 40.144937432638208) 1
5322 13/06/2019 16:14:34 40.1449374326382 -73.9996296570964 POINT (-73.999629657096449 40.144937432638208) 1
5323 12/06/2019 16:14:34 40.1449374326382 -73.9996296570964 POINT (-73.999629657096449 40.144937432638208) 1
5324 11/06/2019 16:14:34 40.1449374326382 -73.9996296570964 POINT (-73.999629657096449 40.144937432638208) 1
Microsoft SQL Server 2005 XML Showplan
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.481" Build="14.0.3045.24"><BatchSequence><Batch><Statements><StmtSimple StatementText="select *&#xa;from dbo.v_example&#xa;where latlong.STDistance(geography::Point(40,-74,4326)) &lt;=1609.344e1&#xa;and most_recent is not null" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="1583.76" StatementEstRows="21196.9" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x09D1D5A1F18EE1E5" QueryPlanHash="0xAF25ABC554AD29E4" CardinalityEstimationModelVersion="140"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" MemoryGrant="586296" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="56" CompileTime="0" CompileCPU="0" CompileMemory="304"><Warnings><MemoryGrantWarning GrantWarningKind="Excessive Grant" RequestedMemory="586296" GrantedMemory="586296" MaxUsedMemory="15816"></MemoryGrantWarning></Warnings><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="646648" RequiredMemory="512" DesiredMemory="646648" RequestedMemory="586296" GrantWaitTime="0" GrantedMemory="586296" MaxUsedMemory="15816" MaxQueryMemory="586296"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419378" EstimatedPagesCached="26211" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1955448"></OptimizerHardwareDependentProperties><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="296" CpuTime="296"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="21196.9" EstimateIO="0" EstimateCPU="0.00211969" AvgRowSize="4067" EstimatedTotalSubtreeCost="1583.76" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ColumnReference Column="Expr1003"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1003"></ColumnReference><ScalarOperator ScalarString="CASE WHEN [Expr1002]&lt;(5) THEN (1) ELSE NULL END"><IF><Condition><ScalarOperator><Compare CompareOp="LT"><ScalarOperator><Identifier><ColumnReference Column="Expr1002"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="1" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="21196.9" EstimateIO="0" EstimateCPU="129.204" AvgRowSize="4071" EstimatedTotalSubtreeCost="1583.76" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="260" Batches="0" ActualExecutionMode="Row" ActualElapsedms="296" ActualCPUms="296" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="2" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="129000" EstimateIO="0" EstimateCPU="0.01032" AvgRowSize="4071" EstimatedTotalSubtreeCost="1454.55" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="129000" Batches="0" ActualExecutionMode="Row" ActualElapsedms="156" ActualCPUms="156" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><SequenceProject><DefinedValues><DefinedValue><ColumnReference Column="Expr1002"></ColumnReference><ScalarOperator ScalarString="row_number"><Sequence FunctionName="row_number"></Sequence></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="3" PhysicalOp="Segment" LogicalOp="Segment" EstimateRows="129000" EstimateIO="0" EstimateCPU="0.00258" AvgRowSize="4071" EstimatedTotalSubtreeCost="1454.54" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ColumnReference Column="Segment1005"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="129000" Batches="0" ActualExecutionMode="Row" ActualElapsedms="156" ActualCPUms="156" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1005"></ColumnReference></SegmentColumn><RelOp NodeId="4" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="129000" EstimateIO="1452.7" EstimateCPU="0.769326" AvgRowSize="4063" EstimatedTotalSubtreeCost="1454.54" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="129000" Batches="0" ActualExecutionMode="Row" ActualElapsedms="156" ActualCPUms="156" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="586296" OutputMemoryGrant="585912" UsedMemoryGrant="15816"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="129000" EstimateIO="0" EstimateCPU="0.0129" AvgRowSize="4063" EstimatedTotalSubtreeCost="1.06771" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ScalarOperator ScalarString="[fiddle_155b2671a8e843da81a165fb5b86dc46].[dbo].[example].[latlong]"><Identifier><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Clustered Index Scan" LogicalOp="Clustered Index Scan" EstimateRows="129000" EstimatedRowsRead="129000" EstimateIO="0.912755" EstimateCPU="0.142057" AvgRowSize="4063" EstimatedTotalSubtreeCost="1.05481" TableCardinality="129000" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="129000" Batches="0" ActualExecutionMode="Row" ActualElapsedms="15" ActualCPUms="15" ActualScans="1" ActualLogicalReads="1235" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="129000" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="0" ForcedIndex="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Index="[pk_example]" IndexKind="Clustered" Storage="RowStore"></Object></IndexScan></RelOp></ComputeScalar></RelOp></Sort></RelOp></Segment></RelOp></SequenceProject></RelOp><Predicate><ScalarOperator ScalarString="[fiddle_155b2671a8e843da81a165fb5b86dc46].[dbo].[example].[latlong].STDistance([geography]::Point((4.0000000000000000e+001),(-7.4000000000000000e+001),(4326)))&lt;=(1.6093440000000001e+004) AND CASE WHEN [Expr1002]&lt;(5) THEN (1) ELSE NULL END IS NOT NULL"><Logical Operation="AND"><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><UDTMethod><CLRFunction Assembly="Microsoft.SqlServer.Types" Class="Microsoft.SqlServer.Types.SqlGeography" Method="STDistance"></CLRFunction><ScalarOperator><Identifier><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="ConstExpr1004"><ScalarOperator><UDTMethod><CLRFunction Assembly="Microsoft.SqlServer.Types" Class="Microsoft.SqlServer.Types.SqlGeography" Method="Point"></CLRFunction><ScalarOperator><Const ConstValue="(4.0000000000000000e+001)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(-7.4000000000000000e+001)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(4326)"></Const></ScalarOperator></UDTMethod></ScalarOperator></ColumnReference></Identifier></ScalarOperator></UDTMethod></ScalarOperator><ScalarOperator><Const ConstValue="(1.6093440000000001e+004)"></Const></ScalarOperator></Compare></ScalarOperator><ScalarOperator><Compare CompareOp="IS NOT"><ScalarOperator><IF><Condition><ScalarOperator><Compare CompareOp="LT"><ScalarOperator><Identifier><ColumnReference Column="Expr1002"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(5)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Const ConstValue="(1)"></Const></ScalarOperator></Then><Else><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Else></IF></ScalarOperator><ScalarOperator><Const ConstValue="NULL"></Const></ScalarOperator></Compare></ScalarOperator></Logical></ScalarOperator></Predicate></Filter></RelOp></ComputeScalar></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>
example_id transaction_dt latitude longitude latlong
5834 11/06/2019 16:14:34 39.8836979593953 -74.1123744863092 POINT (-74.112374486309164 39.883697959395327)
5193 12/06/2019 16:14:34 40.1161909066071 -73.8872446774006 POINT (-73.887244677400631 40.116190906607088)
5857 08/06/2019 16:14:34 39.875786151413 -74.0970316580654 POINT (-74.0970316580654 39.875786151412953)
5456 09/06/2019 16:14:34 40.1165300877096 -74.1121612064384 POINT (-74.112161206438373 40.116530087709577)
6120 05/06/2019 16:14:34 39.892345584843 -73.8739094010218 POINT (-73.873909401021763 39.892345584842978)
5479 06/06/2019 16:14:34 40.1075136606765 -74.1264886339523 POINT (-74.126488633952292 40.10751366067651)
5811 14/06/2019 16:14:34 39.89272844709 -74.1266405661269 POINT (-74.126640566126937 39.892728447089972)
5247 08/06/2019 16:14:34 40.1337733226225 -73.9273950995621 POINT (-73.9273950995621 40.133773322622467)
5828 07/06/2019 16:14:34 39.8880785347519 -74.1196509469795 POINT (-74.119650946979462 39.888078534751891)
5840 05/06/2019 16:14:34 39.8836979593953 -74.1123744863092 POINT (-74.112374486309164 39.883697959395327)
5425 10/06/2019 16:14:34 40.1279235960576 -74.0886805313313 POINT (-74.08868053133132 40.127923596057606)
5187 08/06/2019 16:14:34 40.1117959294713 -73.8799588167048 POINT (-73.879958816704828 40.11179592947127)
6066 09/06/2019 16:14:34 39.8720052112403 -73.9116517695578 POINT (-73.9116517695578 39.872005211240271)
5293 12/06/2019 16:14:34 40.1433236164225 -73.9719224122925 POINT (-73.971922412292486 40.1433236164225)
5874 11/06/2019 16:14:34 39.8690688229611 -74.080759413171 POINT (-74.080759413171023 39.86906882296109)
5379 06/06/2019 16:14:34 40.1406539947625 -74.0455277951493 POINT (-74.045527795149312 40.140653994762495)
5233 12/06/2019 16:14:34 40.1308721421233 -73.918932716477 POINT (-73.918932716477045 40.13087214212328)
5934 11/06/2019 16:14:34 39.8566662301413 -74.0279619227726 POINT (-74.027961922772647 39.856666230141286)
6020 05/06/2019 16:14:34 39.8593244185206 -73.9546605124076 POINT (-73.954660512407557 39.8593244185206)
5333 12/06/2019 16:14:34 40.1447764552719 -74.0088971370793 POINT (-74.008897137079273 40.14477645527186)
5339 06/06/2019 16:14:34 40.1447764552719 -74.0088971370793 POINT (-74.008897137079273 40.14477645527186)
6080 05/06/2019 16:14:34 39.8754931279851 -73.9036044265936 POINT (-73.903604426593589 39.875493127985109)
5433 12/06/2019 16:14:34 40.1244228833921 -74.0967480841038 POINT (-74.0967480841038 40.124422883392128)
5439 06/06/2019 16:14:34 40.1244228833921 -74.0967480841038 POINT (-74.0967480841038 40.124422883392128)
5974 11/06/2019 16:14:34 39.8552191771366 -73.9911420761936 POINT (-73.99114207619364 39.855219177136561)
5980 05/06/2019 16:14:34 39.8552191771366 -73.9911420761936 POINT (-73.99114207619364 39.855219177136561)
5287 08/06/2019 16:14:34 40.1420911090072 -73.9627930359167 POINT (-73.962793035916675 40.142091109007175)
5880 05/06/2019 16:14:34 39.8690688229611 -74.080759413171 POINT (-74.080759413171023 39.86906882296109)
6126 09/06/2019 16:14:34 39.8972333905517 -73.8671984670204 POINT (-73.867198467020359 39.8972333905517)
5239 06/06/2019 16:14:34 40.1308721421233 -73.918932716477 POINT (-73.918932716477045 40.13087214212328)
5485 10/06/2019 16:14:34 40.1026109522104 -74.1332015704258 POINT (-74.133201570425825 40.102610952210419)
6026 09/06/2019 16:14:34 39.8612045082636 -73.9457573143311 POINT (-73.9457573143311 39.861204508263583)
5917 08/06/2019 16:14:34 39.8594628775953 -74.0460583099265 POINT (-74.046058309926508 39.859462877595327)
5419 06/06/2019 16:14:34 40.1311156366514 -74.0803981366358 POINT (-74.080398136635836 40.131115636651366)
6083 12/06/2019 16:14:34 39.8792805460761 -73.8957880477504 POINT (-73.8957880477504 39.879280546076075)
6060 05/06/2019 16:14:34 39.8688251526908 -73.9199107629876 POINT (-73.919910762987641 39.8688251526908)
5207 08/06/2019 16:14:34 40.1203056275055 -73.8948035632537 POINT (-73.894803563253731 40.120305627505516)
5370 05/06/2019 16:14:34 40.1422022318738 -74.0364806001375 POINT (-74.036480600137523 40.142202231873831)
5184 11/06/2019 16:14:34 40.1117959294713 -73.8799588167048 POINT (-73.879958816704828 40.11179592947127)
5848 07/06/2019 16:14:34 39.879597222123 -74.1048286796057 POINT (-74.104828679605731 39.879597222123031)
5442 13/06/2019 16:14:34 40.1206219786962 -74.1045812863513 POINT (-74.104581286351291 40.120621978696207)
5393 12/06/2019 16:14:34 40.1365435334158 -74.0632694531001 POINT (-74.063269453100133 40.136543533415811)
5256 09/06/2019 16:14:34 40.1363516578974 -73.9360334244253 POINT (-73.9360334244253 40.13635165789735)
5250 05/06/2019 16:14:34 40.1337733226225 -73.9273950995621 POINT (-73.9273950995621 40.133773322622467)
6009 06/06/2019 16:14:34 39.8577825588499 -73.9636722675078 POINT (-73.963672267507846 39.857782558849934)
6109 06/06/2019 16:14:34 39.8877168852471 -73.8809226707491 POINT (-73.880922670749058 39.887716885247116)
5299 06/06/2019 16:14:34 40.1433236164225 -73.9719224122925 POINT (-73.971922412292486 40.1433236164225)
5966 09/06/2019 16:14:34 39.8550589352619 -74.0003704441225 POINT (-74.000370444122524 39.855058935261944)
5376 09/06/2019 16:14:34 40.1406539947625 -74.0455277951493 POINT (-74.045527795149312 40.140653994762495)
6040 05/06/2019 16:14:34 39.8634183261066 -73.9369840009815 POINT (-73.936984000981539 39.863418326106554)
5350 05/06/2019 16:14:34 40.1442659635745 -74.0181430463418 POINT (-74.018143046341834 40.144265963574519)
5276 09/06/2019 16:14:34 40.1405155971263 -73.9537538554862 POINT (-73.953753855486227 40.1405155971263)
5227 08/06/2019 16:14:34 40.127655146052 -73.9106667566745 POINT (-73.910666756674487 40.127655146052042)
5817 08/06/2019 16:14:34 39.89272844709 -74.1266405661269 POINT (-74.126640566126937 39.892728447089972)
5891 14/06/2019 16:14:34 39.8636103097967 -74.0637138411498 POINT (-74.063713841149834 39.863610309796677)
5940 05/06/2019 16:14:34 39.8566662301413 -74.0279619227726 POINT (-74.027961922772647 39.856666230141286)
5399 06/06/2019 16:14:34 40.1365435334158 -74.0632694531001 POINT (-74.063269453100133 40.136543533415811)
5176 09/06/2019 16:14:34 40.1071313366801 -73.872963566699 POINT (-73.872963566698971 40.107131336680133)
5911 14/06/2019 16:14:34 39.8594628775953 -74.0460583099265 POINT (-74.046058309926508 39.859462877595327)
5413 12/06/2019 16:14:34 40.1311156366514 -74.0803981366358 POINT (-74.080398136635836 40.131115636651366)
6089 06/06/2019 16:14:34 39.8792805460761 -73.8957880477504 POINT (-73.8957880477504 39.879280546076075)
5960 05/06/2019 16:14:34 39.8552471360297 -74.0095979252562 POINT (-74.00959792525623 39.855247136029746)
5356 09/06/2019 16:14:34 40.1434071951488 -74.0273449695742 POINT (-74.027344969574244 40.143407195148832)
5319 06/06/2019 16:14:34 40.1447485054048 -73.9903630750002 POINT (-73.990363075000232 40.14474850540482)
5307 08/06/2019 16:14:34 40.144210131601 -73.9811198571789 POINT (-73.981119857178868 40.144210131601)
5270 05/06/2019 16:14:34 40.1386008998059 -73.9448267756848 POINT (-73.944826775684845 40.138600899805908)
5897 08/06/2019 16:14:34 39.8636103097967 -74.0637138411498 POINT (-74.063713841149834 39.863610309796677)
5946 09/06/2019 16:14:34 39.8557833288826 -74.0188024300137 POINT (-74.0188024300137 39.855783328882588)
5997 08/06/2019 16:14:34 39.8565826210426 -73.9727709968065 POINT (-73.972770996806489 39.856582621042584)
6003 12/06/2019 16:14:34 39.8577825588499 -73.9636722675078 POINT (-73.963672267507846 39.857782558849934)
6103 12/06/2019 16:14:34 39.8877168852471 -73.8809226707491 POINT (-73.880922670749058 39.887716885247116)
5213 12/06/2019 16:14:34 40.1241301282421 -73.9026172175202 POINT (-73.902617217520174 40.124130128242136)
5462 13/06/2019 16:14:34 40.1121571192162 -74.1194695358892 POINT (-74.119469535889166 40.112157119216178)
5954 11/06/2019 16:14:34 39.8552471360297 -74.0095979252562 POINT (-74.00959792525623 39.855247136029746)
5313 12/06/2019 16:14:34 40.1447485054048 -73.9903630750002 POINT (-73.990363075000232 40.14474850540482)
5854 11/06/2019 16:14:34 39.875786151413 -74.0970316580654 POINT (-74.0970316580654 39.875786151412953)
5903 12/06/2019 16:14:34 39.8613699277074 -74.0549518674478 POINT (-74.054951867447812 39.861369927707436)
5362 13/06/2019 16:14:34 40.1422022318738 -74.0364806001375 POINT (-74.036480600137523 40.142202231873831)
5336 09/06/2019 16:14:34 40.1447764552719 -74.0088971370793 POINT (-74.008897137079273 40.14477645527186)
6000 05/06/2019 16:14:34 39.8565826210426 -73.9727709968065 POINT (-73.972770996806489 39.856582621042584)
5359 06/06/2019 16:14:34 40.1434071951488 -74.0273449695742 POINT (-74.027344969574244 40.143407195148832)
6023 12/06/2019 16:14:34 39.8612045082636 -73.9457573143311 POINT (-73.9457573143311 39.861204508263583)
5453 12/06/2019 16:14:34 40.1165300877096 -74.1121612064384 POINT (-74.112161206438373 40.116530087709577)
5883 12/06/2019 16:14:34 39.866178658638 -74.0723232353388 POINT (-74.0723232353388 39.86617865863802)
5382 13/06/2019 16:14:34 40.1387662367477 -74.054464630135 POINT (-74.054464630135 40.1387662367477)
6046 09/06/2019 16:14:34 39.8659605704808 -73.9283615947162 POINT (-73.9283615947162 39.865960570480844)
5196 09/06/2019 16:14:34 40.1161909066071 -73.8872446774006 POINT (-73.887244677400631 40.116190906607088)
5860 05/06/2019 16:14:34 39.875786151413 -74.0970316580654 POINT (-74.0970316580654 39.875786151412953)
5405 10/06/2019 16:14:34 40.1339912717127 -74.0719209378814 POINT (-74.071920937881387 40.133991271712652)
6069 06/06/2019 16:14:34 39.8720052112403 -73.9116517695578 POINT (-73.9116517695578 39.872005211240271)
5173 12/06/2019 16:14:34 40.1071313366801 -73.872963566699 POINT (-73.872963566698971 40.107131336680133)
5837 08/06/2019 16:14:34 39.8836979593953 -74.1123744863092 POINT (-74.112374486309164 39.883697959395327)
6092 13/06/2019 16:14:34 39.8833583896531 -73.888221402349 POINT (-73.888221402348975 39.8833583896531)
5476 09/06/2019 16:14:34 40.1075136606765 -74.1264886339523 POINT (-74.126488633952292 40.10751366067651)
5814 11/06/2019 16:14:34 39.89272844709 -74.1266405661269 POINT (-74.126640566126937 39.892728447089972)
5342 13/06/2019 16:14:34 40.1442659635745 -74.0181430463418 POINT (-74.018143046341834 40.144265963574519)
5330 05/06/2019 16:14:34 40.1449374326382 -73.9996296570964 POINT (-73.999629657096449 40.144937432638208)
5923 12/06/2019 16:14:34 39.8578937260205 -74.0370544736288 POINT (-74.037054473628828 39.857893726020514)
6077 08/06/2019 16:14:34 39.8754931279851 -73.9036044265936 POINT (-73.903604426593589 39.875493127985109)
5236 09/06/2019 16:14:34 40.1308721421233 -73.918932716477 POINT (-73.918932716477045 40.13087214212328)
5390 05/06/2019 16:14:34 40.1387662367477 -74.054464630135 POINT (-74.054464630135 40.1387662367477)
6017 08/06/2019 16:14:34 39.8593244185206 -73.9546605124076 POINT (-73.954660512407557 39.8593244185206)
6029 06/06/2019 16:14:34 39.8612045082636 -73.9457573143311 POINT (-73.9457573143311 39.861204508263583)
5296 09/06/2019 16:14:34 40.1433236164225 -73.9719224122925 POINT (-73.971922412292486 40.1433236164225)
5983 12/06/2019 16:14:34 39.8557274780307 -73.9819349131332 POINT (-73.981934913133173 39.855727478030737)
5831 14/06/2019 16:14:34 39.8836979593953 -74.1123744863092 POINT (-74.112374486309164 39.883697959395327)
5482 13/06/2019 16:14:34 40.1026109522104 -74.1332015704258 POINT (-74.133201570425825 40.102610952210419)
5488 07/06/2019 16:14:34 40.1026109522104 -74.1332015704258 POINT (-74.133201570425825 40.102610952210419)
5290 05/06/2019 16:14:34 40.1420911090072 -73.9627930359167 POINT (-73.962793035916675 40.142091109007175)
5877 08/06/2019 16:14:34 39.8690688229611 -74.080759413171 POINT (-74.080759413171023 39.86906882296109)
6123 12/06/2019 16:14:34 39.8972333905517 -73.8671984670204 POINT (-73.867198467020359 39.8972333905517)
5190 05/06/2019 16:14:34 40.1117959294713 -73.8799588167048 POINT (-73.879958816704828 40.11179592947127)
5436 09/06/2019 16:14:34 40.1244228833921 -74.0967480841038 POINT (-74.0967480841038 40.124422883392128)
5977 08/06/2019 16:14:34 39.8552191771366 -73.9911420761936 POINT (-73.99114207619364 39.855219177136561)
5253 12/06/2019 16:14:34 40.1363516578974 -73.9360334244253 POINT (-73.9360334244253 40.13635165789735)
5230 05/06/2019 16:14:34 40.127655146052 -73.9106667566745 POINT (-73.910666756674487 40.127655146052042)
5894 11/06/2019 16:14:34 39.8636103097967 -74.0637138411498 POINT (-74.063713841149834 39.863610309796677)
5396 09/06/2019 16:14:34 40.1365435334158 -74.0632694531001 POINT (-74.063269453100133 40.136543533415811)
5465 10/06/2019 16:14:34 40.1121571192162 -74.1194695358892 POINT (-74.119469535889166 40.112157119216178)
5871 14/06/2019 16:14:34 39.8690688229611 -74.080759413171 POINT (-74.080759413171023 39.86906882296109)
6129 06/06/2019 16:14:34 39.8972333905517 -73.8671984670204 POINT (-73.867198467020359 39.8972333905517)
6057 08/06/2019 16:14:34 39.8688251526908 -73.9199107629876 POINT (-73.919910762987641 39.8688251526908)
6106 09/06/2019 16:14:34 39.8877168852471 -73.8809226707491 POINT (-73.880922670749058 39.887716885247116)
5914 11/06/2019 16:14:34 39.8594628775953 -74.0460583099265 POINT (-74.046058309926508 39.859462877595327)
5920 05/06/2019 16:14:34 39.8594628775953 -74.0460583099265 POINT (-74.046058309926508 39.859462877595327)
5422 13/06/2019 16:14:34 40.1279235960576 -74.0886805313313 POINT (-74.08868053133132 40.127923596057606)
6086 09/06/2019 16:14:34 39.8792805460761 -73.8957880477504 POINT (-73.8957880477504 39.879280546076075)
5322 13/06/2019 16:14:34 40.1449374326382 -73.9996296570964 POINT (-73.999629657096449 40.144937432638208)
5273 12/06/2019 16:14:34 40.1405155971263 -73.9537538554862 POINT (-73.953753855486227 40.1405155971263)
5279 06/06/2019 16:14:34 40.1405155971263 -73.9537538554862 POINT (-73.953753855486227 40.1405155971263)
5820 05/06/2019 16:14:34 39.89272844709 -74.1266405661269 POINT (-74.126640566126937 39.892728447089972)
5937 08/06/2019 16:14:34 39.8566662301413 -74.0279619227726 POINT (-74.027961922772647 39.856666230141286)
5943 12/06/2019 16:14:34 39.8557833288826 -74.0188024300137 POINT (-74.0188024300137 39.855783328882588)
5445 10/06/2019 16:14:34 40.1206219786962 -74.1045812863513 POINT (-74.104581286351291 40.120621978696207)
5986 09/06/2019 16:14:34 39.8557274780307 -73.9819349131332 POINT (-73.981934913133173 39.855727478030737)
5204 11/06/2019 16:14:34 40.1203056275055 -73.8948035632537 POINT (-73.894803563253731 40.120305627505516)
5963 12/06/2019 16:14:34 39.8550589352619 -74.0003704441225 POINT (-74.000370444122524 39.855058935261944)
5373 12/06/2019 16:14:34 40.1406539947625 -74.0455277951493 POINT (-74.045527795149312 40.140653994762495)
6037 08/06/2019 16:14:34 39.8634183261066 -73.9369840009815 POINT (-73.936984000981539 39.863418326106554)
6063 12/06/2019 16:14:34 39.8720052112403 -73.9116517695578 POINT (-73.9116517695578 39.872005211240271)
6112 13/06/2019 16:14:34 39.892345584843 -73.8739094010218 POINT (-73.873909401021763 39.892345584842978)
5259 06/06/2019 16:14:34 40.1363516578974 -73.9360334244253 POINT (-73.9360334244253 40.13635165789735)
5994 11/06/2019 16:14:34 39.8565826210426 -73.9727709968065 POINT (-73.972770996806489 39.856582621042584)
6006 09/06/2019 16:14:34 39.8577825588499 -73.9636722675078 POINT (-73.963672267507846 39.857782558849934)
5353 12/06/2019 16:14:34 40.1434071951488 -74.0273449695742 POINT (-74.027344969574244 40.143407195148832)
5224 11/06/2019 16:14:34 40.127655146052 -73.9106667566745 POINT (-73.910666756674487 40.127655146052042)
5851 14/06/2019 16:14:34 39.875786151413 -74.0970316580654 POINT (-74.0970316580654 39.875786151412953)
5863 12/06/2019 16:14:34 39.8722738799244 -74.089002145372 POINT (-74.089002145371992 39.872273879924428)
5900 05/06/2019 16:14:34 39.8636103097967 -74.0637138411498 POINT (-74.063713841149834 39.863610309796677)
5402 13/06/2019 16:14:34 40.1339912717127 -74.0719209378814 POINT (-74.071920937881387 40.133991271712652)
5210 05/06/2019 16:14:34 40.1203056275055 -73.8948035632537 POINT (-73.894803563253731 40.120305627505516)
5957 08/06/2019 16:14:34 39.8552471360297 -74.0095979252562 POINT (-74.00959792525623 39.855247136029746)
6043 12/06/2019 16:14:34 39.8659605704808 -73.9283615947162 POINT (-73.9283615947162 39.865960570480844)
5416 09/06/2019 16:14:34 40.1311156366514 -74.0803981366358 POINT (-74.080398136635836 40.131115636651366)
5316 09/06/2019 16:14:34 40.1447485054048 -73.9903630750002 POINT (-73.990363075000232 40.14474850540482)
5310 05/06/2019 16:14:34 40.144210131601 -73.9811198571789 POINT (-73.981119857178868 40.144210131601)
5267 08/06/2019 16:14:34 40.1386008998059 -73.9448267756848 POINT (-73.944826775684845 40.138600899805908)
5808 07/06/2019 16:14:34 39.8976365474813 -74.1333265257813 POINT (-74.1333265257813 39.8976365474813)
5216 09/06/2019 16:14:34 40.1241301282421 -73.9026172175202 POINT (-73.902617217520174 40.124130128242136)
5459 06/06/2019 16:14:34 40.1165300877096 -74.1121612064384 POINT (-74.112161206438373 40.116530087709577)
6049 06/06/2019 16:14:34 39.8659605704808 -73.9283615947162 POINT (-73.9283615947162 39.865960570480844)
6100 05/06/2019 16:14:34 39.8833583896531 -73.888221402349 POINT (-73.888221402348975 39.8833583896531)
5431 14/06/2019 16:14:34 40.1244228833921 -74.0967480841038 POINT (-74.0967480841038 40.124422883392128)
6024 11/06/2019 16:14:34 39.8612045082636 -73.9457573143311 POINT (-73.9457573143311 39.861204508263583)
6095 10/06/2019 16:14:34 39.8833583896531 -73.888221402349 POINT (-73.888221402348975 39.8833583896531)
5408 07/06/2019 16:14:34 40.1339912717127 -74.0719209378814 POINT (-74.071920937881387 40.133991271712652)
6072 13/06/2019 16:14:34 39.8754931279851 -73.9036044265936 POINT (-73.903604426593589 39.875493127985109)
5477 08/06/2019 16:14:34 40.1075136606765 -74.1264886339523 POINT (-74.126488633952292 40.10751366067651)
5809 06/06/2019 16:14:34 39.8976365474813 -74.1333265257813 POINT (-74.1333265257813 39.8976365474813)
5454 11/06/2019 16:14:34 40.1165300877096 -74.1121612064384 POINT (-74.112161206438373 40.116530087709577)
6118 07/06/2019 16:14:34 39.892345584843 -73.8739094010218 POINT (-73.873909401021763 39.892345584842978)
5815 10/06/2019 16:14:34 39.89272844709 -74.1266405661269 POINT (-74.126640566126937 39.892728447089972)
5437 08/06/2019 16:14:34 40.1244228833921 -74.0967480841038 POINT (-74.0967480841038 40.124422883392128)
6018 07/06/2019 16:14:34 39.8593244185206 -73.9546605124076 POINT (-73.954660512407557 39.8593244185206)
5199 06/06/2019 16:14:34 40.1161909066071 -73.8872446774006 POINT (-73.887244677400631 40.116190906607088)
5377 08/06/2019 16:14:34 40.1406539947625 -74.0455277951493 POINT (-74.045527795149312 40.140653994762495)
6078 07/06/2019 16:14:34 39.8754931279851 -73.9036044265936 POINT (-73.903604426593589 39.875493127985109)
5886 09/06/2019 16:14:34 39.866178658638 -74.0723232353388 POINT (-74.0723232353388 39.86617865863802)
5391 14/06/2019 16:14:34 40.1365435334158 -74.0632694531001 POINT (-74.063269453100133 40.136543533415811)
5972 13/06/2019 16:14:34 39.8552191771366 -73.9911420761936 POINT (-73.99114207619364 39.855219177136561)
5331 14/06/2019 16:14:34 40.1447764552719 -74.0088971370793 POINT (-74.008897137079273 40.14477645527186)
5245 10/06/2019 16:14:34 40.1337733226225 -73.9273950995621 POINT (-73.9273950995621 40.133773322622467)
6032 13/06/2019 16:14:34 39.8634183261066 -73.9369840009815 POINT (-73.936984000981539 39.863418326106554)
5191 14/06/2019 16:14:34 40.1161909066071 -73.8872446774006 POINT (-73.887244677400631 40.116190906607088)
5185 10/06/2019 16:14:34 40.1117959294713 -73.8799588167048 POINT (-73.879958816704828 40.11179592947127)
5926 09/06/2019 16:14:34 39.8578937260205 -74.0370544736288 POINT (-74.037054473628828 39.857893726020514)
5932 13/06/2019 16:14:34 39.8566662301413 -74.0279619227726 POINT (-74.027961922772647 39.856666230141286)
5291 14/06/2019 16:14:34 40.1433236164225 -73.9719224122925 POINT (-73.971922412292486 40.1433236164225)
5285 10/06/2019 16:14:34 40.1420911090072 -73.9627930359167 POINT (-73.962793035916675 40.142091109007175)
5826 09/06/2019 16:14:34 39.8880785347519 -74.1196509469795 POINT (-74.119650946979462 39.888078534751891)
5832 13/06/2019 16:14:34 39.8836979593953 -74.1123744863092 POINT (-74.112374486309164 39.883697959395327)
5483 12/06/2019 16:14:34 40.1026109522104 -74.1332015704258 POINT (-74.133201570425825 40.102610952210419)
5385 10/06/2019 16:14:34 40.1387662367477 -74.054464630135 POINT (-74.054464630135 40.1387662367477)
5978 07/06/2019 16:14:34 39.8552191771366 -73.9911420761936 POINT (-73.99114207619364 39.855219177136561)
5337 08/06/2019 16:14:34 40.1447764552719 -74.0088971370793 POINT (-74.008897137079273 40.14477645527186)
5878 07/06/2019 16:14:34 39.8690688229611 -74.080759413171 POINT (-74.080759413171023 39.86906882296109)
6124 11/06/2019 16:14:34 39.8972333905517 -73.8671984670204 POINT (-73.867198467020359 39.8972333905517)
5182 13/06/2019 16:14:34 40.1117959294713 -73.8799588167048 POINT (-73.879958816704828 40.11179592947127)
5348 07/06/2019 16:14:34 40.1442659635745 -74.0181430463418 POINT (-74.018143046341834 40.144265963574519)
5846 09/06/2019 16:14:34 39.879597222123 -74.1048286796057 POINT (-74.104828679605731 39.879597222123031)
6107 08/06/2019 16:14:34 39.8877168852471 -73.8809226707491 POINT (-73.880922670749058 39.887716885247116)
5205 10/06/2019 16:14:34 40.1203056275055 -73.8948035632537 POINT (-73.894803563253731 40.120305627505516)
5254 11/06/2019 16:14:34 40.1363516578974 -73.9360334244253 POINT (-73.9360334244253 40.13635165789735)
5231 14/06/2019 16:14:34 40.1308721421233 -73.918932716477 POINT (-73.918932716477045 40.13087214212328)
5468 07/06/2019 16:14:34 40.1121571192162 -74.1194695358892 POINT (-74.119469535889166 40.112157119216178)
5895 10/06/2019 16:14:34 39.8636103097967 -74.0637138411498 POINT (-74.063713841149834 39.863610309796677)
6058 07/06/2019 16:14:34 39.8688251526908 -73.9199107629876 POINT (-73.919910762987641 39.8688251526908)
5823 12/06/2019 16:14:34 39.8880785347519 -74.1196509469795 POINT (-74.119650946979462 39.888078534751891)
5872 13/06/2019 16:14:34 39.8690688229611 -74.080759413171 POINT (-74.080759413171023 39.86906882296109)
5417 08/06/2019 16:14:34 40.1311156366514 -74.0803981366358 POINT (-74.080398136635836 40.131115636651366)
6081 14/06/2019 16:14:34 39.8792805460761 -73.8957880477504 POINT (-73.8957880477504 39.879280546076075)
5274 11/06/2019 16:14:34 40.1405155971263 -73.9537538554862 POINT (-73.953753855486227 40.1405155971263)
5938 07/06/2019 16:14:34 39.8566662301413 -74.0279619227726 POINT (-74.027961922772647 39.856666230141286)
6015 10/06/2019 16:14:34 39.8593244185206 -73.9546605124076 POINT (-73.954660512407557 39.8593244185206)
5225 10/06/2019 16:14:34 40.127655146052 -73.9106667566745 POINT (-73.910666756674487 40.127655146052042)
5889 06/06/2019 16:14:34 39.866178658638 -74.0723232353388 POINT (-74.0723232353388 39.86617865863802)
5397 08/06/2019 16:14:34 40.1365435334158 -74.0632694531001 POINT (-74.063269453100133 40.136543533415811)
6064 11/06/2019 16:14:34 39.8720052112403 -73.9116517695578 POINT (-73.9116517695578 39.872005211240271)
5325 10/06/2019 16:14:34 40.1449374326382 -73.9996296570964 POINT (-73.999629657096449 40.144937432638208)
5866 09/06/2019 16:14:34 39.8722738799244 -74.089002145372 POINT (-74.089002145371992 39.872273879924428)
5915 10/06/2019 16:14:34 39.8594628775953 -74.0460583099265 POINT (-74.046058309926508 39.859462877595327)
5448 07/06/2019 16:14:34 40.1206219786962 -74.1045812863513 POINT (-74.104581286351291 40.120621978696207)
5374 11/06/2019 16:14:34 40.1406539947625 -74.0455277951493 POINT (-74.045527795149312 40.140653994762495)
5989 06/06/2019 16:14:34 39.8557274780307 -73.9819349131332 POINT (-73.981934913133173 39.855727478030737)
6038 07/06/2019 16:14:34 39.8634183261066 -73.9369840009815 POINT (-73.936984000981539 39.863418326106554)
6087 08/06/2019 16:14:34 39.8792805460761 -73.8957880477504 POINT (-73.8957880477504 39.879280546076075)
5354 11/06/2019 16:14:34 40.1434071951488 -74.0273449695742 POINT (-74.027344969574244 40.143407195148832)
5852 13/06/2019 16:14:34 39.875786151413 -74.0970316580654 POINT (-74.0970316580654 39.875786151412953)
6101 14/06/2019 16:14:34 39.8877168852471 -73.8809226707491 POINT (-73.880922670749058 39.887716885247116)
5211 14/06/2019 16:14:34 40.1241301282421 -73.9026172175202 POINT (-73.902617217520174 40.124130128242136)
5317 08/06/2019 16:14:34 40.1447485054048 -73.9903630750002 POINT (-73.990363075000232 40.14474850540482)
5305 10/06/2019 16:14:34 40.144210131601 -73.9811198571789 POINT (-73.981119857178868 40.144210131601)
5909 06/06/2019 16:14:34 39.8613699277074 -74.0549518674478 POINT (-74.054951867447812 39.861369927707436)
5958 07/06/2019 16:14:34 39.8552471360297 -74.0095979252562 POINT (-74.00959792525623 39.855247136029746)
5368 07/06/2019 16:14:34 40.1422022318738 -74.0364806001375 POINT (-74.036480600137523 40.142202231873831)
5995 10/06/2019 16:14:34 39.8565826210426 -73.9727709968065 POINT (-73.972770996806489 39.856582621042584)
6044 11/06/2019 16:14:34 39.8659605704808 -73.9283615947162 POINT (-73.9283615947162 39.865960570480844)
5262 13/06/2019 16:14:34 40.1386008998059 -73.9448267756848 POINT (-73.944826775684845 40.138600899805908)
5268 07/06/2019 16:14:34 40.1386008998059 -73.9448267756848 POINT (-73.944826775684845 40.138600899805908)
5311 14/06/2019 16:14:34 40.1447485054048 -73.9903630750002 POINT (-73.990363075000232 40.14474850540482)
5803 12/06/2019 16:14:34 39.8976365474813 -74.1333265257813 POINT (-74.1333265257813 39.8976365474813)
6052 13/06/2019 16:14:34 39.8688251526908 -73.9199107629876 POINT (-73.919910762987641 39.8688251526908)
5460 05/06/2019 16:14:34 40.1165300877096 -74.1121612064384 POINT (-74.112161206438373 40.116530087709577)
5952 13/06/2019 16:14:34 39.8552471360297 -74.0095979252562 POINT (-74.00959792525623 39.855247136029746)
5411 14/06/2019 16:14:34 40.1311156366514 -74.0803981366358 POINT (-74.080398136635836 40.131115636651366)
6001 14/06/2019 16:14:34 39.8577825588499 -73.9636722675078 POINT (-73.963672267507846 39.857782558849934)
5265 10/06/2019 16:14:34 40.1386008998059 -73.9448267756848 POINT (-73.944826775684845 40.138600899805908)
5858 07/06/2019 16:14:34 39.875786151413 -74.0970316580654 POINT (-74.0970316580654 39.875786151412953)
5929 06/06/2019 16:14:34 39.8578937260205 -74.0370544736288 POINT (-74.037054473628828 39.857893726020514)
5242 13/06/2019 16:14:34 40.1337733226225 -73.9273950995621 POINT (-73.9273950995621 40.133773322622467)
5906 09/06/2019 16:14:34 39.8613699277074 -74.0549518674478 POINT (-74.054951867447812 39.861369927707436)
5219 06/06/2019 16:14:34 40.1241301282421 -73.9026172175202 POINT (-73.902617217520174 40.124130128242136)
5480 05/06/2019 16:14:34 40.1075136606765 -74.1264886339523 POINT (-74.126488633952292 40.10751366067651)
5812 13/06/2019 16:14:34 39.89272844709 -74.1266405661269 POINT (-74.126640566126937 39.892728447089972)
5171 14/06/2019 16:14:34 40.1071313366801 -73.872963566699 POINT (-73.872963566698971 40.107131336680133)
5835 10/06/2019 16:14:34 39.8836979593953 -74.1123744863092 POINT (-74.112374486309164 39.883697959395327)
5428 07/06/2019 16:14:34 40.1279235960576 -74.0886805313313 POINT (-74.08868053133132 40.127923596057606)
5451 14/06/2019 16:14:34 40.1165300877096 -74.1121612064384 POINT (-74.112161206438373 40.116530087709577)
6115 10/06/2019 16:14:34 39.892345584843 -73.8739094010218 POINT (-73.873909401021763 39.892345584842978)
5474 11/06/2019 16:14:34 40.1075136606765 -74.1264886339523 POINT (-74.126488633952292 40.10751366067651)
5188 07/06/2019 16:14:34 40.1117959294713 -73.8799588167048 POINT (-73.879958816704828 40.11179592947127)
5935 10/06/2019 16:14:34 39.8566662301413 -74.0279619227726 POINT (-74.027961922772647 39.856666230141286)
5248 07/06/2019 16:14:34 40.1337733226225 -73.9273950995621 POINT (-73.9273950995621 40.133773322622467)
5875 10/06/2019 16:14:34 39.8690688229611 -74.080759413171 POINT (-74.080759413171023 39.86906882296109)
5969 06/06/2019 16:14:34 39.8550589352619 -74.0003704441225 POINT (-74.000370444122524 39.855058935261944)
5981 14/06/2019 16:14:34 39.8557274780307 -73.9819349131332 POINT (-73.981934913133173 39.855727478030737)
5294 11/06/2019 16:14:34 40.1433236164225 -73.9719224122925 POINT (-73.971922412292486 40.1433236164225)
5282 13/06/2019 16:14:34 40.1420911090072 -73.9627930359167 POINT (-73.962793035916675 40.142091109007175)
5434 11/06/2019 16:14:34 40.1244228833921 -74.0967480841038 POINT (-74.0967480841038 40.124422883392128)
5440 05/06/2019 16:14:34 40.1244228833921 -74.0967480841038 POINT (-74.0967480841038 40.124422883392128)
6021 14/06/2019 16:14:34 39.8612045082636 -73.9457573143311 POINT (-73.9457573143311 39.861204508263583)
5334 11/06/2019 16:14:34 40.1447764552719 -74.0088971370793 POINT (-74.008897137079273 40.14477645527186)
6121 14/06/2019 16:14:34 39.8972333905517 -73.8671984670204 POINT (-73.867198467020359 39.8972333905517)
6127 08/06/2019 16:14:34 39.8972333905517 -73.8671984670204 POINT (-73.867198467020359 39.8972333905517)
5388 07/06/2019 16:14:34 40.1387662367477 -74.054464630135 POINT (-74.054464630135 40.1387662367477)
5975 10/06/2019 16:14:34 39.8552191771366 -73.9911420761936 POINT (-73.99114207619364 39.855219177136561)
5288 07/06/2019 16:14:34 40.1420911090072 -73.9627930359167 POINT (-73.962793035916675 40.142091109007175)
5829 06/06/2019 16:14:34 39.8880785347519 -74.1196509469795 POINT (-74.119650946979462 39.888078534751891)
6075 10/06/2019 16:14:34 39.8754931279851 -73.9036044265936 POINT (-73.903604426593589 39.875493127985109)
5941 14/06/2019 16:14:34 39.8557833288826 -74.0188024300137 POINT (-74.0188024300137 39.855783328882588)
6012 13/06/2019 16:14:34 39.8593244185206 -73.9546605124076 POINT (-73.954660512407557 39.8593244185206)
5869 06/06/2019 16:14:34 39.8722738799244 -74.089002145372 POINT (-74.089002145371992 39.872273879924428)
5918 07/06/2019 16:14:34 39.8594628775953 -74.0460583099265 POINT (-74.046058309926508 39.859462877595327)
5420 05/06/2019 16:14:34 40.1311156366514 -74.0803981366358 POINT (-74.080398136635836 40.131115636651366)
5371 14/06/2019 16:14:34 40.1406539947625 -74.0455277951493 POINT (-74.045527795149312 40.140653994762495)
6035 10/06/2019 16:14:34 39.8634183261066 -73.9369840009815 POINT (-73.936984000981539 39.863418326106554)
6084 11/06/2019 16:14:34 39.8792805460761 -73.8957880477504 POINT (-73.8957880477504 39.879280546076075)
5394 11/06/2019 16:14:34 40.1365435334158 -74.0632694531001 POINT (-74.063269453100133 40.136543533415811)
5208 07/06/2019 16:14:34 40.1203056275055 -73.8948035632537 POINT (-73.894803563253731 40.120305627505516)
5179 06/06/2019 16:14:34 40.1071313366801 -73.872963566699 POINT (-73.872963566698971 40.107131336680133)
5351 14/06/2019 16:14:34 40.1434071951488 -74.0273449695742 POINT (-74.027344969574244 40.143407195148832)
5345 10/06/2019 16:14:34 40.1442659635745 -74.0181430463418 POINT (-74.018143046341834 40.144265963574519)
5843 12/06/2019 16:14:34 39.879597222123 -74.1048286796057 POINT (-74.104828679605731 39.879597222123031)
5328 07/06/2019 16:14:34 40.1449374326382 -73.9996296570964 POINT (-73.999629657096449 40.144937432638208)
5961 14/06/2019 16:14:34 39.8550589352619 -74.0003704441225 POINT (-74.000370444122524 39.855058935261944)
5992 13/06/2019 16:14:34 39.8565826210426 -73.9727709968065 POINT (-73.972770996806489 39.856582621042584)
5302 13/06/2019 16:14:34 40.144210131601 -73.9811198571789 POINT (-73.981119857178868 40.144210131601)
5228 07/06/2019 16:14:34 40.127655146052 -73.9106667566745 POINT (-73.910666756674487 40.127655146052042)
5471 14/06/2019 16:14:34 40.1075136606765 -74.1264886339523 POINT (-74.126488633952292 40.10751366067651)
5892 13/06/2019 16:14:34 39.8636103097967 -74.0637138411498 POINT (-74.063713841149834 39.863610309796677)
5400 05/06/2019 16:14:34 40.1365435334158 -74.0632694531001 POINT (-74.063269453100133 40.136543533415811)
6061 14/06/2019 16:14:34 39.8720052112403 -73.9116517695578 POINT (-73.9116517695578 39.872005211240271)
5202 13/06/2019 16:14:34 40.1203056275055 -73.8948035632537 POINT (-73.894803563253731 40.120305627505516)
5251 14/06/2019 16:14:34 40.1363516578974 -73.9360334244253 POINT (-73.9360334244253 40.13635165789735)
5271 14/06/2019 16:14:34 40.1405155971263 -73.9537538554862 POINT (-73.953753855486227 40.1405155971263)
5912 13/06/2019 16:14:34 39.8594628775953 -74.0460583099265 POINT (-74.046058309926508 39.859462877595327)
5414 11/06/2019 16:14:34 40.1311156366514 -74.0803981366358 POINT (-74.080398136635836 40.131115636651366)
5365 10/06/2019 16:14:34 40.1422022318738 -74.0364806001375 POINT (-74.036480600137523 40.142202231873831)
6041 14/06/2019 16:14:34 39.8659605704808 -73.9283615947162 POINT (-73.9283615947162 39.865960570480844)
5308 07/06/2019 16:14:34 40.144210131601 -73.9811198571789 POINT (-73.981119857178868 40.144210131601)
5222 13/06/2019 16:14:34 40.127655146052 -73.9106667566745 POINT (-73.910666756674487 40.127655146052042)
5898 07/06/2019 16:14:34 39.8636103097967 -74.0637138411498 POINT (-74.063713841149834 39.863610309796677)
6055 10/06/2019 16:14:34 39.8688251526908 -73.9199107629876 POINT (-73.919910762987641 39.8688251526908)
5357 08/06/2019 16:14:34 40.1434071951488 -74.0273449695742 POINT (-74.027344969574244 40.143407195148832)
5849 06/06/2019 16:14:34 39.879597222123 -74.1048286796057 POINT (-74.104828679605731 39.879597222123031)
5855 10/06/2019 16:14:34 39.875786151413 -74.0970316580654 POINT (-74.0970316580654 39.875786151412953)
6098 07/06/2019 16:14:34 39.8833583896531 -73.888221402349 POINT (-73.888221402348975 39.8833583896531)
6104 11/06/2019 16:14:34 39.8877168852471 -73.8809226707491 POINT (-73.880922670749058 39.887716885247116)
5457 08/06/2019 16:14:34 40.1165300877096 -74.1121612064384 POINT (-74.112161206438373 40.116530087709577)
5949 06/06/2019 16:14:34 39.8557833288826 -74.0188024300137 POINT (-74.0188024300137 39.855783328882588)
5955 10/06/2019 16:14:34 39.8552471360297 -74.0095979252562 POINT (-74.00959792525623 39.855247136029746)
5998 07/06/2019 16:14:34 39.8565826210426 -73.9727709968065 POINT (-73.972770996806489 39.856582621042584)
5314 11/06/2019 16:14:34 40.1447485054048 -73.9903630750002 POINT (-73.990363075000232 40.14474850540482)
5806 09/06/2019 16:14:34 39.8976365474813 -74.1333265257813 POINT (-74.1333265257813 39.8976365474813)
5360 05/06/2019 16:14:34 40.1434071951488 -74.0273449695742 POINT (-74.027344969574244 40.143407195148832)
5289 06/06/2019 16:14:34 40.1420911090072 -73.9627930359167 POINT (-73.962793035916675 40.142091109007175)
5953 12/06/2019 16:14:34 39.8552471360297 -74.0095979252562 POINT (-74.00959792525623 39.855247136029746)
5266 09/06/2019 16:14:34 40.1386008998059 -73.9448267756848 POINT (-73.944826775684845 40.138600899805908)
5930 05/06/2019 16:14:34 39.8578937260205 -74.0370544736288 POINT (-74.037054473628828 39.857893726020514)
5383 12/06/2019 16:14:34 40.1387662367477 -74.054464630135 POINT (-74.054464630135 40.1387662367477)
6047 08/06/2019 16:14:34 39.8659605704808 -73.9283615947162 POINT (-73.9283615947162 39.865960570480844)
5243 12/06/2019 16:14:34 40.1337733226225 -73.9273950995621 POINT (-73.9273950995621 40.133773322622467)
5907 08/06/2019 16:14:34 39.8613699277074 -74.0549518674478 POINT (-74.054951867447812 39.861369927707436)
5406 09/06/2019 16:14:34 40.1339912717127 -74.0719209378814 POINT (-74.071920937881387 40.133991271712652)
6070 05/06/2019 16:14:34 39.8720052112403 -73.9116517695578 POINT (-73.9116517695578 39.872005211240271)
5220 05/06/2019 16:14:34 40.1241301282421 -73.9026172175202 POINT (-73.902617217520174 40.124130128242136)
5884 11/06/2019 16:14:34 39.866178658638 -74.0723232353388 POINT (-74.0723232353388 39.86617865863802)
5429 06/06/2019 16:14:34 40.1279235960576 -74.0886805313313 POINT (-74.08868053133132 40.127923596057606)
6093 12/06/2019 16:14:34 39.8833583896531 -73.888221402349 POINT (-73.888221402348975 39.8833583896531)
5197 08/06/2019 16:14:34 40.1161909066071 -73.8872446774006 POINT (-73.887244677400631 40.116190906607088)
5452 13/06/2019 16:14:34 40.1165300877096 -74.1121612064384 POINT (-74.112161206438373 40.116530087709577)
5861 14/06/2019 16:14:34 39.8722738799244 -74.089002145372 POINT (-74.089002145371992 39.872273879924428)
6116 09/06/2019 16:14:34 39.892345584843 -73.8739094010218 POINT (-73.873909401021763 39.892345584842978)
5174 11/06/2019 16:14:34 40.1071313366801 -73.872963566699 POINT (-73.872963566698971 40.107131336680133)
5475 10/06/2019 16:14:34 40.1075136606765 -74.1264886339523 POINT (-74.126488633952292 40.10751366067651)
5838 07/06/2019 16:14:34 39.8836979593953 -74.1123744863092 POINT (-74.112374486309164 39.883697959395327)
5283 12/06/2019 16:14:34 40.1420911090072 -73.9627930359167 POINT (-73.962793035916675 40.142091109007175)
6030 05/06/2019 16:14:34 39.8612045082636 -73.9457573143311 POINT (-73.9457573143311 39.861204508263583)
5924 11/06/2019 16:14:34 39.8578937260205 -74.0370544736288 POINT (-74.037054473628828 39.857893726020514)
5936 09/06/2019 16:14:34 39.8566662301413 -74.0279619227726 POINT (-74.027961922772647 39.856666230141286)
5389 06/06/2019 16:14:34 40.1387662367477 -74.054464630135 POINT (-74.054464630135 40.1387662367477)
5329 06/06/2019 16:14:34 40.1449374326382 -73.9996296570964 POINT (-73.999629657096449 40.144937432638208)
5984 11/06/2019 16:14:34 39.8557274780307 -73.9819349131332 POINT (-73.981934913133173 39.855727478030737)
5343 12/06/2019 16:14:34 40.1442659635745 -74.0181430463418 POINT (-74.018143046341834 40.144265963574519)
5970 05/06/2019 16:14:34 39.8550589352619 -74.0003704441225 POINT (-74.000370444122524 39.855058935261944)
6122 13/06/2019 16:14:34 39.8972333905517 -73.8671984670204 POINT (-73.867198467020359 39.8972333905517)
5237 08/06/2019 16:14:34 40.1308721421233 -73.918932716477 POINT (-73.918932716477045 40.13087214212328)
5830 05/06/2019 16:14:34 39.8880785347519 -74.1196509469795 POINT (-74.119650946979462 39.888078534751891)
6076 09/06/2019 16:14:34 39.8754931279851 -73.9036044265936 POINT (-73.903604426593589 39.875493127985109)
5435 10/06/2019 16:14:34 40.1244228833921 -74.0967480841038 POINT (-74.0967480841038 40.124422883392128)
5976 09/06/2019 16:14:34 39.8552191771366 -73.9911420761936 POINT (-73.99114207619364 39.855219177136561)
5870 05/06/2019 16:14:34 39.8722738799244 -74.089002145372 POINT (-74.089002145371992 39.872273879924428)
5372 13/06/2019 16:14:34 40.1406539947625 -74.0455277951493 POINT (-74.045527795149312 40.140653994762495)
6036 09/06/2019 16:14:34 39.8634183261066 -73.9369840009815 POINT (-73.936984000981539 39.863418326106554)
5893 12/06/2019 16:14:34 39.8636103097967 -74.0637138411498 POINT (-74.063713841149834 39.863610309796677)
5395 10/06/2019 16:14:34 40.1365435334158 -74.0632694531001 POINT (-74.063269453100133 40.136543533415811)
5489 06/06/2019 16:14:34 40.1026109522104 -74.1332015704258 POINT (-74.133201570425825 40.102610952210419)
5821 14/06/2019 16:14:34 39.8880785347519 -74.1196509469795 POINT (-74.119650946979462 39.888078534751891)
5466 09/06/2019 16:14:34 40.1121571192162 -74.1194695358892 POINT (-74.119469535889166 40.112157119216178)
6130 05/06/2019 16:14:34 39.8972333905517 -73.8671984670204 POINT (-73.867198467020359 39.8972333905517)
5203 12/06/2019 16:14:34 40.1203056275055 -73.8948035632537 POINT (-73.894803563253731 40.120305627505516)
5280 05/06/2019 16:14:34 40.1405155971263 -73.9537538554862 POINT (-73.953753855486227 40.1405155971263)
5944 11/06/2019 16:14:34 39.8557833288826 -74.0188024300137 POINT (-74.0188024300137 39.855783328882588)
5446 09/06/2019 16:14:34 40.1206219786962 -74.1045812863513 POINT (-74.104581286351291 40.120621978696207)
5180 05/06/2019 16:14:34 40.1071313366801 -73.872963566699 POINT (-73.872963566698971 40.107131336680133)
5352 13/06/2019 16:14:34 40.1434071951488 -74.0273449695742 POINT (-74.027344969574244 40.143407195148832)
5346 09/06/2019 16:14:34 40.1442659635745 -74.0181430463418 POINT (-74.018143046341834 40.144265963574519)
5303 12/06/2019 16:14:34 40.144210131601 -73.9811198571789 POINT (-73.981119857178868 40.144210131601)
5297 08/06/2019 16:14:34 40.1433236164225 -73.9719224122925 POINT (-73.971922412292486 40.1433236164225)
5844 11/06/2019 16:14:34 39.879597222123 -74.1048286796057 POINT (-74.104828679605731 39.879597222123031)
5323 12/06/2019 16:14:34 40.1449374326382 -73.9996296570964 POINT (-73.999629657096449 40.144937432638208)
5913 12/06/2019 16:14:34 39.8594628775953 -74.0460583099265 POINT (-74.046058309926508 39.859462877595327)
5987 08/06/2019 16:14:34 39.8557274780307 -73.9819349131332 POINT (-73.981934913133173 39.855727478030737)
5472 13/06/2019 16:14:34 40.1075136606765 -74.1264886339523 POINT (-74.126488633952292 40.10751366067651)
5964 11/06/2019 16:14:34 39.8550589352619 -74.0003704441225 POINT (-74.000370444122524 39.855058935261944)
5423 12/06/2019 16:14:34 40.1279235960576 -74.0886805313313 POINT (-74.08868053133132 40.127923596057606)
6013 12/06/2019 16:14:34 39.8593244185206 -73.9546605124076 POINT (-73.954660512407557 39.8593244185206)
5864 11/06/2019 16:14:34 39.8722738799244 -74.089002145372 POINT (-74.089002145371992 39.872273879924428)
5366 09/06/2019 16:14:34 40.1422022318738 -74.0364806001375 POINT (-74.036480600137523 40.142202231873831)
5260 05/06/2019 16:14:34 40.1363516578974 -73.9360334244253 POINT (-73.9360334244253 40.13635165789735)
5223 12/06/2019 16:14:34 40.127655146052 -73.9106667566745 POINT (-73.910666756674487 40.127655146052042)
5415 10/06/2019 16:14:34 40.1311156366514 -74.0803981366358 POINT (-74.080398136635836 40.131115636651366)
5403 12/06/2019 16:14:34 40.1339912717127 -74.0719209378814 POINT (-74.071920937881387 40.133991271712652)
5993 12/06/2019 16:14:34 39.8565826210426 -73.9727709968065 POINT (-73.972770996806489 39.856582621042584)
6007 08/06/2019 16:14:34 39.8577825588499 -73.9636722675078 POINT (-73.963672267507846 39.857782558849934)
6056 09/06/2019 16:14:34 39.8688251526908 -73.9199107629876 POINT (-73.919910762987641 39.8688251526908)
5950 05/06/2019 16:14:34 39.8557833288826 -74.0188024300137 POINT (-74.0188024300137 39.855783328882588)
5956 09/06/2019 16:14:34 39.8552471360297 -74.0095979252562 POINT (-74.00959792525623 39.855247136029746)
5309 06/06/2019 16:14:34 40.144210131601 -73.9811198571789 POINT (-73.981119857178868 40.144210131601)
5801 14/06/2019 16:14:34 39.8976365474813 -74.1333265257813 POINT (-74.1333265257813 39.8976365474813)
5807 08/06/2019 16:14:34 39.8976365474813 -74.1333265257813 POINT (-74.1333265257813 39.8976365474813)
5850 05/06/2019 16:14:34 39.879597222123 -74.1048286796057 POINT (-74.104828679605731 39.879597222123031)
5901 14/06/2019 16:14:34 39.8613699277074 -74.0549518674478 POINT (-74.054951867447812 39.861369927707436)
5409 06/06/2019 16:14:34 40.1339912717127 -74.0719209378814 POINT (-74.071920937881387 40.133991271712652)
6050 05/06/2019 16:14:34 39.8659605704808 -73.9283615947162 POINT (-73.9283615947162 39.865960570480844)
6099 06/06/2019 16:14:34 39.8833583896531 -73.888221402349 POINT (-73.888221402348975 39.8833583896531)
5194 11/06/2019 16:14:34 40.1161909066071 -73.8872446774006 POINT (-73.887244677400631 40.116190906607088)
5455 10/06/2019 16:14:34 40.1165300877096 -74.1121612064384 POINT (-74.112161206438373 40.116530087709577)
6119 06/06/2019 16:14:34 39.892345584843 -73.8739094010218 POINT (-73.873909401021763 39.892345584842978)
5217 08/06/2019 16:14:34 40.1241301282421 -73.9026172175202 POINT (-73.902617217520174 40.124130128242136)
5881 14/06/2019 16:14:34 39.866178658638 -74.0723232353388 POINT (-74.0723232353388 39.86617865863802)
5432 13/06/2019 16:14:34 40.1244228833921 -74.0967480841038 POINT (-74.0967480841038 40.124422883392128)
6096 09/06/2019 16:14:34 39.8833583896531 -73.888221402349 POINT (-73.888221402348975 39.8833583896531)
5478 07/06/2019 16:14:34 40.1075136606765 -74.1264886339523 POINT (-74.126488633952292 40.10751366067651)
5810 05/06/2019 16:14:34 39.8976365474813 -74.1333265257813 POINT (-74.1333265257813 39.8976365474813)
5200 05/06/2019 16:14:34 40.1161909066071 -73.8872446774006 POINT (-73.887244677400631 40.116190906607088)
6113 12/06/2019 16:14:34 39.892345584843 -73.8739094010218 POINT (-73.873909401021763 39.892345584842978)
5887 08/06/2019 16:14:34 39.866178658638 -74.0723232353388 POINT (-74.0723232353388 39.86617865863802)
5426 09/06/2019 16:14:34 40.1279235960576 -74.0886805313313 POINT (-74.08868053133132 40.127923596057606)
5332 13/06/2019 16:14:34 40.1447764552719 -74.0088971370793 POINT (-74.008897137079273 40.14477645527186)
5246 09/06/2019 16:14:34 40.1337733226225 -73.9273950995621 POINT (-73.9273950995621 40.133773322622467)
5234 11/06/2019 16:14:34 40.1308721421233 -73.918932716477 POINT (-73.918932716477045 40.13087214212328)
6067 08/06/2019 16:14:34 39.8720052112403 -73.9116517695578 POINT (-73.9116517695578 39.872005211240271)
6079 06/06/2019 16:14:34 39.8754931279851 -73.9036044265936 POINT (-73.903604426593589 39.875493127985109)
5921 14/06/2019 16:14:34 39.8578937260205 -74.0370544736288 POINT (-74.037054473628828 39.857893726020514)
5933 12/06/2019 16:14:34 39.8566662301413 -74.0279619227726 POINT (-74.027961922772647 39.856666230141286)
5392 13/06/2019 16:14:34 40.1365435334158 -74.0632694531001 POINT (-74.063269453100133 40.136543533415811)
5380 05/06/2019 16:14:34 40.1406539947625 -74.0455277951493 POINT (-74.045527795149312 40.140653994762495)
6019 06/06/2019 16:14:34 39.8593244185206 -73.9546605124076 POINT (-73.954660512407557 39.8593244185206)
5286 09/06/2019 16:14:34 40.1420911090072 -73.9627930359167 POINT (-73.962793035916675 40.142091109007175)
5873 12/06/2019 16:14:34 39.8690688229611 -74.080759413171 POINT (-74.080759413171023 39.86906882296109)
6027 08/06/2019 16:14:34 39.8612045082636 -73.9457573143311 POINT (-73.9457573143311 39.861204508263583)
5186 09/06/2019 16:14:34 40.1117959294713 -73.8799588167048 POINT (-73.879958816704828 40.11179592947127)
5340 05/06/2019 16:14:34 40.1447764552719 -74.0088971370793 POINT (-74.008897137079273 40.14477645527186)
5973 12/06/2019 16:14:34 39.8552191771366 -73.9911420761936 POINT (-73.99114207619364 39.855219177136561)
5240 05/06/2019 16:14:34 40.1308721421233 -73.918932716477 POINT (-73.918932716477045 40.13087214212328)
5486 09/06/2019 16:14:34 40.1026109522104 -74.1332015704258 POINT (-74.133201570425825 40.102610952210419)
5827 08/06/2019 16:14:34 39.8880785347519 -74.1196509469795 POINT (-74.119650946979462 39.888078534751891)
6073 12/06/2019 16:14:34 39.8754931279851 -73.9036044265936 POINT (-73.903604426593589 39.875493127985109)
5927 08/06/2019 16:14:34 39.8578937260205 -74.0370544736288 POINT (-74.037054473628828 39.857893726020514)
5386 09/06/2019 16:14:34 40.1387662367477 -74.054464630135 POINT (-74.054464630135 40.1387662367477)
5206 09/06/2019 16:14:34 40.1203056275055 -73.8948035632537 POINT (-73.894803563253731 40.120305627505516)
5277 08/06/2019 16:14:34 40.1405155971263 -73.9537538554862 POINT (-73.953753855486227 40.1405155971263)
5443 12/06/2019 16:14:34 40.1206219786962 -74.1045812863513 POINT (-74.104581286351291 40.120621978696207)
6059 06/06/2019 16:14:34 39.8688251526908 -73.9199107629876 POINT (-73.919910762987641 39.8688251526908)
5824 11/06/2019 16:14:34 39.8880785347519 -74.1196509469795 POINT (-74.119650946979462 39.888078534751891)
5183 12/06/2019 16:14:34 40.1117959294713 -73.8799588167048 POINT (-73.879958816704828 40.11179592947127)
5847 08/06/2019 16:14:34 39.879597222123 -74.1048286796057 POINT (-74.104828679605731 39.879597222123031)
5867 08/06/2019 16:14:34 39.8722738799244 -74.089002145372 POINT (-74.089002145371992 39.872273879924428)
5369 06/06/2019 16:14:34 40.1422022318738 -74.0364806001375 POINT (-74.036480600137523 40.142202231873831)
6033 12/06/2019 16:14:34 39.8634183261066 -73.9369840009815 POINT (-73.936984000981539 39.863418326106554)
6039 06/06/2019 16:14:34 39.8634183261066 -73.9369840009815 POINT (-73.936984000981539 39.863418326106554)
6110 05/06/2019 16:14:34 39.8877168852471 -73.8809226707491 POINT (-73.880922670749058 39.887716885247116)
5469 06/06/2019 16:14:34 40.1121571192162 -74.1194695358892 POINT (-74.119469535889166 40.112157119216178)
5967 08/06/2019 16:14:34 39.8550589352619 -74.0003704441225 POINT (-74.000370444122524 39.855058935261944)
6010 05/06/2019 16:14:34 39.8577825588499 -73.9636722675078 POINT (-73.963672267507846 39.857782558849934)
6016 09/06/2019 16:14:34 39.8593244185206 -73.9546605124076 POINT (-73.954660512407557 39.8593244185206)
5326 09/06/2019 16:14:34 40.1449374326382 -73.9996296570964 POINT (-73.999629657096449 40.144937432638208)
5249 06/06/2019 16:14:34 40.1337733226225 -73.9273950995621 POINT (-73.9273950995621 40.133773322622467)
5818 07/06/2019 16:14:34 39.89272844709 -74.1266405661269 POINT (-74.126640566126937 39.892728447089972)
5990 05/06/2019 16:14:34 39.8557274780307 -73.9819349131332 POINT (-73.981934913133173 39.855727478030737)
5177 08/06/2019 16:14:34 40.1071313366801 -73.872963566699 POINT (-73.872963566698971 40.107131336680133)
5349 06/06/2019 16:14:34 40.1442659635745 -74.0181430463418 POINT (-74.018143046341834 40.144265963574519)
5300 05/06/2019 16:14:34 40.1433236164225 -73.9719224122925 POINT (-73.971922412292486 40.1433236164225)
5226 09/06/2019 16:14:34 40.127655146052 -73.9106667566745 POINT (-73.910666756674487 40.127655146052042)
5841 14/06/2019 16:14:34 39.879597222123 -74.1048286796057 POINT (-74.104828679605731 39.879597222123031)
5890 05/06/2019 16:14:34 39.866178658638 -74.0723232353388 POINT (-74.0723232353388 39.86617865863802)
5947 08/06/2019 16:14:34 39.8557833288826 -74.0188024300137 POINT (-74.0188024300137 39.855783328882588)
5449 06/06/2019 16:14:34 40.1206219786962 -74.1045812863513 POINT (-74.104581286351291 40.120621978696207)
6053 12/06/2019 16:14:34 39.8688251526908 -73.9199107629876 POINT (-73.919910762987641 39.8688251526908)
6090 05/06/2019 16:14:34 39.8792805460761 -73.8957880477504 POINT (-73.8957880477504 39.879280546076075)
6102 13/06/2019 16:14:34 39.8877168852471 -73.8809226707491 POINT (-73.880922670749058 39.887716885247116)
5320 05/06/2019 16:14:34 40.1447485054048 -73.9903630750002 POINT (-73.990363075000232 40.14474850540482)
5910 05/06/2019 16:14:34 39.8613699277074 -74.0549518674478 POINT (-74.054951867447812 39.861369927707436)
5996 09/06/2019 16:14:34 39.8565826210426 -73.9727709968065 POINT (-73.972770996806489 39.856582621042584)
5306 09/06/2019 16:14:34 40.144210131601 -73.9811198571789 POINT (-73.981119857178868 40.144210131601)
5269 06/06/2019 16:14:34 40.1386008998059 -73.9448267756848 POINT (-73.944826775684845 40.138600899805908)
5257 08/06/2019 16:14:34 40.1363516578974 -73.9360334244253 POINT (-73.9360334244253 40.13635165789735)
5363 12/06/2019 16:14:34 40.1422022318738 -74.0364806001375 POINT (-74.036480600137523 40.142202231873831)
5463 12/06/2019 16:14:34 40.1121571192162 -74.1194695358892 POINT (-74.119469535889166 40.112157119216178)
6004 11/06/2019 16:14:34 39.8577825588499 -73.9636722675078 POINT (-73.963672267507846 39.857782558849934)
5904 11/06/2019 16:14:34 39.8613699277074 -74.0549518674478 POINT (-74.054951867447812 39.861369927707436)
5412 13/06/2019 16:14:34 40.1311156366514 -74.0803981366358 POINT (-74.080398136635836 40.131115636651366)
5263 12/06/2019 16:14:34 40.1386008998059 -73.9448267756848 POINT (-73.944826775684845 40.138600899805908)
5214 11/06/2019 16:14:34 40.1241301282421 -73.9026172175202 POINT (-73.902617217520174 40.124130128242136)
5804 11/06/2019 16:14:34 39.8976365474813 -74.1333265257813 POINT (-74.1333265257813 39.8976365474813)
5218 07/06/2019 16:14:34 40.1241301282421 -73.9026172175202 POINT (-73.902617217520174 40.124130128242136)
5882 13/06/2019 16:14:34 39.866178658638 -74.0723232353388 POINT (-74.0723232353388 39.86617865863802)
5241 14/06/2019 16:14:34 40.1337733226225 -73.9273950995621 POINT (-73.9273950995621 40.133773322622467)
5905 10/06/2019 16:14:34 39.8613699277074 -74.0549518674478 POINT (-74.054951867447812 39.861369927707436)
5172 13/06/2019 16:14:34 40.1071313366801 -73.872963566699 POINT (-73.872963566698971 40.107131336680133)
5836 09/06/2019 16:14:34 39.8836979593953 -74.1123744863092 POINT (-74.112374486309164 39.883697959395327)
5195 10/06/2019 16:14:34 40.1161909066071 -73.8872446774006 POINT (-73.887244677400631 40.116190906607088)
5859 06/06/2019 16:14:34 39.875786151413 -74.0970316580654 POINT (-74.0970316580654 39.875786151412953)
5813 12/06/2019 16:14:34 39.89272844709 -74.1266405661269 POINT (-74.126640566126937 39.892728447089972)
5295 10/06/2019 16:14:34 40.1433236164225 -73.9719224122925 POINT (-73.971922412292486 40.1433236164225)
5473 12/06/2019 16:14:34 40.1075136606765 -74.1264886339523 POINT (-74.126488633952292 40.10751366067651)
5876 09/06/2019 16:14:34 39.8690688229611 -74.080759413171 POINT (-74.080759413171023 39.86906882296109)
5888 07/06/2019 16:14:34 39.866178658638 -74.0723232353388 POINT (-74.0723232353388 39.86617865863802)
5235 10/06/2019 16:14:34 40.1308721421233 -73.918932716477 POINT (-73.918932716477045 40.13087214212328)
6114 11/06/2019 16:14:34 39.892345584843 -73.8739094010218 POINT (-73.873909401021763 39.892345584842978)
5341 14/06/2019 16:14:34 40.1442659635745 -74.0181430463418 POINT (-74.018143046341834 40.144265963574519)
5922 13/06/2019 16:14:34 39.8578937260205 -74.0370544736288 POINT (-74.037054473628828 39.857893726020514)
5427 08/06/2019 16:14:34 40.1279235960576 -74.0886805313313 POINT (-74.08868053133132 40.127923596057606)
5281 14/06/2019 16:14:34 40.1420911090072 -73.9627930359167 POINT (-73.962793035916675 40.142091109007175)
5982 13/06/2019 16:14:34 39.8557274780307 -73.9819349131332 POINT (-73.981934913133173 39.855727478030737)
6068 07/06/2019 16:14:34 39.8720052112403 -73.9116517695578 POINT (-73.9116517695578 39.872005211240271)
5381 14/06/2019 16:14:34 40.1387662367477 -74.054464630135 POINT (-74.054464630135 40.1387662367477)
5387 08/06/2019 16:14:34 40.1387662367477 -74.054464630135 POINT (-74.054464630135 40.1387662367477)
6128 07/06/2019 16:14:34 39.8972333905517 -73.8671984670204 POINT (-73.867198467020359 39.8972333905517)
5481 14/06/2019 16:14:34 40.1026109522104 -74.1332015704258 POINT (-74.133201570425825 40.102610952210419)
5487 08/06/2019 16:14:34 40.1026109522104 -74.1332015704258 POINT (-74.133201570425825 40.102610952210419)
6022 13/06/2019 16:14:34 39.8612045082636 -73.9457573143311 POINT (-73.9457573143311 39.861204508263583)
6028 07/06/2019 16:14:34 39.8612045082636 -73.9457573143311 POINT (-73.9457573143311 39.861204508263583)
5335 10/06/2019 16:14:34 40.1447764552719 -74.0088971370793 POINT (-74.008897137079273 40.14477645527186)
5928 07/06/2019 16:14:34 39.8578937260205 -74.0370544736288 POINT (-74.037054473628828 39.857893726020514)
5189 06/06/2019 16:14:34 40.1117959294713 -73.8799588167048 POINT (-73.879958816704828 40.11179592947127)
6074 11/06/2019 16:14:34 39.8754931279851 -73.9036044265936 POINT (-73.903604426593589 39.875493127985109)
5301 14/06/2019 16:14:34 40.144210131601 -73.9811198571789 POINT (-73.981119857178868 40.144210131601)
5278 07/06/2019 16:14:34 40.1405155971263 -73.9537538554862 POINT (-73.953753855486227 40.1405155971263)
5229 06/06/2019 16:14:34 40.127655146052 -73.9106667566745 POINT (-73.910666756674487 40.127655146052042)
5942 13/06/2019 16:14:34 39.8557833288826 -74.0188024300137 POINT (-74.0188024300137 39.855783328882588)
5444 11/06/2019 16:14:34 40.1206219786962 -74.1045812863513 POINT (-74.104581286351291 40.120621978696207)
5919 06/06/2019 16:14:34 39.8594628775953 -74.0460583099265 POINT (-74.046058309926508 39.859462877595327)
6105 10/06/2019 16:14:34 39.8877168852471 -73.8809226707491 POINT (-73.880922670749058 39.887716885247116)
5470 05/06/2019 16:14:34 40.1121571192162 -74.1194695358892 POINT (-74.119469535889166 40.112157119216178)
5962 13/06/2019 16:14:34 39.8550589352619 -74.0003704441225 POINT (-74.000370444122524 39.855058935261944)
5968 07/06/2019 16:14:34 39.8550589352619 -74.0003704441225 POINT (-74.000370444122524 39.855058935261944)
5321 14/06/2019 16:14:34 40.1449374326382 -73.9996296570964 POINT (-73.999629657096449 40.144937432638208)
5327 08/06/2019 16:14:34 40.1449374326382 -73.9996296570964 POINT (-73.999629657096449 40.144937432638208)
5819 06/06/2019 16:14:34 39.89272844709 -74.1266405661269 POINT (-74.126640566126937 39.892728447089972)
5868 07/06/2019 16:14:34 39.8722738799244 -74.089002145372 POINT (-74.089002145371992 39.872273879924428)
5985 10/06/2019 16:14:34 39.8557274780307 -73.9819349131332 POINT (-73.981934913133173 39.855727478030737)
5991 14/06/2019 16:14:34 39.8565826210426 -73.9727709968065 POINT (-73.972770996806489 39.856582621042584)
6034 11/06/2019 16:14:34 39.8634183261066 -73.9369840009815 POINT (-73.936984000981539 39.863418326106554)
5178 07/06/2019 16:14:34 40.1071313366801 -73.872963566699 POINT (-73.872963566698971 40.107131336680133)
5252 13/06/2019 16:14:34 40.1363516578974 -73.9360334244253 POINT (-73.9360334244253 40.13635165789735)
5842 13/06/2019 16:14:34 39.879597222123 -74.1048286796057 POINT (-74.104828679605731 39.879597222123031)
5421 14/06/2019 16:14:34 40.1279235960576 -74.0886805313313 POINT (-74.08868053133132 40.127923596057606)
6011 14/06/2019 16:14:34 39.8593244185206 -73.9546605124076 POINT (-73.954660512407557 39.8593244185206)
6085 10/06/2019 16:14:34 39.8792805460761 -73.8957880477504 POINT (-73.8957880477504 39.879280546076075)
5201 14/06/2019 16:14:34 40.1203056275055 -73.8948035632537 POINT (-73.894803563253731 40.120305627505516)
6062 13/06/2019 16:14:34 39.8720052112403 -73.9116517695578 POINT (-73.9116517695578 39.872005211240271)
6111 14/06/2019 16:14:34 39.892345584843 -73.8739094010218 POINT (-73.873909401021763 39.892345584842978)
5805 10/06/2019 16:14:34 39.8976365474813 -74.1333265257813 POINT (-74.1333265257813 39.8976365474813)
6042 13/06/2019 16:14:34 39.8659605704808 -73.9283615947162 POINT (-73.9283615947162 39.865960570480844)
6054 11/06/2019 16:14:34 39.8688251526908 -73.9199107629876 POINT (-73.919910762987641 39.8688251526908)
5272 13/06/2019 16:14:34 40.1405155971263 -73.9537538554862 POINT (-73.953753855486227 40.1405155971263)
5899 06/06/2019 16:14:34 39.8636103097967 -74.0637138411498 POINT (-74.063713841149834 39.863610309796677)
5948 07/06/2019 16:14:34 39.8557833288826 -74.0188024300137 POINT (-74.0188024300137 39.855783328882588)
5450 05/06/2019 16:14:34 40.1206219786962 -74.1045812863513 POINT (-74.104581286351291 40.120621978696207)
5401 14/06/2019 16:14:34 40.1339912717127 -74.0719209378814 POINT (-74.071920937881387 40.133991271712652)
5258 07/06/2019 16:14:34 40.1363516578974 -73.9360334244253 POINT (-73.9360334244253 40.13635165789735)
6005 10/06/2019 16:14:34 39.8577825588499 -73.9636722675078 POINT (-73.963672267507846 39.857782558849934)
6091 14/06/2019 16:14:34 39.8833583896531 -73.888221402349 POINT (-73.888221402348975 39.8833583896531)
5209 06/06/2019 16:14:34 40.1203056275055 -73.8948035632537 POINT (-73.894803563253731 40.120305627505516)
5215 10/06/2019 16:14:34 40.1241301282421 -73.9026172175202 POINT (-73.902617217520174 40.124130128242136)
5464 11/06/2019 16:14:34 40.1121571192162 -74.1194695358892 POINT (-74.119469535889166 40.112157119216178)
5458 07/06/2019 16:14:34 40.1165300877096 -74.1121612064384 POINT (-74.112161206438373 40.116530087709577)
5358 07/06/2019 16:14:34 40.1434071951488 -74.0273449695742 POINT (-74.027344969574244 40.143407195148832)
5315 10/06/2019 16:14:34 40.1447485054048 -73.9903630750002 POINT (-73.990363075000232 40.14474850540482)
5856 09/06/2019 16:14:34 39.875786151413 -74.0970316580654 POINT (-74.0970316580654 39.875786151412953)
5364 11/06/2019 16:14:34 40.1422022318738 -74.0364806001375 POINT (-74.036480600137523 40.142202231873831)
5264 11/06/2019 16:14:34 40.1386008998059 -73.9448267756848 POINT (-73.944826775684845 40.138600899805908)
5999 06/06/2019 16:14:34 39.8565826210426 -73.9727709968065 POINT (-73.972770996806489 39.856582621042584)
6097 08/06/2019 16:14:34 39.8833583896531 -73.888221402349 POINT (-73.888221402348975 39.8833583896531)
5384 11/06/2019 16:14:34 40.1387662367477 -74.054464630135 POINT (-74.054464630135 40.1387662367477)
6048 07/06/2019 16:14:34 39.8659605704808 -73.9283615947162 POINT (-73.9283615947162 39.865960570480844)
5407 08/06/2019 16:14:34 40.1339912717127 -74.0719209378814 POINT (-74.071920937881387 40.133991271712652)
6071 14/06/2019 16:14:34 39.8754931279851 -73.9036044265936 POINT (-73.903604426593589 39.875493127985109)
5833 12/06/2019 16:14:34 39.8836979593953 -74.1123744863092 POINT (-74.112374486309164 39.883697959395327)
5931 14/06/2019 16:14:34 39.8566662301413 -74.0279619227726 POINT (-74.027961922772647 39.856666230141286)
5430 05/06/2019 16:14:34 40.1279235960576 -74.0886805313313 POINT (-74.08868053133132 40.127923596057606)
6094 11/06/2019 16:14:34 39.8833583896531 -73.888221402349 POINT (-73.888221402348975 39.8833583896531)
5244 11/06/2019 16:14:34 40.1337733226225 -73.9273950995621 POINT (-73.9273950995621 40.133773322622467)
5908 07/06/2019 16:14:34 39.8613699277074 -74.0549518674478 POINT (-74.054951867447812 39.861369927707436)
6117 08/06/2019 16:14:34 39.892345584843 -73.8739094010218 POINT (-73.873909401021763 39.892345584842978)
5221 14/06/2019 16:14:34 40.127655146052 -73.9106667566745 POINT (-73.910666756674487 40.127655146052042)
5885 10/06/2019 16:14:34 39.866178658638 -74.0723232353388 POINT (-74.0723232353388 39.86617865863802)
5198 07/06/2019 16:14:34 40.1161909066071 -73.8872446774006 POINT (-73.887244677400631 40.116190906607088)
5862 13/06/2019 16:14:34 39.8722738799244 -74.089002145372 POINT (-74.089002145371992 39.872273879924428)
5175 10/06/2019 16:14:34 40.1071313366801 -73.872963566699 POINT (-73.872963566698971 40.107131336680133)
5839 06/06/2019 16:14:34 39.8836979593953 -74.1123744863092 POINT (-74.112374486309164 39.883697959395327)
5816 09/06/2019 16:14:34 39.89272844709 -74.1266405661269 POINT (-74.126640566126937 39.892728447089972)
5378 07/06/2019 16:14:34 40.1406539947625 -74.0455277951493 POINT (-74.045527795149312 40.140653994762495)
5971 14/06/2019 16:14:34 39.8552191771366 -73.9911420761936 POINT (-73.99114207619364 39.855219177136561)
6125 10/06/2019 16:14:34 39.8972333905517 -73.8671984670204 POINT (-73.867198467020359 39.8972333905517)
5284 11/06/2019 16:14:34 40.1420911090072 -73.9627930359167 POINT (-73.962793035916675 40.142091109007175)
5438 07/06/2019 16:14:34 40.1244228833921 -74.0967480841038 POINT (-74.0967480841038 40.124422883392128)
6065 10/06/2019 16:14:34 39.8720052112403 -73.9116517695578 POINT (-73.9116517695578 39.872005211240271)
5344 11/06/2019 16:14:34 40.1442659635745 -74.0181430463418 POINT (-74.018143046341834 40.144265963574519)
6031 14/06/2019 16:14:34 39.8634183261066 -73.9369840009815 POINT (-73.936984000981539 39.863418326106554)
5292 13/06/2019 16:14:34 40.1433236164225 -73.9719224122925 POINT (-73.971922412292486 40.1433236164225)
5879 06/06/2019 16:14:34 39.8690688229611 -74.080759413171 POINT (-74.080759413171023 39.86906882296109)
5192 13/06/2019 16:14:34 40.1161909066071 -73.8872446774006 POINT (-73.887244677400631 40.116190906607088)
5825 10/06/2019 16:14:34 39.8880785347519 -74.1196509469795 POINT (-74.119650946979462 39.888078534751891)
5979 06/06/2019 16:14:34 39.8552191771366 -73.9911420761936 POINT (-73.99114207619364 39.855219177136561)
5338 07/06/2019 16:14:34 40.1447764552719 -74.0088971370793 POINT (-74.008897137079273 40.14477645527186)
5925 10/06/2019 16:14:34 39.8578937260205 -74.0370544736288 POINT (-74.037054473628828 39.857893726020514)
5238 07/06/2019 16:14:34 40.1308721421233 -73.918932716477 POINT (-73.918932716477045 40.13087214212328)
5484 11/06/2019 16:14:34 40.1026109522104 -74.1332015704258 POINT (-74.133201570425825 40.102610952210419)
6025 10/06/2019 16:14:34 39.8612045082636 -73.9457573143311 POINT (-73.9457573143311 39.861204508263583)
5467 08/06/2019 16:14:34 40.1121571192162 -74.1194695358892 POINT (-74.119469535889166 40.112157119216178)
5965 10/06/2019 16:14:34 39.8550589352619 -74.0003704441225 POINT (-74.000370444122524 39.855058935261944)
6108 07/06/2019 16:14:34 39.8877168852471 -73.8809226707491 POINT (-73.880922670749058 39.887716885247116)
5181 14/06/2019 16:14:34 40.1117959294713 -73.8799588167048 POINT (-73.879958816704828 40.11179592947127)
5255 10/06/2019 16:14:34 40.1363516578974 -73.9360334244253 POINT (-73.9360334244253 40.13635165789735)
5845 10/06/2019 16:14:34 39.879597222123 -74.1048286796057 POINT (-74.104828679605731 39.879597222123031)
5418 07/06/2019 16:14:34 40.1311156366514 -74.0803981366358 POINT (-74.080398136635836 40.131115636651366)
6082 13/06/2019 16:14:34 39.8792805460761 -73.8957880477504 POINT (-73.8957880477504 39.879280546076075)
5232 13/06/2019 16:14:34 40.1308721421233 -73.918932716477 POINT (-73.918932716477045 40.13087214212328)
5490 05/06/2019 16:14:34 40.1026109522104 -74.1332015704258 POINT (-74.133201570425825 40.102610952210419)
5822 13/06/2019 16:14:34 39.8880785347519 -74.1196509469795 POINT (-74.119650946979462 39.888078534751891)
5896 09/06/2019 16:14:34 39.8636103097967 -74.0637138411498 POINT (-74.063713841149834 39.863610309796677)
5441 14/06/2019 16:14:34 40.1206219786962 -74.1045812863513 POINT (-74.104581286351291 40.120621978696207)
5304 11/06/2019 16:14:34 40.144210131601 -73.9811198571789 POINT (-73.981119857178868 40.144210131601)
5298 07/06/2019 16:14:34 40.1433236164225 -73.9719224122925 POINT (-73.971922412292486 40.1433236164225)
5375 10/06/2019 16:14:34 40.1406539947625 -74.0455277951493 POINT (-74.045527795149312 40.140653994762495)
5347 08/06/2019 16:14:34 40.1442659635745 -74.0181430463418 POINT (-74.018143046341834 40.144265963574519)
5916 09/06/2019 16:14:34 39.8594628775953 -74.0460583099265 POINT (-74.046058309926508 39.859462877595327)
5424 11/06/2019 16:14:34 40.1279235960576 -74.0886805313313 POINT (-74.08868053133132 40.127923596057606)
6014 11/06/2019 16:14:34 39.8593244185206 -73.9546605124076 POINT (-73.954660512407557 39.8593244185206)
6088 07/06/2019 16:14:34 39.8792805460761 -73.8957880477504 POINT (-73.8957880477504 39.879280546076075)
5324 11/06/2019 16:14:34 40.1449374326382 -73.9996296570964 POINT (-73.999629657096449 40.144937432638208)
5275 10/06/2019 16:14:34 40.1405155971263 -73.9537538554862 POINT (-73.953753855486227 40.1405155971263)
5865 10/06/2019 16:14:34 39.8722738799244 -74.089002145372 POINT (-74.089002145371992 39.872273879924428)
5939 06/06/2019 16:14:34 39.8566662301413 -74.0279619227726 POINT (-74.027961922772647 39.856666230141286)
5447 08/06/2019 16:14:34 40.1206219786962 -74.1045812863513 POINT (-74.104581286351291 40.120621978696207)
5398 07/06/2019 16:14:34 40.1365435334158 -74.0632694531001 POINT (-74.063269453100133 40.136543533415811)
5988 07/06/2019 16:14:34 39.8557274780307 -73.9819349131332 POINT (-73.981934913133173 39.855727478030737)
5212 13/06/2019 16:14:34 40.1241301282421 -73.9026172175202 POINT (-73.902617217520174 40.124130128242136)
5461 14/06/2019 16:14:34 40.1121571192162 -74.1194695358892 POINT (-74.119469535889166 40.112157119216178)
5959 06/06/2019 16:14:34 39.8552471360297 -74.0095979252562 POINT (-74.00959792525623 39.855247136029746)
6008 07/06/2019 16:14:34 39.8577825588499 -73.9636722675078 POINT (-73.963672267507846 39.857782558849934)
5355 10/06/2019 16:14:34 40.1434071951488 -74.0273449695742 POINT (-74.027344969574244 40.143407195148832)
5318 07/06/2019 16:14:34 40.1447485054048 -73.9903630750002 POINT (-73.990363075000232 40.14474850540482)
5945 10/06/2019 16:14:34 39.8557833288826 -74.0188024300137 POINT (-74.0188024300137 39.855783328882588)
5404 11/06/2019 16:14:34 40.1339912717127 -74.0719209378814 POINT (-74.071920937881387 40.133991271712652)
5367 08/06/2019 16:14:34 40.1422022318738 -74.0364806001375 POINT (-74.036480600137523 40.142202231873831)
5802 13/06/2019 16:14:34 39.8976365474813 -74.1333265257813 POINT (-74.1333265257813 39.8976365474813)
6045 10/06/2019 16:14:34 39.8659605704808 -73.9283615947162 POINT (-73.9283615947162 39.865960570480844)
6051 14/06/2019 16:14:34 39.8688251526908 -73.9199107629876 POINT (-73.919910762987641 39.8688251526908)
5261 14/06/2019 16:14:34 40.1386008998059 -73.9448267756848 POINT (-73.944826775684845 40.138600899805908)
6002 13/06/2019 16:14:34 39.8577825588499 -73.9636722675078 POINT (-73.963672267507846 39.857782558849934)
5312 13/06/2019 16:14:34 40.1447485054048 -73.9903630750002 POINT (-73.990363075000232 40.14474850540482)
5853 12/06/2019 16:14:34 39.875786151413 -74.0970316580654 POINT (-74.0970316580654 39.875786151412953)
5902 13/06/2019 16:14:34 39.8613699277074 -74.0549518674478 POINT (-74.054951867447812 39.861369927707436)
5951 14/06/2019 16:14:34 39.8552471360297 -74.0095979252562 POINT (-74.00959792525623 39.855247136029746)
5410 05/06/2019 16:14:34 40.1339912717127 -74.0719209378814 POINT (-74.071920937881387 40.133991271712652)
5361 14/06/2019 16:14:34 40.1422022318738 -74.0364806001375 POINT (-74.036480600137523 40.142202231873831)
Microsoft SQL Server 2005 XML Showplan
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.481" Build="14.0.3045.24"><BatchSequence><Batch><Statements><StmtSimple StatementText="select *&#xa;from dbo.example&#xa;where latlong.STDistance(geography::Point(40,-74,4326)) &lt;=1609.344e1" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="2.02389" StatementEstRows="38700" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0x05C93332229058A6" QueryPlanHash="0x8AA547FB14D68B20" CardinalityEstimationModelVersion="140"><StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false"></StatementSetOptions><QueryPlan DegreeOfParallelism="0" MemoryGrant="1040" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="72" CompileTime="62" CompileCPU="62" CompileMemory="576"><MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="1040" RequiredMemory="1024" DesiredMemory="1040" RequestedMemory="1040" GrantWaitTime="0" GrantedMemory="1040" MaxUsedMemory="352" MaxQueryMemory="586296"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="419378" EstimatedPagesCached="26211" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="1955448"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2019-06-14T17:14:50.20" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_36B12243]" Table="[extended_index_885578193_384000]" Schema="[sys]" Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]"></StatisticsInfo><StatisticsInfo LastUpdate="2019-06-14T17:14:49.83" ModificationCount="0" SamplingPercent="100" Statistics="[s_example]" Table="[extended_index_885578193_384000]" Schema="[sys]" Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]"></StatisticsInfo></OptimizerStatsUsage><TraceFlags IsCompileTime="1"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><TraceFlags IsCompileTime="0"><TraceFlag Value="460" Scope="Global"></TraceFlag><TraceFlag Value="8017" Scope="Global"></TraceFlag></TraceFlags><QueryTimeStats ElapsedTime="47" CpuTime="47"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="38700" EstimateIO="0" EstimateCPU="0.00150131" AvgRowSize="4063" EstimatedTotalSubtreeCost="2.02389" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="650" Batches="0" ActualExecutionMode="Row" ActualElapsedms="31" ActualCPUms="31" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OuterReferences><RelOp NodeId="1" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="359.166" EstimateIO="0" EstimateCPU="3.59166e-005" AvgRowSize="8090" EstimatedTotalSubtreeCost="1.66236" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ScalarOperator ScalarString="[fiddle_155b2671a8e843da81a165fb5b86dc46].[dbo].[example].[latlong]"><Identifier><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="2" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="359.166" EstimateIO="0" EstimateCPU="0.00150131" AvgRowSize="4064" EstimatedTotalSubtreeCost="1.66233" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1290" Batches="0" ActualExecutionMode="Row" ActualElapsedms="15" ActualCPUms="15" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0" WithUnorderedPrefetch="1"><OuterReferences><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="pk0"></ColumnReference><ColumnReference Column="Expr1012"></ColumnReference></OuterReferences><RelOp NodeId="4" PhysicalOp="Hash Match" LogicalOp="Aggregate" EstimateRows="3.59166" EstimateIO="0" EstimateCPU="0.0345788" AvgRowSize="12" EstimatedTotalSubtreeCost="0.632775" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Expr1004"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="pk0"></ColumnReference></OutputList><MemoryFractions Input="1" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1290" Batches="0" ActualExecutionMode="Row" ActualElapsedms="15" ActualCPUms="15" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="1040" OutputMemoryGrant="1040" UsedMemoryGrant="352"></RunTimeCountersPerThread></RunTimeInformation><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1004"></ColumnReference><ScalarOperator ScalarString="MAX([Expr1009])"><Aggregate Distinct="0" AggType="MAX"><ScalarOperator><Identifier><ColumnReference Column="Expr1009"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="pk0"></ColumnReference></HashKeysBuild><RelOp NodeId="5" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="3591.66" EstimateIO="0" EstimateCPU="0.000359166" AvgRowSize="12" EstimatedTotalSubtreeCost="0.598196" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="pk0"></ColumnReference><ColumnReference Column="Expr1009"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1009"></ColumnReference><ScalarOperator ScalarString="[fiddle_155b2671a8e843da81a165fb5b86dc46].[sys].[extended_index_885578193_384000].[Attr]+[Attr]"><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="Attr"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="Attr"></ColumnReference></Identifier></ScalarOperator></Arithmetic></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="6" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="3591.66" EstimateIO="0" EstimateCPU="0.0150131" AvgRowSize="13" EstimatedTotalSubtreeCost="0.597837" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="Attr"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="pk0"></ColumnReference><ColumnReference Column="Attr"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1290" Batches="0" ActualExecutionMode="Row" ActualElapsedms="15" ActualCPUms="15" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0" WithUnorderedPrefetch="1"><OuterReferences><ColumnReference Column="Id"></ColumnReference><ColumnReference Column="LimitId"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference></OuterReferences><RelOp NodeId="8" PhysicalOp="Table-valued function" LogicalOp="Table-valued function" EstimateRows="1000" EstimateIO="0" EstimateCPU="0.00100016" AvgRowSize="18" EstimatedTotalSubtreeCost="0.00100016" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Column="Id"></ColumnReference><ColumnReference Column="Attr"></ColumnReference><ColumnReference Column="LimitId"></ColumnReference></OutputList><MemoryFractions Input="0" Output="0"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1152" Batches="0" ActualExecutionMode="Row" ActualElapsedms="15" ActualCPUms="15" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><TableValuedFunction><DefinedValues><DefinedValue><ColumnReference Column="Id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="Attr"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Column="LimitId"></ColumnReference></DefinedValue></DefinedValues><Object Table="[GeodeticTessellation]"></Object><ParameterList><ScalarOperator ScalarString="[geography]::Point((4.0000000000000000e+001),(-7.4000000000000000e+001),(4326))"><Identifier><ColumnReference Column="ConstExpr1002"><ScalarOperator><UDTMethod><CLRFunction Assembly="Microsoft.SqlServer.Types" Class="Microsoft.SqlServer.Types.SqlGeography" Method="Point"></CLRFunction><ScalarOperator><Const ConstValue="(4.0000000000000000e+001)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(-7.4000000000000000e+001)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(4326)"></Const></ScalarOperator></UDTMethod></ScalarOperator></ColumnReference></Identifier></ScalarOperator><ScalarOperator ScalarString="(768)"><Const ConstValue="(768)"></Const></ScalarOperator><ScalarOperator ScalarString="(9)"><Const ConstValue="(9)"></Const></ScalarOperator><ScalarOperator ScalarString="(1)"><Const ConstValue="(1)"></Const></ScalarOperator><ScalarOperator ScalarString="(1.6093440000000001e+004)"><Const ConstValue="(1.6093440000000001e+004)"></Const></ScalarOperator></ParameterList></TableValuedFunction></RelOp><RelOp NodeId="9" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="3.59166" EstimatedRowsRead="3.59166" EstimateIO="0.003125" EstimateCPU="0.000160951" AvgRowSize="12" EstimatedTotalSubtreeCost="0.581824" TableCardinality="129000" Parallel="0" EstimateRebinds="994.377" EstimateRewinds="4.62341" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="Attr"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="pk0"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1290" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="1152" ActualLogicalReads="2306" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1290" ActualEndOfScans="1152" ActualExecutions="1152"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="Attr"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="pk0"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[sys]" Table="[extended_index_885578193_384000]" Index="[s_example]" TableReferenceId="-1" IndexKind="Spatial" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><StartRange ScanType="GE"><RangeColumns><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="Id"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[Id]"><Identifier><ColumnReference Column="Id"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></StartRange><EndRange ScanType="LE"><RangeColumns><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="Id"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[LimitId]"><Identifier><ColumnReference Column="LimitId"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></EndRange></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp></Hash></RelOp><RelOp NodeId="10" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimatedRowsRead="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="4063" EstimatedTotalSubtreeCost="1.02805" TableCardinality="129000" Parallel="0" EstimateRebinds="358.166" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1290" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualScans="0" ActualLogicalReads="3692" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRowsRead="1290" ActualEndOfScans="0" ActualExecutions="1290"></RunTimeCountersPerThread></RunTimeInformation><IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore"><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Index="[pk_example]" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[fiddle_155b2671a8e843da81a165fb5b86dc46].[sys].[extended_index_885578193_384000].[pk0]"><Identifier><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="pk0"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp><RelOp NodeId="11" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="0.00100138" AvgRowSize="9" EstimatedTotalSubtreeCost="0.360021" Parallel="0" EstimateRebinds="357.631" EstimateRewinds="0.534443" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="650" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualRebinds="1290" ActualRewinds="0" ActualEndOfScans="640" ActualExecutions="1290"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="1"><RelOp NodeId="12" PhysicalOp="Constant Scan" LogicalOp="Constant Scan" EstimateRows="1" EstimateIO="0" EstimateCPU="1.157e-006" AvgRowSize="9" EstimatedTotalSubtreeCost="0.000359323" Parallel="0" EstimateRebinds="0" EstimateRewinds="358.166" EstimatedExecutionMode="Row"><OutputList></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="650" Batches="0" ActualExecutionMode="Row" ActualElapsedms="0" ActualCPUms="0" ActualEndOfScans="0" ActualExecutions="650"></RunTimeCountersPerThread></RunTimeInformation><ConstantScan></ConstantScan></RelOp><Predicate><ScalarOperator ScalarString="CASE WHEN [Expr1004]&gt;(2) THEN SridMatch([fiddle_155b2671a8e843da81a165fb5b86dc46].[dbo].[example].[latlong],[geography]::Point((4.0000000000000000e+001),(-7.4000000000000000e+001),(4326))) ELSE [fiddle_155b2671a8e843da81a165fb5b86dc46].[dbo].[example].[latlong].STDistance([geography]::Point((4.0000000000000000e+001),(-7.4000000000000000e+001),(4326)))&lt;=(1.6093440000000001e+004) END"><IF><Condition><ScalarOperator><Compare CompareOp="GT"><ScalarOperator><Identifier><ColumnReference Column="Expr1004"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Intrinsic FunctionName="SridMatch"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="ConstExpr1002"><ScalarOperator><UDTMethod><CLRFunction Assembly="Microsoft.SqlServer.Types" Class="Microsoft.SqlServer.Types.SqlGeography" Method="Point"></CLRFunction><ScalarOperator><Const ConstValue="(4.0000000000000000e+001)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(-7.4000000000000000e+001)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(4326)"></Const></ScalarOperator></UDTMethod></ScalarOperator></ColumnReference></Identifier></ScalarOperator></Intrinsic></ScalarOperator></Then><Else><ScalarOperator><Compare CompareOp="LE"><ScalarOperator><UDTMethod><CLRFunction Assembly="Microsoft.SqlServer.Types" Class="Microsoft.SqlServer.Types.SqlGeography" Method="STDistance"></CLRFunction><ScalarOperator><Identifier><ColumnReference Database="[fiddle_155b2671a8e843da81a165fb5b86dc46]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Identifier><ColumnReference Column="ConstExpr1002"><ScalarOperator><UDTMethod><CLRFunction Assembly="Microsoft.SqlServer.Types" Class="Microsoft.SqlServer.Types.SqlGeography" Method="Point"></CLRFunction><ScalarOperator><Const ConstValue="(4.0000000000000000e+001)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(-7.4000000000000000e+001)"></Const></ScalarOperator><ScalarOperator><Const ConstValue="(4326)"></Const></ScalarOperator></UDTMethod></ScalarOperator></ColumnReference></Identifier></ScalarOperator></UDTMethod></ScalarOperator><ScalarOperator><Const ConstValue="(1.6093440000000001e+004)"></Const></ScalarOperator></Compare></ScalarOperator></Else></IF></ScalarOperator></Predicate></Filter></RelOp></NestedLoops></RelOp></QueryPlan></StmtSimple></Statements></Batch></BatchSequence></ShowPlanXML>