Hi,
>>what about the multiple geometry column issue? what would be a use case
for that and how would you suggest to present those in OJ? ..ede For postgis, as far as I remember, we read the first geometry column as geometry and following geometry columns as String or Object (don't remember).
In the RunQueryPlugin, if I need the second geometry column of a table having geom1, geom2, I write :
select geom2 as geom, * from table
(or the exact list of columns to avoid duplication of geom2 column)
Michaël
envoyé : 29 septembre 2020 à 10:57 de : edgar.sol...@web.de à : jump-pilot-devel@lists.sourceforge.net objet : Re: [JPP-Devel] Run datastore query too tied to schema with Spatialide DS
morning Jukka,
On 9/29/2020 9:15, Rahkonen Jukka (MML) wrote: >> There would be still some corner cases left (select geom as geometry1, ST_Centroid(geom) as geometry2... in theory our features may hold multiple geometries. just one can be shown though and the second would be like some object attribute. not sure what'd be a use case for that.
what about the multiple geometry column issue? what would be a use case for that and how would you suggest to present those in OJ? ..ede
_______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
|
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel