Permalink
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
34 lines (31 sloc) 1022 Bytes
[Module Metadata]
AUTHOR=Sarah Edwards/mac4n6.com/@iamevltwin
MODULE_NOTES=Parked Vehicle - Last Location
[Database Metadata]
DATABASE=Local.sqlite
PLATFORMS=IOS
VERSIONS=11
[Query Metadata]
QUERY_NAME=routined_local_vehicle_parked
ACTIVITY=Location
KEY_TIMESTAMP=DATE
[SQL Query 11]
QUERY=
SELECT
DATETIME(ZRTVEHICLEEVENTMO.ZDATE + 978307200, 'unixepoch') AS "DATE",
DATETIME(ZRTVEHICLEEVENTMO.ZLOCDATE + 978307200, 'unixepoch') AS "LOCATION DATE",
ZLOCLATITUDE || ", " || ZLOCLONGITUDE AS "COORDINATES",
ZVEHICLEIDENTIFIER AS "VEHICLE IDENTIFIER",
ZLOCUNCERTAINTY AS "LOCATION UNCERTAINTY",
ZIDENTIFIER AS "IDENTIFIER",
ZLOCATIONQUALITY AS "LOCATION QUALITY",
ZUSERSETLOCATION AS "USER SET LOCATION",
ZUSUALLOCATION AS "USUAL LOCATION",
ZNOTES AS "NOTES",
ZGEOMAPITEM AS "GEO MAP ITEM",
ZPHOTODATA AS "PHOTO DATA",
ZLOCLATITUDE AS "LATITUDE",
ZLOCLONGITUDE AS "LONGITUDE",
ZRTVEHICLEEVENTMO.Z_PK AS "ZRTLEARNEDVISITMO TABLE ID"
FROM
ZRTVEHICLEEVENTMO