Points not showing in map... but not entirely absent

[BrantleeSR]

I am an absolute novice with ArcGIS (please be gentle with me!). I am using online access on a MacBook Pro in Chrome. 

What I'm trying to do: The city of Gainesville, FL makes their traffic accident data publically available, and exportable as a geojson file. I want to visualize the data on a map, so I downloaded the geojson file and uploaded it as a map layer in ArcGIS. Nothing fancy, all default settings.

What is happening: Only two data points are showing on the map, one from 2022 and one from 2023. If I click on either of those points, I get the expected pop-up with all the associated data, all good. If I open the associated data table for the layer, I can see that all the data is there: 6,000 records. But only two of the 6000 are showing up on the map.

[I tried to load a screen cap here to show the layer, data table, pop-up for one of the points, and information settings, but got a "you do not have permission to upload images" error, so I reckon we'll just have to start in on the thousand words that the one picture is worth!]

I've seen a lot of posts with questions about data points not showing up, but they've all been all-or-nothing. Any idea why two and only two out of 6000 records would be appearing? Or how to get the rest in on the party?

Many thanks!

[JaredPilbeam2]

Could be anything. Here's two things that pop into my head since I can't see your project. Could be there is a Definition Query set to show only certain fields and then forgot about. Right click layer properties > Definition Query.

Or look in the symbology. Maybe you don't have all the values added.

[BrantleeSR]

I'm sorry, I can't figure out how to get to the menu that you are showing. I really wish I could share a screencap here, because none of what I see looks like your screen caps!

I have no "layer properties" in my view to right-click on. I can drop down a menu from the "..." next to the layer in the Layers list, and select "show properties," but it just opens a bar at the right side of the map with expandable boxes for information, symbology, appearance, visibility, editing, refresh interval, and feature display order. Under "information," there is a button to "manage layer properties," but clicking on it just gives a message, "all properties are stored in source layer" with options to reset to source layer or disconnect layer properties. I don't see a "definition query" anywhere in the assortment of boxes.

In the "symbology" box, I just get a toggle switch for "show in map legend," the name of the layer with the default map symbol, and a link to "edit layer style." If I click on that, I get a "choose attributes" box and a "pick a style" box. Under "choose attributes," there is a "+ Field" button, and I tried adding street address or intersection, but for both attempts, it just popped up a new map legend without actually putting any more points on the map.

I know this probably isn't very helpful, but I'm still getting a "you do not have permission to upload images" error message here. Is there a trick to uploading screenshots?

[RyanUthoff]

I don't think you're doing anything wrong. I found the traffic accidents dataset on their website and downloaded it as a geojson and brought it into ArcGIS Pro and I see the same thing as you. But, what's actually happening is that all the points are on top of each other so it only appears as if there a couple records. But in reality, all the records are there, they are just on top of each other.

Luckily, there are latitude and longitude fields in the attribute table. So to get the "true" spatial data of those points, what you can do is create a new table with the spatial locations based off the values in the lat/lon fields.

Edit: I'm not aware of a way to create a spatial table based off of lat/lon columns in AGOL. I only know how to do it in ArcGIS Pro.

[BrantleeSR]

Thank you!!! 

That gets us a big step closer! Now the question just becomes: how do I get it to use the lat/long data to render the points, rather than whatever the heck it is using right now!

[RyanUthoff]

Do you have access to ArcGIS Pro? Like I said in my post above, that's the only way I know of generate the points based off the lat/lon columns. I'm not sure if it's possible to do it directly in AGOL.

[BrantleeSR]

I don't have a Pro license; just access through UF. But the data is also downloadable as a csv file. Could that be edited somehow to correct the location info, then converted and uploaded? I don't know how to tell ArcGIS which data column to use for the location, but I can edit spreadsheets like a champ.

[RyanUthoff · Accepted solution]

Actually, yes, that will work. Just download the data as a csv, and then upload the csv to AGOL. From there, you'll get to a page that looks like this:

You can modify that as necessary. And then when you click next, you'll get to this page where you can specify the lat/lon from the columns in the spreadsheet.

After you do that, it should create a new layer in AGOL with the spatial locations of all the records.

[BrantleeSR]

BINGO! Uploading from CSV worked. 

One more question: you noticed that the points were all on top of each other in the original geojson upload. How do you see points under other points in an ArcGIS map? Can an area be selected to show the number of points stacked on top of each other? 

Thanks so much for your help!

[RyanUthoff]

In an ArcGIS Online web map, you can see if they're on top of each by clicking on one of the points. In the pop-up, you will see arrow icons where you're able to switch to view the attributes of other records. So in the case of my example screenshot below, there are two records on top of each other. And you're able to change the pop-up to view the attributes of the other records on top of each other by clicking the arrow button.