# lat_long_countries_capital
=============================================

Some explanations in connection with a POC on leaflet.js  

## Explanations
---------------------
The purpose was to output custom markers on a map with the help of an average latitude and longitude for each country. 
I add the MySQL table and a integration of an example with a custom marker.



## Content
--------------
1. **countries_capitals_location_fr_en.sql**: The full mysql table that contains  
	The country codes ISO 3166 eg AU for Australia  
	The English name of the country eg Australia  
	The French translation eg Australie  
	Average latitude and longitude of the country  
2. **countries_capitals_location_fr_en.json**: A json output of the MySQL Table.
3. **custom-icons-example.html with the directory icons**: An example of integration with a custom marker with leaftlet.js  



## For more information
------------------------------------
Feel free to check in French some articles @
[Flaven.net](http://flaven.fr//)








# lat_long_countries_capital
=============================================

Some explanations in connection with a POC on leaflet.js  

## Explanations
---------------------
The purpose was to output custom markers on a map with the help of an average latitude and longitude for each country. 
I add the MySQL table and a integration of an example with a custom marker.



## Content
--------------
1. **countries_capitals_location_fr_en.sql**: The full mysql table that contains  
	The country codes ISO 3166 eg AU for Australia  
	The English name of the country eg Australia  
	The French translation eg Australie  
	Average latitude and longitude of the country  
2. **countries_capitals_location_fr_en.json**: A json output of the MySQL Table.
3. **custom-icons-example.html with the directory icons**: An example of integration with a custom marker with leaftlet.js 
4 **countries_capitals_location_fr_en_full.sql**: Another MySQL table that provides additional columns to handle these languages: Swahili, Arabic, Persian, Russian, English, Chinese, French, Cambodian, Brazilian Portuguese, Vietnamese, Hausa, Spanish. Some translations are missing!
 



## For more information
------------------------------------
Feel free to check in French some articles @
[Flaven.net](http://flaven.fr//)








Add a new MySQL file countries_capitals_location_fr_en_full.sql
Add a new MySQL file countries_capitals_location_fr_en_full.sql
