2018-05-05 04:14:49,047 DEBUG: Downloading http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7 to addresses-primary-e8e076ca.csv 2018-05-05 04:14:49,047 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7 with args {'f': 'json'} 2018-05-05 04:14:49,737 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'f': 'json', 'returnCountOnly': 'true'} 2018-05-05 04:14:50,033 INFO: Source has 42490 rows 2018-05-05 04:14:50,033 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7 with args {'f': 'json'} 2018-05-05 04:14:50,300 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'f': 'json', 'returnCountOnly': 'true'} 2018-05-05 04:14:50,633 INFO: Built 43 requests using resultOffset method 2018-05-05 04:14:50,634 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 0, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:14:51,906 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 1000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:14:52,996 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 2000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:14:54,385 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 3000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:14:55,741 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 4000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:14:56,955 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 5000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:14:58,150 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 6000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:14:59,397 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 7000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:00,675 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 8000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:01,777 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 9000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:02,963 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 10000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:04,378 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 11000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:05,643 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 12000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:07,073 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 13000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:08,343 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 14000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:09,497 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 15000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:10,818 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 16000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:12,139 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 17000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:13,321 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 18000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:14,822 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 19000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:16,101 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 20000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:17,564 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 21000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:18,798 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 22000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:19,065 INFO: Resource usage: { user: 25%, system: 0%, memory: 545MB, read: 0KB, written: 1568KB, sent: 102KB, received: 1601KB, period: 30sec, procs: 1 } 2018-05-05 04:15:20,264 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 23000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:21,685 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 24000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:23,344 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 25000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:24,787 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 26000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:26,302 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 27000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:27,873 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 28000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:29,412 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 29000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:30,801 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 30000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:32,276 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 31000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:33,743 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 32000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:35,291 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 33000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:36,666 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 34000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:38,332 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 35000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:39,946 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 36000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:41,312 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 37000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:42,936 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 38000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:44,356 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 39000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:45,850 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 40000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:47,443 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 41000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:48,878 DEBUG: Requesting http://geo.kelowna.ca/arcgis/rest/services/OpenData/MapServer/7/query with args {'where': '1=1', 'resultOffset': 42000, 'f': 'json', 'resultRecordCount': 1000, 'outFields': '*', 'returnGeometry': True, 'geometryPrecision': 7, 'outSR': '4326'} 2018-05-05 04:15:49,051 INFO: Resource usage: { user: 21%, system: 0%, memory: 545MB, read: 0KB, written: 1472KB, sent: 27KB, received: 477KB, period: 30sec, procs: 1 } 2018-05-05 04:15:49,898 INFO: Downloaded 42490 ESRI features for file /tmp/worker-prf0d184/work-9zsgs2yj/out/process_one-h2xaei5k/cache-7c2vf9r3/esri/addresses-primary-e8e076ca.csv 2018-05-05 04:15:49,936 INFO: Cached data in file:///tmp/worker-prf0d184/work-9zsgs2yj/out/process_one-h2xaei5k/cached/addresses-primary-e8e076ca.csv 2018-05-05 04:15:49,956 DEBUG: URL says ".csv" for file:///tmp/worker-prf0d184/work-9zsgs2yj/out/process_one-h2xaei5k/cached/addresses-primary-e8e076ca.csv 2018-05-05 04:15:49,956 DEBUG: Guessed addresses-primary-0c906914.csv for file:///tmp/worker-prf0d184/work-9zsgs2yj/out/process_one-h2xaei5k/cached/addresses-primary-e8e076ca.csv 2018-05-05 04:15:49,961 DEBUG: File exists /tmp/worker-prf0d184/work-9zsgs2yj/out/process_one-h2xaei5k/conform-_gtcq1nn/http/addresses-primary-0c906914.csv 2018-05-05 04:15:49,962 INFO: Downloaded to ['/tmp/worker-prf0d184/work-9zsgs2yj/out/process_one-h2xaei5k/conform-_gtcq1nn/http/addresses-primary-0c906914.csv'] 2018-05-05 04:15:49,962 WARNING: Could not guess a single compression from file names 2018-05-05 04:15:49,962 INFO: Decompressed to 1 files 2018-05-05 04:15:49,967 INFO: Sampled 6 records 2018-05-05 04:15:49,967 DEBUG: Converting to /tmp/worker-prf0d184/work-9zsgs2yj/out/process_one-h2xaei5k/conform-_gtcq1nn 2018-05-05 04:15:49,968 DEBUG: extract temp file /tmp/openaddr-extracted-3o7_dsdd.csv 2018-05-05 04:15:49,968 INFO: ESRI GeoJSON source found; treating it as CSV 2018-05-05 04:15:49,968 INFO: Converting source CSV /tmp/worker-prf0d184/work-9zsgs2yj/out/process_one-h2xaei5k/conform-_gtcq1nn/http/addresses-primary-0c906914.csv 2018-05-05 04:16:04,733 INFO: Converted to /tmp/worker-prf0d184/work-9zsgs2yj/out/process_one-h2xaei5k/conform-_gtcq1nn/converted/addresses-primary-0c906914.csv with 42490 addresses 2018-05-05 04:16:04,734 INFO: Processed data in /tmp/worker-prf0d184/work-9zsgs2yj/out/process_one-h2xaei5k/out.csv 2018-05-05 04:16:04,734 WARNING: Nothing previewed