<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
All,
<div class=""><br class="">
</div>
<div class="">Answering my own post.</div>
<div class=""><br class="">
</div>
<div class="">While it’s not the most elegant, it works . . .</div>
<div class=""><br class="">
</div>
<div class="">I’m importing the Lines and Arcs separately into AutoCAD.</div>
<div class=""><br class="">
</div>
<div class="">Here are my SQL statements (W/embedded AutoLISP code . . .) :</div>
<div class=""><br class="">
</div>
<div class="">— circularStrings</div>
<div class=""><br class="">
</div>
<div class="">
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>select </div>
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>'(setq p1 (list ' || substring(ST_AsText(ST_PointN(geom, 1)) from 7) || ') ' ||</div>
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>'(setq p2 (list ' || substring(ST_AsText(ST_PointN(geom, 2)) from 7) || ') ' ||</div>
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>'(setq p3 (list ' || substring(ST_AsText(ST_PointN(geom, 3)) from 7) || ') ' ||</div>
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>'(command "arc" p1 p2 p3) ' ||</div>
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>'(setq newf (cdr (assoc -1 (entget (entlast))))) ' ||</div>
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>'(ade_odaddrecord newf "CSEGMENTS") ' ||</div>
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>'(ade_odsetfield newf "CSEGMENTS" "row_number" 0 ' || row_number || ') ' ||</div>
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>'(ade_odsetfield newf "CSEGMENTS" "parcelid" 0 "' || parcelid || '") ' ||</div>
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>'(ade_odsetfield newf "CSEGMENTS" "length" 0 ' || length || ') ' as lispcode</div>
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>from</div>
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>rc_parcel_csegments</div>
<div class=""><br class="">
</div>
<div class="">— output sample . . .</div>
<div class=""><br class="">
</div>
<div class="">
<div class="">"(setq p1 (list 600685.235522255 219942.697182685)) (setq p2 (list 600693.342558373 219979.8599755)) (setq p3 (list 600698.003484443 220017.610119224)) (command "arc" p1 p2 p3) (setq newf (cdr (assoc -1 (entget (entlast))))) (ade_odaddrecord newf
"CSEGMENTS") (ade_odsetfield newf "CSEGMENTS" "row_number" 0 1) (ade_odsetfield newf "CSEGMENTS" "parcelid" 0 "013022120083") (ade_odsetfield newf "CSEGMENTS" "length" 0 76.1003792415913) "</div>
<div class="">"(setq p1 (list 600948.746080443 219842.610487968)) (setq p2 (list 600948.358392681 219840.945456597)) (setq p3 (list 600947.965196267 219839.281702653)) (command "arc" p1 p2 p3) (setq newf (cdr (assoc -1 (entget (entlast))))) (ade_odaddrecord
newf "CSEGMENTS") (ade_odsetfield newf "CSEGMENTS" "row_number" 0 2) (ade_odsetfield newf "CSEGMENTS" "parcelid" 0 "013022130020") (ade_odsetfield newf "CSEGMENTS" "length" 0 3.41915697291469) "</div>
<div class="">"(setq p1 (list 600657.889986396 219869.353512585)) (setq p2 (list 600673.300839893 219905.377319746)) (setq p3 (list 600685.235522255 219942.697182685)) (command "arc" p1 p2 p3) (setq newf (cdr (assoc -1 (entget (entlast))))) (ade_odaddrecord
newf "CSEGMENTS") (ade_odsetfield newf "CSEGMENTS" "row_number" 0 3) (ade_odsetfield newf "CSEGMENTS" "parcelid" 0 "013022130031") (ade_odsetfield newf "CSEGMENTS" "length" 0 78.3927875233048) "</div>
</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">— lineStrings</div>
<div class=""><br class="">
</div>
<div class="">
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>select </div>
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>'(setq p1 (list ' || substring(ST_AsText(ST_PointN(geom, 1)) from 7) || ') ' ||</div>
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>'(setq p2 (list ' || substring(ST_AsText(ST_PointN(geom, 2)) from 7) || ') ' ||</div>
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>'(command "line" p1 p2 "") ' ||</div>
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>'(setq newf (cdr (assoc -1 (entget (entlast))))) ' ||</div>
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>'(ade_odaddrecord newf "CSEGMENTS") ' ||</div>
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>'(ade_odsetfield newf "CSEGMENTS" "row_number" 0 ' || row_number || ') ' ||</div>
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>'(ade_odsetfield newf "CSEGMENTS" "parcelid" 0 "' || parcelid || '") ' ||</div>
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>'(ade_odsetfield newf "CSEGMENTS" "length" 0 ' || length || ') ' as lispcode</div>
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>from</div>
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span>rc_parcel_lsegments</div>
</div>
<div class=""><br class="">
</div>
<div class="">— output sample . . .basically, I just run the (Auto)LISP code on the commandline in AutoCAD, and I end up with features and Objectdata attached . . .works like a charm.</div>
<div class=""><br class="">
</div>
<div class="">
<div class="">"(setq p1 (list 595666.114621326 156963.072483376)) (setq p2 (list 595663.839722514 157136.207306489)) (command "line" p1 p2 "") (setq newf (cdr (assoc -1 (entget (entlast))))) (ade_odaddrecord newf "CSEGMENTS") (ade_odsetfield newf "CSEGMENTS"
"row_number" 0 1) (ade_odsetfield newf "CSEGMENTS" "parcelid" 0 "C98") (ade_odsetfield newf "CSEGMENTS" "length" 0 173.14976794376) "</div>
<div class="">"(setq p1 (list 595663.839722514 157136.207306489)) (setq p2 (list 595661.224519357 157507.969695389)) (command "line" p1 p2 "") (setq newf (cdr (assoc -1 (entget (entlast))))) (ade_odaddrecord newf "CSEGMENTS") (ade_odsetfield newf "CSEGMENTS"
"row_number" 0 2) (ade_odsetfield newf "CSEGMENTS" "parcelid" 0 "C98") (ade_odsetfield newf "CSEGMENTS" "length" 0 371.771587252435) "</div>
<div class="">"(setq p1 (list 595661.224519357 157507.969695389)) (setq p2 (list 595791.264319509 157507.750218511)) (command "line" p1 p2 "") (setq newf (cdr (assoc -1 (entget (entlast))))) (ade_odaddrecord newf "CSEGMENTS") (ade_odsetfield newf "CSEGMENTS"
"row_number" 0 3) (ade_odsetfield newf "CSEGMENTS" "parcelid" 0 "C98") (ade_odsetfield newf "CSEGMENTS" "length" 0 130.039985364846) "</div>
</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div>
<blockquote type="cite" class="">
<div class="">On May 17, 2017, at 2:22 PM, Basques, Bob (CI-StPaul) <<a href="mailto:bob.basques@ci.stpaul.mn.us" class="">bob.basques@ci.stpaul.mn.us</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
All,
<div class=""><br class="">
</div>
<div class="">I tried DXF (although there were some settings I didn’t try) and that didn’t seem to work, the arcs came in, but no attribute (extended) data applied to any of the features. Even GeoJSON doesn’t seem to support circles/arcs (right)?
<div class=""><br class="">
</div>
<div class="">Am I going to need to write my own importer for CSV, or? Still phutzing with it . . .</div>
<div class=""><br class="">
</div>
<div class="">thankks</div>
<div class=""><br class="">
</div>
<div class="">bobb</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
<div class="">
<div style="font-family: 'Comic Sans MS'; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-east-asian: normal; font-variant-position: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<div style="letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<div class=""><br class="Apple-interchange-newline">
<br class="">
</div>
<div class="">“There is nothing quite so useless as doing with great efficiency something that should not be done at all.” </div>
<div class=""> - Peter Drucker</div>
<div class=""><br class="">
</div>
</div>
<br class="Apple-interchange-newline">
</div>
<br class="Apple-interchange-newline" style="font-family: 'Comic Sans MS'; font-size: 12px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-east-asian: normal; font-variant-position: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;">
<br class="Apple-interchange-newline">
</div>
<br class="">
</div>
</div>
</div>
_______________________________________________<br class="">
postgis-users mailing list<br class="">
<a href="mailto:postgis-users@lists.osgeo.org" class="">postgis-users@lists.osgeo.org</a><br class="">
https://lists.osgeo.org/mailman/listinfo/postgis-users</div>
</blockquote>
</div>
<br class="">
<div class="">
<div style="color: rgb(0, 0, 0); font-family: 'Comic Sans MS'; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<br class="Apple-interchange-newline">
<br class="">
</div>
<div style="color: rgb(0, 0, 0); font-family: 'Comic Sans MS'; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<dt class="">"C makes it easy to shoot yourself in the foot; C++ makes it harder, but when you do, it blows away your whole leg."<span class="Apple-converted-space"> </span></dt><dd class="">- Bjarne Stroustrup
<div class=""><br class="">
</div>
</dd></div>
<br class="Apple-interchange-newline">
</div>
<br class="">
</div>
</body>
</html>