Re: [MonetDB-users] Fwd: wkb representation of a geometry

Assume that you have a table like geometries(id INT, shape GEOMETRY) and the query SELECT id, GeomFromText(shape) FROM geometries . Would this query return the WKB representation of the geometries "directly" or is there an intermediate step where the geometry is being converted to WKT (WKB --> WKT --> WKB)? On Wed, Apr 27, 2011 at 3:30 PM, Sjoerd Mullender wrote:

On 2011-04-27 11:30, Georgios Garmpis wrote:

...

In SQL

I need something like that SELECT AsWKB('POINT(1, 2)');

What about this: SELECT GeomFromText('POINT(1 2)', 0);

The string ('POINT(1 2)') should not have a comma in it, and the extra argument (0) is ignored.

...

On Wed, Apr 27, 2011 at 12:09 PM, mailto:Stefan.Manegold@cwi.nl> wrote:

George,

where do you need to get the Well Known Binary representation of a geometry? As documentation? In C? In MAL? In SQL?

Stefan

On Wed, Apr 27, 2011 at 11:50:53AM +0300, Georgios Garmpis wrote: > Hi, > > I need to get the Well Known Binary representation of a geometry but > I didn't find any function in documentation to do this. > Any ideas? > > -- > George Garbis

>

------------------------------------------------------------------------------

...

> WhatsUp Gold - Download Free Network Management Software > The most intuitive, comprehensive, and cost-effective network > management toolset available today. Delivers lowest initial > acquisition cost and overall TCO of any competing solution. > http://p.sf.net/sfu/whatsupgold-sd

> _______________________________________________ > MonetDB-users mailing list > MonetDB-users@lists.sourceforge.net mailto:MonetDB-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

------------------------------------------------------------------------------

...

WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net mailto:MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- George Garbis

------------------------------------------------------------------------------

...

WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd

_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- Sjoerd Mullender

------------------------------------------------------------------------------ WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users