State GIS Shape file error

[akeyXHWHT]

I have a contour shape file I created in QGIS from New York State GIS data.  I have used the method before that has been well described in this forum in the past.

1) Map import the shape file

2) Open a new drawing and query the elevation object data from the first drawing using the Mapwspace tool.

3)  Tell it which object data is the elevation and execute and then all your polylines have their elevation changed to the object data elevation for each line.

4) Create your surface from there and proceed as necessary.

This has worked several times for me in the past.

Howerever, this time the process fails because instead of the elevation of the object data being a just a number in that database cell, it's a number then ft after.  So mapimport can't create a surface from GIS data because it doesn't understand the elevation data.  And the mapwspace query doesn't work either for the same reason.

So I tried to edit the database dbf file directly with open office calc, as many people on this forum have already described.  I can open the database and remove "ft" from all the cells so the elevation column is just the number, but when I try to save the file I get an error that the shape length column has cells with more than 19 digits and 15 digits after the decimal.  Even if I try to format that column so it is less than 19 characters I still get an error and it won't let me save.

If I try to open the data base in excel and make the change, civil 3d shows an error that the database is corrupt or the entries in the dbf file don't match the shp file.

Any ideas?

[akeyXHWHT]

You’re welcome.  I’m always impressed how helpful and no nonsense this forum is. 

[ChicagoLooper]

---

@Pointdump wrote:

I didn't have any problem editing the ELEVATION Field. 

---

(Regarding post #15......)

OK. I tried again and I am now able to change Elevation field from Character to Integer.  I don’t why Name was editable and Elevation wasn’t. 

[Pointdump]

@ChicagoLooper,
"I don’t why Name was editable and Elevation wasn’t."
Betcha I know why. It seems only able to do one edit at a time. Doing both at the same time, one doesn't "take".
Dave

[ChicagoLooper]

Hmmm.........still odd. The only reason why I ended up editing Name to integer was due to Elevation not being editable. Never tried doing both at the same time...never occurred to me to do both at same time. I was ready to try Global Mapper but threw a Hail Mary to Name instead. 🤔 

[АлексЮстасу]

CADaSchtroumpf improved OD2DXF38.lsp - moving objects to height based on the OD field value.
Now not only Polylines rise, but also Lines.