Latest posts for the topic "Best way to implement name search in Geoname database"

Best way to implement name search in Geoname database

victorin — GMT

Hi, I'd like to know the best way to efficiently search for names in Geoname's databases, just like it's done in geoname search API functions I've noticed that if you search for an alternate name it finds the right place properly, so my question is what indexes/joins are needed? And another question is how geoname's api sort/choose among results because if I do a simple fulltext query in my imported Geoname table it returns more than 10 rows, on the other hand geoname's api only return 4 places for the same query. Thank you!!

Re:Best way to implement name search in Geoname database

marc — GMT

The GeoNames search is not database driven. It is a dedicated fulltext search index. Best Marc

Re:Best way to implement name search in Geoname database

Richard Tobin — GMT

marc wrote:

The GeoNames search is not database driven. It is a dedicated fulltext search index.

Is the code available so we can run local copies?

Re:Best way to implement name search in Geoname database

marc — GMT

The code is not available. I simply don't have the time to also provide support for this. Best Marc