> For the complete documentation index, see [llms.txt](https://chagos.gitbook.io/parish-online/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://chagos.gitbook.io/parish-online/parish-online-banter-sessions/251003-03oct25-session-25-40.md). # 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 {% embed url="" %} ### 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](https://www.somerset.gov.uk/planning-buildings-and-land/street-naming-and-numbering/)\ 00:23:44 David Morgan-Jones: [https://epc.opendatacommunities.org](https://epc.opendatacommunities.org/)\ 00:30:11 Stuart Bacon: [https://shared.xmap.cloud?map=0ef40ce2-d7c1-4b83-9b35-a1477b62972b](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](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](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](https://shared.xmap.cloud/?map=bc99dc6f-a870-4e73-a9fd-fec8ded5e367)\ 00:44:24 Stuart Bacon: \ 01:13:57 David Morgan-Jones: *** ### 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.