UK Users Group

 View Only
  • 1.  Multi Search Tool

    Posted 03-06-2023 13:01

    Time for a new video

    I have been setting up the new Multi Search Tool with OS AddressBase Core for a fast search and locate. It's a free tool to download from the MapInfo MarketPlace. Impressive results - remember to index your search fields.

    https://youtu.be/bI0WR7AYqms

    Enjoy



    ------------------------------
    John Ievers
    CDR Group
    Hope Valley, United Kingdom
    ------------------------------


  • 2.  RE: Multi Search Tool

    Posted 03-09-2023 08:40

    Thanks John, 

    MapInfo has always seemed to lack a good gazetteer search, so I'll give this a go. It's a shame that fuzzy searching is less than performant even on much smaller datasets. @Peter Møller once gave me a tool called Find DBMS that could connect to PostGIS and do the search server side (taking advantage of specialised text indexing) which was really fast. I wonder if this can do that?

    Otherwise it'd be good to get a tool working that can search the OS Places API, but I'm a bit rusty on querying web services in MapBasic...



    ------------------------------
    Tom Parker
    Cambridgeshire County Council
    HUNTINGDON
    ------------------------------



  • 3.  RE: Multi Search Tool

    Employee
    Posted 03-09-2023 09:09

    Yeah, that FindDBMS tool what quite fast as I remember, and flexible, as it could search views as well as base tables.

    That tool should still work if you have your data in a database - it doesn't have to be PostgreSQL/PostGIS.

    The idea behind Wildcard Search was the same as the idea behind DBMS Find: Providing an easy-to-use tool that quickly can find and list records matching the entered value.

    I guess the DBMS Find tool could even be improved to take advantage of some of the text comparison functions of the database.



    ------------------------------
    Peter Horsbøll Møller
    Principal Presales Consultant | Distinguished Engineer
    Precisely | Trust in Data
    ------------------------------