Map property information

The railway company owns two properties that are up for sale. To market these rail-adjacent properties to prospective buyers, the real estate manager has prepared a spreadsheet containing information and important characteristics of the properties. In this section, you will import this spreadsheet and plot the properties on the map in ArcGIS Business Analyst. Once the properties and their characteristics are on the map, the real estate manager can use Business Analyst to generate marketing materials.

Create a project

Projects are the way Business Analyst organizes and groups together relevant content. For this project, you'll use site data prepared beforehand by the real estate manager. This data will be added to your project and stored in the project pane.

  1. Sign in to your ArcGIS organizational account.
    Note:

    If you don't have an organizational account, you can sign up for an ArcGIS free trial.

  2. In a new window or tab, sign in to the ArcGIS Business Analyst Web App.
    Note:

    If you have previously used ArcGIS Business Analyst Web App, the app may open in an existing project.

  3. If necessary, click the Home tab and select Create New Project.

    Create New Project button

    The Create Project window appears.

  4. In the Create Project window, for Project name, type Rail Industry Property Development and add your name or initials. Click Create.

    Title your project.

    The process of setting up a project may take a minute or more as each of the project layers and data directories are created. When the project is created, a confirmation window appears.

  5. In the confirmation window, ensure Open new projects as soon as they are created is checked and click OK.

    Open new projects as soon as they are created is checked in the confirmation window.

    Your new project opens. A pop-up may appear, offering a guided tour of the user interface.

  6. If necessary, close the Step-by-Step Guided Tours pop-up and click Clear map to remove any existing data layers that may be in the map display.

    Clear any existing layers off the map.

    Your rail project now only contains the data and sites relevant to the work in this lesson.

Add data

Next, you'll add data to your new project. You will add property information using a spreadsheet containing the properties’ characteristics, which you'll upload to Business Analyst.

  1. Download the Rail Owned Properties.zip file.
  2. Unzip the data to a location of your choosing, such as your Documents folder.

    The Rail Owned Properties folder contains three items: a Microsoft Excel file with information about the properties and two images.

  3. In Business Analyst, on the ribbon, click Add Data and choose Import File.

    Import a file to add data to the map.

    The Import File pane appears.

  4. For Select a file to import, click Browse. In the Rail Owned Properties folder, select the Rail Owned Properties Excel file.
  5. Click Import.

    Import the file

    Once the data loads, you're prompted to choose the type of data being imported: point locations or geographic boundaries. The properties are point locations.

  6. For Select the type of data being imported, choose Point locations and click Next.

    Next, you'll select the fields in the CSV file that match the property locations on the map.

  7. Under And / or, make sure that the Latitude and Longitude fields match the Latitude and Longitude columns.

    Match the latitude and longitude columns.

  8. Click View data table.

    View data table on the Import File pane

    The table pane opens to show the two points you're importing. The table shows information for two sites named Beaumont Hub and Santa Ana Depot and includes qualitative description, zoning information, utilities providers, and nearby features such as interstates.

  9. On the Import file pane, click Hide data table to close the table, and click Next.

    The map zooms to Southern California, and points corresponding to the property locations are added to the map. In the Import File pane, you can choose how the points are styled. For now, you’ll use the default style.

  10. Click Next.
  11. Under Save and name the new layer, select Create and save sites for all points.

    Create and save sites for all points.

    The buffer options are enabled. For these buffers, you want to calculate possible drive times from the sites so that later you can see who and what is within certain drive times of your sites.

  12. Click Drive time and for Time, type 10, 20, and 30 minutes.
    Drive Time filters

    Each of these buffers will be created as a site.

  13. For New layer name, type California Rail Owned Properties and add your initials. Check the box for Open all labels for imported data.

    Save a new layer

  14. Click Save.

    The two properties are saved as sites with buffer drive times around them.

    (drive-times) 10, 20, and 30-minute drive times from the prospective properties.

    On the map, red indicates a 10-minute drive time, green a 20-minute drive time, and blue a 30-minute drive time.

  15. Close the property location pop-ups.
  16. In the Import File pane, click I’m Done.

You have mapped information about two properties up for sale by the railway company. You also created sites with 10-, 20-, and 30-minute drive times around them to focus our future analyses. Next, you'll use infographics to create a polished property flyer and develop marketing materials for each site.


Run Infographics

With infographics, you can create ready-to-use marketing materials for each site. This can include property flyers for the sites, as well as demographic and labor force information for use in marketing the properties to specific industries.

Create property flyers

Now that the properties for sale are on the map in Business Analyst, you can take advantage of the extra information the spreadsheet included (as well as demographic details included with Business Analyst) to make property flyers.

  1. On the map, click the Santa Ana Depot site (the westernmost site) to open its site menu. On the menu, click Add photo.

    Add a photo to the site.

    The site details pane appears. This pane shows information about the site, including name, address, and other attributes that you uploaded in the file.

  2. In the site details pane, click Add photo.

    Browse to the photo you want to add.

  3. Browse to and select the Santa Ana Depot image file from the Rail Owned Properties folder.

    Once the file has uploaded, the photo will be visible in the site details pane.

    Santa Ana Depot photo

  4. Click Close.
  5. Use what you have learned to add a photo to the Beaumont Hub site, browsing to and uploading the Beaumont Hub image file from the Rail Owned Properties folder.

    Now that both of your sites have photos associated with them, you can create a property flyer for each.

  6. On the site menu for the Beaumont Hub, click Infographics.

    Create infographics for the site.

    When you click Infographics, your default infographic runs for the site. Depending on your organizational settings and if you've used Business Analyst before, your result may vary. Now, you'll change the default template to Property Details to run it instantly for the second site.

  7. On the ribbon, click the name of the current infographic template. In the list, point to Property Details and click Make default.

    Make the Property Details infographic template your default.

    The Property Details template is now your default infographic. Now, you'll run the infographic.

  8. In the list, click Property Details.

    The infographic opens, populated by your site information (including photo and information from the data table) and key demographic information about the area. This infographic shows statistics for the 10-minute drive time you calculated.

    Infographic for your first site

  9. Explore the interactive elements of the infographic.

    You can zoom and pan the map by moving the pointer over the map panel, page through and filter site details, and point to the Key Demographic Facts and Annual Spending per Household for more information.

  10. Close the Property Details infographic for Beaumont Hub.

Run comparison infographics

You can use infographics to create more granular analyses and compare sites. This can be useful when marketing the qualities of two properties against each other, or when pitching a property to a particular industry. In this section, you will first run a basic comparison between the two properties. Then you will run a few more comparison infographics to look at specific features of the properties.

  1. On the map, if necessary, click the Santa Ana Depot site to open its site menu. On the menu, click Infographics.

    Your default infographic, Property Details, runs for the buffer area 10 minutes around the Santa Ana site.

  2. On the ribbon, click 10 minutes and choose Add sites to compare.

    Add sites to compare in your infographic.

    The Select Site window appears.

  3. In the Select Site window, click the Currently on map tab and choose the Beaumont Hub site.

    Add the Beaumont site from the Currently on map tab.

  4. Click Apply.

    The Beaumont Hub site is added to the infographic menu.

  5. On the ribbon, click 10 minutes to view the drop-down menu.

    Drop-down menu for infographics now with options to view each drive time buffer distance for both sites.

    The two sites with their three buffers now appear on the menu.

  6. In the drop-down menu, turn on the Side by side comparison toggle button.

    Buffers for both sites.

    Note:

    When you turn on the Side by side comparison toggle button, you will be taken directly to your side-by-side comparison infographics. You will not actually see the toggle button move.

    A side-by-side comparison infographic appears, showing site details for each of the buffers for both sites. The sites are bracketed into columns showing the three buffers, displaying information and demographics for the 10-, 20-, and 30-minute buffer drive times.

    Side by side comparison for all buffers for both sites.

    The infographic summarizes some key information that will be useful to potential buyers and site users. Creating a benchmark allows you to compare differences in key variables.

  7. For the Santa Ana site, next to the 10 minutes header, click the options button and click Make benchmark.

    Set the 10 minutes buffer for the Santa Ana Depot site as the benchmark.

    The site user will need a skilled workforce and large labor pool to draw from. Workers prefer short commutes to work, creating competition for jobs, so well-paid, new job opportunities close to where they reside will be attractive. Median household income provides a way to compare markets, calculate per-hour wages, and income expectations. Note the similarity in residential and daytime populations between the two sites within the 10-minute drive time, but the significant differences at 20 minutes and beyond.

  8. Close the infographic.

    You'll now create another comparison infographic to examine the labor profile of the regions surrounding each property. Examining which job sectors are most popular in the area can help the real estate manager, and the potential buyer, understand which industries might want to develop this property.

  9. On the Business Analyst ribbon, click Reports, click the Build Reports tab, and choose Build Infographics.

    Build infographics in the Build Report menu

  10. In the Reports pane, select Add template and choose Browse gallery.

    Add a new template.

  11. In the Browse Gallery window, find and point to the Civilian Labor Profile template and click Add.

    Add the Civilian Labor Profile template to your saved templates.

    The template is added to your collection. It is now accessible from the My templates tab. This infographic provides more details on the job skills, employment levels, and occupations of workers within the rail sites’ trade areas.

  12. Click the My templates tab.

    The Civilian Labor Profile template has been added to your collection.

  13. Point to the Civilian Labor Profile template and click the options button and select Set as the default infographic.

    Set the Civilian Labor Profile infographic as the default.

  14. On the Business Analyst ribbon, click Maps.
  15. On the map, if necessary, click one of your sites to open the site menu and click Infographics.

    The Civilian Labor Profile infographic runs for your site.

    Civilian Labor Profile infographic for the Santa Ana Depot site.

  16. Use what you have learned to add the other site to your infographic and turn on Side by side comparison.
    Tip:

    On the infographic ribbon, click 10 minutes, click Add sites to compare and add the other site. Click 10 minutes and turn on Side by side comparison.

    Comparison of the Civilian Labor Profile for both sites.

    The civilian labor force participation shows significant differences between the two sites. Within the 20-minute drive time trade areas, Beaumont’s blue-collar jobs represent 26 percent of all occupation employment compared to 32 percent for Santa Ana. Service industry employment rates are similar. Labor force participation is also about 6 percent lower for Beaumont at a 20-minute drive, suggesting that there may be a pool of workers not in the labor force, which is confirmed by the unemployment rate differences.

    Exploring the occupations in more detail using the job types charts, transportation workers are the sixth-largest segment in Beaumont compared to Santa Ana, while manufacturing is fifth in both markets. This identifies differences in worker experience, supply, and demand, which may also lead to differences in hourly wage expectations and worker availability between the two sites if the potential use is as a transportation hub or manufacturing site.

This lesson showed how you can use Business Analyst to create boardroom-ready reports and infographics using site information from spreadsheets, tables, or web sites. Using comparison analysis and benchmarks, you can explore and examine multiple possible use cases for the rail site, understand the pros and cons of each location, and gain more contextual knowledge about the labor pools and market characteristics that support the sites.

You can find more lessons in the Learn ArcGIS Lesson Gallery.