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
2024-05-06 18:40:36.9467987
39.8550589352619
-74.0003704441225
POINT (-74.000370444122524 39.855058935261944)
1

5962
2024-05-05 18:40:36.9467987
39.8550589352619
-74.0003704441225
POINT (-74.000370444122524 39.855058935261944)
1

5963
2024-05-04 18:40:36.9467987
39.8550589352619
-74.0003704441225
POINT (-74.000370444122524 39.855058935261944)
1

5964
2024-05-03 18:40:36.9467987
39.8550589352619
-74.0003704441225
POINT (-74.000370444122524 39.855058935261944)
1

5971
2024-05-06 18:40:36.9467987
39.8552191771366
-73.9911420761936
POINT (-73.99114207619364 39.855219177136561)
1

5972
2024-05-05 18:40:36.9467987
39.8552191771366
-73.9911420761936
POINT (-73.99114207619364 39.855219177136561)
1

5973
2024-05-04 18:40:36.9467987
39.8552191771366
-73.9911420761936
POINT (-73.99114207619364 39.855219177136561)
1

5974
2024-05-03 18:40:36.9467987
39.8552191771366
-73.9911420761936
POINT (-73.99114207619364 39.855219177136561)
1

5951
2024-05-06 18:40:36.9467987
39.8552471360297
-74.0095979252562
POINT (-74.00959792525623 39.855247136029746)
1

5952
2024-05-05 18:40:36.9467987
39.8552471360297
-74.0095979252562
POINT (-74.00959792525623 39.855247136029746)
1

5953
2024-05-04 18:40:36.9467987
39.8552471360297
-74.0095979252562
POINT (-74.00959792525623 39.855247136029746)
1

5954
2024-05-03 18:40:36.9467987
39.8552471360297
-74.0095979252562
POINT (-74.00959792525623 39.855247136029746)
1

5981
2024-05-06 18:40:36.9467987
39.8557274780307
-73.9819349131332
POINT (-73.981934913133173 39.855727478030737)
1

5982
2024-05-05 18:40:36.9467987
39.8557274780307
-73.9819349131332
POINT (-73.981934913133173 39.855727478030737)
1

5983
2024-05-04 18:40:36.9467987
39.8557274780307
-73.9819349131332
POINT (-73.981934913133173 39.855727478030737)
1

5984
2024-05-03 18:40:36.9467987
39.8557274780307
-73.9819349131332
POINT (-73.981934913133173 39.855727478030737)
1

5941
2024-05-06 18:40:36.9467987
39.8557833288826
-74.0188024300137
POINT (-74.0188024300137 39.855783328882588)
1

5942
2024-05-05 18:40:36.9467987
39.8557833288826
-74.0188024300137
POINT (-74.0188024300137 39.855783328882588)
1

5943
2024-05-04 18:40:36.9467987
39.8557833288826
-74.0188024300137
POINT (-74.0188024300137 39.855783328882588)
1

5944
2024-05-03 18:40:36.9467987
39.8557833288826
-74.0188024300137
POINT (-74.0188024300137 39.855783328882588)
1

5991
2024-05-06 18:40:36.9467987
39.8565826210426
-73.9727709968065
POINT (-73.972770996806489 39.856582621042584)
1

5992
2024-05-05 18:40:36.9467987
39.8565826210426
-73.9727709968065
POINT (-73.972770996806489 39.856582621042584)
1

5993
2024-05-04 18:40:36.9467987
39.8565826210426
-73.9727709968065
POINT (-73.972770996806489 39.856582621042584)
1

5994
2024-05-03 18:40:36.9467987
39.8565826210426
-73.9727709968065
POINT (-73.972770996806489 39.856582621042584)
1

5931
2024-05-06 18:40:36.9467987
39.8566662301413
-74.0279619227726
POINT (-74.027961922772647 39.856666230141286)
1

5932
2024-05-05 18:40:36.9467987
39.8566662301413
-74.0279619227726
POINT (-74.027961922772647 39.856666230141286)
1

5933
2024-05-04 18:40:36.9467987
39.8566662301413
-74.0279619227726
POINT (-74.027961922772647 39.856666230141286)
1

5934
2024-05-03 18:40:36.9467987
39.8566662301413
-74.0279619227726
POINT (-74.027961922772647 39.856666230141286)
1

6001
2024-05-06 18:40:36.9467987
39.8577825588499
-73.9636722675078
POINT (-73.963672267507846 39.857782558849934)
1

6002
2024-05-05 18:40:36.9467987
39.8577825588499
-73.9636722675078
POINT (-73.963672267507846 39.857782558849934)
1

6003
2024-05-04 18:40:36.9467987
39.8577825588499
-73.9636722675078
POINT (-73.963672267507846 39.857782558849934)
1

6004
2024-05-03 18:40:36.9467987
39.8577825588499
-73.9636722675078
POINT (-73.963672267507846 39.857782558849934)
1

5921
2024-05-06 18:40:36.9467987
39.8578937260205
-74.0370544736288
POINT (-74.037054473628828 39.857893726020514)
1

5922
2024-05-05 18:40:36.9467987
39.8578937260205
-74.0370544736288
POINT (-74.037054473628828 39.857893726020514)
1

5923
2024-05-04 18:40:36.9467987
39.8578937260205
-74.0370544736288
POINT (-74.037054473628828 39.857893726020514)
1

5924
2024-05-03 18:40:36.9467987
39.8578937260205
-74.0370544736288
POINT (-74.037054473628828 39.857893726020514)
1

6011
2024-05-06 18:40:36.9467987
39.8593244185206
-73.9546605124076
POINT (-73.954660512407557 39.8593244185206)
1

6012
2024-05-05 18:40:36.9467987
39.8593244185206
-73.9546605124076
POINT (-73.954660512407557 39.8593244185206)
1

6013
2024-05-04 18:40:36.9467987
39.8593244185206
-73.9546605124076
POINT (-73.954660512407557 39.8593244185206)
1

6014
2024-05-03 18:40:36.9467987
39.8593244185206
-73.9546605124076
POINT (-73.954660512407557 39.8593244185206)
1

5911
2024-05-06 18:40:36.9467987
39.8594628775953
-74.0460583099265
POINT (-74.046058309926508 39.859462877595327)
1

5912
2024-05-05 18:40:36.9467987
39.8594628775953
-74.0460583099265
POINT (-74.046058309926508 39.859462877595327)
1

5913
2024-05-04 18:40:36.9467987
39.8594628775953
-74.0460583099265
POINT (-74.046058309926508 39.859462877595327)
1

5914
2024-05-03 18:40:36.9467987
39.8594628775953
-74.0460583099265
POINT (-74.046058309926508 39.859462877595327)
1

6021
2024-05-06 18:40:36.9467987
39.8612045082636
-73.9457573143311
POINT (-73.9457573143311 39.861204508263583)
1

6022
2024-05-05 18:40:36.9467987
39.8612045082636
-73.9457573143311
POINT (-73.9457573143311 39.861204508263583)
1

6023
2024-05-04 18:40:36.9467987
39.8612045082636
-73.9457573143311
POINT (-73.9457573143311 39.861204508263583)
1

6024
2024-05-03 18:40:36.9467987
39.8612045082636
-73.9457573143311
POINT (-73.9457573143311 39.861204508263583)
1

5901
2024-05-06 18:40:36.9467987
39.8613699277074
-74.0549518674478
POINT (-74.054951867447812 39.861369927707436)
1

5902
2024-05-05 18:40:36.9467987
39.8613699277074
-74.0549518674478
POINT (-74.054951867447812 39.861369927707436)
1

5903
2024-05-04 18:40:36.9467987
39.8613699277074
-74.0549518674478
POINT (-74.054951867447812 39.861369927707436)
1

5904
2024-05-03 18:40:36.9467987
39.8613699277074
-74.0549518674478
POINT (-74.054951867447812 39.861369927707436)
1

6031
2024-05-06 18:40:36.9467987
39.8634183261066
-73.9369840009815
POINT (-73.936984000981539 39.863418326106554)
1

6032
2024-05-05 18:40:36.9467987
39.8634183261066
-73.9369840009815
POINT (-73.936984000981539 39.863418326106554)
1

6033
2024-05-04 18:40:36.9467987
39.8634183261066
-73.9369840009815
POINT (-73.936984000981539 39.863418326106554)
1

6034
2024-05-03 18:40:36.9467987
39.8634183261066
-73.9369840009815
POINT (-73.936984000981539 39.863418326106554)
1

5891
2024-05-06 18:40:36.9467987
39.8636103097967
-74.0637138411498
POINT (-74.063713841149834 39.863610309796677)
1

5892
2024-05-05 18:40:36.9467987
39.8636103097967
-74.0637138411498
POINT (-74.063713841149834 39.863610309796677)
1

5893
2024-05-04 18:40:36.9467987
39.8636103097967
-74.0637138411498
POINT (-74.063713841149834 39.863610309796677)
1

5894
2024-05-03 18:40:36.9467987
39.8636103097967
-74.0637138411498
POINT (-74.063713841149834 39.863610309796677)
1

6041
2024-05-06 18:40:36.9467987
39.8659605704808
-73.9283615947162
POINT (-73.9283615947162 39.865960570480844)
1

6042
2024-05-05 18:40:36.9467987
39.8659605704808
-73.9283615947162
POINT (-73.9283615947162 39.865960570480844)
1

6043
2024-05-04 18:40:36.9467987
39.8659605704808
-73.9283615947162
POINT (-73.9283615947162 39.865960570480844)
1

6044
2024-05-03 18:40:36.9467987
39.8659605704808
-73.9283615947162
POINT (-73.9283615947162 39.865960570480844)
1

5881
2024-05-06 18:40:36.9467987
39.866178658638
-74.0723232353388
POINT (-74.0723232353388 39.86617865863802)
1

5882
2024-05-05 18:40:36.9467987
39.866178658638
-74.0723232353388
POINT (-74.0723232353388 39.86617865863802)
1

5883
2024-05-04 18:40:36.9467987
39.866178658638
-74.0723232353388
POINT (-74.0723232353388 39.86617865863802)
1

5884
2024-05-03 18:40:36.9467987
39.866178658638
-74.0723232353388
POINT (-74.0723232353388 39.86617865863802)
1

6051
2024-05-06 18:40:36.9467987
39.8688251526908
-73.9199107629876
POINT (-73.919910762987641 39.8688251526908)
1

6052
2024-05-05 18:40:36.9467987
39.8688251526908
-73.9199107629876
POINT (-73.919910762987641 39.8688251526908)
1

6053
2024-05-04 18:40:36.9467987
39.8688251526908
-73.9199107629876
POINT (-73.919910762987641 39.8688251526908)
1

6054
2024-05-03 18:40:36.9467987
39.8688251526908
-73.9199107629876
POINT (-73.919910762987641 39.8688251526908)
1

5871
2024-05-06 18:40:36.9467987
39.8690688229611
-74.080759413171
POINT (-74.080759413171023 39.86906882296109)
1

5872
2024-05-05 18:40:36.9467987
39.8690688229611
-74.080759413171
POINT (-74.080759413171023 39.86906882296109)
1

5873
2024-05-04 18:40:36.9467987
39.8690688229611
-74.080759413171
POINT (-74.080759413171023 39.86906882296109)
1

5874
2024-05-03 18:40:36.9467987
39.8690688229611
-74.080759413171
POINT (-74.080759413171023 39.86906882296109)
1

6061
2024-05-06 18:40:36.9467987
39.8720052112403
-73.9116517695578
POINT (-73.9116517695578 39.872005211240271)
1

6062
2024-05-05 18:40:36.9467987
39.8720052112403
-73.9116517695578
POINT (-73.9116517695578 39.872005211240271)
1

6063
2024-05-04 18:40:36.9467987
39.8720052112403
-73.9116517695578
POINT (-73.9116517695578 39.872005211240271)
1

6064
2024-05-03 18:40:36.9467987
39.8720052112403
-73.9116517695578
POINT (-73.9116517695578 39.872005211240271)
1

5861
2024-05-06 18:40:36.9467987
39.8722738799244
-74.089002145372
POINT (-74.089002145371992 39.872273879924428)
1

5862
2024-05-05 18:40:36.9467987
39.8722738799244
-74.089002145372
POINT (-74.089002145371992 39.872273879924428)
1

5863
2024-05-04 18:40:36.9467987
39.8722738799244
-74.089002145372
POINT (-74.089002145371992 39.872273879924428)
1

5864
2024-05-03 18:40:36.9467987
39.8722738799244
-74.089002145372
POINT (-74.089002145371992 39.872273879924428)
1

6071
2024-05-06 18:40:36.9467987
39.8754931279851
-73.9036044265936
POINT (-73.903604426593589 39.875493127985109)
1

6072
2024-05-05 18:40:36.9467987
39.8754931279851
-73.9036044265936
POINT (-73.903604426593589 39.875493127985109)
1

6073
2024-05-04 18:40:36.9467987
39.8754931279851
-73.9036044265936
POINT (-73.903604426593589 39.875493127985109)
1

6074
2024-05-03 18:40:36.9467987
39.8754931279851
-73.9036044265936
POINT (-73.903604426593589 39.875493127985109)
1

5851
2024-05-06 18:40:36.9467987
39.875786151413
-74.0970316580654
POINT (-74.0970316580654 39.875786151412953)
1

5852
2024-05-05 18:40:36.9467987
39.875786151413
-74.0970316580654
POINT (-74.0970316580654 39.875786151412953)
1

5853
2024-05-04 18:40:36.9467987
39.875786151413
-74.0970316580654
POINT (-74.0970316580654 39.875786151412953)
1

5854
2024-05-03 18:40:36.9467987
39.875786151413
-74.0970316580654
POINT (-74.0970316580654 39.875786151412953)
1

6081
2024-05-06 18:40:36.9467987
39.8792805460761
-73.8957880477504
POINT (-73.8957880477504 39.879280546076075)
1

6082
2024-05-05 18:40:36.9467987
39.8792805460761
-73.8957880477504
POINT (-73.8957880477504 39.879280546076075)
1

6083
2024-05-04 18:40:36.9467987
39.8792805460761
-73.8957880477504
POINT (-73.8957880477504 39.879280546076075)
1

6084
2024-05-03 18:40:36.9467987
39.8792805460761
-73.8957880477504
POINT (-73.8957880477504 39.879280546076075)
1

5841
2024-05-06 18:40:36.9467987
39.879597222123
-74.1048286796057
POINT (-74.104828679605731 39.879597222123031)
1

5842
2024-05-05 18:40:36.9467987
39.879597222123
-74.1048286796057
POINT (-74.104828679605731 39.879597222123031)
1

5843
2024-05-04 18:40:36.9467987
39.879597222123
-74.1048286796057
POINT (-74.104828679605731 39.879597222123031)
1

5844
2024-05-03 18:40:36.9467987
39.879597222123
-74.1048286796057
POINT (-74.104828679605731 39.879597222123031)
1

6091
2024-05-06 18:40:36.9467987
39.8833583896531
-73.888221402349
POINT (-73.888221402348975 39.8833583896531)
1

6092
2024-05-05 18:40:36.9467987
39.8833583896531
-73.888221402349
POINT (-73.888221402348975 39.8833583896531)
1

6093
2024-05-04 18:40:36.9467987
39.8833583896531
-73.888221402349
POINT (-73.888221402348975 39.8833583896531)
1

6094
2024-05-03 18:40:36.9467987
39.8833583896531
-73.888221402349
POINT (-73.888221402348975 39.8833583896531)
1

5831
2024-05-06 18:40:36.9467987
39.8836979593953
-74.1123744863092
POINT (-74.112374486309164 39.883697959395327)
1

5832
2024-05-05 18:40:36.9467987
39.8836979593953
-74.1123744863092
POINT (-74.112374486309164 39.883697959395327)
1

5833
2024-05-04 18:40:36.9467987
39.8836979593953
-74.1123744863092
POINT (-74.112374486309164 39.883697959395327)
1

5834
2024-05-03 18:40:36.9467987
39.8836979593953
-74.1123744863092
POINT (-74.112374486309164 39.883697959395327)
1

6101
2024-05-06 18:40:36.9467987
39.8877168852471
-73.8809226707491
POINT (-73.880922670749058 39.887716885247116)
1

6102
2024-05-05 18:40:36.9467987
39.8877168852471
-73.8809226707491
POINT (-73.880922670749058 39.887716885247116)
1

6103
2024-05-04 18:40:36.9467987
39.8877168852471
-73.8809226707491
POINT (-73.880922670749058 39.887716885247116)
1

6104
2024-05-03 18:40:36.9467987
39.8877168852471
-73.8809226707491
POINT (-73.880922670749058 39.887716885247116)
1

5821
2024-05-06 18:40:36.9467987
39.8880785347519
-74.1196509469795
POINT (-74.119650946979462 39.888078534751891)
1

5822
2024-05-05 18:40:36.9467987
39.8880785347519
-74.1196509469795
POINT (-74.119650946979462 39.888078534751891)
1

5823
2024-05-04 18:40:36.9467987
39.8880785347519
-74.1196509469795
POINT (-74.119650946979462 39.888078534751891)
1

5824
2024-05-03 18:40:36.9467987
39.8880785347519
-74.1196509469795
POINT (-74.119650946979462 39.888078534751891)
1

6111
2024-05-06 18:40:36.9467987
39.892345584843
-73.8739094010218
POINT (-73.873909401021763 39.892345584842978)
1

6112
2024-05-05 18:40:36.9467987
39.892345584843
-73.8739094010218
POINT (-73.873909401021763 39.892345584842978)
1

6113
2024-05-04 18:40:36.9467987
39.892345584843
-73.8739094010218
POINT (-73.873909401021763 39.892345584842978)
1

6114
2024-05-03 18:40:36.9467987
39.892345584843
-73.8739094010218
POINT (-73.873909401021763 39.892345584842978)
1

5811
2024-05-06 18:40:36.9467987
39.89272844709
-74.1266405661269
POINT (-74.126640566126937 39.892728447089972)
1

5812
2024-05-05 18:40:36.9467987
39.89272844709
-74.1266405661269
POINT (-74.126640566126937 39.892728447089972)
1

5813
2024-05-04 18:40:36.9467987
39.89272844709
-74.1266405661269
POINT (-74.126640566126937 39.892728447089972)
1

5814
2024-05-03 18:40:36.9467987
39.89272844709
-74.1266405661269
POINT (-74.126640566126937 39.892728447089972)
1

6121
2024-05-06 18:40:36.9467987
39.8972333905517
-73.8671984670204
POINT (-73.867198467020359 39.8972333905517)
1

6122
2024-05-05 18:40:36.9467987
39.8972333905517
-73.8671984670204
POINT (-73.867198467020359 39.8972333905517)
1

6123
2024-05-04 18:40:36.9467987
39.8972333905517
-73.8671984670204
POINT (-73.867198467020359 39.8972333905517)
1

6124
2024-05-03 18:40:36.9467987
39.8972333905517
-73.8671984670204
POINT (-73.867198467020359 39.8972333905517)
1

5801
2024-05-06 18:40:36.9467987
39.8976365474813
-74.1333265257813
POINT (-74.1333265257813 39.8976365474813)
1

5802
2024-05-05 18:40:36.9467987
39.8976365474813
-74.1333265257813
POINT (-74.1333265257813 39.8976365474813)
1

5803
2024-05-04 18:40:36.9467987
39.8976365474813
-74.1333265257813
POINT (-74.1333265257813 39.8976365474813)
1

5804
2024-05-03 18:40:36.9467987
39.8976365474813
-74.1333265257813
POINT (-74.1333265257813 39.8976365474813)
1

5481
2024-05-06 18:40:36.9467987
40.1026109522104
-74.1332015704258
POINT (-74.133201570425825 40.102610952210419)
1

5482
2024-05-05 18:40:36.9467987
40.1026109522104
-74.1332015704258
POINT (-74.133201570425825 40.102610952210419)
1

5483
2024-05-04 18:40:36.9467987
40.1026109522104
-74.1332015704258
POINT (-74.133201570425825 40.102610952210419)
1

5484
2024-05-03 18:40:36.9467987
40.1026109522104
-74.1332015704258
POINT (-74.133201570425825 40.102610952210419)
1

5171
2024-05-06 18:40:36.9467987
40.1071313366801
-73.872963566699
POINT (-73.872963566698971 40.107131336680133)
1

5172
2024-05-05 18:40:36.9467987
40.1071313366801
-73.872963566699
POINT (-73.872963566698971 40.107131336680133)
1

5173
2024-05-04 18:40:36.9467987
40.1071313366801
-73.872963566699
POINT (-73.872963566698971 40.107131336680133)
1

5174
2024-05-03 18:40:36.9467987
40.1071313366801
-73.872963566699
POINT (-73.872963566698971 40.107131336680133)
1

5471
2024-05-06 18:40:36.9467987
40.1075136606765
-74.1264886339523
POINT (-74.126488633952292 40.10751366067651)
1

5472
2024-05-05 18:40:36.9467987
40.1075136606765
-74.1264886339523
POINT (-74.126488633952292 40.10751366067651)
1

5473
2024-05-04 18:40:36.9467987
40.1075136606765
-74.1264886339523
POINT (-74.126488633952292 40.10751366067651)
1

5474
2024-05-03 18:40:36.9467987
40.1075136606765
-74.1264886339523
POINT (-74.126488633952292 40.10751366067651)
1

5181
2024-05-06 18:40:36.9467987
40.1117959294713
-73.8799588167048
POINT (-73.879958816704828 40.11179592947127)
1

5182
2024-05-05 18:40:36.9467987
40.1117959294713
-73.8799588167048
POINT (-73.879958816704828 40.11179592947127)
1

5183
2024-05-04 18:40:36.9467987
40.1117959294713
-73.8799588167048
POINT (-73.879958816704828 40.11179592947127)
1

5184
2024-05-03 18:40:36.9467987
40.1117959294713
-73.8799588167048
POINT (-73.879958816704828 40.11179592947127)
1

5461
2024-05-06 18:40:36.9467987
40.1121571192162
-74.1194695358892
POINT (-74.119469535889166 40.112157119216178)
1

5462
2024-05-05 18:40:36.9467987
40.1121571192162
-74.1194695358892
POINT (-74.119469535889166 40.112157119216178)
1

5463
2024-05-04 18:40:36.9467987
40.1121571192162
-74.1194695358892
POINT (-74.119469535889166 40.112157119216178)
1

5464
2024-05-03 18:40:36.9467987
40.1121571192162
-74.1194695358892
POINT (-74.119469535889166 40.112157119216178)
1

5191
2024-05-06 18:40:36.9467987
40.1161909066071
-73.8872446774006
POINT (-73.887244677400631 40.116190906607088)
1

5192
2024-05-05 18:40:36.9467987
40.1161909066071
-73.8872446774006
POINT (-73.887244677400631 40.116190906607088)
1

5193
2024-05-04 18:40:36.9467987
40.1161909066071
-73.8872446774006
POINT (-73.887244677400631 40.116190906607088)
1

5194
2024-05-03 18:40:36.9467987
40.1161909066071
-73.8872446774006
POINT (-73.887244677400631 40.116190906607088)
1

5451
2024-05-06 18:40:36.9467987
40.1165300877096
-74.1121612064384
POINT (-74.112161206438373 40.116530087709577)
1

5452
2024-05-05 18:40:36.9467987
40.1165300877096
-74.1121612064384
POINT (-74.112161206438373 40.116530087709577)
1

5453
2024-05-04 18:40:36.9467987
40.1165300877096
-74.1121612064384
POINT (-74.112161206438373 40.116530087709577)
1

5454
2024-05-03 18:40:36.9467987
40.1165300877096
-74.1121612064384
POINT (-74.112161206438373 40.116530087709577)
1

5201
2024-05-06 18:40:36.9467987
40.1203056275055
-73.8948035632537
POINT (-73.894803563253731 40.120305627505516)
1

5202
2024-05-05 18:40:36.9467987
40.1203056275055
-73.8948035632537
POINT (-73.894803563253731 40.120305627505516)
1

5203
2024-05-04 18:40:36.9467987
40.1203056275055
-73.8948035632537
POINT (-73.894803563253731 40.120305627505516)
1

5204
2024-05-03 18:40:36.9467987
40.1203056275055
-73.8948035632537
POINT (-73.894803563253731 40.120305627505516)
1

5441
2024-05-06 18:40:36.9467987
40.1206219786962
-74.1045812863513
POINT (-74.104581286351291 40.120621978696207)
1

5442
2024-05-05 18:40:36.9467987
40.1206219786962
-74.1045812863513
POINT (-74.104581286351291 40.120621978696207)
1

5443
2024-05-04 18:40:36.9467987
40.1206219786962
-74.1045812863513
POINT (-74.104581286351291 40.120621978696207)
1

5444
2024-05-03 18:40:36.9467987
40.1206219786962
-74.1045812863513
POINT (-74.104581286351291 40.120621978696207)
1

5211
2024-05-06 18:40:36.9467987
40.1241301282421
-73.9026172175202
POINT (-73.902617217520174 40.124130128242136)
1

5212
2024-05-05 18:40:36.9467987
40.1241301282421
-73.9026172175202
POINT (-73.902617217520174 40.124130128242136)
1

5213
2024-05-04 18:40:36.9467987
40.1241301282421
-73.9026172175202
POINT (-73.902617217520174 40.124130128242136)
1

5214
2024-05-03 18:40:36.9467987
40.1241301282421
-73.9026172175202
POINT (-73.902617217520174 40.124130128242136)
1

5431
2024-05-06 18:40:36.9467987
40.1244228833921
-74.0967480841038
POINT (-74.0967480841038 40.124422883392128)
1

5432
2024-05-05 18:40:36.9467987
40.1244228833921
-74.0967480841038
POINT (-74.0967480841038 40.124422883392128)
1

5433
2024-05-04 18:40:36.9467987
40.1244228833921
-74.0967480841038
POINT (-74.0967480841038 40.124422883392128)
1

5434
2024-05-03 18:40:36.9467987
40.1244228833921
-74.0967480841038
POINT (-74.0967480841038 40.124422883392128)
1

5221
2024-05-06 18:40:36.9467987
40.127655146052
-73.9106667566745
POINT (-73.910666756674487 40.127655146052042)
1

5222
2024-05-05 18:40:36.9467987
40.127655146052
-73.9106667566745
POINT (-73.910666756674487 40.127655146052042)
1

5223
2024-05-04 18:40:36.9467987
40.127655146052
-73.9106667566745
POINT (-73.910666756674487 40.127655146052042)
1

5224
2024-05-03 18:40:36.9467987
40.127655146052
-73.9106667566745
POINT (-73.910666756674487 40.127655146052042)
1

5421
2024-05-06 18:40:36.9467987
40.1279235960576
-74.0886805313313
POINT (-74.08868053133132 40.127923596057606)
1

5422
2024-05-05 18:40:36.9467987
40.1279235960576
-74.0886805313313
POINT (-74.08868053133132 40.127923596057606)
1

5423
2024-05-04 18:40:36.9467987
40.1279235960576
-74.0886805313313
POINT (-74.08868053133132 40.127923596057606)
1

5424
2024-05-03 18:40:36.9467987
40.1279235960576
-74.0886805313313
POINT (-74.08868053133132 40.127923596057606)
1

5231
2024-05-06 18:40:36.9467987
40.1308721421233
-73.918932716477
POINT (-73.918932716477045 40.13087214212328)
1

5232
2024-05-05 18:40:36.9467987
40.1308721421233
-73.918932716477
POINT (-73.918932716477045 40.13087214212328)
1

5233
2024-05-04 18:40:36.9467987
40.1308721421233
-73.918932716477
POINT (-73.918932716477045 40.13087214212328)
1

5234
2024-05-03 18:40:36.9467987
40.1308721421233
-73.918932716477
POINT (-73.918932716477045 40.13087214212328)
1

5411
2024-05-06 18:40:36.9467987
40.1311156366514
-74.0803981366358
POINT (-74.080398136635836 40.131115636651366)
1

5412
2024-05-05 18:40:36.9467987
40.1311156366514
-74.0803981366358
POINT (-74.080398136635836 40.131115636651366)
1

5413
2024-05-04 18:40:36.9467987
40.1311156366514
-74.0803981366358
POINT (-74.080398136635836 40.131115636651366)
1

5414
2024-05-03 18:40:36.9467987
40.1311156366514
-74.0803981366358
POINT (-74.080398136635836 40.131115636651366)
1

5241
2024-05-06 18:40:36.9467987
40.1337733226225
-73.9273950995621
POINT (-73.9273950995621 40.133773322622467)
1

5242
2024-05-05 18:40:36.9467987
40.1337733226225
-73.9273950995621
POINT (-73.9273950995621 40.133773322622467)
1

5243
2024-05-04 18:40:36.9467987
40.1337733226225
-73.9273950995621
POINT (-73.9273950995621 40.133773322622467)
1

5244
2024-05-03 18:40:36.9467987
40.1337733226225
-73.9273950995621
POINT (-73.9273950995621 40.133773322622467)
1

5401
2024-05-06 18:40:36.9467987
40.1339912717127
-74.0719209378814
POINT (-74.071920937881387 40.133991271712652)
1

5402
2024-05-05 18:40:36.9467987
40.1339912717127
-74.0719209378814
POINT (-74.071920937881387 40.133991271712652)
1

5403
2024-05-04 18:40:36.9467987
40.1339912717127
-74.0719209378814
POINT (-74.071920937881387 40.133991271712652)
1

5404
2024-05-03 18:40:36.9467987
40.1339912717127
-74.0719209378814
POINT (-74.071920937881387 40.133991271712652)
1

5251
2024-05-06 18:40:36.9467987
40.1363516578974
-73.9360334244253
POINT (-73.9360334244253 40.13635165789735)
1

5252
2024-05-05 18:40:36.9467987
40.1363516578974
-73.9360334244253
POINT (-73.9360334244253 40.13635165789735)
1

5253
2024-05-04 18:40:36.9467987
40.1363516578974
-73.9360334244253
POINT (-73.9360334244253 40.13635165789735)
1

5254
2024-05-03 18:40:36.9467987
40.1363516578974
-73.9360334244253
POINT (-73.9360334244253 40.13635165789735)
1

5391
2024-05-06 18:40:36.9467987
40.1365435334158
-74.0632694531001
POINT (-74.063269453100133 40.136543533415811)
1

5392
2024-05-05 18:40:36.9467987
40.1365435334158
-74.0632694531001
POINT (-74.063269453100133 40.136543533415811)
1

5393
2024-05-04 18:40:36.9467987
40.1365435334158
-74.0632694531001
POINT (-74.063269453100133 40.136543533415811)
1

5394
2024-05-03 18:40:36.9467987
40.1365435334158
-74.0632694531001
POINT (-74.063269453100133 40.136543533415811)
1

5261
2024-05-06 18:40:36.9467987
40.1386008998059
-73.9448267756848
POINT (-73.944826775684845 40.138600899805908)
1

5262
2024-05-05 18:40:36.9467987
40.1386008998059
-73.9448267756848
POINT (-73.944826775684845 40.138600899805908)
1

5263
2024-05-04 18:40:36.9467987
40.1386008998059
-73.9448267756848
POINT (-73.944826775684845 40.138600899805908)
1

5264
2024-05-03 18:40:36.9467987
40.1386008998059
-73.9448267756848
POINT (-73.944826775684845 40.138600899805908)
1

5381
2024-05-06 18:40:36.9467987
40.1387662367477
-74.054464630135
POINT (-74.054464630135 40.1387662367477)
1

5382
2024-05-05 18:40:36.9467987
40.1387662367477
-74.054464630135
POINT (-74.054464630135 40.1387662367477)
1

5383
2024-05-04 18:40:36.9467987
40.1387662367477
-74.054464630135
POINT (-74.054464630135 40.1387662367477)
1

5384
2024-05-03 18:40:36.9467987
40.1387662367477
-74.054464630135
POINT (-74.054464630135 40.1387662367477)
1

5271
2024-05-06 18:40:36.9467987
40.1405155971263
-73.9537538554862
POINT (-73.953753855486227 40.1405155971263)
1

5272
2024-05-05 18:40:36.9467987
40.1405155971263
-73.9537538554862
POINT (-73.953753855486227 40.1405155971263)
1

5273
2024-05-04 18:40:36.9467987
40.1405155971263
-73.9537538554862
POINT (-73.953753855486227 40.1405155971263)
1

5274
2024-05-03 18:40:36.9467987
40.1405155971263
-73.9537538554862
POINT (-73.953753855486227 40.1405155971263)
1

5371
2024-05-06 18:40:36.9467987
40.1406539947625
-74.0455277951493
POINT (-74.045527795149312 40.140653994762495)
1

5372
2024-05-05 18:40:36.9467987
40.1406539947625
-74.0455277951493
POINT (-74.045527795149312 40.140653994762495)
1

5373
2024-05-04 18:40:36.9467987
40.1406539947625
-74.0455277951493
POINT (-74.045527795149312 40.140653994762495)
1

5374
2024-05-03 18:40:36.9467987
40.1406539947625
-74.0455277951493
POINT (-74.045527795149312 40.140653994762495)
1

5281
2024-05-06 18:40:36.9467987
40.1420911090072
-73.9627930359167
POINT (-73.962793035916675 40.142091109007175)
1

5282
2024-05-05 18:40:36.9467987
40.1420911090072
-73.9627930359167
POINT (-73.962793035916675 40.142091109007175)
1

5283
2024-05-04 18:40:36.9467987
40.1420911090072
-73.9627930359167
POINT (-73.962793035916675 40.142091109007175)
1

5284
2024-05-03 18:40:36.9467987
40.1420911090072
-73.9627930359167
POINT (-73.962793035916675 40.142091109007175)
1

5361
2024-05-06 18:40:36.9467987
40.1422022318738
-74.0364806001375
POINT (-74.036480600137523 40.142202231873831)
1

5362
2024-05-05 18:40:36.9467987
40.1422022318738
-74.0364806001375
POINT (-74.036480600137523 40.142202231873831)
1

5363
2024-05-04 18:40:36.9467987
40.1422022318738
-74.0364806001375
POINT (-74.036480600137523 40.142202231873831)
1

5364
2024-05-03 18:40:36.9467987
40.1422022318738
-74.0364806001375
POINT (-74.036480600137523 40.142202231873831)
1

5291
2024-05-06 18:40:36.9467987
40.1433236164225
-73.9719224122925
POINT (-73.971922412292486 40.1433236164225)
1

5292
2024-05-05 18:40:36.9467987
40.1433236164225
-73.9719224122925
POINT (-73.971922412292486 40.1433236164225)
1

5293
2024-05-04 18:40:36.9467987
40.1433236164225
-73.9719224122925
POINT (-73.971922412292486 40.1433236164225)
1

5294
2024-05-03 18:40:36.9467987
40.1433236164225
-73.9719224122925
POINT (-73.971922412292486 40.1433236164225)
1

5351
2024-05-06 18:40:36.9467987
40.1434071951488
-74.0273449695742
POINT (-74.027344969574244 40.143407195148832)
1

5352
2024-05-05 18:40:36.9467987
40.1434071951488
-74.0273449695742
POINT (-74.027344969574244 40.143407195148832)
1

5353
2024-05-04 18:40:36.9467987
40.1434071951488
-74.0273449695742
POINT (-74.027344969574244 40.143407195148832)
1

5354
2024-05-03 18:40:36.9467987
40.1434071951488
-74.0273449695742
POINT (-74.027344969574244 40.143407195148832)
1

5301
2024-05-06 18:40:36.9467987
40.144210131601
-73.9811198571789
POINT (-73.981119857178868 40.144210131601)
1

5302
2024-05-05 18:40:36.9467987
40.144210131601
-73.9811198571789
POINT (-73.981119857178868 40.144210131601)
1

5303
2024-05-04 18:40:36.9467987
40.144210131601
-73.9811198571789
POINT (-73.981119857178868 40.144210131601)
1

5304
2024-05-03 18:40:36.9467987
40.144210131601
-73.9811198571789
POINT (-73.981119857178868 40.144210131601)
1

5341
2024-05-06 18:40:36.9467987
40.1442659635745
-74.0181430463418
POINT (-74.018143046341834 40.144265963574519)
1

5342
2024-05-05 18:40:36.9467987
40.1442659635745
-74.0181430463418
POINT (-74.018143046341834 40.144265963574519)
1

5343
2024-05-04 18:40:36.9467987
40.1442659635745
-74.0181430463418
POINT (-74.018143046341834 40.144265963574519)
1

5344
2024-05-03 18:40:36.9467987
40.1442659635745
-74.0181430463418
POINT (-74.018143046341834 40.144265963574519)
1

5311
2024-05-06 18:40:36.9467987
40.1447485054048
-73.9903630750002
POINT (-73.990363075000232 40.14474850540482)
1

5312
2024-05-05 18:40:36.9467987
40.1447485054048
-73.9903630750002
POINT (-73.990363075000232 40.14474850540482)
1

5313
2024-05-04 18:40:36.9467987
40.1447485054048
-73.9903630750002
POINT (-73.990363075000232 40.14474850540482)
1

5314
2024-05-03 18:40:36.9467987
40.1447485054048
-73.9903630750002
POINT (-73.990363075000232 40.14474850540482)
1

5331
2024-05-06 18:40:36.9467987
40.1447764552719
-74.0088971370793
POINT (-74.008897137079273 40.14477645527186)
1

5332
2024-05-05 18:40:36.9467987
40.1447764552719
-74.0088971370793
POINT (-74.008897137079273 40.14477645527186)
1

5333
2024-05-04 18:40:36.9467987
40.1447764552719
-74.0088971370793
POINT (-74.008897137079273 40.14477645527186)
1

5334
2024-05-03 18:40:36.9467987
40.1447764552719
-74.0088971370793
POINT (-74.008897137079273 40.14477645527186)
1

5321
2024-05-06 18:40:36.9467987
40.1449374326382
-73.9996296570964
POINT (-73.999629657096449 40.144937432638208)
1

5322
2024-05-05 18:40:36.9467987
40.1449374326382
-73.9996296570964
POINT (-73.999629657096449 40.144937432638208)
1

5323
2024-05-04 18:40:36.9467987
40.1449374326382
-73.9996296570964
POINT (-73.999629657096449 40.144937432638208)
1

5324
2024-05-03 18:40:36.9467987
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.3451.2"><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="140.35" 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="408368" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="56" CompileTime="15" CompileCPU="15" CompileMemory="304"><Warnings><MemoryGrantWarning GrantWarningKind="Excessive Grant" RequestedMemory="408368" GrantedMemory="408368" MaxUsedMemory="15816"></MemoryGrantWarning></Warnings><MemoryGrantInfo SerialRequiredMemory="512" SerialDesiredMemory="646648" RequiredMemory="512" DesiredMemory="646648" RequestedMemory="408368" GrantWaitTime="0" GrantedMemory="408368" MaxUsedMemory="15816" MaxQueryMemory="408264"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="608728"></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><WaitStats><Wait WaitType="ASYNC_NETWORK_IO" WaitTimeMs="277" WaitCount="1"></Wait></WaitStats><QueryTimeStats ElapsedTime="906" CpuTime="628"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="21196.9" EstimateIO="0" EstimateCPU="0.00211969" AvgRowSize="4067" EstimatedTotalSubtreeCost="140.35" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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="140.348" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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="628" ActualCPUms="628" 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="11.1442" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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="456" ActualCPUms="456" 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="11.1339" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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="441" ActualCPUms="441" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1005"></ColumnReference></SegmentColumn><RelOp NodeId="4" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="129000" EstimateIO="0.0112613" EstimateCPU="10.0524" AvgRowSize="4063" EstimatedTotalSubtreeCost="11.1313" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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="425" ActualCPUms="425" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="408368" OutputMemoryGrant="407984" UsedMemoryGrant="15816"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ScalarOperator ScalarString="[fiddle_5f0c8faa376346c4994e02f50d916714].[dbo].[example].[latlong]"><Identifier><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="129000" Batches="0" ActualExecutionMode="Row" ActualElapsedms="78" ActualCPUms="78" 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_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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_5f0c8faa376346c4994e02f50d916714].[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_5f0c8faa376346c4994e02f50d916714]" 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>


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


most_recent
example_id
transaction_dt
latitude
longitude
latlong


1
5961
2024-05-06 18:40:36.9467987
39.8550589352619
-74.0003704441225
POINT (-74.000370444122524 39.855058935261944)

1
5962
2024-05-05 18:40:36.9467987
39.8550589352619
-74.0003704441225
POINT (-74.000370444122524 39.855058935261944)

1
5963
2024-05-04 18:40:36.9467987
39.8550589352619
-74.0003704441225
POINT (-74.000370444122524 39.855058935261944)

1
5964
2024-05-03 18:40:36.9467987
39.8550589352619
-74.0003704441225
POINT (-74.000370444122524 39.855058935261944)

1
5971
2024-05-06 18:40:36.9467987
39.8552191771366
-73.9911420761936
POINT (-73.99114207619364 39.855219177136561)

1
5972
2024-05-05 18:40:36.9467987
39.8552191771366
-73.9911420761936
POINT (-73.99114207619364 39.855219177136561)

1
5973
2024-05-04 18:40:36.9467987
39.8552191771366
-73.9911420761936
POINT (-73.99114207619364 39.855219177136561)

1
5974
2024-05-03 18:40:36.9467987
39.8552191771366
-73.9911420761936
POINT (-73.99114207619364 39.855219177136561)

1
5951
2024-05-06 18:40:36.9467987
39.8552471360297
-74.0095979252562
POINT (-74.00959792525623 39.855247136029746)

1
5952
2024-05-05 18:40:36.9467987
39.8552471360297
-74.0095979252562
POINT (-74.00959792525623 39.855247136029746)

1
5953
2024-05-04 18:40:36.9467987
39.8552471360297
-74.0095979252562
POINT (-74.00959792525623 39.855247136029746)

1
5954
2024-05-03 18:40:36.9467987
39.8552471360297
-74.0095979252562
POINT (-74.00959792525623 39.855247136029746)

1
5981
2024-05-06 18:40:36.9467987
39.8557274780307
-73.9819349131332
POINT (-73.981934913133173 39.855727478030737)

1
5982
2024-05-05 18:40:36.9467987
39.8557274780307
-73.9819349131332
POINT (-73.981934913133173 39.855727478030737)

1
5983
2024-05-04 18:40:36.9467987
39.8557274780307
-73.9819349131332
POINT (-73.981934913133173 39.855727478030737)

1
5984
2024-05-03 18:40:36.9467987
39.8557274780307
-73.9819349131332
POINT (-73.981934913133173 39.855727478030737)

1
5941
2024-05-06 18:40:36.9467987
39.8557833288826
-74.0188024300137
POINT (-74.0188024300137 39.855783328882588)

1
5942
2024-05-05 18:40:36.9467987
39.8557833288826
-74.0188024300137
POINT (-74.0188024300137 39.855783328882588)

1
5943
2024-05-04 18:40:36.9467987
39.8557833288826
-74.0188024300137
POINT (-74.0188024300137 39.855783328882588)

1
5944
2024-05-03 18:40:36.9467987
39.8557833288826
-74.0188024300137
POINT (-74.0188024300137 39.855783328882588)

1
5991
2024-05-06 18:40:36.9467987
39.8565826210426
-73.9727709968065
POINT (-73.972770996806489 39.856582621042584)

1
5992
2024-05-05 18:40:36.9467987
39.8565826210426
-73.9727709968065
POINT (-73.972770996806489 39.856582621042584)

1
5993
2024-05-04 18:40:36.9467987
39.8565826210426
-73.9727709968065
POINT (-73.972770996806489 39.856582621042584)

1
5994
2024-05-03 18:40:36.9467987
39.8565826210426
-73.9727709968065
POINT (-73.972770996806489 39.856582621042584)

1
5931
2024-05-06 18:40:36.9467987
39.8566662301413
-74.0279619227726
POINT (-74.027961922772647 39.856666230141286)

1
5932
2024-05-05 18:40:36.9467987
39.8566662301413
-74.0279619227726
POINT (-74.027961922772647 39.856666230141286)

1
5933
2024-05-04 18:40:36.9467987
39.8566662301413
-74.0279619227726
POINT (-74.027961922772647 39.856666230141286)

1
5934
2024-05-03 18:40:36.9467987
39.8566662301413
-74.0279619227726
POINT (-74.027961922772647 39.856666230141286)

1
6001
2024-05-06 18:40:36.9467987
39.8577825588499
-73.9636722675078
POINT (-73.963672267507846 39.857782558849934)

1
6002
2024-05-05 18:40:36.9467987
39.8577825588499
-73.9636722675078
POINT (-73.963672267507846 39.857782558849934)

1
6003
2024-05-04 18:40:36.9467987
39.8577825588499
-73.9636722675078
POINT (-73.963672267507846 39.857782558849934)

1
6004
2024-05-03 18:40:36.9467987
39.8577825588499
-73.9636722675078
POINT (-73.963672267507846 39.857782558849934)

1
5921
2024-05-06 18:40:36.9467987
39.8578937260205
-74.0370544736288
POINT (-74.037054473628828 39.857893726020514)

1
5922
2024-05-05 18:40:36.9467987
39.8578937260205
-74.0370544736288
POINT (-74.037054473628828 39.857893726020514)

1
5923
2024-05-04 18:40:36.9467987
39.8578937260205
-74.0370544736288
POINT (-74.037054473628828 39.857893726020514)

1
5924
2024-05-03 18:40:36.9467987
39.8578937260205
-74.0370544736288
POINT (-74.037054473628828 39.857893726020514)

1
6011
2024-05-06 18:40:36.9467987
39.8593244185206
-73.9546605124076
POINT (-73.954660512407557 39.8593244185206)

1
6012
2024-05-05 18:40:36.9467987
39.8593244185206
-73.9546605124076
POINT (-73.954660512407557 39.8593244185206)

1
6013
2024-05-04 18:40:36.9467987
39.8593244185206
-73.9546605124076
POINT (-73.954660512407557 39.8593244185206)

1
6014
2024-05-03 18:40:36.9467987
39.8593244185206
-73.9546605124076
POINT (-73.954660512407557 39.8593244185206)

1
5911
2024-05-06 18:40:36.9467987
39.8594628775953
-74.0460583099265
POINT (-74.046058309926508 39.859462877595327)

1
5912
2024-05-05 18:40:36.9467987
39.8594628775953
-74.0460583099265
POINT (-74.046058309926508 39.859462877595327)

1
5913
2024-05-04 18:40:36.9467987
39.8594628775953
-74.0460583099265
POINT (-74.046058309926508 39.859462877595327)

1
5914
2024-05-03 18:40:36.9467987
39.8594628775953
-74.0460583099265
POINT (-74.046058309926508 39.859462877595327)

1
6021
2024-05-06 18:40:36.9467987
39.8612045082636
-73.9457573143311
POINT (-73.9457573143311 39.861204508263583)

1
6022
2024-05-05 18:40:36.9467987
39.8612045082636
-73.9457573143311
POINT (-73.9457573143311 39.861204508263583)

1
6023
2024-05-04 18:40:36.9467987
39.8612045082636
-73.9457573143311
POINT (-73.9457573143311 39.861204508263583)

1
6024
2024-05-03 18:40:36.9467987
39.8612045082636
-73.9457573143311
POINT (-73.9457573143311 39.861204508263583)

1
5901
2024-05-06 18:40:36.9467987
39.8613699277074
-74.0549518674478
POINT (-74.054951867447812 39.861369927707436)

1
5902
2024-05-05 18:40:36.9467987
39.8613699277074
-74.0549518674478
POINT (-74.054951867447812 39.861369927707436)

1
5903
2024-05-04 18:40:36.9467987
39.8613699277074
-74.0549518674478
POINT (-74.054951867447812 39.861369927707436)

1
5904
2024-05-03 18:40:36.9467987
39.8613699277074
-74.0549518674478
POINT (-74.054951867447812 39.861369927707436)

1
6031
2024-05-06 18:40:36.9467987
39.8634183261066
-73.9369840009815
POINT (-73.936984000981539 39.863418326106554)

1
6032
2024-05-05 18:40:36.9467987
39.8634183261066
-73.9369840009815
POINT (-73.936984000981539 39.863418326106554)

1
6033
2024-05-04 18:40:36.9467987
39.8634183261066
-73.9369840009815
POINT (-73.936984000981539 39.863418326106554)

1
6034
2024-05-03 18:40:36.9467987
39.8634183261066
-73.9369840009815
POINT (-73.936984000981539 39.863418326106554)

1
5891
2024-05-06 18:40:36.9467987
39.8636103097967
-74.0637138411498
POINT (-74.063713841149834 39.863610309796677)

1
5892
2024-05-05 18:40:36.9467987
39.8636103097967
-74.0637138411498
POINT (-74.063713841149834 39.863610309796677)

1
5893
2024-05-04 18:40:36.9467987
39.8636103097967
-74.0637138411498
POINT (-74.063713841149834 39.863610309796677)

1
5894
2024-05-03 18:40:36.9467987
39.8636103097967
-74.0637138411498
POINT (-74.063713841149834 39.863610309796677)

1
6041
2024-05-06 18:40:36.9467987
39.8659605704808
-73.9283615947162
POINT (-73.9283615947162 39.865960570480844)

1
6042
2024-05-05 18:40:36.9467987
39.8659605704808
-73.9283615947162
POINT (-73.9283615947162 39.865960570480844)

1
6043
2024-05-04 18:40:36.9467987
39.8659605704808
-73.9283615947162
POINT (-73.9283615947162 39.865960570480844)

1
6044
2024-05-03 18:40:36.9467987
39.8659605704808
-73.9283615947162
POINT (-73.9283615947162 39.865960570480844)

1
5881
2024-05-06 18:40:36.9467987
39.866178658638
-74.0723232353388
POINT (-74.0723232353388 39.86617865863802)

1
5882
2024-05-05 18:40:36.9467987
39.866178658638
-74.0723232353388
POINT (-74.0723232353388 39.86617865863802)

1
5883
2024-05-04 18:40:36.9467987
39.866178658638
-74.0723232353388
POINT (-74.0723232353388 39.86617865863802)

1
5884
2024-05-03 18:40:36.9467987
39.866178658638
-74.0723232353388
POINT (-74.0723232353388 39.86617865863802)

1
6051
2024-05-06 18:40:36.9467987
39.8688251526908
-73.9199107629876
POINT (-73.919910762987641 39.8688251526908)

1
6052
2024-05-05 18:40:36.9467987
39.8688251526908
-73.9199107629876
POINT (-73.919910762987641 39.8688251526908)

1
6053
2024-05-04 18:40:36.9467987
39.8688251526908
-73.9199107629876
POINT (-73.919910762987641 39.8688251526908)

1
6054
2024-05-03 18:40:36.9467987
39.8688251526908
-73.9199107629876
POINT (-73.919910762987641 39.8688251526908)

1
5871
2024-05-06 18:40:36.9467987
39.8690688229611
-74.080759413171
POINT (-74.080759413171023 39.86906882296109)

1
5872
2024-05-05 18:40:36.9467987
39.8690688229611
-74.080759413171
POINT (-74.080759413171023 39.86906882296109)

1
5873
2024-05-04 18:40:36.9467987
39.8690688229611
-74.080759413171
POINT (-74.080759413171023 39.86906882296109)

1
5874
2024-05-03 18:40:36.9467987
39.8690688229611
-74.080759413171
POINT (-74.080759413171023 39.86906882296109)

1
6061
2024-05-06 18:40:36.9467987
39.8720052112403
-73.9116517695578
POINT (-73.9116517695578 39.872005211240271)

1
6062
2024-05-05 18:40:36.9467987
39.8720052112403
-73.9116517695578
POINT (-73.9116517695578 39.872005211240271)

1
6063
2024-05-04 18:40:36.9467987
39.8720052112403
-73.9116517695578
POINT (-73.9116517695578 39.872005211240271)

1
6064
2024-05-03 18:40:36.9467987
39.8720052112403
-73.9116517695578
POINT (-73.9116517695578 39.872005211240271)

1
5861
2024-05-06 18:40:36.9467987
39.8722738799244
-74.089002145372
POINT (-74.089002145371992 39.872273879924428)

1
5862
2024-05-05 18:40:36.9467987
39.8722738799244
-74.089002145372
POINT (-74.089002145371992 39.872273879924428)

1
5863
2024-05-04 18:40:36.9467987
39.8722738799244
-74.089002145372
POINT (-74.089002145371992 39.872273879924428)

1
5864
2024-05-03 18:40:36.9467987
39.8722738799244
-74.089002145372
POINT (-74.089002145371992 39.872273879924428)

1
6071
2024-05-06 18:40:36.9467987
39.8754931279851
-73.9036044265936
POINT (-73.903604426593589 39.875493127985109)

1
6072
2024-05-05 18:40:36.9467987
39.8754931279851
-73.9036044265936
POINT (-73.903604426593589 39.875493127985109)

1
6073
2024-05-04 18:40:36.9467987
39.8754931279851
-73.9036044265936
POINT (-73.903604426593589 39.875493127985109)

1
6074
2024-05-03 18:40:36.9467987
39.8754931279851
-73.9036044265936
POINT (-73.903604426593589 39.875493127985109)

1
5851
2024-05-06 18:40:36.9467987
39.875786151413
-74.0970316580654
POINT (-74.0970316580654 39.875786151412953)

1
5852
2024-05-05 18:40:36.9467987
39.875786151413
-74.0970316580654
POINT (-74.0970316580654 39.875786151412953)

1
5853
2024-05-04 18:40:36.9467987
39.875786151413
-74.0970316580654
POINT (-74.0970316580654 39.875786151412953)

1
5854
2024-05-03 18:40:36.9467987
39.875786151413
-74.0970316580654
POINT (-74.0970316580654 39.875786151412953)

1
6081
2024-05-06 18:40:36.9467987
39.8792805460761
-73.8957880477504
POINT (-73.8957880477504 39.879280546076075)

1
6082
2024-05-05 18:40:36.9467987
39.8792805460761
-73.8957880477504
POINT (-73.8957880477504 39.879280546076075)

1
6083
2024-05-04 18:40:36.9467987
39.8792805460761
-73.8957880477504
POINT (-73.8957880477504 39.879280546076075)

1
6084
2024-05-03 18:40:36.9467987
39.8792805460761
-73.8957880477504
POINT (-73.8957880477504 39.879280546076075)

1
5841
2024-05-06 18:40:36.9467987
39.879597222123
-74.1048286796057
POINT (-74.104828679605731 39.879597222123031)

1
5842
2024-05-05 18:40:36.9467987
39.879597222123
-74.1048286796057
POINT (-74.104828679605731 39.879597222123031)

1
5843
2024-05-04 18:40:36.9467987
39.879597222123
-74.1048286796057
POINT (-74.104828679605731 39.879597222123031)

1
5844
2024-05-03 18:40:36.9467987
39.879597222123
-74.1048286796057
POINT (-74.104828679605731 39.879597222123031)

1
6091
2024-05-06 18:40:36.9467987
39.8833583896531
-73.888221402349
POINT (-73.888221402348975 39.8833583896531)

1
6092
2024-05-05 18:40:36.9467987
39.8833583896531
-73.888221402349
POINT (-73.888221402348975 39.8833583896531)

1
6093
2024-05-04 18:40:36.9467987
39.8833583896531
-73.888221402349
POINT (-73.888221402348975 39.8833583896531)

1
6094
2024-05-03 18:40:36.9467987
39.8833583896531
-73.888221402349
POINT (-73.888221402348975 39.8833583896531)

1
5831
2024-05-06 18:40:36.9467987
39.8836979593953
-74.1123744863092
POINT (-74.112374486309164 39.883697959395327)

1
5832
2024-05-05 18:40:36.9467987
39.8836979593953
-74.1123744863092
POINT (-74.112374486309164 39.883697959395327)

1
5833
2024-05-04 18:40:36.9467987
39.8836979593953
-74.1123744863092
POINT (-74.112374486309164 39.883697959395327)

1
5834
2024-05-03 18:40:36.9467987
39.8836979593953
-74.1123744863092
POINT (-74.112374486309164 39.883697959395327)

1
6101
2024-05-06 18:40:36.9467987
39.8877168852471
-73.8809226707491
POINT (-73.880922670749058 39.887716885247116)

1
6102
2024-05-05 18:40:36.9467987
39.8877168852471
-73.8809226707491
POINT (-73.880922670749058 39.887716885247116)

1
6103
2024-05-04 18:40:36.9467987
39.8877168852471
-73.8809226707491
POINT (-73.880922670749058 39.887716885247116)

1
6104
2024-05-03 18:40:36.9467987
39.8877168852471
-73.8809226707491
POINT (-73.880922670749058 39.887716885247116)

1
5821
2024-05-06 18:40:36.9467987
39.8880785347519
-74.1196509469795
POINT (-74.119650946979462 39.888078534751891)

1
5822
2024-05-05 18:40:36.9467987
39.8880785347519
-74.1196509469795
POINT (-74.119650946979462 39.888078534751891)

1
5823
2024-05-04 18:40:36.9467987
39.8880785347519
-74.1196509469795
POINT (-74.119650946979462 39.888078534751891)

1
5824
2024-05-03 18:40:36.9467987
39.8880785347519
-74.1196509469795
POINT (-74.119650946979462 39.888078534751891)

1
6111
2024-05-06 18:40:36.9467987
39.892345584843
-73.8739094010218
POINT (-73.873909401021763 39.892345584842978)

1
6112
2024-05-05 18:40:36.9467987
39.892345584843
-73.8739094010218
POINT (-73.873909401021763 39.892345584842978)

1
6113
2024-05-04 18:40:36.9467987
39.892345584843
-73.8739094010218
POINT (-73.873909401021763 39.892345584842978)

1
6114
2024-05-03 18:40:36.9467987
39.892345584843
-73.8739094010218
POINT (-73.873909401021763 39.892345584842978)

1
5811
2024-05-06 18:40:36.9467987
39.89272844709
-74.1266405661269
POINT (-74.126640566126937 39.892728447089972)

1
5812
2024-05-05 18:40:36.9467987
39.89272844709
-74.1266405661269
POINT (-74.126640566126937 39.892728447089972)

1
5813
2024-05-04 18:40:36.9467987
39.89272844709
-74.1266405661269
POINT (-74.126640566126937 39.892728447089972)

1
5814
2024-05-03 18:40:36.9467987
39.89272844709
-74.1266405661269
POINT (-74.126640566126937 39.892728447089972)

1
6121
2024-05-06 18:40:36.9467987
39.8972333905517
-73.8671984670204
POINT (-73.867198467020359 39.8972333905517)

1
6122
2024-05-05 18:40:36.9467987
39.8972333905517
-73.8671984670204
POINT (-73.867198467020359 39.8972333905517)

1
6123
2024-05-04 18:40:36.9467987
39.8972333905517
-73.8671984670204
POINT (-73.867198467020359 39.8972333905517)

1
6124
2024-05-03 18:40:36.9467987
39.8972333905517
-73.8671984670204
POINT (-73.867198467020359 39.8972333905517)

1
5801
2024-05-06 18:40:36.9467987
39.8976365474813
-74.1333265257813
POINT (-74.1333265257813 39.8976365474813)

1
5802
2024-05-05 18:40:36.9467987
39.8976365474813
-74.1333265257813
POINT (-74.1333265257813 39.8976365474813)

1
5803
2024-05-04 18:40:36.9467987
39.8976365474813
-74.1333265257813
POINT (-74.1333265257813 39.8976365474813)

1
5804
2024-05-03 18:40:36.9467987
39.8976365474813
-74.1333265257813
POINT (-74.1333265257813 39.8976365474813)

1
5481
2024-05-06 18:40:36.9467987
40.1026109522104
-74.1332015704258
POINT (-74.133201570425825 40.102610952210419)

1
5482
2024-05-05 18:40:36.9467987
40.1026109522104
-74.1332015704258
POINT (-74.133201570425825 40.102610952210419)

1
5483
2024-05-04 18:40:36.9467987
40.1026109522104
-74.1332015704258
POINT (-74.133201570425825 40.102610952210419)

1
5484
2024-05-03 18:40:36.9467987
40.1026109522104
-74.1332015704258
POINT (-74.133201570425825 40.102610952210419)

1
5171
2024-05-06 18:40:36.9467987
40.1071313366801
-73.872963566699
POINT (-73.872963566698971 40.107131336680133)

1
5172
2024-05-05 18:40:36.9467987
40.1071313366801
-73.872963566699
POINT (-73.872963566698971 40.107131336680133)

1
5173
2024-05-04 18:40:36.9467987
40.1071313366801
-73.872963566699
POINT (-73.872963566698971 40.107131336680133)

1
5174
2024-05-03 18:40:36.9467987
40.1071313366801
-73.872963566699
POINT (-73.872963566698971 40.107131336680133)

1
5471
2024-05-06 18:40:36.9467987
40.1075136606765
-74.1264886339523
POINT (-74.126488633952292 40.10751366067651)

1
5472
2024-05-05 18:40:36.9467987
40.1075136606765
-74.1264886339523
POINT (-74.126488633952292 40.10751366067651)

1
5473
2024-05-04 18:40:36.9467987
40.1075136606765
-74.1264886339523
POINT (-74.126488633952292 40.10751366067651)

1
5474
2024-05-03 18:40:36.9467987
40.1075136606765
-74.1264886339523
POINT (-74.126488633952292 40.10751366067651)

1
5181
2024-05-06 18:40:36.9467987
40.1117959294713
-73.8799588167048
POINT (-73.879958816704828 40.11179592947127)

1
5182
2024-05-05 18:40:36.9467987
40.1117959294713
-73.8799588167048
POINT (-73.879958816704828 40.11179592947127)

1
5183
2024-05-04 18:40:36.9467987
40.1117959294713
-73.8799588167048
POINT (-73.879958816704828 40.11179592947127)

1
5184
2024-05-03 18:40:36.9467987
40.1117959294713
-73.8799588167048
POINT (-73.879958816704828 40.11179592947127)

1
5461
2024-05-06 18:40:36.9467987
40.1121571192162
-74.1194695358892
POINT (-74.119469535889166 40.112157119216178)

1
5462
2024-05-05 18:40:36.9467987
40.1121571192162
-74.1194695358892
POINT (-74.119469535889166 40.112157119216178)

1
5463
2024-05-04 18:40:36.9467987
40.1121571192162
-74.1194695358892
POINT (-74.119469535889166 40.112157119216178)

1
5464
2024-05-03 18:40:36.9467987
40.1121571192162
-74.1194695358892
POINT (-74.119469535889166 40.112157119216178)

1
5191
2024-05-06 18:40:36.9467987
40.1161909066071
-73.8872446774006
POINT (-73.887244677400631 40.116190906607088)

1
5192
2024-05-05 18:40:36.9467987
40.1161909066071
-73.8872446774006
POINT (-73.887244677400631 40.116190906607088)

1
5193
2024-05-04 18:40:36.9467987
40.1161909066071
-73.8872446774006
POINT (-73.887244677400631 40.116190906607088)

1
5194
2024-05-03 18:40:36.9467987
40.1161909066071
-73.8872446774006
POINT (-73.887244677400631 40.116190906607088)

1
5451
2024-05-06 18:40:36.9467987
40.1165300877096
-74.1121612064384
POINT (-74.112161206438373 40.116530087709577)

1
5452
2024-05-05 18:40:36.9467987
40.1165300877096
-74.1121612064384
POINT (-74.112161206438373 40.116530087709577)

1
5453
2024-05-04 18:40:36.9467987
40.1165300877096
-74.1121612064384
POINT (-74.112161206438373 40.116530087709577)

1
5454
2024-05-03 18:40:36.9467987
40.1165300877096
-74.1121612064384
POINT (-74.112161206438373 40.116530087709577)

1
5201
2024-05-06 18:40:36.9467987
40.1203056275055
-73.8948035632537
POINT (-73.894803563253731 40.120305627505516)

1
5202
2024-05-05 18:40:36.9467987
40.1203056275055
-73.8948035632537
POINT (-73.894803563253731 40.120305627505516)

1
5203
2024-05-04 18:40:36.9467987
40.1203056275055
-73.8948035632537
POINT (-73.894803563253731 40.120305627505516)

1
5204
2024-05-03 18:40:36.9467987
40.1203056275055
-73.8948035632537
POINT (-73.894803563253731 40.120305627505516)

1
5441
2024-05-06 18:40:36.9467987
40.1206219786962
-74.1045812863513
POINT (-74.104581286351291 40.120621978696207)

1
5442
2024-05-05 18:40:36.9467987
40.1206219786962
-74.1045812863513
POINT (-74.104581286351291 40.120621978696207)

1
5443
2024-05-04 18:40:36.9467987
40.1206219786962
-74.1045812863513
POINT (-74.104581286351291 40.120621978696207)

1
5444
2024-05-03 18:40:36.9467987
40.1206219786962
-74.1045812863513
POINT (-74.104581286351291 40.120621978696207)

1
5211
2024-05-06 18:40:36.9467987
40.1241301282421
-73.9026172175202
POINT (-73.902617217520174 40.124130128242136)

1
5212
2024-05-05 18:40:36.9467987
40.1241301282421
-73.9026172175202
POINT (-73.902617217520174 40.124130128242136)

1
5213
2024-05-04 18:40:36.9467987
40.1241301282421
-73.9026172175202
POINT (-73.902617217520174 40.124130128242136)

1
5214
2024-05-03 18:40:36.9467987
40.1241301282421
-73.9026172175202
POINT (-73.902617217520174 40.124130128242136)

1
5431
2024-05-06 18:40:36.9467987
40.1244228833921
-74.0967480841038
POINT (-74.0967480841038 40.124422883392128)

1
5432
2024-05-05 18:40:36.9467987
40.1244228833921
-74.0967480841038
POINT (-74.0967480841038 40.124422883392128)

1
5433
2024-05-04 18:40:36.9467987
40.1244228833921
-74.0967480841038
POINT (-74.0967480841038 40.124422883392128)

1
5434
2024-05-03 18:40:36.9467987
40.1244228833921
-74.0967480841038
POINT (-74.0967480841038 40.124422883392128)

1
5221
2024-05-06 18:40:36.9467987
40.127655146052
-73.9106667566745
POINT (-73.910666756674487 40.127655146052042)

1
5222
2024-05-05 18:40:36.9467987
40.127655146052
-73.9106667566745
POINT (-73.910666756674487 40.127655146052042)

1
5223
2024-05-04 18:40:36.9467987
40.127655146052
-73.9106667566745
POINT (-73.910666756674487 40.127655146052042)

1
5224
2024-05-03 18:40:36.9467987
40.127655146052
-73.9106667566745
POINT (-73.910666756674487 40.127655146052042)

1
5421
2024-05-06 18:40:36.9467987
40.1279235960576
-74.0886805313313
POINT (-74.08868053133132 40.127923596057606)

1
5422
2024-05-05 18:40:36.9467987
40.1279235960576
-74.0886805313313
POINT (-74.08868053133132 40.127923596057606)

1
5423
2024-05-04 18:40:36.9467987
40.1279235960576
-74.0886805313313
POINT (-74.08868053133132 40.127923596057606)

1
5424
2024-05-03 18:40:36.9467987
40.1279235960576
-74.0886805313313
POINT (-74.08868053133132 40.127923596057606)

1
5231
2024-05-06 18:40:36.9467987
40.1308721421233
-73.918932716477
POINT (-73.918932716477045 40.13087214212328)

1
5232
2024-05-05 18:40:36.9467987
40.1308721421233
-73.918932716477
POINT (-73.918932716477045 40.13087214212328)

1
5233
2024-05-04 18:40:36.9467987
40.1308721421233
-73.918932716477
POINT (-73.918932716477045 40.13087214212328)

1
5234
2024-05-03 18:40:36.9467987
40.1308721421233
-73.918932716477
POINT (-73.918932716477045 40.13087214212328)

1
5411
2024-05-06 18:40:36.9467987
40.1311156366514
-74.0803981366358
POINT (-74.080398136635836 40.131115636651366)

1
5412
2024-05-05 18:40:36.9467987
40.1311156366514
-74.0803981366358
POINT (-74.080398136635836 40.131115636651366)

1
5413
2024-05-04 18:40:36.9467987
40.1311156366514
-74.0803981366358
POINT (-74.080398136635836 40.131115636651366)

1
5414
2024-05-03 18:40:36.9467987
40.1311156366514
-74.0803981366358
POINT (-74.080398136635836 40.131115636651366)

1
5241
2024-05-06 18:40:36.9467987
40.1337733226225
-73.9273950995621
POINT (-73.9273950995621 40.133773322622467)

1
5242
2024-05-05 18:40:36.9467987
40.1337733226225
-73.9273950995621
POINT (-73.9273950995621 40.133773322622467)

1
5243
2024-05-04 18:40:36.9467987
40.1337733226225
-73.9273950995621
POINT (-73.9273950995621 40.133773322622467)

1
5244
2024-05-03 18:40:36.9467987
40.1337733226225
-73.9273950995621
POINT (-73.9273950995621 40.133773322622467)

1
5401
2024-05-06 18:40:36.9467987
40.1339912717127
-74.0719209378814
POINT (-74.071920937881387 40.133991271712652)

1
5402
2024-05-05 18:40:36.9467987
40.1339912717127
-74.0719209378814
POINT (-74.071920937881387 40.133991271712652)

1
5403
2024-05-04 18:40:36.9467987
40.1339912717127
-74.0719209378814
POINT (-74.071920937881387 40.133991271712652)

1
5404
2024-05-03 18:40:36.9467987
40.1339912717127
-74.0719209378814
POINT (-74.071920937881387 40.133991271712652)

1
5251
2024-05-06 18:40:36.9467987
40.1363516578974
-73.9360334244253
POINT (-73.9360334244253 40.13635165789735)

1
5252
2024-05-05 18:40:36.9467987
40.1363516578974
-73.9360334244253
POINT (-73.9360334244253 40.13635165789735)

1
5253
2024-05-04 18:40:36.9467987
40.1363516578974
-73.9360334244253
POINT (-73.9360334244253 40.13635165789735)

1
5254
2024-05-03 18:40:36.9467987
40.1363516578974
-73.9360334244253
POINT (-73.9360334244253 40.13635165789735)

1
5391
2024-05-06 18:40:36.9467987
40.1365435334158
-74.0632694531001
POINT (-74.063269453100133 40.136543533415811)

1
5392
2024-05-05 18:40:36.9467987
40.1365435334158
-74.0632694531001
POINT (-74.063269453100133 40.136543533415811)

1
5393
2024-05-04 18:40:36.9467987
40.1365435334158
-74.0632694531001
POINT (-74.063269453100133 40.136543533415811)

1
5394
2024-05-03 18:40:36.9467987
40.1365435334158
-74.0632694531001
POINT (-74.063269453100133 40.136543533415811)

1
5261
2024-05-06 18:40:36.9467987
40.1386008998059
-73.9448267756848
POINT (-73.944826775684845 40.138600899805908)

1
5262
2024-05-05 18:40:36.9467987
40.1386008998059
-73.9448267756848
POINT (-73.944826775684845 40.138600899805908)

1
5263
2024-05-04 18:40:36.9467987
40.1386008998059
-73.9448267756848
POINT (-73.944826775684845 40.138600899805908)

1
5264
2024-05-03 18:40:36.9467987
40.1386008998059
-73.9448267756848
POINT (-73.944826775684845 40.138600899805908)

1
5381
2024-05-06 18:40:36.9467987
40.1387662367477
-74.054464630135
POINT (-74.054464630135 40.1387662367477)

1
5382
2024-05-05 18:40:36.9467987
40.1387662367477
-74.054464630135
POINT (-74.054464630135 40.1387662367477)

1
5383
2024-05-04 18:40:36.9467987
40.1387662367477
-74.054464630135
POINT (-74.054464630135 40.1387662367477)

1
5384
2024-05-03 18:40:36.9467987
40.1387662367477
-74.054464630135
POINT (-74.054464630135 40.1387662367477)

1
5271
2024-05-06 18:40:36.9467987
40.1405155971263
-73.9537538554862
POINT (-73.953753855486227 40.1405155971263)

1
5272
2024-05-05 18:40:36.9467987
40.1405155971263
-73.9537538554862
POINT (-73.953753855486227 40.1405155971263)

1
5273
2024-05-04 18:40:36.9467987
40.1405155971263
-73.9537538554862
POINT (-73.953753855486227 40.1405155971263)

1
5274
2024-05-03 18:40:36.9467987
40.1405155971263
-73.9537538554862
POINT (-73.953753855486227 40.1405155971263)

1
5371
2024-05-06 18:40:36.9467987
40.1406539947625
-74.0455277951493
POINT (-74.045527795149312 40.140653994762495)

1
5372
2024-05-05 18:40:36.9467987
40.1406539947625
-74.0455277951493
POINT (-74.045527795149312 40.140653994762495)

1
5373
2024-05-04 18:40:36.9467987
40.1406539947625
-74.0455277951493
POINT (-74.045527795149312 40.140653994762495)

1
5374
2024-05-03 18:40:36.9467987
40.1406539947625
-74.0455277951493
POINT (-74.045527795149312 40.140653994762495)

1
5281
2024-05-06 18:40:36.9467987
40.1420911090072
-73.9627930359167
POINT (-73.962793035916675 40.142091109007175)

1
5282
2024-05-05 18:40:36.9467987
40.1420911090072
-73.9627930359167
POINT (-73.962793035916675 40.142091109007175)

1
5283
2024-05-04 18:40:36.9467987
40.1420911090072
-73.9627930359167
POINT (-73.962793035916675 40.142091109007175)

1
5284
2024-05-03 18:40:36.9467987
40.1420911090072
-73.9627930359167
POINT (-73.962793035916675 40.142091109007175)

1
5361
2024-05-06 18:40:36.9467987
40.1422022318738
-74.0364806001375
POINT (-74.036480600137523 40.142202231873831)

1
5362
2024-05-05 18:40:36.9467987
40.1422022318738
-74.0364806001375
POINT (-74.036480600137523 40.142202231873831)

1
5363
2024-05-04 18:40:36.9467987
40.1422022318738
-74.0364806001375
POINT (-74.036480600137523 40.142202231873831)

1
5364
2024-05-03 18:40:36.9467987
40.1422022318738
-74.0364806001375
POINT (-74.036480600137523 40.142202231873831)

1
5291
2024-05-06 18:40:36.9467987
40.1433236164225
-73.9719224122925
POINT (-73.971922412292486 40.1433236164225)

1
5292
2024-05-05 18:40:36.9467987
40.1433236164225
-73.9719224122925
POINT (-73.971922412292486 40.1433236164225)

1
5293
2024-05-04 18:40:36.9467987
40.1433236164225
-73.9719224122925
POINT (-73.971922412292486 40.1433236164225)

1
5294
2024-05-03 18:40:36.9467987
40.1433236164225
-73.9719224122925
POINT (-73.971922412292486 40.1433236164225)

1
5351
2024-05-06 18:40:36.9467987
40.1434071951488
-74.0273449695742
POINT (-74.027344969574244 40.143407195148832)

1
5352
2024-05-05 18:40:36.9467987
40.1434071951488
-74.0273449695742
POINT (-74.027344969574244 40.143407195148832)

1
5353
2024-05-04 18:40:36.9467987
40.1434071951488
-74.0273449695742
POINT (-74.027344969574244 40.143407195148832)

1
5354
2024-05-03 18:40:36.9467987
40.1434071951488
-74.0273449695742
POINT (-74.027344969574244 40.143407195148832)

1
5301
2024-05-06 18:40:36.9467987
40.144210131601
-73.9811198571789
POINT (-73.981119857178868 40.144210131601)

1
5302
2024-05-05 18:40:36.9467987
40.144210131601
-73.9811198571789
POINT (-73.981119857178868 40.144210131601)

1
5303
2024-05-04 18:40:36.9467987
40.144210131601
-73.9811198571789
POINT (-73.981119857178868 40.144210131601)

1
5304
2024-05-03 18:40:36.9467987
40.144210131601
-73.9811198571789
POINT (-73.981119857178868 40.144210131601)

1
5341
2024-05-06 18:40:36.9467987
40.1442659635745
-74.0181430463418
POINT (-74.018143046341834 40.144265963574519)

1
5342
2024-05-05 18:40:36.9467987
40.1442659635745
-74.0181430463418
POINT (-74.018143046341834 40.144265963574519)

1
5343
2024-05-04 18:40:36.9467987
40.1442659635745
-74.0181430463418
POINT (-74.018143046341834 40.144265963574519)

1
5344
2024-05-03 18:40:36.9467987
40.1442659635745
-74.0181430463418
POINT (-74.018143046341834 40.144265963574519)

1
5311
2024-05-06 18:40:36.9467987
40.1447485054048
-73.9903630750002
POINT (-73.990363075000232 40.14474850540482)

1
5312
2024-05-05 18:40:36.9467987
40.1447485054048
-73.9903630750002
POINT (-73.990363075000232 40.14474850540482)

1
5313
2024-05-04 18:40:36.9467987
40.1447485054048
-73.9903630750002
POINT (-73.990363075000232 40.14474850540482)

1
5314
2024-05-03 18:40:36.9467987
40.1447485054048
-73.9903630750002
POINT (-73.990363075000232 40.14474850540482)

1
5331
2024-05-06 18:40:36.9467987
40.1447764552719
-74.0088971370793
POINT (-74.008897137079273 40.14477645527186)

1
5332
2024-05-05 18:40:36.9467987
40.1447764552719
-74.0088971370793
POINT (-74.008897137079273 40.14477645527186)

1
5333
2024-05-04 18:40:36.9467987
40.1447764552719
-74.0088971370793
POINT (-74.008897137079273 40.14477645527186)

1
5334
2024-05-03 18:40:36.9467987
40.1447764552719
-74.0088971370793
POINT (-74.008897137079273 40.14477645527186)

1
5321
2024-05-06 18:40:36.9467987
40.1449374326382
-73.9996296570964
POINT (-73.999629657096449 40.144937432638208)

1
5322
2024-05-05 18:40:36.9467987
40.1449374326382
-73.9996296570964
POINT (-73.999629657096449 40.144937432638208)

1
5323
2024-05-04 18:40:36.9467987
40.1449374326382
-73.9996296570964
POINT (-73.999629657096449 40.144937432638208)

1
5324
2024-05-03 18:40:36.9467987
40.1449374326382
-73.9996296570964
POINT (-73.999629657096449 40.144937432638208)




Microsoft SQL Server 2005 XML Showplan


<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.481" Build="14.0.3451.2"><BatchSequence><Batch><Statements><StmtSimple StatementText="WITH CTE AS&#xa;(&#xa;select most_recent= iif(row_number() over (partition by latitude,longitude order by transaction_dt desc) &lt; 5,1,null)&#xa;,*&#xa;from dbo.v_example2&#xa;where latlong.STDistance(geography::Point(40,-74,4326)) &lt;=1609.344e1&#xa;)&#xa;SELECT&#xa;* &#xa;FROM CTE&#xa;WHERE most_recent is not null" StatementId="1" StatementCompId="2" StatementType="SELECT" RetrievedFromCache="true" StatementSubTreeCost="2.08297" StatementEstRows="11610" SecurityPolicyApplied="false" StatementOptmLevel="FULL" QueryHash="0xB4E699776065D861" QueryPlanHash="0x0C9AB86336F2A569" 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="7264" NonParallelPlanReason="NoParallelPlansInDesktopOrExpressEdition" CachedPlanSize="88" CompileTime="112" CompileCPU="96" CompileMemory="760"><MemoryGrantInfo SerialRequiredMemory="1536" SerialDesiredMemory="7264" RequiredMemory="1536" DesiredMemory="7264" RequestedMemory="7264" GrantWaitTime="0" GrantedMemory="7264" MaxUsedMemory="584" MaxQueryMemory="408264"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="610688"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-05-06T18:40:57.34" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_36B12243]" Table="[extended_index_885578193_384000]" Schema="[sys]" Database="[fiddle_5f0c8faa376346c4994e02f50d916714]"></StatisticsInfo><StatisticsInfo LastUpdate="2024-05-06T18:40:56.27" ModificationCount="0" SamplingPercent="100" Statistics="[s_example]" Table="[extended_index_885578193_384000]" Schema="[sys]" Database="[fiddle_5f0c8faa376346c4994e02f50d916714]"></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="60" CpuTime="60"></QueryTimeStats><RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="11610" EstimateIO="0" EstimateCPU="0.001161" AvgRowSize="4067" EstimatedTotalSubtreeCost="2.08297" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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="11610" EstimateIO="0" EstimateCPU="0.037926" AvgRowSize="4071" EstimatedTotalSubtreeCost="2.08181" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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="60" ActualCPUms="60" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Filter StartupExpression="0"><RelOp NodeId="2" PhysicalOp="Sequence Project" LogicalOp="Compute Scalar" EstimateRows="38700" EstimateIO="0" EstimateCPU="0.003096" AvgRowSize="4071" EstimatedTotalSubtreeCost="2.04388" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ColumnReference Column="Expr1002"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="650" Batches="0" ActualExecutionMode="Row" ActualElapsedms="60" ActualCPUms="60" 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="38700" EstimateIO="0" EstimateCPU="0.000774" AvgRowSize="4071" EstimatedTotalSubtreeCost="2.04079" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ColumnReference Column="Segment1015"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="650" Batches="0" ActualExecutionMode="Row" ActualElapsedms="60" ActualCPUms="60" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><Segment><GroupBy><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference></GroupBy><SegmentColumn><ColumnReference Column="Segment1015"></ColumnReference></SegmentColumn><RelOp NodeId="4" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="38700" EstimateIO="0" EstimateCPU="0.00150131" AvgRowSize="4063" EstimatedTotalSubtreeCost="2.04001" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="650" Batches="0" ActualExecutionMode="Row" ActualElapsedms="60" ActualCPUms="60" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></OuterReferences><RelOp NodeId="5" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="359.166" EstimateIO="0.0112613" EstimateCPU="0.00486419" AvgRowSize="8090" EstimatedTotalSubtreeCost="1.67849" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row"><OutputList><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></OutputList><MemoryFractions Input="0.997207" Output="1"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1290" Batches="0" ActualExecutionMode="Row" ActualElapsedms="43" ActualCPUms="43" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="6224" OutputMemoryGrant="5856" UsedMemoryGrant="232"></RunTimeCountersPerThread></RunTimeInformation><Sort Distinct="0"><OrderBy><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference></OrderByColumn><OrderByColumn Ascending="1"><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference></OrderByColumn><OrderByColumn Ascending="0"><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference></OrderByColumn></OrderBy><RelOp NodeId="6" 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_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ScalarOperator ScalarString="[fiddle_5f0c8faa376346c4994e02f50d916714].[dbo].[example].[latlong]"><Identifier><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference></Identifier></ScalarOperator></DefinedValue></DefinedValues><RelOp NodeId="7" 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_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ColumnReference Column="Expr1006"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1290" Batches="0" ActualExecutionMode="Row" ActualElapsedms="43" ActualCPUms="43" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0" WithUnorderedPrefetch="1"><OuterReferences><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="pk0"></ColumnReference><ColumnReference Column="Expr1014"></ColumnReference></OuterReferences><RelOp NodeId="9" 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="Expr1006"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="pk0"></ColumnReference></OutputList><MemoryFractions Input="1" Output="0.0027933"></MemoryFractions><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1290" Batches="0" ActualExecutionMode="Row" ActualElapsedms="43" ActualCPUms="43" ActualScans="0" ActualLogicalReads="0" ActualPhysicalReads="0" ActualReadAheads="0" ActualLobLogicalReads="0" ActualLobPhysicalReads="0" ActualLobReadAheads="0" ActualEndOfScans="1" ActualExecutions="1" InputMemoryGrant="6752" OutputMemoryGrant="1040" UsedMemoryGrant="352"></RunTimeCountersPerThread></RunTimeInformation><Hash><DefinedValues><DefinedValue><ColumnReference Column="Expr1006"></ColumnReference><ScalarOperator ScalarString="MAX([Expr1011])"><Aggregate Distinct="0" AggType="MAX"><ScalarOperator><Identifier><ColumnReference Column="Expr1011"></ColumnReference></Identifier></ScalarOperator></Aggregate></ScalarOperator></DefinedValue></DefinedValues><HashKeysBuild><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="pk0"></ColumnReference></HashKeysBuild><RelOp NodeId="10" 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_5f0c8faa376346c4994e02f50d916714]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="pk0"></ColumnReference><ColumnReference Column="Expr1011"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Column="Expr1011"></ColumnReference><ScalarOperator ScalarString="[fiddle_5f0c8faa376346c4994e02f50d916714].[sys].[extended_index_885578193_384000].[Attr]+[Attr]"><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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="11" 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_5f0c8faa376346c4994e02f50d916714]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="Attr"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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="43" ActualCPUms="43" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0" WithUnorderedPrefetch="1"><OuterReferences><ColumnReference Column="Id"></ColumnReference><ColumnReference Column="LimitId"></ColumnReference><ColumnReference Column="Expr1013"></ColumnReference></OuterReferences><RelOp NodeId="13" 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="43" ActualCPUms="43" 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="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><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="14" 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_5f0c8faa376346c4994e02f50d916714]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="Attr"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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_5f0c8faa376346c4994e02f50d916714]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="Attr"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="pk0"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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_5f0c8faa376346c4994e02f50d916714]" 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_5f0c8faa376346c4994e02f50d916714]" 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="15" 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_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Index="[pk_example]" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[fiddle_5f0c8faa376346c4994e02f50d916714].[sys].[extended_index_885578193_384000].[pk0]"><Identifier><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="pk0"></ColumnReference></Identifier></ScalarOperator></RangeExpressions></Prefix></SeekKeys></SeekPredicateNew></SeekPredicates></IndexScan></RelOp></NestedLoops></RelOp></ComputeScalar></RelOp></Sort></RelOp><RelOp NodeId="16" 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="17" 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 [Expr1006]&gt;(2) THEN SridMatch([fiddle_5f0c8faa376346c4994e02f50d916714].[dbo].[example].[latlong],[geography]::Point((4.0000000000000000e+001),(-7.4000000000000000e+001),(4326))) ELSE [fiddle_5f0c8faa376346c4994e02f50d916714].[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="Expr1006"></ColumnReference></Identifier></ScalarOperator><ScalarOperator><Const ConstValue="(2)"></Const></ScalarOperator></Compare></ScalarOperator></Condition><Then><ScalarOperator><Intrinsic FunctionName="SridMatch"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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></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_5f0c8faa376346c4994e02f50d916714]" 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></Else></IF></ScalarOperator></Predicate></Filter></RelOp></NestedLoops></RelOp></Segment></RelOp></SequenceProject></RelOp><Predicate><ScalarOperator ScalarString="CASE WHEN [Expr1002]&lt;(5) THEN (1) ELSE NULL END IS NOT NULL"><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></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
2024-05-03 18:40:36.9467987
39.8836979593953
-74.1123744863092
POINT (-74.112374486309164 39.883697959395327)

5193
2024-05-04 18:40:36.9467987
40.1161909066071
-73.8872446774006
POINT (-73.887244677400631 40.116190906607088)

5857
2024-04-30 18:40:36.9467987
39.875786151413
-74.0970316580654
POINT (-74.0970316580654 39.875786151412953)

5456
2024-05-01 18:40:36.9467987
40.1165300877096
-74.1121612064384
POINT (-74.112161206438373 40.116530087709577)

6120
2024-04-27 18:40:36.9467987
39.892345584843
-73.8739094010218
POINT (-73.873909401021763 39.892345584842978)

5479
2024-04-28 18:40:36.9467987
40.1075136606765
-74.1264886339523
POINT (-74.126488633952292 40.10751366067651)

5811
2024-05-06 18:40:36.9467987
39.89272844709
-74.1266405661269
POINT (-74.126640566126937 39.892728447089972)

5247
2024-04-30 18:40:36.9467987
40.1337733226225
-73.9273950995621
POINT (-73.9273950995621 40.133773322622467)

5828
2024-04-29 18:40:36.9467987
39.8880785347519
-74.1196509469795
POINT (-74.119650946979462 39.888078534751891)

5840
2024-04-27 18:40:36.9467987
39.8836979593953
-74.1123744863092
POINT (-74.112374486309164 39.883697959395327)

5425
2024-05-02 18:40:36.9467987
40.1279235960576
-74.0886805313313
POINT (-74.08868053133132 40.127923596057606)

5187
2024-04-30 18:40:36.9467987
40.1117959294713
-73.8799588167048
POINT (-73.879958816704828 40.11179592947127)

6066
2024-05-01 18:40:36.9467987
39.8720052112403
-73.9116517695578
POINT (-73.9116517695578 39.872005211240271)

5293
2024-05-04 18:40:36.9467987
40.1433236164225
-73.9719224122925
POINT (-73.971922412292486 40.1433236164225)

5874
2024-05-03 18:40:36.9467987
39.8690688229611
-74.080759413171
POINT (-74.080759413171023 39.86906882296109)

5379
2024-04-28 18:40:36.9467987
40.1406539947625
-74.0455277951493
POINT (-74.045527795149312 40.140653994762495)

5233
2024-05-04 18:40:36.9467987
40.1308721421233
-73.918932716477
POINT (-73.918932716477045 40.13087214212328)

5934
2024-05-03 18:40:36.9467987
39.8566662301413
-74.0279619227726
POINT (-74.027961922772647 39.856666230141286)

6020
2024-04-27 18:40:36.9467987
39.8593244185206
-73.9546605124076
POINT (-73.954660512407557 39.8593244185206)

5333
2024-05-04 18:40:36.9467987
40.1447764552719
-74.0088971370793
POINT (-74.008897137079273 40.14477645527186)

5339
2024-04-28 18:40:36.9467987
40.1447764552719
-74.0088971370793
POINT (-74.008897137079273 40.14477645527186)

6080
2024-04-27 18:40:36.9467987
39.8754931279851
-73.9036044265936
POINT (-73.903604426593589 39.875493127985109)

5433
2024-05-04 18:40:36.9467987
40.1244228833921
-74.0967480841038
POINT (-74.0967480841038 40.124422883392128)

5439
2024-04-28 18:40:36.9467987
40.1244228833921
-74.0967480841038
POINT (-74.0967480841038 40.124422883392128)

5974
2024-05-03 18:40:36.9467987
39.8552191771366
-73.9911420761936
POINT (-73.99114207619364 39.855219177136561)

5980
2024-04-27 18:40:36.9467987
39.8552191771366
-73.9911420761936
POINT (-73.99114207619364 39.855219177136561)

5287
2024-04-30 18:40:36.9467987
40.1420911090072
-73.9627930359167
POINT (-73.962793035916675 40.142091109007175)

5880
2024-04-27 18:40:36.9467987
39.8690688229611
-74.080759413171
POINT (-74.080759413171023 39.86906882296109)

6126
2024-05-01 18:40:36.9467987
39.8972333905517
-73.8671984670204
POINT (-73.867198467020359 39.8972333905517)

5239
2024-04-28 18:40:36.9467987
40.1308721421233
-73.918932716477
POINT (-73.918932716477045 40.13087214212328)

5485
2024-05-02 18:40:36.9467987
40.1026109522104
-74.1332015704258
POINT (-74.133201570425825 40.102610952210419)

6026
2024-05-01 18:40:36.9467987
39.8612045082636
-73.9457573143311
POINT (-73.9457573143311 39.861204508263583)

5917
2024-04-30 18:40:36.9467987
39.8594628775953
-74.0460583099265
POINT (-74.046058309926508 39.859462877595327)

5419
2024-04-28 18:40:36.9467987
40.1311156366514
-74.0803981366358
POINT (-74.080398136635836 40.131115636651366)

6083
2024-05-04 18:40:36.9467987
39.8792805460761
-73.8957880477504
POINT (-73.8957880477504 39.879280546076075)

6060
2024-04-27 18:40:36.9467987
39.8688251526908
-73.9199107629876
POINT (-73.919910762987641 39.8688251526908)

5207
2024-04-30 18:40:36.9467987
40.1203056275055
-73.8948035632537
POINT (-73.894803563253731 40.120305627505516)

5370
2024-04-27 18:40:36.9467987
40.1422022318738
-74.0364806001375
POINT (-74.036480600137523 40.142202231873831)

5184
2024-05-03 18:40:36.9467987
40.1117959294713
-73.8799588167048
POINT (-73.879958816704828 40.11179592947127)

5848
2024-04-29 18:40:36.9467987
39.879597222123
-74.1048286796057
POINT (-74.104828679605731 39.879597222123031)

5442
2024-05-05 18:40:36.9467987
40.1206219786962
-74.1045812863513
POINT (-74.104581286351291 40.120621978696207)

5393
2024-05-04 18:40:36.9467987
40.1365435334158
-74.0632694531001
POINT (-74.063269453100133 40.136543533415811)

5256
2024-05-01 18:40:36.9467987
40.1363516578974
-73.9360334244253
POINT (-73.9360334244253 40.13635165789735)

5250
2024-04-27 18:40:36.9467987
40.1337733226225
-73.9273950995621
POINT (-73.9273950995621 40.133773322622467)

6009
2024-04-28 18:40:36.9467987
39.8577825588499
-73.9636722675078
POINT (-73.963672267507846 39.857782558849934)

6109
2024-04-28 18:40:36.9467987
39.8877168852471
-73.8809226707491
POINT (-73.880922670749058 39.887716885247116)

5299
2024-04-28 18:40:36.9467987
40.1433236164225
-73.9719224122925
POINT (-73.971922412292486 40.1433236164225)

5966
2024-05-01 18:40:36.9467987
39.8550589352619
-74.0003704441225
POINT (-74.000370444122524 39.855058935261944)

5376
2024-05-01 18:40:36.9467987
40.1406539947625
-74.0455277951493
POINT (-74.045527795149312 40.140653994762495)

6040
2024-04-27 18:40:36.9467987
39.8634183261066
-73.9369840009815
POINT (-73.936984000981539 39.863418326106554)

5350
2024-04-27 18:40:36.9467987
40.1442659635745
-74.0181430463418
POINT (-74.018143046341834 40.144265963574519)

5276
2024-05-01 18:40:36.9467987
40.1405155971263
-73.9537538554862
POINT (-73.953753855486227 40.1405155971263)

5227
2024-04-30 18:40:36.9467987
40.127655146052
-73.9106667566745
POINT (-73.910666756674487 40.127655146052042)

5817
2024-04-30 18:40:36.9467987
39.89272844709
-74.1266405661269
POINT (-74.126640566126937 39.892728447089972)

5891
2024-05-06 18:40:36.9467987
39.8636103097967
-74.0637138411498
POINT (-74.063713841149834 39.863610309796677)

5940
2024-04-27 18:40:36.9467987
39.8566662301413
-74.0279619227726
POINT (-74.027961922772647 39.856666230141286)

5399
2024-04-28 18:40:36.9467987
40.1365435334158
-74.0632694531001
POINT (-74.063269453100133 40.136543533415811)

5176
2024-05-01 18:40:36.9467987
40.1071313366801
-73.872963566699
POINT (-73.872963566698971 40.107131336680133)

5911
2024-05-06 18:40:36.9467987
39.8594628775953
-74.0460583099265
POINT (-74.046058309926508 39.859462877595327)

5413
2024-05-04 18:40:36.9467987
40.1311156366514
-74.0803981366358
POINT (-74.080398136635836 40.131115636651366)

6089
2024-04-28 18:40:36.9467987
39.8792805460761
-73.8957880477504
POINT (-73.8957880477504 39.879280546076075)

5960
2024-04-27 18:40:36.9467987
39.8552471360297
-74.0095979252562
POINT (-74.00959792525623 39.855247136029746)

5356
2024-05-01 18:40:36.9467987
40.1434071951488
-74.0273449695742
POINT (-74.027344969574244 40.143407195148832)

5319
2024-04-28 18:40:36.9467987
40.1447485054048
-73.9903630750002
POINT (-73.990363075000232 40.14474850540482)

5307
2024-04-30 18:40:36.9467987
40.144210131601
-73.9811198571789
POINT (-73.981119857178868 40.144210131601)

5270
2024-04-27 18:40:36.9467987
40.1386008998059
-73.9448267756848
POINT (-73.944826775684845 40.138600899805908)

5897
2024-04-30 18:40:36.9467987
39.8636103097967
-74.0637138411498
POINT (-74.063713841149834 39.863610309796677)

5946
2024-05-01 18:40:36.9467987
39.8557833288826
-74.0188024300137
POINT (-74.0188024300137 39.855783328882588)

5997
2024-04-30 18:40:36.9467987
39.8565826210426
-73.9727709968065
POINT (-73.972770996806489 39.856582621042584)

6003
2024-05-04 18:40:36.9467987
39.8577825588499
-73.9636722675078
POINT (-73.963672267507846 39.857782558849934)

6103
2024-05-04 18:40:36.9467987
39.8877168852471
-73.8809226707491
POINT (-73.880922670749058 39.887716885247116)

5213
2024-05-04 18:40:36.9467987
40.1241301282421
-73.9026172175202
POINT (-73.902617217520174 40.124130128242136)

5462
2024-05-05 18:40:36.9467987
40.1121571192162
-74.1194695358892
POINT (-74.119469535889166 40.112157119216178)

5954
2024-05-03 18:40:36.9467987
39.8552471360297
-74.0095979252562
POINT (-74.00959792525623 39.855247136029746)

5313
2024-05-04 18:40:36.9467987
40.1447485054048
-73.9903630750002
POINT (-73.990363075000232 40.14474850540482)

5854
2024-05-03 18:40:36.9467987
39.875786151413
-74.0970316580654
POINT (-74.0970316580654 39.875786151412953)

5903
2024-05-04 18:40:36.9467987
39.8613699277074
-74.0549518674478
POINT (-74.054951867447812 39.861369927707436)

5362
2024-05-05 18:40:36.9467987
40.1422022318738
-74.0364806001375
POINT (-74.036480600137523 40.142202231873831)

5336
2024-05-01 18:40:36.9467987
40.1447764552719
-74.0088971370793
POINT (-74.008897137079273 40.14477645527186)

6000
2024-04-27 18:40:36.9467987
39.8565826210426
-73.9727709968065
POINT (-73.972770996806489 39.856582621042584)

5359
2024-04-28 18:40:36.9467987
40.1434071951488
-74.0273449695742
POINT (-74.027344969574244 40.143407195148832)

6023
2024-05-04 18:40:36.9467987
39.8612045082636
-73.9457573143311
POINT (-73.9457573143311 39.861204508263583)

5453
2024-05-04 18:40:36.9467987
40.1165300877096
-74.1121612064384
POINT (-74.112161206438373 40.116530087709577)

5883
2024-05-04 18:40:36.9467987
39.866178658638
-74.0723232353388
POINT (-74.0723232353388 39.86617865863802)

5382
2024-05-05 18:40:36.9467987
40.1387662367477
-74.054464630135
POINT (-74.054464630135 40.1387662367477)

6046
2024-05-01 18:40:36.9467987
39.8659605704808
-73.9283615947162
POINT (-73.9283615947162 39.865960570480844)

5196
2024-05-01 18:40:36.9467987
40.1161909066071
-73.8872446774006
POINT (-73.887244677400631 40.116190906607088)

5860
2024-04-27 18:40:36.9467987
39.875786151413
-74.0970316580654
POINT (-74.0970316580654 39.875786151412953)

5405
2024-05-02 18:40:36.9467987
40.1339912717127
-74.0719209378814
POINT (-74.071920937881387 40.133991271712652)

6069
2024-04-28 18:40:36.9467987
39.8720052112403
-73.9116517695578
POINT (-73.9116517695578 39.872005211240271)

5173
2024-05-04 18:40:36.9467987
40.1071313366801
-73.872963566699
POINT (-73.872963566698971 40.107131336680133)

5837
2024-04-30 18:40:36.9467987
39.8836979593953
-74.1123744863092
POINT (-74.112374486309164 39.883697959395327)

6092
2024-05-05 18:40:36.9467987
39.8833583896531
-73.888221402349
POINT (-73.888221402348975 39.8833583896531)

5476
2024-05-01 18:40:36.9467987
40.1075136606765
-74.1264886339523
POINT (-74.126488633952292 40.10751366067651)

5814
2024-05-03 18:40:36.9467987
39.89272844709
-74.1266405661269
POINT (-74.126640566126937 39.892728447089972)

5342
2024-05-05 18:40:36.9467987
40.1442659635745
-74.0181430463418
POINT (-74.018143046341834 40.144265963574519)

5330
2024-04-27 18:40:36.9467987
40.1449374326382
-73.9996296570964
POINT (-73.999629657096449 40.144937432638208)

5923
2024-05-04 18:40:36.9467987
39.8578937260205
-74.0370544736288
POINT (-74.037054473628828 39.857893726020514)

6077
2024-04-30 18:40:36.9467987
39.8754931279851
-73.9036044265936
POINT (-73.903604426593589 39.875493127985109)

5236
2024-05-01 18:40:36.9467987
40.1308721421233
-73.918932716477
POINT (-73.918932716477045 40.13087214212328)

5390
2024-04-27 18:40:36.9467987
40.1387662367477
-74.054464630135
POINT (-74.054464630135 40.1387662367477)

6017
2024-04-30 18:40:36.9467987
39.8593244185206
-73.9546605124076
POINT (-73.954660512407557 39.8593244185206)

6029
2024-04-28 18:40:36.9467987
39.8612045082636
-73.9457573143311
POINT (-73.9457573143311 39.861204508263583)

5296
2024-05-01 18:40:36.9467987
40.1433236164225
-73.9719224122925
POINT (-73.971922412292486 40.1433236164225)

5983
2024-05-04 18:40:36.9467987
39.8557274780307
-73.9819349131332
POINT (-73.981934913133173 39.855727478030737)

5831
2024-05-06 18:40:36.9467987
39.8836979593953
-74.1123744863092
POINT (-74.112374486309164 39.883697959395327)

5482
2024-05-05 18:40:36.9467987
40.1026109522104
-74.1332015704258
POINT (-74.133201570425825 40.102610952210419)

5488
2024-04-29 18:40:36.9467987
40.1026109522104
-74.1332015704258
POINT (-74.133201570425825 40.102610952210419)

5290
2024-04-27 18:40:36.9467987
40.1420911090072
-73.9627930359167
POINT (-73.962793035916675 40.142091109007175)

5877
2024-04-30 18:40:36.9467987
39.8690688229611
-74.080759413171
POINT (-74.080759413171023 39.86906882296109)

6123
2024-05-04 18:40:36.9467987
39.8972333905517
-73.8671984670204
POINT (-73.867198467020359 39.8972333905517)

5190
2024-04-27 18:40:36.9467987
40.1117959294713
-73.8799588167048
POINT (-73.879958816704828 40.11179592947127)

5436
2024-05-01 18:40:36.9467987
40.1244228833921
-74.0967480841038
POINT (-74.0967480841038 40.124422883392128)

5977
2024-04-30 18:40:36.9467987
39.8552191771366
-73.9911420761936
POINT (-73.99114207619364 39.855219177136561)

5253
2024-05-04 18:40:36.9467987
40.1363516578974
-73.9360334244253
POINT (-73.9360334244253 40.13635165789735)

5230
2024-04-27 18:40:36.9467987
40.127655146052
-73.9106667566745
POINT (-73.910666756674487 40.127655146052042)

5894
2024-05-03 18:40:36.9467987
39.8636103097967
-74.0637138411498
POINT (-74.063713841149834 39.863610309796677)

5396
2024-05-01 18:40:36.9467987
40.1365435334158
-74.0632694531001
POINT (-74.063269453100133 40.136543533415811)

5465
2024-05-02 18:40:36.9467987
40.1121571192162
-74.1194695358892
POINT (-74.119469535889166 40.112157119216178)

5871
2024-05-06 18:40:36.9467987
39.8690688229611
-74.080759413171
POINT (-74.080759413171023 39.86906882296109)

6129
2024-04-28 18:40:36.9467987
39.8972333905517
-73.8671984670204
POINT (-73.867198467020359 39.8972333905517)

6057
2024-04-30 18:40:36.9467987
39.8688251526908
-73.9199107629876
POINT (-73.919910762987641 39.8688251526908)

6106
2024-05-01 18:40:36.9467987
39.8877168852471
-73.8809226707491
POINT (-73.880922670749058 39.887716885247116)

5914
2024-05-03 18:40:36.9467987
39.8594628775953
-74.0460583099265
POINT (-74.046058309926508 39.859462877595327)

5920
2024-04-27 18:40:36.9467987
39.8594628775953
-74.0460583099265
POINT (-74.046058309926508 39.859462877595327)

5422
2024-05-05 18:40:36.9467987
40.1279235960576
-74.0886805313313
POINT (-74.08868053133132 40.127923596057606)

6086
2024-05-01 18:40:36.9467987
39.8792805460761
-73.8957880477504
POINT (-73.8957880477504 39.879280546076075)

5322
2024-05-05 18:40:36.9467987
40.1449374326382
-73.9996296570964
POINT (-73.999629657096449 40.144937432638208)

5273
2024-05-04 18:40:36.9467987
40.1405155971263
-73.9537538554862
POINT (-73.953753855486227 40.1405155971263)

5279
2024-04-28 18:40:36.9467987
40.1405155971263
-73.9537538554862
POINT (-73.953753855486227 40.1405155971263)

5820
2024-04-27 18:40:36.9467987
39.89272844709
-74.1266405661269
POINT (-74.126640566126937 39.892728447089972)

5937
2024-04-30 18:40:36.9467987
39.8566662301413
-74.0279619227726
POINT (-74.027961922772647 39.856666230141286)

5943
2024-05-04 18:40:36.9467987
39.8557833288826
-74.0188024300137
POINT (-74.0188024300137 39.855783328882588)

5445
2024-05-02 18:40:36.9467987
40.1206219786962
-74.1045812863513
POINT (-74.104581286351291 40.120621978696207)

5986
2024-05-01 18:40:36.9467987
39.8557274780307
-73.9819349131332
POINT (-73.981934913133173 39.855727478030737)

5204
2024-05-03 18:40:36.9467987
40.1203056275055
-73.8948035632537
POINT (-73.894803563253731 40.120305627505516)

5963
2024-05-04 18:40:36.9467987
39.8550589352619
-74.0003704441225
POINT (-74.000370444122524 39.855058935261944)

5373
2024-05-04 18:40:36.9467987
40.1406539947625
-74.0455277951493
POINT (-74.045527795149312 40.140653994762495)

6037
2024-04-30 18:40:36.9467987
39.8634183261066
-73.9369840009815
POINT (-73.936984000981539 39.863418326106554)

6063
2024-05-04 18:40:36.9467987
39.8720052112403
-73.9116517695578
POINT (-73.9116517695578 39.872005211240271)

6112
2024-05-05 18:40:36.9467987
39.892345584843
-73.8739094010218
POINT (-73.873909401021763 39.892345584842978)

5259
2024-04-28 18:40:36.9467987
40.1363516578974
-73.9360334244253
POINT (-73.9360334244253 40.13635165789735)

5994
2024-05-03 18:40:36.9467987
39.8565826210426
-73.9727709968065
POINT (-73.972770996806489 39.856582621042584)

6006
2024-05-01 18:40:36.9467987
39.8577825588499
-73.9636722675078
POINT (-73.963672267507846 39.857782558849934)

5353
2024-05-04 18:40:36.9467987
40.1434071951488
-74.0273449695742
POINT (-74.027344969574244 40.143407195148832)

5224
2024-05-03 18:40:36.9467987
40.127655146052
-73.9106667566745
POINT (-73.910666756674487 40.127655146052042)

5851
2024-05-06 18:40:36.9467987
39.875786151413
-74.0970316580654
POINT (-74.0970316580654 39.875786151412953)

5863
2024-05-04 18:40:36.9467987
39.8722738799244
-74.089002145372
POINT (-74.089002145371992 39.872273879924428)

5900
2024-04-27 18:40:36.9467987
39.8636103097967
-74.0637138411498
POINT (-74.063713841149834 39.863610309796677)

5402
2024-05-05 18:40:36.9467987
40.1339912717127
-74.0719209378814
POINT (-74.071920937881387 40.133991271712652)

5210
2024-04-27 18:40:36.9467987
40.1203056275055
-73.8948035632537
POINT (-73.894803563253731 40.120305627505516)

5957
2024-04-30 18:40:36.9467987
39.8552471360297
-74.0095979252562
POINT (-74.00959792525623 39.855247136029746)

6043
2024-05-04 18:40:36.9467987
39.8659605704808
-73.9283615947162
POINT (-73.9283615947162 39.865960570480844)

5416
2024-05-01 18:40:36.9467987
40.1311156366514
-74.0803981366358
POINT (-74.080398136635836 40.131115636651366)

5316
2024-05-01 18:40:36.9467987
40.1447485054048
-73.9903630750002
POINT (-73.990363075000232 40.14474850540482)

5310
2024-04-27 18:40:36.9467987
40.144210131601
-73.9811198571789
POINT (-73.981119857178868 40.144210131601)

5267
2024-04-30 18:40:36.9467987
40.1386008998059
-73.9448267756848
POINT (-73.944826775684845 40.138600899805908)

5808
2024-04-29 18:40:36.9467987
39.8976365474813
-74.1333265257813
POINT (-74.1333265257813 39.8976365474813)

5216
2024-05-01 18:40:36.9467987
40.1241301282421
-73.9026172175202
POINT (-73.902617217520174 40.124130128242136)

5459
2024-04-28 18:40:36.9467987
40.1165300877096
-74.1121612064384
POINT (-74.112161206438373 40.116530087709577)

6049
2024-04-28 18:40:36.9467987
39.8659605704808
-73.9283615947162
POINT (-73.9283615947162 39.865960570480844)

6100
2024-04-27 18:40:36.9467987
39.8833583896531
-73.888221402349
POINT (-73.888221402348975 39.8833583896531)

5431
2024-05-06 18:40:36.9467987
40.1244228833921
-74.0967480841038
POINT (-74.0967480841038 40.124422883392128)

6024
2024-05-03 18:40:36.9467987
39.8612045082636
-73.9457573143311
POINT (-73.9457573143311 39.861204508263583)

6095
2024-05-02 18:40:36.9467987
39.8833583896531
-73.888221402349
POINT (-73.888221402348975 39.8833583896531)

5408
2024-04-29 18:40:36.9467987
40.1339912717127
-74.0719209378814
POINT (-74.071920937881387 40.133991271712652)

6072
2024-05-05 18:40:36.9467987
39.8754931279851
-73.9036044265936
POINT (-73.903604426593589 39.875493127985109)

5477
2024-04-30 18:40:36.9467987
40.1075136606765
-74.1264886339523
POINT (-74.126488633952292 40.10751366067651)

5809
2024-04-28 18:40:36.9467987
39.8976365474813
-74.1333265257813
POINT (-74.1333265257813 39.8976365474813)

5454
2024-05-03 18:40:36.9467987
40.1165300877096
-74.1121612064384
POINT (-74.112161206438373 40.116530087709577)

6118
2024-04-29 18:40:36.9467987
39.892345584843
-73.8739094010218
POINT (-73.873909401021763 39.892345584842978)

5815
2024-05-02 18:40:36.9467987
39.89272844709
-74.1266405661269
POINT (-74.126640566126937 39.892728447089972)

5437
2024-04-30 18:40:36.9467987
40.1244228833921
-74.0967480841038
POINT (-74.0967480841038 40.124422883392128)

6018
2024-04-29 18:40:36.9467987
39.8593244185206
-73.9546605124076
POINT (-73.954660512407557 39.8593244185206)

5199
2024-04-28 18:40:36.9467987
40.1161909066071
-73.8872446774006
POINT (-73.887244677400631 40.116190906607088)

5377
2024-04-30 18:40:36.9467987
40.1406539947625
-74.0455277951493
POINT (-74.045527795149312 40.140653994762495)

6078
2024-04-29 18:40:36.9467987
39.8754931279851
-73.9036044265936
POINT (-73.903604426593589 39.875493127985109)

5886
2024-05-01 18:40:36.9467987
39.866178658638
-74.0723232353388
POINT (-74.0723232353388 39.86617865863802)

5391
2024-05-06 18:40:36.9467987
40.1365435334158
-74.0632694531001
POINT (-74.063269453100133 40.136543533415811)

5972
2024-05-05 18:40:36.9467987
39.8552191771366
-73.9911420761936
POINT (-73.99114207619364 39.855219177136561)

5331
2024-05-06 18:40:36.9467987
40.1447764552719
-74.0088971370793
POINT (-74.008897137079273 40.14477645527186)

5245
2024-05-02 18:40:36.9467987
40.1337733226225
-73.9273950995621
POINT (-73.9273950995621 40.133773322622467)

6032
2024-05-05 18:40:36.9467987
39.8634183261066
-73.9369840009815
POINT (-73.936984000981539 39.863418326106554)

5191
2024-05-06 18:40:36.9467987
40.1161909066071
-73.8872446774006
POINT (-73.887244677400631 40.116190906607088)

5185
2024-05-02 18:40:36.9467987
40.1117959294713
-73.8799588167048
POINT (-73.879958816704828 40.11179592947127)

5926
2024-05-01 18:40:36.9467987
39.8578937260205
-74.0370544736288
POINT (-74.037054473628828 39.857893726020514)

5932
2024-05-05 18:40:36.9467987
39.8566662301413
-74.0279619227726
POINT (-74.027961922772647 39.856666230141286)

5291
2024-05-06 18:40:36.9467987
40.1433236164225
-73.9719224122925
POINT (-73.971922412292486 40.1433236164225)

5285
2024-05-02 18:40:36.9467987
40.1420911090072
-73.9627930359167
POINT (-73.962793035916675 40.142091109007175)

5826
2024-05-01 18:40:36.9467987
39.8880785347519
-74.1196509469795
POINT (-74.119650946979462 39.888078534751891)

5832
2024-05-05 18:40:36.9467987
39.8836979593953
-74.1123744863092
POINT (-74.112374486309164 39.883697959395327)

5483
2024-05-04 18:40:36.9467987
40.1026109522104
-74.1332015704258
POINT (-74.133201570425825 40.102610952210419)

5385
2024-05-02 18:40:36.9467987
40.1387662367477
-74.054464630135
POINT (-74.054464630135 40.1387662367477)

5978
2024-04-29 18:40:36.9467987
39.8552191771366
-73.9911420761936
POINT (-73.99114207619364 39.855219177136561)

5337
2024-04-30 18:40:36.9467987
40.1447764552719
-74.0088971370793
POINT (-74.008897137079273 40.14477645527186)

5878
2024-04-29 18:40:36.9467987
39.8690688229611
-74.080759413171
POINT (-74.080759413171023 39.86906882296109)

6124
2024-05-03 18:40:36.9467987
39.8972333905517
-73.8671984670204
POINT (-73.867198467020359 39.8972333905517)

5182
2024-05-05 18:40:36.9467987
40.1117959294713
-73.8799588167048
POINT (-73.879958816704828 40.11179592947127)

5348
2024-04-29 18:40:36.9467987
40.1442659635745
-74.0181430463418
POINT (-74.018143046341834 40.144265963574519)

5846
2024-05-01 18:40:36.9467987
39.879597222123
-74.1048286796057
POINT (-74.104828679605731 39.879597222123031)

6107
2024-04-30 18:40:36.9467987
39.8877168852471
-73.8809226707491
POINT (-73.880922670749058 39.887716885247116)

5205
2024-05-02 18:40:36.9467987
40.1203056275055
-73.8948035632537
POINT (-73.894803563253731 40.120305627505516)

5254
2024-05-03 18:40:36.9467987
40.1363516578974
-73.9360334244253
POINT (-73.9360334244253 40.13635165789735)

5231
2024-05-06 18:40:36.9467987
40.1308721421233
-73.918932716477
POINT (-73.918932716477045 40.13087214212328)

5468
2024-04-29 18:40:36.9467987
40.1121571192162
-74.1194695358892
POINT (-74.119469535889166 40.112157119216178)

5895
2024-05-02 18:40:36.9467987
39.8636103097967
-74.0637138411498
POINT (-74.063713841149834 39.863610309796677)

6058
2024-04-29 18:40:36.9467987
39.8688251526908
-73.9199107629876
POINT (-73.919910762987641 39.8688251526908)

5823
2024-05-04 18:40:36.9467987
39.8880785347519
-74.1196509469795
POINT (-74.119650946979462 39.888078534751891)

5872
2024-05-05 18:40:36.9467987
39.8690688229611
-74.080759413171
POINT (-74.080759413171023 39.86906882296109)

5417
2024-04-30 18:40:36.9467987
40.1311156366514
-74.0803981366358
POINT (-74.080398136635836 40.131115636651366)

6081
2024-05-06 18:40:36.9467987
39.8792805460761
-73.8957880477504
POINT (-73.8957880477504 39.879280546076075)

5274
2024-05-03 18:40:36.9467987
40.1405155971263
-73.9537538554862
POINT (-73.953753855486227 40.1405155971263)

5938
2024-04-29 18:40:36.9467987
39.8566662301413
-74.0279619227726
POINT (-74.027961922772647 39.856666230141286)

6015
2024-05-02 18:40:36.9467987
39.8593244185206
-73.9546605124076
POINT (-73.954660512407557 39.8593244185206)

5225
2024-05-02 18:40:36.9467987
40.127655146052
-73.9106667566745
POINT (-73.910666756674487 40.127655146052042)

5889
2024-04-28 18:40:36.9467987
39.866178658638
-74.0723232353388
POINT (-74.0723232353388 39.86617865863802)

5397
2024-04-30 18:40:36.9467987
40.1365435334158
-74.0632694531001
POINT (-74.063269453100133 40.136543533415811)

6064
2024-05-03 18:40:36.9467987
39.8720052112403
-73.9116517695578
POINT (-73.9116517695578 39.872005211240271)

5325
2024-05-02 18:40:36.9467987
40.1449374326382
-73.9996296570964
POINT (-73.999629657096449 40.144937432638208)

5866
2024-05-01 18:40:36.9467987
39.8722738799244
-74.089002145372
POINT (-74.089002145371992 39.872273879924428)

5915
2024-05-02 18:40:36.9467987
39.8594628775953
-74.0460583099265
POINT (-74.046058309926508 39.859462877595327)

5448
2024-04-29 18:40:36.9467987
40.1206219786962
-74.1045812863513
POINT (-74.104581286351291 40.120621978696207)

5374
2024-05-03 18:40:36.9467987
40.1406539947625
-74.0455277951493
POINT (-74.045527795149312 40.140653994762495)

5989
2024-04-28 18:40:36.9467987
39.8557274780307
-73.9819349131332
POINT (-73.981934913133173 39.855727478030737)

6038
2024-04-29 18:40:36.9467987
39.8634183261066
-73.9369840009815
POINT (-73.936984000981539 39.863418326106554)

6087
2024-04-30 18:40:36.9467987
39.8792805460761
-73.8957880477504
POINT (-73.8957880477504 39.879280546076075)

5354
2024-05-03 18:40:36.9467987
40.1434071951488
-74.0273449695742
POINT (-74.027344969574244 40.143407195148832)

5852
2024-05-05 18:40:36.9467987
39.875786151413
-74.0970316580654
POINT (-74.0970316580654 39.875786151412953)

6101
2024-05-06 18:40:36.9467987
39.8877168852471
-73.8809226707491
POINT (-73.880922670749058 39.887716885247116)

5211
2024-05-06 18:40:36.9467987
40.1241301282421
-73.9026172175202
POINT (-73.902617217520174 40.124130128242136)

5317
2024-04-30 18:40:36.9467987
40.1447485054048
-73.9903630750002
POINT (-73.990363075000232 40.14474850540482)

5305
2024-05-02 18:40:36.9467987
40.144210131601
-73.9811198571789
POINT (-73.981119857178868 40.144210131601)

5909
2024-04-28 18:40:36.9467987
39.8613699277074
-74.0549518674478
POINT (-74.054951867447812 39.861369927707436)

5958
2024-04-29 18:40:36.9467987
39.8552471360297
-74.0095979252562
POINT (-74.00959792525623 39.855247136029746)

5368
2024-04-29 18:40:36.9467987
40.1422022318738
-74.0364806001375
POINT (-74.036480600137523 40.142202231873831)

5995
2024-05-02 18:40:36.9467987
39.8565826210426
-73.9727709968065
POINT (-73.972770996806489 39.856582621042584)

6044
2024-05-03 18:40:36.9467987
39.8659605704808
-73.9283615947162
POINT (-73.9283615947162 39.865960570480844)

5262
2024-05-05 18:40:36.9467987
40.1386008998059
-73.9448267756848
POINT (-73.944826775684845 40.138600899805908)

5268
2024-04-29 18:40:36.9467987
40.1386008998059
-73.9448267756848
POINT (-73.944826775684845 40.138600899805908)

5311
2024-05-06 18:40:36.9467987
40.1447485054048
-73.9903630750002
POINT (-73.990363075000232 40.14474850540482)

5803
2024-05-04 18:40:36.9467987
39.8976365474813
-74.1333265257813
POINT (-74.1333265257813 39.8976365474813)

6052
2024-05-05 18:40:36.9467987
39.8688251526908
-73.9199107629876
POINT (-73.919910762987641 39.8688251526908)

5460
2024-04-27 18:40:36.9467987
40.1165300877096
-74.1121612064384
POINT (-74.112161206438373 40.116530087709577)

5952
2024-05-05 18:40:36.9467987
39.8552471360297
-74.0095979252562
POINT (-74.00959792525623 39.855247136029746)

5411
2024-05-06 18:40:36.9467987
40.1311156366514
-74.0803981366358
POINT (-74.080398136635836 40.131115636651366)

6001
2024-05-06 18:40:36.9467987
39.8577825588499
-73.9636722675078
POINT (-73.963672267507846 39.857782558849934)

5265
2024-05-02 18:40:36.9467987
40.1386008998059
-73.9448267756848
POINT (-73.944826775684845 40.138600899805908)

5858
2024-04-29 18:40:36.9467987
39.875786151413
-74.0970316580654
POINT (-74.0970316580654 39.875786151412953)

5929
2024-04-28 18:40:36.9467987
39.8578937260205
-74.0370544736288
POINT (-74.037054473628828 39.857893726020514)

5242
2024-05-05 18:40:36.9467987
40.1337733226225
-73.9273950995621
POINT (-73.9273950995621 40.133773322622467)

5906
2024-05-01 18:40:36.9467987
39.8613699277074
-74.0549518674478
POINT (-74.054951867447812 39.861369927707436)

5219
2024-04-28 18:40:36.9467987
40.1241301282421
-73.9026172175202
POINT (-73.902617217520174 40.124130128242136)

5480
2024-04-27 18:40:36.9467987
40.1075136606765
-74.1264886339523
POINT (-74.126488633952292 40.10751366067651)

5812
2024-05-05 18:40:36.9467987
39.89272844709
-74.1266405661269
POINT (-74.126640566126937 39.892728447089972)

5171
2024-05-06 18:40:36.9467987
40.1071313366801
-73.872963566699
POINT (-73.872963566698971 40.107131336680133)

5835
2024-05-02 18:40:36.9467987
39.8836979593953
-74.1123744863092
POINT (-74.112374486309164 39.883697959395327)

5428
2024-04-29 18:40:36.9467987
40.1279235960576
-74.0886805313313
POINT (-74.08868053133132 40.127923596057606)

5451
2024-05-06 18:40:36.9467987
40.1165300877096
-74.1121612064384
POINT (-74.112161206438373 40.116530087709577)

6115
2024-05-02 18:40:36.9467987
39.892345584843
-73.8739094010218
POINT (-73.873909401021763 39.892345584842978)

5474
2024-05-03 18:40:36.9467987
40.1075136606765
-74.1264886339523
POINT (-74.126488633952292 40.10751366067651)

5188
2024-04-29 18:40:36.9467987
40.1117959294713
-73.8799588167048
POINT (-73.879958816704828 40.11179592947127)

5935
2024-05-02 18:40:36.9467987
39.8566662301413
-74.0279619227726
POINT (-74.027961922772647 39.856666230141286)

5248
2024-04-29 18:40:36.9467987
40.1337733226225
-73.9273950995621
POINT (-73.9273950995621 40.133773322622467)

5875
2024-05-02 18:40:36.9467987
39.8690688229611
-74.080759413171
POINT (-74.080759413171023 39.86906882296109)

5969
2024-04-28 18:40:36.9467987
39.8550589352619
-74.0003704441225
POINT (-74.000370444122524 39.855058935261944)

5981
2024-05-06 18:40:36.9467987
39.8557274780307
-73.9819349131332
POINT (-73.981934913133173 39.855727478030737)

5294
2024-05-03 18:40:36.9467987
40.1433236164225
-73.9719224122925
POINT (-73.971922412292486 40.1433236164225)

5282
2024-05-05 18:40:36.9467987
40.1420911090072
-73.9627930359167
POINT (-73.962793035916675 40.142091109007175)

5434
2024-05-03 18:40:36.9467987
40.1244228833921
-74.0967480841038
POINT (-74.0967480841038 40.124422883392128)

5440
2024-04-27 18:40:36.9467987
40.1244228833921
-74.0967480841038
POINT (-74.0967480841038 40.124422883392128)

6021
2024-05-06 18:40:36.9467987
39.8612045082636
-73.9457573143311
POINT (-73.9457573143311 39.861204508263583)

5334
2024-05-03 18:40:36.9467987
40.1447764552719
-74.0088971370793
POINT (-74.008897137079273 40.14477645527186)

6121
2024-05-06 18:40:36.9467987
39.8972333905517
-73.8671984670204
POINT (-73.867198467020359 39.8972333905517)

6127
2024-04-30 18:40:36.9467987
39.8972333905517
-73.8671984670204
POINT (-73.867198467020359 39.8972333905517)

5388
2024-04-29 18:40:36.9467987
40.1387662367477
-74.054464630135
POINT (-74.054464630135 40.1387662367477)

5975
2024-05-02 18:40:36.9467987
39.8552191771366
-73.9911420761936
POINT (-73.99114207619364 39.855219177136561)

5288
2024-04-29 18:40:36.9467987
40.1420911090072
-73.9627930359167
POINT (-73.962793035916675 40.142091109007175)

5829
2024-04-28 18:40:36.9467987
39.8880785347519
-74.1196509469795
POINT (-74.119650946979462 39.888078534751891)

6075
2024-05-02 18:40:36.9467987
39.8754931279851
-73.9036044265936
POINT (-73.903604426593589 39.875493127985109)

5941
2024-05-06 18:40:36.9467987
39.8557833288826
-74.0188024300137
POINT (-74.0188024300137 39.855783328882588)

6012
2024-05-05 18:40:36.9467987
39.8593244185206
-73.9546605124076
POINT (-73.954660512407557 39.8593244185206)

5869
2024-04-28 18:40:36.9467987
39.8722738799244
-74.089002145372
POINT (-74.089002145371992 39.872273879924428)

5918
2024-04-29 18:40:36.9467987
39.8594628775953
-74.0460583099265
POINT (-74.046058309926508 39.859462877595327)

5420
2024-04-27 18:40:36.9467987
40.1311156366514
-74.0803981366358
POINT (-74.080398136635836 40.131115636651366)

5371
2024-05-06 18:40:36.9467987
40.1406539947625
-74.0455277951493
POINT (-74.045527795149312 40.140653994762495)

6035
2024-05-02 18:40:36.9467987
39.8634183261066
-73.9369840009815
POINT (-73.936984000981539 39.863418326106554)

6084
2024-05-03 18:40:36.9467987
39.8792805460761
-73.8957880477504
POINT (-73.8957880477504 39.879280546076075)

5394
2024-05-03 18:40:36.9467987
40.1365435334158
-74.0632694531001
POINT (-74.063269453100133 40.136543533415811)

5208
2024-04-29 18:40:36.9467987
40.1203056275055
-73.8948035632537
POINT (-73.894803563253731 40.120305627505516)

5179
2024-04-28 18:40:36.9467987
40.1071313366801
-73.872963566699
POINT (-73.872963566698971 40.107131336680133)

5351
2024-05-06 18:40:36.9467987
40.1434071951488
-74.0273449695742
POINT (-74.027344969574244 40.143407195148832)

5345
2024-05-02 18:40:36.9467987
40.1442659635745
-74.0181430463418
POINT (-74.018143046341834 40.144265963574519)

5843
2024-05-04 18:40:36.9467987
39.879597222123
-74.1048286796057
POINT (-74.104828679605731 39.879597222123031)

5328
2024-04-29 18:40:36.9467987
40.1449374326382
-73.9996296570964
POINT (-73.999629657096449 40.144937432638208)

5961
2024-05-06 18:40:36.9467987
39.8550589352619
-74.0003704441225
POINT (-74.000370444122524 39.855058935261944)

5992
2024-05-05 18:40:36.9467987
39.8565826210426
-73.9727709968065
POINT (-73.972770996806489 39.856582621042584)

5302
2024-05-05 18:40:36.9467987
40.144210131601
-73.9811198571789
POINT (-73.981119857178868 40.144210131601)

5228
2024-04-29 18:40:36.9467987
40.127655146052
-73.9106667566745
POINT (-73.910666756674487 40.127655146052042)

5471
2024-05-06 18:40:36.9467987
40.1075136606765
-74.1264886339523
POINT (-74.126488633952292 40.10751366067651)

5892
2024-05-05 18:40:36.9467987
39.8636103097967
-74.0637138411498
POINT (-74.063713841149834 39.863610309796677)

5400
2024-04-27 18:40:36.9467987
40.1365435334158
-74.0632694531001
POINT (-74.063269453100133 40.136543533415811)

6061
2024-05-06 18:40:36.9467987
39.8720052112403
-73.9116517695578
POINT (-73.9116517695578 39.872005211240271)

5202
2024-05-05 18:40:36.9467987
40.1203056275055
-73.8948035632537
POINT (-73.894803563253731 40.120305627505516)

5251
2024-05-06 18:40:36.9467987
40.1363516578974
-73.9360334244253
POINT (-73.9360334244253 40.13635165789735)

5271
2024-05-06 18:40:36.9467987
40.1405155971263
-73.9537538554862
POINT (-73.953753855486227 40.1405155971263)

5912
2024-05-05 18:40:36.9467987
39.8594628775953
-74.0460583099265
POINT (-74.046058309926508 39.859462877595327)

5414
2024-05-03 18:40:36.9467987
40.1311156366514
-74.0803981366358
POINT (-74.080398136635836 40.131115636651366)

5365
2024-05-02 18:40:36.9467987
40.1422022318738
-74.0364806001375
POINT (-74.036480600137523 40.142202231873831)

6041
2024-05-06 18:40:36.9467987
39.8659605704808
-73.9283615947162
POINT (-73.9283615947162 39.865960570480844)

5308
2024-04-29 18:40:36.9467987
40.144210131601
-73.9811198571789
POINT (-73.981119857178868 40.144210131601)

5222
2024-05-05 18:40:36.9467987
40.127655146052
-73.9106667566745
POINT (-73.910666756674487 40.127655146052042)

5898
2024-04-29 18:40:36.9467987
39.8636103097967
-74.0637138411498
POINT (-74.063713841149834 39.863610309796677)

6055
2024-05-02 18:40:36.9467987
39.8688251526908
-73.9199107629876
POINT (-73.919910762987641 39.8688251526908)

5357
2024-04-30 18:40:36.9467987
40.1434071951488
-74.0273449695742
POINT (-74.027344969574244 40.143407195148832)

5849
2024-04-28 18:40:36.9467987
39.879597222123
-74.1048286796057
POINT (-74.104828679605731 39.879597222123031)

5855
2024-05-02 18:40:36.9467987
39.875786151413
-74.0970316580654
POINT (-74.0970316580654 39.875786151412953)

6098
2024-04-29 18:40:36.9467987
39.8833583896531
-73.888221402349
POINT (-73.888221402348975 39.8833583896531)

6104
2024-05-03 18:40:36.9467987
39.8877168852471
-73.8809226707491
POINT (-73.880922670749058 39.887716885247116)

5457
2024-04-30 18:40:36.9467987
40.1165300877096
-74.1121612064384
POINT (-74.112161206438373 40.116530087709577)

5949
2024-04-28 18:40:36.9467987
39.8557833288826
-74.0188024300137
POINT (-74.0188024300137 39.855783328882588)

5955
2024-05-02 18:40:36.9467987
39.8552471360297
-74.0095979252562
POINT (-74.00959792525623 39.855247136029746)

5998
2024-04-29 18:40:36.9467987
39.8565826210426
-73.9727709968065
POINT (-73.972770996806489 39.856582621042584)

5314
2024-05-03 18:40:36.9467987
40.1447485054048
-73.9903630750002
POINT (-73.990363075000232 40.14474850540482)

5806
2024-05-01 18:40:36.9467987
39.8976365474813
-74.1333265257813
POINT (-74.1333265257813 39.8976365474813)

5360
2024-04-27 18:40:36.9467987
40.1434071951488
-74.0273449695742
POINT (-74.027344969574244 40.143407195148832)

5289
2024-04-28 18:40:36.9467987
40.1420911090072
-73.9627930359167
POINT (-73.962793035916675 40.142091109007175)

5953
2024-05-04 18:40:36.9467987
39.8552471360297
-74.0095979252562
POINT (-74.00959792525623 39.855247136029746)

5266
2024-05-01 18:40:36.9467987
40.1386008998059
-73.9448267756848
POINT (-73.944826775684845 40.138600899805908)

5930
2024-04-27 18:40:36.9467987
39.8578937260205
-74.0370544736288
POINT (-74.037054473628828 39.857893726020514)

5383
2024-05-04 18:40:36.9467987
40.1387662367477
-74.054464630135
POINT (-74.054464630135 40.1387662367477)

6047
2024-04-30 18:40:36.9467987
39.8659605704808
-73.9283615947162
POINT (-73.9283615947162 39.865960570480844)

5243
2024-05-04 18:40:36.9467987
40.1337733226225
-73.9273950995621
POINT (-73.9273950995621 40.133773322622467)

5907
2024-04-30 18:40:36.9467987
39.8613699277074
-74.0549518674478
POINT (-74.054951867447812 39.861369927707436)

5406
2024-05-01 18:40:36.9467987
40.1339912717127
-74.0719209378814
POINT (-74.071920937881387 40.133991271712652)

6070
2024-04-27 18:40:36.9467987
39.8720052112403
-73.9116517695578
POINT (-73.9116517695578 39.872005211240271)

5220
2024-04-27 18:40:36.9467987
40.1241301282421
-73.9026172175202
POINT (-73.902617217520174 40.124130128242136)

5884
2024-05-03 18:40:36.9467987
39.866178658638
-74.0723232353388
POINT (-74.0723232353388 39.86617865863802)

5429
2024-04-28 18:40:36.9467987
40.1279235960576
-74.0886805313313
POINT (-74.08868053133132 40.127923596057606)

6093
2024-05-04 18:40:36.9467987
39.8833583896531
-73.888221402349
POINT (-73.888221402348975 39.8833583896531)

5197
2024-04-30 18:40:36.9467987
40.1161909066071
-73.8872446774006
POINT (-73.887244677400631 40.116190906607088)

5452
2024-05-05 18:40:36.9467987
40.1165300877096
-74.1121612064384
POINT (-74.112161206438373 40.116530087709577)

5861
2024-05-06 18:40:36.9467987
39.8722738799244
-74.089002145372
POINT (-74.089002145371992 39.872273879924428)

6116
2024-05-01 18:40:36.9467987
39.892345584843
-73.8739094010218
POINT (-73.873909401021763 39.892345584842978)

5174
2024-05-03 18:40:36.9467987
40.1071313366801
-73.872963566699
POINT (-73.872963566698971 40.107131336680133)

5475
2024-05-02 18:40:36.9467987
40.1075136606765
-74.1264886339523
POINT (-74.126488633952292 40.10751366067651)

5838
2024-04-29 18:40:36.9467987
39.8836979593953
-74.1123744863092
POINT (-74.112374486309164 39.883697959395327)

5283
2024-05-04 18:40:36.9467987
40.1420911090072
-73.9627930359167
POINT (-73.962793035916675 40.142091109007175)

6030
2024-04-27 18:40:36.9467987
39.8612045082636
-73.9457573143311
POINT (-73.9457573143311 39.861204508263583)

5924
2024-05-03 18:40:36.9467987
39.8578937260205
-74.0370544736288
POINT (-74.037054473628828 39.857893726020514)

5936
2024-05-01 18:40:36.9467987
39.8566662301413
-74.0279619227726
POINT (-74.027961922772647 39.856666230141286)

5389
2024-04-28 18:40:36.9467987
40.1387662367477
-74.054464630135
POINT (-74.054464630135 40.1387662367477)

5329
2024-04-28 18:40:36.9467987
40.1449374326382
-73.9996296570964
POINT (-73.999629657096449 40.144937432638208)

5984
2024-05-03 18:40:36.9467987
39.8557274780307
-73.9819349131332
POINT (-73.981934913133173 39.855727478030737)

5343
2024-05-04 18:40:36.9467987
40.1442659635745
-74.0181430463418
POINT (-74.018143046341834 40.144265963574519)

5970
2024-04-27 18:40:36.9467987
39.8550589352619
-74.0003704441225
POINT (-74.000370444122524 39.855058935261944)

6122
2024-05-05 18:40:36.9467987
39.8972333905517
-73.8671984670204
POINT (-73.867198467020359 39.8972333905517)

5237
2024-04-30 18:40:36.9467987
40.1308721421233
-73.918932716477
POINT (-73.918932716477045 40.13087214212328)

5830
2024-04-27 18:40:36.9467987
39.8880785347519
-74.1196509469795
POINT (-74.119650946979462 39.888078534751891)

6076
2024-05-01 18:40:36.9467987
39.8754931279851
-73.9036044265936
POINT (-73.903604426593589 39.875493127985109)

5435
2024-05-02 18:40:36.9467987
40.1244228833921
-74.0967480841038
POINT (-74.0967480841038 40.124422883392128)

5976
2024-05-01 18:40:36.9467987
39.8552191771366
-73.9911420761936
POINT (-73.99114207619364 39.855219177136561)

5870
2024-04-27 18:40:36.9467987
39.8722738799244
-74.089002145372
POINT (-74.089002145371992 39.872273879924428)

5372
2024-05-05 18:40:36.9467987
40.1406539947625
-74.0455277951493
POINT (-74.045527795149312 40.140653994762495)

6036
2024-05-01 18:40:36.9467987
39.8634183261066
-73.9369840009815
POINT (-73.936984000981539 39.863418326106554)

5893
2024-05-04 18:40:36.9467987
39.8636103097967
-74.0637138411498
POINT (-74.063713841149834 39.863610309796677)

5395
2024-05-02 18:40:36.9467987
40.1365435334158
-74.0632694531001
POINT (-74.063269453100133 40.136543533415811)

5489
2024-04-28 18:40:36.9467987
40.1026109522104
-74.1332015704258
POINT (-74.133201570425825 40.102610952210419)

5821
2024-05-06 18:40:36.9467987
39.8880785347519
-74.1196509469795
POINT (-74.119650946979462 39.888078534751891)

5466
2024-05-01 18:40:36.9467987
40.1121571192162
-74.1194695358892
POINT (-74.119469535889166 40.112157119216178)

6130
2024-04-27 18:40:36.9467987
39.8972333905517
-73.8671984670204
POINT (-73.867198467020359 39.8972333905517)

5203
2024-05-04 18:40:36.9467987
40.1203056275055
-73.8948035632537
POINT (-73.894803563253731 40.120305627505516)

5280
2024-04-27 18:40:36.9467987
40.1405155971263
-73.9537538554862
POINT (-73.953753855486227 40.1405155971263)

5944
2024-05-03 18:40:36.9467987
39.8557833288826
-74.0188024300137
POINT (-74.0188024300137 39.855783328882588)

5446
2024-05-01 18:40:36.9467987
40.1206219786962
-74.1045812863513
POINT (-74.104581286351291 40.120621978696207)

5180
2024-04-27 18:40:36.9467987
40.1071313366801
-73.872963566699
POINT (-73.872963566698971 40.107131336680133)

5352
2024-05-05 18:40:36.9467987
40.1434071951488
-74.0273449695742
POINT (-74.027344969574244 40.143407195148832)

5346
2024-05-01 18:40:36.9467987
40.1442659635745
-74.0181430463418
POINT (-74.018143046341834 40.144265963574519)

5303
2024-05-04 18:40:36.9467987
40.144210131601
-73.9811198571789
POINT (-73.981119857178868 40.144210131601)

5297
2024-04-30 18:40:36.9467987
40.1433236164225
-73.9719224122925
POINT (-73.971922412292486 40.1433236164225)

5844
2024-05-03 18:40:36.9467987
39.879597222123
-74.1048286796057
POINT (-74.104828679605731 39.879597222123031)

5323
2024-05-04 18:40:36.9467987
40.1449374326382
-73.9996296570964
POINT (-73.999629657096449 40.144937432638208)

5913
2024-05-04 18:40:36.9467987
39.8594628775953
-74.0460583099265
POINT (-74.046058309926508 39.859462877595327)

5987
2024-04-30 18:40:36.9467987
39.8557274780307
-73.9819349131332
POINT (-73.981934913133173 39.855727478030737)

5472
2024-05-05 18:40:36.9467987
40.1075136606765
-74.1264886339523
POINT (-74.126488633952292 40.10751366067651)

5964
2024-05-03 18:40:36.9467987
39.8550589352619
-74.0003704441225
POINT (-74.000370444122524 39.855058935261944)

5423
2024-05-04 18:40:36.9467987
40.1279235960576
-74.0886805313313
POINT (-74.08868053133132 40.127923596057606)

6013
2024-05-04 18:40:36.9467987
39.8593244185206
-73.9546605124076
POINT (-73.954660512407557 39.8593244185206)

5864
2024-05-03 18:40:36.9467987
39.8722738799244
-74.089002145372
POINT (-74.089002145371992 39.872273879924428)

5366
2024-05-01 18:40:36.9467987
40.1422022318738
-74.0364806001375
POINT (-74.036480600137523 40.142202231873831)

5260
2024-04-27 18:40:36.9467987
40.1363516578974
-73.9360334244253
POINT (-73.9360334244253 40.13635165789735)

5223
2024-05-04 18:40:36.9467987
40.127655146052
-73.9106667566745
POINT (-73.910666756674487 40.127655146052042)

5415
2024-05-02 18:40:36.9467987
40.1311156366514
-74.0803981366358
POINT (-74.080398136635836 40.131115636651366)

5403
2024-05-04 18:40:36.9467987
40.1339912717127
-74.0719209378814
POINT (-74.071920937881387 40.133991271712652)

5993
2024-05-04 18:40:36.9467987
39.8565826210426
-73.9727709968065
POINT (-73.972770996806489 39.856582621042584)

6007
2024-04-30 18:40:36.9467987
39.8577825588499
-73.9636722675078
POINT (-73.963672267507846 39.857782558849934)

6056
2024-05-01 18:40:36.9467987
39.8688251526908
-73.9199107629876
POINT (-73.919910762987641 39.8688251526908)

5950
2024-04-27 18:40:36.9467987
39.8557833288826
-74.0188024300137
POINT (-74.0188024300137 39.855783328882588)

5956
2024-05-01 18:40:36.9467987
39.8552471360297
-74.0095979252562
POINT (-74.00959792525623 39.855247136029746)

5309
2024-04-28 18:40:36.9467987
40.144210131601
-73.9811198571789
POINT (-73.981119857178868 40.144210131601)

5801
2024-05-06 18:40:36.9467987
39.8976365474813
-74.1333265257813
POINT (-74.1333265257813 39.8976365474813)

5807
2024-04-30 18:40:36.9467987
39.8976365474813
-74.1333265257813
POINT (-74.1333265257813 39.8976365474813)

5850
2024-04-27 18:40:36.9467987
39.879597222123
-74.1048286796057
POINT (-74.104828679605731 39.879597222123031)

5901
2024-05-06 18:40:36.9467987
39.8613699277074
-74.0549518674478
POINT (-74.054951867447812 39.861369927707436)

5409
2024-04-28 18:40:36.9467987
40.1339912717127
-74.0719209378814
POINT (-74.071920937881387 40.133991271712652)

6050
2024-04-27 18:40:36.9467987
39.8659605704808
-73.9283615947162
POINT (-73.9283615947162 39.865960570480844)

6099
2024-04-28 18:40:36.9467987
39.8833583896531
-73.888221402349
POINT (-73.888221402348975 39.8833583896531)

5194
2024-05-03 18:40:36.9467987
40.1161909066071
-73.8872446774006
POINT (-73.887244677400631 40.116190906607088)

5455
2024-05-02 18:40:36.9467987
40.1165300877096
-74.1121612064384
POINT (-74.112161206438373 40.116530087709577)

6119
2024-04-28 18:40:36.9467987
39.892345584843
-73.8739094010218
POINT (-73.873909401021763 39.892345584842978)

5217
2024-04-30 18:40:36.9467987
40.1241301282421
-73.9026172175202
POINT (-73.902617217520174 40.124130128242136)

5881
2024-05-06 18:40:36.9467987
39.866178658638
-74.0723232353388
POINT (-74.0723232353388 39.86617865863802)

5432
2024-05-05 18:40:36.9467987
40.1244228833921
-74.0967480841038
POINT (-74.0967480841038 40.124422883392128)

6096
2024-05-01 18:40:36.9467987
39.8833583896531
-73.888221402349
POINT (-73.888221402348975 39.8833583896531)

5478
2024-04-29 18:40:36.9467987
40.1075136606765
-74.1264886339523
POINT (-74.126488633952292 40.10751366067651)

5810
2024-04-27 18:40:36.9467987
39.8976365474813
-74.1333265257813
POINT (-74.1333265257813 39.8976365474813)

5200
2024-04-27 18:40:36.9467987
40.1161909066071
-73.8872446774006
POINT (-73.887244677400631 40.116190906607088)

6113
2024-05-04 18:40:36.9467987
39.892345584843
-73.8739094010218
POINT (-73.873909401021763 39.892345584842978)

5887
2024-04-30 18:40:36.9467987
39.866178658638
-74.0723232353388
POINT (-74.0723232353388 39.86617865863802)

5426
2024-05-01 18:40:36.9467987
40.1279235960576
-74.0886805313313
POINT (-74.08868053133132 40.127923596057606)

5332
2024-05-05 18:40:36.9467987
40.1447764552719
-74.0088971370793
POINT (-74.008897137079273 40.14477645527186)

5246
2024-05-01 18:40:36.9467987
40.1337733226225
-73.9273950995621
POINT (-73.9273950995621 40.133773322622467)

5234
2024-05-03 18:40:36.9467987
40.1308721421233
-73.918932716477
POINT (-73.918932716477045 40.13087214212328)

6067
2024-04-30 18:40:36.9467987
39.8720052112403
-73.9116517695578
POINT (-73.9116517695578 39.872005211240271)

6079
2024-04-28 18:40:36.9467987
39.8754931279851
-73.9036044265936
POINT (-73.903604426593589 39.875493127985109)

5921
2024-05-06 18:40:36.9467987
39.8578937260205
-74.0370544736288
POINT (-74.037054473628828 39.857893726020514)

5933
2024-05-04 18:40:36.9467987
39.8566662301413
-74.0279619227726
POINT (-74.027961922772647 39.856666230141286)

5392
2024-05-05 18:40:36.9467987
40.1365435334158
-74.0632694531001
POINT (-74.063269453100133 40.136543533415811)

5380
2024-04-27 18:40:36.9467987
40.1406539947625
-74.0455277951493
POINT (-74.045527795149312 40.140653994762495)

6019
2024-04-28 18:40:36.9467987
39.8593244185206
-73.9546605124076
POINT (-73.954660512407557 39.8593244185206)

5286
2024-05-01 18:40:36.9467987
40.1420911090072
-73.9627930359167
POINT (-73.962793035916675 40.142091109007175)

5873
2024-05-04 18:40:36.9467987
39.8690688229611
-74.080759413171
POINT (-74.080759413171023 39.86906882296109)

6027
2024-04-30 18:40:36.9467987
39.8612045082636
-73.9457573143311
POINT (-73.9457573143311 39.861204508263583)

5186
2024-05-01 18:40:36.9467987
40.1117959294713
-73.8799588167048
POINT (-73.879958816704828 40.11179592947127)

5340
2024-04-27 18:40:36.9467987
40.1447764552719
-74.0088971370793
POINT (-74.008897137079273 40.14477645527186)

5973
2024-05-04 18:40:36.9467987
39.8552191771366
-73.9911420761936
POINT (-73.99114207619364 39.855219177136561)

5240
2024-04-27 18:40:36.9467987
40.1308721421233
-73.918932716477
POINT (-73.918932716477045 40.13087214212328)

5486
2024-05-01 18:40:36.9467987
40.1026109522104
-74.1332015704258
POINT (-74.133201570425825 40.102610952210419)

5827
2024-04-30 18:40:36.9467987
39.8880785347519
-74.1196509469795
POINT (-74.119650946979462 39.888078534751891)

6073
2024-05-04 18:40:36.9467987
39.8754931279851
-73.9036044265936
POINT (-73.903604426593589 39.875493127985109)

5927
2024-04-30 18:40:36.9467987
39.8578937260205
-74.0370544736288
POINT (-74.037054473628828 39.857893726020514)

5386
2024-05-01 18:40:36.9467987
40.1387662367477
-74.054464630135
POINT (-74.054464630135 40.1387662367477)

5206
2024-05-01 18:40:36.9467987
40.1203056275055
-73.8948035632537
POINT (-73.894803563253731 40.120305627505516)

5277
2024-04-30 18:40:36.9467987
40.1405155971263
-73.9537538554862
POINT (-73.953753855486227 40.1405155971263)

5443
2024-05-04 18:40:36.9467987
40.1206219786962
-74.1045812863513
POINT (-74.104581286351291 40.120621978696207)

6059
2024-04-28 18:40:36.9467987
39.8688251526908
-73.9199107629876
POINT (-73.919910762987641 39.8688251526908)

5824
2024-05-03 18:40:36.9467987
39.8880785347519
-74.1196509469795
POINT (-74.119650946979462 39.888078534751891)

5183
2024-05-04 18:40:36.9467987
40.1117959294713
-73.8799588167048
POINT (-73.879958816704828 40.11179592947127)

5847
2024-04-30 18:40:36.9467987
39.879597222123
-74.1048286796057
POINT (-74.104828679605731 39.879597222123031)

5867
2024-04-30 18:40:36.9467987
39.8722738799244
-74.089002145372
POINT (-74.089002145371992 39.872273879924428)

5369
2024-04-28 18:40:36.9467987
40.1422022318738
-74.0364806001375
POINT (-74.036480600137523 40.142202231873831)

6033
2024-05-04 18:40:36.9467987
39.8634183261066
-73.9369840009815
POINT (-73.936984000981539 39.863418326106554)

6039
2024-04-28 18:40:36.9467987
39.8634183261066
-73.9369840009815
POINT (-73.936984000981539 39.863418326106554)

6110
2024-04-27 18:40:36.9467987
39.8877168852471
-73.8809226707491
POINT (-73.880922670749058 39.887716885247116)

5469
2024-04-28 18:40:36.9467987
40.1121571192162
-74.1194695358892
POINT (-74.119469535889166 40.112157119216178)

5967
2024-04-30 18:40:36.9467987
39.8550589352619
-74.0003704441225
POINT (-74.000370444122524 39.855058935261944)

6010
2024-04-27 18:40:36.9467987
39.8577825588499
-73.9636722675078
POINT (-73.963672267507846 39.857782558849934)

6016
2024-05-01 18:40:36.9467987
39.8593244185206
-73.9546605124076
POINT (-73.954660512407557 39.8593244185206)

5326
2024-05-01 18:40:36.9467987
40.1449374326382
-73.9996296570964
POINT (-73.999629657096449 40.144937432638208)

5249
2024-04-28 18:40:36.9467987
40.1337733226225
-73.9273950995621
POINT (-73.9273950995621 40.133773322622467)

5818
2024-04-29 18:40:36.9467987
39.89272844709
-74.1266405661269
POINT (-74.126640566126937 39.892728447089972)

5990
2024-04-27 18:40:36.9467987
39.8557274780307
-73.9819349131332
POINT (-73.981934913133173 39.855727478030737)

5177
2024-04-30 18:40:36.9467987
40.1071313366801
-73.872963566699
POINT (-73.872963566698971 40.107131336680133)

5349
2024-04-28 18:40:36.9467987
40.1442659635745
-74.0181430463418
POINT (-74.018143046341834 40.144265963574519)

5300
2024-04-27 18:40:36.9467987
40.1433236164225
-73.9719224122925
POINT (-73.971922412292486 40.1433236164225)

5226
2024-05-01 18:40:36.9467987
40.127655146052
-73.9106667566745
POINT (-73.910666756674487 40.127655146052042)

5841
2024-05-06 18:40:36.9467987
39.879597222123
-74.1048286796057
POINT (-74.104828679605731 39.879597222123031)

5890
2024-04-27 18:40:36.9467987
39.866178658638
-74.0723232353388
POINT (-74.0723232353388 39.86617865863802)

5947
2024-04-30 18:40:36.9467987
39.8557833288826
-74.0188024300137
POINT (-74.0188024300137 39.855783328882588)

5449
2024-04-28 18:40:36.9467987
40.1206219786962
-74.1045812863513
POINT (-74.104581286351291 40.120621978696207)

6053
2024-05-04 18:40:36.9467987
39.8688251526908
-73.9199107629876
POINT (-73.919910762987641 39.8688251526908)

6090
2024-04-27 18:40:36.9467987
39.8792805460761
-73.8957880477504
POINT (-73.8957880477504 39.879280546076075)

6102
2024-05-05 18:40:36.9467987
39.8877168852471
-73.8809226707491
POINT (-73.880922670749058 39.887716885247116)

5320
2024-04-27 18:40:36.9467987
40.1447485054048
-73.9903630750002
POINT (-73.990363075000232 40.14474850540482)

5910
2024-04-27 18:40:36.9467987
39.8613699277074
-74.0549518674478
POINT (-74.054951867447812 39.861369927707436)

5996
2024-05-01 18:40:36.9467987
39.8565826210426
-73.9727709968065
POINT (-73.972770996806489 39.856582621042584)

5306
2024-05-01 18:40:36.9467987
40.144210131601
-73.9811198571789
POINT (-73.981119857178868 40.144210131601)

5269
2024-04-28 18:40:36.9467987
40.1386008998059
-73.9448267756848
POINT (-73.944826775684845 40.138600899805908)

5257
2024-04-30 18:40:36.9467987
40.1363516578974
-73.9360334244253
POINT (-73.9360334244253 40.13635165789735)

5363
2024-05-04 18:40:36.9467987
40.1422022318738
-74.0364806001375
POINT (-74.036480600137523 40.142202231873831)

5463
2024-05-04 18:40:36.9467987
40.1121571192162
-74.1194695358892
POINT (-74.119469535889166 40.112157119216178)

6004
2024-05-03 18:40:36.9467987
39.8577825588499
-73.9636722675078
POINT (-73.963672267507846 39.857782558849934)

5904
2024-05-03 18:40:36.9467987
39.8613699277074
-74.0549518674478
POINT (-74.054951867447812 39.861369927707436)

5412
2024-05-05 18:40:36.9467987
40.1311156366514
-74.0803981366358
POINT (-74.080398136635836 40.131115636651366)

5263
2024-05-04 18:40:36.9467987
40.1386008998059
-73.9448267756848
POINT (-73.944826775684845 40.138600899805908)

5214
2024-05-03 18:40:36.9467987
40.1241301282421
-73.9026172175202
POINT (-73.902617217520174 40.124130128242136)

5804
2024-05-03 18:40:36.9467987
39.8976365474813
-74.1333265257813
POINT (-74.1333265257813 39.8976365474813)

5218
2024-04-29 18:40:36.9467987
40.1241301282421
-73.9026172175202
POINT (-73.902617217520174 40.124130128242136)

5882
2024-05-05 18:40:36.9467987
39.866178658638
-74.0723232353388
POINT (-74.0723232353388 39.86617865863802)

5241
2024-05-06 18:40:36.9467987
40.1337733226225
-73.9273950995621
POINT (-73.9273950995621 40.133773322622467)

5905
2024-05-02 18:40:36.9467987
39.8613699277074
-74.0549518674478
POINT (-74.054951867447812 39.861369927707436)

5172
2024-05-05 18:40:36.9467987
40.1071313366801
-73.872963566699
POINT (-73.872963566698971 40.107131336680133)

5836
2024-05-01 18:40:36.9467987
39.8836979593953
-74.1123744863092
POINT (-74.112374486309164 39.883697959395327)

5195
2024-05-02 18:40:36.9467987
40.1161909066071
-73.8872446774006
POINT (-73.887244677400631 40.116190906607088)

5859
2024-04-28 18:40:36.9467987
39.875786151413
-74.0970316580654
POINT (-74.0970316580654 39.875786151412953)

5813
2024-05-04 18:40:36.9467987
39.89272844709
-74.1266405661269
POINT (-74.126640566126937 39.892728447089972)

5295
2024-05-02 18:40:36.9467987
40.1433236164225
-73.9719224122925
POINT (-73.971922412292486 40.1433236164225)

5473
2024-05-04 18:40:36.9467987
40.1075136606765
-74.1264886339523
POINT (-74.126488633952292 40.10751366067651)

5876
2024-05-01 18:40:36.9467987
39.8690688229611
-74.080759413171
POINT (-74.080759413171023 39.86906882296109)

5888
2024-04-29 18:40:36.9467987
39.866178658638
-74.0723232353388
POINT (-74.0723232353388 39.86617865863802)

5235
2024-05-02 18:40:36.9467987
40.1308721421233
-73.918932716477
POINT (-73.918932716477045 40.13087214212328)

6114
2024-05-03 18:40:36.9467987
39.892345584843
-73.8739094010218
POINT (-73.873909401021763 39.892345584842978)

5341
2024-05-06 18:40:36.9467987
40.1442659635745
-74.0181430463418
POINT (-74.018143046341834 40.144265963574519)

5922
2024-05-05 18:40:36.9467987
39.8578937260205
-74.0370544736288
POINT (-74.037054473628828 39.857893726020514)

5427
2024-04-30 18:40:36.9467987
40.1279235960576
-74.0886805313313
POINT (-74.08868053133132 40.127923596057606)

5281
2024-05-06 18:40:36.9467987
40.1420911090072
-73.9627930359167
POINT (-73.962793035916675 40.142091109007175)

5982
2024-05-05 18:40:36.9467987
39.8557274780307
-73.9819349131332
POINT (-73.981934913133173 39.855727478030737)

6068
2024-04-29 18:40:36.9467987
39.8720052112403
-73.9116517695578
POINT (-73.9116517695578 39.872005211240271)

5381
2024-05-06 18:40:36.9467987
40.1387662367477
-74.054464630135
POINT (-74.054464630135 40.1387662367477)

5387
2024-04-30 18:40:36.9467987
40.1387662367477
-74.054464630135
POINT (-74.054464630135 40.1387662367477)

6128
2024-04-29 18:40:36.9467987
39.8972333905517
-73.8671984670204
POINT (-73.867198467020359 39.8972333905517)

5481
2024-05-06 18:40:36.9467987
40.1026109522104
-74.1332015704258
POINT (-74.133201570425825 40.102610952210419)

5487
2024-04-30 18:40:36.9467987
40.1026109522104
-74.1332015704258
POINT (-74.133201570425825 40.102610952210419)

6022
2024-05-05 18:40:36.9467987
39.8612045082636
-73.9457573143311
POINT (-73.9457573143311 39.861204508263583)

6028
2024-04-29 18:40:36.9467987
39.8612045082636
-73.9457573143311
POINT (-73.9457573143311 39.861204508263583)

5335
2024-05-02 18:40:36.9467987
40.1447764552719
-74.0088971370793
POINT (-74.008897137079273 40.14477645527186)

5928
2024-04-29 18:40:36.9467987
39.8578937260205
-74.0370544736288
POINT (-74.037054473628828 39.857893726020514)

5189
2024-04-28 18:40:36.9467987
40.1117959294713
-73.8799588167048
POINT (-73.879958816704828 40.11179592947127)

6074
2024-05-03 18:40:36.9467987
39.8754931279851
-73.9036044265936
POINT (-73.903604426593589 39.875493127985109)

5301
2024-05-06 18:40:36.9467987
40.144210131601
-73.9811198571789
POINT (-73.981119857178868 40.144210131601)

5278
2024-04-29 18:40:36.9467987
40.1405155971263
-73.9537538554862
POINT (-73.953753855486227 40.1405155971263)

5229
2024-04-28 18:40:36.9467987
40.127655146052
-73.9106667566745
POINT (-73.910666756674487 40.127655146052042)

5942
2024-05-05 18:40:36.9467987
39.8557833288826
-74.0188024300137
POINT (-74.0188024300137 39.855783328882588)

5444
2024-05-03 18:40:36.9467987
40.1206219786962
-74.1045812863513
POINT (-74.104581286351291 40.120621978696207)

5919
2024-04-28 18:40:36.9467987
39.8594628775953
-74.0460583099265
POINT (-74.046058309926508 39.859462877595327)

6105
2024-05-02 18:40:36.9467987
39.8877168852471
-73.8809226707491
POINT (-73.880922670749058 39.887716885247116)

5470
2024-04-27 18:40:36.9467987
40.1121571192162
-74.1194695358892
POINT (-74.119469535889166 40.112157119216178)

5962
2024-05-05 18:40:36.9467987
39.8550589352619
-74.0003704441225
POINT (-74.000370444122524 39.855058935261944)

5968
2024-04-29 18:40:36.9467987
39.8550589352619
-74.0003704441225
POINT (-74.000370444122524 39.855058935261944)

5321
2024-05-06 18:40:36.9467987
40.1449374326382
-73.9996296570964
POINT (-73.999629657096449 40.144937432638208)

5327
2024-04-30 18:40:36.9467987
40.1449374326382
-73.9996296570964
POINT (-73.999629657096449 40.144937432638208)

5819
2024-04-28 18:40:36.9467987
39.89272844709
-74.1266405661269
POINT (-74.126640566126937 39.892728447089972)

5868
2024-04-29 18:40:36.9467987
39.8722738799244
-74.089002145372
POINT (-74.089002145371992 39.872273879924428)

5985
2024-05-02 18:40:36.9467987
39.8557274780307
-73.9819349131332
POINT (-73.981934913133173 39.855727478030737)

5991
2024-05-06 18:40:36.9467987
39.8565826210426
-73.9727709968065
POINT (-73.972770996806489 39.856582621042584)

6034
2024-05-03 18:40:36.9467987
39.8634183261066
-73.9369840009815
POINT (-73.936984000981539 39.863418326106554)

5178
2024-04-29 18:40:36.9467987
40.1071313366801
-73.872963566699
POINT (-73.872963566698971 40.107131336680133)

5252
2024-05-05 18:40:36.9467987
40.1363516578974
-73.9360334244253
POINT (-73.9360334244253 40.13635165789735)

5842
2024-05-05 18:40:36.9467987
39.879597222123
-74.1048286796057
POINT (-74.104828679605731 39.879597222123031)

5421
2024-05-06 18:40:36.9467987
40.1279235960576
-74.0886805313313
POINT (-74.08868053133132 40.127923596057606)

6011
2024-05-06 18:40:36.9467987
39.8593244185206
-73.9546605124076
POINT (-73.954660512407557 39.8593244185206)

6085
2024-05-02 18:40:36.9467987
39.8792805460761
-73.8957880477504
POINT (-73.8957880477504 39.879280546076075)

5201
2024-05-06 18:40:36.9467987
40.1203056275055
-73.8948035632537
POINT (-73.894803563253731 40.120305627505516)

6062
2024-05-05 18:40:36.9467987
39.8720052112403
-73.9116517695578
POINT (-73.9116517695578 39.872005211240271)

6111
2024-05-06 18:40:36.9467987
39.892345584843
-73.8739094010218
POINT (-73.873909401021763 39.892345584842978)

5805
2024-05-02 18:40:36.9467987
39.8976365474813
-74.1333265257813
POINT (-74.1333265257813 39.8976365474813)

6042
2024-05-05 18:40:36.9467987
39.8659605704808
-73.9283615947162
POINT (-73.9283615947162 39.865960570480844)

6054
2024-05-03 18:40:36.9467987
39.8688251526908
-73.9199107629876
POINT (-73.919910762987641 39.8688251526908)

5272
2024-05-05 18:40:36.9467987
40.1405155971263
-73.9537538554862
POINT (-73.953753855486227 40.1405155971263)

5899
2024-04-28 18:40:36.9467987
39.8636103097967
-74.0637138411498
POINT (-74.063713841149834 39.863610309796677)

5948
2024-04-29 18:40:36.9467987
39.8557833288826
-74.0188024300137
POINT (-74.0188024300137 39.855783328882588)

5450
2024-04-27 18:40:36.9467987
40.1206219786962
-74.1045812863513
POINT (-74.104581286351291 40.120621978696207)

5401
2024-05-06 18:40:36.9467987
40.1339912717127
-74.0719209378814
POINT (-74.071920937881387 40.133991271712652)

5258
2024-04-29 18:40:36.9467987
40.1363516578974
-73.9360334244253
POINT (-73.9360334244253 40.13635165789735)

6005
2024-05-02 18:40:36.9467987
39.8577825588499
-73.9636722675078
POINT (-73.963672267507846 39.857782558849934)

6091
2024-05-06 18:40:36.9467987
39.8833583896531
-73.888221402349
POINT (-73.888221402348975 39.8833583896531)

5209
2024-04-28 18:40:36.9467987
40.1203056275055
-73.8948035632537
POINT (-73.894803563253731 40.120305627505516)

5215
2024-05-02 18:40:36.9467987
40.1241301282421
-73.9026172175202
POINT (-73.902617217520174 40.124130128242136)

5464
2024-05-03 18:40:36.9467987
40.1121571192162
-74.1194695358892
POINT (-74.119469535889166 40.112157119216178)

5458
2024-04-29 18:40:36.9467987
40.1165300877096
-74.1121612064384
POINT (-74.112161206438373 40.116530087709577)

5358
2024-04-29 18:40:36.9467987
40.1434071951488
-74.0273449695742
POINT (-74.027344969574244 40.143407195148832)

5315
2024-05-02 18:40:36.9467987
40.1447485054048
-73.9903630750002
POINT (-73.990363075000232 40.14474850540482)

5856
2024-05-01 18:40:36.9467987
39.875786151413
-74.0970316580654
POINT (-74.0970316580654 39.875786151412953)

5364
2024-05-03 18:40:36.9467987
40.1422022318738
-74.0364806001375
POINT (-74.036480600137523 40.142202231873831)

5264
2024-05-03 18:40:36.9467987
40.1386008998059
-73.9448267756848
POINT (-73.944826775684845 40.138600899805908)

5999
2024-04-28 18:40:36.9467987
39.8565826210426
-73.9727709968065
POINT (-73.972770996806489 39.856582621042584)

6097
2024-04-30 18:40:36.9467987
39.8833583896531
-73.888221402349
POINT (-73.888221402348975 39.8833583896531)

5384
2024-05-03 18:40:36.9467987
40.1387662367477
-74.054464630135
POINT (-74.054464630135 40.1387662367477)

6048
2024-04-29 18:40:36.9467987
39.8659605704808
-73.9283615947162
POINT (-73.9283615947162 39.865960570480844)

5407
2024-04-30 18:40:36.9467987
40.1339912717127
-74.0719209378814
POINT (-74.071920937881387 40.133991271712652)

6071
2024-05-06 18:40:36.9467987
39.8754931279851
-73.9036044265936
POINT (-73.903604426593589 39.875493127985109)

5833
2024-05-04 18:40:36.9467987
39.8836979593953
-74.1123744863092
POINT (-74.112374486309164 39.883697959395327)

5931
2024-05-06 18:40:36.9467987
39.8566662301413
-74.0279619227726
POINT (-74.027961922772647 39.856666230141286)

5430
2024-04-27 18:40:36.9467987
40.1279235960576
-74.0886805313313
POINT (-74.08868053133132 40.127923596057606)

6094
2024-05-03 18:40:36.9467987
39.8833583896531
-73.888221402349
POINT (-73.888221402348975 39.8833583896531)

5244
2024-05-03 18:40:36.9467987
40.1337733226225
-73.9273950995621
POINT (-73.9273950995621 40.133773322622467)

5908
2024-04-29 18:40:36.9467987
39.8613699277074
-74.0549518674478
POINT (-74.054951867447812 39.861369927707436)

6117
2024-04-30 18:40:36.9467987
39.892345584843
-73.8739094010218
POINT (-73.873909401021763 39.892345584842978)

5221
2024-05-06 18:40:36.9467987
40.127655146052
-73.9106667566745
POINT (-73.910666756674487 40.127655146052042)

5885
2024-05-02 18:40:36.9467987
39.866178658638
-74.0723232353388
POINT (-74.0723232353388 39.86617865863802)

5198
2024-04-29 18:40:36.9467987
40.1161909066071
-73.8872446774006
POINT (-73.887244677400631 40.116190906607088)

5862
2024-05-05 18:40:36.9467987
39.8722738799244
-74.089002145372
POINT (-74.089002145371992 39.872273879924428)

5175
2024-05-02 18:40:36.9467987
40.1071313366801
-73.872963566699
POINT (-73.872963566698971 40.107131336680133)

5839
2024-04-28 18:40:36.9467987
39.8836979593953
-74.1123744863092
POINT (-74.112374486309164 39.883697959395327)

5816
2024-05-01 18:40:36.9467987
39.89272844709
-74.1266405661269
POINT (-74.126640566126937 39.892728447089972)

5378
2024-04-29 18:40:36.9467987
40.1406539947625
-74.0455277951493
POINT (-74.045527795149312 40.140653994762495)

5971
2024-05-06 18:40:36.9467987
39.8552191771366
-73.9911420761936
POINT (-73.99114207619364 39.855219177136561)

6125
2024-05-02 18:40:36.9467987
39.8972333905517
-73.8671984670204
POINT (-73.867198467020359 39.8972333905517)

5284
2024-05-03 18:40:36.9467987
40.1420911090072
-73.9627930359167
POINT (-73.962793035916675 40.142091109007175)

5438
2024-04-29 18:40:36.9467987
40.1244228833921
-74.0967480841038
POINT (-74.0967480841038 40.124422883392128)

6065
2024-05-02 18:40:36.9467987
39.8720052112403
-73.9116517695578
POINT (-73.9116517695578 39.872005211240271)

5344
2024-05-03 18:40:36.9467987
40.1442659635745
-74.0181430463418
POINT (-74.018143046341834 40.144265963574519)

6031
2024-05-06 18:40:36.9467987
39.8634183261066
-73.9369840009815
POINT (-73.936984000981539 39.863418326106554)

5292
2024-05-05 18:40:36.9467987
40.1433236164225
-73.9719224122925
POINT (-73.971922412292486 40.1433236164225)

5879
2024-04-28 18:40:36.9467987
39.8690688229611
-74.080759413171
POINT (-74.080759413171023 39.86906882296109)

5192
2024-05-05 18:40:36.9467987
40.1161909066071
-73.8872446774006
POINT (-73.887244677400631 40.116190906607088)

5825
2024-05-02 18:40:36.9467987
39.8880785347519
-74.1196509469795
POINT (-74.119650946979462 39.888078534751891)

5979
2024-04-28 18:40:36.9467987
39.8552191771366
-73.9911420761936
POINT (-73.99114207619364 39.855219177136561)

5338
2024-04-29 18:40:36.9467987
40.1447764552719
-74.0088971370793
POINT (-74.008897137079273 40.14477645527186)

5925
2024-05-02 18:40:36.9467987
39.8578937260205
-74.0370544736288
POINT (-74.037054473628828 39.857893726020514)

5238
2024-04-29 18:40:36.9467987
40.1308721421233
-73.918932716477
POINT (-73.918932716477045 40.13087214212328)

5484
2024-05-03 18:40:36.9467987
40.1026109522104
-74.1332015704258
POINT (-74.133201570425825 40.102610952210419)

6025
2024-05-02 18:40:36.9467987
39.8612045082636
-73.9457573143311
POINT (-73.9457573143311 39.861204508263583)

5467
2024-04-30 18:40:36.9467987
40.1121571192162
-74.1194695358892
POINT (-74.119469535889166 40.112157119216178)

5965
2024-05-02 18:40:36.9467987
39.8550589352619
-74.0003704441225
POINT (-74.000370444122524 39.855058935261944)

6108
2024-04-29 18:40:36.9467987
39.8877168852471
-73.8809226707491
POINT (-73.880922670749058 39.887716885247116)

5181
2024-05-06 18:40:36.9467987
40.1117959294713
-73.8799588167048
POINT (-73.879958816704828 40.11179592947127)

5255
2024-05-02 18:40:36.9467987
40.1363516578974
-73.9360334244253
POINT (-73.9360334244253 40.13635165789735)

5845
2024-05-02 18:40:36.9467987
39.879597222123
-74.1048286796057
POINT (-74.104828679605731 39.879597222123031)

5418
2024-04-29 18:40:36.9467987
40.1311156366514
-74.0803981366358
POINT (-74.080398136635836 40.131115636651366)

6082
2024-05-05 18:40:36.9467987
39.8792805460761
-73.8957880477504
POINT (-73.8957880477504 39.879280546076075)

5232
2024-05-05 18:40:36.9467987
40.1308721421233
-73.918932716477
POINT (-73.918932716477045 40.13087214212328)

5490
2024-04-27 18:40:36.9467987
40.1026109522104
-74.1332015704258
POINT (-74.133201570425825 40.102610952210419)

5822
2024-05-05 18:40:36.9467987
39.8880785347519
-74.1196509469795
POINT (-74.119650946979462 39.888078534751891)

5896
2024-05-01 18:40:36.9467987
39.8636103097967
-74.0637138411498
POINT (-74.063713841149834 39.863610309796677)

5441
2024-05-06 18:40:36.9467987
40.1206219786962
-74.1045812863513
POINT (-74.104581286351291 40.120621978696207)

5304
2024-05-03 18:40:36.9467987
40.144210131601
-73.9811198571789
POINT (-73.981119857178868 40.144210131601)

5298
2024-04-29 18:40:36.9467987
40.1433236164225
-73.9719224122925
POINT (-73.971922412292486 40.1433236164225)

5375
2024-05-02 18:40:36.9467987
40.1406539947625
-74.0455277951493
POINT (-74.045527795149312 40.140653994762495)

5347
2024-04-30 18:40:36.9467987
40.1442659635745
-74.0181430463418
POINT (-74.018143046341834 40.144265963574519)

5916
2024-05-01 18:40:36.9467987
39.8594628775953
-74.0460583099265
POINT (-74.046058309926508 39.859462877595327)

5424
2024-05-03 18:40:36.9467987
40.1279235960576
-74.0886805313313
POINT (-74.08868053133132 40.127923596057606)

6014
2024-05-03 18:40:36.9467987
39.8593244185206
-73.9546605124076
POINT (-73.954660512407557 39.8593244185206)

6088
2024-04-29 18:40:36.9467987
39.8792805460761
-73.8957880477504
POINT (-73.8957880477504 39.879280546076075)

5324
2024-05-03 18:40:36.9467987
40.1449374326382
-73.9996296570964
POINT (-73.999629657096449 40.144937432638208)

5275
2024-05-02 18:40:36.9467987
40.1405155971263
-73.9537538554862
POINT (-73.953753855486227 40.1405155971263)

5865
2024-05-02 18:40:36.9467987
39.8722738799244
-74.089002145372
POINT (-74.089002145371992 39.872273879924428)

5939
2024-04-28 18:40:36.9467987
39.8566662301413
-74.0279619227726
POINT (-74.027961922772647 39.856666230141286)

5447
2024-04-30 18:40:36.9467987
40.1206219786962
-74.1045812863513
POINT (-74.104581286351291 40.120621978696207)

5398
2024-04-29 18:40:36.9467987
40.1365435334158
-74.0632694531001
POINT (-74.063269453100133 40.136543533415811)

5988
2024-04-29 18:40:36.9467987
39.8557274780307
-73.9819349131332
POINT (-73.981934913133173 39.855727478030737)

5212
2024-05-05 18:40:36.9467987
40.1241301282421
-73.9026172175202
POINT (-73.902617217520174 40.124130128242136)

5461
2024-05-06 18:40:36.9467987
40.1121571192162
-74.1194695358892
POINT (-74.119469535889166 40.112157119216178)

5959
2024-04-28 18:40:36.9467987
39.8552471360297
-74.0095979252562
POINT (-74.00959792525623 39.855247136029746)

6008
2024-04-29 18:40:36.9467987
39.8577825588499
-73.9636722675078
POINT (-73.963672267507846 39.857782558849934)

5355
2024-05-02 18:40:36.9467987
40.1434071951488
-74.0273449695742
POINT (-74.027344969574244 40.143407195148832)

5318
2024-04-29 18:40:36.9467987
40.1447485054048
-73.9903630750002
POINT (-73.990363075000232 40.14474850540482)

5945
2024-05-02 18:40:36.9467987
39.8557833288826
-74.0188024300137
POINT (-74.0188024300137 39.855783328882588)

5404
2024-05-03 18:40:36.9467987
40.1339912717127
-74.0719209378814
POINT (-74.071920937881387 40.133991271712652)

5367
2024-04-30 18:40:36.9467987
40.1422022318738
-74.0364806001375
POINT (-74.036480600137523 40.142202231873831)

5802
2024-05-05 18:40:36.9467987
39.8976365474813
-74.1333265257813
POINT (-74.1333265257813 39.8976365474813)

6045
2024-05-02 18:40:36.9467987
39.8659605704808
-73.9283615947162
POINT (-73.9283615947162 39.865960570480844)

6051
2024-05-06 18:40:36.9467987
39.8688251526908
-73.9199107629876
POINT (-73.919910762987641 39.8688251526908)

5261
2024-05-06 18:40:36.9467987
40.1386008998059
-73.9448267756848
POINT (-73.944826775684845 40.138600899805908)

6002
2024-05-05 18:40:36.9467987
39.8577825588499
-73.9636722675078
POINT (-73.963672267507846 39.857782558849934)

5312
2024-05-05 18:40:36.9467987
40.1447485054048
-73.9903630750002
POINT (-73.990363075000232 40.14474850540482)

5853
2024-05-04 18:40:36.9467987
39.875786151413
-74.0970316580654
POINT (-74.0970316580654 39.875786151412953)

5902
2024-05-05 18:40:36.9467987
39.8613699277074
-74.0549518674478
POINT (-74.054951867447812 39.861369927707436)

5951
2024-05-06 18:40:36.9467987
39.8552471360297
-74.0095979252562
POINT (-74.00959792525623 39.855247136029746)

5410
2024-04-27 18:40:36.9467987
40.1339912717127
-74.0719209378814
POINT (-74.071920937881387 40.133991271712652)

5361
2024-05-06 18:40:36.9467987
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.3451.2"><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="21" CompileCPU="21" CompileMemory="576"><MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="1040" RequiredMemory="1024" DesiredMemory="1040" RequestedMemory="1040" GrantWaitTime="0" GrantedMemory="1040" MaxUsedMemory="352" MaxQueryMemory="408264"></MemoryGrantInfo><OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="1258238" EstimatedPagesCached="78639" EstimatedAvailableDegreeOfParallelism="1" MaxCompileMemory="610688"></OptimizerHardwareDependentProperties><OptimizerStatsUsage><StatisticsInfo LastUpdate="2024-05-06T18:40:57.34" ModificationCount="0" SamplingPercent="100" Statistics="[_WA_Sys_00000003_36B12243]" Table="[extended_index_885578193_384000]" Schema="[sys]" Database="[fiddle_5f0c8faa376346c4994e02f50d916714]"></StatisticsInfo><StatisticsInfo LastUpdate="2024-05-06T18:40:56.27" ModificationCount="0" SamplingPercent="100" Statistics="[s_example]" Table="[extended_index_885578193_384000]" Schema="[sys]" Database="[fiddle_5f0c8faa376346c4994e02f50d916714]"></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><WaitStats><Wait WaitType="ASYNC_NETWORK_IO" WaitTimeMs="15" WaitCount="4"></Wait></WaitStats><QueryTimeStats ElapsedTime="60" CpuTime="44"></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_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="650" Batches="0" ActualExecutionMode="Row" ActualElapsedms="44" ActualCPUms="44" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0"><OuterReferences><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ColumnReference Column="Expr1004"></ColumnReference></OutputList><ComputeScalar><DefinedValues><DefinedValue><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference><ScalarOperator ScalarString="[fiddle_5f0c8faa376346c4994e02f50d916714].[dbo].[example].[latlong]"><Identifier><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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="44" ActualCPUms="44" ActualEndOfScans="1" ActualExecutions="1"></RunTimeCountersPerThread></RunTimeInformation><NestedLoops Optimized="0" WithUnorderedPrefetch="1"><OuterReferences><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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_5f0c8faa376346c4994e02f50d916714]" 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="25" ActualCPUms="25" 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_5f0c8faa376346c4994e02f50d916714]" 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_5f0c8faa376346c4994e02f50d916714]" 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_5f0c8faa376346c4994e02f50d916714].[sys].[extended_index_885578193_384000].[Attr]+[Attr]"><Arithmetic Operation="ADD"><ScalarOperator><Identifier><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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_5f0c8faa376346c4994e02f50d916714]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="Attr"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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="25" ActualCPUms="25" 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="25" ActualCPUms="25" 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_5f0c8faa376346c4994e02f50d916714]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="Attr"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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_5f0c8faa376346c4994e02f50d916714]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="Attr"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[sys]" Table="[extended_index_885578193_384000]" Column="pk0"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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_5f0c8faa376346c4994e02f50d916714]" 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_5f0c8faa376346c4994e02f50d916714]" 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_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference></OutputList><RunTimeInformation><RunTimeCountersPerThread Thread="0" ActualRows="1290" Batches="0" ActualExecutionMode="Row" ActualElapsedms="18" ActualCPUms="18" 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_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="transaction_dt"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latitude"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="longitude"></ColumnReference></DefinedValue><DefinedValue><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="latlong" ComputedColumn="1"></ColumnReference></DefinedValue></DefinedValues><Object Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Index="[pk_example]" IndexKind="Clustered" Storage="RowStore"></Object><SeekPredicates><SeekPredicateNew><SeekKeys><Prefix ScanType="EQ"><RangeColumns><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" Schema="[dbo]" Table="[example]" Column="example_id"></ColumnReference></RangeColumns><RangeExpressions><ScalarOperator ScalarString="[fiddle_5f0c8faa376346c4994e02f50d916714].[sys].[extended_index_885578193_384000].[pk0]"><Identifier><ColumnReference Database="[fiddle_5f0c8faa376346c4994e02f50d916714]" 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_5f0c8faa376346c4994e02f50d916714].[dbo].[example].[latlong],[geography]::Point((4.0000000000000000e+001),(-7.4000000000000000e+001),(4326))) ELSE [fiddle_5f0c8faa376346c4994e02f50d916714].[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_5f0c8faa376346c4994e02f50d916714]" 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_5f0c8faa376346c4994e02f50d916714]" 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>