GnomePlanet Stock Travel Photography

Register and login to use the Lightboxes and Client Area.

 

There are 0 registered members and 8 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: Using CSVed

The Photographer's World Database of Countries, States, and Cities is primarily designed to be uploaded to a server on the web and used to run a sophisticated database-based website. But 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 this 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, just follow the notes below...

Once you have installed the CSVed program, start it running, and click 'File > Open' then browse to the .csv file you wish to view.

When the file opens, the screen may show something similar to the image on the right (click to see it enlarged). Don't panic!

Click to see larger image

Do the following, in the correct order:

  1. Click 'Set Separator > Pipe'
  2. Check 'Use Start Row as Column Captions'
  3. Click the little '+' icon to hide the toolbar
  4. Click the Refresh icon to reload the page
Click to see larger image

You can now scroll up and down or side to side through the entire table, and inspect any value that you choose.

Click to see larger image

To make it easier to Copy and Paste values from the table to a different program, click on any of the data lines in the main window. The Edit Form window will open - it can be re-sized if necessary by dragging one of the corners.

Double-Click on any of the form values to select them, then right-click > Copy to copy to the Clipboard. You can also use the standard Windows shortcut: Control-C.

Click to see larger image

Stock Photograph Search

Advanced Search Page

Latest Photos

Sadu and truck decorated with marigold flowers for Basant Panchami Snana procession.Couple walking on the Uyuni Salt Flats at Isla Pescado.
Colorful Kumbh Mela festival tents under concrete  pillars of the Lal Bahadur Shastri Bridge.Rowing boat passes bathing pilgrims and tents next to River Ganges in early dawn light.
Rowing boat passes bathing pilgrims and tents next to River Ganges in early dawn light.Monument to Pioneering Archaeologists at the Pucara Walled City Ruins.
View some of the latest images posted to GnomePlanet Travel Photography

Random Photo

Tower of Westminster Cathedral framed by office buildings on Victoria Street.

Tower of Westminster Cathedral framed by office buildings on Victoria Street..

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