Hello Marcin,
sounds stupid, but are you sure the 10 datasets have geometries within
the requested bbox? I don't see any other problem/mistakes.
Jörg
Am 19.10.23 um 11:39 schrieb Marcin Niemyjski via MapServer-users:
Hello,
I encountered a problem, specifically:
This query works:
|DATA 'geometry from (select * from mrc order by maxcc desc) as subquery
using unique unique_id' |
However, this query doesn't work:
|DATA 'geometry from (select * from mrc order by maxcc desc limit 10) as
subquery using unique unique_id' |
Here's the full tileindex definition:
|LAYER DEBUG 5 STATUS OFF NAME "time_idx" TYPE POLYGON
CONNECTIONTYPE postgis CONNECTION "***" DATA 'geometry from (select
* from mrc order by maxcc desc limit 10) as subquery using unique
unique_id' PROJECTION "init=epsg:3857" END VALIDATION 'maxCC'
'^[0-9]{1,3}$' 'default_maxCC' '100' END METADATA "wms_title"
"tile-index-cloud" "wms_timeextent" "2022-02-01/2023-10-10/P1D"
"wms_timeitem" "timestamp" "wms_timedefault" "2023-10-10"
"wms_enable_request" "!*" END END |
My MapServer version is 7.6.4.
The query results (but returns data in Postgres
) in an empty window. I'm following the guidelines provided at
https://mapserver.org/input/vector/postgis.html#data-access-connection-method <https://mapserver.org/input/vector/postgis.html#data-access-connection-method>.
Best,
marcin
<https://outlook.office.com/bookwithme/user/[email protected]?anonymous&ep=signature>
Book time to meet with me
<https://outlook.office.com/bookwithme/user/[email protected]?anonymous&ep=signature>
_______________________________________________
MapServer-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/mapserver-users
--
Viele Grüße,
Jörg Thomsen
---------------------------------------------
Aufwind durch Wissen!
Web-Seminare und Online-Schulungen
bei der www.foss-academy.com
---------------------------------------------
Jörg Thomsen
WhereGroup GmbH
Bundesallee 23
10717 Berlin
Germany
Tel: +49 (0)30 / 5130 278 74
Fax: +49 (0)30 / 5130 278 11
[email protected]
www.wheregroup.com
Geschäftsführer:
Olaf Knopp, Peter Stamm
Amtsgericht Bonn, HRB 9885
-------------------------------
Folgen Sie der WhereGroup auf twitter: http://twitter.com/WhereGroup_com
_______________________________________________
MapServer-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/mapserver-users
