AutoCad :: Extract Coordinate Data

Jan 23, 2013

I work in a manufacturing facility and we are trying to come up with a way to extract data from an AutoCAD file in to a .KML or .CSV file which gives coordinate points, etc.

This will be used in a mapping-type software to display/highlight areas of the plant with zooming capabilities and information shown on the left-side. We are trying to make it look something like Google Maps, so it can used to determine areas of the plant undergoing work, lighting zones, etc.

In a nutshell, I want to be able to extract coordinate data from our layout(s) which can used to pinpoint locations on the map and highlight regions, etc. Perhaps it could export data in to Excel with attributes assigned to the coordinates which give Area, Bay Location, etc. The initial thought was to somehow export this to a .KML file and use that as a starting point.

View 2 Replies


ADVERTISEMENT

AutoCAD Inventor :: Edit / Extract 3D Coordinate After Excel XYZ Upload

May 9, 2013

I'm doing some work with routed tubing at the moment using the Excel XYZ upload facility with auto-bend enabled and it works great. What I would like to know is if there is a way to edit an individual intersect point after the 3D line has been created? I've tried myself but can only movethe complete line, (all coordinates).

I would also like to know if it is possible to extract all XYZ intersect points back to excel or a table within Inventor so I could use the data with a CNC bending machine? Even displaying all coodrinates on the screen at once would be useful.

A working example would be as follows..., I will upload the customers XYZ data to create a 3D line, modifiy specific intersect points to simplify manufacturing and then extract the new co-ordinates to be used for prototyping purposes.

View 1 Replies View Related

AutoCAD Civil 3D :: Data And Different Coordinate Systems

Aug 1, 2012

I have a problem with different coordinate systems. I have a drawing in old Finnish coordinate system (KKJ, kaista 4) and I have a point file, which is made in ETRS-GK29 coordinate system. When I try to transfer the points to the drawing, the points will land way off from the drawing or I get this error message "Coordinate transformation from ETRF89.FinlandGK-29 to FINL-KKJ4 failed for point located at {29511662.554000,6948599.365000}. This usually indicates the point falls outside the boundaries of the destination coordinate system". I have checked and the point {29511662.554000,6948599.365000} should be over the drawing.

View 3 Replies View Related

AutoCAD Civil 3D :: Data Referencing And Coordinate Transformations

Aug 10, 2012

I have 50+ project sites scattered along a 600+ mile alignment.  My alignment reference drawing coordinate system is set to a UTM coordinate system.  My project site drawings are set to state plane coordinate systems.  Does coordinate transformation automatically occur with data references?

View 1 Replies View Related

AutoCAD 2010 :: ASCII File With XYZ Coordinate Data

Nov 22, 2011

I have a .PTS file (an ASCII file with XYZ coordinate data + two additional sets of info per point). Is there any way to bring this into AutoCAD natively?

View 7 Replies View Related

AutoCAD Map 3D :: Coordinate System Transformation On ASCII Data

Mar 22, 2011

I have acsii data that I need to add to a map. My coordinate system for the map is CANA83-3TM114

The coordinate system for the ascii points are unknown. How do I transform the data to the same coordinate system as my map?

View 3 Replies View Related

AutoCAD Civil 3D :: Create Point From Coordinate And Elevation Data

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

AutoCAD Civil 3D :: Using Transform Coordinate System And Data Shortcuts?

Mar 21, 2012

We are starting a project that we will be preparing a site grading plan for.We are being provided with an ALTA Survey drawing that is on state plane coordinate system, and the existing topography that I will be using for my existing surface is on a UTM coordinate system.

The site grading plan needs to be on state plane coordinate system that the ALTA Survey drawing is on.

I haven't done it before but I understand you can use Map 3D and take drawings that are on different coordinate systems and have them line up properly.

If I have my existing surface in a UTM coordinate system and want to data shortcut it into my site grading plan that's on state plane coordinates, will that work?

View 9 Replies View Related

AutoCad 3D :: Extract Data From 3D Object

May 27, 2011

is there any way to use data extraction and get the dimensions of the solid. Using dynamic blocks on 3d solid is not an option as far as i know. I tried using block with attributes and field which refer to a dimension line but it's too complicated and takes far more time than just check them by hand.

View 0 Replies View Related

AutoCad :: How To Extract Data In A Viewport

Oct 31, 2012

I have tried this question before but it is now becomming a little more urgent. I would like to extract data I can see in a viewport then add it to the data it finds in the paperspace of the sheet. I don't want the entire drawing (modelspace) just what is seen in the viewport. Then do this process again and so on. 1 excel sheet per 1 sheet.

View 1 Replies View Related

AutoCAD Civil 3D :: SHP File Data Connect Imports To Wrong Coordinate System

Jul 11, 2013

When the attached shape file (change soilmu_a_a.txt to .shp) is imported using MAPIMPORT the data aligns with other imported georeferenced raster imagery (said imagery was imported using the MAPIINSERT command).  If the same shape file is imported using the data connect tool it shows up in a much different location (see word document).

The drawing coordinate system code is "UTM83-18F" and the data was downloaded from the Web Soil Survey's data download with the identical coordinate system (see attached readme.txt).

I prefer to use the data connect option when importing this type of shape file because I can label them all using a theme and use stylize the data for visualization/presentation.

As an aside, I have found that data connect does not automatically transform data coordinate systems to match your drawing coordinate system as advertised.  I've used the edit coordinate system to no avail; however, again when the file is imported using MAPIMPORT and saved as a drawing (with native data coordinate system) and then that drawing is queried from a drawing in a different coordinate system it seems to transform the coordinate system just fine.  Is this a problem with data connect?

View 7 Replies View Related

AutoCAD 2013 :: Extract Data From Excel To Field

Feb 2, 2013

I enter data into an Excel job setup worksheet. I then want to be able to extract data from given cells in the Excel worksheet, and have this become fields in AutoCAD. I do not want to use a table in AutoCAD - I want (ideally) to have the Excel data come in to AutoCAD as a field. I can see that Data Links tends to come in only to a table in AutoCAD. 

View 1 Replies View Related

AutoCAD Inventor :: ILogic Extract Data From String (CSV)?

May 9, 2013

Seeing this error

Error on Line 10 : 'SealString_1' is not declared. It may be inaccessible due to its protection level.
 
Dim SealString_1 As String Dim SealString_2 As String Dim SealString_3 As String Dim SealString_4 As String Dim SealString_5 As String Dim SealString_6 As String Dim SealString_7 As String For Each S As String In SealString_1.Split(",") If i = 0 Then name = S If i = 1 Then name = OD If i = 2 Then name = ID If i = 3 Then name = DE If i = 4 Then name = LI i = i + 1 Next S

View 1 Replies View Related

AutoCAD .NET :: Title Block - Extract Data From Drawing

Jun 18, 2012

I need to extract data from AutoCad Drawing using C# or VB.Net.

I have a Title Block which is not inserted using attributes. It has some horizontal & vertical lines drawn  to look like a table and text added between them. See the attchment.

I need to extract data from that and display in Ms-Excel or in a datagridview.

View 9 Replies View Related

AutoCAD Visual LISP / AutoLISP :: Extract Data From DXF File?

Oct 6, 2011

I am trying to write a lisp file that extracts the LAYER, Z, X, Y, TEXT HEIGHT, POINT NUMBER, from the attached DXF file. Ultimately I will have the lisp insert a "POINT" at the X,Y,Z, cords, and then a "TEXT" entity at the same coordinates with the text height value and the point number string. Both entities need to be on the layer ending in  "-PN". The layer name will change depending on the date. I have a third party program that creates the DXF file.

The point of the lisp file is to insert the point numbers and points into my drawing at their correct locations. For the life of me I can not make this work. I have attached the little bit of lisp I have, which unfortunately does not work properly because of it searching for the "TEXT" entry in the DXF file of which there are three per point number. I only need one. I have also attached the DXF file I have. maybe just an overall procedure that I can then code myself? I'm just not good at getting lisp to read a file and extract what I want from it.

View 4 Replies View Related

AutoCAD Inventor :: Extract CNC Data For Bending Of Structural Tube

Aug 15, 2013

Is there a method of extracting XYZ data to use for CNC tube bending from components developed in frame generator ? I know that in routed systems you can export that data, but can the same thing be done with frame generator or any individual bent tube or pipe part?

View 4 Replies View Related

AutoCAD Visual LISP / AutoLISP :: Extract Point Data

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

AutoCad :: Extract Data To Excel Without Replacing Document Header

May 17, 2013

I have an excel document with a document header reserving rows 1-12. When i use "extract data" in autocad, i don't want the excel header to disappear. Can i set another cell than A1 to be the starting cell in Excel? Or how do i keep the header in the document?

View 5 Replies View Related

GIMP :: How To Extract RGB Pixel Data From JPG

Dec 7, 2011

I am trying to take a jpg file of an image, and write each RGB pixel color's value into a 3 component integer vector corresponding to the RGB components of the color for that pixel. For each pixel in the jpg, I wish to write the corresponding 3 by 1 integer vector into a matrix after which I plan to do a SVD decomposition of the newly constructed matrix to do an image analysis.

Any plug-in that allows one to efficiently iterate through each pixel in a jpg, and convert the pixel data to a RGB integer vector, and say write to a file?

Specific Details: I am using gimp 2.6 as my image editor, and wish to collect all the RGB 3 by 1 integer vectors (where each 3 by 1 integer vector corresponds to RGB color of exactly one pixel in the jpg image) into a matrix of integer so that I can do a reduced SVD decomposition of that matrix to analyse the pixel data: I wish to compare two similar images by using the SVD decomposition of integer matrices corresponding to the two images saved as jpg files pic1.jpg and pic2.jpg.

View 4 Replies View Related

AutoCAD Civil 3D :: Import Data Wizard - Coordinate Transformation On Import?

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

InDesign :: Extract The Data From Tracking / Story Editor Outside?

Feb 20, 2014

Can you extract the data from tracking/story editor outside of InDesign?  I do a large catalogue and want a way to identify which product sets had changes made to them or not, but not just within story editor, but download the data to say a txt file or excel, etc.

View 4 Replies View Related

AutoCad :: Image Set In One Coordinate System Into A Drawing In Another Coordinate System

Mar 14, 2012

how do i get an image set in one coordinate system come into a drawing in another coordinate system?

View 3 Replies View Related

AutoCAD VB :: OCS Coordinate System Of Block To UCS Or WCS Coordinate System?

May 28, 2012

I want to know how to transform OCS Coordinate of A block object to UCS or WCS Coordinate .

It's Block's OCS   Coordinate  not other objects.

View 7 Replies View Related

AutoCAD Civil 3D :: Combining Feature Data (Adding Data To Shape File)

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

AutoCAD Civil 3D :: Use FDO Data To Populate Custom Data Field Expression

Apr 10, 2013

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?

View 4 Replies View Related

AutoCAD Civil 3D :: Data Shortcuts Transferring Super Elevation Data

Jun 7, 2012

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

View 2 Replies View Related

AutoCad :: Performing Data Extraction And Linking To External Data With Formulas

Apr 19, 2012

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.

View 2 Replies View Related

AutoCAD Civil 3D :: Missing Data From Profile View Vertical Geometry Data Bands?

Sep 9, 2011

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.

View 4 Replies View Related

AutoCAD Civil 3D :: Data Panel Is Missing / Data Connect Route Doesn't Work

May 3, 2013

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.

View 1 Replies View Related

AutoCAD 2013 :: Embed Data In Table So That User Can Select From Group Of Data Within One Cell?

Oct 24, 2013

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.

View 2 Replies View Related

AutoCAD Inventor :: Unwanted Data In Design Data Folder

Oct 12, 2011

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.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved