hello ..I have my data in excel file and I wanted to convert it to points, add xy coordinates and finally create a shape file.. I need your help please...Considering this is my first time to deal with this type of data.
Thanks a lot
ABDALLA
ok let me try it and see
Hi,
1) Convert XY table to XY event layer
Choose appropriate spatial reference (e.g. GCS_WGS_1984)
2) Export the XY event layer to feature class.
Jayanta..Thanks for your reply. I don't have xy table, but I have excel file with crime data in 10 counties. My question is how to add xy coordinates and convert it to a point.
Hi Abdalla,
What is available in your table - only county names? if that is the case, see if you can find the coordinates for the counties and add them to the table (one column x one column y).
perhaps give an example of your data?
You can use the excel sheet as a XY table. XY table is just a generic term.
Hi Victor..I have crime data from 10 counties in Colorado. The table only has years and types of crime e.g murder, homicide etc. it doesn't have any xy coordinates. I'm attaching a sample with this message
I have had a look at you table, I have rearranged it a little, have a look at the attachment. simple table, no white spots, no spaces in column names, extra field county. if you add all other records you have to this table you can import it as table in arcmap. then either link it to a shapefile or add x y info of every county.
I have added the new xls and a shapefile (derived from Colorado.gov: The Official State Web Portal) - polygon - there are tools to convert it to points.
Hope this works
Victor
Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
