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 <[email protected]> > 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 <[email protected]> > > *To:* PostGIS Users Discussion <[email protected]> > *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 <[email protected]> > > 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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
