 Hi there, welcome back to my YouTube channel. This is Daniel Rosal here in Jerusalem. So I just did a video looking at GIS GovMap actually is what it's called. It's the Israeli government's GIS system That is freely available on the internet. You just need to go to govmap.gov.il in order to access it And it is a really really powerful tool containing lots and lots of info now If you kind of showed your average person GovMap, they might say well that looks like kind of a something like Google Maps and the the difference really between this and Google Maps is that there is just So much information. It's why it's called a geographic geographic. I'm not sure geographic or geographical information system and they're basically you have layers of information and You can create a layer as a registered user for your own access but the layers are basically data layers maintained by Public bodies government bodies in Israel and these are put on to the map because it's a lot more interesting to engage with you know data when it's presented on a map format and You can we'll see some other really cool things that you can do in a moment, so I've talked about before how you can one of the one of the layers in in GovMap that you can manipulate is the layer of G of the cellular antennas cellular connectivity and that's really useful if you're trying to figure out let's say Well, who is going to be if I move to this neighborhood who's going to have infrastructure there now? I've talked before about the differences between mobile operators and MVNO's mobile virtual network operators and that It's useful to know if you're using an MVNO Let's say like Rami Levy mobile Well, who's infrastructure do they use and it really comes down to cellcom Palafone or this company called PFI Which is hot serving hot and partner. So if I go into Jerusalem and the lovely city of Jerusalem and if I turn on the the Layer for Cellular One one one one moment. It's it's not like in this. Oh, there we go I can turn I can turn this on and now we're seeing all the antennas. That's what you're looking at here on the map now It color coded so you can see each one each company. This is a telephone. This is this company called PFI PFI or I think it's PHI actually PHI yeah, PHI and you see here Michelette at hot partner and Basically, you can go into anyone and you can see the identifier you can see Where it is you can see what type of antenna it is you can see when it was last inspected you can read an actual description of where it is and Very importantly, you see here at the bottom door Salosh Arba. You can see what it's broadcasting This is a 3g and 4g antenna Now, let's say I wanted to know how many How many excuse me? Antennas there were in a certain area that had fight that were 5g capable. So Then I could add a filter on to this antenna layer. So there's a see-noon button here and If I scroll all the way down to the bottom, I've got technology at technology or she do which means broadcast technology and There I can let's say I want to search for 5g 5g Sorry, just five now the way they the way they do it is that each They separate in the filter each You know if it's like a 5g antenna or a 5 and a 4g or and a 5 and a 4 and a 3g or a 5 and a 4 and a 3 and a 2g They're all separate. So you just need to like click a little bit here 5 5 5 5 5 and finally 5g only and now what you're looking at is all the 5g And I sell your antennas in Jerusalem. This is where they are This is who operates them all The information one might want to know about 5g in Jerusalem now There is one more cool thing you can do and I said I would just do this do this video to showcase it Say you wanted to know well, how many 5g towers does cellcom have in Jerusalem or in this Area so what you can do then is click into this function and go for the boxing tool and What this allows you to do is you tell it firstly what layer what layer we want to extract our data from so we're going to extract data from the antenna layer and next how we want to How we want to select the area so we can do a circle which is good for a radius obviously we can do a box We can do a user-defined shape I'm just going to do a box for the simplicity of this demo and I'm going to just look at like kind of West Jerusalem ish here for 5g and Find all the antennas Now watch watch in awe as it packages up the info 407 antennas in that box so that's how many antennas that it was able to find That's a lot of antennas in that area. So that's like this is like the the spreadsheet. We're going to get here It's gonna be like West Jerusalem antennas Star study directory. It's all the antennas now what you can do is an under owed you can click on your say To export it to an Excel document So I click on that and I would get Download 3.xls and now we can do some work in a spreadsheet editor as opposed to on the internet So this is where again the power is really kind of coming to shine through and you can answer questions like well How many 5g antennas does cellcom have in Jerusalem? You know you might what you might want to know and of course by the way this video is being recorded on The upload date and therefore the situation might change drastically So just for the purpose of simplicity now it's liberated all the info we had online for every single antenna It has the identifier. It has the address. It has the It has whose authority it's under Jerusalem municipality in this case It has the Date of the last periodic inspection What type of an antenna it is I mean everything you can filter on absolutely all of this information and put your spreadsheet wizardry to work Here I'm just curious what this one is actually. Let me just take a quick peek. Oh I think it even has like the license for a specific antenna. You can go through it one by one Just just check This is on the Siviva, this is on the website of the Not sure this is actually going to work. Anyway, anyway, let's not go off in a while while tangent here So what I'm gonna do it and then now this is the important bit is the what type of an antenna is it so you can see This is mocked up everything your 2g 3g 4g antennas your 4g or 3g only antennas. What I'm going to do is just to simplify this video I'm just going to Get rid of everything except for company and what type of antenna it is and this is how you can this is one Way to count cellcom 5g Towers in Jerusalem would be to I'm just going to use the I'm just going to use the auto smart filtering function here on LibreOffice calculator and I'm just going to apply a smart filter and Now what I can do is filter only on So you can see it show me all the different options here Or you can't actually see that but I'm able to search items for five. So there's five four and three There's also There is also actually one sec. I'm just going to just going to move move myself because this is kind of the Important part you could say of the of what I wanted to show So, you know depending on what software you use will be a different I'm just going to go for five four and three g five four three two Those are the 5g options that I'm seeing which makes sense that They have some 5g on some for arms and on some four and three g antennas And then on the like antennas that kind of do do it all including 2g So those are the two permutations. It's found throughout all of that area in Jerusalem So I'm just going to filter only on those five four three two and five four and three And now we just got a list of all the 5g capable antennas in Jerusalem along with to operate them and there's actually only There are Let me just see one second There are 42 of 407 records found that reflects the state that it's an early deployment Now, you know, you can see basically there is PHI have a number of them Selcom have a number of them and Pelopon have a number of them You know, there are more easier ways to count but we can just also use Use this manner here Okay, so I just unhid the counting the counting a quick tool there on the bottom right so PHI which is servicing hot and partner In this now, this is just this box. It's not the official Jerusalem municipality boundaries But in this box of the 407 407 400 or something antennas PHI has 17 Selcom has this many and Pelopon have this many Selcom has that is Selcom Selcom has 16 and Pelopon has nine so that's basically how Sort of straightforward it is to use the GIS tool draw a circle or a box or Hectagon or a pender whatever the word is for that custom geometric shape and in order to analysis analyze an area of territory according to according to a layer that you've they're looking at in GIS in this case looking at the Looking at the cell phone deployment and the 5g deployment and I can see for a whole city or for a neighborhood or for just a little bit of a neighborhood exactly how many 5g towers are in that city and Who operates them and which company if I was looking to go with whatever company the most towers? With about one minute in a spreadsheet program. I could also find that out So hope that video was mildly interesting to anyone interested in technology in Israel And particularly in subscribing to four or 5g connectivity And just yeah, if you're interested in getting more tech videos from me, feel free to subscribe to this YouTube channel