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