To Cloud Run or Not to Cloud Run

[jirhiker]

Laptop, cloud-sql-proxy

********** TRANSFERRING WELLS **********
Processing row 25 of 28411. NM-11224, avg rows per second: 0.39
Processing row 50 of 28411. NM-21466, avg rows per second: 0.42
Processing row 75 of 28411. NM-21486, avg rows per second: 0.42

[jirhiker]

2025-09-11 21:55:18,044 [INFO ] Starting transfer
2025-09-11 21:55:18,044 [INFO ] Erasing existing data and initializing lexicon and sensors
2025-09-11 21:55:44,034 [INFO ] Done erasing existing data. 25.99s
2025-09-11 21:55:44,035 [INFO ] Initializing lexicon and sensors
2025-09-11 22:04:56,999 [INFO ] Done initializing lexicon. 552.96s
2025-09-11 22:04:57,556 [INFO ] Done initializing lexicon. 0.56s
2025-09-11 22:04:57,556 [INFO ]
2025-09-11 22:04:57,556 [INFO ] ********** TRANSFERRING WELLS **********
2025-09-11 22:05:59,361 [INFO ] Processing row 25 of 100. NM-21975, avg rows per second: 0.45
2025-09-11 22:06:55,947 [INFO ] Processing row 50 of 100. PP-040, avg rows per second: 0.44
2025-09-11 22:07:54,507 [INFO ] Processing row 75 of 100. NM-02887, avg rows per second: 0.44
2025-09-11 22:08:57,875 [INFO ]
2025-09-11 22:08:57,875 [INFO ] ********** TRANSFERRING SPRINGS **********
2025-09-11 22:09:56,380 [INFO ] Processing row 25 of 855. TB-1029, avg rows per second: 0.45
2025-09-11 22:10:52,751 [INFO ] Processing row 50 of 855. TS-115, avg rows per second: 0.45
2025-09-11 22:11:48,408 [INFO ] Processing row 75 of 855. NM-28354, avg rows per second: 0.45
2025-09-11 22:12:43,981 [WARNING ] Reached limit of 100 rows. Stopping migration.
2025-09-11 22:12:44,448 [INFO ]
2025-09-11 22:12:44,448 [INFO ] ********** TRANSFERRING PERENNIAL STREAMS **********
2025-09-11 22:13:42,351 [INFO ] Processing row 25 of 176. AR-0527, avg rows per second: 0.45
2025-09-11 22:14:38,267 [INFO ] Processing row 50 of 176. SM-4071, avg rows per second: 0.45
2025-09-11 22:15:33,974 [INFO ] Processing row 75 of 176. SM-3024, avg rows per second: 0.45
2025-09-11 22:16:29,615 [WARNING ] Reached limit of 100 rows. Stopping migration.
2025-09-11 22:16:30,084 [INFO ]
2025-09-11 22:16:30,084 [INFO ] ********** TRANSFERRING EPHEMERAL STREAMS **********
2025-09-11 22:17:27,963 [INFO ] Processing row 25 of 38. NM-27181, avg rows per second: 0.45
2025-09-11 22:17:57,680 [INFO ]
2025-09-11 22:17:57,681 [INFO ] ********** TRANSFERRING METEOROLOGICAL **********
2025-09-11 22:18:55,481 [INFO ] Processing row 25 of 64. SM-5002, avg rows per second: 0.45
2025-09-11 22:19:51,097 [INFO ] Processing row 50 of 64. SM-2013, avg rows per second: 0.45
2025-09-11 22:20:22,941 [INFO ]
2025-09-11 22:20:22,941 [INFO ] ********** TRANSFERRING CONTACTS **********
2025-09-11 22:20:28,115 [WARNING ] Skipping physical address for first contact Warren Thompson. Validation error: 1 validation error for CreateAddress
postal_code
Input should be a valid string [type=string_type, input_value=None, input_type=NoneType]
For further information visit https://errors.pydantic.dev/2.11/v/string_type
Processing PointID: 221 EB-663
2025-09-11 22:20:29,537 [INFO ] added first contact for PointID EB-663
added second contact for PointID EB-663
Processing PointID: 441 EB-057
2025-09-11 22:20:31,640 [INFO ] added first contact for PointID EB-057
Skipping second contact for PointID EB-057 due to validation error: 1 validation error for CreateContact
Value error, Either name or organization must be provided. [type=value_error, input_value={'thing_id': 31, 'release...wners': 'Noonan, Mitch'}, input_type=dict]
For further information visit https://errors.pydantic.dev/2.11/v/value_error
Processing PointID: 647 QU-047
Skipping second contact for PointID QU-047 due to validation error: 1 validation error for CreateContact
Value error, Either name or organization must be provided. [type=value_error, input_value={'thing_id': 1, 'release_...ez, Andrew and Cecilia'}, input_type=dict]
For further information visit https://errors.pydantic.dev/2.11/v/value_error
2025-09-11 22:20:33,145 [INFO ] added first contact for PointID QU-047
Processing PointID: 1040 TB-0123
2025-09-11 22:20:34,169 [INFO ] added first contact for PointID TB-0123
Skipping second contact for PointID TB-0123 due to validation error: 1 validation error for CreateContact
Value error, Either name or organization must be provided. [type=value_error, input_value={'thing_id': 93, 'release...: 'Hemphill, Eddie Bob'}, input_type=dict]
For further information visit https://errors.pydantic.dev/2.11/v/value_error
Processing PointID: 1670 TB-0161
Skipping second contact for PointID TB-0161 due to validation error: 1 validation error for CreateContact
Value error, Either name or organization must be provided. [type=value_error, input_value={'thing_id': 36, 'release... 'Gamble, Richard/Dori'}, input_type=dict]
For further information visit https://errors.pydantic.dev/2.11/v/value_error
2025-09-11 22:20:35,978 [INFO ] added first contact for PointID TB-0161
2025-09-11 22:20:35,985 [INFO ]
2025-09-11 22:20:35,985 [INFO ] ********** TRANSFERRING WATER LEVELS **********
2025-09-11 22:20:44,365 [INFO ] Processing PointID: ('AB-0132',)
2025-09-11 22:20:46,032 [INFO ] Processing PointID: ('BW-0131',)
2025-09-11 22:20:47,781 [INFO ] Processing PointID: ('DA-0050',)
2025-09-11 22:20:49,514 [INFO ] Processing PointID: ('DA-0141',)
2025-09-11 22:20:51,282 [INFO ] Processing PointID: ('DE-0219',)
2025-09-11 22:20:54,207 [INFO ] Processing PointID: ('DE-0274',)
2025-09-11 22:21:13,875 [INFO ] Processing PointID: ('EB-057',)
2025-09-11 22:21:15,665 [INFO ] Processing PointID: ('EB-663',)
2025-09-11 22:21:19,778 [INFO ] Processing PointID: ('NM-00430',)
2025-09-11 22:21:19,779 [WARNING ] Skipping row 42728 due to missing data.
2025-09-11 22:21:23,899 [WARNING ] Skipping row 271811 due to missing data.
2025-09-11 22:21:27,534 [INFO ] Processing PointID: ('NM-00761',)
2025-09-11 22:21:56,817 [INFO ] Processing row 25 of 54. NM-00761, avg rows per second: 0.35
2025-09-11 22:22:27,375 [INFO ] Processing row 50 of 54. NM-00761, avg rows per second: 0.49
2025-09-11 22:22:33,887 [INFO ] Processing PointID: ('NM-00797',)
2025-09-11 22:22:35,668 [INFO ] Processing PointID: ('NM-00900',)
2025-09-11 22:22:38,589 [INFO ] Processing PointID: ('NM-00902',)
2025-09-11 22:22:43,919 [INFO ] Processing PointID: ('NM-02181',)
2025-09-11 22:23:13,185 [INFO ] Processing row 25 of 30. NM-02181, avg rows per second: 0.17
2025-09-11 22:23:20,927 [INFO ] Processing PointID: ('NM-02255',)
2025-09-11 22:23:27,456 [INFO ] Processing PointID: ('NM-02743',)
2025-09-11 22:23:29,198 [WARNING ] Skipping row 65285 due to missing data.
2025-09-11 22:23:55,851 [INFO ] Processing row 25 of 33. NM-02743, avg rows per second: 0.13
2025-09-11 22:24:08,002 [INFO ] Processing PointID: ('NM-02887',)
2025-09-11 22:24:13,396 [INFO ] Processing PointID: ('NM-02969',)
2025-09-11 22:24:21,252 [INFO ] Processing PointID: ('NM-03078',)
2025-09-11 22:24:50,627 [INFO ] Processing row 25 of 83. NM-03078, avg rows per second: 0.10
2025-09-11 22:25:21,219 [INFO ] Processing row 50 of 83. NM-03078, avg rows per second: 0.18
2025-09-11 22:25:51,897 [INFO ] Processing row 75 of 83. NM-03078, avg rows per second: 0.24
2025-09-11 22:26:03,312 [INFO ] Processing PointID: ('NM-03186',)
2025-09-11 22:26:32,795 [INFO ] Processing row 25 of 36. NM-03186, avg rows per second: 0.07
2025-09-11 22:26:47,790 [INFO ] Processing PointID: ('NM-03744',)
2025-09-11 22:26:51,982 [INFO ] Processing PointID: ('NM-04094',)
2025-09-11 22:27:17,770 [INFO ] Processing PointID: ('NM-04265',)
2025-09-11 22:27:19,517 [INFO ] Processing PointID: ('NM-04859',)
2025-09-11 22:27:48,999 [INFO ] Processing row 25 of 40. NM-04859, avg rows per second: 0.06
2025-09-11 22:28:08,841 [INFO ] Processing PointID: ('NM-04897',)
2025-09-11 22:28:10,587 [INFO ] Processing PointID: ('NM-05445',)
2025-09-11 22:28:29,225 [INFO ] Processing PointID: ('NM-05451',)
2025-09-11 22:28:30,981 [INFO ] Processing PointID: ('NM-05494',)
2025-09-11 22:29:00,383 [INFO ] Processing row 25 of 28. NM-05494, avg rows per second: 0.05
2025-09-11 22:29:05,714 [INFO ] Processing PointID: ('NM-06378',)
2025-09-11 22:29:09,856 [INFO ] Processing PointID: ('NM-07101',)
2025-09-11 22:29:40,555 [INFO ] Processing PointID: ('NM-07171',)
2025-09-11 22:29:48,348 [INFO ] Processing PointID: ('NM-07286',)
2025-09-11 22:29:53,715 [INFO ] Processing PointID: ('NM-07733',)
2025-09-11 22:30:00,273 [INFO ] Processing PointID: ('NM-08407',)
2025-09-11 22:30:02,044 [INFO ] Processing PointID: ('NM-08520',)
2025-09-11 22:30:08,609 [INFO ] Processing PointID: ('NM-09388',)
2025-09-11 22:30:18,804 [INFO ] Processing PointID: ('NM-09918',)
2025-09-11 22:30:49,442 [INFO ] Processing PointID: ('NM-10516',)
2025-09-11 22:30:51,174 [INFO ] Processing PointID: ('NM-10905',)
2025-09-11 22:30:56,504 [INFO ] Processing PointID: ('NM-11224',)
2025-09-11 22:31:06,692 [INFO ] Processing PointID: ('NM-11649',)
2025-09-11 22:31:36,107 [INFO ] Processing row 25 of 41. NM-11649, avg rows per second: 0.04
2025-09-11 22:31:57,042 [INFO ] Processing PointID: ('NM-12061',)
2025-09-11 22:32:07,180 [INFO ] Processing PointID: ('NM-12301',)
2025-09-11 22:32:08,974 [INFO ] Processing PointID: ('NM-12464',)
2025-09-11 22:32:17,956 [INFO ] Processing PointID: ('NM-12467',)
2025-09-11 22:32:24,554 [INFO ] Processing PointID: ('NM-12619',)
2025-09-11 22:32:29,932 [INFO ] Processing PointID: ('NM-12948',)
2025-09-11 22:32:59,310 [INFO ] Processing PointID: ('NM-12999',)
2025-09-11 22:33:05,861 [INFO ] Processing PointID: ('NM-13614',)
2025-09-11 22:33:13,638 [INFO ] Processing PointID: ('NM-13808',)
2025-09-11 22:33:15,674 [INFO ] Processing PointID: ('NM-14015',)
2025-09-11 22:33:24,663 [INFO ] Processing PointID: ('NM-14316',)
2025-09-11 22:33:54,036 [INFO ] Processing row 25 of 42. NM-14316, avg rows per second: 0.03
2025-09-11 22:34:16,256 [INFO ] Processing PointID: ('NM-14570',)
2025-09-11 22:34:17,995 [INFO ] Processing PointID: ('NM-14724',)
2025-09-11 22:34:19,786 [INFO ] Processing PointID: ('NM-14754',)
2025-09-11 22:34:33,938 [INFO ] Processing PointID: ('NM-14823',)
2025-09-11 22:34:35,669 [INFO ] Processing PointID: ('NM-15060',)
2025-09-11 22:34:37,403 [INFO ] Processing PointID: ('NM-15282',)
2025-09-11 22:34:46,371 [INFO ] Processing PointID: ('NM-15515',)
2025-09-11 22:34:58,901 [INFO ] Processing PointID: ('NM-15818',)
2025-09-11 22:35:00,642 [INFO ] Processing PointID: ('NM-16031',)
2025-09-11 22:35:02,383 [INFO ] Processing PointID: ('NM-16509',)
2025-09-11 22:35:15,200 [INFO ] Processing PointID: ('NM-18139',)
2025-09-11 22:35:18,156 [INFO ] Processing PointID: ('NM-18288',)
2025-09-11 22:35:36,662 [INFO ] Processing PointID: ('NM-18772',)
2025-09-11 22:35:38,428 [INFO ] Processing PointID: ('NM-19178',)
2025-09-11 22:35:42,549 [INFO ] Processing PointID: ('NM-19371',)
2025-09-11 22:35:45,936 [INFO ] Processing PointID: ('NM-19826',)
2025-09-11 22:35:52,495 [INFO ] Processing PointID: ('NM-19941',)
2025-09-11 22:35:55,445 [INFO ] Processing PointID: ('NM-20879',)
2025-09-11 22:35:57,178 [INFO ] Processing PointID: ('NM-21254',)
2025-09-11 22:36:20,489 [INFO ] Processing PointID: ('NM-21348',)
2025-09-11 22:36:22,230 [INFO ] Processing PointID: ('NM-21466',)
2025-09-11 22:36:24,001 [INFO ] Processing PointID: ('NM-21486',)
2025-09-11 22:36:25,746 [INFO ] Processing PointID: ('NM-21884',)
2025-09-11 22:36:27,500 [INFO ] Processing PointID: ('NM-21920',)
2025-09-11 22:36:36,495 [WARNING ] Skipping row 31231 due to missing data.
2025-09-11 22:36:55,691 [INFO ] Processing row 25 of 115. NM-21920, avg rows per second: 0.03
2025-09-11 22:37:26,222 [INFO ] Processing row 50 of 115. NM-21920, avg rows per second: 0.05
2025-09-11 22:37:56,749 [INFO ] Processing row 75 of 115. NM-21920, avg rows per second: 0.07
2025-09-11 22:38:27,344 [INFO ] Processing row 100 of 115. NM-21920, avg rows per second: 0.09
2025-09-11 22:38:47,505 [INFO ] Processing PointID: ('NM-21975',)
2025-09-11 22:38:49,297 [INFO ] Processing PointID: ('NM-22372',)
2025-09-11 22:38:52,264 [INFO ] Processing PointID: ('NM-22572',)
2025-09-11 22:38:54,018 [INFO ] Processing PointID: ('NM-23206',)
2025-09-11 22:39:06,591 [INFO ] Processing PointID: ('NM-23265',)
2025-09-11 22:39:08,707 [INFO ] Processing PointID: ('NM-25835',)
2025-09-11 22:39:11,915 [INFO ] Processing PointID: ('NM-26136',)
2025-09-11 22:39:13,649 [INFO ] Processing PointID: ('NM-27856',)
2025-09-11 22:39:19,037 [INFO ] Processing PointID: ('QU-047',)
2025-09-11 22:39:24,407 [INFO ] Processing PointID: ('QY-0083',)
2025-09-11 22:39:27,330 [INFO ] Processing PointID: ('QY-0181',)
2025-09-11 22:39:30,299 [INFO ] Processing PointID: ('QY-0274',)
2025-09-11 22:39:30,306 [WARNING ] Skipping row 8039 due to missing data.
2025-09-11 22:39:30,306 [INFO ] Processing PointID: ('QY-0940',)
2025-09-11 22:39:32,042 [INFO ] Processing PointID: ('SD-0035',)
2025-09-11 22:39:33,797 [INFO ] Processing PointID: ('TB-0123',)
2025-09-11 22:39:33,798 [WARNING ] Skipping row 49209 due to missing data.
2025-09-11 22:39:33,799 [INFO ] Processing PointID: ('TB-0161',)
2025-09-11 22:39:39,199 [INFO ] Processing PointID: ('TO-0365',)
2025-09-11 22:39:40,977 [INFO ] Processing PointID: ('UC-0100',)
2025-09-11 22:40:04,225 [INFO ]
2025-09-11 22:40:04,225 [INFO ] ********** TRANSFERRING LINK IDS **********
2025-09-11 22:40:07,482 [INFO ] Processing PointID: NM-15515, Thing ID: 89, a=nan, b=nan
2025-09-11 22:40:07,483 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x16f0efe00>
2025-09-11 22:40:08,281 [INFO ] Processing PointID: QU-047, Thing ID: 1, a=nan, b=nan
2025-09-11 22:40:08,281 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3029d7d90>
2025-09-11 22:40:09,085 [INFO ] Processing PointID: QY-0940, Thing ID: 84, a=9.28.23.212, b=nan
2025-09-11 22:40:09,085 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3029d7d90>
2025-09-11 22:40:09,900 [INFO ] Processing PointID: NM-18288, Thing ID: 44, a=nan, b=nan
2025-09-11 22:40:09,900 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x16f1622c0>
2025-09-11 22:40:10,687 [INFO ] Processing PointID: NM-08520, Thing ID: 72, a=nan, b=nan
2025-09-11 22:40:10,687 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x16f1622c0>
2025-09-11 22:40:11,479 [INFO ] Processing PointID: NM-19941, Thing ID: 73, a=nan, b=nan
2025-09-11 22:40:11,479 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x302cb1a30>
2025-09-11 22:40:12,275 [INFO ] Processing PointID: TO-0365, Thing ID: 90, a=8N9E7.211, b=nan
2025-09-11 22:40:12,275 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x300d2bf00>
2025-09-11 22:40:13,068 [INFO ] Processing PointID: NM-03078, Thing ID: 66, a=S226, b=nan
2025-09-11 22:40:13,069 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x300d2bf00>
2025-09-11 22:40:13,866 [INFO ] Processing PointID: NM-23265, Thing ID: 96, a=nan, b=nan
2025-09-11 22:40:13,866 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x16f16e750>
2025-09-11 22:40:14,684 [INFO ] Processing PointID: NM-14754, Thing ID: 11, a=nan, b=nan
2025-09-11 22:40:14,684 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x16f16ef50>
2025-09-11 22:40:15,474 [INFO ] Processing PointID: NM-12061, Thing ID: 9, a=nan, b=nan
2025-09-11 22:40:15,474 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x303189e50>
2025-09-11 22:40:16,268 [INFO ] Processing PointID: NM-21884, Thing ID: 74, a=nan, b=nan
2025-09-11 22:40:16,268 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x303189e50>
2025-09-11 22:40:17,059 [INFO ] Processing PointID: NM-00900, Thing ID: 75, a=nan, b=nan
2025-09-11 22:40:17,059 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x12fe1b850>
2025-09-11 22:40:17,853 [INFO ] Processing PointID: NM-23206, Thing ID: 94, a=nan, b=nan
2025-09-11 22:40:17,853 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x12fe1b850>
2025-09-11 22:40:18,641 [INFO ] Processing PointID: NM-05494, Thing ID: 15, a=nan, b=nan
2025-09-11 22:40:18,641 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x302ef1bf0>
2025-09-11 22:40:19,444 [INFO ] Processing PointID: NM-06378, Thing ID: 63, a=nan, b=nan
2025-09-11 22:40:19,444 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x303179190>
2025-09-11 22:40:20,253 [INFO ] Processing PointID: TB-0161, Thing ID: 36, a=nan, b=nan
2025-09-11 22:40:20,253 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x303178050>
2025-09-11 22:40:21,040 [INFO ] Processing PointID: NM-02181, Thing ID: 39, a=nan, b=nan
2025-09-11 22:40:21,041 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x300d5dbd0>
2025-09-11 22:40:21,830 [INFO ] Processing PointID: NM-14316, Thing ID: 7, a=nan, b=nan
2025-09-11 22:40:21,830 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x300d5db20>
2025-09-11 22:40:22,623 [INFO ] Processing PointID: NM-21975, Thing ID: 26, a=nan, b=nan
2025-09-11 22:40:22,623 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:23,415 [INFO ] Processing PointID: NM-12301, Thing ID: 86, a=nan, b=nan
2025-09-11 22:40:23,415 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:24,226 [INFO ] Processing PointID: AB-0132, Thing ID: 43, a=S167, b=nan
2025-09-11 22:40:24,227 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:25,040 [INFO ] Processing PointID: NM-00761, Thing ID: 92, a=nan, b=nan
2025-09-11 22:40:25,040 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:25,831 [INFO ] Processing PointID: NM-12619, Thing ID: 37, a=nan, b=nan
2025-09-11 22:40:25,831 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:26,619 [INFO ] Processing PointID: NM-13808, Thing ID: 91, a=nan, b=nan
2025-09-11 22:40:26,619 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:27,410 [INFO ] Processing PointID: DE-0219, Thing ID: 10, a=nan, b=nan
2025-09-11 22:40:27,410 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:28,209 [INFO ] Processing PointID: NM-04897, Thing ID: 62, a=nan, b=nan
2025-09-11 22:40:28,210 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:29,005 [INFO ] Processing PointID: NM-22572, Thing ID: 8, a=nan, b=nan
2025-09-11 22:40:29,005 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:29,822 [INFO ] Processing PointID: NM-10905, Thing ID: 47, a=nan, b=nan
2025-09-11 22:40:29,823 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:30,612 [INFO ] Processing PointID: NM-11649, Thing ID: 38, a=nan, b=nan
2025-09-11 22:40:30,612 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:31,402 [INFO ] Processing PointID: NM-15060, Thing ID: 99, a=nan, b=nan
2025-09-11 22:40:31,403 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:32,191 [INFO ] Processing PointID: NM-12948, Thing ID: 40, a=nan, b=nan
2025-09-11 22:40:32,191 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:32,979 [INFO ] Processing PointID: NM-04265, Thing ID: 95, a=nan, b=nan
2025-09-11 22:40:32,979 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:33,767 [INFO ] Processing PointID: NM-19371, Thing ID: 28, a=nan, b=nan
2025-09-11 22:40:33,767 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:34,580 [INFO ] Processing PointID: NM-00797, Thing ID: 50, a=nan, b=nan
2025-09-11 22:40:34,580 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:35,400 [INFO ] Processing PointID: NM-04094, Thing ID: 52, a=nan, b=nan
2025-09-11 22:40:35,400 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:36,188 [INFO ] Processing PointID: BW-0713, Thing ID: 80, a=4.9.23.20.140, b=nan
2025-09-11 22:40:36,188 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:36,976 [INFO ] Processing PointID: EB-057, Thing ID: 31, a=nan, b=nan
2025-09-11 22:40:36,976 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:37,764 [INFO ] Processing PointID: NM-14015, Thing ID: 58, a=nan, b=nan
2025-09-11 22:40:37,764 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:38,551 [INFO ] Processing PointID: NM-07171, Thing ID: 54, a=nan, b=nan
2025-09-11 22:40:38,551 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:39,362 [INFO ] Processing PointID: NM-26800, Thing ID: 79, a=nan, b=nan
2025-09-11 22:40:39,363 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:40,183 [INFO ] Processing PointID: NM-19178, Thing ID: 16, a=nan, b=nan
2025-09-11 22:40:40,183 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:40,970 [INFO ] Processing PointID: NM-00902, Thing ID: 64, a=nan, b=nan
2025-09-11 22:40:40,970 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:41,760 [INFO ] Processing PointID: NM-07286, Thing ID: 82, a=nan, b=nan
2025-09-11 22:40:41,761 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:42,552 [INFO ] Processing PointID: BW-0131, Thing ID: 21, a=11S9E22.441, b=nan
2025-09-11 22:40:42,552 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:43,345 [INFO ] Processing PointID: QY-0083, Thing ID: 81, a=10.32.17.313, b=nan
2025-09-11 22:40:43,346 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:44,144 [INFO ] Processing PointID: NM-05451, Thing ID: 78, a=nan, b=nan
2025-09-11 22:40:44,145 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:44,962 [INFO ] Processing PointID: SD-0035, Thing ID: 57, a=7N.7E.17.411, b=nan
2025-09-11 22:40:44,963 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:45,750 [INFO ] Processing PointID: NM-18139, Thing ID: 14, a=nan, b=nan
2025-09-11 22:40:45,750 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:46,539 [INFO ] Processing PointID: DE-0274, Thing ID: 85, a=nan, b=nan
2025-09-11 22:40:46,539 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:47,326 [INFO ] Processing PointID: EB-663, Thing ID: 35, a=nan, b=nan
2025-09-11 22:40:47,326 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:48,115 [INFO ] Processing PointID: NM-02887, Thing ID: 76, a=nan, b=nan
2025-09-11 22:40:48,115 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:48,902 [INFO ] Processing PointID: NM-00430, Thing ID: 65, a=nan, b=nan
2025-09-11 22:40:48,903 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:49,746 [INFO ] Processing PointID: NM-07101, Thing ID: 34, a=nan, b=nan
2025-09-11 22:40:49,746 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:50,535 [INFO ] Processing PointID: NM-12467, Thing ID: 4, a=nan, b=nan
2025-09-11 22:40:50,536 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:51,322 [INFO ] Processing PointID: NM-19826, Thing ID: 22, a=nan, b=nan
2025-09-11 22:40:51,323 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:52,111 [INFO ] Processing PointID: NM-09918, Thing ID: 77, a=nan, b=nan
2025-09-11 22:40:52,111 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:52,904 [INFO ] Processing PointID: TB-0123, Thing ID: 93, a=nan, b=nan
2025-09-11 22:40:52,904 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:53,694 [INFO ] Processing PointID: NM-22372, Thing ID: 25, a=nan, b=nan
2025-09-11 22:40:53,694 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:54,499 [INFO ] Processing PointID: TO-0225, Thing ID: 17, a=6N8E11.42, b=nan
2025-09-11 22:40:54,500 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:55,324 [INFO ] Processing PointID: NM-21920, Thing ID: 19, a=nan, b=nan
2025-09-11 22:40:55,324 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:56,111 [INFO ] Processing PointID: PP-040, Thing ID: 51, a=PW-45, b=nan
2025-09-11 22:40:56,111 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:56,904 [INFO ] Processing PointID: NM-11224, Thing ID: 32, a=nan, b=nan
2025-09-11 22:40:56,904 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:57,690 [INFO ] Processing PointID: UC-0100, Thing ID: 24, a=nan, b=nan
2025-09-11 22:40:57,690 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:58,485 [INFO ] Processing PointID: NM-15818, Thing ID: 29, a=nan, b=nan
2025-09-11 22:40:58,486 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:40:59,285 [INFO ] Processing PointID: QY-0274, Thing ID: 20, a=11.31.19.333, b=nan
2025-09-11 22:40:59,285 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:00,100 [INFO ] Processing PointID: NM-12999, Thing ID: 56, a=nan, b=nan
2025-09-11 22:41:00,101 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:00,890 [INFO ] Processing PointID: NM-07733, Thing ID: 67, a=nan, b=nan
2025-09-11 22:41:00,890 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:01,682 [INFO ] Processing PointID: NM-12464, Thing ID: 18, a=nan, b=nan
2025-09-11 22:41:01,682 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:02,470 [INFO ] Processing PointID: NM-21254, Thing ID: 3, a=nan, b=nan
2025-09-11 22:41:02,471 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:03,268 [INFO ] Processing PointID: PC-037, Thing ID: 41, a=PW-060, b=nan
2025-09-11 22:41:03,268 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:04,069 [INFO ] Processing PointID: NM-03744, Thing ID: 2, a=nan, b=nan
2025-09-11 22:41:04,070 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:04,884 [INFO ] Processing PointID: NM-02969, Thing ID: 49, a=nan, b=nan
2025-09-11 22:41:04,884 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:05,674 [INFO ] Processing PointID: NM-14570, Thing ID: 45, a=nan, b=nan
2025-09-11 22:41:05,674 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:06,463 [INFO ] Processing PointID: NM-02743, Thing ID: 71, a=nan, b=nan
2025-09-11 22:41:06,463 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:07,251 [INFO ] Processing PointID: NM-21466, Thing ID: 60, a=nan, b=nan
2025-09-11 22:41:07,252 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:08,408 [INFO ] Processing PointID: NM-13614, Thing ID: 48, a=nan, b=nan
2025-09-11 22:41:08,408 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:09,202 [INFO ] Processing PointID: NM-27856, Thing ID: 46, a=nan, b=nan
2025-09-11 22:41:09,203 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:10,053 [INFO ] Processing PointID: NM-26878, Thing ID: 13, a=nan, b=nan
2025-09-11 22:41:10,054 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:10,847 [INFO ] Processing PointID: NM-26136, Thing ID: 59, a=nan, b=nan
2025-09-11 22:41:10,847 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:11,642 [INFO ] Processing PointID: NM-15282, Thing ID: 70, a=nan, b=nan
2025-09-11 22:41:11,642 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:12,441 [INFO ] Processing PointID: NM-18772, Thing ID: 5, a=nan, b=nan
2025-09-11 22:41:12,441 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:13,234 [INFO ] Processing PointID: NM-16031, Thing ID: 69, a=nan, b=nan
2025-09-11 22:41:13,234 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:14,026 [INFO ] Processing PointID: NM-10516, Thing ID: 42, a=nan, b=nan
2025-09-11 22:41:14,026 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:14,849 [INFO ] Processing PointID: NM-05445, Thing ID: 12, a=nan, b=nan
2025-09-11 22:41:14,849 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:15,637 [INFO ] Processing PointID: NM-21348, Thing ID: 88, a=nan, b=nan
2025-09-11 22:41:15,637 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:16,431 [INFO ] Processing PointID: NM-16509, Thing ID: 97, a=nan, b=nan
2025-09-11 22:41:16,431 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:17,223 [INFO ] Processing PointID: DA-0141, Thing ID: 55, a=26S4E19.13, b=nan
2025-09-11 22:41:17,223 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:18,017 [INFO ] Processing PointID: NM-02255, Thing ID: 33, a=nan, b=nan
2025-09-11 22:41:18,017 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:18,806 [INFO ] Processing PointID: NM-14724, Thing ID: 23, a=nan, b=nan
2025-09-11 22:41:18,807 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:19,604 [INFO ] Processing PointID: NM-08407, Thing ID: 61, a=nan, b=nan
2025-09-11 22:41:19,604 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:20,420 [INFO ] Processing PointID: DA-0050, Thing ID: 68, a=22S1E24.222, b=nan
2025-09-11 22:41:20,420 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:21,213 [INFO ] Processing PointID: NM-20879, Thing ID: 53, a=nan, b=nan
2025-09-11 22:41:21,213 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:22,003 [INFO ] Processing PointID: NM-03186, Thing ID: 83, a=nan, b=nan
2025-09-11 22:41:22,004 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:22,796 [INFO ] Processing PointID: NM-04859, Thing ID: 100, a=nan, b=nan
2025-09-11 22:41:22,797 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:23,588 [INFO ] Processing PointID: NM-25835, Thing ID: 27, a=nan, b=nan
2025-09-11 22:41:23,588 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:24,382 [INFO ] Processing PointID: NM-21486, Thing ID: 87, a=nan, b=nan
2025-09-11 22:41:24,383 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:25,200 [INFO ] Processing PointID: QY-0181, Thing ID: 30, a=11.30.14.143b, b=nan
2025-09-11 22:41:25,200 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:25,990 [INFO ] Processing PointID: NM-14823, Thing ID: 98, a=nan, b=nan
2025-09-11 22:41:25,990 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:26,784 [INFO ] Processing PointID: NM-09388, Thing ID: 6, a=nan, b=nan
2025-09-11 22:41:26,784 [INFO ] adding link id: <db.thing.ThingIdLink object at 0x3031b4690>
2025-09-11 22:41:29,854 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 0
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 1
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 2
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 3
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 4
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 5
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 6
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 7
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 8
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 9
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 10
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 11
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 12
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 13
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 14
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 15
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 16
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 17
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 18
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 19
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 20
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 21
2025-09-11 22:41:29,855 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 22
2025-09-11 22:41:30,094 [WARNING ] OSEPOD is "X", "?", or "exempt", id=X for row 23
2025-09-11 22:41:30,094 [WARNING ] OSEWellTagID is null for row 23
2025-09-11 22:41:30,349 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 24
2025-09-11 22:41:30,349 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 25
2025-09-11 22:41:30,349 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 26
2025-09-11 22:41:30,349 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 27
2025-09-11 22:41:30,349 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 28
2025-09-11 22:41:30,349 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 29
2025-09-11 22:41:30,664 [WARNING ] OSEWellTagID is null for row 30
2025-09-11 22:41:31,139 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 31
2025-09-11 22:41:31,140 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 32
2025-09-11 22:41:31,140 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 33
2025-09-11 22:41:31,461 [WARNING ] OSEWellTagID is null for row 34
2025-09-11 22:41:32,248 [WARNING ] OSEWellTagID is null for row 35
2025-09-11 22:41:32,723 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 36
2025-09-11 22:41:32,723 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 37
2025-09-11 22:41:32,723 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 38
2025-09-11 22:41:32,723 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 39
2025-09-11 22:41:33,045 [WARNING ] OSEPOD is "X", "?", or "exempt", id=X for row 40
2025-09-11 22:41:33,045 [WARNING ] OSEWellTagID is null for row 40
2025-09-11 22:41:33,283 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 41
2025-09-11 22:41:33,283 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 42
2025-09-11 22:41:33,283 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 43
2025-09-11 22:41:33,283 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 44
2025-09-11 22:41:33,283 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 45
2025-09-11 22:41:33,283 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 46
2025-09-11 22:41:33,283 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 47
2025-09-11 22:41:33,283 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 48
2025-09-11 22:41:33,283 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 49
2025-09-11 22:41:33,601 [WARNING ] OSEWellTagID is null for row 50
2025-09-11 22:41:34,076 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 51
2025-09-11 22:41:34,076 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 52
2025-09-11 22:41:34,076 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 53
2025-09-11 22:41:34,076 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 54
2025-09-11 22:41:34,076 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 55
2025-09-11 22:41:34,420 [WARNING ] OSEPOD is "X", "?", or "exempt", id=X for row 56
2025-09-11 22:41:34,420 [WARNING ] OSEWellTagID is null for row 56
2025-09-11 22:41:34,657 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 57
2025-09-11 22:41:34,657 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 58
2025-09-11 22:41:34,657 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 59
2025-09-11 22:41:34,657 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 60
2025-09-11 22:41:34,657 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 61
2025-09-11 22:41:34,657 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 62
2025-09-11 22:41:34,657 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 63
2025-09-11 22:41:34,657 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 64
2025-09-11 22:41:34,657 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 65
2025-09-11 22:41:34,657 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 66
2025-09-11 22:41:34,657 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 67
2025-09-11 22:41:34,657 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 68
2025-09-11 22:41:34,657 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 69
2025-09-11 22:41:35,007 [WARNING ] OSEWellTagID is null for row 70
2025-09-11 22:41:35,484 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 71
2025-09-11 22:41:35,484 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 72
2025-09-11 22:41:35,484 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 73
2025-09-11 22:41:35,484 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 74
2025-09-11 22:41:35,484 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 75
2025-09-11 22:41:35,484 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 76
2025-09-11 22:41:35,801 [WARNING ] OSEPOD id does not match regex ^[A-Z]{1,2}-\d{5,6}, id=LRG-08447 for row 77
2025-09-11 22:41:35,801 [WARNING ] OSEWellTagID is null for row 77
2025-09-11 22:41:36,039 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 78
2025-09-11 22:41:36,039 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 79
2025-09-11 22:41:36,039 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 80
2025-09-11 22:41:36,039 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 81
2025-09-11 22:41:36,039 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 82
2025-09-11 22:41:36,039 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 83
2025-09-11 22:41:36,039 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 84
2025-09-11 22:41:36,039 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 85
2025-09-11 22:41:36,039 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 86
2025-09-11 22:41:36,039 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 87
2025-09-11 22:41:36,039 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 88
2025-09-11 22:41:36,039 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 89
2025-09-11 22:41:36,039 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 90
2025-09-11 22:41:36,039 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 91
2025-09-11 22:41:36,358 [WARNING ] OSEPOD is "X", "?", or "exempt", id=X for row 92
2025-09-11 22:41:36,358 [WARNING ] OSEWellTagID is null for row 92
2025-09-11 22:41:36,596 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 93
2025-09-11 22:41:36,597 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 94
2025-09-11 22:41:36,597 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 95
2025-09-11 22:41:36,597 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 96
2025-09-11 22:41:36,597 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 97
2025-09-11 22:41:36,597 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 98
2025-09-11 22:41:36,597 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 99
2025-09-11 22:41:36,913 [WARNING ] OSEWellTagID is null for row 100
2025-09-11 22:41:37,387 [INFO ]
2025-09-11 22:41:37,387 [INFO ] ********** TRANSFERRING GROUPS **********
2025-09-11 22:41:38,562 [INFO ] Adding 14 things to group Questa Red River, prefix QU
2025-09-11 22:41:38,800 [INFO ] Adding 9 things to group Questa Red River, prefix TC
2025-09-11 22:41:39,043 [INFO ] Adding 22 things to group Questa Red River, prefix TS
2025-09-11 22:41:45,349 [INFO ] Adding 4 things to group S.Taos Valley, prefix TV
2025-09-11 22:41:45,590 [INFO ] Adding 22 things to group S.Taos Valley, prefix TS
2025-09-11 22:41:52,107 [INFO ] Adding 18 things to group La Cienega, prefix EB
2025-09-11 22:41:57,437 [INFO ] Adding 17 things to group San Agustin Plains Alamosa Creek, prefix SA
2025-09-11 22:42:02,539 [INFO ] Adding 84 things to group Sacramento Mtns, prefix SM
2025-09-11 22:42:23,645 [INFO ] Adding 18 things to group Espanola Basin, prefix EB
2025-09-11 22:42:29,003 [INFO ] Adding 23 things to group Tularosa Basin, prefix TB
2025-09-11 22:42:29,243 [INFO ] Adding 84 things to group Tularosa Basin, prefix SM
2025-09-11 22:42:50,351 [INFO ] Adding 84 things to group SM Watershed, prefix SM
2025-09-11 22:43:11,473 [INFO ] Adding 1 things to group Union County, prefix UC
2025-09-11 22:43:12,735 [INFO ] Adding 2 things to group White Sands, prefix WS
2025-09-11 22:43:14,235 [INFO ] Adding 1 things to group Jornada Del Muerto, prefix JM
2025-09-11 22:43:17,602 [INFO ] Adding 6 things to group Truth or Consequences, prefix HS
2025-09-11 22:43:20,078 [INFO ] Adding 3 things to group Geothermal, prefix GT
2025-09-11 22:43:23,906 [INFO ] Adding 9 things to group Taos Plateau, prefix TC
2025-09-11 22:43:24,144 [INFO ] Adding 22 things to group Taos Plateau, prefix TS
2025-09-11 22:43:30,473 [INFO ] Adding 97 things to group New Mexico, prefix NM
2025-09-11 22:43:54,907 [INFO ] Adding 2 things to group Tiffany Fire Restoration, prefix SO
2025-09-11 22:43:58,499 [INFO ] Adding 11 things to group El Morro, prefix EM
2025-09-11 22:44:02,164 [INFO ] Adding 6 things to group Statewide Recharge, prefix SR
2025-09-11 22:44:04,609 [INFO ] Adding 2 things to group San Miguel County, prefix MI
2025-09-11 22:44:06,142 [INFO ] Adding 2 things to group Socorro, prefix SO
2025-09-11 22:44:07,635 [INFO ] Adding 15 things to group Animas River, prefix AR
2025-09-11 22:44:12,271 [INFO ] Adding 8 things to group Quay County, prefix QY
2025-09-11 22:44:15,206 [INFO ] Adding 6 things to group Sandia and N. Manzano Mtns., prefix SD
2025-09-11 22:44:17,690 [INFO ] Adding 10 things to group Brackish Water, prefix BW
2025-09-11 22:44:21,137 [INFO ] Adding 2 things to group Dona Ana County, prefix DA
2025-09-11 22:44:22,631 [INFO ] Adding 23 things to group Eastern Tularosa Basin, prefix TB
2025-09-11 22:44:29,144 [INFO ] Adding 2 things to group Colfax County, prefix CX
2025-09-11 22:44:30,658 [INFO ] Adding 1 things to group Eddy County, prefix ED
2025-09-11 22:44:31,950 [INFO ] Adding 3 things to group Torrance County, prefix TO
2025-09-11 22:44:35,765 [INFO ] Adding 22 things to group Taos Gorge Springs, prefix TS
2025-09-11 22:44:44,077 [INFO ] Adding 16 things to group Placitas, prefix PC
2025-09-11 22:44:48,926 [INFO ] Adding 8 things to group Picuris Pueblo, prefix PP
2025-09-11 22:44:51,888 [INFO ] Adding 9 things to group Sunshine Valley, prefix TC
2025-09-11 22:44:57,141 [INFO ] Adding 2 things to group Albuquerque Basin, prefix AB
2025-09-11 22:44:58,871 [INFO ] Adding 2 things to group Tiffany Fire Recovery, prefix SO
2025-09-11 22:45:00,405 [INFO ] Adding 1 things to group Salt Basin, prefix SB
2025-09-11 22:45:01,702 [INFO ] Adding 4 things to group Mimbres Basin, prefix MB
2025-09-11 22:45:03,681 [INFO ] Adding 2 things to group MRGCD, prefix SO
2025-09-11 22:45:05,184 [INFO ] Adding 2 things to group Delaware Basin, prefix DE
2025-09-11 22:45:06,713 [INFO ] Adding 2 things to group ABCWUA, prefix AB
2025-09-11 22:45:07,186 [INFO ] Adding 97 things to group ABCWUA, prefix NM

[jirhiker]

Laptop, local dockerized postgres

2025-09-15 09:08:52,772 [INFO    ] Starting transfer
2025-09-15 09:08:52,772 [INFO    ] Erasing existing data and initializing lexicon and sensors
2025-09-15 09:08:52,772 [INFO    ] Erasing existing data
2025-09-15 09:08:53,056 [INFO    ] Recreating tables
2025-09-15 09:08:53,265 [INFO    ] erase took 0.492794 seconds
2025-09-15 09:08:53,265 [INFO    ] Initializing lexicon
2025-09-15 09:08:56,469 [INFO    ] lexicon took 3.204375 seconds
2025-09-15 09:08:56,469 [INFO    ] Initializing sensors
2025-09-15 09:08:56,473 [INFO    ] sensor took 0.004229 seconds
2025-09-15 09:08:56,473 [INFO    ] 
2025-09-15 09:08:56,473 [INFO    ] ********** TRANSFERRING WELLS **********
2025-09-15 09:09:01,438 [INFO    ] Processing row 25 of 100. NM-21975,  avg rows per second: 44.06
2025-09-15 09:09:01,905 [INFO    ] Processing row 50 of 100. PP-040,  avg rows per second: 48.30
2025-09-15 09:09:02,340 [INFO    ] Processing row 75 of 100. NM-02887,  avg rows per second: 51.04
2025-09-15 09:09:02,811 [INFO    ] transfer_wells took 6.337768 seconds
2025-09-15 09:09:03,838 [INFO    ] transfer_wellscreens took 1.027058 seconds
2025-09-15 09:09:03,838 [INFO    ] 
2025-09-15 09:09:03,838 [INFO    ] ********** TRANSFERRING SPRINGS **********
2025-09-15 09:09:06,634 [INFO    ] Processing row 25 of 855. TB-1029,  avg rows per second: 49.75
2025-09-15 09:09:07,511 [INFO    ] Processing row 50 of 855. TS-115,  avg rows per second: 36.26
2025-09-15 09:09:07,965 [INFO    ] Processing row 75 of 855. NM-28354,  avg rows per second: 40.91
2025-09-15 09:09:08,428 [WARNING ] Reached limit of 100 rows. Stopping migration.
2025-09-15 09:09:08,432 [INFO    ] transfer_springs took 4.593848 seconds
2025-09-15 09:09:08,432 [INFO    ] 
2025-09-15 09:09:08,432 [INFO    ] ********** TRANSFERRING PERENNIAL STREAMS **********
2025-09-15 09:09:11,226 [INFO    ] Processing row 25 of 176. AR-0527,  avg rows per second: 50.15
2025-09-15 09:09:11,691 [INFO    ] Processing row 50 of 176. SM-4071,  avg rows per second: 51.87
2025-09-15 09:09:12,155 [INFO    ] Processing row 75 of 176. SM-3024,  avg rows per second: 52.51
2025-09-15 09:09:12,621 [WARNING ] Reached limit of 100 rows. Stopping migration.
2025-09-15 09:09:12,625 [INFO    ] transfer_perennial_stream took 4.192987 seconds
2025-09-15 09:09:12,626 [INFO    ] 
2025-09-15 09:09:12,626 [INFO    ] ********** TRANSFERRING EPHEMERAL STREAMS **********
2025-09-15 09:09:15,381 [INFO    ] Processing row 25 of 38. NM-27181,  avg rows per second: 54.27
2025-09-15 09:09:15,649 [INFO    ] transfer_ephemeral_stream took 3.022977 seconds
2025-09-15 09:09:15,649 [INFO    ] 
2025-09-15 09:09:15,649 [INFO    ] ********** TRANSFERRING METEOROLOGICAL **********
2025-09-15 09:09:18,422 [INFO    ] Processing row 25 of 64. SM-5002,  avg rows per second: 47.07
2025-09-15 09:09:18,873 [INFO    ] Processing row 50 of 64. SM-2013,  avg rows per second: 50.90
2025-09-15 09:09:19,130 [INFO    ] transfer_met took 3.481498 seconds
2025-09-15 09:09:19,130 [INFO    ] 
2025-09-15 09:09:19,130 [INFO    ] ********** TRANSFERRING CONTACTS **********
2025-09-15 09:09:23,291 [INFO    ] Processing PointID: 221 EB-663
2025-09-15 09:09:23,291 [WARNING ] Skipping physical address for first contact Warren Thompson. Validation error: 1 validation error for CreateAddress
postal_code
  Input should be a valid string [type=string_type, input_value=None, input_type=NoneType]
    For further information visit https://errors.pydantic.dev/2.11/v/string_type
2025-09-15 09:09:23,322 [INFO    ] added first contact for PointID EB-663
2025-09-15 09:09:23,333 [INFO    ] added second contact for PointID EB-663
2025-09-15 09:09:23,336 [INFO    ] Processing PointID: 441 EB-057
2025-09-15 09:09:23,345 [INFO    ] added first contact for PointID EB-057
2025-09-15 09:09:23,345 [CRITICAL] Skipping second contact for PointID EB-057 due to validation error: 1 validation error for CreateContact
  Value error, Either name or organization must be provided. [type=value_error, input_value={'thing_id': 31, 'release...wners': 'Noonan, Mitch'}, input_type=dict]
    For further information visit https://errors.pydantic.dev/2.11/v/value_error
2025-09-15 09:09:23,350 [INFO    ] Processing PointID: 647 QU-047
2025-09-15 09:09:23,365 [INFO    ] added first contact for PointID QU-047
2025-09-15 09:09:23,366 [CRITICAL] Skipping second contact for PointID QU-047 due to validation error: 1 validation error for CreateContact
  Value error, Either name or organization must be provided. [type=value_error, input_value={'thing_id': 1, 'release_...ez, Andrew and Cecilia'}, input_type=dict]
    For further information visit https://errors.pydantic.dev/2.11/v/value_error
2025-09-15 09:09:23,368 [INFO    ] Processing PointID: 1040 TB-0123
2025-09-15 09:09:23,374 [INFO    ] added first contact for PointID TB-0123
2025-09-15 09:09:23,374 [CRITICAL] Skipping second contact for PointID TB-0123 due to validation error: 1 validation error for CreateContact
  Value error, Either name or organization must be provided. [type=value_error, input_value={'thing_id': 93, 'release...: 'Hemphill, Eddie Bob'}, input_type=dict]
    For further information visit https://errors.pydantic.dev/2.11/v/value_error
2025-09-15 09:09:23,377 [INFO    ] Processing PointID: 1670 TB-0161
2025-09-15 09:09:23,388 [INFO    ] added first contact for PointID TB-0161
2025-09-15 09:09:23,388 [CRITICAL] Skipping second contact for PointID TB-0161 due to validation error: 1 validation error for CreateContact
  Value error, Either name or organization must be provided. [type=value_error, input_value={'thing_id': 36, 'release... 'Gamble, Richard/Dori'}, input_type=dict]
    For further information visit https://errors.pydantic.dev/2.11/v/value_error
2025-09-15 09:09:23,395 [INFO    ] transfer_contacts took 4.265059 seconds
2025-09-15 09:09:23,395 [INFO    ] 
2025-09-15 09:09:23,396 [INFO    ] ********** TRANSFERRING WATER LEVELS **********
2025-09-15 09:09:29,490 [INFO    ] Processing PointID: ('AB-0132',)
2025-09-15 09:09:29,533 [INFO    ] Processing PointID: ('BW-0131',)
2025-09-15 09:09:29,549 [INFO    ] Processing PointID: ('DA-0050',)
2025-09-15 09:09:29,565 [INFO    ] Processing PointID: ('DA-0141',)
2025-09-15 09:09:29,580 [INFO    ] Processing PointID: ('DE-0219',)
2025-09-15 09:09:29,607 [INFO    ] Processing PointID: ('DE-0274',)
2025-09-15 09:09:29,791 [INFO    ] Processing PointID: ('EB-057',)
2025-09-15 09:09:29,808 [INFO    ] Processing PointID: ('EB-663',)
2025-09-15 09:09:29,846 [INFO    ] Processing PointID: ('NM-00430',)
2025-09-15 09:09:29,847 [WARNING ] Skipping row 42728 due to missing data.
2025-09-15 09:09:29,884 [WARNING ] Skipping row 271811 due to missing data.
2025-09-15 09:09:29,918 [INFO    ] Processing PointID: ('NM-00761',)
2025-09-15 09:09:30,194 [INFO    ] Processing row 25 of 54. NM-00761,  avg rows per second: 35.42
2025-09-15 09:09:30,449 [INFO    ] Processing row 50 of 54. NM-00761,  avg rows per second: 52.02
2025-09-15 09:09:30,516 [INFO    ] Processing PointID: ('NM-00797',)
2025-09-15 09:09:30,532 [INFO    ] Processing PointID: ('NM-00900',)
2025-09-15 09:09:30,558 [INFO    ] Processing PointID: ('NM-00902',)
2025-09-15 09:09:30,606 [INFO    ] Processing PointID: ('NM-02181',)
2025-09-15 09:09:30,885 [INFO    ] Processing row 25 of 30. NM-02181,  avg rows per second: 17.90
2025-09-15 09:09:30,955 [INFO    ] Processing PointID: ('NM-02255',)
2025-09-15 09:09:31,015 [INFO    ] Processing PointID: ('NM-02743',)
2025-09-15 09:09:31,031 [WARNING ] Skipping row 65285 due to missing data.
2025-09-15 09:09:31,268 [INFO    ] Processing row 25 of 33. NM-02743,  avg rows per second: 14.05
2025-09-15 09:09:31,369 [INFO    ] Processing PointID: ('NM-02887',)
2025-09-15 09:09:31,415 [INFO    ] Processing PointID: ('NM-02969',)
2025-09-15 09:09:31,483 [INFO    ] Processing PointID: ('NM-03078',)
2025-09-15 09:09:31,745 [INFO    ] Processing row 25 of 83. NM-03078,  avg rows per second: 11.08
2025-09-15 09:09:32,011 [INFO    ] Processing row 50 of 83. NM-03078,  avg rows per second: 19.82
2025-09-15 09:09:32,285 [INFO    ] Processing row 75 of 83. NM-03078,  avg rows per second: 26.82
2025-09-15 09:09:32,381 [INFO    ] Processing PointID: ('NM-03186',)
2025-09-15 09:09:32,645 [INFO    ] Processing row 25 of 36. NM-03186,  avg rows per second: 7.92
2025-09-15 09:09:32,780 [INFO    ] Processing PointID: ('NM-03744',)
2025-09-15 09:09:32,816 [INFO    ] Processing PointID: ('NM-04094',)
2025-09-15 09:09:33,046 [INFO    ] Processing PointID: ('NM-04265',)
2025-09-15 09:09:33,062 [INFO    ] Processing PointID: ('NM-04859',)
2025-09-15 09:09:33,322 [INFO    ] Processing row 25 of 40. NM-04859,  avg rows per second: 6.52
2025-09-15 09:09:33,493 [INFO    ] Processing PointID: ('NM-04897',)
2025-09-15 09:09:33,509 [INFO    ] Processing PointID: ('NM-05445',)
2025-09-15 09:09:33,680 [INFO    ] Processing PointID: ('NM-05451',)
2025-09-15 09:09:33,697 [INFO    ] Processing PointID: ('NM-05494',)
2025-09-15 09:09:33,953 [INFO    ] Processing row 25 of 28. NM-05494,  avg rows per second: 5.60
2025-09-15 09:09:34,001 [INFO    ] Processing PointID: ('NM-06378',)
2025-09-15 09:09:34,038 [INFO    ] Processing PointID: ('NM-07101',)
2025-09-15 09:09:34,349 [INFO    ] Processing PointID: ('NM-07171',)
2025-09-15 09:09:34,413 [INFO    ] Processing PointID: ('NM-07286',)
2025-09-15 09:09:34,458 [INFO    ] Processing PointID: ('NM-07733',)
2025-09-15 09:09:34,513 [INFO    ] Processing PointID: ('NM-08407',)
2025-09-15 09:09:34,528 [INFO    ] Processing PointID: ('NM-08520',)
2025-09-15 09:09:34,587 [INFO    ] Processing PointID: ('NM-09388',)
2025-09-15 09:09:34,676 [INFO    ] Processing PointID: ('NM-09918',)
2025-09-15 09:09:34,947 [INFO    ] Processing PointID: ('NM-10516',)
2025-09-15 09:09:34,962 [INFO    ] Processing PointID: ('NM-10905',)
2025-09-15 09:09:35,008 [INFO    ] Processing PointID: ('NM-11224',)
2025-09-15 09:09:35,095 [INFO    ] Processing PointID: ('NM-11649',)
2025-09-15 09:09:35,365 [INFO    ] Processing row 25 of 41. NM-11649,  avg rows per second: 4.25
2025-09-15 09:09:35,549 [INFO    ] Processing PointID: ('NM-12061',)
2025-09-15 09:09:35,642 [INFO    ] Processing PointID: ('NM-12301',)
2025-09-15 09:09:35,656 [INFO    ] Processing PointID: ('NM-12464',)
2025-09-15 09:09:35,733 [INFO    ] Processing PointID: ('NM-12467',)
2025-09-15 09:09:35,790 [INFO    ] Processing PointID: ('NM-12619',)
2025-09-15 09:09:35,837 [INFO    ] Processing PointID: ('NM-12948',)
2025-09-15 09:09:36,104 [INFO    ] Processing PointID: ('NM-12999',)
2025-09-15 09:09:36,163 [INFO    ] Processing PointID: ('NM-13614',)
2025-09-15 09:09:36,231 [INFO    ] Processing PointID: ('NM-13808',)
2025-09-15 09:09:36,247 [INFO    ] Processing PointID: ('NM-14015',)
2025-09-15 09:09:36,325 [INFO    ] Processing PointID: ('NM-14316',)
2025-09-15 09:09:36,592 [INFO    ] Processing row 25 of 42. NM-14316,  avg rows per second: 3.52
2025-09-15 09:09:36,791 [INFO    ] Processing PointID: ('NM-14570',)
2025-09-15 09:09:36,811 [INFO    ] Processing PointID: ('NM-14724',)
2025-09-15 09:09:36,828 [INFO    ] Processing PointID: ('NM-14754',)
2025-09-15 09:09:36,944 [INFO    ] Processing PointID: ('NM-14823',)
2025-09-15 09:09:36,959 [INFO    ] Processing PointID: ('NM-15060',)
2025-09-15 09:09:36,973 [INFO    ] Processing PointID: ('NM-15282',)
2025-09-15 09:09:37,059 [INFO    ] Processing PointID: ('NM-15515',)
2025-09-15 09:09:37,166 [INFO    ] Processing PointID: ('NM-15818',)
2025-09-15 09:09:37,180 [INFO    ] Processing PointID: ('NM-16031',)
2025-09-15 09:09:37,201 [INFO    ] Processing PointID: ('NM-16509',)
2025-09-15 09:09:37,311 [INFO    ] Processing PointID: ('NM-18139',)
2025-09-15 09:09:37,338 [INFO    ] Processing PointID: ('NM-18288',)
2025-09-15 09:09:37,503 [INFO    ] Processing PointID: ('NM-18772',)
2025-09-15 09:09:37,518 [INFO    ] Processing PointID: ('NM-19178',)
2025-09-15 09:09:37,556 [INFO    ] Processing PointID: ('NM-19371',)
2025-09-15 09:09:37,584 [INFO    ] Processing PointID: ('NM-19826',)
2025-09-15 09:09:37,640 [INFO    ] Processing PointID: ('NM-19941',)
2025-09-15 09:09:37,664 [INFO    ] Processing PointID: ('NM-20879',)
2025-09-15 09:09:37,676 [INFO    ] Processing PointID: ('NM-21254',)
2025-09-15 09:09:37,876 [INFO    ] Processing PointID: ('NM-21348',)
2025-09-15 09:09:37,889 [INFO    ] Processing PointID: ('NM-21466',)
2025-09-15 09:09:37,902 [INFO    ] Processing PointID: ('NM-21486',)
2025-09-15 09:09:37,916 [INFO    ] Processing PointID: ('NM-21884',)
2025-09-15 09:09:37,930 [INFO    ] Processing PointID: ('NM-21920',)
2025-09-15 09:09:38,006 [WARNING ] Skipping row 31231 due to missing data.
2025-09-15 09:09:38,185 [INFO    ] Processing row 25 of 115. NM-21920,  avg rows per second: 2.87
2025-09-15 09:09:38,451 [INFO    ] Processing row 50 of 115. NM-21920,  avg rows per second: 5.58
2025-09-15 09:09:38,734 [INFO    ] Processing row 75 of 115. NM-21920,  avg rows per second: 8.11
2025-09-15 09:09:39,013 [INFO    ] Processing row 100 of 115. NM-21920,  avg rows per second: 10.50
2025-09-15 09:09:39,186 [INFO    ] Processing PointID: ('NM-21975',)
2025-09-15 09:09:39,199 [INFO    ] Processing PointID: ('NM-22372',)
2025-09-15 09:09:39,225 [INFO    ] Processing PointID: ('NM-22572',)
2025-09-15 09:09:39,240 [INFO    ] Processing PointID: ('NM-23206',)
2025-09-15 09:09:39,353 [INFO    ] Processing PointID: ('NM-23265',)
2025-09-15 09:09:39,368 [INFO    ] Processing PointID: ('NM-25835',)
2025-09-15 09:09:39,393 [INFO    ] Processing PointID: ('NM-26136',)
2025-09-15 09:09:39,407 [INFO    ] Processing PointID: ('NM-27856',)
2025-09-15 09:09:39,457 [INFO    ] Processing PointID: ('QU-047',)
2025-09-15 09:09:39,511 [INFO    ] Processing PointID: ('QY-0083',)
2025-09-15 09:09:39,538 [INFO    ] Processing PointID: ('QY-0181',)
2025-09-15 09:09:39,572 [INFO    ] Processing PointID: ('QY-0274',)
2025-09-15 09:09:39,573 [WARNING ] Skipping row 8039 due to missing data.
2025-09-15 09:09:39,573 [INFO    ] Processing PointID: ('QY-0940',)
2025-09-15 09:09:39,586 [INFO    ] Processing PointID: ('SD-0035',)
2025-09-15 09:09:39,600 [INFO    ] Processing PointID: ('TB-0123',)
2025-09-15 09:09:39,600 [WARNING ] Skipping row 49209 due to missing data.
2025-09-15 09:09:39,600 [INFO    ] Processing PointID: ('TB-0161',)
2025-09-15 09:09:39,645 [INFO    ] Processing PointID: ('TO-0365',)
2025-09-15 09:09:39,659 [INFO    ] Processing PointID: ('UC-0100',)
2025-09-15 09:09:39,881 [INFO    ] transfer_water_levels took 16.485017 seconds
2025-09-15 09:09:39,881 [INFO    ] 
2025-09-15 09:09:39,881 [INFO    ] ********** TRANSFERRING LINK IDS **********
2025-09-15 09:09:42,279 [INFO    ] Processing PointID: NM-15515, Thing ID: 89, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,290 [INFO    ] Processing PointID: QU-047, Thing ID: 1, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,296 [INFO    ] Processing PointID: QY-0940, Thing ID: 84, AlternateSiteID=9.28.23.212, AlternateSiteID2=None
2025-09-15 09:09:42,296 [INFO    ] adding link id: QY-0940
2025-09-15 09:09:42,303 [INFO    ] Processing PointID: NM-18288, Thing ID: 44, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,308 [INFO    ] Processing PointID: NM-08520, Thing ID: 72, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,312 [INFO    ] Processing PointID: NM-19941, Thing ID: 73, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,316 [INFO    ] Processing PointID: TO-0365, Thing ID: 90, AlternateSiteID=8N9E7.211, AlternateSiteID2=None
2025-09-15 09:09:42,316 [INFO    ] adding link id: TO-0365
2025-09-15 09:09:42,323 [INFO    ] Processing PointID: NM-03078, Thing ID: 66, AlternateSiteID=S226, AlternateSiteID2=None
2025-09-15 09:09:42,323 [INFO    ] adding link id: NM-03078
2025-09-15 09:09:42,329 [INFO    ] Processing PointID: NM-23265, Thing ID: 96, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,332 [INFO    ] Processing PointID: NM-14754, Thing ID: 11, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,336 [INFO    ] Processing PointID: NM-12061, Thing ID: 9, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,339 [INFO    ] Processing PointID: NM-21884, Thing ID: 74, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,343 [INFO    ] Processing PointID: NM-00900, Thing ID: 75, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,347 [INFO    ] Processing PointID: NM-23206, Thing ID: 94, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,351 [INFO    ] Processing PointID: NM-05494, Thing ID: 15, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,355 [INFO    ] Processing PointID: NM-06378, Thing ID: 63, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,359 [INFO    ] Processing PointID: TB-0161, Thing ID: 36, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,363 [INFO    ] Processing PointID: NM-02181, Thing ID: 39, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,367 [INFO    ] Processing PointID: NM-14316, Thing ID: 7, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,371 [INFO    ] Processing PointID: NM-21975, Thing ID: 26, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,375 [INFO    ] Processing PointID: NM-12301, Thing ID: 86, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,379 [INFO    ] Processing PointID: AB-0132, Thing ID: 43, AlternateSiteID=S167, AlternateSiteID2=None
2025-09-15 09:09:42,380 [INFO    ] adding link id: AB-0132
2025-09-15 09:09:42,387 [INFO    ] Processing PointID: NM-00761, Thing ID: 92, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,391 [INFO    ] Processing PointID: NM-12619, Thing ID: 37, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,396 [INFO    ] Processing PointID: NM-13808, Thing ID: 91, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,400 [INFO    ] Processing PointID: DE-0219, Thing ID: 10, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,404 [INFO    ] Processing PointID: NM-04897, Thing ID: 62, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,408 [INFO    ] Processing PointID: NM-22572, Thing ID: 8, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,412 [INFO    ] Processing PointID: NM-10905, Thing ID: 47, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,416 [INFO    ] Processing PointID: NM-11649, Thing ID: 38, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,421 [INFO    ] Processing PointID: NM-15060, Thing ID: 99, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,425 [INFO    ] Processing PointID: NM-12948, Thing ID: 40, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,429 [INFO    ] Processing PointID: NM-04265, Thing ID: 95, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,433 [INFO    ] Processing PointID: NM-19371, Thing ID: 28, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,437 [INFO    ] Processing PointID: NM-00797, Thing ID: 50, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,441 [INFO    ] Processing PointID: NM-04094, Thing ID: 52, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,445 [INFO    ] Processing PointID: BW-0713, Thing ID: 80, AlternateSiteID=4.9.23.20.140, AlternateSiteID2=None
2025-09-15 09:09:42,445 [INFO    ] adding link id: BW-0713
2025-09-15 09:09:42,451 [INFO    ] Processing PointID: EB-057, Thing ID: 31, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,456 [INFO    ] Processing PointID: NM-14015, Thing ID: 58, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,460 [INFO    ] Processing PointID: NM-07171, Thing ID: 54, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,463 [INFO    ] Processing PointID: NM-26800, Thing ID: 79, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,468 [INFO    ] Processing PointID: NM-19178, Thing ID: 16, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,472 [INFO    ] Processing PointID: NM-00902, Thing ID: 64, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,476 [INFO    ] Processing PointID: NM-07286, Thing ID: 82, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,479 [INFO    ] Processing PointID: BW-0131, Thing ID: 21, AlternateSiteID=11S9E22.441, AlternateSiteID2=None
2025-09-15 09:09:42,479 [INFO    ] adding link id: BW-0131
2025-09-15 09:09:42,487 [INFO    ] Processing PointID: QY-0083, Thing ID: 81, AlternateSiteID=10.32.17.313, AlternateSiteID2=None
2025-09-15 09:09:42,487 [INFO    ] adding link id: QY-0083
2025-09-15 09:09:42,493 [INFO    ] Processing PointID: NM-05451, Thing ID: 78, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,497 [INFO    ] Processing PointID: SD-0035, Thing ID: 57, AlternateSiteID=7N.7E.17.411, AlternateSiteID2=None
2025-09-15 09:09:42,497 [INFO    ] adding link id: SD-0035
2025-09-15 09:09:42,504 [INFO    ] Processing PointID: NM-18139, Thing ID: 14, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,508 [INFO    ] Processing PointID: DE-0274, Thing ID: 85, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,512 [INFO    ] Processing PointID: EB-663, Thing ID: 35, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,517 [INFO    ] Processing PointID: NM-02887, Thing ID: 76, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,521 [INFO    ] Processing PointID: NM-00430, Thing ID: 65, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,526 [INFO    ] Processing PointID: NM-07101, Thing ID: 34, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,530 [INFO    ] Processing PointID: NM-12467, Thing ID: 4, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,535 [INFO    ] Processing PointID: NM-19826, Thing ID: 22, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,539 [INFO    ] Processing PointID: NM-09918, Thing ID: 77, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,544 [INFO    ] Processing PointID: TB-0123, Thing ID: 93, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,549 [INFO    ] Processing PointID: NM-22372, Thing ID: 25, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,554 [INFO    ] Processing PointID: TO-0225, Thing ID: 17, AlternateSiteID=6N8E11.42, AlternateSiteID2=None
2025-09-15 09:09:42,554 [INFO    ] adding link id: TO-0225
2025-09-15 09:09:42,562 [INFO    ] Processing PointID: NM-21920, Thing ID: 19, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,567 [INFO    ] Processing PointID: PP-040, Thing ID: 51, AlternateSiteID=PW-45, AlternateSiteID2=None
2025-09-15 09:09:42,567 [INFO    ] adding link id: PP-040
2025-09-15 09:09:42,574 [INFO    ] Processing PointID: NM-11224, Thing ID: 32, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,578 [INFO    ] Processing PointID: UC-0100, Thing ID: 24, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,582 [INFO    ] Processing PointID: NM-15818, Thing ID: 29, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,587 [INFO    ] Processing PointID: QY-0274, Thing ID: 20, AlternateSiteID=11.31.19.333, AlternateSiteID2=None
2025-09-15 09:09:42,587 [INFO    ] adding link id: QY-0274
2025-09-15 09:09:42,594 [INFO    ] Processing PointID: NM-12999, Thing ID: 56, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,598 [INFO    ] Processing PointID: NM-07733, Thing ID: 67, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,601 [INFO    ] Processing PointID: NM-12464, Thing ID: 18, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,605 [INFO    ] Processing PointID: NM-21254, Thing ID: 3, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,609 [INFO    ] Processing PointID: PC-037, Thing ID: 41, AlternateSiteID=PW-060, AlternateSiteID2=None
2025-09-15 09:09:42,609 [INFO    ] adding link id: PC-037
2025-09-15 09:09:42,616 [INFO    ] Processing PointID: NM-03744, Thing ID: 2, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,619 [INFO    ] Processing PointID: NM-02969, Thing ID: 49, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,622 [INFO    ] Processing PointID: NM-14570, Thing ID: 45, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,625 [INFO    ] Processing PointID: NM-02743, Thing ID: 71, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,629 [INFO    ] Processing PointID: NM-21466, Thing ID: 60, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,634 [INFO    ] Processing PointID: NM-13614, Thing ID: 48, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,638 [INFO    ] Processing PointID: NM-27856, Thing ID: 46, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,641 [INFO    ] Processing PointID: NM-26878, Thing ID: 13, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,646 [INFO    ] Processing PointID: NM-26136, Thing ID: 59, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,650 [INFO    ] Processing PointID: NM-15282, Thing ID: 70, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,654 [INFO    ] Processing PointID: NM-18772, Thing ID: 5, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,658 [INFO    ] Processing PointID: NM-16031, Thing ID: 69, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,662 [INFO    ] Processing PointID: NM-10516, Thing ID: 42, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,666 [INFO    ] Processing PointID: NM-05445, Thing ID: 12, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,670 [INFO    ] Processing PointID: NM-21348, Thing ID: 88, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,673 [INFO    ] Processing PointID: NM-16509, Thing ID: 97, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,677 [INFO    ] Processing PointID: DA-0141, Thing ID: 55, AlternateSiteID=26S4E19.13, AlternateSiteID2=None
2025-09-15 09:09:42,678 [INFO    ] adding link id: DA-0141
2025-09-15 09:09:42,684 [INFO    ] Processing PointID: NM-02255, Thing ID: 33, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,689 [INFO    ] Processing PointID: NM-14724, Thing ID: 23, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,693 [INFO    ] Processing PointID: NM-08407, Thing ID: 61, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,698 [INFO    ] Processing PointID: DA-0050, Thing ID: 68, AlternateSiteID=22S1E24.222, AlternateSiteID2=None
2025-09-15 09:09:42,698 [INFO    ] adding link id: DA-0050
2025-09-15 09:09:42,705 [INFO    ] Processing PointID: NM-20879, Thing ID: 53, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,709 [INFO    ] Processing PointID: NM-03186, Thing ID: 83, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,713 [INFO    ] Processing PointID: NM-04859, Thing ID: 100, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,717 [INFO    ] Processing PointID: NM-25835, Thing ID: 27, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,722 [INFO    ] Processing PointID: NM-21486, Thing ID: 87, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,727 [INFO    ] Processing PointID: QY-0181, Thing ID: 30, AlternateSiteID=11.30.14.143b, AlternateSiteID2=None
2025-09-15 09:09:42,727 [INFO    ] adding link id: QY-0181
2025-09-15 09:09:42,734 [INFO    ] Processing PointID: NM-14823, Thing ID: 98, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,738 [INFO    ] Processing PointID: NM-09388, Thing ID: 6, AlternateSiteID=None, AlternateSiteID2=None
2025-09-15 09:09:42,740 [INFO    ] transfer_link_ids took 2.859569 seconds
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 0
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 1
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 2
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 3
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 4
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 5
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 6
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 7
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 8
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 9
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 10
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 11
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 12
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 13
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 14
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 15
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 16
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 17
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 18
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 19
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 20
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 21
2025-09-15 09:09:44,756 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 22
2025-09-15 09:09:44,761 [WARNING ] OSEPOD is "X", "?", or "exempt", id=X for row 23
2025-09-15 09:09:44,761 [WARNING ] OSEWellTagID is null for row 23
2025-09-15 09:09:44,764 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 24
2025-09-15 09:09:44,764 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 25
2025-09-15 09:09:44,764 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 26
2025-09-15 09:09:44,764 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 27
2025-09-15 09:09:44,764 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 28
2025-09-15 09:09:44,764 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 29
2025-09-15 09:09:44,768 [WARNING ] OSEWellTagID is null for row 30
2025-09-15 09:09:44,777 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 31
2025-09-15 09:09:44,777 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 32
2025-09-15 09:09:44,777 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 33
2025-09-15 09:09:44,780 [WARNING ] OSEWellTagID is null for row 34
2025-09-15 09:09:44,785 [WARNING ] OSEWellTagID is null for row 35
2025-09-15 09:09:44,788 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 36
2025-09-15 09:09:44,788 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 37
2025-09-15 09:09:44,788 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 38
2025-09-15 09:09:44,788 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 39
2025-09-15 09:09:44,792 [WARNING ] OSEPOD is "X", "?", or "exempt", id=X for row 40
2025-09-15 09:09:44,792 [WARNING ] OSEWellTagID is null for row 40
2025-09-15 09:09:44,794 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 41
2025-09-15 09:09:44,794 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 42
2025-09-15 09:09:44,794 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 43
2025-09-15 09:09:44,794 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 44
2025-09-15 09:09:44,794 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 45
2025-09-15 09:09:44,794 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 46
2025-09-15 09:09:44,794 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 47
2025-09-15 09:09:44,794 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 48
2025-09-15 09:09:44,794 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 49
2025-09-15 09:09:44,796 [WARNING ] OSEWellTagID is null for row 50
2025-09-15 09:09:44,799 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 51
2025-09-15 09:09:44,799 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 52
2025-09-15 09:09:44,799 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 53
2025-09-15 09:09:44,799 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 54
2025-09-15 09:09:44,799 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 55
2025-09-15 09:09:44,801 [WARNING ] OSEPOD is "X", "?", or "exempt", id=X for row 56
2025-09-15 09:09:44,801 [WARNING ] OSEWellTagID is null for row 56
2025-09-15 09:09:44,802 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 57
2025-09-15 09:09:44,802 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 58
2025-09-15 09:09:44,802 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 59
2025-09-15 09:09:44,802 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 60
2025-09-15 09:09:44,802 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 61
2025-09-15 09:09:44,802 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 62
2025-09-15 09:09:44,802 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 63
2025-09-15 09:09:44,802 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 64
2025-09-15 09:09:44,802 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 65
2025-09-15 09:09:44,802 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 66
2025-09-15 09:09:44,802 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 67
2025-09-15 09:09:44,802 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 68
2025-09-15 09:09:44,802 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 69
2025-09-15 09:09:44,805 [WARNING ] OSEWellTagID is null for row 70
2025-09-15 09:09:44,808 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 71
2025-09-15 09:09:44,808 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 72
2025-09-15 09:09:44,808 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 73
2025-09-15 09:09:44,808 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 74
2025-09-15 09:09:44,808 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 75
2025-09-15 09:09:44,808 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 76
2025-09-15 09:09:44,810 [WARNING ] OSEPOD id does not match regex ^[A-Z]{1,2}-\d{5,6}, id=LRG-08447 for row 77
2025-09-15 09:09:44,810 [WARNING ] OSEWellTagID is null for row 77
2025-09-15 09:09:44,811 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 78
2025-09-15 09:09:44,811 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 79
2025-09-15 09:09:44,811 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 80
2025-09-15 09:09:44,811 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 81
2025-09-15 09:09:44,811 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 82
2025-09-15 09:09:44,811 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 83
2025-09-15 09:09:44,811 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 84
2025-09-15 09:09:44,811 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 85
2025-09-15 09:09:44,811 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 86
2025-09-15 09:09:44,811 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 87
2025-09-15 09:09:44,811 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 88
2025-09-15 09:09:44,811 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 89
2025-09-15 09:09:44,811 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 90
2025-09-15 09:09:44,811 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 91
2025-09-15 09:09:44,813 [WARNING ] OSEPOD is "X", "?", or "exempt", id=X for row 92
2025-09-15 09:09:44,813 [WARNING ] OSEWellTagID is null for row 92
2025-09-15 09:09:44,814 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 93
2025-09-15 09:09:44,814 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 94
2025-09-15 09:09:44,814 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 95
2025-09-15 09:09:44,814 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 96
2025-09-15 09:09:44,814 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 97
2025-09-15 09:09:44,814 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 98
2025-09-15 09:09:44,814 [WARNING ] Both OSEWellID and OSEWelltagID are null for row 99
2025-09-15 09:09:44,816 [WARNING ] OSEWellTagID is null for row 100
2025-09-15 09:09:44,820 [INFO    ] transfer_link_ids_welldata took 2.079431 seconds
2025-09-15 09:09:44,820 [INFO    ] 
2025-09-15 09:09:44,820 [INFO    ] ********** TRANSFERRING GROUPS **********
2025-09-15 09:09:45,597 [INFO    ] Adding 14 things to group Questa Red River, prefix QU
2025-09-15 09:09:45,601 [INFO    ] Adding 9 things to group Questa Red River, prefix TC
2025-09-15 09:09:45,605 [INFO    ] Adding 22 things to group Questa Red River, prefix TS
2025-09-15 09:09:45,655 [INFO    ] Adding 4 things to group S.Taos Valley, prefix TV
2025-09-15 09:09:45,658 [INFO    ] Adding 22 things to group S.Taos Valley, prefix TS
2025-09-15 09:09:45,699 [INFO    ] Adding 18 things to group La Cienega, prefix EB
2025-09-15 09:09:45,731 [INFO    ] Adding 17 things to group San Agustin Plains Alamosa Creek, prefix SA
2025-09-15 09:09:45,763 [INFO    ] Adding 84 things to group Sacramento Mtns, prefix SM
2025-09-15 09:09:45,893 [INFO    ] Adding 18 things to group Espanola Basin, prefix EB
2025-09-15 09:09:45,929 [INFO    ] Adding 23 things to group Tularosa Basin, prefix TB
2025-09-15 09:09:45,932 [INFO    ] Adding 84 things to group Tularosa Basin, prefix SM
2025-09-15 09:09:46,065 [INFO    ] Adding 84 things to group SM Watershed, prefix SM
2025-09-15 09:09:46,194 [INFO    ] Adding 1 things to group Union County, prefix UC
2025-09-15 09:09:46,203 [INFO    ] Adding 2 things to group White Sands, prefix WS
2025-09-15 09:09:46,213 [INFO    ] Adding 1 things to group Jornada Del Muerto, prefix JM
2025-09-15 09:09:46,232 [INFO    ] Adding 6 things to group Truth or Consequences, prefix HS
2025-09-15 09:09:46,245 [INFO    ] Adding 3 things to group Geothermal, prefix GT
2025-09-15 09:09:46,266 [INFO    ] Adding 9 things to group Taos Plateau, prefix TC
2025-09-15 09:09:46,268 [INFO    ] Adding 22 things to group Taos Plateau, prefix TS
2025-09-15 09:09:46,306 [INFO    ] Adding 97 things to group New Mexico, prefix NM
2025-09-15 09:09:46,456 [INFO    ] Adding 2 things to group Tiffany Fire Restoration, prefix SO
2025-09-15 09:09:46,480 [INFO    ] Adding 11 things to group El Morro, prefix EM
2025-09-15 09:09:46,502 [INFO    ] Adding 6 things to group Statewide Recharge, prefix SR
2025-09-15 09:09:46,517 [INFO    ] Adding 2 things to group San Miguel County, prefix MI
2025-09-15 09:09:46,526 [INFO    ] Adding 2 things to group Socorro, prefix SO
2025-09-15 09:09:46,535 [INFO    ] Adding 15 things to group Animas River, prefix AR
2025-09-15 09:09:46,561 [INFO    ] Adding 8 things to group Quay County, prefix QY
2025-09-15 09:09:46,578 [INFO    ] Adding 6 things to group Sandia and N. Manzano Mtns., prefix SD
2025-09-15 09:09:46,593 [INFO    ] Adding 10 things to group Brackish Water, prefix BW
2025-09-15 09:09:46,614 [INFO    ] Adding 2 things to group Dona Ana County, prefix DA
2025-09-15 09:09:46,623 [INFO    ] Adding 23 things to group Eastern Tularosa Basin, prefix TB
2025-09-15 09:09:46,661 [INFO    ] Adding 2 things to group Colfax County, prefix CX
2025-09-15 09:09:46,669 [INFO    ] Adding 1 things to group Eddy County, prefix ED
2025-09-15 09:09:46,679 [INFO    ] Adding 3 things to group Torrance County, prefix TO
2025-09-15 09:09:46,703 [INFO    ] Adding 22 things to group Taos Gorge Springs, prefix TS
2025-09-15 09:09:46,756 [INFO    ] Adding 16 things to group Placitas, prefix PC
2025-09-15 09:09:46,787 [INFO    ] Adding 8 things to group Picuris Pueblo, prefix PP
2025-09-15 09:09:46,806 [INFO    ] Adding 9 things to group Sunshine Valley, prefix TC
2025-09-15 09:09:46,848 [INFO    ] Adding 2 things to group Albuquerque Basin, prefix AB
2025-09-15 09:09:46,859 [INFO    ] Adding 2 things to group Tiffany Fire Recovery, prefix SO
2025-09-15 09:09:46,870 [INFO    ] Adding 1 things to group Salt Basin, prefix SB
2025-09-15 09:09:46,879 [INFO    ] Adding 4 things to group Mimbres Basin, prefix MB
2025-09-15 09:09:46,892 [INFO    ] Adding 2 things to group MRGCD, prefix SO
2025-09-15 09:09:46,903 [INFO    ] Adding 2 things to group Delaware Basin, prefix DE
2025-09-15 09:09:46,913 [INFO    ] Adding 2 things to group ABCWUA, prefix AB
2025-09-15 09:09:46,919 [INFO    ] Adding 97 things to group ABCWUA, prefix NM
2025-09-15 09:09:47,088 [INFO    ] transfer_groups took 2.268261 seconds
2025-09-15 09:09:47,088 [INFO    ] main_transfer took 54.316709 seconds

Process finished with exit code 0

[jirhiker]

commit: 343af2b1e2654d4fdfdce345fa9edb9d01f6ee7b. local

This is significantly slower than previous versions because of the state, county, and quad_name lookup.

2025-09-18 07:07:06,928 [INFO    ] ********** STARTING TRANSFER **********
2025-09-18 07:07:06,928 [INFO    ] Erasing existing data and initializing lexicon and sensors
2025-09-18 07:07:06,928 [INFO    ] Erasing existing data
2025-09-18 07:07:07,215 [INFO    ] Recreating tables
2025-09-18 07:07:07,441 [INFO    ] erase took 0.51248 seconds
2025-09-18 07:07:07,441 [INFO    ] Initializing lexicon
2025-09-18 07:07:10,685 [INFO    ] lexicon took 3.243914 seconds
2025-09-18 07:07:10,685 [INFO    ] Initializing sensors
2025-09-18 07:07:10,689 [INFO    ] sensor took 0.004392 seconds
2025-09-18 07:07:10,689 [INFO    ] 
2025-09-18 07:07:10,689 [INFO    ] ********** TRANSFERRING WELLS **********
2025-09-18 07:07:15,253 [WARNING ] PointID QU-047 has duplicate records. Skipping.
2025-09-18 07:07:28,931 [WARNING ] Reached limit of 15 rows. Stopping migration.
2025-09-18 07:07:28,950 [INFO    ] transfer_wells took 18.260553 seconds
2025-09-18 07:07:29,952 [INFO    ] transfer_wellscreens took 1.00248 seconds
2025-09-18 07:07:29,953 [INFO    ] 
2025-09-18 07:07:29,953 [INFO    ] ********** TRANSFERRING SPRINGS **********
2025-09-18 07:07:46,228 [WARNING ] Reached limit of 15 rows. Stopping migration.
2025-09-18 07:07:46,234 [INFO    ] transfer_springs took 16.281117 seconds
2025-09-18 07:07:46,234 [INFO    ] 
2025-09-18 07:07:46,234 [INFO    ] ********** TRANSFERRING PERENNIAL STREAMS **********
2025-09-18 07:08:02,731 [WARNING ] Reached limit of 15 rows. Stopping migration.
2025-09-18 07:08:02,736 [INFO    ] transfer_perennial_stream took 16.502 seconds
2025-09-18 07:08:02,736 [INFO    ] 
2025-09-18 07:08:02,736 [INFO    ] ********** TRANSFERRING EPHEMERAL STREAMS **********
2025-09-18 07:08:19,019 [WARNING ] Reached limit of 15 rows. Stopping migration.
2025-09-18 07:08:19,025 [INFO    ] transfer_ephemeral_stream took 16.289262 seconds
2025-09-18 07:08:19,025 [INFO    ] 
2025-09-18 07:08:19,025 [INFO    ] ********** TRANSFERRING METEOROLOGICAL **********
2025-09-18 07:08:35,712 [WARNING ] Reached limit of 15 rows. Stopping migration.
2025-09-18 07:08:35,716 [INFO    ] transfer_met took 16.691094 seconds
2025-09-18 07:08:35,717 [INFO    ] 
2025-09-18 07:08:35,717 [INFO    ] ********** TRANSFERRING CONTACTS **********
2025-09-18 07:08:39,792 [INFO    ] transfer_contacts took 4.075366 seconds
2025-09-18 07:08:39,792 [INFO    ] 
2025-09-18 07:08:39,792 [INFO    ] ********** TRANSFERRING WATER LEVELS **********
2025-09-18 07:08:45,690 [INFO    ] Processing PointID: DE-0219
2025-09-18 07:08:45,750 [INFO    ] Processing PointID: NM-03744
2025-09-18 07:08:45,789 [INFO    ] Processing PointID: NM-05445
2025-09-18 07:08:45,963 [INFO    ] Processing PointID: NM-05494
2025-09-18 07:08:46,229 [INFO    ] Processing row 25 of 28. NM-05494,  avg rows per second: 46.39
2025-09-18 07:08:46,283 [INFO    ] Processing PointID: NM-09388
2025-09-18 07:08:46,378 [INFO    ] Processing PointID: NM-12061
2025-09-18 07:08:46,476 [INFO    ] Processing PointID: NM-12467
2025-09-18 07:08:46,532 [INFO    ] Processing PointID: NM-14316
2025-09-18 07:08:46,788 [INFO    ] Processing row 25 of 42. NM-14316,  avg rows per second: 22.77
2025-09-18 07:08:46,987 [INFO    ] Processing PointID: NM-14754
2025-09-18 07:08:47,112 [INFO    ] Processing PointID: NM-18139
2025-09-18 07:08:47,136 [INFO    ] Processing PointID: NM-18772
2025-09-18 07:08:47,149 [INFO    ] Processing PointID: NM-21254
2025-09-18 07:08:47,351 [INFO    ] Processing PointID: NM-22572
2025-09-18 07:08:47,367 [INFO    ] transfer_water_levels took 7.575213 seconds
2025-09-18 07:08:47,367 [INFO    ] 
2025-09-18 07:08:47,367 [INFO    ] ********** TRANSFERRING LINK IDS **********
2025-09-18 07:08:49,806 [INFO    ] Processing PointID: NM-14754, Thing ID: 10, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:08:49,817 [INFO    ] Processing PointID: NM-12061, Thing ID: 8, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:08:49,827 [INFO    ] Processing PointID: NM-05494, Thing ID: 14, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:08:49,835 [INFO    ] Processing PointID: NM-14316, Thing ID: 6, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:08:49,841 [INFO    ] Processing PointID: DE-0219, Thing ID: 9, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:08:49,845 [INFO    ] Processing PointID: NM-22572, Thing ID: 7, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:08:49,850 [INFO    ] Processing PointID: NM-18139, Thing ID: 13, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:08:49,854 [INFO    ] Processing PointID: NM-12467, Thing ID: 3, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:08:49,857 [INFO    ] Processing PointID: NM-21254, Thing ID: 2, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:08:49,861 [INFO    ] Processing PointID: NM-03744, Thing ID: 1, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:08:49,865 [INFO    ] Processing PointID: NM-26878, Thing ID: 12, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:08:49,869 [INFO    ] Processing PointID: NM-18772, Thing ID: 4, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:08:49,873 [INFO    ] Processing PointID: NM-05445, Thing ID: 11, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:08:49,877 [INFO    ] Processing PointID: NM-09388, Thing ID: 5, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:08:49,878 [INFO    ] transfer_link_ids took 2.510967 seconds
2025-09-18 07:08:51,844 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-03744
2025-09-18 07:08:51,844 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-21254
2025-09-18 07:08:51,844 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-12467
2025-09-18 07:08:51,844 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-18772
2025-09-18 07:08:51,844 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-09388
2025-09-18 07:08:51,844 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-14316
2025-09-18 07:08:51,844 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-22572
2025-09-18 07:08:51,844 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-12061
2025-09-18 07:08:51,844 [WARNING ] Both OSEWellID and OSEWelltagID are null for DE-0219
2025-09-18 07:08:51,844 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-14754
2025-09-18 07:08:51,844 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-05445
2025-09-18 07:08:51,844 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-26878
2025-09-18 07:08:51,844 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-18139
2025-09-18 07:08:51,844 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-05494
2025-09-18 07:08:51,844 [INFO    ] transfer_link_ids_welldata took 1.965652 seconds
2025-09-18 07:08:51,844 [INFO    ] 
2025-09-18 07:08:51,844 [INFO    ] ********** TRANSFERRING GROUPS **********
2025-09-18 07:08:52,590 [INFO    ] Adding 4 things to group Questa Red River, prefix QU
2025-09-18 07:08:52,595 [INFO    ] Adding 3 things to group Questa Red River, prefix TC
2025-09-18 07:08:52,599 [INFO    ] Adding 4 things to group Questa Red River, prefix TS
2025-09-18 07:08:52,629 [INFO    ] Adding 1 things to group S.Taos Valley, prefix TV
2025-09-18 07:08:52,631 [INFO    ] Adding 4 things to group S.Taos Valley, prefix TS
2025-09-18 07:08:52,652 [INFO    ] Adding 5 things to group La Cienega, prefix EB
2025-09-18 07:08:52,672 [INFO    ] Adding 4 things to group San Agustin Plains Alamosa Creek, prefix SA
2025-09-18 07:08:52,690 [INFO    ] Adding 12 things to group Sacramento Mtns, prefix SM
2025-09-18 07:08:52,720 [INFO    ] Adding 5 things to group Espanola Basin, prefix EB
2025-09-18 07:08:52,734 [INFO    ] Adding 5 things to group Tularosa Basin, prefix TB
2025-09-18 07:08:52,735 [INFO    ] Adding 12 things to group Tularosa Basin, prefix SM
2025-09-18 07:08:52,759 [INFO    ] Adding 12 things to group SM Watershed, prefix SM
2025-09-18 07:08:52,849 [INFO    ] Adding 3 things to group Taos Plateau, prefix TC
2025-09-18 07:08:52,851 [INFO    ] Adding 4 things to group Taos Plateau, prefix TS
2025-09-18 07:08:52,865 [INFO    ] Adding 19 things to group New Mexico, prefix NM
2025-09-18 07:08:52,925 [INFO    ] Adding 3 things to group El Morro, prefix EM
2025-09-18 07:08:52,955 [INFO    ] Adding 3 things to group Animas River, prefix AR
2025-09-18 07:08:52,972 [INFO    ] Adding 3 things to group Sandia and N. Manzano Mtns., prefix SD
2025-09-18 07:08:52,982 [INFO    ] Adding 2 things to group Brackish Water, prefix BW
2025-09-18 07:08:52,998 [INFO    ] Adding 5 things to group Eastern Tularosa Basin, prefix TB
2025-09-18 07:08:53,041 [INFO    ] Adding 4 things to group Taos Gorge Springs, prefix TS
2025-09-18 07:08:53,066 [INFO    ] Adding 3 things to group Placitas, prefix PC
2025-09-18 07:08:53,078 [INFO    ] Adding 1 things to group Picuris Pueblo, prefix PP
2025-09-18 07:08:53,086 [INFO    ] Adding 3 things to group Sunshine Valley, prefix TC
2025-09-18 07:08:53,109 [INFO    ] Adding 1 things to group Albuquerque Basin, prefix AB
2025-09-18 07:08:53,144 [INFO    ] Adding 1 things to group Delaware Basin, prefix DE
2025-09-18 07:08:53,152 [INFO    ] Adding 1 things to group ABCWUA, prefix AB
2025-09-18 07:08:53,155 [INFO    ] Adding 19 things to group ABCWUA, prefix NM
2025-09-18 07:08:53,200 [INFO    ] transfer_groups took 1.356115 seconds
2025-09-18 07:08:53,200 [INFO    ] main_transfer took 106.272417 seconds

[jirhiker]

@jacob-a-brown
commit: 343af2b1e2654d4fdfdce345fa9edb9d01f6ee7b. local

removed state,county,quadname lookup. run cleanup_wells as a separate process

2025-09-18 07:14:16,229 [INFO ] ********** STARTING TRANSFER **********
2025-09-18 07:14:16,229 [INFO ] Erasing existing data and initializing lexicon and sensors
2025-09-18 07:14:16,229 [INFO ] Erasing existing data
2025-09-18 07:14:16,516 [INFO ] Recreating tables
2025-09-18 07:14:16,743 [INFO ] erase took 0.514296 seconds
2025-09-18 07:14:16,743 [INFO ] Initializing lexicon
2025-09-18 07:14:20,195 [INFO ] lexicon took 3.451988 seconds
2025-09-18 07:14:20,196 [INFO ] Initializing sensors
2025-09-18 07:14:20,200 [INFO ] sensor took 0.004216 seconds
2025-09-18 07:14:20,200 [INFO ]
2025-09-18 07:14:20,200 [INFO ] ********** TRANSFERRING WELLS **********
2025-09-18 07:14:24,594 [WARNING ] PointID QU-047 has duplicate records. Skipping.
2025-09-18 07:14:25,048 [WARNING ] Reached limit of 15 rows. Stopping migration.
2025-09-18 07:14:25,068 [INFO ] transfer_wells took 4.867673 seconds
2025-09-18 07:14:26,124 [INFO ] transfer_wellscreens took 1.055875 seconds
2025-09-18 07:14:26,124 [INFO ]
2025-09-18 07:14:26,124 [INFO ] ********** TRANSFERRING SPRINGS **********
2025-09-18 07:14:28,664 [WARNING ] Reached limit of 15 rows. Stopping migration.
2025-09-18 07:14:28,668 [INFO ] transfer_springs took 2.544596 seconds
2025-09-18 07:14:28,668 [INFO ]
2025-09-18 07:14:28,668 [INFO ] ********** TRANSFERRING PERENNIAL STREAMS **********
2025-09-18 07:14:31,192 [WARNING ] Reached limit of 15 rows. Stopping migration.
2025-09-18 07:14:31,196 [INFO ] transfer_perennial_stream took 2.52749 seconds
2025-09-18 07:14:31,196 [INFO ]
2025-09-18 07:14:31,196 [INFO ] ********** TRANSFERRING EPHEMERAL STREAMS **********
2025-09-18 07:14:33,708 [WARNING ] Reached limit of 15 rows. Stopping migration.
2025-09-18 07:14:33,711 [INFO ] transfer_ephemeral_stream took 2.515074 seconds
2025-09-18 07:14:33,711 [INFO ]
2025-09-18 07:14:33,711 [INFO ] ********** TRANSFERRING METEOROLOGICAL **********
2025-09-18 07:14:36,233 [WARNING ] Reached limit of 15 rows. Stopping migration.
2025-09-18 07:14:36,236 [INFO ] transfer_met took 2.525284 seconds
2025-09-18 07:14:36,237 [INFO ]
2025-09-18 07:14:36,237 [INFO ] ********** TRANSFERRING CONTACTS **********
2025-09-18 07:14:40,529 [INFO ] transfer_contacts took 4.292653 seconds
2025-09-18 07:14:40,529 [INFO ]
2025-09-18 07:14:40,529 [INFO ] ********** TRANSFERRING WATER LEVELS **********
2025-09-18 07:14:46,271 [INFO ] Processing PointID: DE-0219
2025-09-18 07:14:46,327 [INFO ] Processing PointID: NM-03744
2025-09-18 07:14:46,366 [INFO ] Processing PointID: NM-05445
2025-09-18 07:14:46,556 [INFO ] Processing PointID: NM-05494
2025-09-18 07:14:46,816 [INFO ] Processing row 25 of 28. NM-05494, avg rows per second: 45.74
2025-09-18 07:14:46,860 [INFO ] Processing PointID: NM-09388
2025-09-18 07:14:46,952 [INFO ] Processing PointID: NM-12061
2025-09-18 07:14:47,050 [INFO ] Processing PointID: NM-12467
2025-09-18 07:14:47,116 [INFO ] Processing PointID: NM-14316
2025-09-18 07:14:47,380 [INFO ] Processing row 25 of 42. NM-14316, avg rows per second: 22.51
2025-09-18 07:14:47,583 [INFO ] Processing PointID: NM-14754
2025-09-18 07:14:47,711 [INFO ] Processing PointID: NM-18139
2025-09-18 07:14:47,737 [INFO ] Processing PointID: NM-18772
2025-09-18 07:14:47,752 [INFO ] Processing PointID: NM-21254
2025-09-18 07:14:47,959 [INFO ] Processing PointID: NM-22572
2025-09-18 07:14:47,976 [INFO ] transfer_water_levels took 7.446381 seconds
2025-09-18 07:14:47,976 [INFO ]
2025-09-18 07:14:47,976 [INFO ] ********** TRANSFERRING LINK IDS **********
2025-09-18 07:14:50,786 [INFO ] Processing PointID: NM-14754, Thing ID: 10, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:14:50,792 [INFO ] Processing PointID: NM-12061, Thing ID: 8, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:14:50,796 [INFO ] Processing PointID: NM-05494, Thing ID: 14, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:14:50,799 [INFO ] Processing PointID: NM-14316, Thing ID: 6, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:14:50,803 [INFO ] Processing PointID: DE-0219, Thing ID: 9, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:14:50,806 [INFO ] Processing PointID: NM-22572, Thing ID: 7, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:14:50,810 [INFO ] Processing PointID: NM-18139, Thing ID: 13, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:14:50,814 [INFO ] Processing PointID: NM-12467, Thing ID: 3, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:14:50,818 [INFO ] Processing PointID: NM-21254, Thing ID: 2, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:14:50,823 [INFO ] Processing PointID: NM-03744, Thing ID: 1, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:14:50,826 [INFO ] Processing PointID: NM-26878, Thing ID: 12, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:14:50,831 [INFO ] Processing PointID: NM-18772, Thing ID: 4, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:14:50,834 [INFO ] Processing PointID: NM-05445, Thing ID: 11, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:14:50,839 [INFO ] Processing PointID: NM-09388, Thing ID: 5, AlternateSiteID=None, AlternateSiteID2=None
2025-09-18 07:14:50,840 [INFO ] transfer_link_ids took 2.864394 seconds
2025-09-18 07:14:53,766 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-03744
2025-09-18 07:14:53,766 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-21254
2025-09-18 07:14:53,766 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-12467
2025-09-18 07:14:53,766 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-18772
2025-09-18 07:14:53,766 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-09388
2025-09-18 07:14:53,766 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-14316
2025-09-18 07:14:53,766 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-22572
2025-09-18 07:14:53,766 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-12061
2025-09-18 07:14:53,766 [WARNING ] Both OSEWellID and OSEWelltagID are null for DE-0219
2025-09-18 07:14:53,766 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-14754
2025-09-18 07:14:53,766 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-05445
2025-09-18 07:14:53,766 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-26878
2025-09-18 07:14:53,766 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-18139
2025-09-18 07:14:53,766 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-05494
2025-09-18 07:14:53,766 [INFO ] transfer_link_ids_welldata took 2.925729 seconds
2025-09-18 07:14:53,766 [INFO ]
2025-09-18 07:14:53,766 [INFO ] ********** TRANSFERRING GROUPS **********
2025-09-18 07:14:54,509 [INFO ] Adding 4 things to group Questa Red River, prefix QU
2025-09-18 07:14:54,519 [INFO ] Adding 3 things to group Questa Red River, prefix TC
2025-09-18 07:14:54,524 [INFO ] Adding 4 things to group Questa Red River, prefix TS
2025-09-18 07:14:54,546 [INFO ] Adding 1 things to group S.Taos Valley, prefix TV
2025-09-18 07:14:54,548 [INFO ] Adding 4 things to group S.Taos Valley, prefix TS
2025-09-18 07:14:54,567 [INFO ] Adding 5 things to group La Cienega, prefix EB
2025-09-18 07:14:54,586 [INFO ] Adding 4 things to group San Agustin Plains Alamosa Creek, prefix SA
2025-09-18 07:14:54,599 [INFO ] Adding 12 things to group Sacramento Mtns, prefix SM
2025-09-18 07:14:54,624 [INFO ] Adding 5 things to group Espanola Basin, prefix EB
2025-09-18 07:14:54,636 [INFO ] Adding 5 things to group Tularosa Basin, prefix TB
2025-09-18 07:14:54,638 [INFO ] Adding 12 things to group Tularosa Basin, prefix SM
2025-09-18 07:14:54,660 [INFO ] Adding 12 things to group SM Watershed, prefix SM
2025-09-18 07:14:54,731 [INFO ] Adding 3 things to group Taos Plateau, prefix TC
2025-09-18 07:14:54,733 [INFO ] Adding 4 things to group Taos Plateau, prefix TS
2025-09-18 07:14:54,744 [INFO ] Adding 19 things to group New Mexico, prefix NM
2025-09-18 07:14:54,795 [INFO ] Adding 3 things to group El Morro, prefix EM
2025-09-18 07:14:54,823 [INFO ] Adding 3 things to group Animas River, prefix AR
2025-09-18 07:14:54,838 [INFO ] Adding 3 things to group Sandia and N. Manzano Mtns., prefix SD
2025-09-18 07:14:54,847 [INFO ] Adding 2 things to group Brackish Water, prefix BW
2025-09-18 07:14:54,859 [INFO ] Adding 5 things to group Eastern Tularosa Basin, prefix TB
2025-09-18 07:14:54,899 [INFO ] Adding 4 things to group Taos Gorge Springs, prefix TS
2025-09-18 07:14:54,922 [INFO ] Adding 3 things to group Placitas, prefix PC
2025-09-18 07:14:54,931 [INFO ] Adding 1 things to group Picuris Pueblo, prefix PP
2025-09-18 07:14:54,940 [INFO ] Adding 3 things to group Sunshine Valley, prefix TC
2025-09-18 07:14:54,966 [INFO ] Adding 1 things to group Albuquerque Basin, prefix AB
2025-09-18 07:14:55,005 [INFO ] Adding 1 things to group Delaware Basin, prefix DE
2025-09-18 07:14:55,013 [INFO ] Adding 1 things to group ABCWUA, prefix AB
2025-09-18 07:14:55,017 [INFO ] Adding 19 things to group ABCWUA, prefix NM
2025-09-18 07:14:55,067 [INFO ] transfer_groups took 1.300511 seconds
2025-09-18 07:14:55,067 [INFO ] main_transfer took 38.837951 seconds

[jacob-a-brown]

It certainly makes it slower, and often times out, but shouldn't it still be there for data fidelity and integrity? We could also retrieve those values with GET requests and not store them, but doing so would make the requests take way longer and render them unusable with the frontend.

[jirhiker]

I want the state, county, and quad values set during a separate process e.g. cleanup_state_county_quad_name(). This is only for the transfer process. Once the locations are in the database we can loop back thru and set all the state,county and quad names

[jirhiker]

2025-09-22 10:24:31,802 [INFO    ] Erasing existing data and initializing lexicon and sensors
2025-09-22 10:24:31,802 [INFO    ] Erasing existing data
2025-09-22 10:24:46,231 [INFO    ] Recreating tables
2025-09-22 10:25:02,933 [INFO    ] erase took 31.130501 seconds
2025-09-22 10:25:02,934 [INFO    ] Initializing lexicon
2025-09-22 10:35:58,486 [INFO    ] lexicon took 655.55214 seconds
2025-09-22 10:35:58,488 [INFO    ] Initializing sensors
2025-09-22 10:35:59,184 [INFO    ] sensor took 0.696109 seconds
2025-09-22 10:35:59,184 [INFO    ] 
2025-09-22 10:35:59,184 [INFO    ] ********** TRANSFERRING WELLS **********
2025-09-22 10:36:06,172 [WARNING ] PointID QU-047 has duplicate records. Skipping.
2025-09-22 10:37:12,055 [INFO    ] Processing row 25 of 38447. NM-21975,  avg rows per second: 0.38
2025-09-22 10:38:20,606 [INFO    ] Processing row 50 of 38447. PP-040,  avg rows per second: 0.37
2025-09-22 10:39:29,327 [INFO    ] Processing row 75 of 38447. NM-02887,  avg rows per second: 0.37
2025-09-22 10:40:38,347 [WARNING ] Reached limit of 100 rows. Stopping migration.
2025-09-22 10:40:38,950 [INFO    ] transfer_wells took 279.766166 seconds
2025-09-22 10:40:45,572 [INFO    ] transfer_wellscreens took 6.621484 seconds
2025-09-22 10:40:45,572 [INFO    ] 
2025-09-22 10:40:45,572 [INFO    ] ********** TRANSFERRING SPRINGS **********
2025-09-22 10:41:56,466 [INFO    ] Processing row 25 of 855. TB-1029,  avg rows per second: 0.37
2025-09-22 10:41:59,485 [INFO    ] Location MB-1004 has no Altitude. Setting from National Map EPQS for 
2025-09-22 10:43:06,133 [INFO    ] Processing row 50 of 855. TS-115,  avg rows per second: 0.37
2025-09-22 10:44:13,758 [INFO    ] Processing row 75 of 855. NM-28354,  avg rows per second: 0.37
2025-09-22 10:45:21,463 [WARNING ] Reached limit of 100 rows. Stopping migration.
2025-09-22 10:45:22,041 [INFO    ] transfer_springs took 276.468527 seconds
2025-09-22 10:45:22,041 [INFO    ] 
2025-09-22 10:45:22,041 [INFO    ] ********** TRANSFERRING PERENNIAL STREAMS **********
2025-09-22 10:46:33,525 [INFO    ] Processing row 25 of 176. AR-0527,  avg rows per second: 0.37
2025-09-22 10:47:41,378 [INFO    ] Processing row 50 of 176. SM-4071,  avg rows per second: 0.37
2025-09-22 10:48:49,638 [INFO    ] Processing row 75 of 176. SM-3024,  avg rows per second: 0.37
2025-09-22 10:49:58,029 [WARNING ] Reached limit of 100 rows. Stopping migration.
2025-09-22 10:49:58,617 [INFO    ] transfer_perennial_stream took 276.576331 seconds
2025-09-22 10:49:58,617 [INFO    ] 
2025-09-22 10:49:58,617 [INFO    ] ********** TRANSFERRING EPHEMERAL STREAMS **********
2025-09-22 10:51:10,375 [INFO    ] Processing row 25 of 38. NM-27181,  avg rows per second: 0.37
2025-09-22 10:51:45,949 [INFO    ] transfer_ephemeral_stream took 107.330971 seconds
2025-09-22 10:51:45,949 [INFO    ] 
2025-09-22 10:51:45,949 [INFO    ] ********** TRANSFERRING METEOROLOGICAL **********
2025-09-22 10:52:57,248 [INFO    ] Processing row 25 of 64. SM-5002,  avg rows per second: 0.37
2025-09-22 10:53:08,675 [INFO    ] Location MB-2003 has no Altitude. Setting from National Map EPQS for 
2025-09-22 10:53:45,264 [INFO    ] Location MB-2001 has no Altitude. Setting from National Map EPQS for 
2025-09-22 10:54:07,611 [INFO    ] Processing row 50 of 64. SM-2013,  avg rows per second: 0.36
2025-09-22 10:54:24,507 [INFO    ] Location MB-2002 has no Altitude. Setting from National Map EPQS for 
2025-09-22 10:54:48,129 [INFO    ] transfer_met took 182.180501 seconds
2025-09-22 10:54:48,130 [INFO    ] 
2025-09-22 10:54:48,130 [INFO    ] ********** TRANSFERRING CONTACTS **********
2025-09-22 10:54:54,132 [INFO    ] Processing PointID: 221 EB-663
2025-09-22 10:54:54,134 [WARNING ] Skipping physical address for first contact Warren Thompson. Validation error: 1 validation error for CreateAddress
postal_code
  Input should be a valid string [type=string_type, input_value=None, input_type=NoneType]
    For further information visit https://errors.pydantic.dev/2.11/v/string_type
2025-09-22 10:54:55,830 [INFO    ] added first contact for PointID EB-663
2025-09-22 10:54:57,040 [INFO    ] added second contact for PointID EB-663
2025-09-22 10:54:57,416 [INFO    ] Processing PointID: 441 EB-057
2025-09-22 10:54:58,277 [INFO    ] added first contact for PointID EB-057
2025-09-22 10:54:58,277 [CRITICAL] Skipping second contact for PointID EB-057 due to validation error: 1 validation error for CreateContact
  Value error, Either name or organization must be provided. [type=value_error, input_value={'thing_id': 30, 'release...wners': 'Noonan, Mitch'}, input_type=dict]
    For further information visit https://errors.pydantic.dev/2.11/v/value_error
2025-09-22 10:54:58,661 [INFO    ] Processing PointID: 1040 TB-0123
2025-09-22 10:54:59,507 [INFO    ] added first contact for PointID TB-0123
2025-09-22 10:54:59,508 [CRITICAL] Skipping second contact for PointID TB-0123 due to validation error: 1 validation error for CreateContact
  Value error, Either name or organization must be provided. [type=value_error, input_value={'thing_id': 92, 'release...: 'Hemphill, Eddie Bob'}, input_type=dict]
    For further information visit https://errors.pydantic.dev/2.11/v/value_error
2025-09-22 10:54:59,894 [INFO    ] Processing PointID: 1670 TB-0161
2025-09-22 10:55:01,576 [INFO    ] added first contact for PointID TB-0161
2025-09-22 10:55:01,577 [CRITICAL] Skipping second contact for PointID TB-0161 due to validation error: 1 validation error for CreateContact
  Value error, Either name or organization must be provided. [type=value_error, input_value={'thing_id': 35, 'release... 'Gamble, Richard/Dori'}, input_type=dict]
    For further information visit https://errors.pydantic.dev/2.11/v/value_error
2025-09-22 10:55:01,582 [INFO    ] transfer_contacts took 13.452743 seconds
2025-09-22 10:55:01,583 [INFO    ] 
2025-09-22 10:55:01,583 [INFO    ] ********** TRANSFERRING WATER LEVELS **********
2025-09-22 10:55:11,991 [INFO    ] Processing PointID: AB-0132
2025-09-22 10:55:14,117 [INFO    ] Processing PointID: BW-0131
2025-09-22 10:55:16,241 [INFO    ] Processing PointID: DA-0050
2025-09-22 10:55:18,361 [INFO    ] Processing PointID: DA-0141
2025-09-22 10:55:20,527 [INFO    ] Processing PointID: DE-0219
2025-09-22 10:55:24,087 [INFO    ] Processing PointID: DE-0274
2025-09-22 10:55:47,832 [INFO    ] Processing PointID: EB-057
2025-09-22 10:55:49,939 [INFO    ] Processing PointID: EB-663
2025-09-22 10:55:49,940 [WARNING ] Skipping row 195043 due to invalid date/time: time data '2018-05-04 10:47:00.0000000' does not match format '%Y-%m-%d %I:%M:%S %p'
2025-09-22 10:55:53,480 [INFO    ] Processing PointID: NM-00430
2025-09-22 10:55:53,481 [WARNING ] Skipping row 42728 due to missing data.
2025-09-22 10:55:58,561 [WARNING ] Skipping row 271811 due to missing data.
2025-09-22 10:56:03,060 [INFO    ] Processing PointID: NM-00761
2025-09-22 10:56:38,502 [INFO    ] Processing row 25 of 54. NM-00761,  avg rows per second: 0.29
2025-09-22 10:57:15,032 [INFO    ] Processing row 50 of 54. NM-00761,  avg rows per second: 0.41
2025-09-22 10:57:22,817 [INFO    ] Processing PointID: NM-00797
2025-09-22 10:57:24,902 [INFO    ] Processing PointID: NM-00900
2025-09-22 10:57:28,597 [INFO    ] Processing PointID: NM-00902
2025-09-22 10:57:35,254 [INFO    ] Processing PointID: NM-02181
2025-09-22 10:58:10,713 [INFO    ] Processing row 25 of 30. NM-02181,  avg rows per second: 0.14
2025-09-22 10:58:19,967 [INFO    ] Processing PointID: NM-02255
2025-09-22 10:58:27,902 [INFO    ] Processing PointID: NM-02743
2025-09-22 10:58:30,036 [WARNING ] Skipping row 65285 due to missing data.
2025-09-22 10:59:02,071 [INFO    ] Processing row 25 of 33. NM-02743,  avg rows per second: 0.11
2025-09-22 10:59:15,907 [INFO    ] Processing PointID: NM-02887
2025-09-22 10:59:22,484 [INFO    ] Processing PointID: NM-02969
2025-09-22 10:59:31,815 [INFO    ] Processing PointID: NM-03078
2025-09-22 11:00:07,222 [INFO    ] Processing row 25 of 83. NM-03078,  avg rows per second: 0.08
2025-09-22 11:00:45,409 [INFO    ] Processing row 50 of 83. NM-03078,  avg rows per second: 0.15
2025-09-22 11:01:22,487 [INFO    ] Processing row 75 of 83. NM-03078,  avg rows per second: 0.20
2025-09-22 11:01:36,359 [INFO    ] Processing PointID: NM-03186
2025-09-22 11:02:11,577 [INFO    ] Processing row 25 of 36. NM-03186,  avg rows per second: 0.06
2025-09-22 11:02:29,990 [INFO    ] Processing PointID: NM-03744
2025-09-22 11:02:35,380 [INFO    ] Processing PointID: NM-04094
2025-09-22 11:03:07,855 [INFO    ] Processing PointID: NM-04265
2025-09-22 11:03:10,058 [INFO    ] Processing PointID: NM-04859
2025-09-22 11:03:46,334 [INFO    ] Processing row 25 of 40. NM-04859,  avg rows per second: 0.05
2025-09-22 11:04:10,379 [INFO    ] Processing PointID: NM-04897
2025-09-22 11:04:12,497 [INFO    ] Processing PointID: NM-05445
2025-09-22 11:04:34,984 [INFO    ] Processing PointID: NM-05451
2025-09-22 11:04:37,113 [INFO    ] Processing PointID: NM-05494
2025-09-22 11:05:12,808 [INFO    ] Processing row 25 of 28. NM-05494,  avg rows per second: 0.04
2025-09-22 11:05:19,282 [INFO    ] Processing PointID: NM-06378
2025-09-22 11:05:24,301 [INFO    ] Processing PointID: NM-07101
2025-09-22 11:06:01,280 [INFO    ] Processing PointID: NM-07171
2025-09-22 11:06:10,729 [INFO    ] Processing PointID: NM-07286
2025-09-22 11:06:17,177 [INFO    ] Processing PointID: NM-07733
2025-09-22 11:06:25,618 [INFO    ] Processing PointID: NM-08407
2025-09-22 11:06:27,770 [INFO    ] Processing PointID: NM-08520
2025-09-22 11:06:35,664 [INFO    ] Processing PointID: NM-09388
2025-09-22 11:06:47,956 [INFO    ] Processing PointID: NM-09918
2025-09-22 11:07:26,166 [INFO    ] Processing PointID: NM-10516
2025-09-22 11:07:28,473 [INFO    ] Processing PointID: NM-10905
2025-09-22 11:07:35,214 [INFO    ] Processing PointID: NM-11224
2025-09-22 11:07:47,623 [INFO    ] Processing PointID: NM-11649
2025-09-22 11:08:23,586 [INFO    ] Processing row 25 of 41. NM-11649,  avg rows per second: 0.03
2025-09-22 11:08:49,572 [INFO    ] Processing PointID: NM-12061
2025-09-22 11:09:01,882 [INFO    ] Processing PointID: NM-12301
2025-09-22 11:09:04,030 [INFO    ] Processing PointID: NM-12464
2025-09-22 11:09:14,915 [INFO    ] Processing PointID: NM-12467
2025-09-22 11:09:22,883 [INFO    ] Processing PointID: NM-12619
2025-09-22 11:09:29,334 [INFO    ] Processing PointID: NM-12948
2025-09-22 11:10:05,231 [INFO    ] Processing PointID: NM-12999
2025-09-22 11:10:13,345 [INFO    ] Processing PointID: NM-13614
2025-09-22 11:10:22,732 [INFO    ] Processing PointID: NM-13808
2025-09-22 11:10:24,841 [INFO    ] Processing PointID: NM-14015
2025-09-22 11:10:35,850 [INFO    ] Processing PointID: NM-14316
2025-09-22 11:11:11,406 [INFO    ] Processing row 25 of 42. NM-14316,  avg rows per second: 0.03
2025-09-22 11:11:38,963 [INFO    ] Processing PointID: NM-14570
2025-09-22 11:11:41,151 [INFO    ] Processing PointID: NM-14724
2025-09-22 11:11:43,338 [INFO    ] Processing PointID: NM-14754
2025-09-22 11:12:00,135 [INFO    ] Processing PointID: NM-14823
2025-09-22 11:12:02,265 [INFO    ] Processing PointID: NM-15060
2025-09-22 11:12:04,465 [INFO    ] Processing PointID: NM-15282
2025-09-22 11:12:15,333 [INFO    ] Processing PointID: NM-15515
2025-09-22 11:12:30,766 [INFO    ] Processing PointID: NM-15818
2025-09-22 11:12:32,898 [INFO    ] Processing PointID: NM-16031
2025-09-22 11:12:35,050 [INFO    ] Processing PointID: NM-16509
2025-09-22 11:12:50,204 [INFO    ] Processing PointID: NM-18139
2025-09-22 11:12:53,794 [INFO    ] Processing PointID: NM-18288
2025-09-22 11:13:17,449 [INFO    ] Processing PointID: NM-18772
2025-09-22 11:13:19,633 [INFO    ] Processing PointID: NM-19178
2025-09-22 11:13:24,850 [INFO    ] Processing PointID: NM-19371
2025-09-22 11:13:28,541 [INFO    ] Processing PointID: NM-19826
2025-09-22 11:13:36,705 [INFO    ] Processing PointID: NM-19941
2025-09-22 11:13:40,366 [INFO    ] Processing PointID: NM-20879
2025-09-22 11:13:42,570 [INFO    ] Processing PointID: NM-21254
2025-09-22 11:14:11,138 [INFO    ] Processing PointID: NM-21348
2025-09-22 11:14:13,254 [INFO    ] Processing PointID: NM-21466
2025-09-22 11:14:15,679 [INFO    ] Processing PointID: NM-21486
2025-09-22 11:14:17,811 [INFO    ] Processing PointID: NM-21884
2025-09-22 11:14:19,932 [INFO    ] Processing PointID: NM-21920
2025-09-22 11:14:30,799 [WARNING ] Skipping row 31231 due to missing data.
2025-09-22 11:14:54,630 [INFO    ] Processing row 25 of 115. NM-21920,  avg rows per second: 0.02
2025-09-22 11:15:32,058 [INFO    ] Processing row 50 of 115. NM-21920,  avg rows per second: 0.04
2025-09-22 11:16:08,723 [INFO    ] Processing row 75 of 115. NM-21920,  avg rows per second: 0.06
2025-09-22 11:16:45,486 [INFO    ] Processing row 100 of 115. NM-21920,  avg rows per second: 0.08
2025-09-22 11:17:09,628 [INFO    ] Processing PointID: NM-21975
2025-09-22 11:17:11,720 [INFO    ] Processing PointID: NM-22372
2025-09-22 11:17:15,581 [INFO    ] Processing PointID: NM-22572
2025-09-22 11:17:17,699 [INFO    ] Processing PointID: NM-23206
2025-09-22 11:17:33,096 [INFO    ] Processing PointID: NM-23265
2025-09-22 11:17:35,211 [INFO    ] Processing PointID: NM-25835
2025-09-22 11:17:39,068 [INFO    ] Processing PointID: NM-26136
2025-09-22 11:17:41,216 [INFO    ] Processing PointID: NM-27856
2025-09-22 11:17:47,623 [INFO    ] Processing PointID: QY-0083
2025-09-22 11:17:51,183 [INFO    ] Processing PointID: QY-0181
2025-09-22 11:17:54,745 [INFO    ] Processing PointID: QY-0274
2025-09-22 11:17:54,745 [WARNING ] Skipping row 8039 due to missing data.
2025-09-22 11:17:54,745 [INFO    ] Processing PointID: QY-0940
2025-09-22 11:17:56,861 [INFO    ] Processing PointID: SD-0035
2025-09-22 11:17:58,977 [INFO    ] Processing PointID: TB-0123
2025-09-22 11:17:58,981 [WARNING ] Skipping row 49209 due to missing data.
2025-09-22 11:17:58,981 [INFO    ] Processing PointID: TB-0161
2025-09-22 11:18:05,481 [INFO    ] Processing PointID: TO-0365
2025-09-22 11:18:07,906 [INFO    ] Processing PointID: UC-0100
2025-09-22 11:18:36,342 [INFO    ] transfer_water_levels took 1414.759631 seconds
2025-09-22 11:18:36,343 [INFO    ] 
2025-09-22 11:18:36,343 [INFO    ] ********** TRANSFERRING LINK IDS **********
2025-09-22 11:18:39,578 [INFO    ] Processing PointID: NM-15515, Thing ID: 88, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:40,261 [INFO    ] Processing PointID: QY-0940, Thing ID: 83, AlternateSiteID=9.28.23.212, AlternateSiteID2=None
2025-09-22 11:18:40,262 [INFO    ] adding link id: QY-0940
2025-09-22 11:18:41,230 [INFO    ] Processing PointID: NM-18288, Thing ID: 43, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:41,932 [INFO    ] Processing PointID: NM-08520, Thing ID: 71, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:42,638 [INFO    ] Processing PointID: NM-19941, Thing ID: 72, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:43,313 [INFO    ] Processing PointID: TO-0365, Thing ID: 89, AlternateSiteID=8N9E7.211, AlternateSiteID2=None
2025-09-22 11:18:43,313 [INFO    ] adding link id: TO-0365
2025-09-22 11:18:44,285 [INFO    ] Processing PointID: NM-03078, Thing ID: 65, AlternateSiteID=S226, AlternateSiteID2=None
2025-09-22 11:18:44,286 [INFO    ] adding link id: NM-03078
2025-09-22 11:18:45,273 [INFO    ] Processing PointID: NM-23265, Thing ID: 95, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:45,968 [INFO    ] Processing PointID: NM-14754, Thing ID: 10, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:46,662 [INFO    ] Processing PointID: NM-12061, Thing ID: 8, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:47,349 [INFO    ] Processing PointID: NM-21884, Thing ID: 73, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:48,038 [INFO    ] Processing PointID: NM-00900, Thing ID: 74, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:48,718 [INFO    ] Processing PointID: NM-23206, Thing ID: 93, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:49,402 [INFO    ] Processing PointID: NM-05494, Thing ID: 14, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:50,089 [INFO    ] Processing PointID: NM-06378, Thing ID: 62, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:50,773 [INFO    ] Processing PointID: TB-0161, Thing ID: 35, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:51,452 [INFO    ] Processing PointID: NM-02181, Thing ID: 38, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:52,130 [INFO    ] Processing PointID: NM-14316, Thing ID: 6, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:52,802 [INFO    ] Processing PointID: NM-21975, Thing ID: 25, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:53,511 [INFO    ] Processing PointID: NM-12301, Thing ID: 85, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:54,202 [INFO    ] Processing PointID: AB-0132, Thing ID: 42, AlternateSiteID=S167, AlternateSiteID2=None
2025-09-22 11:18:54,202 [INFO    ] adding link id: AB-0132
2025-09-22 11:18:55,185 [INFO    ] Processing PointID: NM-00761, Thing ID: 91, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:55,870 [INFO    ] Processing PointID: NM-12619, Thing ID: 36, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:56,560 [INFO    ] Processing PointID: NM-13808, Thing ID: 90, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:57,247 [INFO    ] Processing PointID: DE-0219, Thing ID: 9, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:57,943 [INFO    ] Processing PointID: NM-04897, Thing ID: 61, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:58,631 [INFO    ] Processing PointID: NM-22572, Thing ID: 7, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:18:59,314 [INFO    ] Processing PointID: NM-10905, Thing ID: 46, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:00,013 [INFO    ] Processing PointID: NM-11649, Thing ID: 37, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:00,702 [INFO    ] Processing PointID: NM-15060, Thing ID: 98, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:01,394 [INFO    ] Processing PointID: NM-12948, Thing ID: 39, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:02,082 [INFO    ] Processing PointID: NM-04265, Thing ID: 94, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:02,759 [INFO    ] Processing PointID: NM-19371, Thing ID: 27, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:03,441 [INFO    ] Processing PointID: NM-00797, Thing ID: 49, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:04,131 [INFO    ] Processing PointID: NM-04094, Thing ID: 51, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:04,824 [INFO    ] Processing PointID: BW-0713, Thing ID: 79, AlternateSiteID=4.9.23.20.140, AlternateSiteID2=None
2025-09-22 11:19:04,824 [INFO    ] adding link id: BW-0713
2025-09-22 11:19:05,789 [INFO    ] Processing PointID: EB-057, Thing ID: 30, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:06,457 [INFO    ] Processing PointID: NM-14015, Thing ID: 57, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:07,141 [INFO    ] Processing PointID: NM-07171, Thing ID: 53, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:07,816 [INFO    ] Processing PointID: NM-26800, Thing ID: 78, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:08,490 [INFO    ] Processing PointID: NM-19178, Thing ID: 15, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:09,165 [INFO    ] Processing PointID: NM-00902, Thing ID: 63, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:09,834 [INFO    ] Processing PointID: NM-07286, Thing ID: 81, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:10,511 [INFO    ] Processing PointID: BW-0131, Thing ID: 20, AlternateSiteID=11S9E22.441, AlternateSiteID2=None
2025-09-22 11:19:10,511 [INFO    ] adding link id: BW-0131
2025-09-22 11:19:11,470 [INFO    ] Processing PointID: QY-0083, Thing ID: 80, AlternateSiteID=10.32.17.313, AlternateSiteID2=None
2025-09-22 11:19:11,470 [INFO    ] adding link id: QY-0083
2025-09-22 11:19:12,436 [INFO    ] Processing PointID: NM-05451, Thing ID: 77, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:13,112 [INFO    ] Processing PointID: SD-0035, Thing ID: 56, AlternateSiteID=7N.7E.17.411, AlternateSiteID2=None
2025-09-22 11:19:13,113 [INFO    ] adding link id: SD-0035
2025-09-22 11:19:14,091 [INFO    ] Processing PointID: NM-18139, Thing ID: 13, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:14,764 [INFO    ] Processing PointID: DE-0274, Thing ID: 84, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:15,441 [INFO    ] Processing PointID: EB-663, Thing ID: 34, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:16,134 [INFO    ] Processing PointID: NM-02887, Thing ID: 75, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:16,818 [INFO    ] Processing PointID: NM-00430, Thing ID: 64, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:17,501 [INFO    ] Processing PointID: NM-07101, Thing ID: 33, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:18,188 [INFO    ] Processing PointID: NM-12467, Thing ID: 3, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:18,865 [INFO    ] Processing PointID: NM-19826, Thing ID: 21, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:19,554 [INFO    ] Processing PointID: NM-09918, Thing ID: 76, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:20,236 [INFO    ] Processing PointID: TB-0123, Thing ID: 92, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:20,913 [INFO    ] Processing PointID: NM-22372, Thing ID: 24, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:21,590 [INFO    ] Processing PointID: TO-0225, Thing ID: 16, AlternateSiteID=6N8E11.42, AlternateSiteID2=None
2025-09-22 11:19:21,590 [INFO    ] adding link id: TO-0225
2025-09-22 11:19:22,574 [INFO    ] Processing PointID: NM-21920, Thing ID: 18, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:23,267 [INFO    ] Processing PointID: PP-040, Thing ID: 50, AlternateSiteID=PW-45, AlternateSiteID2=None
2025-09-22 11:19:23,268 [INFO    ] adding link id: PP-040
2025-09-22 11:19:24,251 [INFO    ] Processing PointID: NM-11224, Thing ID: 31, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:24,941 [INFO    ] Processing PointID: UC-0100, Thing ID: 23, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:25,635 [INFO    ] Processing PointID: NM-15818, Thing ID: 28, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:26,318 [INFO    ] Processing PointID: QY-0274, Thing ID: 19, AlternateSiteID=11.31.19.333, AlternateSiteID2=None
2025-09-22 11:19:26,319 [INFO    ] adding link id: QY-0274
2025-09-22 11:19:27,275 [INFO    ] Processing PointID: NM-12999, Thing ID: 55, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:27,966 [INFO    ] Processing PointID: NM-07733, Thing ID: 66, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:28,646 [INFO    ] Processing PointID: NM-12464, Thing ID: 17, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:29,335 [INFO    ] Processing PointID: NM-21254, Thing ID: 2, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:30,030 [INFO    ] Processing PointID: PC-037, Thing ID: 40, AlternateSiteID=PW-060, AlternateSiteID2=None
2025-09-22 11:19:30,030 [INFO    ] adding link id: PC-037
2025-09-22 11:19:31,013 [INFO    ] Processing PointID: NM-03744, Thing ID: 1, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:31,704 [INFO    ] Processing PointID: NM-02969, Thing ID: 48, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:32,391 [INFO    ] Processing PointID: NM-14570, Thing ID: 44, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:33,079 [INFO    ] Processing PointID: NM-02743, Thing ID: 70, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:33,766 [INFO    ] Processing PointID: NM-21466, Thing ID: 59, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:34,447 [INFO    ] Processing PointID: NM-13614, Thing ID: 47, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:35,138 [INFO    ] Processing PointID: NM-27856, Thing ID: 45, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:35,815 [INFO    ] Processing PointID: NM-26878, Thing ID: 12, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:36,489 [INFO    ] Processing PointID: NM-26136, Thing ID: 58, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:37,155 [INFO    ] Processing PointID: NM-15282, Thing ID: 69, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:37,826 [INFO    ] Processing PointID: NM-18772, Thing ID: 4, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:38,497 [INFO    ] Processing PointID: NM-16031, Thing ID: 68, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:39,170 [INFO    ] Processing PointID: NM-10516, Thing ID: 41, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:39,840 [INFO    ] Processing PointID: NM-05445, Thing ID: 11, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:40,505 [INFO    ] Processing PointID: NM-21348, Thing ID: 87, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:41,180 [INFO    ] Processing PointID: NM-16509, Thing ID: 96, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:41,844 [INFO    ] Processing PointID: DA-0141, Thing ID: 54, AlternateSiteID=26S4E19.13, AlternateSiteID2=None
2025-09-22 11:19:41,844 [INFO    ] adding link id: DA-0141
2025-09-22 11:19:42,842 [INFO    ] Processing PointID: NM-02255, Thing ID: 32, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:43,515 [INFO    ] Processing PointID: NM-14724, Thing ID: 22, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:44,176 [INFO    ] Processing PointID: NM-08407, Thing ID: 60, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:44,851 [INFO    ] Processing PointID: DA-0050, Thing ID: 67, AlternateSiteID=22S1E24.222, AlternateSiteID2=None
2025-09-22 11:19:44,852 [INFO    ] adding link id: DA-0050
2025-09-22 11:19:45,811 [INFO    ] Processing PointID: NM-20879, Thing ID: 52, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:46,481 [INFO    ] Processing PointID: NM-03186, Thing ID: 82, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:47,151 [INFO    ] Processing PointID: NM-04859, Thing ID: 99, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:47,823 [INFO    ] Processing PointID: NM-25835, Thing ID: 26, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:48,508 [INFO    ] Processing PointID: NM-21486, Thing ID: 86, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:49,187 [INFO    ] Processing PointID: QY-0181, Thing ID: 29, AlternateSiteID=11.30.14.143b, AlternateSiteID2=None
2025-09-22 11:19:49,187 [INFO    ] adding link id: QY-0181
2025-09-22 11:19:50,178 [INFO    ] Processing PointID: NM-14823, Thing ID: 97, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:50,859 [INFO    ] Processing PointID: NM-09388, Thing ID: 5, AlternateSiteID=None, AlternateSiteID2=None
2025-09-22 11:19:51,155 [INFO    ] transfer_link_ids took 74.812589 seconds
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-03744
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-21254
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-12467
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-18772
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-09388
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-14316
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-22572
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-12061
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for DE-0219
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-14754
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-05445
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-26878
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-18139
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-05494
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-19178
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for TO-0225
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-12464
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-21920
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for QY-0274
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for BW-0131
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-19826
2025-09-22 11:19:53,838 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-14724
2025-09-22 11:19:54,131 [WARNING ] OSEPOD is "X", "?", or "exempt", id=X for row 22
2025-09-22 11:19:54,131 [WARNING ] OSEWellTagID is null for row 22
2025-09-22 11:19:54,414 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-22372
2025-09-22 11:19:54,415 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-21975
2025-09-22 11:19:54,415 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-25835
2025-09-22 11:19:54,415 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-19371
2025-09-22 11:19:54,415 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-15818
2025-09-22 11:19:54,415 [WARNING ] Both OSEWellID and OSEWelltagID are null for QY-0181
2025-09-22 11:19:54,799 [WARNING ] OSEWellTagID is null for row 29
2025-09-22 11:19:55,379 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-11224
2025-09-22 11:19:55,379 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-02255
2025-09-22 11:19:55,379 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-07101
2025-09-22 11:19:55,763 [WARNING ] OSEWellTagID is null for row 33
2025-09-22 11:19:56,722 [WARNING ] OSEWellTagID is null for row 34
2025-09-22 11:19:57,305 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-12619
2025-09-22 11:19:57,305 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-11649
2025-09-22 11:19:57,305 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-02181
2025-09-22 11:19:57,305 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-12948
2025-09-22 11:19:57,695 [WARNING ] OSEPOD is "X", "?", or "exempt", id=X for row 39
2025-09-22 11:19:57,695 [WARNING ] OSEWellTagID is null for row 39
2025-09-22 11:19:57,982 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-10516
2025-09-22 11:19:57,982 [WARNING ] Both OSEWellID and OSEWelltagID are null for AB-0132
2025-09-22 11:19:57,982 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-18288
2025-09-22 11:19:57,982 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-14570
2025-09-22 11:19:57,982 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-27856
2025-09-22 11:19:57,982 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-10905
2025-09-22 11:19:57,982 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-13614
2025-09-22 11:19:57,982 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-02969
2025-09-22 11:19:57,982 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-00797
2025-09-22 11:19:58,367 [WARNING ] OSEWellTagID is null for row 49
2025-09-22 11:19:58,947 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-04094
2025-09-22 11:19:58,947 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-20879
2025-09-22 11:19:58,947 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-07171
2025-09-22 11:19:58,947 [WARNING ] Both OSEWellID and OSEWelltagID are null for DA-0141
2025-09-22 11:19:58,947 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-12999
2025-09-22 11:19:59,331 [WARNING ] OSEPOD is "X", "?", or "exempt", id=X for row 55
2025-09-22 11:19:59,331 [WARNING ] OSEWellTagID is null for row 55
2025-09-22 11:19:59,614 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-14015
2025-09-22 11:19:59,614 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-26136
2025-09-22 11:19:59,614 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-21466
2025-09-22 11:19:59,614 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-08407
2025-09-22 11:19:59,615 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-04897
2025-09-22 11:19:59,615 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-06378
2025-09-22 11:19:59,615 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-00902
2025-09-22 11:19:59,615 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-00430
2025-09-22 11:19:59,615 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-03078
2025-09-22 11:19:59,615 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-07733
2025-09-22 11:19:59,615 [WARNING ] Both OSEWellID and OSEWelltagID are null for DA-0050
2025-09-22 11:19:59,615 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-16031
2025-09-22 11:19:59,615 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-15282
2025-09-22 11:20:00,014 [WARNING ] OSEWellTagID is null for row 69
2025-09-22 11:20:00,597 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-08520
2025-09-22 11:20:00,597 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-19941
2025-09-22 11:20:00,597 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-21884
2025-09-22 11:20:00,597 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-00900
2025-09-22 11:20:00,597 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-02887
2025-09-22 11:20:00,597 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-09918
2025-09-22 11:20:00,976 [WARNING ] OSEPOD id does not match regex ^[A-Z]{1,2}-\d{5,6}, id=LRG-08447 for row 76
2025-09-22 11:20:00,977 [WARNING ] OSEWellTagID is null for row 76
2025-09-22 11:20:01,270 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-26800
2025-09-22 11:20:01,270 [WARNING ] Both OSEWellID and OSEWelltagID are null for BW-0713
2025-09-22 11:20:01,270 [WARNING ] Both OSEWellID and OSEWelltagID are null for QY-0083
2025-09-22 11:20:01,270 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-07286
2025-09-22 11:20:01,270 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-03186
2025-09-22 11:20:01,271 [WARNING ] Both OSEWellID and OSEWelltagID are null for QY-0940
2025-09-22 11:20:01,271 [WARNING ] Both OSEWellID and OSEWelltagID are null for DE-0274
2025-09-22 11:20:01,271 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-12301
2025-09-22 11:20:01,271 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-21486
2025-09-22 11:20:01,271 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-21348
2025-09-22 11:20:01,271 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-15515
2025-09-22 11:20:01,271 [WARNING ] Both OSEWellID and OSEWelltagID are null for TO-0365
2025-09-22 11:20:01,271 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-13808
2025-09-22 11:20:01,271 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-00761
2025-09-22 11:20:01,645 [WARNING ] OSEPOD is "X", "?", or "exempt", id=X for row 91
2025-09-22 11:20:01,646 [WARNING ] OSEWellTagID is null for row 91
2025-09-22 11:20:01,934 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-23206
2025-09-22 11:20:01,935 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-04265
2025-09-22 11:20:01,935 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-23265
2025-09-22 11:20:01,935 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-16509
2025-09-22 11:20:01,935 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-14823
2025-09-22 11:20:01,935 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-15060
2025-09-22 11:20:01,935 [WARNING ] Both OSEWellID and OSEWelltagID are null for NM-04859
2025-09-22 11:20:01,935 [INFO    ] transfer_link_ids_welldata took 10.779434 seconds
2025-09-22 11:20:01,935 [INFO    ] 
2025-09-22 11:20:01,935 [INFO    ] ********** TRANSFERRING GROUPS **********
2025-09-22 11:20:03,332 [INFO    ] Adding 13 things to group Questa Red River, prefix QU
2025-09-22 11:20:03,630 [INFO    ] Adding 9 things to group Questa Red River, prefix TC
2025-09-22 11:20:03,925 [INFO    ] Adding 22 things to group Questa Red River, prefix TS
2025-09-22 11:20:11,685 [INFO    ] Adding 4 things to group S.Taos Valley, prefix TV
2025-09-22 11:20:11,981 [INFO    ] Adding 22 things to group S.Taos Valley, prefix TS
2025-09-22 11:20:20,227 [INFO    ] Adding 18 things to group La Cienega, prefix EB
2025-09-22 11:20:26,705 [INFO    ] Adding 17 things to group San Agustin Plains Alamosa Creek, prefix SA
2025-09-22 11:20:32,955 [INFO    ] Adding 84 things to group Sacramento Mtns, prefix SM
2025-09-22 11:20:59,044 [INFO    ] Adding 18 things to group Espanola Basin, prefix EB
2025-09-22 11:21:05,749 [INFO    ] Adding 23 things to group Tularosa Basin, prefix TB
2025-09-22 11:21:06,049 [INFO    ] Adding 84 things to group Tularosa Basin, prefix SM
2025-09-22 11:21:32,421 [INFO    ] Adding 84 things to group SM Watershed, prefix SM
2025-09-22 11:21:58,511 [INFO    ] Adding 1 things to group Union County, prefix UC
2025-09-22 11:22:00,107 [INFO    ] Adding 2 things to group White Sands, prefix WS
2025-09-22 11:22:01,995 [INFO    ] Adding 1 things to group Jornada Del Muerto, prefix JM
2025-09-22 11:22:06,462 [INFO    ] Adding 6 things to group Truth or Consequences, prefix HS
2025-09-22 11:22:09,464 [INFO    ] Adding 3 things to group Geothermal, prefix GT
2025-09-22 11:22:14,088 [INFO    ] Adding 9 things to group Taos Plateau, prefix TC
2025-09-22 11:22:14,377 [INFO    ] Adding 22 things to group Taos Plateau, prefix TS
2025-09-22 11:22:21,986 [INFO    ] Adding 97 things to group New Mexico, prefix NM
2025-09-22 11:22:52,466 [INFO    ] Adding 2 things to group Tiffany Fire Restoration, prefix SO
2025-09-22 11:22:56,852 [INFO    ] Adding 11 things to group El Morro, prefix EM
2025-09-22 11:23:01,392 [INFO    ] Adding 6 things to group Statewide Recharge, prefix SR
2025-09-22 11:23:04,452 [INFO    ] Adding 2 things to group San Miguel County, prefix MI
2025-09-22 11:23:06,339 [INFO    ] Adding 2 things to group Socorro, prefix SO
2025-09-22 11:23:08,213 [INFO    ] Adding 15 things to group Animas River, prefix AR
2025-09-22 11:23:13,941 [INFO    ] Adding 8 things to group Quay County, prefix QY
2025-09-22 11:23:17,589 [INFO    ] Adding 6 things to group Sandia and N. Manzano Mtns., prefix SD
2025-09-22 11:23:20,639 [INFO    ] Adding 10 things to group Brackish Water, prefix BW
2025-09-22 11:23:24,862 [INFO    ] Adding 2 things to group Dona Ana County, prefix DA
2025-09-22 11:23:26,727 [INFO    ] Adding 23 things to group Eastern Tularosa Basin, prefix TB
2025-09-22 11:23:34,855 [INFO    ] Adding 2 things to group Colfax County, prefix CX
2025-09-22 11:23:36,734 [INFO    ] Adding 1 things to group Eddy County, prefix ED
2025-09-22 11:23:38,314 [INFO    ] Adding 3 things to group Torrance County, prefix TO
2025-09-22 11:23:43,066 [INFO    ] Adding 22 things to group Taos Gorge Springs, prefix TS
2025-09-22 11:23:53,447 [INFO    ] Adding 16 things to group Placitas, prefix PC
2025-09-22 11:23:59,454 [INFO    ] Adding 8 things to group Picuris Pueblo, prefix PP
2025-09-22 11:24:03,127 [INFO    ] Adding 9 things to group Sunshine Valley, prefix TC
2025-09-22 11:24:09,874 [INFO    ] Adding 2 things to group Albuquerque Basin, prefix AB
2025-09-22 11:24:11,992 [INFO    ] Adding 2 things to group Tiffany Fire Recovery, prefix SO
2025-09-22 11:24:13,831 [INFO    ] Adding 1 things to group Salt Basin, prefix SB
2025-09-22 11:24:15,382 [INFO    ] Adding 4 things to group Mimbres Basin, prefix MB
2025-09-22 11:24:17,768 [INFO    ] Adding 2 things to group MRGCD, prefix SO
2025-09-22 11:24:19,601 [INFO    ] Adding 2 things to group Delaware Basin, prefix DE
2025-09-22 11:24:21,434 [INFO    ] Adding 2 things to group ABCWUA, prefix AB
2025-09-22 11:24:22,019 [INFO    ] Adding 97 things to group ABCWUA, prefix NM
2025-09-22 11:24:54,347 [INFO    ] transfer_groups took 292.412493 seconds
2025-09-22 11:24:54,348 [INFO    ] main_transfer took 3622.54619 seconds

[jirhiker]

Cloud run job limit=100
TLDR; 2025-09-23 17:24:32,407 [INFO ] main_transfer took 77.422401 seconds

[jirhiker]

Cloud run job limit=500
main_transfer took 265.091445 seconds

[jirhiker]

Cloud run job limit=5000
main_transfer took 2166.888893 seconds