The URL to use for the connection is the URL of the landing page https://kulturdb.de/cgi-bin/mapserv/kdb_ogcapi/ogcapi/
That link opens as http on a browser but QGIS knows how to read the document as JSON. -Jukka Rahkonen- ________________________________________ Lähettäjä: MapServer-users käyttäjän Schroeter via MapServer-users puolesta Lähetetty: Keskiviikko 9. huhtikuuta 2025 11.50 Vastaanottaja: mapserver-users@lists.osgeo.org Aihe: Re: [MapServer-users] OGCAPI Hello Jörg, thanks for the answer, strangely enough Qgis (version 3.4) is still stubbornly trying to send me a WFS request. I have now also cleared the cache and explicitly set OGC-Api. The wrong request is always set in the diagnostic tools. Which url do you enter as the source in Qgis? Have you ever created a service with > 40,000 objects? Sven Am 09.04.2025 um 09:28 schrieb Jörg Thomsen (WhereGroup) via MapServer-users: > Hello Sven, > > somehow qgis tried to use a wfs-request. I had to configure your > service explizit as OGC-Api (not "Maximum") and delete the cache in > QGIS. Now I can use both collections. > > The kdb_alle works not for all items, I have tried up to 10.000 (in > QGIS with checkbox 'only load items i curent mapxtent'. > > https://kulturdb.de/cgi-bin/mapserv/kdb_ogcapi/ogcapi/collections/kdb_alle/items?f=json&limit=10000 > > > Don't know what ist happening, perhaps the MapServer log can tell you > more. > > Jörg > > Am 08.04.25 um 17:56 schrieb Schroeter via MapServer-users: >> Hi all, >> >> I am currently testing the ogcapi function in the current Mapserver >> 8.4 and already have an example online: >> https://kulturdb.de/cgi-bin/mapserv/kdb_ogcapi/ogcapi/collections?f=html >> In the first collection, all objects (approx. 48,000 point objects >> from a Postgis DB) are queried. Unfortunately extremely slow. >> 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.: >> 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 >> >> >> With the second collection with only 333 objects, it works quite well: >> https://kulturdb.de/cgi-bin/mapserv/kdb_ogcapi/ogcapi/collections/kdb_brunnen/items?f=html >> >> >> Here is the map file for it >> >> MAP >> NAME "kdb_trier" >> STATUS ON >> SIZE 400 400 >> EXTENT 6.074 49.492 7.296 50.435 >> UNITS METERS >> >> PROJECTION >> "init=epsg:4326" >> END >> >> WEB >> METADATA >> # OGC API Features Konfiguration >> "ows_enable_request" "*" >> "ows_getfeatureinfo_formatlist" >> "text/plain,text/html,application/json,application/vnd.ogc.gml,gml" >> "oga_onlineresource" >> "https://kulturdb.de/cgi-bin/mapserv/kdb_ogcapi/ogcapi" >> "oga_title" "KDB Trier" >> "oga_abstract" "Objekte der >> Kulturdatenbank der Region Trier" >> "oga_srs" "EPSG:25832 EPSG:4326 >> EPSG:3857" >> "oga_html_template_directory" >> "/var/www/html/ogcapi/templates/html-bootstrap4/" >> "oga_extent" "6.074 49.492 7.296 >> 50.435" >> "oga_use_default_extent_for_getfeature" "true" >> "oga_limit_default" "10" >> "oga_limit_max" "500" >> "oga_paging" "true" >> "oga_paging_linkheader" "true" >> "gml_include_items" "all" >> "gml_featureid" "lfdnr" >> END >> >> TEMPLATE "/var/www/mapserver/template/dummy.html" >> >> END >> >> OUTPUTFORMAT >> NAME "png" >> DRIVER AGG/PNG >> MIMETYPE "image/png" >> IMAGEMODE RGB >> EXTENSION "png" >> FORMATOPTION "GAMMA=0.75" >> END >> >> OUTPUTFORMAT >> NAME "application/json" >> DRIVER "OGR/GEOJSON" >> MIMETYPE "application/json" >> FORMATOPTION "FORM=SIMPLE" >> FORMATOPTION "STORAGE=memory" >> END >> >> SYMBOL >> NAME "circle" >> TYPE ELLIPSE >> POINTS >> 1 1 >> END >> FILLED TRUE >> END >> >> LAYER >> NAME "kdb_alle" >> TYPE POINT >> STATUS ON >> INCLUDE "_connection_kdb.inc" >> DATA "the_geom FROM kdb_kultur_ogr USING UNIQUE lfdnr" >> PROJECTION >> "init=epsg:4326" >> END >> >> METADATA >> >> # OGC API Features Metadaten >> "oga_title" "KDB Trier - alle >> Objekte" >> "oga_description" "Alle Objekte der >> Kulturdatenbank der Region Trier" >> "oga_id_field" "lfdnr" >> "oga_queryable" "true" >> "oga_extent" "6.074 49.492 7.296 >> 50.435" >> "ows_title" "KDB Trier - alle >> Objekte" >> "ows_abstract" "Alle Objekte der >> Kulturdatenbank der Region Trier" >> "oga_extent" "6.074 49.492 7.296 >> 50.435" >> "oga_use_default_extent_for_getfeature" "true" >> "oga_limit_default" "10" >> "oga_limit_max" "500" >> "oga_paging" "true" >> "oga_paging_linkheader" "true" >> "gml_include_items" "all" >> "gml_featureid" "lfdnr" >> >> END >> >> TEMPLATE "/var/www/mapserver/template/dummy.html" >> >> CLASS >> NAME "KDB" >> STYLE >> SYMBOL "circle" >> SIZE 6 >> COLOR 255 0 0 >> OUTLINECOLOR 255 255 255 >> END >> END >> END # LAYER >> >> >> LAYER >> NAME "kdb_brunnen" >> TYPE POINT >> STATUS ON >> INCLUDE "_connection_kdb.inc" >> DATA "the_geom FROM (SELECT * FROM kdb_kultur_ogr WHERE b_kateg >> = 'Brunnen') AS foo USING UNIQUE lfdnr" >> PROJECTION >> "init=epsg:4326" >> END >> >> METADATA >> >> # OGC API Features Metadaten >> "oga_title" "KDB Trier - Brunnen" >> "oga_description" "Brunnen Objekte der >> Kulturdatenbank der Region Trier" >> "oga_id_field" "lfdnr" >> "oga_queryable" "true" >> "oga_extent" "6.074 49.492 7.296 >> 50.435" >> "ows_title" "KDB Trier - Brunnen" >> "ows_abstract" "Brunnen Objekte >> der Kulturdatenbank der Region Trier" >> "oga_extent" "6.074 49.492 7.296 >> 50.435" >> "oga_use_default_extent_for_getfeature" "true" >> "oga_limit_default" "10" >> "oga_limit_max" "500" >> "oga_paging" "true" >> "oga_paging_linkheader" "true" >> "gml_include_items" "all" >> "gml_featureid" "lfdnr" >> >> END >> >> TEMPLATE "/var/www/mapserver/template/dummy.html" >> >> CLASS >> NAME "KDB" >> STYLE >> SYMBOL "circle" >> SIZE 6 >> COLOR 255 0 0 >> OUTLINECOLOR 255 255 255 >> END >> END >> END # LAYER >> >> >> END # MAP >> >> THE MS Version: >> 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 >> >> 1. How can I speed up the display for the first collection? >> 2. the collections are not recognised in QGIS, What ist wrong? >> >> Thanx >> Sven >> >> >> >> >> >> _______________________________________________ >> MapServer-users mailing list >> MapServer-users@lists.osgeo.org >> https://lists.osgeo.org/mailman/listinfo/mapserver-users > _______________________________________________ MapServer-users mailing list MapServer-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ MapServer-users mailing list MapServer-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users