Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have a dataset of several states and a table with many informations about them, they are already joined, what i want to do now is to create 5 classes about the average lifespan.

they have to be within the ranges of 37 - 50 for class 1, >50 - 60 for class 2, >60 - 70 for class 3, >70 - 75 for class 4 and >75 for class 5.

Now i have already tried the reclass by table tool but for some reason it wont allow me to use the needed fields. when i tried it via properties and then tried to type in 5 classes i couldnt do it as well.

im actually supposed to create a new field and do it by the field calculator in the table but since this field calculator is so different to the selection by attributes im also absolutely lost with that.

Does anybody know a way that might work for my problem?

share|improve this question
2  
Reclass by Table Tool is for raster data. Do your have raster or vector data? –  Jens Feb 17 at 9:27

1 Answer 1

in the field calculator, here is what you can use:

parser : PYTHON

check "show code block"

code block :

def reclass(a):

    if (a <= 50):
        return 1
    elif (a <=60):
        return 2
    #add the other conditions here (you must respect the indentation)

    else:
        return 999

result :

 reclass(!yourfield!)
share|improve this answer
    
+1. @Christian: check in which table (dataset of states or table with informations) you want to calculate the values​​. Joined table table with informations could be read only. –  Jens Feb 17 at 10:24
    
@Jens: i want to calculate it in the table with informations. how can i check if the table is read only? –  Daniel Feb 17 at 11:03
    
@Christian: It depends on file format of the table. e.g. text and Excel files are read-only. You can edit e.g. dbf and Geodatabase tables. Here is a list of table formats‌​. –  Jens Feb 17 at 11:15
    
@Jens: i think its a geodatabase table and im able to modify it. only problem now is that i used the expressions of radouxju from above but the field calculator wont activate the ok button.i filled in all the informations with intendation in the code block. is there anything that remains to be filled in the field after the =? –  Daniel Feb 17 at 11:36
    
@Christian. You have to calculate the field before you do the join. After the join it is read-only. –  Jens Feb 17 at 11:52

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.