Spectrum Spatial (SSA/LIM)

Hi Guys,

I am wishing to configure a query that returns objects within or intersecting a buffer of a currently selected object, can this be achieved in SSA and if so where and how.

cheers

 

Hi Peter,

Currently it is possible, however, you will have to create a custom template for this process. @Mitchell Holliday? @Max Ainscough? have a example of this process within a SSA demo server.

We will be reviewing the whole query process in a future release. This will include the ability to create advanced queries.

Regards

Andy

?Thanks Andy, is the demo server publicly accessible and is the example template available for users to download?

I for one would really like to implement this type of query as its important for our Council LIMS process. Essentially for us this type of query is used to return building consents within 100m from a selected property. Feeds into area history for type of businesses at the location, possible ground contamination issues.

cheers

Hi Peter, We do have some public sites (I will post a link) and we do have a few custom templates via the download link on the top menu on this site. We are making some changes to the SSA architecture over the coming releases, which will help us create a more stable, richer product. However, doing so could also impact some of the custom templates. My suggestion would be to look at understanding how they work and how they're deployed. Once you have further questions please post on here and we will provide further assistance. Regards Andy

You need this link: http://communitydownloads.pbinsight.com/code-exchange/product/spectrum-spatial-analyst

Hi Andy,

Thank you for the link to the html template locations, I was aware of these ones and have utilised and implemented the custom css and icons example within our sites templates and added links that automate searches in our public website for relevant policies, District Plan section documents and rates against a property.

thanks

Hi Andy,

I think what I'll do for the moment is to setup a SQL function, stored procedure to perform the spatial query SQL server side within a sql view within the DB and just return the results back to Spectrum Spatial using a data bind, as in my case I only need the text data not the objects. 

I do have a data bind that pulls current information but over time as properties change hands, are subdivided, or amalgamated, history is lost. To allow for this our GIS consents data is simply built from cadastre which allows spatial queries to pull historical data for properties that used to exist at a given location.

I'm sure all SSA users would make use of an ability to configure spatial queries within SSA though, as this would be very handy.

With this in mind within SSA you can currently perform spatial queries for an object at a location by using a buffered annotation created from the selected object. This does however require that the layer is available within a map overlay. In my case the layer has over 67400 objects which in my mind will be detrimental to SSA performance.

cheers

 

Hey @Peter van Dijk? Did you manage to get the advanced query configuration in SSA?

Hi @Andy d'Andilly? I believe the infotemplate that has been configured to Sewer layer in public sector map configuration from https://spectrumspatial.com/web/landing/ (https://spectrumspatial.com/connect/analyst/mobile/#/main?mapcfg=LGS%20Assets) will help Peter van DijK. Where do we get access to such material? It would help user like us to experiment more with SSA.

Thanks!

HI Krishna, I've ended up creating a DB table and linking via data bind. The SQL table is generated via scheduled script and takes about 25mins to generate approx 1.2 million rows of spatial match data.

The demo sites look interesting, It would be great if those templates could be made available via the PB downloads SSA examples site. I am really interested in being able to present those type of visualisations for census / statistics data.

Hopefully @Andy d'Andilly? and @Max Ainscough? will get together and decide to release these types of templates with some baking instructions, the community as a whole I feel would benefit greatly.

cheers

 

?