Switch branches/tags
Nothing to show
Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
..
Failed to load latest commit information.
icons
README.md
countries_capitals_location_fr_en.json
countries_capitals_location_fr_en.sql
countries_capitals_location_fr_en_full.sql
custom-icons-example.html

README.md

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