2019-02-02 22:09:47,191 DEBUG: Downloading http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1 to addresses-primary-c7bfc6b1.csv 2019-02-02 22:09:47,191 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1 with args {'f': 'json'} 2019-02-02 22:09:47,474 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'returnCountOnly': 'true', 'where': '1=1'} 2019-02-02 22:09:47,714 INFO: Source has 28632 rows 2019-02-02 22:09:47,715 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1 with args {'f': 'json'} 2019-02-02 22:09:47,844 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'returnCountOnly': 'true', 'where': '1=1'} 2019-02-02 22:09:48,086 INFO: Built 29 requests using resultOffset method 2019-02-02 22:09:48,086 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 0, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:09:50,071 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 1000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:09:52,294 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 2000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:09:54,161 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 3000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:09:56,036 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 4000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:09:58,114 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 5000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:00,229 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 6000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:02,568 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 7000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:04,806 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 8000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:07,155 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 9000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:09,544 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 10000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:11,745 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 11000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:14,059 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 12000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:16,853 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 13000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:17,236 INFO: Resource usage: { user: 35%, system: 1%, memory: 564MB, read: 0KB, written: 10564KB, sent: 385KB, received: 18428KB, period: 30sec, procs: 1 } 2019-02-02 22:10:19,916 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 14000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:22,426 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 15000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:25,253 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 16000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:28,232 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 17000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:30,885 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 18000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:33,232 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 19000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:35,611 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 20000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:38,324 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 21000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:40,957 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 22000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:43,732 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 23000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:46,368 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 24000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:47,225 INFO: Resource usage: { user: 27%, system: 0%, memory: 561MB, read: 0KB, written: 7264KB, sent: 271KB, received: 13807KB, period: 30sec, procs: 1 } 2019-02-02 22:10:49,027 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 25000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:52,342 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 26000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:55,337 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 27000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:10:58,421 DEBUG: Requesting http://geodata.hawaii.gov/arcgis/rest/services/KOHA/koha/MapServer/1/query with args {'f': 'json', 'outSR': '4326', 'resultRecordCount': 1000, 'where': '1=1', 'returnGeometry': True, 'resultOffset': 28000, 'outFields': '*', 'geometryPrecision': 7} 2019-02-02 22:11:00,802 INFO: Downloaded 28632 ESRI features for file /tmp/worker-i4zj7ris/work-ybsffmu4/out/process_one-j21g5dp0/cache-hte8ze4z/esri/addresses-primary-c7bfc6b1.csv 2019-02-02 22:11:00,956 INFO: Cached data in file:///tmp/worker-i4zj7ris/work-ybsffmu4/out/process_one-j21g5dp0/cached/addresses-primary-c7bfc6b1.csv 2019-02-02 22:11:01,012 DEBUG: URL says ".csv" for file:///tmp/worker-i4zj7ris/work-ybsffmu4/out/process_one-j21g5dp0/cached/addresses-primary-c7bfc6b1.csv 2019-02-02 22:11:01,012 DEBUG: Guessed addresses-primary-fd5af66d.csv for file:///tmp/worker-i4zj7ris/work-ybsffmu4/out/process_one-j21g5dp0/cached/addresses-primary-c7bfc6b1.csv 2019-02-02 22:11:01,072 DEBUG: File exists /tmp/worker-i4zj7ris/work-ybsffmu4/out/process_one-j21g5dp0/conform-32hts6zy/http/addresses-primary-fd5af66d.csv 2019-02-02 22:11:01,073 INFO: Downloaded to ['/tmp/worker-i4zj7ris/work-ybsffmu4/out/process_one-j21g5dp0/conform-32hts6zy/http/addresses-primary-fd5af66d.csv'] 2019-02-02 22:11:01,073 WARNING: Could not guess a single compression from file names 2019-02-02 22:11:01,074 INFO: Decompressed to 1 files 2019-02-02 22:11:01,075 INFO: Sampled 6 records 2019-02-02 22:11:01,075 DEBUG: Converting to /tmp/worker-i4zj7ris/work-ybsffmu4/out/process_one-j21g5dp0/conform-32hts6zy 2019-02-02 22:11:01,084 DEBUG: extract temp file /tmp/openaddr-extracted-jdvyisi5.csv 2019-02-02 22:11:01,084 INFO: ESRI GeoJSON source found; treating it as CSV 2019-02-02 22:11:01,085 INFO: Converting source CSV /tmp/worker-i4zj7ris/work-ybsffmu4/out/process_one-j21g5dp0/conform-32hts6zy/http/addresses-primary-fd5af66d.csv 2019-02-02 22:11:12,138 INFO: Converted to /tmp/worker-i4zj7ris/work-ybsffmu4/out/process_one-j21g5dp0/conform-32hts6zy/converted/addresses-primary-fd5af66d.csv with 28633 addresses 2019-02-02 22:11:12,153 INFO: Processed data in /tmp/worker-i4zj7ris/work-ybsffmu4/out/process_one-j21g5dp0/out.csv 2019-02-02 22:11:12,153 WARNING: Nothing previewed