<!DOCTYPE html>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<font face="Arial">Hi all,<br>
</font>
<div class="moz-signature"><font face="Arial"><br>
I am currently testing the ogcapi function in the current
Mapserver 8.4 and already have an example online:<br>
<a class="moz-txt-link-freetext" href="https://kulturdb.de/cgi-bin/mapserv/kdb_ogcapi/ogcapi/collections?f=html">https://kulturdb.de/cgi-bin/mapserv/kdb_ogcapi/ogcapi/collections?f=html</a><br>
In the first collection, all objects (approx. 48,000 point
objects from a Postgis DB) are queried. Unfortunately extremely
slow.<br>
If I query all objects via a WMS, they come very quickly, it
should not be due to the DB or the connection, everything is
cleanly indexed etc.:<br>
<a class="moz-txt-link-freetext" href="https://kulturdb.de/cgi-bin/mapserv?map=kdb&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&BBOX=49.49%2C6.0739%2C50.4%2C7.296&CRS=EPSG%3A4326&WIDTH=762&HEIGHT=588&LAYERS=kdb_alle&STYLES=&FORMAT=image%2Fpng">https://kulturdb.de/cgi-bin/mapserv?map=kdb&SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&BBOX=49.49%2C6.0739%2C50.4%2C7.296&CRS=EPSG%3A4326&WIDTH=762&HEIGHT=588&LAYERS=kdb_alle&STYLES=&FORMAT=image%2Fpng</a><br>
<br>
With the second collection with only 333 objects, it works quite
well:<br>
<a class="moz-txt-link-freetext" href="https://kulturdb.de/cgi-bin/mapserv/kdb_ogcapi/ogcapi/collections/kdb_brunnen/items?f=html">https://kulturdb.de/cgi-bin/mapserv/kdb_ogcapi/ogcapi/collections/kdb_brunnen/items?f=html</a><br>
<br>
Here is the map file for it<br>
<br>
MAP<br>
NAME "kdb_trier"<br>
STATUS ON<br>
SIZE 400 400<br>
EXTENT 6.074 49.492 7.296 50.435 <br>
UNITS METERS<br>
<br>
PROJECTION<br>
"init=epsg:4326"<br>
END<br>
<br>
WEB<br>
METADATA<br>
# OGC API Features Konfiguration<br>
"ows_enable_request" "*"<br>
"ows_getfeatureinfo_formatlist"
"text/plain,text/html,application/json,application/vnd.ogc.gml,gml"<br>
"oga_onlineresource"
<a class="moz-txt-link-rfc2396E" href="https://kulturdb.de/cgi-bin/mapserv/kdb_ogcapi/ogcapi">"https://kulturdb.de/cgi-bin/mapserv/kdb_ogcapi/ogcapi"</a><br>
"oga_title" "KDB Trier"<br>
"oga_abstract" "Objekte der
Kulturdatenbank der Region Trier"<br>
"oga_srs" "EPSG:25832
EPSG:4326 EPSG:3857"<br>
"oga_html_template_directory"
"/var/www/html/ogcapi/templates/html-bootstrap4/"<br>
"oga_extent" "6.074 49.492 7.296
50.435"<br>
"oga_use_default_extent_for_getfeature" "true"<br>
"oga_limit_default" "10"<br>
"oga_limit_max" "500"<br>
"oga_paging" "true"<br>
"oga_paging_linkheader" "true"<br>
"gml_include_items" "all" <br>
"gml_featureid" "lfdnr"<br>
END<br>
<br>
TEMPLATE "/var/www/mapserver/template/dummy.html"<br>
<br>
END<br>
<br>
OUTPUTFORMAT<br>
NAME "png"<br>
DRIVER AGG/PNG<br>
MIMETYPE "image/png"<br>
IMAGEMODE RGB<br>
EXTENSION "png"<br>
FORMATOPTION "GAMMA=0.75"<br>
END<br>
<br>
OUTPUTFORMAT<br>
NAME "application/json"<br>
DRIVER "OGR/GEOJSON"<br>
MIMETYPE "application/json"<br>
FORMATOPTION "FORM=SIMPLE"<br>
FORMATOPTION "STORAGE=memory"<br>
END<br>
<br>
SYMBOL<br>
NAME "circle"<br>
TYPE ELLIPSE<br>
POINTS<br>
1 1<br>
END<br>
FILLED TRUE<br>
END<br>
<br>
LAYER<br>
NAME "kdb_alle"<br>
TYPE POINT<br>
STATUS ON<br>
INCLUDE "_connection_kdb.inc"<br>
DATA "the_geom FROM kdb_kultur_ogr USING UNIQUE lfdnr"<br>
PROJECTION<br>
"init=epsg:4326"<br>
END<br>
<br>
METADATA<br>
<br>
# OGC API Features Metadaten<br>
"oga_title" "KDB Trier - alle
Objekte"<br>
"oga_description" "Alle Objekte der
Kulturdatenbank der Region Trier"<br>
"oga_id_field" "lfdnr"<br>
"oga_queryable" "true"<br>
"oga_extent" "6.074 49.492
7.296 50.435" <br>
"ows_title" "KDB Trier -
alle Objekte"<br>
"ows_abstract" "Alle Objekte
der Kulturdatenbank der Region Trier"<br>
"oga_extent" "6.074 49.492
7.296 50.435"<br>
"oga_use_default_extent_for_getfeature" "true"<br>
"oga_limit_default" "10"<br>
"oga_limit_max" "500"<br>
"oga_paging" "true"<br>
"oga_paging_linkheader" "true"<br>
"gml_include_items" "all" <br>
"gml_featureid" "lfdnr"<br>
<br>
END<br>
<br>
TEMPLATE "/var/www/mapserver/template/dummy.html"<br>
<br>
CLASS<br>
NAME "KDB"<br>
STYLE<br>
SYMBOL "circle"<br>
SIZE 6<br>
COLOR 255 0 0<br>
OUTLINECOLOR 255 255 255<br>
END<br>
END<br>
END # LAYER<br>
<br>
<br>
LAYER<br>
NAME "kdb_brunnen"<br>
TYPE POINT<br>
STATUS ON<br>
INCLUDE "_connection_kdb.inc"<br>
DATA "the_geom FROM (SELECT * FROM kdb_kultur_ogr WHERE
b_kateg = 'Brunnen') AS foo USING UNIQUE lfdnr"<br>
PROJECTION<br>
"init=epsg:4326"<br>
END<br>
<br>
METADATA<br>
<br>
# OGC API Features Metadaten<br>
"oga_title" "KDB Trier -
Brunnen"<br>
"oga_description" "Brunnen Objekte
der Kulturdatenbank der Region Trier"<br>
"oga_id_field" "lfdnr"<br>
"oga_queryable" "true"<br>
"oga_extent" "6.074 49.492
7.296 50.435" <br>
"ows_title" "KDB Trier -
Brunnen"<br>
"ows_abstract" "Brunnen
Objekte der Kulturdatenbank der Region Trier"<br>
"oga_extent" "6.074 49.492
7.296 50.435"<br>
"oga_use_default_extent_for_getfeature" "true"<br>
"oga_limit_default" "10"<br>
"oga_limit_max" "500"<br>
"oga_paging" "true"<br>
"oga_paging_linkheader" "true"<br>
"gml_include_items" "all" <br>
"gml_featureid" "lfdnr"<br>
<br>
END<br>
<br>
TEMPLATE "/var/www/mapserver/template/dummy.html"<br>
<br>
CLASS<br>
NAME "KDB"<br>
STYLE<br>
SYMBOL "circle"<br>
SIZE 6<br>
COLOR 255 0 0<br>
OUTLINECOLOR 255 255 255<br>
END<br>
END<br>
END # LAYER <br>
<br>
<br>
END # MAP<br>
</font>
<br>
THE MS Version:<br>
MapServer version 8.4.0 PROJ version 9.1 GDAL version 3.6
OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML SUPPORTS=PROJ SUPPORTS=AGG
SUPPORTS=FREETYPE SUPPORTS=CAIRO SUPPORTS=ICONV
SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER
SUPPORTS=OGCAPI_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS
SUPPORTS=GEOS INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL
INPUT=SHAPEFILE INPUT=FLATGEOBUF<br>
<br>
1. How can I speed up the display for the first collection?<br>
2. the collections are not recognised in QGIS, What ist wrong?<br>
<br>
Thanx<br>
Sven<br>
<br>
<br>
<br>
<br>
</div>
</body>
</html>