ST_lcsSubDistance

geometry,ARRAY['2010-01-01 11:30':timestamp,'2010-01-01 11:31','2010-01-01 11:32','2010-01-01 11:33','2010-01-01 11:34','2010-01-01 11:35'],NULL)a,ST_makeTrajectory('STPOINT','LINESTRINGZ(114.000529 33.588163 54.87,114....

ST_lcsSubDistance

geometry,ARRAY['2010-01-01 11:30':timestamp,'2010-01-01 11:31','2010-01-01 11:32','2010-01-01 11:33','2010-01-01 11:34','2010-01-01 11:35'],NULL)a,ST_makeTrajectory('STPOINT','LINESTRINGZ(114.000529 33.588163 54.87,114....

ST_lcsSubDistance

geometry,ARRAY['2010-01-01 11:30':timestamp,'2010-01-01 11:31','2010-01-01 11:32','2010-01-01 11:33','2010-01-01 11:34','2010-01-01 11:35'],NULL)a,ST_makeTrajectory('STPOINT','LINESTRINGZ(114.000529 33.588163 54.87,114....

ST_append

}},"events":[{"1":"2010-01-01 14:30:00"},{"2":"2010-01-01 15:00:00"},{"3":"2010-01-01 15:30:00"}]}}(1 row)-轨迹 With traj AS(Select ST_makeTrajectory('STPOINT','LINESTRING(1 1,6 6,9 8)':geometry,'[2010-01-01 11:30,2010-01-...

轨迹模型

st_starttime|st_endtime-+-2010-01-01 14:30:00|2010-01-01 15:30:00 2010-01-01 14:30:00|2010-01-01 15:30:00 2010-01-01 14:30:00|2010-01-01 15:30:00 2010-01-01 14:30:00|2010-01-01 15:30:00(4 rows)分析轨迹间的相近性 WITH traj ...

轨迹模型

st_starttime|st_endtime-+-2010-01-01 14:30:00|2010-01-01 15:30:00 2010-01-01 14:30:00|2010-01-01 15:30:00 2010-01-01 14:30:00|2010-01-01 15:30:00 2010-01-01 14:30:00|2010-01-01 15:30:00(4 rows)分析轨迹间的相近性 WITH traj ...

轨迹模型

st_starttime|st_endtime-+-2010-01-01 14:30:00|2010-01-01 15:30:00 2010-01-01 14:30:00|2010-01-01 15:30:00 2010-01-01 14:30:00|2010-01-01 15:30:00 2010-01-01 14:30:00|2010-01-01 15:30:00(4 rows)分析轨迹间的相近性 WITH traj ...

ST_AsTable

st_astable-("2010-01-01 11:30:00",1,1)("2010-01-01 12:30:00",3,5)(2 rows)-输出表格 select*from ST_AsTable('{"trajectory":{"version":1,"type":"STPOINT","leafcount":2,"start_time":"2010-01-01 11:30:00","end_time":"2010-01-01...

ST_AsTable

st_astable-("2010-01-01 11:30:00",1,1)("2010-01-01 12:30:00",3,5)(2 rows)-输出表格 select*from ST_AsTable('{"trajectory":{"version":1,"type":"STPOINT","leafcount":2,"start_time":"2010-01-01 11:30:00","end_time":"2010-01-01...

ST_AsTable

st_astable-("2010-01-01 11:30:00",1,1)("2010-01-01 12:30:00",3,5)(2 rows)-输出表格 select*from ST_AsTable('{"trajectory":{"version":1,"type":"STPOINT","leafcount":2,"start_time":"2010-01-01 11:30:00","end_time":"2010-01-01...

ST_makeTrajectory

sdf","sdfff"]},"active":{"type":"timestamp","length":8,"nullable":false,"value":["2010-01-01 14:30:00","2010-01-01 15:00:00","2010-01-01 15:30:00"]}},"events":[{"1":"2010-01-01 14:30:00"},{"2":"2010-01-01 15:00:00"},{"3":...

ST_makeTrajectory

sdf","sdfff"]},"active":{"type":"timestamp","length":8,"nullable":false,"value":["2010-01-01 14:30:00","2010-01-01 15:00:00","2010-01-01 15:30:00"]}},"events":[{"1":"2010-01-01 14:30:00"},{"2":"2010-01-01 15:00:00"},{"3":...

ST_makeTrajectory

sdf","sdfff"]},"active":{"type":"timestamp","length":8,"nullable":false,"value":["2010-01-01 14:30:00","2010-01-01 15:00:00","2010-01-01 15:30:00"]}},"events":[{"1":"2010-01-01 14:30:00"},{"2":"2010-01-01 15:00:00"},{"3":...

ST_makeTrajectory

sdf","sdfff"]},"active":{"type":"timestamp","length":8,"nullable":false,"value":["2010-01-01 14:30:00","2010-01-01 15:00:00","2010-01-01 15:30:00"]}},"events":[{"1":"2010-01-01 14:30:00"},{"2":"2010-01-01 15:00:00"},{"3":...

轨迹模型

st_starttime|st_endtime-+-2010-01-01 14:30:00|2010-01-01 15:30:00 2010-01-01 14:30:00|2010-01-01 15:30:00 2010-01-01 14:30:00|2010-01-01 15:30:00 2010-01-01 14:30:00|2010-01-01 15:30:00 2010-01-01 14:30:00|2010-01-01 15:30...

如何使用Outlook 2010收发邮件?

以Outlook 2010为例的操作步骤:用户信息 您的姓名:输入您的姓名,作为外发邮件“发件人”字段中显示的内容;电子邮件地址:输入您的完整邮箱的地 址;服务器信息 接收邮件服务器(POP3):pop3.aliyun.com 或 接收邮件服务器(imap):imap...

ST_InsertAttr

LINESTRING(114 35,115 36,116 37)","timeline":["2010-01-01 14:30:00","2010-01-01 15:00:00","2010-01-01 15:30:00"],"attributes":{"leafcount":3,"velocity":{"type":"integer","length":2,"nullable":true,"value":[120,130,140]},...

ST_InsertAttr

LINESTRING(114 35,115 36,116 37)","timeline":["2010-01-01 14:30:00","2010-01-01 15:00:00","2010-01-01 15:30:00"],"attributes":{"leafcount":3,"velocity":{"type":"integer","length":2,"nullable":true,"value":[120,130,140]},...

ST_trajAttrsAsText

st_trajattrsastext-{"2010-01-01 12:30:00",NULL}(1 row)With traj AS(select '{"trajectory":{"version":1,"type":"STPOINT","leafcount":2,"start_time":"2010-01-01 11:30:00","end_time":"2010-01-01 12:30:00","spatial":"SRID=4326;...

ST_trajAttrsAsText

st_trajattrsastext-{"2010-01-01 12:30:00",NULL}(1 row)With traj AS(select '{"trajectory":{"version":1,"type":"STPOINT","leafcount":2,"start_time":"2010-01-01 11:30:00","end_time":"2010-01-01 12:30:00","spatial":"SRID=4326;...

ST_InsertAttr

LINESTRING(114 35,115 36,116 37)","timeline":["2010-01-01 14:30:00","2010-01-01 15:00:00","2010-01-01 15:30:00"],"attributes":{"leafcount":3,"velocity":{"type":"integer","length":2,"nullable":true,"value":[120,130,140]},...

ST_trajAttrsAsText

st_trajattrsastext-{"2010-01-01 12:30:00",NULL}(1 row)With traj AS(select '{"trajectory":{"version":1,"type":"STPOINT","leafcount":2,"start_time":"2010-01-01 11:30:00","end_time":"2010-01-01 12:30:00","spatial":"SRID=4326;...

ST_trajAttrsAsText

st_trajattrsastext-{"2010-01-01 12:30:00",NULL}(1 row)With traj AS(select '{"trajectory":{"version":1,"type":"STPOINT","leafcount":2,"start_time":"2010-01-01 11:30:00","end_time":"2010-01-01 12:30:00","spatial":"SRID=4326;...

ST_eventTimes

示例 With traj AS(select '{"trajectory":{"version":1,"type":"STPOINT","leafcount":2,"start_time":"2010-01-01 11:30:00","end_time":"2010-01-01 12:30:00","spatial":"SRID=4326;LINESTRING(1 1,3 5)","timeline":["2010-01-01 11:...

ST_eventTimes

示例 With traj AS(select '{"trajectory":{"version":1,"type":"STPOINT","leafcount":2,"start_time":"2010-01-01 11:30:00","end_time":"2010-01-01 12:30:00","spatial":"SRID=4326;LINESTRING(1 1,3 5)","timeline":["2010-01-01 11:...

ST_eventTimes

示例 With traj AS(select '{"trajectory":{"version":1,"type":"STPOINT","leafcount":2,"start_time":"2010-01-01 11:30:00","end_time":"2010-01-01 12:30:00","spatial":"SRID=4326;LINESTRING(1 1,3 5)","timeline":["2010-01-01 11:...

ST_eventTimes

示例 With traj AS(select '{"trajectory":{"version":1,"type":"STPOINT","leafcount":2,"start_time":"2010-01-01 11:30:00","end_time":"2010-01-01 12:30:00","spatial":"SRID=4326;LINESTRING(1 1,3 5)","timeline":["2010-01-01 11:...

ST_attrTimestampFilter

value2 属性固定值-上限 示例 insert into traj values(3,ST_makeTrajectory('STPOINT':leaftype,st_geomfromtext('LINESTRING(114 35,115 36,116 37)',4326),ARRAY['2010-01-01 14:30':timestamp,'2010-01-01 15:00','2010-01-01 15:30'],...

ST_samplingInterval

string","length":20,"nullable":true,"value":["120","130","140"]},"active":{"type":"timestamp","nullable":false,"value":["Fri Jan 01 14:30:00 2010","Fri Jan 01 15:00:00 2010","Fri Jan 01 15:30:00 2010"]}},"events":[{"1":...

ST_samplingInterval

string","length":20,"nullable":true,"value":["120","130","140"]},"active":{"type":"timestamp","nullable":false,"value":["Fri Jan 01 14:30:00 2010","Fri Jan 01 15:00:00 2010","Fri Jan 01 15:30:00 2010"]}},"events":[{"1":...

ST_samplingInterval

string","length":20,"nullable":true,"value":["120","130","140"]},"active":{"type":"timestamp","nullable":false,"value":["Fri Jan 01 14:30:00 2010","Fri Jan 01 15:00:00 2010","Fri Jan 01 15:30:00 2010"]}},"events":[{"1":...

ST_attrTimestampFilter

示例 insert into traj values(3,ST_makeTrajectory('STPOINT':leaftype,st_geomfromtext('LINESTRING(114 35,115 36,116 37)',4326),ARRAY['2010-01-01 14:30':timestamp,'2010-01-01 15:00','2010-01-01 15:30'],'{"leafcount":3,...

ST_attrTimestampFilter

示例 insert into traj values(3,ST_makeTrajectory('STPOINT':leaftype,st_geomfromtext('LINESTRING(114 35,115 36,116 37)',4326),ARRAY['2010-01-01 14:30':timestamp,'2010-01-01 15:00','2010-01-01 15:30'],'{"leafcount":3,...

ST_samplingInterval

string","length":20,"nullable":true,"value":["120","130","140"]},"active":{"type":"timestamp","nullable":false,"value":["Fri Jan 01 14:30:00 2010","Fri Jan 01 15:00:00 2010","Fri Jan 01 15:30:00 2010"]}},"events":[{"1":...

ST_attrTimestampFilter

示例 insert into traj values(3,ST_makeTrajectory('STPOINT':leaftype,st_geomfromtext('LINESTRING(114 35,115 36,116 37)',4326),ARRAY['2010-01-01 14:30':timestamp,'2010-01-01 15:00','2010-01-01 15:30'],'{"leafcount":3,...

ST_attrLength

LINESTRING(1 1,3 5)","timeline":["2010-01-01 11:30:00","2010-01-01 12:30:00"],"attributes":{"leafcount":2,"velocity":{"type":"integer","length":4,"nullable":true,"value":[1,null]},"speed":{"type":"float","length":8,...

ST_attrType

LINESTRING(1 1,3 5)","timeline":["2010-01-01 11:30:00","2010-01-01 12:30:00"],"attributes":{"leafcount":2,"velocity":{"type":"integer","length":4,"nullable":true,"value":[1,null]},"speed":{"type":"float","length":8,...

ST_attrLength

LINESTRING(1 1,3 5)","timeline":["2010-01-01 11:30:00","2010-01-01 12:30:00"],"attributes":{"leafcount":2,"velocity":{"type":"integer","length":4,"nullable":true,"value":[1,null]},"speed":{"type":"float","length":8,...

ST_attrName

LINESTRING(1 1,3 5)","timeline":["2010-01-01 11:30:00","2010-01-01 12:30:00"],"attributes":{"leafcount":2,"velocity":{"type":"integer","length":4,"nullable":true,"value":[1,null]},"speed":{"type":"float","length":8,...

ST_attrNullable

LINESTRING(1 1,3 5)","timeline":["2010-01-01 11:30:00","2010-01-01 12:30:00"],"attributes":{"leafcount":2,"velocity":{"type":"integer","length":4,"nullable":true,"value":[1,null]},"speed":{"type":"float","length":8,...
共有93条 < 1 2 3 4 ... 93 >
跳转至: GO
产品推荐
云服务器 安全管家服务 安全中心
这些文档可能帮助您
数字证书管理服务(原SSL证书) 商标服务 云虚拟主机 域名 弹性公网IP 短信服务
新人特惠 爆款特惠 最新活动 免费试用