[postgis-users] PostGIS Conceptual and Phisical Modelling

[Carlos Andrade]

Works great, I can see the views as long as I have a geometry on it, I just
need to work my current sql to keep moving the shape foward along with the
selected route now.

Thank you very much!! :-)

Carlos Andrade
http://carlosandrade.co



2011/11/3 Carlos Andrade <carlosviansi at gmail.com>

> 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/ad90762c/attachment.html>