Any one give me a JDBC sql query for my spatio temporal query?
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"
"Find all usertrajectories that move from place H to place B"
here for example in this image objid 7 moves from H to B, hence the result should be .
objids : 7
7 trajectory is HHBHC
I want a SQL query for this.