Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Hi this seems like it should be an easy problem, but its been giving me a headache.

I have a .xls spreadsheet with about 60,000 rows. Most of them have Latitude and Longitude. I simply want to display these as points in Arc10.

I've tried making a .dbf in arccatalog and creating a feature class from XY data. The first times I tried this the rows that had no lat/long were given 0,0. The problem is the scale is about 1:1e200+ feet... so the points with correct lat/long are all together but so tiny I can't even zoom into them.

So the second time I just took out all the rows without lat/long. Now the points show up but compared to the old points and the counties they are not lined up and they are tiny...

I've also tried using it as a .csv and as the .xls and in QGIS. I went through all the rows and took out the lat/long points that were entered incorrectly (not in decimal degrees) as well...

On the map there little red point way off where it should be, and it is actually 40,000 points on a scale of 1:19 feet instead of 1:3,000,000ish... The projection is the same as the other layers and when I click on individual points they have the same lat/long, just in different spots.

share|improve this question
    
can you show us how your dbf file looks like (header + 5lines) ? –  A.R Nov 2 '12 at 10:48

1 Answer 1

up vote 5 down vote accepted

When someone says that data points are tiny compared to other data layers, the usual problem is that the new points have been assigned a projected coordinate system--probably the one that the other layers are using--but the new points are latitude-longitude and should be assigned a geographic coordinate system.

The Add XY tool will default to the data frame's coordinate system. You need to change that to match what these points are in.

Even though you're seeing latitude-longitude in the data frame, the display units (data frame properties, general tab) may have been set to show degrees or degrees-minutes-seconds even though the data frame's coordinate system is projected.

share|improve this answer
    
Ok... so the data frame properties says the map units are feet and the display units are feet. I take it this makes my lat/long instead of being 27 deg N and -82 W... its making it 27 feet N and -82 Feet west? And I've tried changing the map units and display units before and after adding my data, but neither seems to change how they're displayed... –  Steven Hunter Douglas Nov 1 '12 at 15:49
1  
@StevenHunterDouglas, yes, I think that is what's happening. When you add the lat/lon data, set the coordinate system (spatial reference) to...well, try NAD 1983 since it's US. –  mkennedy Nov 1 '12 at 15:52
    
@StevenHunterDouglas, And I should have said in the previous comment, look in geographic coordinate systems, North America for NAD 1983. –  mkennedy Nov 1 '12 at 16:21
    
Ah yes of course. When I used the XY data tool I was adding a PCS. All I needed was NAD 83... Thanks –  Steven Hunter Douglas Nov 1 '12 at 16:38

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.