topic Re: ArcGIS10.0-PythonWindow:Make XY Event Layer- .csv & WGS 1984: Errors 000622 & 000 in Python Questions

ArcGIS10.0-PythonWindow:Make XY Event Layer- .csv & WGS 1984: Errors 000622 & 000628?

ScottChang — Tue, 16 Oct 2012 11:23:55 GMT

Hi all,
In the Excel 2007, I created a .csv file of the XY-coordinates for 10 points of my sampling locations at Edgewood, Maryland - see the attached file. In the Python Window of my ArcGIS 10.0, I executed the following Python script:

>>> # scMakeXYlayer.py   for 12 points  Just X- & Y-coord, but no Z-coord in the csv & the .py file
... # Description: Creates an XY layer and exports it to a layer file
... # Author: ESRI - modified by Scott Chang per Chris Thompson's New No-Z (Date:  16 Oct 2012)
... # import system modules 
... import arcpy
... from arcpy import env
... # Set environment settings
... env.workspace = 'C:\TEMP\BS_Test.gdb'
...  
... try:
...     # Set the local variables
...     # in_Table = "firestations.csv"
...     tb = r'C:\TEMP\WritingGeometries\APGriMMRP.csv'
...     xc = "X"
...     yc = "Y"
...     
...     out_Layer = "BHsWellLocations_layer"
...     saved_Layer = r"c:\TEMP\BHsWellLocations.lyr"
...  
...     # Set the spatial reference
...     # spRef = r"Coordinate Systems\Projected Coordinate Systems\Utm\Nad 1983\NAD 1983 UTM Zone 11N.prj"
...     spRef = r"Coordinate Systems\Geographic Coordinate System\World\WGS 1984" 
...  
...     # Make the XY event layer...
...     arcpy.MakeXYEventLayer_management(tb, xc, yc, out_Layer, spRef)
...  
...     # Print the total rows
...     print arcpy.GetCount_management(out_Layer)
...  
...     # Save to a layer file
...     arcpy.SaveToLayerFile_management(out_Layer, saved_Layer)
...  
... except:
...     # If an error occurred print the message to the screen
...     print arcpy.GetMessages()
... 
ERROR 000622: Failed to execute (Make XY Event Layer). Parameters are not valid.
ERROR 000628: Cannot set input into parameter spatial_reference.
>>>

Please kindly help and advise me why I got these 2 errors and how to fix them.

Thanks,
Scott Chang

Re: ArcGIS10.0-PythonWindow:Make XY Event Layer- .csv & WGS 1984: Errors 000622 & 000

ArkadiuszMatoszka — Tue, 16 Oct 2012 13:11:45 GMT

Hi,
Looking at attached file, I think coordinates format is invalid. To create features in WGS coordinates have to be in decimal degrees and in your file they aren't.
Another thing is what you want to achieve by creating lyr on event layer?
If you want to save event layer as featureclass use CopyFeatuers_management instead.

Cheers
Arek

Re: ArcGIS10.0-PythonWindow:Make XY Event Layer- .csv & WGS 1984: Errors 000622 & 000

ScottChang — Sun, 12 Dec 2021 00:09:05 GMT

Hi Arek, Thanks for your nice response.

1) I used the UTM <=> Lat/Long Decimal Degrees converter to change the X,Y-coordinates of 10 points in UTM Zone 18 (NAD 83) to the new X,Y-coordinates of same 10 points in World WGS 1984 - see the attached xls file. Then I executed my scMakeXYlayer.py in the Python Window of my ArcGIS 10.0:

>>> # scMakeXYlayer.py   for 10 points at APG-RI-MMRP site  
... # WGS 1984: X- & Y-coord, but no Z-coord in the csv & the .py file
... # Description: Creates an XY layer and exports it to a layer file
... # Author: ESRI - modified by Scott Chang per Chris Thompson's New No-Z (Date:  17 Oct 2012)
... # import system modules 
... import arcpy
... from arcpy import env
... # Set environment settings
... env.workspace = 'C:\TEMP\BS_Test.gdb'
...  
... try:
...     # Set the local variables
...     # in_Table = "firestations.csv"
...     tb = r'C:\TEMP\WritingGeometries\ApgRImmrpWGS.csv'
...     xc = "X"
...     yc = "Y"
...     
...     out_Layer = "BHsWellEdgewood_layer"
...     saved_Layer = r"c:\TEMP\BHsWellEdgewood.lyr"
...  
...     # Set the spatial reference
...     # spRef = r"Coordinate Systems\Projected Coordinate Systems\Utm\Nad 1983\NAD 1983 UTM Zone 18N.prj"
...     spRef = r"Coordinate Systems\Geographic Coordinate System\World\WGS 1984.prj" 
...  
...     # Make the XY event layer...
...     arcpy.MakeXYEventLayer_management(tb, xc, yc, out_Layer, spRef)
...  
...     # Print the total rows
...     print arcpy.GetCount_management(out_Layer)
...  
...     # Save to a layer file
...     arcpy.SaveToLayerFile_management(out_Layer, saved_Layer)
...  
... except:
...     # If an error occurred print the message to the screen
...     print arcpy.GetMessages()
... 
ERROR 000622: Failed to execute (Make XY Event Layer). Parameters are not valid.
ERROR 000628: Cannot set input into parameter spatial_reference.
>>>

I got the same Errors 000622 and 000628 again. I wonder why my scMakeXYlayer.py with the "UTM" XY-coordinates worked before, but my new shcMakeXYlayer.py with the "World WGS 1984" XY-coordinates did not work!!!??? Please kindly help and enlighten me on this strange matter.

2) I don't understand your second thing you mentioned and I don't know how to implement it. Please give me the detailed instructions of writing the Python code for doing it.

Thanks,
Scott Chang

Re: ArcGIS10.0-PythonWindow:Make XY Event Layer- .csv & WGS 1984: Errors 000622 & 000

ArkadiuszMatoszka — Sun, 12 Dec 2021 00:09:08 GMT

I made few changes to your code and test it with xls you've attached, and it seems to be working fine.
You may want to check is everything is ok with your wgs 84.prj, and path to it. Also i recommend to skip setting env, unless you wanne use it. Below code with my modifications, also should explain how to use CopyFeatures instead of SaveToLayerFile.


import arcpy
from arcpy import env
# Set environment settings
#env.workspace = 'C:\TEMP\BS_Test.gdb'
 
try:
    # Set the local variables
    # in_Table = "firestations.csv"
    tb = 'D:\\ApgRImmrpWGS.xls\\ApgRImmrpWGS$'
    xc = "X"
    yc = "Y"
    
    out_Layer = "BHsWellLocations_layer"
    saved_Layer = r"c:\Tmp\BHsWellLocations.shp"
 
    # Set the spatial reference
    # spRef = r"Coordinate Systems\Projected Coordinate Systems\Utm\Nad 1983\NAD 1983 UTM Zone 11N.prj"
    spRef = r"Coordinate Systems\Geographic Coordinate System\World\WGS 1984" 
 
    # Make the XY event layer...
    arcpy.MakeXYEventLayer_management(tb, xc, yc, out_Layer, spRef)
 
    # Print the total rows
    print arcpy.GetCount_management(out_Layer)
 
    # Save to a layer file
    arcpy.CopyFeatures_management(out_Layer, saved_Layer)
 
except:
    # If an error occurred print the message to the screen
    print arcpy.GetMessages()

Regards
Arek

Re: ArcGIS10.0-PythonWindow:Make XY Event Layer- .csv & WGS 1984: Errors 000622 & 000

ScottChang — Sun, 12 Dec 2021 00:09:11 GMT

Hi Arek, Thanks for your nice response.

I modified my Python script as you instructed to do CopyFeatures. In the Python Window of my ArcGIS 10.0 (Desktop), I executed the following code:

>>> # scMakeXYlayer.py   for 12 points  Just X- & Y-coord, but no Z-coord in the csv & the .py file
... # Description: Creates an XY layer and uses CopyFeatures to save it to a layer file
... # Author: ESRI - modified by Scott Chang per Arkadiusz Matoszka (Date:  24 Oct 2012)
... # import system modules 
... import arcpy
... from arcpy import env
... # Set environment settings
... # env.workspace = 'C:\TEMP\BS_Test.gdb'  # New!!!
...  
... try:
...     # Set the local variables
...     # in_Table = "firestations.csv"
...     tb = 'C:\TEMP\WritingGeometries\arekAPGriMMRP.xls\APGriMMRP$'
...     xc = "X"
...     yc = "Y"
...     
...     out_Layer = "Pointlocations_layer"
...     saved_Layer = r"c:\TEMP\arekAPGriMMRPLocations.shp" # not .layer!!!
...  
...     # Set the spatial reference
...     spRef = r"Coordinate Systems\Projected Coordinate Systems\Utm\Nad 1983\NAD 1983 UTM Zone 11N.prj"
...     # spRef = r"Coordinate Systems\Geographic Coordinate System\World\WGS 1984" 
...  
...     # Make the XY event layer...
...     arcpy.MakeXYEventLayer_management(tb, xc, yc, out_Layer, spRef)
...  
...     # Print the total rows
...     print arcpy.GetCount_management(out_Layer)
...  
...     # Save to a layer file
...     # arcpy.SaveToLayerFile_management(out_Layer, saved_Layer)
...     arcpy.CopyFeatures_management(out_Layer, saved_Layer) # New!!!
... except:
...     # If an error occurred print the message to the screen
...     print arcpy.GetMessages()
... 
Executing: MakeXYEventLayer C:\TEMP\WritingGeometries rekAPGriMMRP.xls\APGriMMRP$ X Y Pointlocations_layer "PROJCS['NAD_1983_UTM_Zone_11N',GEOGCS['GCS_North_American_1983',DATUM['D_North_American_1983',SPHEROID['GRS_1980',6378137.0,298.257222101]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]],PROJECTION['Transverse_Mercator'],PARAMETER['False_Easting',500000.0],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',-117.0],PARAMETER['Scale_Factor',0.9996],PARAMETER['Latitude_Of_Origin',0.0],UNIT['Meter',1.0]];-5120900 -9998100 10000;-100000 10000;-100000 10000;0.001;0.001;0.001;IsHighPrecision" #
Start Time: Wed Oct 24 08:12:45 2012
Failed to execute. Parameters are not valid.
ERROR 000732: XY Table: Dataset C:\TEMP\WritingGeometries rekAPGriMMRP.xls\APGriMMRP$ does not exist or is not supported
Failed to execute (MakeXYEventLayer).
Failed at Wed Oct 24 08:12:45 2012 (Elapsed Time: 0.00 seconds)
>>>

I don't know why it does not work for me. I have ArcGIS Desktop 10.0 - it is not a very sophiscated version of ArcGIS 10 (I feel). I wonder: Did you use a more sophiscated/advanced version of ArcGIS 10 system to do your "CopyFeatures" Python programming? I really like to use the xls file and the "CopyFeatures" code staement to do the "Make XY Event Layer" Python programming like the manual way to get the "Point" featurs.
Please kindly help and advise again.

Thanks,
Scott Chang

Re: ArcGIS10.0-PythonWindow:Make XY Event Layer- .csv & WGS 1984: Errors 000622 & 000

T__WayneWhitley — Sun, 12 Dec 2021 00:09:14 GMT

Your problem is not with Copy Features but with reading the table pathname for Make XY Event.

You have done this:

>>> tb = 'C:\TEMP\WritingGeometries\arekAPGriMMRP.xls\APGriMMRP$'

>>> # which returns a faulty pathname because '\' is read as an escape character by Python
>>> print tb
C:\TEMP\WritingGeometriesrekAPGriMMRP.xls\APGriMMRP$

...and should have followed the sample given you by Arek more closely since it is easy to make a minor error to foul the whole works:

>>> # as given you by arekmatoszka: 
>>> tb = 'C:\\TEMP\\WritingGeometries\\arekAPGriMMRP.xls\\APGriMMRP$'

>>> print tb
C:\TEMP\WritingGeometries\arekAPGriMMRP.xls\APGriMMRP$


>>> # or do this:
>>> tb = r'C:\TEMP\WritingGeometries\arekAPGriMMRP.xls\APGriMMRP$'

>>> print tb
C:\TEMP\WritingGeometries\arekAPGriMMRP.xls\APGriMMRP$

Re: ArcGIS10.0-PythonWindow:Make XY Event Layer- .csv & WGS 1984: Errors 000622 & 000

ScottChang — Wed, 31 Oct 2012 13:14:47 GMT

Hi Wayne, Thanks for your nice response.

1) I corrected my mistake in tb = r"C:\TEMP\...\...xls\ApgRImmrpWGS$" as you pointed out. It worked and I got the right output and Map. But, in addition to ID, Pt_ID, X, Y, I saw there are blank F5, F6 and F7 columns that appear in the Attribute Table also - see the attached file. I don't know why they (i.e. blank F5, F6 and F7) appear in the Attribute Table. Can you tell me how I can avoid them to appear in the Attribute Table?

2) Can I use the .txt file for input of ID, Pt_ID, X, Y via tb = r"C:\TEMP\....txt\...? If it can be done this way, please give me the detailed code statement for tb = r"C:\TEMP\....txt\...

Please kindly help and respond again.

Thanks,
Scott Chang

P.S. In doing "WritingGeometries" ArcPy-Python programming before, I used the following code blindly:
infile = r"C:\TEMP\WritingGeometries\WritingGeometries_12Points.txt"
I did/do not understand "infile" at all. Could you please enlighten me on infile and its usage for me?

Re: ArcGIS10.0-PythonWindow:Make XY Event Layer- .csv & WGS 1984: Errors 000622 & 000

T__WayneWhitley — Wed, 31 Oct 2012 13:49:58 GMT

Looks to me like you've got 'extra' columns defined in your Excel worksheet for the table, even though they are blank....so when processing they automatically get written. Change this by 'redefining' the range in Excel. Also, I think an easy way is to define the print range which shows up as a separate 'table' in ArcGIS, so you can use that too. Any questions, you can experiment with defining ranges in Excel to see how that in turn is read in ArcGIS...just be careful with file locking.

Anyway, looks like you are pretty much there with what I'd call successful output!
EDIT: By the way, thanks to Arek for the provided code that answers your basic initial question.

If you want to use a text file instead, you can look into that later - not sure the tools such as Make XY Event Layer work as well (or directly) with text files. Incidentally (if this is more convenient), as in 'intermediary' agent, you can use Excel to read native text data formatted in a saved xls (or xlsx, etc.) which in turn can be read directly by ArcGIS - no need to change the script you are now using.

As far as the 'infile' text file code in the sample, the reading of the file is done line by line using Python's methods from 'fileinput' module (not using arcpy's search cursor). Going this route will involve dealing directly with the input file's structure, the delimiter used, parsing the strings into appropriate variables, etc.

Re: ArcGIS10.0-PythonWindow:Make XY Event Layer- .csv & WGS 1984: Errors 000622 & 000

ScottChang — Sun, 12 Dec 2021 00:09:17 GMT

Hi Wayne,
1) I went to the "Home" manu => clicked on "Clear" to delete F5, F6 and F7 columnns of my xls file. Then I saved it and I executed the Python script in the Python Window of my ArcGIS 10.0. It worked and I got the right output without the blank F5, F6 and F7 columns in the Attribute Table.
2) I added a new column "Z" and the values for the 10 points. Then I executed the newly revised script:

>>> # scMakeXYlayer.py   for 10 points of ApgRImmrp:   X-, Y-, and Z-coord in the xls & the .py file
... # Description: Creates an XY layer and uses CopyFeatures to save it to a layer file
... # Author: ESRI - modified by Scott Chang per Arkadiusz Matoszka & Wayne Whitley (Date:  31 Oct 2012)
... # import system modules 
... import arcpy
... from arcpy import env
... # Set environment settings
... # env.workspace = r"C:\TEMP\BS_Test.gdb"  # New!!!
...  
... try:
...     # Set the local variables
...     # in_Table = "firestations.csv"
...     tb = r"C:\TEMP\WritingGeometries\ApgRImmrpWGS.xls\ApgRImmrpWGS$"
...     xc = "X"
...     yc = "Y"
...     zc = "Z"
...     out_Layer = "Pointlocations_layer"
...     saved_Layer = r"c:\TEMP\APGriMMRPBHsWell.shp" # not .layer!!!
...  
...     # Set the spatial reference
...     spRef = r"Coordinate Systems\Projected Coordinate Systems\Utm\Nad 1983\NAD 1983 UTM Zone 11N.prj"
...     # spRef = r"Coordinate Systems\Geographic Coordinate System\World\WGS 1984" 
...  
...     # Make the XY event layer...
...     arcpy.MakeXYEventLayer_management(tb, xc, yc, out_Layer, spRef)
...  
...     # Print the total rows
...     print arcpy.GetCount_management(out_Layer)
...  
...     # Save to a layer file
...     # arcpy.SaveToLayerFile_management(out_Layer, saved_Layer)
...     arcpy.CopyFeatures_management(out_Layer, saved_Layer) # New!!!
... except:
...     # If an error occurred print the message to the screen
...     print arcpy.GetMessages()
... 
Executing: MakeXYEventLayer C:\TEMP\WritingGeometries\ApgRImmrpWGS.xls\ApgRImmrpWGS$ X Y Pointlocations_layer "PROJCS['NAD_1983_UTM_Zone_11N',GEOGCS['GCS_North_American_1983',DATUM['D_North_American_1983',SPHEROID['GRS_1980',6378137.0,298.257222101]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]],PROJECTION['Transverse_Mercator'],PARAMETER['False_Easting',500000.0],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',-117.0],PARAMETER['Scale_Factor',0.9996],PARAMETER['Latitude_Of_Origin',0.0],UNIT['Meter',1.0]];-5120900 -9998100 10000;-100000 10000;-100000 10000;0.001;0.001;0.001;IsHighPrecision" #
Start Time: Wed Oct 31 13:31:34 2012
Failed to execute. Parameters are not valid.
ERROR 000725: Layer Name or Table View: Dataset Pointlocations_layer already exists.
Failed to execute (MakeXYEventLayer).
Failed at Wed Oct 31 13:31:34 2012 (Elapsed Time: 0.00 seconds)
>>>

It did not work at all. I am lost now. Please help and advise again.

Thanks,
Scott Chang

Re: ArcGIS10.0-PythonWindow:Make XY Event Layer- .csv & WGS 1984: Errors 000622 & 000

ScottChang — Sun, 12 Dec 2021 00:09:20 GMT

Hi Wayne,
I tried to use the right spRef=r"........\World\WGS 1984" and arcpy.MakeXYEventLayer_management(tb, xc, yc, zc, out_layer, spRef):

>>> # scMakeXYlayer.py   for 10 points of ApgRImmrp:   X-, Y-, and Z-coord in the xls & the .py file
... # Description: Creates an XY layer and uses CopyFeatures to save it to a layer file
... # Author: ESRI - modified by Scott Chang per Arkadiusz Matoszka & Wayne Whitley (Date:  31 Oct 2012)
... # import system modules 
... import arcpy
... from arcpy import env
... # Set environment settings
... # env.workspace = r"C:\TEMP\BS_Test.gdb"  # New!!!
...  
... try:
...     # Set the local variables
...     # in_Table = "firestations.csv"
...     tb = r"C:\TEMP\WritingGeometries\ApgRImmrpWGSxyz.xls\ApgRImmrpWGS$"
...     xc = "X"
...     yc = "Y"
...     zc = "Z"
...     out_Layer = "Pointlocations_layer"
...     saved_Layer = r"c:\TEMP\APGriMMRPBHsWellZ.shp" # not .layer!!!
...  
...     # Set the spatial reference
...     # spRef = r"Coordinate Systems\Projected Coordinate Systems\Utm\Nad 1983\NAD 1983 UTM Zone 11N.prj"
...     spRef = r"Coordinate Systems\Geographic Coordinate System\World\WGS 1984" 
...  
...     # Make the XY event layer...
...     arcpy.MakeXYEventLayer_management(tb, xc, yc, zc, out_Layer, spRef)
...  
...     # Print the total rows
...     print arcpy.GetCount_management(out_Layer)
...  
...     # Save to a layer file
...     # arcpy.SaveToLayerFile_management(out_Layer, saved_Layer)
...     arcpy.CopyFeatures_management(out_Layer, saved_Layer) # New!!!
... except:
...     # If an error occurred print the message to the screen
...     print arcpy.GetMessages()
... 
ERROR 000622: Failed to execute (Make XY Event Layer). Parameters are not valid.
ERROR 000628: Cannot set input into parameter spatial_reference.
>>>

I got the new errors: Errors 000622 & 000628!!!

Please help and advise again.

Thanks,
Scott Chang

Re: ArcGIS10.0-PythonWindow:Make XY Event Layer- .csv & WGS 1984: Errors 000622 & 000

DarrenWiens2 — Wed, 31 Oct 2012 21:13:57 GMT

The order of parameters from the help is (note that the z-field is last):

MakeXYEventLayer_management (table, in_x_field, in_y_field, out_layer, {spatial_reference}, {in_z_field})

So, your call should be:

arcpy.MakeXYEventLayer_management(tb, xc, yc, out_Layer, spRef, zc)

Re: ArcGIS10.0-PythonWindow:Make XY Event Layer- .csv & WGS 1984: Errors 000622 & 000

ScottChang — Sun, 12 Dec 2021 00:09:22 GMT

Hi Darren, Thanks for your valuable response.
I followed your instruction and added the "zc" to the last place of arcpy.MakeXYEventLayer_management(....., zc). I also checked my .xls file for the "zc" data, etc. - see the attched .xls file.
I executed my revised Python script in the Python Window of my ArcGIS 10.0:

>>> # scMakeXYlayerZ.py   for 10 points of ApgRImmrp:   X-, Y-, and Z-coord in the xls & the .py file
... # Description: Creates an XY layer and uses CopyFeatures to save it to a layer file
... # Author: ESRI - modified by Scott Chang per Arkadiusz Matoszka, Wayne Whitley and Darren Wiens 
... # (Date:  1 Nov 2012)
... # import system modules 
... import arcpy
... from arcpy import env
... # Set environment settings
... # env.workspace = r"C:\TEMP\BS_Test.gdb"         # New!!!  (per Arek)
...  
... try:
...     # Set the local variables
...     # in_Table = "firestations.csv"
...     tb = r"C:\TEMP\WritingGeometries\ApgRImmrpWGSxyz.xls\ApgRImmrpWGS$"
...     xc = "X"
...     yc = "Y"
...     zc = "Z"
...     out_Layer = "Pointlocations_layer"
...     saved_Layer = r"c:\TEMP\APGriMMRPBHsWellZ.shp"     # not .layer!!!
...  
...     # Set the spatial reference
...     # spRef = r"Coordinate Systems\Projected Coordinate Systems\Utm\Nad 1983\NAD 1983 UTM Zone 11N.prj"
...     spRef = r"Coordinate Systems\Geographic Coordinate System\World\WGS 1984" 
...  
...     # Make the XY event layer...
...     arcpy.MakeXYEventLayer_management(tb, xc, yc, out_Layer, spRef, zc)  # zc should be last (per Darren)
...  
...     # Print the total rows
...     print arcpy.GetCount_management(out_Layer)
...  
...     # Save to a layer file
...     # arcpy.SaveToLayerFile_management(out_Layer, saved_Layer)
...     arcpy.CopyFeatures_management(out_Layer, saved_Layer)      # New!!! (per Arek)
... except:
...     # If an error occurred print the message to the screen
...     print arcpy.GetMessages()
... 
ERROR 000622: Failed to execute (Make XY Event Layer). Parameters are not valid.
ERROR 000628: Cannot set input into parameter spatial_reference.
>>>

It did not work at all-ERRORS 000622 and 000628 again. Please kindly help and advise again.

Thanks in advance,
Scott Chang

Re: ArcGIS10.0-PythonWindow:Make XY Event Layer- .csv & WGS 1984: Errors 000622 & 000

T__WayneWhitley — Thu, 01 Nov 2012 13:22:45 GMT

Uh, this might sound uninformed, but I'm just curious - does the WGS84 coord sys even support Z coordinates?

Apparently, yes. Just tested this with WGS 84, using lat/lon points, 4 of them with the Make XY Event Layer Z parameter ranging from -25 to 25. Probably meters is assumed, I'm not certain and haven't tested much at all with this. It may depend on whether you've defined your vertical datum (if you have one).

Re: ArcGIS10.0-PythonWindow:Make XY Event Layer- .csv & WGS 1984: Errors 000622 & 000

DarrenWiens2 — Thu, 01 Nov 2012 14:45:42 GMT

It looks like there's a problem with how you're specifying your coordinate system. Apparently, there are 3 ways to properly create a spatial reference:
1.) Use the name of the coordinate system (I couldn't get it to work with "GCS_WGS_1984" or "WGS_1984", so I'm not sure what it's looking for)
2.) Use a projection file (.prj) (I didn't try this)
3.) Use a coordinate system's factory code (or authority code) (this works)

Try making spRef = 4326

This works for me:

arcpy.MakeXYEventLayer_management("H:/GIS_Data/ApgRImmrpWGSxyz.xls/ApgRImmrpWGS$", "X", "Y", "outputlayer",4326, "Z")

Re: ArcGIS10.0-PythonWindow:Make XY Event Layer- .csv & WGS 1984: Errors 000622 & 000

ScottChang — Thu, 01 Nov 2012 17:15:04 GMT

Hi Darren, Thanks for your nice and valuable response.
I revised the input information in the arcpyMakeXYEventLayer_management(....) as you instructed. Then I executed my revised Python script in the Python Window of my ArcGIS 10.0 - see the attached docx file. It worked. But It gave me (i) outputlayer only, (ii) no out_Layer and saved_Layer, and (iii) ERROR 000732. I think that (i), (ii) and (iii) can be improved/corrected. Please kindly help and advise me how to improve/correct (i), (ii) and (iii).
Thanks again,
Scott Chang

Re: ArcGIS10.0-PythonWindow:Make XY Event Layer- .csv & WGS 1984: Errors 000622 & 000

T__WayneWhitley — Thu, 01 Nov 2012 17:26:24 GMT

I'm sorry for your pain - but you've introduced a new layer name as output, "outputlayer".

Naturally this is going to 'break the chain'. You using 2 more tools trying to access out_Layer (a variable reference to "Pointlocations_layer")

Your fix should be to ust the out_Layer variable (no quotes).

Re: ArcGIS10.0-PythonWindow:Make XY Event Layer- .csv & WGS 1984: Errors 000622 & 000

ScottChang — Thu, 01 Nov 2012 18:54:53 GMT

Hi Wayne, Thanks for your nice, valuable response.
I changed the "outputlayer" to out_Layer as you instructed. I executed the newly revised Python script. It worked beautifully. I got no errors and 2 right output/Layers (APGriMMRPBHsWellZ and Pointlocation_layer) in TOC-see the attached file. One final questions to ask you: I guess that APGriMMRPBHsWellZ is a shapfile and Pointlocation_layer is NOT a shapefile (just a layer). Do I guess it right? Why are they different? How can I tell the difference between these 2 output? Please help and respond.

Thanks,
Scott Chang

Re: ArcGIS10.0-PythonWindow:Make XY Event Layer- .csv & WGS 1984: Errors 000622 & 000

T__WayneWhitley — Thu, 01 Nov 2012 19:14:21 GMT

Yes, you guessed right...the one with the shp file extension is the shapefile.

The main difference is shapefile or feature class, etc. is stored separate from your map. A 'feature layer' (and a 'table view') are 'virtual' -- they can be added to your map but essentially when your map is deleted, or when your ArcGIS session is ended either without saving or without the option to 'add outputs to display', then the output is lost.

That's basically it - usually it's better to save data outside the map doc so at least you can access it from another doc, if you wish. At the very least, although you shouldn't be losing mxds, data tends to be safer in a shapefile library or in gdb(s).

Hope that helps. And hope you're keeping your sense of humor working through some of these problems. Now, make sure you award points to everyone who helped you! 🙂

Re: ArcGIS10.0-PythonWindow:Make XY Event Layer- .csv & WGS 1984: Errors 000622 & 000

ScottChang — Mon, 05 Nov 2012 11:26:18 GMT

Hi Wayne, Thanks for your response.

Please let me know how I can award the points to everyone who helped me in this Make XY Layer Event Python pergramming.

Thanks,
Scott Chang

Re: ArcGIS10.0-PythonWindow:Make XY Event Layer- .csv & WGS 1984: Errors 000622 & 000

T__WayneWhitley — Mon, 05 Nov 2012 17:56:19 GMT

See what I will call the 'toggle button' over to the upper right of the post - fiddle with that, up arrow awards points.... I forget exactly how you 'check mark' a response for the answer but you can probably figure it out (or maybe in FAQ?) - thing is, I believe you can only award 1 correct answer. Points, on the other hand, can be applied 'sprinkling' onto several posts, if you will.

Thanks for participating and keeping us on our toes!

- Wayne

EDIT: See the pic at the top of the page:
http://forums.arcgis.com/index.php