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 sjoerd@acm.org 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, <Stefan.Manegold@cwi.nl 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