jkburges
jkburges
/ geotools queries.txt
Created
November 2, 2015 05:53
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
| ## 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 |
jkburges
/ chain_example.xml
Created
October 28, 2015 00:05
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
| <?xml version="1.0" encoding="UTF-8"?> | |
| <wps:Execute version="1.0.0" service="WPS" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.opengis.net/wps/1.0.0" xmlns:wfs="http://www.opengis.net/wfs" xmlns:wps="http://www.opengis.net/wps/1.0.0" xmlns:ows="http://www.opengis.net/ows/1.1" xmlns:gml="http://www.opengis.net/gml" xmlns:ogc="http://www.opengis.net/ogc" xmlns:wcs="http://www.opengis.net/wcs/1.1.1" xmlns:xlink="http://www.w3.org/1999/xlink" xsi:schemaLocation="http://www.opengis.net/wps/1.0.0 http://schemas.opengis.net/wps/1.0.0/wpsAll.xsd"> | |
| <ows:Identifier>gs:Notifier</ows:Identifier> | |
| <wps:DataInputs> | |
| <wps:Input> | |
| <ows:Identifier>notifiable</ows:Identifier> | |
| <wps:Reference mimeType="application/octet-stream" xlink:href="http://geoserver/wps" method="POST"> | |
| <wps:Body> | |
| <wps:Execute version="1.0.0" service="WPS"> | |
| <ows:Identifier>gs:Fallible</ows:Identifier> |
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
| [INFO] Scanning for projects... | |
| [WARNING] | |
| [WARNING] Some problems were encountered while building the effective model for au.org.emii:geoserver-layer-filter-extension:jar:1.0.0 | |
| [WARNING] 'build.plugins.plugin.version' for org.apache.maven.plugins:maven-compiler-plugin is missing. @ au.org.emii:geoserver-layer-filter-extension:[unknown-version], /Users/jkburges/git/geoserver-build/src/extension/geoserver-layer-filter-extension/pom.xml, line 63, column 21 | |
| [WARNING] | |
| [WARNING] It is highly recommended to fix these problems because they threaten the stability of your build. | |
| [WARNING] | |
| [WARNING] For this reason, future Maven versions might no longer support building such malformed projects. | |
| [WARNING] | |
| [INFO] ------------------------------------------------------------------------ |
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
| [INFO] Scanning for projects... | |
| [WARNING] | |
| [WARNING] Some problems were encountered while building the effective model for au.org.emii:geoserver-layer-filter-extension:jar:1.0.0 | |
| [WARNING] 'build.plugins.plugin.version' for org.apache.maven.plugins:maven-compiler-plugin is missing. @ au.org.emii:geoserver-layer-filter-extension:[unknown-version], /Users/jkburges/git/geoserver-build/src/extension/geoserver-layer-filter-extension/pom.xml, line 63, column 21 | |
| [WARNING] | |
| [WARNING] It is highly recommended to fix these problems because they threaten the stability of your build. | |
| [WARNING] | |
| [WARNING] For this reason, future Maven versions might no longer support building such malformed projects. | |
| [WARNING] | |
| [INFO] ------------------------------------------------------------------------ |
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
| [INFO] Scanning for projects... | |
| [WARNING] | |
| [WARNING] Some problems were encountered while building the effective model for au.org.emii.wps:gogoduck:jar:2.0 | |
| [WARNING] The expression ${parent.version} is deprecated. Please use ${project.parent.version} instead. | |
| [WARNING] | |
| [WARNING] It is highly recommended to fix these problems because they threaten the stability of your build. | |
| [WARNING] | |
| [WARNING] For this reason, future Maven versions might no longer support building such malformed projects. | |
| [WARNING] | |
| [INFO] |
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
| [INFO] Scanning for projects... | |
| [ERROR] [ERROR] Some problems were encountered while processing the POMs: | |
| [WARNING] 'build.plugins.plugin.version' for org.apache.maven.plugins:maven-compiler-plugin is missing. @ line 69, column 21 | |
| [ERROR] 'dependencies.dependency.version' for org.geoserver.web:gs-web-core:jar is missing. @ line 29, column 21 | |
| [ERROR] 'dependencies.dependency.version' for org.geoserver:gs-wfs:jar is missing. @ line 33, column 21 | |
| [ERROR] 'dependencies.dependency.version' for org.apache.wicket:wicket:jar must be a valid version but is '${wicket.version}'. @ line 40, column 22 | |
| [ERROR] 'dependencies.dependency.version' for org.geoserver.web:gs-web-core:jar is missing. @ line 29, column 21 | |
| [ERROR] 'dependencies.dependency.version' for org.geoserver:gs-wfs:jar is missing. @ line 33, column 21 | |
| @ | |
| [ERROR] The build could not read 2 projects -> [Help 1] |
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
| <project xmlns="http://maven.apache.org/POM/4.0.0" | |
| xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" | |
| xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 | |
| http://maven.apache.org/maven-v4_0_0.xsd "> | |
| <modelVersion>4.0.0</modelVersion> | |
| <groupId>org.geoserver</groupId> | |
| <artifactId>hello_wps</artifactId> | |
| <packaging>jar</packaging> | |
| <version>2.8-SNAPSHOT</version> |
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
| <project xmlns="http://maven.apache.org/POM/4.0.0" | |
| xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" | |
| xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 | |
| http://maven.apache.org/maven-v4_0_0.xsd "> | |
| <modelVersion>4.0.0</modelVersion> | |
| <groupId>org.geoserver</groupId> | |
| <artifactId>hello_wps</artifactId> | |
| <packaging>jar</packaging> | |
| <version>2.8-SNAPSHOT</version> |
jkburges
/ netcdfs.txt
Created
October 5, 2015 05:32
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
| IMOS_SOOP-TMV_TSB_20080828T101848Z_VLST_FV02_transect-M2D_END-20080828T204908Z.nc | |
| IMOS_SOOP-TMV_TSB_20080829T101313Z_VLST_FV02_transect-D2M_END-20080829T205143Z.nc | |
| IMOS_SOOP-TMV_TSB_20080830T101010Z_VLST_FV02_transect-M2D_END-20080830T204910Z.nc | |
| IMOS_SOOP-TMV_TSB_20080901T095222Z_VLST_FV02_transect-D2M_END-20080901T204612Z.nc | |
| IMOS_SOOP-TMV_TSB_20080902T100053Z_VLST_FV02_transect-M2D_END-20080902T204403Z.nc | |
| IMOS_SOOP-TMV_TSB_20080903T095249Z_VLST_FV02_transect-D2M_END-20080903T203929Z.nc | |
| IMOS_SOOP-TMV_TSB_20080904T094608Z_VLST_FV02_transect-M2D_END-20080904T204518Z.nc | |
| IMOS_SOOP-TMV_TSB_20080905T100334Z_VLST_FV02_transect-D2M_END-20080905T204204Z.nc | |
| IMOS_SOOP-TMV_TSB_20080906T094954Z_VLST_FV02_transect-M2D_END-20080906T204404Z.nc | |
| IMOS_SOOP-TMV_TSB_20080908T095208Z_VLST_FV02_transect-D2M_END-20080908T204158Z.nc |
jkburges
/ sqlerror.sql
Created
September 18, 2015 05:43
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
| Running test au.org.emii.aatams.monthlyreport.MonthlyReportsTests...2015-09-18 15:15:57,262 [main] [] WARN Sql - Failed to execute: WITH vd AS ( | |
| SELECT DISTINCT p.id AS project_id, | |
| p.name AS project_name, | |
| i.name AS installation_name, | |
| ist.name AS station_name, | |
| vd.transmitter_id, | |
| CASE WHEN vd.receiver_deployment_id IS NULL THEN rd.id ELSE vd.receiver_deployment_id END AS receiver_deployment_id, | |
| registered, | |
| COUNT(timestamp) AS no_detections, | |
| min(timestamp) AS start_date, |