-- 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