SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table example
(
     example_id int identity constraint pk_example primary key clustered,
     transaction_dt datetime2 not null,
     latitude float not null,
     longitude float not null,
     latlong as geography::Point(latitude,longitude,4326) persisted not null
)
;with geos as (
    select geo
    from (values(40e),(41),(42),(43),(44)) x(lat)
    cross join (values(-70e),(-71e),(-72e),(-73),(-74)) y(long)
    cross join (values(.0e),(.25),(.5),(.75)) z(offset)
    cross apply (
    select geo=geo.STPointN(row_number() over (order by (select 1)))
    from (select geography::Point(lat+offset,long+offset,4326).STBuffer(1609.344e1)) z(geo)
    cross apply string_split(space(128),' ') _
    )q
)
insert into example
select dateadd(d,-i,sysutcdatetime()),geo.Lat,geo.Long
from geos
cross join (values(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) d(i)
129000 rows affected

create spatial index s_example on example(latlong)
create or alter view dbo.v_example
with schemabinding as
select example_id
      ,transaction_dt
      ,latitude
      ,longitude
      ,latlong
      ,most_recent= iif(row_number() over (partition by latitude,longitude order by transaction_dt desc) < 5,1,null)
from dbo.example;
set statistics xml on;
select *
from dbo.v_example
where latlong.STDistance(geography::Point(40,-74,4326)) <=1609.344e1
and most_recent is not null


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>


set statistics xml on;
select *
from dbo.example
where latlong.STDistance(geography::Point(40,-74,4326)) <=1609.344e1


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>