Create points from a table

Data that is spatial in nature is not always stored in a spatial data format. For example, street addresses and latitude-longitude coordinates identify geographic locations but are often stored in spreadsheets, databases, or text files. If you have geographic information stored as a table, ArcGIS Pro can display it on a map and convert it to spatial data.

Overview

Create points from a table overview video

• Video length: 9:24.
• This video was created with ArcGIS Pro 2.8.

In this tutorial, you'll create spatial data from a table containing the latitude-longitude coordinates of huts in a New Zealand national park. Huts in New Zealand are equivalent to cabins in the United States—they may or may not have sleeping bunks, kitchen facilities, electricity, and running water. The table of hut locations is stored as a comma-separated values file (.csv). CSV is a common, nonproprietary file format for tabular data.

• Estimated time: 45 minutes
• Software requirements: ArcGIS Pro Basic

Note:

The quick-start tutorials are updated at each software release. For the best experience, use an online help version that matches your software version.

Open the project

Your study area is Egmont National Park in the Taranaki region of New Zealand.

1. Start ArcGIS Pro and sign in if necessary.
2. On the start page, next to the list of recent projects, click Open another project.

   Note:

   If you already have a project open, click the Project tab on the ribbon. In the list of side tabs, click Open. On the Open page, click Open another project at the top of the page.

3. On the Open Project dialog box, under Portal , click ArcGIS Online .

   Note:

   If you are signed in to ArcGIS Enterprise , you must set your active portal to ArcGIS Online to access the tutorial data. If you can't do this, you can download the data from a browser.

4. At the top of the dialog box, in the Search box, type Create points from a table and press the Enter key.
5. In the list of search results, click Create points from a table to select the project package.

   Note:

   If there is more than one project package with this name, select the package with the Authoritative badge . In the Owner column, the owner name is ArcGISProTutorials. If you don't get any results, see No search results are returned.

6. Click OK.

   The project opens to the Taranaki region on New Zealand's North Island. The boundary of Egmont National Park is drawn with an orange outline. Mount Taranaki is in the center of the park.

   The active view is a 2D map named Egmont. The project also contains a 3D scene named Egmont 3D, which is not currently open.

   

7. On the ribbon, click the View tab. In the Windows group, click Reset Panes and click Reset Panes for Mapping (Default).

   This ensures that the Contents and Catalog panes are open and that other panes are closed.

8. On the ribbon, click the Map tab. In the Navigate group, click Bookmarks , and under Egmont Bookmarks, click Egmont National Park to zoom in to the park.

Make a feature class from a .csv file

The .csv file is stored as an attachment in your project package. You'll add it to the map as a table and convert it to a feature class with a geoprocessing tool.

1. On the Map tab, in the Layer group, click Add Data .
2. On the browse dialog box, in the list of quick links, under Project , click Folders .
3. In the window on the right, browse to Create_points_from_a_table > commondata > userdata.

   

   The userdata folder contains a .csv file and a text file with metadata.

4. Click Egmont_National_Park_Huts.csv to select it and click OK.

   The .csv file is added to the Contents pane under Standalone Tables.

   Note:

   In a project package, files that can't be stored in a geodatabase—such as shapefiles, .csv files, and text files—are included as attachments. In the project package folder structure, attachments are stored in the <project home folder>\commondata\userdata folder.

5. In the Contents pane, right-click Egmont_National_Park_Huts.csv and click Open .

   

   The table's attributes include the name and type of hut, the number of people it accommodates, and its latitude-longitude coordinates in decimal degrees. Latitude-longitude coordinates, or some other set of x,y coordinate system values, are needed to create a feature class from a table.

6. Close the table.
7. In the Contents pane, right-click Egmont_National_Park_Huts.csv, click Create Points From Table and click XY Table To Point .

   Note:

   The XY Table To Point tool can also be opened from the Standalone Table tab, on the Create Points group, by clicking From Table and then clicking XY Table To Point .

   The XY Table To Point window appears. The Input Table parameter is correctly set to the .csv file. The X Field and Y Field parameters are also correctly set to LONGITUDE and LATITUDE, respectively.

   Note:

   For convenience, some geoprocessing tools open in a floating window. You can also open these tools in the Geoprocessing pane.

8. Change the Output Feature Class name to ENP_Lodgings.

   ENP stands for Egmont National Park.

9. Leave the Z Field parameter empty.

   The table doesn't contain elevation values for the huts.

   The Coordinate System parameter is set to GCS_WGS_1984. This coordinate system is used by default because it is a common one for latitude-longitude values. In fact, it is the correct coordinate system for this data. (You can confirm this by opening the Egmont_National_Park_Huts_metadata.txt file.)

   

10. Click OK.

    

    When the operation finishes, a new feature class is created in the project geodatabase. A layer named ENP_Lodgings, representing the hut locations, is added to the map with default symbology.

11. In the Catalog pane, expand Databases and expand create_points_from_a_table.gdb to see the new feature class.

    

Add metadata

You can add item description metadata to the feature class. An item description includes a title, summary, description, and tags. It may also include credits and use limitations. Metadata provides important background information about your data. It is indexed by ArcGIS Pro to generate search results when you search for data.

1. In the Catalog pane (not the Contents pane), right-click the ENP_Lodgings feature class and click Edit Metadata .

   A metadata view opens. In the Contents pane, the elements of the metadata style are displayed.

   

   Note:

   If you're using the default Item Description metadata style, the only element listed in the Contents pane is Item Description. The metadata element is currently invalid because required information is missing. If you're using a different metadata style, you'll see other metadata elements as well. Item Description is the only element you will edit in this tutorial.

2. In the metadata view, in the Title box, type Egmont National Park Lodgings.
3. In the Tags box, type (or copy and paste) the following keywords: cabins, hotels, huts, Egmont National Park, Taranaki, New Zealand.

   Make sure the keywords are separated by commas.

4. In the Summary (Purpose) box, add the following text: Locations of huts, lodges, and hotels in Egmont National Park for planning hiking and ski trips.
5. Click in the Description (Abstract) text box.

   In the Contents pane, the Item Description element is now marked valid because the required information is present.

6. In the Description (Abstract) box, add the following text: Features were created from a CSV file with latitude-longitude coordinates and projected to NZTM. The source coordinates were derived from measurements made by Peter Scott. Peter Scott’s data was published on May 13, 2015, and is shared under a Creative Commons Attribution 3.0 New Zealand license. Peter Scott’s dataset is more accurate than this dataset. For more information, see the online dataset Egmont National Park - Huts, accessible at https://koordinates.com. Additional features in this dataset were digitized on the Esri World Imagery basemap.
7. In the Credits box, add the following text: Peter Scott ([e-mail]); koordinates.com.
8. Under Credits, click New Use Limitation . In the Use Limitation box, add the following text: Creative Commons Attribution 3.0 New Zealand.

   Note:

   If spell-checking is enabled on the settings page (as it is by default), unrecognized words are marked with wavy underlines. See Proofing options for more information.

9. On the ribbon, on the Metadata tab, in the Manage Metadata group, click Save .
10. Close the ENP_Lodgings metadata view.
11. On the Quick Access Toolbar, click Save Project .

Examine the layer

You'll zoom in on a couple of features in the ENP_Lodgings layer to make sure they are actually located on buildings. You'll also change the layer's name.

1. On the Egmont map, zoom in close on any point feature.

   

2. Optionally, examine one or two other features.
3. In the Contents pane, right-click the ENP_Lodgings layer and click Properties .
4. On the Layer Properties dialog box, on the General tab, change the layer name to Lodgings.
5. Optionally, click Apply.

   It isn't necessary to click Apply because every change you make in the Layer Properties dialog box is saved when you click OK. However, clicking Apply allows you to see layer name changes reflected immediately on the Contents pane. This is useful when you are making several changes and want to confirm the effect of a change before committing other changes.

6. Click OK.

   The layer name is updated in the Contents pane.

7. On the ribbon, click the Map tab if necessary. In the Navigate group, click Bookmarks . Under Egmont Bookmarks, click Egmont National Park.
8. On the Quick Access Toolbar, click Save Project .

Symbolize the layer

You'll set a minimum scale for the layer so the huts don't display at small scales. You'll also set scale-based sizing for the layer so the symbols get larger as you zoom in. Finally, you'll choose a symbol that shows up well on the imagery basemap.

1. In the Contents pane, click the Lodgings layer to select it, if necessary. On the ribbon, click the Feature Layer tab.
2. In the Visibility Range group, click the drop-down arrow next to Minimum Scale and click 1:500,000.

   Tip:

   If 1:500,000 is not in the drop-down list, type the value directly into the input box or choose a different value.

3. In the Contents pane, click the symbol for the Lodgings layer.

   

   The Symbology pane appears and displays options to format point symbols.

4. At the top of the pane, click the Gallery tab, if necessary. In the scrolling box of symbols, under ArcGIS 2D, click Square 1. (Choose the solid black symbol, not Square 1 40%, which is partially transparent.)
5. At the top of the pane, click the Properties tab. Confirm that the Symbol tab is selected under it.
6. Check the Enable scale-based sizing check box.

   A slider appears under the Size property. It has two size stops (short vertical bars) that represent the minimum and maximum map scales for which symbol sizes can be set.

7. Hover over the leftmost size stop.

   

   The first stop is set at 1:500,000. This is the smallest scale at which the layer is visible because of your minimum scale setting.

8. Hover over the other size stop.

   This stop is set at 1:1,000, the largest scale to which you can assign a symbol size. You can zoom in closer than 1:1,000 on the map, but the symbol size won't increase. The second stop is currently selected (blue). Above the slider, the size value for the selected stop is 10 pt.

9. Change the Size value to 12 pt.

   This will be the maximum size of your symbol.

10. Click the first size stop to select it.

    The size value for this stop is currently 10 pt.

11. Change the Size value to 2 pt.

    When the map scale is 1:500,000, the Lodgings symbol will be 2 points in size. As you zoom in, the symbol size will gradually increase until it reaches a maximum size of 12 points.

12. At the top of the pane, under Properties, click the Layers tab .
13. Under Appearance, click the Color drop-down arrow. On the color palette, click Anemone Violet.

    

14. Change the Outline color setting to Gray 30%.

    

15. Change the Outline width value to 1.5 pt and press the Enter key.
16. At the bottom of the pane, click Apply.

    

    At the current map scale, the symbol outline may not be noticeable.

    Note:

    In ArcGIS Pro, thin lines are simulated with transparency when antialiasing is turned on (as it is by default). If you need to see a thin line, such as a symbol outline, at all scales, turn off antialiasing.

17. On the ribbon, click the Map tab. In the Navigate group, click Bookmarks . Under Egmont Bookmarks, click Taranaki Region.

    The map zooms out to a regional scale and the symbols do not display on the map.

18. In the map scale box in the lower left corner of the map view, click the drop-down arrow and click 1:500,000.

    The layer displays and the features appear at their minimum size.

19. Zoom in gradually to see the symbol size increase.

    

20. Go to the Egmont National Park bookmark.
21. On the Quick Access Toolbar, click Save Project .

Add a feature interactively

The Lodgings layer has 13 features: 10 huts that belong to the Department of Conservation and 3 that belong to alpine clubs. In addition, there are 2 resort hotels inside the park that aren't in the .csv file. In this section, you'll locate the first of these hotels, Dawson Falls Mountain Lodge, and add a feature to the layer. When you add the feature to the layer, you are actually adding it to the ENP_Lodgings feature class that is the layer's data source.

1. On the ribbon, on the Map tab, in the Inquiry group, click Locate .

   The Locate pane appears.

2. In the Locate pane, click the Options drop-down arrow to see your locate providers. Confirm that ArcGIS Geocoding service is included in the list and that it is enabled.

   A locate provider finds map locations from text descriptions or spatial coordinates. Default locate providers with ArcGIS Pro include XY provider and ArcGIS Geocoding service.

3. Click Options again to collapse the list.

   You'll search for Dawson Falls Mountain Lodge by its name.

4. In the Locate pane, in the search box, type Dawson Falls Mountain. Do not press the Enter key.

   As you type, a list of suggestions appears and updates.

5. Hover over the first entry for Dawson Falls Mountain Lodge (there may be more than one) and confirm that the address is Dawson Falls Mountain Lodge, Manaia Road, Egmont National Park, Taranaki, 4391, NZL.

   

6. Click the highlighted entry.

   The map zooms in and a marker is placed at the end of Manaia Road.

7. In the map scale box at the bottom of the view, click the drop-down arrow and click 1:1,000.

   The marker is located about 75 meters north of the lodge, but it's close enough for your purposes.

   

8. In the Locate pane, right-click the marker and click Add To Feature Class .
9. In the Add To Feature Class dialog box, expand Lodgings and click the Lodgings feature template.

   

10. Click OK.
11. In the Locate pane, in the search box, click Delete to clear the address.

    The temporary marker is removed from the map. The new feature in the Lodgings layer is selected. You'll add attribute values to the feature.

12. On the ribbon, click the Edit tab. In the Selection group, click Attributes .

    The Attributes pane appears and displays attributes for the selected feature.

    Note:

    The NAME field is automatically populated with information from the Locate pane.

13. In the lower half of the Attributes pane, on the Attributes tab, click in the NAME text box and edit it to read Dawson Falls Mountain Lodge. Press the Tab key.
14. For TYPE, type Hotel and press the Tab key.
15. For CAPACITY, type 24. Click Apply.

    You can leave <Null> values in the LATITUDE and LONGITUDE fields.

16. On the Edit tab, in the Selection group, click Clear .

Add another feature

The second hotel in the park is the Stratford Mountain House on Pembroke Road. You'll locate it by its latitude-longitude coordinates.

1. Make the Locate pane active. In the search box, type (or copy and paste) 174.12248, -39.306201 and press the Enter key.

   Results are found by both the XY provider and the ArcGIS Geocoding service.

   

   The map zooms to the XY provider location highlighted in the pane and a marker is added.

2. In the Locate pane, right-click the highlighted candidate and click Add To Feature Class .
3. On the Add To Feature Class dialog box, expand the Lodgings heading, if necessary, and click the Lodgings feature template. Click OK.
4. In the Locate pane, in the search box, click Delete to remove the temporary marker.

   You see the new, selected feature representing Stratford Mountain House.

5. Make the Attributes pane active. Click in the NAME text box and replace the x,y coordinates with Stratford Mountain House. Press the Tab key.
6. For TYPE, type Hotel and press the Tab key.
7. For CAPACITY, type 22. Click Apply.
8. On the ribbon, on the Edit tab, in the Selection group, click Clear .

   

9. In the Manage Edits group, click Save . On the Save Edits prompt, click Yes.
10. In the Contents pane, right-click the Lodgings layer and click Attribute Table . Scroll to the bottom of the table.

    

    The table has 15 records, including records for the two features you just created.

11. Close the table.
12. On the ribbon, click the Map tab and go to the Egmont National Park bookmark.
13. On the Quick Access Toolbar, click Save Project .

View the layer in the 3D scene

You can display 2D layers in 3D scenes. The scene's elevation surface correctly positions the 2D features in a 3D landscape. You'll copy the Lodgings layer from the Egmont map and paste it into the Egmont 3D scene.

1. In the Contents pane, right-click the Lodgings layer and click Copy .
2. Make the Catalog pane active and expand Maps . Right-click Egmont 3D and click Open Local View .

   The Egmont 3D scene opens and becomes the active view.

   Tip:

   You can open the scene in global or local view mode. This scene has a relatively small extent and uses a projected coordinate system, so a local view is appropriate. To change the view mode for an open scene, click the View tab on the ribbon. In the View group, click Global or Local .

3. In the Contents pane, right-click the scene name, Egmont 3D, and click Paste .

   The Lodgings layer appears in the 2D Layers category of the Contents pane.

4. On the ribbon, on the Map tab, in the Navigate group, make sure the Explore tool is selected.
5. Use the mouse buttons and wheel button to zoom, pan, tilt, and rotate the scene. Alternatively, use the on-screen navigator in the scene.

   The features display in their correct locations on the 3D surface, but the symbols lie flat on the surface—like bits of paper stuck to the mountain.

6. In the Contents pane, drag the Lodgings layer from the 2D Layers category to the 3D Layers category.

   The layer now uses 3D drawing properties, but for the moment the lodging symbols may be hard to see on the map.

7. In the Contents pane, double-click the Lodgings layer to open its properties.
8. On the Layer Properties dialog box, click the Display tab. Under Display symbols in scene, confirm that the Screen units option is selected. Click the Improved perspective check box and click OK.

   The symbols stand up on the surface. This effect is called billboarding. It's an improvement, but a symbol designed for 3D viewing will look even better.

9. In the Contents pane, click the symbol for the Lodgings layer.
10. In the Symbology pane, under Format Point Symbol, click the Gallery tab, if necessary.
11. Next to the search box, click the All styles drop-down arrow and click Project styles.

    The Project styles setting includes the styles added by default to your ArcGIS Pro project, as well as any styles you add yourself. The All styles setting includes all system styles installed with ArcGIS Pro. Choosing Project styles narrows the scope of symbol searches.

12. In the search box, type cube and press the Enter key.
13. In the list of symbols, under ArcGIS 3D, click Standing Cube.

    

    You can access more symbols by adding styles.

14. At the top of the pane, click the Properties tab. Click the Symbol tab under it, if necessary.
15. Click the Color drop-down arrow and click any color you like. Change the Size setting to 9 pt and click Apply.

    Note:

    Scale-based sizing is not available in scenes. For this scene, a 9 or 10 point symbol works well at most scales but may be too small or too large at some scales.

16. Continue to explore the scene using navigation tools and Egmont 3D bookmarks.

    

17. On the Quick Access Toolbar, click Save Project .

You can convert a tabular dataset, such as a Microsoft Excel file or a .csv file, to spatial data in ArcGIS Pro as long as the table includes street addresses or spatial coordinates. This allows you to visualize and spatially analyze a wide variety of data—from customer lists to tables scraped from websites—that is spatial in nature but not yet spatially enabled.