search

stuartemiddleton / geoparsepy

geoparsepy is a Python geoparsing library that will extract and disambiguate locations from text. It uses a local OpenStreetMap database which allows very high and unlimited geoparsing throughput, unlike approaches that use a third-party geocoding service (e.g. Google Geocoding API). this repository holds Python examples to use the PyPI library.
Other
54 stars 4 forks source link

Database setup fails #3

Closed daveekr closed 3 years ago

daveekr commented 3 years ago

Hi,

I started several attempts to setup the database required for geoparsepy. However I failed to do so on several devices and environments. I tried it on macOS locally and with Docker, same on Windows. I am not 100 % certain but I think the encoding of the sql Files is somehow messed up. Also I am struggling to setup the collation from the sql-Files.

Can anyone confirm that the dumps actually work and maybe give some advice?

Thanks in advance.

stuartemiddleton commented 3 years ago

the encoding of the SQL files on google drive link is UTF-8 and it should have size 1.2Gbytes (zipped and tar). I suggest you have downloaded the files OK, that they unzip and untar OK. Postgres should expect UTF-8 unless you have configured it differently.

others have got it working OK (look at the closed geoparsepy issues), so the SQL files themselves should be fine.

you have not reported the errors you get. the commands for installing the database are in the readme. if you are using Win10 then this link has some help setting up the client encoding correctly stackoverflow