Zirwin95
Zirwin95
/ DECO Query Ex #1
Last active
December 19, 2015 23:28
A query of the event recorded in Wyoming using Postgres Standard Query Language (pSQL).
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Motivation: find the fields we are interested in. | |
| "The images and duration from and between events recorded by two phones at a specific location (Casper, Wyoming)." | |
| *42.820738, -106.265443* | |
| gsw=> \d deco_observation_v | |
| View "public.deco_observation_v" | |
| Column | Type | Modifiers | |
| ---------------------------+--------------------------+----------- | |
| id_pk | bigint | (Image identification, primary key) |