2018-05-13 00:00:16,368 DEBUG: Downloading http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0 to addresses-primary-11ca645b.csv 2018-05-13 00:00:16,369 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0 with args {'f': 'json'} 2018-05-13 00:00:16,762 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'where': '1=1', 'f': 'json', 'returnCountOnly': 'true'} 2018-05-13 00:00:17,411 INFO: Source has 29054 rows 2018-05-13 00:00:17,411 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0 with args {'f': 'json'} 2018-05-13 00:00:17,584 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'where': '1=1', 'f': 'json', 'returnCountOnly': 'true'} 2018-05-13 00:00:17,730 INFO: Built 30 requests using resultOffset method 2018-05-13 00:00:17,731 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 0, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:19,032 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 1000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:20,290 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 2000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:21,568 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 3000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:22,790 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 4000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:24,231 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 5000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:25,531 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 6000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:26,753 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 7000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:27,999 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 8000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:29,412 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 9000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:30,799 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 10000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:32,137 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 11000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:33,387 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 12000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:34,702 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 13000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:35,989 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 14000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:37,193 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 15000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:38,649 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 16000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:39,884 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 17000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:41,074 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 18000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:42,358 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 19000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:43,589 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 20000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:44,818 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 21000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:46,075 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 22000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:46,402 INFO: Resource usage: { user: 24%, system: 0%, memory: 548MB, read: 0KB, written: 2000KB, sent: 60KB, received: 3376KB, period: 30sec, procs: 1 } 2018-05-13 00:00:47,339 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 23000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:48,555 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 24000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:50,079 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 25000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:51,517 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 26000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:52,845 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 27000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:54,309 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 28000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:55,689 DEBUG: Requesting http://services5.arcgis.com/zEv9BLFdYq38maPG/ArcGIS/rest/services/CivicAddress_Public/FeatureServer/0/query with args {'resultOffset': 29000, 'resultRecordCount': 1000, 'outFields': '*', 'geometryPrecision': 7, 'outSR': '4326', 'where': '1=1', 'f': 'json', 'returnGeometry': True} 2018-05-13 00:00:56,021 INFO: Downloaded 29054 ESRI features for file /tmp/worker-i8k7pgo0/work-u7i5j43e/out/process_one-6b5g0862/cache-9_yk8qra/esri/addresses-primary-11ca645b.csv 2018-05-13 00:00:56,092 INFO: Cached data in file:///tmp/worker-i8k7pgo0/work-u7i5j43e/out/process_one-6b5g0862/cached/addresses-primary-11ca645b.csv 2018-05-13 00:00:56,108 DEBUG: URL says ".csv" for file:///tmp/worker-i8k7pgo0/work-u7i5j43e/out/process_one-6b5g0862/cached/addresses-primary-11ca645b.csv 2018-05-13 00:00:56,108 DEBUG: Guessed addresses-primary-33753c06.csv for file:///tmp/worker-i8k7pgo0/work-u7i5j43e/out/process_one-6b5g0862/cached/addresses-primary-11ca645b.csv 2018-05-13 00:00:56,111 DEBUG: File exists /tmp/worker-i8k7pgo0/work-u7i5j43e/out/process_one-6b5g0862/conform-q4_ka55e/http/addresses-primary-33753c06.csv 2018-05-13 00:00:56,112 INFO: Downloaded to ['/tmp/worker-i8k7pgo0/work-u7i5j43e/out/process_one-6b5g0862/conform-q4_ka55e/http/addresses-primary-33753c06.csv'] 2018-05-13 00:00:56,112 WARNING: Could not guess a single compression from file names 2018-05-13 00:00:56,112 INFO: Decompressed to 1 files 2018-05-13 00:00:56,137 INFO: Sampled 6 records 2018-05-13 00:00:56,138 DEBUG: Converting to /tmp/worker-i8k7pgo0/work-u7i5j43e/out/process_one-6b5g0862/conform-q4_ka55e 2018-05-13 00:00:56,138 DEBUG: extract temp file /tmp/openaddr-extracted-_tcviqev.csv 2018-05-13 00:00:56,138 INFO: ESRI GeoJSON source found; treating it as CSV 2018-05-13 00:00:56,139 INFO: Converting source CSV /tmp/worker-i8k7pgo0/work-u7i5j43e/out/process_one-6b5g0862/conform-q4_ka55e/http/addresses-primary-33753c06.csv 2018-05-13 00:01:13,176 INFO: Converted to /tmp/worker-i8k7pgo0/work-u7i5j43e/out/process_one-6b5g0862/conform-q4_ka55e/converted/addresses-primary-33753c06.csv with 29054 addresses 2018-05-13 00:01:13,207 INFO: Processed data in /tmp/worker-i8k7pgo0/work-u7i5j43e/out/process_one-6b5g0862/out.csv 2018-05-13 00:01:13,207 WARNING: Nothing previewed