Ok, right now I think I finished the improvements on the loader. It can now create overviews, external tables and customized block size.<br><br>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. <br>
<br><i>SELECT foo.rid, foo.gid, <br> (foo.geomval).geom As geom, (foo.geomval).val<br>FROM<br> (<br>SELECT A.rid, g.gid , ST_Intersection(A.rast, g.the_geom) As geomval, nextval('teste') as mid<br> FROM topo2 AS A, "testeL" As g <br>
) As foo<br>where<br>(ST_IsEmpty((foo.geomval).geom)=False);</i><br><br>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.<br>
<br>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.<br>
<br>Best regards,<br>Mauricio de Paulo<br><br><br><div class="gmail_quote">2011/7/14 Maurício de Paulo <span dir="ltr"><<a href="mailto:mauricio.dev@gmail.com">mauricio.dev@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Gentlemen,<br>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.<br>Now I'd like to help integrate wktraster.<br>
<br>I've improved the loader, now it's able to create overviews and read the metadata from the file. <br><br>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. <br>
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.<br>
<br>Best regards,<br clear="all"><font color="#888888"><br>-- <br>Mauricio de Paulo<br>Engenheiro Cartografo<br><a href="http://mapeandoobrasil.blogspot.com" target="_blank">MapeandoOBrasil</a><br><br>
</font></blockquote></div><br><br clear="all"><br>-- <br>Mauricio de Paulo<br>Engenheiro Cartografo<br><a href="http://mapeandoobrasil.blogspot.com" target="_blank">MapeandoOBrasil</a><br><br>