[Mapbender-commits] r9561 - trunk/documents/presentations/FOSS4G2016
svn_mapbender at osgeo.org
svn_mapbender at osgeo.org
Mon Aug 22 02:33:04 PDT 2016
Author: astrid_emde
Date: 2016-08-22 02:33:04 -0700 (Mon, 22 Aug 2016)
New Revision: 9561
Added:
trunk/documents/presentations/FOSS4G2016/FOSS4G2016_Mapbender3_Workshop_digitizer.txt
trunk/documents/presentations/FOSS4G2016/FOSS4G2016_Mapbender3_Workshop_searchrouter.txt
Log:
demos osm_local
Added: trunk/documents/presentations/FOSS4G2016/FOSS4G2016_Mapbender3_Workshop_digitizer.txt
===================================================================
--- trunk/documents/presentations/FOSS4G2016/FOSS4G2016_Mapbender3_Workshop_digitizer.txt (rev 0)
+++ trunk/documents/presentations/FOSS4G2016/FOSS4G2016_Mapbender3_Workshop_digitizer.txt 2016-08-22 09:33:04 UTC (rev 9561)
@@ -0,0 +1,93 @@
+-- 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}
Added: trunk/documents/presentations/FOSS4G2016/FOSS4G2016_Mapbender3_Workshop_searchrouter.txt
===================================================================
--- trunk/documents/presentations/FOSS4G2016/FOSS4G2016_Mapbender3_Workshop_searchrouter.txt (rev 0)
+++ trunk/documents/presentations/FOSS4G2016/FOSS4G2016_Mapbender3_Workshop_searchrouter.txt 2016-08-22 09:33:04 UTC (rev 9561)
@@ -0,0 +1,80 @@
+-- View: public.view_planet_osm_point
+
+-- 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";
+
+
+#---------------------------------------------------------
+class: Mapbender\CoreBundle\Component\SQLSearchEngine
+class_options:
+ connection: osm_local
+ relation: public.view_planet_osm_point
+ attributes:
+ - osm_id
+ - amenity
+ - brand
+ - highway
+ - name
+ - location
+ - gid
+ geometry_attribute: geom
+form:
+ location:
+ type: text
+ options:
+ required: false
+ label: location
+ attr:
+ data-autocomplete: on
+ compare: ilike
+results:
+ view: table
+ count: true
+ headers:
+ location: Location
+ brand: Brand
+ callback:
+ event: click
+ options:
+ buffer: 50
+ minScale: 500
+ maxScale: 2500
+ styleMap:
+ default:
+ strokeColor: '#00ff00'
+ strokeOpacity: 1
+ fillOpacity: 0
+ select:
+ strokeColor: '#ff0000'
+ fillColor: '#ff0000'
+ fillOpacity: 0.8
More information about the Mapbender_commits
mailing list