Discussion Groups

All Discussion Groups » AutoCAD Civil 3D

Thread: Import Survey Point Attributes


Permlink Replies: 7 - Last Post: Jan 23, 2009 6:21 PM Last Post By: mjfarrell@earth...
caengr@swbell.net

Posts: 1
Registered: 10/17/08
Import Survey Point Attributes
Posted: Dec 30, 2008 3:13 AM
  Click to reply to this thread Reply
I am trying to figure out if there is a way to import point attributes assigned in TDS Survey Pro into Civil 3d 2009. We collect a lot of data for GIS and we are attaching attributes to points collected. For instance for a MH we might have # of pipes, diameter of pipes, material of pipes, etc attached to that point. The attributes are included in the RAW file out of TDS but those attributes are not included in the fieldbook conversion using the included Survey Link. However attribute data IS included in the fieldbooks that are converted by StringerConnect. But civil3d will not import any fieldbooks that I convert with that software. Actually, it will import it but there are no points, figures, etc. I have also tried to import the JOB file through Trimble Link. Trimble Link recognizes the attribute data but will not import it.

Can anyone tell me how we might get this attribute data attached to Civil 3d points? Preferably we would like to have a point with the attribute data attached as object data.

Thanks in advance!
Laurie Comerford
Re: Import Survey Point Attributes
Posted: Dec 30, 2008 6:09 AM   in response to: caengr@swbell.net in response to: caengr@swbell.net
  Click to reply to this thread Reply
Hi caengr,

When you say Civil 3D will not import Fieldbooks - what do you mean?

Are you getting any messages which tell you what is happening?

If you care to send me the fieldbooks I'll have a look and see if I can
advise what it happening.

laurie
dot
comerford
at
westnet
dot
com
dot
au

Regards


Laurie Comerford

caengr@swbell.net wrote:
I am trying to figure out if there is a way to import point attributes
assigned in TDS Survey Pro into Civil 3d 2009. We collect a lot of data
for GIS and we are attaching attributes to points collected. For
instance for a MH we might have # of pipes, diameter of pipes, material
of pipes, etc attached to that point. The attributes are included in the
RAW file out of TDS but those attributes are not included in the
fieldbook conversion using the included Survey Link. However attribute
data IS included in the fieldbooks that are converted by
StringerConnect. But civil3d will not import any fieldbooks that I
convert with that software. Actually, it will import it but there are no
points, figures, etc. I have also tried to import the JOB file through
Trimble Link. Trimble Link recognizes the attribute data but will not
import it. Can anyone tell me how we might get this attribute data
attached to Civil 3d points? Preferably we would like to have a point
with the attribute data attached as object data. Thanks in advance!
Murph
Re: Import Survey Point Attributes
Posted: Dec 30, 2008 1:05 PM   in response to: caengr@swbell.net in response to: caengr@swbell.net
  Click to reply to this thread Reply


If you are after only a point object with Object
Data attached to it, can you save the GPS points as a ESRI SHP file in the TDS
software, then use the MapImport to import the shp file?

 

On another note, seeing this is about GIS
data collected with GPS units, please follow this up though to the
AutoCAD MAP3D team, they are looking for real world cases.


 

 


I
am trying to figure out if there is a way to import point attributes assigned
in TDS Survey Pro into Civil 3d 2009. We collect a lot of data for GIS and we
are attaching attributes to points collected. For instance for a MH we might
have # of pipes, diameter of pipes, material of pipes, etc attached to that
point. The attributes are included in the RAW file out of TDS but those
attributes are not included in the fieldbook conversion using the included
Survey Link. However attribute data IS included in the fieldbooks that are
converted by StringerConnect. But civil3d will not import any fieldbooks that
I convert with that software. Actually, it will import it but there are no
points, figures, etc. I have also tried to import the JOB file through Trimble
Link. Trimble Link recognizes the attribute data but will not import it. Can
anyone tell me how we might get this attribute data attached to Civil 3d
points? Preferably we would like to have a point with the attribute data
attached as object data. Thanks in advance!

civil3dtrimble

Posts: 2
Registered: 01/22/09
Re: Import Survey Point Attributes
Posted: Jan 23, 2009 5:16 AM   in response to: caengr@swbell.net in response to: caengr@swbell.net
  Click to reply to this thread Reply
I am also having issues importing point attributes from survey data. We are using trimble ACU and TSC2 contollers both with GPS and Total stations. It is common survey practice in setout, detail, cadastral, all types of surveys to want attribute information attached in excess of the code. I have spoken with Trimble and with KarelCAD.

If importing through Stringer, it doesnt have enough fields in any import option. Whether I try using a points file or DC file or SDR file or whatever it doesnt matter because stringer just doesnt allow that extra field.

If using trimblelink. It shows the attribute data but then doesnt bring it through either.

I have developed my own method. I make any field edits in the controller. Then I export to a .csv file using one of the .xsl files provided by trimble - eg "comma delimited with notes" or "comma delimited with attributes". None of there are quite right so I need to bring it into excel and make edits like changing null heights to zero and removing the column that has the prompt for the attribute (eg when we pick up a light pole we are asked for the "number" we then type in the number - this is the actual attribute we want which is in the next column). I asked for a .xsl file that doesnt need editing and I was told that only standard ones are provided and we are lucky even to get them. We apparently need to pay someone to code one especially for us. Surely we are not that unique!!!!

eg original information

101,5006.242,2007.885,?,005,005:Description,oip
102,5035.951,1949.908,?,003,003:Description,o.peg
103,4999.971,1999.995,?,003,003:Description,o.peg
104,4963.226,1975.392,?,003,003:Description,o.peg
105,4930.131,1974.393,?,005,005:Description,oip
106,5012.287,1982.765,?,008,008:Description,top of stake
107,5021.056,1970.605,?,008,008:Description,stake

changed to

101,5006.242,2007.885,0,005,oip
102,5035.951,1949.908,0,003,o.peg
103,4999.971,1999.995,0,003,o.peg
104,4963.226,1975.392,0,003,o.peg
105,4930.131,1974.393,0,005,oip
106,5012.287,1982.765,0,008,top of stake
107,5021.056,1970.605,0,008,stake

I created a new point file format in my template to have an extra field PNEZCD

I had to do many things to my templates so that different codes use the extra field in different ways. Usually to do with a point label style that then needs to be put into the description key set. This makes things more automatic.

I then use points import in Civil3D. Things go onto their right layers and use the attribute information that was entered in the field.

I then run stringer which then strings them up and uses the stringer profiles csv that I also had to create for our use, to allocate strings to their correct layers

It would be great if we could automate the allocation of text to strings. eg if it could write "back of kerb" to a back of kerb string or 100 to a 100mm diameter pipe etc.

How are other people achieving the use of their attribute data. I find it hard to belive that other people are happy to import their survey data without being able to use their attribute data.

There must be other trimble Civil3D users out there in the world
mjfarrell@earth...

Posts: 53
Registered: 05/09/05
Re: Import Survey Point Attributes
Posted: Jan 23, 2009 6:43 AM   in response to: civil3dtrimble in response to: civil3dtrimble
  Click to reply to this thread Reply
depending on your data, one can import attributes with points.

we did just this recently, using User Defined Properties, and then used those in the point file import mode.

it brought the attributes right along.
so you might not get them as part of a FBK import, however you can get them as a points import operation
civil3dtrimble

Posts: 2
Registered: 01/22/09
Re: Import Survey Point Attributes
Posted: Jan 23, 2009 7:16 AM   in response to: mjfarrell@earth... in response to: mjfarrell@earth...
  Click to reply to this thread Reply
yes I have already managed to import my attributes as described and used a user defined property for the extra column and then used that in text styles etc to automate procedures. I am disappointed that I had to do it the way I mentioned instead of using stringer or survey database. If I could use survey database then I can retain all my setup information etc for QA purposes and if coming through stringer then I could use the RW5 editor as it is intended but I cant do that and use attributes at the same time. The way I am doing it via a .csv file is dumbing down the original information and using a workaround. It also takes extra steps to remove columns, header and null heights.

Are you working with survey data?
Laurie Comerford
Re: Import Survey Point Attributes
Posted: Jan 23, 2009 7:57 AM   in response to: civil3dtrimble in response to: civil3dtrimble
  Click to reply to this thread Reply
Hi civil3dtrimble,

If you care to send me the data file you extract from Trimble (not a Job
file as they are binary and I can't interpret them) and a drawing
showing how you want data from this file displayed.

i.e. Import the file using the method you use now and add such labelling
data as you want to see (put the hand labelling all on a single layer
for the moment so it is easily identified) and I'll see if anything can
be done to make it easier for you.

Regards


Laurie Comerford

laurie
dot
comerford
at
westnet
dot
com
dot
au

civil3dtrimble wrote:
yes I have already managed to import my attributes as described and used
a user defined property for the extra column and then used that in text
styles etc to automate procedures. I am disappointed that I had to do it
the way I mentioned instead of using stringer or survey database. If I
could use survey database then I can retain all my setup information etc
for QA purposes and if coming through stringer then I could use the RW5
editor as it is intended but I cant do that and use attributes at the
same time. The way I am doing it via a .csv file is dumbing down the
original information and using a workaround. It also takes extra steps
to remove columns, header and null heights. Are you working with survey
data?
mjfarrell@earth...

Posts: 53
Registered: 05/09/05
Re: Import Survey Point Attributes
Posted: Jan 23, 2009 6:21 PM   in response to: civil3dtrimble in response to: civil3dtrimble
  Click to reply to this thread Reply
yes we were using survey data

however after much testing we settled on
using the FBK for as much as we could
using the CSV file to get what we couldn't (the point attributes)

this dispite C3D allowing for nine(9) string characters as part of the Description Key.