Required a lsp to make automatic topo survey by creating layer point text from one excel

[sdhara.hit]

Required a autocad lsp that can create text and point from excel file also make sure that text & point will be in same layer as text value or mention layer name. also need to crate that layer name from excel. Its to make automatic topo survey.

[Sea-Haven]

If you just want to import points look at "Lee-mac pt manager" 

Re Automatic Topo survey you want CIV3D, Civil Site Design, Stringer to mention a few. Last 2 work with Bricscad also.

[john.uhden]

@sdhara.hit ,

As @Sea-Haven sagely pointed out, topo surveys don't create themselves from point data.  The data has to be analyzed to create a TIN (triangulated irregular network) or DTM (digital terrain model) from all the points to derive all the contours.  And for that you need to have the software @Sea-Haven recommended.

Those wizards, dating back to David C. Arnold, must be geniuses because I wouldn't even know where to start.

[Sea-Haven]

If each point is say P,X,Y,Z,D then yes can string via description and not necessarily make a TIN surface, like you have played with this sort of point data for years. Often thought about doing a stringing lisp get it wrong and you have a bowl of spaghetti. A lot is involved in stringing need a Library of description codes.

[sdhara.hit]

@john.uhden @Sea-Haven  I have data in excel  x y z point id layer name format. so There would be lsp that can create layer from layer column, create point by concatenate x,y,z,layername , and also lsp can create text with layer by concatenate x,y,z,pointid,layer  . I just want autocad lsp. not civil 3d

[john.uhden]

@Sea-Haven ,

Even without connecting kerb points, just random shots, or even a grid of shots, would be daunting for me to triangulate, let alone correctly.

[john.uhden]

@sdhara.hit ,

Yes, by all means freeware AutoLisp is the least expensive way to go.  And this place is like a freeware drive-through.  But you get only what you pay for.

Years ago, before AutoCAD, we used to draw the contours between the points by eye.  Today's software does no better than that, but all that terrain data makes it possible for software to create profiles and cross sections and perform earthwork calculations.  I wish you luck in your quest.

[daniel_cadext]

do you have a sample file?

[Sea-Haven]

Importing just points can be done very easy, the real question is the original request was for a Topo result. This is a Topo from reading data points via CIV3D or another Topo software etc. It has all the points strung. Really need @sdhara.hit to provide a sample dwg of what is really required and yes a sample data file.

[daniel_cadext]

Yeah, just wanted to play around with the data in Python, which has a ton of tools available,

I.e. GDAL, CGAL, Shapely, GeoPandas to name a few

This guy names a couple dozen tools, some I have yet to tryout

https://www.reddit.com/r/StructuralEngineering/comments/1b0l1ss/python_libraries_for_civil_and_struc...

I don’t know many libraries for lisp, there’s a tin generator here,  https://www.theswamp.org/index.php?topic=9042.0

I’m also interested in trying out Apache Arrow’s Parquet high performance file format, with this kind of data structure.

Next level performance reading columnar compared to reading data from excel

[Sea-Haven]

Re TIN's search for lisp by YMG has many functions, "TriangV0.6.7.lsp" may be later versions than this.

[sdhara.hit]

Dear all, don't make it complex. Think simple. I have a data on excel x y z point id & layer name. I just want to draw point in same layer as mention in excel . and also I want to draw text from excel. In "CAD tools" there was a option to provide layer name of text. But I did not find any lisp or script to draw point in predefine layer. 

Point Name	X Coordinate	Y Coordinate	Z Coordinate	Layer Name
DR	491045.6	2532722.664	0	Design Road
DR	491050	2532725.186	0	Design Road
DR	491054.4	2532727.865	0	Design Road
ER	491059.8	2532732.13	0	Existing Road
ER	491064.9	2532735.849	0	Existing Road
ER	491070.8	2532740.157	0	Existing Road
ER	491076.4	2532744.378	0	Existing Road
BLD	491081	2532748.739	0	Builiding
BLD	491085.2	2532754.837	0	Builiding
BLD	491088.2	2532761.28	0	Builiding
BLD	491089.5	2532767.901	0	Builiding
BLD	491088.9	2532774.644	0	Builiding

[autoid374ceb4990]

sdhara:

  Your original post indicated that you wanted to create a "topo survey".  The data in your last post has no Z values.  How do you expect to draw points and use them to create a contour map with no elevations?  Does your data just represent contour lines?

[pbejse]

---

@autoid374ceb4990 wrote:

sdhara:

  Your original post indicated that you wanted to create a "topo survey".  

---

I second this.

@sdhara.hit 

Now based on post #13, what you wanted now are POINT entity with a label from column Point name and  both on a specific layer from column Layer name?

[john.uhden]

@pbejse ,

Thank you for pointing that out.

I guess he's planning to draw the contours by eye, as I had suggested.

Or maybe he never wanted contours.  I dunno.

[autoid374ceb4990]

If you plot the 12 points that the OP listed, they look more like a contour line rather than random spot elevation points.

[john.uhden]

@autoid374ceb4990 ,

Depending on how you connect them, any 12 spots could look like a contour.

Anyway, I have never heard of a survey crew trying to collect shots all at the same elevation, unless, of course, they are at the water's edge of a placid pond.

Here in New Jersey the survey crew doesn't wait for mean high tide (only 2 X per 24-hour day) and try to take shots exactly where the waves extends up the beaches of the Atlantic Ocean, and Barnegat Bay, and Great Bay, and the Navesink River, and the Manasquan River, etc.  They take them in the water and above and in the office we interpolate the location of the MHWL by elevation.  Anyway, the MHWL elevation is determined by some government agency (NOOA, USC&GS, USACE, whatever) for ranges of locations  along the coast based on years of data analyses.

[Sea-Haven]

Hi @john.uhden here in Derby the tide can be (only 1 X per 24-hour day) with 9m tides.

[Sea-Haven]

Post the full sample xls. Nothing worse than make a dummy xls for testing and it has something missing compared to real.

[sdhara.hit]

Its too much high level thinking. I don't want couture. It 2d topo survey . I will just want to draw point in same layer as per excel by one click. is there any lisp? I will draw text from cad tools. is to easy in cad tools.