Adding an Enterprise Geocoding Module U.S. Database Resource
Whenever you install a new database resource or modify an existing database resource you must define it in Management Console in order for it to become available on your system. This procedure describes how to add or modify a U.S. database resource for the Enterprise Geocoding Module.
- If you haven't already done so, install the dataset files on your system. For instructions on installing databases, see the Spectrumâ„¢ Technology Platform Installation Guide.
- In Management Console, under Resources, choose Spectrum Databases.
- To create a new database resource, click the Add button . To make changes to an existing database resource, select it, then click the Edit button . To delete a database resource, select it, then click the delete button .
-
If you are creating a new database resource, on the Add
Database page, enter a name for the database resource in the
Name field. The name can be anything you choose. If
you are creating a new database by copying an existing one, rename the default
name as needed. 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.
Note: If you are using the Enterprise Geocoding Module with the Siebel Module, name the U.S. geocoding database KGDDatasource.
-
In the Pool size field, specify the maximum number of
concurrent requests you want this database to handle.
The optimal pool size varies by module. You will generally see the best results by setting the pool size between one-half to twice the number of CPUs on the server, with the optimal pool size for most modules being the same as the number of CPUs. For example, if your server has four CPUs you may want to experiment with a pool size between 2 (one-half the number of CPUs) and 8 (twice the number of CPUs) with the optimal size possibly being 4 (the number of CPUs).
- In the Module field, select GeoStan. The Type field, US Geographic Coders, is selected by default.
-
To add a new dataset, under Data Source, click the Add
button . In the Path field, specify
the folder that contains the dataset files.You can type in a path or click the
Browse button to locate the dataset you need, then click
Ok. You can include multiple dataset paths. This
allows you to specify a single resource that includes both the primary dataset
and any optional datasets you may have, such as DPV, LACSLink, or
elevation data.
For DPV and LACSLink datasets, the interface provides Yes/No indicators on whether DPV and LACSLink data are detected in any of the defined paths for the database resource.
- If you have additional datasets to add, click the Add button . To edit a dataset path, select the dataset, then click the Edit button . To remove a dataset, select the dataset, then click the delete button .
-
If you have multiple datasets and want to reorder them, select a dataset and click the Up
or Down
button
to move the file in the dataset list.
Note: The order of the datasets sets the priority of the dataset to use when a match is made to multiple same-level datasets; for example, a match made to 2 streets datasets. In this case, the dataset listed higher will be used.
- When you are done with your changes, click Save.