Here is the general task i am wanting to accomplish. To start, thank you for the help in advance.
I am a AutoCad drafter for telecommunications and I have utility pole points (long/lats)
I can insert the poles via long/lat and all is great, my issue is I would like more information in those points.
For example, pole number, class, HOA, Make Ready...
Currently I create a survey data store and import ASCII Points using PNE(comma delimited)
So with my Excel file (this is where I get my pole information from) I get a point/northing/easting to enter into the formatting section.
I would like to add more information to these individual points, like ploe number, class, HOA...
If I view the point table I see that there are a lot of other columns, can I use them or customize them? is there a quick tutorial on this issue?
I hope I have explained this well, I can also create a sample file if needed.
Thank you for the help.
David Bykerk
Cad Drafter
EA Tech
Solved! Go to Solution.
Solved by Murph_Map. Go to Solution.
Great question, sir. I'd do as follows:
@antoniovinci wrote:Great question, sir. I'd do as follows:
- in Autocad, making _MAPEXPORT of your points to a shape file
- close Autocad
- adding the other fields (class, HOA, Make Ready, and so on) with a shape editor like "Mapwindow GIS"
- close the shape editor
- populating the new empty columns of the shapeset's .DBF file by means of Excel
- close Excel
- in Autocad, making _MAPIMPORT of this populated shape file.
ONLY if they are stili using version 2006 or less. With newer versions there is no need to do that.
@Anonymous wrote:Here is the general task i am wanting to accomplish. To start, thank you for the help in advance.
I am a AutoCad drafter for telecommunications and I have utility pole points (long/lats)
I can insert the poles via long/lat and all is great, my issue is I would like more information in those points.
For example, pole number, class, HOA, Make Ready...
Currently I create a survey data store and import ASCII Points using PNE(comma delimited)
With that data store you cn save that displat layer to sdf format with its own name (which the data store is BTW) then open the sdf schemea and add more properties/fields as needed.
In the Map task pane, map explorer tab, select your sdf layer then click on the schema icon and edit. Expand the tree on the left then click on New Property, provide a name for that field/column and the type should be data, string length as needed.
Thanks for the great replies, FYI, I am using CadMaps 2011, I will try out the solution shortly and respond with a solved or unsolved response.
Thanks Again