Timeline for Using cursor to make all LONG fields with NULL values 0 in ArcPy?
Current License: CC BY-SA 3.0
18 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 13, 2016 at 20:42 | history | edited | PolyGeo♦ | CC BY-SA 3.0 |
deleted 55 characters in body
|
| Oct 13, 2016 at 20:40 | history | rollback | PolyGeo♦ |
Rollback to Revision 5
|
|
| Oct 13, 2016 at 17:36 | history | edited | Kevin | CC BY-SA 3.0 |
Fixed the case sensitive error - NONE to None
|
| Oct 13, 2016 at 17:32 | answer | added | Aaron♦ | timeline score: 3 | |
| Oct 13, 2016 at 17:22 | history | reopened |
Geoffrey West Aaron♦ |
||
| Oct 13, 2016 at 17:14 | history | edited | Geoffrey West | CC BY-SA 3.0 |
added 38 characters in body
|
| Oct 13, 2016 at 17:08 | comment | added | Bera | Change if row[0] == 'NULL': to if row[0] is None: | |
| Oct 13, 2016 at 17:08 | comment | added | Jvhowube | I would try if row[0]: instead of seeing if the string 'Null' is in there. Null is nothing, therefore you wanna just see if a value exists or not. | |
| Oct 13, 2016 at 17:04 | history | edited | Geoffrey West | CC BY-SA 3.0 |
added 166 characters in body
|
| Oct 13, 2016 at 2:49 | history | edited | PolyGeo♦ | CC BY-SA 3.0 |
added 2 characters in body; edited title
|
| Oct 13, 2016 at 1:42 | comment | added | Midavalo♦ | You mention using an update cursor, but your example doesn't show the cursor. Can you edit your question to include what you've tried using the Update Cursor, and what it actually does when you try it? | |
| Oct 13, 2016 at 0:20 | review | Reopen votes | |||
| Oct 13, 2016 at 0:25 | |||||
| Oct 13, 2016 at 0:07 | comment | added | Michael Stimson | How big is your joined table? Instead of joining you could create a dictionary, cursor through your joined table populating the dictionary, then for your calculation and then use if key in dict: to calculate matching rows else calculate 0... works simpler (and faster) than trying to use a join on a cursor. Note: Key is your join field value and value is a tuple or list containing the important row values. | |
| Oct 12, 2016 at 23:57 | history | edited | Geoffrey West | CC BY-SA 3.0 |
added 56 characters in body
|
| Oct 12, 2016 at 23:56 | comment | added | PolyGeo♦ | The code you have presented is less than a code snippet that illustrates where you are stuck. For example, your title, body and tags all mention cursors but your code does not. I recommend not thinking about GIS SE as being some sort of online GIS tutor. For your questions to be answered here they should as much as possible describe not just what you want to do, but precisely what you have tried and where you are stuck trying that. | |
| Oct 12, 2016 at 23:54 | history | closed | PolyGeo♦ | Not suitable for this site | |
| Oct 12, 2016 at 23:54 | comment | added | Michael Stimson | Assuming you have the license to overwrite all values calc them all to 0 before the join and use a join as 'matching only', this will omit your non-joined features. If you can't overwrite all then in python you can use a query like table.field is not null, calculate and then invert to get the non-joined and null values and calc to 0. | |
| Oct 12, 2016 at 23:45 | history | asked | Geoffrey West | CC BY-SA 3.0 |