<html><head></head><body><div class="ydpe19f82e2yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;" dir="ltr" data-setdir="false"><div>Zmitser,</div><div><br></div><div dir="ltr" data-setdir="false">You have to have the following on a MAP file:</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">LAYER</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">...<br></div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"> CONNECTION "host=<HOST> ... password=<PASSWORD>"</div><div dir="ltr" data-setdir="false">CONNECTIONTYPE <CONNECTION_TYPE><br></div><div dir="ltr" data-setdir="false">DATA "<GEOM_COLUMN> FROM <TABLE NAME> USING UNIQUE <ID> USING SRID=<SRID>"</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">...</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">END</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">On DATA you must specify the name of the geometry column and the table, if you're using a database. If you are using a shape file you just have to include the DATA keyword with the path and the name of the SHP file.<br></div><div dir="ltr" data-setdir="false"><br></div><div><br></div>
</div><div id="ydp4a9c06dayahoo_quoted_6860825563" class="ydp4a9c06dayahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Tuesday, March 23, 2021, 2:34:48 AM CST, Zmitser Kozhukh via mapserver-users <mapserver-users@lists.osgeo.org> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="ydp4a9c06dayiv6459760804">
<div><div>Dear mapserver users, I need to specify data parameter at the location item of tileindex.</div><div>So far, I have tried many possibilities but none works:<br>‘host=127.0.0.1 dbname=database user=admin password=admin DATA "geom from table using unique id using srid=4326"’</div><div>or</div><div>host=127.0.0.1 dbname=database user=admin password=admin data="geom from table using unique id using srid=4326"</div><div>etc.</div><div>Still I get an error :</div><div><span style="color:rgb(0, 0, 0);font-family:monospace;font-size:13px;font-style:normal;font-weight:400;letter-spacing:normal;orphans:2;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;display:inline !important;float:none;">msDrawMap(): Image handling error. Failed to draw layer named 'layer'. msPostGISLayerOpen(): Query error. Nothing specified in DATA statement.</span></div><div><div>Could someone please tell in which format data statement should be?</div></div><div>In documentation it is written vaguely:</div><div><span style="color:rgb(62, 67, 73);font-family:Arial, sans-serif;font-size:12.8px;font-style:normal;font-weight:400;letter-spacing:normal;orphans:2;text-indent:0px;text-transform:none;white-space:normal;widows:2;word-spacing:0px;background-color:rgb(255, 255, 255);text-decoration-style:initial;text-decoration-color:initial;display:inline !important;float:none;">Normally the location should contain the path to the tile file relative to the shapepath, not relative to the tileindex itself. If the DATA parameter contains a value then it is added to the end of the location.</span></div><div> </div><div><div><div>--<br>Zmitser Kozhukh</div></div></div></div>
</div>_______________________________________________<br>mapserver-users mailing list<br><a href="mailto:mapserver-users@lists.osgeo.org" rel="nofollow" target="_blank">mapserver-users@lists.osgeo.org</a><br><a href="https://lists.osgeo.org/mailman/listinfo/mapserver-users" rel="nofollow" target="_blank">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br></div>
</div>
</div></body></html>