MySql find country via geometry / spatial data?

I am not sure you can do this only using MySQL. If you can interface the MySQL data with a scripting language, the n you can try the following. Generate an image of the world map.

Each pixel in the image will store the country id. You can lookup the country details from the MySQL db using this id.

Up vote 1 down vote favorite share g+ share fb share tw.

I want request my db with LAT/LON an get back a countrycode. I have the world borders in a mysql database (converted shapefile from djangoproject.com) as geometry datafield. When using SELECT countyname FROM `world` WHERE Contains(ogc_geom, POINT(-18, 64)) I get back not only "iceland" (which is true) but also greenland, russia and usa.

I tried other points (point in mongolia founds also in china and russia), tried using intersects(), checked with multipolygons... good ideas? Thanks, stefan mysql geometry spatial border link|improve this question asked Nov 25 '11 at 22:38showmetheworld61.

Consider posting on gis.stackexchange.com Or, save yourself a lot of time and use something like developer.yahoo.com/geo/placefinder – tomfumb Nov 25 '11 at 23:03 We have no way of answering this question without knowing what data is stored in the database. Please post a minimal sample: complete, concise and reproduces the issue. – outis Nov 25 '11 at 23:17.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.