<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
<font size="2">Hi</font><div><font size="2"><br></font></div><div><font size="2">i'm working with geomoose version 2.6.1</font></div><div><font size="2"><br></font></div><div><font size="2">I have some layers in shapefile but the most part is postgis.</font></div><div><font size="2">Everything is ok except that with the postgis layers the select and the query services do not work. The select returns well the attributes but says that "<b>Found Shapes: </b><span style="background-color: rgb(255, 255, 255);">0" and does not highlight any feature. The query service return no value at all. The select and the query service is fine with the shapefile based layers and the identify service is fine with both layers.</span></font></div><div><span style="background-color: rgb(255, 255, 255);"><font size="2"><br></font></span></div><div><span style="background-color: rgb(255, 255, 255);"><font size="2">I followed the documentation in the demo but this documentation is made for shapefiles, maybe something is missing with my config. </font></span></div><div><span style="background-color: rgb(255, 255, 255);"><font size="2"><br></font></span></div><div><span style="background-color: rgb(255, 255, 255);"><font size="2">Anyone can help?</font></span></div><div><font size="2"><br></font></div><div><font size="2">Thanks</font></div><div><span style="background-color: rgb(255, 255, 255);"><font face="Arial, Helvetica, sans-serif"><span style="font-size: 12px;"><br></span></font></span></div><div><span style="background-color: rgb(255, 255, 255);"><font face="Arial, Helvetica, sans-serif"><span style="font-size: 12px;"><br></span></font></span></div><div><span style="background-color: rgb(255, 255, 255);"><font face="Arial, Helvetica, sans-serif"><span style="font-size: 12px;">My configs are the folowing:</span></font></span></div><div><span style="background-color: rgb(255, 255, 255);"><font face="Arial, Helvetica, sans-serif"><span style="font-size: 12px;"><br></span></font></span></div><div><span style="background-color: rgb(255, 255, 255);"><font face="Arial, Helvetica, sans-serif"><span style="font-size: 12px;">mapbook describing the query and the select services:</span></font></span></div><div><span style="background-color: rgb(255, 255, 255);"><font face="Arial, Helvetica, sans-serif"><span style="font-size: 12px;"><br></span></font></span></div><div><span style="background-color: rgb(255, 255, 255); font-size: 12px;"><font face="Arial, Helvetica, sans-serif"><div><service name="buffered_select" title="Select Features"></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><url>php/select.php</url></div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><!-- Send a selection shape + the visible layers list to the service --></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><step type="spatial" showTools="true" name="shape" line="true" polygon="true" point="true" default="polygon" edit-polygon="false" pan="false"></div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><header><![CDATA[Create a selection area by clicking on the map.]]></header></div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><input type="visiblelayers" name="layers"/></div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><!-- </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>Option values should be the mapbook path to the layer.</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>This only supports 'mapserver'-type layers.</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>--></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><input type="select" name="select_layer" title="Select features from:"></div><div><span class="Apple-tab-span" style="white-space: pre;"> </span><option value="pontos_demo/pontos_demo">Pontos_demo</option></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><option value="pontos_shp/pontos_shp">Pontos_shp</option></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><option value="prov_shp/prov_shp">prov_shp</option></div><div><span class="Apple-tab-span" style="white-space:pre"> </span></input></div><div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><!--</div><div><span class="Apple-tab-span" style="white-space:pre"> </span><input type="user" name="select_buffer" title="Buffer Selected Features (m)">0</input></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>--></div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><input type="length" name="selection_buffer" title="Buffer Selection Shape">0</input></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><input type="select" name="query_layer" title="Using Features In"></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><option value="">No Layer</option></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><option value="pontos_demo/pontos_demo">Pontos_demo</option></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><option value="pontos_shp/pontos_shp">Pontos_shp</option></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><option value="prov_shp/prov_shp">prov_shp</option></div><div><span class="Apple-tab-span" style="white-space:pre"> </span></input></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><input type="projection" name="projection"/></div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><footnote><![CDATA[</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>]]></footnote></div><div><span class="Apple-tab-span" style="white-space:pre"> </span></step></div><div><span class="Apple-tab-span" style="white-space: pre;"> </span></service></div></font></span></div><div><span style="background-color: rgb(255, 255, 255);"><font face="Arial, Helvetica, sans-serif"><span style="font-size: 12px;">----------------------------------------------------------------------------------------------------------------------------------------------</span></font></span></div><div><span style="background-color: rgb(255, 255, 255); font-size: 12px;"><font face="Arial, Helvetica, sans-serif"><div><span class="Apple-tab-span" style="white-space: pre;"> </span><service name="search_parcels" title="Search"></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><url>php/query.php</url></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><step type="input"></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><input type="hidden" name="highlight" value="true"/></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><input type="hidden" name="mode" value="search"/></div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><input type="hidden" name="layer0" value="pontos_demo/pontos_demo"/></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><input type="hidden" name="template0" value="itemquery"/></div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><input type="select" name="fieldname0" title="Search By:"></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><option value="gid">ID</option></div><div><span class="Apple-tab-span" style="white-space: pre;"> </span></input></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><input type="select" name="comparitor0" title="That: "></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><option value="like-icase">Contains</option></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><option value="right-like-icase">Begins With</option></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><option value="eq-str">Matches Exactly</option></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><option value="in">In List</option></div><div><span class="Apple-tab-span" style="white-space:pre"> </span></input></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><input type="user" name="value0" title=""/></div><div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><input type="hidden" name="fieldname1" value="FIN_SQ_FT"/></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><input type="select" name="operator1"></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><option value="or">OR</option></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><option value="and">AND</option></div><div><span class="Apple-tab-span" style="white-space:pre"> </span></input></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><input type="select" name="comparitor1" title="Having Fin. Sq. Ft. "></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><option value="gt">Greater Than</option></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><option value="eq">Equal To</option></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><option value="lt">Less Than</option></div><div><span class="Apple-tab-span" style="white-space:pre"> </span></input></div><div><span class="Apple-tab-span" style="white-space:pre"> </span><input type="user" name="value1" title=""/></div><div><span class="Apple-tab-span" style="white-space:pre"> </span></step></div><div><span class="Apple-tab-span" style="white-space: pre;"> </span></service></div></font></span></div><div><span style="background-color: rgb(255, 255, 255);"><font face="Arial, Helvetica, sans-serif"><span style="font-size: 12px;">---------------------------------------------------------------------------------</span></font></span></div><div><span style="background-color: rgb(255, 255, 255);"><font face="Arial, Helvetica, sans-serif"><span style="font-size: 12px;"><br></span></font></span></div><div><span style="background-color: rgb(255, 255, 255);"><font face="Arial, Helvetica, sans-serif"><span style="font-size: 12px;">map file of the postgis layer:</span></font></span></div><div><br></div><div><span style="background-color: rgb(255, 255, 255);"><font face="Arial, Helvetica, sans-serif"><div><span style="font-size: 12px;"><br></span></div><div><span style="font-size: 12px;">MAP</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>NAME 'pontos_demo'</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>SIZE 800 650</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>STATUS ON</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>EXTENT 19.069345 -27.742864 51.134315 -9.525530</span></div><div><span style="font-size: 12px;"><br></span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>UNITS METERS</span></div><div><span style="font-size: 12px;"><br></span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>INCLUDE "../../geomoose_globals.map"</span></div><div><span style="font-size: 12px;"><br></span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>WEB</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>METADATA</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>'ows_title' 'Pontos'</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>'ows_srs' 'EPSG:4326 EPSG:3857'</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>'ows_enable_request' '*'</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>'ows_onlineresource' 'http://www.geomoose.org'</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>END</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>END</span></div><div><span style="font-size: 12px;"><br></span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>PROJECTION</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>'init=epsg:4326'</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>END</span></div><div><span style="font-size: 12px;"><br></span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>LEGEND</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span> STATUS ON</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span> LABEL</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>TYPE TRUETYPE</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>FONT vera_sans</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>SIZE 8</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>COLOR 0 0 0</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span> END<span class="Apple-tab-span" style="white-space:pre"> </span></span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>END<span class="Apple-tab-span" style="white-space:pre"> </span></span></div><div><span style="font-size: 12px;"> </span></div><div><span style="font-size: 12px;"> <span class="Apple-tab-span" style="white-space:pre"> </span>LAYER</span></div><div><span style="font-size: 12px;"> <span class="Apple-tab-span" style="white-space:pre"> </span> NAME 'pontos_demo'</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span> TYPE POINT</span></div><div><span style="font-size: 12px;"> <span class="Apple-tab-span" style="white-space:pre"> </span> DUMP true</span></div><div><span style="font-size: 12px;"> <span class="Apple-tab-span" style="white-space:pre"> </span> EXTENT 19.069345 -27.742864 51.134315 -9.525530</span></div><div><span style="font-size: 12px;"> <span class="Apple-tab-span" style="white-space:pre"> </span> CONNECTIONTYPE postgis</span></div><div><span style="font-size: 12px;"> <span class="Apple-tab-span" style="white-space:pre"> </span> CONNECTION "dbname='atlas_mz' host=localhost port=5432 user='postgres' password='postgis' sslmode=disable"</span></div><div><span style="font-size: 12px;"> <span class="Apple-tab-span" style="white-space:pre"> </span> DATA 'the_geom FROM "public"."pontos_sportgis" USING UNIQUE gid USING srid=4326'</span></div><div><span style="font-size: 12px;"><br></span></div><div><span style="font-size: 12px;"> LABELITEM 'tipo_infra'</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>LABELCACHE ON</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>LABELMAXSCALE 500000</span></div><div><span style="font-size: 12px;"> CLASSITEM 'tipo'</span></div><div><span style="font-size: 12px;"> CLASS</span></div><div><span style="font-size: 12px;"> NAME "Estadio" </span></div><div><span style="font-size: 12px;"> EXPRESSION "1" </span></div><div><span style="font-size: 12px;"> STYLE</span></div><div><span style="font-size: 12px;"> SYMBOL "circle" </span></div><div><span style="font-size: 12px;"> SIZE 17.0 </span></div><div><span style="font-size: 12px;"> OUTLINECOLOR 0 0 0</span></div><div><span style="font-size: 12px;"> COLOR 0 0 0</span></div><div><span style="font-size: 12px;"> END</span></div><div><span style="font-size: 12px;"> LABEL </span></div><div><span style="font-size: 12px;"> FONT vera_sans</span></div><div><span style="font-size: 12px;"> TYPE truetype</span></div><div><span style="font-size: 12px;"> SIZE 13</span></div><div><span style="font-size: 12px;"> COLOR 0 0 0</span></div><div><span style="font-size: 12px;"> ANGLE 0</span></div><div><span style="font-size: 12px;"> POSITION auto</span></div><div><span style="font-size: 12px;"> FORCE true</span></div><div><span style="font-size: 12px;"> ANTIALIAS true</span></div><div><span style="font-size: 12px;"> PARTIALS true</span></div><div><span style="font-size: 12px;"> END </span></div><div><span style="font-size: 12px;"> END</span></div><div><span style="font-size: 12px;"> CLASS</span></div><div><span style="font-size: 12px;"> NAME "Campo de futebol" </span></div><div><span style="font-size: 12px;"> EXPRESSION "2" </span></div><div><span style="font-size: 12px;"> STYLE</span></div><div><span style="font-size: 12px;"> SYMBOL "circle" </span></div><div><span style="font-size: 12px;"> SIZE 12 </span></div><div><span style="font-size: 12px;"> OUTLINECOLOR 0 0 0</span></div><div><span style="font-size: 12px;"> COLOR 255 170 0</span></div><div><span style="font-size: 12px;"> END</span></div><div><span style="font-size: 12px;"> LABEL </span></div><div><span style="font-size: 12px;"> FONT vera_sans</span></div><div><span style="font-size: 12px;"> TYPE truetype</span></div><div><span style="font-size: 12px;"> SIZE 9</span></div><div><span style="font-size: 12px;"> COLOR 0 0 0</span></div><div><span style="font-size: 12px;"> ANGLE 0</span></div><div><span style="font-size: 12px;"> POSITION auto</span></div><div><span style="font-size: 12px;"> #FORCE true</span></div><div><span style="font-size: 12px;"> ANTIALIAS true</span></div><div><span style="font-size: 12px;"> PARTIALS true</span></div><div><span style="font-size: 12px;"> END </span></div><div><span style="font-size: 12px;"> END</span></div><div><span style="font-size: 12px;"> CLASS</span></div><div><span style="font-size: 12px;"> NAME "Campo de tenis" </span></div><div><span style="font-size: 12px;"> EXPRESSION "3" </span></div><div><span style="font-size: 12px;"> STYLE</span></div><div><span style="font-size: 12px;"> SYMBOL "circle" </span></div><div><span style="font-size: 12px;"> SIZE 7.0 </span></div><div><span style="font-size: 12px;"> OUTLINECOLOR 0 0 0</span></div><div><span style="font-size: 12px;"> COLOR 255 0 0</span></div><div><span style="font-size: 12px;"> END</span></div><div><span style="font-size: 12px;"> LABEL </span></div><div><span style="font-size: 12px;"> FONT vera_sans</span></div><div><span style="font-size: 12px;"> TYPE truetype</span></div><div><span style="font-size: 12px;"> SIZE 9</span></div><div><span style="font-size: 12px;"> COLOR 0 0 0</span></div><div><span style="font-size: 12px;"> ANGLE 0</span></div><div><span style="font-size: 12px;"> POSITION auto</span></div><div><span style="font-size: 12px;"> #FORCE true</span></div><div><span style="font-size: 12px;"> ANTIALIAS true</span></div><div><span style="font-size: 12px;"> PARTIALS true</span></div><div><span style="font-size: 12px;"> END </span></div><div><span style="font-size: 12px;"> END</span></div><div><span style="font-size: 12px;"><br></span></div><div><span style="font-size: 12px;"><br></span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>METADATA</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span># drill-down identify service record.</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span> <span class="Apple-tab-span" style="white-space:pre"> </span>'identify_record'<span class="Apple-tab-span" style="white-space:pre"> </span>'templates/identify.html'</span></div><div><span style="font-size: 12px;"><br></span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span># query.php / "Search Parcels" functionality.</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>'itemquery'<span class="Apple-tab-span" style="white-space:pre"> </span>'templates/search_result.html'</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>'itemquery-filter'<span class="Apple-tab-span" style="white-space:pre"> </span>'/.*[qstring].*/i' </span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>'qstring_validation_pattern' '.'</span></div><div><span class="Apple-tab-span" style="white-space: pre; font-size: 12px;"> </span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span># Feature reports are stored in the conf/feature_report directory.</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>'feature_report' 'parcel.xml'</span></div><div><span style="font-size: 12px;"><br></span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span> <span class="Apple-tab-span" style="white-space:pre"> </span>'select_record'<span class="Apple-tab-span" style="white-space:pre"> </span>'templates/select_result.html'</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>'select_header' 'templates/select_header.html'</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>'popups' 'parcels_popup.html'</span></div><div><span style="font-size: 12px;"><br></span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>END</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>TOLERANCE 1</span></div><div><span style="font-size: 12px;"><span class="Apple-tab-span" style="white-space:pre"> </span>TOLERANCEUNITS PIXELS</span></div><div><span style="font-size: 12px;"><br></span></div><div><span style="font-size: 12px;"><br></span></div><div><span style="font-size: 12px;"><br></span></div><div><span style="font-size: 12px;"> <span class="Apple-tab-span" style="white-space:pre"> </span> END</span></div><div><span style="font-size: 12px;"> </span></div><div><span style="font-size: 12px;">END ## end Map</span></div><div style="font-size: 12px;"><br></div></font></span></div><div><span style="background-color: rgb(255, 255, 255);"><font face="Arial, Helvetica, sans-serif"><span style="font-size: 12px;"><br></span></font></span></div><div><span style="background-color: rgb(255, 255, 255);"><font face="Arial, Helvetica, sans-serif"><span style="font-size: 12px;">-------------------------------</span></font></span></div><div><span style="background-color: rgb(255, 255, 255);"><font face="Arial, Helvetica, sans-serif"><span style="font-size: 12px;">postgis table:</span></font></span></div><div>-------------------------------</div><div><span style="background-color: rgb(255, 255, 255);"><font face="Arial, Helvetica, sans-serif"><div><span style="font-size: 12px;">CREATE TABLE public.pontos_sportgis</span></div><div><span style="font-size: 12px;">(</span></div><div><span style="font-size: 12px;"> gid integer NOT NULL DEFAULT nextval('pontos_sportgis_gid_seq'::regclass),</span></div><div><span style="font-size: 12px;"> the_geom geometry(MultiPoint,4326),</span></div><div><span style="font-size: 12px;"> tipo_infra character varying(80),</span></div><div><span style="font-size: 12px;"> fotografia character varying(80),</span></div><div><span style="font-size: 12px;"> tipo smallint,</span></div><div><span style="font-size: 12px;"> nome character(50),</span></div><div><span style="font-size: 12px;"> CONSTRAINT pontos_sportgis_pkey PRIMARY KEY (gid )</span></div><div><span style="font-size: 12px;">)</span></div><div><span style="font-size: 12px;">WITH (</span></div><div><span style="font-size: 12px;"> OIDS=FALSE</span></div><div><span style="font-size: 12px;">);</span></div><div><span style="font-size: 12px;">ALTER TABLE public.pontos_sportgis</span></div><div><span style="font-size: 12px;"> OWNER TO postgres;</span></div><div><br></div><div><span style="font-size: 12px;">CREATE INDEX sidx_pontos_sportgis_the_geom</span></div><div><span style="font-size: 12px;"> ON public.pontos_sportgis</span></div><div><span style="font-size: 12px;"> USING gist</span></div><div><span style="font-size: 12px;"> (the_geom );</span></div><div style="font-size: 12px;"><br></div></font></span></div><div><span style="background-color: rgb(255, 255, 255);"><font face="Arial, Helvetica, sans-serif"><span style="font-size: 12px;"><br></span></font></span></div> </div></body>
</html>