topic Re: Loss of attributes when importing Shapefiles in Civil 3D Forum

Loss of attributes when importing Shapefiles

samoh21 — Tue, 16 May 2017 11:04:37 GMT

Followings happens:

I import GIS contours as shapefile, where the elevation is shown as attribute.

After the import, some polylines are missing their attribute?

I have checked the GIS contours through data connection, (SHP) and i can see all the attributes.
I have tried to import the shapefile several times, and it appears to be random each times which polylines that have no attributes

What can it be?

Re: Loss of attributes when importing Shapefiles

Todd_Rogers — Tue, 16 May 2017 12:51:05 GMT

Why not create a Civil 3D surface from GIS data? If you go to Surfaces, there is an option under there for Create Surface from GIS Data.

Re: Loss of attributes when importing Shapefiles

Ranjit_Singh — Tue, 16 May 2017 15:01:24 GMT

If you have permission to share the shape file then upload the shp file. It will be helpful in understanding the issue.

PS: If shp doesn't upload then zip the file before uploading.

Re: Loss of attributes when importing Shapefiles

Anonymous — Tue, 16 May 2017 17:24:27 GMT

I don't have shapefile data to test at the moment, so this is all from memory.

When importing a shapefile, there should be an option to place the line at elevation defined by attribute, then you select what attribute sets the elevation.

The properties your looking at are the geometric properties of the line, what elevation the line physically sits at.

when you import a shapefile with attributes, I THINK, the attributes that come with it are displayed on one of the other tabs of the properties window (Extended Data maybe.)

So, if you poke around the other tabs, and find the elevation attribute with the correct data, but don't have the lines sitting at the right elevation in space, I'd look for the import at elevation option on the import dialog.

Now, if this WAS the answer, I'd expect all contours to come in at 0 elevation. If the data was imported correctly, no idea why only some would be at the proper elevation.

Re: Loss of attributes when importing Shapefiles

jmayo-EE — Tue, 16 May 2017 18:52:23 GMT

https://knowledge.autodesk.com/support/autocad-civil-3d/troubleshooting/caas/sfdcarticles/sfdcarticles/Importing-an-ESRI-shapefile-with-elevation-values-s.html

This workflow is the same as it was before Civil 3D was even thought of.

Re: Loss of attributes when importing Shapefiles

samoh21 — Sun, 21 May 2017 17:15:13 GMT

@jmayo-EE I have used the same work flow,

But the problem it is when i import the shapefiles with the data, not all the attributes comes along wtih the polylines.

i have uploaded the files, maybe you could try.

Re: Loss of attributes when importing Shapefiles

Joe-Bouza — Sun, 21 May 2017 18:06:37 GMT

Are you selecting all the attributes to import?

I'm with Tim. If your end result is a surface, make it directly from gis

Re: Loss of attributes when importing Shapefiles

Joe-Bouza — Sun, 21 May 2017 21:36:13 GMT

I meant Todd. Why do I get you two mixed up?

Re: Loss of attributes when importing Shapefiles

Pointdump — Sun, 21 May 2017 23:38:01 GMT

Samoh,

Your attachment has only the SHP file. Also needed are the SHX, DBF, and PRJ files.

Dave

Re: Loss of attributes when importing Shapefiles

jmayo-EE — Mon, 22 May 2017 13:09:23 GMT

FYI, I also agree w/ a GIS workflow.

With most public data I have used, contours rarely if ever import from a shp file with elev's assigned to the plines and I have always had to run the query (see 2nd part in link above) to assign the contou elev.

Did you perform the query correctly?

Re: Loss of attributes when importing Shapefiles

AllenJessup — Mon, 22 May 2017 13:54:50 GMT

I would think that if some of the attributes are missing. That might be a problem with the original GIS files. If you post the files @Pointdump mentioned. We can confirm that.

Re: Loss of attributes when importing Shapefiles

samoh21 — Tue, 23 May 2017 11:37:05 GMT

Thanks guys,

I should have attached all the files now, its only the xrefs to th SHP.
SHP is attached before.

The contours are in 10x10 km, and have added a dwg with the area of the contours i have problems with.

Re: Loss of attributes when importing Shapefiles

Joe-Bouza — Tue, 23 May 2017 12:54:16 GMT

<>.rar? how bout a regular zip file? I know i'm not downloading a trojan to see what you have.

Re: Loss of attributes when importing Shapefiles

AllenJessup — Tue, 23 May 2017 13:07:50 GMT

@Joe-Bouza

I tried zipping it but It's too large to post. We have goo AV software and it let the RAR past. Up to you if you open it or not.

Re: Loss of attributes when importing Shapefiles

Joe-Bouza — Tue, 23 May 2017 13:54:17 GMT

@AllenJessup are you the OP too? I was responding to the op, I meant no ill, just dont like those sites for down loads.

What does that mean go AV and let rar past?

Re: Loss of attributes when importing Shapefiles

AllenJessup — Tue, 23 May 2017 14:02:23 GMT

@Joe-Bouza wrote:

@AllenJessup are you the OP too?

What does that mean go AV and let rar past?

No. Just trying to help the OP. I noticed that their responses take some time. So I thought I could provide a Zip after "UnZipping" the RAR.

Bad typing. Should be Good Anti-Virus. I decompressed the RAR and the AV had no complaints. It scans every file as it's created. I'm thinking the OP used the RAR format to get past the size limit.

I brought the SHP into a new drawing and tried querying it. But it's been running for a half an hour. So I have to kill it and move on. I'll try again during lunch.

Re: Loss of attributes when importing Shapefiles

AllenJessup — Tue, 23 May 2017 14:35:40 GMT

OK. Now I need to know which Data Field contains the elevation. Looking at them I thought only HOEJDE made sense. But when I query the area within the rectangle defined in your drawing. Every contour has an elevation.

Re: Loss of attributes when importing Shapefiles

tcorey — Tue, 23 May 2017 16:50:00 GMT

I imported your shp file using MapImport (in Civil 3D 2018). I wrote the following code to find any polylines that do not have HOEJDE (elevation) attribute. None were found. This routine also moves your polylines to the elevation captured from the HOEDJE attribute value. You can change the _Tims layer name in the code to whatever you want, but be sure the layer exists before you run the code.

					;find polyline of 0 elevation in attribs or nil HOEJDE on special layer
(vl-load-com)

(defun c:go ( / ccmdecho cmenuecho ls len ctr pl recno z)
  (setq ccmdecho (getvar "CMDECHO")
	cmenuecho (getvar "MENUECHO")
	)
  (setvar "CMDECHO" 0)
  (setvar "MENUECHO" 0)

  (setq	ls  (ssget "x" (List (cons 0 "LWPOLYLINE")))
	len (sslength ls)
	ctr 0
  )
  (while (< ctr len)
    (setq pl	(ssname ls ctr)
	  recno	(ade_odgetrecord pl "REFERENCEKURVE0_25" 0)
	  Z	(ade_odgetrecfield recno "HOEJDE")
    )
    (cond ((= z nil)
	   (vl-cmdf "Change" pl "" "P" "La" "_Tims" "") ;change _Tims to your layer. Be sure it exists.
	   )
	  ((= z 0)
	   (vl-cmdf "Change" pl "" "P" "la" "_Tims" "")
	   )
	  ((> z 0)
	   (vl-cmdf "Change" pl "" "P" "E" z "")
	   )
	  )
    


    
    (setq ctr (1+ ctr))
    (prompt
      (strcat "\n" (rtos ctr 2 0) " polylines processed...")
    )
  )
  (setvar "CMDECHO" ccmdecho)
  (setvar "MENUECHO" cmenuecho)
  (princ)
)

Re: Loss of attributes when importing Shapefiles

Joe-Bouza — Tue, 23 May 2017 17:23:11 GMT

I gotcha.

from lack of response I assume the surface from GIS is not working for some reason?

Re: Loss of attributes when importing Shapefiles

AllenJessup — Tue, 23 May 2017 17:26:18 GMT

Joe-Bouza wrote:

from lack of response I assume the surface from GIS is not working for some reason?

It wouldn't work for me. No idea why. After selecting the SHP file the Next button remained greyed out. Tried three times with the same results.