Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id E39B0B5DC5D for ; Thu, 22 Sep 2011 03:04:59 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 68038-02 for ; Thu, 22 Sep 2011 06:04:53 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from nm28.bullet.mail.sp2.yahoo.com (nm28.bullet.mail.sp2.yahoo.com [98.139.91.98]) by mail.postgresql.org (Postfix) with SMTP id 9655CB5DC13 for ; Thu, 22 Sep 2011 03:04:51 -0300 (ADT) Received: from [98.139.91.66] by nm28.bullet.mail.sp2.yahoo.com with NNFMP; 22 Sep 2011 06:04:51 -0000 Received: from [98.139.91.41] by tm6.bullet.mail.sp2.yahoo.com with NNFMP; 22 Sep 2011 06:04:51 -0000 Received: from [127.0.0.1] by omp1041.mail.sp2.yahoo.com with NNFMP; 22 Sep 2011 06:04:51 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 170695.68714.bm@omp1041.mail.sp2.yahoo.com Received: (qmail 46460 invoked by uid 60001); 22 Sep 2011 06:04:51 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1316671491; bh=mKxfohgqu4waPsxd2EUbdzvftRAxkF0KMKC7UFW4Zuw=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=TPuJvLwMdZqhmg/0or1LSrvWw0T6yAvPABRSNihruOG1ukuGMrI6OCwCoqKEo0sTWlvFirI5x6RyqiT+w8BhPFFUeuWgMMogEMGuJyTO0gfk9rv/lesPcmKeV3lSiGu+sxFVdLg6Ztmrg0MHaG7nPDPAWvBTcqftzqYftUOeXY0= 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:MIME-Version:Content-Type; b=3uBZoK6vk0x0TiFGbCVi6ozvJ+AAwQJZu6TSazICdCdsBV339ThZbkOPHXCxhc8QDho6OZskGGXba/xEU6X39wbiadYKdMeZg1zAEUjjQVbG+mfrD+z/n5wg24SK0OFqUaWBrQGQVkyG+m41CVA3dV4UmVP642cVxNYDKEGi6Fo=; X-YMail-OSG: Yqnhex8VM1kHvjxOAX1AC57Rl3oK14jWyH3sK5_MKff8_Wz penTkDspM7AhV6WMufsHeWE2YA9ODk3gmSyN5pzLKhcxP5ZAamw2s_7FZ.Ey GHgwrnWr4NfgCDljA9voQ13Xhd.pN7HALusOT.nUz3TvYVJgSN9D0B1VzO_0 LoqkjiF7W66T2J.7g3YXNq5NC4fu9duOTRqFDE.83FyJKkLbIk.wM6O2YRma NZns5igEl6LIYKffIBKmW_QFgpiob50hLQILyfJkfMd.mHQcU.P13qBFAayv cDvB.1ZnmcUyaxPnL7.h_u6chOtcFFCbIbxe0_b9U3zjmk8Wen_oDmqzS.ZN 3mPyiBT_6d4VVllPwIzKJCA1f5VWbbvH.K64f1yhBZuCcsnW7A_X8retuyOW SCw2k.vFy0mj4flP_7k39IxJqwg-- Received: from [213.74.30.152] by web45109.mail.sp1.yahoo.com via HTTP; Wed, 21 Sep 2011 23:04:50 PDT X-Mailer: YahooMailWebService/0.8.114.317681 Message-ID: <1316671490.39010.YahooMailNeo@web45109.mail.sp1.yahoo.com> Date: Wed, 21 Sep 2011 23:04:50 -0700 (PDT) From: Asli Akarsakarya Reply-To: Asli Akarsakarya Subject: a spatial table's bounding box To: "pgsql-sql@postgresql.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-37561979-2127801088-1316671490=:39010" 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: 201109/70 X-Sequence-Number: 35870 ---37561979-2127801088-1316671490=:39010 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hello,=C2=A0 My question is a basic one for postGIS, I believe. It should h= ave a primitive answer somewhere, but I don't have it.=C2=A0 I want to get = the extensions of =C2=A0spatial table. Say that there is a spatial table na= med 'roads', and a some road geometry inside. I want to fetch the bounding = box (envelope or extension) for that table, that means for all the roads th= at it has.=C2=A0 According the OGC specification, this should be defined in= the "geometry_columns" table. As four columns, "minX", "minY", "maxX" and = "maxY". But I couldn't find it anywhere on my postgis. Yet. From which tabl= e/view? With what SQL? Thanks for your answers, Asl=C4=B1. ---37561979-2127801088-1316671490=:39010 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable 
Hello, =0A=0AMy question is a basic one for postGIS, I believe. It sh=
ould have a primitive answer somewhere, but I don't have it. =0A=0AI w=
ant to get the extensions of  spatial table. Say that there is a spati=
al table named 'roads', and a some road geometry inside. I want to fetch th=
e bounding box (envelope or extension) for that table, that means for all t=
he roads that it has. =0A=0AAccording the OGC specification, this shou=
ld be defined in the "geometry_columns" table. As four columns, "minX", "mi=
nY", "maxX" and "maxY". But I couldn't find it anywhere on my postgis. Yet.=
=0A=0AFrom which table/view? With what SQL?=0A=0AThanks for your answers,=
=0A=0AAsl=C4=B1.
---37561979-2127801088-1316671490=:39010--