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

Another example would the following. Suppose that we have the table geometries(id INT, shape GEOMETRY) and we would like to retrieve the WKB and WKT representation of the geometry. For example we would like to ask the following query: select id, AsWKB(geo) AS GeoWKB, AsWKT(geo) AS GeoWKT from geometries Regards, Kostis On Wed, Apr 27, 2011 at 12:30 PM, Georgios Garmpis wrote:

In SQL

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

On Wed, Apr 27, 2011 at 12:09 PM, 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 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 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