There are 0 registered members and 9 guests currently viewing the site.
A password will be e-mailed to you.
Photographer's World Database of Countries, States, and Cities: StructureThis 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. TableName: country PrimaryKey: CountryID 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.
TableName: state PrimaryKey: StateID 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.
TableName: city PrimaryKey: CityID 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.
TableName: flag PrimaryKey: FlagID 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.
TableName: type_of_place PrimaryKey: TypeOfPlaceID 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.
TableName: class_of_place PrimaryKey: ClassOfPlaceID 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.
TableName: theme PrimaryKey: ThemeID 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.
TableName: photo PrimaryKey: PhotoID 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 PageTag Cloud
0
all
alma-ata
architect
are
argentina
ark
artistic
ashgabat
beijing
bolivia
buddhist
cabinda
canada
car
china
city
creativity
culture
door
doors
end
foz do iguacu
history
horizon
india
kazakhstan
kerala
land
man
men
military
moskovskaya oblast
museum
nature
nizhny novgorod
one
onguday
outdoor
people
rajasthan
representation
rio
russia asiatic
russia european
salta
semipalatinsk
transport
uniform
use
Popular searches on this site. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Web design by gnomeplanet.com :: All images and pages on this site are © 2008 - 2024 and remain the property of gnomeplanet.com :: All rights reserved |