Hi, I'm not sure I announced my txt-driver0.2.jar for OpenJUMP I know there are some other around there (from Pirol, from SS ?) I did not compare features (though it would be interesting to do so)
you'll find my plugin at http://geo.michaelm.free.fr/OpenJUMP/resources/drivers/ can read : [ID] X Y [Z] [attributes] [ID] WKT [attributes] with or without header and with usual separators (tab,comma...) can write X Y Z attributes WKT attributes The main effort has been to integrate it to Paul Austin's driver framework. Michaël Stefan Steiniger a écrit : > nice! > > thanks for putting in the effort > > cheers from C > stefan > > Michaël Michaud schrieb: > >> Hi, >> >> Finally, I followed Paolo's advice and added two parameters ala ant >> Those two parameters are >> ${view} >> ${fence} >> Instead of writing them, one can use a button I added on the right of >> the panel (a nice icon would be better...) >> It is not as user friendly as a checkbox, but I think it will be more >> flexible. >> >> For now on, it only works with postgis (ST_GeomFromText function is used >> in the substitution) >> Don't know how to adapt it for other database : is ST_GeomFromText >> recognized by other spatial db ? >> >> Here is an example for a fast query inside the view : >> select asbinary(the_geom) from mytable t >> where t.the_geom && ${fence} >> >> Michaël >> >> >> Paolo Rizzi a écrit : >> >>> I think the geom column name can be anything, but something ala >>> "Apache ant" parameter substitution could be a good idea, like: >>> >>> select * from (userquery) >>> where <whatever_the_geom_is> && {OJ.view.current.geom} >>> and intersects(<whatever_the_geom_is>,{OJ.view.current.geom}) >>> >>> OpenJump should substitute the string "{OJ.view.current.geom}" with the >>> current bbox.geometry of the view. >>> Other well-known parameters may be useful, like...??? Can't think of >>> anyone right now!!! >>> >>> Another improvement would be for Layers coming from a "Run datastore >>> query" to have the "Refresh" menu' command like "Add datastore" Layers have. >>> Also "Run Datastore" Layers should be saved inside OJ Task/Project, so >>> you don't have to manually reenter them each time. >>> >>> Bye >>> Paolo Rizzi >>> >>> >>> >>> >>>> Hi, >>>> >>>> I use "Run datastore query panel " a lot and your suggestion seems very >>>> useful to me. >>>> >>>> I'll try to dive into the code to see if I can add this feature, but it >>>> may be difficult to manage every case in a clean way (because the >>>> geometry column name is not fixed and because the query may be complex, >>>> with where conditions, joins, group by...). >>>> >>>> I think one approach could be to identify the geometry column >>>> (asbinary() or asewkb()), to create an alias >>>> ex. asbinary(geomcolumn) as GEOMETRY4OJ >>>> then to create a new query like >>>> select * from (userquery) where GEOMETRY4OJ && bbox.geometry and >>>> intersects(GEOMETRY4OJ,bbox.geometry) >>>> not sure if it works >>>> >>>> any idea ? >>>> >>>> Michaël >>>> >>>> Rahkonen Jukka a écrit : >>>> >>>> >>>>> Hi, >>>>> >>>>> While playing with SkyJUMP and pdf printing which does not work with Add >>>>> datastore layer I soon realised that I would like to see a "Use view >>>>> extents as BBOX filter" check box in the Run datastore query panel. >>>>> >>>>> -Jukka Rahkonen- >>>>> >>>>> ------------------------------------------------------------------------------ >>>>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 >>>>> 30-Day >>>>> trial. Simplify your report design, integration and deployment - and >>>>> focus on >>>>> what you do best, core application coding. Discover what's new with >>>>> Crystal Reports now. http://p.sf.net/sfu/bobj-july >>>>> _______________________________________________ >>>>> Jump-pilot-devel mailing list >>>>> [email protected] >>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>> >>>>> >>>>> >>>>> >>>>> >>>> ------------------------------------------------------------------------------ >>>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 >>>> 30-Day >>>> trial. Simplify your report design, integration and deployment - and focus >>>> on >>>> what you do best, core application coding. Discover what's new with >>>> Crystal Reports now. http://p.sf.net/sfu/bobj-july >>>> _______________________________________________ >>>> Jump-pilot-devel mailing list >>>> [email protected] >>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>> >>>> >>> ------------------------------------------------------------------------------ >>> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day >>> trial. Simplify your report design, integration and deployment - and focus >>> on >>> what you do best, core application coding. Discover what's new with >>> Crystal Reports now. http://p.sf.net/sfu/bobj-july >>> _______________________________________________ >>> Jump-pilot-devel mailing list >>> [email protected] >>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>> >>> >>> >>> >> ------------------------------------------------------------------------------ >> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day >> trial. Simplify your report design, integration and deployment - and focus >> on >> what you do best, core application coding. Discover what's new with >> Crystal Reports now. http://p.sf.net/sfu/bobj-july >> _______________________________________________ >> Jump-pilot-devel mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >> >> >> > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Jump-pilot-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > > ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Jump-pilot-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
