Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id CDE86B5DD39 for ; Tue, 4 Oct 2011 15:22:51 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 79261-04-2 for ; Tue, 4 Oct 2011 18:22:45 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from nm19-vm1.bullet.mail.sp2.yahoo.com (nm19-vm1.bullet.mail.sp2.yahoo.com [98.139.91.217]) by mail.postgresql.org (Postfix) with SMTP id 790C1B5DCE2 for ; Tue, 4 Oct 2011 15:22:20 -0300 (ADT) Received: from [98.139.91.61] by nm19.bullet.mail.sp2.yahoo.com with NNFMP; 04 Oct 2011 18:22:19 -0000 Received: from [98.139.91.27] by tm1.bullet.mail.sp2.yahoo.com with NNFMP; 04 Oct 2011 18:22:19 -0000 Received: from [127.0.0.1] by omp1027.mail.sp2.yahoo.com with NNFMP; 04 Oct 2011 18:22:19 -0000 X-Yahoo-Newman-Property: ymail-5 X-Yahoo-Newman-Id: 606725.94110.bm@omp1027.mail.sp2.yahoo.com Received: (qmail 53875 invoked by uid 60001); 4 Oct 2011 18:22:19 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1317752539; bh=18+B3TCI9dtPCYHuugZZD45ldCHj+KeAwV6soKt1Gf8=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:Cc:MIME-Version:Content-Type; b=OeYuYikhtMDNgGno9nQ7g1f29tOu1co4Jn4lfMqFGAfjRC/PvnPztoKCnQN10679w9Cr9+mCm5FwkA24bHWJRo6UhqJ7K6HgFD5fkMmiqHuNGnekxveoZ6+lwx4G2+GnRAz+keG0f0jaz5npG268C7r5WEa0+CEyD8lZ/7ncFSg= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:Cc:MIME-Version:Content-Type; b=wKUeM59mJtSla/cg/AHBh1vIkY/T2L86lShVjGzwhG6yxqWSPBfq2FTS8wbKbh5li8uNmFXDIoj6mb7XDxGfj2BeY02QXIBZYeMmU+x16kNW2/abhGjQyLasLKp6vnmeezTPFKebZashyRoZQGmJo4V5K0SEArQeiRG0j3FU/SQ=; X-YMail-OSG: yI.RrFQVM1mq3m837s.HIOGf3oW3DILjfyfuy3VFCn5HO2c DEjOQI9KC4JN7yZ56fEISnjzw9nFJBdCj3r4UH8OcEvdt1uhUjN6W73S2us8 WLEGh_7QbCpqpB_ZXFzsWlPS24P8rl8nGlfv.HuaC0sETIz2PYd5kL6kAVG9 eGuiOlRjul5vZ2NWy.FTLmRJr.grq6ZbplA3hrCMVR19sp8nniX72HhfDhqe ejBPs5Zq7_hPQ80_AX_Erk8qVMNlJiU_3xKDy7hXkdHU744cnwODrZ5IVMh8 6qrsj2cyeHYcXz_GA7pnl5gSRbxNHQmW68_h_hK.FOjvhNqrEylWKncJgxth b68Ea1.lCffM8ZH8ZZlcjwPhIdxzNADuEJF4r8n8M_JH4VvMpKVfqT40GYcH 6rpuZalMj114s2C56XiIQg_e7vg-- Received: from [213.74.30.152] by web45104.mail.sp1.yahoo.com via HTTP; Tue, 04 Oct 2011 11:22:19 PDT X-Mailer: YahooMailWebService/0.8.114.317681 Message-ID: <1317752539.52809.YahooMailNeo@web45104.mail.sp1.yahoo.com> Date: Tue, 4 Oct 2011 11:22:19 -0700 (PDT) From: Asli Akarsakarya Reply-To: Asli Akarsakarya Subject: Re: a spatial table's bounding box To: =?utf-8?B?RmlsaXAgUmVtYmlhxYJrb3dza2k=?= Cc: "\"pgsql-sql@postgresql.org\"" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1959915115-559003312-1317752539=:52809" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.402 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RP_MATCHES_RCVD=-0.504 X-Spam-Level: X-Archive-Number: 201110/2 X-Sequence-Number: 35886 --1959915115-559003312-1317752539=:52809 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Thank you very much.=0A=0A>I would try >SELECT st_envelope( st_collect(geom= ) ) FROM roads; >HTH, Filip>> I want to get the extensions of spatial tabl= e. Say that there is a spatial table named 'roads', and a some road geometr= y inside. I want to fetch the bounding box (envelope or extension) for that= table, that means for all the roads that it has.>>=0A>> According the OGC = specification, this should be defined in the "geometry_columns" table. As f= our columns, "minX", "minY", "maxX" and "maxY". But I couldn't find it anyw= here on my postgis. Yet.=0A>>=0A>> From which table/view? With what SQL? = =0A --1959915115-559003312-1317752539=:52809 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable 
Thank you very much.

>I would try=0A=0A>S=
ELECT st_envelope( st_collect(geom) ) FROM roads;=0A=0A>HTH, Filip
= >> I want to get the extensions of= spatial table. Say that there is a spatial table named 'roads', and a som= e road geometry inside. I want to fetch the bounding box (envelope or exten= sion) for that table, that means for all the roads that it has.
>>=0A>> According the OGC specification, t=
his should be defined in the "geometry_columns" table. As four columns, "mi=
nX", "minY", "maxX" and "maxY". But I couldn't find it anywhere on my postg=
is. Yet.=0A>>=0A>> From which table/view? With what SQL?=0A
=
--1959915115-559003312-1317752539=:52809--