Creating a Routing Database Resource - spectrum_platform - 23.1


Product type
Product family
Spectrum > Geocoding > Enterprise Tax
Spectrum > GeoEnrichment
Spectrum > Web Services
Spectrum > Spatial > Spectrum Spatial
Spectrum > Spectrum Platform
Spectrum > Data Integration
Spectrum > Quality > Addressing
Spectrum > Quality > Spectrum Quality
Spectrum > Discovery
Spectrum > Dataflow Designer
Spectrum > Quality > Context Graph
Product name
Precisely Spectrum
First publish date

You must be a Spectrum Technology Platform administrator (admin) or Spatial administrator (spatial-admin) to perform this task. If you are a Spatial sub-administrator (spatial-sub-admin), then you must have permission to the folder that you are adding to or editing.

To create a routing database resource for Spectrum:
  1. In Management Console, go to Resources > Spectrum Databases.
  2. Click the Add button to create a new database resource, or change an existing database resource by clicking the Edit button .
    Note: You can create a new database resource by copying an existing one by clicking the Copy button .
  3. If you are creating a new database, enter a name for the database resource in the Name field.
    The name can be anything you choose. If you create a new database by copying an existing one, then rename it. You cannot modify the name of an existing database resource, because any services or jobs that reference the database resource by its original name would fail.
  4. Change the Pool Size value if needed, by specifying the maximum number of concurrent requests you want this database to handle.
    Note: This setting represents the number of threads on the components that are listening for service requests from the Spectrum Technology Platform for executing a Spatial routing stage (that is, the maximum number of managed connections). Every web service request enters Spectrum from the platform and passes to the components. To accommodate greater request loads, increase the default value (which is 4). We recommend a pool size that matches the number of CPUs. The maximum setting should not go above twice the number of the CPU core; for example, on a 4 CPU machine, the combined number of threads for all services should not exceed 8. Run performance tests with various settings to find the optimal performance.
  5. Specify the Min memory (MB) and Max memory (MB) heap memory values.
  6. In the Module field, select Spatial.
  7. In the Type field, select Enterprise Routing.
  8. From Network Type, select the type of network that is applicable for the database. You can choose between Driving and Pedestrian.
    A list of available databases appears in the table below. Each database is listed with its description and vintage.
  9. Select the databases from the list.
    To find out more about installing Spectrum data, see Installing a Spectrum Database.
  10. Select Override advanced settings if applicable. This feature lets you override settings such as additional command-line arguments when starting process, properties, and environment variables for remote process.
  11. Click Save to add the database.
    A list of the Spectrum databases and their status displays. (It may take a moment to refresh the Status column.)
The database resource now displays in the list of available database resources for Route, Travel Boundary, Cost Matrix, Find Nearest, Get Travel Boundary, Get Travel Cost Matrix, Get Travel Directions, and Get Route Data.