Hi, Nice idea. You may even be able to define your symbolized layer as a "view". The query may be a bit more complex as geometries must have absolute coordinates so that your symbol must be translated with different values for each feature By chance, both postgis and SpatiLite have a translate function (ST_Translate for postgis and ShiftCoords for spatialite Assuming data geometry are points and symbols are any geometry centered on the origin, it could be
SELECT d.attribute_1, d.attribute_2, d.attribute_3, ShiftCoords(s.Geometry, X(d.geometry), Y(d.geometry)) from data d, symbol s # "d" is a synonyme for data layer, "s" for symbol layer, see the line above WHERE d.Symbol_ID=s.ID # ID is connecting the tables Michaël Rahkonen Jukka a écrit : > 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 > > > ------------------------------------------------------------------------------ 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
