251003 - 03Oct25 - session 25-40
EPC data, Addresses, Co-ordinates of a point, Public Maps, Footpaths and Stiles, Help/Support, Merge (poor explanation), mapping a hole, request for more filter functions
Video Timeline: (min:sec)
00:00 - 05:22 Joining banter
05:22 - 12:20 EPC banter
12:20 - 23:35 Addresses
23:35 - 28:30 Co-ordinates of a point
28:30 - 31:15. Banter
31:15 - 43:30 Public Maps
43:30 - 45:45 Banter
45:45 - 48:15 Footpaths, Stiles (Roam Somerset)
48:15 - 53:50 Public Map, Parish boundary
53:50 - 56:40 Getting help/support
56:40 - 70:00 Merge (poorly explained!), mapping a hole
70:00 - 72:00 More functions in filtering desired
72:00 - 78:46 (end) Banter
Chat:
00:21:28 Retired Clerk: Somerset Council address change info...Street naming and numbering management 00:23:44 David Morgan-Jones: https://epc.opendatacommunities.org 00:30:11 Stuart Bacon: https://shared.xmap.cloud?map=0ef40ce2-d7c1-4b83-9b35-a1477b62972b 00:30:21 Stuart Bacon: https://shared.xmap.cloud?map=dfdb234d-f66a-44ba-b2f5-6cf0dce5f186 00:30:35 Stuart Bacon: https://shared.xmap.cloud?map=c6760b0c-6089-4cca-a2de-582ed159f225 00:31:05 Stuart Bacon: Land ownership https://shared.xmap.cloud?map=bc99dc6f-a870-4e73-a9fd-fec8ded5e367 00:44:24 Stuart Bacon: https://brutontowncouncil.gov.uk/ 01:13:57 David Morgan-Jones: https://epc.opendatacommunities.org/domestic/search
Audio Transcript: (for AI search engine)
WEBVTT
1 00:00:38.290 --> 00:00:39.780 tristram cary: Hello, son, Graham.
2 00:00:40.010 --> 00:00:46.499 Graham Stoddart-Stones: Good day to you And, I gather David's joining us today.
3 00:00:46.500 --> 00:00:47.430 tristram cary: Yes.
4 00:00:47.800 --> 00:00:50.980 Graham Stoddart-Stones: Does he have a specific task in mind, do you know?
5 00:00:50.980 --> 00:00:54.590 tristram cary: Yes, he does. He's, you know his from U-Shot?
6 00:00:55.120 --> 00:00:55.720 Graham Stoddart-Stones: Yes.
7 00:00:55.720 --> 00:01:10.800 tristram cary: And we're talking to Hart about doing, you know, doing better on solar energy and, sorry, on retrofits and solar and everything. Yeah. And he wants to know how we're going to do… he's got information he wants to get out of the EPC data.
8 00:01:11.110 --> 00:01:11.950 Graham Stoddart-Stones: Okay.
9 00:01:11.950 --> 00:01:14.170 tristram cary: He wants to ask if anybody else has had a go.
10 00:01:15.580 --> 00:01:18.009 tristram cary: And what the spec is for the data we want.
11 00:01:18.180 --> 00:01:23.070 tristram cary: And then we'll… and then I might have a go at Chris's muse and see if he can get us to help him.
12 00:01:23.360 --> 00:01:24.170 Graham Stoddart-Stones: Right.
13 00:01:24.170 --> 00:01:30.809 tristram cary: But actually, David's quite… he's pretty good technically, so he might be able to help us actually do it.
14 00:01:30.810 --> 00:01:32.220 Graham Stoddart-Stones: I'm sure, yes.
15 00:01:32.520 --> 00:01:33.460 Graham Stoddart-Stones: Good day, Pete.
16 00:01:33.460 --> 00:01:42.959 tristram cary: I think if we could all agree what we want to achieve, I think the discussion about what information you want out of the EPCs would be useful.
17 00:01:43.770 --> 00:01:44.550 Graham Stoddart-Stones: Right.
18 00:01:45.490 --> 00:01:47.570 Graham Stoddart-Stones: I want to say good afternoon to Peter.
19 00:01:47.830 --> 00:01:49.120 Peter Lewis: Good afternoon.
20 00:01:49.370 --> 00:01:50.550 Graham Stoddart-Stones: Good afternoon to Richard.
21 00:01:51.220 --> 00:01:51.930 tristram cary: Richard.
22 00:01:52.700 --> 00:01:54.699 Graham Stoddart-Stones: Have you been blown away yet?
23 00:01:54.860 --> 00:01:56.319 Retired Clerk: No, but it's raining.
24 00:01:57.150 --> 00:02:00.049 Graham Stoddart-Stones: I was just saying, all the cranes would have stopped.
25 00:02:00.330 --> 00:02:01.000 Retired Clerk: Oh, boy.
26 00:02:01.000 --> 00:02:03.119 Graham Stoddart-Stones: We've got the sort of wind that we have.
27 00:02:05.090 --> 00:02:05.410 Graham Stoddart-Stones: But…
28 00:02:05.730 --> 00:02:07.330 Retired Clerk: You shouldn't have had the beans.
29 00:02:08.970 --> 00:02:14.969 Graham Stoddart-Stones: No, well… Have you had a big win, Graham? It's getting there. Getting there.
30 00:02:14.970 --> 00:02:17.950 tristram cary: Yeah, I thought it was all further north, it was the…
31 00:02:18.180 --> 00:02:22.149 Graham Stoddart-Stones: Well, I think, I think, yes, I think the north of Ireland has really been clobbered, but…
32 00:02:22.150 --> 00:02:22.770 tristram cary: Oh.
33 00:02:22.770 --> 00:02:24.449 Graham Stoddart-Stones: Not to worry,
34 00:02:26.360 --> 00:02:28.669 tristram cary: Mediterranean South, we don't notice these things.
35 00:02:29.200 --> 00:02:33.449 Retired Clerk: Is it as bad as a 1987 Great Wind? That's the… that's the worry.
36 00:02:33.740 --> 00:02:34.960 tristram cary: Yeah, surely not.
37 00:02:34.960 --> 00:02:37.709 Graham Stoddart-Stones: Well, that one didn't exist, did it?
38 00:02:38.080 --> 00:02:39.150 Graham Stoddart-Stones: No danger of a typhoon.
39 00:02:39.150 --> 00:02:40.270 tristram cary: Good, really?
40 00:02:41.360 --> 00:02:43.129 Retired Clerk: Not in Michael Fish's world.
41 00:02:44.970 --> 00:02:45.760 Graham Stoddart-Stones: Hey, Andrew!
42 00:02:46.280 --> 00:02:47.130 Andrew Clegg: Hello!
43 00:02:47.590 --> 00:02:48.500 tristram cary: Hello, Andrew.
44 00:02:48.930 --> 00:02:49.600 Andrew Clegg: Nope.
45 00:02:51.280 --> 00:02:52.110 Graham Stoddart-Stones: No.
46 00:02:55.770 --> 00:02:58.329 Graham Stoddart-Stones: Well, given that we're past the witching hour.
47 00:02:59.460 --> 00:03:05.379 Graham Stoddart-Stones: Peter, you have pride of place as somebody who's hopefully arrived with a question or two to ask.
48 00:03:07.800 --> 00:03:09.850 Peter Lewis: Oh, dude, can you hear me? Okay.
49 00:03:11.710 --> 00:03:14.410 Graham Stoddart-Stones: So, does that mean you're not going to ask any questions?
50 00:03:14.410 --> 00:03:16.539 Peter Lewis: Well, I wasn't… can you hear me? I don't know, can you hear me?
51 00:03:16.580 --> 00:03:17.400 Graham Stoddart-Stones: Yep, yep, yep.
52 00:03:17.400 --> 00:03:28.129 Peter Lewis: No, I didn't have a particular set of questions, but I'd just been looking around… I'd been asked by somebody in the parish to have a look at it, and I've been looking around, and I came across your banter.
53 00:03:28.220 --> 00:03:41.329 Peter Lewis: I think a copy of your banter from last week, actually, which I… which I, listened to, and I thought I'd join you this week and see what… what, might emerge from that, and see whether… I might have a question by the time we get to the end.
54 00:03:41.330 --> 00:03:43.130 Graham Stoddart-Stones: Right.
55 00:03:43.650 --> 00:03:45.100 Graham Stoddart-Stones: Right, well, that's fine.
56 00:03:45.660 --> 00:03:46.475 Graham Stoddart-Stones: So…
57 00:03:49.860 --> 00:03:54.189 Graham Stoddart-Stones: I have, Bristrum, an outstanding XMAP ticket.
58 00:03:54.840 --> 00:04:04.100 Graham Stoddart-Stones: Because I uploaded data, and it came back to me and said, syntax error, and I hate programs that say syntax error, because it doesn't tell you what the bloody program is.
59 00:04:05.290 --> 00:04:15.799 Graham Stoddart-Stones: So I write to the help desk and say, what's the issue? And they come back and they say, we can't quite put our finger on it. We don't know what it is.
60 00:04:15.800 --> 00:04:19.520 tristram cary: I'm sorry, what… where is the issue?
61 00:04:20.950 --> 00:04:25.989 tristram cary: in XMAP, uploading data from… Uploading data. Once they lost it.
62 00:04:26.600 --> 00:04:27.360 Graham Stoddart-Stones: What?
63 00:04:27.360 --> 00:04:28.280 tristram cary: They've lost it.
64 00:04:28.280 --> 00:04:33.340 Graham Stoddart-Stones: No, no, no, no, no, I see what you mean. No, no, they can't quite put their finger on what the error is.
65 00:04:34.420 --> 00:04:36.759 tristram cary: That sounds, that sounds situation normal.
66 00:04:36.760 --> 00:04:38.910 Graham Stoddart-Stones: Oh, that's not kind.
67 00:04:40.510 --> 00:04:44.530 Graham Stoddart-Stones: But, but it was, Simon that told me, so I thought, well, you know.
68 00:04:44.530 --> 00:04:45.260 tristram cary: Hmm.
69 00:04:45.930 --> 00:04:53.520 Graham Stoddart-Stones: It probably is something weird, but I didn't think there's anything weird in my data. Never mind. David, good day to you.
70 00:04:53.520 --> 00:04:54.970 David Morgan-Jones: Hi, Graham.
71 00:04:54.970 --> 00:05:03.230 Graham Stoddart-Stones: And we're doubly pleased to see you, because not only are you a sensible chap with a double-barreled name…
72 00:05:04.930 --> 00:05:08.759 Graham Stoddart-Stones: Tristan tells me that you're arriving with a specific query.
73 00:05:09.730 --> 00:05:12.649 Graham Stoddart-Stones: People with specific queries are always welcome on this show.
74 00:05:16.670 --> 00:05:20.529 Graham Stoddart-Stones: So, the floor is yours if you'd like to air your grievance.
75 00:05:20.530 --> 00:05:24.450 David Morgan-Jones: It's not a grievance, it's a, it's a how-to.
76 00:05:26.260 --> 00:05:33.439 David Morgan-Jones: And… what I was talking with, Tristram about yesterday was…
77 00:05:34.220 --> 00:05:45.120 David Morgan-Jones: We want to identify all those houses within the parish, That have either no, out of date.
78 00:05:45.980 --> 00:05:51.310 David Morgan-Jones: or below a level C grade for their APCs?
79 00:05:51.310 --> 00:05:52.010 Graham Stoddart-Stones: Yep.
80 00:05:53.620 --> 00:05:57.199 Graham Stoddart-Stones: And I thought you could do that anyway, but you're saying obviously not.
81 00:05:57.200 --> 00:05:59.029 chris edwards: Hi, Chris. Hi, Stuart. Hello.
82 00:05:59.560 --> 00:06:00.210 Stuart Bacon: Hello!
83 00:06:02.180 --> 00:06:07.410 Graham Stoddart-Stones: So, what's the difference between that and the data that's sitting in Paris Online at the moment?
84 00:06:08.120 --> 00:06:12.749 David Morgan-Jones: Well, I don't know how to get it. I mean, the bottom line is, I have no idea how to access it.
85 00:06:12.750 --> 00:06:14.479 Retired Clerk: Oh, I see.
86 00:06:14.480 --> 00:06:15.390 David Morgan-Jones: Yeah!
87 00:06:15.390 --> 00:06:20.619 Graham Stoddart-Stones: Oh, well… The, the expert on things like that is Stuart.
88 00:06:21.570 --> 00:06:25.170 Graham Stoddart-Stones: Because he only just arrived, so he hasn't got the site idea…
89 00:06:27.250 --> 00:06:28.119 Retired Clerk: You stitched him up.
90 00:06:28.120 --> 00:06:29.949 Graham Stoddart-Stones: Look at me in the deep end there, Graham.
91 00:06:30.730 --> 00:06:32.579 Graham Stoddart-Stones: It's the only way to learn to swim.
92 00:06:35.250 --> 00:06:40.589 Graham Stoddart-Stones: I can't remember… are we gonna download our EPC data, can't we?
93 00:06:40.930 --> 00:06:41.880 Graham Stoddart-Stones: Yeah.
94 00:06:41.880 --> 00:06:47.020 Stuart Bacon: It's in there, but it's not down as APC. No, it's EPC.
95 00:06:47.020 --> 00:06:48.329 Retired Clerk: Excellent. I appreciate that.
96 00:06:48.330 --> 00:06:56.799 tristram cary: Yeah, but you can't… you can't, as I remember, you can't, do a data extract of all the houses in your parish to say which ones are, say, below D.
97 00:06:57.700 --> 00:06:58.580 Graham Stoddart-Stones: Really?
98 00:06:59.190 --> 00:07:06.060 David Morgan-Jones: Yeah, I mean, basically what I want is a list. I need a list so that I can,
99 00:07:06.190 --> 00:07:09.039 David Morgan-Jones: Take it off the, the, the system.
100 00:07:09.040 --> 00:07:10.580 Retired Clerk: Alright.
101 00:07:11.120 --> 00:07:16.439 Retired Clerk: I'll take off… I'll take off the footpath and try and get… get to the,
102 00:07:16.620 --> 00:07:18.279 Retired Clerk: Get to where you want to be.
103 00:07:19.950 --> 00:07:22.840 tristram cary: And you guys have better come up with a good answer, because I told David this.
104 00:07:22.840 --> 00:07:24.260 Graham Stoddart-Stones: She's a bit.
105 00:07:24.260 --> 00:07:30.920 tristram cary: solve all your problems. And I think it's fair to say, Davidson, you haven't had much experience of driving parishion lines.
106 00:07:30.920 --> 00:07:37.489 David Morgan-Jones: No, no, I've had a little go occasionally when I need something like a copy of the map, or…
107 00:07:37.610 --> 00:07:42.999 David Morgan-Jones: Add some bits and pieces, but not… nothing more complicated than that.
108 00:07:43.000 --> 00:07:48.369 Graham Stoddart-Stones: I'm just checking that I can do it for you before we, like, take you in there and say, this is how you do it.
109 00:07:51.290 --> 00:07:53.639 Stuart Bacon: This is Richard's screen, is it?
110 00:07:53.640 --> 00:07:59.070 Retired Clerk: It is. The largest self-contained in one parish building site in the world.
111 00:07:59.610 --> 00:08:01.100 Andrew Clegg: Okay.
112 00:08:01.100 --> 00:08:03.469 Retired Clerk: in early, because I haven't been here for a couple of weeks.
113 00:08:04.010 --> 00:08:09.639 Retired Clerk: So, moving away from HPC, we'll come back to the parish of Stagurizi.
114 00:08:09.830 --> 00:08:13.480 Graham Stoddart-Stones: Okay, so because it's a third party, it's not being set up with a table.
115 00:08:13.810 --> 00:08:14.640 Graham Stoddart-Stones: View.
116 00:08:15.930 --> 00:08:18.310 Retired Clerk: There's your… there's your potentials.
117 00:08:18.780 --> 00:08:27.359 Retired Clerk: shown on screen, to come down to see, literally, EPC, potential to see, so that the system already does that for you.
118 00:08:27.720 --> 00:08:29.069 Retired Clerk: But as you say.
119 00:08:29.810 --> 00:08:32.409 tristram cary: Well, that's not quite… that's not quite what he asked for. He didn't…
120 00:08:32.419 --> 00:08:34.969 Retired Clerk: No, that isn't what he asked… that isn't what he asked for.
121 00:08:35.700 --> 00:08:37.550 Stuart Bacon: You want the current rating?
122 00:08:37.679 --> 00:08:38.690 Stuart Bacon: I think.
123 00:08:38.690 --> 00:08:40.599 tristram cary: It's your current rating, is what you want.
124 00:08:41.630 --> 00:08:42.679 Retired Clerk: Okay…
125 00:08:43.210 --> 00:08:48.429 tristram cary: The question is now, how can you produce a spreadsheet of all the ones that are below D?
126 00:08:49.100 --> 00:08:50.540 tristram cary: Or, I suppose.
127 00:08:50.540 --> 00:08:51.020 Stuart Bacon: Hmm…
128 00:08:51.020 --> 00:09:00.140 tristram cary: almost as good. Each… you know, if we could produce a list of everything that's got an E, and everything that's got an F, and everything's got a D, that would be just as good, because we could do the list of it in…
129 00:09:00.140 --> 00:09:18.749 Graham Stoddart-Stones: So, I think my answer is going to be heresy for you, David, but I would direct you towards the government of the United Kingdom, which produces a wonderful list in no less than 5.6 gigabytes of every EPC certificate in the country.
130 00:09:19.500 --> 00:09:25.120 Graham Stoddart-Stones: And you can filter out your area from, you know, Hart, or U-Shot, or whatever it is you want from that.
131 00:09:25.860 --> 00:09:28.209 tristram cary: Yeah, but we got that already in Paris Online.
132 00:09:28.450 --> 00:09:30.859 Graham Stoddart-Stones: We haven't got it in a spreadsheet.
133 00:09:31.070 --> 00:09:32.550 tristram cary: Sorry, it's…
134 00:09:32.550 --> 00:09:33.930 David Morgan-Jones: That's true.
135 00:09:34.130 --> 00:09:40.560 Graham Stoddart-Stones: Trying hard to sort of solve the questions of the strange creatures who come onto this site, or this session.
136 00:09:41.500 --> 00:09:48.790 Andrew Clegg: Is there any reason why these EPC things you can't… you can't convert to a spreadsheet?
137 00:09:48.790 --> 00:09:57.030 Graham Stoddart-Stones: Well, when data is put into Parish Online, it's put in either to have a table view or have not a table view, and whoever.
138 00:09:57.030 --> 00:09:57.450 Andrew Clegg: genes.
139 00:09:57.450 --> 00:09:58.990 Graham Stoddart-Stones: And did it with have not?
140 00:09:59.320 --> 00:10:07.260 tristram cary: There was… I can't quite remember, but there was a re… there was some reason why that happened, and it was very… because we asked… we asked for the… we asked to be able to…
141 00:10:07.480 --> 00:10:22.939 tristram cary: have it in a spreadsheet and then analyze the data, and there was a reason why we couldn't. And I know, again, I always say this, it's on the list, but I have no idea when it's going to be sold. But I wonder whether there… I wonder whether we could up the priority of that work if
142 00:10:23.400 --> 00:10:28.260 tristram cary: If this team and this banter group said, you know, we all want this, and this is… this is what we want.
143 00:10:28.260 --> 00:10:35.670 Graham Stoddart-Stones: It doesn't work that way. You have to have somebody who's not associated with this group put it in, otherwise he just gets rejected out of hand.
144 00:10:35.670 --> 00:10:37.309 tristram cary: Dude, that's not true.
145 00:10:37.310 --> 00:10:39.139 Retired Clerk: David, David fits the bill.
146 00:10:39.140 --> 00:10:42.750 Graham Stoddart-Stones: Classified as trouble… troublemaker.
147 00:10:42.750 --> 00:10:51.949 Andrew Clegg: I find I'm using the spreadsheet almost all the time. You know, not for Parish Online, it's XMAP, but I do find it's…
148 00:10:51.950 --> 00:10:52.830 Graham Stoddart-Stones: Very useful, isn't it?
149 00:10:52.830 --> 00:10:56.140 Andrew Clegg: unique that it's so useful, I'm using it all the time, almost.
150 00:10:56.650 --> 00:11:06.500 Graham Stoddart-Stones: Yeah. So, in answer to your immediate question, David, if you go onto Gov.uk and look for EPC data, you can download all of it.
151 00:11:06.720 --> 00:11:08.400 Graham Stoddart-Stones: And that will give you what you want.
152 00:11:08.760 --> 00:11:11.580 Graham Stoddart-Stones: I'm sorry it's not a parish online answer, but…
153 00:11:11.720 --> 00:11:26.950 David Morgan-Jones: No, no, no, no, I'm quite happy to take it whichever way it comes. The only downside, I've got a feeling, is, if you look at your EPCs within your parishes, you will find that where an EPC exists.
154 00:11:27.980 --> 00:11:32.040 David Morgan-Jones: That's great, and it will even tell you if the EPC is out of date.
155 00:11:32.290 --> 00:11:45.949 David Morgan-Jones: What it doesn't do is actually, well, it does show you, by default, those houses that have no EPC. So, if I download the, EPC dataset from the government.
156 00:11:46.150 --> 00:11:50.339 David Morgan-Jones: What it will show me is a list of houses that have…
157 00:11:50.650 --> 00:11:56.100 Graham Stoddart-Stones: Alright, well, you certainly get a list of all the houses in your parish, and then compare the two.
158 00:11:56.100 --> 00:11:59.490 David Morgan-Jones: Where do you get the list of the houses from the parish? Is there a data set?
159 00:11:59.490 --> 00:12:03.389 Graham Stoddart-Stones: If you go into… can you show your screen, and we'll drive you to it?
160 00:12:03.650 --> 00:12:04.800 David Morgan-Jones: Sure.
161 00:12:13.320 --> 00:12:16.619 Graham Stoddart-Stones: Can you see that? Yes, well, so far, you haven't actually got there.
162 00:12:16.800 --> 00:12:17.940 Retired Clerk: Very good.
163 00:12:17.940 --> 00:12:22.679 Graham Stoddart-Stones: If you go up to the, magnifying glass at the top of the left column.
164 00:12:22.680 --> 00:12:24.539 Retired Clerk: Yup, that's the one that… yup.
165 00:12:24.910 --> 00:12:26.980 Graham Stoddart-Stones: And type in address.
166 00:12:27.750 --> 00:12:28.460 David Morgan-Jones: Right.
167 00:12:31.500 --> 00:12:33.000 Graham Stoddart-Stones: Preferably with two Ds.
168 00:12:33.000 --> 00:12:33.880 David Morgan-Jones: That helps.
169 00:12:34.610 --> 00:12:35.670 David Morgan-Jones: Ugh.
170 00:12:36.560 --> 00:12:39.219 Graham Stoddart-Stones: There you go. And then go into addresses, yep.
171 00:12:39.220 --> 00:12:39.590 David Morgan-Jones: Yup.
172 00:12:39.590 --> 00:12:41.440 Graham Stoddart-Stones: And address base plus points?
173 00:12:42.520 --> 00:12:44.379 Graham Stoddart-Stones: And click on the cogwheel.
174 00:12:45.950 --> 00:12:47.870 Graham Stoddart-Stones: and download Table View.
175 00:12:48.020 --> 00:12:55.420 Graham Stoddart-Stones: or go into TableView, then you probably want to put a… filter on.
176 00:12:56.120 --> 00:13:00.019 Graham Stoddart-Stones: So, if you go into the column.
177 00:13:00.940 --> 00:13:03.620 Graham Stoddart-Stones: Tab at the top, click on the little down arrow.
178 00:13:04.500 --> 00:13:09.890 Graham Stoddart-Stones: And see what we've got. Can you scroll down, David? You've got town or parish or something there.
179 00:13:10.990 --> 00:13:16.199 Graham Stoddart-Stones: So you've got a locality name, which may be you… I'm not sure if you…
180 00:13:16.200 --> 00:13:17.540 David Morgan-Jones: Oh, locality name, yeah.
181 00:13:17.540 --> 00:13:23.160 Graham Stoddart-Stones: Yeah, so I'm just thinking… well, I'm looking along, if you… can you scroll across to the right of your screen?
182 00:13:23.160 --> 00:13:24.259 David Morgan-Jones: Yep. Here we go.
183 00:13:25.050 --> 00:13:30.600 Graham Stoddart-Stones: Keep going, keep going, keep going, keep going. It's gotta be town name, hasn't it, for you? Do you…
184 00:13:31.150 --> 00:13:32.249 Graham Stoddart-Stones: You want new shot?
185 00:13:33.060 --> 00:13:33.950 Graham Stoddart-Stones: Yeah.
186 00:13:33.950 --> 00:13:35.880 tristram cary: You want the parish, you want the parish.
187 00:13:36.150 --> 00:13:36.939 David Morgan-Jones: Well, the power.
188 00:13:36.940 --> 00:13:39.870 Graham Stoddart-Stones: Don't think we have a parish. I don't see a parish, do you?
189 00:13:39.870 --> 00:13:43.350 Stuart Bacon: It's not a dataset you… you can…
190 00:13:44.410 --> 00:13:48.260 Stuart Bacon: Sort of, yeah, using the table view, unfortunately. Gestron?
191 00:13:48.980 --> 00:13:54.280 tristram cary: Can't you go… I'm confused now, because I thought if you go into your home.
192 00:13:55.150 --> 00:13:57.930 tristram cary: Screen, and you click.
193 00:13:58.100 --> 00:14:00.780 tristram cary: Can't you do data extract on the parish?
194 00:14:01.350 --> 00:14:03.159 Graham Stoddart-Stones: We can try that one.
195 00:14:03.160 --> 00:14:04.809 tristram cary: I think that works. I think I've done it.
196 00:14:04.810 --> 00:14:05.510 Graham Stoddart-Stones: So…
197 00:14:05.930 --> 00:14:07.140 David Morgan-Jones: Tell me how to get there.
198 00:14:07.140 --> 00:14:10.249 Graham Stoddart-Stones: So, close that off by clicking on the X.
199 00:14:10.860 --> 00:14:14.549 Graham Stoddart-Stones: Come out of table view by clicking on the X at its top right.
200 00:14:14.820 --> 00:14:15.340 Graham Stoddart-Stones: Yup.
201 00:14:15.940 --> 00:14:21.989 Graham Stoddart-Stones: And click anywhere in your parish, which is sadly, you're fine. Just click anywhere.
202 00:14:22.090 --> 00:14:22.570 David Morgan-Jones: Yup.
203 00:14:24.490 --> 00:14:25.500 David Morgan-Jones: From that?
204 00:14:25.500 --> 00:14:29.720 Graham Stoddart-Stones: So that's working. Oh, maybe you haven't got parish layers turned on? I'm probably…
205 00:14:29.720 --> 00:14:33.220 tristram cary: Hell, why can't we go back to his home screen?
206 00:14:33.580 --> 00:14:34.950 Graham Stoddart-Stones: Yeah, we can do that.
207 00:14:35.920 --> 00:14:38.700 Graham Stoddart-Stones: Oh, because he doesn't got it turned on, is he?
208 00:14:40.480 --> 00:14:41.310 David Morgan-Jones: Holmes Group.
209 00:14:41.310 --> 00:14:48.240 Graham Stoddart-Stones: There you go, that's the parish, and now if you go into the, the data extract isn't there.
210 00:14:48.870 --> 00:14:50.649 tristram cary: It is top right, isn't it?
211 00:14:50.860 --> 00:14:51.390 tristram cary: Nope.
212 00:14:51.390 --> 00:14:53.379 Graham Stoddart-Stones: Okay, that's right, yup. So, if you go on there…
213 00:14:53.380 --> 00:14:54.180 tristram cary: like that.
214 00:14:54.600 --> 00:14:56.989 Graham Stoddart-Stones: Then extract from address space.
215 00:15:00.950 --> 00:15:03.160 Graham Stoddart-Stones: So, yeah, second one down.
216 00:15:05.330 --> 00:15:07.899 Graham Stoddart-Stones: And I think that's probably all you need.
217 00:15:07.900 --> 00:15:08.520 tristram cary: press run.
218 00:15:08.520 --> 00:15:10.239 Graham Stoddart-Stones: This close run down at the bottom.
219 00:15:12.390 --> 00:15:15.479 Graham Stoddart-Stones: And they are, they're all the buildings in your parish.
220 00:15:15.480 --> 00:15:18.670 Stuart Bacon: And you can export that in the bottom left to a spreadsheet.
221 00:15:19.120 --> 00:15:19.730 tristram cary: Yep.
222 00:15:19.730 --> 00:15:24.490 Graham Stoddart-Stones: And then just compare that with the list of houses that do have EPCs.
223 00:15:25.330 --> 00:15:30.389 David Morgan-Jones: Oh, right, okay, so I could just do a search. Oh, right, okay, cool.
224 00:15:30.390 --> 00:15:31.719 Graham Stoddart-Stones: We'll just do a compare.
225 00:15:31.720 --> 00:15:33.030 David Morgan-Jones: Alright, brilliant.
226 00:15:33.030 --> 00:15:33.660 Graham Stoddart-Stones: Yeah.
227 00:15:34.070 --> 00:15:38.859 tristram cary: And you can use that, yeah, and you can add, of course, you can add columns to that.
228 00:15:39.120 --> 00:15:40.170 tristram cary: spreadsheet.
229 00:15:40.200 --> 00:15:49.749 Graham Stoddart-Stones: To say APC rating… You can do a lookup on something that's common to both data sheets, which might be the address, it might.
230 00:15:50.050 --> 00:15:53.930 David Morgan-Jones: Yeah, I'll find, I'll find a key, key field to, filter…
231 00:15:53.930 --> 00:15:58.470 Graham Stoddart-Stones: The real one, the best feeling of the lot is the UPRN, because that's unique.
232 00:15:58.620 --> 00:16:03.740 Graham Stoddart-Stones: So that would be the best one. If the government list comes down with a UPRN, you're in Tova.
233 00:16:05.070 --> 00:16:08.879 David Morgan-Jones: So… Second column from the… Oh, yeah, got you, the UPRN there, yeah.
234 00:16:08.880 --> 00:16:09.530 Graham Stoddart-Stones: up.
235 00:16:09.640 --> 00:16:16.230 David Morgan-Jones: Okay, so I'll, I'll try and see if I… I'll download the, gov.uk…
236 00:16:16.230 --> 00:16:19.119 Graham Stoddart-Stones: Yeah, I think I might have it somewhere, but I'll…
237 00:16:19.250 --> 00:16:22.060 Graham Stoddart-Stones: If someone else would like to chat, I'll just go and look for him.
238 00:16:23.130 --> 00:16:25.230 Graham Stoddart-Stones: Although I can't remember where I put it.
239 00:16:25.810 --> 00:16:29.530 David Morgan-Jones: It's alright, if you can just chat me the URL, I'll download it.
240 00:16:29.530 --> 00:16:29.970 tristram cary: I'll take.
241 00:16:33.590 --> 00:16:36.300 Peter Lewis: Can anybody tell me where that address list is?
242 00:16:36.520 --> 00:16:40.070 Peter Lewis: comes from. Who is the owner of that address list?
243 00:16:40.070 --> 00:16:40.780 Stuart Bacon: Royal Miami.
244 00:16:40.780 --> 00:16:45.840 Peter Lewis: errors in it. Where does one go to have them amended?
245 00:16:47.630 --> 00:16:49.960 Graham Stoddart-Stones: I should think Ordnance Survey.
246 00:16:51.830 --> 00:16:53.209 Peter Lewis: On that address list, really?
247 00:16:54.150 --> 00:16:58.020 Stuart Bacon: The address space comes from Royal Mail, doesn't it? Isn't that what it says in the.
248 00:16:58.020 --> 00:16:59.659 Peter Lewis: Not a path, it's not path.
249 00:16:59.660 --> 00:17:00.020 tristram cary: Oh my god.
250 00:17:00.020 --> 00:17:02.030 Peter Lewis: It's not the postal address file, it's not path.
251 00:17:02.780 --> 00:17:03.700 Peter Lewis: Surely.
252 00:17:05.859 --> 00:17:07.519 tristram cary: No, it's not taxed, but…
253 00:17:08.160 --> 00:17:09.329 Retired Clerk: Postman, Pat.
254 00:17:09.609 --> 00:17:16.809 Peter Lewis: No, PATH, P-A-F, not P-A-T. Postal address file. It's not… I don't think it's the postal address file.
255 00:17:17.249 --> 00:17:26.949 Peter Lewis: Because it's identifying properties in the parish that are not addresses in my parish, as an example. And I'm just… I'm intrigued by that.
256 00:17:49.240 --> 00:17:51.450 Stuart Bacon: No, it doesn't take…
257 00:17:51.450 --> 00:17:58.829 Peter Lewis: I couldn't see anywhere where it indicated who was the ultimate owner of that data.
258 00:17:59.720 --> 00:18:01.610 Stuart Bacon: To find… to find your answer…
259 00:18:02.030 --> 00:18:07.059 Stuart Bacon: Click on Help, and create a ticket, and ask Chris a question.
260 00:18:07.060 --> 00:18:08.340 Peter Lewis: Yep, I can do that.
261 00:18:09.670 --> 00:18:10.279 Peter Lewis: Thank you.
262 00:18:17.360 --> 00:18:19.660 tristram cary: Have I missed anything vitally important?
263 00:18:20.030 --> 00:18:22.289 Stuart Bacon: Where the address-based data comes from.
264 00:18:23.820 --> 00:18:27.119 tristram cary: comes from an ordinary survey.
265 00:18:28.790 --> 00:18:31.080 Graham Stoddart-Stones: Well, that makes us two against the rest of them.
266 00:18:34.190 --> 00:18:35.430 tristram cary: Who else does it come from?
267 00:18:38.490 --> 00:18:40.559 Retired Clerk: We saw Coachman Pat.
268 00:18:40.750 --> 00:18:47.400 Peter Lewis: The address is in the address space. From ordinance… really? That's not an ordinance survey issue, is it?
269 00:18:48.370 --> 00:18:51.120 Peter Lewis: It's a local authority issue, together with the post office, together with.
270 00:18:51.120 --> 00:18:52.920 tristram cary: Oh, yeah, well, that's a… you know…
271 00:18:52.920 --> 00:18:54.940 Peter Lewis: But it's not path, that's my point.
272 00:18:55.390 --> 00:18:57.999 Peter Lewis: So I'm just… I think it might be local authority.
273 00:18:58.840 --> 00:19:12.279 tristram cary: No, I think that that's a long-running battle. So the local property gassoteer, whatever it was called, you know, there was always a fuss, because Ordnance Service said, well, we own this thing, even though the data's being provided through the
274 00:19:12.410 --> 00:19:18.569 tristram cary: the, L… LPRN, or whatever it's called. Yeah. But I think they were overruled.
275 00:19:20.590 --> 00:19:25.319 Peter Lewis: So if it's wrong, then you think it's a… it's an ordinary survey issue, then, you?
276 00:19:25.470 --> 00:19:26.919 tristram cary: I, I think so.
277 00:19:26.920 --> 00:19:27.490 Peter Lewis: Okay.
278 00:19:28.950 --> 00:19:29.990 Peter Lewis: I'll let you know.
279 00:19:29.990 --> 00:19:33.490 Graham Stoddart-Stones: They'll certainly answer you if they… if you send them a question.
280 00:19:33.490 --> 00:19:37.069 tristram cary: Why, you've got, you've got some wrong bum data, have you?
281 00:19:37.070 --> 00:19:39.000 Peter Lewis: Yeah, absolutely, yeah, yeah.
282 00:19:39.370 --> 00:19:39.860 Peter Lewis: Yeah.
283 00:19:39.860 --> 00:19:43.419 tristram cary: That's been… that's been addressed in your local property cassette?
284 00:19:43.880 --> 00:19:56.279 Peter Lewis: No, if I go to my… so I was just playing with this, so I looked at my own property. I thought, that's a good place to start when you're looking… trying to work out what's going on, and it's wrong. You know, I apparently have an annex, which is my garage.
285 00:19:56.460 --> 00:20:05.249 Peter Lewis: it's not my garage. So it's just… it's wrong, in that sense. So it's positionally wrong.
286 00:20:06.250 --> 00:20:07.750 Peter Lewis: Yeah. So…
287 00:20:08.190 --> 00:20:12.069 Retired Clerk: Have you checked it against your deeds? Stroke the land?
288 00:20:12.070 --> 00:20:16.399 Peter Lewis: I do have an annex, I do have an annex, but it's not the… it's not as marked on the map.
289 00:20:16.800 --> 00:20:21.099 tristram cary: But of course, all this is changing now, because of the, whatever they call it now, the, national…
290 00:20:21.100 --> 00:20:22.080 Graham Stoddart-Stones: Yeah.
291 00:20:22.080 --> 00:20:23.310 tristram cary: NGD.
292 00:20:23.790 --> 00:20:36.489 tristram cary: National Geographical database, which is adding all sorts of, you know, there's going to be data attached to the UPRNs of all sorts of things, like the date of the build of the house, and all that stuff.
293 00:20:38.530 --> 00:20:41.290 chris edwards: When is that due… when is that due to kick in?
294 00:20:42.210 --> 00:20:53.669 tristram cary: That's a very good question. I'm not sure there's a date. There's… Orland Survey's got quite a lot about it in their website, and I think they're waiting until they're… because they want the partner network, a big, huge reversal of
295 00:20:53.720 --> 00:21:03.249 tristram cary: policy over the last 10 years. They want the partner network to take responsibility for providing that data to the market.
296 00:21:03.670 --> 00:21:13.080 tristram cary: And their intention is to shut down, you know, the conventional master map, and then have products that are produced by the partner network.
297 00:21:13.320 --> 00:21:18.030 tristram cary: And Ordnance Airbby itself will not take part in those products.
298 00:21:18.700 --> 00:21:31.460 tristram cary: But, just to get back to the reason for the… nobody quite knows the date is that, it depends on when the partner network can get access to the data and create products.
299 00:21:32.570 --> 00:21:33.130 chris edwards: Thank you.
300 00:21:35.540 --> 00:21:48.340 tristram cary: But I… and I think… I think OS run quite a lot of workshops on it now, but for every… for anybody, so if you… if you look at… if you… if you put NGD into the OS website, you might find quite a lot of information and future news.
301 00:21:52.870 --> 00:21:59.360 Peter Lewis: Yeah, I've seen that address about the Somerset Council address change info thing, which you've just put on… somebody just put that on the notes?
302 00:22:00.140 --> 00:22:07.169 Retired Clerk: Yeah, because they say they're responsible for providing official addresses to all residential and commercial properties.
303 00:22:07.170 --> 00:22:10.549 Peter Lewis: Yeah, so that's local authority thing. That's what I thought, it must be local authority.
304 00:22:10.550 --> 00:22:16.550 Retired Clerk: They'll charge you for the privilege of painting your info. Yeah, yeah, no, that's, that's fine.
305 00:22:16.550 --> 00:22:22.810 Peter Lewis: But, it's interesting, they've got the address, but just the location is wrong.
306 00:22:24.740 --> 00:22:25.910 Peter Lewis: That's fair enough.
307 00:22:34.700 --> 00:22:35.550 David Morgan-Jones: Graham?
308 00:22:35.550 --> 00:22:36.560 Graham Stoddart-Stones: Yeah, huh?
309 00:22:36.560 --> 00:22:43.060 David Morgan-Jones: I've found the site, I've downloaded it, you can download it by, district Council.
310 00:22:43.630 --> 00:22:44.650 Graham Stoddart-Stones: Okay.
311 00:22:44.650 --> 00:22:49.640 David Morgan-Jones: So I've only downloaded 8 megs, as opposed to, X many gigs.
312 00:22:49.640 --> 00:22:51.060 Graham Stoddart-Stones: 5 gigs, yeah.
313 00:22:51.180 --> 00:22:55.279 Graham Stoddart-Stones: So, have you… could you just slip the address in the chat, please?
314 00:22:55.280 --> 00:22:55.970 David Morgan-Jones: Yup.
315 00:22:57.580 --> 00:23:02.590 Graham Stoddart-Stones: Who's… I've succeeded in losing my copy, or not being able to find it, at least.
316 00:23:18.070 --> 00:23:21.910 Graham Stoddart-Stones: Chris, the first 20 minutes of the meeting are up, and you haven't asked a question yet.
317 00:23:24.500 --> 00:23:30.509 chris edwards: I'll give you a low-key question, or I'll ask a low-key question.
318 00:23:30.510 --> 00:23:31.110 Graham Stoddart-Stones: Huh? Okay.
319 00:23:31.850 --> 00:23:34.830 chris edwards: Where are we?
320 00:23:38.200 --> 00:23:41.579 chris edwards: Right, let me just show you what I've been up to.
321 00:23:41.730 --> 00:23:43.180 chris edwards: Yesterday.
322 00:23:45.110 --> 00:23:47.880 Graham Stoddart-Stones: Oh my, speed indication devices.
323 00:23:47.880 --> 00:23:51.029 chris edwards: So, we've acquired another SID.
324 00:23:51.510 --> 00:23:56.320 chris edwards: And we've got to show locations where we want the posts to be put.
325 00:23:56.910 --> 00:24:01.580 chris edwards: So, I print… I printed off a map with these locations.
326 00:24:02.000 --> 00:24:13.089 chris edwards: So, if I, if I go into, for instance, print, And then…
327 00:24:13.770 --> 00:24:19.789 chris edwards: I've sh… down here, one of the options, Show Center Coordinates.
328 00:24:19.790 --> 00:24:20.190 Graham Stoddart-Stones: Yep.
329 00:24:20.190 --> 00:24:22.630 chris edwards: So what does that actually mean?
330 00:24:22.860 --> 00:24:26.579 Graham Stoddart-Stones: He'll give you the coordinates of the middle of that little map.
331 00:24:27.160 --> 00:24:30.160 chris edwards: Yeah, but where would they be shown? Because, I mean, I'll show you…
332 00:24:30.160 --> 00:24:34.509 Graham Stoddart-Stones: You probably need to print it, don't you? Select it first, Chris. Whoops.
333 00:24:34.510 --> 00:24:35.145 Retired Clerk: like…
334 00:24:38.260 --> 00:24:39.069 tristram cary: Yeah, I haven't loaded.
335 00:24:39.070 --> 00:24:39.590 chris edwards: fixed.
336 00:24:39.900 --> 00:24:43.840 chris edwards: I was wondering whether the coordinates would actually be printed.
337 00:24:43.840 --> 00:24:47.049 Graham Stoddart-Stones: Well, they're not. I think they might be, but you haven't selected it, Chris.
338 00:24:47.050 --> 00:24:48.369 tristram cary: Yeah, you didn't select it.
339 00:24:48.770 --> 00:24:51.250 chris edwards: So, let's go… go back.
340 00:24:51.370 --> 00:24:53.140 Graham Stoddart-Stones: You have to select it.
341 00:24:54.310 --> 00:24:55.179 Stuart Bacon: Click on it.
342 00:24:55.520 --> 00:24:57.040 tristram cary: No.
343 00:24:57.040 --> 00:24:59.610 Graham Stoddart-Stones: To the left hand… Chris, go to the left-hand side.
344 00:24:59.720 --> 00:25:02.580 Graham Stoddart-Stones: In the column, Show Center Coordinates, that one.
345 00:25:02.930 --> 00:25:03.979 Graham Stoddart-Stones: There you go.
346 00:25:04.870 --> 00:25:05.610 Stuart Bacon: Right?
347 00:25:06.900 --> 00:25:07.670 chris edwards: Yeah?
348 00:25:08.490 --> 00:25:11.179 Graham Stoddart-Stones: We don't know if it's gonna do anything, we just hope it will.
349 00:25:11.180 --> 00:25:13.649 chris edwards: Oh, blah, I want the legend as well.
350 00:25:13.890 --> 00:25:14.880 Graham Stoddart-Stones: Right, well…
351 00:25:15.810 --> 00:25:17.770 Stuart Bacon: Now click Print again.
352 00:25:24.950 --> 00:25:26.050 Stuart Bacon: Scroll down.
353 00:25:26.500 --> 00:25:28.389 Stuart Bacon: And that's that bottom one.
354 00:25:29.400 --> 00:25:32.519 chris edwards: So, let me get rid of everybody's photographs.
355 00:25:32.520 --> 00:25:33.680 Graham Stoddart-Stones: It's in the… it's in the…
356 00:25:33.680 --> 00:25:34.730 chris edwards: I would have thought.
357 00:25:34.730 --> 00:25:38.159 Graham Stoddart-Stones: Chris, it's on the top… Chris, it's on the top line.
358 00:25:38.320 --> 00:25:40.590 Graham Stoddart-Stones: go to the parish online box, and go…
359 00:25:40.590 --> 00:25:41.230 chris edwards: Oh, damn.
360 00:25:41.230 --> 00:25:42.010 Graham Stoddart-Stones: There you go.
361 00:25:42.260 --> 00:25:45.739 chris edwards: Oh, right! So if I wanted to print the three…
362 00:25:45.890 --> 00:25:51.280 chris edwards: three coordinates. I can't do that, can I? It's just the one.
363 00:25:51.860 --> 00:25:53.690 tristram cary: But you have a different scale.
364 00:25:53.690 --> 00:25:56.460 Retired Clerk: No, that's not… that's nothing to do with your…
365 00:25:56.460 --> 00:25:58.199 tristram cary: the information of the SIDS.
366 00:25:58.210 --> 00:26:00.090 Graham Stoddart-Stones: That's the map. It's pretty the map.
367 00:26:00.570 --> 00:26:02.770 Graham Stoddart-Stones: The center of… where the center of your map is.
368 00:26:02.770 --> 00:26:03.360 chris edwards: Hmm.
369 00:26:03.860 --> 00:26:06.009 Andrew Clegg: Why is center misspelt?
370 00:26:06.690 --> 00:26:08.540 Stuart Bacon: It's Americanized.
371 00:26:09.580 --> 00:26:18.269 tristram cary: Tristram, you're in trouble. You've got to be very.
372 00:26:18.270 --> 00:26:19.999 Graham Stoddart-Stones: Preacherous behavior, you know?
373 00:26:20.000 --> 00:26:21.849 chris edwards: He's off with his head.
374 00:26:22.190 --> 00:26:29.949 chris edwards: Kirsten, I didn't understand I didn't understand your answer. If we refer to this coordinate. Yeah. Yeah.
375 00:26:30.520 --> 00:26:33.999 chris edwards: Is that the center of the map itself?
376 00:26:34.000 --> 00:26:34.700 tristram cary: Yes.
377 00:26:35.200 --> 00:26:37.439 chris edwards: Oh, right. Well, I don't want that at all.
378 00:26:37.440 --> 00:26:40.729 tristram cary: So what do… you want to say, you want the Sikora?
379 00:26:41.000 --> 00:26:41.609 chris edwards: That's point.
380 00:26:41.840 --> 00:26:43.930 chris edwards: Why do you want each of these points?
381 00:26:44.130 --> 00:26:47.739 tristram cary: Yeah, well, that's… that's not a function, that's not a print function.
382 00:26:47.740 --> 00:26:49.070 chris edwards: Oh, right.
383 00:26:49.480 --> 00:26:52.270 chris edwards: I've never even heard of…
384 00:26:52.960 --> 00:27:01.009 chris edwards: Let me just get rid of this. I never even heard show center coordinates before, so that's a new one on me.
385 00:27:01.010 --> 00:27:01.820 Graham Stoddart-Stones: Okay.
386 00:27:02.020 --> 00:27:02.390 chris edwards: Mmm.
387 00:27:02.390 --> 00:27:02.740 Graham Stoddart-Stones: So, it'.
388 00:27:02.740 --> 00:27:07.040 tristram cary: So you can have a north arrow, it's just, you know, sort of stuff you can put around the map, you can have a north.
389 00:27:07.040 --> 00:27:08.269 chris edwards: Yeah, I, I always…
390 00:27:08.270 --> 00:27:09.030 tristram cary: He's an author.
391 00:27:09.060 --> 00:27:10.070 chris edwards: Of course.
392 00:27:10.070 --> 00:27:14.719 Graham Stoddart-Stones: I think it's that you… Chris is quite right, that's a new function, isn't it? I hadn't seen that one before.
393 00:27:14.720 --> 00:27:16.110 tristram cary: Oh, I have no idea.
394 00:27:16.110 --> 00:27:16.660 Graham Stoddart-Stones: Probably.
395 00:27:17.140 --> 00:27:17.800 tristram cary: I love it.
396 00:27:18.100 --> 00:27:21.039 tristram cary: It's good to know Paris Reline's adding functions all the time.
397 00:27:21.040 --> 00:27:24.989 Graham Stoddart-Stones: Well, they have this irritating habit of not telling you that they've done it.
398 00:27:25.440 --> 00:27:26.560 tristram cary: Until the next newsletter.
399 00:27:26.560 --> 00:27:28.720 Graham Stoddart-Stones: You just come across it by accident.
400 00:27:28.720 --> 00:27:34.320 tristram cary: It's in the newsletter, surely. Sometimes, sometimes not. You've got to keep your notes.
401 00:27:35.850 --> 00:27:36.230 Graham Stoddart-Stones: Chris.
402 00:27:36.230 --> 00:27:38.739 Stuart Bacon: If he wants you to…
403 00:27:39.270 --> 00:27:43.740 Graham Stoddart-Stones: Chris, if you wanted to print the coordinates, you could use the coordinates as a label.
404 00:27:43.920 --> 00:27:45.770 Graham Stoddart-Stones: And then it'll come out on the map.
405 00:27:46.870 --> 00:27:58.770 chris edwards: Yes, I've actually done… I've done the numbering of the three SID post locations with number 1, number 2, number 3, but I suppose I could add the coordinates as well.
406 00:27:59.310 --> 00:28:04.729 Graham Stoddart-Stones: Yeah, or you could add a field for the coordinates, and then just make that field the label field.
407 00:28:04.900 --> 00:28:05.560 chris edwards: Yep.
408 00:28:05.700 --> 00:28:06.470 chris edwards: Yup.
409 00:28:06.750 --> 00:28:10.170 tristram cary: But do you also want the center point of those three coordinates?
410 00:28:10.170 --> 00:28:13.470 Graham Stoddart-Stones: Nope, that was just… And this is…
411 00:28:13.470 --> 00:28:17.369 chris edwards: Well, I mean, we wouldn't want to go that specific, no.
412 00:28:17.370 --> 00:28:18.180 tristram cary: Could, yeah.
413 00:28:18.180 --> 00:28:18.790 chris edwards: No.
414 00:28:23.770 --> 00:28:27.040 Graham Stoddart-Stones: Well, it was a very good question, Chris, and it occupied at least 3 minutes.
415 00:28:27.660 --> 00:28:28.470 Graham Stoddart-Stones: Thank you.
416 00:28:31.980 --> 00:28:35.939 Graham Stoddart-Stones: So, Peter, the onus is on you now to say, if you've…
417 00:28:36.310 --> 00:28:42.099 Graham Stoddart-Stones: You're sort of having a nodding acquaintance with Parrish Online. Is there anything in particular you'd like to see about it?
418 00:28:42.640 --> 00:28:55.839 Peter Lewis: No, do you know, I actually spent a couple of hours yesterday on the train up to London having a play with it, and it's all quite intuitive, actually, I think. I was quite impressed, the fact that it was really very intuitive.
419 00:28:55.840 --> 00:29:02.690 Peter Lewis: But, just a simple little thing that I… that question, just rather than me spending hours searching for that answer, I thought you might know it, but…
420 00:29:02.690 --> 00:29:06.179 Peter Lewis: There's a ticket for that sort of thing, that's very straightforward.
421 00:29:06.180 --> 00:29:12.820 Graham Stoddart-Stones: Would you write that down as a certificate and send it to me? Because I'd like to use it for everybody who says, I have no idea how this thing works.
422 00:29:12.820 --> 00:29:13.140 Peter Lewis: Nice job.
423 00:29:13.140 --> 00:29:21.599 Graham Stoddart-Stones: Well, I suppose it's intuitive for people that are, you know, you've got to know how to know what a pencil is before you can write, haven't you?
424 00:29:21.640 --> 00:29:22.160 Stuart Bacon: Whoa!
425 00:29:22.340 --> 00:29:26.860 Peter Lewis: It's intuitive if you're used to that sort of,
426 00:29:27.690 --> 00:29:42.099 Peter Lewis: logic of doing things, but I know, I'm intrigued as to what people generally use. Part of the reason I joined the band was to see what people are using it for. I mean, you know, we've got a tiny weeny parish here. I don't really think it adds a great deal to us.
427 00:29:42.210 --> 00:29:48.179 Peter Lewis: I mean, it's as cheap as chips in that sense, it doesn't matter. But I'm not sure…
428 00:29:48.180 --> 00:29:54.999 Graham Stoddart-Stones: do it, this is the clue for your… some of your public maps, because they're fantastic examples of what you can do with it.
429 00:29:55.480 --> 00:29:58.670 tristram cary: Do you… are you working on a neighbourhood plan, or do you have one?
430 00:29:59.510 --> 00:30:03.039 Peter Lewis: We're not working on one at the moment, but, we do have one, yeah.
431 00:30:03.040 --> 00:30:08.990 tristram cary: Because when you do, I think Parish Online's very useful for that, because it keeps, you know, it keeps… you can keep all your data up to date.
432 00:30:08.990 --> 00:30:13.710 Peter Lewis: Yeah, yeah, yeah. No, I can see that. I can see that for specific projects, or…
433 00:30:13.710 --> 00:30:32.870 Peter Lewis: tasks like that, then it would be, you know, it's a good way to do it. The issue I think we will have is that we have a parish clerk who supports about four different parishes, and they, you know, for her benefit, it's no point in one of them doing it and not the other three, if you follow that thinking. So, you know, it's one of those…
434 00:30:33.810 --> 00:30:49.379 Peter Lewis: bigger than me, bigger than me, problem to resolve, if you like. But, actually, no, I was… I don't know who… I mean, I'd never seen it before this week, Parish Online, never come across my… come across my table at all, and I thought, well, that's really…
435 00:30:49.560 --> 00:30:52.420 Peter Lewis: Actually, quite an interesting product.
436 00:30:52.740 --> 00:30:59.690 Peter Lewis: That may have a, you know, that may have a use, and it's quite, it's quite, well, I thought, quite intuitively easy to, get your head around.
437 00:30:59.690 --> 00:31:03.209 Graham Stoddart-Stones: So, have you got the chat facility up on your screen, Peter?
438 00:31:03.910 --> 00:31:04.680 Peter Lewis: I have, yeah.
439 00:31:04.680 --> 00:31:09.719 Graham Stoddart-Stones: Well, if you look at some of those links, click on any of those links that Stuart's just put up.
440 00:31:10.190 --> 00:31:15.239 Graham Stoddart-Stones: And I think they're fabulous examples of what you can use Parish Online for.
441 00:31:17.700 --> 00:31:19.390 Peter Lewis: Yeah, I'm just… I've just clicked.
442 00:31:19.930 --> 00:31:20.410 Graham Stoddart-Stones: Right.
443 00:31:20.410 --> 00:31:23.930 Peter Lewis: Yeah, yeah, yeah, yeah, yeah, no, absolutely. I, I.
444 00:31:24.430 --> 00:31:30.680 Graham Stoddart-Stones: And this is a public website, so anybody in the… well, anybody in the world can actually click on that
445 00:31:31.010 --> 00:31:38.079 Graham Stoddart-Stones: data and see the link, and you can select the layers on or off. If you've clicked on the parish layers button in the.
446 00:31:38.310 --> 00:31:39.470 Stuart Bacon: Top left-hand corner.
447 00:31:39.470 --> 00:31:40.940 Graham Stoddart-Stones: Up to the top left-hand corner, yep.
448 00:31:40.940 --> 00:31:42.920 Peter Lewis: Yeah, yeah, yeah, yeah, yeah, yeah, yeah.
449 00:31:44.000 --> 00:31:52.559 Peter Lewis: No, I got to that, I understood that, I can see, I mean, I can see. It's sort of, think, think of a, think of a use, and it's probably available, I got that.
450 00:31:52.690 --> 00:31:56.860 Peter Lewis: Funnily enough. But, .
451 00:31:56.860 --> 00:32:02.110 Graham Stoddart-Stones: The other thing is to look at the hundreds of layers and see if you can say that layer would be useful to us, and that one wouldn't.
452 00:32:02.960 --> 00:32:20.540 David Morgan-Jones: Graham, could, I really like this function, I must admit, we need to do it, because we're doing, as you showed last time, about how to create, sort of, biodiversity markers all over the place. How do you make… how do you actually link it into your, parish online?
453 00:32:20.540 --> 00:32:24.010 David Morgan-Jones: parish website. So if I wanted to put a link to a map.
454 00:32:24.770 --> 00:32:28.539 David Morgan-Jones: Like the one that I'm just playing with in the chat.
455 00:32:29.490 --> 00:32:32.229 Graham Stoddart-Stones: Well, there you go, so why don't you talk to the author?
456 00:32:32.380 --> 00:32:33.290 Graham Stoddart-Stones: Thanks, sir.
457 00:32:33.820 --> 00:32:36.039 Graham Stoddart-Stones: Stuart, I'm bound to rape you in somehow.
458 00:32:36.040 --> 00:32:42.979 Stuart Bacon: Yep, no, well, okay, so, yep, here we go, bear with me one second, and…
459 00:32:43.510 --> 00:32:46.909 Peter Lewis: presumably you can just embed that code into your HTML, or whatever.
460 00:32:47.050 --> 00:32:49.779 Stuart Bacon: Well, yes, but the system will do it for you.
461 00:32:49.780 --> 00:32:50.360 Peter Lewis: Yeah, okay.
462 00:32:50.360 --> 00:32:56.180 Stuart Bacon: So… Top right-hand corner on the cogwheel for administration.
463 00:32:56.390 --> 00:32:57.380 David Morgan-Jones: Yup.
464 00:32:57.600 --> 00:32:59.329 Stuart Bacon: And then…
465 00:32:59.330 --> 00:32:59.960 Peter Lewis: Yeah.
466 00:33:00.530 --> 00:33:05.130 Stuart Bacon: Create a… or click on the public maps on the left-hand side.
467 00:33:05.350 --> 00:33:12.230 Stuart Bacon: I've created some, but I mean, we can run through the process of how we do that.
468 00:33:12.460 --> 00:33:13.510 Stuart Bacon: as well.
469 00:33:13.650 --> 00:33:14.440 David Morgan-Jones: Right.
470 00:33:16.270 --> 00:33:32.090 Stuart Bacon: So, clicking on the plus sign there opens up the option to determine the style of mapping in which you're going to use, whether you want it to be using the aerial imagery, more detailed, or a basic sort of open data mapping.
471 00:33:32.240 --> 00:33:39.979 David Morgan-Jones: Well, I'll tell you what, let's work on a real example, Stuart. Why don't we look at all your EPC, data?
472 00:33:41.950 --> 00:33:44.000 David Morgan-Jones: You're mapping for your EPC.
473 00:33:46.180 --> 00:33:51.639 Stuart Bacon: Just trying to think which bike swamp would be easier. Go for that one, yes. Yeah.
474 00:33:52.130 --> 00:33:59.760 Stuart Bacon: So we're looking at… On it, in the next one.
475 00:34:00.000 --> 00:34:05.660 Stuart Bacon: Okay, so there's nothing… is there anything else you want with the EPC data?
476 00:34:05.860 --> 00:34:19.689 David Morgan-Jones: No, I just want to show which houses have EPC, and I'd like to show the ones that, the two layers would be the one… the EPC and the EPC date, so that it shows all the out-of-date EPCs.
477 00:34:23.080 --> 00:34:23.630 Graham Stoddart-Stones: Pacific.
478 00:34:23.630 --> 00:34:24.839 tristram cary: It is so sticky.
479 00:34:24.840 --> 00:34:25.630 David Morgan-Jones: You could age.
480 00:34:25.929 --> 00:34:26.730 Stuart Bacon: Yep.
481 00:34:26.730 --> 00:34:27.959 tristram cary: And current racing.
482 00:34:27.960 --> 00:34:28.400 Stuart Bacon: Currently.
483 00:34:28.400 --> 00:34:29.960 David Morgan-Jones: Current rating, yeah.
484 00:34:30.530 --> 00:34:34.370 Stuart Bacon: Or do you want potential to see, as well, for people?
485 00:34:34.370 --> 00:34:46.649 David Morgan-Jones: No, not for… not for this map, no, just… this is really just part of the initial PSYOPS to, show what, you know, show everybody what they're… what's going on within the parish.
486 00:34:47.790 --> 00:34:48.630 Stuart Bacon: Okay.
487 00:34:48.790 --> 00:34:51.820 Stuart Bacon: I mean, yeah. So I assume then…
488 00:34:52.600 --> 00:34:57.400 Stuart Bacon: the map to show the area I want to cover.
489 00:34:57.690 --> 00:34:59.160 Stuart Bacon: Yup.
490 00:34:59.520 --> 00:35:06.499 Stuart Bacon: And I mean, if I wanted to take that right down to start initially on a few houses, you can do, or…
491 00:35:06.800 --> 00:35:19.220 Stuart Bacon: yeah, do it for the whole of, the built-up area of a parish, or the whole area of the parish, however you want to do that. Yeah. Click next, then,
492 00:35:23.020 --> 00:35:28.490 Stuart Bacon: Give it a name, because it won't save unless you do give it a name.
493 00:35:28.490 --> 00:35:28.870 David Morgan-Jones: Yep.
494 00:35:28.870 --> 00:35:30.219 Stuart Bacon: And determine…
495 00:35:30.220 --> 00:35:30.810 Graham Stoddart-Stones: Yo.
496 00:35:31.290 --> 00:35:35.000 Stuart Bacon: Determine which layer you want the map to start
497 00:35:35.250 --> 00:35:41.180 Stuart Bacon: showing. So, do you want both sets of data there? Probably not, is the.
498 00:35:41.440 --> 00:35:55.309 David Morgan-Jones: Well, what, yeah, just try the EPC certificate age, because it basically puts a little, circle around the EPC to show, whether it's red, amber, green, in other words, date, out of date, end date.
499 00:35:56.100 --> 00:36:01.850 Stuart Bacon: Yeah. No, I can do that, and then people can turn their current rating on or off. Okay, cool.
500 00:36:02.040 --> 00:36:05.550 Stuart Bacon: later. So, that then has created.
501 00:36:05.980 --> 00:36:06.790 David Morgan-Jones: the mock…
502 00:36:06.920 --> 00:36:26.639 Stuart Bacon: or hunky-dory, and you get two, two links then. You can either, copy the, the URL to share it and give anybody, just download that, and whatever on your website, and that now shows me…
503 00:36:28.210 --> 00:36:31.859 David Morgan-Jones: So, yeah, and you've got the layers on the left-hand side of the screen.
504 00:36:31.860 --> 00:36:32.190 Graham Stoddart-Stones: Yes.
505 00:36:32.190 --> 00:36:45.629 Stuart Bacon: So you either turn… because you've selected the, the current age and the, the current rate… sorry, the certificate age and the current rating is the choice of what we can offer. We can flick between those.
506 00:36:46.060 --> 00:36:51.429 Stuart Bacon: And that comes out as absolutely blank.
507 00:36:51.430 --> 00:36:52.260 David Morgan-Jones: Wonderful.
508 00:36:52.540 --> 00:36:56.049 tristram cary: Zoom in a bit. Zoom in a bit. I think you may… may be.
509 00:36:58.900 --> 00:36:59.520 Graham Stoddart-Stones: Nope.
510 00:36:59.840 --> 00:37:00.200 David Morgan-Jones: Nope.
511 00:37:01.300 --> 00:37:03.000 David Morgan-Jones: Oh, how interesting.
512 00:37:04.300 --> 00:37:07.670 Stuart Bacon: How bizarre!
513 00:37:08.360 --> 00:37:10.980 David Morgan-Jones: Right, who's got the ticket system up and running?
514 00:37:14.380 --> 00:37:15.090 Stuart Bacon: Well, no.
515 00:37:15.390 --> 00:37:19.530 Peter Lewis: Maybe you have to select them both before you create.
516 00:37:19.530 --> 00:37:19.920 Graham Stoddart-Stones: No.
517 00:37:19.920 --> 00:37:21.890 Peter Lewis: Takes the data with it, and then turn it off.
518 00:37:21.890 --> 00:37:30.840 Stuart Bacon: Well, no, it's pulled the data through, it's just there is no… Yeah, data there, to…
519 00:37:31.190 --> 00:37:32.479 Peter Lewis: Has it pulled it through?
520 00:37:32.910 --> 00:37:36.760 Peter Lewis: Let's pulled that bit through, because you'd select… maybe, I was, like, suggesting maybe because you'd selected…
521 00:37:36.760 --> 00:37:44.610 Stuart Bacon: What I was selecting was the… which… Which layer you start seeing.
522 00:37:44.930 --> 00:37:49.339 Stuart Bacon: So, I selected that it was just the certificate age.
523 00:37:49.340 --> 00:37:49.790 Peter Lewis: Yeah, yeah.
524 00:37:49.790 --> 00:37:53.979 Stuart Bacon: That we… Show in that map.
525 00:37:54.390 --> 00:37:58.229 tristram cary: Try the other way, try the other way around, Stuart, see if the data has been pulled through.
526 00:38:00.910 --> 00:38:03.230 Stuart Bacon: Yeah, sorry, just turn that on.
527 00:38:03.610 --> 00:38:06.910 Stuart Bacon: Current rating, that's empty, so I'll go back in.
528 00:38:07.270 --> 00:38:07.850 tristram cary: That's funny.
529 00:38:07.850 --> 00:38:08.779 Stuart Bacon: Is that one?
530 00:38:10.110 --> 00:38:12.230 Stuart Bacon: And we'll go back.
531 00:38:12.890 --> 00:38:14.380 Stuart Bacon: Both are there…
532 00:38:14.640 --> 00:38:16.000 tristram cary: Yeah, try that.
533 00:38:16.000 --> 00:38:17.209 Stuart Bacon: Try it that way.
534 00:38:20.130 --> 00:38:22.440 Stuart Bacon: So, that's now…
535 00:38:27.050 --> 00:38:27.620 Graham Stoddart-Stones: There it is.
536 00:38:27.620 --> 00:38:28.700 Stuart Bacon: Totally blank.
537 00:38:29.050 --> 00:38:30.279 Stuart Bacon: I'm not…
538 00:38:30.790 --> 00:38:35.960 David Morgan-Jones: Stuart, if you go into Parish Online itself,
539 00:38:36.720 --> 00:38:41.520 David Morgan-Jones: And… and let's go… let's go out of the public mapping and go into the normal mapping.
540 00:38:41.660 --> 00:38:44.809 David Morgan-Jones: On the, on the, on the GUI.
541 00:38:45.740 --> 00:38:46.350 Stuart Bacon: Yep.
542 00:38:47.650 --> 00:38:59.000 David Morgan-Jones: Yeah, if you go, yeah, out of there, into that, and then… then click those two, you'll see what I mean when you click… so if you do the current rating and certificate age.
543 00:38:59.160 --> 00:39:00.780 David Morgan-Jones: And then zoom in.
544 00:39:03.260 --> 00:39:05.359 David Morgan-Jones: Look, yeah.
545 00:39:05.760 --> 00:39:12.280 Stuart Bacon: No, sorry, I was just looking and seeing that both, yeah, both actually show up that, it just doesn't follow through to the public map.
546 00:39:12.280 --> 00:39:17.820 David Morgan-Jones: Yeah, yeah, that's right. So, can you see the little, little circular halos around the,
547 00:39:18.290 --> 00:39:20.200 David Morgan-Jones: the EPC scores.
548 00:39:20.200 --> 00:39:27.129 Stuart Bacon: Yeah, so, current certificate age, Has no recognisable…
549 00:39:27.430 --> 00:39:27.770 Graham Stoddart-Stones: Nature.
550 00:39:27.770 --> 00:39:29.280 Stuart Bacon: Legend to it.
551 00:39:29.280 --> 00:39:30.160 David Morgan-Jones: Right.
552 00:39:31.890 --> 00:39:34.760 Stuart Bacon: But looks like it's circles.
553 00:39:34.880 --> 00:39:39.579 Stuart Bacon: The map shows it as circles, but the legend picks up nothing.
554 00:39:40.570 --> 00:39:41.860 David Morgan-Jones: That's bad.
555 00:39:41.860 --> 00:39:42.510 Andrew Clegg: Did you…
556 00:39:42.510 --> 00:39:43.059 tristram cary: And the…
557 00:39:43.060 --> 00:39:47.810 Andrew Clegg: Far enough, in the, in the, public map?
558 00:39:48.660 --> 00:39:49.390 Stuart Bacon: Whoa.
559 00:39:49.590 --> 00:39:52.189 Stuart Bacon: I can come back to the public map.
560 00:39:52.190 --> 00:39:52.670 Andrew Clegg: Yeah.
561 00:39:53.710 --> 00:39:57.940 Graham Stoddart-Stones: No, he's quite right. It shows nothing in the certificate 8. I'm looking at mine.
562 00:39:57.960 --> 00:40:01.370 David Morgan-Jones: And in fact, what it's done is it's translated
563 00:40:01.570 --> 00:40:08.720 David Morgan-Jones: The, so on the online… on the GUI version, they come through as a square.
564 00:40:09.200 --> 00:40:14.029 David Morgan-Jones: And they're coming through as a circle, with a…
565 00:40:14.560 --> 00:40:20.920 David Morgan-Jones: Can you actually just click this certificate age again? Because they look as though they're coming through with a number.
566 00:40:21.300 --> 00:40:25.500 Stuart Bacon: Certificate age is coming through with a number of years.
567 00:40:25.720 --> 00:40:28.249 Stuart Bacon: But the current rating isn't showing.
568 00:40:28.250 --> 00:40:34.360 David Morgan-Jones: Yeah, can you just un… just take the current rate… oh yeah, the certificate… so just take the current rating away.
569 00:40:35.180 --> 00:40:35.740 Stuart Bacon: Yep.
570 00:40:36.280 --> 00:40:39.210 David Morgan-Jones: Oh, oh, you've got the certificate of age there.
571 00:40:39.510 --> 00:40:42.369 tristram cary: That's the age, it's got a color code, and it's got a year.
572 00:40:43.660 --> 00:40:47.600 tristram cary: Maybe, maybe on the, what happens if you click…
573 00:40:47.860 --> 00:40:51.020 David Morgan-Jones: Both of those, when you,
574 00:40:53.480 --> 00:40:58.670 David Morgan-Jones: Yeah, because it's giving you an age, it's giving you a number, not a grading.
575 00:40:59.060 --> 00:40:59.570 tristram cary: Yeah.
576 00:40:59.570 --> 00:41:01.880 Graham Stoddart-Stones: Well, it depends which one you turn on first.
577 00:41:03.460 --> 00:41:07.890 Graham Stoddart-Stones: Yeah, I, if you turn them both on, you tend to get the letter.
578 00:41:08.510 --> 00:41:10.749 David Morgan-Jones: So if you go back to the…
579 00:41:10.750 --> 00:41:13.359 Stuart Bacon: No letters. I'm getting nothing on…
580 00:41:13.360 --> 00:41:14.880 tristram cary: On the public map.
581 00:41:15.430 --> 00:41:21.880 Stuart Bacon: on the public map, I'd turn the current rating on, And there's nothing there.
582 00:41:22.090 --> 00:41:26.359 Stuart Bacon: Only when you click on Certificate Age that it brings something.
583 00:41:26.730 --> 00:41:29.610 Stuart Bacon: Really? Which is, you color writing on…
584 00:41:29.990 --> 00:41:32.959 Stuart Bacon: And the number of years of how old your certificate is.
585 00:41:35.790 --> 00:41:37.750 Retired Clerk: Well, we need to raise it.
586 00:41:37.960 --> 00:41:42.310 tristram cary: I, ticket on that public map function.
587 00:41:43.230 --> 00:41:43.910 Graham Stoddart-Stones: weird.
588 00:41:44.990 --> 00:41:48.300 David Morgan-Jones: Yeah, it's, it's pulling through the certificate age.
589 00:41:51.860 --> 00:41:53.809 Stuart Bacon: I can sit… looking at…
590 00:41:54.100 --> 00:41:55.560 Retired Clerk: Sort of the…
591 00:41:55.720 --> 00:41:59.450 Stuart Bacon: Yeah, when you logged in, Cyrus, Song of it.
592 00:41:59.640 --> 00:42:02.790 Stuart Bacon: Certificate aid shows there, and the…
593 00:42:02.970 --> 00:42:04.690 tristram cary: Corporation chose.
594 00:42:05.450 --> 00:42:10.659 Graham Stoddart-Stones: When you turn them both… when you turn them both on, it's the letter that predominates.
595 00:42:12.240 --> 00:42:15.849 Stuart Bacon: Yeah. Yeah. Because that will be.
596 00:42:15.850 --> 00:42:17.710 tristram cary: Which is right, that's what you want, because you've got the color.
597 00:42:17.710 --> 00:42:22.250 Stuart Bacon: It's the hierarchy in the list, isn't it? The higher up those lists on the left.
598 00:42:22.410 --> 00:42:27.330 Stuart Bacon: That it determines what's on top of What shows beneath it?
599 00:42:27.330 --> 00:42:35.320 tristram cary: Yeah. I think it's also useful, because you're getting the EPC rating, as well as an indication of whether it's way out of date.
600 00:42:35.320 --> 00:42:37.130 Graham Stoddart-Stones: Yes. Agreed.
601 00:42:37.130 --> 00:42:39.000 tristram cary: But I think it's a useful summary.
602 00:42:40.450 --> 00:42:48.680 tristram cary: Can I ask, not a parish online question, but, the thing that David and I are trying to do with Hart District Council, we're both in Hart.
603 00:42:48.890 --> 00:42:59.570 tristram cary: is to try to get a group of parishes interested in creating a database of all their housing stock, and then try to encourage a retrofit supplier who wants to work with heart.
604 00:42:59.650 --> 00:43:15.050 tristram cary: help us fill in the gaps, and subsidize, or even give for free, EPCs for the houses that don't have them, or that are way out of date, on the basis that they then stand to win quite a lot of retrofit work.
605 00:43:15.060 --> 00:43:23.279 tristram cary: If they could work strategically with the council. So I was interested to ask whether any of you guys in different parishes and different districts and different counties
606 00:43:23.310 --> 00:43:28.569 tristram cary: Have done such a thing, of creating a sort of a database of all the housing stock in the parish.
607 00:43:28.650 --> 00:43:31.850 tristram cary: based on… the EPCs that do exist.
608 00:43:35.840 --> 00:43:37.899 chris edwards: Tristram, I think…
609 00:43:38.200 --> 00:43:45.400 chris edwards: one of our neighbouring parishes has done such an exercise. Now, the name of the parish is Bruton.
610 00:43:45.550 --> 00:43:47.250 chris edwards: B-R-U-T.
611 00:43:47.250 --> 00:43:47.650 Graham Stoddart-Stones: Oh.
612 00:43:48.320 --> 00:43:49.260 Graham Stoddart-Stones: Fairly sir.
613 00:43:49.260 --> 00:43:51.190 chris edwards: If you, if you dig down…
614 00:43:51.580 --> 00:43:57.169 chris edwards: On their records, you might find information about what you've just asked about.
615 00:43:57.170 --> 00:43:59.180 tristram cary: Okay, that's good. Bruton.
616 00:43:59.420 --> 00:44:01.050 tristram cary: brooded in Somerset.
617 00:44:01.050 --> 00:44:01.870 Graham Stoddart-Stones: Yeah.
618 00:44:01.870 --> 00:44:03.619 chris edwards: And it's a town council.
619 00:44:03.840 --> 00:44:07.739 Graham Stoddart-Stones: Yeah, the parish… oh, the town clerk is Elise,
620 00:44:07.850 --> 00:44:09.279 Graham Stoddart-Stones: I'll just think about herself.
621 00:44:09.280 --> 00:44:10.140 chris edwards: newbie?
622 00:44:11.100 --> 00:44:11.950 chris edwards: Newbie?
623 00:44:11.950 --> 00:44:13.740 Graham Stoddart-Stones: Yes, Lisa Newby at 3.
624 00:44:15.710 --> 00:44:19.070 tristram cary: Because it would be very nice if… if there was a sort of…
625 00:44:19.570 --> 00:44:26.789 tristram cary: or recognized or recommended method of doing this. The people… then we could all sort of learn and try to
626 00:44:26.920 --> 00:44:31.259 tristram cary: Come down to one way of doing it that would be comparable across different parishes.
627 00:44:31.260 --> 00:44:31.960 chris edwards: Hmm.
628 00:44:34.550 --> 00:44:42.080 Graham Stoddart-Stones: Can't understand why Paris Online doesn't have a workspace facility where you say, I want to do this, and it just shows you this is the steps you have to take.
629 00:44:42.080 --> 00:44:42.770 tristram cary: British…
630 00:44:43.950 --> 00:44:56.570 tristram cary: I might chose to leave the meeting. It would indeed be very nice, and I keep being told it's on my way someday.
631 00:44:59.150 --> 00:45:02.080 Peter Lewis: Catherine, are you, are you, parish online, then?
632 00:45:02.080 --> 00:45:03.460 tristram cary: Yes, for myself.
633 00:45:03.460 --> 00:45:05.080 Peter Lewis: Yes.
634 00:45:05.250 --> 00:45:17.609 tristram cary: Well, I'm not… when I say I'm parachall, I'm not… I'm not… I have no idea how it works, or how to make it. I'm not at all a good user, but I am the chairman of the company and was responsible for creating it in the first place in 2007.
635 00:45:18.320 --> 00:45:19.470 Peter Lewis: Right, very good.
636 00:45:20.410 --> 00:45:22.119 tristram cary: But I'm not a technical or GI.
637 00:45:22.120 --> 00:45:27.970 Peter Lewis: Somebody's there before you slag it off, isn't it, really? I'm glad I said I thought it was intuitive.
638 00:45:27.970 --> 00:45:30.090 tristram cary: Exactly, it's very pissed, it's noted.
639 00:45:31.810 --> 00:45:33.709 Graham Stoddart-Stones: It might have been in writing.
640 00:45:37.890 --> 00:45:39.449 chris edwards: Graham, I've got another question.
641 00:45:40.190 --> 00:45:42.159 Graham Stoddart-Stones: So, Chris, well done.
642 00:45:44.190 --> 00:45:45.610 chris edwards: Forgive me for…
643 00:45:45.610 --> 00:45:50.409 Graham Stoddart-Stones: I'm giving Andrew fair warning that I'm coming up to a topic that he raised the other day.
644 00:45:50.410 --> 00:45:53.460 chris edwards: Right.
645 00:45:53.500 --> 00:45:56.350 Retired Clerk: Here… here is my…
646 00:45:56.440 --> 00:46:04.229 chris edwards: parish, and in Somerset, Now, I've got to make a list of all the styles
647 00:46:04.980 --> 00:46:09.220 chris edwards: Where we're going to change the styles to kissing dates.
648 00:46:09.270 --> 00:46:11.859 Graham Stoddart-Stones: So I've got to come up with a list.
649 00:46:12.010 --> 00:46:16.129 chris edwards: Of styles, many of them which are broken.
650 00:46:16.750 --> 00:46:19.869 chris edwards: How… what's… what's the best way of me…
651 00:46:20.160 --> 00:46:26.459 chris edwards: doing that. What's the easiest way? Well, because you're not in Paris online here, are you? I know, I know I'm not.
652 00:46:26.460 --> 00:46:27.020 Graham Stoddart-Stones: Joe.
653 00:46:27.520 --> 00:46:29.629 chris edwards: But, I mean… I mean, I could…
654 00:46:29.750 --> 00:46:37.720 chris edwards: do each one separately onto a spreadsheet, and then put that on Parish… on a Parish Online map.
655 00:46:38.100 --> 00:46:44.720 chris edwards: Has anybody got an idea How that would be… How it would be done.
656 00:46:44.900 --> 00:46:47.059 Retired Clerk: With the least amount of…
657 00:46:48.170 --> 00:46:49.959 chris edwards: Going backwards and forwards, you know.
658 00:46:49.960 --> 00:46:56.919 Graham Stoddart-Stones: I've forgotten how you get to the menu in Rome Somerset, but isn't there… there's an export facility, isn't there?
659 00:46:57.250 --> 00:46:58.680 Graham Stoddart-Stones: Seems remember there is.
660 00:46:59.400 --> 00:47:02.400 Stuart Bacon: If you go up to… And you have to…
661 00:47:02.400 --> 00:47:03.330 Retired Clerk: players.
662 00:47:03.760 --> 00:47:06.620 Graham Stoddart-Stones: I think you may need to be logged in, Chris.
663 00:47:08.290 --> 00:47:09.150 chris edwards: Right.
664 00:47:09.150 --> 00:47:14.889 Graham Stoddart-Stones: But I'm pretty sure that there's a way of getting the data out, and you'd be much better off just having them exported.
665 00:47:14.890 --> 00:47:24.209 chris edwards: Oh, right. Oh, well, I haven't thought of that, thank you very much. I'm not going to bugger about now, so… I'll hand you back to whoever wants…
666 00:47:24.350 --> 00:47:27.620 chris edwards: to ask the next question. Thank you, Graham.
667 00:47:27.620 --> 00:47:32.909 Retired Clerk: Chris, just be aware that that isn't necessarily a definitive map, it's…
668 00:47:32.910 --> 00:47:35.060 Graham Stoddart-Stones: It's hugely out of date, isn't it?
669 00:47:35.060 --> 00:47:37.350 chris edwards: Yes, yes, I realize it's out of date.
670 00:47:37.350 --> 00:47:46.760 Retired Clerk: Being one of the streamer volunteers, you know, I know that there are several places where the gates and styles and what have you are not on the same map.
671 00:47:46.760 --> 00:47:49.030 Graham Stoddart-Stones: You've got a start somewhere, haven't you? That's true.
672 00:47:49.030 --> 00:47:49.990 chris edwards: Yep, yep.
673 00:47:49.990 --> 00:47:50.850 Graham Stoddart-Stones: You might…
674 00:47:50.850 --> 00:47:51.300 chris edwards: Thanks.
675 00:47:51.300 --> 00:47:58.319 Graham Stoddart-Stones: If we ever have anybody on here from Paris Online, you might want to ask them why their footpaths don't show the styles and the bridges.
676 00:47:58.510 --> 00:48:03.090 Graham Stoddart-Stones: You know… But they'll come back with some weird answer saying they're.
677 00:48:03.090 --> 00:48:04.030 Andrew Clegg: I'm responsible for this.
678 00:48:04.030 --> 00:48:04.550 Graham Stoddart-Stones: data.
679 00:48:04.550 --> 00:48:09.420 tristram cary: Precisely, it's all our data. There's no way we can produce good data for you.
680 00:48:09.420 --> 00:48:15.389 David Morgan-Jones: graeme, can I just ask, going back to the external, maps.
681 00:48:15.830 --> 00:48:22.240 David Morgan-Jones: How do you actually make sure that when you do it, you portray the, the parish boundary?
682 00:48:24.040 --> 00:48:24.580 Graham Stoddart-Stones: You couldn't.
683 00:48:24.580 --> 00:48:26.460 chris edwards: Toggle on and toggle off.
684 00:48:26.460 --> 00:48:29.630 David Morgan-Jones: Oh, right. What, as you build the map layer.
685 00:48:29.850 --> 00:48:30.470 Stuart Bacon: Yeah.
686 00:48:30.730 --> 00:48:34.280 Stuart Bacon: So, if you show… if you share your screen at the moment, I'll walk you through it.
687 00:48:34.280 --> 00:48:37.649 David Morgan-Jones: Alright, I will share my screen. Quite wrong.
688 00:48:43.900 --> 00:48:45.440 David Morgan-Jones: Right, can you see that?
689 00:48:45.440 --> 00:48:46.030 Stuart Bacon: Yeah.
690 00:48:48.490 --> 00:48:50.679 Stuart Bacon: So now if you click on…
691 00:48:50.790 --> 00:48:52.840 Stuart Bacon: The cog in the top right.
692 00:48:53.060 --> 00:48:53.690 David Morgan-Jones: Yep.
693 00:48:55.590 --> 00:48:56.650 David Morgan-Jones: Administration?
694 00:48:56.650 --> 00:48:57.820 Stuart Bacon: Administration.
695 00:48:59.250 --> 00:49:00.460 David Morgan-Jones: Public maps.
696 00:49:00.460 --> 00:49:01.030 Stuart Bacon: Yep.
697 00:49:01.840 --> 00:49:02.180 David Morgan-Jones: Virgin?
698 00:49:02.180 --> 00:49:05.229 Graham Stoddart-Stones: Click on the… Click the plus sign in the middle.
699 00:49:05.230 --> 00:49:09.349 Stuart Bacon: Click on the plus, on the column there, middle one, yeah.
700 00:49:09.990 --> 00:49:11.490 Stuart Bacon: So, click Next.
701 00:49:12.620 --> 00:49:17.830 Stuart Bacon: And scroll down here, to find the parish.
702 00:49:20.800 --> 00:49:26.530 Graham Stoddart-Stones: It's… Aren't you a new shot?
703 00:49:31.900 --> 00:49:35.730 tristram cary: Isn't it? Doesn't it come under administrative boundaries?
704 00:49:38.010 --> 00:49:40.050 Graham Stoddart-Stones: It's the third… it's…
705 00:49:45.850 --> 00:49:53.820 Stuart Bacon: I think it's gonna be in… I think it's actually gonna be in your start… in your next list, actually. Sorry, thinking about it. So, yeah, skip… skip to next.
706 00:49:56.680 --> 00:50:01.750 Stuart Bacon: And we want to scroll down… to… perish.
707 00:50:02.180 --> 00:50:05.980 Stuart Bacon: And we also want to add on your EPCs as you go past them.
708 00:50:07.200 --> 00:50:08.950 David Morgan-Jones: Okay, let me.
709 00:50:13.590 --> 00:50:13.990 Graham Stoddart-Stones: They are.
710 00:50:13.990 --> 00:50:17.020 David Morgan-Jones: PC, so we want… Current rating…
711 00:50:17.340 --> 00:50:17.920 Stuart Bacon: Yep.
712 00:50:18.310 --> 00:50:19.690 Stuart Bacon: Certificate age.
713 00:50:19.960 --> 00:50:20.760 Stuart Bacon: Don't you?
714 00:50:22.250 --> 00:50:24.279 David Morgan-Jones: What's the current rating generalized?
715 00:50:26.360 --> 00:50:31.180 tristram cary: It's, it's less… it's C and better and D and worse.
716 00:50:31.670 --> 00:50:33.630 David Morgan-Jones: Oh, right, okay, got you, got you.
717 00:50:33.630 --> 00:50:36.449 tristram cary: It's just a red-green indication. I don't think it's very useful.
718 00:50:37.460 --> 00:50:40.330 David Morgan-Jones: And then come down to…
719 00:50:40.330 --> 00:50:41.200 Graham Stoddart-Stones: Parish.
720 00:50:41.830 --> 00:50:42.540 Graham Stoddart-Stones: Whoops.
721 00:50:42.540 --> 00:50:43.400 David Morgan-Jones: harsh…
722 00:50:46.570 --> 00:50:47.230 Stuart Bacon: Nope.
723 00:50:47.230 --> 00:50:47.850 David Morgan-Jones: I don't…
724 00:50:47.850 --> 00:50:48.990 Stuart Bacon: Click next.
725 00:50:52.730 --> 00:50:55.090 Retired Clerk: Center the map where you…
726 00:50:56.150 --> 00:50:58.700 Stuart Bacon: Best think that needs to be.
727 00:50:58.920 --> 00:50:59.389 Stuart Bacon: I'm just…
728 00:50:59.390 --> 00:51:02.799 tristram cary: And scale it, and the scale, yeah.
729 00:51:04.900 --> 00:51:11.199 David Morgan-Jones: Unfortunately, we've got a rather odd, parish, a rather odd shape to it.
730 00:51:11.250 --> 00:51:16.029 Graham Stoddart-Stones: So that's… well, that's the core… that's the center part of the parish.
731 00:51:16.690 --> 00:51:24.220 Stuart Bacon: People can move the map around a bit when they've got it anyway, that's not the extent of the map, so you find… click next, now.
732 00:51:25.990 --> 00:51:29.069 Stuart Bacon: And give it a title.
733 00:51:30.060 --> 00:51:31.640 David Morgan-Jones: Alright.
734 00:51:32.370 --> 00:51:33.200 David Morgan-Jones: Harsh.
735 00:51:33.310 --> 00:51:36.140 David Morgan-Jones: PCs… Yep.
736 00:51:36.670 --> 00:51:37.490 David Morgan-Jones: Unsave.
737 00:51:37.490 --> 00:51:43.820 Stuart Bacon: Now, I would turn off… be the… the…
738 00:51:44.280 --> 00:51:46.079 Graham Stoddart-Stones: Age will occur, isn't.
739 00:51:46.080 --> 00:51:48.470 Stuart Bacon: Yeah, the current rights, you know, the certificate age.
740 00:51:48.660 --> 00:51:50.849 David Morgan-Jones: I'll turn that off for the moment. Yeah.
741 00:51:50.850 --> 00:51:52.210 Stuart Bacon: And then click Save.
742 00:51:54.200 --> 00:51:57.949 Stuart Bacon: And now, if you copy the…
743 00:51:58.420 --> 00:52:00.700 Stuart Bacon: You click on the right-hand side…
744 00:52:01.380 --> 00:52:05.560 Stuart Bacon: Team difference. Sorry, it does exactly what you've just done, but so do you having to highlight the.
745 00:52:05.560 --> 00:52:09.090 David Morgan-Jones: Yeah, I've got you. And I'm just gonna put it into my browser.
746 00:52:09.260 --> 00:52:09.810 Graham Stoddart-Stones: Yep.
747 00:52:10.110 --> 00:52:12.249 Graham Stoddart-Stones: There's the boundary.
748 00:52:12.350 --> 00:52:14.850 David Morgan-Jones: Oh yeah, there's a boundary coming up, clearly.
749 00:52:15.360 --> 00:52:15.950 Graham Stoddart-Stones: Nope.
750 00:52:16.180 --> 00:52:18.079 David Morgan-Jones: But no EPCs.
751 00:52:18.080 --> 00:52:20.100 Graham Stoddart-Stones: Well, you may need to turn them on.
752 00:52:20.730 --> 00:52:22.129 tristram cary: They, they were on.
753 00:52:22.130 --> 00:52:24.440 Graham Stoddart-Stones: Well, only one of them, the current rating.
754 00:52:24.440 --> 00:52:25.220 tristram cary: Yeah.
755 00:52:25.220 --> 00:52:33.289 Stuart Bacon: Yeah, it's the current rating is the one that we're having problems with that's not feeding the data through. It's the certificate age is the one that feeds.
756 00:52:33.290 --> 00:52:34.160 David Morgan-Jones: Yeah, got you.
757 00:52:35.770 --> 00:52:38.630 Stuart Bacon: From now on, that's now giving you…
758 00:52:38.720 --> 00:52:40.310 Graham Stoddart-Stones: Yay, yep.
759 00:52:46.190 --> 00:52:50.450 David Morgan-Jones: You see, we're sort of the bulwark pushing away all the buildings.
760 00:52:50.870 --> 00:52:51.260 Graham Stoddart-Stones: S.
761 00:52:51.650 --> 00:52:53.829 David Morgan-Jones: That's it. Surrounded.
762 00:52:54.090 --> 00:52:55.649 Graham Stoddart-Stones: Yes, you are, aren't you?
763 00:52:56.270 --> 00:53:01.359 David Morgan-Jones: Luckily, we have this huge area, which is part of the military trading estate, so,
764 00:53:01.530 --> 00:53:05.019 David Morgan-Jones: That's not gonna… Causes too much of a problem.
765 00:53:05.400 --> 00:53:10.620 David Morgan-Jones: But, yeah. Okay, that's cool. We just need to, fix it, Tristan.
766 00:53:10.930 --> 00:53:11.680 tristram cary: Yep.
767 00:53:12.060 --> 00:53:15.139 tristram cary: Will you arrange… will you raise the, ticket?
768 00:53:16.030 --> 00:53:17.870 Retired Clerk: How the hell do I raise a ticket?
769 00:53:17.870 --> 00:53:18.490 Graham Stoddart-Stones: Yeah.
770 00:53:18.490 --> 00:53:19.240 tristram cary: No, that's a question.
771 00:53:19.240 --> 00:53:20.750 Graham Stoddart-Stones: Don't turn it off.
772 00:53:20.750 --> 00:53:22.219 tristram cary: You're ticket raiser.
773 00:53:22.630 --> 00:53:29.869 David Morgan-Jones: Alright, share my screen again. Yeah, okay… Got it, yup.
774 00:53:30.170 --> 00:53:30.840 Graham Stoddart-Stones: Yep.
775 00:53:30.840 --> 00:53:34.460 Stuart Bacon: And now, if you go back to the, one tab to the left.
776 00:53:34.460 --> 00:53:35.000 Retired Clerk: Nope.
777 00:53:37.390 --> 00:53:41.580 Stuart Bacon: Yeah, and go back to your maps in the top right-hand corner, though, the second one in.
778 00:53:41.580 --> 00:53:42.789 Graham Stoddart-Stones: That one. Yeah.
779 00:53:42.790 --> 00:53:43.790 Stuart Bacon: Platform.
780 00:53:46.250 --> 00:53:52.169 Stuart Bacon: So from the main idea here, we need help. We need, we need some support, so click on Help.
781 00:53:53.360 --> 00:53:55.400 Stuart Bacon: And contact support.
782 00:53:56.650 --> 00:54:05.830 Stuart Bacon: And fill that in, and that creates the ticket for you, within your details. You can also…
783 00:54:07.330 --> 00:54:09.869 Stuart Bacon: If you sign in,
784 00:54:10.050 --> 00:54:22.090 Stuart Bacon: to that. I mean, I don't… I must admit, Tristram, I am somewhat confused as to why the ticket system, you have to sign in again to when you're already signed into Parish Online.
785 00:54:22.450 --> 00:54:24.179 Graham Stoddart-Stones: Because it's a separate…
786 00:54:24.180 --> 00:54:25.440 tristram cary: Yeah, good question.
787 00:54:25.670 --> 00:54:31.379 Graham Stoddart-Stones: So, no, they're two separate systems, so signing into Paris Online does not sign you into the knowledge base.
788 00:54:32.400 --> 00:54:33.509 Stuart Bacon: Yeah, but boy.
789 00:54:33.510 --> 00:54:34.440 tristram cary: Nobody couldn't.
790 00:54:34.440 --> 00:54:35.319 Stuart Bacon: Does it not do that?
791 00:54:35.320 --> 00:54:36.630 Retired Clerk: Good morning.
792 00:54:36.890 --> 00:54:37.220 Graham Stoddart-Stones: But maybe…
793 00:54:37.220 --> 00:54:39.189 Stuart Bacon: Because every user's got their own unique.
794 00:54:39.190 --> 00:54:43.110 tristram cary: That sounds… that sounds like another… that sounds like another ticket, Stuart.
795 00:54:43.430 --> 00:54:47.360 Graham Stoddart-Stones: So, I have another piece of advice for you, David.
796 00:54:48.400 --> 00:54:49.940 Retired Clerk: come on a Friday afternoon.
797 00:54:49.940 --> 00:54:59.690 Graham Stoddart-Stones: You save a lot of time and trouble if you just send an email to support at parishonline.co.uk, and that's exactly the same as creating a ticket, but you don't go through all the palava.
798 00:55:00.100 --> 00:55:06.599 David Morgan-Jones: Yeah, like, I've no idea what my parish online ID is.
799 00:55:06.600 --> 00:55:15.269 Graham Stoddart-Stones: You don't need one. Well, that's why I say, just send it from your regular email, send it to support at parish-online.co.uk, and that's it.
800 00:55:15.440 --> 00:55:16.949 tristram cary: And Dick, when I need you…
801 00:55:17.140 --> 00:55:18.920 Graham Stoddart-Stones: They'll come back with an email that.
802 00:55:18.920 --> 00:55:20.349 Retired Clerk: They've mentioned for you up today.
803 00:55:20.350 --> 00:55:21.120 Graham Stoddart-Stones: open this ticket.
804 00:55:22.330 --> 00:55:24.230 tristram cary: Don't mention Graham's not arts.
805 00:55:24.230 --> 00:55:28.270 Graham Stoddart-Stones: Absolutely not. Or anybody else on this…
806 00:55:28.300 --> 00:55:28.880 tristram cary: Cool.
807 00:55:28.880 --> 00:55:32.000 Graham Stoddart-Stones: Or, you know, all certified troublemakers.
808 00:55:33.670 --> 00:55:38.010 tristram cary: Now, you're being very unfair. The ticket, the response to the ticket is pretty quick, isn't it?
809 00:55:38.830 --> 00:55:44.689 Retired Clerk: Well, yes, you get an answer that says we have no idea what the problem is, we'll get back to you.
810 00:55:46.630 --> 00:55:50.349 Retired Clerk: I think I get a good insult.
811 00:55:51.710 --> 00:55:57.919 Peter Lewis: Just to be fair to you, Tristan, I did that the other day, because I had some questions, and I got a very quick response.
812 00:55:57.920 --> 00:55:58.719 tristram cary: They're good.
813 00:55:58.720 --> 00:56:02.519 Peter Lewis: I did it very late at night, and the following morning, there was response waiting for me.
814 00:56:02.520 --> 00:56:03.450 tristram cary: Excellent.
815 00:56:03.450 --> 00:56:06.219 Peter Lewis: A very nice lady had also created a ticket.
816 00:56:06.840 --> 00:56:11.100 Peter Lewis: I was then able to log in and find somewhere else, but it was a bit odd to have to log in.
817 00:56:11.100 --> 00:56:11.570 tristram cary: No, that'd be.
818 00:56:11.570 --> 00:56:12.089 Peter Lewis: Nice to see.
819 00:56:12.090 --> 00:56:15.979 tristram cary: Well, do raise that, that with, who is that?
820 00:56:16.350 --> 00:56:19.550 Peter Lewis: Can't think. That was, that was… I'll tell you who that was.
821 00:56:20.760 --> 00:56:22.590 Peter Lewis: Useful person.
822 00:56:26.850 --> 00:56:27.690 tristram cary: Windy.
823 00:56:28.500 --> 00:56:32.460 Peter Lewis: I think it was, I think it was. I'll just have to look and see.
824 00:56:32.760 --> 00:56:34.170 Peter Lewis: There it was, but .
825 00:56:34.170 --> 00:56:35.180 tristram cary: When debates.
826 00:56:35.180 --> 00:56:35.870 Graham Stoddart-Stones: Oops.
827 00:56:35.870 --> 00:56:38.620 Peter Lewis: Yeah, exactly, that was who it was, yeah, yeah.
828 00:56:38.840 --> 00:56:42.189 Graham Stoddart-Stones: So… Are you now seeing my screen, Andrew?
829 00:56:43.540 --> 00:56:43.960 tristram cary: Yep.
830 00:56:43.960 --> 00:56:45.879 Graham Stoddart-Stones: You wanted to…
831 00:56:45.880 --> 00:56:49.660 Andrew Clegg: see this new merge thing in action. Oh, okay.
832 00:56:50.050 --> 00:56:54.639 Graham Stoddart-Stones: And if you have… let me just select a layer that's got some data in it, let's turn that off.
833 00:56:57.430 --> 00:56:59.769 Graham Stoddart-Stones: If I go down to some lines…
834 00:57:07.140 --> 00:57:09.929 Graham Stoddart-Stones: We need to come work central.
835 00:57:10.750 --> 00:57:11.569 Graham Stoddart-Stones: You go.
836 00:57:13.370 --> 00:57:17.099 Graham Stoddart-Stones: So, I've got two lines on the map.
837 00:57:18.090 --> 00:57:25.250 Graham Stoddart-Stones: And I went into the record for them, Gom saw.
838 00:57:25.660 --> 00:57:28.200 Graham Stoddart-Stones: And you go into the first one, say.
839 00:57:28.320 --> 00:57:33.879 Graham Stoddart-Stones: And you want to turn on the merge, which is… which one is it? That one? That one, that one?
840 00:57:34.670 --> 00:57:49.739 Graham Stoddart-Stones: Oh, it's already merged, but if it's not already merged, then you get an extra symbol up here, and you turn that on, and then you click on the other item, and it puts the two together as one. And when these two are now joined, so if you move them.
841 00:57:50.570 --> 00:57:52.210 Graham Stoddart-Stones: Sorry, both of them move.
842 00:57:54.980 --> 00:57:57.959 Graham Stoddart-Stones: If I go into… hate mode…
843 00:58:01.810 --> 00:58:03.430 Graham Stoddart-Stones: You, come on, son.
844 00:58:05.070 --> 00:58:06.339 Graham Stoddart-Stones: Well, it would…
845 00:58:08.400 --> 00:58:09.310 Retired Clerk: Interesting.
846 00:58:09.310 --> 00:58:09.980 Andrew Clegg: There's…
847 00:58:09.980 --> 00:58:11.390 Graham Stoddart-Stones: It did, at one stage.
848 00:58:11.390 --> 00:58:13.600 Andrew Clegg: They both, they both move together.
849 00:58:13.850 --> 00:58:15.120 Graham Stoddart-Stones: Yes, exactly.
850 00:58:15.440 --> 00:58:16.600 Retired Clerk: The whole world moved.
851 00:58:16.600 --> 00:58:18.910 Graham Stoddart-Stones: Well, yeah, it's… I'm not quite sure why.
852 00:58:18.910 --> 00:58:20.019 tristram cary: Are you hated?
853 00:58:21.170 --> 00:58:21.900 Graham Stoddart-Stones: Yes.
854 00:58:21.900 --> 00:58:23.349 tristram cary: Huh, I understand.
855 00:58:23.800 --> 00:58:25.240 Graham Stoddart-Stones: And not now.
856 00:58:26.570 --> 00:58:28.599 Graham Stoddart-Stones: I'm there on my test line.
857 00:58:29.070 --> 00:58:31.599 Graham Stoddart-Stones: And I should be into edit mode.
858 00:58:32.160 --> 00:58:33.089 Graham Stoddart-Stones: There we go.
859 00:58:33.540 --> 00:58:35.950 Graham Stoddart-Stones: So now, if I move one, well…
860 00:58:40.010 --> 00:58:41.479 tristram cary: Oh, is that another order.
861 00:58:42.350 --> 00:58:43.990 Graham Stoddart-Stones: Way.
862 00:58:43.990 --> 00:58:48.130 tristram cary: No, maybe, no, sorry, maybe you shouldn't be an idiot. No, you've got to be an idiot to move them, haven't it.
863 00:58:48.130 --> 00:58:56.959 Graham Stoddart-Stones: Oh, yes, you have to. Maybe you can't go back to edit it, Graeme. Maybe it just moves in the first one before you save it.
864 00:58:56.960 --> 00:58:59.670 Andrew Clegg: Once it's saved, it's saved in stone.
865 00:59:00.150 --> 00:59:04.509 Graham Stoddart-Stones: Well, they're now joined as one record, so.
866 00:59:04.810 --> 00:59:05.630 Andrew Clegg: Oh, are they?
867 00:59:05.630 --> 00:59:06.340 Graham Stoddart-Stones: Yes.
868 00:59:06.340 --> 00:59:09.349 Retired Clerk: But it only appears as you're editing one, though, Graham.
869 00:59:09.350 --> 00:59:11.910 Graham Stoddart-Stones: Exactly, because they're joined together.
870 00:59:11.910 --> 00:59:13.600 Retired Clerk: It sounds like another ticket.
871 00:59:13.600 --> 00:59:14.960 Graham Stoddart-Stones: So, if I…
872 00:59:18.960 --> 00:59:19.670 Graham Stoddart-Stones: Night.
873 00:59:19.670 --> 00:59:22.479 tristram cary: Very odd. I saw that working the other day, too.
874 00:59:22.830 --> 00:59:29.819 Graham Stoddart-Stones: It's actually quite… I thought it was quite handy, so let's go into this, create a new feature.
875 00:59:30.780 --> 00:59:32.059 Graham Stoddart-Stones: So if I just…
876 00:59:41.200 --> 00:59:43.809 Andrew Clegg: So there's your line, Andrew. Yeah?
877 00:59:45.620 --> 00:59:46.710 Graham Stoddart-Stones: And we'll save it.
878 00:59:47.410 --> 00:59:49.500 Graham Stoddart-Stones: And then we'll create another one.
879 00:59:50.080 --> 00:59:51.320 Graham Stoddart-Stones: But it's Ryan.
880 00:59:52.500 --> 00:59:53.569 Stuart Bacon: You're slowing.
881 00:59:55.860 --> 00:59:57.650 Graham Stoddart-Stones: Or, whoever Few is.
882 00:59:58.240 --> 00:59:59.540 Graham Stoddart-Stones: I'm gonna quit that one.
883 01:00:01.680 --> 01:00:02.999 Graham Stoddart-Stones: Put the two together.
884 01:00:05.570 --> 01:00:07.920 Graham Stoddart-Stones: Now, if you select the first one…
885 01:00:10.480 --> 01:00:14.570 Graham Stoddart-Stones: You… where's the share button? That's not a share button.
886 01:00:18.010 --> 01:00:18.650 Graham Stoddart-Stones: Welp.
887 01:00:18.650 --> 01:00:18.980 tristram cary: No.
888 01:00:18.980 --> 01:00:20.770 Graham Stoddart-Stones: When I tried it the first time, it worked beautifully.
889 01:00:21.660 --> 01:00:23.839 Graham Stoddart-Stones: I lost the share button, maybe they turned it off.
890 01:00:24.840 --> 01:00:27.250 chris edwards: Re-read the newsletter.
891 01:00:28.950 --> 01:00:29.410 Graham Stoddart-Stones: Oh, man.
892 01:00:29.410 --> 01:00:31.409 tristram cary: There was a video posted in the newsletter, wasn't it?
893 01:00:32.960 --> 01:00:34.460 Graham Stoddart-Stones: We can do that, too.
894 01:00:35.850 --> 01:00:36.680 Andrew Clegg: Hmm…
895 01:00:41.380 --> 01:00:42.659 Graham Stoddart-Stones: Bear with me a second.
896 01:01:13.350 --> 01:01:16.780 Graham Stoddart-Stones: This is the old one, isn't it? It's a bit later than 60.
897 01:01:18.890 --> 01:01:21.299 Stuart Bacon: That was July, yeah, very year.
898 01:01:21.870 --> 01:01:22.710 tristram cary: Nope.
899 01:01:44.040 --> 01:01:45.009 Graham Stoddart-Stones: Bry that one.
900 01:01:48.550 --> 01:01:50.170 David Morgan-Jones: How'd you sign up to these?
901 01:01:50.480 --> 01:01:51.980 tristram cary: That's it, that's all.
902 01:01:51.980 --> 01:01:52.490 Graham Stoddart-Stones: Yup.
903 01:01:52.490 --> 01:01:55.730 tristram cary: You should… they should come, in the website.
904 01:02:06.320 --> 01:02:07.390 Graham Stoddart-Stones: Okay.
905 01:02:08.160 --> 01:02:11.609 Graham Stoddart-Stones: You're going to select them both before I go into the… sorry.
906 01:02:12.860 --> 01:02:15.910 Graham Stoddart-Stones: Let's go back over to…
907 01:02:25.650 --> 01:02:27.180 Graham Stoddart-Stones: I think maybe you have to do…
908 01:02:29.420 --> 01:02:32.769 tristram cary: David, in the Parish Online website, you can sign up for the newsletter.
909 01:02:32.770 --> 01:02:33.860 David Morgan-Jones: Alright, okay.
910 01:02:36.570 --> 01:02:42.790 Graham Stoddart-Stones: Yeah, or you can do it. There used to be a system down here, you know, that's gone now, is it?
911 01:02:43.340 --> 01:02:44.750 Graham Stoddart-Stones: The opportunity to look at?
912 01:02:45.380 --> 01:02:49.129 Graham Stoddart-Stones: Well, I'm delighted I've showed this so demonstratively to you. Yeah.
913 01:02:49.380 --> 01:02:50.509 Graham Stoddart-Stones: Andrew, I'm sure.
914 01:02:50.510 --> 01:02:54.489 Andrew Clegg: You need to be able to shift-click, don't you? You need to shift-click things.
915 01:02:54.490 --> 01:02:59.929 Graham Stoddart-Stones: Yes, well, you can. So if you go into the knowledge base, because they know all these things there.
916 01:03:00.970 --> 01:03:03.089 Graham Stoddart-Stones: And then talk about Verge.
917 01:03:07.220 --> 01:03:08.240 Graham Stoddart-Stones: Here you go.
918 01:03:09.580 --> 01:03:14.429 Graham Stoddart-Stones: And there was this bit about flattening as a group, or… sorry, as a group, or…
919 01:03:16.330 --> 01:03:24.360 Graham Stoddart-Stones: So, yes, the group option was the one I had, and you… the multiple features are treated as one, but their individual geometry remains the same.
920 01:03:25.600 --> 01:03:26.620 Andrew Clegg: Yeah.
921 01:03:26.620 --> 01:03:27.170 Graham Stoddart-Stones: But you don't.
922 01:03:27.170 --> 01:03:30.970 tristram cary: But it… and are you sharing… are you following what's happening down on that…
923 01:03:32.840 --> 01:03:33.230 Graham Stoddart-Stones: That'd be fun.
924 01:03:33.230 --> 01:03:33.620 tristram cary: like that.
925 01:03:34.060 --> 01:03:34.890 tristram cary: hard to do it.
926 01:03:34.890 --> 01:03:35.580 Graham Stoddart-Stones: Yep.
927 01:03:36.330 --> 01:03:39.750 Graham Stoddart-Stones: Well, now that I've showed Andrew where it is, he could do all the work.
928 01:03:39.750 --> 01:03:43.209 Andrew Clegg: I'll see if I can find time.
929 01:03:44.120 --> 01:03:49.500 Graham Stoddart-Stones: I thought this was a rather nice little video, actually, showing you what to do.
930 01:03:50.050 --> 01:03:52.690 Graham Stoddart-Stones: But you get that merge symbol.
931 01:03:53.270 --> 01:03:57.210 Graham Stoddart-Stones: Which I didn't get before… when I went back into it.
932 01:03:58.450 --> 01:04:00.420 tristram cary: Yeah, but you intersected one of the objects in there.
933 01:04:00.420 --> 01:04:02.839 Graham Stoddart-Stones: This is, this is like, do you remember…
934 01:04:03.160 --> 01:04:16.940 Graham Stoddart-Stones: We used to have a chap who wanted to merge all his mowing verges together into one, and then, when he'd done it, he found that it was not very convenient, and then discovered there was no way of undoing it. He had to delete them all and start again, which is very irritating.
935 01:04:17.460 --> 01:04:22.690 Graham Stoddart-Stones: And I'm not sure that we aren't in the same position here. I'm not sure how you undo your merge.
936 01:04:25.610 --> 01:04:26.710 Andrew Clegg: Oh, mmm.
937 01:04:26.710 --> 01:04:29.830 Graham Stoddart-Stones: You can't add or remove objects from it, okay?
938 01:04:32.290 --> 01:04:33.999 Graham Stoddart-Stones: Yeah, so you can't undo it.
939 01:04:35.200 --> 01:04:40.599 Stuart Bacon: Well, that… so, once you've merged something, you can't merge anything else to it, is that what it says?
940 01:04:42.820 --> 01:04:45.669 Graham Stoddart-Stones: Yes, you can add or remove objects from it.
941 01:04:47.320 --> 01:04:53.019 Graham Stoddart-Stones: So you can create it, but you can't amend it, and you can't, delete things from it.
942 01:04:53.590 --> 01:04:54.979 Graham Stoddart-Stones: You can't undo it.
943 01:04:55.210 --> 01:04:56.220 Graham Stoddart-Stones: Which is…
944 01:04:56.990 --> 01:05:00.359 Andrew Clegg: So you'd better make a copy of your lair before you start messing around.
945 01:05:00.360 --> 01:05:02.749 Graham Stoddart-Stones: Absolutely, yes, good advice.
946 01:05:02.750 --> 01:05:04.769 tristram cary: That's a good… that's a good…
947 01:05:04.770 --> 01:05:05.810 Graham Stoddart-Stones: Good advice.
948 01:05:06.100 --> 01:05:08.719 Graham Stoddart-Stones: Using the group split layer function.
949 01:05:09.340 --> 01:05:16.390 Stuart Bacon: Because I was… I was thinking it would be potentially useful in terms of planning.
950 01:05:16.500 --> 01:05:19.989 Stuart Bacon: And where you get, sort of,
951 01:05:20.150 --> 01:05:27.829 Stuart Bacon: off-site BNG arrangements, you could theoretically, sort of, modify that to,
952 01:05:27.980 --> 01:05:34.960 Stuart Bacon: merge those two as to one item, but if you can't then, sort of, amend that
953 01:05:35.380 --> 01:05:46.830 Stuart Bacon: Area, should the… should, during the process of the planning application, the area change, which is something out of our control, and we try and update the record, then you have to go back and start from scratch?
954 01:05:46.830 --> 01:05:48.470 Graham Stoddart-Stones: You know, it's a pain, isn't it?
955 01:05:49.120 --> 01:05:53.170 Graham Stoddart-Stones: I can think of some applications where this could be very useful.
956 01:05:53.620 --> 01:06:01.409 Graham Stoddart-Stones: then, where… You've got something that you… the shape of it remains the same, but the location may change.
957 01:06:01.590 --> 01:06:06.520 Graham Stoddart-Stones: So if you're doing a, I don't know, a summer fate, and you've got all the…
958 01:06:06.680 --> 01:06:07.550 Andrew Clegg: Hmm.
959 01:06:08.770 --> 01:06:18.479 Graham Stoddart-Stones: marquees is set up in a certain order, then next year, you can put exactly the same marquees up, but they're going to be in a different field, so you just move them.
960 01:06:19.200 --> 01:06:23.039 Graham Stoddart-Stones: Assuming the field is the same shape, or has enough of the same space in it.
961 01:06:23.040 --> 01:06:26.809 tristram cary: And actually, this application with a hole in it is quite useful, too.
962 01:06:26.810 --> 01:06:28.409 Graham Stoddart-Stones: That's really useful, I like that.
963 01:06:28.410 --> 01:06:31.559 tristram cary: That would be very hard to do without the function of.
964 01:06:31.910 --> 01:06:32.540 Graham Stoddart-Stones: And…
965 01:06:32.540 --> 01:06:33.330 tristram cary: Yo.
966 01:06:33.330 --> 01:06:38.599 Graham Stoddart-Stones: Yes, I've done it, it's doable, but this is much a much better way of doing it. Yeah.
967 01:06:38.930 --> 01:06:39.820 Graham Stoddart-Stones: Agreed.
968 01:06:39.950 --> 01:06:46.460 Stuart Bacon: But… Yeah, I mean, I guess… sorry, I'm trying to think… I've got an example I could show.
969 01:06:46.700 --> 01:06:53.959 Stuart Bacon: Of this, where… I'll go…
970 01:06:59.960 --> 01:07:04.439 Stuart Bacon: So, yeah, example at the moment, I've got
971 01:07:04.970 --> 01:07:19.820 Stuart Bacon: off-site open space there would be wonderful to sort of, not open space, sorry, off-site BNG area would be wonderful to link them together, but there's potential that the… the area might change during the planning
972 01:07:20.000 --> 01:07:29.239 Stuart Bacon: Determination, so I'm a little bit skeptical about wanting to do that and then having to redraw it, because it's a sizeable
973 01:07:30.320 --> 01:07:34.570 Stuart Bacon: Sizable plot to redraw the,
974 01:07:34.760 --> 01:07:41.480 Stuart Bacon: the things of. That would be a little bit of a nuisance. The other one,
975 01:07:41.850 --> 01:07:49.760 Stuart Bacon: And… am I in the right… I'm sorry, I'm in the wrong account. Let me log out and start again.
976 01:07:50.270 --> 01:07:51.559 Stuart Bacon: Apologies for that.
977 01:08:07.140 --> 01:08:16.620 Stuart Bacon: Yeah, so the other one, where you've got a hole in a development, I've had to draw two…
978 01:08:17.240 --> 01:08:18.550 Stuart Bacon: two shapes.
979 01:08:18.810 --> 01:08:26.149 Stuart Bacon: And then, yeah, whenever you do calculations, it's… calculate the size of the small shape and take it off the big one.
980 01:08:26.609 --> 01:08:27.189 Graham Stoddart-Stones: Beautiful.
981 01:08:27.550 --> 01:08:33.330 Stuart Bacon: But if I… if I can, yeah, keyhole that now, then that might be… that might be positive.
982 01:08:34.560 --> 01:08:35.500 Andrew Clegg: Yeah. Yep.
983 01:08:35.500 --> 01:08:37.870 Stuart Bacon: Well, that's where a planning application is, sort of.
984 01:08:38.010 --> 01:08:41.079 Stuart Bacon: Yeah, got all of the site, but keeps parties.
985 01:08:41.950 --> 01:08:45.440 Stuart Bacon: The existing farm, and… Messages with the rest of it.
986 01:08:47.560 --> 01:08:54.229 Andrew Clegg: When you're doing complicated, fairly complicated layers, what I have done in the past is to keep drafts
987 01:08:55.040 --> 01:09:03.530 Andrew Clegg: You know, and then, then if you do make errors, then you can go back to the previous one, if you used your copy function and keep a draft.
988 01:09:04.290 --> 01:09:05.010 Graham Stoddart-Stones: Yes.
989 01:09:06.069 --> 01:09:12.099 Graham Stoddart-Stones: If you're doing it in the same session, there's an undo feature that you can go back to.
990 01:09:12.109 --> 01:09:12.789 Andrew Clegg: Yeah.
991 01:09:12.790 --> 01:09:14.389 Graham Stoddart-Stones: But I agree, your idea…
992 01:09:14.399 --> 01:09:19.389 Andrew Clegg: But the trouble is, you see, what we really need then is a little folder in which you can
993 01:09:20.100 --> 01:09:25.430 Andrew Clegg: Put the drafts in on the left-hand column.
994 01:09:25.439 --> 01:09:27.359 Graham Stoddart-Stones: That's a very novel idea, Andrew.
995 01:09:27.359 --> 01:09:32.189 Andrew Clegg: Wonderful. Somebody's mentioned it before, haven't they?
996 01:09:33.310 --> 01:09:38.179 Andrew Clegg: That bloke Clegg down in Martok, he keeps on and on and on whinging.
997 01:09:38.950 --> 01:09:44.620 Graham Stoddart-Stones: Gentlemen, let me ask if there are any more questions, or any more points that anyone wishes to raise.
998 01:09:44.620 --> 01:09:54.520 Stuart Bacon: I've got one slight query that's something that came up to me in what we were looking at earlier on. A question for the group to see whether on, sort of.
999 01:09:54.900 --> 01:10:02.790 Stuart Bacon: Yeah, looking at this in an entirely different way, but it occurred to me as we were looking at, sort of, the,
1000 01:10:02.900 --> 01:10:09.189 Stuart Bacon: the discussion on EPCs, that, at the moment.
1001 01:10:09.280 --> 01:10:14.819 Retired Clerk: sort of the… the certificate age, if you were to… to go in and try and.
1002 01:10:15.350 --> 01:10:16.430 Stuart Bacon: filter.
1003 01:10:16.750 --> 01:10:24.849 Stuart Bacon: Based on… sort of, was the… An energy rating, say.
1004 01:10:25.240 --> 01:10:30.100 Stuart Bacon: You can only get a filter based on what it equals.
1005 01:10:30.360 --> 01:10:34.859 Stuart Bacon: Now, based on what David was asking for earlier on.
1006 01:10:35.170 --> 01:10:38.880 Stuart Bacon: Would there be any mileage in asking for a…
1007 01:10:39.090 --> 01:10:47.319 Stuart Bacon: is greater than, or is smaller than, a certain figure, where you're looking for, sort of, analyzing multiple results within a
1008 01:10:47.470 --> 01:10:52.949 Stuart Bacon: a dataset, so that you want to look at all EPCs that are over
1009 01:10:53.190 --> 01:10:55.810 Stuart Bacon: 8 years old, say, maybe, or something.
1010 01:10:57.120 --> 01:11:02.129 Stuart Bacon: Is that me alone that would see that as something worthwhile, or is…
1011 01:11:02.130 --> 01:11:04.170 Graham Stoddart-Stones: I think that'd be hugely useful.
1012 01:11:05.990 --> 01:11:08.110 Stuart Bacon: Would that be achievable, Tristan?
1013 01:11:09.320 --> 01:11:18.000 tristram cary: Well, I was wondering what… I don't know in parishion line, but if we've got all the data, if that… if that government.u…co.uk data set
1014 01:11:18.150 --> 01:11:24.120 tristram cary: sorry, government.org, yeah. If that government data set has all the EPC…
1015 01:11:24.620 --> 01:11:28.430 tristram cary: Reports, and they're in a form that you can analyze them.
1016 01:11:28.570 --> 01:11:29.689 tristram cary: then yes.
1017 01:11:31.230 --> 01:11:39.699 Stuart Bacon: Well, yeah, I mean, because presumably, obviously at the moment, you've got all of that data in there, because when you show the, the age of the…
1018 01:11:39.870 --> 01:11:49.770 Stuart Bacon: the data set, the age of the EPC, that's what it shows when you look at the number, and whatever there. The number…
1019 01:11:50.290 --> 01:11:59.649 Stuart Bacon: correlates to how many years old your ETC is, so if there was a way of filtering that data, so you were only looking at
1020 01:11:59.900 --> 01:12:02.999 Stuart Bacon: Those over a certain number.
1021 01:12:03.480 --> 01:12:06.149 tristram cary: Yeah, but I'm not sure… We have to…
1022 01:12:06.390 --> 01:12:14.660 tristram cary: Yeah, we'd have to experiment. But as I remember it, we couldn't do that. We couldn't… we couldn't, for some reason, manipulate the data.
1023 01:12:15.000 --> 01:12:16.549 Andrew Clegg: The EPC data.
1024 01:12:17.070 --> 01:12:17.530 Stuart Bacon: Okay.
1025 01:12:17.530 --> 01:12:22.730 tristram cary: Because it had been loaded as, like, a raster file instead of a… I mean, not controllable.
1026 01:12:23.810 --> 01:12:33.510 Andrew Clegg: Because the way you'd normally do a thing like that is to take it into table view, and then adjust the columns.
1027 01:12:33.510 --> 01:12:34.690 Graham Stoddart-Stones: it down, yeah.
1028 01:12:34.690 --> 01:12:35.080 Andrew Clegg: Yeah.
1029 01:12:35.080 --> 01:12:36.450 tristram cary: but we… I don't think we can.
1030 01:12:36.660 --> 01:12:37.270 Andrew Clegg: Yeah.
1031 01:12:37.400 --> 01:12:38.039 tristram cary: But that's…
1032 01:12:38.040 --> 01:12:50.129 Graham Stoddart-Stones: It's a straightforward SQL query, you ought to be able to put it into… because you've got everything sitting in a SQL database. Well, I think we need to ask… when we've got the spec of what we want, I think we need to talk to Chris and see what can be done. Yeah.
1033 01:12:50.300 --> 01:12:52.430 tristram cary: But my understanding is, at the moment, we can't.
1034 01:12:52.830 --> 01:13:00.560 Graham Stoddart-Stones: If I go back to David, that link you put in for the EPC data doesn't actually give the listing, it just gives you the individual properties?
1035 01:13:00.850 --> 01:13:05.300 Graham Stoddart-Stones: Did you find the bit that gives you a list of all the properties in the country?
1036 01:13:06.650 --> 01:13:09.600 David Morgan-Jones: I… Yes.
1037 01:13:10.540 --> 01:13:12.360 David Morgan-Jones: John, I'll see if I can find it again.
1038 01:13:13.360 --> 01:13:16.389 Graham Stoddart-Stones: Well, you put A-Link into the chat.
1039 01:13:16.390 --> 01:13:17.269 David Morgan-Jones: No, I did.
1040 01:13:17.270 --> 01:13:20.269 Graham Stoddart-Stones: So that link is not the one that gives the individual.
1041 01:13:22.840 --> 01:13:27.170 Stuart Bacon: Yeah. No, I guess, sorry, looking at the,
1042 01:13:27.340 --> 01:13:33.410 Stuart Bacon: the query from another angle. If you were looking at, say, burials.
1043 01:13:33.830 --> 01:13:39.759 Stuart Bacon: And wanting to filter for anybody over a certain or under a certain age.
1044 01:13:39.900 --> 01:13:44.780 Stuart Bacon: Where you've got, rather than the filter option only existing there as.
1045 01:13:44.800 --> 01:13:47.700 Graham Stoddart-Stones: Equals, yeah. If it was anything…
1046 01:13:47.770 --> 01:14:03.880 Stuart Bacon: greater than or less than a certain result. It's the… well, I guess what we're wanting to do is not… it's not base it on any particular layer, it's the way in which the filter system works to provide that
1047 01:14:03.990 --> 01:14:09.770 Stuart Bacon: Equals is less than or greater than, sort of, option within the filter system.
1048 01:14:09.940 --> 01:14:12.050 tristram cary: So that's there in the operators, is it?
1049 01:14:12.460 --> 01:14:15.330 Stuart Bacon: Well, at the moment, the operator only offers.
1050 01:14:15.330 --> 01:14:17.910 tristram cary: It only offers equals one for all data.
1051 01:14:17.910 --> 01:14:18.600 Stuart Bacon: Yeah.
1052 01:14:18.600 --> 01:14:22.290 tristram cary: Yeah, that's… that it does seem… very limiting.
1053 01:14:22.780 --> 01:14:35.439 Peter Lewis: But on the basis he's offering equals, it assumes that he can manipulate the data. And therefore, if it's a straight SQL query, if he can do equals, he can do greater than and less than, must be able to.
1054 01:14:37.150 --> 01:14:39.709 tristram cary: I've learned not to say must be able to, it's my team.
1055 01:14:40.560 --> 01:14:40.920 Peter Lewis: Well…
1056 01:14:41.340 --> 01:14:44.140 tristram cary: Well, it's a good question.
1057 01:14:44.140 --> 01:14:44.810 Stuart Bacon: Yeah.
1058 01:14:47.810 --> 01:14:53.979 Stuart Bacon: Okay, but if that's… if that's something others see value in, I can fill a ticket in and not waste my time doing so.
1059 01:14:53.980 --> 01:14:58.159 Andrew Clegg: It's nothing like Tristram's presence to generate questions, is there?
1060 01:14:58.160 --> 01:15:03.650 tristram cary: Stuart, if you could, that would be very useful. Why don't you do that?
1061 01:15:03.650 --> 01:15:06.399 Stuart Bacon: Yeah, no, I'll fill a ticket in for that one, that's fine, Patricia.
1062 01:15:06.400 --> 01:15:07.690 tristram cary: Due. Do.
1063 01:15:14.720 --> 01:15:15.770 tristram cary: Good.
1064 01:15:17.270 --> 01:15:24.359 Graham Stoddart-Stones: I'm just looking, I've got, David, I've got a reply from the government that says, here's my link to the list.
1065 01:15:25.870 --> 01:15:29.059 David Morgan-Jones: Well, if you, if you… I'll share my screen.
1066 01:15:29.250 --> 01:15:32.710 Graham Stoddart-Stones: It's a very large file, it's 5.8GB, it's wonderful.
1067 01:15:32.710 --> 01:15:43.109 David Morgan-Jones: Yeah, but if you go… if you go down, the left-hand side, and it says there's a, a banner, a title called Local Government.
1068 01:15:43.340 --> 01:15:46.250 David Morgan-Jones: If you then click in your local authority.
1069 01:15:47.580 --> 01:15:48.460 Graham Stoddart-Stones: Right?
1070 01:15:48.460 --> 01:15:54.329 David Morgan-Jones: and then, filter. It will then filter, so for… I assume you're on the Isle of Wire, aren't you?
1071 01:15:54.330 --> 01:15:54.870 Graham Stoddart-Stones: Yeah.
1072 01:15:55.220 --> 01:16:02.010 David Morgan-Jones: Yeah, so if you select Isle of Wight, it will then filter the, dataset down to the Isle of Wight.
1073 01:16:03.160 --> 01:16:07.500 David Morgan-Jones: And then it will produce… for me, it only produced 6 megs.
1074 01:16:07.690 --> 01:16:15.250 David Morgan-Jones: And interestingly, I've just been looking at the, the spreadsheet that it's downloaded. It's got the.
1075 01:16:15.250 --> 01:16:16.000 Graham Stoddart-Stones: UPRN.
1076 01:16:16.000 --> 01:16:18.919 David Morgan-Jones: the UPRN for every house that's been uploaded.
1077 01:16:18.920 --> 01:16:20.649 Graham Stoddart-Stones: It's gonna make your life very easy, isn't it?
1078 01:16:20.650 --> 01:16:26.390 David Morgan-Jones: Yeah, so I'll do a spreadsheet merge and identify those
1079 01:16:28.230 --> 01:16:30.259 David Morgan-Jones: The only one it… it's like…
1080 01:16:30.390 --> 01:16:39.530 David Morgan-Jones: complexity that I'm gonna have is that it's… it's downloaded heart as opposed to the parish. So it's defining what
1081 01:16:40.920 --> 01:16:44.559 David Morgan-Jones: what houses constitute the Ushot Parish?
1082 01:16:46.450 --> 01:16:52.270 Graham Stoddart-Stones: From that, that large, heart list. That you can get from Parish Online, so that was what…
1083 01:16:52.500 --> 01:16:53.209 tristram cary: No statistic.
1084 01:16:53.210 --> 01:16:55.729 Graham Stoddart-Stones: And you select the parish record, and then…
1085 01:16:55.730 --> 01:17:01.569 David Morgan-Jones: No, no, I've got… I've got the… I've got that, which is the EPC data set.
1086 01:17:01.570 --> 01:17:02.980 Graham Stoddart-Stones: Damned I did that.
1087 01:17:02.980 --> 01:17:12.179 David Morgan-Jones: You don't have… you do the address list, use the address list, and you get the address of every building. Oh, right, yeah, of course, it's the address list. Let me just check the…
1088 01:17:12.180 --> 01:17:13.139 tristram cary: do the addresses.
1089 01:17:13.140 --> 01:17:15.799 David Morgan-Jones: The address… let me just have a look, and .
1090 01:17:16.480 --> 01:17:19.410 Graham Stoddart-Stones: So if you go in, just click anywhere in your parish.
1091 01:17:20.650 --> 01:17:21.820 Graham Stoddart-Stones: Parish record.
1092 01:17:23.780 --> 01:17:27.820 Graham Stoddart-Stones: And then in the parish record, there's a facility for extracting data.
1093 01:17:28.250 --> 01:17:29.040 David Morgan-Jones: Irish.
1094 01:17:29.150 --> 01:17:31.979 David Morgan-Jones: Online, somehow I've lost it.
1095 01:17:32.240 --> 01:17:35.240 David Morgan-Jones: Okay, whizzing through, logging in.
1096 01:17:37.280 --> 01:17:39.940 David Morgan-Jones: Alright, so if I just share…
1097 01:17:42.480 --> 01:17:48.500 David Morgan-Jones: So, okay, so I'm now… I'm now in here, so if I just click on here, I've got my parish stuff here.
1098 01:17:48.500 --> 01:17:51.899 Graham Stoddart-Stones: Alright, so go up to the top, the down arrow up there.
1099 01:17:51.900 --> 01:17:52.460 David Morgan-Jones: Yup.
1100 01:17:52.930 --> 01:17:56.170 Graham Stoddart-Stones: To click on that, Type in address space.
1101 01:17:58.930 --> 01:18:00.579 David Morgan-Jones: Address plays plus points, isn't it?
1102 01:18:00.580 --> 01:18:04.689 Graham Stoddart-Stones: That's it, right? So those, that's every building in your parish.
1103 01:18:04.690 --> 01:18:05.690 David Morgan-Jones: Perfect.
1104 01:18:06.130 --> 01:18:09.040 Graham Stoddart-Stones: So, follow suit with them.
1105 01:18:09.700 --> 01:18:13.920 Graham Stoddart-Stones: Stuart's advice, and just export it. Click on the export button down the bottom left.
1106 01:18:14.160 --> 01:18:14.880 David Morgan-Jones: Dumb.
1107 01:18:14.880 --> 01:18:16.250 Graham Stoddart-Stones: And get it all out, yep.
1108 01:18:16.960 --> 01:18:17.940 Graham Stoddart-Stones: There you are.
1109 01:18:18.170 --> 01:18:18.680 David Morgan-Jones: daughters.
1110 01:18:18.680 --> 01:18:22.509 Graham Stoddart-Stones: a VLOOKUP to the other list and get all the certificates?
1111 01:18:22.510 --> 01:18:32.080 David Morgan-Jones: Yeah, yeah, I'll, I'll, I'll, I'll, yeah, I'll merge the, the, the, the link in the spreadsheet and, do the, do the, do the needful. That's super, thank you very much, everybody.
1112 01:18:32.450 --> 01:18:40.300 Graham Stoddart-Stones: Right. Good. If there are no more questions, everybody, thank you very much for a fascinating session. Enjoyed it, hope you did too. Have a good week.
1113 01:18:40.300 --> 01:18:41.380 David Morgan-Jones: Yeah, yeah, thanks very much, Graham.
1114 01:18:41.610 --> 01:18:44.159 Retired Clerk: Bye, Grant. Bye. Bye.
1115 01:18:44.160 --> 01:18:44.670 Peter Lewis: Thank you.
1116 01:18:44.670 --> 01:18:44.990 tristram cary: Bye.
Last updated