Any one give me a JDBC sql query for my spatio temporal query?
2 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   shobana_nandakumar
Posted On:   Friday, February 4, 2011 06:31 AM

Trajectory table OBJID PLACE 7 H 8 Q 9 W 10 A 7 H 8 A 1 S 2 D 4 G 7 B 3 K 7 H 3 I 7 C i have trajectory table as shown in above. I want a spatio-temporal query using JDBC-SQL to retrieve results. 1. " Find all OBJIDs that move from place H to place B" 2. "Find all usertrajectories that move from place H to place B" here for example in this table objid 7 moves from H to B, hence the result should be .    More>>

Trajectory table

OBJID PLACE

7 H

8 Q

9 W

10 A

7 H

8 A

1 S

2 D

4 G

7 B

3 K

7 H

3 I

7 C

i have trajectory table as shown in above. I want a spatio-temporal query using JDBC-SQL to retrieve results.

1. " Find all OBJIDs that move from place H to place B"

2. "Find all usertrajectories that move from place H to place B"

here for example in this table objid 7 moves from H to B, hence the result should be .

output

query1

objids : 7


query2

7 trajectory is HHBHC

I want a SQL query for this.

   <<Less

Re: Any one give me a JDBC sql query for my spatio temporal query?

Posted By:   bbuggins  
Posted On:   Friday, June 14, 2013 05:43 PM

Bloody Spammers.
Limy Dedicated Servers  are the ultimate hosting solution that the ever-changing online industry can offer at the moment. With total authority over your own server and its excellent response time, your site will grow together with your business and you will keep your customers highly satisfied. You do not have to worry about sharing your resources – you get an entire server with all the space and bandwidth at your disposal.
http://www.limyservers.com/

Re: Any one give me a JDBC sql query for my spatio temporal query?

Posted By:   Anonymous  
Posted On:   Wednesday, February 9, 2011 12:34 AM

SELECT PLACE FROM Trajectory WHERE OBJID = 7

About | Sitemap | Contact