[Qgis-developer] Re: DB Manager integration

[Maurício de Paulo]

Ok, right now I think I finished the improvements on the loader. It can now
create overviews, external tables and customized block size.

So I started testing the wktraster loaded with the rt_sql_layer plugin. As
intersection (raster,vector) returns vectors, it's already possible. The
code bellow is an example of how to get a profile from a raster and load in
qgis.

*SELECT foo.rid, foo.gid,
   (foo.geomval).geom As geom, (foo.geomval).val
FROM
    (
SELECT A.rid, g.gid , ST_Intersection(A.rast, g.the_geom) As geomval,
nextval('teste') as mid
 FROM topo2 AS A, "testeL" As g
) As foo
where
(ST_IsEmpty((foo.geomval).geom)=False);*

The result was succesfull, but it's not what I expected. Am I right to think
that it should only give me values on the vertexes? The result was a huge
amount of linestrings, each representing one pixel, I think. It's almost
impossible to view in QGIS.

Well, at least it's working. I think we can split the functions on postgis
raster in two type: geometry and raster returning functions. So there might
be some SQLs that are going to show raster and some that are going to show
vector. I'm still confused as how am I going to make it easier for the users
as this behavior is extremely different from the postgis geometry behavior.

Best regards,
Mauricio de Paulo


2011/7/14 Maurício de Paulo <mauricio.dev at gmail.com>

> Gentlemen,
> I'm back to work on the wktraster plugin as part of a class work for one
> the courses i'm attending. I've read about the DBManager integration and
> seen the RT SQL spatialite integration.
> Now I'd like to help integrate wktraster.
>
> I've improved the loader, now it's able to create overviews and read the
> metadata from the file.
>
> I'd like to implement the RT_SQL_Layer integration now as my work is aimed
> at getting the results of a SQL on the screen.
> Could you please guide what's the best path to contribute? Martin once told
> me about the postgis manager git repository (which now I think I can read),
> but I don't know if anything changed since the merge with spatialite.
>
> Best regards,
>
> --
> Mauricio de Paulo
> Engenheiro Cartografo
> MapeandoOBrasil <http://mapeandoobrasil.blogspot.com>
>
>


-- 
Mauricio de Paulo
Engenheiro Cartografo
MapeandoOBrasil <http://mapeandoobrasil.blogspot.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/qgis-developer/attachments/20110714/93048169/attachment-0001.html