Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[udig-devel] [jira] Created: (UDIG-1134) QGIS-like dialog for PostGIS layer selection 
QGIS-like dialog for PostGIS layer selection
--------------------------------------------

                 Key: UDIG-1134
                 URL: http://jira.codehaus.org/browse/UDIG-1134
             Project: uDIG
          Issue Type: Improvement
          Components: postgis
    Affects Versions: UDIG 1.1.RC6a
         Environment: any
            Reporter: Martin Jansche
         Assigned To: Jody Garnett
            Priority: Minor


The PostGIS table selection dialog is a bit unusual to me, having worked with QGIS before.  First, I'd like to be able to select tables from multiple schemas at the same time. Second, I only want to see tables with one or more geometry columns (if a table has multiple geometry columns, it should be listed multiple times). Third, relying exclusively on the OpenGIS table GEOMETRY_COLUMNS will not suffice, because that table won't include views.  Here's a query I would suggest for retrieving the tables and views with geometry columns, based on, but not completely identical to, what QGIS does:

SELECT pg_namespace.nspname AS "Schema", pg_class.relname AS "Name", pg_attribute.attname AS "Geometry Column"
   FROM pg_attribute, pg_class, pg_type, pg_namespace
  WHERE pg_type.typname = 'geometry' AND pg_attribute.atttypid = pg_type.oid AND pg_attribute.attrelid = pg_class.oid AND pg_namespace.oid = pg_class.relnamespace AND (pg_class.relkind = 'r' OR pg_class.relkind = 'v');

The result of this query could be incorporated into the PostGIS table dialog more or less directly. I'm picturing a first dialog window asking for the host, port, database, role, and password. With that information, a connection can be opened and the above query can be issued. Then the next dialog window would display a list with three columns (schema, table/view name, geometry column) allowing the user to select any number of layers to include.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

Back to the top