1. Navigate to the Datasets page.
2. Click Create Dataset.
   The Create Dataset window opens:

   Figure 3-6 Creating a Dataset

   
   Description of "Figure 3-6 Creating a Dataset"
3. Click on one of the data source options and perform the steps appropriate to your selection as shown in the following:
   From file upload:

   1. Upload one of the supported file types.
   2. Click Create.

   From table/view:

   1. Select a connection from the Select Connection drop-down.
   2. Click Create.

      The Select items to create datasets window opens listing all the tables, views and GeoRaster data present in the database.

      Figure 3-7 Select the Data Source

      
      Description of "Figure 3-7 Select the Data Source"
   3. Select an item from the list and click OK.

   From Cesium datasets:

   1. Create a dataset for Cesium map visualization by selecting a 3D dataset file or a CZML file.

      Figure 3-8 Options for Creating a Cesium Dataset

      
      Description of "Figure 3-8 Options for Creating a Cesium Dataset"

      You can choose one of the following options:

      • Upload czml file: Upload a .czml file.
      • Upload tileset: Upload a tileset zip file. The supported formats are:
        • .b3dm: Batched
        • .pnts: Point Cloud

        Tip:

        You can increase the default size limit for zip files larger than 50 MB by updating the dataset_max_size attribute for the upload property defined in <user_home_folder>/.sgtech/sgtech_config.json file.
      • Czml file located on server: Specify the czml file to be uploaded from the server by entering the Name of the .czml file and the Directory path.
      • Tileset located on server: Specify the tileset file to be uploaded from the server by entering the Name of the tileset.json file and the Directory path.

      Note:

      When uploading a CZML file or a tileset file from the server:

      • If the file is not under <SGTECH_HOME>/cesiumdata or <SGTECH_HOME>/3d-tilesets as it may apply, then you must manually migrate the datasets when migrating Spatial Studio.
      • You can update the unzipped file limits in the General tab in the Administration page. The following two advanced settings parameters need to be modified:
        • Maximum unzipped item
        • Maximum unzipped total
   2. Click Create.

   From GeoJSON URL:

   It is important to note the following prior to creating a GeoJSON URL dataset:

   • A GeoJSON URL based dataset accesses its data directly from the source URL. There is no database table managed in Spatial Studio for this dataset.
   • A GeoJSON URL based dataset does not support Spatial Analysis.
   • A GeoJSON URL based dataset is subject to the same upload size limit, or 100MB, whichever is smaller.
   • If a GeoJSON URL does not support CORS (Cross-Origin Resource Sharing), then Spatial Studio will act as a proxy to the browser requesting the GeoJSON URL data.

   The following steps enable you to create a GeoJSON URL dataset:

   1. Specify the GeoJSON URL to access GeoJSON data from an external domain for map visualization.

      Note:

      Ensure you add the external domain used for accessing GeoJSON data to the list of entries in the Safe Domains list.
   2. Click Create.

      Create dataset from GeoJSON window opens as shown:

      Figure 3-9 Creating a Dataset from GeoJSON

      
      Description of "Figure 3-9 Creating a Dataset from GeoJSON"
   3. Optionally, enter a Dataset name.
   4. Click Submit.

      The GeoJSON URL dataset gets created with the warning, No key column was found. You must resolve the warning in order to use the dataset as a map layer for visualization. See Datasets with Issues for more details to resolve the warning.

   The new dataset is added and listed on the Datasets page.

• Enabling Spatial on a View-Based Dataset with Latitude and Longitude Columns
  

1. Navigate to the Datasets page.
2. Right-click on the dataset name on which you want to apply geocoding.
3. Select Geocode Addresses from the Prepare context menu.
   Geocode Addresses dialog opens as shown:

   Figure 3-12 Geocode Addresses

   
   Description of "Figure 3-12 Geocode Addresses"
4. Select the Geo-type for the geo-attributes to be used for geocoding.
5. Optionally, switch ON Save coordinates in columns to save the geocoordinates to the dataset and to the underlying database table.
6. Optionally, enter Latitude column name and Longitude column name, if you switched ON Save coordinates in columns in the preceding step.
7. Click Apply.
   You can monitor the Geocode dataset background task on the Jobs page. A successful completion of the job indicates that geocoding is applied for the data in the dataset.
   You can verify that geocoding has been applied by viewing the latitude and longitude columns in the dataset properties and in the input source database table along with the GC_GEOMETRY column of data type SDO_GEOMETRY.

1. Navigate to the Datasets page.
2. Right-click on the dataset name on which you want to apply reverse geocoding.
3. Select Reverse Geocode from the Prepare context menu.
4. Optionally select and modify the required Location attributes as shown in Figure 3-13.
   The Input text fields for Location attributes are the column names to be created in the underlying database table for the target dataset.
5. Click Apply.
   You can monitor the Reverse geocode dataset background task on the Jobs page. A successful completion of the job indicates that reverse geocoding is applied for the data in the dataset.
   By viewing the dataset properties, you can verify that reverse geocoding has been applied to your dataset as shown in the following figure:

   Figure 3-13 Reverse Geocoding

   
   Description of "Figure 3-13 Reverse Geocoding"

1. Navigate to the Datasets page.
2. Right-click on the non-spatial dataset which you want to join to a spatial dataset.
3. Select Join to Spatial Dataset from the Prepare context menu.
   The following window opens:

   Figure 3-14 Joining to a Spatial Dataset

   
   Description of "Figure 3-14 Joining to a Spatial Dataset"
4. Optionally, enter a dataset name for Name of join result dataset.
5. Select the Spatial dataset for the join.
   On selection, the primary key associated with the spatial dataset is validated against the non-spatial dataset key. If the datasets key values are not suitable for a join operation, then the following error is displayed:

   Dataset key columns to join must be the same data type

6. Optionally, select the required columns for the joined result dataset from the non-spatial and spatial datasets.
7. Click OK.

   The joined dataset is created and it appears as a row on the Datasets Page. This dataset will contain all the column properties selected from both the spatial and non-spatial datasets. You can verify the properties of the joined dataset both in the Dataset Properties window on the Datasets page and when using the dataset for map visualization and analysis on the Active Projects page, as shown:

   Figure 3-15 Appended Non-spatial and Spatial Properties

   
   Description of "Figure 3-15 Appended Non-spatial and Spatial Properties"

1. Navigate to the Administration page.
2. Click Basemaps under Settings.
   The Basemaps window listing all the available basemaps opens.
3. Click Add Basemap and click on one of the following basemap types:
   • XYZ Raster tiles
   • OGC WMS
   • Vector tiles
4. Enter Name and URL for the selected basemap type.
5. Optionally enter Attribution and API Key.

   Tip:

   Once you have entered all the required fields, you can preview the basemap by clicking Quick View.
6. Click Save to add the base map.
   For example, the following figure show the OGC WMS basemap configuration window:

   Figure 3-18 Adding a OGC WMS Map

   
   Description of "Figure 3-18 Adding a OGC WMS Map"

   Note:

   It is important to add the domain name to Safe Domains in order to enable the Spatial Studio application to access the required service for the basemap.

1. Navigate to the Administration page.
2. Click Basemaps under Settings.
   The Basemaps window listing all the available basemaps opens.
3. Click against the required custom basemap and click Edit from the context menu.

   Note:

   Edit is disabled for predefined Spatial Studio maps.

   The custom basemap configuration details are displayed for editing as shown:

   Figure 3-19 Editing a Custom Basemap

   
   Description of "Figure 3-19 Editing a Custom Basemap"
4. Modify the required parameters, such as Name, Attribution, URL or API Key.
5. Click Save.
   The custom basemap details are modified and the updates are shown in the Basemaps window.

1. Click the Visualizations tab on the left pane in the Active Project page.
   This lists the various visualization options.
2. Click and drag Table from the list to the visualization window on the right to create a table visualization.
   This opens an empty layer in the visualization window.
3. Click the Data tab on the left pane in the Active Project page.
   This lists all the Datasets that are loaded for the project.
4. Click and drag the desired dataset from the list to the empty layer on the right.

   Note:

   You can view only one dataset in a table view. If you want to view multiple datasets, you must create one table view for each dataset.
   This opens the data in tabular format for visualization as shown:

   Figure 3-21 Tabular Visualization

   
   Description of "Figure 3-21 Tabular Visualization"

   You can easily scroll up or down the table to view the data rows as the table supports infinite scrolling.

   You can delete the table visualization by clicking the X icon on the top-right.

Spatial Studio supports the following types of map visualizations:

• Geometry Data Visualization:
  • Point type
  • Line type
  • Polygon / Area type
• GeoRaster Data Visualization
• Hexagonal Data Visualization using H3 Aggregations

The following sections describe how to get started on these visualizations:

• Visualizing a Point Map
  
• About GeoRaster Data Visualization
  
• About Hexagonal Data Visualization Using H3 Aggregations
  
• About Custom Map Regions Visualization
  
• Visualizing a Moving Object
  Starting from Oracle Spatial Studio Release 22.1.0, you can visualize moving objects using a spatiotemporal dataset.

Spatial Studio uses a CesiumJS plugin to enable you to view 3D visualizations using 3D Tiles or CZML data on a Cesium map.

Cesium map allows you to display your real-world geospatial 3D data in a 3D environment. In order to build interactive 3D visualizations using Cesium maps, you can upload one of the following files to Spatial Studio:

• 3D Tileset: Supports formats are:
  • Point Cloud (.pnts)
  • Batched 3D Model (.b3dm)
• CZML file: CZML formatted data in .czml files

It is important to note the following when using a Cesium map visualization:

• Generating 3D Tiles or CZML formatted data file for your geospatial 3D data must be carried out using any third party software outside of Oracle Spatial Studio.
• 3D Tiles and CZML files are stored in the file system on Spatial Studio's server, not in Oracle Database.
• Currently this feature supports only displaying 3D Tiles and CZML data on maps. It does not support 3D analysis.

• Visualizing a 3D Tileset Using a Cesium Map
  
• Visualizing CZML Data Using a Cesium Map
  

Spatial Studio allows you to explore different styling options for your map layers, in order to enhance visualization and analysis.

The styling options provided to you may vary depending on the type of data you are mapping.

The following sections describe a few styling techniques for the different data types:

• Applying a Render Style For a Point Layer
  
• Applying Style for a GeoRaster Layer
  
• Applying Data-Driven Style to a Map with H3 Aggregations
  
• Applying Predefined Colors to a Map Layer
  
• Applying Predefined Symbols to a Map Layer
  
• Setting Selection Tolerance on a Map Layer
  
• Adding a Pin on a Map
  
• Applying Map Backgrounds
  

1. Click the Settings icon in your map tool bar.
2. Switch on the Show time slider toggle button and click OK.
   A time slider bar appears at the bottom of the map visualization canvas.
3. Click the Time slider settings icon on the time slider bar.

   Figure 3-46 Time slider Settings

   
   Description of "Figure 3-46 Time slider Settings"
4. Select the Date columns and the Time unit to be applied for visualization.
5. Optionally, switch on or off the Time range and Time labels always on toggle buttons.
6. Optionally, select Playback speed.
7. Click OK.
   You can now interact with your map using the time slider to view the change of your data over time.

   Figure 3-47 Using a Time slider in Map Visualization

   
   Description of "Figure 3-47 Using a Time slider in Map Visualization"

1. Click against the dataset whose coordinates needs to be filtered in the Data tab of the Layers list.
2. Select Spatial Analysis.
   The Spatial Analysis Operations window as shown in opens.
3. Click on the Filter tab and select Return shapes within a specific distance of another.
   Within distance dialog box opens as shown:

   Figure 3-49 Spatial Analysis - Within Distance Configuration

   
   Description of "Figure 3-49 Spatial Analysis - Within Distance Configuration "
4. EnterAnalysis name.
5. Select the Layer to be filtered.
6. Select the Layer to be used as the filter.
7. Enter distance and unit.
8. Click Run.
   The Analysis result is listed under Analyses in the Data elements panel on the left pane of the Active Project page.
9. Drag and drop the analysis result on the map view.
   This creates a new map layer highlighting the filtered coordinates within a specific distance from a point as shown:

   Figure 3-50 Spatial Analysis - Within Distance Visualization

   
   Description of "Figure 3-50 Spatial Analysis - Within Distance Visualization"

1. Click against the analysis to be edited under Analyses tab in the Data elements pane of the Active Project page.
2. Select Modify Parameters as shown:

   Note:

   Modify Parameters in the context menu will be disabled for spatial analysis operations that cannot be modified.

   Figure 3-51 Modify Spatial Analysis Parameters

   
   Description of "Figure 3-51 Modify Spatial Analysis Parameters"

   The dialog box displaying the original definition for the specific spatial analysis opens.

3. Modify the required parameters and click Run.
   The analysis gets updated and the updates can be visualized in the map view.