topic Re: Add XY data Latitude Category empty upon re using in Mapping Questions

Add XY data Latitude Category empty upon re using

EricOstrowski — Wed, 14 Oct 2015 17:22:19 GMT

Whenever I add XY data from a .CSV file the latitude category disappears when I reopen the .CSV file after uploading more data.

Is there a reason why my latitude category disappears when I try to update my coordinates?

The latitude coordinates are present in the .CSV but the option to choose those latitude coordinates is gone.

Re: Add XY data Latitude Category empty upon re using

DanPatterson_Retired — Wed, 14 Oct 2015 17:34:18 GMT

Check the column... the columns won't be an option if it is represented as text...it may look like a number but it may be formatted as text, and/or the column contains text or blanks

Re: Add XY data Latitude Category empty upon re using

NICOLAPEDDIS — Thu, 15 Oct 2015 14:07:32 GMT

Dan is right, the latitude and the longitude must be formated as number, then you can easly import the csv file in arccatalog or arcmap to trasform the point text in a point feature, and add the z value if is present as formatted a number. If lat and long are not present you wont able to rappresent x, y and z data in arcmap

Re: Add XY data Latitude Category empty upon re using

EricOstrowski — Wed, 21 Oct 2015 18:30:17 GMT

I changed both latitude and longitude columns to number format from general format.

After converting the option to select latitude was still missing.

Re: Add XY data Latitude Category empty upon re using

EricOstrowski — Wed, 21 Oct 2015 18:34:17 GMT

I addition the file does not save the changes from general format to number format.

Re: Add XY data Latitude Category empty upon re using

EricOstrowski — Wed, 21 Oct 2015 18:35:49 GMT

In addition to that*

Re: Add XY data Latitude Category empty upon re using

DanPatterson_Retired — Wed, 21 Oct 2015 18:43:49 GMT

I assume you are creating this file in something like a spreadsheet, hence if the format can't be changed from general to number there is something in the columns (like spaces) or in the cells that prohibits (like saving degrees minutes and seconds in a column)...but this is conjecture until you copy and paste some of the rows in your initial question to show what you are working with.

Re: Add XY data Latitude Category empty upon re using

EricOstrowski — Fri, 06 Nov 2015 18:01:35 GMT

OBJECTID	Address	City	Zip	State	Trap Series	Latitude	Longitude	Pos_7_17	Pos_7_23	Pos_8_4	Pos_8_5	Pos_8_7	Pos_8_10	Pos_8_13	Pos_8_19	Pos_8_26	Pos_8_28	Pos_8_31	Pos_9_08	Pos_9_09	Pos_9_10	Pos_9_15	Pos_9_16	Pos_9_17	Pos_9_18	Pos_9_28	Pos_10_1	Pos_10_8	Pos_10_13	Pos_10_21_15	Pos_11_5_15
35	Santiago Creek & Bike Path	Orange	92866	CA	ET-04	33.77677	-117.851202			1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
36	21510 E Basin Ave, Walnut Drain	Orange	92866	CA	ET-04	33.79456	-117.831225			1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
37	6569 S Kentucky Dr, End of Loretta	Orange	92866	CA	ET-04	33.77736	-117.824821			1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
38	22151 Reneer Ave	Orange	92866	CA	ET-04	33.79639	-117.876153			1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1

Re: Add XY data Latitude Category empty upon re using

EricOstrowski — Fri, 06 Nov 2015 18:04:55 GMT

Here is an example of the formatting of our rows with false addresses. We found and replaced some of the spacing issues in the columns however the problem of the latitude category disappearing still persists when we attempt to re add the xy data from the file.

Re: Add XY data Latitude Category empty upon re using

DarrenWiens2 — Fri, 06 Nov 2015 18:38:23 GMT

Probably not the issue, but your column "Trap Series" has a space in it, which may throw a monkey wrench in the gears.

Re: Add XY data Latitude Category empty upon re using

ChrisDonohue__GISP — Fri, 06 Nov 2015 22:46:01 GMT

A question - is your .csv "live-linked" to your existing spatial data or after adding new data you are importing it as if it was a totally new file?

Chris Donohue, GISP

Re: Add XY data Latitude Category empty upon re using

DanPatterson_Retired — Fri, 06 Nov 2015 23:14:52 GMT

Darren may be on to something with the potential space in the field name before the Lat and Long fields. As a test you could try several things

just export the Lat and Long data to a separate file and see if it imports
move the lat and long fields to the beginning of the file and see if it imports
fix the field name
ensure there are no blank rows of empty values to be on the safe side.

Re: Add XY data Latitude Category empty upon re using

RebeccaStrauch__GISP — Sun, 08 Nov 2015 09:52:24 GMT

in addition to Darren's and Dan's suggestions about formatting, it is possible that the & specifically, and possibly the commas in the address field are causing issues.

To fix the Trap Series field name, change it to TrapSeries or Trap_Series will help. Check other column names for spaces too.

If "live linked" as Chris mentioned, you may need to save your mxd or even close and reopen to get the changes to update. However, if you have to "event theme" from the AddXY set up, you shouldn't have to recreate it, the changes should appear automatically. It may be that if this event is already there, that trying to create a new version is prevented because the csv is locked with the other event table, and therefore would allow it to be created again. I'm not 100% positive about this, but logically I can see this being an issue.

Re: Add XY data Latitude Category empty upon re using

EricOstrowski — Thu, 12 Nov 2015 23:04:19 GMT

Yes it is "live-linked" to existing spatial data.

Re: Add XY data Latitude Category empty upon re using

EricOstrowski — Thu, 12 Nov 2015 23:12:45 GMT

Removing the spaces from the category names and placing the lat & long fields at the beginning of the file solved the issue.