Batch editing to correct flower ID on interactions with insect posts

Is there a method to batch edit or correct multiple postings at one time? I have 800 insect posts that incorrectly show interaction with Asters. Should be American Asters. Correcting these one at a time is time-consuming.

Bugeyed Bernie

I’ve run into the same issue, and I haven’t found a workaround. You may just have to put in the time. Or post a link of the observations in question and I’ll help out.

and ask for help on the Identifriday thread.

do you mean in your observation fields? and would it be possible to see an example?

1 Like

the existing Batch Edit screen only seems to allow you to add observation fields, not edit existing ones. so then the only way that i know of to batch edit existing observation field values would be to use the API via PUT /v1/observation_field_values/{id}.

this particular endpoint is a little cumbersome to use because you have to know the observation field record id, not just the observation id and observation field id. this means that for each observation, you have to look up the observation field record id, which means you also have to go through GET /v1/observations. that’s annoying because fully automating this would then require the user to have some sort of development set up, or i would need to write something for a particular cloud-based interpreter, or i would have to write a custom application to do this.

so since this is hopefully just a one time thing, i’m going to just give you some custom curl commands to run which should address your particular situation. i’m going to assume you’re using a Windows machine, and you’ll run these commands using a Windows batch file.

first, i’m assuming the following:

i looked up the observation field record IDs using a modified version of this Observable notebook: https://observablehq.com/@robin-song/inaturalist-api-example-1b

based on the above, here’s the base of the batch file that you’ll use:

@echo off
set jwt=redacted
set obs_field_id=3126
set obs_field_value=56112
set obs[0].id=189606020
set obs[0].ofid=24813198
set obs[1].id=188790987
set obs[1].ofid=24740916
set obs[2].id=187785933
set obs[2].ofid=24627310
set obs[3].id=187785932
set obs[3].ofid=24627309
set obs[4].id=187559195
set obs[4].ofid=24594776
set obs[5].id=187557307
set obs[5].ofid=24594636
set obs[6].id=187557300
set obs[6].ofid=24594634
set obs[7].id=187557276
set obs[7].ofid=24594628
set obs[8].id=187304159
set obs[8].ofid=24565226
set obs[9].id=186764892
set obs[9].ofid=24508795
set obs[10].id=186532241
set obs[10].ofid=24485706
set obs[11].id=186532240
set obs[11].ofid=24485705
set obs[12].id=186532239
set obs[12].ofid=24485704
set obs[13].id=186462481
set obs[13].ofid=24478545
set obs[14].id=186462478
set obs[14].ofid=24478543
set obs[15].id=186462473
set obs[15].ofid=24478541
set obs[16].id=186462472
set obs[16].ofid=24478540
set obs[17].id=186462471
set obs[17].ofid=24478539
set obs[18].id=186462460
set obs[18].ofid=24478536
set obs[19].id=186462446
set obs[19].ofid=24478529
set obs[20].id=186462443
set obs[20].ofid=24478527
set obs[21].id=186462442
set obs[21].ofid=24478526
set obs[22].id=186462426
set obs[22].ofid=24478522
set obs[23].id=186329683
set obs[23].ofid=24467592
set obs[24].id=186329673
set obs[24].ofid=24467589
set obs[25].id=186329672
set obs[25].ofid=24467588
set obs[26].id=186329656
set obs[26].ofid=24467587
set obs[27].id=186329642
set obs[27].ofid=24467581
set obs[28].id=186329633
set obs[28].ofid=24467578
set obs[29].id=186329632
set obs[29].ofid=24467577
set obs[30].id=186329622
set obs[30].ofid=24467576
set obs[31].id=186204201
set obs[31].ofid=24456830
set obs[32].id=186204190
set obs[32].ofid=24456823
set obs[33].id=186204184
set obs[33].ofid=24456820
set obs[34].id=186204178
set obs[34].ofid=24456819
set obs[35].id=186204177
set obs[35].ofid=24456816
set obs[36].id=186204176
set obs[36].ofid=24456815
set obs[37].id=186204175
set obs[37].ofid=24456814
set obs[38].id=186204172
set obs[38].ofid=24456812
set obs[39].id=186204170
set obs[39].ofid=24456810
set obs[40].id=186204161
set obs[40].ofid=24456803
set obs[41].id=186204159
set obs[41].ofid=24456802
set obs[42].id=186204158
set obs[42].ofid=24456801
set obs[43].id=186204146
set obs[43].ofid=24456793
set obs[44].id=186096124
set obs[44].ofid=24448179
set obs[45].id=186096111
set obs[45].ofid=24448173
set obs[46].id=186096099
set obs[46].ofid=24448170
set obs[47].id=186096098
set obs[47].ofid=24448169
set obs[48].id=186096077
set obs[48].ofid=24448162
set obs[49].id=186041642
set obs[49].ofid=24443942
set obs[50].id=186041640
set obs[50].ofid=24443941
set obs[51].id=186041639
set obs[51].ofid=24443940
set obs[52].id=186041638
set obs[52].ofid=24443939
set obs[53].id=186041635
set obs[53].ofid=24443937
set obs[54].id=186041633
set obs[54].ofid=24443936
set obs[55].id=186041632
set obs[55].ofid=24443935
set obs[56].id=186041623
set obs[56].ofid=24443932
set obs[57].id=186041619
set obs[57].ofid=24443931
set obs[58].id=186041611
set obs[58].ofid=24443930
set obs[59].id=186041609
set obs[59].ofid=24443929
set obs[60].id=186041607
set obs[60].ofid=24443928
set obs[61].id=186041603
set obs[61].ofid=24443927
set obs[62].id=186041594
set obs[62].ofid=24443925
set obs[63].id=186041593
set obs[63].ofid=24443923
set obs[64].id=186041587
set obs[64].ofid=24443921
set obs[65].id=186041585
set obs[65].ofid=24443919
set obs[66].id=186041584
set obs[66].ofid=24443918
set obs[67].id=186041583
set obs[67].ofid=24443916
set obs[68].id=186041582
set obs[68].ofid=24443915
set obs[69].id=186041581
set obs[69].ofid=24443914
set obs[70].id=185964407
set obs[70].ofid=24436928
set obs[71].id=185964401
set obs[71].ofid=24436923
set obs[72].id=185964399
set obs[72].ofid=24436921
set obs[73].id=185964396
set obs[73].ofid=24436919
set obs[74].id=185964390
set obs[74].ofid=24436916
set obs[75].id=185964389
set obs[75].ofid=24436915
set obs[76].id=185964388
set obs[76].ofid=24436914
set obs[77].id=185964386
set obs[77].ofid=24436913
set obs[78].id=185964385
set obs[78].ofid=24436912
set obs[79].id=185964379
set obs[79].ofid=24436911
set obs[80].id=185964378
set obs[80].ofid=24436910
set obs[81].id=185964375
set obs[81].ofid=24436907
set obs[82].id=185964372
set obs[82].ofid=24436906
set obs[83].id=185964371
set obs[83].ofid=24436905
set obs[84].id=185964362
set obs[84].ofid=24436904
set obs[85].id=185964358
set obs[85].ofid=24436903
set obs[86].id=185964356
set obs[86].ofid=24436902
set obs[87].id=185964355
set obs[87].ofid=24436901
set obs[88].id=185964354
set obs[88].ofid=24436900
set obs[89].id=185964352
set obs[89].ofid=24436899
set obs[90].id=185964351
set obs[90].ofid=24436898
set obs[91].id=185964349
set obs[91].ofid=24436897
set obs[92].id=185730355
set obs[92].ofid=24419205
set obs[93].id=185730354
set obs[93].ofid=24419203
set obs[94].id=185730353
set obs[94].ofid=24419204
set obs[95].id=185730350
set obs[95].ofid=24419202
set obs[96].id=185730349
set obs[96].ofid=24419201
set obs[97].id=185730348
set obs[97].ofid=24419200
set obs[98].id=185730346
set obs[98].ofid=24419199
set obs[99].id=185730343
set obs[99].ofid=24419197
set obs[100].id=185730338
set obs[100].ofid=24419196
set obs[101].id=185730337
set obs[101].ofid=24419195
set obs[102].id=185730335
set obs[102].ofid=24419194
set obs[103].id=185730333
set obs[103].ofid=24419192
set obs[104].id=185730328
set obs[104].ofid=24419191
set obs[105].id=185730327
set obs[105].ofid=24419189
set obs[106].id=185730325
set obs[106].ofid=24419186
set obs[107].id=185730323
set obs[107].ofid=24419185
set obs[108].id=185730322
set obs[108].ofid=24419184
set obs[109].id=185730317
set obs[109].ofid=24419183
set obs[110].id=184318886
set obs[110].ofid=24301317
set obs[111].id=184318883
set obs[111].ofid=24301316
set obs[112].id=184318880
set obs[112].ofid=24301314
set obs[113].id=184318879
set obs[113].ofid=24301313
set obs[114].id=184318878
set obs[114].ofid=24301312
set obs[115].id=184318877
set obs[115].ofid=24301311
set obs[116].id=184318876
set obs[116].ofid=24301309
set obs[117].id=184318875
set obs[117].ofid=24301308
set obs[118].id=184318872
set obs[118].ofid=24301307
set obs[119].id=184318868
set obs[119].ofid=24301306
set obs[120].id=184318866
set obs[120].ofid=24301305
set obs[121].id=184318862
set obs[121].ofid=24301304
set obs[122].id=184318860
set obs[122].ofid=24301303
set obs[123].id=184318848
set obs[123].ofid=24301301
set obs[124].id=184318847
set obs[124].ofid=24301300
set obs[125].id=184318846
set obs[125].ofid=24301299
set obs[126].id=184318844
set obs[126].ofid=24301298
set obs[127].id=184318841
set obs[127].ofid=24301297
set obs[128].id=184313567
set obs[128].ofid=24300785
set obs[129].id=184313564
set obs[129].ofid=24300784
set obs[130].id=184313558
set obs[130].ofid=24300783
set obs[131].id=184313553
set obs[131].ofid=24300782
set obs[132].id=184313552
set obs[132].ofid=24300781
set obs[133].id=184313547
set obs[133].ofid=24300780
set obs[134].id=184313545
set obs[134].ofid=24300779
set obs[135].id=184313541
set obs[135].ofid=24300778
set obs[136].id=184313539
set obs[136].ofid=24300777
set obs[137].id=184313533
set obs[137].ofid=24300776
set obs[138].id=184313521
set obs[138].ofid=24300773
set obs[139].id=184313516
set obs[139].ofid=24300772
set obs[140].id=184313513
set obs[140].ofid=24300771
set obs[141].id=184313510
set obs[141].ofid=24300770
set obs[142].id=184313508
set obs[142].ofid=24300769
set obs[143].id=184313502
set obs[143].ofid=24300768
set obs[144].id=184313501
set obs[144].ofid=24300767
set obs[145].id=184313489
set obs[145].ofid=24300766
set obs[146].id=184313480
set obs[146].ofid=24300765
set obs[147].id=184313476
set obs[147].ofid=24300764
set obs[148].id=184313472
set obs[148].ofid=24300763
set obs[149].id=184313469
set obs[149].ofid=24300762
set obs[150].id=184313457
set obs[150].ofid=24300760
set obs[151].id=184313451
set obs[151].ofid=24300759
set obs[152].id=183758017
set obs[152].ofid=24246745
set obs[153].id=183746758
set obs[153].ofid=24246163
set obs[154].id=183746756
set obs[154].ofid=24246162
set obs[155].id=183746747
set obs[155].ofid=24246159
set obs[156].id=183746742
set obs[156].ofid=24246158
set obs[157].id=183746741
set obs[157].ofid=24246157
set obs[158].id=183746734
set obs[158].ofid=24246156
set obs[159].id=183746730
set obs[159].ofid=24246155
set obs[160].id=183746726
set obs[160].ofid=24246153
set obs[161].id=183746724
set obs[161].ofid=24246151
set obs[162].id=183746722
set obs[162].ofid=24246149
set obs[163].id=183746721
set obs[163].ofid=24246147
set obs[164].id=183746710
set obs[164].ofid=24246144
set obs[165].id=183491534
set obs[165].ofid=24224193
set obs[166].id=183491530
set obs[166].ofid=24224191
set obs[167].id=183426576
set obs[167].ofid=24218891
set obs[168].id=183426574
set obs[168].ofid=24218889
set obs[169].id=183426567
set obs[169].ofid=24218887
set obs[170].id=183426566
set obs[170].ofid=24218886
set obs[171].id=183426564
set obs[171].ofid=24218884
set obs[172].id=183426559
set obs[172].ofid=24218883
set obs[173].id=183426558
set obs[173].ofid=24218881
set obs[174].id=183426553
set obs[174].ofid=24218880
set obs[175].id=183426552
set obs[175].ofid=24218878
set obs[176].id=183426549
set obs[176].ofid=24218877
set obs[177].id=183426547
set obs[177].ofid=24218876
set obs[178].id=183426546
set obs[178].ofid=24218875
set obs[179].id=183426544
set obs[179].ofid=24218874
set obs[180].id=183426543
set obs[180].ofid=24218872
set obs[181].id=183426542
set obs[181].ofid=24218870
set obs[182].id=183426534
set obs[182].ofid=24218869
set obs[183].id=183426531
set obs[183].ofid=24218868
set obs[184].id=183426530
set obs[184].ofid=24218867
set obs[185].id=183426529
set obs[185].ofid=24218865
set obs[186].id=183426524
set obs[186].ofid=24218864
set obs[187].id=183426521
set obs[187].ofid=24218862
set obs[188].id=183419109
set obs[188].ofid=24218216
set obs[189].id=183419106
set obs[189].ofid=24218215
set obs[190].id=183419104
set obs[190].ofid=24218213
set obs[191].id=183419103
set obs[191].ofid=24218212
set obs[192].id=183419101
set obs[192].ofid=24218211
set obs[193].id=183419100
set obs[193].ofid=24218210
set obs[194].id=183419099
set obs[194].ofid=24218209
set obs[195].id=183419097
set obs[195].ofid=24218208
set obs[196].id=183419095
set obs[196].ofid=24218207
set obs[197].id=183419094
set obs[197].ofid=24218206
set obs[198].id=183419092
set obs[198].ofid=24218205
set obs[199].id=183419091
set obs[199].ofid=24218204
set obs[200].id=183419090
set obs[200].ofid=24218203
set obs[201].id=183419089
set obs[201].ofid=24218201
set obs[202].id=183419088
set obs[202].ofid=24218200
set obs[203].id=183419085
set obs[203].ofid=24218199
set obs[204].id=183419081
set obs[204].ofid=24218197
set obs[205].id=183419077
set obs[205].ofid=24218196
set obs[206].id=183419074
set obs[206].ofid=24218195
set obs[207].id=183419071
set obs[207].ofid=24218193
set obs[208].id=183419070
set obs[208].ofid=24218191
set obs[209].id=183419064
set obs[209].ofid=24218187
set obs[210].id=183419046
set obs[210].ofid=24218183
set obs[211].id=182955913
set obs[211].ofid=24176517
set obs[212].id=182955903
set obs[212].ofid=24176512
set obs[213].id=182955902
set obs[213].ofid=24176511
set obs[214].id=182955893
set obs[214].ofid=24176510
set obs[215].id=182955892
set obs[215].ofid=24176509
set obs[216].id=182955891
set obs[216].ofid=24176508
set obs[217].id=182955880
set obs[217].ofid=24176500
set obs[218].id=182946258
set obs[218].ofid=24175805
set obs[219].id=182946257
set obs[219].ofid=24175804
set obs[220].id=182940930
set obs[220].ofid=24175383
set obs[221].id=182940929
set obs[221].ofid=24175381
set obs[222].id=182940922
set obs[222].ofid=24175377
set obs[223].id=182940921
set obs[223].ofid=24175376
set obs[224].id=182940920
set obs[224].ofid=24175373
set obs[225].id=182940919
set obs[225].ofid=24175372
set obs[226].id=182940913
set obs[226].ofid=24175371
set obs[227].id=182940912
set obs[227].ofid=24175369
set obs[228].id=182940907
set obs[228].ofid=24175368
set obs[229].id=182940905
set obs[229].ofid=24175367
set obs[230].id=182940904
set obs[230].ofid=24175366
set obs[231].id=182935535
set obs[231].ofid=24174922
set obs[232].id=182935532
set obs[232].ofid=24174921
set obs[233].id=182935531
set obs[233].ofid=24174919
set obs[234].id=182935528
set obs[234].ofid=24174918
set obs[235].id=182935526
set obs[235].ofid=24174916
set obs[236].id=182935519
set obs[236].ofid=24174912
set obs[237].id=182935496
set obs[237].ofid=24174900
set obs[238].id=182935495
set obs[238].ofid=24174899
set obs[239].id=182935492
set obs[239].ofid=24174898
set obs[240].id=182935490
set obs[240].ofid=24174897
set obs[241].id=182935487
set obs[241].ofid=24174895
set obs[242].id=182935479
set obs[242].ofid=24174893
set obs[243].id=182935462
set obs[243].ofid=24174891
set obs[244].id=182935461
set obs[244].ofid=24174890
set obs[245].id=182929380
set obs[245].ofid=24174362
set obs[246].id=182929357
set obs[246].ofid=24174353
set obs[247].id=182929348
set obs[247].ofid=24174351
set obs[248].id=182929346
set obs[248].ofid=24174350
set obs[249].id=182929345
set obs[249].ofid=24174349
set obs[250].id=182929344
set obs[250].ofid=24174348
set obs[251].id=182929342
set obs[251].ofid=24174347
set obs[252].id=182929340
set obs[252].ofid=24174346
set obs[253].id=182929339
set obs[253].ofid=24174345
set obs[254].id=182929336
set obs[254].ofid=24174344
set obs[255].id=182929334
set obs[255].ofid=24174343
set obs[256].id=182872873
set obs[256].ofid=24169474
set obs[257].id=182872871
set obs[257].ofid=24169472
set obs[258].id=182872854
set obs[258].ofid=24169463
set obs[259].id=182867774
set obs[259].ofid=24168995
set obs[260].id=182867755
set obs[260].ofid=24168983
set obs[261].id=182867743
set obs[261].ofid=24168980
set obs[262].id=181451900
set obs[262].ofid=24033282
set obs[263].id=181451889
set obs[263].ofid=24033280
set obs[264].id=181451858
set obs[264].ofid=24033274
set obs[265].id=181277370
set obs[265].ofid=24021204
set obs[266].id=181277357
set obs[266].ofid=24021202
set obs[267].id=181127824
set obs[267].ofid=24009199
set obs[268].id=181127097
set obs[268].ofid=24009019
set obs[269].id=180932817
set obs[269].ofid=23992710
set obs[270].id=180930651
set obs[270].ofid=23992584
set obs[271].id=180351181
set obs[271].ofid=23948393
set obs[272].id=180348302
set obs[272].ofid=23947636
set obs[273].id=180348279
set obs[273].ofid=23947627
set obs[274].id=180168217
set obs[274].ofid=23928070
set obs[275].id=142301990
set obs[275].ofid=20619557
set obs[276].id=142301696
set obs[276].ofid=20619506
set obs[277].id=142301526
set obs[277].ofid=20619478
set obs[278].id=142301491
set obs[278].ofid=20619470
set obs[279].id=142301449
set obs[279].ofid=20619464
set obs[280].id=142301340
set obs[280].ofid=20619449
set obs[281].id=142300455
set obs[281].ofid=20619407
set obs[282].id=142299971
set obs[282].ofid=20619382
set obs[283].id=142299902
set obs[283].ofid=20619379
set obs[284].id=142299776
set obs[284].ofid=20619289
set obs[285].id=142299731
set obs[285].ofid=20619288
set obs[286].id=142299680
set obs[286].ofid=20619284
set obs[287].id=142299628
set obs[287].ofid=20619282
set obs[288].id=142299389
set obs[288].ofid=20619269
set obs[289].id=142299360
set obs[289].ofid=20619267
set obs[290].id=142299320
set obs[290].ofid=20619258
set obs[291].id=142299293
set obs[291].ofid=20619256
set obs[292].id=142299261
set obs[292].ofid=20619255
set obs[293].id=142299222
set obs[293].ofid=20619251
set obs[294].id=142299000
set obs[294].ofid=20619245
set obs[295].id=142298956
set obs[295].ofid=20619244
set obs[296].id=142298890
set obs[296].ofid=20619240
set obs[297].id=142298809
set obs[297].ofid=20619232
set obs[298].id=142298770
set obs[298].ofid=20619229
set obs[299].id=142298661
set obs[299].ofid=20619225
set obs[300].id=142251361
set obs[300].ofid=20615221
set obs[301].id=142250750
set obs[301].ofid=20615181
set obs[302].id=142250710
set obs[302].ofid=20615171
set obs[303].id=142250680
set obs[303].ofid=20615157
set obs[304].id=142250628
set obs[304].ofid=20615144
set obs[305].id=142250570
set obs[305].ofid=20615141
set obs[306].id=142250520
set obs[306].ofid=20615128
set obs[307].id=142250446
set obs[307].ofid=20615123
set obs[308].id=142250237
set obs[308].ofid=20615087
set obs[309].id=142250170
set obs[309].ofid=20615080
set obs[310].id=142249507
set obs[310].ofid=20615030
set obs[311].id=142249471
set obs[311].ofid=20615028
set obs[312].id=142249125
set obs[312].ofid=20614999
set obs[313].id=142249056
set obs[313].ofid=20614996
set obs[314].id=142247638
set obs[314].ofid=20614917
set obs[315].id=142247595
set obs[315].ofid=20614916
set obs[316].id=142247497
set obs[316].ofid=20614912
set obs[317].id=142247333
set obs[317].ofid=20614902
set obs[318].id=139273252
set obs[318].ofid=20274224
set obs[319].id=139273061
set obs[319].ofid=20274216
set obs[320].id=139272746
set obs[320].ofid=20274180
set obs[321].id=139272452
set obs[321].ofid=20274162
set obs[322].id=139271728
set obs[322].ofid=20274131
set obs[323].id=139271468
set obs[323].ofid=20274124
set obs[324].id=139271377
set obs[324].ofid=20274102
set obs[325].id=139271312
set obs[325].ofid=20274097
set obs[326].id=139271162
set obs[326].ofid=20274083
set obs[327].id=139270998
set obs[327].ofid=20274076
set obs[328].id=139270870
set obs[328].ofid=20274065
set obs[329].id=139269859
set obs[329].ofid=20273984
set obs[330].id=139269716
set obs[330].ofid=20273976
set obs[331].id=139269000
set obs[331].ofid=20273912
set obs[332].id=139268602
set obs[332].ofid=20273789
set obs[333].id=139268397
set obs[333].ofid=20273739
set obs[334].id=139268219
set obs[334].ofid=20273682
set obs[335].id=139267637
set obs[335].ofid=20273549
set obs[336].id=139267542
set obs[336].ofid=20273477
set obs[337].id=139267439
set obs[337].ofid=20273422
set obs[338].id=139267272
set obs[338].ofid=20273378
set obs[339].id=139267121
set obs[339].ofid=20273316
set obs[340].id=139266070
set obs[340].ofid=20273079
set obs[341].id=139265907
set obs[341].ofid=20273067
set obs[342].id=139265628
set obs[342].ofid=20273020
set obs[343].id=139264818
set obs[343].ofid=20272917
set obs[344].id=139264678
set obs[344].ofid=20272910
set obs[345].id=139233529
set obs[345].ofid=20270119
set obs[346].id=139233420
set obs[346].ofid=20270110
set obs[347].id=139233302
set obs[347].ofid=20270095
set obs[348].id=139233002
set obs[348].ofid=20270058
set obs[349].id=139232474
set obs[349].ofid=20270048
set obs[350].id=139232082
set obs[350].ofid=20270016
set obs[351].id=139231810
set obs[351].ofid=20269984
set obs[352].id=139231592
set obs[352].ofid=20269970
set obs[353].id=139229470
set obs[353].ofid=20269853
set obs[354].id=139229384
set obs[354].ofid=20269851
set obs[355].id=139229319
set obs[355].ofid=20269849
set obs[356].id=139229268
set obs[356].ofid=20269846
set obs[357].id=139229199
set obs[357].ofid=20269824
set obs[358].id=139228612
set obs[358].ofid=20269792
set obs[359].id=139228471
set obs[359].ofid=20269787
set obs[360].id=139228231
set obs[360].ofid=20269774
set obs[361].id=139228044
set obs[361].ofid=20269767
set obs[362].id=139227645
set obs[362].ofid=20269720
set obs[363].id=139227600
set obs[363].ofid=20269716
set obs[364].id=139227380
set obs[364].ofid=20269689
set obs[365].id=139227282
set obs[365].ofid=20269672
set obs[366].id=139227154
set obs[366].ofid=20269664
set obs[367].id=139226411
set obs[367].ofid=20269599
set obs[368].id=139226289
set obs[368].ofid=20269598
set obs[369].id=139225725
set obs[369].ofid=20269574
set obs[370].id=139225636
set obs[370].ofid=20269562
set obs[371].id=139225592
set obs[371].ofid=20269560
set obs[372].id=139225522
set obs[372].ofid=20269557
set obs[373].id=139225456
set obs[373].ofid=20269545
set obs[374].id=139225379
set obs[374].ofid=20269541
set obs[375].id=139225340
set obs[375].ofid=20269534
set obs[376].id=139225291
set obs[376].ofid=20269531
set obs[377].id=139224865
set obs[377].ofid=20269492
set obs[378].id=139224794
set obs[378].ofid=20269488
set obs[379].id=139224718
set obs[379].ofid=20269469
set obs[380].id=139224656
set obs[380].ofid=20269468
set obs[381].id=139224585
set obs[381].ofid=20269452
set obs[382].id=139224433
set obs[382].ofid=20269449
set obs[383].id=139224370
set obs[383].ofid=20269445
set obs[384].id=139224322
set obs[384].ofid=20269439
set obs[385].id=139224129
set obs[385].ofid=20269416
set obs[386].id=139224066
set obs[386].ofid=20269414
set obs[387].id=139224019
set obs[387].ofid=20269412
set obs[388].id=139223602
set obs[388].ofid=20269386
set obs[389].id=139223468
set obs[389].ofid=20269374
set obs[390].id=139223323
set obs[390].ofid=20269371
set obs[391].id=139223249
set obs[391].ofid=20269368
set obs[392].id=139157106
set obs[392].ofid=20261563
set obs[393].id=139157032
set obs[393].ofid=20261562
set obs[394].id=139156744
set obs[394].ofid=20261543
set obs[395].id=139155936
set obs[395].ofid=20261467
set obs[396].id=139155787
set obs[396].ofid=20261461
set obs[397].id=139155593
set obs[397].ofid=20261448
set obs[398].id=139155142
set obs[398].ofid=20261390
set obs[399].id=139154642
set obs[399].ofid=20261320
set obs[400].id=139154527
set obs[400].ofid=20261317
set obs[401].id=139154215
set obs[401].ofid=20261294
set obs[402].id=139154042
set obs[402].ofid=20260858
set obs[403].id=139153721
set obs[403].ofid=20260839
set obs[404].id=139153570
set obs[404].ofid=20260830
set obs[405].id=139153477
set obs[405].ofid=20260822
set obs[406].id=139153192
set obs[406].ofid=20260796
set obs[407].id=139152468
set obs[407].ofid=20260716
set obs[408].id=139152320
set obs[408].ofid=20260706
set obs[409].id=139152050
set obs[409].ofid=20260693
set obs[410].id=139151954
set obs[410].ofid=20260679
set obs[411].id=139151836
set obs[411].ofid=20260678
set obs[412].id=139151719
set obs[412].ofid=20260675
set obs[413].id=139151404
set obs[413].ofid=20260667
set obs[414].id=139151282
set obs[414].ofid=20260661
set obs[415].id=139144931
set obs[415].ofid=20259865
set obs[416].id=139144572
set obs[416].ofid=20259840
set obs[417].id=139144174
set obs[417].ofid=20259801
set obs[418].id=139143718
set obs[418].ofid=20259771
set obs[419].id=139143281
set obs[419].ofid=20259766
set obs[420].id=139139986
set obs[420].ofid=20259390
set obs[421].id=139139802
set obs[421].ofid=20259379
set obs[422].id=139138550
set obs[422].ofid=20259298
set obs[423].id=139138487
set obs[423].ofid=20259280
set obs[424].id=139138264
set obs[424].ofid=20259270
set obs[425].id=139113304
set obs[425].ofid=20256883
set obs[426].id=139113157
set obs[426].ofid=20256877
set obs[427].id=139112461
set obs[427].ofid=20256786
set obs[428].id=139112406
set obs[428].ofid=20256784
set obs[429].id=139042224
set obs[429].ofid=20251139
set obs[430].id=139041982
set obs[430].ofid=20251130
set obs[431].id=139041205
set obs[431].ofid=20251086
set obs[432].id=139040387
set obs[432].ofid=20251018
set obs[433].id=139040238
set obs[433].ofid=20251007
set obs[434].id=138606230
set obs[434].ofid=20205001
set obs[435].id=138322145
set obs[435].ofid=20174856
set obs[436].id=138322021
set obs[436].ofid=20174854
set obs[437].id=138321886
set obs[437].ofid=20174844
set obs[438].id=138321637
set obs[438].ofid=20174838
set obs[439].id=138321515
set obs[439].ofid=20174827
set obs[440].id=138321160
set obs[440].ofid=20174802
set obs[441].id=138321085
set obs[441].ofid=20174798
set obs[442].id=138320785
set obs[442].ofid=20174764
set obs[443].id=138320709
set obs[443].ofid=20174760
set obs[444].id=138320666
set obs[444].ofid=20174755
set obs[445].id=138320516
set obs[445].ofid=20174733
set obs[446].id=138320441
set obs[446].ofid=20174729
set obs[447].id=138320239
set obs[447].ofid=20174712
set obs[448].id=138320117
set obs[448].ofid=20174701
set obs[449].id=138319998
set obs[449].ofid=20174691
set obs[450].id=138319678
set obs[450].ofid=20174669
set obs[451].id=138319567
set obs[451].ofid=20174658
set obs[452].id=138319446
set obs[452].ofid=20174645
set obs[453].id=138319252
set obs[453].ofid=20174625
set obs[454].id=138319188
set obs[454].ofid=20174616
set obs[455].id=138319111
set obs[455].ofid=20174605
set obs[456].id=138319048
set obs[456].ofid=20174596
set obs[457].id=138318670
set obs[457].ofid=20174545
set obs[458].id=138318446
set obs[458].ofid=20174509
set obs[459].id=138318269
set obs[459].ofid=20174485
set obs[460].id=138318130
set obs[460].ofid=20174468
set obs[461].id=138318042
set obs[461].ofid=20174462
set obs[462].id=138317615
set obs[462].ofid=20174443
set obs[463].id=138317613
set obs[463].ofid=20174442
set obs[464].id=138316237
set obs[464].ofid=20174307
set obs[465].id=138316128
set obs[465].ofid=20174293
set obs[466].id=138315969
set obs[466].ofid=20174274
set obs[467].id=138125828
set obs[467].ofid=20154735
set obs[468].id=138125226
set obs[468].ofid=20154712
set obs[469].id=138124527
set obs[469].ofid=20154653
set obs[470].id=138124225
set obs[470].ofid=20154645
set obs[471].id=138123748
set obs[471].ofid=20154615
set obs[472].id=138123175
set obs[472].ofid=20154587
set obs[473].id=138122761
set obs[473].ofid=20154571
set obs[474].id=138122463
set obs[474].ofid=20154547
set obs[475].id=138122325
set obs[475].ofid=20154531
set obs[476].id=138121817
set obs[476].ofid=20154451
set obs[477].id=138121221
set obs[477].ofid=20154411
set obs[478].id=138120952
set obs[478].ofid=20154406
set obs[479].id=138120694
set obs[479].ofid=20154368
set obs[480].id=138120509
set obs[480].ofid=20154353
set obs[481].id=138120338
set obs[481].ofid=20154291
set obs[482].id=138120204
set obs[482].ofid=20154284
set obs[483].id=138120101
set obs[483].ofid=20154269
set obs[484].id=138119833
set obs[484].ofid=20154258
set obs[485].id=138119630
set obs[485].ofid=20154253
set obs[486].id=138119388
set obs[486].ofid=20154241
set obs[487].id=138115335
set obs[487].ofid=20153892
set obs[488].id=138115036
set obs[488].ofid=20153870
set obs[489].id=138114915
set obs[489].ofid=20153862
set obs[490].id=138114171
set obs[490].ofid=20153825
set obs[491].id=138049670
set obs[491].ofid=20146671
set obs[492].id=138048795
set obs[492].ofid=20146639
set obs[493].id=138048433
set obs[493].ofid=20146615
set obs[494].id=138048129
set obs[494].ofid=20146604
set obs[495].id=138047988
set obs[495].ofid=20146591
set obs[496].id=138047818
set obs[496].ofid=20146590
set obs[497].id=138047549
set obs[497].ofid=20146581
set obs[498].id=138047020
set obs[498].ofid=20146563
set obs[499].id=138046961
set obs[499].ofid=20146548
set obs[500].id=138046829
set obs[500].ofid=20146542
set obs[501].id=138046701
set obs[501].ofid=20146536
set obs[502].id=138046467
set obs[502].ofid=20146524
set obs[503].id=138046346
set obs[503].ofid=20146522
set obs[504].id=138046208
set obs[504].ofid=20146519
set obs[505].id=138046067
set obs[505].ofid=20146518
set obs[506].id=138045882
set obs[506].ofid=20146513
set obs[507].id=138045708
set obs[507].ofid=20146512
set obs[508].id=138045461
set obs[508].ofid=20146507
set obs[509].id=138045309
set obs[509].ofid=20146504
set obs[510].id=138045166
set obs[510].ofid=20146498
set obs[511].id=138045084
set obs[511].ofid=20146497
set obs[512].id=138045010
set obs[512].ofid=20146489
set obs[513].id=138044906
set obs[513].ofid=20146481
set obs[514].id=138044759
set obs[514].ofid=20146470
set obs[515].id=138044567
set obs[515].ofid=20146459
set obs[516].id=138044491
set obs[516].ofid=20146455
set obs[517].id=138044366
set obs[517].ofid=20146451
set obs[518].id=138043491
set obs[518].ofid=20146421
set obs[519].id=138043270
set obs[519].ofid=20146350
set obs[520].id=138043075
set obs[520].ofid=20146340
set obs[521].id=138042989
set obs[521].ofid=20146323
set obs[522].id=138042880
set obs[522].ofid=20146319
set obs[523].id=138042554
set obs[523].ofid=20146291
set obs[524].id=138042296
set obs[524].ofid=20146283
set obs[525].id=138042108
set obs[525].ofid=20146274
set obs[526].id=138026836
set obs[526].ofid=20145567
set obs[527].id=138026193
set obs[527].ofid=20145530
set obs[528].id=138025845
set obs[528].ofid=20145495
set obs[529].id=137976363
set obs[529].ofid=20140559
set obs[530].id=137976201
set obs[530].ofid=20140552
set obs[531].id=137975874
set obs[531].ofid=20140534
set obs[532].id=137975567
set obs[532].ofid=20140523
set obs[533].id=137975379
set obs[533].ofid=20140517
set obs[534].id=137975066
set obs[534].ofid=20140434
set obs[535].id=137974946
set obs[535].ofid=20140430
set obs[536].id=137974799
set obs[536].ofid=20140429
set obs[537].id=137972612
set obs[537].ofid=20140295
set obs[538].id=137907016
set obs[538].ofid=20132142
set obs[539].id=137906913
set obs[539].ofid=20132133
set obs[540].id=137906730
set obs[540].ofid=20132130
set obs[541].id=137906320
set obs[541].ofid=20132122
set obs[542].id=137904777
set obs[542].ofid=20132062
set obs[543].id=137904194
set obs[543].ofid=20132013
set obs[544].id=137903774
set obs[544].ofid=20131976
set obs[545].id=137903639
set obs[545].ofid=20131964
set obs[546].id=137901167
set obs[546].ofid=20131795
set obs[547].id=137899841
set obs[547].ofid=20131763
set obs[548].id=137799906
set obs[548].ofid=20120552
set obs[549].id=137799150
set obs[549].ofid=20120463
set obs[550].id=137798681
set obs[550].ofid=20120436
set obs[551].id=137798593
set obs[551].ofid=20120434
set obs[552].id=137798495
set obs[552].ofid=20120427
set obs[553].id=137798231
set obs[553].ofid=20120409
set obs[554].id=137798107
set obs[554].ofid=20120407
set obs[555].id=137797199
set obs[555].ofid=20120335
set obs[556].id=137795908
set obs[556].ofid=20120204
set obs[557].id=137795645
set obs[557].ofid=20120188
set obs[558].id=137795384
set obs[558].ofid=20120178
set obs[559].id=137794457
set obs[559].ofid=20120029
set obs[560].id=137794195
set obs[560].ofid=20119980
set obs[561].id=137793970
set obs[561].ofid=20119963
set obs[562].id=137793648
set obs[562].ofid=20119942
set obs[563].id=137793516
set obs[563].ofid=20119931
set obs[564].id=137793424
set obs[564].ofid=20119915
set obs[565].id=137793199
set obs[565].ofid=20119905
set obs[566].id=137792984
set obs[566].ofid=20119895
set obs[567].id=137792921
set obs[567].ofid=20119894
set obs[568].id=137792821
set obs[568].ofid=20119886
set obs[569].id=137687399
set obs[569].ofid=20104426
set obs[570].id=137687325
set obs[570].ofid=20104410
set obs[571].id=136860725
set obs[571].ofid=20014574
set obs[572].id=136860668
set obs[572].ofid=20014565
set obs[573].id=136860600
set obs[573].ofid=20014561
set obs[574].id=136860525
set obs[574].ofid=20014551
set obs[575].id=136860157
set obs[575].ofid=20014525
set obs[576].id=136859891
set obs[576].ofid=20014509
set obs[577].id=136859652
set obs[577].ofid=20014500
set obs[578].id=136859561
set obs[578].ofid=20014464
set obs[579].id=136859396
set obs[579].ofid=20014452
set obs[580].id=136859098
set obs[580].ofid=20014432
set obs[581].id=136858622
set obs[581].ofid=20014406
set obs[582].id=136858104
set obs[582].ofid=20014389
set obs[583].id=136857648
set obs[583].ofid=20014354
set obs[584].id=136849511
set obs[584].ofid=20013833
set obs[585].id=136849341
set obs[585].ofid=20013823
set obs[586].id=136847183
set obs[586].ofid=20013672
set obs[587].id=136846836
set obs[587].ofid=20013656
set obs[588].id=136846631
set obs[588].ofid=20013651
set obs[589].id=136846314
set obs[589].ofid=20013635
set obs[590].id=136845836
set obs[590].ofid=20013562
set obs[591].id=136844884
set obs[591].ofid=20013444
set obs[592].id=136843531
set obs[592].ofid=20013311
set obs[593].id=136843405
set obs[593].ofid=20013283
set obs[594].id=136843234
set obs[594].ofid=20013252
set obs[595].id=136842997
set obs[595].ofid=20013207
set obs[596].id=136842598
set obs[596].ofid=20013141
set obs[597].id=136842444
set obs[597].ofid=20013114
set obs[598].id=136841838
set obs[598].ofid=20013043
set obs[599].id=136840377
set obs[599].ofid=20012824
set obs[600].id=136840123
set obs[600].ofid=20012788
set obs[601].id=136839460
set obs[601].ofid=20012728
set obs[602].id=136839012
set obs[602].ofid=20012672
set obs[603].id=136838760
set obs[603].ofid=20012661
set obs[604].id=136838330
set obs[604].ofid=20012629
set obs[605].id=136738342
set obs[605].ofid=20002454
set obs[606].id=136738213
set obs[606].ofid=20002450
set obs[607].id=136738044
set obs[607].ofid=20002401
set obs[608].id=136737931
set obs[608].ofid=20002370
set obs[609].id=136737751
set obs[609].ofid=20002309
set obs[610].id=136737660
set obs[610].ofid=20002283
set obs[611].id=136737045
set obs[611].ofid=20002122
set obs[612].id=136736780
set obs[612].ofid=20002045
set obs[613].id=136736649
set obs[613].ofid=20002007
set obs[614].id=136736548
set obs[614].ofid=20001983
set obs[615].id=136736321
set obs[615].ofid=20001911
set obs[616].id=136736216
set obs[616].ofid=20001878
set obs[617].id=136736103
set obs[617].ofid=20001849
set obs[618].id=136735938
set obs[618].ofid=20001810
set obs[619].id=136734277
set obs[619].ofid=20001255
set obs[620].id=136734209
set obs[620].ofid=20001224
set obs[621].id=136734039
set obs[621].ofid=20001169
set obs[622].id=136733862
set obs[622].ofid=20001126
set obs[623].id=136733794
set obs[623].ofid=20001083
set obs[624].id=136733727
set obs[624].ofid=20001049
set obs[625].id=136733645
set obs[625].ofid=20001013
set obs[626].id=136733551
set obs[626].ofid=20000970
set obs[627].id=136732583
set obs[627].ofid=20000604
set obs[628].id=136732440
set obs[628].ofid=20000550
set obs[629].id=136731040
set obs[629].ofid=20000487
set obs[630].id=136730921
set obs[630].ofid=20000480
set obs[631].id=136730785
set obs[631].ofid=20000473
set obs[632].id=136727200
set obs[632].ofid=20000179
set obs[633].id=136726657
set obs[633].ofid=20000121
set obs[634].id=136726324
set obs[634].ofid=20000086
set obs[635].id=136726122
set obs[635].ofid=20000068
set obs[636].id=136725665
set obs[636].ofid=20000003
set obs[637].id=136725502
set obs[637].ofid=19999993
set obs[638].id=136725454
set obs[638].ofid=19999983
set obs[639].id=136725348
set obs[639].ofid=19999963
set obs[640].id=136725264
set obs[640].ofid=19999948
set obs[641].id=136725181
set obs[641].ofid=19999933
set obs[642].id=136724929
set obs[642].ofid=19999917
set obs[643].id=136723811
set obs[643].ofid=19999898
set obs[644].id=136723708
set obs[644].ofid=19999894
set obs[645].id=136723480
set obs[645].ofid=19999888
set obs[646].id=136722308
set obs[646].ofid=19999851
set obs[647].id=136635163
set obs[647].ofid=19990311
set obs[648].id=136634906
set obs[648].ofid=19990303
set obs[649].id=136634671
set obs[649].ofid=19990294
set obs[650].id=136634530
set obs[650].ofid=19990283
set obs[651].id=136634454
set obs[651].ofid=19990280
set obs[652].id=136634347
set obs[652].ofid=19990269
set obs[653].id=136634283
set obs[653].ofid=19990262
set obs[654].id=136634119
set obs[654].ofid=19990251
set obs[655].id=136633791
set obs[655].ofid=19990221
set obs[656].id=136633681
set obs[656].ofid=19990212
set obs[657].id=136633382
set obs[657].ofid=19990203
set obs[658].id=136633265
set obs[658].ofid=19990197
set obs[659].id=136633055
set obs[659].ofid=19990183
set obs[660].id=136632890
set obs[660].ofid=19990160
set obs[661].id=136632771
set obs[661].ofid=19990155
set obs[662].id=136632407
set obs[662].ofid=19990137
set obs[663].id=136632163
set obs[663].ofid=19990121
set obs[664].id=136631932
set obs[664].ofid=19990056
set obs[665].id=136630942
set obs[665].ofid=19989895
set obs[666].id=136630597
set obs[666].ofid=19989865
set obs[667].id=136630486
set obs[667].ofid=19989849
set obs[668].id=136630223
set obs[668].ofid=19989837
set obs[669].id=136627716
set obs[669].ofid=19989591
set obs[670].id=136627582
set obs[670].ofid=19989550
set obs[671].id=136627347
set obs[671].ofid=19989496
set obs[672].id=136625698
set obs[672].ofid=19989187
set obs[673].id=136625322
set obs[673].ofid=19989149
set obs[674].id=136624917
set obs[674].ofid=19989095
set obs[675].id=136624548
set obs[675].ofid=19989032
set obs[676].id=136624256
set obs[676].ofid=19988989
set obs[677].id=136623782
set obs[677].ofid=19988808
set obs[678].id=136623593
set obs[678].ofid=19988782
set obs[679].id=136623307
set obs[679].ofid=19988748
set obs[680].id=136623243
set obs[680].ofid=19988745
set obs[681].id=136622695
set obs[681].ofid=19988678
set obs[682].id=136572961
set obs[682].ofid=19984148
set obs[683].id=136571134
set obs[683].ofid=19984006
set obs[684].id=136569798
set obs[684].ofid=19983917
set obs[685].id=136568862
set obs[685].ofid=19983872
set obs[686].id=136568216
set obs[686].ofid=19983833
set obs[687].id=136567788
set obs[687].ofid=19983775
set obs[688].id=136567480
set obs[688].ofid=19983762
set obs[689].id=136567292
set obs[689].ofid=19983737
set obs[690].id=136566899
set obs[690].ofid=19983669
set obs[691].id=136566059
set obs[691].ofid=19983581
set obs[692].id=136565611
set obs[692].ofid=19983495
set obs[693].id=136565294
set obs[693].ofid=19983461
set obs[694].id=136489294
set obs[694].ofid=19977044
set obs[695].id=136488137
set obs[695].ofid=19976945
set obs[696].id=136487857
set obs[696].ofid=19976904
set obs[697].id=136485655
set obs[697].ofid=19976695
set obs[698].id=136484782
set obs[698].ofid=19976631
set obs[699].id=136484703
set obs[699].ofid=19976626
set obs[700].id=136484437
set obs[700].ofid=19976616
set obs[701].id=136483412
set obs[701].ofid=19976512
set obs[702].id=136482965
set obs[702].ofid=19976485
set obs[703].id=136482739
set obs[703].ofid=19976465
set obs[704].id=136480302
set obs[704].ofid=19976301
set obs[705].id=136477510
set obs[705].ofid=19975979
set obs[706].id=135447989
set obs[706].ofid=19882402
set obs[707].id=135447892
set obs[707].ofid=19882398
set obs[708].id=135447580
set obs[708].ofid=19882368
set obs[709].id=135447375
set obs[709].ofid=19882362
set obs[710].id=135446990
set obs[710].ofid=19882349
set obs[711].id=135446008
set obs[711].ofid=19882320
set obs[712].id=135445762
set obs[712].ofid=19882318
set obs[713].id=135445672
set obs[713].ofid=19882315
set obs[714].id=135445614
set obs[714].ofid=19882311
set obs[715].id=135445404
set obs[715].ofid=19882306
set obs[716].id=135444209
set obs[716].ofid=19882267
set obs[717].id=135443788
set obs[717].ofid=19882257
set obs[718].id=135443679
set obs[718].ofid=19882252
set obs[719].id=135443518
set obs[719].ofid=19882245
set obs[720].id=135443428
set obs[720].ofid=19882243
set obs[721].id=135443330
set obs[721].ofid=19882239
set obs[722].id=135441733
set obs[722].ofid=19882180
set obs[723].id=135441645
set obs[723].ofid=19882177
set obs[724].id=135441544
set obs[724].ofid=19882175
set obs[725].id=135441322
set obs[725].ofid=19882171
set obs[726].id=135441235
set obs[726].ofid=19882169
set obs[727].id=135441150
set obs[727].ofid=19882167
set obs[728].id=135441083
set obs[728].ofid=19882166
set obs[729].id=135440943
set obs[729].ofid=19882163
set obs[730].id=135440836
set obs[730].ofid=19882162
set obs[731].id=135440734
set obs[731].ofid=19882160
set obs[732].id=135440644
set obs[732].ofid=19882158
set obs[733].id=135372316
set obs[733].ofid=19877616
set obs[734].id=135371456
set obs[734].ofid=19877528
set obs[735].id=135163670
set obs[735].ofid=19857549
set obs[736].id=135162390
set obs[736].ofid=19857285
set obs[737].id=135162299
set obs[737].ofid=19857271
set obs[738].id=135162198
set obs[738].ofid=19857260
set obs[739].id=135162027
set obs[739].ofid=19857222
set obs[740].id=135160663
set obs[740].ofid=19856876
set obs[741].id=135158474
set obs[741].ofid=19856074
set obs[742].id=135158012
set obs[742].ofid=19855922
set obs[743].id=135157570
set obs[743].ofid=19855868
set obs[744].id=135157458
set obs[744].ofid=19855856
set obs[745].id=135156898
set obs[745].ofid=19855776
set obs[746].id=135155723
set obs[746].ofid=19855652
set obs[747].id=135134922
set obs[747].ofid=19853113
set obs[748].id=135129141
set obs[748].ofid=19852458
set obs[749].id=135127765
set obs[749].ofid=19852369
set obs[750].id=135127295
set obs[750].ofid=19852338
set obs[751].id=135125268
set obs[751].ofid=19852268
set obs[752].id=135119046
set obs[752].ofid=19851689
set obs[753].id=135118876
set obs[753].ofid=19851682
set obs[754].id=135118621
set obs[754].ofid=19851644
set obs[755].id=135117371
set obs[755].ofid=19851589
set obs[756].id=135117285
set obs[756].ofid=19851588
set obs[757].id=135116918
set obs[757].ofid=19851561
set obs[758].id=135114992
set obs[758].ofid=19851473
set obs[759].id=135114185
set obs[759].ofid=19851454
set obs[760].id=135114105
set obs[760].ofid=19851444
set obs[761].id=135113328
set obs[761].ofid=19851351
set obs[762].id=135112711
set obs[762].ofid=19851338
set obs[763].id=135112169
set obs[763].ofid=19851290
set obs[764].id=135111677
set obs[764].ofid=19851217
set obs[765].id=135111462
set obs[765].ofid=19851209
set obs[766].id=135111243
set obs[766].ofid=19851197
set obs[767].id=135110944
set obs[767].ofid=19851186
set obs[768].id=135110695
set obs[768].ofid=19851158
set obs[769].id=135110160
set obs[769].ofid=19851089
set obs[770].id=135109937
set obs[770].ofid=19851087
set obs[771].id=135109815
set obs[771].ofid=19851080
set obs[772].id=135108249
set obs[772].ofid=19850980
set obs[773].id=135108064
set obs[773].ofid=19850971
set obs[774].id=135048614
set obs[774].ofid=19844883
set obs[775].id=134923280
set obs[775].ofid=19832370
set obs[776].id=134923061
set obs[776].ofid=19832351
set obs[777].id=134915641
set obs[777].ofid=19831687
set obs[778].id=134914747
set obs[778].ofid=19831555
set obs[779].id=134914371
set obs[779].ofid=19831534
set obs[780].id=134913728
set obs[780].ofid=19831469
set obs[781].id=134913636
set obs[781].ofid=19831459
set obs[782].id=134913528
set obs[782].ofid=19831450
set obs[783].id=134913389
set obs[783].ofid=19831419
set obs[784].id=134913052
set obs[784].ofid=19831386
set obs[785].id=134912846
set obs[785].ofid=19831383
set obs[786].id=134909958
set obs[786].ofid=19831197
set obs[787].id=134909874
set obs[787].ofid=19831189
set obs[788].id=134909618
set obs[788].ofid=19831185
set obs[789].id=134909333
set obs[789].ofid=19831178
set obs[790].id=134909115
set obs[790].ofid=19831172
set obs[791].id=134908900
set obs[791].ofid=19831169
set obs[792].id=134908509
set obs[792].ofid=19831153
set obs[793].id=134908435
set obs[793].ofid=19831152
set obs[794].id=134907995
set obs[794].ofid=19831144
set obs[795].id=134907741
set obs[795].ofid=19831142
set obs[796].id=134907562
set obs[796].ofid=19831132
set obs[797].id=134907096
set obs[797].ofid=19831108
set obs[798].id=134906933
set obs[798].ofid=19831089
set obs[799].id=134906673
set obs[799].ofid=19831077
set obs[800].id=134896312
set obs[800].ofid=19830253
set obs[801].id=134896135
set obs[801].ofid=19830242
set obs[802].id=134895657
set obs[802].ofid=19830189
set obs[803].id=134498235
set obs[803].ofid=19796055
set obs[804].id=134348093
set obs[804].ofid=19781922
set obs[805].id=134348036
set obs[805].ofid=19781916
set obs[806].id=134345878
set obs[806].ofid=19781536
set obs[807].id=133679461
set obs[807].ofid=19718940
set obs[808].id=133675134
set obs[808].ofid=19718685
set obs[809].id=133674104
set obs[809].ofid=19718555
set obs[810].id=133643250
set obs[810].ofid=19716069
set obs[811].id=133642954
set obs[811].ofid=19716052
set obs[812].id=133642492
set obs[812].ofid=19716021
set obs[813].id=133632163
set obs[813].ofid=19714962
set obs[814].id=133621942
set obs[814].ofid=19714180
set obs[815].id=133249309
set obs[815].ofid=19677737
set obs[816].id=133238636
set obs[816].ofid=19676914
set obs[817].id=133235995
set obs[817].ofid=19676712
set obs[818].id=133235124
set obs[818].ofid=19676669
set obs[819].id=133215913
set obs[819].ofid=19675035
set obs[820].id=133196614
set obs[820].ofid=19673285
set obs[821].id=132807502
set obs[821].ofid=19635652
set obs[822].id=132807226
set obs[822].ofid=19635633
set obs[823].id=132800533
set obs[823].ofid=19635088
set obs[824].id=132800428
set obs[824].ofid=19635085
set obs[825].id=132696675
set obs[825].ofid=19628450
set obs[826].id=132339213
set obs[826].ofid=19600471
set obs[827].id=132285042
set obs[827].ofid=19595232
set obs[828].id=131577212
set obs[828].ofid=19534196
set obs[829].id=131517882
set obs[829].ofid=19529334
set obs[830].id=131517830
set obs[830].ofid=19529331
set obs[831].id=131513930
set obs[831].ofid=19528942
set obs[832].id=131447058
set obs[832].ofid=19523735
set obs[833].id=131444021
set obs[833].ofid=19523581
set obs[834].id=131443630
set obs[834].ofid=19523397
set obs[835].id=131443491
set obs[835].ofid=19523393
set obs[836].id=131443363
set obs[836].ofid=19523391
set obs[837].id=131321830
set obs[837].ofid=19512299
for /L %%i in (0,1,837) do (
  call echo %%i: Changing observation field %obs_field_id% value = %obs_field_value% for observation %%obs[%%i].id%%
  call curl "https://api.inaturalist.org/v1/observation_field_values/%%obs[%%i].ofid%%" -X "PUT" -H "Content-Type: application/json" -H "Accept: application/json" -H "Authorization: %jwt%" -d "{\"observation_field_value\": {\"observation_id\": %%obs[%%i].id%%, \"observation_field\": %obs_field_id%, \"value\": %obs_field_value%}}"
  timeout 1
)
echo Done.
pause

now, it’s your turn:

  1. open up Notepad (or another plain text or code editor) on your machine, and start with a blank document
  2. copy the code above and paste it into the document
  3. in your web browser, while you’re signed into iNaturalist, go to https://www.inaturalist.org/users/api_token. this should show you something that looks like {"api_token": "J.W.T"}. copy the J.W.T value (without the surrounding double quotes).
  4. back in your document, line 2 is set jwt=redacted. you will replace redacted with the value you just copied.
  5. now save this document using a filename with a .bat extension, such as “batchchange.bat”. note that if you’re using Notepad, when you save, you may have to explicitly change the “Save as type” value from “Text documents (*.txt)” to “All files (*.*)”.
  6. find the file you just created, and double-click to execute it. assuming no errors, all your observations will have been changed.

if you want to test the process out on a few observations first before changing the full set, then as part of step 2 above, delete all but the first few pairs of set obs[n] lines, and then in the line that begins with for, change 837 to whatever the maximum n is now. each of these pairs defines a specific observation id and associated observation field record to be changed. if the limited set of observations was changed appropriately, then you can repeat the process for the full set of observations.

1 Like

LMTaylor offered this suggestion.
Here are the steps:

  1. Go to the filtered URL in edit mode (this pulls up a maximum of 200 results at a time): https://www.inaturalist.org/observations/bugeyedbernie?field:interaction->Visited+flower+of=54903
  2. Click “Batch edit” at the top of the list
  3. Select some of the records
  4. “Edit selected”
  5. Open the yellow “Batch operations” box and “More fields”
  6. There is a section that is labeled “Add a field” but actually it can also be used to edit existing fields. So pull up “Interaction->Visited flower of” and set the value to whatever you want to change to.
  7. Click “Apply fields” at the right
  8. “Save all” at the bottom of the page
1 Like

ah, that is a tricky label. i’m glad you found a solution within the existing system.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.