AutoCad :: Import CSV File - Point Data
Jul 5, 2010
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)?
View 9 Replies
ADVERTISEMENT
Jan 17, 2013
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.
Win 7E 64-bit, Intel i7, 12 GB
C3D 2012
View 6 Replies
View Related
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
View 9 Replies
View Related
Jul 12, 2012
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.
View 6 Replies
View Related
May 3, 2012
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.
(running C3D 2012 sp4, Win7 64bit, 8GB)
View 9 Replies
View Related
Jan 2, 2013
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.
View 7 Replies
View Related
Dec 9, 2011
Any (simple) raw point cloud data file.
View 2 Replies
View Related
Jul 16, 2013
I'm hoping this could be a quick fix without completely reinstalling CAD.
I jammed too much LiDAR data into my Index file for point cloud data, and now I can not even open it. Even new drawings are trying to open the overall index with everything in it.
What I want to do is just delete the whole thing and start fresh again, but not sure how to do that. If I could open it once I could start deleting stuff from it, but it is too large to even open.
View 1 Replies
View Related
Oct 17, 2011
I'm relatively new to AutCAD map 3d but I've used arcGIS a while back.
I have existing roads, towns etc data that are already set to UTM 17. I want to import ascii point coordinates (from a comma delimited file) into the file. I can import the ascii coordinates as points fine (easting and northing), however the points come in as the absolute coordinates rather than geometric coordinates. I already set the files for right geographic projections. Beyond manually inputing the coordinates into the coordinate tracker, is there a way to import the coordinates form the file set for the geometric coordinates?
View 2 Replies
View Related
Nov 24, 2012
I'm using Map 3D 2012 with Oracle 11g. I created an enterprise project with an industry model with water and wastewater modules. After this i created my feature classes and defined the utility model linking the geometry feature class to the attribute ones (ex: WA_POINT to WA_ARMATURE, WA_VALVE, WA_HYDRANT etc.).
At this moment i have to import a large amount of data from *.shp or *.sdf files, but theese files contain geometric and attribute data together.
How can i import the geometry from the shp or sdf file to the geometry feature class (ex: WA_POINT) and the attributes to the attribute feature class (ex: WA_VALVE), while creating the reference between the geometry and attribute feature classes?
I tried bulk-copying the geometry, but it doesn't create the coresponding attribute feature.
View 2 Replies
View Related
Aug 20, 2012
I am importing survey data using a .txt file. In that file there are a few lines that I don't want C3D to read. Is there some character I can put at the beginning of the line so that it won't read or give me an error? In some other programs I have seen # or : used to do this.
C3D 2012 sp1
W7Pro 64bit
HP Z400 Workstation
16 GB RAM
Intel Xeon CPU W3565@3.20GHz
NVIDIA Quadro 4000
View 4 Replies
View Related
Jul 3, 2012
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).
View 2 Replies
View Related
May 6, 2008
I had to re install Adobe Photoshop CS3 Extend but now every time I try to start it, it errors out withe the following:
"Could not load the user measurement data point presets file because the file name was not valid."
and "Could not load the user measurement scale presets file because the file name was not valid."
View 2 Replies
View Related
Apr 12, 2012
I have a bunch (hundreds, so manual input not an option) of X,Y points without elevation data that I would like to import into a DWG and assign an elevation that is based on an existing surface object. Is there a way to do this for a point file? The command for inserting individual points would be the "Create points - Surface > Random" but I don't see a way to do this in a batch type method where i have my PNE formatted input file to just move the points to sit on the existing surface.
View 2 Replies
View Related
Feb 6, 2014
I have a very large excel file with a list of companies in this format:
company_category company_name company_description telephone email
In InDesign I have paragraph style for each one but I need a solution to import all this data and apply the styles automatically.
Few things:
- I don't want to import all these into a table. I want all the info in a 3 text columns format that will run accros 150 pages (more or less)
- I'm using InDesign CS6
Is there any way to automate this?
View 2 Replies
View Related
Mar 12, 2014
First i got a big Adobe InDesign File where I already have designed a catalog. It's made through tables.
It looks like this:
So here's my problem. The article numbers are already filled in. And I have a .csv file with 3 different colums. Art.Number, StandardPrice, DaliPrice It looks like this:
So now i want to import only the prices from this file, because the article numbers are already filled in. If i try to import the .csv file through data merge --> create merged document i am not able to choose this field which i marked blue (dataset). I don't know why... maybe i have to format my csv file different?
And also if i try to show the preview it only takes the data from the first line in my csv file. So somehow i have to merge the fields from the csv file with the article number which is already in my indesign file.
All those fields who look like this------>
are from an plugin which is calls easy catalog... but i think i won't need this plugin... i am sure it's also possible with data merge.
View 3 Replies
View Related
May 18, 2011
We are trying to import Point Cloud files having extension .fls into Revit 2012 but are unable to do so. We have attached the screen shots of the messages that we are getting while importing. We have the trial version of Revit Architecture 2012 and need to import the files so that we can convert them to rvt files...
View 9 Replies
View Related
Aug 26, 2011
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
View 2 Replies
View Related
Mar 3, 2013
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.
View 5 Replies
View Related
Apr 24, 2012
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.
View 3 Replies
View Related
Feb 13, 2012
I have been taking data using an EDM and names all of the points. Once I export it to autoCAD as a dxf file, im struggling to find the point data.
View 2 Replies
View Related
Apr 16, 2012
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.
View 4 Replies
View Related
Jul 5, 2012
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.
View 6 Replies
View Related
Feb 11, 2013
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.
View 5 Replies
View Related
Apr 15, 2012
how I can export the nested data of Cogo Points. I need to get them into a spreadsheet.
I have tried exporting a .shp file and opening the .dbf file in excel, however, it only seems to export the data field of the table and not the value.
View 9 Replies
View Related
Jul 4, 2013
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
NB: Am using MS Office 2010
View 1 Replies
View Related
Jul 28, 2012
Is there anyway to create a point from the coordinate and elevation data listed in a section inquiry panel (see attached)?
View 3 Replies
View Related
Jul 10, 2012
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?
View 1 Replies
View Related
Sep 18, 2000
I would like a lisp routine that can extract and export the x, y, z coordinates of all the points in a drawing into a text file so I can use the same in excel.
View 9 Replies
View Related
Nov 19, 2012
I am trying to speak 'surveyor' without the background in the data collectors. We have a new surveyor who uses Terramodel. I have an LDD parcel database that the surveyor is requesting to be translated to points for stakeout.
I can export the parcels to xml and Terramodel will import them, but it seems to import them as lines. The Surveyor wants points to be able to do a map check in Terra Model and program the data collector. I am not seeing a create points from parcel function anywhere from 2004 to 2012.
View 4 Replies
View Related
Jun 13, 2012
I am looking for some good article/location on creating acad plugins for using point cloud data.
View 3 Replies
View Related
