AutoCAD Map 3D :: Accepted Data Types (DateTime / Geometry)
Jan 7, 2014
We are using SQL Server to store our map data, inside tables that contain non-spatial data. I noticed a couple of things;
(1) Fields in SQL with the "date" data type do not show up in the Map 3D schema. Does Map only accept "datetime"? What do you do if the client only wants to see the date?
(2) Fields in SQL using the "geography" data type become "geometry" data types in Map. Perhaps this isn't a problem. We would like to store lat/long and easting/northing data. Do I need to create separate columns for this or is all this data stored in a single column using the "geometry" data type?
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 have several files that have lost their geometric data that is usually there when they are primitives. This also removes the grips that allow me to resize the objects on the fly. Is there any possible way "apply" new data to these objects without recreating them? Is there a command, an express tool or a lisp routine that can accomplish this?
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.
i need to export Geometry Data (in properties) X,Y,Z coordinates/points from a Sold 3D object into Excel (csv.file) I have tried data extraction (EATTEXT) but it doesn’t pick the points up unless I add points manually.
I am trying to import thousands of pictures into Lightroom as I have a mess of pictures do to a long story...But basically I have probably 30,000 pictures in a bunch of folders that I want to import.
One issue I have found is that I don't want to import TIFF, BMP, GIF, or things like PNG. I really only want jpg files or jpeg files unless I stumble across others in another format I haven't found yet.
Can I set something during the import? I have searched the forums and internet, but haven't found anything that mentions this.
How to clean up a mess like this where I have 30,000 pictures but probably only need 10,000 as there are duplicates upon duplicates due to having to move the pictures around in a hurry as I had a mess in my basement during a storm a couple years ago.
I need to validate my CS6. I have a new computer with windows 7. My original photoshop is CS2 which I have updated to CS4 and now CS6. The new computer doesn't accepted CS2 is there any way I can validate CS6 on it.
I'm trying to add an audio file to a slideshow but Lightroom keeps not recognizing my file as song.
I extracted the audio from a footage that I made with my DSLR (Canon Rebel T4i). I first used VLC encapsuling in WAVE but Lightroom didn't accepted the mp3 file created. I tried to convert to a mp3 file using Format Factory and Media Converter but it didn't work either. Is there any specific encoding for audio files to be accepted as a song on Slideshow module ?
I am using original discs with serial number stickers for CS3 extended and CS4 on a 2008 MBP with 10.8.
Problem1:
While still having CS3 installed, and reinstalling CS4, the correct serial # request of pre upgrade version CS3 was repeatedly rejected. So I removed everything Adobe from HD, ran Adobe cleaner which found nothing.
Problem 2:
Now I am unable to install CS3 as I get "problem with installation, contact Adobe" message.I manually removed everything Adobe related from HD to no avail.
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'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 export only certain types of objects using mapexport? I know you can use EntTypes of "All" or Types" in the MapExport.ini file, but can you specify lines and points? I have experimented to no avail. I have searched for explanations for each entry in the MapExport.ini file in the documentation ...also to no avail.
what are the differences among the surface types we can create?
I see we can use convert to surface command and have a surface made from the object which receives NURBS property. And I see we can command a planar surface, realizing it can't have a NURBS Surface for further changes.
when we thicken the planar surface, the surface goes off then, and it can be no longer selected ! what's going on with this planar surface, what is it for? why does autocad actually got a Planar surface?
At my work we have 2 different departments that uses a different type of simplex font. My department uses the standard simplex font and the other uses a customized simplex font. I need to make prints from the other department and its a burden to them for me to ask them to print out a drawing just because our fonts are different. Is there a way I can print their drawings with their font without it loading the standard font that's on my computer?
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
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.
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.
How to filter multiple object types (here, the swamp, Google, and the docs) and have come up empty handed. I have code that filters out everything except for blocks (INSERT) with a few additional parameters to exclude blocks of a certain name, but I also need to include MULTILEADERS in the selection filter.
Here is the code I have for the INSERT filter:
acTypValAr = New TypedValue() {New TypedValue(DxfCode.Start, "INSERT"), New TypedValue(-4, "<NOT"), _ New TypedValue(2, "BLOCKA,BLOCKB,BLOCKC,BLOCKD"), _ New TypedValue(-4, "NOT>")}
How to add MULTILEADERS to this selection filter as well?
Can I use diferrent types of threads (as variants), in one iPart/iFeature file, ex. M10x1.5 (ISO Metric profile) and G1/8" (ISO Pipe Threads)? Look at the file in attachment and correct it if possible.
I have received some architectural models which were modeled in AutoCAD MEP and only have walls modeled as type Standard. Is there a way to transform Standard walls into cavity walls etc., giving wall makeup as you go - or do I have to re-model in order to get quality 2D cuts?
