This is

Your Photographs and EXIF - a mass of data - the details page

My Database Tables
So you've seen how I import and process EXIF data, and produce Google Earth KML files. Here are some tech details.

First, the two main database tables:

{pk1_master}One row per folder
folder textThe folder number
dated textThe date the pics were taken
manypics integerHow many pics are in this folder
location textThe location of the session
lens textThe lens used
iso integerThe ISO - I rarely change midstream
notes textEg, a lovely day, great scenery
rangef textThe first picture number
ranget textThe last picture number
keywords TEXTA series of one-to-many space-separated keywords
{photodata}One row per picture. All data derived from the EXIF except the decimalised lat and long
folder TEXTThe folder number
picture TEXTThe picture number
aperture TEXTAperture
shutter TEXTShutter speed
iso TEXTISO - will match ISO in the other table
lens TEXTDitto
dated TEXTThe GPS-derived date
timed TEXTThe GPS-derived time of the shutter click
rawlat TEXTLatitude in the form 51 deg 24' 8.96" N
rawlong TEXTLongitude in the form 1 deg 18' 45.63" W
rawalt TEXTAltitude as recorded in the EXIF, eg, 98.4 m Above Sea Level
declat TEXTLatitude translated to decimal, eg, 51.402475
declong TEXTLongitude translated to decimal, eg, -1.312675
decalt TEXTAltitude 'sanitised', eg, 98.4
satellites TEXTNumber of satellites visible when picture taken, usually around 7 to 11
heading TEXTThe direction the camera was pointing at the time the pic was taken
cameratempTEXTThe camera temperature when the picture was taken

And a sample KML file, in my latest version:

<?xml version='1.0' encoding='UTF-8'?>
<kml xmlns=''>
<Style id="master">

<description><![CDATA[<span style={background-color:white}><font face=Verdana size=4><font color=maroon>05/08/2016 at 09:25:11</font><br><br>ISO 250 f/5.6 @ 1/1600<br><br><font color=green>50 mm lens</font><br><br>Facing 264.47 °</font></span>]]></description>

<description><![CDATA[<span style={background-color:white}><font face=Verdana size=4><font color=maroon>05/08/2016 at 09:25:45</font><br><br>ISO 250 f/5.6 @ 1/1250<br><br><font color=green>50 mm lens</font><br><br>Facing 333.86 °</font></span>]]></description>