<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof">
Jukka,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof">
thanks, I will do more tests.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof">
Marcin<br>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Rahkonen Jukka <jukka.rahkonen@maanmittauslaitos.fi><br>
<b>Sent:</b> Wednesday, December 14, 2022 2:36 PM<br>
<b>To:</b> Marcin Niemyjski <mniemyjski@cloudferro.com>; Jeff McKenna <jmckenna@gatewaygeomatics.com>; mapserver-users@lists.osgeo.org <mapserver-users@lists.osgeo.org><br>
<b>Subject:</b> VS: [MapServer-users] Tileindex in format different than SHP?</font>
<div> </div>
</div>
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif}
a:link, span.x_MsoHyperlink
{color:blue;
text-decoration:underline}
span.x_Shkpostityyli20
{font-family:"Calibri",sans-serif;
color:windowtext}
.x_MsoChpDefault
{font-size:10.0pt}
@page WordSection1
{margin:70.85pt 2.0cm 70.85pt 2.0cm}
div.x_WordSection1
{}
-->
</style>
<div lang="FI" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="x_WordSection1">
<p class="x_MsoNormal"><span style="">Hi,</span></p>
<p class="x_MsoNormal"><span style=""> </span></p>
<p class="x_MsoNormal"><span lang="EN-US" style="">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.</span></p>
<p class="x_MsoNormal"><span lang="EN-US" style=""> </span></p>
<p class="x_MsoNormal"><span lang="EN-US" style="">-Jukka Rahkonen-</span></p>
<p class="x_MsoNormal"><span lang="EN-US" style=""> </span></p>
<div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0cm 0cm 0cm">
<p class="x_MsoNormal"><b>Lähettäjä:</b> MapServer-users <mapserver-users-bounces@lists.osgeo.org>
<b>Puolesta </b>Marcin Niemyjski via MapServer-users<br>
<b>Lähetetty:</b> keskiviikko 14. joulukuuta 2022 15.08<br>
<b>Vastaanottaja:</b> Jeff McKenna <jmckenna@gatewaygeomatics.com>; mapserver-users@lists.osgeo.org<br>
<b>Aihe:</b> Re: [MapServer-users] Tileindex in format different than SHP?</p>
</div>
</div>
<p class="x_MsoNormal"> </p>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black; background:white">Jeff,</span>
</p>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black; background:white">I checked TILEINDEX documentation before writing to you. I found no information's about other formats except that shapefile is usually used.</span></p>
</div>
<div>
<p class="x_MsoNormal"> </p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black; background:white">Jukka,</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black; background:white">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.</span></p>
</div>
<div>
<p class="x_MsoNormal"> </p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black; background:white">Thank you all,</span></p>
</div>
<div>
<p class="x_MsoNormal"><span style="font-size:12.0pt; color:black; background:white">Marcin</span></p>
</div>
<div class="x_MsoNormal" align="center" style="text-align:center">
<hr size="2" width="98%" align="center">
</div>
<div id="x_divRplyFwdMsg">
<p class="x_MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black"> MapServer-users <<a href="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a>> on behalf of Jeff McKenna <<a href="mailto:jmckenna@gatewaygeomatics.com">jmckenna@gatewaygeomatics.com</a>><br>
<b>Sent:</b> Wednesday, December 14, 2022 1:51 PM<br>
<b>To:</b> <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a> <<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>><br>
<b>Subject:</b> Re: [MapServer-users] Tileindex in format different than SHP?</span>
</p>
<div>
<p class="x_MsoNormal"> </p>
</div>
</div>
<div>
<div>
<p class="x_MsoNormal">I had recently spent a few weeks of effort on updating the documentation
<br>
for TILEINDEX, with many examples, see : <br>
<a href="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">https://mapserver.org/optimization/tileindex.html</a><br>
<br>
-jeff<br>
<br>
<br>
-- <br>
Jeff McKenna<br>
GatewayGeo: Developers of MS4W, MapServer Consulting and Training<br>
co-founder of FOSS4G<br>
<a href="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">http://gatewaygeo.com/</a><br>
<br>
<br>
<br>
On 2022-12-14 7:23 a.m., Marcin Niemyjski via MapServer-users wrote:<br>
> Hello,<br>
> <br>
> Can I use format different than SHP while using tileindex of rasters?<br>
> <br>
> When using Mapfile with configuration as below:<br>
> <br>
> LAYER<br>
> NAME "2021-01-02_high"<br>
> STATUS ON<br>
> TILEINDEX "/DyskPlanetiler/Sentinel1COG/2021/01/02/2021-01-02.gpkg"<br>
> TILEITEM "location"<br>
> TYPE RASTER<br>
> MAXSCALEDENOM 4000000<br>
> GROUP "2021-01-02"<br>
> PROJECTION<br>
> "init=epsg:4326"<br>
> END<br>
> END<br>
> <br>
> error is recived:<br>
> msShapefileOpen(): Unable to access file. <br>
> (/DyskPlanetiler/Sentinel1COG/2021/01/01/2021-01-01.gpkg)<br>
> <br>
> is there a way to use geopackage or flatgeobuf as indexes or do I have <br>
> to go back to shp?<br>
> <br>
> Best,<br>
> Marcin<br>
> <br>
> _______________________________________________<br>
> MapServer-users mailing list<br>
> <a href="mailto:MapServer-users@lists.osgeo.org">MapServer-users@lists.osgeo.org</a><br>
> <a href="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">
https://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
<br>
<br>
_______________________________________________<br>
MapServer-users mailing list<br>
<a href="mailto:MapServer-users@lists.osgeo.org">MapServer-users@lists.osgeo.org</a><br>
<a href="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">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a></p>
</div>
</div>
</div>
</div>
</body>
</html>