function geomfromtext(box3d, integer) does not exist

classic Classic list List threaded Threaded
12 messages Options
Reply | Threaded
Open this post in threaded view
|

function geomfromtext(box3d, integer) does not exist

"Weßling, Achim"
Hallo,

if have some difficulties doing the following SELECT:

SELECT objnr, objart, bemerkung, asText(the_geom) AS the_geom
    FROM f001_e_fla
    WHERE the_geom && GeomFromText('BOX3D(3446100.431483785
5773647.50152, 3446321.932947913 5773823.243699623)'::box3d, 31467);

I get the following error message:

function geomfromtext(box3d, integer) does not exist

What's wrong? If I run this SELECT on my old maschine (postgis 0.8.1 on
postgresql 7.4) I've no problem. But on my new system (postgis 1.0.0 RC6
on postgresql 8.0) I get the above error?

in postgis 0.8.1 the function takes the parameters as geometry and int4,
in postgis 1.0.0 RC6 the function takes the parameters as text and int
4!

But the docu for RC 6 which I downloaded just a few days, has an example
of using box3d as I did!

Any hint would be nice!
--
Mit freundlichem Gruß

Achim Weßling
===========================================
INFOKOM Gütersloh AöR
Fachbereich II - Technische Anwendungen
Herzebrocker Str. 140
33334 Gütersloh
Tel.: 05241/85-2926
[hidden email]
http://www.infokom-gt.de


Reply | Threaded
Open this post in threaded view
|

Re: function geomfromtext(box3d, integer) does not exist

Markus Schaber
Hi, Achim,

Achim Weßling schrieb:

> in postgis 0.8.1 the function takes the parameters as geometry and int4,
> in postgis 1.0.0 RC6 the function takes the parameters as text and int
> 4!

The PostGIS 1.0.0 function is the correct one, as it should only accept
OpenGIS compliant WKT specifications.

As a workaround, you can use setsrid('BOX3D(...)',31467) which should
work on both releases.

> But the docu for RC 6 which I downloaded just a few days, has an example
> of using box3d as I did!

Hups, it seems that the docu is out of date there.

Markus


signature.asc (256 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: function geomfromtext(box3d, integer) does not exist

strk-2
On Wed, Apr 20, 2005 at 12:10:55PM +0200, Markus Schaber wrote:

> Hi, Achim,
>
> Achim Weßling schrieb:
>
> > in postgis 0.8.1 the function takes the parameters as geometry and int4,
> > in postgis 1.0.0 RC6 the function takes the parameters as text and int
> > 4!
>
> The PostGIS 1.0.0 function is the correct one, as it should only accept
> OpenGIS compliant WKT specifications.
>
> As a workaround, you can use setsrid('BOX3D(...)',31467) which should
> work on both releases.
>
> > But the docu for RC 6 which I downloaded just a few days, has an example
> > of using box3d as I did!
>
> Hups, it seems that the docu is out of date there.

I've fixed this in current CVS.
Unfortunately it didn't get into 1.0.0.
--strk;

>
> Markus
>



> _______________________________________________
> postgis-users mailing list
> [hidden email]
> http://postgis.refractions.net/mailman/listinfo/postgis-users


Reply | Threaded
Open this post in threaded view
|

Re: function geomfromtext(box3d, integer) does not exist

Markus Schaber
Hi, Strk,

[hidden email] schrieb:

> I've fixed this in current CVS.
> Unfortunately it didn't get into 1.0.0.

That was fast. Did you "backport" it into the 1.0.0 branch so it gets
into 1.0.1 should that get necessary for other reasons?

Markus

Reply | Threaded
Open this post in threaded view
|

Re: function geomfromtext(box3d, integer) does not exist

strk-2
On Wed, Apr 20, 2005 at 12:20:09PM +0200, Markus Schaber wrote:
> Hi, Strk,
>
> [hidden email] schrieb:
>
> > I've fixed this in current CVS.
> > Unfortunately it didn't get into 1.0.0.
>
> That was fast. Did you "backport" it into the 1.0.0 branch so it gets
> into 1.0.1 should that get necessary for other reasons?

Forgot it. Now done.
--strk;

>
> Markus
> _______________________________________________
> postgis-users mailing list
> [hidden email]
> http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply | Threaded
Open this post in threaded view
|

Re: function geomfromtext(box3d, integer) does not exist

"Weßling, Achim"
So,

can someone tell me how the right syntax looks like?

Achim

Am Mi, den 20.04.2005 schrieb [hidden email] um 12:23:

> On Wed, Apr 20, 2005 at 12:20:09PM +0200, Markus Schaber wrote:
> > Hi, Strk,
> >
> > [hidden email] schrieb:
> >
> > > I've fixed this in current CVS.
> > > Unfortunately it didn't get into 1.0.0.
> >
> > That was fast. Did you "backport" it into the 1.0.0 branch so it gets
> > into 1.0.1 should that get necessary for other reasons?
>
> Forgot it. Now done.
> --strk;
>
> >
> > Markus
> > _______________________________________________
> > postgis-users mailing list
> > [hidden email]
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> [hidden email]
> http://postgis.refractions.net/mailman/listinfo/postgis-users


Reply | Threaded
Open this post in threaded view
|

Re: function geomfromtext(box3d, integer) does not exist

strk-2
On Wed, Apr 20, 2005 at 02:09:46PM +0200, Achim Weßling wrote:
> So,
>
> can someone tell me how the right syntax looks like?

SetSRID('BOX3D(...)'::box3d, SRID)
--strk;

>
> Achim
>
> Am Mi, den 20.04.2005 schrieb [hidden email] um 12:23:
> > On Wed, Apr 20, 2005 at 12:20:09PM +0200, Markus Schaber wrote:
> > > Hi, Strk,
> > >
> > > [hidden email] schrieb:
> > >
> > > > I've fixed this in current CVS.
> > > > Unfortunately it didn't get into 1.0.0.
> > >
> > > That was fast. Did you "backport" it into the 1.0.0 branch so it gets
> > > into 1.0.1 should that get necessary for other reasons?
> >
> > Forgot it. Now done.
> > --strk;
> >
> > >
> > > Markus
> > > _______________________________________________
> > > postgis-users mailing list
> > > [hidden email]
> > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > _______________________________________________
> > postgis-users mailing list
> > [hidden email]
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> [hidden email]
> http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply | Threaded
Open this post in threaded view
|

Re: function geomfromtext(box3d, integer) does not exist

Markus Schaber
In reply to this post by strk-2
Hi, Strk,

[hidden email] schrieb:

>>>I've fixed this in current CVS.
>>>Unfortunately it didn't get into 1.0.0.
>>That was fast. Did you "backport" it into the 1.0.0 branch so it gets
>>into 1.0.1 should that get necessary for other reasons?
> Forgot it. Now done.

Thanks a lot!

Markus

Reply | Threaded
Open this post in threaded view
|

Re: function geomfromtext(box3d, integer) does not exist

"Weßling, Achim"
In reply to this post by strk-2
Sorry ;-)

but after changing my SELECT as follows:

SELECT objnr, objart, bemerkung, asText(the_geom) AS the_geom
    FROM f001_e_fla
    WHERE the_geom && GeomFromText(setsrid('BOX3D(3446100 5773647,
3446321 5773823)'::box3d, 31467));

I get:  Error: ERROR: Invalid OGC WKT (does not start with P,L,M or G)

Again this works on 0.8.1, but doesn't on 1.0.0RC6!

Achim

Am Mi, den 20.04.2005 schrieb [hidden email] um 13:19:

> On Wed, Apr 20, 2005 at 02:09:46PM +0200, Achim Weßling wrote:
> > So,
> >
> > can someone tell me how the right syntax looks like?
>
> SetSRID('BOX3D(...)'::box3d, SRID)
> --strk;
>
> >
> > Achim
> >
> > Am Mi, den 20.04.2005 schrieb [hidden email] um 12:23:
> > > On Wed, Apr 20, 2005 at 12:20:09PM +0200, Markus Schaber wrote:
> > > > Hi, Strk,
> > > >
> > > > [hidden email] schrieb:
> > > >
> > > > > I've fixed this in current CVS.
> > > > > Unfortunately it didn't get into 1.0.0.
> > > >
> > > > That was fast. Did you "backport" it into the 1.0.0 branch so it gets
> > > > into 1.0.1 should that get necessary for other reasons?
> > >
> > > Forgot it. Now done.
> > > --strk;
> > >
> > > >
> > > > Markus
> > > > _______________________________________________
> > > > postgis-users mailing list
> > > > [hidden email]
> > > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > _______________________________________________
> > > postgis-users mailing list
> > > [hidden email]
> > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> > _______________________________________________
> > postgis-users mailing list
> > [hidden email]
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> [hidden email]
> http://postgis.refractions.net/mailman/listinfo/postgis-users


Reply | Threaded
Open this post in threaded view
|

Re: function geomfromtext(box3d, integer) does not exist

strk-2
SetSRID replaces GeomFromText.
GeomFromText, as name suggests accepts TEXT, not BOX3D, not GEOMETRY.
SetSRID accepts GEOMETRY, and feeding it a BOX3D works relying on
BOX3D::GEOMETRY cast.
--strk;

On Wed, Apr 20, 2005 at 02:36:52PM +0200, Achim Weßling wrote:

> Sorry ;-)
>
> but after changing my SELECT as follows:
>
> SELECT objnr, objart, bemerkung, asText(the_geom) AS the_geom
>     FROM f001_e_fla
>     WHERE the_geom && GeomFromText(setsrid('BOX3D(3446100 5773647,
> 3446321 5773823)'::box3d, 31467));
>
> I get:  Error: ERROR: Invalid OGC WKT (does not start with P,L,M or G)
>
> Again this works on 0.8.1, but doesn't on 1.0.0RC6!
>
> Achim
>
> Am Mi, den 20.04.2005 schrieb [hidden email] um 13:19:
> > On Wed, Apr 20, 2005 at 02:09:46PM +0200, Achim Weßling wrote:
> > > So,
> > >
> > > can someone tell me how the right syntax looks like?
> >
> > SetSRID('BOX3D(...)'::box3d, SRID)
> > --strk;
> >
> > >
> > > Achim
> > >
> > > Am Mi, den 20.04.2005 schrieb [hidden email] um 12:23:
> > > > On Wed, Apr 20, 2005 at 12:20:09PM +0200, Markus Schaber wrote:
> > > > > Hi, Strk,
> > > > >
> > > > > [hidden email] schrieb:
> > > > >
> > > > > > I've fixed this in current CVS.
> > > > > > Unfortunately it didn't get into 1.0.0.
> > > > >
> > > > > That was fast. Did you "backport" it into the 1.0.0 branch so it gets
> > > > > into 1.0.1 should that get necessary for other reasons?
> > > >
> > > > Forgot it. Now done.
> > > > --strk;
> > > >
> > > > >
> > > > > Markus
> > > > > _______________________________________________
> > > > > postgis-users mailing list
> > > > > [hidden email]
> > > > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > > _______________________________________________
> > > > postgis-users mailing list
> > > > [hidden email]
> > > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > >
> > > _______________________________________________
> > > postgis-users mailing list
> > > [hidden email]
> > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > _______________________________________________
> > postgis-users mailing list
> > [hidden email]
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> [hidden email]
> http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply | Threaded
Open this post in threaded view
|

Re: function geomfromtext(box3d, integer) does not exist

"Weßling, Achim"
Sorry for my late breaking understanding!!!

Now it works fine!

So I give you another hint for the docu ;-). You reference to the
SimpleFeature Specification for SQL with the following URL which does
not work:

http://www.opengis.org/techno/specs/99-049.pdf

The right URL is: http://www.opengis.org/docs/99-049.pdf. But I think
you better say that the specification can be found at
http://www.opengis.org.

Thanks

Achim

Am Mi, den 20.04.2005 schrieb [hidden email] um 13:53:

> SetSRID replaces GeomFromText.
> GeomFromText, as name suggests accepts TEXT, not BOX3D, not GEOMETRY.
> SetSRID accepts GEOMETRY, and feeding it a BOX3D works relying on
> BOX3D::GEOMETRY cast.
> --strk;
>
> On Wed, Apr 20, 2005 at 02:36:52PM +0200, Achim Weßling wrote:
> > Sorry ;-)
> >
> > but after changing my SELECT as follows:
> >
> > SELECT objnr, objart, bemerkung, asText(the_geom) AS the_geom
> >     FROM f001_e_fla
> >     WHERE the_geom && GeomFromText(setsrid('BOX3D(3446100 5773647,
> > 3446321 5773823)'::box3d, 31467));
> >
> > I get:  Error: ERROR: Invalid OGC WKT (does not start with P,L,M or G)
> >
> > Again this works on 0.8.1, but doesn't on 1.0.0RC6!
> >
> > Achim
> >
> > Am Mi, den 20.04.2005 schrieb [hidden email] um 13:19:
> > > On Wed, Apr 20, 2005 at 02:09:46PM +0200, Achim Weßling wrote:
> > > > So,
> > > >
> > > > can someone tell me how the right syntax looks like?
> > >
> > > SetSRID('BOX3D(...)'::box3d, SRID)
> > > --strk;
> > >
> > > >
> > > > Achim
> > > >
> > > > Am Mi, den 20.04.2005 schrieb [hidden email] um 12:23:
> > > > > On Wed, Apr 20, 2005 at 12:20:09PM +0200, Markus Schaber wrote:
> > > > > > Hi, Strk,
> > > > > >
> > > > > > [hidden email] schrieb:
> > > > > >
> > > > > > > I've fixed this in current CVS.
> > > > > > > Unfortunately it didn't get into 1.0.0.
> > > > > >
> > > > > > That was fast. Did you "backport" it into the 1.0.0 branch so it gets
> > > > > > into 1.0.1 should that get necessary for other reasons?
> > > > >
> > > > > Forgot it. Now done.
> > > > > --strk;
> > > > >
> > > > > >
> > > > > > Markus
> > > > > > _______________________________________________
> > > > > > postgis-users mailing list
> > > > > > [hidden email]
> > > > > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > > > _______________________________________________
> > > > > postgis-users mailing list
> > > > > [hidden email]
> > > > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > >
> > > > _______________________________________________
> > > > postgis-users mailing list
> > > > [hidden email]
> > > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > _______________________________________________
> > > postgis-users mailing list
> > > [hidden email]
> > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> > _______________________________________________
> > postgis-users mailing list
> > [hidden email]
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> [hidden email]
> http://postgis.refractions.net/mailman/listinfo/postgis-users


Reply | Threaded
Open this post in threaded view
|

Re: function geomfromtext(box3d, integer) does not exist

strk-2
Fixed. Thanks!
--strk;

On Wed, Apr 20, 2005 at 03:09:58PM +0200, Achim Weßling wrote:

> Sorry for my late breaking understanding!!!
>
> Now it works fine!
>
> So I give you another hint for the docu ;-). You reference to the
> SimpleFeature Specification for SQL with the following URL which does
> not work:
>
> http://www.opengis.org/techno/specs/99-049.pdf
>
> The right URL is: http://www.opengis.org/docs/99-049.pdf. But I think
> you better say that the specification can be found at
> http://www.opengis.org.
>
> Thanks
>
> Achim
>
> Am Mi, den 20.04.2005 schrieb [hidden email] um 13:53:
> > SetSRID replaces GeomFromText.
> > GeomFromText, as name suggests accepts TEXT, not BOX3D, not GEOMETRY.
> > SetSRID accepts GEOMETRY, and feeding it a BOX3D works relying on
> > BOX3D::GEOMETRY cast.
> > --strk;
> >
> > On Wed, Apr 20, 2005 at 02:36:52PM +0200, Achim Weßling wrote:
> > > Sorry ;-)
> > >
> > > but after changing my SELECT as follows:
> > >
> > > SELECT objnr, objart, bemerkung, asText(the_geom) AS the_geom
> > >     FROM f001_e_fla
> > >     WHERE the_geom && GeomFromText(setsrid('BOX3D(3446100 5773647,
> > > 3446321 5773823)'::box3d, 31467));
> > >
> > > I get:  Error: ERROR: Invalid OGC WKT (does not start with P,L,M or G)
> > >
> > > Again this works on 0.8.1, but doesn't on 1.0.0RC6!
> > >
> > > Achim
> > >
> > > Am Mi, den 20.04.2005 schrieb [hidden email] um 13:19:
> > > > On Wed, Apr 20, 2005 at 02:09:46PM +0200, Achim Weßling wrote:
> > > > > So,
> > > > >
> > > > > can someone tell me how the right syntax looks like?
> > > >
> > > > SetSRID('BOX3D(...)'::box3d, SRID)
> > > > --strk;
> > > >
> > > > >
> > > > > Achim
> > > > >
> > > > > Am Mi, den 20.04.2005 schrieb [hidden email] um 12:23:
> > > > > > On Wed, Apr 20, 2005 at 12:20:09PM +0200, Markus Schaber wrote:
> > > > > > > Hi, Strk,
> > > > > > >
> > > > > > > [hidden email] schrieb:
> > > > > > >
> > > > > > > > I've fixed this in current CVS.
> > > > > > > > Unfortunately it didn't get into 1.0.0.
> > > > > > >
> > > > > > > That was fast. Did you "backport" it into the 1.0.0 branch so it gets
> > > > > > > into 1.0.1 should that get necessary for other reasons?
> > > > > >
> > > > > > Forgot it. Now done.
> > > > > > --strk;
> > > > > >
> > > > > > >
> > > > > > > Markus
> > > > > > > _______________________________________________
> > > > > > > postgis-users mailing list
> > > > > > > [hidden email]
> > > > > > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > > > > _______________________________________________
> > > > > > postgis-users mailing list
> > > > > > [hidden email]
> > > > > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > > >
> > > > > _______________________________________________
> > > > > postgis-users mailing list
> > > > > [hidden email]
> > > > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > > > _______________________________________________
> > > > postgis-users mailing list
> > > > [hidden email]
> > > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > >
> > > _______________________________________________
> > > postgis-users mailing list
> > > [hidden email]
> > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > _______________________________________________
> > postgis-users mailing list
> > [hidden email]
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> [hidden email]
> http://postgis.refractions.net/mailman/listinfo/postgis-users