2018-04-09 22:12:21,672 DEBUG: Downloading http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0 to bm--territory_wide-edfc87de.csv 2018-04-09 22:12:21,672 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0 with args {'f': 'json'} 2018-04-09 22:12:21,906 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0/query with args {'where': '1=1', 'f': 'json', 'returnCountOnly': 'true'} 2018-04-09 22:12:22,264 INFO: Source has 18896 rows 2018-04-09 22:12:22,264 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0 with args {'f': 'json'} 2018-04-09 22:12:22,337 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0/query with args {'where': '1=1', 'f': 'json', 'returnCountOnly': 'true'} 2018-04-09 22:12:22,411 INFO: Built 19 requests using resultOffset method 2018-04-09 22:12:22,411 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0/query with args {'resultRecordCount': 1000, 'resultOffset': 0, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*', 'returnGeometry': True, 'f': 'json', 'outSR': '4326'} 2018-04-09 22:12:23,693 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0/query with args {'resultRecordCount': 1000, 'resultOffset': 1000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*', 'returnGeometry': True, 'f': 'json', 'outSR': '4326'} 2018-04-09 22:12:24,538 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0/query with args {'resultRecordCount': 1000, 'resultOffset': 2000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*', 'returnGeometry': True, 'f': 'json', 'outSR': '4326'} 2018-04-09 22:12:25,247 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0/query with args {'resultRecordCount': 1000, 'resultOffset': 3000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*', 'returnGeometry': True, 'f': 'json', 'outSR': '4326'} 2018-04-09 22:12:25,821 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0/query with args {'resultRecordCount': 1000, 'resultOffset': 4000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*', 'returnGeometry': True, 'f': 'json', 'outSR': '4326'} 2018-04-09 22:12:26,380 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0/query with args {'resultRecordCount': 1000, 'resultOffset': 5000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*', 'returnGeometry': True, 'f': 'json', 'outSR': '4326'} 2018-04-09 22:12:27,123 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0/query with args {'resultRecordCount': 1000, 'resultOffset': 6000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*', 'returnGeometry': True, 'f': 'json', 'outSR': '4326'} 2018-04-09 22:12:27,796 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0/query with args {'resultRecordCount': 1000, 'resultOffset': 7000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*', 'returnGeometry': True, 'f': 'json', 'outSR': '4326'} 2018-04-09 22:12:28,494 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0/query with args {'resultRecordCount': 1000, 'resultOffset': 8000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*', 'returnGeometry': True, 'f': 'json', 'outSR': '4326'} 2018-04-09 22:12:29,052 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0/query with args {'resultRecordCount': 1000, 'resultOffset': 9000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*', 'returnGeometry': True, 'f': 'json', 'outSR': '4326'} 2018-04-09 22:12:29,602 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0/query with args {'resultRecordCount': 1000, 'resultOffset': 10000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*', 'returnGeometry': True, 'f': 'json', 'outSR': '4326'} 2018-04-09 22:12:30,331 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0/query with args {'resultRecordCount': 1000, 'resultOffset': 11000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*', 'returnGeometry': True, 'f': 'json', 'outSR': '4326'} 2018-04-09 22:12:30,925 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0/query with args {'resultRecordCount': 1000, 'resultOffset': 12000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*', 'returnGeometry': True, 'f': 'json', 'outSR': '4326'} 2018-04-09 22:12:31,494 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0/query with args {'resultRecordCount': 1000, 'resultOffset': 13000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*', 'returnGeometry': True, 'f': 'json', 'outSR': '4326'} 2018-04-09 22:12:32,342 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0/query with args {'resultRecordCount': 1000, 'resultOffset': 14000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*', 'returnGeometry': True, 'f': 'json', 'outSR': '4326'} 2018-04-09 22:12:32,915 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0/query with args {'resultRecordCount': 1000, 'resultOffset': 15000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*', 'returnGeometry': True, 'f': 'json', 'outSR': '4326'} 2018-04-09 22:12:33,850 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0/query with args {'resultRecordCount': 1000, 'resultOffset': 16000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*', 'returnGeometry': True, 'f': 'json', 'outSR': '4326'} 2018-04-09 22:12:34,438 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0/query with args {'resultRecordCount': 1000, 'resultOffset': 17000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*', 'returnGeometry': True, 'f': 'json', 'outSR': '4326'} 2018-04-09 22:12:35,265 DEBUG: Requesting http://services5.arcgis.com/YFNj7IqppWGZsn5o/arcgis/rest/services/AddressPoints/FeatureServer/0/query with args {'resultRecordCount': 1000, 'resultOffset': 18000, 'geometryPrecision': 7, 'where': '1=1', 'outFields': '*', 'returnGeometry': True, 'f': 'json', 'outSR': '4326'} 2018-04-09 22:12:36,103 INFO: Downloaded 18896 ESRI features for file /tmp/worker-eqnpse5a/work-79j2zvry/out/process_one-vpvt14sg/cache-jjbja71i/esri/bm--territory_wide-edfc87de.csv 2018-04-09 22:12:36,121 INFO: Cached data in file:///tmp/worker-eqnpse5a/work-79j2zvry/out/process_one-vpvt14sg/cached/bm--territory_wide-edfc87de.csv 2018-04-09 22:12:36,133 DEBUG: URL says ".csv" for file:///tmp/worker-eqnpse5a/work-79j2zvry/out/process_one-vpvt14sg/cached/bm--territory_wide-edfc87de.csv 2018-04-09 22:12:36,133 DEBUG: Guessed bm--territory_wide-b924bba4.csv for file:///tmp/worker-eqnpse5a/work-79j2zvry/out/process_one-vpvt14sg/cached/bm--territory_wide-edfc87de.csv 2018-04-09 22:12:36,135 DEBUG: File exists /tmp/worker-eqnpse5a/work-79j2zvry/out/process_one-vpvt14sg/conform-jevnol7w/http/bm--territory_wide-b924bba4.csv 2018-04-09 22:12:36,136 INFO: Downloaded to ['/tmp/worker-eqnpse5a/work-79j2zvry/out/process_one-vpvt14sg/conform-jevnol7w/http/bm--territory_wide-b924bba4.csv'] 2018-04-09 22:12:36,136 WARNING: Could not guess a single compression from file names 2018-04-09 22:12:36,136 INFO: Decompressed to 1 files 2018-04-09 22:12:36,137 INFO: Sampled 6 records 2018-04-09 22:12:36,137 DEBUG: Converting to /tmp/worker-eqnpse5a/work-79j2zvry/out/process_one-vpvt14sg/conform-jevnol7w 2018-04-09 22:12:36,137 DEBUG: extract temp file /tmp/openaddr-extracted-f0_qm8ba.csv 2018-04-09 22:12:36,138 INFO: ESRI GeoJSON source found; treating it as CSV 2018-04-09 22:12:36,138 INFO: Converting source CSV /tmp/worker-eqnpse5a/work-79j2zvry/out/process_one-vpvt14sg/conform-jevnol7w/http/bm--territory_wide-b924bba4.csv 2018-04-09 22:12:46,054 INFO: Converted to /tmp/worker-eqnpse5a/work-79j2zvry/out/process_one-vpvt14sg/conform-jevnol7w/converted/bm--territory_wide-b924bba4.csv with 18896 addresses 2018-04-09 22:12:46,056 INFO: Processed data in /tmp/worker-eqnpse5a/work-79j2zvry/out/process_one-vpvt14sg/out.csv 2018-04-09 22:12:46,056 WARNING: Nothing previewed