[postgis-users] PostGIS Conceptual and Phisical Modelling

[Carlos Andrade]

Perfect!! Exactly what I needed. Now Im not constrained to the sql
available on any of the GIS tools.

I believe Quantum will notice it when I connect to my database and request
to load the data inside my geo database?

I'll give it a shot!

Thank you very much! Hopefully I'll figure it out before the pres today :D

Carlos Andrade
http://carlosandrade.co



2011/11/3 Phil James <borntopedal at yahoo.co.uk>

> A simple way to see data in Quantum whilst running queries in Postgis is
> to write and test the query in Postgis then wrap it in a view. eg.
>
> SELECT DISTINCT a.* FROM table1 a, table2 b WHERE
> ST_INTERSECTS(a.the_geom, b.the_geom)
>
> can be written as
>
> CREATE VIEW myview AS (SELECT DISTINCT a.* FROM table1 a, table2 b WHERE
> ST_INTERSECTS(a.the_geom, b.the_geom))
>
> Provided there is a a field in the view that can be used as a key (the GID
> is a good one) then Quantum will display it.
>
> If  there is not a unique key (eg. if you use intersects and get multiple
> gids then you can use CREATE TABLE and then add a Primary Key and populate
> geometry columns eg:
>
> CREATE TABLE  mytable AS (SELECT a.* FROM table1 a, table2 b WHERE
> ST_INTERSECTS(a.the_geom, b.the_geom))
> ALTER TABLE mytable
> ADD COLUMN id SERIAL PRIMARY KEY;
>  SELECT POPULATE_GEOMETRY_COLUMNS('public.mytable'::regclass);
>
> Then it will be visible from Quantum.
>
> Hope this helps
>
> Phil
>
> ------------------------------
> *From:* Carlos Andrade <carlosviansi at gmail.com>
>
> *To:* PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> *Sent:* Thursday, 3 November 2011, 8:03
>
> *Subject:* Re: [postgis-users] PostGIS Conceptual and Phisical Modelling
>
> Hi,
>
> Thank you everyone for all your suggestions! I'm gonna check on them! =)
>
> Paolo, I'm happy someone will find use of it, where should I put it?
>
>
> Carlos Andrade
> http://carlosandrade.co
>
>
>
> 2011/11/3 Paolo Cavallini <cavallini at faunalia.it>
>
> Il 02/11/2011 18:55, Carlos Andrade ha scritto:
>
> > I've created a small tutorial on how I got things wokrking around to set
> up on a snow
> > leopard it, is this of any interest to this comunity? It may have
> information that it
> > not 100% accurate, but it was what made it work on my mac. If yes,
> please let me know
> > where could I put it (maybe the wiki, or where would it be).
>
> Yes, please.
> All the best.
> --
> Paolo Cavallini - Faunalia
> www.faunalia.eu
> Full contact details at www.faunalia.eu/pc
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111103/00a51759/attachment.html>