AutoCAD Civil 3D General Discussion

AutoCAD Civil 3D General Discussion

Reply
Valued Mentor
dmartin
Posts: 406
Registered: ‎04-09-2013
Message 1 of 5 (217 Views)

Tips for Resolving Survey Data

217 Views, 4 Replies
09-26-2013 12:05 PM

All,

 

I am curious if any one has any good tips for this.

 

I import multiple CSVs. and I get a duplicate Point# error, so I Resolve. It gives the point a name and no number. How can I have it show me the original point and resolved points in a row so that I can identify wether or not it is a seperate point, or the same point.

 

I am trying to oranize a bunch of data that was collected before I got her that was a little mis-managed as quickly as possible.

Thanks,
Dave

Civil 3D 2013
HP Z400 Workstation
6GB of RAM
296GB HDD
ATI FirePro V5700(FireGL)
Win 7 Home Professional
Please use Kudos Where Deserved



Valued Contributor
MATRIX3DSURVEYS
Posts: 102
Registered: ‎08-18-2005
Message 2 of 5 (175 Views)

Re: Tips for Resolving Survey Data

09-26-2013 06:38 PM in reply to: dmartin

I hate point numbers.  I run projects with upwards of 20 survey crews using equipment from different manufactures and multiple survey methods.  The *.csv file import method is the best method to use.  Forget about the point numbers  and use the description field.  Format the file as  PXYZD.csv and use description keys to identify and sort the information.  On the import menu duplicate point numbers option (use next point number.)

After import apply description keys to put points on the proper layers and generate line work.

 Excel can be used to sort the records and identify duplicates POINT NUMBERS.

1. Process data in the Equipment Manufactures Software so all the capabilities of the instrument can be used. Save processed data in the PXYZD.csv format

 

2. POINT NUMBER  standards for point  numbers: ( If you insist on using point numbers)

CONTROL 1-1000: PRIMARY CONTROL 1-199,  VERTICAL CONTROL 200-299, GPS CONTROL 300-399

TRAVERSE assign blocks of numbers to each crew. CREW 1 1001 - 1999, CREW 2 2000 - 2999 ect.

SIDESHOTS  100000 - 999999

STAKEOUT    1000000 - 99999999

 

3. DESCRIPTION KEY SETS - make sure all crew are using the same code set for both Points and Line work.

 

Jim

Matrix3DSurveys

Valued Mentor
IanMcClain
Posts: 460
Registered: ‎09-29-2008
Message 3 of 5 (143 Views)

Re: Tips for Resolving Survey Data

09-27-2013 11:50 AM in reply to: dmartin

Have you tried using the offset point number option? I haven't had the need to use it in awhile but I have before. If you have multiple files for the same site with oberlapping numbers you could use a different offset for each file, ie +10000 for the first, +20000 for the second, etc.

-Ian McClain
(running C3D 2012 sp4, Win7 64bit, 8GB)
Valued Mentor
dmartin
Posts: 406
Registered: ‎04-09-2013
Message 4 of 5 (135 Views)

Re: Tips for Resolving Survey Data

09-27-2013 12:28 PM in reply to: IanMcClain

I have not, but that may be where I end up going.

Thanks,
Dave

Civil 3D 2013
HP Z400 Workstation
6GB of RAM
296GB HDD
ATI FirePro V5700(FireGL)
Win 7 Home Professional
Please use Kudos Where Deserved



*Expert Elite*
BrianHailey
Posts: 2,850
Registered: ‎04-27-2005
Message 5 of 5 (121 Views)

Re: Tips for Resolving Survey Data

09-27-2013 03:05 PM in reply to: dmartin

In addition to what Jim recommends, I also recommend importing each point file seperately and then putting those points into a point group with the exact same name as the point file. This acts as a sort of "import event".

Brian Hailey
CAD-1.com
My Blog
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!