Permalink
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
27 lines (24 sloc) 798 Bytes
[Module Metadata]
AUTHOR=Sarah Edwards/mac4n6.com/@iamevltwin
MODULE_NOTES=Parked Vehicle - Historical Locations
[Database Metadata]
DATABASE=Local.sqlite
PLATFORMS=IOS
VERSIONS=11
[Query Metadata]
QUERY_NAME=routined_local_vehicle_parked_history
ACTIVITY=Location
KEY_TIMESTAMP=DATE
[SQL Query 11]
QUERY=
SELECT
DATETIME(ZRTVEHICLEEVENTHISTORYMO.ZDATE + 978307200, 'unixepoch') AS "DATE",
DATETIME(ZRTVEHICLEEVENTHISTORYMO.ZLOCDATE + 978307200, 'unixepoch') AS "LOCATION DATE",
ZLOCLATITUDE || ", " || ZLOCLONGITUDE AS "COORDINATES",
ZLOCUNCERTAINTY AS "LOCATION UNCERTAINTY",
ZIDENTIFIER AS "IDENTIFIER",
ZLOCLATITUDE AS "LATITUDE",
ZLOCLONGITUDE AS "LONGITUDE",
ZRTVEHICLEEVENTHISTORYMO.Z_PK AS "ZRTLEARNEDVISITMO TABLE ID"
FROM
ZRTVEHICLEEVENTHISTORYMO