shashidharga Posted February 26, 2013 Share Posted February 26, 2013 Hi friends, I've a map of an area, which has more than 50 streets and I want to name the streets from the excel work sheet. The streets are polylines. I want to show the street names on the polylines. I've no knowlwdge of programming. Thanx in advance, Shashi Quote Link to comment Share on other sites More sharing options...
Organic Posted February 26, 2013 Share Posted February 26, 2013 How does each polyline know whether it is supposed to be Smith Street, john Street or something else? If it is only 50, I would just manually do it. Quote Link to comment Share on other sites More sharing options...
MSasu Posted February 26, 2013 Share Posted February 26, 2013 Which is the correlation between the data from Excel and the said polylines? Can you post an excerpt of data from Excel? Quote Link to comment Share on other sites More sharing options...
shashidharga Posted February 26, 2013 Author Share Posted February 26, 2013 Thanx for the reply. I've street names as data in a table (excel). Want to attach these street names to streets (polylines on the map). So that tha street names are displayed over the polylines. shashi Quote Link to comment Share on other sites More sharing options...
MSasu Posted February 26, 2013 Share Posted February 26, 2013 We already understood that; what is missing is how the data in Excel is linked with the items from AutoCAD drawing. Quote Link to comment Share on other sites More sharing options...
shashidharga Posted February 26, 2013 Author Share Posted February 26, 2013 OK.... I've data (street names) in excel sheet and I don't know how to connect it to autocad to display above the polylines (streets). Like annotation or fields or labels. shashi Quote Link to comment Share on other sites More sharing options...
shashidharga Posted February 26, 2013 Author Share Posted February 26, 2013 Thanx for the reply organic... I've mentioned here 50 as an example. In my map I've 3 Districts, each district has 8 to 12 talukas, each talukas have more than 200 different streets. shashi Quote Link to comment Share on other sites More sharing options...
MSasu Posted February 26, 2013 Share Posted February 26, 2013 I’m sorry, but I’m afraid you didn’t understood me. You have an AutoCAD drawing that contains a bunch of polylines representing some streets. Also, you have an Excel worksheet filled with the names of the said streets. What you need to provide is the rule that exists to link each of those names with the corresponding polyline. By "rule" I mean, do you have a coordinate along each name (a point that reside on the corresponding polyline or close it)? Or there is a parsing rule of the Excel table vs. the sketch? Based on this information someone will be able to suggest a solution. Again, an excerpt of data may help a lot. Quote Link to comment Share on other sites More sharing options...
shashidharga Posted February 26, 2013 Author Share Posted February 26, 2013 Thanx again for your detailed reply. There is no cordinate details or specific rule or relation. I want to place these text from the database to the autocad. shashi Quote Link to comment Share on other sites More sharing options...
MSasu Posted February 26, 2013 Share Posted February 26, 2013 If there is no rule that you can follow to link the names with the corresponding polylines, then I really don't see any automation solution for your issue. Sorry! Quote Link to comment Share on other sites More sharing options...
Murph_map Posted February 26, 2013 Share Posted February 26, 2013 Shashidharga, Where or how did you get the dwg/map and the street name file? If they came from a GIS package you may be able to import/data connect to them with Map3D and it will label them for you. Quote Link to comment Share on other sites More sharing options...
shashidharga Posted February 26, 2013 Author Share Posted February 26, 2013 Hi murph_map.... The map I got it as dgn file with data attached to it as oracle database. But I've only the map and the excel copy of the road attributes. I want name the streets like in the Google map. shashi Quote Link to comment Share on other sites More sharing options...
BIGAL Posted February 26, 2013 Share Posted February 26, 2013 We do stuff every day with maps from our GIS you need to go back to the DGN guys and ask if they have street names as a dgn. Else use google map insert a image under and use it as a guide for the street name location. You will have to do manually. You will find all maps start life as a manual input at some point some one has to create it initally, about the only automation available would be to bring up a street name and then ask where to put in dwg. The big question why are you doing this? Quote Link to comment Share on other sites More sharing options...
shashidharga Posted February 27, 2013 Author Share Posted February 27, 2013 Hi Bigal.. I want to take the plot of all the taluk maps on an A1 or A0 size Paper and submit to the higer authorities to takeup the road construction/maintanance activity of road networks. Each taluk has got 150 to 200 roads/streets. To locate these streets, naming streets on the map is necessary to quickly find or identify the streets. shashi Quote Link to comment Share on other sites More sharing options...
BIGAL Posted February 27, 2013 Share Posted February 27, 2013 Still go back to source you need to go back to the DGN guys and ask if they have street names as a dgn Get DGN again but with Street names also. Quote Link to comment Share on other sites More sharing options...
shashidharga Posted February 27, 2013 Author Share Posted February 27, 2013 Thanx Bigal, I'l try to collect the data from source and get back to you. shashi Quote Link to comment Share on other sites More sharing options...
shashidharga Posted February 27, 2013 Author Share Posted February 27, 2013 Hi Bigal & Murph .. How about this "Auto field" http://www.cadig.com/products/autocad-field.php Is there any thing like this to insert names from excel (free) shashi Quote Link to comment Share on other sites More sharing options...
Murph_map Posted February 28, 2013 Share Posted February 28, 2013 Hi Bigal & Murph ..How about this "Auto field" http://www.cadig.com/products/autocad-field.php Is there any thing like this to insert names from excel (free) shashi FREE, not that I know of. If you ask the source to save the dgn to ESRI shp files with the street names attached then you can import that into AutoCAD Map3d and it will lable all the streets for you. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.