[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: [udig-devel] where conditions while displaying postgis table
|
I am afraid the filter standard we use for interacting with shapefiles, postgis and web feature servers is focused just on a single where statement and does not offer joins.
So I will have to ask you to create a view in your database for this purpose.
There are two developments occurring in GeoTools that should help:
- app schema work allowing you to define a feature type and provide a mapping to the various tables that form its content
- andrea is looking at allowing sql based queries which would hopefully be similar to defining your own view
I have also personally created a work around (a function that does a "lookup" in another table file; I ended up loading the other file into memory to make this happen and cannot really recommend it).
Jody
On 22/06/2010, at 2:19 AM, konfri@xxxxxx wrote:
> Hey,
>
> I'm having a postgis table with several columns storing the position and some meta information like the time. Now, I would like to use the meta information (can be distributed over several tables) and visualizing only certain rows.
>
> At present, I'm using the catalog to display the entire postgis table. Is there a way of adding additional where-conditions?
>
> Thanks,
>
> Kon
>
> --
> GMX DSL: Internet-, Telefon- und Handy-Flat ab 19,99 EUR/mtl.
> Bis zu 150 EUR Startguthaben inklusive! http://portal.gmx.net/de/go/dsl
> _______________________________________________
> User-friendly Desktop Internet GIS (uDig)
> http://udig.refractions.net
> http://lists.refractions.net/mailman/listinfo/udig-devel
