geotools queries.txt

## PO Box (2.8.0)


## With 'Z'
SELECT "timeseries_id","file_url","size","site_code","time",encode(ST_AsEWKB("st_makepoint"),'base64') as "st_makepoint" FROM (select *, ST_makepoint(1, 2) from acorn_hourly_avg_qc.acorn_hourly_avg_qc_timeseries_url where site_code = 'ROT, Rottnest Shelf') as "vtable" WHERE  ("time" = '2014-06-06 10:30:00.0' AND "time" IS NOT NULL ) LIMIT 1000000


## Without 'Z'
SELECT "timeseries_id","file_url","size","site_code","time",encode(ST_AsEWKB("st_makepoint"),'base64') as "st_makepoint" FROM (select *, ST_makepoint(1, 2) from acorn_hourly_avg_qc.acorn_hourly_avg_qc_timeseries_url where site_code = 'ROT, Rottnest Shelf') as "vtable" WHERE  ("time" = '2014-06-06 00:30:00.0' AND "time" IS NOT NULL ) LIMIT 1000000


## PO Box (2.7.1.1)

## With 'Z'
SELECT "timeseries_id","file_url","size","site_code","time",encode(ST_AsEWKB("st_makepoint"),'base64') as "st_makepoint" FROM (select *, ST_makepoint(1, 2) from acorn_hourly_avg_qc.acorn_hourly_avg_qc_timeseries_url where site_code = 'ROT, Rottnest Shelf') as "vtable" WHERE  ("time" = '2014-06-06 10:30:00.0' AND "time" IS NOT NULL ) LIMIT 1000000


## Without 'Z'
SELECT "timeseries_id","file_url","size","site_code","time",encode(ST_AsEWKB("st_makepoint"),'base64') as "st_makepoint" FROM (select *, ST_makepoint(1, 2) from acorn_hourly_avg_qc.acorn_hourly_avg_qc_timeseries_url where site_code = 'ROT, Rottnest Shelf') as "vtable" WHERE  ("time" = '2014-06-06 00:30:00.0' AND "time" IS NOT NULL ) LIMIT 1000000

## 1-aws-syd vagrant

## With 'Z'

SELECT "timeseries_id","file_url","size","site_code","time",encode(ST_AsEWKB("st_makepoint"),'base64') as "st_makepoint" FROM (select *, ST_makepoint(1, 2) from acorn_hourly_avg_qc.acorn_hourly_avg_qc_timeseries_url where site_code = 'ROT, Rottnest Shelf') as "vtable" WHERE  ("time" = '2014-06-05T14:30:00Z' AND "time" IS NOT NULL ) LIMIT 1000000



## Without 'Z'

SELECT "timeseries_id","file_url","size","site_code","time",encode(ST_AsEWKB("st_makepoint"),'base64') as "st_makepoint" FROM (select *, ST_makepoint(1, 2) from acorn_hourly_avg_qc.acorn_hourly_avg_qc_timeseries_url where site_code = 'ROT, Rottnest Shelf') as "vtable" WHERE  ("time" = '2014-06-05T14:30:00Z' AND "time" IS NOT NULL ) LIMIT 1000000