+ Reply to Thread
Results 1 to 3 of 3

Thread: Extract Data from Atrribute Table of Shape File to do further Calculations

  1. #1
    Florian Pattis
    Join Date
    Dec 2011
    Posts
    15
    Points
    0
    Answers Provided
    0


    0

    Default Extract Data from Atrribute Table of Shape File to do further Calculations

    Hello im a beginner of Arcgisand i have following problem

    I have a shapefile where i need to some calculations. In the shapefile there are attributes (Area in m², Irradiance in W/m² and temperature in °C…) and I have to do a multiplication. I can do It manual by adding a new field and type in the expression : Power=Area*Irradiance.
    But I need to do this for a lot of entrys and so I want to make a process in the model builder. How can I extract the data in the attribute table to do the calculations and add a field at the end of the attribute table with the calculated power?

    thanks for your help in advance

    flo

  2. #2
    Richard Fairhurst

    Join Date
    Apr 2010
    Posts
    2,166
    Points
    1367
    Answers Provided
    194


    0

    Default Re: Extract Data from Atrribute Table of Shape File to do further Calculations

    Quote Originally Posted by patflo View Post
    Hello im a beginner of Arcgisand i have following problem

    I have a shapefile where i need to some calculations. In the shapefile there are attributes (Area in m², Irradiance in W/m² and temperature in °C…) and I have to do a multiplication. I can do It manual by adding a new field and type in the expression : Power=Area*Irradiance.
    But I need to do this for a lot of entrys and so I want to make a process in the model builder. How can I extract the data in the attribute table to do the calculations and add a field at the end of the attribute table with the calculated power?

    thanks for your help in advance

    flo
    The Add Field operation can be done with the Add Field tool under the Fields section of the Data Management toolset group. This tool only needs to be used once for a given field on a given feature class/table. If the data source is being recreated without the field each time you need to run the script than it can be part of the script that calculates the field. Otherwise, it needs to be done in its own script and only run if the field has been dropped.

    The rest of the script is simply to first use the Make Feature Layer tool under the Layers and Tableviews section of the Data Management group and the Field Calculator tool under the Fields section of the Data Management group to perform the calculation. If you only want to calculate a selected set of records, you can use the Select By Attribute tool under the Layers and Tableviews section of the Data Management group between those two tools.

  3. #3
    Florian Pattis
    Join Date
    Dec 2011
    Posts
    15
    Points
    0
    Answers Provided
    0


    0

    Default Re: Extract Data from Atrribute Table of Shape File to do further Calculations

    Thank you for your help..it took me some time to figure it out but now it works!

+ Reply to Thread

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts