Permalink
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
25 lines (22 sloc) 616 Bytes
[Module Metadata]
AUTHOR=Sarah Edwards/mac4n6.com/@iamevltwin
MODULE_NOTES=Semi-granular Location Data (~1 Week)
[Database Metadata]
DATABASE=Cache.sqlite,CoreRoutine.sqlite
PLATFORMS=IOS
VERSIONS=10,11
[Query Metadata]
QUERY_NAME=routined_cache_zrthintmo
ACTIVITY=Location
KEY_TIMESTAMP=TIMESTAMP
[SQL Query 10,11]
QUERY=
SELECT
DATETIME(ZDATE + 978307200, 'unixepoch') AS "TIMESTAMP",
ZLATITUDE || ", " || ZLONGITUDE AS "COORDINATES",
ZSOURCE AS "SOURCE",
ZLATITUDE AS "LATITUDE",
ZLONGITUDE AS "LONGITUDE",
ZRTHINTMO.Z_PK AS "ZRTHINTMO TABLE ID"
FROM
ZRTHINTMO