The mini-geocoder from plechi

mini-geocoder's People

Contributors

Stargazers

Watchers

mini-geocoder's Issues

find place name by lat-lon

Hi! Could you look at my question on SO http://stackoverflow.com/questions/42925362/can-i-use-direct-sql-queries-instead-of-using-nominatim-or-other-geo-decoders ?

Is it's possible to drop Nominatim ?

SQL type unknown

how to solve this problem?

 Executing prepared SQL statement [SELECT
  street,
  housenumber,
  postcode,
  city,
  country,
  longitude,
  latitude,
  CAST (ST_DistanceSphere(st_makepoint(longitude,latitude), st_makepoint(?,?)) AS FLOAT) as distance
FROM geocode_optimized  ORDER BY  distance ASC LIMIT 1 OFFSET 0]
2022-02-07 11:53:44.787 DEBUG 25433 --- [nio-8080-exec-4] o.s.jdbc.datasource.DataSourceUtils      : Fetching JDBC Connection from DataSource
2022-02-07 11:53:44.787 TRACE 25433 --- [nio-8080-exec-4] o.s.jdbc.core.StatementCreatorUtils      : Setting SQL statement parameter value: column index 1, parameter value [112.474844], value class [java.lang.Double], SQL type unknown
2022-02-07 11:53:44.787 TRACE 25433 --- [nio-8080-exec-4] o.s.jdbc.core.StatementCreatorUtils      : Setting SQL statement parameter value: column index 2, parameter value [-7.248484], value class [java.lang.Double], SQL type unknown
2022-02-07 11:53:44.789 DEBUG 25433 --- [nio-8080-exec-4] o.s.jdbc.datasource.DataSourceUtils      : Returning JDBC Connection to DataSource

Recommend Projects