There are 0 registered members and 2 guests currently viewing the site.
A password will be e-mailed to you.
Photographer's World Database of Countries, States, and Cities: Structure
This page lists the structure of each table in the 'photographer' World Database of Countries, States, and Cities. It also includes some comments about each of the columns within each of the eight tables, to help you understand the structure of the database.
Column List: CountryID, CountryName, CountryAbbrev, CountryLon, CountryLat, GoogleZoom, DefaultPhotoID
Notes: This table contains the master list of all countries, and provides a variety of information that can be displayed alongside your photographs. The central position can be used to create markers for online dynamic maps, such as Google Maps, and the GoogleZoom field can then store the initial value of zoom that the map should be displayed with.
Column List: StateID, StateName, StateAbbrev, CountryName, CountryAbbrev, StateLon, StateLat, StateTypeEnglish, StateTypeLocal, StatePop2002, GoogleZoom, DefaultPhotoID
Notes: This table contains all known states, provinces, and other administration areas. Population unknown = '-99999'. Where no State_Abbrev exists, this has been filled with the Country_Abbrev. The central position can be used to create markers for online dynamic maps, such as Google Maps, and the GoogleZoom field can then store the initial value of zoom that the map should be displayed with.
Column List: CityID, CityName, CountryName, CountryAbbrev, StateName, StateAbbrev, CityArea, CityLon, CityLat, GoogleZoom, DefaultPhotoID
Notes: Where a name has changed, or a more common spelling is now used, the database has been updated to the Lonely Planet spelling. The central position can be used to create markers for online dynamic maps, such as Google Maps, and the GoogleZoom field can then store the initial value of zoom that the map should be displayed with.
Column List: FlagID, FlagName, CountryAbbrev, StateAbbrev, FlagLon, FlagLat, LinkToFlag
Notes: This table lists all the 48x32 pixel mini-flag .gifs that are included with this database. The Link_To_Flag field is used to create a link to the flag image that you wish to display. Either Country_Abbrev or State_Abbrev may be present, but the Link_To_Flag always contains the correct file name (not including '.gif'). All my available mini-flags are listed.
Column List: TypeOfPlaceID, ClassOfPlaceID, TypeOfPlace, WaypointSymbol
Notes: The TypeOfPlace table is used to provide a way of identifying what type of a place each photograph was taken of, or in, and can thus provide an extra category that photographs can be searched under or grouped under. The types are sub-divided into categories called 'ClassOfPlace', which can be used when presenting a list for data-entry. These values are stored in the table 'ClassOfPlace'. The last field refers to the Waypoint Symbol used for each TypeOfPlace. These values are used when generating Waypoint lists, and dictate what type of Waypoint Symbol is displayed on a GPS receiver.
Column List: ClassOfPlaceID, ClassName
Notes: The ClassOfPlace table is used to reduce redundancy in the TypeOfPlace table. It lists the categories that each TypeOfPlace is grouped under: 01-Worship, 02-Sleeping, 03-Eating, 04-Shopping, 05-Entertainment, 06-Transportation, 07-Essential Services, 08-Tourism, 09-Sites of Interest, 10-Sport, 11-Settlement, 12-Industry, 13-Natural, 14-Marine.
Column List: ThemeID, ThemeName, SubThemeName, SubSubThemeName, DefaultPhotoID
Notes: The Themes table is used to associate a theme to each of your photographs. It thus provides an extra category that photographs can be searched under or grouped under. It also provides a simple method of creating themed-galleries and portfolios. Each Theme can have, optionally, 2 levels of sub-theme, providing a wide range of theme classification.
Column List: PhotoID, LinkToPhoto, DateTaken, TimeTaken, CountryID, StateID, CityID, CountryName, StateName, CityName, TypeOfPlaceID, ThemeID, PhotoLat, PhotoLon, PhotoASL, Description, Keywords, Release, Orientation, Quality, HDR_Set, Status, Width, Height, Views
Notes: This is the table you will use to store details of each of your photographs. It has initially been populated with some sample entries, to give you an idea of the format that you should keep to. The 'NOT NULL' fields are required, and the 'NULL' fields are optional.
Stock Photograph SearchAdvanced Search Page
0 all arch architect architecture are argent argentina ark art blue bol bolivia brazil buddhist building building exterior built built structure car culture day dom door doors england history horizon horizontal la paz land man men old one outdoors people rajasthan red religion rio san scenery temple transport tree united kingdom use uzbekistan 1
Popular searches on this site.
Web design by gnomeplanet.com :: All images and pages on this site are © 2008 - 2018 and remain the property of gnomeplanet.com :: All rights reserved