There are a couple of ways around that issue. One is to redefine your point codes, so they all have three-digit codes. Then you can use letters appended to the number codes to indicate strings - for example, if "103" is a "TOE", then your field guys could collect 103A for "TOEA", 103B for "TOEB", etc. Of course, changing codes is undesirable, because your field guys are used to the codes and doubtless have lots of them memorized, so changing them introduces the likelihood of introducing error. And when you get field data with incorrect point codes on some of the points, it can be difficult to find and correct the errors.
The way we got around it is to use a little Perl routine I wrote. Perl is based on SED/AWK from Unix (with lots of C-like functions thrown in), and is a very good language for making any text file look like any other text file. This also lets us continue to use TGO for reducing our field data, which works better for us than fighting Autodesk's survey database. It also means we have no issues with GPS data, since we do all our GPS network stuff in TGO as well (C3D doesn't seem to have the necessary support for GPS site calibration and data reduction).
We also have old-style data collectors, and it's really annoying to use the Note feature in our data collectors to type in survey commands. So the field guys type the linework commands as abbreviations in the point description, along with a numeric point code. Strings are also numeric, and seperated from the point code with a decimal. So, for example, a "3" is a "TOE", and "3.1" is "TOE1", "3.2" is "TOE2", etc. Multiple strings can be joined together by including more than one code, seperated by another decimal point. If "5" is "TOP", then a point with a description of "3.1.5.2" would be added to both the TOE1 figure and the TOP2 figure. (I do this by creating a duplicate point, so one point has the "TOE1" description and the duplicate has the "TOP2" description.) And as long as a string identifier is used, the Perl code will add the necessary BEGIN, END, and CONT statements automatically. The field guys can still type them explicitly, but most of the time they don't have to.
Then, regardless of what equipment the field guys use, they end up creating a CSV dump of their field shots. We then run the CSV through the Perl script, which converts it to a FBK. Then we dump the FBK into C3D.
Not sure how easy it is for others to use. The Lisp routine started out pretty simple, but it rapidly got more-complicated as I added more stuff. I'm attaching a sample of the CSV file our field guys create, along with the FBK that gets created.
And yeah, we're probably going to hire a rod man for the summer, but the position doesn't pay all that well...
Here's a sample. I'm also attaching a PDF with more info. If you want to try it, the Perl script is posted on
our web site.
202,827.905,1214.616,5974.596,25.1
203,828.497,1214.825,5974.116,2.1
204,825.422,1222.957,5974.056,2.1
205,824.989,1222.472,5974.434,25 .1
206,825.649,1223.348,5974.024,2.2
207,825.707,1223.850,5974.447,25.2
208,824.823,1223.698,5974.008,12 CURB CUT
209,865.843,1225.072,5976.021,20
210,861.593,1237.022,5975.666,2.2
211,861.584,1237.631,5976.243,25.2
212,898.527,1251.801,5977.518,25.2
213 ,898.115,1251.189,5977.076,2.2
214,904.160,1234.992,5977.560,2.2
215,904.484,1235.817,5978.059,25.2.2.2
gets turned into this:
BEG TBCC1
NE SS 202 827.905 1214.616 5974.596 "TBCC1"
BEG FLPV1
NE SS 203 828.497 1214.825 5974.116 "FLPV1"
NE SS 204 825.422 1222.957 5974.056 "FLPV1"
CONT TBCC1
NE SS 205 824.989 1222.472 5974.434 "TBCC1"
BEG FLPV2
NE SS 206 825.649 1223.348 5974.024 "FLPV2"
BEG TBCC2
NE SS 207 825.707 1223.850 5974.447 "TBCC2"
END
NE SS 208 824.823 1223.698 5974.008 "CLFEATURE CURB CUT"
NE SS 209 865.843 1225.072 5976.021 "ASPH"
CONT FLPV2
NE SS 210 861.593 1237.022 5975.666 "FLPV2"
CONT TBCC2
NE SS 211 861.584 1237.631 5976.243 "TBCC2"
NE SS 212 898.527 1251.801 5977.518 "TBCC2"
CONT FLPV2
NE SS 213 898.115 1251.189 5977.076 "FLPV2"
NE SS 214 904.160 1234.992 5977.560 "FLPV2"
CONT TBCC2
NE SS 100000 904.484 1235.817 5978.059 "TBCC2"
CONT FLPV2
NE SS 215 904.484 1235.817 5978.059 "FLPV2"