<div>Hi Brent</div><div> </div><div>I have added polygon feature and its working, Now I have added point using the same criteria available at feature editor guide, but its not working.</div><div> </div><div>Could you please test the URL: </div>
<div> </div><div><a href="http://216.58.43.167/geomoose2/geomoose.html">http://216.58.43.167/geomoose2/geomoose.html</a></div><div> </div><div>and add point.</div><div> </div><div> </div><div>What I have done so far:</div>
<div> </div><div>CREATE TABLE test_points<br>(<br> feature_id integer NOT NULL,<br> attribute1 character varying(100),<br> attribute2 character varying(100),<br> wkb_geometry geometry,<br> CONSTRAINT pk_test_points PRIMARY KEY (feature_id)<br>
)</div><div> </div><div>CREATE SEQUENCE test_points_seq;</div><div>insert into geometry_columns values ('', 'public', 'test_points', 'wkb_geometry', 2, 24, 'GEOMETRY');</div><div> </div>
<div>and follow the instructions available in feature editor guide.</div><div> </div><div>I got this error in firefox.</div><div> </div><div>URL:</div><div> </div><div><a href="http://216.58.43.167/cgi-bin/mapserv.exe?map=%2Fms4w%2Fapps%2Fgeomoose2%2Fmaps%2F%2Fdevelopment%2Ftest_points%2Ftest_points.map&layers=points&mode=map&mapext=457196.607656+4917749.476731+517604.607656+4948205.476731&imgext=457196.607656+4917749.476731+517604.607656+4948205.476731&map_size=2517+1269&imgx=1258.5&imgy=634.5&imgxy=2517+1269">http://216.58.43.167/cgi-bin/mapserv.exe?map=%2Fms4w%2Fapps%2Fgeomoose2%2Fmaps%2F%2Fdevelopment%2Ftest_points%2Ftest_points.map&layers=points&mode=map&mapext=457196.607656+4917749.476731+517604.607656+4948205.476731&imgext=457196.607656+4917749.476731+517604.607656+4948205.476731&map_size=2517+1269&imgx=1258.5&imgy=634.5&imgxy=2517+1269</a></div>
<div> </div><div>Error:</div><div> </div><div>msDrawMap(): Image handling error. Failed to draw layer named 'points'.
prepare_database(): Query error. Error declaring cursor: ERROR: column
"id" does not exist
LINE 1: ...b_geometry)),'NDR'),feature_id::text from (select id as
feat...
^
With query string: DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(wkb_geometry)),'NDR'),feature_id::text
from (select id as feature_id, attribute1, attribute2,
astext(wkb_geometry) as wkt_geometry, wkb_geometry from test_points) as
mytable WHERE wkb_geometry && setSRID('BOX3D(457184.796930448
4917749.476731,517616.418381552 4948205.476731)'::BOX3D, 24 )
</div><div> </div><div> </div><div>I dont know, where I made mistake in creating table, etc.</div><div> </div><div>Could you please help me solving this issue</div><div> </div><div> </div><div>Regards</div><div>Sana</div>