Joined: 21/08/2018 22:48:28
Which mysql field type should I use to store country and city boundaries?
Mysql version: 5.7
Data source: Geonames shapes_all_low.txt (http://download.geonames.org/export/dump/)
The problem is that the coordinates in that file are listed as polygon for some countries and multipolygon for other countries.
I've used Mysql a lot but am completely new to spatial data types and maps and such; that said, I have read that only polygons can go into the polygon field type and only multipolygons for the multipolygon field type for mysql. This makes me think that I need two fields dependong on which type of polygon I need to store? Also, wouldn't this complicated the task of finding out if a point lies within country boundaries?