251010 - 10Oct25 - session 25-41

Footpaths, Stiles, Icons, EPC, AI and XMAP, Nature Recovery Strategy, Nature Wildlife Corridors, new boundaries in Somerset, National Grid data, plenty of Banter

Video Timeline: (min:sec)

00:00 01:57 Introductory Banter

01:57 - 12:15 Footpaths, Stiles and relevant icons

12:15 - 13:20 Banter

13:20 - 20:20 EPC - follow-up from last week combining data from GOV.UK and Parish Online - imports into Parish Online

20:20 - 26:30 Data imports into XMAP, and help from AI in reformatting data

26:30 - 29:28 Somerset Nature Recovery Strategy and mapping - liaison with county IT/GIS

29:28 - 34:00 Two-way data to/from county and parish councils

34:00 - 37:30 Nature Wildlife Corridors

37:30 - 43:00 banter, including new council boundaries in Somerset

43:00 - 48:00 National Grid data, both within Parish Online, and without

48:00 - 54:26 (end) banter

---

Meeting Summary:

Quick recap

The meeting began with informal discussions about recent events and updates on various projects, including public rights of way and mapping interfaces. The group then focused on data management challenges, particularly regarding EPC data analysis and mapping, while Graham shared his experiences with using AI tools for data processing. The latter part of the meeting covered conservation efforts and parish boundary changes in Somerset, along with discussions about integrating National Grid data into Parish Online.

Next steps

• John to look into Somerset's local nature recovery strategy and the mapping issues raised by Andrew regarding parish involvement.

• Andrew to respond to Somerset's nature recovery strategy by the end of October.

• Chris to continue updating the public rights of way map with gates, styles, and signposts, consolidating the three separate layers into one layer with status field.

• David to send his EPC data spreadsheet to the Parish Online help desk and ask them to upload it into a Parish layer.

Summary

Public Rights of Way Project Update

The meeting began with informal greetings and small talk about the weather and a recent conference organized by SALC, which John noted was more focused and successful than the previous year. Chris provided an update on his project involving public rights of way, specifically focusing on listing gates, styles, and signposts. He highlighted the need to distinguish between different types of structures and mentioned plans to work with a Somerset Council officer to address issues such as a damaged style that poses difficulty for older adults, with the intention of replacing it with a kissing gate.

Map Interface Status Field Update

Chris and Graham discussed updating a map interface by adding a status field to consolidate multiple layers into one. They demonstrated how to style different icons based on status, with Chris agreeing to use a "no-entry" sign for removed items. Graham suggested using class-based styling and showed Chris how to select appropriate icons from a library. The conversation concluded with Chris agreeing to consolidate the three layers into one and Graham introducing David to the group.

EPC Data Management Updates

The meeting discussed updates on data management and mapping issues. David shared his progress on EPC data analysis, noting challenges in accessing and displaying the data on public maps. Graham suggested uploading the data to a Parish layer for better control and frequent updates. They also discussed the need to improve public awareness of EPC ratings to encourage energy efficiency improvements. Stuart provided an update on the development of displaying EPC data on public maps, indicating it's on the development list.

AI Tools for Data Conversion

Graham encountered issues with uploading a file to Parish Online due to a syntax error and file naming constraints. After multiple attempts and assistance from the help desk and AI tools like Claude and ChatGPT, he managed to convert the data to the required British National Grid format. While Claude provided a solution but took time, ChatGPT initially failed to make the changes but eventually corrected its output. Graham noted that ChatGPT mangled unrelated data columns, highlighting the trade-off between speed and accuracy when using AI tools for data processing.

AI Development and Data Integration

The group discussed the development and potential of AI, with Graham sharing his experience using Claude for customer service, noting its thoughtful and apologetic nature. Andrew raised concerns about the lack of a suitable mapping platform for parish nature recovery projects, highlighting the need for compatible software to allow data transfer. John mentioned the positive relationship between Chris Mews and Adam Reimer, which has led to a significant amount of data being uploaded from Somerset, though much of it is not very useful. The group agreed to explore the possibility of using Parish Online to receive data from higher authorities, with John offering to follow up on this.

Somerset Nature Recovery Strategy Discussion

The group discussed Somerset's local nature recovery strategy, which Andrew found difficult to navigate on his new Mac OS 26. They noted that the strategy provided limited mapping tools and guidance for parishes, with a requirement to respond by the end of October. The conversation then shifted to conservation efforts, including building corridors for rare species like the shrill carder bee and brown hairstreak butterfly, as well as vipers, across different regions in the UK. David mentioned ongoing work in North Hampshire and Surrey to create connected habitats for these species.

Somerset Parish Boundary Review

The group discussed changes to parish boundaries in Somerset, with the Electoral Commission planning to review and potentially merge smaller parishes by 2027. John explained that this initiative follows the completion of ward boundary reviews, addressing anomalies such as parish boundaries running through houses and situations where ratepayers benefit from authorities in neighboring areas. The discussion highlighted examples of proposed mergers, including Ubley and Langport, while noting resistance in some areas like Ansford, and touched on historical issues with West Somerset's financial viability due to its lack of industry.

National Grid Data Integration Discussion

The group discussed the integration of National Grid data into Parish Online, noting that while detailed substation and transmission line information is available from the National Grid's website, Parish Online currently only displays major overhead transmission routes. Andrew shared his experience of using this data for a large-scale electric vehicle charging station development, highlighting the importance of accurate substation location information. Stuart confirmed that Parish Online can upload shapefiles, though the group expressed surprise that this valuable data isn't already being incorporated into the system.

XMAP Upload File Name Issue

Graham attempted to upload shape files into XMAP but encountered syntax errors due to file name length exceeding 6 characters. He planned to shorten the file names and retry the upload. The conversation ended with participants agreeing to end early, with no other significant discussions or decisions made.

---

Chat:

00:20:00 Stuart Bacon: the layers are a large dataset and there needs some work to be able to deliver that in a Public map at present.

Sorry to be vague, it is on the development list.

00:20:30 Stuart Bacon: That's the response I got from Parish Online about he EPC data not showing in public maps last week.

00:34:38 Stuart Bacon: https://en.wikipedia.org/wiki/MacOS_version_history

00:36:43 Stuart Bacon: https://www.bumblebeeconservation.org/learn-about-bumblebees/species-guide/shrill-carder-bee/

00:37:22 Stuart Bacon: https://www.facebook.com/ourlivinglevels/videos/one-of-the-few-locations-to-spot-the-rare-shrill-carder-bee-in-the-uk-is-along-t/1099432288321168/

00:42:22 Stuart Bacon: https://www.lgbce.org.uk/changing-parish-boundaries

00:45:56 Stuart Bacon: Can Parish Online upload these shape files?

00:45:58 Stuart Bacon: https://www.nationalgrid.com/electricity-transmission/network-and-infrastructure/network-route-maps

00:48:20 Andrew Clegg: https://commercial.nationalgrid.co.uk/network-opportunity-map-application?mapid=secondaryCapacityMap

---

Audio-transcript:

WEBVTT

1 00:00:10.580 --> 00:00:11.910 Graham Stoddart-Stones: Let me see another guy.

2 00:00:22.820 --> 00:00:23.770 Graham Stoddart-Stones: You can go.

3 00:00:24.090 --> 00:00:26.930 Graham Stoddart-Stones: John Christine from Bali.

4 00:00:27.580 --> 00:00:28.740 Graham Stoddart-Stones: David?

5 00:00:32.740 --> 00:00:35.060 Graham Stoddart-Stones: James from Botley and David, okay.

6 00:01:08.250 --> 00:01:10.290 Graham Stoddart-Stones: Welcome back, sir!

7 00:01:10.900 --> 00:01:11.950 john Roberts: Hello, Graham.

8 00:01:11.950 --> 00:01:13.459 Graham Stoddart-Stones: Very nice to see you!

9 00:01:13.820 --> 00:01:14.550 john Roberts: And you?

10 00:01:15.120 --> 00:01:18.420 Graham Stoddart-Stones: Are you… Missing the sunshine already?

11 00:01:19.060 --> 00:01:20.170 john Roberts: Yep.

12 00:01:20.520 --> 00:01:23.659 john Roberts: Yeah, especially today, it's a bit cold today.

13 00:01:25.360 --> 00:01:26.620 Graham Stoddart-Stones: in comparison.

14 00:01:27.000 --> 00:01:27.680 john Roberts: Yep.

15 00:01:27.680 --> 00:01:32.609 Graham Stoddart-Stones: Because actually, we're all thinking how mild it is this winter, or summer, or autumn, whatever we are in.

16 00:01:33.190 --> 00:01:41.740 john Roberts: Well, let's wait and see what we get. I was back a couple of weeks ago, but we had the, SALT conference last Friday, so I was at that all day.

17 00:01:42.020 --> 00:01:42.850 Graham Stoddart-Stones: Okay.

18 00:01:43.020 --> 00:01:44.159 Graham Stoddart-Stones: Was it fun?

19 00:01:45.200 --> 00:01:48.619 john Roberts: It was a better… far better conference than we had last year.

20 00:01:50.810 --> 00:01:51.500 Graham Stoddart-Stones: Particularly.

21 00:01:51.500 --> 00:01:52.560 john Roberts: It's worthwhile.

22 00:01:54.880 --> 00:01:57.269 Graham Stoddart-Stones: Any particular reason for it being better this year?

23 00:01:58.430 --> 00:02:02.140 john Roberts: Yeah, Salk organise it themselves, rather than letting Somerset Council do it.

24 00:02:04.450 --> 00:02:04.980 Graham Stoddart-Stones: Bye.

25 00:02:04.980 --> 00:02:10.740 john Roberts: Well, basically last year, it got flooded with Somerset Council people.

26 00:02:11.660 --> 00:02:14.809 john Roberts: This year, it was only those that were invited.

27 00:02:15.990 --> 00:02:16.570 Graham Stoddart-Stones: Right.

28 00:02:17.840 --> 00:02:22.969 john Roberts: So, it was… it was much more focused on SALP and issues that we need to talk about.

29 00:02:23.310 --> 00:02:24.090 Graham Stoddart-Stones: Alright.

30 00:02:24.840 --> 00:02:27.239 Graham Stoddart-Stones: Good afternoon, everybody. Stuart.

31 00:02:27.460 --> 00:02:29.559 Graham Stoddart-Stones: Retired clerk. Chris.

32 00:02:29.560 --> 00:02:30.470 chris edwards: Hello.

33 00:02:31.740 --> 00:02:34.350 Graham Stoddart-Stones: You have a name, Richard, but who knows what it could be.

34 00:02:35.190 --> 00:02:36.760 Retired Clerk: Richard.

35 00:02:36.760 --> 00:02:38.289 john Roberts: Well, Richard might be a clue.

36 00:02:38.290 --> 00:02:39.290 Retired Clerk: Hang on.

37 00:02:39.620 --> 00:02:42.600 Retired Clerk: Who said that? There's somebody in camouflage, can't see him.

38 00:02:42.600 --> 00:02:44.560 Graham Stoddart-Stones: Yes, exactly.

39 00:02:44.560 --> 00:02:45.240 chris edwards: Yep.

40 00:02:45.240 --> 00:02:48.620 Graham Stoddart-Stones: He merges in well with the woodland behind him.

41 00:02:53.750 --> 00:03:02.829 Graham Stoddart-Stones: Well, I have got extra people have signed up for today, so it's possible we'll get some questions, but I do know that we have an update from Chris.

42 00:03:03.450 --> 00:03:05.329 Graham Stoddart-Stones: At some point.

43 00:03:05.330 --> 00:03:11.520 chris edwards: Yeah, okay, you remember last week, I was asking you about, public rights of way.

44 00:03:11.680 --> 00:03:14.310 Graham Stoddart-Stones: And I had a project on to list.

45 00:03:14.310 --> 00:03:15.410 chris edwards: gates,

46 00:03:15.410 --> 00:03:16.949 Graham Stoddart-Stones: All the styles and everything else.

47 00:03:16.950 --> 00:03:18.219 chris edwards: Styles, yes.

48 00:03:18.430 --> 00:03:21.020 chris edwards: So, just to show you what I've been up to.

49 00:03:21.020 --> 00:03:22.789 Graham Stoddart-Stones: Look, they're all there!

50 00:03:22.790 --> 00:03:37.260 chris edwards: First of all, on the left-hand side, I just had one item for styles, gates, and signposts. Then I realized that I wouldn't be able to distinguish between what was a gate, what was a style, and so on.

51 00:03:37.560 --> 00:03:43.810 chris edwards: So, what I've done, as you can see, I've made 3… layers.

52 00:03:44.530 --> 00:03:46.940 chris edwards: Oh, why hasn't that come up?

53 00:03:47.130 --> 00:03:57.560 chris edwards: There we are. So, most of these are styles. Some are in a very poor state. So, for instance, we're gonna get hold of the

54 00:03:58.140 --> 00:04:07.230 chris edwards: Somerset Council, officer out to do a recce with me, and I think one of these…

55 00:04:07.660 --> 00:04:13.100 chris edwards: one of these… That one there, I think.

56 00:04:13.330 --> 00:04:15.710 chris edwards: if I… if I remember correctly.

57 00:04:20.110 --> 00:04:20.860 Graham Stoddart-Stones: Nobody's the best.

58 00:04:21.010 --> 00:04:34.289 chris edwards: one of the steps here, so it's very difficult for OAPs to go through this style. Yeah. So we… we need a kissing gate here, and that's what I want to try and get hold of this chap for.

59 00:04:34.290 --> 00:04:41.060 chris edwards: for him to agree to change it from a style to a kissing gait. Anyway, that's just one example.

60 00:04:43.480 --> 00:04:51.559 chris edwards: we… I spoke… I asked about labeling, and I think Graham or Stuart said I could… I could put

61 00:04:51.850 --> 00:04:55.989 chris edwards: the coordinates here, instead of just a number.

62 00:04:56.100 --> 00:04:59.400 chris edwards: Well, it's such a fiddly thing that,

63 00:05:00.040 --> 00:05:04.990 chris edwards: I've… I've got the… each… each of these, icons.

64 00:05:05.280 --> 00:05:17.380 chris edwards: if you… if you click on it, here's the ID number, I've got the coordinates there, so I'm going to leave it at that, but I'll still leave the number 1, number 2, number 3 here.

65 00:05:17.700 --> 00:05:20.880 chris edwards: Until such time, I'll get rid of it.

66 00:05:21.330 --> 00:05:23.979 chris edwards: There was a question I was going to ask.

67 00:05:24.870 --> 00:05:35.689 chris edwards: These three styles here are no longer there because this green field is now a housing estate.

68 00:05:35.830 --> 00:05:39.210 chris edwards: So, they've been, obviously, removed by the builder.

69 00:05:39.400 --> 00:05:50.290 chris edwards: I don't suppose I could sort of, Do… do a different… icon.

70 00:05:50.450 --> 00:05:53.549 chris edwards: To say that these no longer apply.

71 00:05:53.550 --> 00:05:54.610 Graham Stoddart-Stones: Pushkaid.

72 00:05:54.890 --> 00:06:00.200 chris edwards: Yeah, so I, I should, I shall do that. Yeah. Was it somebody else gonna chip in?

73 00:06:00.470 --> 00:06:03.520 Graham Stoddart-Stones: I have a question or two for you, Chris.

74 00:06:03.520 --> 00:06:04.060 chris edwards: Yeah.

75 00:06:04.160 --> 00:06:13.029 Graham Stoddart-Stones: So… I don't think it was actually necessary to have 3 separate layers. If you put… a field in…

76 00:06:13.380 --> 00:06:17.900 Graham Stoddart-Stones: any of the layers, call it, say, status, or something like that.

77 00:06:17.900 --> 00:06:18.429 Stuart Bacon: Oh, he…

78 00:06:18.430 --> 00:06:24.780 Graham Stoddart-Stones: And then you could have a different status for the different types of gates, or styles, or whatever they are, and you can…

79 00:06:24.780 --> 00:06:25.569 Stuart Bacon: Click on style.

80 00:06:25.570 --> 00:06:35.879 Graham Stoddart-Stones: you'll be able to style each one according to whatever color or shape you want. And by the same token, if one of your statuses was no longer there.

81 00:06:36.060 --> 00:06:39.990 Graham Stoddart-Stones: Then that would also work for those 3 that you've asked about removing.

82 00:06:40.460 --> 00:06:45.140 chris edwards: Are you talking about me adding the word status here, somewhere?

83 00:06:45.140 --> 00:06:47.630 Graham Stoddart-Stones: Well, as a field, so, yeah.

84 00:06:47.630 --> 00:06:48.560 Stuart Bacon: Yeah, so…

85 00:06:49.170 --> 00:06:52.419 chris edwards: Yeah, obviously, I know, I know what to do. I won't go through that.

86 00:06:52.550 --> 00:06:55.710 chris edwards: go into admin, include stable.

87 00:06:55.710 --> 00:07:01.929 Graham Stoddart-Stones: It's worth doing it because of the people who might be watching this video later, and they want to see how it's done.

88 00:07:01.930 --> 00:07:04.799 chris edwards: Okay, so… style.

89 00:07:10.110 --> 00:07:11.120 chris edwards: Go on.

90 00:07:11.290 --> 00:07:13.990 Graham Stoddart-Stones: Be a bit more determined in your selection, there you go.

91 00:07:21.000 --> 00:07:22.839 Graham Stoddart-Stones: So, you're saying status.

92 00:07:23.840 --> 00:07:26.160 Graham Stoddart-Stones: And you can just leave it as a text field.

93 00:07:26.390 --> 00:07:27.260 chris edwards: Okay.

94 00:07:27.260 --> 00:07:28.150 Graham Stoddart-Stones: And save that.

95 00:07:28.150 --> 00:07:29.460 Stuart Bacon: Click on Add.

96 00:07:29.950 --> 00:07:33.190 Graham Stoddart-Stones: Mmm… well, yes, that's good, that's not a bad idea, good.

97 00:07:33.610 --> 00:07:40.319 Graham Stoddart-Stones: So you could put in style, you could put in kissing Gate, you could put in no longer in use, or…

98 00:07:41.010 --> 00:07:43.979 Graham Stoddart-Stones: And, one of them is through a bridge, wasn't it?

99 00:07:44.190 --> 00:07:45.199 chris edwards: Yeah, that's right.

100 00:07:45.200 --> 00:07:47.040 Graham Stoddart-Stones: Well, so put each of those in.

101 00:07:51.440 --> 00:07:52.230 Graham Stoddart-Stones: Yup.

102 00:07:56.130 --> 00:08:00.139 Graham Stoddart-Stones: And you had 3 choices, so what was the other third one for?

103 00:08:00.750 --> 00:08:01.549 chris edwards: Hang on.

104 00:08:03.590 --> 00:08:06.380 chris edwards: Oh, blimey, I've forgotten, forgotten now.

105 00:08:09.240 --> 00:08:10.579 Stuart Bacon: Click on the three items.

106 00:08:10.580 --> 00:08:14.379 chris edwards: Yeah, hang on, I'm gonna get rid of everybody's photographs.

107 00:08:17.610 --> 00:08:19.770 Graham Stoddart-Stones: Yes, we're in the way again.

108 00:08:20.030 --> 00:08:20.590 chris edwards: Yep.

109 00:08:20.590 --> 00:08:21.280 Graham Stoddart-Stones: Yep.

110 00:08:23.430 --> 00:08:27.880 Graham Stoddart-Stones: Changes. Oh, signpost replacement, okay. That was your fourth… your fifth one.

111 00:08:27.880 --> 00:08:28.860 chris edwards: Yeah.

112 00:08:28.860 --> 00:08:33.860 Graham Stoddart-Stones: So if you go back to the first one, whichever the changes are, the one you're doing, yeah, that one.

113 00:08:34.559 --> 00:08:35.949 Stuart Bacon: Click on the pencil.

114 00:08:39.860 --> 00:08:41.530 Graham Stoddart-Stones: And go into Status.

115 00:08:43.590 --> 00:08:46.259 Graham Stoddart-Stones: Yep, and now into 3 items.

116 00:08:47.870 --> 00:08:49.259 chris edwards: Oh, wait a minute…

117 00:08:49.260 --> 00:08:53.830 Graham Stoddart-Stones: Yeah, yes, just click on the three, the three items, you should be able to… the pencil.

118 00:08:53.940 --> 00:08:56.970 Graham Stoddart-Stones: There you go. And add,

119 00:08:57.370 --> 00:09:00.639 Graham Stoddart-Stones: Same post repair, wasn't it? Or same post, something like that.

120 00:09:03.910 --> 00:09:08.570 chris edwards: Yeah, the finger element is okay, but it's the…

121 00:09:09.320 --> 00:09:14.430 chris edwards: shaft, or whatever you call it, the post itself, which is.

122 00:09:14.430 --> 00:09:17.730 Stuart Bacon: I want style as well on that, Chris, for you, can I help?

123 00:09:17.730 --> 00:09:18.060 Graham Stoddart-Stones: Yeah.

124 00:09:18.060 --> 00:09:20.890 chris edwards: Sorry, say that again, please, Stuart?

125 00:09:21.550 --> 00:09:24.059 Stuart Bacon: You want style as an option.

126 00:09:26.920 --> 00:09:28.360 Stuart Bacon: STI, Ali.

127 00:09:29.240 --> 00:09:30.050 Stuart Bacon: Isn't it?

128 00:09:36.510 --> 00:09:37.190 Graham Stoddart-Stones: Good.

129 00:09:46.930 --> 00:09:48.210 chris edwards: Back to maps.

130 00:09:48.600 --> 00:09:49.220 Graham Stoddart-Stones: Yup.

131 00:09:59.270 --> 00:10:00.909 chris edwards: So, just click on there.

132 00:10:01.150 --> 00:10:01.800 Stuart Bacon: Nope.

133 00:10:03.360 --> 00:10:04.479 chris edwards: Let's get real good.

134 00:10:05.080 --> 00:10:09.270 chris edwards: So… Oh, I thought…

135 00:10:09.270 --> 00:10:12.199 Graham Stoddart-Stones: You need to be in edit mode, and click on your pencil.

136 00:10:12.790 --> 00:10:17.809 Graham Stoddart-Stones: Yeah, go down and change the style field, that's it. Status field, sorry, status field.

137 00:10:19.340 --> 00:10:20.309 Graham Stoddart-Stones: And isn't that.

138 00:10:20.310 --> 00:10:22.600 chris edwards: Oh, no, no, no, sorry, I'm sorry, what am I doing?

139 00:10:22.600 --> 00:10:27.250 Graham Stoddart-Stones: It's no longer in… is that the one that's no longer in… No longer on site, that's right, that's right, that's right.

140 00:10:28.880 --> 00:10:30.639 chris edwards: And could I, could I…

141 00:10:31.020 --> 00:10:36.420 Graham Stoddart-Stones: Or if you now go into… go into the layer and style it, So…

142 00:10:36.420 --> 00:10:37.070 chris edwards: Okay, okay.

143 00:10:37.070 --> 00:10:38.639 Graham Stoddart-Stones: Close your left column, yep.

144 00:10:39.290 --> 00:10:40.780 Graham Stoddart-Stones: Style the lair.

145 00:10:43.060 --> 00:10:47.200 Graham Stoddart-Stones: Brilliant. And then, oops, hang on a second, change your left-hand column.

146 00:10:47.560 --> 00:10:48.280 Graham Stoddart-Stones: to…

147 00:10:48.280 --> 00:10:49.050 chris edwards: I go back.

148 00:10:49.050 --> 00:10:51.829 Graham Stoddart-Stones: Yeah, we'll just go left-hand column, where it says Style Options.

149 00:10:51.830 --> 00:10:52.700 Stuart Bacon: go down.

150 00:10:53.020 --> 00:10:53.570 Graham Stoddart-Stones: Yeah.

151 00:10:53.720 --> 00:10:55.369 chris edwards: Let's get rid of this, first of all.

152 00:10:55.370 --> 00:10:56.170 Graham Stoddart-Stones: Okay, absolutely.

153 00:10:56.170 --> 00:10:56.720 Stuart Bacon: What?

154 00:10:56.720 --> 00:11:00.130 Graham Stoddart-Stones: Yeah. Go into style options, change it to class-based.

155 00:11:02.780 --> 00:11:06.500 Graham Stoddart-Stones: And change the class column to Status.

156 00:11:07.930 --> 00:11:09.020 Graham Stoddart-Stones: Next one up.

157 00:11:09.540 --> 00:11:10.330 Graham Stoddart-Stones: Yep.

158 00:11:14.170 --> 00:11:15.100 Graham Stoddart-Stones: Perfect.

159 00:11:15.330 --> 00:11:17.049 Graham Stoddart-Stones: Good. Save that.

160 00:11:19.320 --> 00:11:20.900 chris edwards: I have used this before, but…

161 00:11:20.900 --> 00:11:26.360 Graham Stoddart-Stones: You need to go back… I'm sorry, you need to go back into style, I beg your pardon, Chris.

162 00:11:26.810 --> 00:11:29.170 Graham Stoddart-Stones: We've actually got to select the style you want.

163 00:11:30.040 --> 00:11:33.790 Graham Stoddart-Stones: So, very confusing to have two words spelt the wrong way, but…

164 00:11:33.930 --> 00:11:36.400 chris edwards: If you go scroll down.

165 00:11:36.740 --> 00:11:44.259 Graham Stoddart-Stones: To get the other two columns, yep. So now, under Style, yep, go into Change the Shapes to Icon.

166 00:11:46.020 --> 00:11:48.620 Graham Stoddart-Stones: Yep, and choose whichever icon you want.

167 00:11:50.280 --> 00:11:55.039 Graham Stoddart-Stones: If it's no longer in use, you might want, sort of, a no-entry sign or something, I don't know.

168 00:11:55.300 --> 00:11:56.860 chris edwards: That's a good one.

169 00:12:00.690 --> 00:12:01.310 Stuart Bacon: Nope.

170 00:12:02.040 --> 00:12:04.470 Graham Stoddart-Stones: That's not gonna work.

171 00:12:04.470 --> 00:12:04.820 chris edwards: out of that.

172 00:12:04.820 --> 00:12:06.010 Graham Stoddart-Stones: Stop, maybe?

173 00:12:07.180 --> 00:12:08.170 Graham Stoddart-Stones: yield?

174 00:12:09.860 --> 00:12:15.110 Graham Stoddart-Stones: There was one that… yeah, there you go, whoops. There's a whole bunch, if you go back to where you were.

175 00:12:16.910 --> 00:12:21.460 Graham Stoddart-Stones: Yeah, they're just… Sorry, they're just regular traffic signs, nothing.

176 00:12:22.230 --> 00:12:23.949 chris edwards: I mean, there are hundreds of these.

177 00:12:23.950 --> 00:12:27.839 Graham Stoddart-Stones: This bottom left one is a stock. Stock when flashing, that's fun.

178 00:12:31.410 --> 00:12:37.090 chris edwards: Let me show you, hmm.

179 00:12:37.090 --> 00:12:42.790 Graham Stoddart-Stones: There are lots of them, aren't there? You could put, gates, and see what sort of you get for gates.

180 00:12:44.190 --> 00:12:45.790 Graham Stoddart-Stones: Or Gate Singular, maybe.

181 00:12:46.610 --> 00:12:47.670 Graham Stoddart-Stones: There you go.

182 00:12:48.790 --> 00:12:49.720 Graham Stoddart-Stones: Shoot, yeah.

183 00:12:49.720 --> 00:12:52.510 chris edwards: I'm gonna use that. I mean, I'll muck around later on.

184 00:12:53.460 --> 00:12:58.380 Graham Stoddart-Stones: Let me get rid of everybody. And then in due course, you want to bring the other two layers

185 00:12:58.530 --> 00:13:03.409 Graham Stoddart-Stones: Into that, the same one, so you've only got one layer now, rather than three.

186 00:13:03.410 --> 00:13:07.150 chris edwards: Yeah, yeah, got it. Okay, yeah, I'll do that at my leisure.

187 00:13:07.150 --> 00:13:11.290 Graham Stoddart-Stones: I should take a moment… I'm just going to take a moment to say hello to David. Welcome.

188 00:13:13.650 --> 00:13:15.020 David Morgan-Jones: Offering figs?

189 00:13:15.490 --> 00:13:16.300 chris edwards: Hello?

190 00:13:16.930 --> 00:13:17.510 Stuart Bacon: Afternoon.

191 00:13:17.510 --> 00:13:21.930 chris edwards: Right. I think we've done that, so thanks, folks, for your input.

192 00:13:22.180 --> 00:13:24.419 chris edwards: I shall now stop sharing.

193 00:13:24.680 --> 00:13:31.990 Graham Stoddart-Stones: I have a bit of an update news for you. So, last week, we had a guy on called Peter Lewis, I think?

194 00:13:32.420 --> 00:13:33.250 Graham Stoddart-Stones: Yup.

195 00:13:33.590 --> 00:13:37.320 Graham Stoddart-Stones: From some weird place down in some weird part of the country.

196 00:13:37.500 --> 00:13:47.260 Graham Stoddart-Stones: And he was having errors with the address space, which was reflecting, an address on his garage that was all wrong.

197 00:13:47.680 --> 00:13:52.169 Graham Stoddart-Stones: So, he wrote off to Somerset Council

198 00:13:52.460 --> 00:14:03.260 Graham Stoddart-Stones: And said, it's all wrong, how do I get a change made? And they replied within a day or so, and said, tell us what change you want, and he showed it to them on Parish Online, and they changed it, so it's all.

199 00:14:03.260 --> 00:14:03.990 chris edwards: Wow.

200 00:14:04.350 --> 00:14:09.510 Graham Stoddart-Stones: So, Somerset Council is clearly Rejuvenated.

201 00:14:10.590 --> 00:14:13.719 Graham Stoddart-Stones: It's working… it believes in service for a change.

202 00:14:14.950 --> 00:14:21.920 Graham Stoddart-Stones: Anyway… So, we've had one question from Chris, David. So, did you come with anything in mind?

203 00:14:23.280 --> 00:14:25.490 David Morgan-Jones: No, but I thought I'd give some feedback.

204 00:14:25.940 --> 00:14:26.350 Graham Stoddart-Stones: Okay.

205 00:14:26.350 --> 00:14:30.719 David Morgan-Jones: on the question that I posed, last week about EPCs.

206 00:14:31.130 --> 00:14:36.869 David Morgan-Jones: If you remember, the issue that I wanted to try and resolve was to…

207 00:14:38.060 --> 00:14:41.379 David Morgan-Jones: Show the number of houses.

208 00:14:41.380 --> 00:14:42.130 Graham Stoddart-Stones: heaven.

209 00:14:42.130 --> 00:14:47.359 David Morgan-Jones: That did not have them, or were in the bracket to be changed.

210 00:14:47.710 --> 00:14:55.839 David Morgan-Jones: So there are a number of issues… there are a number of issues that fell out of that. One, houses with no EPC are not actually indicated on the map.

211 00:14:56.070 --> 00:15:04.540 David Morgan-Jones: And that actually is actually really very useful, because it's… you then know where the property is that you need to go and, go and visit.

212 00:15:04.540 --> 00:15:05.300 Graham Stoddart-Stones: Yep.

213 00:15:05.300 --> 00:15:14.549 David Morgan-Jones: And the other bit issue was that, we spent quite a lot of very clever time trying to, bring those through to the public map.

214 00:15:14.760 --> 00:15:22.320 David Morgan-Jones: Yeah. And I wrote a thing to the help desk, who basically said, it's on the list.

215 00:15:23.120 --> 00:15:29.259 David Morgan-Jones: How astonishing! So it's on the list. Anyway,

216 00:15:29.400 --> 00:15:38.509 David Morgan-Jones: I thought I'd give you a little bit of, sort of an update in terms of the workarounds that both, Graham and, Tristram, suggested.

217 00:15:38.750 --> 00:15:48.290 David Morgan-Jones: So, I downloaded the, the address base from, Parish Online, as you showed me how to.

218 00:15:48.940 --> 00:15:56.530 David Morgan-Jones: And I also got the component from Hart District Council from the EPC web, from the government website.

219 00:15:56.530 --> 00:15:56.960 Graham Stoddart-Stones: Nope.

220 00:15:56.960 --> 00:16:01.629 David Morgan-Jones: And then I linked the two together, the two spreadsheets together.

221 00:16:01.860 --> 00:16:09.740 David Morgan-Jones: And now I have a consolidated list of all the properties with their EPCs.

222 00:16:11.120 --> 00:16:14.700 David Morgan-Jones: And so I've now got,

223 00:16:15.270 --> 00:16:18.719 David Morgan-Jones: totals A through to F, and no data.

224 00:16:20.050 --> 00:16:24.239 David Morgan-Jones: And out of a total of 516 properties.

225 00:16:24.450 --> 00:16:31.480 David Morgan-Jones: I have 208 that either have no data, or in the bands E to F.

226 00:16:32.520 --> 00:16:36.790 David Morgan-Jones: I.e. 40% of our parish.

227 00:16:38.650 --> 00:16:39.879 Graham Stoddart-Stones: And no stickers.

228 00:16:40.260 --> 00:16:47.090 David Morgan-Jones: Yeah, so, I worked out, if it was £50 per EPC,

229 00:16:47.470 --> 00:16:57.199 David Morgan-Jones: To, get that done. That just came in under over 10,000 pounds, just to get the EPCs done.

230 00:16:57.350 --> 00:17:09.930 David Morgan-Jones: So, we're gonna have to think of a slightly different way of getting the data we want, because it's the… it's basically what we want, is to identify the data on the houses.

231 00:17:10.040 --> 00:17:13.180 David Morgan-Jones: That will allow us to engage in the retrofit process.

232 00:17:13.970 --> 00:17:18.589 David Morgan-Jones: And the EPCs are great, but they're… they're far too detailed.

233 00:17:19.290 --> 00:17:30.979 David Morgan-Jones: just to get that bit of information. So we need to come up with a slightly different way of doing it. But, so that's a… I just thought I'd just share the, sort of, a real life trying to,

234 00:17:31.480 --> 00:17:41.330 David Morgan-Jones: get working data to actually make major changes. And it's a bit of a shame that we can't get the data shown on the,

235 00:17:42.230 --> 00:17:53.919 David Morgan-Jones: on the public mapping, because I think one of the biggest things that we need to do is just to show, to everybody what the shape of the housing stock is like.

236 00:17:54.370 --> 00:17:55.319 David Morgan-Jones: In terms of…

237 00:17:55.320 --> 00:18:02.369 Graham Stoddart-Stones: Do you remember, Graeme, that we couldn't get the EPC, the actual EPC data.

238 00:18:02.500 --> 00:18:04.320 David Morgan-Jones: Through to the public mapping.

239 00:18:04.630 --> 00:18:05.300 David Morgan-Jones: Well… Component.

240 00:18:05.300 --> 00:18:10.600 Graham Stoddart-Stones: I do remember that in terms of the parish online data.

241 00:18:11.090 --> 00:18:17.149 Graham Stoddart-Stones: But you've now got the information from your heart division, so they've got their data.

242 00:18:17.790 --> 00:18:18.670 Graham Stoddart-Stones: So…

243 00:18:19.350 --> 00:18:33.480 Graham Stoddart-Stones: What I have a suggestion is that you send your file, your spreadsheet, to the help desk, and ask them to upload it for you into a parish layer, where you've got full control of it, and then you can do everything with it, including sending it through to a public map.

244 00:18:34.830 --> 00:18:45.739 David Morgan-Jones: Oh, really? I hadn't realised you could do that. Alright, okay. Well, you've got full control over anything that's in the parish lair, and you have no control over anything that isn't. So…

245 00:18:45.750 --> 00:18:58.000 Graham Stoddart-Stones: it makes sense to just… and there is a facility for duplicating information, but because your information, half of it isn't in Paris Online at the moment, you just need to ask them to import it for you into a parish layer.

246 00:18:58.400 --> 00:19:02.570 Graham Stoddart-Stones: Which they will usually gladly do, because it only takes them a second or two.

247 00:19:03.350 --> 00:19:06.490 David Morgan-Jones: Right, okay, so, I'll get on…

248 00:19:06.490 --> 00:19:14.500 Graham Stoddart-Stones: You also have the beauty there, that you could update it whenever you feel like it, as information trickles down from the District Council, or from HART Division, isn't it?

249 00:19:17.640 --> 00:19:21.300 Graham Stoddart-Stones: Because one of the issues with these things is that they're constantly getting out of date.

250 00:19:22.190 --> 00:19:25.350 David Morgan-Jones: Yes. It's more…

251 00:19:25.350 --> 00:19:33.739 Graham Stoddart-Stones: online in particular is often nearly a year out of date, because they only update once a year, although I did… I think they were talking about doing it more frequently, but…

252 00:19:34.100 --> 00:19:49.670 Graham Stoddart-Stones: They spend a lot of time working on the data to get those five layers that you look at in APCs, so they don't do it very often, they only do it once or twice a year, so your information is almost always out of date.

253 00:19:49.670 --> 00:19:50.559 David Morgan-Jones: Yeah, yeah, no, no.

254 00:19:50.560 --> 00:19:56.529 Graham Stoddart-Stones: If you get it as soon as the government has it available and download it, then you can update your little bit straight away.

255 00:19:57.660 --> 00:20:04.720 David Morgan-Jones: No, absolutely. No, I… right, now that's giving me all sorts of different, routes to explore.

256 00:20:05.010 --> 00:20:09.390 Graham Stoddart-Stones: Yeah. Because I think the key thing, I don't know about what the rest of the guys think, but…

257 00:20:09.390 --> 00:20:16.710 David Morgan-Jones: One of the key things is about getting information out to everybody. So… and everybody's quite curious about how they compare to everybody else.

258 00:20:16.710 --> 00:20:17.800 Graham Stoddart-Stones: Of course.

259 00:20:17.800 --> 00:20:24.260 David Morgan-Jones: And, so, if we can get this out, And being talked about.

260 00:20:24.720 --> 00:20:32.600 David Morgan-Jones: Then at least… The public becomes much more susceptible to suggesting that they need to try and,

261 00:20:32.760 --> 00:20:39.760 David Morgan-Jones: improve the scores on the doors, or to actually get an EPC, so they know where they stand.

262 00:20:41.450 --> 00:20:44.340 Graham Stoddart-Stones: Right, so that's the answer from Stuart, thank you, yeah.

263 00:20:44.340 --> 00:20:47.149 David Morgan-Jones: Sorry, Stuart, let me grab that. I'll just catch that.

264 00:20:47.700 --> 00:20:53.980 Graham Stoddart-Stones: Well, you work around that if you get them to import your data for you into a parish layer.

265 00:20:54.700 --> 00:20:56.220 Graham Stoddart-Stones: Which they will do.

266 00:20:58.130 --> 00:20:59.100 David Morgan-Jones: Cool, okay.

267 00:20:59.100 --> 00:21:03.859 Graham Stoddart-Stones: Don't mention that I told you, otherwise I won't.

268 00:21:05.370 --> 00:21:08.099 David Morgan-Jones: Alright, that's… that's me done. Thank you very much, Graham.

269 00:21:08.650 --> 00:21:17.689 Graham Stoddart-Stones: Well, you're very welcome. I do have some other news, which is probably of most interest to Andrew, who isn't here today, but,

270 00:21:17.990 --> 00:21:33.379 Graham Stoddart-Stones: I do quite a lot of work with XMAP, and XMAP has the big advantage that you can upload your own files of data to it. So I had a wonderful, result of a survey that, we did in East Anglia back in the summer.

271 00:21:33.530 --> 00:21:35.280 Graham Stoddart-Stones: And,

272 00:21:35.430 --> 00:21:40.569 Graham Stoddart-Stones: there's some funny stories to tell about that using AI, which I'll get to in a second, but…

273 00:21:40.820 --> 00:21:42.840 Graham Stoddart-Stones: Basically.

274 00:21:42.950 --> 00:21:51.649 Graham Stoddart-Stones: I thought, rather than upload this fairly large file of data straight into XMAP, I'll just do a test map on 4 rows of data first.

275 00:21:51.930 --> 00:21:53.339 Graham Stoddart-Stones: To make sure it works.

276 00:21:53.630 --> 00:21:57.529 Graham Stoddart-Stones: And it didn't, it came back with a syntax error.

277 00:21:57.630 --> 00:22:02.379 Graham Stoddart-Stones: Which is a really useless thing to say, because it doesn't tell you what the error is.

278 00:22:02.550 --> 00:22:06.229 Graham Stoddart-Stones: So I sent it off to the help desk and said, can you explain this?

279 00:22:06.520 --> 00:22:08.949 Graham Stoddart-Stones: And they came back and said…

280 00:22:09.570 --> 00:22:16.129 Graham Stoddart-Stones: We're not really sure, I think I mentioned last week that we can't quite put our finger on what the problem is.

281 00:22:16.400 --> 00:22:31.460 Graham Stoddart-Stones: So that's how it was last Friday, and then they came back and said, one of the issues is the length of the name that you've chosen for the file. Could you please release it to, or reduce it to 6 letters or less?

282 00:22:31.650 --> 00:22:42.559 Graham Stoddart-Stones: They said, once you've uploaded it, you can change the name of that layer to anything you like, but the file for uploading has got to be 6 letters, which is brand new to me. So I did that, and it failed again.

283 00:22:42.810 --> 00:22:48.629 Graham Stoddart-Stones: And then they came back and said, although the numbers you've got in your spreadsheet

284 00:22:48.790 --> 00:22:59.410 Graham Stoddart-Stones: are ostensibly correct, they're in the wrong format, so you need to change them to something called BNG for British National Grid 27700.

285 00:22:59.800 --> 00:23:09.280 Graham Stoddart-Stones: So if you send me the data, I'll do it. And I thought, well, I'm going to be doing a lot of this, so I better get the way to do it sorted out first. So I went to Claude.

286 00:23:09.540 --> 00:23:12.770 Graham Stoddart-Stones: Which is a lesser-known AI bot.

287 00:23:13.060 --> 00:23:27.969 Graham Stoddart-Stones: And asked Claude, if I give you, a whole bunch of numbers, could you convert them to BGN2700 or 27700? And he said, oh, absolutely. I don't know if you use Claude, but he's much more polite and enthusiastic than Chad GPT is.

288 00:23:28.220 --> 00:23:32.680 Graham Stoddart-Stones: So, I sent it to Claude, he came back and said, I've renamed

289 00:23:32.860 --> 00:23:48.509 Graham Stoddart-Stones: two new columns in your spreadsheet, and one is called BNG Latitude, and the other is called BNG Longitude, which I thought was very promising, because he was now saying this is British National Grid format. So I sent off my test file again, and it came out with exactly the same error.

290 00:23:48.900 --> 00:23:56.520 Graham Stoddart-Stones: So I sent again to the help desk, can you explain this? And they came back and said, no, but we're working on it.

291 00:23:56.890 --> 00:23:58.750 Graham Stoddart-Stones: So,

292 00:23:58.870 --> 00:24:14.740 Graham Stoddart-Stones: Then I thought to Claude, I said, the information that I downloaded from the survey that we took of 80 or 90 parishes in East Anglia is not very conveniently laid out for Parish Online, because I want it to be in

293 00:24:14.950 --> 00:24:23.469 Graham Stoddart-Stones: a completely different format. So I started doing it by hand, and I thought, this is ridiculous, the whole point of Claude is that he'll do this for you.

294 00:24:23.780 --> 00:24:31.340 Graham Stoddart-Stones: So I sent it to Claude and, said, could you please convert this? I want columns P, Q, R, and S.

295 00:24:31.450 --> 00:24:45.430 Graham Stoddart-Stones: All converted to such and such a format. And he said, I would be delighted to do that for you, so upload your file, and away we go. And the difference between Claude and ChatGPT is that Claude actually shows you what it's doing.

296 00:24:45.600 --> 00:24:52.380 Graham Stoddart-Stones: You get the code flashing past your eyes, which is no use to anybody who doesn't set code, but it's… gives you something to look at.

297 00:24:52.750 --> 00:25:01.319 Graham Stoddart-Stones: And then he said, there's a big download button, click on the download button, and it'll work fine. So I clicked on the download button and said nothing happened.

298 00:25:01.500 --> 00:25:16.349 Graham Stoddart-Stones: So Claude came back and said, you're absolutely right. I need to correct an error, which I'll just do now. I apologize for my mistake. So he changes it, and then says, now try. So I try, same problem. And this reiterates itself for about 20 minutes.

299 00:25:16.850 --> 00:25:29.610 Graham Stoddart-Stones: But finally, we do get to exactly where I wanted to be, so I said, thank you very much, Claude. And then I thought, well, it took Claude 20 minutes to sort it out. I just wonder, out of interest, how long chat GPT will take.

300 00:25:29.750 --> 00:25:37.190 Graham Stoddart-Stones: And ChatGPT came back, exactly the same question, exactly the same data file, and it came back in 3 seconds and said, we're done, download it.

301 00:25:37.480 --> 00:25:43.309 Graham Stoddart-Stones: So I downloaded it, and it was the original file that I'd sent without any changes whatsoever.

302 00:25:43.440 --> 00:25:48.850 Graham Stoddart-Stones: So I complained to ChatGPT and said, no changes, and it came back and said.

303 00:25:49.030 --> 00:25:52.070 Graham Stoddart-Stones: Our mistake, I'll change it for you.

304 00:25:52.520 --> 00:26:07.439 Graham Stoddart-Stones: So, he came back and said, it's all done now, so I downloaded it, and lo and behold, it was exactly what I'd asked for, except that ChatPT had completely mangled two columns of data that weren't involved in this transfer, so…

305 00:26:07.630 --> 00:26:08.909 Graham Stoddart-Stones: the,

306 00:26:09.590 --> 00:26:21.960 Graham Stoddart-Stones: email addresses of people have been changed from their email address to a number, so something like graham at gmail.com had become 11, which I thought was very helpful, and

307 00:26:22.170 --> 00:26:29.190 Graham Stoddart-Stones: There was something else, oh yes, the name of the town that was doing… who supplied the data just disappeared. It was a blank column.

308 00:26:29.320 --> 00:26:40.970 Graham Stoddart-Stones: So I thought that you now have your choices, gentlemen. You can have Claude do it for you, and it may take a while, but you'll get there, or you can have ChatGPT do it, and they'll do what you ask, but they'll mangle everything else in the meantime.

309 00:26:41.680 --> 00:26:45.310 Graham Stoddart-Stones: So, I then went back to Claude and said,

310 00:26:45.800 --> 00:27:01.240 Graham Stoddart-Stones: I asked you to do, you know, P, Q, R, and S, but now I actually don't want S to be done, so could you do P, Q, and R? And Claude said, I'd be delighted to, and there it was, in a split second. So, once he got the hang of what he had to do, he learned from it, which I thought was fun.

311 00:27:02.430 --> 00:27:06.989 Graham Stoddart-Stones: And I'm sure it was very boring, but no one else has raised any topic to talk about, so bad luck.

312 00:27:09.220 --> 00:27:11.750 Stuart Bacon: The pleasures of, AI.

313 00:27:11.750 --> 00:27:20.710 Graham Stoddart-Stones: Yeah, well, it's sort of… it's still in its, very early days, isn't it? But they're getting there. I mean, it did save me hours of work, really.

314 00:27:20.960 --> 00:27:29.290 Graham Stoddart-Stones: And I thought it was quite entertaining, I was quite amused doing this, because Claude is so apologetic, and so thoughtful and kind.

315 00:27:30.010 --> 00:27:32.360 Graham Stoddart-Stones: Which is just nice to meet.

316 00:27:32.640 --> 00:27:34.579 Graham Stoddart-Stones: As customer service.

317 00:27:35.180 --> 00:27:37.370 Graham Stoddart-Stones: They obviously spent a lot of time teaching it.

318 00:27:37.630 --> 00:27:39.239 Graham Stoddart-Stones: From the best examples.

319 00:27:40.430 --> 00:27:44.509 Stuart Bacon: And the timing is terrible, because now here's Andrew to…

320 00:27:44.520 --> 00:27:47.730 Graham Stoddart-Stones: Yeah, so all those stories, he's missed.

321 00:27:47.730 --> 00:27:49.450 Andrew Clegg: We're laughing?

322 00:27:52.320 --> 00:28:00.779 Graham Stoddart-Stones: It is… it is quite, amusing, Andrew, that we've just finished saying, well, this is really of interest to Andrew, but since it's here, I'll tell you lot.

323 00:28:00.780 --> 00:28:03.430 Andrew Clegg: I heard you, I was just driving up from my…

324 00:28:03.600 --> 00:28:07.909 Andrew Clegg: Hardtalk, and I suddenly heard you from the Isle of Wight shouting.

325 00:28:09.940 --> 00:28:16.299 Graham Stoddart-Stones: Well, anyway, so the onus is on you, Andrew, to provide us all with something of fascination and interest.

326 00:28:16.920 --> 00:28:20.340 Graham Stoddart-Stones: to do with Parish Online, hopefully, or Xmap, if not.

327 00:28:21.260 --> 00:28:25.840 Andrew Clegg: No, the… the truth is, I can't remember whether I mentioned this last week.

328 00:28:26.720 --> 00:28:33.790 Andrew Clegg: You know this business is… this nature recovery business that all counties are, sort of working.

329 00:28:33.790 --> 00:28:35.170 Retired Clerk: to do, yeah.

330 00:28:35.170 --> 00:28:38.849 Andrew Clegg: Did I mention it last week, Graham, or was I interrupted by you?

331 00:28:38.850 --> 00:28:45.569 Graham Stoddart-Stones: I'm sure you were interrupted because I don't remember you mentioning it.

332 00:28:45.570 --> 00:28:56.879 Andrew Clegg: Well, what everybody's doing, of course, is producing maps of the county, and they're encouraging us to mark on the maps all the sort of.

333 00:28:57.960 --> 00:29:07.520 Andrew Clegg: Environmental and nature, habitats and important areas that we've got in our parishes.

334 00:29:08.170 --> 00:29:16.229 Andrew Clegg: And the map that they've given us in Somerset is just absolutely hopeless, and you can't… and it's only one way anyway. It's… they're showing us

335 00:29:16.350 --> 00:29:22.930 Andrew Clegg: what they've done, and there's no way in which people from the parishes can contribute to this thing.

336 00:29:23.200 --> 00:29:24.280 Andrew Clegg: I…

337 00:29:24.280 --> 00:29:28.770 Graham Stoddart-Stones: Have you alerted Mr. Roberts to this? Because this sounds like he's right up his street.

338 00:29:29.490 --> 00:29:31.230 Andrew Clegg: Who, who's…

339 00:29:31.230 --> 00:29:35.630 Graham Stoddart-Stones: But you can't see him, because he's dressed in camouflage, and he's.

340 00:29:35.630 --> 00:29:38.149 Andrew Clegg: Oh, I see you all hiding under the stairs, yeah.

341 00:29:40.750 --> 00:29:49.469 Graham Stoddart-Stones: But the sort of liaison that he's built up with Adam seems to be really effective. So maybe you can work with him on it?

342 00:29:49.730 --> 00:30:09.460 Andrew Clegg: Yeah, but what we need is for people to be using the same platform, or at least compatible platforms, and as yet, it seems to me, nowhere near the development of mapping schemes, mapping software like this, which allows us to…

343 00:30:09.460 --> 00:30:13.780 Andrew Clegg: Transfer a layer from one… one bit of software to another.

344 00:30:13.930 --> 00:30:14.440 Andrew Clegg: You know what?

345 00:30:14.440 --> 00:30:29.910 Graham Stoddart-Stones: That's what I was thinking, that John might want to get involved, because I have seen Parish Online do a transfer upwards, so rather than just sucking data from the higher authority, you can actually… they did send some at one point, and it worked.

346 00:30:29.910 --> 00:30:38.560 Andrew Clegg: Yeah. I wonder whether Adam… John, do you feel that Adam would be able to sort of say, we'll give it a try to receive some of your data?

347 00:30:38.750 --> 00:30:43.499 john Roberts: Yeah, I think so, one of the things that came out of the

348 00:30:43.680 --> 00:30:48.320 john Roberts: talk that Chris Mews gave last week at the conference was… the…

349 00:30:48.850 --> 00:30:52.169 john Roberts: solid relationship he's now got with Adam Reimer.

350 00:30:52.470 --> 00:30:53.230 john Roberts: Oh, right!

351 00:30:53.230 --> 00:30:53.880 Andrew Clegg: Oh, that's good.

352 00:30:53.880 --> 00:30:54.330 john Roberts: should…

353 00:30:54.330 --> 00:30:55.100 Graham Stoddart-Stones: Well done, you!

354 00:30:55.100 --> 00:30:55.640 john Roberts: Yay.

355 00:30:55.760 --> 00:30:57.619 john Roberts: To the extent that…

356 00:30:57.760 --> 00:31:09.139 john Roberts: The amount of data that's coming out of Somerset is quite phenomenal at the moment, albeit a lot of it isn't very useful, but they… they are uploading what they've got.

357 00:31:09.260 --> 00:31:10.290 Graham Stoddart-Stones: Huh.

358 00:31:11.850 --> 00:31:17.489 john Roberts: So, yeah, I mean, if Andrew can explain, because I wasn't here last week, so I haven't got a clue what you're talking about, Andrew.

359 00:31:17.780 --> 00:31:37.610 Andrew Clegg: Well, all… we've all been sent, around, all the parishes have been sent something to invite us to comment on their nature recovery strategy, which they just published about 3 weeks ago. So the… you're… are you still… are you the parish clerk, or are you.

360 00:31:38.160 --> 00:31:39.280 john Roberts: Oh, no.

361 00:31:39.280 --> 00:31:42.870 Andrew Clegg: Have you gone the way of all parish clerks?

362 00:31:42.870 --> 00:31:44.439 john Roberts: No, I'm still chairman.

363 00:31:47.590 --> 00:31:48.389 Graham Stoddart-Stones: Oh, it's true.

364 00:31:48.390 --> 00:31:53.509 Andrew Clegg: What does that mean? Golly, there is a lot of data coming out of Somerset now, a lot of it for Sedgemore, by the way.

365 00:31:53.510 --> 00:31:54.710 Retired Clerk: They're just encouraging.

366 00:31:55.190 --> 00:32:01.959 Graham Stoddart-Stones: Yeah. But that is different. They have… you're quite right, they've got improved, you know, large number of layers that they didn't have before.

367 00:32:01.960 --> 00:32:16.290 Andrew Clegg: But they have produced a really surprisingly good nature recovery strategy paper, very readable, easy to follow, and we've been asked to comment. And the big comment for me is, what do we do with it?

368 00:32:16.300 --> 00:32:24.400 Andrew Clegg: You know, if we've got a nice pond, where do we… what do we do… what do we do with it?

369 00:32:24.400 --> 00:32:30.639 john Roberts: Alright, let me look at… let me find what you're talking about first, because I haven't had it, but the clerk may have done.

370 00:32:31.910 --> 00:32:32.680 john Roberts: Or…

371 00:32:32.960 --> 00:32:33.800 Andrew Clegg: I don't know.

372 00:32:34.610 --> 00:32:39.950 Andrew Clegg: Let me see if I can find… I've just updated… I've upgraded my computer to.

373 00:32:40.300 --> 00:32:43.860 Graham Stoddart-Stones: Mac OS 26. Yeah.

374 00:32:43.860 --> 00:32:46.640 Andrew Clegg: And I'm now completely lost.

375 00:32:49.070 --> 00:32:50.989 Andrew Clegg: I'm just trying to find the…

376 00:32:53.530 --> 00:32:58.419 Andrew Clegg: Let's see if I can quickly find the, As usual.

377 00:32:58.740 --> 00:32:59.840 Graham Stoddart-Stones: Twenty-six!

378 00:32:59.840 --> 00:33:00.940 Andrew Clegg: Learns anything.

379 00:33:02.050 --> 00:33:05.340 Andrew Clegg: OS26. You don't know about OS26?

380 00:33:05.340 --> 00:33:07.909 Graham Stoddart-Stones: Well, I'm on a Sequoia 15.6…

381 00:33:07.910 --> 00:33:13.240 Andrew Clegg: Oh, you're 11 behind. It's now…

382 00:33:13.240 --> 00:33:14.330 Graham Stoddart-Stones: That might explain, though.

383 00:33:14.330 --> 00:33:16.060 Andrew Clegg: OS26.

384 00:33:16.060 --> 00:33:19.330 Graham Stoddart-Stones: When did that come out?

385 00:33:19.330 --> 00:33:23.029 Andrew Clegg: 26 is because it's for next year, you know, it's the.

386 00:33:23.030 --> 00:33:23.520 Graham Stoddart-Stones: anecdote.

387 00:33:23.520 --> 00:33:32.210 Andrew Clegg: 26 year, and Mac and iOS and your Mac Watch and everything has been upgraded.

388 00:33:32.810 --> 00:33:37.610 Andrew Clegg: to, OS26. They're all on the same thing now.

389 00:33:38.130 --> 00:33:40.329 john Roberts: Getting back to more mundane matters.

390 00:33:40.330 --> 00:33:40.940 Retired Clerk: We're talking about…

391 00:33:40.940 --> 00:33:43.739 john Roberts: Somerset's local nature recovery strategy.

392 00:33:43.740 --> 00:33:45.229 Andrew Clegg: Yes, I think so.

393 00:33:45.530 --> 00:33:47.000 john Roberts: Right, I've got it on screen now.

394 00:33:47.000 --> 00:33:51.999 Andrew Clegg: Have you got it? Yes, because I've got it somewhere, but I'm not sure where.

395 00:33:53.490 --> 00:33:58.450 Andrew Clegg: It's all very pretty, and nicely laid out, and easily readable, but…

396 00:33:58.660 --> 00:34:02.940 Andrew Clegg: And it's clear… but… but they've…

397 00:34:03.290 --> 00:34:15.780 Andrew Clegg: Telling the parishes what they have to do is just one little paragraph in 56 pages, and they certainly don't provide us with any, any, any,

398 00:34:16.239 --> 00:34:24.650 Andrew Clegg: maps that we can use, except one that we're allowed to… with their map, which we can see. It's a one-way thing, it's not a two-way thing.

399 00:34:26.790 --> 00:34:28.350 john Roberts: Alright, leave that one with me.

400 00:34:28.670 --> 00:34:29.580 Andrew Clegg: Okay.

401 00:34:31.030 --> 00:34:34.300 Andrew Clegg: We have to… we have to respond by the end of October.

402 00:34:36.159 --> 00:34:37.770 john Roberts: I will. I don't know if they will.

403 00:34:39.100 --> 00:34:41.500 Graham Stoddart-Stones: So, the map they send out, is that…

404 00:34:41.670 --> 00:35:00.850 Andrew Clegg: No, it's the strategy, and there is a map that goes with the strategy on which they have started mapping important areas. For example, just down from my front door, there's an important area which is a possible habitat for the Shrilcader bee.

405 00:35:01.700 --> 00:35:02.640 Andrew Clegg: You see, now.

406 00:35:02.640 --> 00:35:09.030 Graham Stoddart-Stones: Very important. You know about the Sheryl Carter. I do. We're trying to build corridors for it to keep going.

407 00:35:09.030 --> 00:35:22.150 Andrew Clegg: I don't know why… I mean, I think there's only 2 or 3 shrillcarders in existence, and they're all in Somerset, and they need to communicate with each other. And we've been asked to make a… to build a corridor here.

408 00:35:23.140 --> 00:35:29.490 Andrew Clegg: So, doing it, yeah. There's money in it as well, you can get money for building Cheryl Cardo B corridors.

409 00:35:30.420 --> 00:35:32.780 Graham Stoddart-Stones: I wonder if my guys know that.

410 00:35:33.800 --> 00:35:35.189 Graham Stoddart-Stones: I'll try that on them.

411 00:35:35.190 --> 00:35:39.490 Andrew Clegg: Not much, and you have to spend it on corridor-building stuff.

412 00:35:40.610 --> 00:35:44.500 john Roberts: They'll now spring up all over the country, whether there's a fee there or not.

413 00:35:54.930 --> 00:35:58.230 Andrew Clegg: Anyway, that's all I have to say, Graham, so back to you.

414 00:35:58.930 --> 00:36:01.320 Graham Stoddart-Stones: And I'm in, I'm asking about shrill Carter Bees.

415 00:36:01.320 --> 00:36:01.980 Andrew Clegg: Oh.

416 00:36:08.320 --> 00:36:10.669 Graham Stoddart-Stones: Isn't it Shrew Okada, G-E-R?

417 00:36:10.670 --> 00:36:17.130 Andrew Clegg: C-A-Shrill, and then it's Carter, C-A-R-D-E-R, I think. Yeah. Yeah.

418 00:36:19.840 --> 00:36:28.230 Andrew Clegg: No, we're building… we're building a corridor for the… for the brown hair streak butterfly, which is a similarly rare creature.

419 00:36:30.390 --> 00:36:34.530 David Morgan-Jones: We're part of a corridor building, corridors for, vipers.

420 00:36:35.190 --> 00:36:35.710 Andrew Clegg: Oh!

421 00:36:35.710 --> 00:36:36.550 David Morgan-Jones: others.

422 00:36:36.550 --> 00:36:37.800 Andrew Clegg: Really?

423 00:36:39.890 --> 00:36:41.529 Andrew Clegg: Where, where are you?

424 00:36:41.810 --> 00:36:46.039 David Morgan-Jones: We're North Hampshire, so we, we've got the, Heather.

425 00:36:46.230 --> 00:36:48.910 David Morgan-Jones: And that moves,

426 00:36:48.910 --> 00:36:49.390 Andrew Clegg: Yeah.

427 00:36:49.390 --> 00:36:50.840 David Morgan-Jones: of Hampshire into Surrey.

428 00:36:51.080 --> 00:36:56.960 David Morgan-Jones: Yeah. So wherever you've got the, sort of, the large heather areas, the adder likes to roam.

429 00:36:57.930 --> 00:36:59.180 Andrew Clegg: Oh, okay.

430 00:36:59.510 --> 00:37:04.360 Andrew Clegg: But has Hampshire produced this, sort of, this kind of.

431 00:37:04.360 --> 00:37:06.810 David Morgan-Jones: No, sorry. Sorry, Wildlife Trust have.

432 00:37:07.130 --> 00:37:08.430 Andrew Clegg: I already want to left trust, yeah.

433 00:37:08.430 --> 00:37:14.199 David Morgan-Jones: And they're trying to build a corridor from Surrey all the way to the New Forest.

434 00:37:18.370 --> 00:37:28.300 Andrew Clegg: I mean, it all makes sense, but they're not joined up, and they haven't thought about the, the necessarily mapping… necessary mapping technology for everyone.

435 00:37:28.770 --> 00:37:37.639 Andrew Clegg: you know, they've got their own little… produce their own little maps, and I suspect each county is producing a… using a different format.

436 00:37:41.110 --> 00:37:47.130 Andrew Clegg: And, parishes don't seem to be involved, except, I gather, South Gloucestershire. They seem to be,

437 00:37:47.360 --> 00:37:49.000 Andrew Clegg: Seriously involved.

438 00:37:49.870 --> 00:37:52.450 Andrew Clegg: But doesn't the King live in South Gloucestershire?

439 00:37:56.520 --> 00:37:56.910 Graham Stoddart-Stones: Sorry.

440 00:37:56.910 --> 00:37:57.610 Retired Clerk: I know, he lives.

441 00:37:57.610 --> 00:37:58.160 Graham Stoddart-Stones: Isn't.

442 00:37:58.160 --> 00:38:00.549 Retired Clerk: No, he lives in… he lives in Gloucestershire.

443 00:38:00.950 --> 00:38:03.410 Andrew Clegg: I mean, not South Gloucestershire, is it?

444 00:38:03.410 --> 00:38:05.919 Retired Clerk: Safe Gloucestershire's Old Avon.

445 00:38:06.080 --> 00:38:07.100 Retired Clerk: Oh, is it?

446 00:38:07.100 --> 00:38:08.150 Andrew Clegg: Oh, really?

447 00:38:08.740 --> 00:38:12.680 Retired Clerk: Igroves, iGroves, real Gloucestershire.

448 00:38:12.680 --> 00:38:13.260 Andrew Clegg: Okay.

449 00:38:13.260 --> 00:38:16.880 Graham Stoddart-Stones: So who lives in that funny building in London with the flag on top of it?

450 00:38:17.960 --> 00:38:18.800 Graham Stoddart-Stones: Doesn't he live there?

451 00:38:18.800 --> 00:38:19.250 Retired Clerk: A clarity.

452 00:38:19.250 --> 00:38:19.950 David Morgan-Jones: Nope.

453 00:38:19.950 --> 00:38:21.230 Retired Clerk: Parents' lion.

454 00:38:21.860 --> 00:38:24.280 Andrew Clegg: That's a cardboard cutout.

455 00:38:26.710 --> 00:38:28.039 Retired Clerk: It's Clarence's house.

456 00:38:28.810 --> 00:38:30.699 Graham Stoddart-Stones: Oh, lovely. Yes, okay.

457 00:38:33.240 --> 00:38:34.950 Graham Stoddart-Stones: Alright, Stuart, it's your turn.

458 00:38:36.330 --> 00:38:39.010 Stuart Bacon: Yeah, no, I just keep putting stuff in chat.

459 00:38:39.290 --> 00:38:44.359 Graham Stoddart-Stones: Well, that's true, you do, that is… yes, that is good. All right, that's one excuse, then.

460 00:38:47.180 --> 00:38:47.740 john Roberts: Yay.

461 00:38:49.670 --> 00:38:54.970 john Roberts: One of the things that, or one of the discussions at the conference on Friday.

462 00:38:55.830 --> 00:38:59.349 john Roberts: was by the… the Electoral Commission.

463 00:39:01.450 --> 00:39:02.980 john Roberts: Because we're aware.

464 00:39:04.140 --> 00:39:06.320 Stuart Bacon: Written registered to post it back then.

465 00:39:06.750 --> 00:39:12.559 john Roberts: No, it's… we're aware that Somerset, at the moment, is changing its ward boundaries.

466 00:39:13.050 --> 00:39:13.580 Andrew Clegg: Yeah.

467 00:39:13.580 --> 00:39:19.819 john Roberts: And… Certainly, Chris will be aware of, some parishes wanting to merge.

468 00:39:20.490 --> 00:39:21.590 john Roberts: And some not.

469 00:39:22.960 --> 00:39:23.530 Andrew Clegg: But…

470 00:39:23.530 --> 00:39:29.080 john Roberts: once the board boundary review is finished.

471 00:39:29.570 --> 00:39:31.970 john Roberts: The Electoral Commission is then starting

472 00:39:32.640 --> 00:39:36.419 john Roberts: Looking at town and parish boundaries, and…

473 00:39:37.130 --> 00:39:41.749 john Roberts: Dividing them up, or merging them, whether they want to merge or not.

474 00:39:43.170 --> 00:39:46.379 Stuart Bacon: What, just within your area, or nationally?

475 00:39:46.380 --> 00:39:51.080 john Roberts: well, Somerset at the moment. Well, we were giving the talk with regards to Somerset.

476 00:39:51.210 --> 00:39:53.469 john Roberts: Whether it's nationally or not, I don't know.

477 00:39:54.950 --> 00:40:00.140 john Roberts: But, certainly within regard to Somerset, they're looking at merging some of the smaller parishes.

478 00:40:01.320 --> 00:40:06.350 john Roberts: And you've got anomalies where the parish boundary goes through the middle of somebody's house, and things like this.

479 00:40:06.980 --> 00:40:08.879 john Roberts: They're gonna change all of this.

480 00:40:09.430 --> 00:40:14.150 john Roberts: And this is supposed to be up and running by 2027.

481 00:40:15.440 --> 00:40:16.270 Andrew Clegg: Mmm.

482 00:40:18.890 --> 00:40:21.760 john Roberts: But I thought it was quite topical, because,

483 00:40:22.220 --> 00:40:25.640 john Roberts: U.S. Episcopy and Langport have merged.

484 00:40:26.180 --> 00:40:31.140 john Roberts: Chris's neighbours are trying to merge, but… Answered isn't.

485 00:40:31.420 --> 00:40:33.200 john Roberts: hostile takeover.

486 00:40:33.530 --> 00:40:34.100 Retired Clerk: He's a hole.

487 00:40:34.100 --> 00:40:34.820 john Roberts: So, take…

488 00:40:35.100 --> 00:40:35.630 chris edwards: Yeah.

489 00:40:35.630 --> 00:40:36.500 Retired Clerk: I'm traversing.

490 00:40:36.500 --> 00:40:39.319 john Roberts: But yeah, it's…

491 00:40:39.530 --> 00:40:44.960 john Roberts: There wasn't anybody at the conference, from what I can gather, from that end of the country, so they wouldn't have known about it.

492 00:40:47.770 --> 00:40:53.799 john Roberts: But it's supposed to be sorted out by the elections on the 6th of May 2027.

493 00:40:57.650 --> 00:40:59.920 john Roberts: Or that's when the consultation will end.

494 00:41:06.870 --> 00:41:15.670 Andrew Clegg: Yeah, but the areas like… like Chris's and like Langport, there must be lots of those, particularly in Somerset, where you've got,

495 00:41:15.860 --> 00:41:19.690 Andrew Clegg: An authority that needs to spend money

496 00:41:19.890 --> 00:41:25.730 Andrew Clegg: But all the ratepayers that benefit from that authority live in the next authority.

497 00:41:26.210 --> 00:41:27.130 Andrew Clegg: So, Christian…

498 00:41:27.130 --> 00:41:27.680 john Roberts: So…

499 00:41:27.680 --> 00:41:33.290 Andrew Clegg: Chris's parish earns the money, and Castle Carey spends it.

500 00:41:34.160 --> 00:41:34.650 chris edwards: Right.

501 00:41:34.650 --> 00:41:40.510 john Roberts: You've got anomalies, I mean, around here, as Richard will know. You've got Otterhampton Parish.

502 00:41:41.180 --> 00:41:47.010 john Roberts: Which includes Cummage. Cummage is the really big village, Otterhampton is a group of houses.

503 00:41:47.010 --> 00:41:47.490 Andrew Clegg: Yeah.

504 00:41:47.490 --> 00:41:49.360 john Roberts: And yet, it's Otterhampton Parish.

505 00:41:51.730 --> 00:41:59.060 john Roberts: And we've got around here several, parish meetings where they're not part of a par… an actual parish at all.

506 00:42:00.580 --> 00:42:02.219 Retired Clerk: Stockton, Bristol.

507 00:42:02.350 --> 00:42:03.459 john Roberts: Stottle and Bristol.

508 00:42:03.460 --> 00:42:05.160 Retired Clerk: Next to Otterampton.

509 00:42:05.650 --> 00:42:06.180 john Roberts: Yeah.

510 00:42:06.180 --> 00:42:07.440 Retired Clerk: Writing for takeover.

511 00:42:08.520 --> 00:42:09.030 Andrew Clegg: And…

512 00:42:09.030 --> 00:42:09.710 john Roberts: Duh.

513 00:42:10.540 --> 00:42:15.099 john Roberts: So, yeah, I mean, but also, you said it yourself, we had West Somerset.

514 00:42:15.610 --> 00:42:17.920 john Roberts: West Somerset, when it was formed.

515 00:42:18.030 --> 00:42:23.779 john Roberts: Didn't actually have any industry or wherewithal of making money.

516 00:42:25.580 --> 00:42:30.820 john Roberts: Whereas places like Sedgemore, Mendit, yeah, they made lots of money.

517 00:42:31.360 --> 00:42:34.580 john Roberts: So West Somerset failed, and this is the kind of boundaries they're looking at.

518 00:42:39.350 --> 00:42:43.999 Retired Clerk: Maybe somebody will have a bright idea and come up with one unitary authority for the whole lot.

519 00:42:44.000 --> 00:42:44.780 chris edwards: Oh, dear.

520 00:42:44.780 --> 00:42:48.780 john Roberts: Yeah, right. Well, that came with your discussion as well.

521 00:42:54.320 --> 00:43:02.510 john Roberts: But the only other thing… well, the interesting point with the conference, I sat in the workshop that Chris Mews did, which was very good.

522 00:43:02.980 --> 00:43:08.200 john Roberts: There were quite a few people there who weren't aware of Parish Online.

523 00:43:09.260 --> 00:43:14.360 john Roberts: Several of whom have now gone away with Graham's email address.

524 00:43:15.860 --> 00:43:17.400 john Roberts: Which I kindly gave them.

525 00:43:18.410 --> 00:43:20.700 Graham Stoddart-Stones: Thank you very much. Much appreciated.

526 00:43:20.700 --> 00:43:27.390 john Roberts: What was noticeable? When somebody mentioned the Friday banter session, Chris quickly changed the subject.

527 00:43:28.250 --> 00:43:31.299 john Roberts: I would say the quickest change.

528 00:43:31.300 --> 00:43:33.829 Andrew Clegg: a subject I've ever seen.

529 00:43:35.930 --> 00:43:39.519 Graham Stoddart-Stones: Perhaps Chris didn't realize that you were a regular member.

530 00:43:39.920 --> 00:43:42.670 john Roberts: Oh, no, I had been talking to him previous to that.

531 00:43:42.670 --> 00:43:43.840 Graham Stoddart-Stones: Bye.

532 00:43:43.840 --> 00:43:45.599 john Roberts: quite amicably, I might add.

533 00:43:45.820 --> 00:43:50.080 john Roberts: Until you mentioned you were part of the metagroup. No, no, he knows where I'm from.

534 00:43:50.510 --> 00:43:52.120 john Roberts: Only knows where I'm from.

535 00:43:52.910 --> 00:43:55.950 Retired Clerk: Right? We're still trying to get…

536 00:43:55.950 --> 00:44:02.690 john Roberts: data out of Wessex Water and National Grid, actually, with actually nil success at the moment.

537 00:44:05.130 --> 00:44:05.780 Graham Stoddart-Stones: Pun.

538 00:44:06.620 --> 00:44:14.810 Graham Stoddart-Stones: Yeah, that's another example. The National Grid, do a very useful interactive map layer for the whole country.

539 00:44:14.810 --> 00:44:29.769 Andrew Clegg: And it's completely open to the… you have to log in, you have to, you know, but you don't have to pay anything. And it tells you a lot about your power supply in your parish, and where all the transformers are and things. Yeah.

540 00:44:29.770 --> 00:44:36.830 Andrew Clegg: But it's… it's not compatible with the parish online, and there doesn't seem to be… Yeah.

541 00:44:36.830 --> 00:44:45.150 john Roberts: They've got… they've got a section in Paris Online, which deals with the National Grid, But it's,

542 00:44:45.770 --> 00:44:48.320 john Roberts: Above ground, you know, the pylons.

543 00:44:48.450 --> 00:44:49.110 Andrew Clegg: Yeah.

544 00:44:49.110 --> 00:44:53.310 john Roberts: But if you put in substations, it doesn't give you down to our level.

545 00:44:53.570 --> 00:45:10.679 Andrew Clegg: Yeah. Well, I had to look up all the substations around me, because we've got a development, which I've spoken about before, on the A303, where they're trying to build a big lorry, lorry park, and electric charging station capable of charging up,

546 00:45:11.100 --> 00:45:20.090 Andrew Clegg: 100 vehicles at once, and for that, you need an electricity supply approximately the same as Martok, the whole village.

547 00:45:20.470 --> 00:45:33.130 Andrew Clegg: And there's only one transformer, only one substation in our part of Somerset that can do that, and that happens to be quite close to us, and so we're getting this thing built.

548 00:45:39.700 --> 00:45:40.440 Graham Stoddart-Stones: Right.

549 00:45:45.550 --> 00:45:47.729 john Roberts: So, I was looking for the National Grid one.

550 00:45:47.730 --> 00:45:48.300 Andrew Clegg: Hmm.

551 00:45:52.840 --> 00:45:55.520 Graham Stoddart-Stones: Sorry, John, I have to leave.

552 00:45:56.670 --> 00:46:05.240 john Roberts: It's supposed to give you substations, towers, pylons, electrical cable, overhead lines, gas site points, gas site, and gas pipe.

553 00:46:05.700 --> 00:46:11.699 john Roberts: But… Those are the very big 440K lines. I've never seen these small.

554 00:46:11.700 --> 00:46:14.729 Stuart Bacon: Anyone I've just, sort of, uploaded, John, to the chat?

555 00:46:14.730 --> 00:46:18.170 john Roberts: No. No, no, no, I haven't got that far yet, Stuart, yeah.

556 00:46:20.340 --> 00:46:24.490 Graham Stoddart-Stones: if… That one you've got, Stuart, does that show you all these things?

557 00:46:25.100 --> 00:46:34.110 Stuart Bacon: It… it shows the… a lot of them as downloadable shapefiles, and shows a map of… So, something.

558 00:46:34.650 --> 00:46:42.130 Graham Stoddart-Stones: Well, the answer to your question is yes, Parish Online does, or at least XMAT does, upload shapefiles.

559 00:46:42.370 --> 00:46:44.370 Graham Stoddart-Stones: Piece of cake.

560 00:46:45.090 --> 00:46:48.759 Graham Stoddart-Stones: And because XMAT does it, then Paris Online gets them.

561 00:46:49.410 --> 00:46:51.630 Graham Stoddart-Stones: So, yes, is the answer to your question.

562 00:46:52.480 --> 00:46:56.859 Graham Stoddart-Stones: And I wonder why, if that data is available, why they aren't bothering with that.

563 00:46:57.720 --> 00:47:04.189 john Roberts: Well, on Parish Online, it's got the main transmission routes. That's what it seems to concentrate on.

564 00:47:04.450 --> 00:47:08.140 Graham Stoddart-Stones: Yeah, and that's what we've got here, isn't it, on these shaped foam? Yeah. Yeah.

565 00:47:09.470 --> 00:47:18.060 john Roberts: when I spoke to Chris about it some time ago, he said that's, at the moment, is all they upload, is the big transmission routes.

566 00:47:18.490 --> 00:47:24.410 john Roberts: And said, you know, best of luck, have a chat. Well, first of all, you've got to find out who you talk to.

567 00:47:25.470 --> 00:47:26.190 Graham Stoddart-Stones: Well…

568 00:47:26.510 --> 00:47:35.870 Graham Stoddart-Stones: As Stuart has pointed out, they've got the towers, the cables, the substations, all readily available, it's just that you can download them from the website.

569 00:47:36.160 --> 00:47:38.960 john Roberts: So I thought it was a piece of cake to Chris.

570 00:47:38.960 --> 00:47:43.369 Graham Stoddart-Stones: To get them, particularly since he's already getting the major overhead lines.

571 00:47:49.230 --> 00:47:54.720 Graham Stoddart-Stones: Because I can see it'd be hugely useful to, you know, parishes to know what was going on, wouldn't it?

572 00:47:55.640 --> 00:48:00.300 Graham Stoddart-Stones: Particularly as we're going into EVs, and that you need to know where the substations are.

573 00:48:01.540 --> 00:48:04.229 Andrew Clegg: Yeah, and the ones with capacity.

574 00:48:04.890 --> 00:48:05.480 Graham Stoddart-Stones: Yes.

575 00:48:05.480 --> 00:48:06.340 Andrew Clegg: That's… that's…

576 00:48:06.340 --> 00:48:08.420 Graham Stoddart-Stones: Does it mention the capacity on these things?

577 00:48:08.420 --> 00:48:13.940 Andrew Clegg: Yeah, I've got… I'm just putting it online, if I can work on now how to put things in the,

578 00:48:14.730 --> 00:48:17.780 Andrew Clegg: And there, I've got the map, yeah.

579 00:48:18.980 --> 00:48:22.060 Graham Stoddart-Stones: Oh, it really is a shape party, I see what you're saying. Okay.

580 00:48:25.310 --> 00:48:29.179 Graham Stoddart-Stones: Let me try putting that into XMAP and see what happens.

581 00:48:35.000 --> 00:48:36.360 Graham Stoddart-Stones: Just out of interest.

582 00:48:39.450 --> 00:48:42.039 Graham Stoddart-Stones: Or are you already doing that, Andrew?

583 00:48:42.040 --> 00:48:47.320 Andrew Clegg: No, I'm not, I'm just, I'm trying to find, our local substations.

584 00:48:47.550 --> 00:48:48.300 Graham Stoddart-Stones: Okay.

585 00:48:49.560 --> 00:48:50.310 Graham Stoddart-Stones: Just elevate.

586 00:48:54.600 --> 00:48:57.460 chris edwards: Graham, what does Claude say all about this?

587 00:49:01.220 --> 00:49:05.650 Retired Clerk: I don't know, he's helping me with carnival plans at the moment, leave me alone.

588 00:49:10.060 --> 00:49:12.559 David Morgan-Jones: I think you're a miserable bunch of people to work with.

589 00:49:12.920 --> 00:49:13.446 chris edwards: What's the.

590 00:49:13.710 --> 00:49:17.460 Retired Clerk: I was very polite to him. I asked…

591 00:49:17.460 --> 00:49:19.510 Graham Stoddart-Stones: You've liked Claude.

592 00:49:20.010 --> 00:49:21.389 Graham Stoddart-Stones: All worried about me.

593 00:49:21.590 --> 00:49:22.190 chris edwards: Nope.

594 00:49:22.390 --> 00:49:24.219 Retired Clerk: Oh, well, I did say about you.

595 00:49:24.220 --> 00:49:29.629 Graham Stoddart-Stones: He said, Claude Bobby said, is that the idiot who was on this morning?

596 00:49:29.630 --> 00:49:31.610 Retired Clerk: I mentioned your name. Yeah.

597 00:49:34.720 --> 00:49:37.719 Graham Stoddart-Stones: Actually, it was funny, I was on very early this morning, like, about…

598 00:49:38.020 --> 00:49:42.700 Graham Stoddart-Stones: 4.30, 5 o'clock, and Claude came immediately and said, good morning, night owl.

599 00:49:47.820 --> 00:49:50.089 Stuart Bacon: Hopefully you do it up at that time of the morning, Graham?

600 00:49:50.940 --> 00:50:00.780 Graham Stoddart-Stones: Well, you know how it is, you wake up in the middle of the night, and your head's buzzing with ideas, and I think, if I don't get them down, they'll never get down.

601 00:50:01.000 --> 00:50:13.089 Graham Stoddart-Stones: And it was all… it's all to do with computers anyway, so I just came out to the office and did everything, and it was… actually, it was for this, spreadsheet that I was discussing before Andrew arrived.

602 00:50:13.200 --> 00:50:19.330 Graham Stoddart-Stones: And I thought, surely Claude can do it better than I can, and lo and behold, he did, in due course.

603 00:50:20.100 --> 00:50:25.879 Graham Stoddart-Stones: Long training issue involved. But he did learn from his mistakes. That was interesting, I thought.

604 00:50:26.810 --> 00:50:30.840 Retired Clerk: And he's got my email, date of birth, and, and phone number now.

605 00:50:33.290 --> 00:50:34.719 Graham Stoddart-Stones: Yours or mine?

606 00:50:34.720 --> 00:50:44.549 Retired Clerk: Well, you can have yours, I don't care about yours, you can take mine. I gave him your date of birth to make me… make me more… more security conscious.

607 00:50:50.980 --> 00:50:53.520 Graham Stoddart-Stones: What are we looking at? Shape files?

608 00:51:38.300 --> 00:51:43.360 Graham Stoddart-Stones: Right, I'm just getting into XLAP to see if I can persuade it to upload these things, just out of interest.

609 00:51:56.260 --> 00:51:58.669 David Morgan-Jones: Graham, if you'll forgive me, I'm going to love you and leave you.

610 00:51:59.200 --> 00:52:01.590 David Morgan-Jones: So I gotta rush off to something else now.

611 00:52:02.010 --> 00:52:08.780 Graham Stoddart-Stones: Well, I do say in all the messages I send around that we're quite prepared to deal with those rogue people who just arrive, ask their questions, and disappear again.

612 00:52:12.090 --> 00:52:15.479 Graham Stoddart-Stones: Alright, catch you later, guys. Bye-bye! Have a good weekend.

613 00:52:15.480 --> 00:52:16.880 David Morgan-Jones: Thanks, bye.

614 00:52:20.030 --> 00:52:22.739 Graham Stoddart-Stones: Okay, we're getting close to the actual life.

615 00:52:23.020 --> 00:52:25.290 Graham Stoddart-Stones: Can we upload this?

616 00:52:36.030 --> 00:52:41.059 Stuart Bacon: National Grid website keeps bibbing to me, keeps telling me it's emailed me, and it hasn't.

617 00:52:58.100 --> 00:53:00.500 Andrew Clegg: How do you upload shape files on…

618 00:53:01.440 --> 00:53:07.949 Graham Stoddart-Stones: You go into Administration, Files, Data Files? Or, sorry, Data, File Upload.

619 00:53:08.550 --> 00:53:09.110 Andrew Clegg: No.

620 00:53:11.530 --> 00:53:14.620 Graham Stoddart-Stones: And I've just uploaded it, let's see what happens.

621 00:53:16.110 --> 00:53:23.360 Graham Stoddart-Stones: It will not astonish you to know that I've got an invalid syntax error.

622 00:53:23.920 --> 00:53:30.029 Graham Stoddart-Stones: But perhaps it's because the names along the, substations is longer than 6 characters. Let me just…

623 00:53:30.560 --> 00:53:33.089 Graham Stoddart-Stones: Shorten those and see if that changes anything.

624 00:54:00.800 --> 00:54:03.010 john Roberts: Where did you find the shapefiles?

625 00:54:03.730 --> 00:54:09.029 Graham Stoddart-Stones: There were… if you click on any one of those things that they download on that first page.

626 00:54:09.280 --> 00:54:11.640 Graham Stoddart-Stones: They are orange. They're all shapefiles.

627 00:54:11.920 --> 00:54:12.770 john Roberts: Okay.

628 00:54:13.580 --> 00:54:17.760 Graham Stoddart-Stones: I thought you mentioned… somebody asked about shapefiles earlier, wasn't it you?

629 00:54:18.400 --> 00:54:19.040 john Roberts: Nope.

630 00:54:19.260 --> 00:54:19.979 Graham Stoddart-Stones: Hmm, okay.

631 00:54:24.110 --> 00:54:28.200 Graham Stoddart-Stones: Sorry, I'm just renaming everything to be less than 6 characters. Might be a second.

632 00:54:39.360 --> 00:54:40.540 Graham Stoddart-Stones: Turn that again.

633 00:54:59.110 --> 00:55:02.009 Graham Stoddart-Stones: Oh, same error. Okay, I'll go back to them.

634 00:55:02.590 --> 00:55:06.429 Graham Stoddart-Stones: With that, but… Sorry, I can't…

635 00:55:06.850 --> 00:55:13.470 Graham Stoddart-Stones: courage you with the glories of XMAPS facilities today. They've obviously still got a major issue on their syntax errors.

636 00:55:16.980 --> 00:55:21.300 Graham Stoddart-Stones: Does anyone else have anything they want to mention, chat about, discuss?

637 00:55:21.940 --> 00:55:22.950 john Roberts: Not today.

638 00:55:22.950 --> 00:55:25.460 Graham Stoddart-Stones: Shall we declare an early start to the weekend?

639 00:55:26.450 --> 00:55:27.439 chris edwards: Okay. Yeah.

640 00:55:27.440 --> 00:55:32.490 Graham Stoddart-Stones: Gentlemen at all, thank you very much. It's been this usual fun thing. Nice to see you back.

641 00:55:32.490 --> 00:55:34.289 chris edwards: Alright, thank you. Bye.

642 00:55:34.290 --> 00:55:35.140 Retired Clerk: Oh, I take care.

643 00:55:35.140 --> 00:55:36.089 Graham Stoddart-Stones: Bye, everyone. Bye-bye.