| SQL |
select avg(lat) as lat_center,
avg(lon) as lon_center,
max(lat) as maxlat,
max(lon) as maxlon,
min(lat) as minlat,
min(lon) as minlon,
max(ele)*3.28 as ele_max,
min(ele)*3.28 as ele_min,
min(tdate) as time_min,
max(tdate) as time_max,
count(*) as pointcount, 188 as line_no
from polylineData |