topic Re: Legend Code in Geotechnical Module in Civil 3D Forum

Legend Code in Geotechnical Module

Anonymous — Wed, 20 Jun 2018 16:00:33 GMT

I am using the geotechnical module and am not sure where to find legend codes to use in my excel file so I can import my data in. Are legend codes mandatory, and if so, are there standard codes? Also, can you briefly explain the purpose of the legend code and why it is used.

Thank you.

Re: Legend Code in Geotechnical Module

Jowennl — Wed, 20 Jun 2018 21:53:26 GMT

Hi @Anonymous,

I used Geotechnical module in its early days. In my memory of using csv I normally ask geotech team to give me Ags or csv or any gint file they have and used that to import to Civil 3d through Geotechnical module. If you are looking for legend or code I remember seeing BH as borehole and TP as test pits and probably there are more and you can contact the company who wrote it and chat with their online chat to give you sample legend to use for csv or sample file as a guide. Try keynetix.com

Also, try this video link and see the help file and maybe they have sample there. This is just a guide to help you find what you are looking for. Good luck.

Cheers,

Jowenn

Re: Legend Code in Geotechnical Module

Jowennl — Wed, 20 Jun 2018 22:02:23 GMT

You can also check this out and see if the sample file would help.

https://knowledge.autodesk.com/support/autocad-civil-3d/troubleshooting/caas/sfdcarticles/sfdcarticles/Geotechnical-Module-Sample-Files.html

Cheers,
Jowenn

Re: Legend Code in Geotechnical Module

Anonymous — Thu, 21 Jun 2018 12:47:09 GMT

Thank you but the video did not answer my questions. Can you briefly explain the purpose for the legend code in the geotechnical module, and what I am missing out on if I do not have it included? I can not find any answers elsewhere.

Thank you

Re: Legend Code in Geotechnical Module

Anonymous — Mon, 09 Jul 2018 11:19:32 GMT

Legend codes are user in the UK and other parts of the world and are predefined values used to describe the physical appearance of the soil/rock. If your local geotechnical codes of practice do not use them then do not worry about them.

In essence they are similar to the USCS in the USA.

If you do not use them then ignore them, or use then to show other properties of your data.

regards

Gary

Re: Legend Code in Geotechnical Module

Anonymous — Wed, 12 Dec 2018 22:04:04 GMT

Hey !!! Gary, could you please provide more information about the legend code. Where I can learn how to use it.

Thank you in advance.

Re: Legend Code in Geotechnical Module

JANSEN7777 — Thu, 05 Sep 2019 15:45:05 GMT

Hi,

thanks for your answer, but it seems a little bit convoluting at the same time, when looking at the USCS in the USA, couldn't find anything about it, would it be possible to find something more accurately about this list, for example location type abbreviations!?

the idea of solving this question is to have a certain order in the tables classification in our company, and in our drawings specially after entering the data.

thanks for your help

Re: Legend Code in Geotechnical Module

rgarford-tull — Tue, 04 Oct 2022 14:04:14 GMT

For those still looking, the AGS published this in "Electronic Transfer of Geotechnical and Geoenvironmental Data (Edition 3.1) including addendum April 2005" in Appendix 1 - Pick Lists Groups ABBR, CODE and UNIT.

accessed from https://www.ags.org.uk/content/uploads/2020/11/Electronic-Transfer-of-Geotechnical-Data-3rd-Edition-Addendum-1.pdf

N.B. This may not be the latest version.

Geol_leg

Code	Description
101	TOPSOIL
102	MADE GROUND
104	CONCRETE
201	CLAY
202	Silty CLAY
203	Sandy CLAY
204	Gravelly CLAY
205	Cobbly CLAY
206	Bouldery CLAY
207	Silty sandy CLAY
208	Silty gravelly CLAY
209	Silty cobbly CLAY
210	Silty bouldery CLAY
211	Silty sandy gravelly CLAY
212	Silty sandy cobbly CLAY
213	Silty sandy bouldery CLAY
214	Silty sandy gravelly cobbly CLAY
215	Silty sandy gravelly bouldery CLAY
216	Silty sandy gravelly cobbly bouldery CLAY
217	Silty sandy organic CLAY
218	Silty sandy gravelly organic CLAY
219	Silty organic CLAY
220	Sandy gravelly CLAY
222	Sandy cobbly CLAY
223	Sandy bouldery CLAY
224	Sandy gravelly cobbly CLAY
225	Sandy gravelly bouldery CLAY
226	Sandy gravelly cobbly bouldery CLAY
227	Sandy organic CLAY
228	Sandy gravelly organic CLAY
229	Organic CLAY
301	SILT
302	CLAY/SILT
303	Sandy SILT
304	Gravelly SILT
305	Organic SILT
310	Sandy gravelly SILT
314	Clayey sandy gravelly organic cobbly SILT
316	Sandy cobbly SILT
317	Sandy bouldery SILT
318	Sandy organic SILT
319	Sandy gravelly organic SILT
320	Sandy gravelly cobbly SILT
321	Sandy gravelly organic cobbly SILT
322	Gravelly cobbly SILT
323	Gravelly bouldery SILT
324	Gravelly organic SILT
325	Gravelly organic cobbly SILT
326	Cobbly SILT
327	Cobbly bouldery SILT
328	Organic cobbly SILT
331	Bouldery SILT
401	SAND
402	Clayey SAND
403	Silty SAND
404	Gravelly SAND
405	Cobbly SAND
406	Bouldery SAND
410	Clayey gravelly SAND
411	Clayey gravelly cobbly SAND
412	Silty gravelly SAND
413	Silty gravelly cobbly SAND
414	Silty gravelly cobbly bouldery SAND
415	Gravelly cobbly SAND
416	Gravelly cobbly bouldery SAND
417	Gravelly bouldery SAND
418	Cobbly bouldery SAND
430	SAND and GRAVEL
431	Organic SAND
433	Silty organic SAND
434	Gravelly organic SAND
435	Cobbly organic SAND
436	Bouldery organic SAND
501	GRAVEL
502	Clayey GRAVEL
503	Silty GRAVEL
504	Sandy GRAVEL
505	Organic GRAVEL
506	Cobbly GRAVEL
507	Bouldery GRAVEL
509	Clayey sandy GRAVEL
510	Clayey cobbly GRAVEL
511	Clayey bouldery GRAVEL
512	Clayey organic GRAVEL
517	Clayey sandy organic GRAVEL
520	Silty sandy GRAVEL
521	Silty cobbly GRAVEL
522	Silty bouldery GRAVEL
523	Silty organic GRAVEL
524	Silty organic sandy GRAVEL
525	Sandy cobbly GRAVEL
526	Sandy bouldery GRAVEL
527	Sandy organic GRAVEL
528	Silty sandy cobbly GRAVEL
601	PEAT
602	Clayey PEAT
603	Silty PEAT
604	Sandy PEAT
605	Gravelly PEAT
606	Cobbly PEAT
608	Clayey sandy PEAT
609	Clayey gravelly PEAT
612	Silty sandy PEAT
613	Silty sandy gravelly PEAT
614	Sandy gravelly PEAT
701	COBBLES
702	Clayey COBBLES
703	Silty COBBLES
704	Sandy COBBLES
705	Gravelly COBBLES
706	Organic COBBLES
708	Clayey sandy COBBLES
709	Clayey gravelly COBBLES
713	Silty sandy COBBLES
714	Silty gravelly COBBLES
715	Silty organic COBBLES
716	Silty gravelly sandy COBBLES
717	Silty sandy organic COBBLES
718	Silty sandy gravelly organic COBBLES
719	Sandy gravelly COBBLES
720	Sandy organic COBBLES
721	Gravelly organic COBBLES
725	COBBLES and BOULDERS
730	BOULDERS
731	Gravelly cobbly BOULDERS
801	MUDSTONE
802	SILTSTONE
803	SANDSTONE
804	LIMESTONE
805	CHALK
806	COAL
807	BRECCIA
808	CONGLOMERATE
809	Fine grained IGNEOUS
810	Medium grained IGNEOUS
811	Coarse grained IGNEOUS
812	Fine grained METAMORPHIC
813	Medium grained METAMORPHIC
814	Coarse grained METAMORPHIC
815	Pyroclastic (volcanic ash)
816	Gypsum, Rocksalt
999	Void