Spectrum Spatial (SSA/LIM)

Hi

I need to get a colleague to update the address search database used in the front end of SSA. The dataset that is used, according to the admin console, is called "Locate - Address1". In our SQL addressing database I can see a view called "Spectrum_address_search". This has been updated recently and when I add the SQL addressing layer to SSA I can see the new address points mapped. But, the new addresses in the source database and map are not available when searching in the search box. Is there a process or script to run on the SSA server to update the search facility?

Many thanks

Chris

------------------------------
Chris Dickinson
North Yorkshire County Council
------------------------------

Are you looking in the 'Address and Routing' tab of the Administration Console Chris?  If so, you would need a csv of the data, minus headings, and with only some sort of address string column, plus an x and a y column.  Check your projection then upload you csv file using the button and dialogue provided.  That is how I have done this in the past.  My data comes in a csv anyway so I just trim the csv to suit.  The different address dataset dropdown would allow you to create multiple address locators, each of which can be assigned to different functionality profiles.
There may be different ways to do this but I have found this to work.

If you want to see when your Address locator was last updated, and check that your csv uploaded correctly,  check here:

...Pitney Bowes\SpectrumSpatialAnalyst\customerconfigurations\analyst\luceneCSVdata

on your application server.  Look at it in details view and you'll see the date.

Hope this helps.

------------------------------
Sean Stephen
Belfast City Council
Belfast
------------------------------

Thanks Sean

------------------------------
Chris Dickinson
North Yorkshire County Council
------------------------------

Original Message:
Sent: 07-04-2022 09:17
From: Sean Stephen
Subject: Updating address search facility in SSA front end v2018

Are you looking in the 'Address and Routing' tab of the Administration Console Chris?  If so, you would need a csv of the data, minus headings, and with only some sort of address string column, plus an x and a y column.  Check your projection then upload you csv file using the button and dialogue provided.  That is how I have done this in the past.  My data comes in a csv anyway so I just trim the csv to suit.  The different address dataset dropdown would allow you to create multiple address locators, each of which can be assigned to different functionality profiles.
There may be different ways to do this but I have found this to work.

If you want to see when your Address locator was last updated, and check that your csv uploaded correctly,  check here:

...Pitney Bowes\SpectrumSpatialAnalyst\customerconfigurations\analyst\luceneCSVdata

on your application server.  Look at it in details view and you'll see the date.

Hope this helps.

------------------------------
Sean Stephen
Belfast City Council
Belfast
------------------------------

Hi Chris,

The Commandline-uploader tool, simple java utility, has been included with Spectrum for a few generations now, docs linked below are for 19.1 but should be valid equally for 18 - Spectrum Spatial™ Guide - Locator Uploader Command Line Utility (precisely.com)

Similar to you we have a view in our SQL database that creates a table with the required addressing/searchable terms and coord values.

The Locator Uploader can be configured to access the database and relevant table, then update the relevant SearchIndex on Spectrum.

We have a couple of these (map project contexts driving different search requirements) that are run as batch file scheduled tasks on the server each night. It is pretty failsafe and I can't recall it erroring at any point in the last few years. Keeps the address up-to-date and completely hands off.

Cheers,

------------------------------
William Dean
Cairns Regional Council
Cairns QLD
------------------------------

Thanks William

------------------------------
Chris Dickinson
North Yorkshire County Council
------------------------------

Original Message:
Sent: 07-04-2022 18:30
From: William Dean
Subject: Updating address search facility in SSA front end v2018

Hi Chris,

The Commandline-uploader tool, simple java utility, has been included with Spectrum for a few generations now, docs linked below are for 19.1 but should be valid equally for 18 - Spectrum Spatial™ Guide - Locator Uploader Command Line Utility (precisely.com)

Similar to you we have a view in our SQL database that creates a table with the required addressing/searchable terms and coord values.

The Locator Uploader can be configured to access the database and relevant table, then update the relevant SearchIndex on Spectrum.

We have a couple of these (map project contexts driving different search requirements) that are run as batch file scheduled tasks on the server each night. It is pretty failsafe and I can't recall it erroring at any point in the last few years. Keeps the address up-to-date and completely hands off.

Cheers,

------------------------------
William Dean
Cairns Regional Council
Cairns QLD
------------------------------