Latest Contributions by ABDALLAMOHAMED

Dan ..I got it.It works great with me... Thanks a lot for your help. Appreciated ... View more

OK let me try it ... View more

Hi Dan ..thanks for your reply. My table is a shapefile table do i still need to add xy coordinates? if so how can i do that? ... View more

ABDALLA, I assumed your stores are also points. So, even INTERSECT option should work. Can you specify 500m for INTERSECT to run the tool? Do you get the Join_Count? When you specify a Search Radius for INTERSECT, any features found within that distance are considered intersected. What license level do you have for ArcGIS 10? Are you using any Service Pack of ArcGIS 10? Dan..I really don't know what license level I have, and don't know if we have any service Pack. This is done by the IT department, and we are just endusers. However, this is a federal government computers and I assume they have the best level of license..As for my question, I have about 176 grovery stores, and about 25,583 points.. Both of them are points. I wanted to spatially join them together to find out how many grocery stores within the limit of 500 meters from each point..When I specified 500m for INTERESECT, the joint_count has a value of 1s (one) for all the 25,583 points..I beleive that is not correct, because I have only 176 stores. My understanding is that I should have something like the following: Point Id 1     has 2 grocery stores point id 3 has 5 grocery stores and so on until the last store. This is just an example. Thanks! ... View more

Dan..I'm using ArcMap 10. When I tried to assign my 500 meters, the only option I have is "Intersect", the other options "Within" and "Contain" are grayed (Not enabled). I do not think "Intersect" option is correct, I need to use either "within" or "contain" to find the number of grocery stores within 500 meters. I have a total of 176 grocery stores, and around 283,000 points that I wanted to join them spatially. ... View more

Could you describe why or how using JOIN_ONE_TO_ONE didn't work for you? Did you get an output? Did the output have a field named Join_Count? About the frequency output table, I understand it is a table, no features. I suggested that you try Join Field tool (Data Management toolbox - Joins toolset). You should specify the following: Input Table - specify your points (the shapefile) Input Join Field - Select FID Join Table - specify the output table of Frequency Output Join Field - select the FID field Join Fields (optional) - check the box labeled FREQUENCY Click OK to run the Join Field tool. This process transfers the FREQUENCY field from the output table of Frequency to the point shapefile. You can now right-click the point layer, go to the Layer Properties - Labels to label the FREQUENCY field; this is the count you wanted. Does it work? Dan..Sorry It took me long time to reply to your post. It has been crazy week already. As to your question why using join_one_to_One didn't work, it is beacuse it won't let me specify my 500 meters distance to the nearest grocery store. That is why I used your second suggestion ( One_to_Many option). I followed your steps strictly, but unfortunately I didn't get what I wanted, that is, the number of grocery stores within this 500 meters. The join_count field has 1's only for the entire area records (25583 records). I don't think this is true because I have only 276 grocery stores. The frequency field has just one field with the value of 2 and the rest is zeros. I thought  the spatial join tool would give me the total number of grocery stores for each 500 meters distance. But so far I didn't. Any tips, appreciated. ... View more

Yes, i tried your first suggestion but didn't work like the second suggestion, that is, use One-to-many option. This one works find and then I used the frequency too and I got the count of store with each ID. The problem the frequency tool output is Info table, not shapefile, that is why it is hard to map it... ... View more

There is no Label tab when I right click on the layer and choose property..I think because the table is An Info table. I was trying to convert it to a shapefile or something but I couldn't..Thanks. ... View more

Dan..It works fine and I got the count of my stores..Now the question is how  to map this table. I wanted to map it so that I can see the number of stores on the map.. Any Hint..Appreciated.. ... View more

Dan.. I found the Iterators.. Thanks a lot.. ABDALLA ... View more

Dan.. I have ArcGIS 10, but I couldn't find ModelBuilder Iterator tool. I would like to give it a try. Any hint on where to find such tool..Thanks a lot.. ABDALLA ... View more

Dan..Both of the above approaches work great. Now I will appy them to my entire data and see the result of that..Hopefully the result will be consistent with the sample data..Because I have large data, the process is going to take at least two days to finish. I will let you know by then.. Thanks a lot.. Appreciated! ABDALLA ... View more

Dan..When I calculated the ConID  by the Rowid , I got the same value numbers as Rowid..Is that what you think is right? look at the output below: FID Shape Id NEAR_FID NEAR_DIST ConID Rowid FID FREQUENCY NEAR_DIST * 0 Polygon 0 2 1716.566324 4 4 0 1 1716.566324 1 Polygon 0 4 1656.804153 3 3 0 1 1656.804153 2 Polygon 0 4 551.543298 1 1 0 2 551.543298 3 Polygon 0 4 602.992525 2 2 0 1 602.992525 4 Polygon 0 2 551.543298 1 1 0 2 551.543298 Do you think that would be a duplicate?? Thanks a lot.. ABDALLA ... View more