2018-05-05 04:18:28,374 DEBUG: Downloading http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0 to addresses-primary-604e96f3.csv 2018-05-05 04:18:28,375 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0 with args {'f': 'json'} 2018-05-05 04:18:28,473 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'where': '1=1', 'returnCountOnly': 'true', 'f': 'json'} 2018-05-05 04:18:28,939 INFO: Source has 28479 rows 2018-05-05 04:18:28,939 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0 with args {'f': 'json'} 2018-05-05 04:18:29,033 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'where': '1=1', 'returnCountOnly': 'true', 'f': 'json'} 2018-05-05 04:18:29,411 INFO: Built 29 requests using resultOffset method 2018-05-05 04:18:29,411 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 0} 2018-05-05 04:18:30,931 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 1000} 2018-05-05 04:18:32,428 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 2000} 2018-05-05 04:18:33,931 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 3000} 2018-05-05 04:18:35,465 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 4000} 2018-05-05 04:18:37,044 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 5000} 2018-05-05 04:18:38,680 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 6000} 2018-05-05 04:18:40,319 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 7000} 2018-05-05 04:18:41,914 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 8000} 2018-05-05 04:18:43,557 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 9000} 2018-05-05 04:18:45,254 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 10000} 2018-05-05 04:18:46,999 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 11000} 2018-05-05 04:18:48,665 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 12000} 2018-05-05 04:18:50,729 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 13000} 2018-05-05 04:18:52,590 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 14000} 2018-05-05 04:18:54,764 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 15000} 2018-05-05 04:18:57,026 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 16000} 2018-05-05 04:18:58,385 INFO: Resource usage: { user: 21%, system: 0%, memory: 545MB, read: 0KB, written: 1232KB, sent: 121KB, received: 1279KB, period: 30sec, procs: 1 } 2018-05-05 04:18:59,330 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 17000} 2018-05-05 04:19:01,684 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 18000} 2018-05-05 04:19:04,102 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 19000} 2018-05-05 04:19:06,564 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 20000} 2018-05-05 04:19:08,998 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 21000} 2018-05-05 04:19:11,440 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 22000} 2018-05-05 04:19:13,845 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 23000} 2018-05-05 04:19:16,116 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 24000} 2018-05-05 04:19:18,612 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 25000} 2018-05-05 04:19:21,140 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 26000} 2018-05-05 04:19:23,557 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 27000} 2018-05-05 04:19:26,000 DEBUG: Requesting http://72.38.148.13:6080/arcgis/rest/services/911/MapServer/0/query with args {'resultRecordCount': 1000, 'outSR': '4326', 'geometryPrecision': 7, 'outFields': '*', 'f': 'json', 'returnGeometry': True, 'where': '1=1', 'resultOffset': 28000} 2018-05-05 04:19:27,845 INFO: Downloaded 28479 ESRI features for file /tmp/worker-6tyjxni5/work-o_fzj_xe/out/process_one-bjzt5ofx/cache-repvo7lk/esri/addresses-primary-604e96f3.csv 2018-05-05 04:19:27,884 INFO: Cached data in file:///tmp/worker-6tyjxni5/work-o_fzj_xe/out/process_one-bjzt5ofx/cached/addresses-primary-604e96f3.csv 2018-05-05 04:19:27,891 DEBUG: URL says ".csv" for file:///tmp/worker-6tyjxni5/work-o_fzj_xe/out/process_one-bjzt5ofx/cached/addresses-primary-604e96f3.csv 2018-05-05 04:19:27,891 DEBUG: Guessed addresses-primary-8664725d.csv for file:///tmp/worker-6tyjxni5/work-o_fzj_xe/out/process_one-bjzt5ofx/cached/addresses-primary-604e96f3.csv 2018-05-05 04:19:27,904 DEBUG: File exists /tmp/worker-6tyjxni5/work-o_fzj_xe/out/process_one-bjzt5ofx/conform-_qs0wy5i/http/addresses-primary-8664725d.csv 2018-05-05 04:19:27,905 INFO: Downloaded to ['/tmp/worker-6tyjxni5/work-o_fzj_xe/out/process_one-bjzt5ofx/conform-_qs0wy5i/http/addresses-primary-8664725d.csv'] 2018-05-05 04:19:27,905 WARNING: Could not guess a single compression from file names 2018-05-05 04:19:27,905 INFO: Decompressed to 1 files 2018-05-05 04:19:27,906 INFO: Sampled 6 records 2018-05-05 04:19:27,906 DEBUG: Converting to /tmp/worker-6tyjxni5/work-o_fzj_xe/out/process_one-bjzt5ofx/conform-_qs0wy5i 2018-05-05 04:19:27,907 DEBUG: extract temp file /tmp/openaddr-extracted-lhfpvaha.csv 2018-05-05 04:19:27,907 INFO: ESRI GeoJSON source found; treating it as CSV 2018-05-05 04:19:27,907 INFO: Converting source CSV /tmp/worker-6tyjxni5/work-o_fzj_xe/out/process_one-bjzt5ofx/conform-_qs0wy5i/http/addresses-primary-8664725d.csv 2018-05-05 04:19:28,444 INFO: Resource usage: { user: 16%, system: 0%, memory: 541MB, read: 0KB, written: 5604KB, sent: 107KB, received: 1903KB, period: 30sec, procs: 1 } 2018-05-05 04:19:41,845 INFO: Converted to /tmp/worker-6tyjxni5/work-o_fzj_xe/out/process_one-bjzt5ofx/conform-_qs0wy5i/converted/addresses-primary-8664725d.csv with 28479 addresses 2018-05-05 04:19:41,847 INFO: Processed data in /tmp/worker-6tyjxni5/work-o_fzj_xe/out/process_one-bjzt5ofx/out.csv 2018-05-05 04:19:41,847 WARNING: Nothing previewed