nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

adding xy data in from csv file

psiri

Hi,

I am having trouble added xy data for a species occurrences into arcmap. I've successfully done it for 83 species but for these 5, I've been having so much trouble. The x- / y- drop down menu doesn't allow me to click anything (where I should be indicating x-column and y-column). I've tried saving it as .csv, text delimited and tried on different gis documents but it still doesn't work.

The data looks something like this:

SPECIES	POINT_X	POINT_Y
u_malah	431235	112448
u_malah	429814.5	170755.6
u_malah	402839.5	290882.2
u_malah	164366	379005

I'm looking to plot it and then draw a minimum polygon. I'm just not sure if is just me, or if there is something wrong with the data?

Any help would be appreciated greatly!

Find more posts tagged with

Accepted answers

All comments

psiri

It worked! Thanks for ending my frustration!

ISP_graynic

Are you simply using "Add Data" in ArcMap or are you bringing it in through a tool?

You might want to try using the "Excel to table" tool in the ArcToolbox and see if that works. I know we have had issues with X/Y data and using the tool has worked. Just an idea.

psiri

yeah I tried that- still no luck. thanks anyway

DanPatterson_Retired

Well I am looking at your data and indeed there are numbers there, but if what you have posted is correct, they are left justified, meaning the data are being represented as text...right-click on the appropriate field names, bring up the properties and specify numeric....if this isn't the case...never mind

psiri

I used excel, but I have checked that its numeric and there are no extra rows. It still comes up blank.

DanPatterson_Retired

What program was used to produce the data? If it originated in an spreadsheet, ensure that the columns are formatted explicitly to numeric, and that there are now missing entries within the rows...save it as a *.csv file and examine it within a text editor. I have also seen cases where a blank row at the end of the file will make it unreadable by Arc*

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.