[MapServer-users] Tileindex in format different than SHP?

[Rahkonen Jukka]

Hi,

You are wrong, a GeoPackage layer as a tileindex is about as fast as a shapefile in common bbox filtering that WMS is, and faster than shapefile index if you want to filter or sort the data by other attributes. That is based on my measurements from some years ago with an orthophoto layer having about 80000 rows in the index. Your data can be different but make a proper test and then jugde by the facts. There is no need to render the tileindex layer once you have made it to work. However, it does offer a handy way for letting your users to query metadata from the individual images with GetFeatureInfo if you happen to have that kind of needs.

-Jukka Rahkonen-

Lähettäjä: MapServer-users <mapserver-users-bounces at lists.osgeo.org> Puolesta Marcin Niemyjski via MapServer-users
Lähetetty: keskiviikko 14. joulukuuta 2022 15.08
Vastaanottaja: Jeff McKenna <jmckenna at gatewaygeomatics.com>; mapserver-users at lists.osgeo.org
Aihe: Re: [MapServer-users] Tileindex in format different than SHP?

Jeff,
I checked TILEINDEX documentation before writing to you. I found no information's about other formats except that shapefile is usually used.

Jukka,
I created an extra layer as you suggested, thanks - it works, but I will stay with Shapefiles on this one. When working with tileindex as extra layer it takes 2x more time for mapserver to render the layer.

Thank you all,
Marcin
________________________________
From: MapServer-users <mapserver-users-bounces at lists.osgeo.org<mailto:mapserver-users-bounces at lists.osgeo.org>> on behalf of Jeff McKenna <jmckenna at gatewaygeomatics.com<mailto:jmckenna at gatewaygeomatics.com>>
Sent: Wednesday, December 14, 2022 1:51 PM
To: mapserver-users at lists.osgeo.org<mailto:mapserver-users at lists.osgeo.org> <mapserver-users at lists.osgeo.org<mailto:mapserver-users at lists.osgeo.org>>
Subject: Re: [MapServer-users] Tileindex in format different than SHP?

I had recently spent a few weeks of effort on updating the documentation
for TILEINDEX, with many examples, see :
https://mapserver.org/optimization/tileindex.html<https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmapserver.org%2Foptimization%2Ftileindex.html&data=05%7C01%7Cjukka.rahkonen%40maanmittauslaitos.fi%7C97a0ff74ad814a33ecf308daddd43c70%7Cc4f8a63255804a1c92371d5a571b71fa%7C0%7C0%7C638066200868945991%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Ytab2HUFqvSlThcIlMrw0uEOTYkcvUQNLwy3knjGS7s%3D&reserved=0>

-jeff


--
Jeff McKenna
GatewayGeo: Developers of MS4W, MapServer Consulting and Training
co-founder of FOSS4G
http://gatewaygeo.com/<https://eur06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgatewaygeo.com%2F&data=05%7C01%7Cjukka.rahkonen%40maanmittauslaitos.fi%7C97a0ff74ad814a33ecf308daddd43c70%7Cc4f8a63255804a1c92371d5a571b71fa%7C0%7C0%7C638066200868945991%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=jVo90DcKenZPc641ZN6rpbnlQmHEOick7VDCP%2BQxBoM%3D&reserved=0>



On 2022-12-14 7:23 a.m., Marcin Niemyjski via MapServer-users wrote:
> Hello,
>
> Can I use format different than SHP while using tileindex of rasters?
>
> When using Mapfile with configuration as below:
>
> LAYER
>              NAME "2021-01-02_high"
>          STATUS ON
>          TILEINDEX "/DyskPlanetiler/Sentinel1COG/2021/01/02/2021-01-02.gpkg"
>          TILEITEM "location"
>          TYPE RASTER
>          MAXSCALEDENOM 4000000
>          GROUP "2021-01-02"
>          PROJECTION
>              "init=epsg:4326"
>          END
> END
>
> error is recived:
> msShapefileOpen(): Unable to access file.
> (/DyskPlanetiler/Sentinel1COG/2021/01/01/2021-01-01.gpkg)
>
> is there a way to use geopackage or flatgeobuf as indexes or do I have
> to go back to shp?
>
> Best,
> Marcin
>
> _______________________________________________
> MapServer-users mailing list
> MapServer-users at lists.osgeo.org<mailto:MapServer-users at lists.osgeo.org>
> https://lists.osgeo.org/mailman/listinfo/mapserver-users<https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fmapserver-users&data=05%7C01%7Cjukka.rahkonen%40maanmittauslaitos.fi%7C97a0ff74ad814a33ecf308daddd43c70%7Cc4f8a63255804a1c92371d5a571b71fa%7C0%7C0%7C638066200868945991%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=uBO9pSmK8xEv5WITuBjAfQJ26kes%2FdMM4gS4KQdH85o%3D&reserved=0>


_______________________________________________
MapServer-users mailing list
MapServer-users at lists.osgeo.org<mailto:MapServer-users at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/mapserver-users<https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fmapserver-users&data=05%7C01%7Cjukka.rahkonen%40maanmittauslaitos.fi%7C97a0ff74ad814a33ecf308daddd43c70%7Cc4f8a63255804a1c92371d5a571b71fa%7C0%7C0%7C638066200868945991%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=uBO9pSmK8xEv5WITuBjAfQJ26kes%2FdMM4gS4KQdH85o%3D&reserved=0>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20221214/742321ef/attachment-0001.htm>