GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
What mysql field type to use for country boundaries?  XML
Forum Index -> General
Author Message
gisconfusion



Joined: 21/08/2018 22:48:28
Messages: 3
Offline

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?
 
Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team