dxf2postgis-discussion Mailing List for DXF to PostGIS converter
Brought to you by:
glasic
Menu
▾
▴
dxf2postgis-discussion — A mailing list targeted at those interested in dxf2postgis
You can subscribe to this list here.
| 2006 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(2) |
Nov
|
Dec
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2007 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
(2) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(8) |
Dec
|
| 2008 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(2) |
Jun
(7) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2011 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(4) |
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Felix F. <ffi...@gm...> - 2011-08-18 02:46:18
|
Are there plans to extend DXF2PostGIS to handle 3D data (PostGIS 2.0)? Thanks! |
|
From: Guglielmo R. <g.r...@gl...> - 2011-05-20 07:14:08
|
---------- Forwarded message ---------- From: Guglielmo Raimondi <g.r...@gl...> Date: 2011/5/20 Subject: Re: [Dxf2postgis-discussion] Support of Archs? To: Bob Pawley <rjp...@sh...> Hi Bob, yes,I understand what you mean, but anyway dxf2postgis not implemented yet segment of circle conversion. May be in the next future. Regards, Guglielmo 2011/5/19 Bob Pawley <rjp...@sh...>: > Hi Guglielmo > > Sorry - I meant to indicate a segment of a circle whatever the technical > term. > > Bob > > > > > -----Original Message----- From: Guglielmo Raimondi > Sent: Thursday, May 19, 2011 12:23 AM > To: Bob Pawley > Cc: dxf...@li... > Subject: Re: [Dxf2postgis-discussion] Support of Archs? > > Hi Bob, > dxf2postgis doesn't work with arch (there is not a geometry type for > arch in postgis, for what i know). > Only geometry type "circle" is converted in point with radius value as > attribute in the table. > Regards, > Guglielmo > > 2011/5/18 Bob Pawley <rjp...@sh...>: >> >> Hi >> >> I attempted to import a dxf file using dxf2postgis. >> >> The dxf had arch geometry (multiline) that wasn’t passed through to the >> Postgis table although the straight lines did come through.. >> >> Did I do something wrong? >> >> Bob >> >> ------------------------------------------------------------------------------ >> What Every C/C++ and Fortran developer Should Know! >> Read this article and learn how Intel has extended the reach of its >> next-generation tools to help Windows* and Linux* C/C++ and Fortran >> developers boost performance applications - including clusters. >> http://p.sf.net/sfu/intel-dev2devmay >> _______________________________________________ >> Dxf2postgis-discussion mailing list >> Dxf...@li... >> https://lists.sourceforge.net/lists/listinfo/dxf2postgis-discussion >> >> > > > > > -------------------------------------------------- > Ing. Guglielmo R. Raimondi > gug...@gm... > -------------------------------------------------- > > -- -------------------------------------------------- Ing. Guglielmo R. Raimondi gug...@gm... c/o MiPAAF - Ministero delle Politiche Agricole, Alimentari e Forestali Gestione Commissariale ex Agensud Via Venti Settembre 98/G 00187 Roma www.gestcomagensud.it tel.: (+39) 06 488887 55 cell.: (+39) 347 6720673 -------------------------------------------------- -- -------------------------------------------------- Ing. Guglielmo R. Raimondi gug...@gm... c/o MiPAAF - Ministero delle Politiche Agricole, Alimentari e Forestali Gestione Commissariale ex Agensud Via Venti Settembre 98/G 00187 Roma www.gestcomagensud.it tel.: (+39) 06 488887 55 cell.: (+39) 347 6720673 -------------------------------------------------- |
|
From: Bob P. <rjp...@sh...> - 2011-05-19 15:20:22
|
Hi Guglielmo Sorry - I meant to indicate a segment of a circle whatever the technical term. Bob -----Original Message----- From: Guglielmo Raimondi Sent: Thursday, May 19, 2011 12:23 AM To: Bob Pawley Cc: dxf...@li... Subject: Re: [Dxf2postgis-discussion] Support of Archs? Hi Bob, dxf2postgis doesn't work with arch (there is not a geometry type for arch in postgis, for what i know). Only geometry type "circle" is converted in point with radius value as attribute in the table. Regards, Guglielmo 2011/5/18 Bob Pawley <rjp...@sh...>: > Hi > > I attempted to import a dxf file using dxf2postgis. > > The dxf had arch geometry (multiline) that wasn’t passed through to the > Postgis table although the straight lines did come through.. > > Did I do something wrong? > > Bob > ------------------------------------------------------------------------------ > What Every C/C++ and Fortran developer Should Know! > Read this article and learn how Intel has extended the reach of its > next-generation tools to help Windows* and Linux* C/C++ and Fortran > developers boost performance applications - including clusters. > http://p.sf.net/sfu/intel-dev2devmay > _______________________________________________ > Dxf2postgis-discussion mailing list > Dxf...@li... > https://lists.sourceforge.net/lists/listinfo/dxf2postgis-discussion > > -------------------------------------------------- Ing. Guglielmo R. Raimondi gug...@gm... -------------------------------------------------- |
|
From: Guglielmo R. <g.r...@gl...> - 2011-05-19 07:24:04
|
Hi Bob, dxf2postgis doesn't work with arch (there is not a geometry type for arch in postgis, for what i know). Only geometry type "circle" is converted in point with radius value as attribute in the table. Regards, Guglielmo 2011/5/18 Bob Pawley <rjp...@sh...>: > Hi > > I attempted to import a dxf file using dxf2postgis. > > The dxf had arch geometry (multiline) that wasn’t passed through to the > Postgis table although the straight lines did come through.. > > Did I do something wrong? > > Bob > ------------------------------------------------------------------------------ > What Every C/C++ and Fortran developer Should Know! > Read this article and learn how Intel has extended the reach of its > next-generation tools to help Windows* and Linux* C/C++ and Fortran > developers boost performance applications - including clusters. > http://p.sf.net/sfu/intel-dev2devmay > _______________________________________________ > Dxf2postgis-discussion mailing list > Dxf...@li... > https://lists.sourceforge.net/lists/listinfo/dxf2postgis-discussion > > -------------------------------------------------- Ing. Guglielmo R. Raimondi gug...@gm... -------------------------------------------------- |
|
From: Bob P. <rjp...@sh...> - 2011-05-18 20:30:52
|
Hi I attempted to import a dxf file using dxf2postgis. The dxf had arch geometry (multiline) that wasn’t passed through to the Postgis table although the straight lines did come through.. Did I do something wrong? Bob |
|
From: Guglielmo R. <g.r...@gl...> - 2008-06-19 21:26:41
|
Hello list. The Astrid's idea is for sure a brilliant solution. Instead of create new table for arc or to add new feature to *_lin table, I prefer to create a new view, using queries suggested by Astrid. In my opinion, the GIS database don't have to replicate all CAD geometry types, but, if it's possible, have to keep the information to reconstruct them. Using views or clever desktop GIS applications (Qgis, gvSIG, Open Jump, uDig, and so on) should be possible display special geometry types. Talking about circular arcs (not complete circle) I'll study the DXF format used to export this kind of geometry and, in the next future, Dxf2PostGIS will be able to convert needed parameters in a PostGIS table (which one?). All the best. Guglielmo R. 2008/6/19 Astrid Emde (WhereGroup) <ast...@wh...>: > On Wed, June 18, 2008 6:04 pm, Guglielmo Raimondi wrote: > > Hello list, > > Dxf2PostGIS convert CIRCLE type as point ad put the radius in the > attribute > > "radius"; > > no other type of arcs are recognized. > > > > (http://www.glasic.it/docs/dxf2postgis-user-guide_en.html) > > Hello list, > > I am thinking about a solutio to get the circles in the PostgreSQL > database. > > What do you think about the following idea: > 1. we can take the information from table_pnt > 2. we can take the function st_buffer (or buffer) to create new polygons > from the information from table table_pnt. > > -------------------- > Insert inInsert into abwasser.schachtgrundriss_plg > ( handle ,path_file_dxf,layer , the_geom ) > SELECT > handle,'CIRCLE', layer, > GeometryFromText( > replace(replace( > astext(buffer(the_geom,radius)) > ,'POLYGON((','MULTIPOLYGON(((') > ,'))',')))'),getSRID(the_geom) > ) > from abwasser.schachtgrundriss_pnt > where schachtgrundriss_pnt.radius > 0; > ----------------- > > Still the ARC are not converted to PostgreSQL/PostGIS. Do you have any > idea, how we can solve this? > --> Here is an idea: > we need three point to calculate segment of the circle: > * center point > * the start_point > * end_point > with this information we construct the segment as a linestring. > > With this attachment I send two images: > 1. dxf_original_data.png which displays the original data and all segments > we want to have > 2. the result data which was converted to PostgreSQL/PostGIS > > We handled arcs in another projects as well. I can send some code snippets > later. > > see you astrid > |
|
From: Astrid E. (WhereGroup) <ast...@wh...> - 2008-06-19 14:35:00
|
On Wed, June 18, 2008 6:04 pm, Guglielmo Raimondi wrote: > Hello list, > Dxf2PostGIS convert CIRCLE type as point ad put the radius in the attribute > "radius"; > no other type of arcs are recognized. > > (http://www.glasic.it/docs/dxf2postgis-user-guide_en.html) Hello list, I am thinking about a solutio to get the circles in the PostgreSQL database. What do you think about the following idea: 1. we can take the information from table_pnt 2. we can take the function st_buffer (or buffer) to create new polygons from the information from table table_pnt. -------------------- Insert inInsert into abwasser.schachtgrundriss_plg ( handle ,path_file_dxf,layer , the_geom ) SELECT handle,'CIRCLE', layer, GeometryFromText( replace(replace( astext(buffer(the_geom,radius)) ,'POLYGON((','MULTIPOLYGON(((') ,'))',')))'),getSRID(the_geom) ) from abwasser.schachtgrundriss_pnt where schachtgrundriss_pnt.radius > 0; ----------------- Still the ARC are not converted to PostgreSQL/PostGIS. Do you have any idea, how we can solve this? --> Here is an idea: we need three point to calculate segment of the circle: * center point * the start_point * end_point with this information we construct the segment as a linestring. With this attachment I send two images: 1. dxf_original_data.png which displays the original data and all segments we want to have 2. the result data which was converted to PostgreSQL/PostGIS We handled arcs in another projects as well. I can send some code snippets later. see you astrid |
|
From: Guglielmo R. <g.r...@gl...> - 2008-06-18 16:04:30
|
Hello list, Dxf2PostGIS convert CIRCLE type as point ad put the radius in the attribute "radius"; no other type of arcs are recognized. (http://www.glasic.it/docs/dxf2postgis-user-guide_en.html) Regards, Guglielmo |
|
From: Guglielmo R. <gug...@gm...> - 2008-06-18 15:56:27
|
Hello list, Dxf2PostGIS convert CIRCLE type as point ad put the radius in the attribute "radius"; no other type of arcs are recognized. (http://www.glasic.it/docs/dxf2postgis-user-guide_en.html) Regards, Guglielmo 2008/6/18 Astrid Emde (WhereGroup) <ast...@wh...>: > Bob Pawley schrieb: > > Hi > > > > I just converted a DXF file and the arcs in the file don't seem to have > come > > through. I checked it with two different viewers. > > > > Is this expected or is there something else I need to do?? > > > > Bob > > > Hello Bob, > > we have the same problem with our data. The arcs are not converted to > the database. Guglielmo could you discribe which objects from the > dxf-file are converted? Is there an object-type ignored? > > -- > > Best regards Astrid > > > ------------------------------------------------------------------------- > Check out the new SourceForge.net Marketplace. > It's the best place to buy or sell services for > just about anything Open Source. > http://sourceforge.net/services/buy/index.php > _______________________________________________ > Dxf2postgis-discussion mailing list > Dxf...@li... > https://lists.sourceforge.net/lists/listinfo/dxf2postgis-discussion > > |
|
From: Astrid E. (WhereGroup) <ast...@wh...> - 2008-06-18 12:16:09
|
Bob Pawley schrieb: > Hi > > I just converted a DXF file and the arcs in the file don't seem to have come > through. I checked it with two different viewers. > > Is this expected or is there something else I need to do?? > > Bob > Hello Bob, we have the same problem with our data. The arcs are not converted to the database. Guglielmo could you discribe which objects from the dxf-file are converted? Is there an object-type ignored? -- Best regards Astrid |
|
From: Bob P. <rjp...@sh...> - 2008-06-17 18:25:25
|
Hi I just converted a DXF file and the arcs in the file don't seem to have come through. I checked it with two different viewers. Is this expected or is there something else I need to do?? Bob |
|
From: Guglielmo R. <g.r...@gl...> - 2008-05-24 06:22:15
|
Bob, I really appreciate your interest to support development of a "postgis2dxf" tool. The "Dxf2PostGIS" was developed to satisfy some requirements for projects paid by a public administration and then we decided to distribute the software with "open source" GPL license. Now if we want to start a new project (or to add new features for "Dxf2PostGIS") to realize the "reverse" tool, I think that should be done with the same kind of license. Have you one or more sponsor to pay the software development (or to contribute for a significant part of it)? What about minimal requirements? What about database schema for the reverse conversion? I suggest to investigate if some other open source GIS software allow conversion in DXF format or plan to do it in future. If not, I'm interested to start a new project with sponsors. Regards, Guglielmo -----Messaggio originale----- Da: Bob Pawley [mailto:rjp...@sh...] Inviato: venerdì 23 maggio 2008 20.16 A: Guglielmo R. Raimondi Oggetto: Re: [Dxf2postgis-discussion] postgis2dxf Guglielmo May I ask what your interest is that you spent the time necessary to create dxf2postgis? Bob ----- Original Message ----- From: "Guglielmo R. Raimondi" <g.r...@gl...> To: "Bob Pawley" <rjp...@sh...> Sent: Friday, May 23, 2008 9:19 AM Subject: re: [Dxf2postgis-discussion] postgis2dxf > Hi Bob, > No news about a tool to convert PostGIS tables in DXF. > Till now I didn't needed this kind of format conversion > utility. > At moment I haven't plan to develop it. > > Guglielmo > > ----- Original Message ----- > Da : Bob Pawley <rjp...@sh...> > A : "dxf...@li..." > <dxf...@li...> > Oggetto : [Dxf2postgis-discussion] postgis2dxf > Data : Fri, 23 May 2008 08:57:48 -0700 > >> Hi >> >> I'm looking to get information out of postgis. >> >> Does anyone know of a postgis2dxf utility?? >> >> Bob >> >> ---------------------------------------------------------- >> --------------- This SF.net email is sponsored by: >> Microsoft Defy all challenges. Microsoft(R) Visual Studio >> 2008. >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ >> _______________________________________________ >> Dxf2postgis-discussion mailing list >> Dxf...@li... >> > https://lists.sourceforge.net/lists/listinfo/dxf2postgis-discussion > > ^^^^^^^^^^^^^^^^^^^^^^^^^^^ > Ing. Guglielmo R. Raimondi > Glasic S.r.l. > www.glasic.it > g.r...@gl... > ^^^^^^^^^^^^^^^^^^^^^^^^^^^ |
|
From: Bob P. <rjp...@sh...> - 2008-05-23 15:57:11
|
Hi I'm looking to get information out of postgis. Does anyone know of a postgis2dxf utility?? Bob |
|
From: Bob P. <rjp...@sh...> - 2007-11-23 17:31:18
|
Thanks Guglielmo and Astrid. This should keep me going for a while. Bob ----- Original Message ----- From: "Guglielmo Nigri" <g....@gl...> To: <dxf...@li...> Sent: Friday, November 23, 2007 3:11 AM Subject: Re: [Dxf2postgis-discussion] New User > Hi Bob, > the terminology used in dxf2postgis for PostGIS data types > follows the Open Geospatial Consortium (formerly OpenGIS > Consortium) standards. You can find the full documentation > on http://www.opengeospatial.org/ . > Since you are interested, I would advice you to read at > least the overview of the Abstract Specification, on > http://www.opengeospatial.org/standards/as , and relevant > portions of the OGC Reference Model, on > http://portal.opengeospatial.org/files/?artifact_id=3836 > [PDF]. > Last but not least, I have to mention the Simple Features > for SQL specification, which you can find on > http://www.opengeospatial.org/standards/sfs > Hope that helps! > Best, > -- Guglielmo Nigri > > > ----- Original Message ----- > Da : "Guglielmo R. Raimondi" <g.r...@gl...> > A : Bob Pawley <rjp...@sh...> > Cc: dxf...@li... > Oggetto : Re: [Dxf2postgis-discussion] New User > Data : Wed, 21 Nov 2007 12:41:24 +0100 > >> Hi Bob. >> POINT, MULTILESTRING and MULTIPOLYGON are geometry data >> types of PostGIS. >> The geometry data types used in AutoCAD (POINT, TEXT, >> BLOCK, POLILINE, CIRCLE, etc.) are all converted in these >> three types. >> Other AutoCAD charateristics are converted in PostgreSQL >> fields of geometric tables (as Handle, layer, etc.). >> >> On the User Guide there is a more detailed description of >> each conversion (both italian and english version): >> >> http://www.glasic.it/docs/dxf2postgis-user-guide.html >> >> Guglielmo Raimondi >> >> ----- Original Message ----- >> Da : Bob Pawley <rjp...@sh...> >> A : dxf...@li... >> Oggetto : [Dxf2postgis-discussion] New User >> Data : Tue, 20 Nov 2007 19:48:23 -0800 >> >> > Hi >> > >> > Can someone point me to a description of the terminology >> > used in dxf2postgis? >> > >> > I am interested in the meaning of terms such as point >> > geometry, multipolygon geometry, handle, etc. >> > >> > A basic description would be very helpful (so I don't >> > have to rely on guesswork). >> > >> > Bob Pawley >> > >> > >> > >> > >> ---------------------------------------------------------- >> > --------------- This SF.net email is sponsored by: >> > Microsoft Defy all challenges. Microsoft(R) Visual >> > Studio 2005. >> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ >> > _______________________________________________ >> > Dxf2postgis-discussion mailing list >> Dxf...@li... > >> > https://lists.sourceforge.net/lists/listinfo/dxf2postgis-discussion >> >> ^^^^^^^^^^^^^^^^^^^^^^^^^^^ >> Ing. Guglielmo R. Raimondi >> Glasic S.r.l. >> http://www.glasic.it >> g.r...@gl... >> cell.: 347 6720673 >> tel.: 06 83502893 >> ^^^^^^^^^^^^^^^^^^^^^^^^^^^ >> > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Dxf2postgis-discussion mailing list > Dxf...@li... > https://lists.sourceforge.net/lists/listinfo/dxf2postgis-discussion |
|
From: Guglielmo N. <g....@gl...> - 2007-11-23 11:11:33
|
Hi Bob, the terminology used in dxf2postgis for PostGIS data types follows the Open Geospatial Consortium (formerly OpenGIS Consortium) standards. You can find the full documentation on http://www.opengeospatial.org/ . Since you are interested, I would advice you to read at least the overview of the Abstract Specification, on http://www.opengeospatial.org/standards/as , and relevant portions of the OGC Reference Model, on http://portal.opengeospatial.org/files/?artifact_id=3836 [PDF]. Last but not least, I have to mention the Simple Features for SQL specification, which you can find on http://www.opengeospatial.org/standards/sfs Hope that helps! Best, -- Guglielmo Nigri ----- Original Message ----- Da : "Guglielmo R. Raimondi" <g.r...@gl...> A : Bob Pawley <rjp...@sh...> Cc: dxf...@li... Oggetto : Re: [Dxf2postgis-discussion] New User Data : Wed, 21 Nov 2007 12:41:24 +0100 > Hi Bob. > POINT, MULTILESTRING and MULTIPOLYGON are geometry data > types of PostGIS. > The geometry data types used in AutoCAD (POINT, TEXT, > BLOCK, POLILINE, CIRCLE, etc.) are all converted in these > three types. > Other AutoCAD charateristics are converted in PostgreSQL > fields of geometric tables (as Handle, layer, etc.). > > On the User Guide there is a more detailed description of > each conversion (both italian and english version): > > http://www.glasic.it/docs/dxf2postgis-user-guide.html > > Guglielmo Raimondi > > ----- Original Message ----- > Da : Bob Pawley <rjp...@sh...> > A : dxf...@li... > Oggetto : [Dxf2postgis-discussion] New User > Data : Tue, 20 Nov 2007 19:48:23 -0800 > > > Hi > > > > Can someone point me to a description of the terminology > > used in dxf2postgis? > > > > I am interested in the meaning of terms such as point > > geometry, multipolygon geometry, handle, etc. > > > > A basic description would be very helpful (so I don't > > have to rely on guesswork). > > > > Bob Pawley > > > > > > > > > ---------------------------------------------------------- > > --------------- This SF.net email is sponsored by: > > Microsoft Defy all challenges. Microsoft(R) Visual > > Studio 2005. > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > > _______________________________________________ > > Dxf2postgis-discussion mailing list > Dxf...@li... > > https://lists.sourceforge.net/lists/listinfo/dxf2postgis-discussion > > ^^^^^^^^^^^^^^^^^^^^^^^^^^^ > Ing. Guglielmo R. Raimondi > Glasic S.r.l. > http://www.glasic.it > g.r...@gl... > cell.: 347 6720673 > tel.: 06 83502893 > ^^^^^^^^^^^^^^^^^^^^^^^^^^^ > |
|
From: Guglielmo N. <g....@gl...> - 2007-11-23 08:33:49
|
Hi Astrid! Sorry I replied to your address only, this was meant to be sent to the list too. I do it now so everyone can read! My invitation / suggestion to contribute is directed to everybody, or nobody in particular, of course :-) To answer your question: sure, the source code on SF is always the latest! --Guglielmo Astrid Emde (WhereGroup) wrote: > Guglielmo Nigri schrieb: >> Hello Astrid, >> a new version is being planned, alas we still are very busy and don't >> have a time schedule for that. >> Your suggestions will be included, rest assured. By the way, if >> anyone reading this is faster or simply has spare time and wants to >> implement them in right now, please feel free to contribute! It's >> open source software :-) >> >> --Guglielmo > Hi Guglielmo, > > it is not that I have spare time....but I would like to contribute. Is > the code on sourceforge the actual version? So I could build the > functionality in and send the code back to you? > > astrid > > |
|
From: Astrid E. (WhereGroup) <ast...@wh...> - 2007-11-23 07:36:45
|
Hi Bob, Bob Pawley schrieb: > Thanks Guglielmo > > When I process a drawing of a single line the geometry column of the *_lin > table has the following : > 0105000000010000000102000000020000000000000000003E400000000000004E400000000000003E400000000000004E40 > > Is there any documentation that can help me understand the signifigance of > this set of characters?? > > Bob PostgreSQL/PostGIS stores geometries in WKB-format (Well-known binary). I f you want to see the geometry as WKT (Well-known text) which is human readle use the following SQL: Select asText(the_geom) from mytable; Select asEWKT(the_geom) from mytable; (gives you uinformatin about the SRID too) For more information about PostGIS have a look at the documentation. There you will find all you need: http://postgis.refractions.net/documentation/ greetings astrid |
|
From: Bob P. <rjp...@sh...> - 2007-11-22 21:27:40
|
Thanks Guglielmo When I process a drawing of a single line the geometry column of the *_lin table has the following : 0105000000010000000102000000020000000000000000003E400000000000004E400000000000003E400000000000004E40 Is there any documentation that can help me understand the signifigance of this set of characters?? Bob ----- Original Message ----- From: "Guglielmo R. Raimondi" <g.r...@gl...> To: "Bob Pawley" <rjp...@sh...> Cc: <dxf...@li...> Sent: Wednesday, November 21, 2007 3:41 AM Subject: re: [Dxf2postgis-discussion] New User > Hi Bob. > POINT, MULTILESTRING and MULTIPOLYGON are geometry data > types of PostGIS. > The geometry data types used in AutoCAD (POINT, TEXT, BLOCK, > POLILINE, CIRCLE, etc.) are all converted in these three > types. > Other AutoCAD charateristics are converted in PostgreSQL > fields of geometric tables (as Handle, layer, etc.). > > On the User Guide there is a more detailed description of > each conversion (both italian and english version): > > http://www.glasic.it/docs/dxf2postgis-user-guide.html > > Guglielmo Raimondi > > ----- Original Message ----- > Da : Bob Pawley <rjp...@sh...> > A : dxf...@li... > Oggetto : [Dxf2postgis-discussion] New User > Data : Tue, 20 Nov 2007 19:48:23 -0800 > >> Hi >> >> Can someone point me to a description of the terminology >> used in dxf2postgis? >> >> I am interested in the meaning of terms such as point >> geometry, multipolygon geometry, handle, etc. >> >> A basic description would be very helpful (so I don't have >> to rely on guesswork). >> >> Bob Pawley >> >> >> ---------------------------------------------------------- >> --------------- This SF.net email is sponsored by: >> Microsoft Defy all challenges. Microsoft(R) Visual Studio >> 2005. >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ >> _______________________________________________ >> Dxf2postgis-discussion mailing list >> Dxf...@li... >> > https://lists.sourceforge.net/lists/listinfo/dxf2postgis-discussion > > ^^^^^^^^^^^^^^^^^^^^^^^^^^^ > Ing. Guglielmo R. Raimondi > Glasic S.r.l. > www.glasic.it > g.r...@gl... > cell.: 347 6720673 > tel.: 06 83502893 > ^^^^^^^^^^^^^^^^^^^^^^^^^^^ |
|
From: Astrid E. (WhereGroup) <ast...@wh...> - 2007-11-22 09:14:05
|
Hello list, I just wanted to ask, wether you think about new version of the converter. I made some suggestions for improvements and it would be nice to buid them in. http://sourceforge.net/mailarchive/forum.php?thread_name=41943.192.168.0.5.1180597704.squirrel%40center&forum_name=dxf2postgis-discussion The suggestions are : 1. Create geometry_column with the function AddGeometryColumn 2. enable the possibility to use a schema What do you think about this? greetings Astrid |
|
From: Guglielmo R. R. <g.r...@gl...> - 2007-11-21 11:41:40
|
Hi Bob. POINT, MULTILESTRING and MULTIPOLYGON are geometry data types of PostGIS. The geometry data types used in AutoCAD (POINT, TEXT, BLOCK, POLILINE, CIRCLE, etc.) are all converted in these three types. Other AutoCAD charateristics are converted in PostgreSQL fields of geometric tables (as Handle, layer, etc.). On the User Guide there is a more detailed description of each conversion (both italian and english version): http://www.glasic.it/docs/dxf2postgis-user-guide.html Guglielmo Raimondi ----- Original Message ----- Da : Bob Pawley <rjp...@sh...> A : dxf...@li... Oggetto : [Dxf2postgis-discussion] New User Data : Tue, 20 Nov 2007 19:48:23 -0800 > Hi > > Can someone point me to a description of the terminology > used in dxf2postgis? > > I am interested in the meaning of terms such as point > geometry, multipolygon geometry, handle, etc. > > A basic description would be very helpful (so I don't have > to rely on guesswork). > > Bob Pawley > > > ---------------------------------------------------------- > --------------- This SF.net email is sponsored by: > Microsoft Defy all challenges. Microsoft(R) Visual Studio > 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Dxf2postgis-discussion mailing list > Dxf...@li... > https://lists.sourceforge.net/lists/listinfo/dxf2postgis-discussion ^^^^^^^^^^^^^^^^^^^^^^^^^^^ Ing. Guglielmo R. Raimondi Glasic S.r.l. www.glasic.it g.r...@gl... cell.: 347 6720673 tel.: 06 83502893 ^^^^^^^^^^^^^^^^^^^^^^^^^^^ |
|
From: Bob P. <rjp...@sh...> - 2007-11-21 03:51:18
|
Hi Can someone point me to a description of the terminology used in dxf2postgis? I am interested in the meaning of terms such as point geometry, multipolygon geometry, handle, etc. A basic description would be very helpful (so I don't have to rely on guesswork). Bob Pawley |
|
From: Guglielmo N. <g....@gl...> - 2007-05-31 09:36:30
|
> Hello list,
Hello Astrid,
> we are using the Dxf2PostGIS-Konverter and it's really working fine and
> very fast.
>
> We have two suggestions to make.
>
> 1. How to create serial-columns and geometry columns
> - it would be better to create searial columns like:
>
> CREATE TABLE abwasser.sinkkaesten_txt
> (
> gid serial,
> ....
>
> Like this the database can decide, how this this serial is created. We had
> problems with older postgresql versions with the way the sequence is
> produces at the moment.
>
Ok, we'll look into this.
> Similar case is the geometry-column:
>
> It would be better to create it with
>
> Select AddGeometryColumn ('myschemaname','abwasser', 'sinkkaesten_txt',
> 'the_geom', 31466,'POINT',2);
>
> and not writing it in the table directly. Here aswell we had problems with
> older versions, as the constraints where different and for example the
> function ndims was not known i our version
>
>
I totally agree. This must have been overlooked since the beginning.
Thanks for pointing it out.
> 2. Possibility to use a schema
> In our database we use schemata to group our data. It would be very cool,
> if Dxf2PostGIS could handle schema aswell. It would be another textfield
> schemaname:
>
> If a schema is should be used there a tree changes necessary:
> - CREATE TABLE myschemaname.mytable....
> - Select AddGeometryColumn ('myschemaname','mytable', 'sinkkaesten_txt',
> 'the_geom', 31466,'POINT',2);
> - INSERT INTO myschemaname.mytable...
>
>
Agreed. Schema support will be present in the next releases.
> What do you think about the suggestions?
>
Very useful! Thank you for your suggestions.
> Greetings from Germany
>
> Astrid Emde
>
>
Greetings from Rome too :-)
Guglielmo Nigri
Glasic S.r.l.
|
|
From: Astrid E. (WhereGroup) <ast...@wh...> - 2007-05-31 07:49:30
|
Hello list,
we are using the Dxf2PostGIS-Konverter and it's really working fine and
very fast.
We have two suggestions to make.
1. How to create serial-columns and geometry columns
- it would be better to create searial columns like:
CREATE TABLE abwasser.sinkkaesten_txt
(
gid serial,
....
Like this the database can decide, how this this serial is created. We had
problems with older postgresql versions with the way the sequence is
produces at the moment.
Similar case is the geometry-column:
It would be better to create it with
Select AddGeometryColumn ('myschemaname','abwasser', 'sinkkaesten_txt',
'the_geom', 31466,'POINT',2);
and not writing it in the table directly. Here aswell we had problems with
older versions, as the constraints where different and for example the
function ndims was not known i our version
2. Possibility to use a schema
In our database we use schemata to group our data. It would be very cool,
if Dxf2PostGIS could handle schema aswell. It would be another textfield
schemaname:
If a schema is should be used there a tree changes necessary:
- CREATE TABLE myschemaname.mytable....
- Select AddGeometryColumn ('myschemaname','mytable', 'sinkkaesten_txt',
'the_geom', 31466,'POINT',2);
- INSERT INTO myschemaname.mytable...
What do you think about the suggestions?
Greetings from Germany
Astrid Emde
----------------------------------
Astrid Emde
WhereGroup GmbH & Co.KG
Siemensstraße 8
D-53121 Bonn
Fon: +49(0)228 90 90 38 - 19
Fax: +49(0)228 90 90 38 - 11
ast...@wh...
http://www.wheregroup.com
|
|
From: Guglielmo R. <g.r...@gl...> - 2007-01-22 14:52:47
|
A new version of the Dxf2PostGis tool has been released. This version includes a new feature to create and populate a table with layer attributes . See the Release Notes for details: (https://sourceforge.net/project/shownotes.php?group_id=177555 <https://sourceforge.net/project/shownotes.php?group_id=177555&release_id=48 0468> &release_id=480468). Regards, Guglielmo Raimondi Glasic S.r.l. www.glasic.it |
|
From: Guglielmo R. <g.r...@gl...> - 2006-10-27 13:24:46
|
A new version of the Dxf2PostgreSQL tool has been released. This version includes a new feature to create and populate a table with layer attributes . See the Release Notes for details (HYPERLINK "http://sourceforge.net/project/shownotes.php?release_id=458848&group_id=177 555"http://sourceforge.net/project/shownotes.php?release_id=458848&group_id= 177555). Regards, Guglielmo Raimondi Glasic S.r.l. HYPERLINK "http://www.glasic.it"http://www.glasic.it -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.408 / Virus Database: 268.13.14/502 - Release Date: 27/10/2006 |
1 message has been excluded from this view by a project administrator.
