Report not found

There was a problem finding this report.
COGS 127: Splicing out GPS coordinates
December 18, 2014 · Refreshed over 3 years ago

Collaborators

Run History
SELECT cast(substr(gps,1,(strpos(gps,','))-1) as float8) as Lat, cast(substr(gps,(strpos(gps,','))+1,char_length(gps)) as float8) as Long FROM kpena2.kpena20 WHERE gps!='inactive' /* This looks more complicated than it really is. Here's a quick explanation: 'cast' is a function that lets us convert our gps field into 'float8,' which means, basically, a number with decimal points. 'substr' and 'strpos' are using the comma in the gps coordinates to splice out latitude and longitude. We then give them names. The WHERE clause here is filtering out any data for which we did not get data. Thanks Kevin, Jose, and Jansen for the sample data! */
SELECT cast(substr(gps,1,(strpos(gps,','))-1) as float8) as Lat, cast(substr(gps,(strpos(gps,','))+1,char_length(gps)) as float8) as Long FROM kpena2.kpena20 WHERE gps!='inactive' /* This looks more complicated than it really is. Here's a quick explanation: 'cast' is a function that lets us convert our gps field into 'float8,' which means, basically, a number with decimal points. 'substr' and 'strpos' are using the comma in the gps coordinates to splice out latitude and longitude. We then give them names. The WHERE clause here is filtering out any data for which we did not get data. Thanks Kevin, Jose, and Jansen for the sample data! */
<div class="mode-header embed-hidden"> <h1>{{ title }}</h1> <p>{{ description }}</p> </div> <div class="container mode-grid"> <div class="row"> <div class="col-md-12"> <mode-chart id="chart_fbf86078bd2a" dataset="dataset" options="chart_options"></mode-chart> </div> </div> <div class="row"> <div class="col-md-12"> <mode-table id="table_0187e6927ad0" dataset="dataset" options="table_options"></mode-table> </div> </div> </div>
{{ dataSourceName(params.queryId) }}

The dataset is too large to view in browser

Export

Looks like something went wrong with your query.

{{ DS.queryRuns[params.queryId].errorMessage }}
This query was cancelled