Permalink
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
29 lines (26 sloc) 801 Bytes
[Module Metadata]
AUTHOR=Sarah Edwards/mac4n6.com/@iamevltwin
MODULE_NOTES=Granular Location Data (~1 Week)
[Database Metadata]
DATABASE=Cache.sqlite,CoreRoutine.sqlite
PLATFORMS=IOS
VERSIONS=10,11
[Query Metadata]
QUERY_NAME=routined_cache_zrtcllocationmo
ACTIVITY=Location
KEY_TIMESTAMP=TIMESTAMP
[SQL Query 10,11]
QUERY=
SELECT
DATETIME(ZTIMESTAMP + 978307200, 'unixepoch') AS "TIMESTAMP",
ZLATITUDE || ", " || ZLONGITUDE AS "COORDINATES",
ZALTITUDE AS "ALTITUDE",
ZCOURSE AS "COURSE",
ZSPEED AS "SPEED (M/S)",
ZHORIZONTALACCURACY AS "HORIZONTAL ACCURACY",
ZVERTICALACCURACY AS "VERTICAL ACCURACY",
ZLATITUDE AS "LATITUDE",
ZLONGITUDE AS "LONGITUDE",
ZRTCLLOCATIONMO.Z_PK AS "ZRTCLLOCATIONMO TABLE ID"
FROM
ZRTCLLOCATIONMO