Quickfinder adress search example

quickfinder.sql

CREATE MATERIALIZED VIEW av.adressen AS 
    SELECT hau.pk, lok.r1_text || COALESCE(' ' || hau.r1_hausnum, '') AS adresse, hau.wkb_geometry
      FROM av.ge_hausnummerpos hau
        JOIN av.ge_lokalisationsnamepos lok ON lok.r1_benannt=hau.r1_gebaeud;

CREATE INDEX adressen_trgm_idx ON av.adressen USING gin (adresse gin_trgm_ops);

SELECT adresse,ST_AsBinary(wkb_geometry)::geometry
  FROM av.adressen
  WHERE similarity(adresse, %(search)s) > 0.2
  ORDER BY adresse <-> %(search)s
LIMIT %(limit)s