nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Najděte více příspěvků označených jako

Mapping

Accepted answers

ryanuthoff

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.

All comments

jpilbeam

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.

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

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?

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.

BrantleeSR

Thank you! This has all been super-helpful!

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.