-- DROP VIEW public.view_planet_osm_point; CREATE OR REPLACE VIEW public.view_planet_osm_point AS SELECT planet_osm_point.osm_id, planet_osm_point.gid, planet_osm_point."addr:housenumber" AS housenumber, planet_osm_point.amenity, planet_osm_point.barrier, planet_osm_point.bicycle, planet_osm_point.brand, planet_osm_point.building, planet_osm_point.capital, planet_osm_point.disused, planet_osm_point.highway, planet_osm_point.historic, planet_osm_point.man_made, planet_osm_point.name, planet_osm_point.power, planet_osm_point.public_transport, planet_osm_point.railway, planet_osm_point.ref AS location, planet_osm_point.religion, planet_osm_point.shop, planet_osm_point.tourism, planet_osm_point."tower:type" AS towertype, planet_osm_point.z_order, planet_osm_point.way AS geom FROM planet_osm_point WHERE planet_osm_point.amenity = 'post_box'::text ALTER TABLE public.view_planet_osm_point OWNER TO "user"; #-------------UNIQUE ID------------------------------------ ALTER TABLE public.planet_osm_point ADD COLUMN gid integer; ALTER TABLE public.planet_osm_point ALTER COLUMN gid SET NOT NULL; ALTER TABLE public.planet_osm_point ALTER COLUMN gid SET DEFAULT nextval('planet_osm_point_gid_seq'::regclass); planet_osm_point_gid_seq: start value auf 9570 setzen #--------------------------------------------------------- poi: label: point digitizing maxResults: 500 featureType: connection: osm_local table: view_planet_osm_point uniqueId: gid geomType: point geomField: geom srid: 4326 openFormAfterEdit: true zoomScaleDenominator: 500 allowEditData: true allowDelete: true allowDigitize: true toolset: - type: drawPoint - type: moveFeature - type: selectFeature - type: removeSelected popup: title: point test suite width: 500px searchType: currentExtent # currentExtent|all - default is currentExtent tableFields: gid: {label: Nr. , width: 20%} location: {label: Location , width: 80%} formItems: - type: tabs children: - type: form title: Basic information css: {padding: 10px} children: - type: label title: Welcome to the digitize demo. Try the new Mapbender3 feature! - type: input title: Name mandatory: true name: name mandatoryText: Please give a name to the poi. infoText: "Help: Please give a name to the new object." - type: input title: Location mandatory: false name: location mandatoryText: Please give a title to the poi. - type: select title: Amenity name: amenity options: {post_box: post_box}