Hi, > The Database Query plugin has taken another approach from the very beginning. > Earlier it used to create a small fake rectangle geometry around coordinates > (0,0) if query did not return a real geometry but nowadays it creates an > FEATURECOLLECTION EMPTY geometry. Very handy for us because we may have in > the database new parcels which have not been digitised yet. Now we can still > see the attributes. I remember this change. I think we improved how a null geometries was handled in a table having a geometry column. The Feature Request is about a query where the geometry column is completely missing. My proposal is to inform the user that the table will not be loaded because geometry column is missing (I thing in the case reported by the user, this one just forgot to include the geometry column, at least this is my guess). Another solution would be to add the geometry column with only empty geometry collections as you suggest. This would probably need more thoughts : how to handle pure atttribute tables in general. I think Kosmo has this feature and Peppe started some experiments with this idea. Another useful tool would be to propose the user to make a join between a OpenJUMP geometry table and a database pure attribute table (as we do with txt file, with an attribute key).
I think I'll start with the first solution which just avoid the user to receive an confusing message. 2 and 3 will need more discussion and development ressources, but they are interesting features for medium-term future. Michaël -Jukka Rahkonen- >> Lähettäjä: SourceForge.net [mailto:[email protected]] >> Lähetetty: 14. helmikuuta 2012 13:36 >> Vastaanottaja: SourceForge.net >> Aihe: [JPP-Devel] [ jump-pilot-Feature Requests-3487532 ] >> Exception with erroneous postgis sql query >> >> Feature Requests item #3487532, was opened at 2012-02-14 03:35 >> Message generated for change (Tracker Item Submitted) made by michaudm >> You can respond by visiting: >> https://sourceforge.net/tracker/?func=detail&atid=679909&aid=3 > 487532&group_id=118054 >> Please note that this message will contain a full copy of the >> comment thread, >> including the initial issue submission, for this request, >> not just the latest update. >> Category: Attribute/Database >> Group: None >> Status: Open >> Priority: 5 >> Private: No >> Submitted By: michael michaud (michaudm) >> Assigned to: michael michaud (michaudm) >> Summary: Exception with erroneous postgis sql query >> >> Initial Comment: >> Throw a better message if the geometry is missing from the >> user query schema >> See discussion in : >> https://sourceforge.net/projects/jump-pilot/forums/forum/72947 > 9/topic/5011215 >> Michaël >> >> ---------------------------------------------------------------------- >> >> You can respond by visiting: >> https://sourceforge.net/tracker/?func=detail&atid=679909&aid=3 > 487532&group_id=118054 >> -------------------------------------------------------------- >> ---------------- >> Keep Your Developer Skills Current with LearnDevNow! >> The most comprehensive online learning library for Microsoft >> developers >> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, >> CSS3, MVC3, >> Metro Style Apps, more. Free future releases when you subscribe now! >> http://p.sf.net/sfu/learndevnow-d2d >> _______________________________________________ >> Jump-pilot-devel mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >> > ------------------------------------------------------------------------------ > Keep Your Developer Skills Current with LearnDevNow! > The most comprehensive online learning library for Microsoft developers > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > Metro Style Apps, more. Free future releases when you subscribe now! > http://p.sf.net/sfu/learndevnow-d2d > _______________________________________________ > Jump-pilot-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ Jump-pilot-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
