can anyone describe, step by step, how to import point data that has Map Object Data also attached to it? I am basically a moron and if someone tells me "import it by attaching to a data source" I will be as clueless as I am now - I need to have my hand held.
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?
My first question would be what format is it in now?
If its a shape file, and you want to import the points, use MAPIMPORT, select the shape file, and in the dialogue box, under 'Data', tell it 'create object data'. You can also specify a layer to put them on, or assign them to blocks.
Yes, the MAPIMPORT of a shp file does exactly what I want to do. I have a drawing going now that I imported 62 separate shp files provided me by a consultant using some other software (not ESRI).
My data is data that I had to supplement what the consultant gave me. The data is in the form of a comma delimited ascii file, or whatever else I can dream up using Excel or Trimble Geomatics Office. TGO does export to a shp file, but the attributes available for export are grossly lacking in choice. furthermore, I only used TGO to try to process my point data in order to get ellipsoid heights based on the coordinate system I am in.
I'm sure that Trimble probably makes an office product, like Pathfinder Office, that will export what I need based on how I collect the data using a Trimble GPS device. But, this doesn't solve my problem now - how to import object data in an ascii file to points with several data fields populated based on what it reads in the ascii file (besides the XYZ insertion point).
thanks for reading and for any input you might have!
You need to st up an ODBC connection and bring the points and data in that way if you want all the attributes. You can use the Civil3D points import also and try to set up a custom format. Then you would need to create the point label style to get all the attributes.
Nice article Murph - I hadn't seen that one.
As a side note Dave, I'm able to export shape files out of TGO with attributes. Its not the best program to work with, but I'm able to get out points with 10-12 attributes attached to it in shp files. Not sure if there's a limit on the amount of attributes it'll export.
Really! Maybe my version of TGO is too old? I have v1.60. Attached is a screen shot that shows my limited attribute options using Export, GIS, ESRI SHp file - points. Maybe I am not doing it correctly?
thanks for your input!
I'm running v1.63, but that shouldn't really matter for this, since I've been doing it since I first got TGO, years ago. When exporting, try selecting the top option 'Arcview shape files - points & lines (.dbf, .shp, .shx). this will send you to a new dialogue box. I select everything on the left side, then hit export. It should give you shape files with attributes.
Access a broad range of knowledge to help get the most out of your products and services.