On 2011-04-27 14:52, Kostis Kyzirakos wrote:This is not available in MonetDB (as far as I can tell by quickly
> In Postgres the WKB representation of a geometry is returned as a byte
> array.
> For example,
>
> LGD=# SELECT ST_AsBinary(ST_GeomFromText('POINT(1 2)',-1));
> st_asbinary
> ----------------------------------------------
> \x0101000000000000000000f03f0000000000000040
> (1 row)
looking at the code).
What you get when you do
SELECT * FROM t;
where t contains a column of type geometry is the string representation
of the internal (WKB) representation produced by the function
GEOSGeomToWKT(). I.e., one conversion WKB->WKT.
If you do
SELECT GeomFromText(g,0) FROM t;
where g is a column of type geometry, it does a conversion
WKB->WKT->WKB->WKT because an intermediate table is created with the
result of GeomFromText. GeomFromText expects a string (varchar) and so
an automatic WKB->WKT conversion takes place. GeomFromText itself does
the WKT->WKB conversion, and you get an extra WKT->WKB conversion
because the select produces a textual representation of the column.
> <mailto:sjoerd@acm.org>> wrote:
>
> On 2011-04-27 14:37, Georgios Garmpis wrote:
> > I have tried GeomFromText but it doesn't seem to return WKB.
> >
> > sql>SELECT GeomFromText('POINT(1 2)', 0);
> >
> +----------------------------------------------------------------------------+
> > | geomfromtext_single_value |
> > +======================================+
> > | POINT (1.0000000000000000 2.0000000000000000) |
> >
> +----------------------------------------------------------------------------+
> > 1 tuple (0.325ms)
>
> Then what do you expect (or wish to get)? What would the WKB look like
> at the SQL level?
>
> >
> >
> > On Wed, Apr 27, 2011 at 3:30 PM, Sjoerd Mullender <sjoerd@acm.org
> <mailto:sjoerd@acm.org>
> > <mailto:sjoerd@acm.org <mailto: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>
> > <mailto:Stefan.Manegold@cwi.nl <mailto:Stefan.Manegold@cwi.nl>>
> > > <mailto:Stefan.Manegold@cwi.nl
> <mailto:Stefan.Manegold@cwi.nl> <mailto: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>
> > <mailto:MonetDB-users@lists.sourceforge.net
> <mailto:MonetDB-users@lists.sourceforge.net>>
> > > <mailto:MonetDB-users@lists.sourceforge.net
> <mailto:MonetDB-users@lists.sourceforge.net>
> > <mailto: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>
> > <mailto:MonetDB-users@lists.sourceforge.net
> <mailto:MonetDB-users@lists.sourceforge.net>>
> > > <mailto:MonetDB-users@lists.sourceforge.net
> <mailto:MonetDB-users@lists.sourceforge.net>
> > <mailto: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
> <mailto:MonetDB-users@lists.sourceforge.net>
> > <mailto:MonetDB-users@lists.sourceforge.net
> <mailto: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
> <mailto:MonetDB-users@lists.sourceforge.net>
> > <mailto: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
> <mailto: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
> <mailto:MonetDB-users@lists.sourceforge.net>
> https://lists.sourceforge.net/lists/listinfo/monetdb-users
>
>
>
>
> ------------------------------------------------------------------------------
> 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