Petascope should not ask SECORE when not necessary

[Bang Pham Huu]

Petascope has a cached of CRS comparison and it will send the request to SECORE if it doesn't contain the needed result. However, it seems it tries not effectively when in this GetCoverage 2D request EPSG:32631 it tried to compare some other kind of CRSs instead of the required '​http://localhost:8080/def/crs/EPSG/0/32631 ' CRS and it takes quite long time to process the request.

Received request: coverageId=test_landsat8&format=image/tiff&request=GetCoverage&service=WCS&subset=E(377983,378013)&subset=N(4903991,4904041)&version=2.0.1


 DEBUG [15:33:52] AbstractHandler@90: Found the request handler: petascope.controller.handler.service.KVPWCSServiceHandler
 DEBUG [15:33:52] CoverageRepostioryService@162: Time to read coverage 'test_landsat8' from database is 10 ms.
 DEBUG [15:33:52] CoverageRepostioryService@168: Coverage: test_landsat8 is read from database.
 TRACE [15:33:52] CrsUtil@1177: OGC(0):AnsiDate?axis-label="t"/EPSG(0):32631 comparison is *not* cached: need to ask SECORE.
 DEBUG [15:33:52] CrsUtil@1245: http://localhost:8080/def/equal?1=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FOGC%2F0%2FAnsiDate%3Faxis-label%3D%22t%22&2=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FEPSG%2F0%2F32631
 TRACE [15:33:52] CrsUtil@1177: OGC(0):Index2D/EPSG(0):32631 comparison is *not* cached: need to ask SECORE.
 DEBUG [15:33:52] CrsUtil@1245: http://localhost:8080/def/equal?1=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FOGC%2F0%2FIndex2D&2=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FEPSG%2F0%2F32631
 TRACE [15:33:52] CrsUtil@1177: EPSG(0):32610/EPSG(0):32631 comparison is *not* cached: need to ask SECORE.
 DEBUG [15:33:52] CrsUtil@1245: http://localhost:8080/def/equal?1=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FEPSG%2F0%2F32610&2=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FEPSG%2F0%2F32631
 TRACE [15:33:52] CrsUtil@1177: EPSG(0):32633/EPSG(0):32631 comparison is *not* cached: need to ask SECORE.
 DEBUG [15:33:52] CrsUtil@1245: http://localhost:8080/def/equal?1=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FEPSG%2F0%2F32633&2=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FEPSG%2F0%2F32631
 TRACE [15:33:52] CrsUtil@1177: OGC(0):Index1D/EPSG(0):32631 comparison is *not* cached: need to ask SECORE.
 DEBUG [15:33:52] CrsUtil@1245: http://localhost:8080/def/equal?1=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FOGC%2F0%2FIndex1D&2=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FEPSG%2F0%2F32631
 TRACE [15:33:52] CrsUtil@1177: OGC(0):AnsiDate?axis-label="time"/EPSG(0):32631 comparison is *not* cached: need to ask SECORE.
 DEBUG [15:33:52] CrsUtil@1245: http://localhost:8080/def/equal?1=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FOGC%2F0%2FAnsiDate%3Faxis-label%3D%22time%22&2=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FEPSG%2F0%2F32631
 TRACE [15:33:52] CrsUtil@1177: OGC(0):Index4D/EPSG(0):32631 comparison is *not* cached: need to ask SECORE.
 DEBUG [15:33:52] CrsUtil@1245: http://localhost:8080/def/equal?1=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FOGC%2F0%2FIndex4D&2=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FEPSG%2F0%2F32631
 TRACE [15:33:52] CrsUtil@1177: OGC(0):Index3D/EPSG(0):32631 comparison is *not* cached: need to ask SECORE.
 DEBUG [15:33:52] CrsUtil@1245: http://localhost:8080/def/equal?1=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FOGC%2F0%2FIndex3D&2=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FEPSG%2F0%2F32631
 TRACE [15:33:52] CrsUtil@1177: EPSG(0):32650/EPSG(0):32631 comparison is *not* cached: need to ask SECORE.
 DEBUG [15:33:52] CrsUtil@1245: http://localhost:8080/def/equal?1=http%3A%2F%2Fwww.opengis.net%2Fdef%2Fcrs%2FEPSG%2F0%2F32650&2=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FEPSG%2F0%2F32631
 TRACE [15:33:52] CrsUtil@1177: OGC(0):AnsiDate/EPSG(0):32631 comparison is *not* cached: need to ask SECORE.
 DEBUG [15:33:52] CrsUtil@1245: http://localhost:8080/def/equal?1=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FOGC%2F0%2FAnsiDate&2=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FEPSG%2F0%2F32631
 TRACE [15:33:52] CrsUtil@1177: OGC(0):AnsiDate?axis-label="unix"/EPSG(0):32631 comparison is *not* cached: need to ask SECORE.
 DEBUG [15:33:52] CrsUtil@1245: http://localhost:8080/def/equal?1=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FOGC%2F0%2FAnsiDate%3Faxis-label%3D%22unix%22&2=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FEPSG%2F0%2F32631
 TRACE [15:33:52] CrsUtil@1177: EPSG(0):3857/EPSG(0):32631 comparison is *not* cached: need to ask SECORE.
 DEBUG [15:33:52] CrsUtil@1245: http://localhost:8080/def/equal?1=http%3A%2F%2Fwww.opengis.net%2Fdef%2Fcrs%2FEPSG%2F0%2F3857&2=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FEPSG%2F0%2F32631
 TRACE [15:33:52] CrsUtil@1177: EPSG(0):4326/EPSG(0):32631 comparison is *not* cached: need to ask SECORE.
 DEBUG [15:33:52] CrsUtil@1245: http://localhost:8080/def/equal?1=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FEPSG%2F0%2F4326&2=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FEPSG%2F0%2F32631
 TRACE [15:33:52] CrsUtil@1177: EPSG(0):4269/EPSG(0):32631 comparison is *not* cached: need to ask SECORE.
 DEBUG [15:33:52] CrsUtil@1245: http://localhost:8080/def/equal?1=http%3A%2F%2Fwww.opengis.net%2Fdef%2Fcrs%2FEPSG%2F0%2F4269&2=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FEPSG%2F0%2F32631
 TRACE [15:33:52] CrsUtil@1177: EPSG(0):4262/EPSG(0):32631 comparison is *not* cached: need to ask SECORE.
 DEBUG [15:33:52] CrsUtil@1245: http://localhost:8080/def/equal?1=http%3A%2F%2Fwww.opengis.net%2Fdef%2Fcrs%2FEPSG%2F0%2F4262&2=http%3A%2F%2Flocalhost%3A8080%2Fdef%2Fcrs%2FEPSG%2F0%2F32631
 TRACE [15:33:52] CrsUtil@1076: http://localhost:8080/def/crs/EPSG/0/32631 CRS needs to be parsed via resolver.
 DEBUG [15:33:52] CrsUtil@294: CRS element found: 'ProjectedCRS'.
 DEBUG [15:33:52] CrsUtil@303: CS element found: cartesianCS
 DEBUG [15:33:52] CrsUtil@308: CS element found: CartesianCS
 DEBUG [15:33:52] CrsUtil@392: Axis element found: E[metre]
 DEBUG [15:33:52] CrsUtil@392: Axis element found: N[metre]
 TRACE [15:33:52] CrsUtil@466: CRS URI http://localhost:8080/def/crs/EPSG/0/32631 is added into cache for future (inter-requests) use.
 DEBUG [15:33:52] ResponseService@128: Generated a single WCPS query from WCS request: for c in (test_landsat8) return encode(c[E(377983:378013), N(4903991:4904041)], "image/tiff")
 DEBUG [15:33:52] RasUtil@104: Executing rasql query: SELECT encode(c[0:0,66:66], "image/tiff" , "{\"geoReference\":{\"crs\":\"EPSG:32631\",\"bbox\":{\"xmin\":377955,\"ymin\":4903885,\"xmax\":378155,\"ymax\":4904085}}}") FROM test_landsat8 AS c