[Geomoose-users] Feature Editor Adding Point, Line, Polygon Problems

[sana butt]

Hi Brent

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.

Could you please test the URL:

http://216.58.43.167/geomoose2/geomoose.html

and add point.


What I have done so far:

CREATE TABLE test_points
(
  feature_id integer NOT NULL,
  attribute1 character varying(100),
  attribute2 character varying(100),
  wkb_geometry geometry,
  CONSTRAINT pk_test_points PRIMARY KEY (feature_id)
)

CREATE SEQUENCE test_points_seq;
insert into geometry_columns values ('', 'public', 'test_points',
'wkb_geometry', 2, 24, 'GEOMETRY');

and follow the instructions available in feature editor guide.

I got this error in firefox.

URL:

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

Error:

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 )


I dont know, where I made mistake in creating table, etc.

Could you please help me solving this issue


Regards
Sana
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/geomoose-users/attachments/20120129/77ad7943/attachment.html