One other note -- the SQL/MM standard calls for an st_geometry_columns view
which is a true view that reads the system catalogs and should only read the
system catalogs I think.
geometry_columns is a left over from OGC standard. So my other point is if
we are going to do things the new way, why
Slight correction in thinking about this more, I suppose if people built
their views something like:
SELECT ST_Transform(geom,4326)::geometry(POINT,4326) As geom
FROM ...
I guess even complex geometry views can be represented correctly in the
system catalogs.
I still would want to go with th
On Fri, May 20, 2011 at 03:15:26AM -0400, Paragon Corporation wrote:
> One other note -- the SQL/MM standard calls for an st_geometry_columns view
> which is a true view that reads the system catalogs and should only read the
> system catalogs I think.
>
> geometry_columns is a left over from OGC
All,
* Sandro Santilli (s...@keybit.net) wrote:
> On Fri, May 20, 2011 at 03:15:26AM -0400, Paragon Corporation wrote:
> > So that is why I was proposing a hybrid -- geometry_columns -- so new
> > PostGIS can work with older tools
Having a hybrid may work for backwards-compatibility reasons, but
In my mind, the *only* reason I'm spending the time to implement
typmod is to turn geometry_columns into a view. If I'm not getting
that, it's not worth spending the time. The whole point, for me, is
that I can CREATE TABLE and boom my data shows up. There should not be
any required manual steps in
On 05/19/2011 10:36 PM, Clay, Bruce wrote:
This is probably a question for the QGis folks but I wanted to check
here first where ther is likely a larger audience.
I create several spatial tables using PostGis and all are visible in
QGis on their own.
When I create a view in PostGis that reache
I have a simple question. I've loaded up shape files from the tigerline US
census bureau. Everything works fine, but I'm trying to find the area of a
geometry in meters. However, I'm only able to get the area in SRID units.
How can I convert from SRID units to meters? Is this a linear conver
ST_geometry_columns - for those who wish for purity -- anyone :)
Paul,
Are you suggesting I'm a lunatic? I'm going to check the mirror now to see
if I'm growing fangs :).
I agree with you though -- that is the main beauty of typmod which is why
strk's solution won't work.
I would almost go wit
Hi Peter,
Here is a link to OSGeo workshop that should be a helpful premier on the
issue in general and provides a solution to your problem through the use
of PostGIS's geography type:
http://workshops.opengeo.org/postgis-intro/geography.html
If you are dealing with a fairly well define area
Dan,
Thanks, that was a really good intro to get my head wrapped around some of the
concepts, as this is all new to me.
Instead of reprojecting my data, I found that I could use the ST_Transform and
::geography cast to have ST_Area return the geography area instead, a la
(snippet follows). Th
10 matches
Mail list logo