update Mapbender 2.4

Astrid Emde astrid.emde at ccgis.de
Tue Aug 1 04:56:20 EDT 2006


Hello List,
(deutsch weiter unten)

thanks for the advise about the update of the guis. Sure gui2 and 
gui_digitize where not there in version 2.2.3, but the update script 
assumes that they already exist.

Here are the 4 SQL to handle the guis:


-----------------------------------------------
-- Insert the guis /Anlegen der guis

INSERT INTO gui (gui_id, gui_name, gui_description, gui_public) VALUES
('gui2','gui2','client element collection',1);

INSERT INTO gui (gui_id, gui_name, gui_description, gui_public) VALUES 
('gui_digitize','gui_digitize','new gui for digitizing',1);


-- assign the gui to the user root / Zuordnung der GUIs zu user root


INSERT INTO gui_mb_user (fkey_gui_id, fkey_mb_user_id, mb_user_type) 
VALUES ('gui2', 1, 'owner');
INSERT INTO gui_mb_user (fkey_gui_id, fkey_mb_user_id, mb_user_type) 
VALUES ('gui_digitize', 1, 'owner');

-------------------------------------------------

But that won't be enough, because the guis don't have any WMS at that 
moment.

In the gui2 that's no problem, you can take the WMS from the GUI called 
gui and link the WMS to the gui2.

For gui_digitize it is a bit more complex, because WMS and WFS come 
together.

Have a look how the gui_digitize is set up at mapbender_dev:

http://wms1.ccgis.de/mapbender_dev/frames/login.php?name=guest&password=guest&mb_user_myGui=gui_digitize

Or make your own account and you can have a look at your own gui_digitize

Attached to the mail is a discription with SQL to help you to update the 
gui_digitize.

-------------------------------------------

Hallo Liste,

danke für den Fehler im update-Script der guis. gui2 und gui_digitize 
lagen in der Version 2.2.3 noch nicht vor, dass Skript geht aber dacvon 
aus, dass sie schon existieren.

Die 4 SQL weiter oben können vor dem Ausführen des Skrites 
update_guis_utf8.sql abgeschickt werden (Anlegen der guis, Zuordnung der 
GUIs zu user root)

Dies wird aber noch nicht ausreichen. Die guis liegen vor sind aber noch 
nicht mit WMS bestückt.

Für die gui2 stellt das kein Problem dar. Hier können einfach über die 
Administration die WMS aus der gui übernommen werden.


Hier der Link zur gui_digitize auf mapbender_dev:

http://wms1.ccgis.de/mapbender_dev/frames/login.php?name=guest&password=guest&mb_user_myGui=gui_digitize

Noch besser ist es ein Account auf mapbender_dev einzurichten und die 
eigene gui_digitize anzuschauen.

http://wms1.ccgis.de/mapbender_dev/


Im Anhang der Mail befindet sich eine Beschreibung für den update der 
gui_digitize

-- 

Schönen Gruß

Astrid Emde

----------------------------------

  Astrid Emde
  CCGIS GbR
  Siemensstraße 8
  53121 Bonn
  Germany

----------------------------------
   astrid.emde at ccgis.de
          www.ccgis.de
----------------------------------
  Tel.:      ++49 (0) 228 90826 19
  Fax.:      ++49 (0) 228 90826 11
  Zentrale:  ++49 (0) 228 90826 0
----------------------------------
-------------- next part --------------
-- Link WMS to GUI / WMS in GUI einbinden
-- link wms Demis world , JPL World Map , Germany from gui to the gui_digitize

-- Have a look at .. for the database structure
-- http://www.mapbender.org/index.php/Database-structure


-- Update the database
-- problems can occur, when test with wfs took place already. then the ids won't fit.
-- and it is better to load the WFS from the admin1- load WFS
-- http://wms1.ccgis.de:80/geoserver/wfs/GetCapabilities?REQUEST=getCapabilities&VERSION=1.0.0&SERVICE=WFS

-- table wfs
-- make sure that wfs_id 2 does not exist

INSERT INTO wfs (wfs_id, wfs_version, wfs_name, wfs_title, wfs_abstract, wfs_getcapabilities, wfs_describefeaturetype, wfs_getfeature, wfs_transaction, wfs_owsproxy) VALUES (2, '1.0.0', 'My GeoServer WFS', 'My GeoServer WFS', '
This is a description of your Web Feature Server.

The GeoServer is a full transactional Web Feature Server, you may wish to limit
GeoServer to a Basic service level to prevent modificaiton of your geographic
data.
     ', 'http://wms1.ccgis.de:80/geoserver/wfs/GetCapabilities?', 'http://wms1.ccgis.de:80/geoserver/wfs/DescribeFeatureType?', 'http://wms1.ccgis.de:80/geoserver/wfs/GetFeature?', 'http://wms1.ccgis.de:80/geoserver/wfs/Transaction?', NULL);



-- wfs_conf
-- make sure that wfs_conf_id 2,3, or 4 don't not exist

INSERT INTO wfs_conf (wfs_conf_id, wfs_conf_abstract, fkey_wfs_id, fkey_featuretype_id, g_label, g_label_id, g_button, g_button_id, g_style, g_buffer, g_res_style, g_use_wzgraphics) VALUES (2, 'myPolygons', 2, 8, 'Polygon:', '', '', '', '', 0.01, '', 1);
INSERT INTO wfs_conf (wfs_conf_id, wfs_conf_abstract, fkey_wfs_id, fkey_featuretype_id, g_label, g_label_id, g_button, g_button_id, g_style, g_buffer, g_res_style, g_use_wzgraphics) VALUES (4, 'myPoints', 2, 16, 'Point:', '', '', '', '', 0.01, '', 1);
INSERT INTO wfs_conf (wfs_conf_id, wfs_conf_abstract, fkey_wfs_id, fkey_featuretype_id, g_label, g_label_id, g_button, g_button_id, g_style, g_buffer, g_res_style, g_use_wzgraphics) VALUES (3, 'myLines', 2, 22, 'Line:', '', '', '', '', 0.01, '', 1);

-- wfs_conf_element
-- make sure that wfs_conf_element_id 12-29 don't not exist

INSERT INTO wfs_conf_element (wfs_conf_element_id, fkey_wfs_conf_id, f_id, f_geom, f_gid, f_search, f_pos, f_style_id, f_toupper, f_label, f_label_id, f_show, f_respos) VALUES (13, 2, 99, 0, 0, 0, 0, '0', 0, '', '0', 1, 1);
INSERT INTO wfs_conf_element (wfs_conf_element_id, fkey_wfs_conf_id, f_id, f_geom, f_gid, f_search, f_pos, f_style_id, f_toupper, f_label, f_label_id, f_show, f_respos) VALUES (14, 2, 100, 0, 0, 0, 0, '0', 0, '', '0', 0, 0);
INSERT INTO wfs_conf_element (wfs_conf_element_id, fkey_wfs_conf_id, f_id, f_geom, f_gid, f_search, f_pos, f_style_id, f_toupper, f_label, f_label_id, f_show, f_respos) VALUES (15, 2, 101, 0, 0, 0, 0, '0', 0, '', '0', 0, 0);
INSERT INTO wfs_conf_element (wfs_conf_element_id, fkey_wfs_conf_id, f_id, f_geom, f_gid, f_search, f_pos, f_style_id, f_toupper, f_label, f_label_id, f_show, f_respos) VALUES (17, 2, 103, 0, 0, 0, 0, '0', 0, '', '0', 0, 0);
INSERT INTO wfs_conf_element (wfs_conf_element_id, fkey_wfs_conf_id, f_id, f_geom, f_gid, f_search, f_pos, f_style_id, f_toupper, f_label, f_label_id, f_show, f_respos) VALUES (16, 2, 102, 1, 0, 0, 0, '0', 0, '', '0', 0, 0);
INSERT INTO wfs_conf_element (wfs_conf_element_id, fkey_wfs_conf_id, f_id, f_geom, f_gid, f_search, f_pos, f_style_id, f_toupper, f_label, f_label_id, f_show, f_respos) VALUES (12, 2, 98, 0, 1, 0, 0, '0', 0, '', '0', 0, 0);
INSERT INTO wfs_conf_element (wfs_conf_element_id, fkey_wfs_conf_id, f_id, f_geom, f_gid, f_search, f_pos, f_style_id, f_toupper, f_label, f_label_id, f_show, f_respos) VALUES (19, 3, 167, 0, 0, 0, 0, '0', 0, '', '0', 1, 1);
INSERT INTO wfs_conf_element (wfs_conf_element_id, fkey_wfs_conf_id, f_id, f_geom, f_gid, f_search, f_pos, f_style_id, f_toupper, f_label, f_label_id, f_show, f_respos) VALUES (20, 3, 168, 0, 0, 0, 0, '0', 0, '', '0', 0, 0);
INSERT INTO wfs_conf_element (wfs_conf_element_id, fkey_wfs_conf_id, f_id, f_geom, f_gid, f_search, f_pos, f_style_id, f_toupper, f_label, f_label_id, f_show, f_respos) VALUES (21, 3, 169, 0, 0, 0, 0, '0', 0, '', '0', 0, 0);
INSERT INTO wfs_conf_element (wfs_conf_element_id, fkey_wfs_conf_id, f_id, f_geom, f_gid, f_search, f_pos, f_style_id, f_toupper, f_label, f_label_id, f_show, f_respos) VALUES (23, 3, 171, 0, 0, 0, 0, '0', 0, '', '0', 0, 0);
INSERT INTO wfs_conf_element (wfs_conf_element_id, fkey_wfs_conf_id, f_id, f_geom, f_gid, f_search, f_pos, f_style_id, f_toupper, f_label, f_label_id, f_show, f_respos) VALUES (22, 3, 170, 1, 0, 0, 0, '0', 0, '', '0', 0, 0);
INSERT INTO wfs_conf_element (wfs_conf_element_id, fkey_wfs_conf_id, f_id, f_geom, f_gid, f_search, f_pos, f_style_id, f_toupper, f_label, f_label_id, f_show, f_respos) VALUES (18, 3, 166, 0, 1, 0, 0, '0', 0, '', '0', 0, 0);
INSERT INTO wfs_conf_element (wfs_conf_element_id, fkey_wfs_conf_id, f_id, f_geom, f_gid, f_search, f_pos, f_style_id, f_toupper, f_label, f_label_id, f_show, f_respos) VALUES (25, 4, 126, 0, 0, 0, 0, '0', 0, '', '0', 1, 1);
INSERT INTO wfs_conf_element (wfs_conf_element_id, fkey_wfs_conf_id, f_id, f_geom, f_gid, f_search, f_pos, f_style_id, f_toupper, f_label, f_label_id, f_show, f_respos) VALUES (26, 4, 127, 0, 0, 0, 0, '0', 0, '', '0', 0, 0);
INSERT INTO wfs_conf_element (wfs_conf_element_id, fkey_wfs_conf_id, f_id, f_geom, f_gid, f_search, f_pos, f_style_id, f_toupper, f_label, f_label_id, f_show, f_respos) VALUES (27, 4, 128, 0, 0, 0, 0, '0', 0, '', '0', 0, 0);
INSERT INTO wfs_conf_element (wfs_conf_element_id, fkey_wfs_conf_id, f_id, f_geom, f_gid, f_search, f_pos, f_style_id, f_toupper, f_label, f_label_id, f_show, f_respos) VALUES (29, 4, 130, 0, 0, 0, 0, '0', 0, '', '0', 0, 0);
INSERT INTO wfs_conf_element (wfs_conf_element_id, fkey_wfs_conf_id, f_id, f_geom, f_gid, f_search, f_pos, f_style_id, f_toupper, f_label, f_label_id, f_show, f_respos) VALUES (28, 4, 129, 1, 0, 0, 0, '0', 0, '', '0', 0, 0);
INSERT INTO wfs_conf_element (wfs_conf_element_id, fkey_wfs_conf_id, f_id, f_geom, f_gid, f_search, f_pos, f_style_id, f_toupper, f_label, f_label_id, f_show, f_respos) VALUES (24, 4, 125, 0, 1, 0, 0, '0', 0, '', '0', 0, 0);     

-- wfs_featuretype
INSERT INTO wfs_featuretype (fkey_wfs_id, featuretype_id, featuretype_name, featuretype_title, featuretype_srs) VALUES (2, 6, 'cite:RoadSegments', 'cite:RoadSegments', 'EPSG:4326');
INSERT INTO wfs_featuretype (fkey_wfs_id, featuretype_id, featuretype_name, featuretype_title, featuretype_srs) VALUES (2, 7, 'topp:ortschaften', 'ortschaften_Type', 'EPSG:4326');
INSERT INTO wfs_featuretype (fkey_wfs_id, featuretype_id, featuretype_name, featuretype_title, featuretype_srs) VALUES (2, 8, 'topp:edit_polygon', 'edit_polygon_Type', 'EPSG:4326');
INSERT INTO wfs_featuretype (fkey_wfs_id, featuretype_id, featuretype_name, featuretype_title, featuretype_srs) VALUES (2, 9, 'cite:DividedRoutes', 'cite:DividedRoutes', 'EPSG:4326');
INSERT INTO wfs_featuretype (fkey_wfs_id, featuretype_id, featuretype_name, featuretype_title, featuretype_srs) VALUES (2, 10, 'cite:Streams', 'cite:Streams', 'EPSG:4326');
INSERT INTO wfs_featuretype (fkey_wfs_id, featuretype_id, featuretype_name, featuretype_title, featuretype_srs) VALUES (2, 11, 'cite:Bridges', 'cite:Bridges', 'EPSG:4326');
INSERT INTO wfs_featuretype (fkey_wfs_id, featuretype_id, featuretype_name, featuretype_title, featuretype_srs) VALUES (2, 12, 'cite:Lakes', 'cite:Lakes', 'EPSG:4326');
INSERT INTO wfs_featuretype (fkey_wfs_id, featuretype_id, featuretype_name, featuretype_title, featuretype_srs) VALUES (2, 13, 'cite:BasicPolygons', 'cite:BasicPolygons', 'EPSG:4326');
INSERT INTO wfs_featuretype (fkey_wfs_id, featuretype_id, featuretype_name, featuretype_title, featuretype_srs) VALUES (2, 14, 'cite:Forests', 'cite:Forests', 'EPSG:4326');
INSERT INTO wfs_featuretype (fkey_wfs_id, featuretype_id, featuretype_name, featuretype_title, featuretype_srs) VALUES (2, 15, 'cite:NamedPlaces', 'cite:NamedPlaces', 'EPSG:4326');
INSERT INTO wfs_featuretype (fkey_wfs_id, featuretype_id, featuretype_name, featuretype_title, featuretype_srs) VALUES (2, 16, 'topp:edit_point', 'edit_point_Type', 'EPSG:4326');
INSERT INTO wfs_featuretype (fkey_wfs_id, featuretype_id, featuretype_name, featuretype_title, featuretype_srs) VALUES (2, 17, 'topp:staedte', 'staedte_Type', 'EPSG:4326');
INSERT INTO wfs_featuretype (fkey_wfs_id, featuretype_id, featuretype_name, featuretype_title, featuretype_srs) VALUES (2, 18, 'topp:post_code_areas', 'post_code_areas_Type', 'EPSG:4326');
INSERT INTO wfs_featuretype (fkey_wfs_id, featuretype_id, featuretype_name, featuretype_title, featuretype_srs) VALUES (2, 19, 'cite:MapNeatline', 'cite:MapNeatline', 'EPSG:4326');
INSERT INTO wfs_featuretype (fkey_wfs_id, featuretype_id, featuretype_name, featuretype_title, featuretype_srs) VALUES (2, 20, 'topp:mapbender_user', 'mapbender_user_Type', 'EPSG:4326');
INSERT INTO wfs_featuretype (fkey_wfs_id, featuretype_id, featuretype_name, featuretype_title, featuretype_srs) VALUES (2, 21, 'cite:Buildings', 'cite:Buildings', 'EPSG:4326');
INSERT INTO wfs_featuretype (fkey_wfs_id, featuretype_id, featuretype_name, featuretype_title, featuretype_srs) VALUES (2, 22, 'topp:edit_line', 'edit_line_Type', 'EPSG:4326');
INSERT INTO wfs_featuretype (fkey_wfs_id, featuretype_id, featuretype_name, featuretype_title, featuretype_srs) VALUES (2, 23, 'cite:Ponds', 'cite:Ponds', 'EPSG:4326');


--wfs_element
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (6, 69, 'the_geom', 'MultiLineStringPropertyType');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (6, 70, 'FID', '');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (6, 71, 'NAME', '');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 72, 'rc', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 73, 'ufi', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 74, 'uni', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 75, 'lat', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 76, 'long', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 77, 'dms_lat', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 78, 'dms_long', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 79, 'utm', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 80, 'jog', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 81, 'fc', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 82, 'dsg', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 83, 'pc', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 84, 'cc1', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 85, 'adm1', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 86, 'adm2', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 87, 'dim', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 88, 'cc2', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 89, 'nt', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 90, 'lc', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 91, 'short_form', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 92, 'generic', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 93, 'sort_name', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 94, 'full_name', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 95, 'full_name_nd', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 96, 'modify_date', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (7, 97, 'the_geom', 'PointPropertyType');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (8, 98, 'gid', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (8, 99, 'name', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (8, 100, 'angle', 'double');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (8, 101, 'annotation', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (8, 102, 'the_geom', 'MultiPolygonPropertyType');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (8, 103, 'style', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (9, 104, 'the_geom', 'MultiLineStringPropertyType');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (9, 105, 'FID', '');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (9, 106, 'NAME', '');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (9, 107, 'NUM_LANES', 'double');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (10, 108, 'the_geom', 'MultiLineStringPropertyType');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (10, 109, 'FID', '');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (10, 110, 'NAME', '');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (11, 111, 'the_geom', 'PointPropertyType');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (11, 112, 'FID', '');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (11, 113, 'NAME', '');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (12, 114, 'the_geom', 'MultiPolygonPropertyType');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (12, 115, 'FID', '');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (12, 116, 'NAME', '');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (13, 117, 'the_geom', 'MultiPolygonPropertyType');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (13, 118, 'ID', '');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (14, 119, 'the_geom', 'MultiPolygonPropertyType');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (14, 120, 'FID', '');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (14, 121, 'NAME', '');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (15, 122, 'the_geom', 'MultiPolygonPropertyType');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (15, 123, 'FID', '');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (15, 124, 'NAME', '');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (16, 125, 'gid', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (16, 126, 'name', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (16, 127, 'angle', 'double');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (16, 128, 'annotation', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (16, 129, 'the_geom', 'PointPropertyType');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (16, 130, 'style', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (17, 131, 'gid', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (17, 132, 'objectid', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (17, 133, 'area', 'double');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (17, 134, 'perimeter', 'double');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (17, 135, 'pppoint_', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (17, 136, 'pppoint_id', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (17, 137, 'pppttype', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (17, 138, 'ppptname', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (17, 139, 'ppptflag', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (17, 140, 'polygonid', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (17, 141, 'scale', 'double');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (17, 142, 'angle', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (17, 143, 'name_neu1', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (17, 144, 'name_typ', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (17, 145, 'the_geom', 'PointPropertyType');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (18, 146, 'plz99', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (18, 147, 'plz99_n', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (18, 148, 'plzort99', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (18, 149, 'the_geom', 'MultiPolygonPropertyType');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (19, 150, 'the_geom', 'MultiLineStringPropertyType');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (19, 151, 'FID', '');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (20, 152, 'gid', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (20, 153, 'firstname', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (20, 154, 'lastname', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (20, 155, 'usertype', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (20, 156, 'orga', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (20, 157, 'url', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (20, 158, 'town', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (20, 159, 'email', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (20, 160, 'fullname', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (20, 161, 'urlmap', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (20, 162, 'the_geom', 'PointPropertyType');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (21, 163, 'the_geom', 'MultiPolygonPropertyType');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (21, 164, 'FID', '');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (21, 165, 'ADDRESS', '');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (22, 166, 'gid', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (22, 167, 'name', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (22, 168, 'angle', 'double');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (22, 169, 'annotation', 'string');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (22, 170, 'the_geom', 'MultiLineStringPropertyType');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (22, 171, 'style', 'int');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (23, 172, 'the_geom', 'MultiPolygonPropertyType');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (23, 173, 'FID', '');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (23, 174, 'NAME', '');
INSERT INTO wfs_element (fkey_featuretype_id, element_id, element_name, element_type) VALUES (23, 175, 'TYPE', '');

-- 2. load the wms to gui_digitize : http://wms1.ccgis.de/cgi-bin/mapserv?map=/data/umn/wfs/germany_wfs_myedit_4326.map&&VERSION=1.1.1&REQUEST=GetCapabilities&SERVICE=WMS

-- 3. Connect the layer of the WFS with the WFS
-- a) admin2_en WMS GUI settings or admin2_de WMS GUi Einstellungen
-- b) select WMS MyEdit Elements
-- c) for each layer connnect the WMS layer with the wfs featureType with the button setWFS


More information about the Mapbender_users mailing list