[Paraview] Contour from Table - how?

[Steven Janzou]

Berk,

I am trying to construct a 24 (hour) by 365 (days) plot of energy
values generated from a simulation and stored in SQLite.

The query that constructs a data table with the the three columns for
plotting is:

select  [hour],(([Month]-1)*31+ [day]) as y, variablevalue
from reportmeterdata rmd join timeindices ti on
rmd.timeindex=ti.timeindex
where recordindex=157
group by [month],[day],[hour]

This is used in the SQLDatabaseTableSource plugin and construct a
table with the [hour], y and variableValue columns from the database -
the plugin adds the idType fourth column.

Then I use a TableToPoints filter to construct a Polygonal Mesh with 1
cell with the correct X range (=[hour]), Y range (=y in query above)
and variableValues from the query.

I then try to construct a contour using the variableValue but that is
not an option in the "Contour By" property of the Contour filter.

I will try the Delaunay filter but need a way to script these data
views and to compare the results over multiple SQLite files - can
Paraview accomplish this?

Thanks,
Steve

On Sun, Mar 15, 2009 at 5:49 PM, Berk Geveci <berk.geveci at kitware.com> wrote:
> What kind of dataset is this and which variable are you contouring by?
> Before you can contour a dataset, you have to create cells (triangles,
> quads, tetrahedras etc.) so that VTK has a way of interpolating values
> over the area/volume. You can do this by using one of the Delaunay
> filters but the solutions may be more straightforward and efficient if
> the dataset is actually in some way structured.
>
> -berk
>
> On Sun, Mar 15, 2009 at 8:25 AM, Steven Janzou <sjanzou at gmail.com> wrote:
>> I have used the latest CVS version with Overview build and used the
>> SQLDatabaseSource plugin to generate a table with four columns - 3
>> data (x int, y int, z float) and one idtype
>>
>> I would like to construct a contour plot using the resulting table data.
>>
>> I have ran the Table data through the TableToPoints filter and
>> generated a Polygonal Mesh with 1 cell and then applied the Contour
>> filter to the TableToPoints results but have no selection available in
>> the "Contour By" drop down.
>>
>> What do I need to do to construct a contour from the Table?
>>
>> Also, can I use lookmarks to compare several different sqlite source
>> files with the contour plot?
>>
>> Thanks,
>> Steve
>> _______________________________________________
>> Powered by www.kitware.com
>>
>> Visit other Kitware open-source projects at http://www.kitware.com/opensource/opensource.html
>>
>> Please keep messages on-topic and check the ParaView Wiki at: http://paraview.org/Wiki/ParaView
>>
>> Follow this link to subscribe/unsubscribe:
>> http://www.paraview.org/mailman/listinfo/paraview
>>
>