'[MapServer-users] jsonb attribute as a tileitem in mapserver'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mapserver-users
Subject:    [MapServer-users] jsonb attribute as a tileitem in mapserver
From:       Marcin Niemyjski via MapServer-users <mapserver-users () lists ! osgeo ! org>
Date:       2023-11-30 14:11:08
Message-ID: AS1PR03MB814966A32CA67E50A2553091A882A () AS1PR03MB8149 ! eurprd03 ! prod ! outlook ! com
[Download RAW message or body]

Hello,

Because my postgres table started to get bigger with every new column, I decided to \
try out the jsonb type column, namely I tried using jsonb attribute as a tileitem \
within tileindex this way:

TILEITEM "location->>'10m'"

where jsonb looks like this:
{
  "10m": "/vsicurl/...",
  "20m": "/vsicurl/...",
  "30m": "/vsicurl/..."
}

but all I get is:
 [warn] [pid 15] mod_fcgid: stderr: msPostGISLayerGetItems(): Query error. Error \
executing SQL. Check server logs.

Is there any way of using jsonb as a location attribute equivalent?

Best,
Marcin
[https://res.cdn.office.net/assets/bookwithme/misc/CalendarPerson20px.png]<https://out \
look.office.com/bookwithme/user/6347c7def05a478ba013ae948648789d@cloudferro.com?anonymous&ep=signature> \
Book time to meet with \
me<https://outlook.office.com/bookwithme/user/6347c7def05a478ba013ae948648789d@cloudferro.com?anonymous&ep=signature>

[Attachment #3 (text/html)]

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} \
</style> </head>
<body dir="ltr">
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, \
Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, \
0, 0);"> Hello,</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, \
Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, \
0, 0);"> <br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, \
Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, \
0, 0);"> <br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, \
Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, \
0, 0);"> Because my postgres table started to get bigger with every new column, I \
decided to try out the jsonb type column, namely I tried using jsonb attribute as a \
tileitem within tileindex this way:<br> <br>
</div>
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, \
Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, \
0, 0);">TILEITEM &quot;location-&gt;&gt;'10m'&quot;</span></div> <div \
class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, \
Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, \
0, 0);"><br> </span></div>
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, \
Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, \
0, 0);">where jsonb looks like this:<br> {</span></div>
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, \
Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, \
0, 0);">&nbsp; &quot;10m&quot;: &quot;/vsicurl/...&quot;,</span></div> <div \
class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, \
Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, \
0, 0);">&nbsp; &quot;20m&quot;: &quot;/vsicurl/...&quot;,</span></div> <div \
class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, \
Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, \
0, 0);">&nbsp; &quot;30m&quot;: &quot;/vsicurl/...&quot;</span></div> <div \
class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, \
Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, \
0, 0);">}<br> <br>
but all I get is:<br>
&nbsp;[warn] [pid 15] mod_fcgid: stderr: msPostGISLayerGetItems(): Query error. Error \
executing SQL. Check server logs.</span></div> <div class="elementToProof"><span \
style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, \
Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"><br> </span></div>
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, \
Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, \
0, 0);">Is there any way of using jsonb as a location attribute \
equivalent?</span></div> <div class="elementToProof"><span style="font-family: Aptos, \
Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: \
12pt; color: rgb(0, 0, 0);"><br> </span></div>
<div class="elementToProof"><span style="font-family: Aptos, Aptos_EmbeddedFont, \
Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, \
0, 0);">Best,</span></div> <div class="elementToProof"><span style="font-family: \
Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; \
font-size: 12pt; color: rgb(0, 0, 0);">Marcin</span></div> <div id="Signature">
<table style="margin-top: 30px; margin-bottom: 30px; width: 95%;" \
id="tableSelected0"> </table>
<table id="pbpsiglinktable">
<tbody>
<tr>
<td><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, \
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"><a \
href="https://outlook.office.com/bookwithme/user/6347c7def05a478ba013ae948648789d@cloudferro.com?anonymous&amp;ep=signature"><img \
src="https://res.cdn.office.net/assets/bookwithme/misc/CalendarPerson20px.png"></a></span></td>
 <td></td>
<td><span style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, \
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 120, 212);"><a \
href="https://outlook.office.com/bookwithme/user/6347c7def05a478ba013ae948648789d@cloudferro.com?anonymous&amp;ep=signature" \
style="text-decoration: none; color: rgb(0, 120, 212);">Book  time to meet with \
me</a></span></td> <td></td>
</tr>
</tbody>
</table>
</div>
</body>
</html>

_______________________________________________
MapServer-users mailing list
MapServer-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

--===============0208203923882012253==--

[prev in list] [next in list] [prev in thread] [next in thread] 