Je travaille sur un devoir pour un cours de criminalistique et je suis bloqué sur une question. Je suis censé différencier le vol inférieur/supérieur à 5000 $ pendant une période spécifique dans une zone spécifique, ce que j'ai fait. On me demande maintenant un tableau Excel montrant le nombre de crimes par adresse dans cette zone. Je pense que je pourrais avoir besoin d'utiliser la sélection par localisation ou par attribut, mais je ne sais pas comment faire pour afficher ce dont j'ai besoin. <\/P>
<\/P>
Voici à quoi ressemble ma carte jusqu'à présent : http:\/\/i.imgur.com\/hbArjdy.jpg?1<\/A><\/P><\/P>Merci d'avance !<\/P><\/BODY><\/HTML>
Merci d'avance !<\/P><\/BODY><\/HTML>
The Tabulate Intersection tool in the Analysis->Statistics toolbox is probably what you are looking for.
if you don't have the Advanced license of ArcMap, tabulate intersection won't work but it is on the right track.
When you mean address, it appears that you also want them within the zone outlined in black. If so you can use the Summarize option within the table and summarize the thefts for that zone since you seem to have preselected the queries to do the initial differentiation.
Alternately, you can perform an intersection of the zone with the points and obtain a similar result, but you will still have to get your counts using Summarize
A select by Spatial Location after your attribute quer(ies) with a summarize will also work.
Once you get the data, you can export the table to a format that Excel can read such as Table to Excel
It's on my school's computer so I'm not actually sure if it's an advanced license. Yup, I need it to be within that one zone. I've already differentiated between the crimes I need I just need a count per address (when I go into the attributes table of each crime and sort by address I can see there are some duplicates, just not sure how to count them).
Thanks for the suggestions, I'll try them out later today.
Open your crime point data. Right click on address field. Select summarize. This creates a summary table and will give you a count of how many times the address appears in the data. You can also pre-select for specific crime types and just summarize the selected records.
Be sure to tell your instructor that some really good guys on the ESRI forum helped you out.
Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
