Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

The following step-by-step instructions and screenshots are based on the Windows 10 operating system with the Windows Classic desktop theme and ArcGIS Pro 2.1.3 software. If your personal system configuration varies, you may experience minor differences from the instructions and screenshots.

 

PART I: Install the R-ArcGIS bridge

  1. Download R and RStudio
    First of all, you need to download and set up R and RStudio (RStudio is a free integrated development environment for R).

    R link (recommend to download R 3.2.2 or later): https://cran.mtu.edu/bin/windows/base/
    R Studio link: https://rstudio.com/products/rstudio/download/

    For both, accept all defaults in the installation wizard.

  2. Prepare data on Houston crime statistics
    Though you can Google search Houston crime GIS data and find the shapefile (with the link: https://cohgis-mycity.opendata.arcgis.com/datasets/hpd-nibrs-crime), it only contains around 4,000 cases, which is far from complete. As a remedy, we need to download the data from Houston Crime Statistics (with the link: https://www.houstontx.gov/police/cs/Monthly_Crime_Data_by_Street_and_Police_Beat.htm). For example, we can focus on the data of year 2020 till end of May (see the following screenshot).



    Note that the data is in .xlsx format. We need to save it as .csv file and then geocode the addresses to make it a shapefile. You need to use credits for geocoding in ArcGIS Pro. For convenience, I have already downloaded the data (and cleaned a little in terms of addresses) and geocoded it into a shapefile. You can downloaded the .rar file attaced here houston-crime-sample.rar and proceed. Notice that, for simplicity, I only use the crime cases of the first 10 days of year 2020, that is, dating from January 1, 2020 to January 10, 2020 (I choose 10 days because the step in Part II using Create Space Time Cube by Aggregating Points requires at least 10 time step intervals (in this case, it requires at least 10 days if the time step interval is set as 1 day).

  3. Create a new project in ArcGIS Pro
    As mentioned above, download the houston-crime-sample.rar file.

    Locate the downloaded file on your computer and extract its contents to a folder named houston-crime-sample in a location of your choice. Open the houston-crime-sample and you will see houston-crime.gdb, the geodatabase which has crime data that you will add to a map.

    Start ArcGIS Pro. Under New, click Map. In the Create a New Project window, for Name, type Houston Crime Analysis. For Location, browse to and choose your houston-crime-sample folder. Uncheck Create a new folder for this project. Click OK, then the project is created.

    In the Catalog pane, on the Project tab, expand Folders and expand the houston-crime-sample folder. Expand the houston-crime.gdb geodatabase, right-click the Houston_Crimes_Sample feature class, and choose Add To Current Map.

    Image Added

    As described above, this map shows locations where crimes occurred from January 1, 2020 through January 10, 2020 in the greater Houston area. This is only a small sample for crime analysis, but the general procedure is the same. You can apply this tutorial for larger data sets of crime statistics.
    Image Removed

  4. Install the R-ArcGIS bridge: automatical method/manual method
    R-ArcGIS bridge is a useful tool for you to reading and writing data to and from ArcGIS Pro and R. Once it is installed, you can also begin running script tools that reference an R script.

    Here are two methods to install R-ArcGIS bridge, automatical or manual.

    Automatical method:
    On the ribbon, click the Project tab.

    Image Added

    Click Options. In the Options pane, under Application, click Geoprocessing. In the R-ArcGIS Support section, select your desired R home directory. Notice that all versions of R that are installed on your computer will appear in the list. Select R 3.2.2 or a later version. For example shown in the screenshot below, I use R 4.0.1.

    Image Added

    If you do not have the ArcGIS R integration package installed, next to Please install the ArcGIS R integration package, click Install package and choose Install package from the Internet. When asked to confirm the installation, click Yes, and when the installation is complete, click Close.

    If you already have the ArcGIS R integration package installed, next to Installed 'arcgisbinding' package version, click the Check for updates button and choose Check package for updates to ensure that you have the latest version of the package.

    In the Options window, click OK. Click the Back button to return to the map

    Manual method:
    Sometimes it turns out error messages when installing the ArcGIS R integration pacakge. You can use the manual method describled as following.

    Go to this website: https://github.com/R-ArcGIS/r-bridge-install (actually you can also refer this tutorial for manual installation). Download the repository r-bridge-install-master.zip by clicking Code and then Download ZIP.

    Image Added

    Download the latest version of the arcgisbinding package in this website: https://github.com/R-ArcGIS/r-bridge/releases/tag/v1.0.1.239. As of writing, this is arcgisbinding_1.0.1.239.zip (this is the updated version by the end of June, 2020).

    Copy both zip files onto the directory of your choise. Extract the r-bridge-install-master.zip file. Place the arcgisbinding_1.0.1.239.zip into the same directory as the R Integration Python toolbox.

    Back to ArcGIS Pro, in the Catalog > Project pane, right-click Toolboxes > Add Toolbox and navigate to the location of the R Integration Python toolbox. Open the toolbox, which should look like the following screenshot:

    Image Added


 

 

PART II: Basic statistical analysis

  1. Project the shapefile

  2. Aggregate point data by counts within a defined location

  3. Analyze crime hot spots: One step forward

 

PART III: Enhance the dataset with additional attributes

  1. Add additional attributes to the original dataset

  2. Further prepare the dataset

 

PART IV (KEY SECTION): Conduct statistical analysis using R and ArcGIS Pro

  1. Bridge your data into R

  2. Calculate smoothed crime rates

  3. Continue analysis in ArcGIS Pro

  4. Identify areas with unusually high crime rates


PART V (KEY SECTION): Identify attributes that influence crime

  1. Create a correlation matrix in R to evaluate attribute relationships