Hi Marin, Jukka nad Michael, thanks for your mails. I will do some tests on the next week and post my results Thanks again.
Peppe --- Gio 11/2/10, Martin Davis <mbda...@refractions.net> ha scritto: > Da: Martin Davis <mbda...@refractions.net> > Oggetto: Re: [JPP-Devel] Find/Substitute geometries > A: "OpenJump develop and use" <jump-pilot-devel@lists.sourceforge.net> > Data: Giovedì 11 febbraio 2010, 23:59 > Yes, you should be able to use > SpatialLite as well for this task. You > would need to translate the block geometries to the > location of the > target points - but it looks like SpatialLite provides > enough functions > to do this. It would be interesting to see the SQL if > someone tries > this out. > > The idea behind JEQL is to provide the power of a SQL DB > engine (and > more!) without requiring one to be installed and > maintained. > > A note on SpatialLite - it uses GEOS, which is the C port > of the JTS > library used in OpenJUMP. So there shouldn't be any > problems with > incompatible Geometry models! > > Rahkonen Jukka wrote: > > Hi, > > > > This might be a use case for a spatial database. I > believe you can do this with the new OpenJUMP SpatiaLite > readers. The steps to follow are: > > > > - make sure that you have some unique ID in your > original layer with all the attributes > > - make another layer which contains only ID and the > alternative geometry > > - store both layers into shapefiles and import them > into SpatiaLite with, for example, Spatialite-GUI > > > > Now you will have a database with two layers. I will > call them as "data" and "symbol". > > > > Now let's assume that you would like to get three > attributes which belong to your data point with ID=10034, > but instead of its own geometry you would like to take it > from the symbol layer. It goes with this SQL > > > > SELECT d.attribute_1, d.attribute_2, d.attribute_3, > s.Geometry > > from data d, symbol s # "d" is a synonyme for > data layer, "s" for symbol layer, see the line above > > WHERE d.ID=s.ID # ID is > connecting the tables > > AND d.id=10034; > > > > You can do much more with relational tables. For > example, you do not need to make alternative geometries for > all features. You can have a symbol for a well in the > symbology table, and with SQL query take that for all the > rows in your data table having a value "well" as a category > attribute. I am sorry I am not good enough in making > SQL queries for giving any advanced examples. However, I > feel that OpenJUMP and Spatialite is a good combination for > learning. > > > > -Jukka- > > > > > > > > > > > > -----Alkuperäinen viesti----- > > Lähettäjä: Giuseppe Aruta [mailto:giuseppe_ar...@yahoo.it] > > Lähetetty: to 11.2.2010 12:54 > > Vastaanottaja: OpenJump develop and use > > Aihe: Re: [JPP-Devel] Find/Substitute geometries > > > > Hi Michael. > > your right: cadplan could be an alternative. > Unfortunately I need to return my GIS datas to a CAD project > and save the simbology as objects. This is not possible to > do with Geoff's plugin. > > That means that the answer to your question is "yes". > > > The problem to store the informations as geometries is > connected to the quantity of data that I or other users > could manage. > > The sample I wrote might give an idea. I have a large > point layer with almost 500 point, devided for classes > (wells, springs, etc) with their own attributes. I want to > use this info into a CAD project (save to DXF), substituting > each point with a real simbol. Note that some symbols have > also a rotation attribute (ex. directions of flows) but this > is another question. > > > > **************************************** > > > > Where is the origin of this problem? > > In Italy (an I suspect in many country) unfortunatelly > DWG is a standard for any private or public projects of > cartography. > > GIS helped me to solve the majority of analysis and > cartographic problems but the restitution to CAD remains a > gap, I want to solve into a basic open (GPL) framework. > > > > ************************************ > > > > Note that there is a simple way to export almost > whatever to CAD: print to PS, convert PS to DXF with > Pstoedit and reopen into OJ. But I like to think a more > elegant and user-frindly way to work. > > > > Meanwhile I am going to explore Martin's idea to use > JEQL which seems to me quite interesting > > > > regards > > > > Peppe > > > > PS: AFAIR there was a project to have a JEQL shell for > OJ. > > > > --- Mer 10/2/10, Michaël Michaud <michael.mich...@free.fr> > ha scritto: > > > > > >> Da: Michaël Michaud <michael.mich...@free.fr> > >> Oggetto: Re: [JPP-Devel] Find/Substitute > geometries > >> A: "OpenJump develop and use" <jump-pilot-devel@lists.sourceforge.net> > >> Data: Mercoledì 10 febbraio 2010, 22:34 > >> Hi Giuseppe, > >> > >>> Hi all, > >>> this would sound strange, but it would be > useful if > >>> > >> people have to add "blocks" (geometries) on a > workbench. > >> > >>> To explain what I mean I give a sample: > >>> > >>> a) I have a layer of points with their own > attributes. > >>> > >> These points represents, for instance, wells and > the > >> attributes are the owners, the quantity of water > user per > >> year, the year of opening etc.. > >> > >>> b) I have a layer with a single wkt polygon > geometry. > >>> > >> This geometry is, for instance, a simple > circle which > >> represent a well in cartography (but it could be > even more > >> complicated multigeometry). This layer represent > my "block" > >> > >>> c) I want to create a new layer where the > points are > >>> > >> substituded by circles, in this case, with the > same original > >> attributes (owners, year etc) of the layer a). > >> > >>> > >>> > >> Have you tried the Cadplan VertexSymbols plugin. > You can > >> define a symbol > >> as any wkt shape. Great idea in my opinion. Of > course, this > >> is not the > >> same approach. > >> And there are currently several limitations : as > far as I > >> can see, there > >> is no way to scale the symbol when the view is > scaled, and > >> this is not > >> possible to display different symbols for > different > >> attribute values. > >> But if this way is not as flexible as what you're > >> suggesting, this is a > >> much more light solution. > >> > >> I'd like to ask : is the geometry you want to > display the > >> actual > >> geometry of your feature > >> yes ==> why don't you store it as your feature > geometry > >> (point, > >> linestring, polygon or even complex multipolygon) > so that > >> it scales with > >> your map scale > >> no ==> why don't you display it as a symbol > (OpenJUMP or > >> Cadplan vertex > >> symbol) ? > >> > >> Sorry if my questions seem naive : I've more a gis > / > >> database culture > >> than a cad one. > >> > >> Michaël > >> > >> > >>> I am conscious that this is more a CAD > question than a > >>> > >> GIS one, but it would be sometimes useful in a > CAD-GIS > >> exchange projects. > >> > >>> Right now I use the "copy"/"past to the > point" > >>> > >> tools with some good resaults exporting a GIS > project into > >> an autocad map one, but this procedure requires a > long job. > >> > >> > >>> I wonder if this could be automatized. > >>> > >>> Regards > >>> > >>> Peppe > >>> > >>> > >>> NB - since I am around another useful > cad > >>> > >> project (Dante's plugins) I wonder if this request > (if > >> realize) could be integrated into a more large > project, a > >> new CAD toolbar for OJ, where to add all new > editing/cad > >> requests. > >> > >>> > >>> > >>> > >>> > >> > ------------------------------------------------------------------------------ > >> > >>> SOLARIS 10 is the OS for Data Centers - > provides > >>> > >> features such as DTrace, > >> > >>> Predictive Self Healing and Award Winning ZFS. > Get > >>> > >> Solaris 10 NOW > >> > >>> http://p.sf.net/sfu/solaris-dev2dev > >>> > _______________________________________________ > >>> Jump-pilot-devel mailing list > >>> Jump-pilot-devel@lists.sourceforge.net > >>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > >>> > >>> > >>> > >>> > >> > ------------------------------------------------------------------------------ > >> SOLARIS 10 is the OS for Data Centers - provides > features > >> such as DTrace, > >> Predictive Self Healing and Award Winning ZFS. Get > Solaris > >> 10 NOW > >> http://p.sf.net/sfu/solaris-dev2dev > >> _______________________________________________ > >> Jump-pilot-devel mailing list > >> Jump-pilot-devel@lists.sourceforge.net > >> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > >> > >> > > > > > > > > > > > ------------------------------------------------------------------------------ > > SOLARIS 10 is the OS for Data Centers - provides > features such as DTrace, > > Predictive Self Healing and Award Winning ZFS. Get > Solaris 10 NOW > > http://p.sf.net/sfu/solaris-dev2dev > > _______________________________________________ > > Jump-pilot-devel mailing list > > Jump-pilot-devel@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > > > > > > > > ------------------------------------------------------------------------------ > > SOLARIS 10 is the OS for Data Centers - provides > features such as DTrace, > > Predictive Self Healing and Award Winning ZFS. Get > Solaris 10 NOW > > http://p.sf.net/sfu/solaris-dev2dev > > _______________________________________________ > > Jump-pilot-devel mailing list > > Jump-pilot-devel@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > > > > > -- > Martin Davis > Senior Technical Architect > Refractions Research, Inc. > (250) 383-3022 > > > ------------------------------------------------------------------------------ > SOLARIS 10 is the OS for Data Centers - provides features > such as DTrace, > Predictive Self Healing and Award Winning ZFS. Get Solaris > 10 NOW > http://p.sf.net/sfu/solaris-dev2dev > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > ------------------------------------------------------------------------------ SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
