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

Reply via email to