<div dir="auto">This doesn't change the question, but I'm 99% sure that it is Geoserver which is refusing to parse the paren-free MultiPoint, not Oracle.<div dir="auto"><br></div><div dir="auto">This *may* affect the discussion, however, since that's at least two major products which do not accept the "incorrect" syntax.</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Dec 18, 2019, 12:23 PM Andy Teucher <<a href="mailto:andy.teucher@gmail.com">andy.teucher@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">The WKT representation of MULTIPOINT features can take two different forms, both of which are accepted (almost) universally. PostGIS (st_astext) implements the format without parentheses around individual point coordinate pairs:<br>
<br>
MULTIPOINT (0 0, 1 1)<br>
vs<br>
MULTIPOINT ((0 0), (1 1))<br>
<br>
I know this has been discussed in the past (<a href="https://lists.osgeo.org/pipermail/postgis-devel/2013-December/023990.html" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/pipermail/postgis-devel/2013-December/023990.html</a> and <a href="https://trac.osgeo.org/postgis/ticket/2558" rel="noreferrer noreferrer" target="_blank">https://trac.osgeo.org/postgis/ticket/2558</a>) however I’ve come across a situation where it is making a difference.<br>
<br>
I have been using a geoserver wfs service to obtain spatial data, and supplying multipoint features to a geometry predicate (e.g., INTERSECTS) without nested parenthesis fails:<br>
<br>
$ wget -O "a.json" "<a href="https://openmaps.gov.bc.ca/geo/pub/wfs?SERVICE=WFS&VERSION=2.0.0&REQUEST=GetFeature&outputFormat=application/json&typeNames=WHSE_BASEMAPPING.GBA_LOCAL_REG_GREENSPACES_SP&SRSNAME=EPSG:3005&CQL_FILTER=INTERSECTS(SHAPE" rel="noreferrer noreferrer" target="_blank">https://openmaps.gov.bc.ca/geo/pub/wfs?SERVICE=WFS&VERSION=2.0.0&REQUEST=GetFeature&outputFormat=application/json&typeNames=WHSE_BASEMAPPING.GBA_LOCAL_REG_GREENSPACES_SP&SRSNAME=EPSG:3005&CQL_FILTER=INTERSECTS(SHAPE</a>, MULTIPOINT (1236285 463726.8, 1228264 463547.4))"<br>
<br>
--2019-12-18 12:08:52--  <a href="https://openmaps.gov.bc.ca/geo/pub/wfs?SERVICE=WFS&VERSION=2.0.0&REQUEST=GetFeature&outputFormat=application/json&typeNames=WHSE_BASEMAPPING.GBA_LOCAL_REG_GREENSPACES_SP&SRSNAME=EPSG:3005&CQL_FILTER=INTERSECTS(SHAPE,%20MULTIPOINT%20(1236285%20463726.8,%201228264%20463547.4))" rel="noreferrer noreferrer" target="_blank">https://openmaps.gov.bc.ca/geo/pub/wfs?SERVICE=WFS&VERSION=2.0.0&REQUEST=GetFeature&outputFormat=application/json&typeNames=WHSE_BASEMAPPING.GBA_LOCAL_REG_GREENSPACES_SP&SRSNAME=EPSG:3005&CQL_FILTER=INTERSECTS(SHAPE,%20MULTIPOINT%20(1236285%20463726.8,%201228264%20463547.4))</a><br>
Resolving <a href="http://openmaps.gov.bc.ca" rel="noreferrer noreferrer" target="_blank">openmaps.gov.bc.ca</a> (<a href="http://openmaps.gov.bc.ca" rel="noreferrer noreferrer" target="_blank">openmaps.gov.bc.ca</a>)... 142.34.140.41<br>
Connecting to <a href="http://openmaps.gov.bc.ca" rel="noreferrer noreferrer" target="_blank">openmaps.gov.bc.ca</a> (<a href="http://openmaps.gov.bc.ca" rel="noreferrer noreferrer" target="_blank">openmaps.gov.bc.ca</a>)|142.34.140.41|:443... connected.<br>
HTTP request sent, awaiting response... 400<br>
2019-12-18 12:08:52 ERROR 400: (no description).<br>
<br>
But it works when inner parentheses are present:<br>
<br>
$ wget -O "a.json" "<a href="https://openmaps.gov.bc.ca/geo/pub/wfs?SERVICE=WFS&VERSION=2.0.0&REQUEST=GetFeature&outputFormat=application/json&typeNames=WHSE_BASEMAPPING.GBA_LOCAL_REG_GREENSPACES_SP&SRSNAME=EPSG:3005&CQL_FILTER=INTERSECTS(SHAPE" rel="noreferrer noreferrer" target="_blank">https://openmaps.gov.bc.ca/geo/pub/wfs?SERVICE=WFS&VERSION=2.0.0&REQUEST=GetFeature&outputFormat=application/json&typeNames=WHSE_BASEMAPPING.GBA_LOCAL_REG_GREENSPACES_SP&SRSNAME=EPSG:3005&CQL_FILTER=INTERSECTS(SHAPE</a>, MULTIPOINT ((1236285 463726.8), (1228264 463547.4)))"<br>
<br>
--2019-12-18 12:10:20--  <a href="https://openmaps.gov.bc.ca/geo/pub/wfs?SERVICE=WFS&VERSION=2.0.0&REQUEST=GetFeature&outputFormat=application/json&typeNames=WHSE_BASEMAPPING.GBA_LOCAL_REG_GREENSPACES_SP&SRSNAME=EPSG:3005&CQL_FILTER=INTERSECTS(SHAPE,%20MULTIPOINT%20((1236285%20463726.8),%20(1228264%20463547.4)))" rel="noreferrer noreferrer" target="_blank">https://openmaps.gov.bc.ca/geo/pub/wfs?SERVICE=WFS&VERSION=2.0.0&REQUEST=GetFeature&outputFormat=application/json&typeNames=WHSE_BASEMAPPING.GBA_LOCAL_REG_GREENSPACES_SP&SRSNAME=EPSG:3005&CQL_FILTER=INTERSECTS(SHAPE,%20MULTIPOINT%20((1236285%20463726.8),%20(1228264%20463547.4)))</a><br>
Resolving <a href="http://openmaps.gov.bc.ca" rel="noreferrer noreferrer" target="_blank">openmaps.gov.bc.ca</a> (<a href="http://openmaps.gov.bc.ca" rel="noreferrer noreferrer" target="_blank">openmaps.gov.bc.ca</a>)... 142.34.140.41<br>
Connecting to <a href="http://openmaps.gov.bc.ca" rel="noreferrer noreferrer" target="_blank">openmaps.gov.bc.ca</a> (<a href="http://openmaps.gov.bc.ca" rel="noreferrer noreferrer" target="_blank">openmaps.gov.bc.ca</a>)|142.34.140.41|:443... connected.<br>
HTTP request sent, awaiting response... 200<br>
Length: unspecified [application/json]<br>
Saving to: ‘a.json’<br>
<br>
a.json                  [ <=>                ]   3.59K  --.-KB/s    in 0s<br>
2019-12-18 12:10:20 (35.4 MB/s) - ‘a.json’ saved [3678]<br>
<br>
I believe the database behind the geoserver is Oracle, which I have seen elsewhere only accepts the variety of MULTIPOINT with nested parentheses (<a href="https://viswaug.wordpress.com/2011/02/13/well-known-text-wkt-representation-for-multipoint/" rel="noreferrer noreferrer" target="_blank">https://viswaug.wordpress.com/2011/02/13/well-known-text-wkt-representation-for-multipoint/</a>).<br>
<br>
What is the possibility of PostGIS being able to output the nested-parens version of MULTIPOINT wkt?<br>
<br>
Thanks for your time!<br>
Andy Teucher<br>
<br>
<br>
_______________________________________________<br>
postgis-devel mailing list<br>
<a href="mailto:postgis-devel@lists.osgeo.org" target="_blank" rel="noreferrer">postgis-devel@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-devel" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-devel</a></blockquote></div>