18 reputation
4
bio website
location
age
visits member for 2 years, 2 months
seen 20 mins ago

59m
comment Export PostGIS line to AutoCAD with graphical direction information
You are right but I tried it and the driver only gets the text, not the style/rotation of that text. So, from the style string LABEL(f:"Arial, Helvetica", s:12pt, t:"Hello World!", a:3) it only understand the t:"Hello World!" and copy that content to the Text DXF object attribute. About the triangle idea I'm afraid the only way is to upgrade to PostGIS 2.0 and use the ST_Project function..
1h
comment Export PostGIS line to AutoCAD with graphical direction information
I don't understand exactly your idea, I don't exactly see the execution of the script, like I said I would like to manage to do it only with the ogr2ogr command and the -sql parameter with the PostgreSQL(PostGIS) Query. I neither know much about DXF, I used to check in the OGR DXF information (gdal.org/drv_dxf.html) to get some idea but there isn't much options. Thank you again.
4h
comment Export PostGIS line to AutoCAD with graphical direction information
Thank you @user30184, I did not had this idea. The main problem is that I need to be able to, once exported, visualise it in an easy way with AutoCAD. And I need to make this export an automatic process with PostGIS (PostgreSQL) and GDAL ogr2ogr command.
12h
revised Export PostGIS line to AutoCAD with graphical direction information
edited tags
12h
revised Export PostGIS line to AutoCAD with graphical direction information
deleted 31 characters in body
12h
awarded  Custodian
12h
reviewed Edit suggested edit on Export PostGIS line to AutoCAD with graphical direction information
12h
revised Export PostGIS line to AutoCAD with graphical direction information
added 26 characters in body; edited title
13h
revised Export PostGIS line to AutoCAD with graphical direction information
added 26 characters in body; edited title
16h
revised Export PostGIS line to AutoCAD with graphical direction information
added 104 characters in body
16h
revised Export PostGIS line to AutoCAD with graphical direction information
added 104 characters in body
17h
asked Export PostGIS line to AutoCAD with graphical direction information
Nov
18
accepted ogr2ogr DXF to PostgreSQL some LINESTRING coordinates mirrored to the negative longitude
Nov
18
answered ogr2ogr DXF to PostgreSQL some LINESTRING coordinates mirrored to the negative longitude
Nov
13
awarded  Editor
Nov
13
revised ogr2ogr DXF to PostgreSQL some LINESTRING coordinates mirrored to the negative longitude
added 174 characters in body
Nov
13
asked ogr2ogr DXF to PostgreSQL some LINESTRING coordinates mirrored to the negative longitude
Oct
7
comment Export Postgis Geometry POINT as Label text to DXF or DGN
Oh yeah! It works, thank you klewis, it was much time spent.. Finally I decided to generate de OGR_STYLE field in the SQL query like: SELECT posicion AS the_geom, 'LABEL(f:\'Times New Roman\',s:12pt,t:\'' || name || '\')' AS OGR_STYLE FROM the_geometry_table c [...], and it became the Text attribute of the DXF Point object :)
Oct
7
awarded  Scholar
Oct
7
accepted Export Postgis Geometry POINT as Label text to DXF or DGN