pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feeda spatial table's bounding box
3+ messages / 2 participants
[nested] [flat]
* a spatial table's bounding box
@ 2011-09-22 06:04 Asli Akarsakarya <asliakar@yahoo.com>
2011-09-23 19:18 ` Re: a spatial table's bounding box Filip Rembiałkowski <plk.zuber@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Asli Akarsakarya @ 2011-09-22 06:04 UTC (permalink / raw)
To: pgsql-sql
Hello, My question is a basic one for postGIS, I believe. It should have a primitive answer somewhere, but I don't have it. I want to get the extensions of spatial table. Say that there is a spatial table named '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 that it has. 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 table/view? With what SQL? Thanks for your answers, Aslı.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: a spatial table's bounding box
2011-09-22 06:04 a spatial table's bounding box Asli Akarsakarya <asliakar@yahoo.com>
@ 2011-09-23 19:18 ` Filip Rembiałkowski <plk.zuber@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Filip Rembiałkowski @ 2011-09-23 19:18 UTC (permalink / raw)
To: Asli Akarsakarya <asliakar@yahoo.com>; +Cc: pgsql-sql
2011/9/22 Asli Akarsakarya <asliakar@yahoo.com>
>
> I want to get the extensions of spatial table. Say that there is a spatial table named '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 that it has.
>
> 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 table/view? With what SQL?
>
>
>
I would try
SELECT st_envelope( st_collect(geom) ) FROM roads;
HTH, Filip
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: a spatial table's bounding box
@ 2011-10-04 18:22 Asli Akarsakarya <asliakar@yahoo.com>
0 siblings, 0 replies; 3+ messages in thread
From: Asli Akarsakarya @ 2011-10-04 18:22 UTC (permalink / raw)
To: Filip Rembiałkowski <plk.zuber@gmail.com>; +Cc: pgsql-sql
Thank you very much.
>I would try >SELECT st_envelope( st_collect(geom) ) FROM roads; >HTH, Filip>> I want to get the extensions of spatial table. Say that there is a spatial table named '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 that it has.>>
>> 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 table/view? With what SQL?
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-10-04 18:22 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-09-22 06:04 a spatial table's bounding box Asli Akarsakarya <asliakar@yahoo.com>
2011-09-23 19:18 ` Filip Rembiałkowski <plk.zuber@gmail.com>
2011-10-04 18:22 Re: a spatial table's bounding box Asli Akarsakarya <asliakar@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox