Rainfall Mapping using IDW Technique for Flood Analysis Using ArcGIS Pro

[Music] hello so um i'm going to start by uh creating a feature so i'm going to go to database and i'm going to click my database and say yeah feature class and i'm gonna type in the name of after class middle degree um rainfall yep so i'm going to leave the alias select points instead of one feature and do next then this is the fields right so i'm going to add my viewers here the first one is going to be the rainfall and it's going to be an integer type so you just select that classic shots integer now the next field is going to be um the latitude or the latitude field so that's going to be um a double so because it's going to be the small point so you're going to select a double if you use football i just go with double i'll do the same thing for the longitude so i'll just type in that and also select to double type there so that's why i've got next uh i'm okay with this one so let's try and finish it so when i click finish it's gonna bring that up there and it's gonna create that feature so i'll just let you do that right so um the next thing i want to do is to now create the features so i'll just go through to edit and just create that feature and one thing you'll notice is that you're going to have to make sure your template your editing is completed so it's all good so i'm going to um check that i'm going to go over to um that setting to create fiat feature template there so you can see managed templates and click that so what that does it helps you um create your features so you let you know what tools are going to be available so i could uh actually uh have actual tables so i can have what i'm editing right i can now type in um the rainfall figure right there on the attribute table but i could also use the feature template to do that as well so i'm going to go set my blog go to properties and go to attributes and then i'll take make sure that the rainfall state because that attribute i want to populate uh right right while i'm picking my my point so i'm gonna do okay i'm gonna click that and just to make sure that everything is right and you can see now it is showing up as required so i'm going to just go there just to uh confirm everything attributes again and make sure that that's turned on that's fine and the rainfall as well the other ones when i calculate them so go all the way back again so you can see now it's showing up rainfall so i can actually type it in there while i'm picking my points so i'm going to show you first how to actually populate the data using an attribute table um then we're going to go over to actually use um the future templates to do that so um my rainfall data that's rightful for many degrees the average rainfall is five to four so i'm going to have um plus or minus 10 right so um so there's going to be an upper bound and a lower bound okay so i'm going to um to make that calculation so the upper bound is plus uh 10 lower around this minus 10 so i'm going to do that plus 10 so i'm going to have um i'm sorry about that so i'm just going to type it in again like 2 plus i'm just saying so we're having a five three four that's the upper bound five three four is over that's what that's the highest rank four data so i'm just going to type in that minus ten so that's going to be the my my lower bound that's five one four so that's the lowest value i could have for the rainfall for any particular location so i'm just gonna close that and come back there i'm gonna zoom in to help for me now so you can see these uh the places around where the water body is the revise should have a higher rainfall so i'm just gonna um select that you see the position as well so it's like that so it creates that that feature so i'm gonna come here and type in my figure that's the rainfall figure there so since there's a little rainfall that seems this close to the water body and you can see the registration without typing it higher while you say five three five for example and say okay all right and i just picked the next one and um i'm going to type in another figure so since that field is a integer type you can type in the text all right so i'm just gonna go somewhere else so this doesn't look like he has a little room full so i'm gonna pick somewhere around if i want to uh show you you can actually now use i'm going to switch over to using my template so what you have to do you need to type in the figure first before you now drop the points unlike actual table where you have to drop the points and then edit your attribute table so if you don't do that it's going to not record you can see now it's recording that there because i typed in the figure first before i pick the point drop the point for that particular location so if i were to type in the to drop the point first before the number is going to be null so it's not going to apply so i'll just pick another point like this doesn't looks a little dry so i'm going to just type in like i said type in your number five um three one five and i'm gonna drop that there so uh you can see that i'm just gonna go close that and once you're done uh you're gonna pick a lot of points so so that it actually covers the story area so that you can have a good uh data so once when that's done you're gonna see all these points i'm gonna open attribute table for this one now so you can see those um the figures for that you can see the lowest one you can like sort it by the highest numbers the other ones are i know so you can see that all right so um what i'm going to do next is to um so i have my points is to calculate my latitude and longitude field so that i can have that exported to excel and use that for in my you know next session uh which of the video i'm just going to right click on that and uh say calculate geometry it's not calculated field you did your measure because they're coordinates so you just select to calculate field so i'm just gonna gonna save this as well so um the property the field is light so i'm gonna select points x coordinates because that's the latitude and the format to be degrees okay this calculator now and then you can now see that uh that's got decimal it's 13 you're going to do something for the longitude collect geometry i'm going to select point y coordinates yeah i'm going to also select the coordinate format to be decimal degrees and okay so i'm going to expand this um double click so you can see that the coordinates uh on the sheet is there as well there are you can see it's all calculated for all everything so you need to make sure your and no selection was done if there's a selection then it's going to want to calculate for that which was selected so i'll just go up and down there you go i'm just going to close this now so um next thing i'm going to do is to run the table to excel tool so i can uh select that to to an xlr table so you can see the first option is the second option rather it's a table to excel so i'm just gonna drag this and drop that as the input table um i'm gonna select my location i'm quite fine with that because that's my database so i'm just going to edit the output name and change that to um since it's not disabled so it's now in excel so i'll just just call that a table around four table and and that's fine i'm gonna use the field aliases this column that's gonna be the column names there there's no alias so i'm just gonna say that he's gonna use that too i'm gonna click run and once you do that it's gonna create mine and um it's gonna give me um this you know once it's selected i'm gonna create also i could always come to my excel table or to just open that and i'm going to see the seven figures there uh like that so that's that's it hello everyone i want to demonstrate how to interpolate your rainfall data say you have an excel file that contains your rainfall data and the latitude and longitude of distance like this so this is my rainfall my light studio my longitude so you too so you have two ways to do this you could convert the table or the excel table to a gi stable the archives broken understand and display from there you can now generate your points or you could just import the table as next y point data so i'm gonna go over to pro and show you what i mean so say i have um my table like you saw what i'm going to do is go to uh analysis tab tools i'm going to search for remember searching is quite easy to find the tools you're looking for i'm going to search for excel table so it's like this this is so the two parameters is asking for is the input table and the output table the sheets and some other ones so i'm gonna um open the location where my actual table is in this case it's right here my folder so that's this i'll select that then it creates an output uh default output for me i'm just going to go ahead and change that because the name is too long um i'll just call that like right so if i do that i'm gonna have to select the sheet this way the sheet was um now remember that's the sheet name there so i'll select that and when i run this if i run this uh it's going to generate a standalone table for me which is going to look something like this right so now if i open that i can see my rainfall data my longitudinal longitude all right so the next thing i would do would be to right click on this table and say display x y data if i click that it's going to bring up the display xy data tool uh with some parameters which i have select and once i do that it's going to bring out my point data now the other way to do this is to just go to your map that comes to add data so this time you're going to add your x y point data because from excel you have your longitude and you want to shoot and they're pointed so you can just add it directly so i'm going to just click that and it's going to bring this to processing tool called xy table to point so i'm going to import my table um i'm just going to um go and select that table open it and select the excel table itself this shit's way least and the same thing i'm just gonna have to um rename these i'll just call this x y or something it's a simple name now it's really important you need to know your x is latitude and your y is long which it didn't read it correctly because for some reason it thinks that the longitude is the x field so you have to correct that you know to have to make sure that they are correct so i'm going to select my long let me shoot for the for x and y is going to be longer but the last shoot for x and y is the longest so um this is the current system on my map so i'm going to leave it at that and i'm just going to click run so it runs and you can see my point data really sitting on where they are supposed to i don't quite like my symbology so i'm going to change that i'll just uh so i'll just come here and change it's really quite still big so i'm just going to use this to about four right so so that's my rainfall data so the next thing to do is now to carry out your interpolation now i'm just going to go ahead and just search for idw that's the investigation method so that you have two options you have the one for 3d and these tools you have the one under um the geostatistical analysis tool and special analysis so this is the one you want to use because we're doing special analysis you want to use the special analysis tool so i'm going to select this idw and it as usual in actual parameters the input point feature the z value which is your elevation and the upper raster itself selfies we can always fix that so i could just drop down and select start it recognizes that this is the point later so i could select that instead of another way i could do is to drag from table of content dropping on my space now my z value is my rainfall so i need to select that as well now my output raster default name i'm just going to go ahead and change that i could just add that right name of the output in the location my cell size has to be the same as my dm right because i have to i need my my cell size to be consistent across all my different layers so i'm just gonna go ahead and just select that i'm just gonna wait for it for pretty slow so um i open my database where i have all that my gm i'll just like that all right and another thing i could do would have been to maybe go to environment and set that using um this see what i've been seeing so you um come out right so i'll just do that on the list but you have to do this only one time if you do it here you don't have to do it here so maybe it's just better to just come to environments which you're familiar with and just do it nonetheless so everything else is going to be the same i'm just going to um confirm but i'm fine with this rainfall my upper raster itself size and this one's optional one other thing i'll do is to use my mask to be my my uh area my story area i'm just gonna select that as my mask so that it keeps that so i don't have to run the clip tool again then um yeah that's what i'm gonna do or personal accents um it's going to be um same as my that right so i'm going to select my my area i could i could as well select this because i cleaned it already it's the same thing so i was just running um and everything everything is perfectly um okay i'm just going to run that and there you go that's my result and that's how to generate an idw interpolation using your excel data uh just to recap you bring in elsa excel table onto pro and then you extract the xy value so that it comes out at the point or you could just add it using the the data tool from your rerun so that's how you create the idw documentation of your rainfall data

Channel: Geohazards Risk Mapping Initiative

Views: 312

Rating: 5 out of 5

Keywords: mapping, IDW, Interpolation, esri, arcgis pro, flood mapping, flood analysis, grmi, idw

Id: fpgYnWJQqGQ

Length: 18min 39sec (1119 seconds)

Published: Fri Feb 26 2021