Transfer Excel data to ArcMap
#1
Posted 30 November 2012 - 11:45 AM
My lab partner and I are doing a map on earthquakes in California for the month of November. We have the earthquake data in Excel and transfered it to ArcMap. We are having trouble with it plotting the points on our base map, its not matching the basemap so the dots are not in California they are in the ocean. Anyone know how to fix this?
#2
Posted 01 December 2012 - 01:02 AM
My lab partner and I are doing a map on earthquakes in California for the month of November. We have the earthquake data in Excel and transfered it to ArcMap. We are having trouble with it plotting the points on our base map, its not matching the basemap so the dots are not in California they are in the ocean. Anyone know how to fix this?
Sounds like a coordinate system mismatch. You'll need to specify the coordinate system (and projection) used by both, then ArcMap will be able to match them. Didn't you get a warning about that when you imported the points?
Aside from that, keep in mind that it is (at least geologically) possible for earthquakes to happen in the ocean.
Red Geographics
Email: hans@redgeographics.com / Twitter: @redgeographics
#3
Posted 01 December 2012 - 11:11 AM
If you are confidant that you are assigning the correct coordinate system on import than it may be the values in the table itself. They may be missing a negative value for the longitude. Or, you may have switched the lat for the long on import. Check all of these things and let us know if anything works.
David
GIS Reference and Instruction Specialist, Stanford Geospatial Center.
www.mapbliss.com
#4
Posted 03 December 2012 - 12:39 PM
#5
Posted 03 December 2012 - 01:26 PM
Thank you! The coordinate systems were not matching. Also I was looking at the data my partner and I have gathered about California earthquake activity and we saw that most of the earthquakes occur in South California, is that because the San Andrea Fault goes through South California more than North California? Thanks.
I think there is a more complex fault system in S CA but that may have nothing to do with the numbers. When looking at only one month of earthquakes you are bound to get a non-representative sample. A better study would be to look at monthly or yearly averages averages over some longer period of time.
GIS Reference and Instruction Specialist, Stanford Geospatial Center.
www.mapbliss.com
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users


Sign In
Create Account
United States
Back to top
Netherlands









