Drawing lines at angles from xy coordinate

[LauraBlackburn]

I have three fixed points and a number of lines I would like to draw that radiate out from each point.  I have tried to use the bearing distance to line tool but it keeps failing for some reason and I'm not exactly sure how to draw my lines otherwise.  I am using the angle field for the bearing and this is in degrees (I think...the values fall between 0 and 360).  And my distance field is the 20yrSpread field which is in KM.

Any help is greatly appreciated...see the attached table.

[LauraBlackburn]

Richard,

I tried making all those values ones and it still didn't work.  I do completely understand what you are saying, though.

I guess I'll try a few more changes to the table and see what happens.

Laura

[LauraBlackburn]

Thanks to all of your for all of your helpful comments.  It ended up working when I changed the table to a csv file.  I guess Arc 10.3.1 and Excel 2013 don't play nicely together.

Thanks so much for your help - this forum is great for a speedy response to most all of the GIS problems I run into!

Have a great weekend!

[RichardFairhurst]

I suspect when you converted the data to a cvs file ArcMap imports the field names that began with numbers differently.  Also, if you check the output of the Bearing Distance to Line tool the cvs file created I bet the 15yrDisplacement and 20yrSpread field names changed to begin with a letter.

[DanPatterson_Retired]

So in summary...

the tools allows you to work with ill-formed data files without checks for the things that will cause it to crash. 

There are several links on how to work with excel files, which are quite good, unfortunately, the advice therein is not checked by the tool itself. 

And there are a few help file topics

Understanding how to use Microsoft Excel files in ArcGIS—Help | ArcGIS for Desktop

Formatting a table in Microsoft Excel for use in ArcGIS—Help | ArcGIS for Desktop

and several other links elsewhere for the user to search out and explore

[LauraBlackburn]

Arc did allow me to bring the CSV file in with numbers at the beginning of field names, but when that table is exported into a gdb then the field names are changed to include an "F" at the beginning of the numeric field name.

Also, thanks Dan for links.  I'll check into those and try not to create poorly constructed excel files.