<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"Predformátované HTML Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.PredformtovanHTMLChar
{mso-style-name:"Predformátované HTML Char";
mso-style-priority:99;
mso-style-link:"Predformátované HTML";
font-family:Consolas;
mso-ligatures:none;}
span.gmailsignatureprefix
{mso-style-name:gmail_signature_prefix;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Hi Jackie,<o:p></o:p></p>
<p class="MsoNormal">Thank you for you answer.<o:p></o:p></p>
<p class="MsoNormal">Yes that would be the solution that we need and would help us.<o:p></o:p></p>
<p class="MsoNormal">Now we have solved the problem using new database tables where we copy the data from view. It was possible as the data are mostly static and doesn’t change often.<o:p></o:p></p>
<p class="MsoNormal">Martin<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="SK">From:</span></b><span lang="SK"> mapguide-users <mapguide-users-bounces@lists.osgeo.org>
<b>On Behalf Of </b>Jackie Ng<br>
<b>Sent:</b> Friday, May 5, 2023 12:15 PM<br>
<b>To:</b> mapguide-users@lists.osgeo.org<br>
<b>Subject:</b> Re: [mapguide-users] MapGuide MVT Tiles with view as source<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">Hi Martin,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I am pretty sure the PostgreSQL provider supports configuration as it is based on the same shared codebase used by ODBC, SQL Server and MySQL providers, which all support configuration.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">By supporting configuration, we can specify a XML configuration document that provides a customised logical feature schema representation of your PostGIS db that says that <some other column> in that view is the identity property, instead
of what the provider thinks (by default) is your identity property.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">However, making such a configuration document is a PITA right now because the easiest way to do this with FDO Toolbox (ref: <a href="https://themapguyde.blogspot.com/2010/08/using-fdo-schema-overrides.html">https://themapguyde.blogspot.com/2010/08/using-fdo-schema-overrides.html</a>)
doesn't work for PostgreSQL because of the I'm checking for configuration support is completely dumb and needs to be fixed.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">That issue is referenced here: <a href="https://github.com/jumpinjackie/fdotoolbox/issues/82">
https://github.com/jumpinjackie/fdotoolbox/issues/82</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Once I've fixed that issue and release a new FDO Toolbox with that fix included shortly after, you can follow the referenced blog post link to customise the identity property of that view.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">- Jackie<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">You wrote:<o:p></o:p></p>
</div>
<div>
<div>
<pre style="white-space:pre-wrap"><span style="color:black">Hi,<o:p></o:p></span></pre>
<pre><span style="color:black">We are using TileSetDefinition with TileProvider set to XYZ and TileFormat set to MVT.<o:p></o:p></span></pre>
<pre><span style="color:black">The problem we have is that all features inside the vector tiles have attribute "id" set to 0.<o:p></o:p></span></pre>
<pre><span style="color:black">We have found out that the problem is that we are using view as the source data for layer. When we change the source data to table, then the features have the attribute "id" set to primary key value. The source data are stored in PostgreSQL database.<o:p></o:p></span></pre>
<pre><span style="color:black">Is there some possibility to configure which column from the view should be used as the attribute "id" for the vector tile features?<o:p></o:p></span></pre>
<pre><span style="color:black">Thank you for any hint,<o:p></o:p></span></pre>
<pre><span style="color:black">Martin<o:p></o:p></span></pre>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><span class="gmailsignatureprefix">-- </span><o:p></o:p></p>
<div>
<div>
<p class="MsoNormal"><i><span style="font-size:7.5pt">Please Note: I no longer create new posts or post replies to any OSGeo mailing list through nabble. As a result, you most likely won't see this message appear on nabble's view of any OSGeo mailing list and
may only see this message through mailing list archives or depending on your mailing list subscription settings, through daily message digests or automated notifications from the mailing lists.</span></i><o:p></o:p></p>
</div>
</div>
</div>
</div>
</body>
</html>