AutoCAD Map 3D :: Import Point Data With Object Data?
Jan 20, 2011
how to import point data that has Map Object Data also attached to it? "import it by attaching to a data source".
Example: I have a bunch of manholes. Each MH has X,Y,Z, but also Type, Invert Elevs., Pipe Sizes, Pipe Materials, Pipe Directions, Structure Type/Material, etc. etc. etc. I may have point data representing MH's, airport runway ends, trees, anything you can imagine, with all kinds of data imaginable.
I want to import this data directly into Autocad/Civil 3D as either Autocad points, lines, or closed polylines (I also have utility lines, parking lots, etc.- all with data associated with it), all with the data attached as object data. I know that anything more complex than points might be hard to explain here, so I am hoping at least for a solution on how to import points - I have 99,999 MH's and obviously I don't want to have to type all that data in one by one.
I basically suck at using sql server. I can get around using the Map workspace and the different tabs. I have never used FDO, and I am not even sure what it is.
I fooled it today by creating 99,999 Autocad points at the correct XYZ, attaching the correct object data to them, then exporting as a shp file. I went into the shp_name.dbf file and edited it to add the data I wanted by cutting & pasting from Excel. then I re-imported the shp file. but, this is a workaround at best.
Surely Map can import objects and their associated data fields, all populated with valid data! all I need is to know how to do it. I mean, if this is not something I can do directly using Map commands should I take the money I earned by surveying 99,999 MH's with my GIS data collector that allows me to assign 101data fields to each object I survey, and buy something better?
C3D 2012 on 64bit Win 7 all up to date
Dell Precision 7core 8GB RAM
NVIDIA Quadro FX 1800M
LDT/C3D user since release 12
I have a database of points I am trying to import, and the point data for each point includes a hyperlink. I've created a set of custom User-Defined Property Classifications for all the data types in the point database, and I've created a point file format to use to import the points.
It's a database of existing curb ramps, the data includes things like widths, slopes, some text, and a hyperlink to the Google Streetview at each ramp. I've created a custom point label that will show the data I need to see at each ramp.
All goes great except that the import fails because of the hyperlinks. I've tested it by removing the hyperlinks from a small test portion of the data set, and the test points are then successfully imported. I suppose I can delete the hyperlinks from the entire database, but if there is a way to include the hyperlinks in the point import I would prefer that.
I have collected point data for the positions of trees using PocketGIS software. The software produces a csv. file with the Northings and eastings of each point surveyed to which are attached a number of other attributes (e.g. tree tag number, height, species etc.).
Is it possible to import and plot these points directly into AutoCAD?
Can some or all of the attributes be included (i.e. it would be very useful if the positions could be plotted together with the tag number)?
It was in Feb - March 2012. I was then using AutoCAD Civil 3D 2012. I had faced a problem of getting ground data for a large surface by using satellite imageries processed by some government wing of USA (NASA?), have lost track of it.
I have a drawing with Objects that have both Object Data and Linked data in an Access database. I need to get information from the linked table to a new linked table for each object.
I have thought that if I get the necessary information from the Linked table record to the object data for each object, I could then convert the Object data to a new link and am looking for a way to copy the data from a field in the Linked Table to the object data. There is at least one field common to both the OD and Linked Table record.
In my company, they have just upgraded the old version of Autocad LT 2004 to the new 2013 and we have created menu to make our job easy. I have try to transfer the menu file .mnc to 2013 but it's not working or I don't do it the right way.
I'm working in AutoCAD Map 3D 2008 and Autocad Civil 3D 2009.
The General Task:I want to convert the object data to attribute data so that I can export it to an Excel file, add another column of data, and then import that new data as attribute data.
The Specific Task:I have thousands of campus water meter locations (a block with a small icon, attribute data, and object data) that belong to two different systems, domestic water and lake water. Each of these blocks has object data item (a barcode tag) that I want to show as a label next to the block.
However, before I do that, I want to export that barcode data to an excel file so I add a column (eventually a new piece of attribute data) that says whether or not that specific water meter is radio read or manually read. I want to then import that radio read/manual read excel file back into autocad and have an X appear on the block icon if it is radio read. I also want the barcode information to show up as a label.
My problem:I can't get the barcode object data to export with the locations in one easy excel sheet that I can simply import after I have made my changes.
Find some person on here who knows how to convert object data to attribute data.
When you use the Import Survey Data wizard it automatically creates a point group that goes to the top of the list. This used to be created with a standard point style and description, but something has changed and I'm getting a different symbol and label that I definitely don't want as the default. I would think that this would be controled by the CreatePointGroup settings, but that isn't working for me. I can't find any other settings that would override or control this.
As the heading says - my Map 3d 2011 rearranges object data fields upon import. If I open the coverage in ArcMAP they are in one order (the correct order), and importing to Map mixes that order up. I have around 125 object data fields for each of 2700 objects. Even if the capability existed in Map, rearranging back to the proper order "by hand" is not an option. Is there a setting or something I overlooked that will tell Map to import the data fields in the same order that they are in before the import?
C3D 2012 on 64bit Win 7 all up to date Dell Precision 7core 8GB RAM NVIDIA Quadro FX 1800M LDT/C3D user since release 12
I have centerline data from SHP file that I can either import or attach to. Has a few lines of object data with it including a centerline of road name. Each one unique. When I attach to the data, I can then "join" with it additional data from a database. When I select a line and look at the properties, it contains both the original object data AND the additional data from the database. SO far So good.
When I edit the style and try to add feature labels only part of the labels come in. I end up with a lot of them with only the letters "text" or just not there. If I right-click on the line and select "Show Data Table" I can confirm that there is data for that label. I find nothing in common with the map features that have labels, or don't have labels. Kind of random.
Question: If I import the SHP file and create object data I need to know if there is a way to "ADD" the rest of my data that is in the database to this object data. If so then I think I could define a Template and label each piece with the block with attributes. Is this possible? OR
Is it possible for me to export to a new SHP file after I have connected to the data (both shp file and database).
I'm wanting to use a diffuse colour to alter the iterations in the mesh smooth modifier. I'm using the wire parameters dialogue but am unsure of how to turn the 3 point value of the diffuse (rgb) into linear (1 point) data.
Work Computer - Max 2012, Core i7 3.6, 6GB RAM, ATI FireGL V7700 512MB, Windows 7 64bit Home Computer -BBC Electron with tape player and a copy of creepy cave
when I import PNEZD format .csv using import wizard the coordinates get transformed. all points are shifted about 20' in northing and 5 feet in easting. I have to use the import wizard w/ survey database in order to process linework codes.
I have a master shape file that contains parcel ID, owner, tax info., etc. I have another file ( access 2003 -open to better file format suggestions-) which contains parcel ID and a "yes" or " no" entry for whether or not the parcel needs a new water meter. All I want to do is add the water meter information into the other shape file. This would create one shape file with one table with all the information that I need.
Ultimately I will use the information to do a map query and find out spatially where i need new water meters.
Right now i have the master shape file connected though the “Connect to Data” feature. I also have the new data added to the drawing though the Data sources------>attach under the “Map Explorer” Task pane. I attached access file (ver. 2003 .mdb) which has two columns “Parcel ID” and “Meter”.
I right click on the shape file under the display manager and select”Create a Join;” however my water meter table is not listed as an option. Will this not work?
Plan B - I tried to Create and connect to the access file as an ODBC connection. Followed this guy’s directions to a T [URL]. But when i populate my table under the fdo connection the column headings exist ( “parcel ID” and “Meter”) but the actual data is missing. Am I missing something important?
Note: I am running c3d 2012 on a Win 7 64 Bit machine. I also removed office 32 bit apps and installed 64 bit apps to see if that would solve the problem. No go.
say you make some parcels in your project with custom data fields like: id_no, permit_no, acres_served etc. you attach an agency provided shape file via an fdo connection that has many fields of information like above.
when you right click on your parcel and do parcel properties you get a tab that lets you input the custom parcel data.
lets say you print an fdo map label showing, say, the id_no, provided in the shape file. Then in your custom parcel properties for id_no you type that in.
is there a way to make an expression to put in the other custom parcel properties that will read, say, the permit_no(id_no) from the fdo like and put that information in the custom parcel property field?
I'm having problems getting super elevation data to transfer to different drawings by means of an alignment data shortcut. I know alignments hold the super elevation data so I've gone into my alignments data shortcut, input my super elevation data, saved and closed. Now when I open my finished grade drawing, reference in my alignment and profiles, then create a corridor from that information, my super elevation didn't transfer with the reference.
I pulled cross sections and it appears is has no clue there is any super elevation data. Also, I tried bringing it directly into the drawing I'm doing my corridors in and it erred saying I must be in the parent alignment drawing. Data shortcuts are pretty much useless to me if super elevation data doesn't transfer.
64 bit Windows 7 Intel Xeon (R) @2.8GHz 6.00GB Ram Civil 3D 2012 Civil 3D 2012 Intel(R) Xeon W3530 @ 2.80GHz 6.00GB Ram Windows 7 Professional
I am trying to link my extracted data from blocks with attributes to an extenal source so that the table I create and place into the drawing already has the formulas I need to due the required calculations. But every time I create and place the table the formulas are not in the table. I include the columes that contain the data but it doesn't seem to be working.
i have created a data band in profile view that should show a created profiles elevation, but some of the the data fields are missing irregulary. Also in the data band that shoud show the diferenece betven the tow profiles - EG and the new profile the data is missing. The EG profiles data and the surface are ok all is shown.
I've just installed Civil3D, 64-bit on windows 7(running on bootcamp) and am trying to insert a georeferenced raster image but have encountered some issues.
1. "Home tab>>Data panel>>>insert An Image" - The data panel is missing and it's also not found in "customize palettes"
2. Trying the data connect route does not work either: Display manager>>>Data>>>Connect To Data - There is no 'Data' option and I cannot connect to Data.
Is it possible to embedd data in a table so that a user can select from a group of data within one cell?
I use this technique quite often in Excel. One cell in a table can have various values: A, B, C, or D. While another cell can have a different set of values to choose from: BLUE, RED, ORANGE, or PURPLE. The user can pull down an arrow (similar to a dynamic block) and choose from a set list of values.
I know that the xmls are very important in the design data folder and we shouldn't mess with them.What about the rest of the folders. I have around 11 folders. GOST, AEC Exchange, AIT, Cable & Harness, Bend Tables, DWG-DXF etc...
I need to know if any of these folders can be deleted? We don't use AEC Exchange, Cable Harness, BIm Exchange, Design Accelerator, Tube & Pipe.
What about the Optimisation, DXF-DWG. I am not sure if I am using them unknowingly.Does this could be deleted? Is there a procedure to get rid of them.
Is it possible to add data to a feature data table? Example: The shape file data downloaded from NRCS only has the Soil number for the State. As I check out features I would like to add data for the soil name, soil group, etc. as additional columns in the data table and have it available in the future by checking the feature back in to my local information.
Is there a way to "data shortcut" information imported from a data file into multiple drawings? If so, is there a way to lock the data points "in place" and not be able to adjust the point location/elevation, but allow the movement the text information around within the drawing.
The goal is to have multiple drawings with these data points and be able to move the text information from the style, but not (in a million years) be able to move the data point itself. There may be multiple drawings with these points located within them.
how to show point labels on the points I imported from a .shp file. I used MAPIMPORT and brought in the associated object data but I don't know how to get it to display in my drawing.
I am wondering if it's possible to have a point code automatically add data to a user-defined field either in the survey database or in a drawing. For instance, our surveyors currently will code a catch basin as CB INV2.2 if it has an invert depth of 2.2'. I have a survey point user-defined property called InvertDepth. Is it possible to get the survey database to automatically add 2.2 to that user-defined property or does that have to be manually input? I have an expression and a label style that will take the elevation shot and subtract the depth number to give me the invert elevation on a lable, but I'd like to see if this can be done automatically without having to manually type in the depth on every point that is a catch basin or other inlet.
I've looked into the description key-set's parameters, but they seem to be mostly for display purposes and writing a full description.
I'm working on a topo survey and the contours are crossing each others (See attached pic) and what I did was edit the surface by adding points. I know that these points are fake, but how does this affect the terrain surface for design point of view? I did try swapping edge and deleting lines but makes it worse. Also as you can see in the pic, I don't see the added points like it did back C3D 2008.
I have an excel sheet containing alignment coordinates i.e
Station Number Northings Eastings and Tangential Direction
I wanted to export these into Civil 3d so that I can work with the info. What format would I save my excel document? is it 'text (tab delimited)' or 'csv (comma delimited) or formatted text (space delimited)?
I've tried all the above but I keep getting an error message from AutoCAD that point files not in right format
2012 SP2. I get this very descriptive message while trying to create a point cloud: The following error occurred processing the point cloud data: An error ocurred in data processing.
I've previously created point clouds from the same data (ENZ comma delimited) without a problem. I believe this was done before applying SP2. Any problems creating point clouds since SP2?
