Skip to main content
Geographic Information Systems

Return to Question

added 5 characters in body; edited tags; edited title
Source Link
PolyGeo ♦
PolyGeo ♦
  • 65.5k
  • 29
  • 115
  • 352

Calculate Calculating Min and Max Across fields while skipping Zeros

I am using ArcGIS Desktop 10.5 here. I have a streets layer that has address ranges in the fields FromLeft, ToLeft, FromRight, and ToRight. I am trying to create a street index csv that has the low and high values for each street. I'm trying to calculate the min and max values across the 4 fields and calculate those into 2 new fields called MIN and MAX.

I used min( !FromLeft!, !FromRight!, !ToLeft!, !ToRight!) to get the minimum values, great.

The only thing is that some streets have 0 in one or more of these 4 fields. I would like to skip the value 0 from this calculation and only consider non-zero numbers. 

Can this be done using the field calculator? 

All my fields are LONGs.

enter image description here

Calculate Min and Max Across fields while skipping Zeros

I am using ArcGIS 10.5 here. I have a streets layer that has address ranges in the fields FromLeft, ToLeft, FromRight, and ToRight. I am trying to create a street index csv that has the low and high values for each street. I'm trying to calculate the min and max values across the 4 fields and calculate those into 2 new fields called MIN and MAX.

I used min( !FromLeft!, !FromRight!, !ToLeft!, !ToRight!) to get the minimum values, great.

The only thing is that some streets have 0 in one or more of these 4 fields. I would like to skip the value 0 from this calculation and only consider non-zero numbers. Can this be done using the field calculator? All my fields are LONGs.

enter image description here

Calculating Min and Max Across fields while skipping Zeros

I am using ArcGIS Desktop 10.5 here. I have a streets layer that has address ranges in the fields FromLeft, ToLeft, FromRight, and ToRight. I am trying to create a street index csv that has the low and high values for each street. I'm trying to calculate the min and max values across the 4 fields and calculate those into 2 new fields called MIN and MAX.

I used min( !FromLeft!, !FromRight!, !ToLeft!, !ToRight!) to get the minimum values.

The only thing is that some streets have 0 in one or more of these 4 fields. I would like to skip the value 0 from this calculation and only consider non-zero numbers. 

Can this be done using the field calculator? 

All my fields are LONGs.

enter image description here

deleted 3 characters in body
Source Link
tigerwoulds
tigerwoulds
  • 617
  • 6
  • 17

I am using ArcGIS 10.5 here. I have a streets layer that has address ranges in the fields FromLeft, ToLeft, FromRight, and ToRight. I am trying to create a street index csv that has the low and high values for each street. I'm trying to calculate the min and max values across the 4 fields and calculate those into 2 new fields called MIN and MAX.

I used min( !FromLeft!, !FromRight!, !ToLeft!, !ToRight!) to get the minimum values, great.

The only thing is that some streets have 0 in one or more of these 4 fields. I would like to skip the value 0 from this calculation and only consider non-zero numbers. Can this be done using in the field calculator? All my fields are LONGs.

enter image description here

I am using ArcGIS 10.5 here. I have a streets layer that has address ranges in the fields FromLeft, ToLeft, FromRight, and ToRight. I am trying to create a street index csv that has the low and high values for each street. I'm trying to calculate the min and max values across the 4 fields and calculate those into 2 new fields called MIN and MAX.

I used min( !FromLeft!, !FromRight!, !ToLeft!, !ToRight!) to get the minimum values, great.

The only thing is that some streets have 0 in one or more of these 4 fields. I would like to skip the value 0 from this calculation and only consider non-zero numbers. Can this be done using in the field calculator? All my fields are LONGs.

enter image description here

I am using ArcGIS 10.5 here. I have a streets layer that has address ranges in the fields FromLeft, ToLeft, FromRight, and ToRight. I am trying to create a street index csv that has the low and high values for each street. I'm trying to calculate the min and max values across the 4 fields and calculate those into 2 new fields called MIN and MAX.

I used min( !FromLeft!, !FromRight!, !ToLeft!, !ToRight!) to get the minimum values, great.

The only thing is that some streets have 0 in one or more of these 4 fields. I would like to skip the value 0 from this calculation and only consider non-zero numbers. Can this be done using the field calculator? All my fields are LONGs.

enter image description here

Source Link
tigerwoulds
tigerwoulds
  • 617
  • 6
  • 17

Calculate Min and Max Across fields while skipping Zeros

I am using ArcGIS 10.5 here. I have a streets layer that has address ranges in the fields FromLeft, ToLeft, FromRight, and ToRight. I am trying to create a street index csv that has the low and high values for each street. I'm trying to calculate the min and max values across the 4 fields and calculate those into 2 new fields called MIN and MAX.

I used min( !FromLeft!, !FromRight!, !ToLeft!, !ToRight!) to get the minimum values, great.

The only thing is that some streets have 0 in one or more of these 4 fields. I would like to skip the value 0 from this calculation and only consider non-zero numbers. Can this be done using in the field calculator? All my fields are LONGs.

enter image description here