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; } } }

Counting points in buffers

ErikaMartino

Hi All,

Up until now, everyone on this forum has saved my bacon, so I thougt I would try my luck again! I am counting facilites (points) within buffers using spatial joing and sum, the problem, however, is this: when I do a 'blind eye' count, the count is 2, for example, in buffer A yet when I look at the spatial join count it shows as 10! Could someone suggest why this would occur? The points are listed as "multipoints" in the geography type, would this distort the count and if yes, how do I rectify this issue?

Thanking you in advance!

Find more posts tagged with

Accepted answers

All comments

ErikaMartino

Hi Dan,

I was able to add a time field in my table but I can't use field calculator to set a time, see blue... (eg. (length/mph*60)). I can't input that formula for some reason...

DanPatterson_Retired

You missed my point... you have to add a time field to your table, and calculate time from the Shape length (aka distance) and some 'speed limit'. if you have distance, distance/unit time you can calculate time.

ErikaMartino

Hi Dan,

Thank you as always for speedy reply. Could you detail the step by step process I would need to undertake to do this? I am not per se interested in speed / time, however, I have googled the process and tried to add time but the analysis keeps failing, see below, I have added parameters and evaluators (at least I think I have!) and still not working. Any advice would be very helpful. Neither data inputs have a time table, which I have tried to add using field calculator but it won't give me that option...

DanPatterson_Retired

the simplest way is to add a field and calculate time from an assumed speed of traversal.

Consider the simplest idea, that the speed 'limit' is 50 km/hour. You can calculate the time of traversal for a segment of a 'shape' from its length. So if you have a 1 km road, how long do you think it would take you in minutes or seconds to traverse that road segment? You can categorize your mode of transportation and/or road (read, network edges) according to a 'limit'. This obviously explains why the shortest path need not be the fastest since various routes to a destination from an origin can have different physical lengths and a 'temporal length'.

So you will have to add this constraint into your analysis, either keeping it simple, or categorizing your 'roads/edges/routes/paths' accordingly.

ErikaMartino

Hi Dan,

Thanks for prompt response - I have setup a network dataset (shape file) that has streets and junctions, however, when I go into the properties toolbar to change the attributes of the network the only attribute listed is length, with no time component. Could you offer advice on how I might fix this? The XY are the resident locations, the greenspace file is the vertices of the green space, however, the network dataset is coming up as an error? The distance is the length, but why do I need to assign time to this?

DanPatterson_Retired

it is referring to the road network not the facilities you should have had a shape field in the FC

DanPatterson_Retired

why not use the builtin tool? are you using an old version of arcmap (ie 9.3 or less as per the link you sent)

ErikaMartino

Hi All,

One last question: I am using Network Analyst to find the nearest distance to a park from a resident's location (i have converted the park polygons to line and then vertices). I keep getting this error? Could someone suggest an alternate?

ShengdiZhang_1-1634701572738.png

ErikaMartino

Also, would this method also work;

How To: Convert a multipoint feature class into a point feature class ?

ErikaMartino

Thank you both, there goes a week of analysis, at least now I know what the issue was!

DanPatterson_Retired

blow the file apart using Multipart To Singlepart—Help | ArcGIS for Desktop

things are never as they appear, so don't rely on your eyes... always check the geometry

JayantaPoddar

The multipoint geometry could be causing the issue. The geometry should be "point".

Use the following steps to convert the above data to point feature class.

1. Add two new fields in the attribute table, viz., "X" and "Y". Calculate the respective X and Y coordinates using CALCULATE GEOMETRY. Choose "Decimal Degrees" as units.

2. Using Table to Excel tool, convert the table to Excel.

3. Open the excel file in MS Excel. Delete the Geometry field.

4. In ArcMap, File > Add Data > Add XY data. Use appropriate spatial reference (e.g. GCS_WGS_1984 or any other appropriate GCS).

5. Export the Event layer to a Feature class/shapefile.

Then try the Spatial Join once again.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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