Update records with ArcPy update cursor? Geodatabase format












2














I try to update thousands of rows when all records get the same value.
My code has a loop that runs thousands of times.
Is it possible for the program to make the change to all the columns in one command and save run time ?



For example, php+mySQL can do this:



mysql_query("UPDATE all_records SET Xcenter = $val1, Ycenter = $val2 WHERE ID > 100");


This is my code:



    for row in rows:

    row.setValue("Xcenter", val1)

    row.setValue("Ycenter", val2)

    rows.updateRow(row)





arcpy arcmap







share|improve this question









New contributor




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




















  • Please Edit the question to specify the data storage format of the target (file geodatabase, RDBMS, shapefile,...) and provide a sample of your existing code.
    – Vince
    2 hours ago






  • 1




    By thousands of fields, you actually mean thousands of rows/records?
    – BERA
    2 hours ago






  • 1




    Please add more code, since that fragment is missing cursor creation. Note that there are no versions of ArcGIS which aren't retired for which non-DataAccess cursors are appropriate. setRow is not supported on DataAcess cursor rows, and DataAcess cursors are much faster than the old, deprecated cursors. You also have indent issues.
    – Vince
    2 hours ago












  • exactly. I mean thousands of records. I updated. Thanks
    – Oz1988
    2 hours ago










  • What's wrong with a for loop? In essence, it's exactly what's going one behind the scenes of any other method, except, with a da cursor, it should be more efficient than using an unnecessary intermediary like CalculateField.
    – Tom
    1 hour ago
















2














I try to update thousands of rows when all records get the same value.
My code has a loop that runs thousands of times.
Is it possible for the program to make the change to all the columns in one command and save run time ?



For example, php+mySQL can do this:



mysql_query("UPDATE all_records SET Xcenter = $val1, Ycenter = $val2 WHERE ID > 100");


This is my code:



    for row in rows:

    row.setValue("Xcenter", val1)

    row.setValue("Ycenter", val2)

    rows.updateRow(row)





arcpy arcmap







share|improve this question









New contributor




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




















  • Please Edit the question to specify the data storage format of the target (file geodatabase, RDBMS, shapefile,...) and provide a sample of your existing code.
    – Vince
    2 hours ago






  • 1




    By thousands of fields, you actually mean thousands of rows/records?
    – BERA
    2 hours ago






  • 1




    Please add more code, since that fragment is missing cursor creation. Note that there are no versions of ArcGIS which aren't retired for which non-DataAccess cursors are appropriate. setRow is not supported on DataAcess cursor rows, and DataAcess cursors are much faster than the old, deprecated cursors. You also have indent issues.
    – Vince
    2 hours ago












  • exactly. I mean thousands of records. I updated. Thanks
    – Oz1988
    2 hours ago










  • What's wrong with a for loop? In essence, it's exactly what's going one behind the scenes of any other method, except, with a da cursor, it should be more efficient than using an unnecessary intermediary like CalculateField.
    – Tom
    1 hour ago














2












2








2







I try to update thousands of rows when all records get the same value.
My code has a loop that runs thousands of times.
Is it possible for the program to make the change to all the columns in one command and save run time ?



For example, php+mySQL can do this:



mysql_query("UPDATE all_records SET Xcenter = $val1, Ycenter = $val2 WHERE ID > 100");


This is my code:



    for row in rows:

    row.setValue("Xcenter", val1)

    row.setValue("Ycenter", val2)

    rows.updateRow(row)





arcpy arcmap







share|improve this question









New contributor




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











I try to update thousands of rows when all records get the same value.
My code has a loop that runs thousands of times.
Is it possible for the program to make the change to all the columns in one command and save run time ?



For example, php+mySQL can do this:



mysql_query("UPDATE all_records SET Xcenter = $val1, Ycenter = $val2 WHERE ID > 100");


This is my code:



    for row in rows:

    row.setValue("Xcenter", val1)

    row.setValue("Ycenter", val2)

    rows.updateRow(row)





arcpy arcmap




arcpy arcmap






share|improve this question









New contributor




Oz1988 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 question









New contributor




Oz1988 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 question




share|improve this question








edited 2 hours ago









BERA

14.8k52041




14.8k52041






New contributor




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









asked 2 hours ago









Oz1988Oz1988

112




112




New contributor




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





New contributor





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






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












  • Please Edit the question to specify the data storage format of the target (file geodatabase, RDBMS, shapefile,...) and provide a sample of your existing code.
    – Vince
    2 hours ago






  • 1




    By thousands of fields, you actually mean thousands of rows/records?
    – BERA
    2 hours ago






  • 1




    Please add more code, since that fragment is missing cursor creation. Note that there are no versions of ArcGIS which aren't retired for which non-DataAccess cursors are appropriate. setRow is not supported on DataAcess cursor rows, and DataAcess cursors are much faster than the old, deprecated cursors. You also have indent issues.
    – Vince
    2 hours ago












  • exactly. I mean thousands of records. I updated. Thanks
    – Oz1988
    2 hours ago










  • What's wrong with a for loop? In essence, it's exactly what's going one behind the scenes of any other method, except, with a da cursor, it should be more efficient than using an unnecessary intermediary like CalculateField.
    – Tom
    1 hour ago


















  • Please Edit the question to specify the data storage format of the target (file geodatabase, RDBMS, shapefile,...) and provide a sample of your existing code.
    – Vince
    2 hours ago






  • 1




    By thousands of fields, you actually mean thousands of rows/records?
    – BERA
    2 hours ago






  • 1




    Please add more code, since that fragment is missing cursor creation. Note that there are no versions of ArcGIS which aren't retired for which non-DataAccess cursors are appropriate. setRow is not supported on DataAcess cursor rows, and DataAcess cursors are much faster than the old, deprecated cursors. You also have indent issues.
    – Vince
    2 hours ago












  • exactly. I mean thousands of records. I updated. Thanks
    – Oz1988
    2 hours ago










  • What's wrong with a for loop? In essence, it's exactly what's going one behind the scenes of any other method, except, with a da cursor, it should be more efficient than using an unnecessary intermediary like CalculateField.
    – Tom
    1 hour ago
















Please Edit the question to specify the data storage format of the target (file geodatabase, RDBMS, shapefile,...) and provide a sample of your existing code.
– Vince
2 hours ago




Please Edit the question to specify the data storage format of the target (file geodatabase, RDBMS, shapefile,...) and provide a sample of your existing code.
– Vince
2 hours ago




1




1




By thousands of fields, you actually mean thousands of rows/records?
– BERA
2 hours ago




By thousands of fields, you actually mean thousands of rows/records?
– BERA
2 hours ago




1




1




Please add more code, since that fragment is missing cursor creation. Note that there are no versions of ArcGIS which aren't retired for which non-DataAccess cursors are appropriate. setRow is not supported on DataAcess cursor rows, and DataAcess cursors are much faster than the old, deprecated cursors. You also have indent issues.
– Vince
2 hours ago






Please add more code, since that fragment is missing cursor creation. Note that there are no versions of ArcGIS which aren't retired for which non-DataAccess cursors are appropriate. setRow is not supported on DataAcess cursor rows, and DataAcess cursors are much faster than the old, deprecated cursors. You also have indent issues.
– Vince
2 hours ago














exactly. I mean thousands of records. I updated. Thanks
– Oz1988
2 hours ago




exactly. I mean thousands of records. I updated. Thanks
– Oz1988
2 hours ago












What's wrong with a for loop? In essence, it's exactly what's going one behind the scenes of any other method, except, with a da cursor, it should be more efficient than using an unnecessary intermediary like CalculateField.
– Tom
1 hour ago




What's wrong with a for loop? In essence, it's exactly what's going one behind the scenes of any other method, except, with a da cursor, it should be more efficient than using an unnecessary intermediary like CalculateField.
– Tom
1 hour ago










2 Answers
2






active

oldest

votes


















2














Try the da.UpdateCursor:



import arcpy

feature_class = r'C:data.gdbfeatures1'



val1 = 123

val2 = 456



sql = """{0} > 100""".format(arcpy.AddFieldDelimiters(feature_class, 'ID'))



fields_to_update = ['Xcenter','Ycenter']

with arcpy.da.UpdateCursor(feature_class, fields_to_update, sql) as cursor:

    for row in cursor:

        row = val1, val2

        cursor.updateRow(row)





share|improve this answer























  • First of all thank you Also in your program there is a loop that runs thousands of times (as many records) I'm looking for something to do it at once. The values I put are identical to all records so I do not want to run thousands of times in a loop
    – Oz1988
    2 hours ago








  • 1




    @Oz1988: The data access cursors (da.UpdateCursor etc.) are very fast so thousands of rows should not be a problem, it should finish in a few seconds. This is what they are designed to do. I know no other way.
    – BERA
    2 hours ago








  • 1




    @Oz1988 If you had a large number of rows (tens to hundreds of millions), it would actually be much faster to set multiple values per row than to use the Field Calculator one column at a time. Your stated goal and intended methodology are incongruous.
    – Vince
    2 hours ago





















2














I have a weird feeling that you are looking for arcpy.CalculateField_management It is simple and quick calculate field help






share|improve this answer





















    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
    });


    }
    });






    Oz1988 is a new contributor. Be nice, and check out our Code of Conduct.










    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f307790%2fupdate-records-with-arcpy-update-cursor-geodatabase-format%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    2 Answers
    2






    active

    oldest

    votes








    2 Answers
    2






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    2














    Try the da.UpdateCursor:



    import arcpy
    
feature_class = r'C:data.gdbfeatures1'
    

    
val1 = 123
    
val2 = 456
    

    
sql = """{0} > 100""".format(arcpy.AddFieldDelimiters(feature_class, 'ID'))
    

    
fields_to_update = ['Xcenter','Ycenter']
    
with arcpy.da.UpdateCursor(feature_class, fields_to_update, sql) as cursor:
    
    for row in cursor:
    
        row = val1, val2
    
        cursor.updateRow(row)





    share|improve this answer























    • First of all thank you Also in your program there is a loop that runs thousands of times (as many records) I'm looking for something to do it at once. The values I put are identical to all records so I do not want to run thousands of times in a loop
      – Oz1988
      2 hours ago








    • 1




      @Oz1988: The data access cursors (da.UpdateCursor etc.) are very fast so thousands of rows should not be a problem, it should finish in a few seconds. This is what they are designed to do. I know no other way.
      – BERA
      2 hours ago








    • 1




      @Oz1988 If you had a large number of rows (tens to hundreds of millions), it would actually be much faster to set multiple values per row than to use the Field Calculator one column at a time. Your stated goal and intended methodology are incongruous.
      – Vince
      2 hours ago


















    2














    Try the da.UpdateCursor:



    import arcpy
    
feature_class = r'C:data.gdbfeatures1'
    

    
val1 = 123
    
val2 = 456
    

    
sql = """{0} > 100""".format(arcpy.AddFieldDelimiters(feature_class, 'ID'))
    

    
fields_to_update = ['Xcenter','Ycenter']
    
with arcpy.da.UpdateCursor(feature_class, fields_to_update, sql) as cursor:
    
    for row in cursor:
    
        row = val1, val2
    
        cursor.updateRow(row)





    share|improve this answer























    • First of all thank you Also in your program there is a loop that runs thousands of times (as many records) I'm looking for something to do it at once. The values I put are identical to all records so I do not want to run thousands of times in a loop
      – Oz1988
      2 hours ago








    • 1




      @Oz1988: The data access cursors (da.UpdateCursor etc.) are very fast so thousands of rows should not be a problem, it should finish in a few seconds. This is what they are designed to do. I know no other way.
      – BERA
      2 hours ago








    • 1




      @Oz1988 If you had a large number of rows (tens to hundreds of millions), it would actually be much faster to set multiple values per row than to use the Field Calculator one column at a time. Your stated goal and intended methodology are incongruous.
      – Vince
      2 hours ago
















    2












    2








    2






    Try the da.UpdateCursor:



    import arcpy
    
feature_class = r'C:data.gdbfeatures1'
    

    
val1 = 123
    
val2 = 456
    

    
sql = """{0} > 100""".format(arcpy.AddFieldDelimiters(feature_class, 'ID'))
    

    
fields_to_update = ['Xcenter','Ycenter']
    
with arcpy.da.UpdateCursor(feature_class, fields_to_update, sql) as cursor:
    
    for row in cursor:
    
        row = val1, val2
    
        cursor.updateRow(row)





    share|improve this answer














    Try the da.UpdateCursor:



    import arcpy
    
feature_class = r'C:data.gdbfeatures1'
    

    
val1 = 123
    
val2 = 456
    

    
sql = """{0} > 100""".format(arcpy.AddFieldDelimiters(feature_class, 'ID'))
    

    
fields_to_update = ['Xcenter','Ycenter']
    
with arcpy.da.UpdateCursor(feature_class, fields_to_update, sql) as cursor:
    
    for row in cursor:
    
        row = val1, val2
    
        cursor.updateRow(row)






    share|improve this answer














    share|improve this answer



    share|improve this answer








    edited 2 hours ago

























    answered 2 hours ago









    BERABERA

    14.8k52041




    14.8k52041












    • First of all thank you Also in your program there is a loop that runs thousands of times (as many records) I'm looking for something to do it at once. The values I put are identical to all records so I do not want to run thousands of times in a loop
      – Oz1988
      2 hours ago








    • 1




      @Oz1988: The data access cursors (da.UpdateCursor etc.) are very fast so thousands of rows should not be a problem, it should finish in a few seconds. This is what they are designed to do. I know no other way.
      – BERA
      2 hours ago








    • 1




      @Oz1988 If you had a large number of rows (tens to hundreds of millions), it would actually be much faster to set multiple values per row than to use the Field Calculator one column at a time. Your stated goal and intended methodology are incongruous.
      – Vince
      2 hours ago




















    • First of all thank you Also in your program there is a loop that runs thousands of times (as many records) I'm looking for something to do it at once. The values I put are identical to all records so I do not want to run thousands of times in a loop
      – Oz1988
      2 hours ago








    • 1




      @Oz1988: The data access cursors (da.UpdateCursor etc.) are very fast so thousands of rows should not be a problem, it should finish in a few seconds. This is what they are designed to do. I know no other way.
      – BERA
      2 hours ago








    • 1




      @Oz1988 If you had a large number of rows (tens to hundreds of millions), it would actually be much faster to set multiple values per row than to use the Field Calculator one column at a time. Your stated goal and intended methodology are incongruous.
      – Vince
      2 hours ago


















    First of all thank you Also in your program there is a loop that runs thousands of times (as many records) I'm looking for something to do it at once. The values I put are identical to all records so I do not want to run thousands of times in a loop
    – Oz1988
    2 hours ago






    First of all thank you Also in your program there is a loop that runs thousands of times (as many records) I'm looking for something to do it at once. The values I put are identical to all records so I do not want to run thousands of times in a loop
    – Oz1988
    2 hours ago






    1




    1




    @Oz1988: The data access cursors (da.UpdateCursor etc.) are very fast so thousands of rows should not be a problem, it should finish in a few seconds. This is what they are designed to do. I know no other way.
    – BERA
    2 hours ago






    @Oz1988: The data access cursors (da.UpdateCursor etc.) are very fast so thousands of rows should not be a problem, it should finish in a few seconds. This is what they are designed to do. I know no other way.
    – BERA
    2 hours ago






    1




    1




    @Oz1988 If you had a large number of rows (tens to hundreds of millions), it would actually be much faster to set multiple values per row than to use the Field Calculator one column at a time. Your stated goal and intended methodology are incongruous.
    – Vince
    2 hours ago






    @Oz1988 If you had a large number of rows (tens to hundreds of millions), it would actually be much faster to set multiple values per row than to use the Field Calculator one column at a time. Your stated goal and intended methodology are incongruous.
    – Vince
    2 hours ago















    2














    I have a weird feeling that you are looking for arcpy.CalculateField_management It is simple and quick calculate field help






    share|improve this answer


























      2














      I have a weird feeling that you are looking for arcpy.CalculateField_management It is simple and quick calculate field help






      share|improve this answer
























        2












        2








        2






        I have a weird feeling that you are looking for arcpy.CalculateField_management It is simple and quick calculate field help






        share|improve this answer












        I have a weird feeling that you are looking for arcpy.CalculateField_management It is simple and quick calculate field help







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered 2 hours ago









        ChrisLChrisL

        354312




        354312






















            Oz1988 is a new contributor. Be nice, and check out our Code of Conduct.










            draft saved

            draft discarded


















            Oz1988 is a new contributor. Be nice, and check out our Code of Conduct.













            Oz1988 is a new contributor. Be nice, and check out our Code of Conduct.












            Oz1988 is a new contributor. Be nice, and check out our Code of Conduct.
















            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.





            Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


            Please pay close attention to the following guidance:


            • 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%2f307790%2fupdate-records-with-arcpy-update-cursor-geodatabase-format%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

            濃尾地震

            Image
            濃尾地震 『岐阜市街大地震之図』 歌川国利画 本震 発生日 1891年（明治24年）10月28日 発生時刻 6時38分50秒（JST） 震央 日本 岐阜県本巣郡西根尾村（現・本巣市） 北緯35度35分 東経136度20分（ 地図 ） 規模    マグニチュード（M）8.0 最大震度    震度7： 注1 福井県今立郡鯖江町、愛知県葉栗郡大田島村、東春日井郡勝川村 地震の種類 直下型地震 被害 死傷者数 死者7,273人、負傷者17,175人 注1：当時の震度階級では「激烈」 プロジェクト:地球科学 プロジェクト:災害 テンプレートを表示 濃尾地震 （のうびじしん）は、1891年（明治24年）10月28日に濃尾地方で発生した、日本史上最大の内陸地殻内地震。「 美濃・尾張地震 （みの・おわりじしん）」とも呼ばれている。辛卯の年に発生したことから 辛卯震災 と呼んでいる報告書もある。 目次 1 概要 1.1 震源断層 2 被害 3 各地の震度 4 前兆現象 5 報道 6 学術的な意義 7 地震防災 8 脚注 9 関連項目 10 外部リンク 概要 濃尾地震発生当時の根尾谷断層 濃尾地震を引き起こした根尾谷断層 写真中央を斜めに走る段差が根尾谷断層 濃尾地震は、1891年10月28日6時38分50秒に発生した。震源は、岐阜県本巣郡西根尾村（現・本巣市）、北緯35度35分、東経136度20分付近。河角廣 (1951) は岐阜市付近（北緯35.6度、東経136.6度）に震央を仮定し規模 M K = 7.0 を与え [1] 、マグニチュードは M = 8.4 に換算されているが、明治・大正期の地震については0.5程度大きく見積もられているとされる [2] 。また、震央距離と震度との関係など当時のデータから後にM8.0 [3] とも推定される。アメリカ地質調査所 (USGS) でも8.0としている [4] 。「根尾谷断層帯」が活動した典型的な内陸地殻内地震（いわゆる直下型地震）であり、これは記録が残っている日本の内陸
            Read more

            How to rewrite equation of hyperbola in standard form

            Image
            2 $begingroup$ I was wondering about this question: $$ 9 x ^ 2 -4y^2-72x=0 $$ What is the step-by-step process of writing such an equation which, in this case, has the graph of a hyperbola in standard form? Please excuse me for my messy equation. As I am relatively new to Mathematics Stack Exchange, I do not know how to insert superscripts. Thank you ahead of time! calculus conic-sections share | cite | improve this question edited 2 hours ago Key Flex 8,637 6 12 33 asked 2 hours ago
            Read more

            No ethernet ip address in my vocore2

            Image
            0 I just flashed my vocore2u with openwrt 18.06.1, and plug it with an ethernet cable to access network while setting up wireless access-point for my phone. The AP is working and connected to the network, but the ip in my phone is in the subnet of another router. And there's no ip assigned to my vocore2 so I cannot ssh into it. After connecting to vocore2 with serial terminal, ping 8.8.8.8 is also failed. How can I make my vocore2 gain ip from the router and setting up the network well? root@OpenWrt:/etc/config# ifconfig apcli0 Link encap:Ethernet HWaddr BA:D8:12:07:01:71 inet6 addr: fe80::b8d8:12ff:fe07:171/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:0 errors:0 dropped:0 overruns:0 frame:0 TX packets:0 erro
            Read more