topic Re: MakeXYEventLayer Issues with .csv in Python Questions

MakeXYEventLayer Issues with .csv

KarlRoth — Wed, 16 Apr 2014 19:37:25 GMT

Hello!

I have been working on plotting points on to a world map using latitude longitude coordinates in a .csv file, but they are always plotted in the wrong location.

Here is my code:

arcpy.MakeXYEventLayer_management('C:/FilePath.../SafeCastData.csv',"Latitude","Longitude","TestPlot",
[INDENT][INDENT][INDENT]u'GeographicCoordinateSystem/World/WGS 1984',"Value")[/INDENT] [/INDENT][/INDENT]

This plots them all at the south pole in the World Topology Basemap.

What Works:
Creating a geodatabase, importing csv file into a table, adding data to ArcMAP table of contents, and clicking Display XY... with all of the same settings as above.

Why does using a geodatabase work, but not a csv file? I really need a way to work on the file directly in the python code, and not through ArcMAP.

Thanks in advance!

Re: MakeXYEventLayer Issues with .csv

AmyKlug — Wed, 16 Apr 2014 21:14:01 GMT

Try switching positions. Longitude is your X and latitude is your Y

Re: MakeXYEventLayer Issues with .csv

KarlRoth — Fri, 18 Apr 2014 00:11:19 GMT

Great, Thanks! Now I am able to plot my data, but my PointToRaster_conversion() function is not showing up, and it is displaying the wrong values in the table of contents.

Displays values 3.40282e-038- 3.40282e+038 (I assume that's the max and min values allowed!)

My actual value range is from 20-40

I checked the attribute table of my point feature class, and all of the "Values" look fine...
Any idea what's going on here?

Re: MakeXYEventLayer Issues with .csv

KarlRoth — Fri, 18 Apr 2014 00:13:44 GMT

Sorry I thought I added that part of the code. Here is my point to raster conversion:

arcpy.PointToRaster_conversion(feature class name, "Value", out data name, "MEAN", "Vaule", 10000)

Thanks!

Re: MakeXYEventLayer Issues with .csv

IanMurray — Fri, 18 Apr 2014 16:13:15 GMT

Karl,

I'm not sure this is the problem, but I thought it was worth point out.

arcpy.PointToRaster_conversion(feature class name, "Value", out data name, "MEAN", "Vaule", 10000)

First you have a syntax error I'm assuming "Vaule" should be "Value".

Secondly, the 5th parameter, which is priority field should only be used when you use the MOST_FREQUENT cell assignment(4th parameter). It should probably left just a blank string when you use "Mean" cell assignment. This may or may not have anything to do with you getting the wrong values.

arcpy.PointToRaster_conversion(feature class name, "Value", out data name, "MEAN", "", 10000)

Re: MakeXYEventLayer Issues with .csv

KarlRoth — Fri, 18 Apr 2014 22:08:45 GMT

Ian,

I tried all that, and it still didn't work. I can only get PointToRaster to work if I first use Display XY Data on a geodatabase, but both methods (Display XY Data and MakeXYEventLayer) create a multipoint feature class. What's going on here?

The weird thing is that I'm not getting any error messages. Just no output.

Re: MakeXYEventLayer Issues with .csv

AmyKlug — Mon, 21 Apr 2014 16:09:47 GMT

Does it work using the point to raster geoprocessing tool?