
<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div>Not sure what is happening here. When I query the database I find every survey has an extra CENTRELINE row with all the fields containing NULL or zero values apart from the first row which I think has no centrelines as it’s the index file.</div><div><br></div>Test 2<br class="Apple-interchange-newline"><table style="position: static; z-index: auto;"><tbody><tr style="font-family: Times;"><td>Centreline ID</td><td>Survey ID</td><td>NAME</td><td>TITLE</td></tr><tr style="font-family: Times;"><td>2</td><td>1</td><td></td><td>No Title</td></tr><tr style="font-family: Times;"><td>34</td><td>31</td><td>1954</td><td>1954</td></tr><tr style="font-family: Times;"><td>32</td><td>31</td><td>1954</td><td>No Title</td></tr><tr style="font-family: Times;"><td>33</td><td>31</td><td>1954</td><td>1954</td></tr><tr style="font-family: Times;"><td>38</td><td>36</td><td>1954_ramps</td><td>1954 Ramps</td></tr><tr style="font-family: Times;"><td>37</td><td>36</td><td>1954_ramps</td><td>No Title</td></tr><tr style="font-family: Times;"><td>42</td><td>40</td><td>1954-endloop</td><td>1954-endloop</td></tr><tr style="font-family: Times;"><td>41</td><td>40</td><td>1954-endloop</td><td>No Title</td></tr><tr style="font-family: Times;"><td>46</td><td>44</td><td>1954_up_ramp</td><td>1954</td></tr><tr style="font-family: Times;"><td>45</td><td>44</td><td>1954_up_ramp</td><td>No Title</td></tr><tr style="font-family: Times;"><td>50</td><td>48</td><td>nothing_to_be_proud_of</td><td>Nothing to be proud of</td></tr><tr style="font-family: Times;"><td>49</td><td>48</td><td>nothing_to_be_proud_of</td><td>No Title</td></tr><tr style="font-family: Times;"><td>824</td><td>822</td><td>1954_garden_extension</td><td>1954 - Garden of Good and Evil extensions</td></tr><tr style="font-family: Times;"><td>823</td><td>822</td><td>1954_garden_extension</td><td>No Title</td></tr><tr style="font-family: Times;"><td>1032</td><td>1030</td><td>a65_highway_to_the_dales</td><td>dirty yorkshire habits</td></tr><tr style="font-family: Times;"><td>1031</td><td>1030</td><td>a65_highway_to_the_dales</td><td>No Title</td></tr><tr style="font-family: Times;"><td>1251</td><td>1250</td><td>aah_disto</td><td>No Title</td></tr><tr style="font-family: Times;"><td>1252</td><td>1250</td><td>aah_disto</td><td>Aah Disto</td></tr><tr style="font-family: Times;"><td>1255</td><td>1254</td><td>ancestor_passage</td><td>No Title</td></tr><tr style="font-family: Times;"><td>1256</td><td>1254</td><td>ancestor_passage</td><td>Ancestor Passage</td></tr><tr style="font-family: Times;"></tr></tbody></table><div><br></div><div>

<div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div style="color: rgb(0, 0, 0); font-variant: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">Dave Clucas<br><a href="http://daveclucas.com" style="font-family: Helvetica; font-style: normal; font-weight: normal;">daveclucas.com</a><br><a href="http://sarawak-caves.com" style="font-family: Helvetica; font-style: normal; font-weight: normal;">sarawak-caves.com</a><br><a href="mailto:daveclucas@icloud.com" style="font-family: Helvetica; font-style: normal; font-weight: normal;">dave.clucas@icloud.com</a><br><br><span style="font-size: 14px;"><b>Exploring the World</b></span><span style="font-family: Helvetica; font-style: normal; font-weight: normal;"> - One cave at a time<br><br></span></div></div></div></div>

</div>

<br></body></html>