GnomePlanet Stock Travel Photography

Register and login to use the Lightboxes and Client Area.

 

There are 0 registered members and 11 guests currently viewing the site.

Member Login

Not a member yet? Sign Up!

 

A password will be e-mailed to you.

Visit the GnomePlanet Stock Travel Photography Gallery for High-Res Stock Travel Photos, Travel Photographer Tutorials, Tips, and Resources  

Photographer's World Database of Countries, States, and Cities

What is it? This website runs on a database that references all the photos online with the correct spelling and location for countries, states, and cities all around the world. It uses a number of separate tables to keep the information compact, fast to access, and easy to maintain. A number of people have expressed interest in this database, so I have now decided to offer an adapted version for anyone to use.

Who is it for? This database is ideally suited for any photographer who also likes experimenting with web pages and databases, but who previously couldn't find a source of all the data. It is useful for someone who wishes to set up an online database-driven gallery of their photos, or for someone who wants to keep track of all their own photographs on a local computer.

What's on offer? The database being offered here has 8 tables:

  • Country: 337 entries
  • State: 2,607 entries
  • City: 34,712 entries
  • Flag: 408 entries
  • Theme: 125 entries
  • Class_Of_Place: 15 entries
  • Type_Of_Place: 132 entries
  • Photo: 10 entries

The first 3 tables: Country, State, and City are the heart of the database. They contain information about each of these categories, and how they inter-relate. The fourth table, Flag, allows the database to link to a flag image for each country. There are also flags for US, Canadian, and Australian states. All are cross-referenced so that the flags, which are included with the database tables, can be used on your own website. Here are a few examples of the flags. There are more details on the Flags page.

World mini-flags

The remaining 4 tables: Theme, Class_Of_Place, Type_Of_Place, and Photo, are included at no charge: they are 'ideas' tables, to help you organise your photos in a more constructive way, and to help you provide themed collections and galleries. 'Photo' is the table where you store details of your own photos, for the database to reference and display. It has been given some sample entries to help you understand the style.

Anything else? Also included is a complete SQL script to set up the database automatically, and some sample queries that you can use to start working with the data. Each table is described in a comprehensive way, and a Sample sub-set of the Database, with installation notes and script, is provided free-of-charge for you to try out before you buy: its on the Download page.

What will I need to use it? The data tables are provided in a set of CSV files, so that they can be imported into a database of your choice. The data tables are also provided in an SQL script, so that they can be loaded straight into an SQL database server. If you intend to use the tables online, you will need a host with mySQL and PHP configured, and at least 1 free database. You will also need some way of uploading your database tables, setting a User account, and configuring the database itself: this usually means 'phpMyAdmin' or similar. IF YOU DON'T UNDERSTAND WHAT I HAVE JUST SAID, DO SOME RESEARCH BEFORE PROCEEDING FURTHER.

Can I just LOOK at the data? Maybe you are a photographer who needs a comprehensive list of world countries, states and cities to use when sorting or key-wording your photographs. You don't want to use the data in a database - you just want to look at the data, and then copy and paste it into Adobe PhotoShop, LightRoom, Bridge, or other image keywording programs. No problem - nothing could be easier. The data tables are provided in a set of CSV files, and you can look at them in any program that can display that format. At the simplest, you could use any Text Viewer program, such as NotePad, but I would recommend a dedicated CSV viewer, such as CSVedExternal link opens a new Browser window. Its very versatile, and its free. To use it, see my CSVed Tutorial page.

Interested? Then please visit these pages:
Structure   Flags   View CSV   Download   Purchase   FAQs

Stock Photograph Search

Advanced Search Page

Latest Photos

Woman looks at rusting steam locomotive in the cemetery of steam engines.Boy with Hindu God face paint raises money from Kumbh Mela pilgrim visitors.
Hindu Sadhu takes photo of Kumbh Mela tents from Lal Bahadur Shastri Bridge.Lines of canvas police tents in pre-dawn light next to Ganges river Sangam.
Decorated trucks drive through dust clouds in Basant Panchami Snana procession.Stucco frontage and tower of the Basilica San Francisco.
View some of the latest images posted to GnomePlanet Travel Photography

Random Photo

Evening 'Aarti' or fire puja performed by Hindu priests on the banks of the Ganga River.

Evening 'Aarti' or fire puja performed by Hindu priests on the banks of the Ganga River..

free counters

Web design by gnomeplanet.com   ::   All images and pages on this site are © 2008 - 2017 and remain the property of gnomeplanet.com   ::   All rights reserved