Wrong min value from ArcGIS 10.4 zonal statistics as tablejoining a table from zonal statistics as table with...

Is it canonical bit space?

Why is it a bad idea to hire a hitman to eliminate most corrupt politicians?

Were any external disk drives stacked vertically?

Why can't we play rap on piano?

Forgetting the musical notes while performing in concert

Brothers & sisters

Is it possible to download Internet Explorer on my Mac running OS X El Capitan?

Why is the 'in' operator throwing an error with a string literal instead of logging false?

How can I tell someone that I want to be his or her friend?

AES: Why is it a good practice to use only the first 16bytes of a hash for encryption?

How can saying a song's name be a copyright violation?

Does a druid starting with a bow start with no arrows?

Could gravitational lensing be used to protect a spaceship from a laser?

Do I have a twin with permutated remainders?

Doing something right before you need it - expression for this?

How much of data wrangling is a data scientist's job?

Can a virus destroy the BIOS of a modern computer?

What is the PIE reconstruction for word-initial alpha with rough breathing?

Where does SFDX store details about scratch orgs?

Took a trip to a parallel universe, need help deciphering

Famous Pre Reformation Christian Pastors (Non Catholic and Non Orthodox)

Should I tell management that I intend to leave due to bad software development practices?

Did converts (ger tzedek) in ancient Israel own land?

I'm flying to France today and my passport expires in less than 2 months



Wrong min value from ArcGIS 10.4 zonal statistics as table


joining a table from zonal statistics as table with a layer, problem with reserved namesArcMap Zonal Statistics not producing attribute tableCompute separate Zonal Statistics table for one raster, zones are many polygons in shapefileZonal Statistics As A Table missing Features in Results?Zonal Statistics as table produces wrong result (only one row of result)python code multirasters zonal statisticsFull list of objects not showing up after using Zonal Statistics as Table tool?Why zonal statistics as table does not include some of my bigger buffers?Why does Zonal Statistics as Table return an empty table?Zonal Statistics as Table: Generic 99999 Error on Some Features






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}







6















I used the zonal statistics as table tool in ArcGIS10.4 to calculate SRTM, the in_zone is a gridded shapefile, the in_value_Raster is the SRTM extracted for the region as in the image (90m x90m). The result table gave me min values of 1 and 0, which does not match the input raster at all. I would like to know what might be causing this problem and how to solve it. Ignore NoData option was checked. Both input shapefile and raster have the same spatial reference system:WGS84. I also converted them into UTM but the min value still didnt make any sense. input zone layer (grids) and input raster layeroutput table, inputs referenced with WGS84output table, inputs referenced with UTMcomplete stats










share|improve this question

























  • It may have to do with the number of unique values in your raster and/or the range of values in your raster. There are some limitations that ESRI should make more explicit. There's not much or clear documentation on the limitations, but see: pro.arcgis.com/en/pro-app/tool-reference/… and pro.arcgis.com/en/pro-app/tool-reference/…. So, you may be getting an artificial wrap-around of values.

    – Tom
    Jun 29 '16 at 16:14













  • there is a bug shifting the column, your 0 and 1 are the area (in degree, rounded) and the very large values are your areas in meters. I mentioned it in another answer, but I don't remember which was the exact question. Anyway, read your table by replacing count with ID, area with count, min with max ... and you'll get the consistent values.

    – radouxju
    Jun 29 '16 at 16:33













  • Thank you Tom, I reset the limit for raster under options.

    – Mouse
    Jun 29 '16 at 17:40













  • @radouxju, could you maybe describe how exactly the columns are shifted? My statistic selection was 'ALL', please see the last image. If I shift all the columns to the next column my MEDIAN column would not have any rows to match, thank you.

    – Mouse
    Jun 29 '16 at 17:41











  • Indeed you loose the last column. If you need the median you need to specifically ask for it.

    – radouxju
    Jun 30 '16 at 7:04


















6















I used the zonal statistics as table tool in ArcGIS10.4 to calculate SRTM, the in_zone is a gridded shapefile, the in_value_Raster is the SRTM extracted for the region as in the image (90m x90m). The result table gave me min values of 1 and 0, which does not match the input raster at all. I would like to know what might be causing this problem and how to solve it. Ignore NoData option was checked. Both input shapefile and raster have the same spatial reference system:WGS84. I also converted them into UTM but the min value still didnt make any sense. input zone layer (grids) and input raster layeroutput table, inputs referenced with WGS84output table, inputs referenced with UTMcomplete stats










share|improve this question

























  • It may have to do with the number of unique values in your raster and/or the range of values in your raster. There are some limitations that ESRI should make more explicit. There's not much or clear documentation on the limitations, but see: pro.arcgis.com/en/pro-app/tool-reference/… and pro.arcgis.com/en/pro-app/tool-reference/…. So, you may be getting an artificial wrap-around of values.

    – Tom
    Jun 29 '16 at 16:14













  • there is a bug shifting the column, your 0 and 1 are the area (in degree, rounded) and the very large values are your areas in meters. I mentioned it in another answer, but I don't remember which was the exact question. Anyway, read your table by replacing count with ID, area with count, min with max ... and you'll get the consistent values.

    – radouxju
    Jun 29 '16 at 16:33













  • Thank you Tom, I reset the limit for raster under options.

    – Mouse
    Jun 29 '16 at 17:40













  • @radouxju, could you maybe describe how exactly the columns are shifted? My statistic selection was 'ALL', please see the last image. If I shift all the columns to the next column my MEDIAN column would not have any rows to match, thank you.

    – Mouse
    Jun 29 '16 at 17:41











  • Indeed you loose the last column. If you need the median you need to specifically ask for it.

    – radouxju
    Jun 30 '16 at 7:04














6












6








6








I used the zonal statistics as table tool in ArcGIS10.4 to calculate SRTM, the in_zone is a gridded shapefile, the in_value_Raster is the SRTM extracted for the region as in the image (90m x90m). The result table gave me min values of 1 and 0, which does not match the input raster at all. I would like to know what might be causing this problem and how to solve it. Ignore NoData option was checked. Both input shapefile and raster have the same spatial reference system:WGS84. I also converted them into UTM but the min value still didnt make any sense. input zone layer (grids) and input raster layeroutput table, inputs referenced with WGS84output table, inputs referenced with UTMcomplete stats










share|improve this question
















I used the zonal statistics as table tool in ArcGIS10.4 to calculate SRTM, the in_zone is a gridded shapefile, the in_value_Raster is the SRTM extracted for the region as in the image (90m x90m). The result table gave me min values of 1 and 0, which does not match the input raster at all. I would like to know what might be causing this problem and how to solve it. Ignore NoData option was checked. Both input shapefile and raster have the same spatial reference system:WGS84. I also converted them into UTM but the min value still didnt make any sense. input zone layer (grids) and input raster layeroutput table, inputs referenced with WGS84output table, inputs referenced with UTMcomplete stats







arcgis-desktop zonal-statistics srtm arcgis-10.4






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Jun 29 '16 at 20:16









PolyGeo

53.9k1781245




53.9k1781245










asked Jun 29 '16 at 16:11









MouseMouse

737




737













  • It may have to do with the number of unique values in your raster and/or the range of values in your raster. There are some limitations that ESRI should make more explicit. There's not much or clear documentation on the limitations, but see: pro.arcgis.com/en/pro-app/tool-reference/… and pro.arcgis.com/en/pro-app/tool-reference/…. So, you may be getting an artificial wrap-around of values.

    – Tom
    Jun 29 '16 at 16:14













  • there is a bug shifting the column, your 0 and 1 are the area (in degree, rounded) and the very large values are your areas in meters. I mentioned it in another answer, but I don't remember which was the exact question. Anyway, read your table by replacing count with ID, area with count, min with max ... and you'll get the consistent values.

    – radouxju
    Jun 29 '16 at 16:33













  • Thank you Tom, I reset the limit for raster under options.

    – Mouse
    Jun 29 '16 at 17:40













  • @radouxju, could you maybe describe how exactly the columns are shifted? My statistic selection was 'ALL', please see the last image. If I shift all the columns to the next column my MEDIAN column would not have any rows to match, thank you.

    – Mouse
    Jun 29 '16 at 17:41











  • Indeed you loose the last column. If you need the median you need to specifically ask for it.

    – radouxju
    Jun 30 '16 at 7:04



















  • It may have to do with the number of unique values in your raster and/or the range of values in your raster. There are some limitations that ESRI should make more explicit. There's not much or clear documentation on the limitations, but see: pro.arcgis.com/en/pro-app/tool-reference/… and pro.arcgis.com/en/pro-app/tool-reference/…. So, you may be getting an artificial wrap-around of values.

    – Tom
    Jun 29 '16 at 16:14













  • there is a bug shifting the column, your 0 and 1 are the area (in degree, rounded) and the very large values are your areas in meters. I mentioned it in another answer, but I don't remember which was the exact question. Anyway, read your table by replacing count with ID, area with count, min with max ... and you'll get the consistent values.

    – radouxju
    Jun 29 '16 at 16:33













  • Thank you Tom, I reset the limit for raster under options.

    – Mouse
    Jun 29 '16 at 17:40













  • @radouxju, could you maybe describe how exactly the columns are shifted? My statistic selection was 'ALL', please see the last image. If I shift all the columns to the next column my MEDIAN column would not have any rows to match, thank you.

    – Mouse
    Jun 29 '16 at 17:41











  • Indeed you loose the last column. If you need the median you need to specifically ask for it.

    – radouxju
    Jun 30 '16 at 7:04

















It may have to do with the number of unique values in your raster and/or the range of values in your raster. There are some limitations that ESRI should make more explicit. There's not much or clear documentation on the limitations, but see: pro.arcgis.com/en/pro-app/tool-reference/… and pro.arcgis.com/en/pro-app/tool-reference/…. So, you may be getting an artificial wrap-around of values.

– Tom
Jun 29 '16 at 16:14







It may have to do with the number of unique values in your raster and/or the range of values in your raster. There are some limitations that ESRI should make more explicit. There's not much or clear documentation on the limitations, but see: pro.arcgis.com/en/pro-app/tool-reference/… and pro.arcgis.com/en/pro-app/tool-reference/…. So, you may be getting an artificial wrap-around of values.

– Tom
Jun 29 '16 at 16:14















there is a bug shifting the column, your 0 and 1 are the area (in degree, rounded) and the very large values are your areas in meters. I mentioned it in another answer, but I don't remember which was the exact question. Anyway, read your table by replacing count with ID, area with count, min with max ... and you'll get the consistent values.

– radouxju
Jun 29 '16 at 16:33







there is a bug shifting the column, your 0 and 1 are the area (in degree, rounded) and the very large values are your areas in meters. I mentioned it in another answer, but I don't remember which was the exact question. Anyway, read your table by replacing count with ID, area with count, min with max ... and you'll get the consistent values.

– radouxju
Jun 29 '16 at 16:33















Thank you Tom, I reset the limit for raster under options.

– Mouse
Jun 29 '16 at 17:40







Thank you Tom, I reset the limit for raster under options.

– Mouse
Jun 29 '16 at 17:40















@radouxju, could you maybe describe how exactly the columns are shifted? My statistic selection was 'ALL', please see the last image. If I shift all the columns to the next column my MEDIAN column would not have any rows to match, thank you.

– Mouse
Jun 29 '16 at 17:41





@radouxju, could you maybe describe how exactly the columns are shifted? My statistic selection was 'ALL', please see the last image. If I shift all the columns to the next column my MEDIAN column would not have any rows to match, thank you.

– Mouse
Jun 29 '16 at 17:41













Indeed you loose the last column. If you need the median you need to specifically ask for it.

– radouxju
Jun 30 '16 at 7:04





Indeed you loose the last column. If you need the median you need to specifically ask for it.

– radouxju
Jun 30 '16 at 7:04










4 Answers
4






active

oldest

votes


















1














This is a bug, let's hope that it will solved soon because you loose the median column. The Feature ID header is missing then all column header are shifhted one step left.



enter image description here






share|improve this answer
























  • re: 'This is a bug'. By a bug, do you mean document as a bug by esri? If so, is there a bug number to track when it has been resolved?

    – Rex
    Apr 12 '18 at 19:53











  • @Rex there is no bug report as far as I know. I call it a bug because the tool does not work as expected, and it work properly in previous versions.

    – radouxju
    Apr 13 '18 at 6:47



















1














I ran the zonal statistics as table again with all the setting identical to the previous try on arcGIS 10.3x and got the correct output with all the desired columns (Image as below).



new output column using arcGIS 10.3x






share|improve this answer































    1














    I did some testing and it appears that when you use your 'OBJECTID' as your zonal field, it cant add it as a column in the output so it causes a miss-match between the columns and the headers (column names). The workaround is to use a different column as your zonal field in your input and your columns should line up in your output.






    share|improve this answer































      0














      Thank you Rex, great job! It help me a lot






      share|improve this answer








      New contributor




      Gilles is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





















        Your Answer








        StackExchange.ready(function() {
        var channelOptions = {
        tags: "".split(" "),
        id: "79"
        };
        initTagRenderer("".split(" "), "".split(" "), channelOptions);

        StackExchange.using("externalEditor", function() {
        // Have to fire editor after snippets, if snippets enabled
        if (StackExchange.settings.snippets.snippetsEnabled) {
        StackExchange.using("snippets", function() {
        createEditor();
        });
        }
        else {
        createEditor();
        }
        });

        function createEditor() {
        StackExchange.prepareEditor({
        heartbeatType: 'answer',
        autoActivateHeartbeat: false,
        convertImagesToLinks: false,
        noModals: true,
        showLowRepImageUploadWarning: true,
        reputationToPostImages: null,
        bindNavPrevention: true,
        postfix: "",
        imageUploader: {
        brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
        contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
        allowUrls: true
        },
        onDemand: true,
        discardSelector: ".discard-answer"
        ,immediatelyShowMarkdownHelp:true
        });


        }
        });














        draft saved

        draft discarded


















        StackExchange.ready(
        function () {
        StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f200432%2fwrong-min-value-from-arcgis-10-4-zonal-statistics-as-table%23new-answer', 'question_page');
        }
        );

        Post as a guest















        Required, but never shown

























        4 Answers
        4






        active

        oldest

        votes








        4 Answers
        4






        active

        oldest

        votes









        active

        oldest

        votes






        active

        oldest

        votes









        1














        This is a bug, let's hope that it will solved soon because you loose the median column. The Feature ID header is missing then all column header are shifhted one step left.



        enter image description here






        share|improve this answer
























        • re: 'This is a bug'. By a bug, do you mean document as a bug by esri? If so, is there a bug number to track when it has been resolved?

          – Rex
          Apr 12 '18 at 19:53











        • @Rex there is no bug report as far as I know. I call it a bug because the tool does not work as expected, and it work properly in previous versions.

          – radouxju
          Apr 13 '18 at 6:47
















        1














        This is a bug, let's hope that it will solved soon because you loose the median column. The Feature ID header is missing then all column header are shifhted one step left.



        enter image description here






        share|improve this answer
























        • re: 'This is a bug'. By a bug, do you mean document as a bug by esri? If so, is there a bug number to track when it has been resolved?

          – Rex
          Apr 12 '18 at 19:53











        • @Rex there is no bug report as far as I know. I call it a bug because the tool does not work as expected, and it work properly in previous versions.

          – radouxju
          Apr 13 '18 at 6:47














        1












        1








        1







        This is a bug, let's hope that it will solved soon because you loose the median column. The Feature ID header is missing then all column header are shifhted one step left.



        enter image description here






        share|improve this answer













        This is a bug, let's hope that it will solved soon because you loose the median column. The Feature ID header is missing then all column header are shifhted one step left.



        enter image description here







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Jun 30 '16 at 7:11









        radouxjuradouxju

        41.3k144122




        41.3k144122













        • re: 'This is a bug'. By a bug, do you mean document as a bug by esri? If so, is there a bug number to track when it has been resolved?

          – Rex
          Apr 12 '18 at 19:53











        • @Rex there is no bug report as far as I know. I call it a bug because the tool does not work as expected, and it work properly in previous versions.

          – radouxju
          Apr 13 '18 at 6:47



















        • re: 'This is a bug'. By a bug, do you mean document as a bug by esri? If so, is there a bug number to track when it has been resolved?

          – Rex
          Apr 12 '18 at 19:53











        • @Rex there is no bug report as far as I know. I call it a bug because the tool does not work as expected, and it work properly in previous versions.

          – radouxju
          Apr 13 '18 at 6:47

















        re: 'This is a bug'. By a bug, do you mean document as a bug by esri? If so, is there a bug number to track when it has been resolved?

        – Rex
        Apr 12 '18 at 19:53





        re: 'This is a bug'. By a bug, do you mean document as a bug by esri? If so, is there a bug number to track when it has been resolved?

        – Rex
        Apr 12 '18 at 19:53













        @Rex there is no bug report as far as I know. I call it a bug because the tool does not work as expected, and it work properly in previous versions.

        – radouxju
        Apr 13 '18 at 6:47





        @Rex there is no bug report as far as I know. I call it a bug because the tool does not work as expected, and it work properly in previous versions.

        – radouxju
        Apr 13 '18 at 6:47













        1














        I ran the zonal statistics as table again with all the setting identical to the previous try on arcGIS 10.3x and got the correct output with all the desired columns (Image as below).



        new output column using arcGIS 10.3x






        share|improve this answer




























          1














          I ran the zonal statistics as table again with all the setting identical to the previous try on arcGIS 10.3x and got the correct output with all the desired columns (Image as below).



          new output column using arcGIS 10.3x






          share|improve this answer


























            1












            1








            1







            I ran the zonal statistics as table again with all the setting identical to the previous try on arcGIS 10.3x and got the correct output with all the desired columns (Image as below).



            new output column using arcGIS 10.3x






            share|improve this answer













            I ran the zonal statistics as table again with all the setting identical to the previous try on arcGIS 10.3x and got the correct output with all the desired columns (Image as below).



            new output column using arcGIS 10.3x







            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered Jun 30 '16 at 9:05









            MouseMouse

            737




            737























                1














                I did some testing and it appears that when you use your 'OBJECTID' as your zonal field, it cant add it as a column in the output so it causes a miss-match between the columns and the headers (column names). The workaround is to use a different column as your zonal field in your input and your columns should line up in your output.






                share|improve this answer




























                  1














                  I did some testing and it appears that when you use your 'OBJECTID' as your zonal field, it cant add it as a column in the output so it causes a miss-match between the columns and the headers (column names). The workaround is to use a different column as your zonal field in your input and your columns should line up in your output.






                  share|improve this answer


























                    1












                    1








                    1







                    I did some testing and it appears that when you use your 'OBJECTID' as your zonal field, it cant add it as a column in the output so it causes a miss-match between the columns and the headers (column names). The workaround is to use a different column as your zonal field in your input and your columns should line up in your output.






                    share|improve this answer













                    I did some testing and it appears that when you use your 'OBJECTID' as your zonal field, it cant add it as a column in the output so it causes a miss-match between the columns and the headers (column names). The workaround is to use a different column as your zonal field in your input and your columns should line up in your output.







                    share|improve this answer












                    share|improve this answer



                    share|improve this answer










                    answered Apr 12 '18 at 20:22









                    RexRex

                    384210




                    384210























                        0














                        Thank you Rex, great job! It help me a lot






                        share|improve this answer








                        New contributor




                        Gilles is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                        Check out our Code of Conduct.

























                          0














                          Thank you Rex, great job! It help me a lot






                          share|improve this answer








                          New contributor




                          Gilles is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                          Check out our Code of Conduct.























                            0












                            0








                            0







                            Thank you Rex, great job! It help me a lot






                            share|improve this answer








                            New contributor




                            Gilles is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                            Check out our Code of Conduct.










                            Thank you Rex, great job! It help me a lot







                            share|improve this answer








                            New contributor




                            Gilles is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                            Check out our Code of Conduct.









                            share|improve this answer



                            share|improve this answer






                            New contributor




                            Gilles is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                            Check out our Code of Conduct.









                            answered 16 mins ago









                            GillesGilles

                            1




                            1




                            New contributor




                            Gilles is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                            Check out our Code of Conduct.





                            New contributor





                            Gilles is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                            Check out our Code of Conduct.






                            Gilles is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                            Check out our Code of Conduct.






























                                draft saved

                                draft discarded




















































                                Thanks for contributing an answer to Geographic Information Systems Stack Exchange!


                                • Please be sure to answer the question. Provide details and share your research!

                                But avoid



                                • Asking for help, clarification, or responding to other answers.

                                • Making statements based on opinion; back them up with references or personal experience.


                                To learn more, see our tips on writing great answers.




                                draft saved


                                draft discarded














                                StackExchange.ready(
                                function () {
                                StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f200432%2fwrong-min-value-from-arcgis-10-4-zonal-statistics-as-table%23new-answer', 'question_page');
                                }
                                );

                                Post as a guest















                                Required, but never shown





















































                                Required, but never shown














                                Required, but never shown












                                Required, but never shown







                                Required, but never shown

































                                Required, but never shown














                                Required, but never shown












                                Required, but never shown







                                Required, but never shown







                                Popular posts from this blog

                                Щит и меч (фильм) Содержание Названия серий | Сюжет |...

                                is 'sed' thread safeWhat should someone know about using Python scripts in the shell?Nexenta bash script uses...

                                Meter-Bus Содержание Параметры шины | Стандартизация |...