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

Missing data for columan "tags" #8

Closed chouisgiser closed 2 years ago

chouisgiser commented 2 years ago

Dear Stuart,

When I restore the table of uk_places using your provided "uk_places.sql" file, I encountered the error "missing data for column "tags" CONTEXT: COPY uk_places_point, line 1: "1 Aaron's Hill {718482994} {-151304,-62149,-58447,-57582} 0101000020E6100000C737CAB0402AE4BFC8A9E7EE..."". I checked the content of sql file and suspected that there are some empty values for the column tags, e.g., the first row, Aaron's Hill.

I am wondering if there is a solution to resolve it? E.g., using '' to fill the empty values?

Thanks in avance.

stuartemiddleton commented 2 years ago

Others have used the SQL file with no problems (including myself). Maybe its a local postgres config issue you have not allowing empty values? The instructions have exactly the commands I used successfully myself.

chouisgiser commented 2 years ago

Thanks a lot for your confirmation, Dr. Middleton, then I will have a more careful check and setting.