 This software called gram plus plus the demonstration of which I will be showing you on the screen in a moment. So Like I work under her as a research associate as I said earlier. So as you can see I will be starting with the presentation as you can see on the On your screens like gram plus plus The main interface of the software is seen now basically gram stands for geo reference area Management, okay, or if you can see it as in local terms Gram for pronounced in English as gram for gram in Hindi village level, you know, like so something on those lines Indigenous officer, so like a more of a Indian name to it. Yeah, so as you can see there are four main modules in the software Okay Now basically the data Preparation like whenever you want to do any analysis you require the data, right? This is GI should allow you to prepare the data on your own you and do the analysis and get the output So the first module in the software is data preparation Okay, I'll show you one by one. I'll just explain all the modules in short first So data preparation basically allows you like there are two options either you can prepare the data yourself or You use the data, which is readily available Okay, now the data which is available is normally in the form of either shape files or some AutoCAD files or something of those On those lines, so you can import the data from those formats into gram plus plus raster or vector format Import the data and you can analyze it Okay, or you when you don't have the data which is readily available Then in that case you have to get the maps scanned you open it in the background and do the on-screen digitization Okay, like maps you can get from agencies like survey of India We which are supposed to supply the authenticated maps of the entire country. Okay So you get the map scan it using a scanner and then open it in the background of the screen and do the on-screen digitization, okay Now once the data is ready, then you can do the analysis based on what model is suited for your application So you can have either vector GIS Where in you can do network analysis you can find the shortest route between a given source and the destination Okay, then you can do analysis like ma'am was showing. Yeah You can export it to shape files. You prepare the data in gram plus plus native format and you export the Data shape you can do that. Yes So in vector GIS, then we have got functionalities like you can do Query like you ask the system some question like show me those villages where population is more than hundred the system will show you the Output on the screen. Okay, so you can prepare thematic maps like based on a population You want to make a colorful map in five different colors or six different colors and you can do that as well You can maintain a hierarchy as ma'am was showing you in her presentation from a country map You can go to a state map from the state you can go to district and so on. So that is possible in the vector GIS part Then comes in after GIS which Allows you to make buffers around a given entity. Okay, you want to make a buffer now during rainy season We say one kilometer area around the River was flooded. Okay. Well, like water and the area got flooded. So how much is one kilometer from the river? You can do buffer on that and get the actual Data. Okay, so that helps that can be done with the help of buffering then you can do watershed delineation like given a point Where all the water will get collected from? Okay, whenever you are thinking of constructing a check dam or a bund or something then you do need to do those kind of Analysis, so where can you construct a check dam? The system will tell you that Then you can do a bit of image processing in the software as well We have provided a module for that as well image processing and a bit of statistics Okay, and then the last is the visualizer module wherein whatever data you have prepared you can Prepare a layout of it so that you can take the printout of that data Okay, so these are all the four modules in short of which will be seeing them one by one, right? And of course last but not the least is the help module which will which kind of takes you through the entire Functionality of the software. Okay, so now first I will show you the data preparation module Yeah So when you click on data preparation the system like there are two options either you want to import the data or You digitize the data. So first of all we'll see some examples of importing data So as you can see on your screens, you can import data from AutoCAD, DXF files You can import data from ArcView shape files Then DVD now, this is not the DVD which actually comes to our mind, but this actually stands for Digital vector data. It is the format provided by Survey of India in case you are asking for a soft copy Okay, normally they as you know, they give the hard copy maps, isn't it? The toposhoots we call them So if you ask them for the CD format, they give you in DVD form digital vector data Okay, then you can import data from a bitmap or raw file can be imported You can import data from ArcView grid data and Ungen data. Okay, at the same time the data can be exported to this formats Okay, now let us see an example. We'll try to import a DVD data So we'll create a blank file first It's a vector file. So we go to that particular Folder and create the data first We'll write the name of the file a new file ideally then map name Basically map name will be the area what you are working on. Say for example, if you are working on this map What we have got is of Kola district in Karnataka, so we'll write Kola here and we'll say create So basically a blank file gets created with polygon segment and point under it Okay, so then we'll click on file import vector from DVD So when you click on it, the system will ask you the DVD file and the info file So first you specify the DVD file. There are so many files in the on the CD So you can click on whichever you want. So say first you click on this file And then there is another text file which they give it contains the information about the area who had surveyed it What scale the map is in okay, so you specify that file as well and just say okay So the system will show you the status. What is happening with the file? It is reading the data Then it will write to the vector file And once it is imported the system will automatically load the data So whatever layer you want, they will get categorized under polygon segment or point. Okay, so For example, we click on each of the layers. They get highlighted one after another as and when you go on clicking So this I am clicking like road railway line. You can click canals. You can click You can click the drainages. Okay, these are all the drainage patterns Then some of the point layers you can click Some points are there railway stations are there along the railway route And some other points so this way this is the entire information Is same as you get it from the yes, sir. Yes, ma'am Digitized data ma'am. It is a digitized data And no not required you can straight away use this for your analysis. This is already done by survey of India Yes Then you have to do it. Yeah, that procedure I will show you ma'am. I'll show that so The data is readily imported and then this you can use it the way you want. Okay, so this is an example of vector Similarly, you can import data from dxf and shape or arc view shape files. Okay We'll see an example now for raster data We'll try to import our arc view grid as key file. So again, we create a blank raster file We'll say create and then we click on file import raster from arc view grid as key Okay So when you click on that the system will as usual ask for you as key file And you can just open it and View the format of the file Like you can open it in notepad. So this is how basically the data is written in an as key file The number of columns as you know raster has rows and columns, right? So the number of columns is written the number of rows Along with what is a cell size in x and y direction 20.62 meters and then your data starts Okay, all this is your data Row, I mean pixel wise. Okay, the data is written pixel wise, but in row first row second row third row that way So we'll just see how it looks when it is imported into raster So it gets immediately displayed onto the screen. So this is basically an example of raster Okay from arc view grid as key. Similarly, you can import data From any of these formats from a bitmap from nrsa like if you have got list 3 or pan files Then you can import straight away those files into gram plus plus raster form From a jpeg you can import and even there is a format called geotip Which basically is a tip file, but it has got coordinates of the area which is required Okay, so that file is called as geotip file. So even the data from geotip file can be imported Okay, so this is the example of raster and vector import. Okay, now let us see When we don't have the data, what do we do in that case as I'm saying like when you have got a topo sheet Okay, so in that case what you have to do you get the topo sheet you scan it Using either is a 0 a4 a3 whatever is the size of the sheet Scan it and save it as either a bitmap a jpeg or tip whatever format is required You save it in that format You open it in the background of the screen and then you can do the onscreen design So let us see how to do that So for that we go to module called map edit. Okay, as the name suggests you can edit a I mean edit any kind of a map over here So a blank screen pops up. So first we'll create a new file The system will ask you for all the information Like what is the name of the file, etc So you have to go to the particular folder where you have saved your bitmap And you can create a file there So say We have got some area I mean some map of KEDA over here as an example So I'll write the name of the map as KEDA So you can see automatically the extension dot vc is taken Okay Map name will again be KEDA And description like whether it's a district level data or block level data Whatever is there you can enter the information Else you click on the next screen Now here you are supposed to enter what is the projection of the data Okay at what projection you are going to digitize the data So most of the times we use polygonic But apart from polygonic we have got other options like Albus to standard nominic lambels to standard marketer is there Even UTM is there So based on whatever projection you require you can select that projection And here you are supposed to enter the scale of the map What scale your map is Now in the toposheet normally it is at 50,000, 25,000, 1 lakh Right So whatever is the scale you have taken you enter that So now for example this map is at 2,50,000 scale So you enter that click next Here the system will ask you to enter the origin parameters The map origin or false origin as it is sometimes called Okay now basically this origin is nothing but the center of the map Okay the center of the map So basically you calculate that now for example Your map is varying from minimum latitude 22 degrees And maximum latitude 23 degrees And minimum longitude 72, maximum 73 So the center will be 22 degrees 30 minutes Average of 2 basically obviously 2230 and 7230 Okay So that parameter you are supposed to enter in latitude and the longitude Okay Now the map what we have got has got a false origin of 2245 And 7300 And we keep these buttons like for example Like if you are in the northern hemisphere or southern hemisphere You click the appropriate button And if you are eastern side of the equator or on the western side So you click again whatever you require So now once you have done that click finish Okay Now we will open the image in the background So we click So as you can see the image gets opened in the background now Okay this is a scanned image Okay this is a scanned image So you just click on that file and it opens up in the background So now the very important step in GIS is registration of a map Like for that is you are providing coordinates to the map Now basically for system this is just a scanned image Like unless and until you give some coordinates to it It doesn't become a GIS Okay So that registration is a very important step in any GIS tool Okay So for that we have to give the tick marks to the image So that we normally it's also called as tick marks So you zoom into the four corners Okay Or if in the corners the latlong is not available You take the known latlong point The intersection of the known latitude and the longitude Okay So here and if you mark it beforehand Before you scan the map it helps Like it helps you in reducing the errors at the time of registration Okay So as you can see here we have already marked the Corner points Okay So we just keep our cursor exactly in the center and click there And then the system will ask you to enter the latlong of that point You're supposed to enter the latitude longitude of that particular point Okay So for this the latitude is 20 to 15 And the longitude is 72 30 Okay You can or rather you have to get the corresponding ground coordinates also What is the actual ground coordinate of that particular latlong So you can convert it and get the coordinates and say add So as you can see in the tick marks the first point is taken Now it doesn't necessarily mean that it is accurate It is right or wrong It only for the system it is just accepted the point Okay So now we will enter the second point So you come to the original scale and zoom to the next corner Normally we do the registration in the anticlockwise way Okay Now we are going to enter the second latitude The latitude since we are moving along the same line Latitude remains the same So it is 22 15 And the longitude will increase now because you are moving to the right So longitude increases So we make it as 73 30 Convert and add So second point is taken Yeah at the same time you can see whether the tick marks have been taken or not Like there is a show tick marks button Which will like tell you what tick marks you are taking And also for people to know like whether any tick mark is there It's normally written at the edges So you can also get the latlong from that point Okay So now we will enter the latitude of this point So now we are moving up So latitude also changes Longitude remains the same But latitude changes So it is 23 15 And 73 30 Convert it and add it Again Minimum four are required Okay maximum can be any number So you click there and enter the second Now we are coming back So latitude remains the same But longitude decreases So 72 30 convert add So now four points are taken Right You can see it Four points have been taken Okay Now we have to calculate The RMS error How Yeah So the accuracy increased by taking about checkpoints Yes Then in case you don't have properly defined latlong marked on the map So then you go for more points Okay That way Yes Yes Based on the projection what you have chosen Based on the false origin coordinate You have given false origin in a meter coordinate Accordingly with the projection in mind Data in mind that Ground Calculation is done Yeah So what's this is done We don't need to do this direction No it is only registration This is only registration on the map sir Now when you digitize The data will get stored in the ground meter In that projection Yeah I'll show you that So now you have to Yeah That basically will be used while calculating the errors Like since you have given the point in the center What happens the error if any it is there It will get equally Spared in all the direction Distributed equally right At easy you need an R Origin is required also To calculate the coordinates Yeah So in the beginning what we gave is This is the point where 500,000 500,000 is the meter Based on that you calculate the meter for anywhere in your center Okay And here why are we giving 4 Suppose you use an affine transformation Affine transformation needs what 3 equations So 3 unknowns So if you give 3 Your error will be always 0 But you have some error Because you know it will not be correct So to judge you how much error Come say come you have to give one more point So that's why he said minimum measure 4 points One should give not in the Anywhere you register In any tool you use You should see Whatever the polynomial transformation you take You should give some extra points Then only you will be able to get there again Okay Even if you work on remote sensing data Yeah And also like you can treat this as a graph paper If you take it in the center Like if you take it in one corner Your coordinates may be negative right So if you treat it in the center Everything is keep the coordinates positive Okay So yeah Now once you have calculated the errors This will show you rms error Okay root mean square error So the error is around 5 meters Now your scale was 1 is to 2,50,000 Quite a high Quite a I mean quite a high scale Or so this is very much acceptable Is hardly a pixel Isn't it So you can accept Otherwise if there are If the scale was 1 is to 100 Then you can't accept this much error You have to be Of course ideally you have to be close to 0 But we can't achieve 0 accuracy anytime right So you have to have a certain acceptable limit So based on the scale The acceptable limit has to be set Yeah So once you See that's what again you should calculate The scale of the map See suppose you take 1 is to 250,000 scale map What is 1 millimeter on the ground 25,000 See 1 millimeter is 250,000 millimeter on the ground How many meters 25,000 Okay centimeter 25,000 And centimeter to meter 3 2 zeroes So 25,000 So 25,000 So 25,000 So how much is it 250 250 Yeah 1 millimeter thickness is 250 meter on the ground On a 250,000 scale map That one has to keep in mind See these all we teach during accuracy How you should quantify your accuracy So again So you should keep in mind If you are digitizing As he said a 500 scale map Your error should be around a centimeter If you are doing a 250,000 scale map What is your acceptable limit You should not go beyond that Millimeter which is your thickness of your land Okay So once you find that The errors are acceptable You will say okay Otherwise you have to repeat the procedure Okay Now once the map is registered Now you can see on your screens at the bottom Wherever I am moving the cursor The coordinates are changing At the bottom you can see Right Wherever I am moving the cursor The coordinates change So now this is a The tick marks Putting the tick marks procedure sir Registration to be done again So as you can see now Once the map is registered The coordinates change at the bottom Right So now you do the digitization Actual digitization will be done now That too layer wise Now for example You will be doing the outer layer Outer boundary first So you click on layer new And give the name as outer Boundary And since it will be a closed polygon You take it as Polygon type Roads, railway line, etc will come under segment And any spatial location will come under point Okay You need to categorize it Contours will come in the segment So polygon and say okay So automatically the layer is created under Polygon layer On the left hand side So just activate it And that means the system knows That you are digitizing outer boundary So now give the command to the system That I want to add segments So suppose for example You want to start the digitization from here So keep your cursor there Zoom in So that you digitize the boundaries accurately And then start with the right click And continue all with left click Ideally follow the center of the line Yeah So this is how the digitization is done No everything is done in the same software sir Yes sir Both are there sir See here you can see both are there You can see at the bottom sir Both are there Press the convert So you see You should get the lat long And the coordinates in down meter are stored inside your machine Okay so you should handle both That is the reason we are doing registration And we say Center this point should be 500,000 Conor I give lat long We press convert Convert converts as per your projection and state Into meters so both should be there Now for example while doing the digitization By mistake you have clicked outside or something Then you can always delete that point And you can continue the digitization Okay as many deletes you want You can perform and then continue from that same point And digitize the entire boundary right And also at any time you can see how much you have done So the system will also show you that part How much the digitization has been done Okay So this way you can create as many layers as you want In a GIS it is always better to have layer concept Right because if you do everything in the same Layer what is the use of having a GIS in it right You can't analyze a separate layer It right yes sir yes ma'am Yeah it will open with the same that all thing has been taken care of Okay ma'am So this is how like now once the map is digitized There are other things like of course ma'am must have covered that in the morning You need to clean the map You can't take it just like that right You have to clean the map why Because we are all humans we can't be accurate while digitizing So there will be errors like this There will be undershoots Right there will be overshoots And there will be something called as sliver polygons Whenever two polygons overlap just very little That a small polygon is formed that's called a sliver polygon So that is also not required right So all the three are taken are to be taken care of right So for that there are two ways either you can do automatically Or you can do manually So first let us see how to do it automatically In automatic cleaning you only have to specify The undershoot distance and the overshoot distance Now if you feel the overshoot distance is going to be around 10 meters So you keep that 10 meters over here For overshoot as well as undershoot Okay and sliver tolerance you can keep Like 2 meters or 3 meters whatever So what will happen Even case the width of that sliver is 2 meters And it will dissolve it And form one common boundary between the two polygons Okay that you have to like guess based on your scale map Okay so when you say okay the system will say clean is complete But the errors are still there That means these lines are more than 10 meters So now in order to save time I will give more distance Okay so now of course you will like whenever one is doing You have to go step by step So you say thousand thousand and say okay As you can see now they are automatically joined Yeah they found that distance is within 1 kilometer So it will snap it to the nearest point Okay but one is still remaining That means it is more than that And whenever you do digitization it's an overshoot It is not required always have overshoots Because they are easy to delete Overshoot undershoot may the problem is You do not know where it is to be joined Right so in overshoot it's better You can just click and delete it So we will see manually how to do that Just select that line and delete it Gone yeah So now the map is without any error right So you clean once again And now it doesn't show any error How come no it won't You know what will happen Technically we are not telling you how we are running time garners See whenever you overshoot the first step what clean does is It breaks the segments at the intersections That is the first step it does Then only you can form the topology As you can see here there are options Like break segments at crossings You can see on the screen While cleaning there are options Break the segment at the crossings Wherever there is an intersection Automatically a break will be done Then remove any duplicate segments Remove any redundant nodes Everything is taken care of map Right Then we form the polygons Or in JIS we call it as building the topology So we will say form polygons The polygon formation is complete So with this what you can do is You can get an idea about whether each Polygon is formed individually or no It gives a test to that And also internally a relation is created between polygons Polygon A is to the right of B to the left of C like that Spatial relation is of course that you do not see That is for the systems purpose Right So this way you can find the polygons Whether they are formed individually or not Okay Otherwise sometimes what happens You may feel like there are two polygons are closed by And you can see there is a line But sometimes while digitizing You may have taken that line back again So a polygon for the system it's a polygon So there may be a gap in between Right So this test basically helps you in removing that error The next step is to label them Identify them Why are you doing these excise Because you want to do some queries etc Right So you need to have the names of the villages Or the blocks or the tassels So here we have given the numbers If you have the names you can write the names Pune, Mumbai, XYZ Okay whatever is the name of that area Or village you can write that And then you will see label polygons So here if we want to redefine the labels That is you want to say one is so and so Two is so and so Then you use label redefinition file That's a notepad file or a text file And say yes Otherwise if you want the same labels Then say no So the labels will be attached Yeah like there are around 76 polygons That is it Yeah but It is there There is a line here so you can see It's not required but it is just taken actually As a frame It's basically a frame you can treat it as a frame Not necessarily just we have taken it Okay Now once the labels are attached The next step is to Database Why database? Because for each village or a district or a block You have got data sets like population Literacy rate Male population female XYZ So those data Can you show population on a map Population of a place can be shown Not for the population in general Right So the population is Population and those attributes are termed as non-spatial data And the map is a spatial entity So you connect the spatial entity with the non-spatial data With the help of a database Database becomes the link between them Okay And the database what we are using is MS access Okay So create table And you give the name of the database file Say magia And give the name of that table also So table creation is complete And you can see the information Table gets created Now by default We are storing SID Which is generated by system System ID It is generated by system You should not change this UID is given by the user That's why it stands for user ID Perimeter and area Now all It automatically is calculated sir Based on your Digitization it gets calculated automatically And other attributes like population etc I have You have to add it By either going to MS access Or there is a tool in the software Which will allow you to create fields And you can just enter the data yourself Okay Right There is also an option of rasterizing this data That is whatever you have done Some functionalities may not be possible in vector So for that you require raster So you can even rasterize the data sets There are some few options For what pixel values you would want Either you want unique You want by class generated That is whatever you have generated You want those values Or you want the actual values Whatever the system has been given So suppose we go for by class generated Next What size you want 8-bit, 16-bit or 32-bit And then The size of the map Like what How many columns by how many rows you want the data to be Raster we normally call it raster is flexible You can have it at 10 by 10 You can have it at 1000 by 1000 Or you can have it by 25,000 by 25,000 Okay so raster is flexible Okay So suppose we go for 1000 columns The rows are automatically adjusted Based on your area of the map Okay So when we say next And say finish The map is created So now let us see How the map looks So we go to the visualizer tool And we open the raster data set over there There is an option of 2D or 3D We will first see it in 2D And you can see the entire map is rasterized I can see when I am On any polygon you keep your cursor You can see the pixel value at the bottom Pixel value at the bottom can be seen here What is the pixel value Like for example for this polygon For entire polygon it is 2 But moment I go to the next polygon It will change That is how it is supposed to right They are all individual polygons So you should have different Pixel values for different polygons Okay So that is what will happen And you can anytime if you want to Change the color etc You can do that Whatever like That of course I will show you Once I am handling this module So this is how the data will look like Okay and you can see the columns Rows position at any pixel At the bottom Along with the Ground coordinates or latlong If you have registered the map in latlong Then even that can will be seen Okay For this map there is no latlong That is why latlong you are not able to see So this is how The map edit module works And in case in the beginning If you have registered the map In a wrong way Okay you can always re-register it Giving the correct latitude to longitude You can always re-register the map Or if you want to change the projection If you want to take it to some other projection You can always do that Okay So those tools are there So this is basically map edit module And at any time you want to correct any data Or update any data You come back open your map here And do the updation Okay so That is why the module is called map edit You edit a map at any time you want Okay So these are the functionalities of Map edit module So we have finished data preparation Now data is prepared Data is ready So next step is to analyze it Right Basically why are you preparing the data Because you want to do some analysis on that Right So we will first We will do the vector GIS Vector analysis Now first we will try to see the vector query module Okay So now vector query module basically Helps you in doing non-spatial query You have prepared the data You have attached the database Okay now you want to get some outputs Based on your certain questions or queries So you do that over here So you open the vector query module And you open the data first So we already have one data set ready with us So we will open that So now as you can see there are so many layers Which we have digitized For this particular layer For this particular file Okay it is particularly one of the blocks in Patiala district of Punjab actually So for example you activate land use layer This is the land use of that area Okay Now does the map make any sense Nothing is highlighted So you can fill it in different colors Okay So we will do that We will fill it in different colors You want solid colors or you want patterns Both the options are there So say for example you go for solid colors When you say okay the map gets filled with Automatically some colors What does each color indicate? Not clear So highlight the legends So the legends will tell you what is what All the gray areas show salt effect So of course if you want to get the color If you want to change the color You can do that That is an option of change fill color Select the particular color whichever you like Say okay And click there the color gets changed Yeah So basically the color you have changed is for cultivated double crop Okay So same way you can go on changing colors Whatever you want In the same fashion Say change fill color You want green color for forest Say okay And the color will change So everywhere forest is there Okay And at any time you want the labels to be highlighted The labels also will get highlighted Okay Then you want to now on top of this You want to show some roads Okay on top of this you want to show some roads So you can activate the road layer Fine And you can say select the line style The colors etc So you have got some styles solid dash Dash dot dash dot dot So say we select solid We will select width as 1 And the color will select Let's say red color Okay The color of the road will change Yeah Then on top of it you want to show some important locations So highlight the important locations In case that also you want to change the styles You can there are some fonts which we give by default So those can be chosen And color can be assigned to it Say black color And you can see the labels of those locations as well Okay So Then you want to give the title to this So you can do that Say this is for nabha block So we can write the data The title as nabha block You want to change the font etc You can do that You click wherever you want the title And you can enlarge it Whatever size you want Then you can give the scale bar Because if you give this map to someone You should be able to know what is the scale of the map Right So the scale bar will be Scale can be given You select the units as kilometers meters Based on your scale So we select kilometers And we will say Say Number of divisions are four And size of each division That is one division represents 10 kilometers And we will highlight our graphical scale So the system will show you What is The scale of this map Right So as you can see the distance between Like you measure that distance So between 0 and 5 If it is say 5 centimeters So 5 centimeters on the map is equal to 5 kilometers on the ground I know I hope everyone knows that Okay Right So that is how the scale is to be interpreted You can give the north arrow We have got quite a few A few around 5 north arrow We are providing So whichever the user likes you can select that Say okay And click it wherever you want You can resize the north arrow Any subtitles if you want to insert You can do that For example This is under Patiala district So you can Write Patiala district Again font etc can be changed Using any color or anything you want Okay Even if any local fonts are there on Installed in a system Even local fonts will come Okay But of course what do you call that The conversion will be Transliteration will happen Like if it is If you have written Patiala district In local font also it will come as Patiala district It won't come as Patiala Jilla Or something like that Okay Right And then Most important like latlong grid Yeah So you can give the latlong grid also over here Now actually I don't know whether it's visible Yeah If the system shows you minimum Latitude and the maximum latitude And minimum longitude and the maximum longitude So you can specify from what latitude You want to start your Latlong grid Okay So now you can see here it is 30 16 So we will write 30 Start drawing the lines from 30 15 And for longitude minimum is 75 57 So you can say 55 And interval will be based on your Obvious interval like whatever is if the The difference between minimum And maximum varies in degrees Then you give degrees either 1 degree 2 degree like that Or if it varies in minutes you give in minutes So here the variation is in minutes So we will give say 3 minutes So the system will draw the lines Latlong lines for you Okay And if you don't want the lines then You can only give display the value So for that just uncheck this option And maybe you can go for 5 minutes So only the values will be printed at the corner Okay And this map if you want to take the printout Actually right now we don't have the Facility for doing it from the software You can save it as a bitmap A BMP file or a PS file or encapsulated Postcript file and you can Take the printout from third party software Like Microsoft Paint is there Or CorralDraw or Photoshop Or PaintShop software like that Okay Right So this is as far as your layout is Concerned Okay We don't do it See you want to make a grid and do the analysis That concept is different Pardon And a printing is possible means See we don't support a printer driver Because based on the output device You got what type of printer you have What software you have Means I love you to save us a Either a postcript file or a BMP So that any device any where you can take it and do it You can change the scale to the level you need it And save it even as a BMP Yeah There is an option of layout change You know like a word gives directly a print command You can't give And like for you the system basically will show you The map in the fit to window size For you to view Okay But you want to take the printout at say 50,000 or 1 million whatever So that change map scale option is there So you change the map scale Give whatever scale you want And map will be blown or shrunk to that particular size Okay And these are some basic options like zooming in Like zoom into that particular area This is fit to window Zoom out Okay Then zoom into particular area You want to zoom into selected area You can do that If you want to pan Like once you have zoomed in You want to pan So you can do that as well And like this by default shows you all the labels Right That makes the map look very clattery Isn't it Very so much of cluster especially when names are there So in case you want to get rid of that You can use this option of custom labels Where in wherever you click Only those labels will be highlighted So the map will look bit decent Isn't it Other than having all the labels This is a much better option So even that facility the software has Right Okay Yeah So now we come to the actual query part Now we have attached or created the database for this layer This is basically a village boundary layer So we have there is an option of viewing the database So you click on that The system will show you all the tables One has generated for that particular layer Like for example we have created a table For agricultural implements like How many tubeless or pumpsets are there in that Each village Number of tractors Harvesters etc Area like what how much area is under cultivation How much is under forest How much area where rice is grown Wheat is grown All that information Communication details Health institutions How many hospitals etc Okay population details are there So whichever you want You can just click on that That particular table will be shown to you And also one good thing about this is You do not know where this Nava one is So you just click here The map polygon will be highlighted in the map Right So just go on clicking on the records The map that particular polygon gets Highlighted Okay Even vice versa is possible That information tool You click on a polygon And you get its record information Okay like for example you click here You get the information about that polygon What is the name of the polygon What is the population etc But it will show you only for the one table Whatever you have selected by default That will be shown first If you want to see it from some other table You have to select another option Okay that way Right Now we come to the querying part So we click on tools query The system will give you three options Do you want to do simple query Do you want to do A giving complex query One or two conditions you want to give Okay giving a and in between And if you have saved any query Previous day you can always rerun it Run saved query Okay So say for example first we go for simple query So now show me those villages where You click on that I want to see there are villages Where there are more than 10 tractors So I will write here More than 10 Number of tractors more than 10 If you want to save this query You can always do it as a query file Say query 1 Save it And then say okay The system will immediately show you the polygons Which are satisfying the query Right But only make sure the data is entered For that particular polygon Okay otherwise Don't expect the system to show you the output Just on I mean Just like that Okay so this is simple query So same way you can do query on any attribute you want And if you want to give conditions like this and that So you go to an option called advanced SQL query So of course I hope everyone is familiar with this screen SQL screen right Select star Select X from tables Where the condition is satisfied Okay So for example we want to do a query like Show me those places where Bus services are present That is here bus services are yes or no You can see here Field values may yes or no it shows That means Boolean yes or no Bus services are present So select X from existing facility 1 table Where bus services from that table are present And And From the second table I want to see Whether any banks are present So you have to place Any banks Okay This is and mind it So it will show you only those polygons Which are satisfying both the queries Okay it's an intersection basically In case a polygon is satisfying both the queries Only then the system will show you the answer So say okay The system will get the query verified from you once Say okay And the system will show you the answer If these are the polygons where both the conditions are there Bus services are also present And banks are also present Okay that way And the third option is run saved query So it's something like You are doing some presentation the next day So to be safe you want to practice some queries The previous day So you can always do that Save them And so that at the time of presentation you save time So you can always run the saved query For example we saved one first query So we'll click that System will show you what you had written in that particular query If you want to change it You can always do that Else say okay The system will show you the output straight away Okay It is of the first query what we give Number of practice more than 10 Okay So this is as far as our queries are concerned Now the next thing what we can do is Generation of thematic maps Maps based on certain themes Like in geography atlas may you would have seen Map different color Population map is shown in different colors Literacy rate is shown in different colors Pi charts bar charts etc So similarly you can create such maps over here So first thematic operations class based So here you will select the table Where population data is entered Of course if you have one table only from that table You will be showing it Here we have got many tables So total population And I want to show it in five classes Okay Or say four classes So the system will fill the entire map Into five different or four different colors And Legends will tell you What does each color indicate So that means all the polygons in green color Are having population between 0 and 1031 All the polygons in blue are having population Between 1031 and 2063 And it also shows the percentage That means the first population range Is occupying 67% of the entire population Okay Now this is as far as giving the classes And getting the output is concerned Sometimes what happens is the user doesn't want these ranges He wants to create his own range He wants 0 to 1500 1500 to 2000 2000 to 5000 So he can give his own ranges as well So for that you go to range based classification Okay So you click on that Go to that particular table And you can type your ranges So when you select population And select that particular field The system will show you that for that Fill the minimum is 0 Maximum is 400 Okay 4127 So here you can type your own ranges 0 to 1000 Enter 1001 to say 2500 And 2500 to say 5000 You are giving more than the actual allocated That's fine And in case you don't want any range You can always omit that There is suppose example you do not want 1001 to 2500 You can omit that range There the system will show you in Blank Okay So it says maximum is this much You have entered 5000 Say okay So the system will draw it in some colors And of course if you don't like any color You can always change that So at any time The map can be saved as a bitmap And all these things can be done At any moment Okay all the screens are Things are available on the right click So everything you can add whenever you want Right So this is as far as range is concerned Then you want to do some comparison Using pie chart So use a pie chart option Say you want to compare Rise grown Of course we have entered the data in percentage Weed grown along with other crops Select them and say okay The system will draw the pie chart for you Yeah For whatever data you have entered It will do for all those polygons sir If you enter data for 100 polygons It will do it for 100 times Yeah And you want to change any time the size of the Pie You can always do that Say you want to increase it or decrease it 20 So you can do that Yeah Then you want to use the bar graph You can do that Say for example you want to compare Number of repulse Number of thresholds Along with number of tractors per village So select it and you can see the output Yeah the bar chart will be shown Okay And of course this is as far as comparing Two or more attributes are concerned Sometimes what happens You want to you want to find a village With the maximum population Or maximum literacy rate So that option is called as graduated circles Based on the value The circles will be drawn Smaller for smaller value Bigger radius for a larger value polygon Okay So we go for graduated circles We select say show me those player Number of tractors I am selecting So the system will draw the entire map Into different size circles So the one which is having the maximum radius Is the one which is having maximum number of tractors Yeah And of course anytime you want to see the values You can do that Now for example it is showing the labels by default Now you want to see the values of the tractors So go to advanced Set label from database option is there So select that And from here you select Number of tractors So the value Number of tractors in each village will be shown to you Yeah Or you want to see the names So there is an option of village name Yeah Even names can be highlighted So you can see village A is having maximum number of tractors Village A B is having maximum number of tractors that way Okay Right So this is as far as your thematic map generation is concerned We have got a few of spatial queries like You drag and drop I like drag and select a few By drawing a rectangle You will get the information about how many polygons have been selected Or if you draw a circle Then wherever the circle intersects the polygons The information about those are I mean those polygons will be shown to you Else If you want to From a particular village You want to find how many villages are coming within 5 kilometer radius So you can say Circle with radius So see from here I want to see how many villages are within 5 kilometers So you give that distance and say okay The system will show you the output Okay these many villages are coming within 5 kilometers From that point From that village You have clicked here so Okay And if you want to calculate the aerial distance between two points Fly distance It is not the actual ground distance It is the aerial distance Or you call it as the Euclidean distance or crow distance Okay So you click here and Say you want to find the distance between these two points The system will show the distance between these two points is 24 kilometers roughly This is the aerial distance mind it Not the actual ground distance Okay Yeah Right So now we come to like all these basic things Otherwise you can change the label font anytime you want Like this is shown at some standard font In case you want to change the label font You can do that If you have an alternate database Instead of if you have created one And if you don't want to create a new Already have some data entered in another database You can always use that But in that you have to keep in mind there has to be some common field Right Either the names have to be common in both the databases Or some census code or something has to be common And also the number of records need to be the same If there are 20 polygons here Ideally 20 polygons should be here in the next database also Okay If any of this condition is satisfied Of course both the condition should be satisfied Then you can use alternate database And you can do queries and all those things Okay We have an option of query on selective region You do not want to do query on the entire map You want to do query only on a selected area So you go for rectangle And you select the particular area You want to do query only within this area So do you want to make a new query? Yes I want to see again the same query Show me those places where more than five factors are there This system will show you only within that selected area Only within the selected area the output is shown Okay Same option is available for a circle As well as circle with radius You didn't get that? It is basically now earlier whatever query you did, ma'am That was on the entire map Now in case you do not want to do query on entire map You can do query on selective region also Okay, that is what I did now For alternate database Yeah Is the user ID to be kept same? Yes Any one field either Relating So since you are not joining You are relating So that should be one key available The concept of DVMS has come In primary key or foreign key Same way one attribute should be common Then only it will sensibly leave Yeah Okay, and then in the beginning I showed Like when you click on a particular polygon You get the information only from one table That is one default table Okay Now you want to set the data from some other You want to see the data from some other table So you click on these options Set information table You select from which table you want to see Say I want to see it from population table So you select that Say okay So the next time you click on a polygon You will see the data from that population table Okay, it will be different than the previous one Yeah Right Then Always I mean we have an option of adding a field to the database Deleting a field Like for example at the time of entering the data You had entered population You had entered male population You forgot female population Female population will be total minus male Or you want to do some calculation Arithmetic calculation Say you want to find the percentage Of rise grown So it will be like rise grown upon total area into 100 So you can do those calculations and get the output straight away Okay So things like that can be done So for example we want to add a field to the database So I'll just show you some I mean I will create a fields called total Which will have the data from number of reapers Something okay Some infrastructure will calculate So number of treasures Plus number of tractors So the expression is written here So the total field should have the addition of all the three fields Right So when you say okay The data will be total is added Okay Right And then For example actually as ma'am was showing in the morning Child map Like when you click on a country map On a state You will have the map of state open for you From the state you click on a district The district map gets opened From the district block Block civil age So if you have got so many maps You want to show some hierarchy You can do that Okay and For that you need a field called links Okay you create a field called links And the option I mean the good thing about this links is It works as a hyperlink kind of a thing Like in the internet when you click on a link You go unread to the next page right Same way here also The good thing is you can open any sort of a file For example if you have done some field tour And you have taken some photographs on the field tour Okay for that village Or for that district So you can just attach those photographs With that particular record comma karke And when you click on that All the photographs will open one by one Or if any excel file is there Any video file Any music file Whatever is there You can open with the Of course that application has to be there in your system So it will open with the default application Okay Right Now we have already added a Link table here Wherein we are opening some map by default Okay we are opening a BMP Okay we have already attached that Information So for that you have to click here View child map So when you click here So that map will get opened The BMP has opened I will just link for showing Okay so this way you can open any map Whatever you want Okay Right I am done with them This is the last tool over here The last one is comparison You want to compare a few districts or villages Wherever some district administrator wants to administer Some work going on in some villages Okay so what he will do He will select a few villages And see what is the status Or say some population How the population has increased Or what is the crop production in those villages Year wise Whatever x, y is there Whatever some comparison has to be done So he can go to this comparison tool He can select a few polygons randomly Okay some few polygons have been selected And say for example You want to compare reapers, treasures with tractors So when you say display chart The system will show you Line wise how the data is varying in each village You can actually the lines are very light Yeah this is better I guess Yeah So it will show you how in each village On x axis you have got the village IDs And y axis is the values So in each village how is the value varying It will show you And you have got legends Where what color is indicating which line And in case you want to draw the bar chart The bar will be shown Okay and in case the limit here Maximum limit we have shown up to 200 If your values are more than 200 Then there is your y axis limit Instead of 200 you write whatever is the limit you require Okay so according to the map will be I mean the result will be shown to you And you can export this as a BMP sir Yes so for example There is an option of copy chart to clipboard Click on this Go to MS paint And say edit paste So that much portion will be printed over here Paste it over here Okay right So this is an option of comparison Okay and last but not the least is the fine tool Where in you want to You have got a large number of dataset with like Say a district map with village boundary You know the name of the village but you not know its location So what are you going to do You know the name of the village So just type that it's called as a fine tool So enter the system will find that particular polygon for you Yeah fine tool is also there Okay so this is as far as your vector Query is concerned right