FAQ Troubleshooting

bin/../lib/geocoder/us/sqlite3.so: undefined symbol: ceil

This error occurs when the math library that contains the ceil() function isn’t linked properly when building sqlite3.so. One solution is to include the ‘-lm’ flag when building. An example from src/libsqlite3_geocoder/Makefile:

levenshtein.o 
        $(CC) $(CFLAGS) -lm -shared $^ -o $@ 

See: http://groups.google.com/group/geocommons-geocode/browse_thread/thread/ecbad686213384f6

Geocode operations find an address, but the latitude and longitude values are not valid

This happens when two different geometry packing functions are used — one on import and the other when geocoding. One solution is to replace the unpack_geometry method with one that uses geo_ruby to unpack the geometry correctly. See http://groups.google.com/group/geocommons-geocode/browse_thread/thread/a85e37e2bc264043