Spectrum Spatial (SSA/LIM)

Use coordinates with feature service SQL query

  • 1.  Use coordinates with feature service SQL query

    Posted 29 days ago
    Hi!

    Is it possible to use feature geometry filed in featureService.searchBySql where clause and therefore construct spatial query in SSA? For example, is it possible to get only these points, which coordinates are smaller than some variable. Something like that: this.featureService.searchBySql({sql:"Select * from \"TABLE\" where feature_x<var_x"}).subscribe((data) =>... });
    As this service I'm working with should work with every layer client adds to this service, I can't use Enterprise Designer REST for that. And as layers are too big to load all data to browser cache to filter objects after Feature Service request, I need some method to spatially query Spectrum tabels straight from SSA.

    Thanks in advance,


    ------------------------------
    Ott Koik
    Ruumab OÛ
    Tartu
    ------------------------------