2018-05-05 04:34:12,130 DEBUG: Downloading https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0 to addresses-primary-eeb63f22.csv 2018-05-05 04:34:12,130 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0 with args {'f': 'json'} 2018-05-05 04:34:12,259 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'returnCountOnly': 'true', 'f': 'json', 'where': '1=1'} 2018-05-05 04:34:12,668 INFO: Source has 34181 rows 2018-05-05 04:34:12,668 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0 with args {'f': 'json'} 2018-05-05 04:34:12,749 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'returnCountOnly': 'true', 'f': 'json', 'where': '1=1'} 2018-05-05 04:34:12,805 INFO: Built 35 requests using resultOffset method 2018-05-05 04:34:12,805 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 0, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:13,385 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 1000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:14,096 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 2000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:14,720 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 3000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:15,258 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 4000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:15,870 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 5000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:16,545 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 6000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:17,249 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 7000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:17,847 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 8000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:18,721 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 9000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:19,756 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 10000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:20,461 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 11000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:21,365 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 12000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:22,414 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 13000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:23,483 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 14000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:24,213 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 15000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:25,066 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 16000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:26,013 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 17000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:26,925 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 18000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:27,804 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 19000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:28,509 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 20000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:29,292 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 21000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:30,263 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 22000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:31,166 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 23000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:32,237 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 24000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:32,830 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 25000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:33,870 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 26000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:34,820 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 27000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:35,536 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 28000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:36,382 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 29000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:36,923 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 30000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:37,825 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 31000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:38,699 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 32000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:39,752 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 33000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:40,705 DEBUG: Requesting https://services1.arcgis.com/SsOSFuyUWJh1AOU5/ArcGIS/rest/services/All_EK_AddressPnt/FeatureServer/0/query with args {'outSR': '4326', 'f': 'json', 'returnGeometry': True, 'resultOffset': 34000, 'resultRecordCount': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*'} 2018-05-05 04:34:41,094 INFO: Downloaded 34181 ESRI features for file /tmp/worker-ny8dya0m/work-gcam6lsb/out/process_one-aortm0d7/cache-l0kls_t_/esri/addresses-primary-eeb63f22.csv 2018-05-05 04:34:41,130 INFO: Cached data in file:///tmp/worker-ny8dya0m/work-gcam6lsb/out/process_one-aortm0d7/cached/addresses-primary-eeb63f22.csv 2018-05-05 04:34:41,145 DEBUG: URL says ".csv" for file:///tmp/worker-ny8dya0m/work-gcam6lsb/out/process_one-aortm0d7/cached/addresses-primary-eeb63f22.csv 2018-05-05 04:34:41,145 DEBUG: Guessed addresses-primary-eab62613.csv for file:///tmp/worker-ny8dya0m/work-gcam6lsb/out/process_one-aortm0d7/cached/addresses-primary-eeb63f22.csv 2018-05-05 04:34:41,148 DEBUG: File exists /tmp/worker-ny8dya0m/work-gcam6lsb/out/process_one-aortm0d7/conform-h9ys3olt/http/addresses-primary-eab62613.csv 2018-05-05 04:34:41,149 INFO: Downloaded to ['/tmp/worker-ny8dya0m/work-gcam6lsb/out/process_one-aortm0d7/conform-h9ys3olt/http/addresses-primary-eab62613.csv'] 2018-05-05 04:34:41,149 WARNING: Could not guess a single compression from file names 2018-05-05 04:34:41,149 INFO: Decompressed to 1 files 2018-05-05 04:34:41,150 INFO: Sampled 6 records 2018-05-05 04:34:41,150 DEBUG: Converting to /tmp/worker-ny8dya0m/work-gcam6lsb/out/process_one-aortm0d7/conform-h9ys3olt 2018-05-05 04:34:41,159 DEBUG: extract temp file /tmp/openaddr-extracted-t4mgv7j0.csv 2018-05-05 04:34:41,159 INFO: ESRI GeoJSON source found; treating it as CSV 2018-05-05 04:34:41,159 INFO: Converting source CSV /tmp/worker-ny8dya0m/work-gcam6lsb/out/process_one-aortm0d7/conform-h9ys3olt/http/addresses-primary-eab62613.csv 2018-05-05 04:34:42,168 INFO: Resource usage: { user: 42%, system: 0%, memory: 546MB, read: 0KB, written: 8908KB, sent: 128KB, received: 2681KB, period: 30sec, procs: 1 } 2018-05-05 04:34:59,948 INFO: Converted to /tmp/worker-ny8dya0m/work-gcam6lsb/out/process_one-aortm0d7/conform-h9ys3olt/converted/addresses-primary-eab62613.csv with 34181 addresses 2018-05-05 04:34:59,950 INFO: Processed data in /tmp/worker-ny8dya0m/work-gcam6lsb/out/process_one-aortm0d7/out.csv 2018-05-05 04:34:59,965 WARNING: Nothing previewed