Closed ihongyang closed 2 years ago
CREATE TABLE diditraj (tid string, traj trajectory);
SELECT st_traj_fromGeoJSON('{"type":"FeatureCollection","features":[{"type":"Feature","properties":{"time":"2018-10-09 07:28:21.0"},"geometry":{"type":"Point","coordinates":[108.99553,34.27859]}},{"type":"Feature","properties":{"time":"2018-10-09 07:28:24.0"},"geometry":{"type":"Point","coordinates":[108.99552,34.27822]}}],"properties":{"oid":"afab91fa68cb417c2f663924a0ba1ff9","tid":"afab91fa68cb417c2f663924a0ba1ff92018-10-09 07:28:21.0"}}');
insert into table diditraj values (1, st_traj_fromGeoJSON('{"type":"FeatureCollection","features":[{"type":"Feature","properties":{"time":"2018-10-09 07:28:21.0"},"geometry":{"type":"Point","coordinates":[108.99553,34.27859]}},{"type":"Feature","properties":{"time":"2018-10-09 07:28:24.0"},"geometry":{"type":"Point","coordinates":[108.99552,34.27822]}}],"properties":{"oid":"afab91fa68cb417c2f663924a0ba1ff9","tid":"afab91fa68cb417c2f663924a0ba1ff92018-10-09 07:28:21.0"}}'));
CREATE TABLE diditraj (tid string, traj trajectory);
SELECT st_traj_fromGeoJSON('{"type":"FeatureCollection","features":[{"type":"Feature","properties":{"time":"2018-10-09 07:28:21.0"},"geometry":{"type":"Point","coordinates":[108.99553,34.27859]}},{"type":"Feature","properties":{"time":"2018-10-09 07:28:24.0"},"geometry":{"type":"Point","coordinates":[108.99552,34.27822]}}],"properties":{"oid":"afab91fa68cb417c2f663924a0ba1ff9","tid":"afab91fa68cb417c2f663924a0ba1ff92018-10-09 07:28:21.0"}}');
insert into table diditraj values (1, st_traj_fromGeoJSON('{"type":"FeatureCollection","features":[{"type":"Feature","properties":{"time":"2018-10-09 07:28:21.0"},"geometry":{"type":"Point","coordinates":[108.99553,34.27859]}},{"type":"Feature","properties":{"time":"2018-10-09 07:28:24.0"},"geometry":{"type":"Point","coordinates":[108.99552,34.27822]}}],"properties":{"oid":"afab91fa68cb417c2f663924a0ba1ff9","tid":"afab91fa68cb417c2f663924a0ba1ff92018-10-09 07:28:21.0"}}'));