Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [udig-devel] Can uDig plot PostGIS data from an SQL view?

Gary Lucas wrote:

I am trying to use uDig 1.1.RC4 to view a subset of records from a Postgres table. The table contains 50 or 60 thousand records, I'm try to view a few hundred. I am interested in doing this on a read-only basis, using uDig as a data-inspection tool, so editing doesn't come into play. I didn't see any way to accomplish this through the style specifications (putting aside overhead issues, the query I use to develop the subset depends on the SQL LIKE operation).  Anyway, I had the idea of creating an
SQL View and reading the data from the view rather than from the actual table.

The uDIG GUI recognizes the SQL view and allows me to add it to a map.
Unfortunately, uDig does not appear to pull back any data.  Nothing plots and
I get a zero feature count.

Did I miss a procedure?  Do I have to do something extra in PostGIS to
enable it to identify the geometry attribute in the SQL view?
Hi Gary,

I'll have a look at this right now and get back to the list today or tomorrow detailing what the problem is and if a quick fix can be applied.

Cheers,
Cory.


Back to the top