2019-02-02 21:10:00,958 DEBUG: Downloading http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9 to addresses-primary-c3dcbabc.csv 2019-02-02 21:10:00,958 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9 with args {'f': 'json'} 2019-02-02 21:10:01,988 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'f': 'json', 'where': '1=1', 'returnCountOnly': 'true'} 2019-02-02 21:10:02,517 INFO: Source has 48597 rows 2019-02-02 21:10:02,518 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9 with args {'f': 'json'} 2019-02-02 21:10:02,675 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'f': 'json', 'where': '1=1', 'returnCountOnly': 'true'} 2019-02-02 21:10:03,150 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'outStatistics': '[{"outStatisticFieldName":"THE_MIN","statisticType":"min","onStatisticField":"OBJECTID"},{"outStatisticFieldName":"THE_MAX","statisticType":"max","onStatisticField":"OBJECTID"}]', 'f': 'json', 'outFields': ''} 2019-02-02 21:10:03,685 INFO: Built 49 requests using OID where clause method 2019-02-02 21:10:03,685 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 0 AND OBJECTID <= 1000'} 2019-02-02 21:10:05,051 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 1000 AND OBJECTID <= 2000'} 2019-02-02 21:10:06,017 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 2000 AND OBJECTID <= 3000'} 2019-02-02 21:10:06,960 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 3000 AND OBJECTID <= 4000'} 2019-02-02 21:10:08,162 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 4000 AND OBJECTID <= 5000'} 2019-02-02 21:10:09,562 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 5000 AND OBJECTID <= 6000'} 2019-02-02 21:10:10,814 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 6000 AND OBJECTID <= 7000'} 2019-02-02 21:10:12,020 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 7000 AND OBJECTID <= 8000'} 2019-02-02 21:10:13,004 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 8000 AND OBJECTID <= 9000'} 2019-02-02 21:10:13,897 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 9000 AND OBJECTID <= 10000'} 2019-02-02 21:10:14,900 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 10000 AND OBJECTID <= 11000'} 2019-02-02 21:10:15,917 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 11000 AND OBJECTID <= 12000'} 2019-02-02 21:10:17,042 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 12000 AND OBJECTID <= 13000'} 2019-02-02 21:10:18,290 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 13000 AND OBJECTID <= 14000'} 2019-02-02 21:10:19,525 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 14000 AND OBJECTID <= 15000'} 2019-02-02 21:10:20,824 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 15000 AND OBJECTID <= 16000'} 2019-02-02 21:10:21,935 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 16000 AND OBJECTID <= 17000'} 2019-02-02 21:10:22,845 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 17000 AND OBJECTID <= 18000'} 2019-02-02 21:10:23,859 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 18000 AND OBJECTID <= 19000'} 2019-02-02 21:10:25,148 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 19000 AND OBJECTID <= 20000'} 2019-02-02 21:10:26,473 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 20000 AND OBJECTID <= 21000'} 2019-02-02 21:10:27,825 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 21000 AND OBJECTID <= 22000'} 2019-02-02 21:10:29,206 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 22000 AND OBJECTID <= 23000'} 2019-02-02 21:10:30,534 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 23000 AND OBJECTID <= 24000'} 2019-02-02 21:10:30,959 INFO: Resource usage: { user: 28%, system: 0%, memory: 547MB, read: 0KB, written: 2476KB, sent: 84KB, received: 2770KB, period: 30sec, procs: 1 } 2019-02-02 21:10:31,838 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 24000 AND OBJECTID <= 25000'} 2019-02-02 21:10:33,231 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 25000 AND OBJECTID <= 26000'} 2019-02-02 21:10:34,636 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 26000 AND OBJECTID <= 27000'} 2019-02-02 21:10:35,714 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 27000 AND OBJECTID <= 28000'} 2019-02-02 21:10:36,649 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 28000 AND OBJECTID <= 29000'} 2019-02-02 21:10:37,696 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 29000 AND OBJECTID <= 30000'} 2019-02-02 21:10:38,972 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 30000 AND OBJECTID <= 31000'} 2019-02-02 21:10:40,319 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 31000 AND OBJECTID <= 32000'} 2019-02-02 21:10:41,322 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 32000 AND OBJECTID <= 33000'} 2019-02-02 21:10:42,391 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 33000 AND OBJECTID <= 34000'} 2019-02-02 21:10:43,758 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 34000 AND OBJECTID <= 35000'} 2019-02-02 21:10:45,089 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 35000 AND OBJECTID <= 36000'} 2019-02-02 21:10:46,478 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 36000 AND OBJECTID <= 37000'} 2019-02-02 21:10:47,800 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 37000 AND OBJECTID <= 38000'} 2019-02-02 21:10:49,140 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 38000 AND OBJECTID <= 39000'} 2019-02-02 21:10:50,398 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 39000 AND OBJECTID <= 40000'} 2019-02-02 21:10:51,691 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 40000 AND OBJECTID <= 41000'} 2019-02-02 21:10:52,899 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 41000 AND OBJECTID <= 42000'} 2019-02-02 21:10:54,105 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 42000 AND OBJECTID <= 43000'} 2019-02-02 21:10:55,300 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 43000 AND OBJECTID <= 44000'} 2019-02-02 21:10:56,543 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 44000 AND OBJECTID <= 45000'} 2019-02-02 21:10:57,841 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 45000 AND OBJECTID <= 46000'} 2019-02-02 21:10:59,294 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 46000 AND OBJECTID <= 47000'} 2019-02-02 21:11:00,616 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 47000 AND OBJECTID <= 48000'} 2019-02-02 21:11:01,009 INFO: Resource usage: { user: 28%, system: 0%, memory: 547MB, read: 0KB, written: 2692KB, sent: 47KB, received: 1577KB, period: 30sec, procs: 1 } 2019-02-02 21:11:01,947 DEBUG: Requesting http://kingscountygis.com:6080/arcgis/rest/services/Kings/MapServer/9/query with args {'geometryPrecision': 7, 'outSR': '4326', 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': 'OBJECTID > 48000 AND OBJECTID <= 48597'} 2019-02-02 21:11:04,061 INFO: Downloaded 48597 ESRI features for file /tmp/worker-8wl4izem/work-t6jnq67q/out/process_one-dqxp1qnl/cache-nv34p6g1/esri/addresses-primary-c3dcbabc.csv 2019-02-02 21:11:04,178 INFO: Cached data in file:///tmp/worker-8wl4izem/work-t6jnq67q/out/process_one-dqxp1qnl/cached/addresses-primary-c3dcbabc.csv 2019-02-02 21:11:04,203 DEBUG: URL says ".csv" for file:///tmp/worker-8wl4izem/work-t6jnq67q/out/process_one-dqxp1qnl/cached/addresses-primary-c3dcbabc.csv 2019-02-02 21:11:04,203 DEBUG: Guessed addresses-primary-fb17be26.csv for file:///tmp/worker-8wl4izem/work-t6jnq67q/out/process_one-dqxp1qnl/cached/addresses-primary-c3dcbabc.csv 2019-02-02 21:11:04,211 DEBUG: File exists /tmp/worker-8wl4izem/work-t6jnq67q/out/process_one-dqxp1qnl/conform-ka508bi2/http/addresses-primary-fb17be26.csv 2019-02-02 21:11:04,211 INFO: Downloaded to ['/tmp/worker-8wl4izem/work-t6jnq67q/out/process_one-dqxp1qnl/conform-ka508bi2/http/addresses-primary-fb17be26.csv'] 2019-02-02 21:11:04,225 WARNING: Could not guess a single compression from file names 2019-02-02 21:11:04,225 INFO: Decompressed to 1 files 2019-02-02 21:11:04,226 INFO: Sampled 6 records 2019-02-02 21:11:04,226 DEBUG: Converting to /tmp/worker-8wl4izem/work-t6jnq67q/out/process_one-dqxp1qnl/conform-ka508bi2 2019-02-02 21:11:04,227 DEBUG: extract temp file /tmp/openaddr-extracted-hslzdp64.csv 2019-02-02 21:11:04,227 INFO: ESRI GeoJSON source found; treating it as CSV 2019-02-02 21:11:04,227 INFO: Converting source CSV /tmp/worker-8wl4izem/work-t6jnq67q/out/process_one-dqxp1qnl/conform-ka508bi2/http/addresses-primary-fb17be26.csv 2019-02-02 21:11:30,519 INFO: Converted to /tmp/worker-8wl4izem/work-t6jnq67q/out/process_one-dqxp1qnl/conform-ka508bi2/converted/addresses-primary-fb17be26.csv with 48597 addresses 2019-02-02 21:11:30,522 INFO: Processed data in /tmp/worker-8wl4izem/work-t6jnq67q/out/process_one-dqxp1qnl/out.csv 2019-02-02 21:11:30,522 WARNING: Nothing previewed